[Share/Release] updated vendors 2.4.3 menu

These ads disappear when you log in.

Results 1 to 12 of 12
  1. #1
    soul02's Avatar Sergeant Major CoreCoins User
    Reputation
    33
    Join Date
    Mar 2008
    Posts
    168
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    [Share/Release] updated vendors 2.4.3

    Global Melee/Caster Trainer
    Download - ifile.it - Free File Hosting
    NPC ID 30030 - 30040

    Global Weapon Trainer
    Download - Ifile.it - Free File Hosting
    NPC ID 30050

    Dungeon 1 to 3
    Download - Ifile.it - Free File Hosting
    NPC ID 60000 - 60002

    Raid Tier 1 to 6
    Download - Ifile.it - Free File Hosting
    NPC ID 60003 - 60008

    Season 1 to 4
    Download - Ifile.it - Free File Hosting
    NPC ID 60009 - 60018

    Mounts
    Download - Ifile.it - Free File Hosting
    NPC ID 60043 - 60056

    Flying Mounts
    Download - Ifile.it - Free File Hosting
    NPC ID 60057 - 60062

    Gemstone
    Download - Ifile.it - Free File Hosting
    NPC ID 60063 - 60070

    PW: soul02

    more to come..

    Credits

    Soul02 - remake and update
    Knaurs - global melee & caster trainer
    Channel_49 - vendors
    Last edited by soul02; 08-30-2008 at 03:33 PM. Reason: fixed download links
    -·=»‡«=·- Soul02 -·=»‡«=·-


    These ads disappear when you log in.

  2. #2
    The [Bapes]'s Avatar Banned
    Reputation
    14
    Join Date
    Aug 2008
    Posts
    21
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    If it works, cool. +Rep

  3. #3
    soul02's Avatar Sergeant Major CoreCoins User
    Reputation
    33
    Join Date
    Mar 2008
    Posts
    168
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    thanks

    -
    -·=»‡«=·- Soul02 -·=»‡«=·-


  4. #4
    Stabatha's Avatar Contributor
    Reputation
    84
    Join Date
    Dec 2007
    Posts
    345
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    [quote=soul02;1044567]

    PW: soul02

    [/quote]

    For those that missed it cause it was so small..



    PW: soul02



    GoblinCity.net -
    Home of the only Cataclysm Twink Server
    Instant Level 49 * Custom Gear * Scripted Raids * Tons More
    We are the oldest private twink server community - Open since 2007

  5. #5
    Simox's Avatar Sergeant
    Reputation
    6
    Join Date
    Dec 2007
    Posts
    54
    Thanks G/R
    0/1
    Trade Feedback
    1 (100%)
    Awesome, thanks. I really needed them

  6. #6
    adde007's Avatar Sergeant
    Reputation
    3
    Join Date
    Jul 2008
    Posts
    35
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    i cant add them to server it comes a error that is this :[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 'Rar!' at line 1
    [Err] Rar!
    [Msg] Finished - Unsuccessfully
    -------------------------------------------------- what am i supposed to do?????

  7. #7
    drewproject86's Avatar Sergeant
    Reputation
    5
    Join Date
    Apr 2008
    Posts
    63
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Originally Posted by adde007 View Post
    i cant add them to server it comes a error that is this :[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 'Rar!' at line 1
    [Err] Rar!
    [Msg] Finished - Unsuccessfully
    -------------------------------------------------- what am i supposed to do?????
    umm dude....did u kinda unrar it first?

  8. #8
    adde007's Avatar Sergeant
    Reputation
    3
    Join Date
    Jul 2008
    Posts
    35
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    how i do that?????

  9. #9
    soul02's Avatar Sergeant Major CoreCoins User
    Reputation
    33
    Join Date
    Mar 2008
    Posts
    168
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Originally Posted by adde007 View Post
    how i do that?????
    dude right click on the .rar and click "EXTRACT FILE"
    -·=»‡«=·- Soul02 -·=»‡«=·-


  10. #10
    knaur's Avatar Elite User
    Reputation
    400
    Join Date
    Nov 2007
    Posts
    634
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    soul02: if he has a software for it yes hehe =)
    a tip is to pack it as zip instead of rar, cause winxp+
    can open zip files without extra software, but rar files need extras.

    adde007: search on internet for winrar
    thats an extractor software for rar files
    ------------------------------------------------------
    Knaur - Founder of The Norwegian Elite Team

  11. #11
    adde007's Avatar Sergeant
    Reputation
    3
    Join Date
    Jul 2008
    Posts
    35
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    but now i get this error when i am trying with the sesons [Err] 1062 - Duplicate entry '60009' for key 1
    [Err] INSERT INTO `creature_names` VALUES ('60009', 'Arena', 'Season I', '', '0', '0', '0', '3', '0', null, '20126', '0', '0', '0', '1', '1', '0', null);
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------

  12. #12
    Ooci's Avatar Member
    Reputation
    1
    Join Date
    Mar 2008
    Posts
    5
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    That's because you gave a database entry in the table that already has a entry (primary key) of 60009.

    Here's a tip...

    Using his gemstone.sql file as an example I read that he is wanting to insert 8 vendors into the creatures_names table first. He tells us how he wants to point to them by the entry field in the table. So, after parsing the SQL I see that the ID's are as follows:

    60063, 60064, 60065, 60066,60067,60068,60069,60070


    Well, we need to make sure those ID's are available. Primary keys MUST be unique. To check this I'll run the following script against my "world" database:

    Code:
    select entry from creature_names where entry in (60063, 60064, 60065, 60066,60067,60068,60069,60070);
    When I run it, I get (Null) as a response. If you get any information other then that your database is already using one or more of those IDs. You have a couple of options.

    The first is to run a delete statement on creature_names which would look like:

    Code:
    delete from creature_names where entry in (60063, 60064, 60065, 60066,60067,60068,60069,60070);
    This might give you grief as I have no idea if the database has cascade deletes in it or not. If it does not, you'll likely have orphaned data or erroneous results when you run the gemstone.sql after the delete.

    To fix that, I might do something like this:

    Code:
    delete from creature_names where entry in (60063, 60064, 60065, 60066,60067,60068,60069,60070);
    delete from creature_proto where entry in (60063, 60064, 60065, 60066,60067,60068,60069,60070);
    delete from vendors where entry in (60063, 60064, 60065, 60066,60067,60068,60069,60070);
    After that, I would try to rerun his gemstone.sql.

    Another option is to change his sql yourself. To do this is easy but time consuming for novices. Basically run the following SQL:

    Code:
    select max(entry + 1) as entry from creature_names
    This is going to give you the next available entry id you can safely use. Let's say for fun that it returned 8650001. So, now you go to the SQL he wrote and start with search and replace. His code says this:

    Code:
    INSERT INTO `creature_names` VALUES ('60063', 'Misc', 'Red Gemstone', '', '0', '0', '0', '3', '0', null, '20126', '0', '0', '0', '1', '1', '0', null);
    You need to replace the first value (the ID of 60063) with that max + 1 number (the 8650001) everywhere in the SQL by doing a global search and replace. Then do the next insert line with 8650002, then the next with 8650003, etc.


    The first line should now read:

    Code:
    INSERT INTO `creature_names` VALUES ('8650001', 'Misc', 'Red Gemstone', '', '0', '0', '0', '3', '0', null, '20126', '0', '0', '0', '1', '1', '0', null);
    Hope that helps.
    Last edited by Ooci; 09-04-2008 at 04:50 PM.

Similar Threads

  1. [Release] WotLK Vendors - Updated Frequently Until Finished
    By Zudrik in forum WoW EMU General Releases
    Replies: 46
    Last Post: 03-31-2009, 01:30 PM
  2. [Release] Channel_49 vendors updated for newest NCDB
    By kanqaz in forum World of Warcraft Emulator Servers
    Replies: 16
    Last Post: 02-10-2008, 11:48 AM
  3. [Release] Channel_49 vendors updated for newest NCDB
    By kanqaz in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 01-15-2008, 06:13 AM
  4. [Release] Channel_49 vendors updated for NCDB 758
    By kanqaz in forum World of Warcraft Emulator Servers
    Replies: 10
    Last Post: 01-01-2008, 11:07 PM
All times are GMT -5. The time now is 04:00 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search