[crazyboylou]

And now the rank system doesn't work on the gameserver.

[DarthNinja]

Originally Posted by kie2611 I have run the plugin and the sql files. I have also re created the sql database but the founditems table still only has 4 columns: ID, STEAMID, ACTUAL TIME and ITEM. If you could please tell me the names of the additional columns I need and their data type ill just create them. thx

I think I know what the trouble is and I'll have an update out soonish to fix it.

Originally Posted by crazyboylou I am having trouble allowing the gameserver to access the webserver. I use Go daddy and I can't find out how to allow access. I tried Cpanal but I couldn't figure out anything about it. Can anyone help?

Yes, your host.
Ask if they allow external mysql connections, and how to configure them.

Originally Posted by crazyboylou And now the rank system doesn't work on the gameserver.

Surprise.

[galadril]

~~Update WebUI 7.6.0 ~~

Download:
http://www.multiupload.com/CVHF3KQTAK

Added all the latest weapons as supported in the DarthNinja christmas release :-)

Added found items:
acr_assassins_cowl.4e72dde86c77b2a3c4c1a68c46 15f6c19e457a2e.png
bad_winter_crate.eed5d41ab92964a3e14e33e9ea6b a000e80690d7.png
bowtie.3dada19c616dba4b20abe31899772f84506955 f2.png
capones_capper.e462eb63d54e1502c10c9f185fc231 504b0e4206.png
c_acr_hookblade.bff93c1997f755c608bf74d9eadcd bb5261529d8.png
c_drg_manmelter.b76b87bda3242806c05a6201a4024 a560269e805.png
c_drg_phlogistinator.99b83086e28b2f85ed4c925a c5e3c6e123289aec.png
c_drg_pomson.4e5424f79346065be63181b94e758369 1d38db5b.png
c_drg_thirddegree.a0b74c75233404dc9aef3537ec0 33ea4bd883ee0.png
c_drg_wrenchmotron.e653fff68b114c2c64439f6fa1 8ba95dd50a0940.png
c_sr3_punch.077e5337d574c95e4b359be6082fb128c d037c45.png
c_xms_cold_shoulder.19ae17161a5b98e0105ffc6ff c4ee79edbe8ee1b.png
c_xms_giftwrap.dfc82e73461f5cb82787a854539a7c e2c8f7225f.png
c_xms_gloves.3dee18c9ad25a3b3c97c66dbaa3babd6 7d1314a5.png
drg_badge.57823ce4588d8fece1a1bc42a6d4c942b82 49bfd.png
drg_badge_copper.c5ab338e733740f3e62dde54ce2e 26488d2857d0.png
drg_badge_silver.b750f30c74b68f0ecb9a8585620d c51a116cb0c4.png
drg_brainiac_goggles.e51182126ede0f7c6e03ec0c d8d723196d72f650.png
drg_brainiac_hair.e5066a35b278d5290ed8dcf8592 e2ec2acde529c.png
drg_pyro_bubblehelmet.b6acad238823f110b417b8e 54ead921545b92ed5.png
drg_pyro_fueltank.c9fcf960077c0761f39838dc6b9 b5fe3814d9079.png
grordborts_engineer_bundle.7477184326d3eceb8c 06f0a4439a7d926347acdc.png
grordborts_pyro_bundle.7dd81482babc411781480b e17ab8c9528b36e2c9.png
grordborts_xmas_bundle.b35a86680b0ec9e60f818f 78d4a770b06b232b9b.png
noisemaker_xmas.aaeab7ff07b6a16df8c44ce1e1f24 499725e4679.png
notch_head_demo.a738004d187e47830b2fc26a2dc11 919d0a71961.png
provided_by.png
replay_hat.718315e19e9aa2aed8cae4e15d11d17ffa 31d7b0.png
sniper_crocleather_slouch.b15d9d562a6fb9f0193 7d98a006fdc06827e8492.png
something_special.3872d2689d6ef7165619734b9fb 30c17d3d5f4a7.png
sr3_badge.aa68f18685a828e82d70e9f0c58778ca421 55253.png
sr3_heavy_mask.8e1ebfd07d18b65f1c75d98b4a20ff 6033799b1f.png
trn_heavy_knight.dba53da7adf78d3d76c5a5933dd4 157418ce9e48.png
trn_wiz_hat_demo.969d5700c526108989b9e93ef08e aeb17cacbab9.png
ugc_trophy_medal_participant.81d952dcdaa3521b 3ba98f416222e0a3872a9587.png
ugc_trophy_medal_platinum.85f646e6a27f19454a5 999f3f382b04a040f6eb0.png
ugc_trophy_medal_silver.0af401fb00f21164b1e5f e41b9fd08c0645b6d5a.png
winter_crate.ad25034a1453c63f43a658ab6d30da80 b307f562.png
xmas_key.00b3590954a309f9612aa90c904b2bc2dbde dcf9.png
xmas_wicked_key.1a6fac760f7858d978174d6a40edc 385f04dff9f.png
xms_bat.9d742f558c81024019f65a6fef3f3fcefaae7 d6d.png
xms_engineer_stocking.9265191f29f108e5c6b66e6 eb6f74e841f86cede.png
xms_engineer_voodoospy.5354130e3be547a0f3160c 38d1af2ce8a6a661eb.png
xms_flamethrower.800383db1f5907020b71ba97b79d c886b0853f90.png
xms_furcap_demo.f4d784ffcac7539f24ccc71dab4bf 13284cebe2a.png
xms_gift_hat_demo.5116915118aa1698913254ec923 ec4b71640e1bf.png
xms_heavy_beard.6608c39ae0e3ac0e2312d7157acc8 665b0392030.png
xms_heavy_minigunlights.7697f96e29684b4e6770e 21905015b4bba289ead.png
xms_heavy_sandvichsafe.bb2bfa9dfa8df97ca00b6b d73a9cd655306a34a0.png
xms_knife.7ab2be3140d50b76c2ee783e067baea3408 374e6.png
xms_medigun.865427fc82cb3965a6c362d8eab40f2e9 1a76622.png
xms_pyro_bells.416ec9f93f966ed819cef879f344b3 0e584d826e.png
xms_pyro_parka.de5a5f80e74f428204a4f4a7d09461 2173adbe50.png
xms_rocketlauncher.e8269736c749530eae09bae41d ccf370bfb2d491.png
xms_santa_hat_demo.227b4d6dba0f2f97395c617f89 2e510c0d474970.png
xms_scattergun.530c487413a246fc1c149ef67d6264 ffa0d13274.png
xms_scout_elf_hat.87960ae4a22d5cdfcb568d24c8c 4e376f1a48e7d.png
xms_scout_elf_sneakers.4c1eaded25a8a76243d3bd 17329756cf7b47f6fd.png
xms_sniperrifle.0788404f4040a3f6d249a59175ac3 b70c6405bf3.png
xms_sniper_sweater_vest.f79217e593fa1ad2069dd 9ddb660f58c3ee4b361.png
xms_snowcoat.9900ad5da6428c5cfbf82ed0009e4ad1 16420758.png
xms_soldier_ornaments.4594393c5c24100c6547c28 a0baa204df2242827.png
xms_steamwhistle_spy.d19e21ee84411f0bee387532 5d4791b459d37170.png
xms_stickybomb_launcher.ab31377d2feaefdc52420 84626bdfaab2a0a013f.png
xms_winter_joy_hat_demo.bb4eb80628e470fb42a70 5b956196aed4348534c.png
xms_wrench.0eeb6bbc09d3042738b820cf3eaa1a3efa 2cb11b.png

Updated files install:
- FTP the images/weaponicons and images/items
- Run the items and weapons sqlscript

Demo:
http://www.heinisblog.nl/tf2stats

Have a nice Christmas :-)

[war100ck]

galadril;

You have a bug on the site.
http://www.heinisblog.nl/tf2stats/weapon_ranking.php

Query SELECT sum(KW_UnarmedCombat) as Sum FROM `Player` failed: Unknown column 'KW_UnarmedCombat' in 'field list'Query SELECT sum(KW_WangaPrick) as Sum FROM `Player` failed: Unknown column 'KW_WangaPrick' in 'field list'Query SELECT sum(KW_ScottishHandshake) as Sum FROM `Player` failed: Unknown column 'KW_ScottishHandshake' in 'field list'Query SELECT sum(KW_ConscientiousObjector) as Sum FROM `Player` failed: Unknown column 'KW_ConscientiousObjector' in 'field list'Query SELECT sum(KW_Saxxy) as Sum FROM `Player` failed: Unknown column 'KW_Saxxy' in 'field list'Query SELECT sum(EyeBossStuns) as Sum FROM `Player` failed: Unknown column 'EyeBossStuns' in 'field list'Query SELECT sum(EyeBossKills) as Sum FROM `Player` failed: Unknown column 'EyeBossKills' in 'field list'Query SELECT sum(KW_phlogistinator) as Sum FROM `Player` failed: Unknown column 'KW_phlogistinator' in 'field list'Query SELECT sum(KW_manmelter) as Sum FROM `Player` failed: Unknown column 'KW_manmelter' in 'field list'Query SELECT sum(KW_thirddegree) as Sum FROM `Player` failed: Unknown column 'KW_thirddegree' in 'field list'Query SELECT sum(KW_holiday_punch) as Sum FROM `Player` failed: Unknown column 'KW_holiday_punch' in 'field list'Query SELECT sum(KW_pomson) as Sum FROM `Player` failed: Unknown column 'KW_pomson' in 'field list'Query SELECT sum(KW_eureka_effect) as Sum FROM `Player` failed: Unknown column 'KW_eureka_effect' in 'field list'Query SELECT sum(KW_sharp_dresser) as Sum FROM `Player` failed: Unknown column 'KW_sharp_dresser' in 'field list'Query SELECT sum(KW_spy_cicle) as Sum FROM `Player` failed: Unknown column 'KW_spy_cicle' in 'field list'

[DarthNinja]

Nice tiny image with unreadable error output. That's totally useful.

[crazyboylou]

In step 11 of the pdf you mention Remote MySQL section or Access Hosts section. I can't find it on the go daddy site. And I can't figure out how to get cpanel to work with Go Daddy.

is this all I need in the database.cfg?
"tf2stats"
{
"driver" "mysql"
"host" "50.63.244.143"
"database" "tf2statsmonocle.db.8689553.hostedresource.co m"
"user" "tf2statsmonocle"
"pass" "--------nope---------"
//"timeout" "0"
"port" "3306"
}

This is what comes up on this site if it helps.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'tf2statsmonocle@'@'97.74.24.115' (using password: YES) in /home/content/53/8689553/html/tf2stats/inc/dbconnect.php on line 4 Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/53/8689553/html/tf2stats/inc/dbconnect.php on line 5 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/content/53/8689553/html/tf2stats/inc/dbconnect.php on line 5 Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/53/8689553/html/tf2stats/inc/dbconnect.php on line 6 Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/content/53/8689553/html/tf2stats/inc/dbconnect.php on line 6 Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/53/8689553/html/tf2stats/index.php on line 8 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/content/53/8689553/html/tf2stats/index.php on line 8 Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/53/8689553/html/tf2stats/index.php on line 14 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/content/53/8689553/html/tf2stats/index.php on line 14 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/53/8689553/html/tf2stats/index.php on line 20

[DarthNinja]

Your config is fine:

Originally Posted by DarthNinja Originally Posted by crazyboylou I am having trouble allowing the gameserver to access the webserver. I use Go daddy and I can't find out how to allow access. I tried Cpanal but I couldn't figure out anything about it. Can anyone help? Yes, your host. Ask if they allow external mysql connections, and how to configure them.

war100ck:
You're not running the latest version of the plugin.

[crazyboylou]

Yes, your host. Ask if they allow external mysql connections, and how to configure them.

I did and they told me that the database.cfg was all i needed.

[war100ck]

DarthNinja:
I wrote galadril on his site in case an error

[DarthNinja]

Originally Posted by crazyboylou I did and they told me that the database.cfg was all i needed.

That's incorrect, and for the record I meant the host of your SQL server, not your game server.

Originally Posted by war100ck DarthNinja: I wrote galadril on his site in case an error

You're getting that error because your plugin is out of date.