[Trinity SQL] Players start with riding skills

[Synth]

Hello Emudevs,today i'm going to release a simple query that will make players start with riding skills,its made by me.

SQL info:
●Players start with riding skills on login.
NOTE:I make 2 way of SQL's one for least rev and the other if you are using all races and all classes and you have an old DB.

SQL:​

-- Player Start with Riding Skills (Least Rev)
INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
(0, 0, 33389, 'Apprentice Riding'),
(0, 0, 33392, 'Journeyman Riding'),
(0, 0, 34092, 'Expert Riding'),
(0, 0, 34093, 'Artisan Riding'),
(0, 0, 54198, 'Cold Weather Flying');

-- Player Start with Riding Skills (Old Rev)
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
(0, 0, 33389, 'Apprentice Riding'),
(0, 0, 33392, 'Journeyman Riding'),
(0, 0, 34092, 'Expert Riding'),
(0, 0, 34093, 'Artisan Riding'),
(0, 0, 54198, 'Cold Weather Flying');

If you have any question feel free to ask me.

Thank you!
Best regards,
Synth !

 

[Tommy]

Awesome, thanks for the release!

 

[Synth]

Awesome, thanks for the release!

Haha no problem man.

 

[Black Ace]

Thank you

 

[Synth]

Thank you

No problem :smile:

 

[Zulku]

Thanks

 

[Rochet2]

Since the DB uses default values, you should be able to make a version that works for both

INSERT INTO `playercreateinfo_spell` (`Spell`, `Note`) VALUES
(33389, 'Apprentice Riding'),
(33392, 'Journeyman Riding'),
(34092, 'Expert Riding'),
(34093, 'Artisan Riding'),
(54198, 'Cold Weather Flying');

 

[Synth]

Since the DB uses default values, you should be able to make a version that works for both

INSERT INTO `playercreateinfo_spell` (`Spell`, `Note`) VALUES
(33389, 'Apprentice Riding'),
(33392, 'Journeyman Riding'),
(34092, 'Expert Riding'),
(34093, 'Artisan Riding'),
(54198, 'Cold Weather Flying');

Ahh thank you :fuckthathshit:

 

[Synth]

Thanks

No problem :smile: