Upgrated DF items

[deathwish]

Does anyone know if the new DF items been made yet? or if anyone working on them yet? if not, i dont mind doing them

[Tolakram]

No, most if not all of ours are old. I did a quality upgrade, mass update statement, but no change in stats or procs.

[deathwish]

Ok, what i do is, i will upgrade the weapons off Pendragon and post the updates once i have finished

[Graveen]

thumbs up !

[deathwish]

lol just fixed most of the alb df items and i dont no what i did but i messed something up and i could not get it to load into a database lol, so i restarted but im making the update in c#.
Just need to ask a quick question, in the database, how would i make a command to remove a merchantitem as they have replaced all caster staffs with one staff, so when i finish i can fix the merchantitems too.
Would it look something like this?


Find MerchantItem REMOVE `ItemListID` = 'Item list' ?

[Tolakram]

/merchant articles remove <page> <slot>

In the DB:

delete from merchantitem where itemtemplateid = 'whatever'

or more complicated

delete from merchantitem m
inner join itemtemplate i on m.itemtemplateid = i.id_nb
where i.objecttype = ??

Or something like that. Careful with deletes, best have a backup of your db first.

[deathwish]

Thanks Tolakram, i have a mess about and find whats one works the best, i always backup every silly thing lol, i need too lol
Im updating item stats, new dpsand qua, item models and colours too, only thing im not sure is going to be 100% right is the procs, the procs and charges in my database for the items never worked, but i think i have found the right ones for the df items, i will test befor i upload

[Roozzz]

You could not load it? Any errors? I rather see SQL files then scripted, its simply a lot more versatile.

Regarding charges and rpocs, make sure that they have entries in linexspell. They should be listed as item effects.

[deathwish]

I will upload the items as a sql once i have finish, just i keep getting proplem with Merecs itemcreator, i dont no why, just it keeps playing up when i use export the item into sql

[Tolakram]

Sorry about item creator, I rebuilt a version that works with the new DB structure here: http://markalot.org/storm/ItemCreator.zip

[deathwish]

Thank you for the link Tolakram, should be alot faster to make now

[Tolakram]

Woops,

I forgot to mention that the new fields don't actually save to the insert script, they just look pretty right now.

[rdsandersjr]

I updated Item Creator, and you should be able to build the latest from SVN that gives you more search options like packageID, ID_NB, and name.

[deathwish]

nice work rdsandersjr, im loving the updated version, so much faster to use, but its still taking hours to redo all the items, im on my 4th merchant lol, what is there like 27 merchants? lol

[rdsandersjr]

haha yea, there are alot of them =) If you have any suggestions for it please let me know and I will try to add it. Im going to try to implement the fields Tola added in the next few days.