Discussion in 'Programming & Scripting' started by Jester, Jun 23, 2008.
just open phpmyadmin and click on empty
TRUNCATE TABLE `accounts`
Is there a command to make everyone level 8?
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.
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
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"
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
i need help how i make new player position? 1000 1000 7
Explain it a little better, what exactly you want to do?
I Got Gesior AAC and i want any new player be his position 1000 1000 7 because its 0 0 0
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
guys i have a real proplem , when i add the sql code it shows nothing no errors no confirm messages , rly nothing!
Tutorial for using commands in phpmyadmin? I was thinking that tutorial should be for console commands in mysql
Possible to make a sql command to give a player a group id? without going to player tables, and im using TFS 1.0
How can i give people in database mana and health