[Archive] Mangoszero 1.12 custom item creator *request*
[Archive] Mangoszero 1.12 custom item creator *request*
11-04-2025, 12:45 PM
Original source
Quote: Hello i need a item creator for mangoszero .. thx
rektbyfaith
11-04-2025, 12:45 PM #1Archived author: sirzufall • Posted: 2025-11-04T13:45:18.720121
Original source
Quote: Hello i need a item creator for mangoszero .. thx
11-04-2025, 12:45 PM
Original source
Quote: i also would like this, but for NPCs. +rep to anyone who knows of such a thing
rektbyfaith
11-04-2025, 12:45 PM #2Archived author: Garneth • Posted: 2025-11-04T13:45:18.720121
Original source
Quote: i also would like this, but for NPCs. +rep to anyone who knows of such a thing
11-04-2025, 12:45 PM
Original source
Quote: 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
Code:
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
![[Image: 34529599.png]](http://img143.imageshack.us/img143/1714/34529599.png)
![[Image: 49982632.png]](http://img716.imageshack.us/img716/8733/49982632.png)
![[Image: 57871500.png]](http://img823.imageshack.us/img823/5876/57871500.png)
![[Image: 76651970.png]](http://img821.imageshack.us/img821/188/76651970.png)
![[Image: 91715991.png]](http://img708.imageshack.us/img708/6111/91715991.png)
![[Image: 46267725.png]](http://img109.imageshack.us/img109/3114/46267725.png)
![[Image: 56732444.png]](http://img27.imageshack.us/img27/8919/56732444.png)
![[Image: 89914746.png]](http://img684.imageshack.us/img684/8568/89914746.png)
rektbyfaith
11-04-2025, 12:45 PM #3Archived author: Facerolling • Posted: 2025-11-04T13:45:18.720121
Original source
Quote: 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
Code:
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
11-04-2025, 12:45 PM
Original source
Quote: good guide
![[Image: smile.png]](https://www.ownedcore.com/forums/images/smilies/smile.png)
rektbyfaith
11-04-2025, 12:45 PM #4Archived author: predattak • Posted: 2025-11-04T13:45:18.720121
Original source
Quote: good guide
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)