AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   sqlload_id() :: Connect Error: (https://forums.alliedmods.net/showthread.php?t=192463)

CS-A-Roland 08-10-2012 13:21

sqlload_id() :: Connect Error:
 
Hey there...


again a Problem, and i think this time it's a Bot problem. I saving data to a database by STEAM_ID, and all works fine for players. But if the map starts after a mapchange my bots connect and i get errors like this here:

Quote:

L 08/10/2012 - 09:09:43: [wowmod.amxx] [WowMOD] Client [1] connected... ( Player account )
L 08/10/2012 - 09:09:43: [wowmod.amxx] [WowMOD] Client [3] connected... ( Player account )
L 08/10/2012 - 09:09:43: [wowmod.amxx] WowMOD SQL :: sqlload_id() :: Connect Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 08/10/2012 - 09:09:44: [amxbans_main.amxx] [AMXBans] AMXBans 6.0.0 ist online
L 08/10/2012 - 09:09:44: [wowmod.amxx] WowMOD SQL :: sqlload_id() :: Connect Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 08/10/2012 - 09:09:44: [wowmod.amxx] [WowMOD] Client [4] connected... ( Player account )
L 08/10/2012 - 09:09:44: [wowmod.amxx] WowMOD SQL :: sqlload_id() :: Connect Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 08/10/2012 - 09:09:44: [wowmod.amxx] [WowMOD] CLEANUP: Removing task id [200]
L 08/10/2012 - 09:09:44: [amxbans_main.amxx] [AMXBans] Keine Gruende in der Datenbank gefunden. Statische Gruende wurden statt dessen geladen
L 08/10/2012 - 09:09:44: [wowmod.amxx] WowMOD SQL :: sqlload_id() :: Connect Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 08/10/2012 - 09:09:44: [wowmod.amxx] [WowMOD] Client [5] connected... ( Player account )
L 08/10/2012 - 09:09:44: [wowmod.amxx] WowMOD SQL :: Loading Configuration File...
L 08/10/2012 - 09:09:44: [wowmod.amxx] WowMOD SQL :: Configuration File Loaded [OK]
L 08/10/2012 - 09:09:44: [wowmod.amxx] WowMOD SQL :: sqlload_id() :: Connect Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 08/10/2012 - 09:09:44: [wowmod.amxx] [WowMOD] CLEANUP: Removing task id [200]
L 08/10/2012 - 09:09:44: [wowmod.amxx] WowMOD SQL :: sqlload_id() :: Connect Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 08/10/2012 - 09:09:44: [wowmod.amxx] [WowMOD] Client [6] connected... ( Player account )
L 08/10/2012 - 09:09:44: [wowmod.amxx] WowMOD SQL :: sqlload_id() :: Connect Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 08/10/2012 - 09:09:44: [wowmod.amxx] [WowMOD] CLEANUP: Removing task id [200]
L 08/10/2012 - 09:09:45: [wowmod.amxx] WowMOD SQL :: sqlload_id() :: Connect Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 08/10/2012 - 09:09:45: [wowmod.amxx] [WowMOD] Client [7] connected... ( Player account )
L 08/10/2012 - 09:09:45: [wowmod.amxx] WowMOD SQL :: Config Report: host=(127.0.0.1) user=(USER) pass=(PASS) db=(DATABASE)
L 08/10/2012 - 09:09:45: [wowmod.amxx] WowMOD SQL :: Connected [OK]
All this Client [1] are Bots or my HLTV! How can i ignore them or save it by their name if i use the steamid funcion to save the data of my players?!

striker07 08-14-2012 12:08

Re: sqlload_id() :: Connect Error:
 
Quote:

Originally Posted by CS-A-Roland (Post 1768576)
All this Client [1] are Bots or my HLTV! How can i ignore them or save it by their name if i use the steamid funcion to save the data of my players?!

ignore the bots and HLTV from saving exp. are you using podbots or czbots? if you are using czbots then check this out, its from connormcleod and lets the czbots register their events or giving them an id i'm not completely sure how it works but it fixes a great deal of czbots problems
PHP Code:

if( is_user_bot(id) || is_user_hltv(id) )
    return 
PLUGIN_HANDLED

but bots should be able to save their data too on mysql, i'm not entirely sure how it's done with me with rpgx but bots save their exp as one user so all bots have same levels, them bots dont have steam id in my sql database.
authid of bots is BOT i think look at this

CS-A-Roland 08-16-2012 09:03

Re: sqlload_id() :: Connect Error:
 
Had fixed it allready like other smaler problems with the plugin. But saving data of the bots are atm not good for it, there are to much data to save and load so its better for the plugin to ignore them.
There is a problem with save/load the data and stop it later i think, so ive started to create some checks based on wc3ft and try to create a better database function. Later i think i test it with a bot saving function...
But thanks ive forgotten the hltv... :D


All times are GMT -4. The time now is 05:41.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.