Error when creating account through phpmyadmin

[Lara23]

I'm trying to play offline just to have some fun but I'm having a problem setting up accounts. I opened a local server and everything seems to be running smoothly however I can't log in in any of the existing accounts. I also tried to create a new one but I failed miserably. The following screenshot is from the current state of my database account. It is supposed to work when I try 1/1 or GOD/2 right? Or Nah? Maybe I'm missing something due to my lack of knowledge.
It would mean the world if someone gives me some help, I just wanna play something that puts a smile on my face when I'm off work. Thanks in advance.

 

[Discovery]

Hello @Lara23 .

Well, for default all servers are sha1 encoding. (TFS 1.x + and some 0.4 versions)

You need generated sha1 key in a query, like:

INSERT INTO accounts (name,password) VALUES ('YOUR_ACCOUNT_NAME',SHA1('YOUR_PASSWORD'));

If your mysql version dont have support to sha1 inside queries, use a generator like: SHA1 online (http://www.sha1-online.com/)

A example for a generate value:
Key: 123456
Sha1 key: 7c4a8d09ca3762af61e59520943dc26494f8941b

In the final will be result like this:

INSERT INTO accounts (name,password) VALUES ('1','7c4a8d09ca3762af61e59520943dc26494f8941b');

Account: 1
Password: 123456

You can run a query in phpmyadmin, clicking in SQL (menu on top).

All websites have a sha1 inside the account creators .php files. You can use them too.

Enjoy!

 

[Lara23]

Hello @Lara23 .

Well, for default all servers are sha1 encoding. (TFS 1.x + and some 0.4 versions)

You need generated sha1 key in a query, like:

INSERT INTO accounts (name,password) VALUES ('YOUR_ACCOUNT_NAME',SHA1('YOUR_PASSWORD'));

If your mysql version dont have support to sha1 inside queries, use a generator like: SHA1 online (http://www.sha1-online.com/)

A example for a generate value:
Key: 123456
Sha1 key: 7c4a8d09ca3762af61e59520943dc26494f8941b

In the final will be result like this:

INSERT INTO accounts (name,password) VALUES ('1','7c4a8d09ca3762af61e59520943dc26494f8941b');

Account: 1
Password: 123456

You can run a query in phpmyadmin, clicking in SQL (menu on top).

All websites have a sha1 inside the account creators .php files. You can use them too.

Enjoy!

I would never expect such a detailed answer, glad to have a person like you contributing to this community, cheers for that!
I not only was able to create an account with the code you provided but I also learnt how to do it myself, thanks!
Hmmm, if you dare me asking, now that I created an account, how do I create a character nested in this account?

 

[Discovery]

@Lara23
I recommend you to use a website like Znote, MyAAC to create accounts and characters.

Because if you create a character using your phpmyadmin probabily will forget some important columns to insert values.

A character table have a lot of columns if you forget insert a value(not default) probably will returns a error when you tried to login.
Like: Your town id not exist or something like that.

Every TFS version have your own default style, for example: TFS 1.x have your player_skills inside players table and another changes for example.

INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `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`, `deleted`)
VALUES
(NULL, 'Gamemaster', '3', 'YOUR_ACCOUNT_ID', '2', '1', '155', '155', '100', '0', '0', '0', '0', '136', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '10', '0', '10', '0', '10', '0', '10', '0', '10', '0', '10', '0', '10', '0', '0');

Replace YOUR_ACCOUNT_ID for your accounts > id column number in your respective account.

 

[Lara23]

@Lara23
I recommend you to use a website like Znote, MyAAC to create accounts and characters.

Because if you create a character using your phpmyadmin probabily will forget some important columns to insert values.

A character table have a lot of columns if you forget insert a value(not default) probably will returns a error when you tried to login.
Like: Your town id not exist or something like that.

Every TFS version have your own default style, for example: TFS 1.x have your player_skills inside players table and another changes for example.

INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `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`, `deleted`)
VALUES
(NULL, 'Gamemaster', '3', 'YOUR_ACCOUNT_ID', '2', '1', '155', '155', '100', '0', '0', '0', '0', '136', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '10', '0', '10', '0', '10', '0', '10', '0', '10', '0', '10', '0', '10', '0', '0');

Replace YOUR_ACCOUNT_ID for your accounts > id column number in your respective account.

That makes total sense and is for sure the best practice.
I appreciate all the time you invested to kindly help a stranger, let me know if I can return your kindness.

Is there any "tutorial" that would update my knowledge about open tibia in general? Back in my days, all servers would come with an executable file, pretty much ready to play, for example. Nowadays you have to compile it all and I have no idea why. Maybe I should take a step back and learn how things work nowadays. If you have any book or website in mind, would be way better than throwing random questions at you!
Once again, thank you SO much for helping me out. You're the MVP.

 

[Discovery]

That makes total sense and is for sure the best practice.
I appreciate all the time you invested to kindly help a stranger, let me know if I can return your kindness.

Is there any "tutorial" that would update my knowledge about open tibia in general? Back in my days, all servers would come with an executable file, pretty much ready to play, for example. Nowadays you have to compile it all and I have no idea why. Maybe I should take a step back and learn how things work nowadays. If you have any book or website in mind, would be way better than throwing random questions at you!
Once again, thank you SO much for helping me out. You're the MVP.

You're welcome.

Check the pin threads in that category:
Programming & Scripting (https://otland.net/forums/programming-scripting.481/)