phpmyadmin codes.

[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)

 

[Elexonic]

UPDATE accounts SET premium_points = premium_points + 60 WHERE id IN (SELECT id FROM players WHERE level >200)

Have this but don`t work :S

 

[rox666]

You should use talkaction /reward, also make a rune that giving 60 points..
about outfits,addons,sex go phpmyadmin then go players, you will find lookbody bla bla any u want u can change
also in phpmyadmin u can find "skull" thats how many frags player has "^^

 

[Elexonic]

Bump

 

[dereker]

You have to do it after you close the server.

If you want to do when the server is online then you have to make query in LUA

 

[Cykotitan]

UPDATE accounts SET premium_points = premium_points + 60 WHERE id IN (SELECT account_id FROM players WHERE level >= 200 GROUP BY account_id);

DELETE FROM player_storage WHERE `key` >= 1000000;
UPDATE players SET lookaddons = 0, looktype =
	CASE
		WHEN sex = 0 THEN 136
		ELSE 128
	END;

DELETE from killers WHERE id IN(select kill_id from player_killers);
TRUNCATE TABLE player_killers;

config.lua houseDataStorage = "relational", /reload config, /save and shutdown, query

DELETE FROM `tile_items` 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)

start server and do the same procedure to enable binary storage again

 

[TibiaGameHost]

All codes:
www.darkot.com/comandos.php

 

[treadwellpar]

You have to do it after you close the server.

 

[Elexonic]

Thanks all and Cykotitan
Tested this night
i love you =)

 

[Elexonic]

one would need also to give certain players with points x name. example

UPDATE accounts SET premium_points = premium_points + 60 WHERE name = (pedro,juan,luis]


thanks

 

[Elexonic]

Bumpp!

 

[Elexonic]

also anyone know a good descrambler sha1 password online?

 

[Evan]

Considering the SHA1 passwords were encoded using SALT values, I don't think there's an online decoder that works.

 

[Elexonic]

This comand work perfect.. i need added more name chars..



UPDATE accounts SET premium_points = premium_points + 60 WHERE id IN (SELECT account_id FROM players WHERE name = "druida" GROUP BY account_id);

:S

 

[Elexonic]

Bump!

 

[Elexonic]

Bump!

 

[Elexonic]

Fixed Thanks All!