Need these items added to DB please

[Ememjr]

Jab,
i could not find a way to add items in the editor
in order for language primers to work now, when buying from a merchant, these items need added to the DB, as they are not there, and they are not in census , that i can find

there are 10 items, i numbered from 900-909, so that when eventually items get readded and updated from census these wont be in the normal number scheme, hope this is ok if not, then once they are added please let me know the new id number so i can adjust the scripts

much appreciated

languageprimer.zip

[Jabantiz]

[mention]Ememjr[/mention]

Your insert does not match our tables (doesn't match as we can't currently push db table changes to the db patcher) so I had to manually edit the sql's and this is what I ended up with, if this looks good I will push it to the emu server.

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`, `lua_script`) values('900','Dwarven Language Primer','Normal','371','0','4294967295','4294967295','1200','900','0','ItemScripts/DwarvenLanguagePrimer.lua');
insert into `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`, `lua_script`) values('901','Ayr\'Dal Language Primer','Normal','711','0','4294967295','4294967295','1200','901','0','ItemScripts/AyrDalLanguagePrimer.lua');
insert into `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`, `lua_script`) values('902','Feir\'Dal Language Primer','Normal','711','0','4294967295','4294967295','1200','902','0','ItemScripts/FeirDalLanguagePrimer.lua');
insert into `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`, `lua_script`) values('903','Gnomish Language Primer','Normal','715','0','4294967295','4294967295','1200','903','0','ItemScripts/GnomishLanguagePrimer.lua');
insert into `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`, `lua_script`) values('904','Stout Language Primer','Normal','720','0','4294967295','4294967295','1200','904','0','ItemScripts/StoutLanguagePrimer.lua');
insert into `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`, `lua_script`) values('905','Koada\'Dal Language Primer','Normal','716','0','4294967295','4294967295','1200','905','0','ItemScripts/KoadaDalLanguagePrimer.lua');
insert into `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`, `lua_script`) values('906','Guktan Language Primer','Normal','719','0','4294967295','4294967295','1200','906','0','ItemScripts/GuktanLanguagePrimer.lua');
insert into `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`, `lua_script`) values('907','Halasian Language Primer','Normal','719','0','4294967295','4294967295','1200','907','0','ItemScripts/HalasianLanguagePrimer.lua');
insert into `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`, `lua_script`) values('908','Kerran Languange Primer','Normal','714','0','4294967295','4294967295','1200','908','0','ItemScripts/KerranLanguangePrimer.lua');
insert into `items` (`id`, `name`, `item_type`, `icon`, `tier`, `skill_id_req`, `skill_id_req2`, `sell_price`, `soe_item_id`, `soe_item_crc`, `lua_script`) values('909','Erudian Language Primer','Normal','713','0','4294967295','4294967295','1200','909','0','ItemScripts/ErudianLanguagePrimer.lua');

[Ememjr]

yes that looks good, do you happen to remember what fields dont match, and ill post what i added and for what ( i know one is the sell status price field so selling prices for items that give status will show on merchants dont sdont recall other atm

[Ememjr]

oh let me konow once pushed and ill start adding those items to merchants

[Jabantiz]

Just pushed them to the emu server, you will need to "/reload items" to see them in game but they should show in the eq2db2 editor if you need to change stuff.


As for table changes it was `reforged`, `ethereal`, `refined`, `sell_status_amount`, and `soe_autoquest_id`. I assume autoquest is your own census parser and I know you posted about the other but I do not have the ability to push DB changes to the patcher currently so I can't get those up right now and no eta on when.

[Ememjr]

aw yes reforged,etheral,refined are for item examines, but the soe_autoquest_id i dont recognize, maybe it was Gangerous, for his quest importer