AAC Znote Acc Not Wroking With Nostalrius 7.7. need help to update Database

[Sp0tl3ss]

Hello im trying to use Znote acc for Nostalrius 7.7 (https://otland.net/threads/nostalrius-7-7.262406/), but im getting an error
"
string(92) "SELECT id, name, password, email, premdays FROM accounts WHERE id = 3 LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'name' in 'field list'"

Post automatically merged: Apr 22, 2021

Znote AAC
string(241) "SELECT account_id, name, level, group_id, vocation, health, healthmax, experience, mana, manamax, sex, lastlogin, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons FROM players WHERE id = 3;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'lookaddons' in 'field list'

 

[Ramirow]

You miss "premdays" column on the accounts table

 

[Saint Spear]

ALTER TABLE `accounts` ADD `name` int NOT NULL;
ALTER TABLE `accounts` ADD `premdays` int NOT NULL;

 

[Sp0tl3ss]

ALTER TABLE `accounts` ADD `name` int NOT NULL;
ALTER TABLE `accounts` ADD `premdays` int NOT NULL;

Gives me an error

SQL-fråga: Kopiera



ALTER TABLE accounts ADD name int NOT NULL



MySQL sa:

#1060 - Kolumnnamn 'name finns flera gånger
Kolumnnamn "name" exists several times.

Fixed this error, but it seems im missing alot of columns...


string(65) "SELECT id FROM accounts WHERE email='[email protected]';"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'email' in 'where clause'

Post automatically merged: Apr 22, 2021

You miss "premdays" column on the accounts table

yes it seems like i need to update several of the columns, i changed to Myaac instead but im still getting errors from columns
"
SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value


Backtrace:

#0 C:\UniServerZ\www\system\libs\pot\OTS_Account.php(140): PDO->exec()
#1 C:\UniServerZ\www\install\steps\7-finish.php(60): OTS_Account->create()
#2 C:\UniServerZ\www\install\index.php(216): require('...')
#3 {main}"

im not sure what im doing wrong here im using the mql file that came with this distro

 

[Znote]

Nostalrius 7.72 compatibility · Issue #343 · Znote/ZnoteAAC

Nostalrius is a TFS 1.2 backported to client version 7.72. Presumably with a good data pack that represents itself as a 7.72 clone of the good old days. The release has gotten attention and people ...

github.com

Znote AAC does not officially support Nostalrius because of bad schema design that breaks compatibility. It is based on TFS 1.2, but modified so it won't work with TFS 1.2 schema compatibility. But there is an unofficial modification of Znote AAC where TFS_10 engine option in config.php is modified to at least partly work with Nostalrius.

I don't think there is a github fork available for Nostalrius support? Someone should make it to allow Nostalrius patches and bugfixes to occur, since I won't do it on the official repo.

Edit: MyAAC by @slaw seems to officially support Nostlarius: (since v0.8.1)

GitHub - slawkens/myaac: Automatic Account Creator (AAC) for Open Tibia Servers written in PHP

Automatic Account Creator (AAC) for Open Tibia Servers written in PHP - slawkens/myaac

github.com

Using an AAC that is maintained (as opposed to downloading an unofficial zip file) and officially support the engine your using is always preferential.

 

[Sp0tl3ss]

Nostalrius 7.72 compatibility · Issue #343 · Znote/ZnoteAAC

Nostalrius is a TFS 1.2 backported to client version 7.72. Presumably with a good data pack that represents itself as a 7.72 clone of the good old days. The release has gotten attention and people ...

github.com

Znote AAC does not officially support Nostalrius because of bad schema design that breaks compatibility. It is based on TFS 1.2, but modified so it won't work with TFS 1.2 schema compatibility. But there is an unofficial modification of Znote AAC where TFS_10 engine option in config.php is modified to at least partly work with Nostalrius.

I don't think there is a github fork available for Nostalrius support? Someone should make it to allow Nostalrius patches and bugfixes to occur, since I won't do it on the official repo.

Edit: MyAAC by @slaw seems to officially support Nostlarius: (since v0.8.1)

GitHub - slawkens/myaac: Automatic Account Creator (AAC) for Open Tibia Servers written in PHP

Automatic Account Creator (AAC) for Open Tibia Servers written in PHP - slawkens/myaac

github.com

Using an AAC that is maintained (as opposed to downloading an unofficial zip file) and officially support the engine your using is always preferential.

Ye i found working schemas and an edited znote version with it, I can crate account, chars login to account but not login to The char. I can post them here when im home incase somone needs it in The future i had some issues with myaac columns aswell

 

[jaaraargh]

Ye i found working schemas and an edited znote version with it, I can crate account, chars login to account but not login to The char. I can post them here when im home incase somone needs it in The future i had some issues with myaac columns aswell

You happen to have the link to the working schema? Trying to have a pet project on my spare time, but not very good with sql

 

[ForgottenNot]

Login / Register​

• Username:
• Password:
• 
  

• New account​

  - Account Recovery

Character search​

Top 5 players​

1 - Game System (1).

Search highscores​

Select skill type to view:
Experience Shielding Axe Sword Club Distance Fist Fish Magic

Server Information​

• Players online: 0
• Registered accounts: 2

Search town list​

Select town:
VenoreThaisKazordoonCarlinAb'DendrielRookgaardLiberty BayPort HopeAnkrahmunDarashiaEdronSvargrondYalaharFarmineGray BeachRoshamuulRookgaard Tutorial IslandIsle of SolitudeIsland Of DestinyRathleton

Register Account​

string(167) "INSERT INTO accounts (id, password, email, creation) VALUES ('5xxx', 'e56f3c24b9d6a2764210bc7f025b9c02b868c5c5', '[email protected]', '1712356853')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'creation' in 'field list'