Jump to content

Useful Queries For RF Online


Recommended Posts

54 minutes ago, Zenobyte said:

uhmm.. how about 55 cap can i still use the tbl_general(PT-GM,MaxLvl 66, Bag 5, Loss Quest, Disable Master Skill).sql?

yes you can use it, just change maxlevel to 55

feel free to ask anything, but everything has a price

W W W . H E A V E N - G A M I N G . O R G

everything has a price to be paid, but not always in terms of money

 

Link to post
Share on other sites
  • Replies 50
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

So, has been long time for me to keep this SQL Queries for myself  i hope this useful for all of you test SQL Queries To Move Character to Another Account : /***********************

DB Upgrade from 2.1.6 to 2.2.3 Created By: Lenin (From Equilibrium Gaming  I suppose) AccountServer 3 Steps GameServer  9 steps   AccountServer.rar GameServer.rar

Update Guild Honour Manual  I did it for the 1st time so don't blame me that much Ron,, I'm still learning.. hehe

Posted Images

On 6/26/2018 at 4:47 PM, noobita said:

Like turning your level back to 1 after Maxed up in exchange with a reward points for game cp.. I've seen this done by Fedor but it was module made, i'm thinking of only using game cp to do the process through a button..

Thanks for the reply..

sorry to bump this, but anyone know how it will work? i'm also very interesting for this kind of system

Link to post
Share on other sites
  • 8 months later...
On 8/9/2017 at 6:19 AM, PrinceRay said:

SET @aname    = 'PrinceRay' -- Player Nickname which u want grant to Council SET @class    = 0 -- See Class Information SET @eserial = (select top 1 eSerial from [RF_World].dbo.tbl_patriarch_candidate order by eSerial desc) SET @race    = (select race from tbl_PvpRankToday where name=@aname) SET @lv    = (select lv from tbl_PvpRankToday where name=@aname) SET @rank    =(select rank from tbl_PvpRankToday where name=@aname) SET @pvppnt    =(select PvpPoint from tbl_PvpRankToday where name=@aname) SET @aserial    =(select serial from tbl_PvpRankToday where name=@aname) SET @gserial    =(select GuildSerial from tbl_PvpRankToday where name=@aname) SET @gname    =(select GuildName from tbl_PvpRankToday where name=@aname) SET @status    = 3  -- See Status Information

candidate order by eSerial desc. why not work sir? i have problem my sql  eror line 15 > Order by eSerial desc
and deleted > Order by eSerial desc < and tested again work execute, i see serial name race pvpranktoday etc same and im restart zone server checked why not chane Archon ? status information 3 and class information 0 sir.. help me  

Im Newbie With My Powers aaaaaaaaaaa

Link to post
Share on other sites
  • 1 year later...
On 12/5/2019 at 1:23 PM, DroneInTheSky said:

candidate order by eSerial desc. why not work sir? i have problem my sql  eror line 15 > Order by eSerial desc
and deleted > Order by eSerial desc < and tested again work execute, i see serial name race pvpranktoday etc same and im restart zone server checked why not chane Archon ? status information 3 and class information 0 sir.. help me  

 

Just now, chepotjr said:

register your character to the Race Manager at HQ as ARCHON first. after then I found error some info. I can run query. maybe wait till nextday

 

Link to post
Share on other sites
  • 2 months later...
On 8/11/2017 at 3:32 AM, PelusoBHxClan said:

Insert Premium and Cash

 

  Hide contents

 

/****** Insert Premium and Cash   ******  by : Hanry Roslaw Saputra ******/

/****** Script Owner : Hanry Roslaw Saputra ******/

/****** Created by : Hanry Roslaw Saputra ******/

DECLARE @name VARCHAR(13)
DECLARE @pw VARCHAR(13)
DECLARE @birth smalldatetime
DECLARE @email varchar(255)
DECLARE @status int
DECLARE @cash int
DECLARE @lama int

/****** Your Name ******/
SET @name = 'roslaw'

/****** Your Password ******/
SET @pw = '123456789'

/****** Birthday ******/
SET @birth = '07-22-1988'

/****** Your Email ******/
SET @email = '[email protected]'

/****** Set 2 for turn on Premium or Set 1 for turn off Premium  ******/
SET @status = '2'

/****** How long players get premium service (in days) exemple : 1 for 1 days, 2 for 2 days, 3 for 3days. ******/
SET @lama = '5'

/****** Cashpoint amount ******/
SET @cash = '100000'

/************************************************************************************************************************************************/

INSERT INTO [RF_USER].[dbo].[tbl_rfaccount] 
    (
        [id],
        [password],
        [birthdate],
        
    )
    VALUES
    (
        CONVERT(BINARY(13),@name),
        CONVERT(BINARY(13),@pw),
        @birth,
        @email
    )

INSERT INTO [BILLING].[dbo].[tbl_UserStatus] 
   
        [id],
        [Status],
        [DTStartPrem],
        [DTEndPrem],
        [Cash]
    )
    VALUES
    (
        @name,
        @status,
        CONVERT(datetime,GETDATE()),
        CONVERT(datetime,GETDATE()[email protected]),
        @cash
    )

/***********************************************************************************************************************************************/

 

 

how if i don't have UserStatus table ?

Link to post
Share on other sites
10 hours ago, Machine said:

check the billing that you are using man.

 

DHSN3.png

Just this, no UserStatus or Personal_Billing.

And i already try to put on manual, but nothing changes.

Edited by Mooo
Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...