[SuperNovaLite]

Thanks Geit!

Here is my drops page:
http://drops.vintagegamingleague.com/

Hope you don't mind Geit, but I might edit this page a bit.

[BBG_Theory]

Originally Posted by ltgenkd @ BBG_Theory: What version of Sourcemod are you running?

MetaMod:Source v1.8.7, SourceMod v1.4.0-dev
216.6.232.147:27015 Big Bang Gamers Trade Server
http://www.tradingunusuals.com/drops/

I am noticing that I have stopped logging now that I went to version 2.02

[pcmaster]

Hi,

Is it possible to add a column called "Server" to show on which server the Item was found/traded/crafted etc. ?

Would be nice.

[ltgenkd]

Originally Posted by BBG_Theory MetaMod:Source v1.8.7, SourceMod v1.4.0-dev 216.6.232.147:27015 Big Bang Gamers Trade Server http://www.tradingunusuals.com/drops/ I am noticing that I have stopped logging now that I went to version 2.02

I also had the same problem. Was going nutz there for a couple days trying to figure why why it stopped logging to the website. The problem for me was the "port" "xxxx" was not set in the database.cfg in addons/sourcemod/configs. As soon as I set that, it started logging again. The default port # for must Mysql db's is 3306, try that one. In the previous versions I never had to set the port # for Mysql. Hope that helps you out.

Also, getting the same bug where items are being registered to another client.

[zxc20033]

Table 'erufa_9187140_drops.itemlogger2_items' doesn't exist
how to fix it

[SuperNovaLite]

Originally Posted by zxc20033 Table 'erufa_9187140_drops.itemlogger2_items' doesn't exist how to fix it

Go into phpMyAdmin > Login > Click on the MySQL database on the left (the one you made) > At the top click SQL tab > Copy and paste what was posted on 1st post:

CREATE TABLE IF NOT EXISTS `itemlogger2_finds` (`id` int(11) unsigned NOT NULL AUTO_INCREMENT,`player_id` int(11) unsigned NOT NULL DEFAULT '0',`server_id` int(11) unsigned NOT NULL DEFAULT '0',`player_count` tinyint(3) unsigned NOT NULL DEFAULT '0',`item_index` int(11) NOT NULL DEFAULT '0' COMMENT 'signed int, 32 bit',`method` tinyint(2) NOT NULL DEFAULT '0',`quality` tinyint(2) NOT NULL DEFAULT '0',`time` int(11) unsigned NOT NULL DEFAULT '0',PRIMARY KEY (`id`),KEY `actual_time` (`time`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `itemlogger2_items` (`id` int(11) unsigned NOT NULL DEFAULT '0',`item_name` tinytext,`proper_name` tinyint(1) DEFAULT NULL,`item_slot` varchar(16) DEFAULT NULL,`image_url` tinytext,`material_type` varchar(16) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `itemlogger2_players` (`id` int(11) unsigned NOT NULL AUTO_INCREMENT,`steam_id` varchar(25) NOT NULL DEFAULT '',`name` varchar(32) DEFAULT NULL,`avatar` tinytext,`avatar_last_updated` int(11) DEFAULT NULL,PRIMARY KEY (`id`),UNIQUE KEY `steam_id` (`steam_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `itemlogger2_qualities` (`id` tinyint(3) unsigned NOT NULL,`name` varchar(32) DEFAULT '0',`raw_name` varchar(32) DEFAULT '0',PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `itemlogger2_servers` (`id` int(11) unsigned NOT NULL AUTO_INCREMENT,`ip` varchar(16) DEFAULT '127.0.0.1',`port` smallint(5) unsigned DEFAULT '27015',`name` tinytext,PRIMARY KEY (`id`),UNIQUE KEY `ip_port` (`ip`,`port`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Then click Go once and thats it. Now update again and try.

NOTE: Some web hosting panels don't automatically allow inbound connections to databases. So for example; In DirectAdmin, you click on the MySQL database and add the host '%' without the '. That will allow all hosts to connect or you could add your server IP without the port.

[Cuz]

Originally Posted by pcmaster Hi, Is it possible to add a column called "Server" to show on which server the Item was found/traded/crafted etc. ? Would be nice.

[aRcTiC]

Strange, after updating from 2.01 to 2.02 the plugin inserts a new id in itemlogger2_finds.server_id and its using the same id for all 3 of my servers, but the new id isn't present in itemlogger2_servers.id?

[imoda]

This update is much better! Now I have no reason to use my own web panel

http://www.tf2items.711clan.net/

[ltgenkd]

When items are found/crafted/traded the web panel sometimes displays no client name associated with the find. When the web panel finally displays the name of the client associated with said item, it is the wrong client name.

This Pic shows the blank field.

This Pic finally shows a client's name but it is associated with the wrong name. To compare, look at the times of the drops.
010:59
011:03
011:03

These 3 drops/crafts should have a different clients name in the row.