Jump to content

Reset all player's honor and arena points


Guest Scooby
 Share

Recommended Posts

  • 2 weeks later...

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

Link to comment
Share on other sites

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 :P

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

Link to comment
Share on other sites

  • 5 months later...
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 ?

Link to comment
Share on other sites

 Share

×
×
  • 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