[DEV] ADD equip item to Mysql

[iononline]

Equip

USE `loong_db`;
DROP TABLE IF EXISTS `loong_db`.`xml_equip_name`;
delimiter $$

CREATE TABLE `xml_equip_name` (
    `id` int(7) DEFAULT NULL,
    `name` varchar(40)CHARACTER SET utf8 DEFAULT NULL,
    `display_type` varchar(40)CHARACTER SET utf8 DEFAULT NULL,
    `desc` Text CHARACTER SET utf8 DEFAULT NULL,
    `desc2` Text CHARACTER SET utf8 DEFAULT NULL,
    `male_icon` varchar(15) DEFAULT NULL,
    `female_icon` varchar(15) DEFAULT NULL,
    `male_right_model` varchar(15) DEFAULT NULL,
    `female_right_model` varchar(15) DEFAULT NULL,
    `pertain_model` varchar(15) DEFAULT NULL,
    `pertain_model_pos` varchar(15) DEFAULT NULL,
    `drop_model` varchar(15) DEFAULT NULL,
    `blade_flare_sfx` varchar(15) DEFAULT NULL,
    `blade_glow_sfx` varchar(15) DEFAULT NULL,
    `attach_sfx` varchar(15) DEFAULT NULL,
    `model_type` tinyint(3) unsigned NOT NULL,
    `attach1_pos` tinyint(3) unsigned NOT NULL,
    `attach2_pos` tinyint(3) unsigned NOT NULL,
    `attach3_pos` tinyint(3) unsigned NOT NULL,
    `male_left_model` varchar(15) DEFAULT NULL,
    `female_left_model` varchar(15) DEFAULT NULL,
    `size` varchar(15) DEFAULT NULL,
    `blade_born_sfx` varchar(15) DEFAULT NULL
)  ENGINE=InnoDB DEFAULT CHARSET=utf8$$

delimiter ;
LOAD  XML LOCAL INFILE '/tmp/equip_name.xml'
INTO TABLE xml_equip_name
CHARACTER SET binary
ROWS IDENTIFIED BY '<item>';
SELECT 
    *
FROM
    `loong_db`.`xml_equip_name`;

item

USE `loong_db`;
DROP TABLE IF EXISTS `loong_db`.`xml_item_name`;
delimiter $$

CREATE TABLE `xml_item_name` (
  `id` int(7) DEFAULT NULL,
  `name` varchar(40) CHARACTER SET utf8 DEFAULT NULL,
  `display_type` varchar(40) CHARACTER SET utf8 DEFAULT NULL,
  `desc` Text CHARACTER SET utf8 DEFAULT NULL,
  `male_icon` varchar(15) DEFAULT NULL,
  `drop_model` varchar(15) DEFAULT NULL,
  `action_blend` tinyint(3) unsigned NOT NULL 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 $$

delimiter ;
LOAD  XML LOCAL INFILE '/tmp/item_name.xml'
INTO TABLE xml_item_name
CHARACTER SET binary
ROWS IDENTIFIED BY '<item>';
SELECT 
    *
FROM
    `loong_db`.`xml_item_name`;

Used for translation.
Find items.
Item Mall php.
confix local my.ini mysql
ex: C:\xampp\mysql\bin\my.ini

[mysqld]
port= 3306
socket = "C:/xampp/mysql/mysql.sock"
basedir = "C:/xampp/mysql" 
tmpdir = "C:/xampp/tmp" 
datadir = "C:/xampp/mysql/data"
pid_file = "mysql.pid"
# enable-named-pipe
key_buffer = 16M
max_allowed_packet = 10M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error = "mysql_error.log"

max_allowed_packet = 10M
tmpdir = "C:/xampp/tmp"