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

    Monk3y

    i had the exact same error follow his instruction on page 1 bottom of the page
     
  3. Offline

    Kiborgik

    what MySQL database you writing on mcmmo properties?
    MySQL DB Name - Put your DB name here
    write this DB name on conect function
     
  4. Offline

    Leemur

    ok, I changed my mcmmo.proprties like that:
    Code:
    #==McMMO Configuration==
    #You can turn off excavation loot tables by turning the option to false
    #You can customize mcMMOs command names by modifying them here as well
    #This is an early version of the configuration file, eventually you'll be able to customize messages from mcMMO and XP gains
    #Sun May 01 12:22:21 EEST 2011
    /whois=whois
    canExcavateApples=true
    /mcability=mcability
    repairXpModifier=2
    /party=party
    /stats=stats
    MySQLuserName=root
    serratedStrikeCooldown=240
    gigaDrillBreakerCooldown=240
    skullSplitterCooldown=240
    abilityDurabilityLoss=2
    canExcavateEggs=true
    MySQLport=3306
    toolsLoseDurabilityFromAbilities=true
    archeryXpModifier=2
    feathersConsumedByChimaeraWing=10
    /mmoedit=mmoedit
    /mctop=mctop
    axesXpModifier=2
    /accept=accept
    superBreakerCooldown=240
    herbalismXpModifier=2
    /ptp=ptp
    berserkCooldown=240
    MySQLdbPass=1174812030
    /mcc=mcc
    xpGainMultiplier=1
    excavationXpModifier=2
    pvp=true
    woodcuttingRequiresAxe=true
    canExcavateMushrooms=true
    anvilMessages=true
    canExcavateCocoaBeans=true
    canExcavateGlowstone=true
    /setmyspawn=setmyspawn
    canExcavateSulphur=true
    repairDiamondLevel=50
    /invite=invite
    greenTerraCooldown=240
    MySQLdbName=test
    woodcuttingXpModifier=2
    unarmedXpModifier=2
    canExcavateDiamond=true
    canExcavateSlowSand=true
    /myspawn=myspawn
    /clearmyspawn=clearmyspawn
    /mcmmo=mcmmo
    canExcavateMusic=true
    treeFellerCooldown=240
    canExcavateNetherrack=true
    acrobaticsXpModifier=2
    MySQLTablePrefix=mcmmo_
    pvpXpRewardModifier=1
    miningXpModifier=2
    MySQLServer=localhost
    UseMySQL=true
    globalXpModifier=1
    /addxp=addxp
    /mcitem=mcitem
    /mcgod=mcgod
    miningRequiresPickaxe=true
    tamingXpModifier=2
    canExcavateCake=true
    archeryFireRateLimit=true
    gravelToClay=true
    /mcrefresh=mcrefresh
    pvpGivesXP=true
    canExcavateBones=true
    swordsXpModifier=2
    
    
    now, my index.php page it's blank (only shows the User Table without any users).
    In my C:\AppServ\MySQL\data\test , which was a blank folder, I descovered a list of files:
    mcmmo_experience.frm
    mcmmo_experience.MYD
    mcmmo_experience.MYI
    etc.. etc..

    I think the informattion in these files are writting wrong.
    Here it is an example for the containing file mcmmo_experience.frm
    Code:
    ю            0  й 1          !               й   ѓГ
            //                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
           Ђ  @ яPRIMARYя                                                                                                                                                                                                         я                                                   MyISAM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
    I use mcc 1.005 and bukkit 740
     
  5. Offline

    Kiborgik

    you write in game "/mmoupdate" ???
     
  6. Offline

    tha d0ctor

    great, too bad im having problem with errors =getting to my database with mcmmo, once the developer fixes mysql this should be great, can't wait!
     
  7. Offline

    Leemur

    yes, Conversion finished!
    but no change. The file is still corrupted.
     
  8. Offline

    Monk3y

    lol all my db information is now corrected and all i get is this

    Fatal error: Class 'webstats' not found in /home/modtv/www/default/public/public/modtvblog/war-room/stats/index.php on line 30

    am i missing something? a variable i need to add
    PHP:
    <?php
    /*
    @[URL='http://forums.bukkit.org/members/last.46338/']Last[/URL] change (02.05.2011)
    ---
    @index file
    ---
    @author Kiborgik (maile and donate [email protected])
    ---
    v0.2
    - add powerlevel
    - some bugfix
    - some cleanups
    - compare phpversion
    - add config (time_cache, prefix)
    v0.1
    - initial relise
    - support mcMMO
    - caching json files
    */
    @error_reporting E_ALL E_WARNING E_NOTICE );
    @
    ini_set 'display_errors'true );
    @
    ini_set 'html_errors'false );
    @
    ini_set 'error_reporting'E_ALL E_WARNING E_NOTICE );
    define 'http://blog.modtv1337.com/war-room/stats/classes'dirname __FILE__ ) );
    //start of compare
    if (version_compare(PHP_VERSION'5.2.1') >= 0) {
        include_once (
    ROOT_DIR.'/classes/mysql.php');
        include_once (
    ROOT_DIR.'/classes/webstats.class.php');

        
    $ws = new webstats();
        
    $ws->connect('modtv''Melinko757''war-room''localhost'); //your settings
        
    $ws->config('time_cache'300); //in sec
        
    $ws->config('prefix''modtv_'); //default prefix
        
    $ws->processingUsers();

    ?>
     
  9. Offline

    Kiborgik

    why you changed?
    Code:
    define ( 'http://blog.modtv1337.com/war-room/stats/classes', dirname ( __FILE__ ) );
    back up to
    Code:
    ROOT_DIR
    and prefix? - dont changed if you dont know what you do
     
  10. Offline

    sdvn

    good job ! awesome webstats
     
  11. Offline

    Kiborgik

    thank you )
     
  12. Offline

    Sketaful

    Download says its v0.1?
     
  13. Offline

    Kiborgik

    thanks, i fix it, named correct, but link is not
     
  14. Offline

    Jaypee

    Anyone knows how to run this with brohoster? Its giving me the error Can't connect to MySQL server on 'brohoster.com' (110)

     
  15. Offline

    Kiborgik

    i think you need changed "localhost" to you server host, see it on control panel, or ask support
     
  16. Offline

    noob4action

    is it possoble two write somethink like an auto-updater?
    best would be a plugin which automaticly updates sql table(from webserver) every x minutes.
    (The plugin can create a table backup and then it can call a php script wich downloads backup via ftp and update's the database of the webserver)
    I'm not able do use write java :(
     
  17. Offline

    Kiborgik

    what you mean? mcMMO autoupdate tables every x minutes
     
  18. Offline

    noob4action

    yeah but often you haven't got access to the database from you webspace.
    For exampe: I use nitrado. then i use a free hoster to host the stats. from there i haven't got access to the nitrado database where mcmmo stores the information. so i wish do have a plugin which makes a backup form selected tables and then calls a php script which imports the data in the webspace database
    did you understant?(else i try it again ;))

    noob4action
     
  19. Offline

    Kiborgik

    use phpmyadmin for import and export database, and no need to reinvent the wheel
     
  20. Offline

    noob4action

    yeah i do at the moment but it would be better if it's autmatic
     
  21. Offline

    Quintin Rose

    I like this. will load ASAP
     
  22. Offline

    HEmile

    I have no clue how to install this. Any help?
     
  23. Offline

    Kiborgik

    you have ICQ?
     
  24. Offline

    HEmile

    eh... no. As I said, I've no clue XD
     
  25. Offline

    TheShadow777

    hey kiborgik i love the idea of this webstats but at me doesnt work, can you help me pls ? maybe at icq ? would be nice :(
     
  26. Offline

    Kiborgik

    273556442 or write you number - i write to you
     
  27. Offline

    MikeThePickle

  28. Offline

    MikeThePickle

    I hope you improve on the formatting a little in the coming versions. Some friendly suggestions:
    1) Change the font. Times New Roman is quite overused and boring.

    2) Get rid of the Users tab or make the Users Skills the default tab.

    3) Make the text larger. Bold the names.

    4) Decrease Cell Width. The cell widths are gigantic for only containing numbers in them. I know they're somewhat wider for the titles but the current widths makes it stretch off the page.

    5) Instead of dark grey/black and grey alternating, maybe change it to white and grey alternating? It would seem a bit easier on the ol' eyes.

    6) Not really a suggestion but just praise. This plugin is awesome, thank you! I really like the sortable columns!

    I know these are all things I can do to customize it but these are just suggestions to change for the default. I think you'll attract more players to your plugin if it looks a bit nicer. Thanks for the great plugin.
     
  29. Offline

    Sketaful

    Hmmm.. Installed, Changed mcMMO to use mysql, all tables done. Checking the page and woa... Looks like everything works, all skillpoints are there, all players to... But wait.. Last login = 1970??? :p

    Edit: So, now it's working :p Just some probs with the transfer to mysql, after next login all was ok. :) Nice one this.

    If anyone feel like doing a wp-plugin for this Id love it :p
     
  30. Offline

    Kiborgik

    thanks for yours responses, when i get better, i'll fix it and do update
     
  31. Offline

    kahlilnc

    OMG I have no idea where to start. Can I add this to my free web site I made? If so how? lol Im a nub.
     

Share This Page