Raised This Month: $51 Target: $400
 12% 

[TF2 Stats] With Web Ranking and Item Logger [v9.1.0]


Post New Thread Reply   
 
Thread Tools Display Modes
Jabra
Junior Member
Join Date: Oct 2011
Location: Germany
Old 10-22-2011 , 19:20   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.6.0/v7.3.0]
Reply With Quote #1991

Ah, at the end of the cfg... I could use my Eyes right *gg*Thx 4 the instant Support. Great Plugin with many Features. Go on with your great work, maybe you could build in a Image, like XLRStats?
Would be cool! ;)
Jabra is offline
deadlystrike
Junior Member
Join Date: Aug 2011
Old 10-29-2011 , 20:45   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.6.0/v7.3.0]
Reply With Quote #1992

the players.php pages and maps.php pages are having major issues on my site

the maps page is getting access denied with another error to sql server
players page is geting a php error ip not found
gamingmadeeasy.com/tf2stats
deadlystrike is offline
galadril
Senior Member
Join Date: Apr 2009
Old 10-31-2011 , 08:46   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.6.0/v7.3.0]
Reply With Quote #1993

~~~Changelog WebUI Update 7.5.0~~~
Install
- Run items.sql sqlscript.
- FTP all new images/items

Download:
http://www.multiupload.com/7WG5L7WGJG

Added found items:
all_domination.f6ad203289023cd4a1f25a5521eb03 6b2e1b0a1c.png
bombonomicon.6dc3119f20faa08d10161fa876c57265 ae46c282.png
bundle_of_bundles.66fdfcd285bc8fd61c2ffd47296 109fb77c60c6f.png
c_unarmed_combat.4ba6e7a41ae445c04f266bc86ceb 4d0939e93d4e.png
c_voodoo_pin.f70d0be3e6cb4064acd9d967ca067449 08bf2ab9.png
demo_bundle_bag.a88c5f351e698db1dd396e88f7229 f5b5ef01838.png
engineer_bundle_bag.e52b4d2b651decec9a5b4158d 66cc0d931b3baf8.png
ghost_aspect.74a63072ba6e3f115ff9dd278e877d8e 1d7f6e75.png
gift_halloween.b71c94eca8c1c0a0c229e0fab42dc0 273b8b966c.png
haunted_eyeball_hat.5959079eb73484df5e47fe7a2 a07c4646a1ac56b.png
heavy_bundle_bag.fdba1f2163f8edb446f1c7562ef9 418e4507c4ba.png
hwn_demo_hat.cac8eee73abd90afe71198744ecd927b 1e60206e.png
hwn_demo_misc1.e2f4583accce08f9a0080dd42821c1 5b7dac0747.png
hwn_demo_misc2.ff34aabc0dd1ddf8bf624eacf493c0 fdc2b41654.png
hwn_engineer_hat.888c5e9b9c41fb7cb64e7604d717 8ff5f8452dea.png
hwn_engineer_misc1.3992a008845f396d463d911816 d9165e4832ffc7.png
hwn_engineer_misc2.e3fa92e3cdfef0cf69a6521f96 bea4cca4df8120.png
hwn_heavy_hat.4747e5f0fede456c469f40ad03e036f 57a2765b1.png
hwn_heavy_misc1.64560d08bb8209d3e669d4512c8d0 8a95ad32511.png
hwn_heavy_misc2.7bfa8076581b7993f64d9e35a39c5 6b79b711d72.png
hwn_medic_hat.8e961ea2131582948aa373942454081 9dcfae38d.png
hwn_medic_misc1.cfcc8be105efb8064a18a1cdbc649 b8a6feec979.png
hwn_medic_misc2.61b93cce06141077cb44498852aac 9eba6706fd2.png
hwn_pyro_hat.d2b5300a102ea67c036149c6d39a09f6 648f2f28.png
hwn_pyro_misc1.b26db8e9a9fde9173cc9d8dfbdd733 01e06836be.png
hwn_pyro_misc2.287a57b1150a1f044f0ed5b54aa438 36fb7371f3.png
hwn_scout_hat.5c556a198299889c4eed682bb9b97b0 dde5808c2.png
hwn_scout_misc1.806f662612ee4c8b52e13bd003742 ced57a0bdf2.png
hwn_scout_misc2.60bfb4afccd0aedc8c6321b5a071d 70ad3065273.png
hwn_sniper_hat.c41c0e82c35e15ba276e3c1448dbb2 c390812ca8.png
hwn_sniper_misc1.652d494d64330b167ba5f7e1fcc3 c56b592b44eb.png
hwn_sniper_misc2.9f4efe73471bf028fda71d3b1b89 ab5711c3b948.png
hwn_soldier_hat.f9853361feb654796b6d5ea5f1d9a 663b41527bd.png
hwn_soldier_misc1.2aee6b05e22eac00852e8c6a58d efcabc3de2e0d.png
hwn_soldier_misc2.ddd52e9b60b553869e496c86b96 bc2a242b51f3b.png
hwn_spy_hat.a4eca782435bce85a6fe53259952f16e4 ae9ea40.png
hwn_spy_misc1.a544d356c0cd721cfbc8d829e30ae78 25694f289.png
hwn_spy_misc2.3daaa6142c885a7c8af1ad4b220e653 87ea6ee34.png
infernal_impaler.7992291004031d55dea83c28c725 7597f0103c05.png
medic_bundle_bag.130a9c3eda926ed31554a24c59a8 16179ec694e3.png
pyro_bundle_bag.c3a5d3be71832b6243043d1cc9ffd c50dcaad061.png
pyro_halloween_gasmask.77d83fdd31abeed5423b23 2c3d6ddd6f3e9994fd.png
scout_bundle_bag.2b6ee159681765601b73743b94ce 673dee76126e.png
seal_mask_demo.c660b8fb236d4cf7f7cc42e1c9c69e b0cd25da37.png
skull_horns_b.3c2f6e8acd44a917be2fa941dba0f4a 7893a2400.png
skull_horns_b2.1b076a6a5ed214a7e447c654dcc37e e3829e25da.png
skull_horns_b3.9e6e4f8b3818dd62e2def6171d63a8 abd3bf28a3.png
sniper_bundle_bag.61d8e072307ea32956328420f14 c7241943c0a26.png
soldier_bundle_bag.223953b9255039f2d1a7ec0ef1 a3bac3b0da65bc.png
spy_bundle_bag.5edb6a15ab58027c3f6a64f73316c4 f1762f54e9.png

Demo:
http://www.heinisblog.nl/tf2stats
__________________
galadril is offline
war100ck
Senior Member
Join Date: Oct 2010
Old 10-31-2011 , 12:41   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.6.0/v7.3.0]
Reply With Quote #1994

They wrote for a similar error, but no one answered

I put the file player.php from the old version, there is no error, but no new items

Last edited by war100ck; 10-31-2011 at 12:57.
war100ck is offline
cool_myll
SourceMod Donor
Join Date: Aug 2011
Old 10-31-2011 , 14:00   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.6.0/v7.3.0]
Reply With Quote #1995

Quote:
Originally Posted by war100ck View Post
They wrote for a similar error, but no one answered

I put the file player.php from the old version, there is no error, but no new items
Same here.
__________________
cool_myll is offline
Obsidian
Senior Member
Join Date: Jun 2011
Old 10-31-2011 , 19:38   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.6.0/v7.3.0]
Reply With Quote #1996

Waiting on DN to update the plugin to support the new weapons to push out the new version of my own Web UI by the way, which includes the new style for the Web UI.
__________________
TF2 Stats plugin alternative web interface - profile @ Github
(tf2stats-webui latest release: 1.1.1)


"If you're not willing to do it right, don't get involved with security or Explosive Ordinance Disposal."
Obsidian is offline
galadril
Senior Member
Join Date: Apr 2009
Old 11-01-2011 , 06:32   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.6.0/v7.3.0]
Reply With Quote #1997

Quote:
Originally Posted by war100ck View Post
They wrote for a similar error, but no one answered
I put the file player.php from the old version, there is no error, but no new items
Quote:
Originally Posted by cool_myll View Post
Same here.
Please check my release note

Important part:
Quote:
Originally Posted by galadril View Post
To merge old found items to the new format:
The next script generates an update statement:

Code:
SELECT DISTINCT  "UPDATE founditems SET ItemIndex = '", i.code, "' WHERE ITEM ='",  fi.item , "';"
FROM founditems as fi, items as i 
WHERE fi.item = i.ITEM
GROUP BY i.ITEM
Run the result of this script to update all previous found items...!
__________________

Last edited by galadril; 11-01-2011 at 06:33.
galadril is offline
cool_myll
SourceMod Donor
Join Date: Aug 2011
Old 11-01-2011 , 08:54   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.6.0/v7.3.0]
Reply With Quote #1998

I think i have done it. But i ll retry this later
__________________
cool_myll is offline
war100ck
Senior Member
Join Date: Oct 2010
Old 11-01-2011 , 08:55   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.6.0/v7.3.0]
Reply With Quote #1999

Quote:
Originally Posted by galadril View Post
Please check my release note

Important part:
Web files are filled with all the new release.
Updated script items.sql
I'm trying to run the script:
Code:
SELECT DISTINCT  "UPDATE founditems SET ItemIndex = '", i.code, "' WHERE ITEM ='",  fi.item , "';"
FROM founditems as fi, items as i 
WHERE fi.item = i.ITEM
GROUP BY i.ITEM
an error : #1054 - Unknown column 'i.code' in 'field list'

Last edited by war100ck; 11-01-2011 at 09:18.
war100ck is offline
galadril
Senior Member
Join Date: Apr 2009
Old 11-02-2011 , 03:56   Re: [TF2 Stats] With Web Ranking and Item Logger [v8.6.0/v7.3.0]
Reply With Quote #2000

Quote:
Originally Posted by war100ck View Post
Web files are filled with all the new release.
Updated script items.sql
I'm trying to run the script:
Code:
SELECT DISTINCT  "UPDATE founditems SET ItemIndex = '", i.code, "' WHERE ITEM ='",  fi.item , "';"
FROM founditems as fi, items as i 
WHERE fi.item = i.ITEM
GROUP BY i.ITEM
an error : #1054 - Unknown column 'i.code' in 'field list'

Ow damn! I've changed the column name code to ItemIndex.. here is a working script:

Code:
SELECT DISTINCT  "UPDATE founditems SET ItemIndex = '", i.ItemIndex, "' WHERE ITEM ='",  fi.item , "';"
FROM founditems as fi, items as i 
WHERE fi.item = i.ITEM
GROUP BY i.ITEM
This generates a new updates sql script to update all founditems
__________________

Last edited by galadril; 11-02-2011 at 03:57.
galadril is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 16:13.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode