PHP [phpMyAdmin] Commands to edit database.

[SpiderOT]

just open phpmyadmin and click on empty
or
TRUNCATE TABLE `accounts`

 

[darkazey]

Is there a command to make everyone level 8?

 

[dgprado]

On my server, some players have two mail boxes inside their depots, so i need a query to list all itemid 2594 with the same pid grouped by player_id.

 

[dgprado]

bump

 

[dgprado]

On my server, some players have two mail boxes inside their depots, so i need a query to list all itemid 2594 with the same pid grouped by player_id.

 

[SpiderOT]

SELECT `player_id` , COUNT( * ) FROM `player_depotitems`
WHERE `itemtype` =2594 AND `pid` = `pid` GROUP BY `player_id` HAVING COUNT( * ) >1 ORDER BY `player_depotitems`.`player_id` ASC LIMIT 0 , 30

 

[Elexonic]

Help question pleased

as I can give 60 points to all players over level 200?

how I can remove the outfit and addons of the players?

as I remove the frags of the Players'


how to remove items from the homes also like this .. but in houses ..
I using houseDataStorage = "binary-tilebased"

DELETE FROM `player_depotitems` WHERE `itemtype` IN (2160, 2453, 6528, 8851, 8909, 8908, 8907, 8906, 8905, 2493, 2361, 8888, 8882, 8883, 8881, 2495, 8918, 10021, 6132, 2640, 2494, 2471, 7429, 7434, 7390, 7384, 7389, 7415, 7406, 7380, 7392, 8890, 8928, 8924, 8930, 8854)

 

[Mr.Bela]

Really nice

 

[God holy]

i have 1 problem
i have Znote Acc 1.4 And Template Tibia.com and have problem in Latest News y Forum
string(53) "SELECT `type` FROM `accounts` WHERE `id`='3' LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'type' in 'field list'

and not have query of !shop command

more expliqued : Conectarse

 

[TibiaGameHost]

Good comands.

 

[bodycarcoo11]

i need help how i make new player position? 1000 1000 7

 

[Boomz]

i need help how i make new player position? 1000 1000 7

Explain it a little better, what exactly you want to do?

 

[bodycarcoo11]

I Got Gesior AAC and i want any new player be his position 1000 1000 7 because its 0 0 0

 

[Ninja]

Why aren't you just adjusting this in config.php?

$config['site']['newchar_towns'] = array(1);

Players will login at the position you registered for town ID 1.

Edit: You can change default position in accountmanagement.php

                    $char_to_copy->setPosX(0);
                    $char_to_copy->setPosY(0);
                    $char_to_copy->setPosZ(0);

 

[Slavico Dooldy]

guys i have a real proplem , when i add the sql code it shows nothing no errors no confirm messages , rly nothing!

 

[Farbror Krut]

Nice tutorial!

 

[xurre]

nice thx!

 

[Szare Jajko]

Tutorial for using commands in phpmyadmin? I was thinking that tutorial should be for console commands in mysql

 

[God Mythera]

Possible to make a sql command to give a player a group id? without going to player tables, and im using TFS 1.0

 

[karem1]

How can i give people in database mana and health