ArcEmu: Item Grabber 3.2 - Arcemu - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

  • (6 Pages)
  • +
  • 1
  • 2
  • 3
  • Last »
  • You cannot start a new topic
  • This topic is locked

Item Grabber 3.2 - Arcemu

#1 User is offline   rofni 

  • Member
  • Pip
  • Group: Members
  • Posts: 77
  • Joined: 11-August 08
  • Gender:Male
  • Location:Belgium
  • Interests:My girfriend

Posted 08 September 2009 - 05:02 PM

Posted Image
Hi all !

Started today on a new version of ItemGrabber.
The previous ItemGrabber is downloaded for more then 6500 times :o
So i am ready to create new tools for it !


Features :
- MySQL connection to your server.
- View SQL file
- Add directly to your DB
- WoWHead DB
- Weapons/Armor/Mats/Mounts/...
- Auto Updater
- Multiple item support (for latest Arcemu)
- Supports all Arcemu Revs
- Supports Mangos
- View added to DB list
- Vendor Grabber (In beta stage, only use on test server !)

Comming soon :
- Make your own Blizzlike DB (The tool will make a new clean items.sql with all wow items from wowhead)
- View your DB
- Make a SQL file with more items
- Quest Grabber
- Loot Grabber
- PREMIUM GRABBER


DOWNLOAD NEW VERSION 3.3 - V1.6.0
http://www.cardinwow.info
updated version, please check this post for updates !

If you like my work, click once a day on a google ad on MyWoW 3.2 Funserver - Index page


Thanks :D Please let me know what you think about my tool.

Posted Image
3

#2 User is offline   Ashberry 

  • Member
  • Pip
  • Group: Members
  • Posts: 99
  • Joined: 10-August 09
  • Gender:Male
  • Interests:rofni's girlfriend (and his coding talents)

Posted 08 September 2009 - 05:11 PM

Excellent!

No problems using this with the latest database structures?


BTW if you add a way to grab more than one item at a time. I'll buy you a car (not really, but it's the thought that counts, right?)
0

#3 User is offline   rofni 

  • Member
  • Pip
  • Group: Members
  • Posts: 77
  • Joined: 11-August 08
  • Gender:Male
  • Location:Belgium
  • Interests:My girfriend

Posted 08 September 2009 - 05:13 PM

it works with the latest rev.
Its almost ready that you can say add me the items from 14000-18000 :o
0

#4 User is offline   Ashberry 

  • Member
  • Pip
  • Group: Members
  • Posts: 99
  • Joined: 10-August 09
  • Gender:Male
  • Interests:rofni's girlfriend (and his coding talents)

Posted 08 September 2009 - 05:19 PM

View Postrofni, on 08 September 2009 - 05:13 PM, said:

it works with the latest rev.
Its almost ready that you can say add me the items from 14000-18000 :o


Sweeet, gonna keep an eye on this one then! Nice work!
0

#5 User is offline   rofni 

  • Member
  • Pip
  • Group: Members
  • Posts: 77
  • Joined: 11-August 08
  • Gender:Male
  • Location:Belgium
  • Interests:My girfriend

Posted 08 September 2009 - 05:21 PM

when you run the app, it will check for the latest version, so when i release it and you run the tool, you will be able to update.

Btw : Lol @ your interests

Edit : Almost done with multi item support :D
Forgot that you get banned for 15 minutes when you read more then 2 xml files /s :o
0

#6 User is offline   Dzjhenghiz 

  • حشّاشين
  • Group: Contributor
  • Posts: 1,936
  • Joined: 07-June 08
  • Gender:Male
  • Location:2nd stone after the 3rd oase western sahara
  • Interests:M.C.S.E :- Minesweeper Consultant & Solitaire Expert
  • Server OS:Other

Posted 08 September 2009 - 08:10 PM

Nice release Ty very much will gonna test it ^^
Need Help With Arcemu ? ^^
Posted Image
Concordia res parvae crescunt In varietate concordia
Spoiler

0

#7 User is offline   rofni 

  • Member
  • Pip
  • Group: Members
  • Posts: 77
  • Joined: 11-August 08
  • Gender:Male
  • Location:Belgium
  • Interests:My girfriend

Posted 08 September 2009 - 08:33 PM

added the multiple item support :o
0

#8 User is offline   daemon07 

  • Newbie
  • Group: Members
  • Posts: 6
  • Joined: 04-September 09

Posted 08 September 2009 - 08:39 PM

thanks alot for this but i get some errors trying to import the items .

[SQL] INSERT INTO items VALUES ('42324','2','5','-1','Relentless Gladiator's Bonegrinder','60808','4','36864','0','0','0','17','-1','-1','245','80','0','0','0','0','0','0','0','0','1','0','4','38','271','7','204','32','90','35','90','0','0','0','0','0','0','0','0','0','0','0','0','0','0','736','1105','0','0','0','0','0','0','0','0','0','0','0','3600','0','100','0','1','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','-1','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','1','','0','0','0','','0','1','1','0','0','0','0','120','0','0','0','0','0','0','0','0','0','0','0','0','-1','-1','0','0','0')


thats the item im trying to import =)

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Bonegrinder','60808','4','36864','0','0','0','17','-1','-1','245','80','0','0'' at line 1


this was an easy fix tho just change the 'Relentless Gladiator's Bonegrinder' to "Relentless Gladiator's Bonegrinder"
but then i end up with

[Err] 1366 - Incorrect integer value: '' for column 'quest_id' at row 1


then i couldent be bothered anymore. what database are you using for this i should maybe change from whydb rev61?
0

#9 User is offline   rofni 

  • Member
  • Pip
  • Group: Members
  • Posts: 77
  • Joined: 11-August 08
  • Gender:Male
  • Location:Belgium
  • Interests:My girfriend

Posted 08 September 2009 - 08:42 PM

its because of the value is empty and your mysql server doesn't accept empty cells.
I will try to fix it within 10 minutes.
0

#10 User is offline   Dzjhenghiz 

  • حشّاشين
  • Group: Contributor
  • Posts: 1,936
  • Joined: 07-June 08
  • Gender:Male
  • Location:2nd stone after the 3rd oase western sahara
  • Interests:M.C.S.E :- Minesweeper Consultant & Solitaire Expert
  • Server OS:Other

Posted 08 September 2009 - 08:46 PM

I think u need to make some check for items like http://www.wowhead.com/?item=47115 and the other, i think the problem is in the 's which works when u do \'s (the Mysql doesnt like that)


f.e. 'Death\'s Verdict' instead of 'Death's Verdict'
Need Help With Arcemu ? ^^
Posted Image
Concordia res parvae crescunt In varietate concordia
Spoiler

0

#11 User is offline   rofni 

  • Member
  • Pip
  • Group: Members
  • Posts: 77
  • Joined: 11-August 08
  • Gender:Male
  • Location:Belgium
  • Interests:My girfriend

Posted 08 September 2009 - 09:12 PM

whoops :o not /'s , its \'s
Its also late for me lol :D

Edit : Restart your tool and install the update ! It will fix the 2 errors.
0

#12 User is offline   daemon07 

  • Newbie
  • Group: Members
  • Posts: 6
  • Joined: 04-September 09

Posted 08 September 2009 - 09:15 PM

hehe xD
0

#13 User is offline   Dzjhenghiz 

  • حشّاشين
  • Group: Contributor
  • Posts: 1,936
  • Joined: 07-June 08
  • Gender:Male
  • Location:2nd stone after the 3rd oase western sahara
  • Interests:M.C.S.E :- Minesweeper Consultant & Solitaire Expert
  • Server OS:Other

Posted 08 September 2009 - 10:43 PM

Wow, great tool seems to work just fine... only take your time when u do this program.

I scanned for missing entries in my dbase and filled a lot xD... 2 morrow a full day of item testing ahead xD

Ty
Need Help With Arcemu ? ^^
Posted Image
Concordia res parvae crescunt In varietate concordia
Spoiler

0

#14 User is offline   Ashberry 

  • Member
  • Pip
  • Group: Members
  • Posts: 99
  • Joined: 10-August 09
  • Gender:Male
  • Interests:rofni's girlfriend (and his coding talents)

Posted 09 September 2009 - 04:54 AM

Ok finally checked it out. Looks good, seems to be ok, except...

The multiple item part doesn't seem to work. I tried it to start with, with a small range. It came up with one failed and then kinda froze, no error messages or crash dumps. Just froze and needed to be shut down via the task manager. Tried it a few more times and didn't get any response, just instant freezing effect. :P

Scratch that bit, I'm an idiot! It WAS adding items, but as the app does still appear to freeze (becomes highly unresponsive, can't click anything etc.) and there's no icon to show it's working, or a cancel button and so on. It does come across as looking like it died.

However..

Tried the single item part. It let me add a couple, but is now telling me I have items in my DB when I don't (I'm viewing the database at the same time and watching for any changes), so I don't know why it's doing that.


Do I need to be running this in admin mode or something? I'm on Vista x64 Ultimate btw, if that makes a difference. Still voted your post up, for going to the trouble to even try make this, because it'll be awesome when it's fully working! :D
0

#15 User is offline   Navid 

  • Persian Prance of ArcEmu
  • Group: Super Moderator
  • Posts: 718
  • Joined: 30-June 09
  • IRC:Lurker-
  • Gender:Male
  • Location:Iran
  • Interests:PHP,C++,ArcEmu and exactly our lovely community and specially money xD
  • Server OS:Windows

Posted 09 September 2009 - 07:06 AM

hmm,good release,wanna to test it
I'm here to check,lurk and kill you so behave or you will be lurked

Posted Image
0

#16 User is offline   Shauren 

  • Helper
  • Group: Contributor
  • Posts: 808
  • Joined: 04-November 08
  • Gender:Male
  • Location:Poland
  • Interests:hmm, wow?

Posted 09 September 2009 - 07:36 AM

nice, but i wonder why is required disenchanting skill appearing twice in SQL? (4th and 5th number from the end, should be only 5th)
0

#17 User is offline   rofni 

  • Member
  • Pip
  • Group: Members
  • Posts: 77
  • Joined: 11-August 08
  • Gender:Male
  • Location:Belgium
  • Interests:My girfriend

Posted 09 September 2009 - 11:23 AM

View PostShauren, on 09 September 2009 - 07:36 AM, said:

nice, but i wonder why is required disenchanting skill appearing twice in SQL? (4th and 5th number from the end, should be only 5th)


Thanks, i deleted that last disenchanting skill and added the right one.
Will update it within a few minutes.
0

#18 User is offline   Navid 

  • Persian Prance of ArcEmu
  • Group: Super Moderator
  • Posts: 718
  • Joined: 30-June 09
  • IRC:Lurker-
  • Gender:Male
  • Location:Iran
  • Interests:PHP,C++,ArcEmu and exactly our lovely community and specially money xD
  • Server OS:Windows

Posted 09 September 2009 - 01:49 PM

I forgot,talk to skysoftware company,they are really good in Grabb ,like LanGrabber and SkyGrabber :D :P
I'm here to check,lurk and kill you so behave or you will be lurked

Posted Image
0

#19 User is offline   rofni 

  • Member
  • Pip
  • Group: Members
  • Posts: 77
  • Joined: 11-August 08
  • Gender:Male
  • Location:Belgium
  • Interests:My girfriend

Posted 09 September 2009 - 02:15 PM

Added a newer version, just restart and update !
It will support other Arcemu revisions.
0

#20 User is offline   low.b0b 

  • Newbie
  • Group: Members
  • Posts: 5
  • Joined: 07-December 08

Posted 09 September 2009 - 02:32 PM

Very nice, but the MUlti Item tool still doesnt work for me :P
0

Share this topic:


  • (6 Pages)
  • +
  • 1
  • 2
  • 3
  • Last »
  • You cannot start a new topic
  • This topic is locked

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users