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

Windows MySql

Pro Warbringer

Retired with developing
Joined
Sep 23, 2008
Messages
3,582
Reaction score
25
Location
Austria
Well im making a lil' war server and i dont know how to make the accounts in MySql actuelly i forgot how to do it.
Any help? And btw. how to create char's there? ;o
 
Tried use the search function on how to "install" a war server or something? :P I got no experience of making a war server so it was just a suggestion since I can't help you -.-
 
Tried use the search function on how to "install" a war server or something? :P I got no experience of making a war server so it was just a suggestion since I can't help you -.-

So why even bother i used the search function and i didn't find anything what could help me.
 
pre-made characters? make the characters then press on file .db and make it read-only :p

There are currently no character's on the server im using 7.6 Avesta .
Could u make me an little tutorial?

tried everything cant get it working HELP!
 
Last edited by a moderator:
Ehh...
Go to localhost/phpmyadmin -> your database -> accounts.
Press 'Add', near 'Structure', 'Export' and other buttons.
Fill in the fields, press Submit/Execute.

Now go to localhost/phpmyadmin -> your database -> players.
Press 'Add' once again.
Fill in characters info, select account_id you previously made, press Submit/Execute.

If you want to edit certain characters skills, take its ID and go to player_skill table, press 'Browse' and find skills with player_id same as ID.

You can alwats update it with SQL query:
PHP:
UPDATE player_skills SET value = SKILL_LEVEL, WHERE player_id = PLAYER_ID AND skill_id = SKILL_ID;

Dont really remember if it was value, nor skill_id. Just press 'Strucutre' and you will know what are the right names.
 
Back
Top