• 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!

Level Loss

Sort by date Sort by votes
You need to execute some code in your sql box if you want to edit all players loss. I'm certain there are similar scripts on Otland you easily can modify.

Something like this should probably work

replace LEVELLOSS with the correct text the database is using and the number to whatever playerloss you want ppl too have, then edit
Leveloss2 to the same you put on LEVELLOSS and check a character too see what leveloss all player have and replace the number there aswell.

Not tested and i want a verification that this works so don't try it unless someone aproves it too work or you might mess something up..

UPDATE players SET LEVELLOSS= 1 WHERE Leveloss2= 2

//Massen
 
Upvote 0 Downvote
Code: 
BEGIN
   UPDATE `players` SET LEVELLOSS= 1 WHERE Leveloss2= 2;
END

I'm newbie in database, I don't know make codes and I don't know add codes to database.
 
Upvote 0 Downvote
Aight i searched for you, this should work (credits too Cykotitan)

Code: 
UPDATE `players`
 SET
 `loss_experience` = '10',
 `loss_mana` = '10',
 `loss_skills` = '10',
 `loss_items` = '10'

In phpmyadmin you press your database(the place all your characters accounts etc are saved), then press sql(also called query window) above the dropdownlist, a new window will popup where you can write. Paste the code above and press "GO".

Should work =)

//Massen
 
Upvote 0 Downvote
Massen said:
Aight i searched for you, this should work (credits too Cykotitan)

Code: 
UPDATE `players`
 SET
 `loss_experience` = '10',
 `loss_mana` = '10',
 `loss_skills` = '10',
 `loss_items` = '10'
In phpmyadmin you press your database(the place all your characters accounts etc are saved), then press sql(also called query window) above the dropdownlist, a new window will popup where you can write. Paste the code above and press "GO".

Should work =)

//Massen
Click to expand...

You forgot the ";" :p

Code: 
UPDATE `players` SET `loss_experience` = '10', `loss_mana` = '10', `loss_skills` = '10', `loss_items` = '10';
 
Upvote 0 Downvote
After:
Code: 
DROP TABLE IF EXISTS `server_config`;
I can add:
Code: 
UPDATE `players` SET `loss_experience` = '10', `loss_mana` = '10', `loss_skills` = '10', `loss_items` = '10';
??
 
Upvote 0 Downvote
You first select your server database and then click in here:

25012009230524ue8.png
 
Upvote 0 Downvote
Back
Top