[Geit]

Originally Posted by asherkin Great system, found a few issues though. Line 189 of index.php needs the / in the beginning of the string removed. In avatars_cron.php there are a few issues: $path_to_avatars should have "avatars/" added on directly in the variable. The first time $xml is set should be removed, as it's switched to use the web api below it. Then the correct way to get the avatar would be $profile->players->player->avatarmedium.

Cheers! Updated the web panel yet again.

(Issues with avatar_cron are purely because I quickly adapted it from our, GamingMaster's, Daemon which is a lot more dated and complicated then what is included)

[DeJaDeW]

Thanks, no major problems yet. Great job.

http://bfused.com/?page_id=272

Now all I need to setup a cron job

[aRcTiC]

nnCron and wget works well for the avatars cron job i set it to 5 minutes
also Geit can you also add item search as well?

[DontWannaName]

Sooo... does this require a lot of constant mysql use or does it send the data on map end so it doesnt lag users during gameplay.

[Geit]

Originally Posted by aRcTiC nnCron and wget works well for the avatars cron job i set it to 5 minutes also Geit can you also add item search as well?

Will do.

Originally Posted by DontWannaName Sooo... does this require a lot of constant mysql use or does it send the data on map end so it doesnt lag users during gameplay.

It uses threaded queries (minus the connection event) and doesn't process results so there should be no lag at all.

[aRcTiC]

plugin hooks item_found event and logs it instantly when someone finds,crafts,unboxes,trades,earns,gifts,purch ases,refunds something...
so ya it constantly uses your mysql db and not just on map change

edit:
i couldn't wait so i edited a few things and added item search myself
also made it search the whole db not just from midnight of that day

notice ip localhost was related to how you got ip in your plugin, so i changed the ip cvar to my outside ip
all should be better i hope

http://uberz.servegame.com/drops

[Skyrider]

It keeps saying:

Table 'my1094_drops.log' doesn't exist

I've edited both index & update.php and also ran it.

EDIT:
I manually ran:

CREATE TABLE IF NOT EXISTS `log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL, `steam_id` varchar(25) NOT NULL DEFAULT '0', `time` int(11) NOT NULL DEFAULT '0', `players` int(11) NOT NULL DEFAULT '0', `item` varchar(50) NOT NULL DEFAULT '0', `server` varchar(32) NOT NULL DEFAULT '0', `method` tinyint(2) NOT NULL DEFAULT '0', `quality` tinyint(2) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `actualderptime` (`time`), KEY `Index 3` (`steam_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Through Phpmyadmin. Works good now.

I am getting errors though when using update.php

[07-Oct-2010 13:49:46] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so: undefined symbol: sqlite3_libversion in Unknown on line 0 [07-Oct-2010 13:50:07] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so: undefined symbol: sqlite3_libversion in Unknown on line 0 [07-Oct-2010 13:52:06] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so: undefined symbol: sqlite3_libversion in Unknown on line 0 [07-Oct-2010 13:52:11] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so: undefined symbol: sqlite3_libversion in Unknown on line 0

The site doesn't really seem to update though:
http://drops.forcepit.com/

I'm pretty sure everything is set correctly in the database.cfg file. No errors within the sourcemod logs..

Plus,
Number of items found/crafted today: 0
That's 0 per hour!

It's not updating.

Does the plugin show any kind of SQL errors within the error log if it can't connect?

[aRcTiC]

found the rimmed raincatcher (aka drinking_hat.png) lulz
heres the pack for people who couldn't use update.php for whatever reason

[Skyrider]

Originally Posted by aRcTiC found the rimmed raincatcher (aka drinking_hat.png) lulz heres the pack for people who couldn't use update.php for whatever reason

File attachment doesn't work.

[aRcTiC]

fixed, here again