Merecs ItemCreator for Dawn of Light

[Dinberg]

Graveen you fool

[IStandAloneToo]

I'd like to be able to use this to update an item not just create it.

[Graveen]

you can, File->item->load from database (or anything near).

When you export the item, depending if the id_nb is existing or not, you can select your statement 'UPDATE' or 'INSERT INTO'.

[Merec]

It's really strange, I think just about 4 of 100 peaple knows what my Tool allready can do..... the last tree pages here are the same all the time.

[Graveen]

in fact for my part i really see useful and abilties of your tool when i has to update/create items. But if you do a quick review of your soft, it is not evident (load ie in in 2nd deep menu) to know features.

to summarize:

1/ Merec IC can graphically create and/or modify items.
2/ Merec IC can generate C# or SQL syntax (create with INSERT, modify with UPDATE)
3/ Merec IC is handling looting of this item (not used for my part atm)
4/ Merec IC allows you to search an item, to display a list of model, a list of spell -> a precise selection of the bonus
5/ Merec IC is autoadaptative to your DB syntax and can directly commit to DB

Mainly existing bugs/limitations
- not null field can cause problems when commit to mysql db
- single quote ( sql injection) are not handled (they exists in some DB)
- you need to supply some values for blank fields (poison, spells)

i hope i'm right

[IStandAloneToo]

you can, File->item->load from database (or anything near).

When you export the item, depending if the id_nb is existing or not, you can select your statement 'UPDATE' or 'INSERT INTO'.

Hmm, since I can't read German I didn't know exactly what the error was but now I see. It throws an exception saying that MaxCharges (or PoisonCharges) threw a NULL reference exception and in the itemtemplate table we can have those fields be null.

[Graveen]

yes. i put theses fields at 0 value on my test DB.
You should also have a CanUseEvery notnull-error (i changed locaol db to accept null values)

So i UPDATE'd theses fields to have correct structure b4 export and reimport to Livedol.

[Merec]

Merecs ItemCreator goes version 2.1, see first post.

[Graveen]

really thx mr Merec !!!!

[Merec]

I do not really know if this tool is still in use by some people, but I found a bug while searching a model-id.

This is now fixed in version 2.1.0.1

bye

[Graveen]

this tool is used a lot i think

[Roozzz]

Just re-installed it today

[Merec]

Sources are now available. View the first post.

[Graveen]

/bow.

I'll put Merec's sources into DOL svn.

The whole project is vs2008 - framework 2 - and i have to remove the click once signatures to allow everyone to compile from scratch.

Now, everyone can use the source to adapt it.


Thanks a lot for this tool, Merec, and again many thanks for releasing the source.

[Dinberg]

Cheers M!