Raised This Month: $ Target: $400
 0% 

sqlload_id() :: Connect Error:


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
CS-A-Roland
Member
Join Date: Jul 2009
Old 08-10-2012 , 13:21   sqlload_id() :: Connect Error:
Reply With Quote #1

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?!
__________________
oOOOoooh it's www.Cs-Attack.de
New World of Warcraft Mod Beta 0.5(based on WC3FT 3.5)
Counterstrike 1.6 SERVER:
Server IP: 193.192.58.154:27200

CONDITION ZERO SERVER:
Server IP: 193.192.58.154:27016
CS-A-Roland is offline
striker07
Veteran Member
Join Date: Mar 2012
Location: Solar System/Earth/Belgi
Old 08-14-2012 , 12:08   Re: sqlload_id() :: Connect Error:
Reply With Quote #2

Quote:
Originally Posted by CS-A-Roland View Post
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
__________________

Working on:
[CSGO/CSS] Mmorpg - an extensive XP/level modulair platform
Progress: [♣♣♣♣♣♣♣|♣♣♣]

Last edited by striker07; 08-14-2012 at 12:15.
striker07 is offline
CS-A-Roland
Member
Join Date: Jul 2009
Old 08-16-2012 , 09:03   Re: sqlload_id() :: Connect Error:
Reply With Quote #3

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...
__________________
oOOOoooh it's www.Cs-Attack.de
New World of Warcraft Mod Beta 0.5(based on WC3FT 3.5)
Counterstrike 1.6 SERVER:
Server IP: 193.192.58.154:27200

CONDITION ZERO SERVER:
Server IP: 193.192.58.154:27016
CS-A-Roland is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


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