Raised This Month: $51 Target: $400
 12% 

[TF2 Stats] With Web Ranking and Item Logger [v9.1.0]


Post New Thread Reply   
 
Thread Tools Display Modes
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 02-05-2013 , 14:11   Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]
Reply With Quote #2371

Shared hosting is like rolling dice to see what will work.
__________________
DarthNinja is offline
dstoler
Member
Join Date: Nov 2012
Old 02-05-2013 , 14:16   Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]
Reply With Quote #2372

Ok so I now have given up trying to connect my nfo server with my bluehost database So I now have a database through nfoservers on the same local machine. Everything is setup in databases.cfg and I imported my databases from bluehost to the nfo one. The only thing is my username is simply "s4l" and there is no way for me to create another user named "s4l_dstoler" the plugin is now kicking back this error:

[TF2_Stats.smx] TF2 Stats Failed to connect! Error: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 02/05/2013 - 13:09:53: [TF2_Stats.smx] Please check your database settings and permssions and try again!

The [2002] error points me to needing another user but I am not sure of that. Has anoyone here seen this error before? I spent weeks tackling a [2003] and now this. Gotta love it!
dstoler is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 02-05-2013 , 14:25   Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]
Reply With Quote #2373

How to fix the issue -> http://forums.alliedmods.net/showpos...67&postcount=7

-Edit, thanks for the donation!
__________________

Last edited by DarthNinja; 02-05-2013 at 14:28.
DarthNinja is offline
dstoler
Member
Join Date: Nov 2012
Old 02-05-2013 , 14:55   Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]
Reply With Quote #2374

No problem man! Wish I could give more. You would NOT believe what just happened to me. I was setting up the new database with my remote server and sure enough it kicked back the error you were talking about with an ip address I had never seen before. An ip address that I have been trying to get from Nfoservers for 6 weeks now because I knew that was the problem but they kept turning me down. I am an amateur and they knew it so they would just dismiss me and point fingers at my webhost. I kept going and going learning so much in the process. It is working like a charm now with my original setup (bluehost database connected to my local home server and my remote nfoserver.) I want to thank you Darth for helping me out. Off to send an email to support thanking them for exchanging 50 emails and 3 pages of forums with me and countless chats when I knew the problem all along. sigh....
dstoler is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 02-05-2013 , 15:10   Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]
Reply With Quote #2375

Yay! I'm glad it's working for you now.
__________________
DarthNinja is offline
scorpadorp
SourceMod Donor
Join Date: May 2012
Location: NC
Old 02-07-2013 , 13:55   Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]
Reply With Quote #2376

I installed your custom plugin and everything works fine except for this:

Code:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/www/runit/public/tf2stats/player.php on line 169

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/www/runit/public/tf2stats/player.php on line 329
I took a look at player.php and it's trying to fetch this:
Code:
while ($region = mysql_fetch_array($ergebnisregion))
Btw, the new features work perfectly!

Last edited by scorpadorp; 02-07-2013 at 14:31.
scorpadorp is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 02-07-2013 , 14:37   Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]
Reply With Quote #2377

Did you run the SQL files that came with the site?
__________________
DarthNinja is offline
scorpadorp
SourceMod Donor
Join Date: May 2012
Location: NC
Old 02-07-2013 , 14:42   Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]
Reply With Quote #2378

Just the weapons 1. I'll try the rest now.

Edit: Imported all the sql files. Fixed the error for appearing in webrank.

However, when a client types 'rank', 'top10' or another chat command, nothing appears.

Edit x2: This appears in logs
Code:
L 02/07/2013 - 14:56:17: [SM] Native "GetClientTeam" reported: Client 2 is not in game
L 02/07/2013 - 14:56:17: [SM] Displaying call stack trace for plugin "TF2_Stats.smx":
L 02/07/2013 - 14:56:17: [SM]   [0]  Line 4553, C:\sourcemod-1.5.0-hg3756-windows\TF2_Stats.sp::Event_round_end()

Last edited by scorpadorp; 02-07-2013 at 14:58.
scorpadorp is offline
zpeedy88
Junior Member
Join Date: Aug 2012
Old 02-28-2013 , 18:19   Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]
Reply With Quote #2379

Hey guys.. i updated sourcemod with latest snapshot.. now the websites wont show people that are online... i made sure i didnt overwrite the database.cfg
__________________
Cutting your feelings in half

www.illuzone.us
zpeedy88 is offline
Tomvdr
New Member
Join Date: Mar 2013
Old 03-01-2013 , 18:34   Re: [TF2 Stats] With Web Ranking and Item Logger [v9.1.0]
Reply With Quote #2380

Hello,

I have installed the latest version of TF2 Stats with Sourcemod 1.4.8 Stable Build. Whenever I do "say test", it gives me an error:

Quote:
003:21 L 03/01/2013 - 2327: rcon from "My Ip here": command "say ".""
003:21 L 03/01/2013 - 2327: [SM] Native "IsClientInGame" reported: Client index 0 is invalid
003:21 L 03/01/2013 - 2327: [SM] Displaying call stack trace for plugin "TF2_Stats.smx":
003:21 L 03/01/2013 - 2327: [SM] [0] Line 4329, C:\sourcemod-1.5.0-hg3600\TF2_Stats.sp::Command_Say()
003:21 Console: "."
It's not really game-breaking, but I'd like to know why this happens.

Thanks.
Tomvdr 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 13:03.


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