Quote:
Originally Posted by Tony258
Hi,
Anyone got a script to send all accounts, that are not duplicated in ip address,
coins.
For example send all accounts 5k coins, but i dont want them to have
heaps of accounts like then they could make 10, and then 10x 5k = 50k
So anyone have a script so it restricts it to send coins to 1 account per ip.
Thanks Community
|
Okay.
1. Auto give cash triger script for all user
Code:
CREATE TRIGGER [free] ON [dbo].[user_cash]
after Insert
as
Update [user_cash] set [user_cash].amount=5000000,free_amount=5000000
From Inserted
Where [user_cash].group_id=inserted.group_id
and [user_cash].id=inserted.id
It will give to "amount=5000000 + free_amount=5000000 = 10000000 coin"
2. Auto give money(dill) triger script for all user
Code:
CREATE TRIGGER [money] ON [dbo].[user_character]
after Insert
as
Update [user_character] set [user_character].dwMoney=5000000
From Inserted
Where [user_character].character_no=inserted.character_no
and [user_character].character_name=inserted.character_name
and [user_character].user_no=inserted.user_no
It will give to "dwmoney=5000000 dill"
Enjoy!!