Raised This Month: $32 Target: $400
 8% 

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


Post New Thread Reply   
 
Thread Tools Display Modes
Leontar
Junior Member
Join Date: Jul 2010
Old 01-28-2012 , 16:58   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.10.1]
Reply With Quote #2111

Yes, just this one gives an error as you can see.
Leontar is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 01-28-2012 , 17:09   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.10.1]
Reply With Quote #2112

Quote:
Originally Posted by Leontar View Post
Yes, just this one gives an error as you can see.
I can't see the error, but it looks like you're right. There's a bug that is preventing the founditems table from being created.
You can run this SQL to create it by hand:
Code:
CREATE TABLE IF NOT EXISTS `founditems` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `STEAMID` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `ACTUALTIME` int(11) NOT NULL DEFAULT '0',
  `ITEM` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `ItemIndex` int(10) NOT NULL DEFAULT '0' COMMENT 'Item definition index from items_game.txt',
  `Quality` int(3) NOT NULL DEFAULT '0' COMMENT 'Int value for vintage, strange, etc',
  `Method` int(3) NOT NULL DEFAULT '0' COMMENT 'Crafted, traded, found, unboxed, etc',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
I'll post an update for the plugin shortly so this is fixed.
__________________

Last edited by DarthNinja; 01-28-2012 at 17:10.
DarthNinja is offline
Leontar
Junior Member
Join Date: Jul 2010
Old 01-28-2012 , 17:13   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.10.1]
Reply With Quote #2113

That fixed it. Many thanks for your help
Leontar is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 01-28-2012 , 17:16   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.10.1]
Reply With Quote #2114

Quote:
Originally Posted by Leontar View Post
That fixed it. Many thanks for your help
Sure thing, thanks for helping me find that bug
__________________
DarthNinja is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 01-28-2012 , 17:39   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.10.1]
Reply With Quote #2115

Version 8.10.2 released:
  • Fixed founditems table not being created in some cases.
__________________
DarthNinja is offline
fknChaos
New Member
Join Date: Jan 2012
Old 01-30-2012 , 20:21   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.10.1]
Reply With Quote #2116

Hey there. Love the plugin!

Wondering one thing, do you have the item list for what most of the weapons in are in the DB-table? Because I can't figure out what the "KW_Cg" is?

Thank you!
- fknChaos
fknChaos is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 01-30-2012 , 21:19   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.10.1]
Reply With Quote #2117

Quote:
Originally Posted by fknChaos View Post
Hey there. Love the plugin!

Wondering one thing, do you have the item list for what most of the weapons in are in the DB-table? Because I can't figure out what the "KW_Cg" is?

Thank you!
- fknChaos
KW_Cg would be kills that use the log name "minigun".
__________________
DarthNinja is offline
fknChaos
New Member
Join Date: Jan 2012
Old 01-30-2012 , 22:01   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.10.1]
Reply With Quote #2118

Quote:
Originally Posted by DarthNinja View Post
KW_Cg would be kills that use the log name "minigun".
Right, do you have a list over what is what in the table?
__________________
WeHeartGaming.com - My community
fknChaos is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 01-30-2012 , 23:15   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.10.1]
Reply With Quote #2119

Quote:
Originally Posted by fknChaos View Post
Right, do you have a list over what is what in the table?
There is no list. All the column names should be self explanatory, the rest you can find out by looking at the plugin's source code (just ctrl+f for the column name).
__________________
DarthNinja is offline
Vooda
New Member
Join Date: Jan 2012
Old 01-31-2012 , 02:13   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.10.1]
Reply With Quote #2120

I'm having trouble getting the plugin working, I know I'm missing something stupid. I was just wondering if anyone could tell me what? I'm quite new to modding.

I only have 2 Mods installed MetaMod and SourceMod.
I have the following files in place...
  • .../orangebox/tf/sound/tf2stats/top10.wav.bz2
  • .../orangebox/tf/cfg/tf2-stats.cfg
  • .../orangebox/tf/addons/sourcemod/scripting/TF2_Stats.sp
  • .../orangebox/tf/addons/sourcemod/plugins/TF2_Stats.smx
  • .../orangebox/tf/addons/sourcemod/configs/geoip/GeoIp.dat
But i get no reaction from the plugin when i type rank in game. Also can somebody please tell me if there would be any log files i could read to shed some light on it.

Last edited by Vooda; 01-31-2012 at 02:14.
Vooda is offline
Reply


Thread Tools
Display Modes

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 16:31.


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