[Release] Master First Aid Trainer! SQL

[svedin]

Information
I have made a "Master First Aid" that summarize all the Bandage and Anti-Venom.

So no more books and no quests to get 450 in First Aid.
(The Tent and the other stuffs if from my mall that i'm working on to release)

Tested with ArcEmu_rev.2003
*************************

Screen Shot



And so the Sqls:

/*---------------------------------------------------------*/;
/*------- Sql mabe by Svedin  -----------------------------*/;
/*------- This will not be removed from the script --------*/;
/*---------------------------------------------------------*/;

delete from trainer_spells where entry = '930812';

/*First aid*/;
insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (930812,0,3273,1000,0,0,0,12,0,0), (930812,0,3275,1000,3273,0,0,12,0,0), (930812,0,3276,1000,3275,50,0,12,0,0), (930812,0,3274,1000,3276,50,0,12,0,0), (930812,0,3277,1000,3276,80,0,12,0,0), (930812,0,3278,1000,3277,115,0,12,0,0), (930812,0,7928,1000,3278,150,0,12,0,0), (930812,0,7924,1000,7928,150,0,12,0,0), (930812,0,7929,1000,7924,180,0,12,0,0), (930812,0,10840,1000,7929,210,0,12,0,0),
(930812,0,10846,1000,7929,200,0,12,0,0), (930812,0,10841,1000,10846,240,0,12,0,0), (930812,0,18629,1000,10841,260,0,12,0,0), (930812,0,18630,1000,18629,290,0,12,0,0), (930812,0,27028,1000,18630,290,0,12,0,0), (930812,0,27032,1000,27028,330,0,12,0,0), (930812,0,45545,1000,27032,350,0,12,0,0), (930812,0,27033,1000,45542,360,0,12,0,0),
(930812,0,45542,1000,45545,350,0,12,0,0), (930812,0,45546,1000,45542,400,0,12,0,0), (930812,0,7934,1000,3273,80,0,12,0,0), (930812,0,7935,1000,7934,130,0,12,0,0), (930812,0,23787,1000,7935,300,0,12,0,0);

The second Sql:

/*---------------------------------------------------------*/;
/*------- Sql mabe by Svedin  -----------------------------*/;
/*------- This will not be removed from the script --------*/;
/*---------------------------------------------------------*/;
delete from trainer_defs where entry = '930812';

insert into trainer_defs (entry, required_skill, required_skillvalue, req_class, trainer_type, trainer_ui_window_message, can_train_gossip_textid, cannot_train_gossip_textid) values ('930812', '0', '0', '0', '0', 'Hello $N! Ready for some First Aid!', '0', '0');

The Npc:

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('930812', "Doc Quick", "Master Doctor", '', '0', '16', '0', '0', '0', '0', '6446', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('930812', '80', '80', '7', '6000', '6000', '1000', '1', '17', '1200', '0', '70', '1000', '0', '0', '0', '0', '3600', '700', '0', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

[defqonone]

Very nice I like

[Bunster]

Haha i likes +Rep if i cud

[svedin]

Thanks, i start to thought that no one like this one.. ^^

[Lilltimmy]

Nice, you named him well. Not like all the other NPC's out there, they're named like "LOL PROFFESION TRANER IIIVVVXX" xD +Rep x2.

[svedin]

Thanks Motivet262 =)

oh dear, 85 views and only 3 reply? Leechers?

[Lilltimmy]

Still you cannot beat my release... 2 comments and one said +Rep but i didnt gain any rep, and leeched 2000 Downloads...

[svedin]

haha Motivet262, no i can't beat that. but what did you think about the npc?

[heytoj]

thanks, svedin! this is just great!
btw, how do i spawn the tent and other stuff? plz answer.

[Lilltimmy]

Its great, and good for PvP Servers since First Aid is good in PVP + Arena.

[svedin]

The tents and other stuffs you need to add a sql file, but i dont have that one right now i maby upload it when i come home, thanks for the comments