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

muukis · 03-03-2014 , 14:08 Re: [L4D & L4D2] Custom Player Stats v1.4B121

Quote:

Originally Posted by Evkval

help. how to install ?

Use the guide in the first post. GitHub contains the Russian language.

Mitsuru · 04-09-2014 , 05:04 Re: [L4D & L4D2] Custom Player Stats v1.4B46

Quote:

Originally Posted by muukis

Can you explain me what are you trying to do and how, what errors do you get?

You just extract the files to your website (like http://l4dstats.yourwebsite.com) and then you open a web browser and enter the website URL with createtable.php (like http://l4dstats.yourwebsite.com/createtable.php). That is how you execute the script.

Your website has to support PHP and you have to modify the config.php file before executing the scripts.

Execute install.php：

Access denied for user 'root'@'localhost' (using password: NO)
Can you tell me why?Thank you very much！

Mitsuru · 04-09-2014 , 05:06 Re: [L4D & L4D2] Custom Player Stats v1.4B121

Quote:

//// l4d_stats.sp
// l4d_stats.sp(3011) : warning 200: symbol "StatsPrintToChatAllPreFormatted" is
truncated to 31 characters
// l4d_stats.sp(3011) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(7883) : warning 200: symbol "StatsPrintToChatAllPreFormatted" is
truncated to 31 characters
// l4d_stats.sp(7883) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(7969) : warning 200: symbol "StatsPrintToChatAllPreFormatted" is
truncated to 31 characters
// l4d_stats.sp(7969) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(8007) : warning 200: symbol "StatsPrintToChatAllPreFormatted" is
truncated to 31 characters
// l4d_stats.sp(8007) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(8015) : warning 200: symbol "StatsPrintToChatAllPreFormatted" is
truncated to 31 characters
// l4d_stats.sp(8015) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(11281) : warning 200: symbol "StatsPrintToChatAllPreFormatted" i
s truncated to 31 characters
// l4d_stats.sp(11281) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(11421) : warning 200: symbol "StatsPrintToChatAllPreFormatted" i
s truncated to 31 characters
// l4d_stats.sp(11421) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(11437) : warning 200: symbol "StatsPrintToChatAllPreFormatted" i
s truncated to 31 characters
// l4d_stats.sp(11437) : error 025: function heading differs from prototype
// l4d_stats.sp(11437) : error 025: function heading differs from prototype
// l4d_stats.sp(1143

: error 021: symbol already defined: "StatsPrintToChatAll
PreFormatted"
//
// 10 Errors.
//
// Compilation Time: 2.84 sec

muukis · *Last edited by muukis; 04-10-2014 at 06:24.*

Quote:

Originally Posted by Mitsuru

Execute install.php：

Access denied for user 'root'@'localhost' (using password: NO)
Can you tell me why?Thank you very much！

You shouldn't use root as your connection user. If you insist on doing that, you must make sure root can make the connection from the web server. Also double check your password. Try connecting MySQL server using the console (want to know how - try google).

About the error messages from the compile. What did you do and how? I general, you should just download the precompiled version.

Mitsuru · *Last edited by Mitsuru; 04-15-2014 at 10:39.*

Quote:

Originally Posted by muukis

You shouldn't use root as your connection user. If you insist on doing that, you must make sure root can make the connection from the web server. Also double check your password. Try connecting MySQL server using the console (want to know how - try google).

About the error messages from the compile. What did you do and how? I general, you should just download the precompiled version.

I have found a free web space, support the remote mysql connection. I have updated the metamod1.10.0 sourcemod1.5.3 version.L4d_stats.sp I didn't make any changes.
There is still a mistake:

PHP Code:


			
//// l4d_stats.sp
// l4d_stats.sp(619) : warning 234: symbol "GuessSDKVersion" is marked as deprec
ated: See GetEngineVersion()
//
// Header size:          14988 bytes
// Code size:           222768 bytes
// Data size:           214540 bytes
// Stack/heap size:      16384 bytes; Total requirements:  468680 bytes
//
// 1 Warning.
//
// Compilation Time: 2 sec
// ----------------------------------------

I try to translate webstats template, I know it is very difficult for me

.
If it is a custom map need to add in phpmyadmin data list?
Msleeper template:
L4dsk.Tk

Mitsuru · 04-16-2014 , 12:33 Re: [L4D & L4D2] Custom Player Stats v1.4B46

Quote:

Originally Posted by muukis

You shouldn't use root as your connection user. If you insist on doing that, you must make sure root can make the connection from the web server. Also double check your password. Try connecting MySQL server using the console (want to know how - try google).

About the error messages from the compile. What did you do and how? I general, you should just download the precompiled version.

I know this post has already been a long time, can you help me have a look at my configuration?
Please give me the right advice
config.php
/ / MySQL information for L4D Stats DB
$mysql_server = "127.0.0.1";
$mysql_db = "sg52_l4d";
$mysql_user = "sg52_admin";
$mysql_password = "* * *";
$mysql_tableprefix = "";
Why is 127.0.0.1? Or add other,,,
$game_addresses [] = array (" server: Left 4 Dead ", "wanru.oicp.net: 27015");
Fill in the address of the server here what's the point? Dynamic IP domain name wanru.oicp.net is my explanation, is it right?
The databases. The CFG it wrong?
"L4dstats"
{
"Driver" "mysql"
"The host" "116.251.214.235"
"Database" "sg52_l4d"
"User" "sg52_admin"
"Pass" "* * *"
"Port" "3306"
Create a table the PHP confidence appeared the following:
"l4dstats"
{
"driver" "mysql"
"host" "116.251.214.235"
"database" "sg52_l4d"
"user" "sg52_admin"
"pass" "***"
"port" "3306"
创建表install.php出现以下信心：

Quote:

Duplicate column name 'infected_spawn_8'
Duplicate column name 'lastgamemode'
Duplicate column name 'kill_spitter'
Duplicate column name 'kill_jockey'
Duplicate column name 'kill_charger'
Duplicate column name 'playtime_versus'
Duplicate column name 'playtime_realism'
Duplicate column name 'playtime_survival'
Duplicate column name 'playtime_scavenge'
Duplicate column name 'playtime_realismversus'
Duplicate column name 'points_survivors'
Duplicate column name 'points_infected'
Duplicate column name 'points_realism'
Duplicate column name 'points_scavenge_survivors'
Duplicate column name 'points_scavenge_infected'
Duplicate column name 'points_survival'
Duplicate column name 'points_realism_survivors'
Duplicate column name 'points_realism_infected'
Duplicate column name 'versus_kills_survivors'
Duplicate column name 'realism_kills_survivors'
Duplicate column name 'scavenge_kills_survivors'
Duplicate column name 'jockey_rides'
Duplicate column name 'award_pounce_perfect'
Duplicate column name 'award_pounce_nice'
Duplicate column name 'award_perfect_blindness'
Duplicate column name 'award_infected_win'
Duplicate column name 'award_scavenge_infected_win'
Duplicate column name 'award_bulldozer'
Duplicate column name 'award_survivor_down'
Duplicate column name 'award_ledgegrab'
Duplicate column name 'award_adrenaline'
Duplicate column name 'award_fincap'
Duplicate column name 'award_jockey'
Duplicate column name 'award_charger'
Duplicate column name 'award_defib'
Duplicate column name 'award_matador'
Duplicate column name 'award_witchcrowned'
Duplicate column name 'award_gascans_poured'
Duplicate column name 'award_upgrades_added'
Duplicate column name 'award_scatteringram'
Duplicate column name 'infected_spawn_1'
Duplicate column name 'infected_spawn_2'
Duplicate column name 'infected_spawn_3'
Duplicate column name 'infected_spawn_4'
Duplicate column name 'infected_spawn_5'
Duplicate column name 'infected_spawn_6'
Duplicate column name 'infected_spawn_8'
Duplicate column name 'infected_boomer_vomits'
Duplicate column name 'infected_boomer_blinded'
Duplicate column name 'infected_hunter_pounce_counter'
Duplicate column name 'infected_hunter_pounce_dmg'
Duplicate column name 'infected_smoker_damage'
Duplicate column name 'infected_spitter_damage'
Duplicate column name 'infected_jockey_damage'
Duplicate column name 'infected_jockey_ridetime'
Duplicate column name 'infected_charger_damage'
Duplicate column name 'infected_tank_damage'
Duplicate column name 'infected_tanksniper'
Duplicate column name 'ip'
Duplicate column name 'charger_impacts'
Duplicate column name 'melee_kills'
Players table altered successfully!
Players table altered successfully!
Players table altered successfully!
Unknown column 'versus' in 'maps'
Duplicate column name 'infected_spawn_8_nor'
Duplicate column name 'infected_spawn_8_adv'
Duplicate column name 'infected_spawn_8_exp'
Duplicate column name 'custom'
Duplicate column name 'gamemode'
Duplicate column name 'points_infected_nor'
Duplicate column name 'points_infected_adv'
Duplicate column name 'points_infected_exp'
Duplicate column name 'survivor_kills_nor'
Duplicate column name 'survivor_kills_adv'
Duplicate column name 'survivor_kills_exp'
Duplicate column name 'infected_win_nor'
Duplicate column name 'infected_win_adv'
Duplicate column name 'infected_win_exp'
Duplicate column name 'survivors_win_nor'
Duplicate column name 'survivors_win_adv'
Duplicate column name 'survivors_win_exp'
Duplicate column name 'infected_smoker_damage_nor'
Duplicate column name 'infected_smoker_damage_adv'
Duplicate column name 'infected_smoker_damage_exp'
Duplicate column name 'infected_jockey_damage_nor'
Duplicate column name 'infected_jockey_damage_adv'
Duplicate column name 'infected_jockey_damage_exp'
Duplicate column name 'infected_jockey_ridetime_nor'
Duplicate column name 'infected_jockey_ridetime_adv'
Duplicate column name 'infected_jockey_ridetime_exp'
Duplicate column name 'infected_charger_damage_nor'
Duplicate column name 'infected_charger_damage_adv'
Duplicate column name 'infected_charger_damage_exp'
Duplicate column name 'infected_spitter_damage_nor'
Duplicate column name 'infected_spitter_damage_adv'
Duplicate column name 'infected_spitter_damage_exp'
Duplicate column name 'infected_tank_damage_nor'
Duplicate column name 'infected_tank_damage_adv'
Duplicate column name 'infected_tank_damage_exp'
Duplicate column name 'infected_boomer_vomits_nor'
Duplicate column name 'infected_boomer_vomits_adv'
Duplicate column name 'infected_boomer_vomits_exp'
Duplicate column name 'infected_boomer_blinded_nor'
Duplicate column name 'infected_boomer_blinded_adv'
Duplicate column name 'infected_boomer_blinded_exp'
Duplicate column name 'infected_spawn_1_nor'
Duplicate column name 'infected_spawn_1_adv'
Duplicate column name 'infected_spawn_1_exp'
Duplicate column name 'infected_spawn_2_nor'
Duplicate column name 'infected_spawn_2_adv'
Duplicate column name 'infected_spawn_2_exp'
Duplicate column name 'infected_spawn_3_nor'
Duplicate column name 'infected_spawn_3_adv'
Duplicate column name 'infected_spawn_3_exp'
Duplicate column name 'infected_spawn_4_nor'
Duplicate column name 'infected_spawn_4_adv'
Duplicate column name 'infected_spawn_4_exp'
Duplicate column name 'infected_spawn_5_nor'
Duplicate column name 'infected_spawn_5_adv'
Duplicate column name 'infected_spawn_5_exp'
Duplicate column name 'infected_spawn_6_nor'
Duplicate column name 'infected_spawn_6_adv'
Duplicate column name 'infected_spawn_6_exp'
Duplicate column name 'infected_spawn_8_nor'
Duplicate column name 'infected_spawn_8_adv'
Duplicate column name 'infected_spawn_8_exp'
Duplicate column name 'infected_hunter_pounce_counter_nor'
Duplicate column name 'infected_hunter_pounce_counter_adv'
Duplicate column name 'infected_hunter_pounce_counter_exp'
Duplicate column name 'infected_hunter_pounce_damage_nor'
Duplicate column name 'infected_hunter_pounce_damage_adv'
Duplicate column name 'infected_hunter_pounce_damage_exp'
Duplicate column name 'infected_tanksniper_nor'
Duplicate column name 'infected_tanksniper_adv'
Duplicate column name 'infected_tanksniper_exp'
Duplicate column name 'caralarm_nor'
Duplicate column name 'caralarm_adv'
Duplicate column name 'caralarm_exp'
Duplicate column name 'jockey_rides_nor'
Duplicate column name 'jockey_rides_adv'
Duplicate column name 'jockey_rides_exp'
Duplicate column name 'charger_impacts_nor'
Duplicate column name 'charger_impacts_adv'
Duplicate column name 'charger_impacts_exp'
Maps table altered successfully!
Maps table altered successfully!
Maps table altered successfully!
Duplicate entry 'l4d_airport01_greenhouse-0-' for key 'PRIMARY'
Duplicate entry 'l4d_airport02_offices-0-' for key 'PRIMARY'
Duplicate entry 'l4d_airport03_garage-0-' for key 'PRIMARY'
Duplicate entry 'l4d_airport04_terminal-0-' for key 'PRIMARY'
Duplicate entry 'l4d_airport05_runway-0-' for key 'PRIMARY'
Duplicate entry 'l4d_farm01_hilltop-0-' for key 'PRIMARY'
Duplicate entry 'l4d_farm02_traintunnel-0-' for key 'PRIMARY'
Duplicate entry 'l4d_farm03_bridge-0-' for key 'PRIMARY'
Duplicate entry 'l4d_farm04_barn-0-' for key 'PRIMARY'
Duplicate entry 'l4d_farm05_cornfield-0-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital01_apartment-0-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital02_subway-0-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital03_sewers-0-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital04_interior-0-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital05_rooftop-0-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown01_caves-0-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown02_drainage-0-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown03_ranchhouse-0-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown04_mainstreet-0-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown05_houseboat-0-' for key 'PRIMARY'
Duplicate entry 'l4d_garage01_alleys-0-' for key 'PRIMARY'
Duplicate entry 'l4d_garage02_lots-0-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport01_greenhouse-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport02_offices-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport03_garage-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport04_terminal-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport05_runway-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm01_hilltop-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm02_traintunnel-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm03_bridge-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm04_barn-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm05_cornfield-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital01_apartment-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital02_subway-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital03_sewers-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital04_interior-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital05_rooftop-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown01_caves-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown02_drainage-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown03_ranchhouse-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown04_mainstreet-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown05_houseboat-1-' for key 'PRIMARY'
Duplicate entry 'l4d_garage01_alleys-1-' for key 'PRIMARY'
Duplicate entry 'l4d_garage02_lots-1-' for key 'PRIMARY'
Duplicate entry 'l4d_airport01_greenhouse-3-' for key 'PRIMARY'
Duplicate entry 'l4d_airport02_offices-3-' for key 'PRIMARY'
Duplicate entry 'l4d_airport03_garage-3-' for key 'PRIMARY'
Duplicate entry 'l4d_airport04_terminal-3-' for key 'PRIMARY'
Duplicate entry 'l4d_airport05_runway-3-' for key 'PRIMARY'
Duplicate entry 'l4d_farm01_hilltop-3-' for key 'PRIMARY'
Duplicate entry 'l4d_farm02_traintunnel-3-' for key 'PRIMARY'
Duplicate entry 'l4d_farm03_bridge-3-' for key 'PRIMARY'
Duplicate entry 'l4d_farm04_barn-3-' for key 'PRIMARY'
Duplicate entry 'l4d_farm05_cornfield-3-' for key 'PRIMARY'
Duplicate entry 'l4d_garage01_alleys-3-' for key 'PRIMARY'
Duplicate entry 'l4d_garage02_lots-3-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital01_apartment-3-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital02_subway-3-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital03_sewers-3-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital04_interior-3-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital05_rooftop-3-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown01_caves-3-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown02_drainage-3-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown03_ranchhouse-3-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown04_mainstreet-3-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown05_houseboat-3-' for key 'PRIMARY'
Duplicate entry 'l4d_sv_lighthouse-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport01_greenhouse-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport02_offices-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport03_garage-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport04_terminal-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport05_runway-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm01_hilltop-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm02_traintunnel-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm03_bridge-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm04_barn-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm05_cornfield-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital01_apartment-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital02_subway-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital03_sewers-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital04_interior-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital05_rooftop-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown01_caves-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown02_drainage-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown03_ranchhouse-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown04_mainstreet-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown05_houseboat-3-' for key 'PRIMARY'
Timed Maps table altered successfully!
Timed Maps table altered successfully!
Timed Maps table altered

I know computer elite like you are very busy, but I really need your help! My English is very poor, I hope you can understand... thank you

Mitsuru · *Last edited by Mitsuru; 04-16-2014 at 12:43.*

Quote:

Originally Posted by muukis

You shouldn't use root as your connection user. If you insist on doing that, you must make sure root can make the connection from the web server. Also double check your password. Try connecting MySQL server using the console (want to know how - try google).

About the error messages from the compile. What did you do and how? I general, you should just download the precompiled version.

I know this post has already been a long time, can you help me have a look at my configuration?
Please give me the right advice
config.php
/ / MySQL information for L4D Stats DB
$mysql_server = "127.0.0.1";
$mysql_db = "sg52_l4d";
$mysql_user = "sg52_admin";
$mysql_password = "* * *";
$mysql_tableprefix = "";
Why is 127.0.0.1? Or add other,,,
$game_addresses [] = array (" server: Left 4 Dead ", "wanru.oicp.net: 27015");
Fill in the address of the server here what's the point? Dynamic IP domain name wanru.oicp.net is my explanation, is it right?
The databases. The CFG it wrong?
"l4dstats"
{
"driver" "mysql"
"host" "116.251.214.235"
"database" "sg52_l4d"
"user" "sg52_admin"
"pass" "tcgs250"
"port" "3306"
}
}

Create a table the PHP confidence appeared the following:

Quote:

Duplicate column name 'infected_spawn_8'
Duplicate column name 'lastgamemode'
Duplicate column name 'kill_spitter'
Duplicate column name 'kill_jockey'
Duplicate column name 'kill_charger'
Duplicate column name 'playtime_versus'
Duplicate column name 'playtime_realism'
Duplicate column name 'playtime_survival'
Duplicate column name 'playtime_scavenge'
Duplicate column name 'playtime_realismversus'
Duplicate column name 'points_survivors'
Duplicate column name 'points_infected'
Duplicate column name 'points_realism'
Duplicate column name 'points_scavenge_survivors'
Duplicate column name 'points_scavenge_infected'
Duplicate column name 'points_survival'
Duplicate column name 'points_realism_survivors'
Duplicate column name 'points_realism_infected'
Duplicate column name 'versus_kills_survivors'
Duplicate column name 'realism_kills_survivors'
Duplicate column name 'scavenge_kills_survivors'
Duplicate column name 'jockey_rides'
Duplicate column name 'award_pounce_perfect'
Duplicate column name 'award_pounce_nice'
Duplicate column name 'award_perfect_blindness'
Duplicate column name 'award_infected_win'
Duplicate column name 'award_scavenge_infected_win'
Duplicate column name 'award_bulldozer'
Duplicate column name 'award_survivor_down'
Duplicate column name 'award_ledgegrab'
Duplicate column name 'award_adrenaline'
Duplicate column name 'award_fincap'
Duplicate column name 'award_jockey'
Duplicate column name 'award_charger'
Duplicate column name 'award_defib'
Duplicate column name 'award_matador'
Duplicate column name 'award_witchcrowned'
Duplicate column name 'award_gascans_poured'
Duplicate column name 'award_upgrades_added'
Duplicate column name 'award_scatteringram'
Duplicate column name 'infected_spawn_1'
Duplicate column name 'infected_spawn_2'
Duplicate column name 'infected_spawn_3'
Duplicate column name 'infected_spawn_4'
Duplicate column name 'infected_spawn_5'
Duplicate column name 'infected_spawn_6'
Duplicate column name 'infected_spawn_8'
Duplicate column name 'infected_boomer_vomits'
Duplicate column name 'infected_boomer_blinded'
Duplicate column name 'infected_hunter_pounce_counter'
Duplicate column name 'infected_hunter_pounce_dmg'
Duplicate column name 'infected_smoker_damage'
Duplicate column name 'infected_spitter_damage'
Duplicate column name 'infected_jockey_damage'
Duplicate column name 'infected_jockey_ridetime'
Duplicate column name 'infected_charger_damage'
Duplicate column name 'infected_tank_damage'
Duplicate column name 'infected_tanksniper'
Duplicate column name 'ip'
Duplicate column name 'charger_impacts'
Duplicate column name 'melee_kills'
Players table altered successfully!
Players table altered successfully!
Players table altered successfully!
Unknown column 'versus' in 'maps'
Duplicate column name 'infected_spawn_8_nor'
Duplicate column name 'infected_spawn_8_adv'
Duplicate column name 'infected_spawn_8_exp'
Duplicate column name 'custom'
Duplicate column name 'gamemode'
Duplicate column name 'points_infected_nor'
Duplicate column name 'points_infected_adv'
Duplicate column name 'points_infected_exp'
Duplicate column name 'survivor_kills_nor'
Duplicate column name 'survivor_kills_adv'
Duplicate column name 'survivor_kills_exp'
Duplicate column name 'infected_win_nor'
Duplicate column name 'infected_win_adv'
Duplicate column name 'infected_win_exp'
Duplicate column name 'survivors_win_nor'
Duplicate column name 'survivors_win_adv'
Duplicate column name 'survivors_win_exp'
Duplicate column name 'infected_smoker_damage_nor'
Duplicate column name 'infected_smoker_damage_adv'
Duplicate column name 'infected_smoker_damage_exp'
Duplicate column name 'infected_jockey_damage_nor'
Duplicate column name 'infected_jockey_damage_adv'
Duplicate column name 'infected_jockey_damage_exp'
Duplicate column name 'infected_jockey_ridetime_nor'
Duplicate column name 'infected_jockey_ridetime_adv'
Duplicate column name 'infected_jockey_ridetime_exp'
Duplicate column name 'infected_charger_damage_nor'
Duplicate column name 'infected_charger_damage_adv'
Duplicate column name 'infected_charger_damage_exp'
Duplicate column name 'infected_spitter_damage_nor'
Duplicate column name 'infected_spitter_damage_adv'
Duplicate column name 'infected_spitter_damage_exp'
Duplicate column name 'infected_tank_damage_nor'
Duplicate column name 'infected_tank_damage_adv'
Duplicate column name 'infected_tank_damage_exp'
Duplicate column name 'infected_boomer_vomits_nor'
Duplicate column name 'infected_boomer_vomits_adv'
Duplicate column name 'infected_boomer_vomits_exp'
Duplicate column name 'infected_boomer_blinded_nor'
Duplicate column name 'infected_boomer_blinded_adv'
Duplicate column name 'infected_boomer_blinded_exp'
Duplicate column name 'infected_spawn_1_nor'
Duplicate column name 'infected_spawn_1_adv'
Duplicate column name 'infected_spawn_1_exp'
Duplicate column name 'infected_spawn_2_nor'
Duplicate column name 'infected_spawn_2_adv'
Duplicate column name 'infected_spawn_2_exp'
Duplicate column name 'infected_spawn_3_nor'
Duplicate column name 'infected_spawn_3_adv'
Duplicate column name 'infected_spawn_3_exp'
Duplicate column name 'infected_spawn_4_nor'
Duplicate column name 'infected_spawn_4_adv'
Duplicate column name 'infected_spawn_4_exp'
Duplicate column name 'infected_spawn_5_nor'
Duplicate column name 'infected_spawn_5_adv'
Duplicate column name 'infected_spawn_5_exp'
Duplicate column name 'infected_spawn_6_nor'
Duplicate column name 'infected_spawn_6_adv'
Duplicate column name 'infected_spawn_6_exp'
Duplicate column name 'infected_spawn_8_nor'
Duplicate column name 'infected_spawn_8_adv'
Duplicate column name 'infected_spawn_8_exp'
Duplicate column name 'infected_hunter_pounce_counter_nor'
Duplicate column name 'infected_hunter_pounce_counter_adv'
Duplicate column name 'infected_hunter_pounce_counter_exp'
Duplicate column name 'infected_hunter_pounce_damage_nor'
Duplicate column name 'infected_hunter_pounce_damage_adv'
Duplicate column name 'infected_hunter_pounce_damage_exp'
Duplicate column name 'infected_tanksniper_nor'
Duplicate column name 'infected_tanksniper_adv'
Duplicate column name 'infected_tanksniper_exp'
Duplicate column name 'caralarm_nor'
Duplicate column name 'caralarm_adv'
Duplicate column name 'caralarm_exp'
Duplicate column name 'jockey_rides_nor'
Duplicate column name 'jockey_rides_adv'
Duplicate column name 'jockey_rides_exp'
Duplicate column name 'charger_impacts_nor'
Duplicate column name 'charger_impacts_adv'
Duplicate column name 'charger_impacts_exp'
Maps table altered successfully!
Maps table altered successfully!
Maps table altered successfully!
Duplicate entry 'l4d_airport01_greenhouse-0-' for key 'PRIMARY'
Duplicate entry 'l4d_airport02_offices-0-' for key 'PRIMARY'
Duplicate entry 'l4d_airport03_garage-0-' for key 'PRIMARY'
Duplicate entry 'l4d_airport04_terminal-0-' for key 'PRIMARY'
Duplicate entry 'l4d_airport05_runway-0-' for key 'PRIMARY'
Duplicate entry 'l4d_farm01_hilltop-0-' for key 'PRIMARY'
Duplicate entry 'l4d_farm02_traintunnel-0-' for key 'PRIMARY'
Duplicate entry 'l4d_farm03_bridge-0-' for key 'PRIMARY'
Duplicate entry 'l4d_farm04_barn-0-' for key 'PRIMARY'
Duplicate entry 'l4d_farm05_cornfield-0-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital01_apartment-0-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital02_subway-0-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital03_sewers-0-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital04_interior-0-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital05_rooftop-0-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown01_caves-0-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown02_drainage-0-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown03_ranchhouse-0-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown04_mainstreet-0-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown05_houseboat-0-' for key 'PRIMARY'
Duplicate entry 'l4d_garage01_alleys-0-' for key 'PRIMARY'
Duplicate entry 'l4d_garage02_lots-0-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport01_greenhouse-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport02_offices-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport03_garage-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport04_terminal-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport05_runway-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm01_hilltop-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm02_traintunnel-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm03_bridge-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm04_barn-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm05_cornfield-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital01_apartment-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital02_subway-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital03_sewers-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital04_interior-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital05_rooftop-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown01_caves-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown02_drainage-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown03_ranchhouse-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown04_mainstreet-1-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown05_houseboat-1-' for key 'PRIMARY'
Duplicate entry 'l4d_garage01_alleys-1-' for key 'PRIMARY'
Duplicate entry 'l4d_garage02_lots-1-' for key 'PRIMARY'
Duplicate entry 'l4d_airport01_greenhouse-3-' for key 'PRIMARY'
Duplicate entry 'l4d_airport02_offices-3-' for key 'PRIMARY'
Duplicate entry 'l4d_airport03_garage-3-' for key 'PRIMARY'
Duplicate entry 'l4d_airport04_terminal-3-' for key 'PRIMARY'
Duplicate entry 'l4d_airport05_runway-3-' for key 'PRIMARY'
Duplicate entry 'l4d_farm01_hilltop-3-' for key 'PRIMARY'
Duplicate entry 'l4d_farm02_traintunnel-3-' for key 'PRIMARY'
Duplicate entry 'l4d_farm03_bridge-3-' for key 'PRIMARY'
Duplicate entry 'l4d_farm04_barn-3-' for key 'PRIMARY'
Duplicate entry 'l4d_farm05_cornfield-3-' for key 'PRIMARY'
Duplicate entry 'l4d_garage01_alleys-3-' for key 'PRIMARY'
Duplicate entry 'l4d_garage02_lots-3-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital01_apartment-3-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital02_subway-3-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital03_sewers-3-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital04_interior-3-' for key 'PRIMARY'
Duplicate entry 'l4d_hospital05_rooftop-3-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown01_caves-3-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown02_drainage-3-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown03_ranchhouse-3-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown04_mainstreet-3-' for key 'PRIMARY'
Duplicate entry 'l4d_smalltown05_houseboat-3-' for key 'PRIMARY'
Duplicate entry 'l4d_sv_lighthouse-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport01_greenhouse-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport02_offices-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport03_garage-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport04_terminal-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_airport05_runway-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm01_hilltop-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm02_traintunnel-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm03_bridge-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm04_barn-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_farm05_cornfield-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital01_apartment-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital02_subway-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital03_sewers-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital04_interior-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_hospital05_rooftop-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown01_caves-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown02_drainage-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown03_ranchhouse-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown04_mainstreet-3-' for key 'PRIMARY'
Duplicate entry 'l4d_vs_smalltown05_houseboat-3-' for key 'PRIMARY'
Timed Maps table altered successfully!
Timed Maps table altered successfully!
Timed Maps table altered

I open SRCDS server connection tip: is creating the game"
I know computer elite like you are very busy

, but I really need your help! My English is very poor, I hope you can understand... thank you

muukis · 04-17-2014 , 01:59 Re: [L4D & L4D2] Custom Player Stats v1.4B46

Quote:

Originally Posted by Mitsuru

can you help me have a look at my configuration?
Please give me the right advice
config.php
/ / MySQL information for L4D Stats DB
$mysql_server = "127.0.0.1";
$mysql_db = "sg52_l4d";
$mysql_user = "sg52_admin";
$mysql_password = "* * *";
$mysql_tableprefix = "";
Why is 127.0.0.1? Or add other,,,

Your config look good in these parts. You can change the MySQL server value to what ever is valid IP and your web server has access to it. Not sure, but you may even enter a hostname istead of IP?

Quote:

Originally Posted by Mitsuru

$game_addresses [] = array (" server: Left 4 Dead ", "wanru.oicp.net: 27015");
Fill in the address of the server here what's the point? Dynamic IP domain name wanru.oicp.net is my explanation, is it right?

Correct. This is the link on your web site which a player can click and join the game. It will create a link to your game. If you have more than one game server using the same stats, you may enter multiple addresses. Play with it and see what it does to your web site.

Quote:

Originally Posted by Mitsuru

The databases. The CFG it wrong?
"L4dstats"
{
"Driver" "mysql"
"The host" "116.251.214.235"
"Database" "sg52_l4d"
"User" "sg52_admin"
"Pass" "* * *"
"Port" "3306"
Create a table the PHP confidence appeared the following:
"l4dstats"
{
"driver" "mysql"
"host" "116.251.214.235"
"database" "sg52_l4d"
"user" "sg52_admin"
"pass" "***"
"port" "3306"

Looks good. Your game server must have access to your MySQL server for this to work. User sg52_l4d must be able to access host 116.251.214.235 with port 3306 from your game server IP.

Quote:

Originally Posted by Mitsuru

创建表install.php出现以下信心：

???

Quote:

Originally Posted by Mitsuru

I really need your help! My English is very poor, I hope you can understand... thank you

This can be overwhelming for some, but there is no easy way to do it. There are no simple "one click" installation methods which you can follow. And it is very difficult or impossible to generate a guide that covers all installation types, servers, services, different versions and with all IPS´. That is why the guide is generic and the user must have at least basic understanding of the services the stats uses. It would be a lot easier for us, if you could lend a hand of a person that can speak your language, because I'm not sure I can assist you much further. I will try if you want, but it might not lead to a successful working stats system for you.

Mitsuru · *Last edited by Mitsuru; 04-17-2014 at 11:49.*

My game server connected to the web host the mysql database is successful, rankmenu menu also showed normal, and a map to play one hour why web information without any data?
\ sourcemod \ logs without any error message
http://l4dsk.tk/

Mitsuru · *Last edited by Mitsuru; 04-18-2014 at 12:19.*

Quote:

Originally Posted by EEdover

Hi again,

Thank You Muukis for providing support for this plugin.
I hope that following makes your job easier in future, and You can refer to this post.
For starters I was abele to get the plugin running.
Now some tips for future.

1. ALWAYS check your configs
Even if your game server and web server provider is same. There could be 3 servers involved in process 1) webserver, 2)MySql server, 3) gameserver.
Most important is to find out if webserver and MySql servers are different from game server.
At my case there was OK to use host value "localhost" in config.php file but in databases.cfg "localhost" does not work 99% occasions.
So databases.cfg file must contain MySql server address(NOT WEBSERVER address)they can be, and most likely are different from webserver address.

2. If you can get Your MySql database connected to webserver and not to gameserver then first check your configs at databases.cfg.
If You are convinced that configs are correct check your MySql database tables.
Check that there wasn´t some strange prefixes on your tables names.
Ex. utf8players etc... Tables should be without prefixes.

3. Make sure that Your MySql database allows external connections(from your gameserver)

4. Check, check, check and never give up. That plugin works. It´s all about configs.

For me it took lot of hours to get it running. Lot´s of googleing, forums surfing, mindf-ing, service providers mindf-ing, drinking, smoking, pointing gun on my head etc...
I´ve done it so I am convinced that You can do it too.

Check everything is correct, my game successfully connect to the remote mysql server, mysql no table prefix also do not need to fill in the table prefix. Addons \ sourcemod \ logs without any error messages, no plug-in error information. Rankmenu, etc... All plug-in menu is normal.
Sm_cvar l4d_stats_minhumans 1
But still no statistics, only 00000.... Is always zero
http://l4dsk.tk/
I really don't know what else to do, I tried for so long, so give up???????