• Need these items added to DB please

Posted: **Mon Oct 30, 2017 8:33 am**

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

Posted: **Tue Oct 31, 2017 4:22 pm**

[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');

Posted: **Tue Oct 31, 2017 6:08 pm**

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

Posted: **Tue Oct 31, 2017 6:08 pm**

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

Posted: **Tue Oct 31, 2017 6:24 pm**

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.

Posted: **Tue Oct 31, 2017 6:32 pm**

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

Need these items added to DB please

Need these items added to DB please

Re: Need these items added to DB please

Re: Need these items added to DB please

Re: Need these items added to DB please

Re: Need these items added to DB please

Re: Need these items added to DB please