[INACTIVE][ADMN/SEC/WEB] DataLog - replaced by HawkEye [1000]

Discussion in 'Inactive/Unsupported Plugins' started by oliverw92, Apr 15, 2011.

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

    oliverw92

    Vaupell, Pinkpixels, Sleaker and 2 others like this.
  2. Offline

    anglish

    Cool I'll download it now, i think i did something wrong, the rollback command seems fine now!
     
  3. Offline

    oliverw92

    Coming up in the next version, advanced rules for anti-griefing, anti-swearing etc!

    Code:
    rules:
        fireblock:
            events:
            - 'block-place'
            pattern: '\b51\b'
            worlds:
            - build
            notify-message: '%PLAYER% placed illegal fire block on %WORLD%'
            warn-message: 'You are not allowed to place illegal fire blocks on %WORLD%!'
            action:
                notify: true
                warn: true
                kick: true
                deny: true
            exclude-groups:
            - admins
            - moderator
        no-swears:
            events:
            - 'chat'
            pattern: '(asshole|noob|idiot)'
            notify-message: ''
            warn-message: '%MATCH% is a banned word! Do not say it!'
            action:
                warn: true
            exclude-groups:
            - admins
        no-adminium-items:
            events:
            - 'item-drop'
            - 'item-pickup'
            pattern: '\badminium\b'
            notify-message: '%PLAYER% dropped/picked up adminium on %WORLD%'
            warn-message: 'Do not try to pickup or drop adminium!'
            action:
                notify: true
                warn: true
                kick: true
                deny: true
        no-explosions:
            events:
            - 'explosion'
            action:
                deny: true
    
    As the last rule shows - you can also use to stop any action on datalog from happening - you can deny explosions all the way through to snow formation!
     
  4. Offline

    untergrundbiber

  5. Offline

    oliverw92

  6. Offline

    Xaqa

    Quick question, I have Multiplay host. And I'm using my own website as a host for mySQL. Does the plugin automatically configure the MySQL database(s)? If not, where can I find this configuration?
     
  7. Offline

    oliverw92

    It creates the tables for you. Just give it the database information and you are good to go!
     
  8. Offline

    Xaqa

    @oliverw92

    Well, I did that you see.. and I'm getting this error:
    Error! Table 'crowngaming_IC_20100727_185212.dl_players' doesn't exist
     
  9. Offline

    oliverw92

    Is that from the minecraft console log?

    Working perfectly on 953

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

    darrenstraight

    @Oliver thanks for this plugin, quite suprised I hadent seen it until today when it was suggested as logblock isnt working at the moment for us, I love the web interface nice touch as we were working on one for logblock but well you've already saved us some time now on using this plugin instead. Shame doesnt log whats been taken from a chest though!
    Anyway we are on 1.1.0 and Ive tried /dl rollbackhelp but it just shows me the same commands as /dl help
    Would you be able to provide me with a list of parametres for /dl rollback please?
    Thanks,
    Darren
    p.s. Keep it up!
     
  11. Offline

    oliverw92

    Sorry I forgot that command :p It is already in the next version which will be coming tomorrow.

    The parameters are identical to searching except for you can't use l: in rollbacks - take a look on the wiki, it shows you everything about it.

    Glad you like it!
     
  12. Offline

    darrenstraight

  13. Offline

    Xaqa

  14. Offline

    oliverw92

    Please tell me this:

    • Where is your minecraft server hosted
    • Where is the mysql database hosted that datalog logs to
    • Where is your web interface hosted
     
  15. Offline

    Xaqa

    1.) Multiplay Server Hosts - multiplay.co.uk
    2.) iPage Web Host - ipage.com
    3.) I don't know what you mean, can you explain?
     
  16. Offline

    oliverw92

    Can multiplay not supply you with a database?

    I mean where are the PHP files hosted.
     
  17. Offline

    Xaqa

    No multiplay doesn't supply a database. And I guess hosted on my ipage account. I uploaded them via FTP. :p

    Also, just a note multiplay uses 1.1.1 but their config file is different from yours. Theirs is:

    Code:
    max-lines: 0
    tool-block: 17
    cleanse-age: 0d0h0s
    block-filter:
    - 33
    - 34
    max-connections: 10
    debug: false
    max-radius: 100
    log:
        lava-bucket: true
        block-burn: true
        water-bucket: true
        other: true
        pvp-death: true
        leaf-decay: true
        block-break: true
        open-chest: true
        chat: true
        join: true
        snow-form: true
        quit: true
        sign-place: true
        block-place: true
        door-interact: true
        flint-steel: true
        button: true
        explosion: true
        command: true
        teleport: true
        lever: true
    version: 1.1.1
    mysql:
    port: 3306
    username: crowngamin_app
    hostname: ****************
    password: *************
    database: crowngaming_IC_20100727_185212
    command-filter:
    - /login
    - /restartsrv
    - /register
    
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 13, 2016
  18. Offline

    oliverw92

    The plugin is on 1.2.0 now, update the plugin.
     
  19. Offline

    h0us3cat

    I made a language pack/file.
    For some reason the layout is wrong now :oops:
    Show Spoiler

    <?php

    ///////////////////////////////////////////////////
    // DataLog Interface Lang File //
    // by oliverw92 //
    ///////////////////////////////////////////////////
    // Use this file as a template for //
    // creating other language files. To use //
    // a language file, change the setting in //
    // config.php to point to the new file //
    ///////////////////////////////////////////////////
    $lang = array(

    "pageTitle" => "DataLog Browser",
    "title" => "DataLog",

    "filter" => array("title" => "Filter-opties",
    "players" => "Spelers",
    "xyz" => "XYZ",
    "range" => "Radius",
    "keys" => "Trefwoorden",
    "worlds" => "Werelden",
    "dFrom" => "Vanaf datum (begin datum)",
    "dTo" => "Tot op heden (eind datum)",
    "block" => "Blok",
    "search" => "Zoek",
    "reverse" => "Omgekeerde volgorde",
    "exclude" => "Filter uit te sluiten"),

    "tips" => array("hideFilter" => "Toon / Verberg filter opties",
    "hideResults" => "Toon / Verberg Resultaten",
    "actions" => "Acties om naar te zoeken. U moet tenminste één selecteren",
    "password" => "Wachtwoord om de browser te gebruiken. Alleen vereist als ingesteld",
    "players" => "(Optioneel) Lijst van spelers die je wilt zoeken, gescheiden door komma's",
    "xyz" => "(Optioneel) Coördinaten waar u wilt rond zoeken",
    "range" => "(Optioneel) Radius rond de bovenstaande coördinaten om naar te zoeken",
    "keys" => "(Optioneel) Lijst van trefwoorden gescheiden door een komma",
    "worlds" => "(Optioneel) Lijst van de werelden, gescheiden door komma's. Leeg laten voor alle werelden",
    "dFrom" => "(Optioneel) Begindatum/tijd van zoekperiode",
    "dTo" => "(Optioneel) Einddatum/tijd van zoekperiode",
    "block" => "(Optioneel) blok om naar te zoeken tijdens blok plaats/breek event",
    "reverse" => "Indien aangevinkt, zal volgorde van de logs zijn in omgekeerde chronologische volgorde. Haal het vinkje weg voor het bekijken van chatlogs",
    "exclude" => "(Optioneel) Lijst van trefwoorden om uit te sluiten van de resultaten gescheiden door komma's"),

    "actions" => array("Blok breek",
    "Blok plaats",
    "Bord plaats",
    "Chat",
    "Commando",
    "join",
    "Verlaten",
    "Teleport",
    "Lava emmer",
    "Water emmer",
    "Open kist",
    "Deur",
    "PVP dood",
    "Flint Steel",
    "Lever (Hendel)",
    "Button (Knop)",
    "Other (Andere)",
    "Explosie",
    "Blok brand",
    "sneeuw vorm",
    "blad verval",
    "Mob dood",
    "Andere dood",
    "Item drop",
    "Item pickup"),

    "results" => array("title" => "Resultaten",
    "id" => "ID",
    "date" => "Datum",
    "player" => "Speler",
    "action" => "Actie",
    "world" => "Wereld",
    "xyz" => "XYZ",
    "data" => "Data"),

    "login" => array("password" => "Wachtwoord: ",
    "login" => "Login"),

    "messages" => array("clickTo" => "Klik op zoeken om gegevens op te halen",
    "breakMe" => "Stop met het proberen me te breken!",
    "invalidPass" => "Ongeldig wachtwoord!",
    "noActions" => "U moet minstens één actie selecteren om te zoeken!",
    "noResults" => "Er zijn geen resultaten gevonden die voldoen aan deze opties",
    "error" => "Error!",
    "notLoggedIn" => "U bent niet ingelogd!")

    );

    //Convert foreign characters to entities
    array_walk_recursive($lang, "ents");
    function ents(&$item, $key) {
    $item = htmlentities($item);
    }

    ?>
     

    Attached Files:

  20. Offline

    oliverw92

    You need to watch your line lengths - the checkbox for reversing the order is way too long, which is pushing everything out of place. Try using abreviations instead. That's dutch right?

    You guys are gonna like this - next version of DataLog Interface has sortable columns as well as real-time filtering :)

    [​IMG]

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

    The Wizard

    Can you add "delete result" option to the interface?
    Ex: you search block place, chat, item pickup from player x, you get the result and then press a button to delete the result.
     
  22. Offline

    oliverw92

    DataTables has a nice selection interface so I guess that would be possible. It won't rollback in-game though
     
  23. Offline

    The Wizard

    And if it is possible to log the items you drop when you die. Now it logs items when you throw them.
     
  24. Offline

    oliverw92

    The issue with that is that is logs who killed you at the moment in that field. I guess I could append the inventory but i'm not entirely sure what use it is seeing what someone dropped when they die?
     
  25. Offline

    Xaqa

    @oliverw92 Multiplay refuses to update.. :(
     
  26. Offline

    DomiStyle

    The plugin works well, except a problem:
    The plugin created no config for me.
    I fixed the problem by copying over the config from your wiki but you may want to check?
    Code:
    2011-07-04 03:52:24 [INFO] [DataLog] Starting DataLog initiation process...
    2011-07-04 03:52:24 [INFO] [DataLog] No config.yml detected, creating default file. Please make sure bukkit.yml is configured with your MySQL details
    2011-07-04 03:52:24 [INFO] [DataLog] Updating config file to v1.1
    2011-07-04 03:52:24 [INFO] [DataLog] IMPORTANT: After server has rebooted, stop server and configure plugins/DataLog/config.yml with new info
    2011-07-04 03:52:24 [SEVERE] Error occurred while enabling DataLog v1.2.0 (Is it up to date?): null
    java.lang.NullPointerException
        at uk.co.oliwali.DataLog.util.Config.<init>(Config.java:81)
        at uk.co.oliwali.DataLog.DataLog.onEnable(DataLog.java:62)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:857)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:264)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:151)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:136)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:284)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:271)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Using Craftbukkit r953 and Datalog v1.2.0.
    The server is a new Bukkit r953 install with no other plugins installed and a fresh world.

    Also the most important question for me before I set it free on a public server:
    Does the PHP script cache the queries?
    It would generate an enormous amount of Traffic to ask the database whats up everytime someone opens the page.
    If not could you add it?
    Else the script is looking very good.
     
  27. Offline

    oliverw92

    @Xaqa Wait so you don't have control of plugins on Multiplay, they install them for you? That's a bit crap :confused: Would seriously advise getting different hosting - you pretty much have no control over your server if you can't even upgrade plugins.

    This is a bug in 1.2.0 - it is fixed in the next release coming out today. You can either wait until then, or to fix it simply put this on the end of config.yml:
    Code:
    general:
    The web interface does not cache queries. There is no point - queries are very rarely the same. There are so many options that 99% of the time the queries are different each time. I do not really see it as an issue though - I have monitored traffic from it on my server and there is no impact at all. If you want to optimise it to have as little impact as possible:
    • Have the web server and mysql server on the same computer as your minecraft server - that way it won't even touch external traffic
    • Wait until the next version is released (today hopefully) which now passes pure data for the web browser to format instead of raw formatted html from the server (takes up MUCH less room when transferring to the browser)
    I run a 100 slot server that frequently has 50+ players on and we never have issues with traffic usage from DataLog.

    Can you show me the contents of your config.yml and config.php. Exclude the password only.

    Version v1.3.0
    Update both the interface and the plugin
    • New! Advanced blacklist - blacklist ANYTHING on your server (snow form, illegal items, swearing, leaf decay)
    • New! Real-time filtering of database results in the web interface!
    • New! Columns are now sortable in the web interface!
    • Massively optimised the web interface (it now passes JSON which is processed by the browser instead of passing raw formatted HTML)
    • Moved to JQuery DataTables for displaying tables in the web interface - very fancy!
    • Added Dutch language file (thanks h0us3cat!)
    • Fixed NPE when creating config file
    • Fully JavaDoc'd the entire source code: http://oliverw92.github.com/DataLog/javadoc/

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

    SulimirCular

    I get the following error while launching my server:

    Code:
    2011-07-04 13:52:00 [INFO] [DataLog] Starting DataLog initiation process...
    2011-07-04 13:52:00 [INFO] [DataLog] 1 rule(s) out of 1 loaded from config file
    2011-07-04 13:52:00 [INFO] [DataLog] Using Permissions for user permissions
    2011-07-04 13:52:00 [SEVERE] [DataLog] Error whilst attempting to get connection: java.sql.SQLException: Access denied for user 'root'@'xx.206.xxx.170' (using password: YES)
    2011-07-04 13:52:00 [SEVERE] [DataLog] Error initiating DataLog database connection, disabling plugin
    2011-07-04 13:52:00 [INFO] [DataLog] Version 1.3.0 disabled!
    My Bukkit.yml is configured like this:

    Code:
    settings:
        spawn-radius: 16
        update-folder: update
    aliases:
        icanhasbukkit:
        - version
    database:
        username: d01xxxxxx
        isolation: SERIALIZABLE
        driver: com.mysql.jdbc.Driver
        password: xxxxx
        url: jdbc:mysql://85.xx.144.xx:3306
    
    my mysql connector is in the lib folder with the name mysql-connector-java-bin.jar

    It seems that the plugin still tries to connect as root to localhost

    (I removed some numbers through x
    Any suggestions on this??
     
  29. Offline

    oliverw92

    Please read the wiki - MySQL is not configured in Bukkit.yml and hasn't been since v1.1.

    You also do not need the mysql connector lib anymore. It is included in Bukkit itself
     
  30. Offline

    DomiStyle

    Thanks for the new update, will check it out soon.

    With cache I mean more like only check the database every 2 hours (configurable in config) and cache everything.
    So that everytime someone opens the site it checks if 2 hours are over, if not it takes the cache if yes it requests the database again.
    This function would come in really handy for servers hosting the page on a external server.
    It would also be nice if you could add a timer that shows you when the data got the last update.
    And also a button to force the update.
    This would enable searching through the database when the server is (for some reason) down.

    After 1.3.0 it's not really important but it would be still a very cool feature to have.
    Since the site is not public it is not really bad at all.

    Thanks for your work. :D
     
  31. Offline

    h0us3cat

    yup dutch
     
Thread Status:
Not open for further replies.

Share This Page