[imoda]

Originally Posted by almantsas Can you upload it here or sell for me?

Sure.

I don't really have an install/update package set up, but you can have this for now.

Download: http://www.tf2items.711clan.net/tf2_item_logger.zip

Download the zip, extract, edit the webupload/includes/config.php to your MySQL server settings, put your API key in webupload/update/config.php, upload everything in webupload.

Then for now, you have to manually run the sql statementa in sql/install.sql (via phpMyAdmin or some other source).
** Makes sure you edit in your server's IP and Name at the bottom first or edit/add to it later in your mysql data manager **

If you need to update it, just go to http://www.yoursite.com/update/sql.php and copypasta the sql stuff. It doesn't update the image stuff yet. Still figuring that out. Eventually I'll get the install/update process working better. Just haven't had the time.

If someone else wants to do it for me, that would be dandy too

[pcmaster]

Sorry, If i bury out this Thread, but the Item Logger doesn't work anymore.

It happens since the 21/07/2011 Update, the Server isn't reporting Item Drops anymore.
So the Plugin just doesn't show up any Item Drops in the Web Panel.

Anyway to fix this?

[asherkin]

Originally Posted by pcmaster Anyway to fix this?

No.

[ltgenkd]

Working again, displaying found items as bat, even after running update.php.

[imoda]

Items aren't getting logged correctly. The `item` field is blank for new entries.

Format(query, sizeof(query), "INSERT INTO `log` SET `name`='%s', `steam_id`='%s', `time`=UNIX_TIMESTAMP(), `players`=%i, `item`='%s', `server`='%s', `method`=%i, `quality`=%i;", client_name_esc, client_auth_esc, GetClientCount(true), item_esc, g_ServerIP, method, quality);

"item_esc" isn't getting the item value. Please advice on the correct variable.

In the mean time you can run this query

DELETE FROM log WHERE item = ''

To get rid of the bad records.

[Geit]

Valve have changed the values that are output by the item_found event, rather than output the the item's textual ID they now output it's definition index. - This is going to require some fairly big changes in the plugin and web panel.

I'm aiming to have an update out for the next couple of hours, but that could bit slip back slightly.

EDIT:

Okay, so I missed that deadline - I've gone a bit overboard and have started rewriting the whole thing from scratch - With any luck it'll be done tonight, however don't be surprised if it gets pushed back to sometime this weekend.

[ltgenkd]

Thanks Geit. Appreciate your time. Since your re-writing this from scratch, Can you add the search options that Asherkin added to the top of his web panel?
http://items.limetech.org/

[asherkin]

Originally Posted by ltgenkd Thanks Geit. Appreciate your time. Since your re-writing this from scratch, Can you add the search options that Asherkin added to the top of his web panel? http://items.limetech.org/

I no longer run a server so lost interest in finishing my web ui a looooong time ago, if anyone else wants to work on it, all the code is at http://hg.limetech.org/droplog/.
Everything is under the GPL, same as normal.

[Geit]

Originally Posted by ltgenkd Thanks Geit. Appreciate your time. Since your re-writing this from scratch, Can you add the search options that Asherkin added to the top of his web panel? http://items.limetech.org/

Yeah, I'll be doing that along with a bunch of other stuff... - So far what is planned:

• New database schema (Done! - 49% space improvement on my sample table)
• Converter for new database schema (Done!)
• New, simplified/faster updater (Done!)
• Images from Steam, as opposed to storing them locally. (Done!)
• New method for fetching steam avatars.
• Redesigning the plugin to work with the new schema (Done!)
• Entirely new web panel, with a bunch of different sections - I.e. Individual server statistics, individual player statistics etc. - I've been granted permission to reuse the design from feedback.tf2maps.net for the purpose. (Working on this now)
• Some other stuff I'm probably forgetting.

[imoda]

Could you release the plugin (or a modified old version of the plugin) so we can keep tracking data in th mean time?