sql query

Hi OtLand! Is there any way or query(ies) to reset all the characters in the database? I want to reset the accounts of my server, but I don't want to delete the characters, I only want them to start at level 8 again with default skills and everything fresh new. Obviously clearing storages...

I'm using [Znote AAC] Most powerful guilds (TFS 0.3/4 and 1.0) (https://otland.net/threads/znote-aac-most-powerful-guilds-tfs-0-3-4-and-1-0.209045/) (no table design) and tfs 0.4 the select query is SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `killers` k...

Hello, I had some depots in certain towns linked wrong and now a player has different items in different depots at the same city. Is there a SQL Query that would allow me to send all the items my players have from one depot to another? Example: I have 30 itens in the depot of town 1 and 50 in...

hi guys, we used to have a 'online' column in players table, now we got the player_id in the players_online table, how do I make this query work with the new table? instead of "where online = 1;" I need the SQL equivalent of "where player_id is present in the players_online table"

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

Hello, I'm trying to rewrite some old scripts and I need help as 1.x (1.3 on my case) doesn't have online column on table players. This is the code I used to have: function onThink(interval) local query = db.getResult("Select * FROM `players` WHERE `level` > 350 and `online`=1 ORDER BY `level`...