Jump to content

[Request] Double XP donner player


Guest danielle091

Recommended Posts

Hi Community

First excuse me for my english, my native languaje is spanish, but I try for you can understand my idea. I don't know if this be have post here, if not I'm sorry so much.

Well, I need an core modification or something that I can modific for double xp to players donner in my server, not necesary double can be more xp. If you can help me will be awesome!

Sorry for my english

Daniel ^^

Link to comment
Share on other sites

Try this:

Its old and you'll have to implement it manually but I guess it work (didnt tested it with newest core)...

Code:

http://paste2.org/p/1041421

SQL:

http://paste2.org/p/1041423

With it, you may modify the kill, explore and quest XP for each character (guid) ...

Hi, Thanks so much for this patch.

Ok, now happen with this, I implement manually and all fine. But only show me an error when I want compile mangos. I hope can understand my english.

This is...

..\\..\\src\\game\\Player.cpp(4374): error C2065: 'guid' : identificador no declarado

And I dont know how fix this... I hope can u help me.

Thanks so much guys for reply my request.

Link to comment
Share on other sites

SQL doesn't correspond with code,

SQL should be something like this

CREATE TABLE `character_xp_rate` (
 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
 `xp_rate` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Experience Multiplier',
 PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT

And I think code is incomplete, it can crash the server by several ways

Link to comment
Share on other sites

I guess it happens in DeleteFromDB...

Just replace "guid" with "lowguid" in this case.

I did this, change "guid" for "lowguild" (I discovered myself but thanks for your reply Edder) and compile without problems... I apply SQL posted for Edder.

Now, when I try join an character in world the console show me something same this. No exactly, I dont remember.

Player (GUID:1) no find in character_xp_rate. Can't load table.

Well, thanks to all for yours replys. I hope can help me with this patch.

Link to comment
Share on other sites

Thank you Edder, if you want to improve the patch, i think that would be a good thing the possibility of specify an end date for the bonus, you know what i mean? Would be more unnatended

- you set manually the bonus

- After 1 month (or whatever) system itself disable the bonus

I think this could be done adding two columns in sql like 'enddate' and 'active' and some code in Player::LoadFromDB

Thank you

Link to comment
Share on other sites

Thank you Edder, if you want to improve the patch, i think that would be a good thing the possibility of specify an end date for the bonus, you know what i mean? Would be more unnatended

- you set manually the bonus

- After 1 month (or whatever) system itself disable the bonus

I think this could be done adding two columns in sql like 'enddate' and 'active' and some code in Player::LoadFromDB

Thank you

I agree, will be more complete if add this two columns...

Thanks Edder for the patch.

Link to comment
Share on other sites

XP_Rates Patch [2]

SQL:

http://paste2.org/p/1051992

Code:

http://paste2.org/p/1052509

Tested with mangos core 10640

Try it...

* added starttime and endtime options

* added query to make an entry for all existing characters in character_xp_rates

I dunno what happen if you modify the core xp rates (from mangosd.conf), I tested with default values (1, 1, 1)!

Link to comment
Share on other sites

  • 2 weeks later...
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use