Please need help with bans and mysql

Discussion in 'Bukkit Help' started by kept, Oct 1, 2012.

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

    kept

    Hello...

    I tried the ban managment and all I got is a messed up server. (I had the latest update and 1.3.2 recommend build..)

    Can any1 please suggest something for storing the ban information to mysql? I dont need a plugin who will do the banning..only a plugin or a tool, that will store information to mysql so I can use it for my website.. Or suggest a ban plugin that work and is the simplest of all the ban plugins..

    Thank you!

    edit:
    Maybe anyone can explain, how to use those ban plugins only for to make a banlist not for BANNING the players.. ?
     
  2. Offline

    mmorton89

    Do you not know how to make a mysql database?
    I don't think there is a plugin that makes databases.
     
  3. Offline

    kept

    Umm, sorry? I guess You understood me wrong.. Sorry, maybe because I m in a rush and im not an american or english, so this language is not perfect..


    Any feeds about this plugin?

    http://dev.bukkit.org/server-mods/dynamicban/
     
  4. Offline

    kept

    BUMP..
     
  5. Offline

    kept

    topic is over the fifth page... BUMP
     
  6. Offline

    CRAZYxMUNK3Y

    Have a look at FigAdmin, it uses MySQL and also comes with a code that you can put on your website to show who was banned, when, by who and when they are unbanned (If temp)
     
  7. Offline

    kept

    The last update was for the 1.2.5 craftbukkit version.. I am using the 1.3.2. recommended build..
    Maybe anyone can tell how it's possible to use those plugins ONLY for to make a list not for banning?
     
  8. Offline

    CRAZYxMUNK3Y

    kept
    It still works fine in 1.3.2 though. The issue with making a plugin to just make a table is that all ban plugins are made and save data differently. You can use the one supplied by FigAdmin, but you will have to edit where it gets the data from (Table names mainly).

    FigAdmin PHP Code (open)

    <?
    header('Content-Type: text/html; charset=utf-8');
    ?>
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title>Banned Players of server</title>
    </head>
    <body>
    <?php

    // change these things

    $server = "localhost";
    $dbuser = "root";
    $dbpass = "root";
    $dbname = "minecraft";

    mysql_connect($server, $dbuser, $dbpass);
    mysql_select_db($dbname);

    $result = mysql_query("SELECT * FROM banlist ORDER BY time DESC");

    echo "<table width=70% border=1 cellpadding=5 cellspacing=0>";

    echo "<tr style=\"font-weight:bold\">
    <td>Name</td>
    <td>Reason</td>
    <td>Admin/Mod</td>
    <td>Time of ban</td>
    <td>Time of unban</td>
    </tr>";

    while($row = mysql_fetch_assoc($result)){

    if($col == "#eeeeee"){
    $col = "#ffffff";
    }else{
    $col = "#eeeeee";
    }
    echo "<tr bgcolor=$col>";

    echo "<td>".$row['name']."</td>";
    echo "<td>".$row['reason']."</td>";
    echo "<td>".$row['admin']."</td>";
    echo "<td>".date("d M, Y g:ia",$row['time'])."</td>";
    if($row['temptime'] == "0"){
    echo "<td>∞</td>";
    }else{
    echo "<td>".date("d M, Y g:ia",$row['temptime'])."</td>";
    }

    echo "</tr>";
    }

    echo"</table>"

    ?>
    Ban database provided by
    <a href="http://dev.bukkit.org/server-mods/figadmin/">FigAdmin</a>.
    </body></html>


    Hopefully that explains things.
     
  9. Offline

    kept

    I have everything ready for the web.. All I need is a plugin, that wouldnt make any problems, like banned players can still connect to the server... And would store the info in database..
     
Thread Status:
Not open for further replies.

Share This Page