msanders1020

I am trying to figure how to delete in active chars from char db. I ran this script and it would always time out due to databases being so big CREATE TEMPORARY TABLE TmpTable AS (SELECT `account_id`,`char_id` FROM `char` WHERE `account_id` IN (SELECT `account_id` FROM `login` WHERE `lastlogin` < (CURRENT_TIMESTAMP - interval '5' month))); #Add tables to delete from here. DELETE FROM `guild` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `skill` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `quest` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `mercenary_owner` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `auction` WHERE `seller_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `mercenary` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `memo` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `inventory` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `hotkey` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `cart_inventory` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `homunculus` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `friends` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `global_reg_value` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `elemental` WHERE `char_id` IN (SELECT `char_id` FROM TmpTable); DELETE FROM `pet` WHERE `account_id` IN (SELECT `account_id` FROM TmpTable); DELETE FROM `party` WHERE `leader_id` IN (SELECT `account_id` FROM TmpTable); DELETE FROM `guild_member` WHERE `account_id` IN (SELECT `account_id` FROM TmpTable); DELETE FROM `sc_data` WHERE `account_id` IN (SELECT `account_id` FROM TmpTable); DELETE FROM `storage` WHERE `account_id` IN (SELECT `account_id` FROM TmpTable); DELETE FROM `char` WHERE `account_id` IN (SELECT `account_id` FROM TmpTable); DELETE FROM `login` WHERE `account_id` IN (SELECT `account_id` FROM TmpTable); DELETE FROM `login` WHERE `lastlogin` < (CURRENT_TIMESTAMP - interval '19' month); DROP TABLE TmpTable; Then I ran this one and it worked for the login but Not thinking that I need to delete everything that goes with those accounts. Is there a way to do it with a query or do I have to do it manually now? DELETE FROM `login` WHERE `lastlogin` < (CURRENT_TIMESTAMP - interval '20' month) Thanks in advanced.

Yes, I am using the one that comes with rathena. Video of my problem

I have 6-18-2012 client fully updated kro. I have opened a bug tracker on it because I have tested it with the job master npc and it gives job class and skills but they are greyed. When I use the @job 4212/4211 and it gives the skills and you can add skill points. So, I was wondering if the npc is screwing something up.

I updated my svn yesterday to svn r16720 and the kagerou/oboro skills are now greyed out. Is it something to do with the update to server files? Thanks for the answers.

Hello, I am use rathena svn r15996 and I have a few problems with this cart patch. I had to comment out the code below to get the patch to work but when doing so, I can not take off cart and can not change cart look. Any help would be greatful! Thanks in advance. if( tsd->sc.count && tsd->sc.data[sC_ON_PUSH_CART] ) clif_statuschange_single(&sd->bl,&tsd->bl,SI_ON_PUSH_CART,1,9999,9,0,0); also this case SC_ON_PUSH_CART: if ( sc->data[sC_ON_PUSH_CART] ) { status_change_end(bl, SC_ON_PUSH_CART, -1); return 0; } //if (pc_isriding(sd,OPTION_RIDING|OPTION_RIDING_DRAGON|OPTION_MADOGEAR|OPTION_RIDING_WUG|)) // return 0; These are the errors I would get if I did not comment them out: status.c:7816:92: error: macro "pc_isriding" passed 2 arguments, but takes just 1 status.c: In function ?status_change_start?: status.c:7816: error: ?pc_isriding? undeclared (first use in this function) status.c:7816: error: (Each undeclared identifier is reported only once status.c:7816: error: for each function it appears in.)

Hello, I tried this script but when I try to equip a cart it doesn't allow it. Says Please make sure you are the required job and have the required skill. I am a blacksmith with push cart lvl 10. Running rAthena svn r15996

I have tried 12 plus exe and they all do the samething. I also am running a current server with the same GRF setups and they work fine. The only reason I am not using the client I already have is because I switch to rAthena and applied harmony to the latest SVN. My old client says it is outdated exe. I can click the custom item, weapon, etc but can not equip it because I get a spr error. How to fix this?