Quote:
Originally Posted by teh_rookie
Never tried this but the basic idea should work.
Make a trigger for the character information table or wherever the level of the character is stored.
In that trigger listen for an update on that table and check if the player level = 1,8,16,24,32,42,52,64,76.
If the player level = one of those and this is the first time the player hits that level (use another table which just contains a flag (bit) for each player to keep track of this) then insert the items into the players inventory table.
That is the basic idea of how to implement it. Just browse the database for the character information and inventory tables and if you know a little SQL this shouldn't be hard to accomplish.
|
Putting a trigger on _Char isn't the finest way available but it works - keep in mind that it'll be triggered everytime the table will be changed. Now count the changes per second on that table :)
The basic idea is pretty simple indeed, but you have to keep it flawless and performant, that's the point of the matter ^^
Quote:
Originally Posted by Phoenix 1337
Ask capip for it
|
My nickname is Caipi you azz ;(
Quote:
Originally Posted by AlphaNetwork
quests
|
Doing it with the help of a quest would be also a suitable way - "Dress me!"
______
And ye I'm not allowed to give any information out xD (But SQL ain't a challenge)