Useful Queries For RF Online

[kyzryu 9]

Archived

Creadit : Roslaw, Novanakal, PrinceRay  and People For Create this Query

[Feature] : 

- Bank 7 Slot [Just Execute no Need Drop table Manual]
- Banned User
- Change Job
- Change Race
- Change Council
- Change GM Account Password
- Create GM Account
- Create User Account
- Disable Mail
- Disable Action
- Find Bank Pass
- Insert Premium and Cash
- Move Character to Another Account
- tbl_general(PT-GM,MaxLvl 66, Bag 5, Loss Quest, Disable Master Skill) [Just Execute no Need Drop table Manual]
- View Staff [GM]
- Vote Archon Trigger
- WIPE

 

MSSQL.zip

Edited November 18, 2017 by kyzryu

[erzon 3]

quick question. is the change council effective event without restarting the zone? or still need to restart the zone to take effect?

[DeusEx 328]

7 hours ago, erzon said:

quick question. is the change council effective event without restarting the zone? or still need to restart the zone to take effect?

you must restart the zone for apply the changes.

[jimharry 0]

any have query search item and remplace?

[piyuid 8]

USE [RF_WORLD]
UPDATE tbl_base set Lv='1'

I wanna to ask.. just my simple analogy
using this query, is it lowering the level on the player? and there is an error with this query?
I'm a little worried about using this query..

[MrAditya 2]

is there a query wipe archon and the council ?

[Senyorito 24]

Use RF_World
Truncate Table tbl_patriarch_candidate;

 

try this one

[Killerwoody 72]

Nvm found the issues

Edited May 26, 2018 by Killerwoody
I is the dumb

[noobita 0]

I wonder if rebirth system can be done through sql query?.. if it does can someone give me a clue or simply just release any existing file for it?..

Thanks in advance..

[PrinceRay 199]

6 hours ago, noobita said:

I wonder if rebirth system can be done through sql query?.. if it does can someone give me a clue or simply just release any existing file for it?..

Thanks in advance..

rebirth like what ?