Help how to remove Arena Coin from all players

04/17/2015 17:44 Immortality-Sro#1
Need Query remove arena coin from all player's :confused::confused:
04/17/2015 17:49 SkuulCandy#2
Hi, Arena coin ?? what
04/18/2015 17:07 {Skrillex}#3
He means Aeria Points( Donationpoints //AP)

Use this query:
Quote:
UPDATE PS_UserData.dbo.Users_Master SET Point =(Point - AMOUNT)
If you want to add AP to every player use this
Quote:
UPDATE PS_UserData.dbo.Users_Master SET Point =(Point + AMOUNT)
If you want to Add AP by One Player use this:
Quote:
UPDATE PS_UserData.dbo.Users_Master SET Point =(Point + AMOUNT) where UserID ='Acc-Name'
04/18/2015 17:14 SkuulCandy#4
Ahh, i mean it's AP per min activate ?
04/18/2015 17:18 {Skrillex}#5
No. Please read the topic carefully. He ask how he erase ap from all Players.

Regards
04/18/2015 19:50 SkuulCandy#6
Ah sorry :/ :3
04/20/2015 01:59 momocruz#7
Yes ϟƘƦƖןןΣ✘ is right

to remove AP to all account just use this script and all acount going have " 0 AP "


Quote:
USE PS_UserData
UPDATE Users_Master
SET Point += 0