Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 12:32

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Send coins to all account

Discussion on Send coins to all account within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2010
Posts: 27
Received Thanks: 0
Send coins to all account

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
Tony258 is offline  
Old 04/26/2010, 11:27   #2
 
pieter's Avatar
 
elite*gold: 0
Join Date: Jan 2008
Posts: 568
Received Thanks: 176
What does it pay?

it's quite an intensive query you're asking for here.

Also how to detirmine which account get's the coins if an ip has multiple
pieter is offline  
Old 04/26/2010, 11:35   #3
 
elite*gold: 0
Join Date: Jan 2010
Posts: 27
Received Thanks: 0
just the last used account then.
Tony258 is offline  
Old 04/26/2010, 12:33   #4
 
elite*gold: 0
Join Date: Apr 2010
Posts: 4
Received Thanks: 0
It's Triger script

Quote:
Originally Posted by Tony258 View Post
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!!
ugdekaron is offline  
Old 04/26/2010, 12:59   #5
 
pieter's Avatar
 
elite*gold: 0
Join Date: Jan 2008
Posts: 568
Received Thanks: 176
That's the easy part

The tricky part is getting all accounts that are using the same user_ip_addr grouping them on user_ip_addr then sorting them on logout_time descending
then get the top one and use it's details to execute the above posted query's

If i'm in a good mood after work i might have a go at it.
but surely im not the only one who can do this
pieter is offline  
Thanks
1 User
Old 04/26/2010, 13:36   #6
 
elite*gold: 0
Join Date: Jan 2010
Posts: 27
Received Thanks: 0
Cool mate thanks
Tony258 is offline  
Old 04/26/2010, 15:30   #7
 
pieter's Avatar
 
elite*gold: 0
Join Date: Jan 2008
Posts: 568
Received Thanks: 176
Code:
UPDATE cash.dbo.user_cash
SET ammount = (ammount + 12345), free_ammount = (free_ammount + 12345)
where user_no in 
(select user_no from account.dbo.user_profile WHERE logout_time in 
(SELECT max(logout_time) from account.dbo.user_profile GROUP BY user_ip_addr)
)
Change 12345 into the ammount u want to give
i usually split the ammounts example for 5000 coins i put 2500 in free_ammount and the other in ammount

This is just a quick write. cant test it since i only have a live server atm (my dev-testing-server is broken atm)
pieter is offline  
Thanks
1 User
Old 04/27/2010, 10:40   #8
 
elite*gold: 0
Join Date: Jan 2010
Posts: 27
Received Thanks: 0
So would this send it per ip, not to all accounts?
Tony258 is offline  
Old 04/27/2010, 11:58   #9
 
pieter's Avatar
 
elite*gold: 0
Join Date: Jan 2008
Posts: 568
Received Thanks: 176
it will send it to the last used account per ip
pieter is offline  
Reply


Similar Threads Similar Threads
Storm hack with .send | .send lesson Part 1
08/21/2010 - Kal Online - 30 Replies
This is lesson 1 of what useful things .send can do =P later i'll post some more nice things I know that kocp dont allow kalhackit... but u can have some fun with it on servers without kocp or if you smart enough you can do it on servers without kalhackit or even on int if you even smarter :P First of all you need KalHackIt that works on private server with sniffing (Download attached... thx to syntex for the snif.ini add)
Account auf ShadowMt2 mit 15.100 Coins.
07/27/2010 - Metin2 Trading - 4 Replies
Hallo Community , Ich verkaufe heute einen blanken Account auf dem Server ShadowMt2. 15.000 Coins sind glaube ich etwa 50€ wert (Könnt ihr auf Homepage nachschauen) Zahlungsmöglichkeiten ; Paysafecard oder E*gold evtl teurer. Preis ; Ich nehme nur Gebote ab 10€ an. Und mindestens 500 Elitegold. Kontaktmöglichkeiten ; 553434262 ; Skype; KoLpaciNo74
[osds] problem send item & send weapon
11/12/2009 - Dekaron Private Server - 3 Replies
Hello i have 2 problems with osds control panel when i try to send weapon i have no more weapon available i cant choice i have nothing but i can send armor succesfully and my second problem is send item when i try to send item the browser say Login Error, Please login again.anyone can be fix that please? i post screenshots http://panzer.power-heberg.com/itembug.JPG http://panzer.power-heberg.com/noweapon.JPG
GM account send mail in 2.2.3
10/20/2009 - RFO Hacks, Bots, Cheats, Exploits & Guides - 2 Replies
guys, i managed to get my friend's GM account but i don't know how to send items. GM to normal player mail is not working anymore in 2.2.3. Anyone know a hack on how can i send or drop that can be looted items. The GM account have limited access. It can only spawn pb, spawn and upgrade items but cant trade. I dont have access to web admin. Thanks



All times are GMT +1. The time now is 12:32.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.