Richard Perry - GreyCube.com: Forums / Live Game Server List / Autoremove offline servers

Richard Perry - GreyCube.com :: Forums :: Live Game Server List

Autoremove offline servers

dcum

Wed Nov 17 2010, 08:26AM

Posts: 14
Joined: Sat Feb 06 2010, 11:31AM
Registered Member #5775

Probably to realize in LGSL autoremoval of offline servers. For example, if the server doesn't answer three days it leaves from base. Thanks.

KIKOFF

Thu Nov 18 2010, 10:08AM

Posts: 132
Joined: Thu Nov 18 2010, 08:18AM
Registered Member #6411

Take a look in lgsl_config, is there

Lo cortez, no quita lo valiente... ahhh... yes e107 Rock

dcum

Thu Nov 18 2010, 02:44PM

Posts: 14
Joined: Sat Feb 06 2010, 11:31AM
Registered Member #5775

Where???

KIKOFF

Fri Nov 19 2010, 10:06AM

Posts: 132
Joined: Thu Nov 18 2010, 08:18AM
Registered Member #6411

line 81 "// [ HIDE OFFLINE SERVERS: 0=HIDE 1=SHOW"

Lo cortez, no quita lo valiente... ahhh... yes e107 Rock

»Stefan

Fri Nov 19 2010, 10:12AM

Posts: 172
Joined: Fri Feb 05 2010, 03:56PM
Registered Member #5774

You give answers to + 1 do not know what the member wants

NO LGSL , PHP & query valve and Mysql = http://expertcs.info/

KIKOFF

Fri Nov 19 2010, 03:54PM

Posts: 132
Joined: Thu Nov 18 2010, 08:18AM
Registered Member #6411

Oh sorry I understood something else ...

Lo cortez, no quita lo valiente... ahhh... yes e107 Rock

AGENTUL

Sat Nov 20 2010, 05:05AM

Posts: 33
Joined: Sun Apr 11 2010, 11:50AM
Registered Member #5960

u can make something like this ...




<?php



mysql_query("DELETE FROM `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` WHERE status = '0' ");



?>

this code remove all server from database when status = 0

dcum

Sat Nov 20 2010, 11:19PM

Posts: 14
Joined: Sat Feb 06 2010, 11:31AM
Registered Member #5775

AGENTUL wrote ...

u can make something like this ...




<?php



mysql_query("DELETE FROM `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` WHERE status = '0' ");



?>

this code remove all server from database when status = 0

ths, but when the server changes a map its status is equal 0.

C0n

Sat Feb 11 2012, 02:31PM

Posts: 33
Joined: Tue Nov 03 2009, 01:54AM
Registered Member #5538

This is a good idea but what would make the following code better is.


<?php



mysql_query("DELETE FROM `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` WHERE status = '0' ");



?>

When we add servers to the database we keep a date of when they were last online

Then lets say a server that gets queried that has not been online in 2-3 days 48 or more hours will be deleted.

C0n

Live Steam Server List tracking over 1million servers http://www.steam-hacks.com/servers.html Listing more servers than gametracker and game-monitor