Jump to content
RF-Dev | MMO Private Server Development
PrinceRay

Useful Queries For RF Online

Recommended 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 :

You must be a registered member of RF-Dev and logged in to view this content.


SQL Queries To Changes Council :

You must be a registered member of RF-Dev and logged in to view this content.


SQL Queries To View Staff / GM Account :

You must be a registered member of RF-Dev and logged in to view this content.

 

SQL Queries To Changes GM Account Password : 

You must be a registered member of RF-Dev and logged in to view this content.

 

SQL Queries To Changes Race :

You must be a registered member of RF-Dev and logged in to view this content.


SQL Queries To Changes Job :

You must be a registered member of RF-Dev and logged in to view this content.

 

SQL Queries To Ban User :

You must be a registered member of RF-Dev and logged in to view this content.

 

Queries For WIPE  Database :

You must be a registered member of RF-Dev and logged in to view this content.

If You have question about the queries, feel free to ask (But try the query and explore first before you ask >:().

Tell me if you found Any Bugs.


Feel free to share your own sql queries ;)

Edited by PrinceRay
  • Like 2

Share this post


Link to post
Share on other sites

This is a pretty useful post so I'll go ahead and pin this for now. Thank you for sharing.

Share this post


Link to post
Share on other sites

DB Upgrade from 2.1.6 to 2.2.3 Created By: Lenin (From Equilibrium Gaming  I suppose)

  • AccountServer 3 Steps
  • GameServer  9 steps
  •  

You must be a registered member of RF-Dev and logged in to view this content.

You must be a registered member of RF-Dev and logged in to view this content.

Edited by PelusoBHxClan

Share this post


Link to post
Share on other sites

Update Guild Honour Manual 

You must be a registered member of RF-Dev and logged in to view this content. I did it for the 1st time so don't blame me that much Ron,, I'm still learning.. hehe
  • Like 1

Share this post


Link to post
Share on other sites

tbl_general(PT-GM,MaxLvl 66, Bag 5, Loss Quest, Disable Master Skill)

You must be a registered member of RF-Dev and logged in to view this content.

Share this post


Link to post
Share on other sites
You must be a registered member of RF-Dev and logged in to view this content.

No problem. Thanks for sharing. :)

Share this post


Link to post
Share on other sites
You must be a registered member of RF-Dev and logged in to view this content.

nice share, but can upload archive for query like this ?

sorry before, but i try to make this thread not too long with query like this,

i know u want sharing too, but please if u think ur query is too long like this :(, jst upload as archive

and if query already public like this, upload all in to 1 archive :(

Feature : 

You must be a registered member of RF-Dev and logged in to view this content.

 

You must be a registered member of RF-Dev and logged in to view this content.

Edited by PrinceRay

Share this post


Link to post
Share on other sites
You must be a registered member of RF-Dev and logged in to view this content.

Maybe I should make a RF-Dev git repository? 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×