Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 13:36

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

Advertisement



Automatic Coins Only For Players Online.

Discussion on Automatic Coins Only For Players Online. within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old   #1
 
SuperKick's Avatar
 
elite*gold: 0
Join Date: Nov 2012
Posts: 52
Received Thanks: 20
Automatic Coins Only For Players Online.

Anyone have script for automatic coins only for players online?...


Example: 200 Coins every 2 hours only for players online..



I had it but I lost it and is in elitepvpers not only for online users.
SuperKick is offline  
Old 04/24/2016, 22:21   #2
 
guesswho-.-'s Avatar
 
elite*gold: 0
Join Date: Jan 2012
Posts: 2,392
Received Thanks: 996
eh, I'll make a quick one for you coz I'm bored anyways

DECLARE @no varchar(36)

DECLARE kur SCROLL cursor FOR select user_no from Account.dbo.USER_PROFILE where login_flag <> 0
OPEN kur FETCH NEXT FROM kur INTO @no
WHILE @@FETCH_STATUS = 0
BEGIN
update Cash.dbo.user_cash set amount = amount+200 where user_no = @no
FETCH NEXT FROM kur INTO @no
END
CLOSE kur
DEALLOCATE kur

keep in mind I did not test it at all, it might require some tinkering with
guesswho-.- is offline  
Thanks
7 Users
Old 04/25/2016, 15:06   #3
 
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
Nice work Paul
[DEV]Dekaron is offline  
Old 12/16/2020, 16:46   #4
 
elite*gold: 0
Join Date: Feb 2017
Posts: 53
Received Thanks: 0
Quote:
Originally Posted by guesswho-.- View Post
eh, I'll make a quick one for you coz I'm bored anyways

DECLARE @no varchar(36)

DECLARE kur SCROLL cursor FOR select user_no from Account.dbo.USER_PROFILE where login_flag <> 0
OPEN kur FETCH NEXT FROM kur INTO @no
WHILE @@FETCH_STATUS = 0
BEGIN
update Cash.dbo.user_cash set amount = amount+200 where user_no = @no
FETCH NEXT FROM kur INTO @no
END
CLOSE kur
DEALLOCATE kur

keep in mind I did not test it at all, it might require some tinkering with
how to make it automatic send every hour?
noeblanco is offline  
Old 12/16/2020, 19:27   #5
 
guesswho-.-'s Avatar
 
elite*gold: 0
Join Date: Jan 2012
Posts: 2,392
Received Thanks: 996
Make a job in sql agent that executes this script every hour
guesswho-.- is offline  
Old 12/18/2020, 15:00   #6
 
elite*gold: 0
Join Date: Feb 2017
Posts: 53
Received Thanks: 0
Quote:
Originally Posted by guesswho-.- View Post
Make a job in sql agent that executes this script every hour
i tried this in job but it won't work, it works only if i will execute a query in cash, can you give me specific ideas on how to work this automatic dshop coins for online players?
noeblanco is offline  
Old 12/18/2020, 15:15   #7
 
guesswho-.-'s Avatar
 
elite*gold: 0
Join Date: Jan 2012
Posts: 2,392
Received Thanks: 996
you probably didnt start the job
guesswho-.- is offline  
Old 12/18/2020, 16:54   #8
 
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
or the SQL Server Agent is turn off

1) Make sure the SQL Server Agent is ON
2) to get working properly you can setup Schedules

there is a lots of option and possibility to make more like only give coins to player.
all depends how much your creative.
[DEV]Dekaron is offline  
Old 01/07/2022, 06:34   #9
 
elite*gold: 0
Join Date: Jul 2021
Posts: 16
Received Thanks: 0
gib guide for automatic send every hour
emdee29 is offline  
Old 01/07/2022, 14:24   #10
 
nager2013's Avatar
 
elite*gold: 0
Join Date: Feb 2014
Posts: 89
Received Thanks: 5
DECLARE @no varchar(36)

DECLARE kur SCROLL cursor FOR select user_no from Account.dbo.USER_PROFILE where login_flag <> 0
OPEN kur FETCH NEXT FROM kur INTO @no
WHILE @@FETCH_STATUS = 0
BEGIN
update Cash.dbo.user_cash set amount = amount+200 where user_no = @no
FETCH NEXT FROM kur INTO @no
END
CLOSE kur
DEALLOCATE kur

use this > credit: guesswho-.- and [DEV]Dekaron
nager2013 is offline  
Reply


Similar Threads Similar Threads
[HELP] Coins automatic
07/11/2015 - Dekaron Private Server - 11 Replies
Can any1 help how to send coins automatic? I mean when someone created a character. they have coins automatically. Where to edit at database. pls help Thank you
automatic coins
12/12/2012 - Dekaron Private Server - 4 Replies
how automatic add coins to players , pls help me
ineed add Automatic Buff SystemThe players
11/02/2011 - Rappelz Private Server - 8 Replies
ineed add Automatic Buff SystemThe players buff good عربي ياشباب انا عايز اضيف بف للاعبين يكون حلو اوتومات& #1610;ك
How to add automatic sent coins?
03/06/2010 - Dekaron Private Server - 5 Replies
Title says everything.



All times are GMT +1. The time now is 13:36.


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.