New Items

[Ememjr]

Jab, would it be possible to get a way to add items manually to the db
1. for adding those items that we need now that are missing
2. adding test items where we do not want to mess with real items changing stuff around

or

just add me 26 items starting at ID # 6 through 30 named Test Item X where x is numbered 1-30
once there added ill go modify them to our testing needs


i use these to add all the stats and mods i can think of that we support to them

makes it so much easier to check for changes between builds

i have on my server, but have noticed sometimes our servers are different for some reason
so once i fix on mine and you or cynaar have rebuilt the changes, i can then go in and verify


(like for the last few days i been trying to figure out why quest reward display was not showing rewards correctly on mine for COE but were on EMU
found that I had put the new packect id for coe 1208 in misc functions but it wasnt ever committed, i removed that from mine now it works,

[Ememjr]

i can send you an import you can use if it will make it easier

(but will still need STAT editor on items editor page

[Jabantiz]

neatz asked for a duplicate button but my sql knowledge is not good enough for that. I can manually import some items if you want.

As for the id in misc function, it is sort of like a version and the client can actually handle multiple versions. Leaving it at an older version that we have figured out is usually the best option as item structs are a huge pain to figure out. That said eventually newer clients will no longer recognize some of the older versions so we a re forced to update them.

[Ememjr]

perfect ill sen to the sql script to add the items,

do you think you will be able to get the stat editor under items working, it will be important to be able to modify those test items stats

[Ememjr]

Code: Select all

INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('6','Test Item 1','Normal','496','0','4294967295','4294967295','1200','6','-6');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('7','Test Item 2','Normal','496','0','4294967295','4294967295','1200','7','-7');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('8','Test Item 3','Normal','496','0','4294967295','4294967295','1200','8','-8');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('9','Test Item 4','Normal','496','0','4294967295','4294967295','1200','9','-9');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('10','Test Item 5','Normal','496','0','4294967295','4294967295','1200','10','-10');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('11','Test Item 6','Normal','496','0','4294967295','4294967295','1200','11','-11');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('12','Test Item 7','Normal','496','0','4294967295','4294967295','1200','12','-12');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('13','Test Item 8','Normal','496','0','4294967295','4294967295','1200','13','-13');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('14','Test Item 9','Normal','496','0','4294967295','4294967295','1200','14','-14');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('15','Test Item 10','Normal','496','0','4294967295','4294967295','1200','15','-15');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('16','Test Item 11','Normal','496','0','4294967295','4294967295','1200','16','-16');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('17','Test Item 12','Normal','496','0','4294967295','4294967295','1200','17','-17');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('18','Test Item 13','Normal','496','0','4294967295','4294967295','1200','18','-18');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('19','Test Item 14','Normal','496','0','4294967295','4294967295','1200','19','-19');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('20','Test Item 15','Normal','496','0','4294967295','4294967295','1200','20','-20');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('21','Test Item 16','Normal','496','0','4294967295','4294967295','1200','21','-21');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('22','Test Item 17','Normal','496','0','4294967295','4294967295','1200','22','-22');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('23','Test Item 18','Normal','496','0','4294967295','4294967295','1200','23','-23');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('24','Test Item 19','Normal','496','0','4294967295','4294967295','1200','24','-24');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('25','Test Item 20','Normal','496','0','4294967295','4294967295','1200','25','-25');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('26','Test Item 21','Normal','496','0','4294967295','4294967295','1200','26','-26');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('27','Test Item 22','Normal','496','0','4294967295','4294967295','1200','27','-27');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('28','Test Item 23','Normal','496','0','4294967295','4294967295','1200','28','-28');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('29','Test Item 24','Normal','496','0','4294967295','4294967295','1200','29','-29');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('30','Test Item 25','Normal','496','0','4294967295','4294967295','1200','30','-30');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('31','Test Item 26','Normal','496','0','4294967295','4294967295','1200','31','-31');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('32','Test Item 27','Normal','496','0','4294967295','4294967295','1200','32','-32');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('33','Test Item 28','Normal','496','0','4294967295','4294967295','1200','33','-33');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('34','Test Item 29','Normal','496','0','4294967295','4294967295','1200','34','-34');
INSERT INTO `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`) VALUES('35','Test Item 30','Normal','496','0','4294967295','4294967295','1200','35','-35');

[Ememjr]

Cynnar has import these items (