Reset all player's honor and arena points

[Scooby]

Hi! I will patch up my server to 3.2.0, and I want to reset all player's honor and arena points, but I dont know how. Can some1 help me?

Or just tell me where/how the mangos contains the points.

[Shin Darth]

Search in your "characters" database

[pelle]

...and on its data field. the udb's wiki has something on that

[bulek]

SQL FOR delete arena points:

UPDATE `characters` SET `data`=CONCAT(CAST(SUBSTRING_INDEX(`data`, ' ', 1247) AS CHAR), ' ', 0, ' ', CAST(SUBSTRING_INDEX(`data`, ' ', -47) AS CHAR));

Use this sql server off only when you remember and the security for an advance

[Lynx3d]

I don't think that's correct for 3.2.2, UpdateFields.h says:

PLAYER_FIELD_ARENA_CURRENCY = UNIT_END + 0x0450

Expanding further gives 0x6 + 0x8E + 0x0450 = 0x4E4

In decimal that's 1252, not 1247

Not sure if the -47 is correct, i'm too lazy to do the maths for you

In any case, make a backup because if you made a mistake you can lose some field values...

[Poppei]

goto mangos.conf

MaxHonorPoints = 75000

MaxArenaPoints = 5000

switch to

MaxHonorPoints = 0

MaxArenaPoints = 0

start server ,then have all plager 0 points server stop

then change it in

MaxHonorPoints = 75000

MaxArenaPoints = 5000

[xeross155]

goto mangos.conf

MaxHonorPoints = 75000

MaxArenaPoints = 5000

switch to

MaxHonorPoints = 0

MaxArenaPoints = 0

start server ,then have all plager 0 points server stop

then change it in

MaxHonorPoints = 75000

MaxArenaPoints = 5000

Doesn't that only work on players that actually log in ?

[Raynar]

You're right.

[hunuza]

This should no longer be a problem as honor and arena points are stored in a separate column in characters table...

[Raynar]

Since 3.3....maybe he has 3.2.2a