• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

deathplayer i dont know

Z

ziomek14b

New Member
Joined
Dec 26, 2007
Messages
98
Reaction score
0
hi i have created character and now when i create an monster by god and when im going out of pz with my 9 lvl the monster is killing me and the level is not going down why??
 
Sort by date Sort by votes
Crap.. i forgot MySql sytanx.. again.. sec i might remember.

Code: 
UPDATE players SET loss_experience = 5, loss_mana = 5, loss_skills = 5 WHERE level > 249



edit: I spelled wrong... fixed now.
 
Last edited:
Upvote 0 Downvote
M4t30 said:
Crap.. i forgot MySql sytanx.. again.. sec i might remember.

Code: 
UPDATE players SET loss_experience = 5, loss_mana = 5, loss_skils = 5 WHERE level > 249
Click to expand...


i tried to put it and look

Error
SQL query:

UPDATE players SET loss_experience =5,
loss_mana =5,
loss_skils =5 WHERE LEVEL >249

MySQL said:

#1054 - Unknown column 'loss_skils' in 'field list'
Click to expand...
i have added photo my db look like this now
 
Last edited:
Upvote 0 Downvote
M4t30 said:
Crap.. i forgot MySql sytanx.. again.. sec i might remember.

Code: 
UPDATE players SET loss_experience = 5, loss_mana = 5, loss_skills = 5 WHERE level > 249



edit: I spelled wrong... fixed now.
Click to expand...

M4t30 said:
Make sure that server is offline.
Click to expand...

but i have already update the db and its the same thing i dont know ;/ when the player dies he dont lose any items and skills lvl


have a look on pictures i posted on 1 page you can see in loss_~~ tables its says 0 does it mean anything?
 
Upvote 0 Downvote
Back
Top