dragon coin query

[megingjard]

hi ragezoner . :)

can some people share query for insert dragon coin

[MentaL]

[major333]

hi ragezoner . :)

can some people share query for insert dragon coin

You want to elaborate on what you query you need , Dragon Coins as in Cash Shop coins ?

[megingjard]

the query almost same with cash query. it posible. ?

[major333]

the query almost same with cash query. it posible. ?

Most likely possible, can you take a screen-shot of what exactly what you want changed ?

[megingjard]

USE [dnmembership]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[P_ModCashBalance]
@nvcAccountName = N'megingjard', @IntCashBalance = 45454
SELECT 'Return Value' = @return_value
GO

what command @ for dragon coin?

[major333]

USE [dnmembership]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[P_ModCashBalance]
@nvcAccountName = N'megingjard', @IntCashBalance = 45454
SELECT 'Return Value' = @return_value
GO

what command @ for dragon coin?

Try the command in game "/ CP 'number of coins' "

[megingjard]

ok i tell the trust . i am from drago-dn admin want to make some auto query send to every player online , the target want to send the dragon coin for every 2 hour online.. just that.
several day . maybe a month already trying to find dragon coin table but cant be find . maybe it in binary or something . so i hope someone can help me about this. i just want make my player happy to play . that all

[major333]

ok i tell the trust . i am from drago-dn admin want to make some auto query send to every player online , the target want to send the dragon coin for every 2 hour online.. just that.
several day . maybe a month already trying to find dragon coin table but cant be find . maybe it in binary or something . so i hope someone can help me about this. i just want make my player happy to play . that all

I'll see what i can do, depends on if someone else beats me to it. I'll Get back to you once i have it sorted. Dragon coin is Cashshop coins isn't it ?

[megingjard]

yes. that true

[Shinobi-X]

I'll see what i can do, depends on if someone else beats me to it. I'll Get back to you once i have it sorted. Dragon coin is Cashshop coins isn't it ?

Nope, Dragon coin unit is DC while Cashshop coin unit is CC, of course you can set an item to be buy-able with CC only or both CC and DC points.

[megingjard]

who anyone play epic-dn here? them give to people with some reward cc for everytime online.
like 1 hour online get 200cc like that

so i planning want to make almost same with him but it only in currect Dragon Coin Point.
or it have other function to send maybe using ( dragon coin coupon / or / raw point dc) to everyone using dnt or something?..

the script can be function if it have online user and execute on php using query. to select everyone $online to send the dragon coin the page will be auto refresh every 1 hour or 2 and then it execute again and again non stop . the weird is cant be found dc amount table

thank you guy for reply

[Natzugen]

who anyone play epic-dn here? them give to people with some reward cc for everytime online.
like 1 hour online get 200cc like that

so i planning want to make almost same with him but it only in currect Dragon Coin Point.
or it have other function to send maybe using ( dragon coin coupon / or / raw point dc) to everyone using dnt or something?..

the script can be function if it have online user and execute on php using query. to select everyone $online to send the dragon coin the page will be auto refresh every 1 hour or 2 and then it execute again and again non stop . the weird is cant be found dc amount table

thank you guy for reply

you can try using the the daily login event using the coupons or doing it via sql jobs directly with the cc

[Shinobi-X]

First we need to know where that DC table is in the database. Then the query comes in.. I'll give it a try later..

Edit : found them it is 'PetalIncome' table.. and found the SP/Query, look for dbo.P_AddPetalIncome / dbo.P_AddPetalIncomeByAdmin / dbo.P_AddPetalIncomeForReward.

*Hint - TotalDT column is gametime value in Minute ^_^
:D

[megingjard]

so the reward will be send every with gametime has been set in TotalDT? btw thank you very much for helping. :)