⚔️ TFS 1.8 Downgrade 8.60 — Open Source Tibia Server Base

Kabo Flow · 2026-06-26T21:33:27+0200

PuszekLDZ said:
try this one with SSE2

Thanks, I love you, it worked.

Post automatically merged: Today at 21:34

Now I need a working OTClient or the Tibia 8.6 .DAT/.SPR files.

Post automatically merged: Today at 21:36

I'm asking a lot, I know—we finally got it running—but since I couldn't get it to work before, I've now lost the OTClient (along with its DAT/SPR files). Do you happen to have any data with an account—like a "God" account or just a player account—so I can test it?

PuszekLDZ · 2026-06-26T21:37:54+0200

Kabo Flow said:
Thanks, I love you, it worke

thanks to @Mateus Robeerto - i just compiled his files

try this client GitHub - Mateuzkl/AstraClient (https://github.com/Mateuzkl/AstraClient) with exe below

Post automatically merged: Today at 21:43

dat spr

Kabo Flow · 2026-06-26T21:43:47+0200

PuszekLDZ said:
thanks to @Mateus Robeerto - i just compiled his files

try this client GitHub - Mateuzkl/AstraClient (https://github.com/Mateuzkl/AstraClient) with exe below

Post automatically merged: Today at 21:43

dat spr

PuszekLDZ · 2026-06-26T21:48:04+0200

download this and in datathings are files

GitHub - Mateuzkl/Otcv8--Classic-8.6

Contribute to Mateuzkl/Otcv8--Classic-8.6 development by creating an account on GitHub.

github.com

Kabo Flow · 2026-06-26T21:50:51+0200

PuszekLDZ said:
download this and in datathings are files

GitHub - Mateuzkl/Otcv8--Classic-8.6

Contribute to Mateuzkl/Otcv8--Classic-8.6 development by creating an account on GitHub.

github.com

Now I just need a save file with the "God" account—or just one account I can use—to test and create some scripts for the community.

PuszekLDZ · 2026-06-26T21:51:41+0200

install myaac and You will get that account

Kabo Flow · 2026-06-26T21:53:22+0200

PuszekLDZ said:
install myaac and You will get that account

Don't you have one? schema.sql ... The thing is, like I said, my PC isn't that great—I've already installed XAMPP... I just need one. schema.sql .have accounts...

PuszekLDZ · 2026-06-26T22:00:57+0200

Kabo Flow said:
Don't you have one? schema.sql ... The thing is, like I said, my PC isn't that great—I've already installed XAMPP... I just need one. schema.sql .have accounts...

try
1234567 / tibia

Kabo Flow · 2026-06-26T22:11:39+0200

PuszekLDZ said:
install myaac and You will get that account

[2026-06-26 15:10:17.886] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
[2026-06-26 15:10:31.435] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
[2026-06-26 15:10:43.562] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
[2026-06-26 15:10:45.558] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
[2026-06-26 15:10:47.954] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'

Post automatically merged: Today at 22:12

PuszekLDZ said:
try
1234567 / tibia

Error

Análisis estático:

Se encontraron 2 errores durante el análisis.

Se esperaba un corchete de apertura seguido por un conjunto de valores. (near "CREATE" at position 785)
Símbolo (token) inesperado. (near "CREATE" at position 785)

consulta SQL: Copiar

-- -- Dumping data for table accounts -- INSERT INTO accounts (id, name, password, secret, type, premium_ends_at, email, key, created, rlname, location, country, web_lastlogin, web_flags, email_verified, email_new, email_new_time, email_code, email_next, premium_points, creation, tibia_coins, points_second, vote) VALUES (1, '1', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 1, 0, '', '', 0, '', '', '', 0, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 0), (2, '1234567', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 6, 1813444262, '[email protected]', '', 1782238563, '', '', 'us', 0, 3, 1, '', 0, '', 0, 0, 0, 5327, 0, 0), -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli account_bans -- CREATE TABLE account_bans ( account_id int(11) NOT NULL, reason varchar(255) NOT NULL, banned_at bigint(20) NOT NULL, expires_at bigint(20) NOT NULL, banned_by int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

MySQL ha dicho:

#1064 - Algo está equivocado en su sintax cerca 'CREATE TABLE account_bans (<br>  account_id int(11) NOT NULL,<br>  reason var...' en la linea 15

PuszekLDZ · 2026-06-26T22:14:02+0200

try to make a clean database, import server sql
and do

INSERT INTO accounts (id, name, password, secret, type, premium_ends_at, email, key, created, rlname, location, country, web_lastlogin, web_flags, email_verified, email_new, email_new_time, email_code, email_next, premium_points, creation, tibia_coins, points_second, vote) VALUES
(1, '1', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 1, 0, '', '', 0, '', '', '', 0, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 0),
(2, '1234567', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 6, 1813444262, '[email protected]', '', 1782238563, '', '', 'us', 0, 3, 1, '', 0, '', 0, 0, 0, 5327, 0, 0),

and

INSERT INTO players (id, name, group_id, account_id, level, reset, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, lookmount, currentmount, randomizemount, direction, maglevel, mana, manamax, manaspent, soul, town_id, posx, posy, posz, conditions, cap, sex, lastlogin, lastip, save, skull, skulltime, lastlogout, blessings, onlinetime, deletion, balance, task_hunting_points, bounty_points, soulseals_points, has_weekly_expansion, bonus_rerolls, charmpoints, protection_time, offlinetraining_time, offlinetraining_skill, stamina, xpboost_stamina, xpboost_value, 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, token_protected, token_hash, created, hide, comment, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8) VALUES
(1, 'Account Manager', 1, 1, 1, 0, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 1, 32069, 31901, 6, '', 400, 0, 1782324551, 16777343, 1, 0, 0, 1782324594, 0, 103, 0, 0, 0, 0, 0, 0, 0, 0, 10, 43200, -1, 2516, 0, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0),
(2, 'Crownots Master', 6, 2, 1, 0, 0, 100, 100, 0, 10, 10, 10, 10, 136, 0, 0, 2, 0, 3, 0, 100, 100, 0, 0, 1, 1023, 1024, 7, '', 0, 0, 1782501128, 16777343, 1, 0, 0, 1782501870, 0, 16580, 0, 0, 0, 0, 0, 1, 0, 0, 10, 43200, -1, 1040, 2640, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1782238563, 0, '', 1, 1, 1, 1, 1, 0, 0, 0),

Kabo Flow · 2026-06-26T22:17:57+0200

PuszekLDZ said:
try to make a clean database, import server sql
and do

INSERT INTO accounts (id, name, password, secret, type, premium_ends_at, email, key, created, rlname, location, country, web_lastlogin, web_flags, email_verified, email_new, email_new_time, email_code, email_next, premium_points, creation, tibia_coins, points_second, vote) VALUES
(1, '1', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 1, 0, '', '', 0, '', '', '', 0, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 0),
(2, '1234567', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 6, 1813444262, '[email protected]', '', 1782238563, '', '', 'us', 0, 3, 1, '', 0, '', 0, 0, 0, 5327, 0, 0),

and

INSERT INTO players (id, name, group_id, account_id, level, reset, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, lookmount, currentmount, randomizemount, direction, maglevel, mana, manamax, manaspent, soul, town_id, posx, posy, posz, conditions, cap, sex, lastlogin, lastip, save, skull, skulltime, lastlogout, blessings, onlinetime, deletion, balance, task_hunting_points, bounty_points, soulseals_points, has_weekly_expansion, bonus_rerolls, charmpoints, protection_time, offlinetraining_time, offlinetraining_skill, stamina, xpboost_stamina, xpboost_value, 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, token_protected, token_hash, created, hide, comment, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8) VALUES
(1, 'Account Manager', 1, 1, 1, 0, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 1, 32069, 31901, 6, '', 400, 0, 1782324551, 16777343, 1, 0, 0, 1782324594, 0, 103, 0, 0, 0, 0, 0, 0, 0, 0, 10, 43200, -1, 2516, 0, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0),
(2, 'Crownots Master', 6, 2, 1, 0, 0, 100, 100, 0, 10, 10, 10, 10, 136, 0, 0, 2, 0, 3, 0, 100, 100, 0, 0, 1, 1023, 1024, 7, '', 0, 0, 1782501128, 16777343, 1, 0, 0, 1782501870, 0, 16580, 0, 0, 0, 0, 0, 1, 0, 0, 10, 43200, -1, 1040, 2640, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1782238563, 0, '', 1, 1, 1, 1, 1, 0, 0, 0),

Error

Análisis estático:

Se encontraron 3 errores durante el análisis.

Se esperaba un corchete de apertura seguido por un conjunto de valores. (near "and" at position 583)
Símbolo (token) inesperado. (near "and" at position 583)
Tipo de declaración desconocida. (near "and" at position 583)

consulta SQL: Copiar

INSERT INTO accounts (id, name, password, secret, type, premium_ends_at, email, key, created, rlname, location, country, web_lastlogin, web_flags, email_verified, email_new, email_new_time, email_code, email_next, premium_points, creation, tibia_coins, points_second, vote) VALUES (1, '1', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 1, 0, '', '', 0, '', '', '', 0, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 0), (2, '1234567', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 6, 1813444262, '[email protected]', '', 1782238563, '', '', 'us', 0, 3, 1, '', 0, '', 0, 0, 0, 5327, 0, 0), and INSERT INTO players (id, name, group_id, account_id, level, reset, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, lookmount, currentmount, randomizemount, direction, maglevel, mana, manamax, manaspent, soul, town_id, posx, posy, posz, conditions, cap, sex, lastlogin, lastip, save, skull, skulltime, lastlogout, blessings, onlinetime, deletion, balance, task_hunting_points, bounty_points, soulseals_points, has_weekly_expansion, bonus_rerolls, charmpoints, protection_time, offlinetraining_time, offlinetraining_skill, stamina, xpboost_stamina, xpboost_value, 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, token_protected, token_hash, created, hide, comment, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8) VALUES (1, 'Account Manager', 1, 1, 1, 0, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 1, 32069, 31901, 6, '', 400, 0, 1782324551, 16777343, 1, 0, 0, 1782324594, 0, 103, 0, 0, 0, 0, 0, 0, 0, 0, 10, 43200, -1, 2516, 0, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0), (2, 'Crownots Master', 6, 2, 1, 0, 0, 100, 100, 0, 10, 10, 10, 10, 136, 0, 0, 2, 0, 3, 0, 100, 100, 0, 0, 1, 1023, 1024, 7, '', 0, 0, 1782501128, 16777343, 1, 0, 0, 1782501870, 0, 16580, 0, 0, 0, 0, 0, 1, 0, 0, 10, 43200, -1, 1040, 2640, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1782238563, 0, '', 1, 1, 1, 1, 1, 0, 0, 0),;

MySQL ha dicho:

#1064 - Algo está equivocado en su sintax cerca 'key, created, rlname, location, country, web_lastlogin, web_flags, email_veri...' en la linea 1

PuszekLDZ · 2026-06-26T22:20:25+0200

ok, so I dont kow what You expect
im compiling on i5 6th gen with 8GB ram for now - that server and otc exe files, running 2 test servers and xampp

so dont tell me Your comp is weak, just go and install myaac on clean database and run it for christ sake

Kabo Flow · 2026-06-26T22:22:11+0200

PuszekLDZ said:
ok, so I dont kow what You expect
im compiling on i5 6th gen with 8GB ram for now - that server and otc exe files, running 2 test servers and xampp

so dont tell me Your comp is weak, just go and install myaac on clean database and run it for christ sake

I already have MyAcc... but it won't let me log in... I'm getting this error.
[2026-06-26 15:21:49.340] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
[2026-06-26 15:21:54.351] [info] >> Database: opened MySQL connection #5.
[2026-06-26 15:21:54.354] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
[2026-06-26 15:21:59.370] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'

PuszekLDZ · 2026-06-26T22:22:59+0200

use clean install for that one - not used one for other servers

Kabo Flow · 2026-06-26T22:23:10+0200

PuszekLDZ · 2026-06-26T22:23:53+0200

can You download newest one? not that old one?
thats the problem i think

Kabo Flow · 2026-06-26T22:34:25+0200

PuszekLDZ said:
can You download newest one? not that old one?
thats the problem i think

I can't get myacc set up, let alone fix the error that's preventing me from logging in.

Post automatically merged: 45 minutes ago

It was a struggle, but thanks to Gemini, we got it done. AI is always helpful.

⚔️ TFS 1.8 Downgrade 8.60 — Open Source Tibia Server Base

Member

https://tibia74.eu

Attachments

Member

https://tibia74.eu

Member

https://tibia74.eu

Member

https://tibia74.eu

Attachments

Member

Error​

https://tibia74.eu

Member

Error​

https://tibia74.eu

Member

https://tibia74.eu

Member

https://tibia74.eu

Member

Similar threads

Error

Error