[Archive] [Release]Item Creat0r (checks info from allakhazam and makes query to insert items!
[Archive] [Release]Item Creat0r (checks info from allakhazam and makes query to insert items!
11-04-2025, 12:46 PM
Original source
Quote:
You know the problem. A patch (for e.g. patch 2.3) comes out and you want to have the new items in your DB (thats why Cret0r is back). So what do you do?
You guess a range of IDs, where this items could be stored and than Creat0r gives you a SQL-file with all items with the newest stats wich are stored in this range (using information from allakhazam) in English, German, Spanish... Chiniese - it's up to you. A preview is included. Up to 10000 items can be created at once. If there are creaturelootinformation, you can create a sql-file for them too. You just have to import the SQL-file into your DB and that's all...
By the way, some items for 2.3 are included as an example since the release of 0.5.2 (11-21-2007)..
Download v0.5.2:
Filebeam - Free Fast File Hosting
Total downloads of Creat0r: +1200
Password:
soulfire
Greetz XSoulFireX
this is posted by Soulfire on ascentemu.com,i tested it and it works !
this is a dam nice tool to extract info from allakhazam.com, so new 2.3 items? just check the IDrange on allakhazam and put the numbers in program, the program will make you a sql querie to insert them into your DB
credits go to soulfire !
usage: go to wow.allakhazam.com, check for new items... check the ID range and put the ID range in the program
so for example item: "Dazling Longsword" is a new imba item and you want to add it... you search allakhazam and you come to this link
hxxp://wow.allakhazam.com/db/item.html?witem=869;source=live
869 = the itemID so in the program in IDrange put: 869 - 869
program makes a insert query and voila done !
if you want to add more items just put range bigger
changelog:
Code:
Creat0r 0.5.2.0
- - - - - - - -
[Change] changed sql-structure (works fine for 2400 for e.g.)
[Change] removed protection-stuff because some crying people
[Added] implementation of the "arena rank requirement"-information
[Fixed] Quickfix for the creatureloot-structure
Creat0r 0.5.1.0
- - - - - - - -
[Added] supports the three types of charges correctly
[Fixed] can handle the new structure of alla now
grtz
note: i keep it updated with the original topic!
![[Image: unbenanntnc1.th.gif]](http://img85.imageshack.us/my.php?image=unbenanntnc1.gif)
![[Image: smile.png]](https://www.ownedcore.com/forums/images/smilies/smile.png)
![[Image: wink.png]](https://www.ownedcore.com/forums/images/smilies/wink.png)
rektbyfaith
11-04-2025, 12:46 PM #1Archived author: latruwski • Posted: 2025-11-04T13:46:06.851017
Original source
Quote:
You know the problem. A patch (for e.g. patch 2.3) comes out and you want to have the new items in your DB (thats why Cret0r is back). So what do you do?
You guess a range of IDs, where this items could be stored and than Creat0r gives you a SQL-file with all items with the newest stats wich are stored in this range (using information from allakhazam) in English, German, Spanish... Chiniese - it's up to you. A preview is included. Up to 10000 items can be created at once. If there are creaturelootinformation, you can create a sql-file for them too. You just have to import the SQL-file into your DB and that's all...
By the way, some items for 2.3 are included as an example since the release of 0.5.2 (11-21-2007)..
Download v0.5.2:
Filebeam - Free Fast File Hosting
Total downloads of Creat0r: +1200
Password:
soulfire
Greetz XSoulFireX
this is posted by Soulfire on ascentemu.com,i tested it and it works !
this is a dam nice tool to extract info from allakhazam.com, so new 2.3 items? just check the IDrange on allakhazam and put the numbers in program, the program will make you a sql querie to insert them into your DB
credits go to soulfire !
usage: go to wow.allakhazam.com, check for new items... check the ID range and put the ID range in the program
so for example item: "Dazling Longsword" is a new imba item and you want to add it... you search allakhazam and you come to this link
hxxp://wow.allakhazam.com/db/item.html?witem=869;source=live
869 = the itemID so in the program in IDrange put: 869 - 869
program makes a insert query and voila done !
if you want to add more items just put range bigger
changelog:
Code:
Creat0r 0.5.2.0
- - - - - - - -
[Change] changed sql-structure (works fine for 2400 for e.g.)
[Change] removed protection-stuff because some crying people
[Added] implementation of the "arena rank requirement"-information
[Fixed] Quickfix for the creatureloot-structure
Creat0r 0.5.1.0
- - - - - - - -
[Added] supports the three types of charges correctly
[Fixed] can handle the new structure of alla now
grtz
note: i keep it updated with the original topic!
11-04-2025, 12:46 PM
Original source
Quote: I see, This is cool
rektbyfaith
11-04-2025, 12:46 PM #2Archived author: Anthetara-Shattered-Hand • Posted: 2025-11-04T13:46:06.851017
Original source
Quote: I see, This is cool
11-04-2025, 12:46 PM
Original source
Quote: Originally Posted by Anthetara-Shattered-Hand
I see, This is cool
this is extremely handyseriously
grtz
![[Image: lastpost-right.svg]](https://www.ownedcore.com/forums/images/styles/OwnedCoreFX/buttons/lastpost-right.svg)
![[Image: biggrin.png]](https://www.ownedcore.com/forums/images/smilies/biggrin.png)
rektbyfaith
11-04-2025, 12:46 PM #3Archived author: latruwski • Posted: 2025-11-04T13:46:06.851017
Original source
Quote: Originally Posted by Anthetara-Shattered-Hand
I see, This is cool
this is extremely handy
grtz
11-04-2025, 12:46 PM
Original source
Quote:I thought you could make items with this, not search for them on allakhazam...
rektbyfaith
11-04-2025, 12:46 PM #4Archived author: Gastricpenguin • Posted: 2025-11-04T13:46:06.851017
Original source
Quote:I thought you could make items with this, not search for them on allakhazam...
11-04-2025, 12:46 PM
Original source
Quote: Originally Posted by Gastricpenguin
I thought you could make items with this, not search for them on allakhazam...
nope it creates item queries from the info from allakhazam.com
so if new items are released you just start this program and import them from allakhazam.com
if you wanna create items you can use ascent database editor
grtz
rektbyfaith
11-04-2025, 12:46 PM #5Archived author: latruwski • Posted: 2025-11-04T13:46:06.851017
Original source
Quote: Originally Posted by Gastricpenguin
I thought you could make items with this, not search for them on allakhazam...
nope it creates item queries from the info from allakhazam.com
so if new items are released you just start this program and import them from allakhazam.com
if you wanna create items you can use ascent database editor
grtz
11-04-2025, 12:46 PM
Original source
Quote: so the fact is tht this program just lets u "see" what the new items is and then u gotta make them on your own??
rektbyfaith
11-04-2025, 12:46 PM #6Archived author: claus999 • Posted: 2025-11-04T13:46:06.851017
Original source
Quote: so the fact is tht this program just lets u "see" what the new items is and then u gotta make them on your own??
11-04-2025, 12:46 PM
Original source
Quote: Originally Posted by claus999
so the fact is tht this program just lets u "see" what the new items is and then u gotta make them on your own??
it also makes a query to insert them in your DB...
grtz
rektbyfaith
11-04-2025, 12:46 PM #7Archived author: latruwski • Posted: 2025-11-04T13:46:06.851017
Original source
Quote: Originally Posted by claus999
so the fact is tht this program just lets u "see" what the new items is and then u gotta make them on your own??
it also makes a query to insert them in your DB...
grtz
11-04-2025, 12:46 PM
Original source
Quote: Very Very useful! +rep
(dont say i cant rep because i can, i have 1 rep power XD)
rektbyfaith
11-04-2025, 12:46 PM #8Archived author: Kiev • Posted: 2025-11-04T13:46:06.851017
Original source
Quote: Very Very useful! +rep
(dont say i cant rep because i can, i have 1 rep power XD)
11-04-2025, 12:46 PM
Original source
Quote: somehow this seems so much easier then wow-v =D go you!
rektbyfaith
11-04-2025, 12:46 PM #9Archived author: takeover • Posted: 2025-11-04T13:46:06.851017
Original source
Quote: somehow this seems so much easier then wow-v =D go you!
11-04-2025, 12:46 PM
Original source
Quote: Originally Posted by takeover
somehow this seems so much easier then wow-v =D go you!
well it is much easier then wow-v and if you wnt to create custom items, ascent database editor is much easier to use ^^
grtz
rektbyfaith
11-04-2025, 12:46 PM #10Archived author: latruwski • Posted: 2025-11-04T13:46:06.851017
Original source
Quote: Originally Posted by takeover
somehow this seems so much easier then wow-v =D go you!
well it is much easier then wow-v and if you wnt to create custom items, ascent database editor is much easier to use ^^
grtz
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)