How to return donor points?

[MxSoft]

Is there a way to return all the donor points wasted in the server-??

 

[_Arthur]

nope
(unless you make an NPC for players to return their items, and make it give them points for them)

 

[MxSoft]

But if in gesior you can have a record of the points wasted per account, must be a way to return them to the accounts.......dont you think so?

 

[Cykotitan]

Do you want it in PHP or Lua? I'm not good enough at SQL to do it in pure SQL, sorry.

 

[_Arthur]

But if in gesior you can have a record of the points wasted per account, must be a way to return them to the accounts.......dont you think so?

Well, if you've got a record, then that's a different story.

 

[MxSoft]

Do you want it in PHP or Lua? I'm not good enough at SQL to do it in pure SQL, sorry.

Ty cyko, i can try a php

 

[MxSoft]

BUMP, and how do i reset all players to lvl 8 and remove all addons (rook them)
PLEASE

 

[Cykotitan]

If the script has been deleting records from table z_ots_comunication, it's not possible. It would've been possible if you fixed z_shop_history_item on time.

 

[MxSoft]

If the script has been deleting records from table z_ots_comunication, it's not possible. It would've been possible if you fixed z_shop_history_pacc on time.

But the table i want to use is z_shop_history_item.


Uploaded with ImageShack.us

 

[Cykotitan]

I meant z_shop_history_item, but offer_id is set to 0 for all rows
so it's not possible to see exactly what offer was it

now that you showed that picture it seems to be possible to return points, might look into it

 

[MxSoft]

OK ty

 

[Cykotitan]

Try:

UPDATE accounts SET premium_points = premium_points + (SELECT SUM(price) FROM z_shop_history_item WHERE z_shop_history_item.to_account = accounts.id) WHERE (SELECT COUNT(id) FROM z_shop_history_item WHERE z_shop_history_item.to_account = accounts.id LIMIT 1) > 0;

If everything worked, you can delete all entries if you want:

TRUNCATE TABLE z_shop_history_item;

 

[MxSoft]

Try:

UPDATE accounts SET premium_points = premium_points + (SELECT SUM(price) FROM z_shop_history_item WHERE z_shop_history_item.to_account = accounts.id) WHERE (SELECT COUNT(id) FROM z_shop_history_item WHERE z_shop_history_item.to_account = accounts.id LIMIT 1) > 0;

If everything worked, you can delete all entries if you want:

TRUNCATE TABLE z_shop_history_item;

Ok cyko thx i will try it in a couple of days, i need to recompile a server first, i will PM you if this works