[Powerlord]

A long time ago, psychonic wrote a plugin named HLstatsX:CE SQL API (hlxce-sm-api.sp and include/hlxce-sm-api.inc).

However, the only record I can find of it is in Goerge's github google code archive... Goerge wrote the TF2 GScramble plugin with support for it.

What happened to it?

If it's gone for good, is there some sort of replacement for it?

[DoPe^]

I did find one here tho.
https://code.google.com/p/tf2tmng/so...se/trunk/?r=67
is that the one?

[Powerlord]

Originally Posted by DoPe^ I did find one here tho. https://code.google.com/p/tf2tmng/so...se/trunk/?r=67 is that the one?

That's Goerge's Google Code archive, yes. Whoops, I said Github before... meant Google Code.

Anyway, it used to be in the official HLStatsX:CE Bitbucket a long time ago, but it seems to have vanished now. Since this plugin is at least 4 years old, I can't tell if it even works any more (I don't run HLStatsX CE) but I know users of GScramble want HLStatsX support.

[DoPe^]

Originally Posted by Powerlord That's Goerge's Google Code archive, yes. Whoops, I said Github before... meant Google Code. Anyway, it used to be in the official HLStatsX:CE Bitbucket a long time ago, but it seems to have vanished now. Since this plugin is at least 4 years old, I can't tell if it even works any more (I don't run HLStatsX CE) but I know users of GScramble want HLStatsX support.

I am testing it at the moment.
But it has issues when the server changes map, it then loses the connection to the database and can't connect again.
I've seen somewhere that loading the plugin with a delay after the map changes, should fix the issue.

Edit:
but it does seem to work when it loads.

L 07/08/2014 - 18:07:46: [gscramble.smx] HlxCe Available L 07/08/2014 - 18:07:46: [gscramble.smx] GameMe Unavailavble L 07/08/2014 - 18:07:46: [gscramble.smx] set mp_autoteambalance to false L 07/08/2014 - 18:07:46: [gscramble.smx] Hooking events. L 07/08/2014 - 18:07:46: [gscramble.smx] Setting mp_scrambleteams_auto false

else it spits out these errors on map change

L 07/08/2014 - 17:40:49: [SM] Plugin encountered error 25: Call was aborted L 07/08/2014 - 17:40:49: [SM] Native "SetFailState" reported: Cannot connect to database L 07/08/2014 - 17:40:49: [SM] Displaying call stack trace for plugin "hlxce-sm-api.smx": L 07/08/2014 - 17:40:49: [SM] [0] Line 112, C:\Users\Mikkel\Desktop\hlxce-sm-api.sp::OnConnectedToDatabase()

L 07/08/2014 - 18:10:46: [SM] Plugin encountered error 25: Call was aborted L 07/08/2014 - 18:10:46: [SM] Native "SetFailState" reported: Lost database connection L 07/08/2014 - 18:10:46: [SM] Displaying call stack trace for plugin "hlxce-sm-api.smx": L 07/08/2014 - 18:10:46: [SM] [0] Line 257, C:\Users\Mikkel\Desktop\hlxce-sm-api.sp::GetClientHLXPlayerId() L 07/08/2014 - 18:10:46: [SM] [1] Line 235, C:\Users\Mikkel\Desktop\hlxce-sm-api.sp::OnClientPostAdminCheck() L 07/08/2014 - 20:10:55: Error log file session closed.

Edit 2:
I think I fixed it.
I have attached the plugin

add this to databases.cfg

PHP Code:

    "hlxce"
    {
        "driver"        "mysql"
        "host"            "host ip"
        "database"        "database name"
        "user"            "database username"
        "pass"            "database password"
        "port"            "3306"
    } 


[Kammi_]

can anyone fix this plugin?

sm plugins list

         Load Errors:
         HLstatsX:CE SQL API for Sourcemod: Lost database connection

error log

L 09/03/2016 - 16:36:39: [SM] Displaying call stack trace for plugin "hlxce-sm-api.smx":
L 09/03/2016 - 16:36:39: [SM]   [0]  Line 268, /home/forums/content/files/4/0/1/7/5/135414.attach::GetClientHLXPlayerId()
L 09/03/2016 - 16:36:39: [SM]   [1]  Line 246, /home/forums/content/files/4/0/1/7/5/135414.attach::OnClientPostAdminCheck()
L 09/03/2016 - 16:36:40: [SM] Native "GetArraySize" reported: Invalid Handle 0 (error: 4)

database.cfg

{
    "driver_default"        "mysql"
    
    // When specifying "host", you may use an IP address, a hostname, or a socket file path
    
    "default"
    {
        "driver"            "default"
        "host"                "localhost"
        "database"            "sourcemod"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
    
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }

    "clientprefs"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }

    "gamevoting"
    {
            "driver"    "sqlite"
                "database"  "gamevoting-local"
    }
    
    "sourcebans"
    {
        "driver"            "default"
        "host"                "localhost"
        "database"            "sourceban"
        "user"                "sourceban"
        "pass"                "xxxxxxxxx"
        //"timeout"            "0"
        "port"            "3306"
    }
"warn"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
   "hlxce"
    {
        "driver"        "mysql"
        "host"            "127.0.0.1"
        "database"        "hlx"
        "user"            "hlx"
        "pass"            "xxxxxxxxxx"
        "port"            "3306"
    }  
}

[TrappaTroopa]

Originally Posted by Fukki Si Works fine on my linux host. Windows is having some problems though. Load Errors: HLstatsX:CE SQL API for Sourcemod: Game code query failed (not found)

Is this even needed anymore? Isn't built into the Normal Plugin or the daemon Now? Or does this provide additional functionality that I am unaware of?