HOW TO: Make characters start with riding skill and mount

[mastermania]

Heres a quick guide on how to make a character when created start with a mount for this where going to say the raptor from Zul'Gurub and how to add the spell note: I am not sure if riding skill would be considered under skill but seems to work on spell in db.

First:
INSERT INTO playercreateinfo_items ('indexid', 'protoid', 'slotid', 'amount'); values

is a base of what where going to add so it will look like this

INSERT INTO `playercreateinfo_items` values ('1', '19872', '23', '1');
INSERT INTO `playercreateinfo_items` values ('2', '19872', '23', '1');
INSERT INTO `playercreateinfo_items` values ('3', '19872', '23', '1');
INSERT INTO `playercreateinfo_items` values ('4', '19872', '23', '1');
INSERT INTO `playercreateinfo_items` values ('5', '19872', '23', '1');
INSERT INTO `playercreateinfo_items` values ('6', '19872', '23', '1');
INSERT INTO `playercreateinfo_items` values ('7', '19872', '23', '1');
INSERT INTO `playercreateinfo_items` values ('8', '19872', '23', '1');
INSERT INTO `playercreateinfo_items` values ('9', '19872', '23', '1');
INSERT INTO `playercreateinfo_items` values ('11', '19872', '23', '1');
INSERT INTO `playercreateinfo_items` values ('65', '19872', '23', '1');

INSERT INTO `playercreateinfo_spells` values ('1', '33392');
INSERT INTO `playercreateinfo_spells` values ('2', '33392');
INSERT INTO `playercreateinfo_spells` values ('3', '33392');
INSERT INTO `playercreateinfo_spells` values ('4', '33392');
INSERT INTO `playercreateinfo_spells` values ('5', '33392');
INSERT INTO `playercreateinfo_spells` values ('6', '33392');
INSERT INTO `playercreateinfo_spells` values ('7', '33392');
INSERT INTO `playercreateinfo_spells` values ('8', '33392');
INSERT INTO `playercreateinfo_spells` values ('9', '33392');
INSERT INTO `playercreateinfo_spells` values ('11', '33392');
INSERT INTO `playercreateinfo_spells` values ('65', '33392');

19872 is the item id for them mount so if you want to change the mount then wowhead.com search a mount you want and change that and 33392 is the spell id for epic ground mounts below are the other spell ids for ground mounts etc.

Ground 60 percent: 33389
60 percent flyer: 34092
Epic flyer: 34093

To insert this copy the INSERT INTO stuff and put it into note pad then save it as a .sql and insert into your db.

Feel free to ask questions and hope it works for you all.

[tmag]

good one ,
BTY we need to Execute this file in Navicat or just insert them ?
+REP for ya

[VictoRo]

Yes, you need copy+paste the text above into notepad and do "save as.." and then call it w/e "lol.sql" fx. And then execute in Navicat, Sqlyog or whatever ^^