Plugin Addon: bbStats for BigBrother!

Discussion in 'Bukkit Tools' started by theoutrider, Feb 2, 2011.

Thread Status:
Not open for further replies.
  1. Offline

    nakashimakun

    maehze. Thanks for that code now mine looks a little better But i think the one N3X15 is working on looks amazing I would love mine to display like that.

    Brian.
     
  2. Offline

    Lee Hayward

    N3X15, can you send me your version of this script please.. Or chuck it up on GIT so everyone can get hold of it, maybe even add to it etc.. ;)
     
  3. Offline

    Devion

    Love this site addon and so do my players! Many many kudos from me and them alike ;)

    Since I was fiddling a bit with the code, here and 2.. tho they need some better gfx.

    Code:
    config_awards.php:
    define("AWARDNAME_PARTY",	"Party Man!");
    define("AWARDICON_PARTY",	"images/awards/cake.png");
    define("AWARDTEXT_PARTY",	" knows it ain`t no lie!.");
    define("AWARDACTION_PARTY", BLOCK_CAKE);
    define("AWARDTYPE_PARTY",	NULL);
    define("AWARDSORT_PARTY",	"top");
    
    define("AWARDNAME_ARMED",	"Armed");
    define("AWARDICON_ARMED",	"images/awards/pvp.png");
    define("AWARDTEXT_ARMED",	" is a walking tank!");
    define("AWARDACTION_ARMED",	ARMED_BLOCKS);
    define("AWARDTYPE_ARMED",	NULL);
    define("AWARDSORT_ARMED",	"top");
    
    blocks_constants.php:
    define("ARMED_BLOCKS", "310,311,312,313,276");
    
     

    Attached Files:

  4. Offline

    Lee Hayward

    Has anyone heard from N3X15 , I'd like to discuss getting hold of the code he put together for his bbstats!
     
  5. Offline

    Anoniempje

    Any one got this running on remote server?
    I want this on my webhost but connect to my server a home, but i keep getting an error that it cant connect, ip, user, password, database, all are correct, the debug doesn't show new information that will help me find the source of the problem.

    Fixed it, root was localhost only, needed to add a new user to mysql with my webhost as remote adress. Next up: Why is it empty?...
     
  6. Offline

    heri7

    I can't get bbstats to work. I'm stuck at the Message: "An error has occurred: Database not set up"
    There is a db called minecraft on localhost and there is also the bbdata table.
    here is my config_base.php:
    Code:
    <?php
    // Set SERVER_NAME to '' to hide header text entirely. Good if you want a graphical banner.
    define('SERVER_NAME',        'My Minecraft Server');
    
    // Point this to the directory your MC server resides in. Unused unless you're running SQLite.
    define('SERVER_PATH',        '/opt/mcserver/');
    
    // Currently unused, originally intended for calculating SMP world size.
    define('WORLD_NAME',        'world');
    
    // Database config! Uncomment these to use SQLite (NOT RECOMMENDED due to performance issues)
    //define('DB_MODE',        'sqlite');
    //define('SQLITE_DB',        SERVER_PATH.'plugins/BigBrother/bigbrother.db');
    
    // Edit these to match your MySQL configuration.
    define('DB_MODE',        'localhost:3306/minecraft');
    define('MYSQL_HOST',        'localhost');
    define('MYSQL_USER',        '***');
    define('MYSQL_PASSWORD',    '***');
    define('MYSQL_DATABASE',    'bbdata');
    
    // Time/DB entry limits for awards and toplists. Set to non-0 values if your database is very large and causes the bbStats index page to time out. Entries take priority over days.
    define("STATLIMIT_ENTRIES",    0);
    define("STATLIMIT_DAYS",    0);
     
    // Set to 1 to enable debug mode. Will spew SQL statements and other shenanigans.
    define('BBSTATS_DEBUG',        0);
    
    ?>
    
     
  7. Offline

    Lee Hayward

    Can someone tell me what code I'd need to add on the Index page to have the last logged in time shown next to each players name.. I'm stuck!! help please ;)
     
  8. Offline

    Direct1221

    Change 'bbdata' to 'minecraft'
     
  9. Offline

    Hoddie54

    Hello,
    I am a big lover of BB. I just wanna know if an SQL Database not be stored on localhost and still keep the server running smoothly. This is because my VPS and Webserver for my website are seperate and I wish to use bbStats. MySQL databases are easy to setup on cPanel and It won't lag my VPS (I think).

    Is it better for me to
    a)Host the Database on my VPS and get the Webserver to connect to my VPS
    b) Host the database on my webserver and get my VPS to connect to my webserver

    Thanks in Advance
    --- merged: Feb 22, 2011 7:00 PM ---
    Im getting the following error: anything?
    NOTE: My Database is currently empty
    Code:
    Getting player list...SELECT player FROM bbdata WHERE player NOT IN ("Environment") GROUP BY upper(player) LIMIT 50
    
    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/thepromi/public_html/bb/bbStats/support.php on line 73
    
    Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/thepromi/public_html/bb/bbStats/support.php on line 81
    array(0) { }
    Getting awards...SELECT player FROM bbdata WHERE action=0-864000 GROUP BY player ORDER BY COUNT(player) DESC LIMIT 10
    
    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/thepromi/public_html/bb/bbStats/support.php on line 73
    
    Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/thepromi/public_html/bb/bbStats/support.php on line 81
    SELECT player FROM bbdata WHERE action IN (1) AND type IN (5,20,22,23,24,25,41,42,43,44,45,46,47,50,53,54,57,58,61,63,64,65,66,67,68,69,70,71,75,80,84,85,91,92)-864000 GROUP BY player ORDER BY COUNT(player) DESC LIMIT 10
    
    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/thepromi/public_html/bb/bbStats/support.php on line 73
    
    Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/thepromi/public_html/bb/bbStats/support.php on line 81
    SELECT player FROM bbdata WHERE action IN (1) AND type IN (1,2,3,4,6,7,8,9,10,11,12,13,14,15,16,17,19,21,37,38,39,40,48,49,51,56,73,78,79,81,82,83,86,87,88,89)-864000 GROUP BY player ORDER BY COUNT(player) DESC LIMIT 10
    
     
  10. Offline

    Hoddie54

    EDIT: Does this work with the latest version???
     
  11. Offline

    gaaranosuna

    Hi, I have an error on my web page : Notice: Undefined offset: 0 in C:\wamp\www\bbStats\support.php on line 124

    N3X15 can I have you script please ? thanks
     
  12. Offline

    Lord Chaos

    I am getting:

    There is no database connection set up. Please inform the server administrators that database information needs to be entered in bbStats' config.php.

    My config is:

    Code:
    define('DB_MODE',        '***.***.***.***:3306/minecraft');
    define('MYSQL_HOST',        '***.***.***.***');
    define('MYSQL_USER',        'minecraft');
    define('MYSQL_PASSWORD',    '******');
    define('MYSQL_DATABASE',    'minecraft');
    I am not sure where I am going wrong, this is connecting to a remote Win2008 machine that has MySQL.
     
  13. Offline

    Lee Hayward

    So I gave up waiting for N3X15 to pass me the script he promised to give anyone who asked. I instead went ahead and clumbsily hacked my own scripts together.. Check it out for yourself here: nerks.co.uk , it's the big brother link and there's drop down menu as well.. I've split the parts up , i.e the main page shows a quick overview, then the drop down menus go into more detail... Anyway , let me know what you think..
     
  14. Offline

    contex

    I'm working on something similar, using both BigBrother and Stats. My BigBrother database has about 500,000 records so I created a PHP fucntion which works with cron that creates a new table and export the data from BigBrother every 30 min, so the load time is way easier, anyhow: http://moincraft.com/stats.php, design and code is nowhere to finished. Click on an item icon to see more information.
     
  15. Offline

    M4lk4vi4n

    Why instead of playername is showed a number (and the number it's the same of key "ID" in the "bbusers" table)?

    i use bbrother 1.11 >.>

    p.s. so sorry for bad english, i'm italian...
     
  16. Offline

    harakiwi

    outdated months ago

    the BigBrother Developer changed the table id in the SQL database
     
Thread Status:
Not open for further replies.

Share This Page