[kwski43]

Can we move Geo DB in mysql to other db?
I got problems when backuping large db, backuping this data is pointless.

[muukis]

Originally Posted by kwski43 Can we move Geo DB in mysql to other db? I got problems when backuping large db, backuping this data is pointless.

Yes we can... I'll try to do something in the next update. Though you should be able to take table specific backups, shouldn't you?

About the other thing you had problems with, check your player.php. Is it missing the statscombobox.js set? My web site is working correctly.

[kwski43]

Yes, I fixed it already.

[mrnatural]

note you must have a windows server for this code to work. it dont work on linux servers.

[muukis]

Originally Posted by mrnatural note you must have a windows server for this code to work. it dont work on linux servers.

Could you please explain? What does not work in linux servers? Surely the plugin works in any system? Why wouldn't the PHP-scripts work in the Linux?

Just because you were having problems with some rented servers doesn't mean this code requires windows to work.

[waka-waka]

Edit #2: I'm an idiot and this post can be disregarded. I updated the webstats and MySQL table and all seems well now.

I'm having trouble upgrading to the most recent version of the plugin on my L4D2 server.

Here's the most recent sourcemod error log:

L 02/22/2010 - 15:26:02: SourceMod error session started
L 02/22/2010 - 15:26:02: Info (map "c1m1_hotel") (file "errors_20100222.log")
L 02/22/2010 - 15:26:02: [SM] Native "PrintToConsole" reported: Client index 7667827 is invalid
L 02/22/2010 - 15:26:02: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 02/22/2010 - 15:26:02: [SM]   [0]  Line 5960, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::DoFastQuery()
L 02/22/2010 - 15:26:02: [SM]   [1]  Line 1354, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::ConnectDB()
L 02/22/2010 - 15:26:02: [SM]   [2]  Line 564, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart()
L 02/22/2010 - 15:26:11: Error log file session closed.

Here's the plugins I currently have in use.

[SM] Listing 23 plugins:
  01 Disabled: "Nextmap" (1.3.1) by AlliedModders LLC
  02 "CD Announcer" (2.3) by Fredd
  03 "Admin File Reader" (1.3.1) by AlliedModders LLC
  04 "Sound Commands" (1.3.1) by AlliedModders LLC
  05 "Fun Commands" (1.3.1) by AlliedModders LLC
  06 "Reserved Slots" (1.3.1) by AlliedModders LLC
  07 "SourceBans" (1.4.6) by InterWave Studios Development Team
  08 "L4D Vote Manager 2" (1.5.5) by Madcap
  09 <Error> "Custom Player Stats" (1.4B66) by Mikko Andersson (muukis)
  10 "L4D Black and White Notifier" (1.31) by DarkNoghri, madcap
  11 "Basic Chat" (1.3.1) by AlliedModders LLC
  12 "L4D FF Announce Plugin" (1.4) by Frustian
  13 "Player Commands" (1.3.1) by AlliedModders LLC
  14 "Vocalize Fatigue" (1.2c) by Mr. Zero
  15 "Anti-Flood" (1.3.1) by AlliedModders LLC
  16 "Admin Help" (1.3.1) by AlliedModders LLC
  17 "Fun Votes" (1.3.1) by AlliedModders LLC
  18 "Admin Menu" (1.3.1) by AlliedModders LLC
  19 "Basic Commands" (1.3.1) by AlliedModders LLC
  20 "Basic Votes" (1.3.1) by AlliedModders LLC
  21 "Basic Info Triggers" (1.3.1) by AlliedModders LLC
  22 "Client Preferences" (1.3.1) by AlliedModders LLC
  23 "Basic Comm Control" (1.3.1) by AlliedModders LLC
Load Errors:
Custom Player Stats: Error detected in plugin startup (see error logs)

All I changed was the l4d_stats.smx plugin and added the l4d_stats.txt file, which was missing previously. I haven't updated the webstats yet or the database.


The old version of the plugin that I'm upgrading from on my L4D 1 server still works fine. Both game servers and the MySQL server are on the same machine.


Edit: I also see this near the end of the server's start up. I'm not sure if it is relevant.

commandline.cpp (628) : Assertion Failed: (nIndex >= 0) && (nIndex < m_nParmCount)
commandline.cpp (628) : Assertion Failed: (nIndex >= 0) && (nIndex < m_nParmCount)
baseuser.cpp (313) : Assertion Failed: couldn't find entrypoint 'GetBaseUserDir'
baseuser.cpp (313) : Assertion Failed: couldn't find entrypoint 'GetBaseUserDir'
baseuser.cpp (313) : Assertion Failed: couldn't find entrypoint 'GetBaseUserDir'
baseuser.cpp (313) : Assertion Failed: couldn't find entrypoint 'GetBaseUserDir'
baseuser.cpp (313) : Assertion Failed: couldn't find entrypoint 'GetBaseUserDir'
baseuser.cpp (313) : Assertion Failed: couldn't find entrypoint 'GetBaseUserDir'
Adding master server 72.165.61.189:27011
Adding master server 72.165.61.136:27015

[muukis]

Originally Posted by waka-waka Edit #2: I'm an idiot and this post can be disregarded. I updated the webstats and MySQL table and all seems well now. I'm having trouble upgrading to the most recent version of the plugin on my L4D2 server. Here's the most recent sourcemod error log: L 02/22/2010 - 15:26:02: SourceMod error session started L 02/22/2010 - 15:26:02: Info (map "c1m1_hotel") (file "errors_20100222.log") L 02/22/2010 - 15:26:02: [SM] Native "PrintToConsole" reported: Client index 7667827 is invalid L 02/22/2010 - 15:26:02: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 02/22/2010 - 15:26:02: [SM] [0] Line 5960, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::DoFastQuery() L 02/22/2010 - 15:26:02: [SM] [1] Line 1354, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::ConnectDB() L 02/22/2010 - 15:26:02: [SM] [2] Line 564, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart() L 02/22/2010 - 15:26:11: Error log file session closed.

It's bugged, but you should not get that message if your tables are correctly created. I will be fixed in the next release.

[waka-waka]

Originally Posted by muukis It's bugged, but you should not get that message if your tables are correctly created. I will be fixed in the next release.

It seems my problem was that the database was too old for the newest plugin version. Everything is fine now, updated all four servers with the plugin and the web stats to the latest.

Originally Posted by mrnatural note you must have a windows server for this code to work. it dont work on linux servers.

Not sure I understand this. My two dedicated servers are both 64 bit CentOS and run this plugin and the web interface fine.

[ddxsamx]

Okay guys, I have tried absolutely everything without any luck.

I have my web server and database running, with the stats working in-game.
However, I can't figure out why my webpage doesn't load properly?
http://ddxsamx.com/stats
I am using XAMPP.

Thanks.

[muukis]

Originally Posted by ddxsamx I have my web server and database running, with the stats working in-game. However, I can't figure out why my webpage doesn't load properly? http://ddxsamx.com/stats I am using XAMPP.

https://forums.alliedmods.net/showth...56#post1079256

Not sure how you do this in XAMPP.

EDIT: If you are unable to set the short tags on, wait for the next release. I will convert them to normal tags.