[Release] GM Island Full Spawn (Vendor,Trainer,etc.)

[zeal_aiz]

NEW RELEASE!!!
Make GM life easier!! It sale spree at GM Island!! GM Island now have lot of NPC spawned!! Work with latest ArcEmu DB revision. Keep ur vendor up-to-date!! Check -NEW- vendor at each release below!!

GMI VENDOR v3.0 (Release 18 Sept 2008)
All this vendor spawned!
ID NPC Vendor
50078 - Reagent: Miscellaneous
50077 - Reagent: Jeweler
50076 - Reagent: Enchant
50075 - Reagent: Alchemy
50074 - Reagent: Cooking
50073 - Reagent: Blacksmith II
50072 - Reagent: Blacksmith I
50071 - Reagent: Engineer II
50070 - Reagent: Engineer I
50069 - Reagent: Tailor II
50068 - Reagent: Tailor I
50067 - Reagent: Leather II
50066 - Reagent: Leather I
50065 - Recipe: Jeweler L-Z
50064 - Recipe: Jeweler A-K
50063 - Recipe: Enchant H-Z
50062 - Recipe: Enchant A-G
50061 - Recipe: Alchemy A-Z
50060 - Recipe: Cooking A-Z
50059 - Recipe: Blacksmith S-Z
50058 - Recipe: Blacksmith G-R
50057 - Recipe: Blacksmith A-F
50056 - Recipe: Engineer A-Z
50055 - Recipe: Tailor H-Z
50054 - Recipe: Tailor A-G
50053 - Recipe: Leather S-Z
50052 - Recipe: Leather G-R
50051 - Recipe: Leather A-F
50050 - Recipe: Book A-Z
50049 - Misc: Currency
50048 - Misc: Key
50047 - Misc: Enchantment
50045 - Misc: Container
50044 - Misc: Projectile
50043 - Misc: Mount II
50042 - Misc: Mount I
50035 - Arena: Season II
50034 - Arena: Season II
50033 - Arena: Season II
50032 - Arena: Season I
50031 - Arena: Season I
50030 - Arena: Season I
50029 - Armor: Libram/Idol/Totem
50028 - Armor: Off-Hands
50026 - Armor: Miscellaneous
50025 - Armor: Tabard
50024 - Armor: Shirt
50023 - Armor: Cloak
50022 - Armor: Trinket
50021 - Armor: Rings
50020 - Armor: Necklace
50019 - Weapon: Level 100+
50018 - Weapon: Level 75+
50017 - Weapon: Level 65+
50016 - Weapon: Level 60+
50015 - Weapon: Level 50+
50083 - Armor: Shield
50082 - Armor: Feet
50081 - Armor: Waist
50009 - Armor: Wrist
50008 - Armor: Raid Tier VI
50007 - Armor: Raid Tier V
50006 - Armor: Raid Tier IV
50005 - Armor: Raid Tier III
50004 - Armor: Raid Tier II
50003 - Armor: Raid Tier I
50002 - Armor: Dungeon III
50000 - Armor: Dungeon I
50001 - Armor: Dungeon II
50084 - Misc: Custom
60014 - Arena: Season III
60015 - Arena: Season III
60016 - Arena: Season III
60017 - Arena: Season IV
60018 - Arena: Season IV
60063 - Misc: Red Gemstone
60064 - Misc: Blue Gemstone
60065 - Misc: Yellow Gemstone
60066 - Misc: Purple Gemstone
60067 - Misc: Green Gemstone
60068 - Misc: Orange Gemstone
60069 - Misc: Meta/Prismatic Gemstone
60070 - Misc: Simple Gemstone
60019 - Misc: Potion/Flask/Elixir -NEW-
60020 - Misc: Scrolls -NEW-
60021 - Misc: Book/Tomes/Codex -NEW-

GLOBAL TRAINER v3.0 (Release 18 Sept 2008)All this trainer spawned!!
ID NPC Trainer
30030 - Global Spell Caster Trainer
30040 - Global Melee Trainer
30050 - Global Weapon Trainer
30051 - Global Riding Trainer
30052 - Global GM Trainer -NEW-
30053 - Global Buff Trainer -NEW-

Here Download Link
Full GMI Vendor V3.0 -Filebeam - Free Fast File Hosting (http://filebeam.com/b0df06ba17cdbfd31891a224e83d45a9)
Global Trainer Complete V3.0 -Filebeam - Free Fast File Hosting (http://filebeam.com/ff5fcdccb2f6c067d0989ab22a3413f9)
Full List & NPC ID -Filebeam - Free Fast File Hosting (http://filebeam.com/f901a9d7e8ae32bbceae78063fd27165)
PASSWORD:zeal

What U Have To Do
-Download the file. Unpack the RAR file
- Execute the sql file into ur world DB using Navicat or SQLyog
(Take a look at this tuto if u don't know how http://www.ac-web.org/forum/tutorials/32748-how-run-sql-query-batchfile-ect-mysql-nav-heidi.html)
- Restart ur server, Done!!
- In game, type .recall port gmisland and time for shopping:p!!


I'll update this vendor time to time!! Hope u all like it:D
I already test it with NCDB, WhyDB, PSPDB latest rev. If any prob occure let me know. Don't forget +rep lol

REMEMBER this only work on latest ArcEmu DB rev. You need to apply all latest world update by ArcEmu especially the creature_proto update, so u won't get error "Column count doesn't match value count at row 1":
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0;


CREDIT
- Hercules for base sql file I'm working on
- soul02 for new vendor (Season III and IV, Gem, Global Riding Trainer & lot of help:D)
- knaurs for gr8 Global Trainer
- AC Webians that make Custom Item (<DeMoN>, Ubbelol, mrx3666, me)
- someone75 for Navicat tutorial
- Me for add new vendor & trainer, new item, respawn, and release it;)

[Jkiller]

Hehe first reply awesomeness.


In other words, awesomeness! We now finally have a fully spawned Gm island. Can you please post the id's for the vendors so we can use them to make malls, or is it a notepad file inside the folder?

[soul02]

nice dude.. but how come no mount vendors?

[zeal_aiz]

Hehe first reply awesomeness.


In other words, awesomeness! We now finally have a fully spawned Gm island. Can you please post the id's for the vendors so we can use them to make malls, or is it a notepad file inside the folder?

Ok I'll write NPC ID in notepad. Glad u like it:D

nice dude.. but how come no mount vendors?

Thx dude.. I think I placed it 2nd floor in front of Key Vendor. Let me check it

[Modder420]

SQL Error: Duplicate entry '9660713' for key 1

when trying to test "Full GMI Vendor" SQL

[zeal_aiz]

Hehe first reply awesomeness.


In other words, awesomeness! We now finally have a fully spawned Gm island. Can you please post the id's for the vendors so we can use them to make malls, or is it a notepad file inside the folder?

Done add it -Full List:D

nice dude.. but how come no mount vendors?

Check

SQL Error: Duplicate entry '9660713' for key 1

when trying to test "Full GMI Vendor" SQL

Sory my fault include global trainer spawn there. For ur case run this query on or database ur execute this code:
DELETE FROM creature_spawns WHERE entry BETWEEN 30030 AND 30050;
Then run again the vendor sql, After that run this code again:
INSERT INTO `creature_spawns` VALUES ('9660717', '30040', '1', '16228.8', '16281.6', '13.1748', '3.10311', '0', '20129', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('9660718', '30030', '1', '16229.3', '16284.8', '13.1753', '2.92364', '0', '20130', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('9660719', '30050', '1', '16219.9', '16284.4', '13.1753', '6.15554', '0', '20113', '35', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

Already fix it!! New version 1.1 available:D

[Modder420]

tried v1.1 on a clean database and same error.

[zeal_aiz]

tried v1.1 on a clean database and same error.

Do u run this code?
DELETE FROM creature_spawns WHERE entry BETWEEN 30030 AND 30050;

That v1.1 is for one who doesn't apply the v1.0 before. If this prob occur let me see the full error statement.

[Modder420]

Do u run this code?
DELETE FROM creature_spawns WHERE entry BETWEEN 30030 AND 30050;

That v1.1 is for one who doesn't apply the v1.0 before. If this prob occur let me see the full error statement.

i used v1.1 on a CLEAN database. as in a NEW database. and i posted the error. its the same. you didnt fix it.

[zeal_aiz]

Is this the EXACT error message? Still the same??
SQL Error: Duplicate entry '9660713' for key 1
[U even don't mention which table had error so this not full statement that i request]

If u said u apply v.1.1 i dont put that entry anymore in sql file. So i guest u had that entry in ur database. So edit the sql file on that line which has error, change INSERT TO > REPLACE TO

I try to help u man believe me i'll try but plz juz answer my question first. I put lot on effort on this so if someone has prob that doesn't make me happy:(

[Modder420]

Yes its the same exact error. its not my database. its a fresh compile.

SQL Error: Duplicate entry '9660713' for key 1

Exact error. 3rd time i imported a fresh DB and got the same error.

[zeal_aiz]

Hope this gonna work. v1.2 comment plz

[Modder420]

ok ill be happy to test. i'm not trying to be a pain just wanted to point out the error. :P

[zeal_aiz]

ok ill be happy to test. i'm not trying to be a pain just wanted to point out the error. :P

lol thx dude:p

[MarkQuinn]

Very well done Zeal. I've been looking for something like this that has all the mats I can hope for because I run a small server with just my roommates and with no AH or 40 people to run some of the higher instances you need for high level mats, this will come in handy. I'll probably delete the vendors who give away "free" stuff though to cut down on their damned cheating and free twinking, but oh well. ;)

I couldn't seem to find the trainers, BTW.

[delant]

Awesome! Work fine with whydb database +rep:D

[zeal_aiz]

Very well done Zeal. I've been looking for something like this that has all the mats I can hope for because I run a small server with just my roommates and with no AH or 40 people to run some of the higher instances you need for high level mats, this will come in handy. I'll probably delete the vendors who give away "free" stuff though to cut down on their damned cheating and free twinking, but oh well. ;)

I couldn't seem to find the trainers, BTW.

Thx:D Yeah some vendor sell it free bcoz i put '0' on their extended_cost column in vendors table. If u want make it not free require badge, token etc take a look this useful link http://www.ac-web.org/forum/releases/33291-releases-every-extended-cost-id.html. Do u execute Global trainer sql? If still not respawn put this code:
INSERT INTO `creature_spawns` VALUES ('9660717', '30040', '1', '16228.8', '16281.6', '13.1748', '3.10311', '0', '20129', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('9660718', '30030', '1', '16229.3', '16284.8', '13.1753', '2.92364', '0', '20130', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('9660719', '30050', '1', '16219.9', '16284.4', '13.1753', '6.15554', '0', '20113', '35', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
It should be spawn at entrance of GM House

Awesome! Work fine with whydb database +rep:D

Thx glad it work:D

[MarkQuinn]

Do u execute Global trainer sql? If still not respawn put this code:

Yeah I executed both files and I'll do your fix. Thanks again and also thanks for the tutorial on adding prices!

[Modder420]

worked great. good job. :)

[InsaneTrain]

HOT RELEASE!!!
Make GM life easier!! It sale spree at GM Island!! GM Island now have lot of NPC spawned!! Work with latest DB rev (comp. with latest rev ArcEmu)

GMI VENDOR
- All Reagent & Resipe Vendor spawned
- All Weapon & Armor Vendor spawned
- Gem Vendor spawned
- Season I-IV fully spawned
- Tier I-VI fully spawned
- Custom Vendor spawned (sell Custom Item made by AC-Webian)
- Lot of other vendor (See Full List)

GLOBAL TRAINER
- Global Melee Trainer spawned
- Global Caster Trainer spawned
- Global Weapon Trainer spawned

Here Download Link
Full GMI Vendor V1.2 -Filebeam - Free Fast File Hosting (http://filebeam.com/1f572d15c1656a758cce6119904d62d5)
Global Trainer Complete V1 -Filebeam - Free Fast File Hosting (http://filebeam.com/a6974020b916b1c0f36d676d24c6c0ff)
Full List & NPC ID -Filebeam - Free Fast File Hosting (http://filebeam.com/f901a9d7e8ae32bbceae78063fd27165)
pass:zeal

What U Have To Do
-Download the file. Unpack the RAR file
- Execute the sql file into ur world DB using Navicat or SQLyog
- Restart ur server, Done!!
- In game, type .recall port gmisland and time for shopping:p!!


I'll update this vendor time to time!! Hope u all like it:D
I already test it with NCDB, WhyDB, PSPDB latest rev. If any prob occure let me know. Don't forget +rep lol



CREDIT
- Hercules for Base sql file I'm working on
- soul02 for new vendor (Season III and IV, Gem)
- knaurs for gr8 Global Trainer
- AC-Webian for their Custom Item
- Me for edit, rerwrite, respawn, add few vendor and release it;)


Once again I feel like a noob, but how does someone Execute the sql file into ur world DB using Navicat or SQLyog... keep in mind that im a noob at this.. lol, but once you tell me ill hav learned it, and thats one less stupid question to ask on the fourms :D Thanks for your time.

[soul02]

eh?

[vladkoo]

I have a problem My navicat sais :
1136 - Column count doesn't match value count at row 1
when i exequte Full GMI Vendor and
when i exequte Global Trainer Complete says:
1062 - Duplicate entry '30040' for key 1
pls help me fast !This is big.

[soul02]

1136 - Column count doesn't match value count at row 1 = delete try delete 1-2 column at the end

1062 - Duplicate entry '30040' for key 1 = mean u already have that entry id in ur db

[vladkoo]

I still have this error i have don this but i still get it what to do ?

Can some one help me solve the problem ?

[mikel924]

really? ok every GM island i have tired beside spawning my own always says
1136 - Column count doesn't match value count at row 1

which colunm needs to be deleted? or do ihave to go into every line and delete 1 number? would be faster to create my own.

[Lowbreed]

doesn't work on w/ arcemu (tso2s funserver repack)

[zeal_aiz]

I still have this error i have don this but i still get it what to do ?

Can some one help me solve the problem ?

really? ok every GM island i have tired beside spawning my own always says
1136 - Column count doesn't match value count at row 1

which colunm needs to be deleted? or do ihave to go into every line and delete 1 number? would be faster to create my own.

Ok here the fix:
For column count doesn't match:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0;

For duplicate enty run this cleanup:
DELETE FROM creature_names WHERE entry BETWEEN 30030 AND 30050;
DELETE FROM creature_spawns WHERE entry BETWEEN 30030 AND 30050;
DELETE FROM creature_proto WHERE entry BETWEEN 30030 AND 30050;
DELETE FROM trainer_spells WHERE entry BETWEEN 30030 AND 30050;
DELETE FROM trainer_defs WHERE entry BETWEEN 30030 AND 30050;

doesn't work on w/ arcemu (tso2s funserver repack)

What an error message maybe i can fix it

I will add short tuto for using Navicat and apply this fix to new version soon. Btw tq very much soul02 for helping me a lot a be a nice fren to me:) He the only one who rep me for this release:( Owh wait delant too...

[digitalec424]

What an error message maybe i can fix it


Using ArcEmu here..

All I get when I execute the Vendor batch file is:

[Err] 1136 - Column count doesn't match value count at row 1
[Msg] Finished - Unsuccessfully

..and for the trainers:

[Err] 1062 - Duplicate entry '30040' for key 1
[Msg] Finished - Unsuccessfully

[joelberg]

Ac-webian? Eh...give some real credits to the people creating the items then... sounds weird that you get rep for other peoples work.. or some work atleast...

[zeal_aiz]

Using ArcEmu here..

All I get when I execute the Vendor batch file is:

[Err] 1136 - Column count doesn't match value count at row 1
[Msg] Finished - Unsuccessfully

..and for the trainers:

[Err] 1062 - Duplicate entry '30040' for key 1
[Msg] Finished - Unsuccessfully


U apply fix same as above.:P

Ac-webian? Eh...give some real credits to the people creating the items then... sounds weird that you get rep for other peoples work.. or some work atleast...

Done credit to all custom item maker (for time being it only 3 rite now, i'll credit all of them) thx to point out:P What do u think bout my work?:rolleyes:

[Modder420]

im using arcemu and i have no problems.

[vladkoo]

Yes i think that is a good idea and if you want good plase go spawn the m yuor oun vendors at .recall port Gm thats all not .recall port Gmisland go spawn them at Gm only there are 2 islands

[kuldeepsimar42-]

dude i m getting error
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_proto` VALUES ('30040', '100', '100', '1741', '1000000', '1000000', '1000000', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[soul02]

dude i m getting error
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_proto` VALUES ('30040', '100', '100', '1741', '1000000', '1000000', '1000000', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

delete what in red


INSERT INTO `creature_proto` VALUES ('30040', '100', '100', '1741', '1000000', '1000000', '1000000', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');

[kuldeepsimar42-]

there is nothing in red dude i just cant install ny of those sql files into database

1st file gives (full vendor)
[Err] 1136 - Column count doesn't match value count at row 1
[Err] insert into `creature_proto` values('50080','70','70','35','10000','10000','100 0','1','4225','100','0','1000','1001','0','0','0', '0','0','0','0','0','0','0','0','0','0','500','121 2','0','0','0','0','0','0','1.5','0.208','0','0',' 0','0','0','2.5','8','14','0','0','0','0','0','0', '0');
[Msg] Finished - Unsuccessfully

2nd (global trainer)
[Err] 1062 - Duplicate entry '30040' for key 1
[Err] INSERT INTO `creature_names` VALUES ('30040', 'Global Melee Trainer', 'Hunter, Paladin, Rogue, Shaman & Warrior Trainers', '', '16', '4', '0', '3', '0', null, '20129', '0', '0', '0', '1', '1', '0', '0');
[Msg] Finished - Unsuccessfully
----------------------------------------

hope for help:)

[lilaug2]

Awesome job man.

+rep

[zeal_aiz]

there is nothing in red dude i just cant install ny of those sql files into database

1st file gives (full vendor)
[Err] 1136 - Column count doesn't match value count at row 1
[Err] insert into `creature_proto` values('50080','70','70','35','10000','10000','100 0','1','4225','100','0','1000','1001','0','0','0', '0','0','0','0','0','0','0','0','0','0','500','121 2','0','0','0','0','0','0','1.5','0.208','0','0',' 0','0','0','2.5','8','14','0','0','0','0','0','0', '0');
[Msg] Finished - Unsuccessfully

2nd (global trainer)
[Err] 1062 - Duplicate entry '30040' for key 1
[Err] INSERT INTO `creature_names` VALUES ('30040', 'Global Melee Trainer', 'Hunter, Paladin, Rogue, Shaman & Warrior Trainers', '', '16', '4', '0', '3', '0', null, '20129', '0', '0', '0', '1', '1', '0', '0');
[Msg] Finished - Unsuccessfully
----------------------------------------

hope for help:)

"Column count doesn't match value count at row 1" happen because u doesn't app world update by ArcEmu on creature_proto table. Run this code dude:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0;
"Duplicate entry '30040' for key 1" mean u have already that npc. But to make it work back run this cleanup code:
DELETE FROM creature_names WHERE entry BETWEEN 30030 AND 30050;
DELETE FROM creature_spawns WHERE entry BETWEEN 30030 AND 30050;
DELETE FROM creature_proto WHERE entry BETWEEN 30030 AND 30050;
DELETE FROM trainer_spells WHERE entry BETWEEN 30030 AND 30050;
DELETE FROM trainer_defs WHERE entry BETWEEN 30030 AND 30050;
Already add this cleanup at new version of Global Trainer version 1.1!!!

Awesome job man.

+rep

Tq very much lilaug2:D

[Titanus]

Aww man seriously this is goood. Looking for this for a long2 tiimee. GG +rep
Downloading.....

[mrx3666]

I might make more weapons but I need ideas since I keep making to OP'ed weapons... my last one is the deadliest weapon you'd ever see... If you have any suggestions please pm me ;) I expect some suggestions from you zeal_aiz of anyone!!! D:<

WoW Vendetta - Wage Your War (http://wow-v.com/item.php?id=78574) if you were wondering what it looked (The deadliest weapon)

[jimmon1989]

i went to the download links and all of them are password protected and i dont see the password posted anywhere on the thread:confused:

[faddix]

i went to the download links and all of them are password protected and i dont see the password posted anywhere on the thread:confused:

read again :)
here:
password is: zeal

------------------------------------------------------

[jimmon1989]

ok thanx man

[sufa]

it is good but for public servers it is not good lol cause of hackers

[zeal_aiz]

bump..

[Jkiller]

Ok, Zeal can I please have an update of what's been going on with this, any fixes or anything?

[Kaizo v1.5 E leet]

Works like a charm, thanks mate, much needed.

[revoolt23]

Works like a charm, thanks mate, much needed.

same here m8 gj

[alextyr]

Hey zeal got a Question for u...

Can u make a Global trainer For riding aswell?

From Alextyr

[zorbs]

Hmm.. I've done everything you were saying to do like executing those queries and receive this :

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

any idea?

[zeal_aiz]

Hmm.. I've done everything you were saying to do like executing those queries and receive this :

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

any idea?

Are u already query this code?
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0;

[zorbs]

Ofc.. I tried all but still doesnt work

[zeal_aiz]

Ofc.. I tried all but still doesnt work

I guest the last solution is to edit the sql, delete last number, for example:

Before:
INSERT INTO `creature_proto` VALUES ('30040', '100', '100', '1741', '1000000', '1000000', '1000000', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');

After:
INSERT INTO `creature_proto` VALUES ('30040', '100', '100', '1741', '1000000', '1000000', '1000000', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0');

notice that red colour number been delete. Only edit creature_proto query

[zorbs]

hmm .. how am I suppose to delete the last number? do u have a query or something that I can execute?

[zeal_aiz]

hmm .. how am I suppose to delete the last number? do u have a query or something that I can execute?

Edit the sql files using notepad. Look at line creature_proto, edit it. Btw what emu core did u use? What database u did use?

[zorbs]

Atm I am using Pedregons Repack V2 and my database manager is navicat 8

[zeal_aiz]

Atm I am using Pedregons Repack V2 and my database manager is navicat 8

Ahh u using repack. i don't know well this repack, what emu did it use (ArcEmu, Ascent, Mangos etc)?

[zorbs]

Reborn Ascent .. So I guess it is ascent

[mrx3666]

Yes, it's ascent. ArcEmu has completely different styled commands than that.

[zeal_aiz]

Reborn Ascent .. So I guess it is ascent

Reborn Ascent... It is different from ArcEmu. So u shouldn't run the query before which ALTER creature_proto table. As my first post said this vendor can only adapt ArcEmu world database so bad news for u it can't support your repack that why that error keep coming. Sory i never use Reborn Ascent so there will be no fix for Reborn Ascent DB

[zorbs]

You mean I can't install the vendors now?

[soul02]

Hey zeal got a Question for u...

Can u make a Global trainer For riding aswell?

From Alextyr

here dude.... use this


INSERT INTO `creature_names` VALUES ('30051', 'Global Riding Trainer', 'Soul02', '', '16', '4', '0', '3', '0', null, '20107', '0', '0', '0', '1', '1', '0', null);
INSERT INTO `creature_proto` VALUES ('30051', '100', '100', '35', '1000000', '1000000', '1000000', '1', '17', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `trainer_defs` VALUES ('30051', '0', '0', '0', '0', 'Hi $N, What can I train for you Today?', '0', '0');

INSERT INTO `trainer_spells` VALUES ('30051', '33389', '0', '350000', '0', '0', '0', '30', '0', '0');
INSERT INTO `trainer_spells` VALUES ('30051', '33392', '0', '5400000', '33388', '762', '75', '60', '33388', '0');
INSERT INTO `trainer_spells` VALUES ('30051', '34092', '0', '8000000', '33391', '762', '150', '70', '33391', '0');
INSERT INTO `trainer_spells` VALUES ('30051', '34093', '0', '50000000', '34090', '762', '225', '70', '34090', '0');

You mean I can't install the vendors now?

u can if u make ur own creature_names and creature_proto

[alextyr]

here dude.... use this


INSERT INTO `creature_names` VALUES ('30051', 'Global Riding Trainer', 'Soul02', '', '16', '4', '0', '3', '0', null, '20107', '0', '0', '0', '1', '1', '0', null);
INSERT INTO `creature_proto` VALUES ('30051', '100', '100', '35', '1000000', '1000000', '1000000', '1', '17', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `trainer_defs` VALUES ('30051', '0', '0', '0', '0', 'Hi $N, What can I train for you Today?', '0', '0');

INSERT INTO `trainer_spells` VALUES ('30051', '33389', '0', '350000', '0', '0', '0', '30', '0', '0');
INSERT INTO `trainer_spells` VALUES ('30051', '33392', '0', '5400000', '33388', '762', '75', '60', '33388', '0');
INSERT INTO `trainer_spells` VALUES ('30051', '34092', '0', '8000000', '33391', '762', '150', '70', '33391', '0');
INSERT INTO `trainer_spells` VALUES ('30051', '34093', '0', '50000000', '34090', '762', '225', '70', '34090', '0');



Thx man think ill try it

[Cybrson]

They all have passwords...? Did you add them cause you working on those codes? or did you do on purpose?

[mrx3666]

The password is to make sure no leechers can get it.

[soul02]

They all have passwords...? Did you add them cause you working on those codes? or did you do on purpose?

pass: zeal

[Zaxer]

Omg this is AWESOME!

[zeal_aiz]

The password is to make sure no leechers can get it.

Absolutely:p

here dude.... use this


INSERT INTO `creature_names` VALUES ('30051', 'Global Riding Trainer', 'Soul02', '', '16', '4', '0', '3', '0', null, '20107', '0', '0', '0', '1', '1', '0', null);
INSERT INTO `creature_proto` VALUES ('30051', '100', '100', '35', '1000000', '1000000', '1000000', '1', '17', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `trainer_defs` VALUES ('30051', '0', '0', '0', '0', 'Hi $N, What can I train for you Today?', '0', '0');

INSERT INTO `trainer_spells` VALUES ('30051', '33389', '0', '350000', '0', '0', '0', '30', '0', '0');
INSERT INTO `trainer_spells` VALUES ('30051', '33392', '0', '5400000', '33388', '762', '75', '60', '33388', '0');
INSERT INTO `trainer_spells` VALUES ('30051', '34092', '0', '8000000', '33391', '762', '150', '70', '33391', '0');
INSERT INTO `trainer_spells` VALUES ('30051', '34093', '0', '50000000', '34090', '762', '225', '70', '34090', '0');



u can if u make ur own creature_names and creature_proto

Wow this is nice soul02. I'll add it and credit it to u:D +rep

Omg this is AWESOME!

Thx mate

[Magissia]

Once again I feel like a noob, but how does someone Execute the sql file into ur world DB using Navicat or SQLyog... keep in mind that im a noob at this.. lol, but once you tell me ill hav learned it, and thats one less stupid question to ask on the fourms :D Thanks for your time.
http://www.ac-web.org/forum/tutorials/32748-how-run-sql-query-batchfile-ect-mysql-nav-heidi.html

[sammyg69]

if u guys were smart u wouldnt dl this i did and ran it now i have to restart my server everytime i make an npc

[swiftmpc]

I've been searching for something like this so I can't wait to use it...

I got to the point where it says "SQL Error: Table 'world.items' doesn't exist"

I know somewhere along the line I did something stupid.. And im sure this can be fixed with something really simple im just a nub at the whole SQL concept.

[someone75]

you need to get a new database or find a download for the table items cause its showing it doesn't exist.

If you do have a table called items then your trying to execute the sql query in the wrong database.

[swiftmpc]

I found Items... now as I try to execute it... it says

"SQL Error: "Unknown column 'name' in 'field list'"

[zeal_aiz]

I found Items... now as I try to execute it... it says

"SQL Error: "Unknown column 'name' in 'field list'"

Install new clean DB, then make sure u execute sql at ur world database not character or logon DB (eg. Ascent, WhyDB, NCDB, world etc.) Take a look this tuto if u don't know how http://www.ac-web.org/forum/tutorials/32748-how-run-sql-query-batchfile-ect-mysql-nav-heidi.html. Credit to someone75:D. Also make sure u using ArcEmu latest rev, rev834 and above is compatible

NEW RELEASE GLOBAL TRAINER V2.0!!!

[swiftmpc]

much appreciated for the help.
got it working and its great

+rep <3

[snowflaker]

hi.May i know how to fix pointer bug ? when i move mouse over some vendors it doesnt show my cursor it just like disappear :/.

[soul02]

hi.May i know how to fix pointer bug ? when i move mouse over some vendors it doesnt show my cursor it just like disappear :/.

use this

update `creature_names` set `info_str`=''

*edit
bump!

[mrx3666]

bump :p

[zeal_aiz]

use this

update `creature_names` set `info_str`=''

*edit
bump!

Tq soul02. Yeah bump!!:D

[Neeko]

Nice work. Thanks for this zeal and soul02!
no problems at all installing...

neeko

[crystalboom323]

I have a problem

For the trainers I get [Err] 1136 - Column count doesn't match value count at row 1
[Err] insert into `creature_proto` values('50080','70','70','35','10000','10000','100 0','1','4225','100','0','1000','1001','0','0','0', '0','0','0','0','0','0','0','0','0','0','500','121 2','0','0','0','0','0','0','1.5','0.208','0','0',' 0','0','0','2.5','8','14','0','0','0','0','0','0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

And for global I get [Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_proto` VALUES ('30040', '100', '100', '1741', '1000000', '1000000', '1000000', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[zeal_aiz]

I have a problem

For the trainers I get [Err] 1136 - Column count doesn't match value count at row 1
[Err] insert into `creature_proto` values('50080','70','70','35','10000','10000','100 0','1','4225','100','0','1000','1001','0','0','0', '0','0','0','0','0','0','0','0','0','0','500','121 2','0','0','0','0','0','0','1.5','0.208','0','0',' 0','0','0','2.5','8','14','0','0','0','0','0','0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

And for global I get [Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_proto` VALUES ('30040', '100', '100', '1741', '1000000', '1000000', '1000000', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------


First question what emu did u use? ArcEmu, Ascent, Mangos etc. Then are already apply the fix at creature_proto at first page?

[doko1990b]

ok its working flawless on my server. and one thing. Global trainers are teaching spells that are not supposed to learn before and after specing. u know what I mean?? when I'm Subtlety spec'd rogue i can learn Mutilate from Assassin tree. (i didn't pic the mutilate talent)lol. can u fix this???

[zeal_aiz]

NEW RELEASE!!!!

GMI VENDOR v3.0 featuring new vendor:
1. Misc: Potion/Flask/Elixir
2. Misc: Scrolls
3. Misc: Books/Tomes/Codex

Global Trainer v3.0 featuring new trainer:
1. Global GM Trainer
2. Global Buff Trainer

Let me know if u want add new item into vendor or cool GM spell u want to add!!:D Reply plz

[mikskie]

where can i download
arcemu?

[Hurkulez]

zeal_aiz,

Thx for the mention

+rep

[zeal_aiz]

where can i download
arcemu?

If u using repack, make sure u using ArcEmu coz diffrent emu diffrent DB structure. If u compile yourself, ArcEmu SVN locate svn - Revision 1048: / (http://arcemu.info/svn).
I can compile for u but it not the best way because u can't really choose whether want to use sun++ or other script etc. Later on i also need to compile database for u (Then i think i have to release my own repack after that:P) So the best way, u download faddix repack because he constantly update his emu core (using ArcEmu of course) & already compile all things together http://www.ac-web.org/forum/releases/27134-release-ac-web-ultimate-repack-7-8-updated-2-4-3-warpnpc.html (http://www.ac-web.org/forum/releases/27134-release-ac-web-ultimate-repack-7-8-updated-2-4-3-warpnpc.html) (credit to faddix) but one prob is i don't know who GMI Vendor he using when he say "GMI Vendors(again :)...)" maybe his own GMI Vendor so when u using my GMI Vendor perhaps there is unappropriated vendor spawn in GM Island.. i don't know:P perhaps

zeal_aiz,

Thx for the mention

+rep

lol np, u deserve credit & rep from me. Always:D

[mikskie]

can you make just a gmisland pack like this one but for ascent

[zeal_aiz]

can you make just a gmisland pack like this one but for ascent

Let me see. Do you mean new one ascent, Andy's Ascent?

[mikskie]

uhm i have normal ascent

[zeal_aiz]

uhm i have normal ascent

Hem i'll looking forward to it. Gonna check table structure for Ascent. So i gonna make it suit latest Ascent rev5000 n above.

[mikskie]

Thanks mate it i would be very thankfull

[pipilla]

can you re-upload it !?

[abndrew82]

Thanks much for this, very helpful since using different database then from Repacks now

[rbe1704]

can you make this for ascent i love this job :p

[shadowater99]

no offense but i think you shouldnt release this kind of stuff serously if people want it. they should make it them selves i taught my self. PEOPLE if you want this kind of stuff get a custom repack off of someone and figure out hot it works get all your display ids and codeing then drop that server start your own bam! yours is better and you have a easier understanding

Head Admin of THE LOST VORTEX--- Shadow has spoken

[wibby50]

Aside from a few errors (didnt take long to fix. I just removed all of the spawning, because of the row 1 error. didnt wanna fix it. then the custom items had a TON of errors, and some of it was also in the adding to the vendor. it starts about line 6400, and you either added extra spaces, or you had no spaces and no 's), it is awsome

[manguerola]

+rep it work for me

[sufa]

good release but not practical on a private server that is public some hackers would go to gm island and bam get all the stuff free which kinda sucks and trust me some can !!! lol

[Loxad]

Hello, I'm having a problem with Global Trainers. I have added them succesfully to Database and spawned them but I can't talk to Global Trainers in-game, except Global GM Trainer and Global Buff Trainer, they are working fine. So could anyone help me to make Global Spell Caster Trainer, Global Melee Trainer, Global Weapon Trainer and Global Riding Trainer to work? :( +Rep for the one who knows how to fix that. :P

[triplex3]

will this be updated for WotLK? Also it would be cool with a global proffession trainer too.

[baboo]

Nice it work i will +rep

[Elementalbob]

Kk when I go to execute the batch file it says

[Err] 1062 - Duplicate entry '60019-21546' for key 1
[Err] INSERT INTO `vendors` VALUES ('60019', '21546', '1', '0', '0', '0');
[Msg] Finished - Unsuccessfully

[zxcvbnmmnbvcxz]

ok im using arcemu and i already executed "ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0;"
it gives me the error [Err] 1060 - Duplicate column name 'modImmunities'
[Err] ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0;
[Msg] Finished - Unsuccessfully

and i am still getting the same error

[zeal_aiz]

It mean u already have that table. So skip that step juz execute GM vendor sql.

[cruiser101]

probably because these vendors are old and probably dont support your version.

[zxcvbnmmnbvcxz]

i did that step but it still gave me the error >.<

[zeal_aiz]

I mean skip alter mod immunity step. This is an old step no need to do this if u have WotLK ArcEmu. Juz unrar the Full GMI Vendor and then execute the sql. This should work in ArcEmu since vendor table doesn't change in recent revision. creature_spawn table i'm not really sure if it change or not. If it have some change perhaps u should edit a little bit at creature_spawn query on my sql or juz drop the query. In case u drop the query so u need to spawn it ur self later on.

[birdofdeath]

these vendors are old so their structure for the 'creature_proto' table is behind the times now... to fix this just run both of these (its how i fixed it anyway:

/*
MySQL Data Transfer
Source Host: localhost
Source Database: world
Target Host: localhost
Target Database: world
Date: 12/5/2008 7:40:46 AM
*/

SET FOREIGN_KEY_CHECKS=0;

REPLACE INTO `creature_names` VALUES ('30050', 'Global Weapon Trainer', '', '', '16', '4', '0', '3', '0', null, '20113', '0', '0', '0', '1', '1', '0', '0');
REPLACE INTO `creature_names` VALUES ('30053', 'Global Buff Trainer', 'Melee/Range/Caster', '', '16', '4', '0', '3', '0', null, '22906', '0', '0', '0', '1', '1', '0', '0');
REPLACE INTO `creature_names` VALUES ('30040', 'Global Melee Trainer', 'Hunter, Paladin, Rogue, Shaman & Warrior Trainers', '', '16', '4', '0', '3', '0', null, '20129', '0', '0', '0', '1', '1', '0', '0');
REPLACE INTO `creature_names` VALUES ('30051', 'Global Riding Trainer', '', '', '16', '4', '0', '3', '0', null, '20107', '0', '0', '0', '1', '1', '0', '0');
REPLACE INTO `creature_names` VALUES ('30030', 'Global Spell Caster Trainer', 'Mage, Priest, Warlock & Druid Trainer', '', '16', '4', '0', '3', '0', null, '20130', '0', '0', '0', '1', '1', '0', '0');


then

/*
MySQL Data Transfer
Source Host: localhost
Source Database: world
Target Host: localhost
Target Database: world
Date: 12/5/2008 7:40:50 AM
*/

SET FOREIGN_KEY_CHECKS=0;
REPLACE INTO `creature_proto` VALUES ('30030', '100', '100', '1741', '1000000', '1000000', '1000000', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '3', '8', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
REPLACE INTO `creature_proto` VALUES ('30050', '100', '100', '35', '1000000', '1000000', '1000000', '1', '17', '1000', '0', '1000', '1000', '0', '0', '0', '0', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '3', '8', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
REPLACE INTO `creature_proto` VALUES ('30040', '100', '100', '1741', '1000000', '1000000', '1000000', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '3', '8', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
REPLACE INTO `creature_proto` VALUES ('30051', '100', '100', '35', '1000000', '1000000', '1000000', '1', '17', '1000', '0', '1000', '1000', '0', '0', '0', '0', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '3', '8', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
REPLACE INTO `creature_proto` VALUES ('30052', '80', '80', '35', '126000', '126000', '0', '1', '2', '2000', '0', '336.352', '469.189', '0', '103', '509', '0', '0', '9729', '0', '0', '0', '0', '0', '0', '3', '0.525', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');
REPLACE INTO `creature_proto` VALUES ('30053', '100', '100', '35', '1000000', '1000000', '1000000', '1', '17', '1000', '0', '1000', '1000', '0', '0', '0', '0', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '3', '8', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');



You shouldnt need to do anytthing else if you have already run the main sql. restart and you should be fine.

I personally cant wait for the next set of these I like these vendors alot

[zeal_aiz]

Thx birdofdeath, yeah i made this two month ago for 2.4.3 client but since there much positive response, i'll make this vendor suit latest ArcEmu and Aspire too. But 1st i gonna compile both of them 1st since i play on retail quite a while. Next release gonna include new item n new tier.

[birdofdeath]

awesome man that sounds incredible, keep up the great work!

[zxcvbnmmnbvcxz]

yea, and i got the trainers sql working with a few edits

[Simzy]

if you have problems getting the trainer defs to work use this INSERT INTO `trainer_defs` VALUES ('66630', '0', '0', '0', '0', '0','0','0','Hi $N, What can I train for you Today?', '0', '0');
INSERT INTO `trainer_defs` VALUES ('66640', '0', '0', '0', '0', '0','0','0','Hi $N, What can I train for you Today?', '0', '0');
INSERT INTO `trainer_defs` VALUES ('66650', '0', '0', '0', '0', '0','0','0','Hi $N, how can I help you?', '0', '0');
INSERT INTO `trainer_defs` VALUES ('66651', '0', '0', '0', '0', '0','0','0', 'Hi $N, What can I train for you Today?', '0', '0');
INSERT INTO `trainer_defs` VALUES ('66662', '0', '0', '0', '0', '0','0','0', 'Hi $N, Ready to be true Game Master?', '0', '0');
INSERT INTO `trainer_defs` VALUES ('66653', '0', '0', '0', '0', '0','0','0', 'Hi $N, What can I train for you Today?', '0', '0');


just change the entry to whatever your using for them on your server

[zeal_aiz]

Thx for patient. Wait a few hour tilll I release new GMI Vendor which contain WotlK stuff, thousand of fix, thousand of cleanup, thousand of addition and editing. Required a few test before i release it. Atm this GMI will support ArcEmu later on i will make it support AspireCore too and perhaps MANGoS too.

For Global Trainer I need a day to make cleanup, addition, compatibility with latest WotLK emu.

New GMI concept support enable and disable function for easy install in any of ur database and easy removal. Most importantly i'll make it compile with no problem with latest emu.

EDIT: New thread made!! Please reply post HERE (http://www.ac-web.org/forum/releases/42066-release-full-gmi-vendor-mall-v4-0-a.html)

[Discrit]

aight i fixed the trainers code so if should work for those people having
colum errors

DOWNLOAD NOW! (http://filebeam.com/007aa2b8da33656c43fd2b8be905df88)

[Xam13]

um... password?

[vampire777]

whats the password?

[luraguttn]

duplicate entry 30052 .... what is the problem ?

[simonv]

I've been looking for this, thanks for it, i'm goin to try it now, hope i find no errors ^_^

[herculis]

haha nice i just got done executing it works like a pickle +rep

[Morphex]

Is this for arcemu or HS etc?

[simonv]

i'm using arcemu and it works just FINE, i only missed the Dungeon II spawned, but i just spawned it myself +rep

[luraguttn]

some pictures of the hole thing would be greate :)

[vicoden]

NEW RELEASE!!!
Make GM life easier!! It sale spree at GM Island!! GM Island now have lot of NPC spawned!! Work with latest ArcEmu DB revision. Keep ur vendor up-to-date!! Check -NEW- vendor at each release below!!

GMI VENDOR v3.0 (Release 18 Sept 2008)
All this vendor spawned!
ID NPC Vendor
50078 - Reagent: Miscellaneous
50077 - Reagent: Jeweler
50076 - Reagent: Enchant
50075 - Reagent: Alchemy
50074 - Reagent: Cooking
50073 - Reagent: Blacksmith II
50072 - Reagent: Blacksmith I
50071 - Reagent: Engineer II
50070 - Reagent: Engineer I
50069 - Reagent: Tailor II
50068 - Reagent: Tailor I
50067 - Reagent: Leather II
50066 - Reagent: Leather I
50065 - Recipe: Jeweler L-Z
50064 - Recipe: Jeweler A-K
50063 - Recipe: Enchant H-Z
50062 - Recipe: Enchant A-G
50061 - Recipe: Alchemy A-Z
50060 - Recipe: Cooking A-Z
50059 - Recipe: Blacksmith S-Z
50058 - Recipe: Blacksmith G-R
50057 - Recipe: Blacksmith A-F
50056 - Recipe: Engineer A-Z
50055 - Recipe: Tailor H-Z
50054 - Recipe: Tailor A-G
50053 - Recipe: Leather S-Z
50052 - Recipe: Leather G-R
50051 - Recipe: Leather A-F
50050 - Recipe: Book A-Z
50049 - Misc: Currency
50048 - Misc: Key
50047 - Misc: Enchantment
50045 - Misc: Container
50044 - Misc: Projectile
50043 - Misc: Mount II
50042 - Misc: Mount I
50035 - Arena: Season II
50034 - Arena: Season II
50033 - Arena: Season II
50032 - Arena: Season I
50031 - Arena: Season I
50030 - Arena: Season I
50029 - Armor: Libram/Idol/Totem
50028 - Armor: Off-Hands
50026 - Armor: Miscellaneous
50025 - Armor: Tabard
50024 - Armor: Shirt
50023 - Armor: Cloak
50022 - Armor: Trinket
50021 - Armor: Rings
50020 - Armor: Necklace
50019 - Weapon: Level 100+
50018 - Weapon: Level 75+
50017 - Weapon: Level 65+
50016 - Weapon: Level 60+
50015 - Weapon: Level 50+
50083 - Armor: Shield
50082 - Armor: Feet
50081 - Armor: Waist
50009 - Armor: Wrist
50008 - Armor: Raid Tier VI
50007 - Armor: Raid Tier V
50006 - Armor: Raid Tier IV
50005 - Armor: Raid Tier III
50004 - Armor: Raid Tier II
50003 - Armor: Raid Tier I
50002 - Armor: Dungeon III
50000 - Armor: Dungeon I
50001 - Armor: Dungeon II
50084 - Misc: Custom
60014 - Arena: Season III
60015 - Arena: Season III
60016 - Arena: Season III
60017 - Arena: Season IV
60018 - Arena: Season IV
60063 - Misc: Red Gemstone
60064 - Misc: Blue Gemstone
60065 - Misc: Yellow Gemstone
60066 - Misc: Purple Gemstone
60067 - Misc: Green Gemstone
60068 - Misc: Orange Gemstone
60069 - Misc: Meta/Prismatic Gemstone
60070 - Misc: Simple Gemstone
60019 - Misc: Potion/Flask/Elixir -NEW-
60020 - Misc: Scrolls -NEW-
60021 - Misc: Book/Tomes/Codex -NEW-

GLOBAL TRAINER v3.0 (Release 18 Sept 2008)All this trainer spawned!!
ID NPC Trainer
30030 - Global Spell Caster Trainer
30040 - Global Melee Trainer
30050 - Global Weapon Trainer
30051 - Global Riding Trainer
30052 - Global GM Trainer -NEW-
30053 - Global Buff Trainer -NEW-

Here Download Link
Full GMI Vendor V3.0 -Filebeam - Free Fast File Hosting (http://filebeam.com/b0df06ba17cdbfd31891a224e83d45a9)
Global Trainer Complete V3.0 -Filebeam - Free Fast File Hosting (http://filebeam.com/ff5fcdccb2f6c067d0989ab22a3413f9)
Full List & NPC ID -Filebeam - Free Fast File Hosting (http://filebeam.com/f901a9d7e8ae32bbceae78063fd27165)
PASSWORD:zeal

What U Have To Do
-Download the file. Unpack the RAR file
- Execute the sql file into ur world DB using Navicat or SQLyog
(Take a look at this tuto if u don't know how http://www.ac-web.org/forum/tutorials/32748-how-run-sql-query-batchfile-ect-mysql-nav-heidi.html)
- Restart ur server, Done!!
- In game, type .recall port gmisland and time for shopping:p!!


I'll update this vendor time to time!! Hope u all like it:D
I already test it with NCDB, WhyDB, PSPDB latest rev. If any prob occure let me know. Don't forget +rep lol

REMEMBER this only work on latest ArcEmu DB rev. You need to apply all latest world update by ArcEmu especially the creature_proto update, so u won't get error "Column count doesn't match value count at row 1":
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0;


CREDIT
- Hercules for base sql file I'm working on
- soul02 for new vendor (Season III and IV, Gem, Global Riding Trainer & lot of help:D)
- knaurs for gr8 Global Trainer
- AC Webians that make Custom Item (<DeMoN>, Ubbelol, mrx3666, me)
- someone75 for Navicat tutorial
- Me for add new vendor & trainer, new item, respawn, and release it;)

Wtf this does not work worth a shit im using arcemu 2048 and there are errors out the ass get ur stuff straight please before u put it on here and say is 100 percent

[Namesis]

hey and.. uhm
all vendors (not trainers) when i click it it says:

No sell template found. Report this to dev: <npc id>.

is there isnt a faster way to add all items to this vendors? i thought it already had all.. but they're empty basically. What can i do?..

thx & bb

[sanderk]

Does this work for 3.0.8?

[jimboisit]

when i move the NPC to were i whant them how do i save the there so when i start the server back up they are still in the same place were i left them anyone plz ?

[covenantl33t]

[Err] 1136 - Column count doesn't match value count at row 1
[Err] insert into `creature_proto` values('50080','70','70','35','10000','10000','100 0','1','4225','100','0','1000','1001','0','0','0', '0','0','0','0','0','0','0','0','0','0','500','121 2','0','0','0','0','0','0','1.5','0.208','0','0',' 0','0','0','2.5','8','14','0','0','0','0','0','0', '0');
[Msg] Finished - Unsuccessfully

Thats the error i get when i try doing this, I've tried all the coded fixes you wrote and still nothing. I'm using AC Web Ultimate Repack, the ArcEmu DB. Any help please?! =X

[PaikProductions]

There is a newer release of this one use the link in the first post!

[ss4man]

[SQL]
INSERT INTO `creature_names` VALUES ('30052', 'Global GM Trainer', '', '', '16', '4', '0', '3', '0', null, '23195', '0', '0', '0', '1', '1', '0', null);
[Err] 1062 - Duplicate entry '30052' for key 1


QQ help please

[Artilles]

[SQL]
INSERT INTO `creature_names` VALUES ('30052', 'Global GM Trainer', '', '', '16', '4', '0', '3', '0', null, '23195', '0', '0', '0', '1', '1', '0', null);
[Err] 1062 - Duplicate entry '30052' for key 1


QQ help please

Try this:

UPDATE INTO `creature_names` VALUES ('30052', 'Global GM Trainer', '', '', '16', '4', '0', '3', '0', null, '23195', '0', '0', '0', '1', '1', '0', null);

[hamhawk596]

i keep getting the column count error idk what to do?

i get the column count error and i cant fix it then i query the

ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0;

but then it sais

duplicate column name "modimmunities"


wtf is wrong

[chrono31]

All I get is errors.

Full GMI Vendors gives me this when I execute
it in world:

[Err] 1136 - Column count doesn't match value count at row 1
[Err] insert into `creature_names` values('50078','Reagent','Miscellaneous','','0','7 ','0','0','0','0','18106','18106','0','0','1','1', '0','0'),
('50077','Reagent','Jeweler','','0','7','0','0','0 ','0','18106','18106','0','0','1','1','0','0'),
('50076','Reagent','Enchant','','0','7','0','0','0 ','0','18106','18106','0','0','1','1','0','0'),
('50075','Reagent','Alchemy','','0','7','0','0','0 ','0','18106','18106','0','0','1','1','0','0'),
('50074','Reagent','Cooking','','0','7','0','0','0 ','0','18106','18106','0','0','1','1','0','0'),
('50073','Reagent','Blacksmith II','','0','7','0','0','0','0','18106','18106','0' ,'0','1','1','0','0'),
('50072','Reagent','Blacksmith I','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50071','Reagent','Engineer II','','0','7','0','0','0','0','18106','18106','0' ,'0','1','1','0','0'),
('50070','Reagent','Engineer I','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50069','Reagent','Tailor II','','0','7','0','0','0','0','18106','18106','0' ,'0','1','1','0','0'),
('50068','Reagent','Tailor I','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50067','Reagent','Leather II','','0','7','0','0','0','0','18106','18106','0' ,'0','1','1','0','0'),
('50066','Reagent','Leather I','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50065','Recipe','Jeweler L-Z','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50064','Recipe','Jeweler A-K','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50063','Recipe','Enchant H-Z','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50062','Recipe','Enchant A-G','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50061','Recipe','Alchemy A-Z','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50060','Recipe','Cooking A-Z','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50059','Recipe','Blacksmith S-Z','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50058','Recipe','Blacksmith G-R','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50057','Recipe','Blacksmith A-F','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50056','Recipe','Engineer A-Z','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50055','Recipe','Tailor H-Z','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50054','Recipe','Tailor A-G','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50053','Recipe','Leather S-Z','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50052','Recipe','Leather G-R','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50051','Recipe','Leather A-F','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50050','Recipe','Book A-Z','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50049','Misc','Currency','','0','7','0','0','0', '0','18106','18106','0','0','1','1','0','0'),
('50048','Misc','Key','','0','7','0','0','0','0',' 18106','18106','0','0','1','1','0','0'),
('50047','Misc','Enchantment','','0','7','0','0',' 0','0','18106','18106','0','0','1','1','0','0'),
('50045','Misc','Container','','0','7','0','0','0' ,'0','18106','18106','0','0','1','1','0','0'),
('50044','Misc','Projectile','','0','7','0','0','0 ','0','18106','18106','0','0','1','1','0','0'),
('50043','Misc','Mount II','','0','7','0','0','0','0','18106','18106','0' ,'0','1','1','0','0'),
('50042','Misc','Mount I','','0','7','0','0','0','0','18106','18106','0', '0','1','1','0','0'),
('50035','Arena','Season II','','0','7','0','0','0','0','18106','18106','0' ,'0','1','1','0','0'),
('50034','Arena','Season II','','0','7','0','0','0','0','18106','18106','0' ,'0','1','1','0','0'),
('50033','Arena','Season II','','0','7','0','0','0','0','18106','18106','0' ,'0','1','1','0','0'),
('50032','Arena','Season I','','0','7','0','0','0','0','18106','18106','0', '0','1','
[Msg] Finished - Unsuccessfully
--------------------------------------------------


And Global Trainer Complete:

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_names` VALUES ('30040', 'Global Melee Trainer', 'Hunter, Paladin, Rogue, Shaman & Warrior Trainers', '', '16', '4', '0', '3', '0', null, '20129', '0', '0', '0', '1', '1', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
I tried to use the trick in the first post by executing it as a sql
But it failed to..
(Column count doesn't match value count at row 1)

What could it be?
http://i284.photobucket.com/albums/ll27/Stacysrocker/chrono31.png

[Alvanaar]

To answer your question "What could it be?". Well this post is pretty much a year old. ArcEmu has changed substantially in that time.

[snobben12]

Global Trainer Complete V3.0 -Filebeam - Free Fast File Hosting (http://filebeam.com/ff5fcdccb2f6c067d0989ab22a3413f9)

Says broken for me

[treetree]

they all broken

tree :(

[ubbadd]

When i try with the global trainer SQL file it says column count doesn't match value count at row 1.

what shall i do?

i use HeidiSQL 5.0

[xXemuXx]

"Column count doesn't match value count at row 1" happen because u doesn't app world update by ArcEmu on creature_proto table. Run this code dude:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0;
"Duplicate entry '30040' for key 1" mean u have already that npc. But to make it work back run this cleanup code:
DELETE FROM creature_names WHERE entry BETWEEN 30030 AND 30050;
DELETE FROM creature_spawns WHERE entry BETWEEN 30030 AND 30050;
DELETE FROM creature_proto WHERE entry BETWEEN 30030 AND 30050;
DELETE FROM trainer_spells WHERE entry BETWEEN 30030 AND 30050;
DELETE FROM trainer_defs WHERE entry BETWEEN 30030 AND 30050;
Already add this cleanup at new version of Global Trainer version 1.1!!!



Tq very much lilaug2:D
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0;
doesn't work it says it's already there

[ubbadd]

But WHER shall i put the code?
Creature_proto > ??? table: creature_proto or Query*?

[jordenlewis]

Hi i need help i keep getting this error when i execute it

[Err] 1065 - Query was empty
[Err] ;

[Touch]

i got this errore QQ

[Err] 1146 - Table 'world.creature_names' doesn't exist
[Err] DELETE FROM creature_names WHERE entry BETWEEN 30030 AND 30051;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[kassrt]

This is the error I get when I try to add the full gmi vendor:

Query:
insert into `creature_proto` values('50080','70','70','35','10000','10000','100 0','1','4225','100','0','1000','1001','0','0','0', '0','0','0','0','0','0','0','0','0','0','500','121 2','0','0','0','0','0','0','1.5','0.208','0','0',' 0','0','0','2.5','8','14','0','0','0','0','0','0', '0')

Error occured at:2011-02-21 21:38:11
Line no.:102
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
insert into `creature_proto` values('50080','70','70','35','10000','10000','100 0','1','4225','100','0','1000','1001','0','0','0', '0','0','0','0','0','0','0','0','0','0','500','121 2','0','0','0','0','0','0','1.5','0.208','0','0',' 0','0','0','2.5','8','14','0','0','0','0','0','0', '0')

Error occured at:2011-02-21 21:38:53
Line no.:102
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_proto` VALUES ('30040', '100', '100', '1741', '1000000', '1000000', '1000000', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:39:00
Line no.:14
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:40:34
Line no.:200
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:43:53
Line no.:1
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:44:00
Line no.:1
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:44:23
Line no.:200
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:44:26
Line no.:200
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:45:56
Line no.:15
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:47:55
Line no.:1
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:48:03
Line no.:1
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:48:22
Line no.:1
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
INSERT INTO `creature_names` VALUES ('30052', 'Global GM Trainer', '', '', '16', '4', '0', '3', '0', null, '23195', '0', '0', '0', '1', '1', '0', null)

Error occured at:2011-02-21 21:48:28
Line no.:11
Error Code: 1062 - Duplicate entry '30052' for key 1

Query:
INSERT INTO `creature_names` VALUES ('30052', 'Global GM Trainer', '', '', '16', '4', '0', '3', '0', null, '23195', '0', '0', '0', '1', '1', '0', null)

Error occured at:2011-02-21 21:48:32
Line no.:11
Error Code: 1062 - Duplicate entry '30052' for key 1

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:49:07
Line no.:1
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:49:21
Line no.:201
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:57:47
Line no.:201
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:58:32
Line no.:201
Error Code: 1136 - Column count doesn't match value count at row 1


wat to do?..

[alikianos94]

Ew well how can i update my db ?
My db version is Whydb rev. 126

[Nickelo]

This is waaaaayy old
the errors your getting is because it doesnt match the DB you have... Basically this is outdated