[SOLVED] How to increase mounts speed

[Synth]

Dear Emudevs,
So ye as title said i want to increase my mounts speed so example:
The item ID of this mound 46308,i want to increase his speed to 40% at level 10 and 100% at level 40.
So how can i modify them what should i change/edit/add?

Thank you!
Best regards,
Synth !!

 

[Synth]

Any idea?

 

[Jafferwaffer]

You could look in your database for & change the required level of the item.
You could also allow the training of apprentice riding to level 10. & its speed should change to 100% when Journeyman riding is learn @ level 40.

Sorry for the poor response, really busy at the moment, but this should point you in the right direction.

 

[Synth]

You could look in your database for & change the required level of the item.
You could also allow the training of apprentice riding to level 10. & its speed should change to 100% when Journeyman riding is learn @ level 40.

Sorry for the poor response, really busy at the moment, but this should point you in the right direction.

Ye i take a look in DB i changed the item level of the mount,the problem is changing the spell level for apprentice riding from 20 to 10 i try different way to edit the spell level but realy i didn't find any solution do you know where i can edit the spell level?
Apprentice Riding SpellID:33389
Also once i try to change it in db in npc_trainer table i go to search to npc ID i get the spellID with negative number but in the npc if you lookup for the spell they are in you find different IDs,so i can't change the spell level look what it show me once i search for it:
Image
Don't worry i really appreciate it !! Thank you !!

 

[cata123]

It's in spell.dbc. The amount of speed it's written there in percentage.

 

[Synth]

It's in spell.dbc. The amount of speed it's written there in percentage.

Ye i knw its in spell.dbc and i get the colum of ground speed i think its 81,just now the last problem changing the spell level.

 

[Synth]

So any idea?

 

[Synth]

Anyone?

 

[Foereaper]

So what you want to do is change when a player can learn a spell? Isn't this handled in the spell trainer table? By default, as soon as you can learn the spell you should be able to use any mount for that riding level. If you as a level 1 teach yourself journeyman riding, you should be able to use any journeyman level mounts as long as the item level is within your players level

 

[Synth]

So what you want to do is change when a player can learn a spell? Isn't this handled in the spell trainer table? By default, as soon as you can learn the spell you should be able to use any mount for that riding level. If you as a level 1 teach yourself journeyman riding, you should be able to use any journeyman level mounts as long as the item level is within your players level

No not this,i want exactly change spell level of Apprentice Riding from trainer for player can learn the spell on level 10 instead of 20,so my problem is changing the spell level look here:
Image
So as you see the Apprentice Riding requires level 20 to learn it i wana make it level 10 to make the player learn it.
I try different way to change it also i search in npc_trainer for Entry and the Spell ID of Apprentice riding i didn't found it so i run a query to find the npc with the spellids are in i get this Image II
and as you see ReqLevel is 0.
So i want to know how to change the spell level of Apprentice Riding i try also Spell.dbc i didn't found the colum of spell level also i search for something where is value 20 to replace it with 10 i didn't found it.
NPC ID: 4773
Spell ID (Apprentice Riding):33389
Thank you Foereaper for helping hope you can find any solution for me to slove my problem

 

[Vengeful]

You could look in your database for & change the required level of the item.
You could also allow the training of apprentice riding to level 10. & its speed should change to 100% when Journeyman riding is learn @ level 40.

Sorry for the poor response, really busy at the moment, but this should point you in the right direction.

^^

- - - Updated - - -

Also, try to post something on a diffrent forum if you haven't.
I see there isn't much activity going on here.

 

[Synth]

Any idea guys?

 

[Jafferwaffer]

Why not write a small LUA script which on level 10 teaches the riding to the player automatically and also gives the mount/spell.
Personally I would take this approach as its much easier imo.

 

[Tommy]

^^

- - - Updated - - -

Also, try to post something on a diffrent forum if you haven't.
I see there isn't much activity going on here.

Don't ever suggest that again. Read the rules, specifically Section: 1C, Rule #15.

If you haven't realized, EmuDevs is a place of support and we do not flood our threads with guesses, and we do not reply to most threads that we most likely do not have the answer for. We like to keep our threads clean and our solutions short (if possible). Members can come in and give support if they have knowledge of what the said member (OP) needs help with at ANYTIME. We do frown upon false answers. However, we encourage most answers that can potentially lead to a solution.

OP did receive some answers but they weren't what he was looking for, I honestly don't think there's any inactivity in that. In the world of emulation most issues can take more than a week to solve, given the subject is sensitive and OP is happy with their results. A solution sure as hell isn't dependent on <some other emulation site> that won't answer, people HERE will give the same answers on, members will troll or flood your thread with nonsense (beware of Treetree), etc..

Why not write a small LUA script which on level 10 teaches the riding to the player automatically and also gives the mount/spell.
Personally I would take this approach as its much easier imo.

Or C++ if he isn't using Eluna and accepts doing so.

 

[noc]

Avez-vous essayé ceci? Have you tried this?

SELECT * FROM `npc_trainer` WHERE spellid='33388';

For speed :

creature_template => speed_walk , speed_run

 

[Synth]

Don't ever suggest that again. Read the rules, specifically Section: 1C, Rule #15.

If you haven't realized, EmuDevs is a place of support and we do not flood our threads with guesses, and we do not reply to most threads that we most likely do not have the answer for. We like to keep our threads clean and our solutions short (if possible). Members can come in and give support if they have knowledge of what the said member (OP) needs help with at ANYTIME. We do frown upon false answers. However, we encourage most answers that can potentially lead to a solution.

OP did receive some answers but they weren't what he was looking for, I honestly don't think there's any inactivity in that. In the world of emulation most issues can take more than a week to solve, given the subject is sensitive and OP is happy with their results. A solution sure as hell isn't dependent on <some other emulation site> that won't answer, people HERE will give the same answers on, members will troll or flood your thread with nonsense (beware of Treetree), etc..



Or C++ if he isn't using Eluna and accepts doing so.

Well after i try and search for spell in DB finaly i found my solution,it doesn't want any Script to edit the spell level i just remove the -from the ID then i run this query:

REPLACE INTO `npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillLine`, `ReqSkillRank`, `ReqLevel`) VALUES (202010, 33388, 40000, 762, 0, 10);

,and finaly i go tested now it take effects to change spell level.
Thank you anyway for your support!
Its solved!