Jump to content
PrinceRay

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

 

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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

Share this post


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...