Peopleperson49

I'm not sure if I'm posting in the correct location, so please move if not. Anyways, how do I make an offline server using sql files? I want the functionality of sql. Peopleperson49

Glad we all could help. I completely missed the sleep2, lol. Peopleperson49

Yeap, you said that so much more simply than I did Pneuma, lol. Peopleperson49

What error? You didn't post anything. Thanks. Peopleperson49

I suggest you use something like bindcommand to do that. You can have it do the check just like a script would and then allow that command to be used if they meet the conditions. Requires no src mods. Peopleperson49

I didn't try your script out, but try changing the format of your progress bar to something like this: progressbar "RRGGBB",3; Peopleperson49 I believe yoru color format is wrong. *progressbar "<color>",<seconds>; This command works almost like sleep2, but displays a progress bar above the head of the currently attached character (like cast bar). Once the given amount of seconds passes, the script resumes. If the character moves while the progress bar progresses, it is aborted and the script ends. The color format is in RGB (0xRRGGBB). The color is currently ignored by the client and appears always green. Also message strcharinfo(0),"Text"; should be more like below. But it is also easier for me to just use mes "strcharinfo(0)+" TEXT."; command. *message "<character name>","<message>"; That command will send a message to the chat window of the character specified by name. The text will also appear above the head of that character. It will not be seen by anyone else.

I added a version 1.2 now. The warning is a simple message, but atleast people will have a clue. As long as they actually read it... Peopleperson49

It's not really a bug, but I will script in a warning of this condition. A valid point though. Thanks. Peopleperson49

Nowhere in the script has it delete from the players storage. Peopleperson49 query_sql("DELETE FROM `atcommandlog` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `BalanceRank` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `bonus_script` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `branchlog` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `buyingstore_items` WHERE `buyingstore_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `buyingstores` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `cashlog` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `cp_charprefs` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `cp_choko_rename_log` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `elemental` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `emprank` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `friends` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `guild` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `guild_member` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `homunculus` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `hotkey` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `memo` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `mercenary` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `mercenary_owner` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `mvplog` WHERE `kill_char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `mvprank` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `npclog` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `party` WHERE `leader_char`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `pet` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `picklog` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `pvprank` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `quest` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `sc_data` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `skill` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `skillcooldown` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `vendings` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `zenylog` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `inventory` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `cart_inventory` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `global_reg_value` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `char` WHERE `char_id`='"+escape_sql(.@char_id)+"'");

How do I modify the lua files for adding player class skills to homun characters. I can easily do it for adding or modify player class skills to other classes, but I can't seem to get the homun lua format correct. I tried this below with no luck. Any ideas? Thanks. Peopleperson49 [SKID.AL_HEAL] = { "AL_HEAL"; SkillName = "Heal", MaxLv = 10, SpAmount = { 13, 16, 19, 22, 25, 28, 31, 34, 37, 40 }, bSeperateLv = true, AttackRange = { 9, 9, 9, 9, 9, 9, 9, 9, 9, 9 }, NeedSkillList = { [JOBID.JT_CRUSADER] = { { SKID.CR_TRUST,10 }, { SKID.AL_DEMONBANE,5 } } } _NeedSkillList = { { SKID.HLIF_HEAL,5 } } },

If two characters had the same ID it would have deleted all items for that ID for both characters, nothing would have remained. But if they did somehow share the same ID you would know it because they would have pulled data from the same SQL tables. So both characters would have the exactly the same name, class, stats, items, zeny, etc... Sort of like the same character just happen to show up in two character slots. I don't think that would be an rAthena issue, but more of a SQL or phpadmin database issue of the server. Since the script sets the .@char_id to that of the currently logged in character I still don't believe its possible. All actions following would be strictly limited to that character only. I have tested it and I cannot figure out a way to get it to mess up as described. set .@char_id,getcharid(0); Peopleperson49

It's not possible to delete a character after you log back in. Its just not scripted that way. Also if it was related to that then all your characters you donation items, and zeny would be gone along with everything else. Peopleperson49

I could do that however with the deletecharacter command it deletes everything like they never existed. To have the server perform one more action like store everything wouldn't really be the best course. People using this command should know that they are deleting everything they have and to store what they want to keep. Anyways, maybe I missed what your intent was. Thanks for replying. Peopleperson49

I added version 1.1 now that requires the player to input thier account password prior to deleting the character. Thanks for the suggestions. Peopleperson49

Thats not a bad suggestion sandbox. I thought about it but the point for me was to supplement the fact that for some reason my client won't let me delete characters. So any player would need to be able to use it if needed. I could make it so a GM could use it on players only, but hopefully people arn't on other peoples accounts. If they safe guard it then there won't be any problems. But whose to stop somebody from getting on an account and dropping everything they have or other stuff? Peopleperson49

It will still work just fine with the other tables added there. Just check the map server log when somebody uses it and post here. I believed I removed them all. I will remove them as soon as I see it. Won't affect the scripts operation or your server. I had already added your to skype earlier, lol. Peopleperson49

Thanks for that. Since your using check your map server and tell me if it says cannot find a table. That probably means that I included one of my custom ones and I need to remove that portion. You said you had that problem, were you able to fix it? Thanks. In a funny note if your going to up up + post you should use the, "If you like this post click the "Vote this post up" button to the right of the post.". Anyways thanks again for using. Peopleperson49

Yes this command removes everything from the players account for that character. However the sql is easy to modify if you just wanted to delete something specific. I created this because nomatter how much I try with the 20130807 I cannot get it to delete a character from an account. This is an easy solution. I hope you enjoy! Peopleperson49

This is a good script I wish they would put it in officially so people don't have to reinstall it every time. Anyways good work. I have been using sql more and more in my scripting and this is a good example of what it can do. Nice work. Peopleperson49

Delete Characters This script allows you to delete characters in-game. When used it will ask the player to confirm and then kick them out of the server. When they log back their character and in all variables will be gone forever. It is handy since some of the new clients won't properly delete characters. The map server will get an error that says, "charif_ack_login_req failed - player not online". However all functions work great. I'm working on what error but I think it has to do with the script still going after the player is kicked. If anybody has any ideas let me know. Delete_Character.txt Version 1.0 Delete_Character.txt Version 1.1 Delete_Character.txt Version 1.2

My console is recieving a couple errors that I havn't been able to track down. The mapindex error I have went through ever custom script I have looking for a map reference not listed in the index, however, I litterally have hundreds of custom scripts so it is very possible that I have missed something somewhere. The itemdb_searchrandomid I'm not sure about. I have custom items added but I have checked group 5 and moved everything from it but still get that error. I think group 5 used to be the jellopy drop which I reapproated. Thanks. Peopleperson49

So I had to go back to basics with my sql and I figured it out on my own. The only issue I get is a map server error that says, "[Error]: charif_ack_login_req failed - player not online. Any suggestions with fixing that. Otherwise it works perfectly! Peopleperson49 Had to replace this: query_sql("DELETE FROM char WHERE `char_id` = '"+.@char_id+"'"); With this: query_sql("DELETE FROM `char` WHERE `char_id`='"+escape_sql(.@char_id)+"'");

Good catch on the .@char_id. I had it that way origonally so I'm not sure why I changed it. How do I make sure I have the proper privilege to delete information. I know it deleted some data so I should have permission. The ban works but not the unban section, so the sql might be erroring some how to stop the function. My map server shows no errors though. Peopleperson49 - script Test -1,{ OnPCDieEvent: if(strcharinfo(3) == "aeir_beach") { set .@char_id,getcharid(0); atcommand "@kick "+strcharinfo(0); atcommand "@block "+strcharinfo(0); sleep2 3000; query_sql("DELETE FROM char WHERE `char_id` = '"+.@char_id+"'"); atcommand "@unblock "+strcharinfo(0); } end; }

I had it that way origianally with the OnNightTerror using a sleep2 3000; but it still didn't happen. Basically the same reaction. Some tables deleted and others didn't. Peopleperson49

I'm trying to make a script so that on certain maps if a character is killed it will kick the character and delete it permantently. I put it as a bindcmd for ease of testing. I can't seem to get the sql for some tables to carry out this task. I am familiar with using sql and part of the functions are carried out, but deleting stuff such as char, inventory, cart inventory, and a couple other tables will not delete. I supect it is blocked in some way by the character server. I went through the entire table database to look for anything that retained specific character data to delete, but some of the tables below may be specific to my server. I don't remember which ones at the moment. Peopleperson49 - script NightTerror -1,{ OnNightTerror: set NTCheck,1; atcommand "@kick "+strcharinfo(0)+""; end; OnPCLogoutEvent: if(playerattached()==0) { end; } if(NTCheck!=1) { end; } else { set NTCheck,0; } set .char_id,getcharid(0); query_sql("DELETE FROM atcommandlog WHERE `char_id` ="+.char_id); //query_sql("DELETE FROM BalanceRank WHERE `char_id` ="+.char_id); query_sql("DELETE FROM bonus_script WHERE `char_id` ="+.char_id); query_sql("DELETE FROM branchlog WHERE `char_id` ="+.char_id); query_sql("DELETE FROM buyingstore_items WHERE `buyingstore_id` = "+.char_id); query_sql("DELETE FROM buyingstores WHERE `char_id` ="+.char_id); query_sql("DELETE FROM cashlog WHERE `char_id` ="+.char_id); query_sql("DELETE FROM cp_charprefs WHERE `char_id` ="+.char_id); query_sql("DELETE FROM cp_choko_rename_log WHERE `char_id` ="+.char_id); query_sql("DELETE FROM elemental WHERE `char_id` ="+.char_id); query_sql("DELETE FROM emprank WHERE `char_id` ="+.char_id); query_sql("DELETE FROM friends WHERE `char_id` ="+.char_id); query_sql("DELETE FROM guild WHERE `char_id` ="+.char_id); query_sql("DELETE FROM guild_member WHERE `char_id` ="+.char_id); query_sql("DELETE FROM homunculus WHERE `char_id` ="+.char_id); query_sql("DELETE FROM hotkey WHERE `char_id` ="+.char_id); query_sql("DELETE FROM memo WHERE `char_id` ="+.char_id); query_sql("DELETE FROM mercenary WHERE `char_id` ="+.char_id); query_sql("DELETE FROM mercenary_owner WHERE `char_id` ="+.char_id); query_sql("DELETE FROM mvplog WHERE `kill_char_id` ="+.char_id); query_sql("DELETE FROM mvprank WHERE `char_id` ="+.char_id); query_sql("DELETE FROM npclog WHERE `char_id` ="+.char_id); query_sql("DELETE FROM party WHERE `leader_char` = "+.char_id); query_sql("DELETE FROM pet WHERE `char_id` ="+.char_id); query_sql("DELETE FROM picklog WHERE `char_id` ="+.char_id); query_sql("DELETE FROM pvprank WHERE `char_id` ="+.char_id); query_sql("DELETE FROM quest WHERE `char_id` ="+.char_id); query_sql("DELETE FROM sc_data WHERE `char_id` ="+.char_id); query_sql("DELETE FROM skill WHERE `char_id` ="+.char_id); query_sql("DELETE FROM skillcooldown WHERE `char_id` ="+.char_id); query_sql("DELETE FROM vendings WHERE `char_id` ="+.char_id); query_sql("DELETE FROM zenylog WHERE `char_id` ="+.char_id); query_sql("DELETE FROM inventory WHERE `char_id` ="+.char_id); query_sql("DELETE FROM cart_inventory WHERE `char_id` ="+.char_id); query_sql("DELETE FROM global_reg_value WHERE `char_id` ="+.char_id); query_sql("DELETE FROM char WHERE `char_id` ="+.char_id); end; OnInit: bindatcmd("nightterror",strnpcinfo(0)+"::OnNightTerror"); end; }