Inactive [INFO/WEB] WS v0.5 - Web Stat page for mcMMO(whith MySQL only) [1302]

Discussion in 'Inactive/Unsupported Plugins' started by Kiborgik, Apr 30, 2011.

  1. Offline

    Kiborgik

    Project is closed!
    Simple webstat writen on php5, now only for mcMMO whith MySQL and PHP 5.2.1+
    Version: 0.5
    GitHub: https://github.com/Kiborgik/ws
    Demo: http://ratings.crafthero.net
    Screens:
    Show Spoiler
    [​IMG]

    Download: Last version
    Install:
    1. move files to web-folder on your website
    2. edit config.php
    3. chmod 777 "data"
    4. chmod 666 for all .json files on folder "data"
    5. cake? )
    6. p.s. if you have "internal" problem try delete .htaccess
    7. if you disabled mining on your server:
      • open webstats.class.php found "AND ms.`mining` >0" (on line: 64)
        and delete this part, and all be ok
    8. p.p.s if css/js not load:
      • for IIS need change chmod "min" folder
      • go min/config.php
      • found $min_documentRoot = substr(__FILE__, 0, -15);
      • change it like $min_documentRoot = "c:\\xampp\\htdocs\\ws_for_mcmmo_folder";
      • its your path if you used windows, or '/home/accountname/public_html' if linux
    Upgrade:

    1. upload & rewrite all files except config.php
    2. chmod 666 for all .json files on folder "data" if needed
    3. testing and comment
    Changelog:

    Show Spoiler

    v0.5
    • perfomance relise & secure
    • add index_ajax.php for all ajax request
    • add posible gzip compression for css/js (minify_2.1.4_beta)
    • add cache images and others to .htaccess
    • add google charts :D (ideas?)
    • need mining > 0 for adding to table
    • now limit 1000 users whith biggest mining skill
    • fix some html errors
    v0.4

    v 0.3:

    • add icons & tooltips
    • some fixes
    • fixed "zebra"
    • fixed width
    • remove page "users" & add it to popup on click name
    v 0.2: (need chmod 666 for all .json files on folder "data")

    • add powerlevel
    • some bugfix
    • some cleanups
    • compare php version
    • add config (time_cache, prefix)
    v 0.1:

    • initial relise
    • caching 120s
    • json data for API
    • list users and skills


    TODO:
    • better functional
    • chek all variants for work
    • party(?)
    • search functional
    • fix some css errors
    • cache not only json
    • add weeks ratings and all for it
    • tool tips
    • charts and other graf
    • add power level
    P.S. Waite for your comments and sorry for my english )

    working for food, writing sites to order :)
    if you want remove or replace my copyright do this:
    open js / tooltips.js and remove
    $("#first").append(reclam_text);
    $("#second").append(reclam_text);
     
    FaeDine likes this.
  2. Offline

    Kiborgik

    you used fixed version? try debug files(on download page), set chmod for new files? asq you hoster? try delete .htaccess
     
  3. Offline

    RugRats

    it worked after deleting .htaccess
     
  4. Offline

    Kiborgik

    need more comments and ideas :rolleyes:
     
  5. Offline

    Skinnybones18

    Question: why does 0.5 look like this http://bonesminecraft.net/mcmmo_home/index.php
    but 0.4 looks like this http://bonesminecraft.net/mcmmo/index.php

    this is what I am getting the the test_all.php thing...
    http://bonesminecraft.net/mcmmo_home/min_unit_tests/test_all.php
    Show Spoiler
    Code:
    <br />
    <b>Strict Standards</b>:  strtotime() [<a href='function.strtotime'>function.strtotime</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for '-7.0/DST' instead in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\lib\HTTP\ConditionalGet.php</b> on line <b>339</b><br />
    PASS: Minify : 304 response (1 of 1 tests run so far have passed)
    PASS: Minify : cache, and minifier classes aren't loaded for 304s (2 of 2 tests run so far have passed)
    PASS: Minify : JS and Expires (3 of 3 tests run so far have passed)
    PASS: Minify : Issue 73 (4 of 4 tests run so far have passed)
    PASS: Minify : Issue 89 : bubbleCssImports (5 of 5 tests run so far have passed)
    PASS: Minify : Issue 89 : detect invalid imports (6 of 6 tests run so far have passed)
    PASS: Minify : Issue 89 : don't warn about valid imports (7 of 7 tests run so far have passed)
    !FAIL: Minify : CSS and Etag/Last-Modified (1 of 8 tests run so far have failed)
    PASS: Minify_Build : single file path (8 of 9 tests run so far have passed)
    PASS: Minify_Build : multiple file paths (9 of 10 tests run so far have passed)
    PASS: Minify_Build : file path and a Minify_Source (10 of 11 tests run so far have passed)
    PASS: Minify_Build : uri() with no querystring (11 of 12 tests run so far have passed)
    PASS: Minify_Build : uri() with existing querystring (12 of 13 tests run so far have passed)
    PASS: Minify_HTML_Helper : given URIs (13 of 14 tests run so far have passed)
    PASS: Minify_HTML_Helper : given filepaths (14 of 15 tests run so far have passed)
    <br />
    <b>Notice</b>:  Undefined variable: min_documentRoot in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\groupsConfig.php</b> on line <b>16</b><br />
    <br />
    <b>Notice</b>:  Undefined variable: min_documentRoot in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\groupsConfig.php</b> on line <b>16</b><br />
    <br />
    <b>Notice</b>:  Undefined variable: min_documentRoot in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\groupsConfig.php</b> on line <b>16</b><br />
    <br />
    <b>Notice</b>:  Undefined variable: min_documentRoot in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\groupsConfig.php</b> on line <b>16</b><br />
    <br />
    <b>Notice</b>:  Undefined variable: min_documentRoot in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\groupsConfig.php</b> on line <b>17</b><br />
    <br />
    <b>Notice</b>:  Undefined variable: min_documentRoot in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\groupsConfig.php</b> on line <b>17</b><br />
    <br />
    <b>Notice</b>:  Undefined variable: min_documentRoot in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\groupsConfig.php</b> on line <b>17</b><br />
    <br />
    <b>Notice</b>:  Undefined variable: min_documentRoot in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\groupsConfig.php</b> on line <b>17</b><br />
    <br />
    <b>Notice</b>:  Undefined variable: min_documentRoot in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\groupsConfig.php</b> on line <b>17</b><br />
    PASS: Minify_HTML_Helper : non-existent group & debug (15 of 16 tests run so far have passed)
    PASS: Minify_HTML_Helper : existing group (16 of 17 tests run so far have passed)
    PASS: utils.php : Minify_mtime w/ files & obj (17 of 18 tests run so far have passed)
    <br />
    <b>Strict Standards</b>:  strtotime() [<a href='function.strtotime'>function.strtotime</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for '-7.0/DST' instead in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min_unit_tests\test_Minify_HTML_Helper.php</b> on line <b>56</b><br />
    PASS: utils.php : Minify_mtime w/ obj & group (18 of 19 tests run so far have passed)
    NOTE: Minify_Cache_File : path is set to: 'C:\WINDOWS\TEMP'.
    PASS: Minify_Cache_File : store (19 of 20 tests run so far have passed)
    <br />
    <b>Warning</b>:  filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for C:\WINDOWS\TEMP/Minify_test_cache_noLock in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\lib\Minify\Cache\File.php</b> on line <b>59</b><br />
    !FAIL: Minify_Cache_File : getSize (2 of 21 tests run so far have failed)
    !FAIL: Minify_Cache_File : isValid (3 of 22 tests run so far have failed)
    PASS: Minify_Cache_File : display (20 of 23 tests run so far have passed)
    PASS: Minify_Cache_File : fetch (21 of 24 tests run so far have passed)
    PASS: Minify_Cache_File : store w/ lock (22 of 25 tests run so far have passed)
    <br />
    <b>Warning</b>:  filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for C:\WINDOWS\TEMP/Minify_test_cache_withLock in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\lib\Minify\Cache\File.php</b> on line <b>59</b><br />
    !FAIL: Minify_Cache_File : getSize (4 of 26 tests run so far have failed)
    !FAIL: Minify_Cache_File : isValid (5 of 27 tests run so far have failed)
    PASS: Minify_Cache_File : display w/ lock (23 of 28 tests run so far have passed)
    PASS: Minify_Cache_File : fetch w/ lock (24 of 29 tests run so far have passed)
    !FAIL: Minify_CSS : comments (6 of 30 tests run so far have failed)
    !FAIL: Minify_CSS : hacks (7 of 31 tests run so far have failed)
    !FAIL: Minify_CSS : issue62 (8 of 32 tests run so far have failed)
    PASS: Minify_CSS : paths_prepend (25 of 33 tests run so far have passed)
    PASS: Minify_CSS : paths_rewrite (26 of 34 tests run so far have passed)
    !FAIL: Minify_CSS : selectors (9 of 35 tests run so far have failed)
    !FAIL: Minify_CSS : styles (10 of 36 tests run so far have failed)
    !FAIL: Minify_CSS : subsilver (11 of 37 tests run so far have failed)
    !FAIL: Minify_CSS : unusual_strings (12 of 38 tests run so far have failed)
    !FAIL: Minify_CSS : vladmirated (13 of 39 tests run so far have failed)
    PASS: Minify_CSS_UriRewriter (27 of 40 tests run so far have passed)
    PASS: Minify_CSS_UriRewriter : Issue 99 (28 of 41 tests run so far have passed)
    PASS: Minify_CommentPreserver (29 of 42 tests run so far have passed)
    PASS: Minify_CommentPreserver (30 of 43 tests run so far have passed)
    PASS: Minify_CommentPreserver (31 of 44 tests run so far have passed)
    PASS: Minify_CommentPreserver (32 of 45 tests run so far have passed)
    !FAIL: Minify_HTML (14 of 46 tests run so far have failed)
    !FAIL: Minify_HTML (15 of 47 tests run so far have failed)
    !FAIL: ImportProcessor (16 of 48 tests run so far have failed)
    PASS: ImportProcessor : included right files in right order (33 of 49 tests run so far have passed)
    !FAIL: Minify_Lines (17 of 50 tests run so far have failed)
    PASS: HTTP_Encoder : recognize "x-gzip" as gzip (34 of 51 tests run so far have passed)
    PASS: HTTP_Encoder : gzip w/ non-zero q (35 of 52 tests run so far have passed)
    PASS: HTTP_Encoder : gzip w/ zero q (36 of 53 tests run so far have passed)
    PASS: HTTP_Encoder : IE6 w/o "enhanced security" (37 of 54 tests run so far have passed)
    PASS: HTTP_Encoder : IE6 w/ "enhanced security" (38 of 55 tests run so far have passed)
    PASS: HTTP_Encoder : IE5.5 (39 of 56 tests run so far have passed)
    PASS: HTTP_Encoder : Opera identifying as IE6 (40 of 57 tests run so far have passed)
    PASS: HTTP_Encoder : IE6 w/ "enhanced security" (41 of 58 tests run so far have passed)
    PASS: HTTP_Encoder : deflate : uncompress possible (42 of 59 tests run so far have passed)
    !FAIL: HTTP_Encoder : deflate : compressed to 29.41% of original (18 of 60 tests run so far have failed)
    PASS: HTTP_Encoder : gzip : uncompress possible (43 of 61 tests run so far have passed)
    !FAIL: HTTP_Encoder : gzip : compressed to 29.43% of original (19 of 62 tests run so far have failed)
    PASS: HTTP_Encoder : compress : uncompress possible (44 of 63 tests run so far have passed)
    !FAIL: HTTP_Encoder : compress : compressed to 29.46% of original (20 of 64 tests run so far have failed)
    PASS: HTTP_Encoder : Vary always sent to good browsers (45 of 65 tests run so far have passed)
    PASS: HTTP_Encoder : Vary not sent to bad IE (Issue 126) (46 of 66 tests run so far have passed)
    <br />
    <b>Strict Standards</b>:  strtotime() [<a href='function.strtotime'>function.strtotime</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for '-7.0/DST' instead in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\lib\HTTP\ConditionalGet.php</b> on line <b>339</b><br />
    PASS: HTTP_ConditionalGet : client has valid If-Modified-Since (47 of 67 tests run so far have passed)
    <br />
    <b>Strict Standards</b>:  strtotime() [<a href='function.strtotime'>function.strtotime</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for '-7.0/DST' instead in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\lib\HTTP\ConditionalGet.php</b> on line <b>339</b><br />
    PASS: HTTP_ConditionalGet : client has valid If-Modified-Since with trailing semicolon (48 of 68 tests run so far have passed)
    PASS: HTTP_ConditionalGet : client has valid ETag (non-encoded version) (49 of 69 tests run so far have passed)
    PASS: HTTP_ConditionalGet : client has valid ETag (gzip version) (50 of 70 tests run so far have passed)
    PASS: HTTP_ConditionalGet : no conditional get (51 of 71 tests run so far have passed)
    PASS: HTTP_ConditionalGet : client has invalid ETag (52 of 72 tests run so far have passed)
    <br />
    <b>Strict Standards</b>:  strtotime() [<a href='function.strtotime'>function.strtotime</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for '-7.0/DST' instead in <b>C:\CustomerData\webspaces\webspace_00266635\wwwroot\mcmmo_home\min\lib\HTTP\ConditionalGet.php</b> on line <b>339</b><br />
    PASS: HTTP_ConditionalGet : client has invalid If-Modified-Since (53 of 73 tests run so far have passed)
    !FAIL: JSMin : Overall (21 of 74 tests run so far have failed)
    PASS: JSMin : Don't minify files with + ++ (Issue 144) (54 of 75 tests run so far have passed)
    PASS: JSMin : Quotes in RegExp literals (Issue 74) (55 of 76 tests run so far have passed)
    PASS: environment : DOCUMENT_ROOT should not end in trailing slash (56 of 77 tests run so far have passed)
    PASS: environment : DOCUMENT_ROOT should pass realpath() (57 of 78 tests run so far have passed)
    PASS: environment : DOCUMENT_ROOT should contain this test file (58 of 79 tests run so far have passed)
    !WARN: environment : Local HTTP request failed. Testing cannot continue.
    
     
  6. Offline

    Kiborgik

    http://bonesminecraft.net/mcmmo_home/min/?g=css
    read pls error)
    for IIS need change chmod "min" folder, try it and comment pls
    if this not help:
    • go min/config.php
    • found $min_documentRoot = substr(__FILE__, 0, -15);
    • change it like $min_documentRoot = "c:\\xampp\\htdocs\\ws_for_mcmmo_folder";
    • its your pass if you used windows, or '/home/accountname/public_html' if linux
     
  7. Offline

    Tencao

    It could just be me screwing up, but when I tried to install this, I keep getting this error on min/builder/index.php
    Code:
    Warning: require_once(Solar/Dir.php) [function.require-once]: failed to open stream: No such file or directory in /data/www/slackserv.gaming.multiplay.co.uk/public_html/toplist/min/builder/index.php on line 36
    
    Fatal error: require_once() [function.require]: Failed opening required 'Solar/Dir.php' (include_path='.:/data/www/slackserv.gaming.multiplay.co.uk/public_html') in /data/www/slackserv.gaming.multiplay.co.uk/public_html/toplist/min/builder/index.php on line 36
    And this error on /min/index.php
    Code:
    Warning: require(Minify.php) [function.require]: failed to open stream: No such file or directory in /data/www/slackserv.gaming.multiplay.co.uk/public_html/toplist/min/index.php on line 18
    
    Warning: require(Minify.php) [function.require]: failed to open stream: No such file or directory in /data/www/slackserv.gaming.multiplay.co.uk/public_html/toplist/min/index.php on line 18
    
    Fatal error: require() [function.require]: Failed opening required 'Minify.php' (include_path='.:/data/www/slackserv.gaming.multiplay.co.uk/public_html') in /data/www/slackserv.gaming.multiplay.co.uk/public_html/toplist/min/index.php on line 18
    Anyway on fixing this?
     
  8. Offline

    Kiborgik

    what min/config.php ? and why you go to /min/index.php?
    give me a link to stats on your site
     
  9. Offline

    Tencao

  10. Offline

    Kiborgik

    and your mysql user need have external accses to database
     
  11. Offline

    Tencao

    It should do, levelcraft's web version seems to connect to the database fine, but having issues getting this to connect to mcmmo's, both are on the same database
     
  12. Offline

    Kiborgik

    check config file, and database settings and give me some more info - i'm not a telepat )
     
  13. Offline

    NEO

  14. Offline

    Kiborgik

    chmod
     
  15. Offline

    NEO

    chmod what exactly, cause i followed the instructions exactly. My data folder and json files have the appropriate permissions.
     
  16. Offline

    Kiborgik

    where is http://www.cnation.net/index_ajax.php ?
    try /mmoupdate on chat
     
  17. Offline

    NEO

  18. Offline

    Kiborgik

  19. Offline

    NEO

    /mmoupdate doesnt help

    No clue, what is that page suppose to display normally?

    I can see in the json file all the users are listed, only 3 in json skills.
     
  20. Offline

    Kiborgik

  21. Offline

    alfskan

    I got 500 internal server error after update to 0.5 [pig]

    EDIT: deleted .htaccess
    no more internal error but couldnt load mysql database.
    means there are nobody at web list.

    I cant use this version. can you please upload fore version?
     
  22. Offline

    Kiborgik

    on you server enabled mining?
     
  23. Offline

    alfskan

    you mean mining skill?

    enabled.[sheep]
     
  24. Offline

    Kiborgik

    link?
     
  25. Offline

    Xcite4Ever

    Hey Kiborgik.

    Trying to run the WS v0.5 webstats for mcMMO but keep hiting this problem message:

    MySQL Error!
    ------------------------

    The Error returned was:
    Lost connection to MySQL server at 'reading initial communication packet', system error: 110

    Error Number:
    2013

    I believe everything is setup correctly in the config.php file because I'm using the same info that I used to create the MySQL tables for mcMMO.

    A little help would be appreciated.

    Thx
     
  26. Offline

    Kiborgik

    on my.cnf change bind-address = real.ip
     
  27. Offline

    Kommy000

    How would you show 100 entries default instead of 10?
     
  28. Offline

    Xcite4Ever

    Can't access the my.cnf because I don't have that kinda of access to MySQL server. I normaly use MySQL Workbench to read and write to the tables, apart from the mcMMO plugin doing it by itself.

    Do you have any other solution?
     
  29. Offline

    Kiborgik

    search a way to access

    you can found it on http://www.datatables.net/examples/
    or waiting a new version whith more configuration

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 14, 2016
  30. Offline

    vanja

    I'M STUCK!!! using 000webhost, when i enable mcmmo sql mcmmo stops wokring help help help :(((

    also wtf is this:
    The Error returned was:
    Access denied for user 'a3717093_vanjavk'@'srv15.000webhost.com' (using password: YES)

    it also says when loading mcmmo something like my adress is not allowed on mysql wtf, someone help!!!


    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 14, 2016
  31. Offline

    Kiborgik

    see like incorrect password, recheck config.php, and add external host for mysql
     

Share This Page