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

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 Hide Spoiler

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:
9. • 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 Hide 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 (ideas?)
• need mining > 0 for adding to table
• now limit 1000 users whith biggest mining skill
• fix some html errors

v0.4

• rewrite front-end
• better css+js
• change to Datatables v1.8.0 http://www.datatables.net/
  • add search
  • all previos functions stay
  • add power functional for future
• add ui themes http://www.datatables.net/styling/themes
• more customizations whith http://www.datatables.net/examples/
• fix "Error: can't load data/users.json"
• moved style.css to "css" folder
• remove "them" folder & add "themes"
• remove not used js files
• add config.php (now all customizations on it)
• other fixes

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);

 

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

 

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

 

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

 

you write in game "/mmoupdate" ???

 

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!

 

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

 

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();

?>

 

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

 

good job ! awesome webstats

 

thank you )

 

Download says its v0.1?

 

thanks, i fix it, named correct, but link is not

 

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

 

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

 

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

 

what you mean? mcMMO autoupdate tables every x minutes

 

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

 

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

 

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

 

I like this. will load ASAP

 

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

 

you have ICQ?

 

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

 

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

 

273556442 or write you number - i write to you

 

http://peoplesminecraftserver.com/stats/mcmmo/index.php

;D

 

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.

 

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???

Edit: So, now it's working 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

 

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

 

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.