Advertisement
existence_dev92

Untitled

Mar 23rd, 2019
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. - script FixPvPPoints -1,{
  2. end;
  3.  
  4. OnInit:
  5. .@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);
  6. query_sql("DELETE FROM `acc_reg_num` WHERE `key` = '#PVPPOINT' AND `account_id` IN ( SELECT `account_id` FROM `char` WHERE `login` = 0)");
  7. for(.@i = 0; .@i < .@data; .@i++)
  8. .@store$[.@i] = "('"+.@account_id[.@i]+"', '#PVPPOINTS', '"+.@points[.@i]+"')";
  9. query_sql("INSERT INTO `acc_reg_num` (`account_id`,`key`,`value`) VALUES "+implode( .@store$, "," )+" ON DUPLICATE KEY UPDATE `value`= `value` + values(`value`)");
  10. addrid(0);
  11. .@fix = #PVPPOINT;
  12. #PVPPOINT = 0;
  13. #PVPPOINTS += .@fix;
  14. end;
  15.  
  16. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement