Top 10 Player HlstatsCE Announcer - Page 5

sinblaster · 10-05-2011 , 05:49 Re: Top 10 Player HlstatsCE Announcer

hi Snelvuur.

I have placed in my database.

Code:

    "top10"
        {
"driver"            "default"
        "host"                "203.98.xx.xx"
        "database"            "hlstatsu_dbase"
        "user"                "hlstatsu_user"
        "pass"                "PASSWORD"
    }

As per my game names (pic below) in server.cfg
I have placed

Code:

//TOP 10 ANNOUNCER
// location of the sound (do not include the first initial sound folder)
sm_top10_sound "necro/top10player.mp3" 

// gametype, default is set to "tf"  adjust per server game name
sm_top10_game "necro2"

// Location off message. 1 = Center (default), 2 = Hint text, 3 = Regular text.
sm_top10_text "1"

sinblaster · 10-05-2011 , 12:33 Re: Top 10 Player HlstatsCE Announcer

I have triple checked everything, its still totally spamming the errors. Can you think of anything that may conflict? What is error 4?

Code:

L 10/06/2011 - 03:30:13: SourceMod error session started
L 10/06/2011 - 03:30:13: Info (map "de_dust2_unlimited") (file "errors_20111006.log")
L 10/06/2011 - 03:30:13: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 10/06/2011 - 03:30:13: [SM] Displaying call stack trace for plugin "top10hlxce-announce.smx":
L 10/06/2011 - 03:30:13: [SM]   [0]  Line 84, top10hlxce-announce.sp::CheckTop10()
L 10/06/2011 - 03:30:13: [SM]   [1]  Line 101, top10hlxce-announce.sp::OnClientPostAdminCheck()
L 10/06/2011 - 03:30:13: Error log file session closed.
L 10/06/2011 - 03:30:14: SourceMod error session started
L 10/06/2011 - 03:30:14: Info (map "de_dust2_unlimited") (file "errors_20111006.log")
L 10/06/2011 - 03:30:14: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 10/06/2011 - 03:30:14: [SM] Displaying call stack trace for plugin "top10hlxce-announce.smx":
L 10/06/2011 - 03:30:14: [SM]   [0]  Line 84, top10hlxce-announce.sp::CheckTop10()
L 10/06/2011 - 03:30:14: [SM]   [1]  Line 101, top10hlxce-announce.sp::OnClientPostAdminCheck()
L 10/06/2011 - 03:30:14: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 10/06/2011 - 03:30:14: [SM] Displaying call stack trace for plugin "top10hlxce-announce.smx":
L 10/06/2011 - 03:30:14: [SM]   [0]  Line 84, top10hlxce-announce.sp::CheckTop10()
L 10/06/2011 - 03:30:14: [SM]   [1]  Line 101, top10hlxce-announce.sp::OnClientPostAdminCheck()
L 10/06/2011 - 03:30:14: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 10/06/2011 - 03:30:14: [SM] Displaying call stack trace for plugin "top10hlxce-announce.smx":
L 10/06/2011 - 03:30:14: [SM]   [0]  Line 84, top10hlxce-announce.sp::CheckTop10()
L 10/06/2011 - 03:30:14: [SM]   [1]  Line 101, top10hlxce-announce.sp::OnClientPostAdminCheck()
L 10/06/2011 - 03:30:14: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 10/06/2011 - 03:30:14: [SM] Displaying call stack trace for plugin "top10hlxce-announce.smx":
L 10/06/2011 - 03:30:14: [SM]   [0]  Line 84, top10hlxce-announce.sp::CheckTop10()
L 10/06/2011 - 03:30:14: [SM]   [1]  Line 101, top10hlxce-announce.sp::OnClientPostAdminCheck()
L 10/06/2011 - 03:30:14: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 10/06/2011 - 03:30:14: [SM] Displaying call stack trace for plugin "top10hlxce-announce.smx":
L 10/06/2011 - 03:30:14: [SM]   [0]  Line 84, top10hlxce-announce.sp::CheckTop10()
L 10/06/2011 - 03:30:14: [SM]   [1]  Line 101, top10hlxce-announce.sp::OnClientPostAdminCheck()
L 10/06/2011 - 03:30:14: [smerrormail.smx] Sendmail already in progress
L 10/06/2011 - 03:30:15: Error log file session closed.

Shit on shoe · 10-05-2011 , 14:46 Re: Top 10 Player HlstatsCE Announcer

hello!

this works only for HlstatsX CE ?
I use GameMe , this will works too ?

lokizito · 10-09-2011 , 22:03 Re: Top 10 Player HlstatsCE Announcer

Quote:

Originally Posted by sinblaster

I have triple checked everything, its still totally spamming the errors. Can you think of anything that may conflict? What is error 4?

Code:

L 10/06/2011 - 03:30:13: SourceMod error session started
L 10/06/2011 - 03:30:13: Info (map "de_dust2_unlimited") (file "errors_20111006.log")
L 10/06/2011 - 03:30:13: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 10/06/2011 - 03:30:13: [SM] Displaying call stack trace for plugin "top10hlxce-announce.smx":
L 10/06/2011 - 03:30:13: [SM]   [0]  Line 84, top10hlxce-announce.sp::CheckTop10()
L 10/06/2011 - 03:30:13: [SM]   [1]  Line 101, top10hlxce-announce.sp::OnClientPostAdminCheck()
L 10/06/2011 - 03:30:13: Error log file session closed.
L 10/06/2011 - 03:30:14: SourceMod error session started
L 10/06/2011 - 03:30:14: Info (map "de_dust2_unlimited") (file "errors_20111006.log")
L 10/06/2011 - 03:30:14: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 10/06/2011 - 03:30:14: [SM] Displaying call stack trace for plugin "top10hlxce-announce.smx":
L 10/06/2011 - 03:30:14: [SM]   [0]  Line 84, top10hlxce-announce.sp::CheckTop10()
L 10/06/2011 - 03:30:14: [SM]   [1]  Line 101, top10hlxce-announce.sp::OnClientPostAdminCheck()
L 10/06/2011 - 03:30:14: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 10/06/2011 - 03:30:14: [SM] Displaying call stack trace for plugin "top10hlxce-announce.smx":
L 10/06/2011 - 03:30:14: [SM]   [0]  Line 84, top10hlxce-announce.sp::CheckTop10()
L 10/06/2011 - 03:30:14: [SM]   [1]  Line 101, top10hlxce-announce.sp::OnClientPostAdminCheck()
L 10/06/2011 - 03:30:14: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 10/06/2011 - 03:30:14: [SM] Displaying call stack trace for plugin "top10hlxce-announce.smx":
L 10/06/2011 - 03:30:14: [SM]   [0]  Line 84, top10hlxce-announce.sp::CheckTop10()
L 10/06/2011 - 03:30:14: [SM]   [1]  Line 101, top10hlxce-announce.sp::OnClientPostAdminCheck()
L 10/06/2011 - 03:30:14: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 10/06/2011 - 03:30:14: [SM] Displaying call stack trace for plugin "top10hlxce-announce.smx":
L 10/06/2011 - 03:30:14: [SM]   [0]  Line 84, top10hlxce-announce.sp::CheckTop10()
L 10/06/2011 - 03:30:14: [SM]   [1]  Line 101, top10hlxce-announce.sp::OnClientPostAdminCheck()
L 10/06/2011 - 03:30:14: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 10/06/2011 - 03:30:14: [SM] Displaying call stack trace for plugin "top10hlxce-announce.smx":
L 10/06/2011 - 03:30:14: [SM]   [0]  Line 84, top10hlxce-announce.sp::CheckTop10()
L 10/06/2011 - 03:30:14: [SM]   [1]  Line 101, top10hlxce-announce.sp::OnClientPostAdminCheck()
L 10/06/2011 - 03:30:14: [smerrormail.smx] Sendmail already in progress
L 10/06/2011 - 03:30:15: Error log file session closed.

This errors are because for some reason, the plugin isn't connected to the database.
The default driver set is mysql?
Just to be sure switch:

Code:

"driver"            "default"

to

Code:

"driver"            "mysql"

Does the MySQL server accept outcoming connections?

sinblaster · 10-10-2011 , 02:07 Re: Top 10 Player HlstatsCE Announcer

Hi thanks for replying. yes the "default" was changed to mysql before I got the above errors.
My web server allows incoming and outgoing, I run hlstatsx:ce and sourcebans, I also host sourcebans for other game communities, never have a problem.

It had to be a conflict obviously, I removed this plugin. Again I appreciate your help though

snelvuur · 10-10-2011 , 02:31 Re: Top 10 Player HlstatsCE Announcer

Are you running linux? If so can you do a "vi -b <file>" and see if there are any strange characters near your top10 config in the databases.cfg, since your config looks fine to me.

sinblaster · 10-10-2011 , 05:09 Re: Top 10 Player HlstatsCE Announcer

Quote:

Originally Posted by snelvuur

Are you running linux? If so can you do a "vi -b <file>" and see if there are any strange characters near your top10 config in the databases.cfg, since your config looks fine to me.

hahah thanks for the suggestion, i could if I knew what the hell I was doing, I have a linux web server yes, do I know what I am doing or how to manage it? No.

snelvuur · 10-10-2011 , 05:33 Re: Top 10 Player HlstatsCE Announcer

Ok, then just edit the file again, remove the top10. Edit it manually to the config and upload again to the box.

I've seen this happen, very uncommen.. but i dont know what else could be wrong on your end.

Falco · 10-10-2011 , 18:07 Re: Top 10 Player HlstatsCE Announcer

I'm also having the same error as Sinblaster. Tried all the above suggestions but still no go.

Win Server 2008R2

snelvuur · 10-11-2011 , 18:29 Re: Top 10 Player HlstatsCE Announcer

I'll see if i have some time to add a version with some more logging, but since my gf is overdue (as in child was suppose to be born last friday) i am a bit busy..