Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- - script FixPvPPoints -1,{
- end;
- OnInit:
- .@data = query_sql("SELECT `account_id`, `value` FROM `acc_reg_num` WHERE `key` = '#PVPPOINT' AND `account_id` IN ( SELECT `account_id` FROM `char` WHERE `login` = 0)", .@account_id, .@points);
- query_sql("DELETE FROM `acc_reg_num` WHERE `key` = '#PVPPOINT' AND `account_id` IN ( SELECT `account_id` FROM `char` WHERE `login` = 0)");
- for(.@i = 0; .@i < .@data; .@i++)
- .@store$[.@i] = "('"+.@account_id[.@i]+"', '#PVPPOINTS', '"+.@points[.@i]+"')";
- query_sql("INSERT INTO `acc_reg_num` (`account_id`,`key`,`value`) VALUES "+implode( .@store$, "," )+" ON DUPLICATE KEY UPDATE `value`= `value` + values(`value`)");
- addrid(0);
- .@fix = #PVPPOINT;
- #PVPPOINT = 0;
- #PVPPOINTS += .@fix;
- end;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement