sql

Hello Everyone, Im currently Working on a React SPA with aspnetcore api request. Now i want to implement creatplayer api. Does Somone can Tell me the default values for each vocation lets say for lvl 1 Players Shema: id int(11) name varchar(255) group_id int(11) account_id...

Hi, I'm new to this but I've spent the last 10hours trying to solve this one thing. I've managed to compile the server. I added the schema to mySQL database using Uni server. Added MyACC. Now comes the issue, This is my directory: I got access to 127.0.01 and myACC works so I think atleast...

MariaDB is one of the most popular choices for databases. It was created by the same developers of MySQL with the goal to make it better in terms of security and performance. So if you're still using MySQL in 2024, it's time to update to MariaDB. This tutorial will guide you through the process...

I get these errors on console every few days. Can someone explain what they are and how to fix them? Should I be concerned about any of them? [Error - mysql_real_query] Query: SELECT `reason`, `expires_at`, (SELECT `name` FROM `players` WHERE `id` = `banned_by`) AS `name` FROM `ip_bans` WHERE...

Hi guys, for as long as I can remember I have always dream to create my own Tibia server. However, I don't know much about it. That's why I'm writing this post in search of someone who could help me with SQL and so on. Actually, I just want to help with install an engine with a database. I know...

Hello Everyone ,I add to my Site(Gesior)Ticket System but I have Problem Fatal error: Call to a member function fetch() on a non-object in C:\xampp173\xampp\htdocs\pages\helpdesk.php on line 310 Because I dont Have Page in my phpmyadmin ,how I can add table to my sql?can somebody help me?please

I've seen way too many tutorials showing how to setup MySQL server on a VPS. Please stop using mysql-server. Instead, use MariaDB. It is the exact same as MySQL (meaning: the same developers, the same features [and many more]). But MariaDB is much more secure, much faster (2-3x in most cases)...

Hello everyone, i got the error "no tables were optimized" after i compiling tfs 1.2 8.0, do someone know how to fix it? befor the compilign the databse were normally connected, after source change and new compiling displayed this error... i created an new db it doesnt help. thanks for help...

When I installed the MyAcc website (old-school template) I got it from here: Near the "Server Info" part there is this error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the...

Hi I wrote short code for reports. This code takes info from database and show on webpage all reports. I created in table "player_reports" column "solved" which has automaticaly value 0. Code written below show on webpage all reports with value "solved=0". I created also button "Solve!" which is...

Hello! I'm here looking for guidance. Somebody that can tell me and at the same time teach me how to backtrace this and possibly has a fix? Pretty new to this, but I'm willing to learn about OT's. Trying to learn by customizing a TFS 1.4.1 at the moment, by adding custom skills/items and...

Hello everyone, everything good? A few days ago I have noticed that my server has been giving errors in some tables (which I always repair in PHPMyAdmin), but they come back. Another thing that caught my attention is the error when reading communication packets, apparently it doesn't affect the...

I'm trying to show rebirths on highscores box and characters page on MyAAC (Last version). {% set rows = rows + 1 %} <tr bgcolor="{{ getStyle(rows) }}"> <td>Resets:</td> <td>{{ player.getStorage(14310) }}</td> </tr> On characters page i've tried this, but no success. Always blank. I found this...

Don`t return names on site AND say /ban in the game dont use a function correctly (separatorPos). Ex : /ban player, reason, type, comments (Link of photo error on website) : teste.png (https://drive.google.com/file/d/1yTR9xNW5Mh_7GsAOs0tg5FhGu3yf2xAl/view?usp=sharing) Maybe i know where the...

Hello guys, Players in my otserv are losing ur houses because dont pay rent, but the items should appear in the depot, but the depot is empty. the list of items appears in the "player_depotitems" table but I can't find them in the game. Anyone can help me?

Hi, I have problem with tables so I decided to rename table (houses -> houses_z) and import another table without foreign key check (houses). Now when I close the server and make save I have that information: I delete houses_z but when i try import have that problem: What is wrong? That...

Could somebodby help me, i have 2 little problem :( I don't know what this error is [6/7/2020 23:7:17] sqlite3_prepare_v2(): SQLITE ERROR: no such table: castle_dono (SELECT "guild_id" FROM "castle_dono" WHERE "guild_id" > 0) And this is the other error, it happens when a player log out...

Hello, I have this code function getAccountPoints(cid) local id = db.getResult("SELECT `account_id` FROM `players` WHERE `name` = '" ..getPlayerName(cid).. "';") print("id: " ..id.. "") local res = db.getResult('select `points` from `znote_accounts` where `account_id` = \''..id..'\'')...

TFS 1.2 We have this function on our server, where you pull 1 of 3 levers to set a global storage in db where each lever has its dedicated storage number. What we need, is a global event to check which of the global storages that have the highest value, eg: Lever 1 = 3201 Lever 2 = 3202 Lever...

Hello friends, I would like to know if someone on the forum knows or is more involved in this area of OTS, although we know YurOTS 7.6 xml is obsolete. but my server has been online for more than 11 years and I need my database, I would like to know if it is possible that my XML database can be...