[RELEASE] Full Global Trainer v4.0

[zeal_aiz]

HOT RELEASE!!!
Full Global Trainer v4.0 is here!! Now it easier to train spells no need traveling all in one trainer!!

Full Global Trainer v4.1 (Release 27 Dec 2008)
- Compatibility with ArcEmu rev 1913 or latest. Now also support AspireCore HS branch rev 670 or latest:D!!
- WotLK class spell (DK and others)
- WotLK profession (Insciption and other)
- Lot of other WotLK spells (Cold Weather Riding and lots more)
- Easy to install include Readme
- Add install and remove feature
- Can be execute many time
- Thousand of cleanup
- Thousand of addition
- Thousand of fix and editing
- Clean sql base make it easier for editing and adding item in future
- Contain 7 trainer which train 8000+ TBC & WOTLK spells
- Trainer List:
-ID- -TRAINER-
70000 - Global Melee Trainer: Hunter, Paladin, Rogue, Shaman, Warrior & Death Knight -WOTLK-
70001 - Global Spell Caster Trainer: Mage, Priest, Warlock & Druid -WOTLK-
70002 - Global Weapon Trainer -TBC-
70003 - Global Riding Trainer -TBC- -WOTLK-
70004 - Global GM Trainer -TBC-
70005 - Global Buff Trainer -TBC-
70006 - Global Professions Trainer I -TBC- -WOTLK-
70007 - Global Professions Trainer II -TBC- -WOTLK-
70008 - Global Secondary Skills Trainer -TBC- -WOTLK-

Here Download Link
Full Global Trainer v4.1 ArcEmu - HERE (http://filebeam.com/1958f85bc902824186f646d381be1316)
Full Global Trainer v4.1 AspireCore - HERE (http://filebeam.com/c5c0445d3b67d7126e9da4a550855d05)
PASSWORD:zeal

I'll update this trainer time to time!! Hope u all like it:D
I already test it with NCDB rev46. It should work flawless. If any prob occure let me know.
Repack maker feel free to use this mall vendor but don't forget mention credit:P
Please keep reply on this post, keep this post bump for easier for me to update in future;) U can post suggestion, adding spell, missing spell, bug etc

More to come!!
GMI Mall Vendor Spawn v4.0
- Support ArcEmu and AspireCore latest revision
- I'll make sql query for spawning Full GMI Mall Vendor v4.0 and Full Global Trainer v4.0 at location you want!
- Atm i will spawn this at GM Island. Suggestion here in this thread for another location.
- Make this mall vendor and trainer fully spawn neatly.
- Add enable and disable spawn feature
- Progress: Not started yet gonna rest a while;)

Check Full GMI Mall Vendor v4.0 (http://www.ac-web.org/forum/releases/42066-release-full-gmi-vendor-mall-v4-0-a.html)!! U may find this usefull too!!

CREDIT
- Me, zeal_aiz

[PaikProductions]

+rep +rep +rep!!! mate well done!!!! this is epic! thx!

[faddix]

realy epic!!!
+rep...

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

[zeal_aiz]

TQ faddix and Paik Productions:D TQ everyone. Let me know if I miss anything in trainer. So tiring gonna rest a while -_-

[faddix]

hmm...i found a problem with 70006 - Global Professions Trainer,
whenever i click on him my game/client stop responding, can't even Logout/Exit from game???

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

[PaikProductions]

zeal_aiz got msn or something?

[mako1]

SQL Error: Column count doesn't match value count at row 1 */

[faddix]

I edited your Global Professions Trainer for my server and
make separated 11 trainers for each profession, now they are working fine :) ...

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

[xwielder]

+Rep

[LS12]

This is easy to do! but still +rep for the effort

[mako1]

SQL Error: Column count doesn't match value count at row 1 */ for the "trainer_defs" table anyone know why? seems to work for everyone else :S

[LS12]

What DB do you use?

[faddix]

SQL Error: Column count doesn't match value count at row 1 */ for the "trainer_defs" table anyone know why? seems to work for everyone else :S

you are using old database...
in ArcEmu_rev1902 they have update to the world DB...
so update your core and DB with this:

alter table `trainer_defs` add column `RequiredRace` int DEFAULT '0' NOT NULL after `req_class`;
alter table `trainer_defs` add column `RequiredReputation` int DEFAULT '0' NOT NULL after `RequiredRace`;
alter table `trainer_defs` add column `RequiredReputationValue` int DEFAULT '0' NOT NULL after `RequiredReputation`;

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

[zeal_aiz]

hmm...i found a problem with 70006 - Global Professions Trainer,
whenever i click on him my game/client stop responding, can't even Logout/Exit from game???

---------------------------------------------------------------------
My stupid mistake. I should put 1000+ spell in one trainer. I already seperate it into two now it should work. Sorry for my mistake;)

zeal_aiz got msn or something?
I had ym zeal_aiz@yahoo.com.my. Mg GMT 8+ make sure i'm not sleep at that time lol

SQL Error: Column count doesn't match value count at row 1 */
What emu did u use ArcEmu or Aspire? What revision?

+Rep
Thx dude:D

This is easy to do! but still +rep for the effort
Thx for rep:D Actually, its not that easy. I had to search many spells at Alakazam, Thotboot, Wowhead. Make npc need to create creature name and creature proto. To make it trainer need to create trainer definition and trainer spells. There is 8000++ spells so it is tiring and I work on this Global trainer from scratch. Then I write the sql neatly so as u can see my sql is easy to read and easy to edit or adding. Unless u copy and paste others work.:p No offense dude

Btw i notice i miss few other spell for enchanting and alchemy in global profession trainer. I'll work on it tomorrow. Feel free to report bug or any missing spells. TQ faddix for bug reporting.

[PaikProductions]

zeal_aiz please look at PM or come online on msn :D need to talk with you.

[LS12]

Thx for rep Actually, its not that easy. I had to search many spells at Alakazam, Thotboot, Wowhead. Make npc need to create creature name and creature proto. To make it trainer need to create trainer definition and trainer spells. There is 8000++ spells so it is tiring and I work on this Global trainer from scratch. Then I write the sql neatly so as u can see my sql is easy to read and easy to edit or adding. Unless u copy and paste others work. No offense dude

Btw i notice i miss few other spell for enchanting and alchemy in global profession trainer. I'll work on it tomorrow. Feel free to report bug or any missing spells. TQ faddix for bug reporting.

Well I dont copy other works! But I did a portable vendor item and the item only needed the spell id then i did a NPC so the item could summon it!
So.. the item needed the spell id and the spell needed the NPCs id to summon the npc

[mako1]

you are using old database...
in ArcEmu_rev1902 they have update to the world DB...
so update your core and DB with this:

alter table `trainer_defs` add column `RequiredRace` int DEFAULT '0' NOT NULL after `req_class`;
alter table `trainer_defs` add column `RequiredReputation` int DEFAULT '0' NOT NULL after `RequiredRace`;
alter table `trainer_defs` add column `RequiredReputationValue` int DEFAULT '0' NOT NULL after `RequiredReputation`;

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

Thanks :D

Also the warrior trainer is missing the stances :(

[prank]

Zeal password diffrent for Aspire trainers ?

Anyways like usual, good releases.. +rep

[knaur]

nice onces, but one small problem, alot of the profession trainers miss the start train itself to learn it :/

[Chrisd2k6]

Password Incorrect!

[kinghaigy]

i was training hunter, and there were no spells over lvl 70.. Ill try another class, but thats something you should look into

Other than that - This is totaly awesome!
Thanks!

EDIT: No classes have spells over lvl 70 - could that be because im flagged for BC? i dont have WOTLK - but that shouldnt matter - all those spells are in my game anyway.

Also you may want to take a look at the riding trainer... He has multiples of things to train and is missing Master training.

EDIT: Warriors are missing some earlier spells (like rank 1's) and cant learn the later ones, and they have no stances

[tuve2]

1337

[XXXJOGIXXX]

Full Global Trainer v4.1 AspireCore
Filebeam - Free Fast File Hosting (http://filebeam.com/c5c0445d3b67d7126e9da4a550855d05)
This File is Password Protected. Please Enter the Download Password.
PASSWORD:zeal dont work :mad: pls up it new or say Password pls ;)
ps thx for your work

[Thelordofsummoon]

E-P-I-C release! +rep, thanks for your job!

[Thelordofsummoon]

I found a little bug: the global spell trainer teaches felsteed to every class.

[Hurkulez]

zeal_aiz,

U Rock +REP+

Can you do one for Mangos?

+REP Again when I can...

[XXXJOGIXXX]

Full Global Trainer v4.1 AspireCore
Filebeam - Free Fast File Hosting
This File is Password Protected. Please Enter the Download Password.
PASSWORD:zeal dont work pls up it new or say Password pls
ps thx for your work
pls upload it again with right passwort

[kinghaigy]

I found a little bug: the global spell trainer teaches felsteed to every class.

I noticed that. Not a huge problem. But oh well. Bigger problems are warriors missing their stances, aswell as other low level moves like charge. Other than that, these trainers are great. Oh and you need to add the first rank of enchanting

[birdofdeath]

+rep

[me.name]

Full Global Trainer v4.1 AspireCore

The password for the Aspire version is:

zeal_aiz

[DragonOfIce]

Hey From sounds of it, It's pretty awesome. I just need a little help as to where I put it. I am trying to put them into me WotLK server. Here is a screen-shot of my HediSql. Message Me if you know how to fix it.


http://i549.photobucket.com/albums/ii373/Rs_Living_Legend/JesseAkACheak05/error.jpg

[faddix]

Hey From sounds of it, It's pretty awesome. I just need a little help as to where I put it. I am trying to put them into me WotLK server. Here is a screen-shot of my HediSql. Message Me if you know how to fix it.

you are makeing 2 mistakes:
1. you are using MANGOS, this is for ArcEmu/Aspire
2. you are trying to import to character DB, instead in world DB

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

[yknuf]

Not found! trainers

[kiwimonster]

it freezes when ever i run the SQL??

[Zenro45]

half the spells are missing what is that all about?

[mozdi]

Please helmp me im crying out for some help
im using ac-web repack 8.0 original non modified wen i start installing your vendors the mall vendors going explode and casting stupid game effects pls help me to fix if thanks and my respect is yours....

[callep]

seal u got msn or something?:D

[T4PO]

Nice work, I also Love the Vendors