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