[RELEASE] Full USA Items (1-165)

[Warmonger]

• First run this query.
  
  

   TRUNCATE TABLE t_item 
    

• Then execute the .sql file attached below on "newproject_data"
  
  
• Then run this query. (Also attached below as Item_Fix.zip)
  
  

   # Weapons 
  UPDATE t_item SET a_flag = '134236286' WHERE a_flag = '134250558' AND a_level = '73' AND a_wearing = '2'; 
  UPDATE t_item SET a_flag = '134236286' WHERE a_flag = '134250558' AND a_level = '85' AND a_wearing = '2'; 
  UPDATE t_item SET a_flag = '134236286' WHERE a_flag = '134250558' AND a_level = '97' AND a_wearing = '2'; 
  UPDATE t_item SET a_flag = '134236286' WHERE a_flag = '134250558' AND a_level = '109' AND a_wearing = '2'; 
  UPDATE t_item SET a_flag = '134236286' WHERE a_flag = '134250558' AND a_level = '121' AND a_wearing = '2'; 
  UPDATE t_item SET a_flag = '134236286' WHERE a_flag = '134250558' AND a_level = '133' AND a_wearing = '2'; 
  UPDATE t_item SET a_flag = '134236286' WHERE a_flag = '134250558' AND a_level = '145' AND a_wearing = '2';
  UPDATE t_item SET a_flag = '134236286' WHERE a_flag = '134250558' AND a_level = '149' AND a_wearing = '2';
  UPDATE t_item SET a_flag = '134236286' WHERE a_flag = '134250558' AND a_level = '157' AND a_wearing = '2';
  UPDATE t_item SET a_flag = '134236286' WHERE a_flag = '134250558' AND a_level = '165' AND a_wearing = '2';
   
  # Shields
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '73' AND a_wearing = '4';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '85' AND a_wearing = '4';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '97' AND a_wearing = '4';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '105' AND a_wearing = '4';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '115' AND a_wearing = '4';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '125' AND a_wearing = '4';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '135' AND a_wearing = '4';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '145' AND a_wearing = '4';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '154' AND a_wearing = '4';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '163' AND a_wearing = '4';
   
  # Armor Lv 75-77
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '75' AND a_wearing = '5';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '76' AND a_wearing = '3';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '76' AND a_wearing = '1';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '77' AND a_wearing = '0';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '77' AND a_wearing = '6';
   
  # Armor Lv 85-87
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '85' AND a_wearing = '5';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '86' AND a_wearing = '3';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '86' AND a_wearing = '1';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '87' AND a_wearing = '0';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '87' AND a_wearing = '6';
   
  # Armor Lv 115-117
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '115' AND a_wearing = '5';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '116' AND a_wearing = '3';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '116' AND a_wearing = '1';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '117' AND a_wearing = '0';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '117' AND a_wearing = '6';
   
  # Armor Lv 125-127
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '125' AND a_wearing = '5';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '126' AND a_wearing = '3';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '126' AND a_wearing = '1';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '127' AND a_wearing = '0';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '127' AND a_wearing = '6';
   
  # Armor Lv 135-137
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '135' AND a_wearing = '5';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '136' AND a_wearing = '3';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '136' AND a_wearing = '1';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '137' AND a_wearing = '0';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '137' AND a_wearing = '6';
   
  # Armor Lv 145-147
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '145' AND a_wearing = '5';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '146' AND a_wearing = '3';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '146' AND a_wearing = '1';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '147' AND a_wearing = '0';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '147' AND a_wearing = '6';
   
  # Armor Lv 154-156
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '154' AND a_wearing = '5';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '155' AND a_wearing = '3';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '155' AND a_wearing = '1';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '156' AND a_wearing = '0';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '156' AND a_wearing = '6';
   
  # Armor Lv 163-165
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '163' AND a_wearing = '5';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '164' AND a_wearing = '3';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '164' AND a_wearing = '1';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '165' AND a_wearing = '0';
  UPDATE t_item SET a_flag = '134219902' WHERE a_flag = '134250558' AND a_level = '165' AND a_wearing = '6'; 
    

Don't forget to give a big thanks to Wizatek for his tool.

[hectormousa]

:) Nice release thx

[rzrgames]

Nice work man - gonna make it soo much easier :)

/Edit what client should I be using as it is dropping the items but is giving the default XYZ item

[maxiguti]

Good work Warmonger Thank you very much for the contributions

[Warmonger]

Nice work man - gonna make it soo much easier :)

/Edit what client should I be using as it is dropping the items but is giving the default XYZ item

Client maxs out to level 145 weapons and 135 armors. You will need to use newer client files and update icons/visuals etc for all the items.

[rzrgames]

I thought a newer client won't be compatible with the EP1 server stuff ?? cause in the Server Files Thread it spoke alot about finding the right client

Should I uses like the latest Aeria Client ??

[Warmonger]

I thought a newer client won't be compatible with the EP1 server stuff ?? cause in the Server Files Thread it spoke alot about finding the right client

Should I uses like the latest Aeria Client ??

No, im saying you will need to get the newest itemAll_usa.lod to work with our client. Which it doesn't yet, it throws error report on load. Then you will need to copy over the Item folder for all visuals etc. But until someone releases how to up the level cap, and how to make itemAll_usa.lod work. It would be useless to even try, unless you can do them things. Stick to 133 item for now. Im sure eventually level cap will go up etc. We trying to fix everything to match the 2009 client, not making it into EP2 because thats impossible.

[rzrgames]

If i use the LC Developer Studio by Wizatek can I edit the itemAll_usa.lod to bring it up to scratch by manually adding the items or is the itemALL_uas.lod editable ??

Edit : is there a trick to editing that file ??

[julioclitwin]

Please, repload links?

[br1ngster]

Where i need to put this php code ?

Then execute the .sql file attached below on "newproject_data"

And where this .sql file ???

[rioking]

There is sql file
t_item fix.sql
Need To add this text to Txt document so save it with name xxx.sql

[GeumOhee]

thanks