mysql

Hello guys! I would like to know if there is a talkaction script so that I can remove certain storage from a player. Something like that: /storage "player_name", storage, nill or 1 or -1 On the other hand I would like to know the command line to be able to execute this same function to...

Good Day My server gods I'm having this issue with the guide: Setting up your first server (https://docs.otland.net/ots-guide/running-your-first-ot-server/setting-up-your-first-server) I set up everything with the guide "best" scenario and I get this error, i'm following the instructions but...

Hello, im using in my ot binary-tilebased, how can i find items in house tiles?

Hi, when my server startup i get some errors when optimizing tables, after some attemps it ends with a "failure", but i dont see any problem ingame, someone know how to fix that? and what happen if i start server with startupDatabaseOptimization = false? whats the difference? hello

Filme COD (int, pk) nome(varchar 20, not null) nascimento(datetime, not null) obs(tinybit, not null) obs2(int, fk, not null) I thought of something of the type create table filme ( COD int PRIMARY KEY AUTO_INCREMENT, nome varchar(200) NOT NULL, nascimento datetime NOT NULL, obs tinyint NOT...

Greetings, I'm having some issues with my ots. I've already set mysql, php and ots files up. Everything works fine, engine compiled, website works, accounts can be created. Database looks fine, no errors, all tables ok. When creating an account there's no error, the same when it comes to...

I've been following this tutorial Everything went fine except few things: - In the video he imported forgottenserver.sql (I don't have that file in Forgotten Server 1.2 which i downloaded from github BUT i figured it's schema.sql now) - I've updated config.lua with the connection information...

what difference there is between these 2 functions. luaDatabaseExecute luaDatabaseAsyncExecute The one who does not know anything about this that better not write anything. a little doubt;) (db.query) return boolean value (AsyncExecute) return ???

Hello! im gettings this error. not sure what it means or how to slove it. mysql_real_query(): INSERT INTO `zotsme_logins` (`id`, `player_id`, `login_time` , `logout_time`, `online_time`, `kills`, `deaths`, `assists`) VALUES (NULL, 115, 1525943443, 1525943484, 41, 0, 0, 0); - MYSQL ERROR: Table...

Hello people, so me and a few friends were testing different ways to crash a server and we figured a way (that everybody already knows about), that is by trashing the tiles of a house with thousands of items, possibly hundreads of thounsands, than leaving the house. The crash is caused by the...

Hello My znote can't connet to database on a port other than 3306. I changed ports (2x) in etc/mysql/my.cnf. (engine/database/connect.php) $connect = new mysqli($config['sqlHost'], $config['sqlUser'], $config['sqlPassword'], $config['sqlDatabase']); This works perfectly in port 3306...

Getting these two errors with my website. Query: SELECT `bans`.`id`, `bans`.`type`, `bans`.`value`, `bans`.`param`, `bans`.`active`, `bans`.`expires`, `bans`.`added`, `bans`.`admin_id`, `bans`.`comment` FROM `bans` WHERE `type` = '3' AND `value` = '4' AND `active` = '1' SQLSTATE: 00000 Driver...

Premium Programming/Scripting Services Protocols: 7.x - 10.98 Website services: * Front-end: CSS / JavaScript * Back-end: PHP / Go * SQL * Server setup LAMP In-game services: * Lua * C++ * DLL Injection (tibianic) I do not work with OTClient. Scroll down for free content and examples...

Need Help With Your Website? What I can do for you: * Design (HTML/CSS/JavaScript) * PHP * MySQL/phpmyadmin I've made websites with ZnoteAAC before and know it well. Just send me a quick pm on how you want your website to look and what features you want to have. * Only paid projects atm...

Hi there! I've got problem when connecting to server it throws this error. SELECT `pk`.`player_id`, `pd`.`date` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` WHERE `pd`.`player_id` = 7530 AND...

I have this code for top guilds in latest news $main_content .= '<div class="NewsHeadline"> <div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)"> <table border="0"> <tr> <td...

Hi guys Please help me about this problem [2:16:03.834] mysql_real_query(): UPDATE `players` SET cast=0, castViewers=0, castDescription='' WHERE `world_id` = 0 AND cast > 0; - MYSQL ERROR: Unknown column 'cast' in 'where clause' (1054)

Lately there are some strange results in my database, as well as the following represented below: Àé·� Could anyone tell me what this is about?

Hey guys, this is one of my first threads, I'm brazillian and sorry for my bad english... Well, let's to the issue About 4 days ago, I just downloaded Gesior 2012 for TFS 0.4 + directly from the official repository of Gesior.pl in GitHub. The website seems like very nice, now I'm trying to edit...

I'm working on a lua account manager but the moment i started making the account creator script i noticed a bad pattern. ^ When executing a query everything has to be on one line, in this case its only 6 columns and it looks semi-decent, but can you guess what will happen when i edit the...