Strange, I will install XAMPP 7.4.29, clean and see if I can find Znote 2.0 I believe this is the newer one thats under development still right? Do you run the config on tfs_10 or 1.x ?
[8.60] [TFS 1.2] -[Real Map full] with mount & market system
- Thread starter Shiris undrin
- Start date
Mateus Robeerto
Excellent OT User
The links I used here are for TFS 1.x, indeed.
github.com
github.com
GitHub - gesior/Gesior2012: Gesior 2012 - Account Maker [website] for OTSes, account maker you can find in BRANCHES. Select 'branch'.
Gesior 2012 - Account Maker [website] for OTSes, account maker you can find in BRANCHES. Select 'branch'. - gesior/Gesior2012
github.com
GitHub - Znote/ZnoteAAC at v2
Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - GitHub - Znote/ZnoteAAC at v2
github.com
Can't Reproduce stable results.
Using xampp7.4.29
And Znote 2.0 within the configphp I've set $config['ServerEngine'] = 'TFS_10';
On this 8.60 Using the global3.sql Database structure that was given with the server now hosted on on MariaDb Xamp 7.4.29
And importing the Znote SQL config file in to the Main database "znote_schema.sql" 9KB
Making sure the Database config is fine everything works but account and character creation doesn't.
string(99) "SELECT
(query - SQL error)
Type: select_single (select single row from database)
Unknown column 'premium_ends_at' in 'field list'
This field does exsist inside the Database, however its not naitive, Had to add it myself but it still cant be seen.
Would it be possible for you to send a working config.php " getting rid of any password before uploading" and a working sql schema that has no passwords or account data?
This would probably solve whatever field mismatches I'm seeing.
Conbination of files used
Found inside of this package is
global3.sql 770 KB
znote_schema.sql 152 KB
No positive effect.
znote_schema.sql 9 KB this came with the Znote Account maker 2.0
No positive effect.
They all cause some problems either with account creation or character creation.
either with the above error or with missing players_skills as a field e.t.c
Tried a combination of all schema's in order to match the fields it would want to adres but nothing seems to work.
Using xampp7.4.29
And Znote 2.0 within the configphp I've set $config['ServerEngine'] = 'TFS_10';
On this 8.60 Using the global3.sql Database structure that was given with the server now hosted on on MariaDb Xamp 7.4.29
And importing the Znote SQL config file in to the Main database "znote_schema.sql" 9KB
Making sure the Database config is fine everything works but account and character creation doesn't.
string(99) "SELECT
id, name, password, email, premium_ends_at FROM accounts WHERE id = 2 LIMIT 1;"(query - SQL error)
Type: select_single (select single row from database)
Unknown column 'premium_ends_at' in 'field list'
This field does exsist inside the Database, however its not naitive, Had to add it myself but it still cant be seen.
Would it be possible for you to send a working config.php " getting rid of any password before uploading" and a working sql schema that has no passwords or account data?
This would probably solve whatever field mismatches I'm seeing.
Conbination of files used
Found inside of this package is
global3.sql 770 KB
znote_schema.sql 152 KB
No positive effect.
znote_schema.sql 9 KB this came with the Znote Account maker 2.0
No positive effect.
They all cause some problems either with account creation or character creation.
either with the above error or with missing players_skills as a field e.t.c
Tried a combination of all schema's in order to match the fields it would want to adres but nothing seems to work.
Last edited:
Mateus Robeerto
Excellent OT User
@eddyhvg Friend, it's time to pay attention to everything. The schema is very basic and doesn't contain anything. You need to add the schemas to the SQL to make it work properly. The database will ask you for the missing schemas. So, you should search online, find the schemas, copy and paste them into SQL, and execute them one by one. I'll give an example of the error that occurred in the 'premium_ends_at' part. Just click on the database you created, then go to 'SQL', execute it, and see. After that, figure out what else is needed by asking for the schemas.
SQL:
ALTER TABLE accounts ADD premium_ends_at INT NOT NULL DEFAULT 0;Will step through the fields and add them as I go Along. I just expected that it would work flawlessly without much effort if you have already concatinate both schema's together I thought it would just work and you didn't need to add more fields manually.
johnsamir
Advanced OT User
@Shiris undrin which tool did you use to convert spr/dat files to 8,60? how you did it ? wouldlike to do it by yself to see if i can kept spr/ dat names flags would like to get market system working
does anyone have a suggestion on what could cause items to gain double their intended values?
for example, any item that has + sword fighting like item id 8881 (fireborn giant armor), it will make you sword skill go up by 4 instead of 2, and this repeats itself across every item with many different attributes. maybe the attacks and defences are doubled too? im not sure how I would even test
for example, any item that has + sword fighting like item id 8881 (fireborn giant armor), it will make you sword skill go up by 4 instead of 2, and this repeats itself across every item with many different attributes. maybe the attacks and defences are doubled too? im not sure how I would even test
reginaldofilhog
Member
Why use this in the source?
C++:
integer[abriu_nao_server_atacado] = getGlobalNumber(L, "abriu_nao_server_atacado", 30);
Setting up your first server | OTS Guide
docs.otland.net
brother, i dont understand these things, can you upload it working for me? so i can open the server and play solo and have fun after work?
Setting up your first server | OTS Guide
You need to set up a database. It's simple to setup.
I can't do it for you unfortunately.
Here it is in video format:
its a 1 hour video i doubt its simple lol, nvm i give up
okay lol
- Joined
- Nov 23, 2023
- Messages
- 107
- Reaction score
- 16
the map has a problem with monsters that spawn in unsuitable places. anyone know how to fix it quickly? I described the problem here:
otland.net
TFS 1.X+ - The monsters on the map are in strange positions. Can it be removed?
Hello. On my map, a lot of monsters respawn in strange positions where you can't move. What causes the crash. Is there any way to detect them all or remove them at once or do I have to do it laboriously manually? These monsters are probably causing the crash. The log is at the end of the post...
czaja152
Well-Known Member
- Joined
- Aug 26, 2018
- Messages
- 150
- Reaction score
- 70
maybe ?the map has a problem with monsters that spawn in unsuitable places. anyone know how to fix it quickly? I described the problem here:
TFS 1.X+ - The monsters on the map are in strange positions. Can it be removed?
Hello. On my map, a lot of monsters respawn in strange positions where you can't move. What causes the crash. Is there any way to detect them all or remove them at once or do I have to do it laboriously manually? These monsters are probably causing the crash. The log is at the end of the post...
View attachment 85205
Last edited:
Simonp1512
DBhispano
- Joined
- Feb 22, 2009
- Messages
- 71
- Reaction score
- 5
could you spare the original sources for that otclient? im trying to compile on other otc but need many features that i don't know, as mounts for example, spr and dat is usually an error on otc even the original you post.
thats on your otc @Shiris undrin
if anyone has the error with some dark places on the map, just open the item editor and reload attributes for the items, ill change the version for 860v1 and that solved my dark items error i hope this help for anyone
Code:
ERROR: Failed to read dat '/things/860/Tibia.dat': corrupt data (id: 1661, category: 0, count: 255, lastAttr: 0)'
Post automatically merged:
if anyone has the error with some dark places on the map, just open the item editor and reload attributes for the items, ill change the version for 860v1 and that solved my dark items error i hope this help for anyone
Last edited:
cheiracoca
Active Member
the market doesn't work?
