Honor / Conquest and every other Currency

[Sylvian]

I think there is a big problem with all currencys (display and save).

1st issue: If you get some Valor Points with killing a boss in a heroic instance mod. The display is OK, you can see 70 points more but after logoff / login (or server restart) every points are gone.

2nd issue: just try to add yourself some honor points with gm command (.mod honor 500 for example give you 5 points the display is still ok) but after logoff / login (or server restart) you can see you have something like 7 000 000 in every currencies, after a second restart every is back to normal except you don't have the honor point you give yourself.

3rd issue: The source code is attempting to get the fields: CurrencyId1, CurrencyId2, CurrencyId3, CurrencyCount1, CurrencyCount2, CurrencyCount3 but they aren't in the officiel database structure. This fields able you to make a creature drop currency with ModifyCurrency function, but this one seems to not working correcly too.

Thanks for your help and everything you 're doing, sorry for my french english ^^.

Here is the SQL patch for adding missing SQL fields:

ALTER TABLE creature_onkill_reputation ADD COLUMN CurrencyId1 SMALLINT (6) UNSIGNED NOT NULL DEFAULT 0 AFTER TeamDependent, ADD COLUMN CurrencyId2 SMALLINT (6) UNSIGNED NOT NULL DEFAULT 0 AFTER CurrencyId1, ADD COLUMN CurrencyId3 SMALLINT (6) UNSIGNED NOT NULL DEFAULT 0 AFTER CurrencyId2, ADD COLUMN CurrencyCount1 MEDIUMINT (9) NOT NULL DEFAULT 0 AFTER CurrencyId3, ADD COLUMN CurrencyCount2 MEDIUMINT (9) NOT NULL DEFAULT 0 AFTER CurrencyCount1, ADD COLUMN CurrencyCount3 MEDIUMINT (9) NOT NULL DEFAULT 0 AFTER CurrencyCount2;

[Truffy]

honor works for me..relogged and it maintains.

[cristal]

currency is in the table "creature_onkill_reward "