PHP [phpMyAdmin] Commands to edit database.

[dervin13]

I can make a command to delete accounts without players??

ty

 

[Renusek]

When I tried to create Sample(acc manager only change name) it says:

#1136 - Column count doesn't match value count at row 1

Fixed .

 

[Sync]

nice =}

 

[husamrox]

need help at this...
UPDATE 'player_skills' SET `value` = '100' WHERE `player_id` =3 AND `skillid` =4

 

[husamrox]

Halp plz

 

[Rufo]

Yes.

Simply:

TRUNCATE TABLE `player_storage`;

 

[Triggah]

i have save = 0 for all my chars in my server
but i want storage values, vip list, and depot items to save

how would i do that through queries?

 

[Idiot]

Nice and Thanks alot...

 

[FLE]

Just Checking, To delete all quests I delete all the player_storage from my database?

please clarify thanks!

 

[Slain]

im trying to delete all of a certain item from the server but im getting this error.
using [LUA[ DELETE FROM player_depotitems,
player_items,
tile_items WHERE itemtype =8877

#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 'WHERE itemtype = 8877' at line 1

 

[hodleo]

#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 'WHERE itemtype = 9977' at line 1

I want to delete itemZZZ I get that error
I use tfs 0.2.2, latest mysql

EDIT: I fixed the code although I see the items in the houses yet
rq: I need a query to delete accounts without characteres

 

[hodleo]

heya? can you make a SQL query?
>delete items of orphan houses(no owner)

 

[laredo981]

and how can i create a god or a gm?
i never find a way to do that and
my data carpet doesn't have a players list
to change level or that stuff.
Can anybody help?

 

[frankfarmer]

UPDATE account SET premdays=0;

should be

UPDATE accounts SET premdays=0;

Hehe

 

[Kiman]

Could you make a SQL Query that deletes houses if player is offline for more than 5 days ?

 

[Xeikh]

Nice, thanks

 

[widnet]

Reset players stoage(quest's)

UPDATE player_storage SET `value` = 0

 

[Matheus2020]

is there a code to delete all houses of players that have been inactive for 10 days? Thanks.

 

[Rizzla]

thx

 

[Tony32]

Omg! Best thread ever! Been looking for this for ever! Thank you x99!