Mangoszero 1.12 custom item creator *request*

[sirzufall]

Hello i need a item creator for mangoszero .. thx

[Garneth]

i also would like this, but for NPCs. +rep to anyone who knows of such a thing

[Facerolling]

There is not alot of activity for a pre-bc Database, but you can still add things with relative ease (and do batch edits, which is far better than a simple item/npc creator)

The DB viewer I like to use for this is HeidiSQL because it can auto-generate Insert queries for specific Tables, which is great for adding in new items / NPCs.

Not everything in emulation is handed to you on a silver platter, sometimes you have to do it the old fashioned way.

Download HeidiSQL <- Download HeidiSQL and install

Load it up, input your DB info


Click on your mangoszero db and double click on the table you want to create a query for.


You will now have this show up, you can click on the data tab to bring up the data in table form.


The Show all button shows every entry in the table, it will probably crash HeidiSQL if the table is exceedingly large.



What we want is the query tab, on the right of the query tab you can see all the column names.


You can select all the columns, some of them, or one. I will show how an update query works.
we're going to set the buyprice of all items, select buyprice in the right hand box and right click and "generate UPDATE"


You'll get something like this, Put the price inand hit the blue triangle to run the query.


Remember, you can update more than one column at a time by selecting more than one column name. You can also do something like

UPDATE `item_template`
	SET
		`BuyPrice`=0
	WHERE 
		`itemid`=999

To only change the buyprice of item 999

the Insert function is adding a new row to the table. You must select all the column names for doing this as it will not work otherwise.




Finally, if you're unsure what the columns mean, go to the wiki and search the table name to bring up the structure and how each column is used. For example: this is the item_template structure and what goes where and does what (tongue twister!): Item template - ZeroWiki

[predattak]

good guide