[L4D & L4D2] Custom Player Stats v1.4B121 - Page 95

ki1418z · *Last edited by ki1418z; 07-25-2010 at 12:45.*

Sorry, I don't understand how to do that:

Quote:

Edit your databases.cfg file at /addons/sourcemod/config. Insert "l4dstats" entry with a valid connection info to your Custom Player Stats database

Quote:

"l4d_stats"
{
"driver" "mysql"
"host" "sql110.i34u.com"
"database" "i34u_6040930_l4dstats"
"user" "i34u_6040930"
"pass" "xxxxxx"
//"timeout" "0"
//"port" "0"
}

Is that right?

the server date haven't data to show on the website.
http://myl4d.co.cc/

realdreams · 07-26-2010 , 01:53 Re: [L4D & L4D2] Custom Player Stats v1.4B101

Quote:

// Installation instructions:
// 1. Download and extract http://www.maxmind.com/download/geoi...CountryCSV.zip to web stats root (same folder as updatetable.php)
// 2. Execute updatetable.php (use a web browser) - BE PATIENT AND WAIT FOR THE EXECUTION TO FINISH!
// 3. Delete files GeoIPCountryCSV.zip and GeoIPCountryWhois.csv when installation is successful

I can't find updatetable.php, it's not in the zip file.

ki1418z · 07-26-2010 , 03:59 Re: [L4D & L4D2] Custom Player Stats v1.4B101

My database server may not accepting remote connections.

Any one can borrow your database to me?
*and then pm the database username and pass.
*I will not to login your server. plx assured.

muukis · 07-26-2010 , 04:01 Re: [L4D & L4D2] Custom Player Stats v1.4B101

Quote:

Originally Posted by [-NM-] cal70d

Hey muukis,

Thanks for all your help and maintaining this plugin.

I was wondering if you could make a sql dump of the ip2country_blocks table and add it to the downloads?

I'm having trouble getting the install.php to fill this table. It always times out before it finishes and the starts over each time install.php is run again.
I've tried importing the csv directly, but it is too large.

Thank you.

Try executing the install.php from web server console (command prompt).

Example:

Code:

php ./install.php

Quote:

Originally Posted by ki1418z

Sorry, I don't understand how to do that:

Is that right?

the server date haven't data to show on the website.
http://myl4d.co.cc/

It looks OK, but you will have to make sure your database accepts remote connections from the game server. Google mysql remote access.

Quote:

Originally Posted by realdreams

I can't find updatetable.php, it's not in the zip file.

Sorry! It seems I have not updated all instructions. There is no UPDATETABLE.PHP left. It was replaced with INSTALL.PHP.

ki1418z · *Last edited by ki1418z; 07-26-2010 at 05:37.*

Quote:

Originally Posted by muukis

Try executing the install.php from web server console (command prompt).

Example:

Code:

php ./install.php

It looks OK, but you will have to make sure your database accepts remote connections from the game server. Google mysql remote access.

Sorry! It seems I have not updated all instructions. There is no UPDATETABLE.PHP left. It was replaced with INSTALL.PHP.

Thx for your help.

I use free host, the database not accepts remote connections.

--------------------------------------------------------------------
Any one can borrow your database to me?
*Create database.
*and then pm the database name, username and pass.
*I will not to login to your server to change the setting.

Please assured.

pirko7 · 07-28-2010 , 18:59 Re: [L4D & L4D2] Custom Player Stats v1.4B101

Please i need "full" exaple: database.cfg and config.php

realdreams · 07-28-2010 , 19:59 Re: [L4D & L4D2] Custom Player Stats v1.4B101

Is there a way I can use this for multiple servers with only one stats webpage?

muukis · 07-29-2010 , 03:43 Re: [L4D & L4D2] Custom Player Stats v1.4B101

Quote:

Originally Posted by pirko7

Please i need "full" exaple: database.cfg and config.php

Attached to this post...

Quote:

Originally Posted by realdreams

Is there a way I can use this for multiple servers with only one stats webpage?

Yes. You need one MySQL server, one web server with web stats installed and configured to connect to the one MySQL server, and multiple game servers that all connect to the one MySQL server.

realdreams · *Last edited by realdreams; 07-29-2010 at 04:53.*

Quote:

Originally Posted by muukis

Attached to this post...

Yes. You need one MySQL server, one web server with web stats installed and configured to connect to the one MySQL server, and multiple game servers that all connect to the one MySQL server.

Thanks. I can do this with two Custom Player Stats webpages and 2 mysql DBs, is it possible to get them in a single page, like hlxce (I can view all servers on a single page and one mysql DB )?

I find this

Quote:

// Game server address (adds a Steam connection link over the site name)
// Multiple game server addresses supported (just write multiple configurations and use the correct syntax for each of them)
/* THIS LINE: DO NOT MODIFY OR REMOVE */ $game_addresses = array();
// Syntax:
// $game_addresses[] = array("<NAME>", "<ADDRESS>[:<PORT>]");
// Examples:
// $game_addresses[] = array("Server 1: Left 4 Dead 2", "my.site.net:27016");
// $game_addresses[] = array("Server 2: Kill Them Zombies", "123.0.0.234");

Does it mean I add 2 servers here and set databese.cfg to the same mysql server, then this plugin can work for 2 servers?
Or it only adds steam link?

How does it deal with 2 servers? combine online players or show them separately?
BTW when no enough player stats disabled shows, does the player still be shown as online on webpage?

Thanks.

realdreams · *Last edited by realdreams; 07-29-2010 at 04:48.*

In l4d_stats.cfg, I set l4d_stats_minhumans 1
But it seems the plugin never reads from the cfg file. My setting in cfg file doesnt go into effect.
Does it use this cvar at all? I add l4d_stats_minhumans 1 to server.cfg, but it still doesn't work. (Maybe server.cfg loads before this plugin so its just an unknown command? ) Then how can I change these cvars?

And whats the time interval for stats page update?