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

war100ck

DarthNinj
Thank you for your work on my server all works fine

war100ck · *Last edited by war100ck; 11-03-2011 at 18:05.*

Web interface lags, web developers, remove bugs, I keep your stats from the study
sorry for doblpost
pay attention to my mistake, although it is not my (

galadril · *Last edited by galadril; 11-04-2011 at 04:06.*

Quote:

Originally Posted by war100ck

galadril:
The table in the items created with the new SQL script, the error remained the same, old found objects invisible before, please look at my base in what may be a bug, thanks in advance.
http://rghost.ru/28198481

actions:
1) run items.sql
2) run:

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

3) Select the output of the sql query above and run it to update all found items....!!!!!!!!! If you don't do this, nothing will be changed...

cool_myll

Quote:

Originally Posted by galadril

actions:
1) run items.sql
2) run:

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

3) Select the output of the sql query above and run it to update all found items....!!!!!!!!! If you don't do this, nothing will be changed...

I have done it. 0 rows returned.

Also do you know what wrong with the graphs?
http://stats.tf2.gr/player.php?steam...AM_0:1:4976452

war100ck

Quote:

Originally Posted by galadril

actions:
1) run items.sql
2) run:

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

3) Select the output of the sql query above and run it to update all found items....!!!!!!!!! If you don't do this, nothing will be changed...

Everything was done according to the instructions, items have not appeared.
In order to avoid unnecessary questions made a video, you see the error remains the same

Lob (UK

New Update all working perfect.

Thanks very much and great job as always DarthNinja.

- Lob (UK)

galadril · *Last edited by galadril; 11-04-2011 at 10:49.*

Quote:

Originally Posted by war100ck

Everything was done according to the instructions, items have not appeared.
In order to avoid unnecessary questions made a video, you see the error remains the same

War100ck... it's not only running the script..!
You need to export the result (in your youtube movie on 1: 32).

This result 'is' a sqlscript!! So you need to export the result and then run the query on your stats database. Sorry, but I don;t know how to explain this more clear..

galadril

Quote:

Originally Posted by cool_myll

I have done it. 0 rows returned.

Please check the query that you've run (for spaces for example.. maybe your admin console added some spaces after every value???).. it must update all founditems...

Quote:

Originally Posted by cool_myll

Also do you know what wrong with the graphs?

I have no idea. maybe it's an idea to clean/clear the history table...

Obsidian

Problems found with what I was about to release, the release will be delayed so I can fix them and repackage 1.2.0 with the correct files.

I'm also going to take the time to update Twitter Bootstrap to the new 1.4.0 release, and compile the phar using the experimental --strip-files flag that I've got a pull request pending for on the phar-util project; in my tests, the tf2stats.phar size has dropped over 40%, falling to about 330KiB in size with ALL dependencies included inside.

eraserhead

Hi Galadril,

When going to http://www.pulpfortress.com/tf2stats/map_ranking.php and pressing the link to the map we have on 24/7 it shows an empty page. How can we fix this?