[How to make a sql query for pruning chars]

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.  

[2nd Job classes skill errors]

Yes, I am using the one that comes with rathena.

Video of my problem

[2nd Job classes skill errors]

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.

[2nd Job classes skill errors]

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.

[2012-03-28 Cart Issue]

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.)

[3rd class breeder]

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

[Client 2011-03-15aragexere.exe]

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?