Help query sql

[xSaG 15]

can someone give me a sql query to the items on this?

 

This is the hidden content, please

• Sign In
• or
• Sign Up

[Ira™ 41]

Link not work.

[xSaG 15]

link works, now we tested

[Ira™ 41]

INSERT INTO `item_proto` VALUES ('79501', 0x3F, 0x4172726F777320517569766572, '1', '0', '0', '1', '204980', '20', '512', '', '100000', '0', '0', '0', '0', '0', '7', '86400', '0', '0', '0', '0', '0', '0', '0', '0', '17', '4', '0', '25', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('79502', 0x3F, 0x4172726F777320517569766572, '1', '0', '0', '1', '204980', '20', '512', '', '550000', '0', '0', '0', '0', '0', '7', '604800', '0', '0', '0', '0', '0', '0', '0', '0', '17', '4', '0', '25', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('79503', 0x3F, 0x4172726F777320517569766572, '1', '0', '0', '1', '204980', '20', '512', '', '0', '0', '0', '0', '0', '0', '7', '1296000', '0', '0', '0', '0', '0', '0', '0', '0', '17', '4', '0', '25', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('79504', 0x3F, 0x4172726F777320517569766572, '1', '0', '0', '1', '204980', '20', '512', '', '0', '0', '0', '0', '0', '0', '7', '2592000', '0', '0', '0', '0', '0', '0', '0', '0', '17', '4', '0', '25', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

Here is, but you musy replace FLAG 

I don't have that flag in db and item_proto structure,  actual type is  ITEM_WEAPON (type number 1) .

You must generate code flag for : WEAPON_UNLIMITED_ARROW  (You must generate number type and replace intro item_proto navicat manually)

Edited July 16, 2015 by Ira™