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

    omerdn1

    it's not updating

    EDIT: Never mind
     
  3. Offline

    Kiborgik

    what you want see on WS from this plugins?
     
  4. Offline

    Nikhil

    @Kiborgik
    I get this error:

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

    The Error returned was:
    Table 'mcMMOstats.mcmmo_users' doesn't exist

    Error Number:
    1146
     
  5. Offline

    Kiborgik

    and you didnt know english? ) configure mcmmo for mysql
     
  6. Offline

    Nikhil

    Still getting the error can you tell me whats wrong
    @Kiborgik

    mcMMO config file:
    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
    #Mon Jun 27 20:32:19 MSD 2011
    treeFellerCooldown=180
    CobblestoneItemRepairName=Cobblestone
    gigaDrillBreakerCooldown=180
    canExcavateNetherrack=true
    WoodItemRepairName=Wood Planks
    excavationXpModifier=2
    woodcuttingXpModifier=2
    globalXpModifier=1
    /mcitem=mcitem
    enableMOTD=true
    archeryFireRateLimit=true
    herbalismXpModifier=2
    archeryXpModifier=2
    GoldItemRepairName=Gold Bars
    canExcavateCake=true
    MySQLuserName=root
    /mctop=mctop
    acrobaticsXpModifier=2
    canExcavateDiamond=true
    /mcc=mcc
    abilityDurabilityLoss=2
    canExcavateMusic=true
    /stats=stats
    gravelToClay=true
    superBreakerCooldown=180
    /ptp=ptp
    axesXpModifier=2
    skullSplitterCooldown=180
    CobblestoneRepairItemNumber=4
    canExcavateSulphur=true
    woodcuttingRequiresAxe=true
    repairXpModifier=2
    MySQLdbName=mcMMOstats
    MySQLdbPass=
    locale=en_us
    enableMySpawn=true
    GoldRepairItemNumber=266
    /mcability=mcability
    /mmoedit=mmoedit
    MySQLport=3306
    UseMySQL=true
    xpGainMultiplier=1
    canExcavateApples=true
    /addxp=addxp
    MySQLTablePrefix=mcmmo_
    /whois=whois
    pvpGivesXP=true
    DiamondRepairItemNumber=264
    IronRepairItemNumber=265
    /clearmyspawn=clearmyspawn
    canExcavateGlowstone=true
    greenTerraCooldown=180
    canExcavateEggs=true
    enableHpRegeneration=true
    enableGreenThumbCobbleToMossy=true
    DiamondItemRepairName=Diamond Ore
    IronItemRepairName=Iron Bars
    /setmyspawn=setmyspawn
    repairDiamondLevel=50
    /mcgod=mcgod
    pvpXpRewardModifier=1
    canExcavateMushrooms=true
    tamingXpModifier=2
    anvilMessages=true
    /myspawn=myspawn
    /mcmmo=mcmmo
    /invite=invite
    pvp=false
    /accept=accept
    canExcavateSlowSand=true
    berserkCooldown=180
    miningXpModifier=2
    /party=party
    feathersConsumedByChimaeraWing=10
    MySQLServer=localhost
    WoodRepairItemNumber=5
    swordsXpModifier=2
    canExcavateBones=true
    unarmedXpModifier=2
    miningRequiresPickaxe=true
    canExcavateCocoaBeans=true
    serratedStrikeCooldown=180
    /mcrefresh=mcrefresh
    toolsLoseDurabilityFromAbilities=true
    
    WS config file:

    Code:
    <?php
    /*
    @[URL='http://forums.bukkit.org/members/last.46338/']Last[/URL] change (20.06.2011)
    ---
    @[URL='http://forums.bukkit.org/members/config.15327/']config[/URL] file
    ---
    @author Kiborgik (maile and donate [email protected])
    ---
    */
    $config['mysql_user']="root";
    $config['mysql_password']="(thereisapassword) just not saying";
    $config['mysql_database']="mcMMOstats";
    $config['mysql_server_ip']="localhost";
    $config['mysql_port']=3306;
    $config['time_cache']=300;
    $config['prefix']="mcmmo_";
    ?>
    
     
  7. Offline

    Kiborgik

     
  8. Offline

    Nikhil

    Edit: Sorry fixed it now just me being stupid...
     
  9. Offline

    Wahrheit

    @Kiborgik I'm getting an access denied error using the exact same info that I use for my mcMMO database. Do I need to allow any remote MySQL or anything?
     
  10. Offline

    Kiborgik

    what error? i'm not a telepat (copy it)
     
  11. Offline

    Wahrheit

    I fixed it, your script doesn't allow DNS. Has to be an IP.
     
  12. Offline

    Kiborgik

    it used standart php functions :) and for me work with name.com (example)
     
  13. Offline

    Kiborgik

    0.5 coming soon [cake]
     
    jeffreylec likes this.
  14. Offline

    pitbully

    Hey, I edited the config file with my MySQL information however, I get the following error explaining that it can't connect to my database. Do I have to change settings on my Database to allow the website to get information?

    Show Spoiler

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

    The Error returned was:
    Access denied for user 'root'@'localhost' (using password: YES)

    Error Number:
    1


    I am absolutely certain the information I used was correct.

    (EDIT) Do I need to open the port 3306? I would assume so right?
     
  15. Offline

    Kiborgik

    this error mean - you used incorrect password and/or you can acsses only on localhost whith root ( need add new mysql user and configure it )
     
  16. Offline

    pitbully

    Show Spoiler

    Ok ty, I will configure a new user and see if that works.

    EDIT: That didn't work from what I can tell. I even gave the new user ALL permissions and ALL access rights. I will post my configure file to see if there is something missing.

    Code:
    <?php
    /*
    @[URL='http://forums.bukkit.org/members/last.46338/']Last[/URL] change (20.06.2011)
    ---
    @[URL='http://forums.bukkit.org/members/config.15327/']config[/URL] file
    ---
    @author Kiborgik (maile and donate [email protected])
    ---
    */
    $config['mysql_user']="root";
    $config['mysql_password']="Correct Password Inserted Here";
    $config['mysql_database']="minecraftbeta";
    $config['mysql_server_ip']="localhost";
    $config['mysql_port']="3306";
    $config['time_cache']="300";
    $config['prefix']="mcmmo_";
    ?>
    
    for mysql_database, I have used my schema that includes the mysql data for my minecraft beta server. Is this the correct thing to put there? I am asking, is a Schema a Database? I am a MySQL Noob but I am trying to learn. I use MySQL Workbench for all editing.


    EDIT: I got it to work! Eventually I made a MySQL user matching my hosting service to allow the host to connect to the database at my server's IP (Not localhost) and "MAGIC". It all works now! Thanks :D
     
  17. Offline

    Evotr1p197

    Do i need a Website for this? : S
     
  18. Offline

    Kiborgik

    yes )
    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
     
  19. Offline

    LeGenDaryX

    I have a website but it doesnt support PHP anyway around this or a free host for php?
     
  20. Offline

    Kiborgik

    search a host whith php )
     
  21. Offline

    Axfan

    Hi for some reason the min includes are not working for me. Is there any way to fix this? Do I have to install somthing to use minify?
     
  22. Same issue here, proper broken right now :/
     
  23. Offline

    Robert McKay

    Great, I installed it. But compared to yours, mine looks like shit (its all plain and ugly)

    http://wurld.us/webstats
     
  24. Offline

    Kiborgik

    use test like: http://ratings.crafthero.net/min_unit_tests/test_all.php
    folder min_unit_tests you can download on download page
    and give me your results
    also pls chek mod_gzip installed on Apache

    Pls redownload who has problems, fixed document_root directory for minify

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

    Axfan

    I feel kind of dumb now, I needed to chmod all the directories inside of minify. Works great now! Keep up the good work and thanks for your help. :)
     
  26. Offline

    Kiborgik

    any ideas what adding on next relise? maybe integration whith other plugins, what used mysql? pls help )
     
  27. Offline

    RugRats

    0.5 gives an internal error.
     
  28. Offline

    Kiborgik

    i am not a telepat
     
  29. Offline

    RugRats

    Well 0.4 works just fine so you must of messed something up in 0.5 All it says is that there is an internal error and that i should contact the creator.
     
  30. Offline

    Kiborgik

    screen or copy error? )
     
  31. Offline

    RugRats

    Theres nothing just when you try to go to the page it says internal error contact the maker. No errors just that message.
     

Share This Page