• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

PHP [phpMyAdmin] Commands to edit database.

I don't know if it's possible.

already asked gesior for these who want to test xD
Code:
SELECT `player_id` , COUNT( `player_id` ) ilosc
FROM `player_depotitems`
GROUP BY `player_id`
ORDER BY `ilosc` DESC
 
@JESTER

Hello friend, i'm using AVARIANS AAC, and this have a DELETE INACTIVE PLAYERS COMMAND, but only delete player, now i have many acc without characters, how to me delete this accs on sql command???

-- Can you help me to solve this??? Many thx...
 
do anyone test this command:
DELETE FROM player_items WHERE player_id NOT IN (SELECT id FROM players);

It working good?
 
do anyone test this command:
DELETE FROM player_items WHERE player_id NOT IN (SELECT id FROM players);

It working good?

Test it by changing 'DELETE' with 'SELECT *'
The lines you get is what that gets deleted using that query.
 
Can i fix so all house dont have an owner in the database?
 
Hey, do i need to have the ot off when i do this?
Becaust its just change back when its on
 
It depends on what you make. If you wanna remove bans OTS has to be offline. If you update players lvls or sth the players have to be offline.

Your's ballack13
 
How to clear all houses owners that belongs to player who are inactive for 20 days?

Sorry for my eng.

Ex.:
player buy house but not login for 23 days. How to delete player, his items, depot items and house(set house status to NOBODY).

thanks
 
Last edited:
Is it possible to remove all addons players have received? I had a lousy addon seller, now I got a perfect one. So I want people to regain their addons.

I searched some, and found this;

PHP:
DELETE FROM player_storage WHERE key > 1000000

But I got;

Code:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key > 1000000' at line 1

Hope someone can help me fast! :)
 
Same error when I use that one.

The correct version was;
PHP:
 DELETE FROM player_storage WHERE `key` > 1000000;

-Infamous.

EDIT: Working now!
 
Last edited:
Back
Top