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

How i can create new acc and char in MySQL base

ksarek

New Member
Joined
Jan 7, 2009
Messages
6
Reaction score
1
Hello guys, let me ask you 1 more newbie question.
I have Ubuntu-server with TFS1.2? workable MySQL database and correct scheme.
I would like to understand mechanism of new accs and characters creation by sql-queries.
Just studied sql structure and manually add new items in tables:
for table accounts:
INSERT INTO 'accounts' (name,password,email) VALUES ('555444','qwerty','[email protected]')
other fields like type,premdays,lastday,creation etc were signed automatically

Next step is query for 'players' table:
INSERT INTO 'players' (name,account_id) VALUES ('Ksarek',1)
other fields like level,vocation,.. signed automativ=cally too

Now its looks correct and rdy for working, but i still cant login on my OT.
Could you show me mistake? What is missing?
 
Back
Top