[Request] Double XP donner player

[danielle091]

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 ^^

[darkstalker]

something like this?

http://www.wowhead.com/spell=57353

[danielle091]

something like this?

http://www.wowhead.com/spell=57353

Something same, but for example doble exp... I mean

1x player normal

2x player donner

but I think so that your idea not is bad.

[Edder]

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) ...

[danielle091]

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.

[Edder]

I guess it happens in DeleteFromDB...

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

[xarly]

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

[danielle091]

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.

[Edder]

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

Hell yeah.

I wonder were my complete patch is.

Anyway, I'll try to rewrite it and implement the three rows (quest xp, explore xp, kill xp)...

[Edder]

New patch:

SQL:

http://paste2.org/p/1045237

Code:

http://paste2.org/p/1045234

Should work fine with clean mangos (10625)...

edit: damn URL tags

[xarly]

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

[danielle091]

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.

[Edder]

Well, ok I'll do some research on how to do this...

[Edder]

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)!

[madmax765]

hmm i might half to try this patch out