query

hello somebody can help me ? i wanna fix this im use znote 1.6 and otservbr - tibia12.86 Query: SELECT player_id, COUNT(player_id) FROM player_inboxitems GROUP BY player_id HAVING COUNT(player_id) > 10000

Hello guys, good morning. Today after some hours running my server, this error appeared: [error - mysql_real_query] query: select reason, expires_at, (select name from players where id = banned_by) as name from ip_bans where ip = 1076197311 Any idea how can be fixed and how it happens...

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...

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

hello otlanders, i want to execute this local st = 7052 db.query("UPDATE `player_storage` SET `key` = "7052" WHERE `value` = "..st.."+1") i want to give a db storage to a player (current storage + 1) but it doesnt works this is the error on console ')' expected near '7052'

I've been working on a command that will increase the skill of a player by a determined amount, and this is what i've come up with so far function onSay(cid, words) local config = { item = 10140, -- Item required for command skills = 200, -- Half skill for Sword, Axe, Club...

Hello, I cannot get this to work. I'm using gesior. What I'm trying? I'm trying to get "players_record" value into variable. $record = $SQL->query("SELECT `value` FROM `server_config` WHERE `config` = players_record"); echo $record; It's showing nothing... When I try: $record =...

Hi guys, I need to run a talkaction is made an update on the table players, set cast = 1. I tried as follow, but not work. function onSay(player, words, param) if param == "on" then param = nil end if player:startLiveCast(param) then db.query("UPDATE `players` SET `cast` = 0...