Account manager

[Pasiac]

Can someone help my to add account manager/player account to my tfs 1.1, I have never worked with database and my server dont have any account, so I cant test my scripts.

 

[Limos]

If it's just to test things, you can create an account with a query.
Account.

INSERT INTO `accounts`(`id`, `name`, `password`, `type`, `premdays`, `lastday`, `email`, `creation`) VALUES (1,1,1,5,100,0,'',0)

Character.

INSERT INTO `players`(`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`) VALUES (1,'GOD',3,1,2,1,1000,1000,100,114,0,116,114,140,3,20,1000,1000,100,100,1,95,117,7,'',1000,0,0,0,1,0,0,0,0,0,0,0,43200,-1,2520,10,0,10,0,10,0,10,0,10,0,10,0,10,0)

https://otland.net/threads/mysql-how-to-run-a-query.177833/
You have to change the password so it's sha1.
https://otland.net/threads/tfs-1-0-empty-database-manually-created-acc-still-cant-log-in.225633/