-
Posts
520 -
Joined
-
Last visited
-
Days Won
5
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Everything posted by Sryx
-
Try to 2 click in the korean tabs or change it here. YourRO Folder/savedata/ChatWndInfo_U.lua
-
If you disable Packet Obs Diff to your client you also need to disable #define PACKET_OBFUSCATION. src/config/core.h then put // or comment in this line. //#define PACKET_OBFUSCATION
-
Try this post if you encounter error. prontera,163,184,4 script Yoesic 116,{ mes "What Song Would you like to play?"; switch(select("Streamside:Move your Body:Make a Move:None")) { case 1: if(countitem(.req) < .num) goto noo_noo; playBGMall "12","prontera"; announce "Now playing Streamside ~ "+strcharinfo(0)+" ",bc_all,0xFFFF00; delitem .req, .num; close; case 2: if(countitem(.req) < .num) goto noo_noo; playBGMall "13","prontera"; delitem .req, .num; close; case 3: if(countitem(.req) < .num) goto noo_noo; playBGMall "14","prontera"; delitem .req, .num; close; case 4: mes "Okay Bye Cya Later"; close; } noo_noo: mes "No item"; close; OnInit: set .req, 675; // item requirement set .num, 1; // quantity end; }
-
Do it using OnPCLogintEvent, haven't tried this hope it works. First query it will check if the character have the petrequest. Second query will delete data on char_reg_num. Next line it will set the #petrequest to 1. - script transfer -1,{ OnPCLoginEvent: query_sql ("SELECT `char_id` FROM `char_reg_num` WHERE `char_id`= '" + getcharid(0) + "' and `key` = 'petquest'", .@char_id$); if(.@char_id$ != ""){ query_sql ("DELETE FROM `char_reg_num` WHERE `char_id`= '" + getcharid(0) + "' and `key` = 'petquest'"); set #petquest , 1; end; } }
-
Freebie IP Problem ( want to give freebie again )
Sryx replied to mmjgold's question in Scripting Support
Idk if this what you mean. Change this line. if(!#Freebie && ( getd("$" + .@lip$ + "_ASD") == 0 )) { to (it will give freebies in every new account) if(!#Freebie) { And remove this lines. query_sql ("SELECT `last_ip` FROM `login` WHERE `account_id`= '" + getcharid(3) + "'", .@last_ip$); setd "$" + .@last_ip$ + "_ASD", getd("$" + .@last_ip$ + "_ASD") + 1; If you wan't to give freebies again in specific account you can use the given script above. -
Here mes "[Job Master]"; mes "You are now " + callfunc("F_InsertArticle", jobname(.@i)) + "!"; if (.@i == Job_Novice_High && .LastJob) lastJob = Class; jobchange .@i; Add here>> resetlvl(1);
-
Delete some items of certains accounts using SQL
Sryx replied to Kakaroto's question in Database Requests
If multiple this? DELETE FROM `storage` WHERE `nameid` in ('4407','4408','4407') and account_id in ('2000000','2000001','20000002'); Yes you can also use BETWEEN if you have a series/continuous of account id's. (BETWEEN keyword speak itself) DELETE FROM `storage` WHERE `nameid` in ('4407','4408','4407') and account_id BETWEEN '2000000' and '2000005'; -
Delete some items of certains accounts using SQL
Sryx replied to Kakaroto's question in Database Requests
DELETE FROM `storage` WHERE `nameid` = '4407' and account_id = '2000000'; If you want to delete in more than 1 account or more than 1 item. DELETE FROM `storage` WHERE `nameid` in ('4407','4408') and account_id in ('2000000','2000001'); -
DId you login using tijo2035? Make another account that has account id 2000000 don't use tijo2035 its for the server and sql connection.
-
I try many ID but no one work and my clientinfo.xml match my compiled packet_db Post screenshot of your login table, clientinfo and mmo.h
-
1. ID 1 is reserved for the server and sql connection, and for your first account use '2000000'. 2. Make sure that your clientinfo.xml match your compiled packet db.
-
Harmony is already dead. I suggest to you to find another gameguard.
-
https://rathena.org/wiki/Custom_Items https://rathena.org/wiki/Adding_a_Script
-
1. If your folder name is KOREAN use UNICODE. 2. If your folder name is GERBISH (like the folders inside the grf) use ASCII.
-
Here's the wiki. https://rathena.org/wiki/Custom_Items
-
Try this it will delete the account and all characters under the account id 2000005. DELETE FROM `login` where `account_id` = '2000005'; DELETE FROM `char` where `account_id` = '2000005'; For the Diff Account. DELETE FROM `char` where `char_id` IN ('1500099','1500242');
-
Try to drop all you log tables, then reimport the logs.sql to solve all missing tables. (it will fix all missing/duplicate columns)
-
https://rathena.org/wiki/Edit_Max_Level This might help you.
-
Eto sundan mo nalang ang mga panuto dito sa itaas. https://raw.githubusercontent.com/rathena/rathena/master/npc/scripts_custom.conf
-
https://rathena.org/board/topic/106413-kro-full-client-2016-06-22-includes-bgm-rsu/
-
Update your kro and grf to get the new map resources.
-
Disregard mo nlng ung mapcache bro. Pero fix jan is download mo 4.0 na .NET Framework
-
Post screenshot of you console (map server)