Jump to content
RF-Dev | RF Online Development

PrinceRay

Member
  • Content Count

    250
  • Joined

  • Last visited

  • Days Won

    33

Everything posted by PrinceRay

  1. PrinceRay

    How to know the correct version of the server?

    2232 zoneserver filesize about 10mb+ 223 lower than 2232.
  2. PrinceRay

    New server RF-LIGHT (19/1/2019 OPEN)

    wrong translate or ?
  3. PrinceRay

    Texture/Glow Tutorial

    finally, there's a guide for this one with detailed effect style. i will post my tools for this one later ( to copy current weapon to new weapon effect, with auto particle counter )
  4. PrinceRay

    [TOOL] Server Side to Client Side Code Converter

    its better u allow multiple line, so multiline code converted rather than "coma"
  5. PrinceRay

    Making Auto Update

    Hello There ! So today i want share tutorial how i make a auto update for rf online 223 - 2232 since long time ago, hehe.. since there's already a few tutorial how to make auto update works fine, so i will show how i make the Auto Updates. example tutorial by DeusEx : in my tutorial maybe "more simple" from DeusEx, in my opinion, but it's all up to u again. Tools Required : Update Maker by NiTr0 (TMP Maker) RF Client, RF Launcher Emulator worked fine Video Tutorial (Remake from Tutorial 2013): You can download The Update Maker here : What do you guys think about my step to make auto update with other tutorial ?
  6. PrinceRay

    Launcher DevGordo [2.2.3.2] DONT NEED EMULATOR

    hehe, btw that source alrdy dead
  7. PrinceRay

    Launcher DevGordo [2.2.3.2] DONT NEED EMULATOR

    he alrdy said that
  8. PrinceRay

    How to make effect on under lvl 30 weapon?

    edit effect files, then u can have effect. its all about Chef folder
  9. PrinceRay

    Gold capsules are not visible in the drop.

    use original item.edf, nditem.edf, resource.edf then u can see difference. or maybe u just use patch modified to hack (to get filter loot), just try use original datatable
  10. PrinceRay

    Client automatically shuts down

    they close when u log in the game ? 1. what gameguard do u use ? 2. upload your RF_Online.bin, and post here ( virustotal first ) 3. try to not use any equipment on your account, then try log in. ( or did they dc when u notice the game ? )
  11. PrinceRay

    PHP RPK Extractor

    there's tons of repacker too
  12. PrinceRay

    RF Editor project *store edit* 2232

    why you sad when this project is "open source" do exploration with this stuff
  13. how u change the icon ? just do like that, change the mesh too.
  14. PrinceRay

    Itemloots Problem

    you need check if ur item Exist = 1 or not
  15. PrinceRay

    Build RF

    please read rules before u post like this
  16. PrinceRay

    R3T files

    are you VanCliff Estocado ? you can download here : btw when u release the Vanadium² ?
  17. PrinceRay

    RF Auto Update Launcher

    u can follow my tutorial which only using 1 tools
  18. PrinceRay

    NDLanguange.edf help

    use hex editor, change the totalChar to your total Character String +1 [00 Bytes] you want to edit, add some extra bytes to your files ( use INSERT Mode) example : https://heaven-gaming.org/downloads/ExtraBytes.mp4
  19. PrinceRay

    [2232] Fix for display hunter point

    Important : Using This Application will mess your "Gold Points" when buying from NPC. Use at ur own risk ! i'll try to make another tools to fix display hunter point
  20. PrinceRay

    Useful Queries For RF Online

    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 : /********************************************************** Copyright © 2012 - Heaven Network Website : https://www.heaven-gaming.org Facebook : https://www.facebook.com/princerayz Category : SQL Modules - Move Character To Another Account Table Inject : [RF_WORLD].[tbl_base] Object: RF_USER, RF_WORLD ************************************************************/ DECLARE @ID varchar(16) DECLARE @SAccount int DECLARE @Nick varchar(20) DECLARE @slot int set @Nick = 'PrinceRay' -- Nick Which you want to move set @ID = '!prince' -- Destination ID select @SAccount = serial from [RF_USER].dbo.tbl_UserAccount where id = CONVERT(binary,@ID) IF (@SAccount IS NULL) -- If ID Not Found In Normal Account, Check Is GM Or Not select @SAccount = serial from [RF_User].dbo.tbl_StaffAccount where ID = CONVERT(binary,@ID) IF ((SELECT COUNT(*) FROM [RF_WORLD].dbo.tbl_base WHERE Account = @ID and DCK=0) = 3 OR @SAccount IS NULL) -- If Slot Full / ID Not Found PRINT 'Cant Move Character Because Destination AccountID Slot is full / ID Not Found !' ELSE BEGIN IF(SELECT COUNT(*) FROM [RF_WORLD].dbo.tbl_base WHERE Slot = 0 AND Account = @ID AND DCK=0) = 0 BEGIN UPDATE [RF_WORLD].dbo.tbl_base set Account = @ID, slot='0' ,[email protected] where Name= @Nick print 'Character : "' + @Nick + '", Moved To Account : "' + @ID + '" Slot : 0' END ELSE IF(SELECT COUNT(*) FROM [RF_WORLD].dbo.tbl_base WHERE Slot = 1 AND Account = @ID AND DCK=0) = 0 BEGIN UPDATE [RF_WORLD].dbo.tbl_base set Account = @ID, slot='1' ,[email protected] where Name= @Nick print 'Character : "' + @Nick + '", Moved To Account : "' + @ID + '" Slot : 1' END ELSE IF(SELECT COUNT(*) FROM [RF_WORLD].dbo.tbl_base WHERE Slot = 2 AND Account = @ID AND DCK=0) = 0 BEGIN UPDATE [RF_WORLD].dbo.tbl_base set Account = @ID, slot='2' ,[email protected] where Name= @Nick print 'Character : "' + @Nick + '", Moved To Account : "' + @ID + '" Slot : 2' END --SELECT Serial,Name,Account,Slot,Race,AccountSerial FROM [RF_WORLD].dbo.tbl_base where Account = @ID and DCK=0 END SQL Queries To Changes Council : /******************************************************************* Copyright © 2012 - Heaven Network Website : www.heaven-gaming.org Category : SQL Modules - Changes Council Database Inject : [RF_World] Object: Table [dbo].[tbl_patriarch_candidate] Notice : If Player Are Not In Ranking System, He Can't Promoted ********************************************************************/ USE RF_World DECLARE @eserial int DECLARE @race tinyint DECLARE @lv tinyint DECLARE @rank int DECLARE @pvppnt float DECLARE @aserial int DECLARE @aname varchar(17) DECLARE @gserial int DECLARE @gname varchar(17) DECLARE @class tinyint DECLARE @status tinyint /* [+]Class Information: 0 "Archon"; 1 "Left - Consul"; 2 "Left - Strike Team"; 3 "Left - Deffense Team"; 4 "Left - Support Team"; 5 "Right - Consul"; 7 "Right - Deffense Team"; 6 "Right - Strike Team"; 8 "Right - Support Team"; [+]eSerial Information It's Generated Automatically, It's Take Latest Council Period [+]Status Information 1 - For Assign Him To Next Council Election 2 - To Revoke His Status From Current Council 3 - To Make Him Current Council */ 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 [email protected]) SET @lv = (select lv from tbl_PvpRankToday where [email protected]) SET @rank =(select rank from tbl_PvpRankToday where [email protected]) SET @pvppnt =(select PvpPoint from tbl_PvpRankToday where [email protected]) SET @aserial =(select serial from tbl_PvpRankToday where [email protected]) SET @gserial =(select GuildSerial from tbl_PvpRankToday where [email protected]) SET @gname =(select GuildName from tbl_PvpRankToday where [email protected]) SET @status = 3 -- See Status Information Insert into [dbo].[tbl_patriarch_candidate] (eSerial, Race, Lv, Rank, PvpPoint, ASerial, AName, GSerial, GName, ClassType, State, dtUpScore) Values (@eserial, @race, @lv, @rank, @pvppnt, @aserial, @aname, @gserial, @gname, @class, @status, getdate() ) print 'Current Archon Period : ' + CAST(@eserial as varchar) print 'Nickname : ' + @aname print 'Race : ' + CAST(@race as varchar) print 'Level : ' + CAST(@lv as varchar) print 'Ranking : ' + CAST(@rank as varchar) print 'PvP Point : ' + CAST(@pvppnt as varchar) print 'Account : ' + CAST(@aserial as varchar) print 'Guild Name : ' + @gname print 'Guild Serial :' + CAST(@gserial as varchar) print 'Promoted To : ' + CAST(@class as varchar) print 'Status : ' + CAST(@status as varchar) SQL Queries To View Staff / GM Account : /******************************************************************* Copyright © 2012 - Heaven Network Website : www.heaven-gaming.org Category : SQL Modules - View Staff Account Database Inject : [RF_User] Object: Table [dbo].[tbl_StaffAccount] ********************************************************************/ USE RF_User select convert(varchar, ID), Realname, convert(varchar, PW) From tbl_StaffAccount SQL Queries To Changes GM Account Password : /******************************************************************* Copyright © 2012 - Heaven Network Website : www.heaven-gaming.org Category : SQL Modules - Changes GM Password Database Inject : [RF_User] Object: Table [dbo].[tbl_StaffAccount] ********************************************************************/ use rf_user declare @ID varchar(25) ; declare @NewPass varchar(25); declare @NewName varchar(25); set @ID ='!prince'; -- Current GM ID set @Newpass ='testSQLModules'; -- New Password update tbl_StaffAccount set PW=convert(binary,@NewPass) where id=convert(binary,@ID) where id=convert(binary,@ID) select convert(varchar, ID), Realname, convert(varchar, PW) From tbl_StaffAccount where id= convert (binary,@ID) SQL Queries To Changes Race : /******************************************************************* Copyright © 2012 - Heaven Network Website : www.heaven-gaming.org Category : SQL Modules - Changes Race Database Inject : [RF_World] Object: Table [dbo].[tbl_base] ********************************************************************/ /* [+]Code Race Information: 00 = Bells Female 01 = Bells Male 02 = Cora Female 03 = Cora Male 04 = Accrectian */ use RF_World declare @nick varchar(25); declare @race varchar(2); set @nick ='PrinceRay'; -- Put Nick Here set @race ='03'; -- See Table Race update tbl_base set race=(@race) where name=(@nick) SQL Queries To Changes Job : /******************************************************************* Copyright © 2012 - Heaven Network Website : www.heaven-gaming.org Category : SQL Modules - Changes Job Database Inject : [RF_World] Object: Table [dbo].[tbl_base] ********************************************************************/ /* [+]Code Job Information: CW= CORA WARIOR B0= DEFAULT JOB A,B,C = ACC, BELLS, CORA Warrior [A/B/C]WB0 FORCE = [B/C]FB0 RANGER = [A/B/C/]RB0 FOR LAUNCHER USE THIS TOO SPECIALIST = [A/B/C]SB0 [+] Note : Please Use Reset Job Potion Before Changes Job */ use RF_World declare @nick varchar(25); declare @class varchar(4); set @nick ='PrinceRay'; -- Nickname set @class ='AWB0'; -- See Code Job update tbl_base set class=(@class) where name=(@nick) SQL Queries To Ban User : /******************************************************************* Copyright © 2012 - Heaven Network Website : www.heaven-gaming.org Category : SQL Modules - Ban User Database Inject : [RF_User] Object: Table [dbo].[tbl_UserBan] ********************************************************************/ USE [RF_User] DECLARE @Nick VARCHAR(13), @Aserial int, @nSerial int, @nPeriod int, @nKind int, @szReason varchar(32), @GMReason varchar(32), @GMWriter varchar(32), @ReasonType tinyint /** Nick Which you want to ban **/ SET @Nick = 'PrinceRay' set @Aserial = (Select AccountSerial from RF_World.dbo.tbl_base where Name = @Nick) SELECT @nSerial = @Aserial /** 24 = 1 day, 999 = banned permanen ***/ SET @nPeriod = '999' /**Reason Ban**/ SET @szReason = 'fly and blink' /**Banned By **/ SET @GMWriter = 'PrinceRay' /** JANGAN DI GANGGU GUGAT **/ SET @GMReason = @szReason SET @ReasonType = '1' SET @nKind = '0' INSERT INTO [RF_User].[dbo].[tbl_UserBan] ( [nAccountSerial],[dtStartDate],[nPeriod],[nKind],[szReason],[GMWriter],[reasontype]) VALUES(@nSerial,CONVERT(datetime,GETDATE()),@nPeriod,@nKind,@szReason,@GMWriter,@ReasonType) Queries For WIPE Database : USE [RF_USER] GO delete from tbl_rfaccount; delete from tbl_UserBan; delete from tbl_userAccount; delete from tbl_StaffAccount; delete from tbl_RFAdmin; delete from tbl_RFTestAccount; delete from tbl_StaffAccount; delete from tbl_UserBan; USE [RF_WORLD] GO delete from tbl_general; delete from tbl_base; delete from tbl_AccountTrunk; delete from tbl_AccountTrunk_Extend; delete from tbl_AccountTrunkCharge; delete from tbl_aminepersonal_inven; delete from tbl_animuslog; delete from tbl_battletournament; delete from tbl_Buddy; delete from tbl_Guild; delete from tbl_GuildBattleRank; delete from tbl_history_electraceboss_0; delete from tbl_history_electraceboss_1; delete from tbl_history_electraceboss_2; delete from tbl_history_electraceboss_candidacy_0; delete from tbl_history_electraceboss_candidacy_1; delete from tbl_history_electraceboss_candidacy_2; delete from tbl_history_electraceboss_winner_0; delete from tbl_history_electraceboss_winner_1; delete from tbl_history_electraceboss_winner_2; delete from tbl_honor_guild; delete from tbl_inven; delete from tbl_Macro; delete from tbl_patriarch_candidate; delete from tbl_patriarch_comm; delete from tbl_patriarch_elect; delete from tbl_Punishment; delete from tbl_pvporderview; delete from tbl_pvppointlimitinfo; delete from tbl_PvpRankToday; Queries For Prevent Delete Character By Specific Level /**************************************************************** Copyright © 2018 - Heaven Network Website : https://www.heaven-gaming.org Facebook : https://www.facebook.com/princerayz Category : SQL Modules - Anti Delete Character Table Inject : [RF_WORLD].[tbl_base] Object : - StoredProcedure [dbo].[pDelete_Base] - StoredProcedure [dbo].[pUpdate_DeleteName_Step1] - StoredProcedure [dbo].[pUpdate_DeleteName_Step2] Description : This query will prevent Character Deletion for specific Level Rule, @LevelReq>0 Mean if player create character for first time, and not login yet, player can delete the character, but after he login, he can't delete it any more. ****************************************************************/ USE [RF_World] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[pDelete_Base] @serial int AS BEGIN SET XACT_ABORT ON SET NOCOUNT ON -- Atur Disini Level nya, < artinya lebih kecil > artinya lebih besar, -- Contoh : <= 40, lebih kecil 40 dan level 40 -- >= 40, diatas level 40 dan level 40 BEGIN TRY DECLARE @LevelReq INT; SELECT @LevelReq = Lv FROM [dbo].[tbl_base] Where Serial = @serial BEGIN TRANSACTION IF (@LevelReq >0 AND @LevelReq < 40 ) RETURN 0 ELSE UPDATE [dbo].[tbl_base] SET DCK = 1, Arrange = 1, DeleteTime = getdate() WHERE Serial = @serial COMMIT END TRY BEGIN CATCH IF @@TRANCOUNT>0 ROLLBACK TRANSACTION END CATCH END GO ----------------- 2nd STEP ----------------- ALTER PROCEDURE [dbo].[pUpdate_DeleteName_Step1] @serial int AS BEGIN SET XACT_ABORT ON SET NOCOUNT ON -- Atur Disini Level nya, < artinya lebih kecil > artinya lebih besar, -- Contoh : <= 40, lebih kecil 40 dan level 40 -- >= 40, diatas level 40 dan level 40 BEGIN TRY DECLARE @LevelReq INT; SELECT @LevelReq = Lv FROM [dbo].[tbl_base] Where Serial = @serial BEGIN TRANSACTION IF (@LevelReq >0 AND @LevelReq < 40 ) RETURN 0 ELSE UPDATE [dbo].[tbl_base] SET deletename=name WHERE serial = @serial COMMIT END TRY BEGIN CATCH IF @@TRANCOUNT>0 ROLLBACK TRANSACTION END CATCH END GO ----------------- FINAL STEP ----------------- ALTER PROCEDURE [dbo].[pUpdate_DeleteName_Step2] @serial int AS BEGIN SET XACT_ABORT ON SET NOCOUNT ON -- Atur Disini Level nya, < artinya lebih kecil > artinya lebih besar, -- Contoh : <= 40, lebih kecil 40 dan level 40 -- >= 40, diatas level 40 dan level 40 BEGIN TRY DECLARE @LevelReq INT; SELECT @LevelReq = Lv FROM [dbo].[tbl_base] Where Serial = @serial BEGIN TRANSACTION IF (@LevelReq >0 AND @LevelReq < 40 ) RETURN 0 ELSE UPDATE [dbo].[tbl_base] SET name='*'+cast(serial as varchar) WHERE serial = @serial COMMIT END TRY BEGIN CATCH IF @@TRANCOUNT>0 ROLLBACK TRANSACTION END CATCH END GO Deleting character have 3 step in zone system, so i make 3 prevention, normally if step 1 executed, the 2 more step not proceed, but for bug prevention, i will leave it for 3. This query prevent character level 1 ~ 39 to not be deleted (Level 0 mean player never login the character, only create. still can delete, but if player login, he can't delete it anymore until lvl 40) Note : USE AT YOUR OWN RISK 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
  21. PrinceRay

    Bypass RF Intro/Prologue Movie

    PlayedNum= 0 rather than = ./
  22. PrinceRay

    Corfokit RF tool 223

  23. PrinceRay

    [HELP]Template Corfokit version 2.2.3.2

    install sql server compact
  24. PrinceRay

    PB SYSTEM MESSAGE

    disable it from ur modules
  25. PrinceRay

    Yorozuya - Open Source Zone Guard [2.2.3.2]

    the owner not develop this guard anymore, u can do research with this source
×