• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

Linux Bug with Command Phpmyadmin and Rank

V

Vrotz

Member
Joined
Apr 7, 2011
Messages
1,071
Reaction score
7
Location
Brazil
Hello,

Today I was reset the skills, levels, ML's & storages of my server. I clear the table of skills, storages and execute that command:

PHP: 
UPDATE `players` SET `level` = 8, `experience` = 4200, `health` = 185, `healthmax` = 185, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `cap` = 470;

N' my server are configured to start with some skills. When the paladins or knights DEAD (were created before running the command in database) they lost ALL skills and back to 10. (New characters dont lose the skills when dead). No have error in console when this happen'.

Why this happen'? I do something wrong?

Need a help!
 
Last edited:
Sort by date Sort by votes
Vrotz said:
Hello,

Today I was reset the skills, levels, ML's & storages of my server. I clear the table of skills, storages and execute that command:

PHP: 
UPDATE `players` SET `level` = 8, `experience` = 4200, `health` = 185, `healthmax` = 185, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `cap` = 470;

N' my server are configured to start with some skills. When the paladins or knights DEAD (were created before running the command in database) they lost ALL skills and back to 10. (New characters dont lose the skills when dead). No have error in console when this happen'.

Why this happen'? I do something wrong?

Need a help!
Click to expand...

you answered on your own problem
 
Upvote 0 Downvote
Vrotz said:
Hello,

Today I was reset the skills, levels, ML's & storages of my server. I clear the table of skills, storages and execute that command:
Click to expand...
You messed it up yourself, you never got a response for a "solution" because there is none.
You really need to be careful when you edit the database especially on a live server, in the future before you make any changes to anything ALWAYS make a backup 1st this way when you mess something up you can install the backup and continue on as if nothing went wrong in the 1st place.
 
Upvote 0 Downvote
Breed said:
You messed it up yourself, you never got a response for a "solution" because there is none.
You really need to be careful when you edit the database especially on a live server, in the future before you make any changes to anything ALWAYS make a backup 1st this way when you mess something up you can install the backup and continue on as if nothing went wrong in the 1st place.
Click to expand...

Okay, thanks for your orientation. So why I messed up? Can you explain me better?
 
Upvote 0 Downvote
Back
Top