[TF2] Item Logger (With Web Panel) - Page 14

danielmyst777 · 09-09-2011 , 22:53 Re: [TF2] Item Logger (With Web Panel)

When I downloaded the web part of this plug-in and configured it, when I ran update/index.php, my webpage gave me the error 'nh_items.log doesn't exist'. So I can the php code from post #17 and it created the log table just fine.

Now I am trying to run the update the convert.php code from post #121 in the pre-release file but it gives me the error unknown table 'avatar' in 'fieldlist'. I am assuming that's because my log table doesn't have this field? I can see it adds the converted tables just fine until it get's to the log table code.

Can someone please give me the code to create a correct log table so the convert.php can run successfully?

imoda · 09-12-2011 , 00:02 Re: [TF2] Item Logger (With Web Panel)

Geit, eta on release?

Geit · *Last edited by Geit; 09-19-2011 at 08:40.*

I have pre-release for the web panel available now, I rushed alot of this while on a train journey and it is largely untested, however it should function at a basic level. I will add the extra features I promised at a later date...

You can see a live example at: http://www.gamingmasters.co.uk/drops

Installation is fairly simple:

Upload all the files to a web accessible location with a PHP server etc.
Fill out /system/includes/config.php with Database details and other settings.
Run update.php
Run convert.php if you have Item Logger V1 Table and you want to move to Item Logger V2
Delete update.php and convert.php
Should work, with any luck.

I'll update the OP with this information and tidy it up a little tomorrow, I have to rush off the train now!

EDIT: See OP for downloads

danielmyst777 · *Last edited by danielmyst777; 09-17-2011 at 18:33.*

How to create mySQL database tables before running update.php/convert.php? What's the php code I need to execute in phpmyadmin to create these tables before hand as a clean install?

ltgenkd · *Last edited by ltgenkd; 09-18-2011 at 05:36.*

Quote:

I'll update the OP with this information and tidy it up a little tomorrow, I have to rush off the train now!

Can you add Pagination when you do your tiding?

Getting "You are using an outdated browser" with IE 9. Looks perfect in Firefox 6.0.2 though.

Ran the convert/update.php, deleted the 'log' table, it converted the old db but no new drops are showing at all. When I run the update.php it shows a blank page. The last drop is from 8/27/11.
The new plugin v2.01 is installed on 2 servers. I noticed no server info to fill out in config.php. I am assuming CServerinfo.php takes care of everything.

http://usmcclan2.com/drops/

Any thoughts?

Geit · 09-18-2011 , 17:50 Re: [TF2] Item Logger (With Web Panel)

Quote:

Originally Posted by ltgenkd

Can you add Pagination when you do your tiding?

Ran the convert/update.php, deleted the 'log' table, it converted the old db but no new drops are showing at all. When I run the update.php it shows a blank page. The last drop is from 8/27/11.
http://usmcclan2.com/drops/

Any thoughts?

Pagination is something I meant to add but forgot to, I'll get it done ASAP - which will probably be some time tomorrow.

There is one thing I forgot to mention in my other pre-release -- I changed the configuration block that the plugin uses in sourcemod/configs/databases.cfg from "feedback" to "itemlogger2" -- You will need to change this to continue to have drops log.

SuperNovaLite · *Last edited by SuperNovaLite; 09-21-2011 at 02:37.*

I keep getting this error in the log file:

Quote:

L 09/21/2011 - 16:21:21: [SM] Native "SQL_GetInsertId" reported: Invalid statement or db Handle ba007b (error: 2)
L 09/21/2011 - 16:21:21: [SM] Displaying call stack trace for plugin "itemlogger.smx":
L 09/21/2011 - 16:21:21: [SM] [0] Line 147, /home/groups/alliedmodders/forums/files/6/2/4/7/1/92740.attach::T_PlayerInsert()

I've used the first item logger and that was fine. Don't know whats wrong here.

ltgenkd · 09-22-2011 , 20:26 Re: [TF2] Item Logger (With Web Panel)

Quote:

Originally Posted by SuperNovaLite

I keep getting this error in the log file:

I've used the first item logger and that was fine. Don't know whats wrong here.

Started getting the same error on 9/20/11. Now nothing is being logged.

SuperNovaLite · 09-23-2011 , 05:42 Re: [TF2] Item Logger (With Web Panel)

Quote:

Originally Posted by ltgenkd

Started getting the same error on 9/20/11. Now nothing is being logged.

I know nothing about Sourcemod or plugins, but by looking at the error's, it looks like something to do with inserting the data into the database... maybe a connection problem?

Obsidian · 09-23-2011 , 08:28 Re: [TF2] Item Logger (With Web Panel)

http://validator.w3.org/check?uri=ht...Inline&group=0

Looks like your HTML needs a bit of cleanup. All img tags need alts (it's for accessibility reasons, and is required as per the XHTML 1.0 Strict spec), you've got some unclosed tags in there, all form tags should have an action attribute.

You should also update jquery, they did a panic-update after 1.6.3 to 1.6.4 to fix some things that they broke.

I'll give the backend code a sniff later and provide my findings afterwards. No idea on when I'll get a chance to though.