pastebin - collaborative debugging tool
rathena.kpaste.net RSS


SQL --> TXT item_db Converter
Posted by Anonymous on Wed 7th Dec 2011 17:13
raw | new post

  1. SELECT CONCAT(
  2.         IFNULL(id,''), ',',
  3.         IFNULL(name_english,''), ',',
  4.         IFNULL(name_japanese,''), ',',
  5.         IFNULL(`type`,''), ',',
  6.         IFNULL(price_buy,''), ',',
  7.         IFNULL(price_sell,''), ',',
  8.         IFNULL(weight,''), ',',
  9.         IFNULL(attack,''), ',',
  10.         IFNULL(defence,''), ',',
  11.         IFNULL(`range`,''), ',',
  12.         IFNULL(slots,''), ',',
  13.         IFNULL(equip_jobs,''), ',',
  14.         IFNULL(equip_upper,''), ',',
  15.         IFNULL(equip_genders,''), ',',
  16.         IFNULL(equip_locations,''), ',',
  17.         IFNULL(weapon_level,''), ',',
  18.         IFNULL(equip_level,''), ',',
  19.         IFNULL(refineable,''), ',',
  20.         IFNULL(`view`,''), ',',
  21.         CONCAT('{ ', IFNULL(script,''),         ' },'),
  22.         CONCAT('{ ', IFNULL(equip_script,''),   ' },'),
  23.         CONCAT('{ ', IFNULL(unequip_script,''), ' }')
  24. ) AS 'item_db.txt'
  25. FROM item_db;

Submit a correction or amendment below (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.

Syntax highlighting:

To highlight particular lines, prefix each line with {%HIGHLIGHT}




All content is user-submitted.
The administrators of this site (kpaste.net) are not responsible for their content.
Abuse reports should be emailed to us at