Advertisement
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Outdated KillBearBoys 3.0beta5

Block logging by SQLite3

  1. ljyloo
    Offline

    ljyloo Active Member Plugin Developer

    Joined:
    Aug 24, 2013
    Posts:
    94
    Plugins:
    2
    Thanks for your advice:), it'll make my plguin more efficient?:pSorry, I just have learned how to use SQLite3 for a short time:D
    BTW, do you know how to solve this error?It seems that the Database is overloaded, but I hava no idea to solve it, maybe you can help me?:p

    Attached Files:

  2. wies
    Offline

    wies Notable Member

    Joined:
    Aug 23, 2013
    Posts:
    390
    x y and z are defined as numbers in your database, but in your query you use strings for them (single quotes around them).

    $this->query("INSERT INTO logs VALUES (NULL, '".$name."', '".$action."', '".$blockname."', '".$blockId."', '".$meta."', '".$level."', '".$x."', '".$y."', '".$z."', ".time().")");

    needs to be:

    $this->query("INSERT INTO logs VALUES (NULL, '".$name."', '".$action."', '".$blockname."', '".$blockId."', '".$meta."', '".$level."', ".$x.", ".$y.", ".$z.", ".time().")");

    But I would define blockId and meta as numeric too, and make action also numeric (for example 'place' would be 0, 'break' 1) instead of a string
  3. ljyloo
    Offline

    ljyloo Active Member Plugin Developer

    Joined:
    Aug 24, 2013
    Posts:
    94
    Plugins:
    2
    Thank you so much!:pI'll hava a try
  4. ljyloo
    Offline

    ljyloo Active Member Plugin Developer

    Joined:
    Aug 24, 2013
    Posts:
    94
    Plugins:
    2
    Sometimes it run smoothly, why?:rolleyes:
  5. wies
    Offline

    wies Notable Member

    Joined:
    Aug 23, 2013
    Posts:
    390
    I've no idea, but if it works now it's fine xD
  6. ljyloo
    Offline

    ljyloo Active Member Plugin Developer

    Joined:
    Aug 24, 2013
    Posts:
    94
    Plugins:
    2
    Ok.I need more test:)
  7. ljyloo
    Offline

    ljyloo Active Member Plugin Developer

    Joined:
    Aug 24, 2013
    Posts:
    94
    Plugins:
    2
  8. Sakkz
    Offline

    Sakkz New Member

    Joined:
    Nov 20, 2013
    Posts:
    47
    Minecraft User:
    Sakkz
    I'm using an Android for my server and have no PC/Laptop. What app can I use to see the SQL stuff?
  9. Darunia18
    Offline

    Darunia18 Staff Member Sectional Moderator

    Joined:
    Aug 23, 2013
    Posts:
    754
    Plugins:
    2
    Minecraft User:
    Darunia18
    I'm not sure how compatible SQL databases are with Android, and either way, running a plugin as intensive as this can't be good for a server run on a mobile device. They don't have as much capabilities as PCs and, because they are less powerful, not every plugin will work with it.
  10. ljyloo
    Offline

    ljyloo Active Member Plugin Developer

    Joined:
    Aug 24, 2013
    Posts:
    94
    Plugins:
    2
  11. tnpxxsheepdog
    Offline

    tnpxxsheepdog Notable Member

    Joined:
    Dec 31, 2013
    Posts:
    350
    Minecraft User:
    TNPXXSHEEPDOG
    Are you planning on moving this to 1.4 dev when 0.9.0 comes out? If you do plan to keep supporting it, I will get it!
  12. LDX
    Offline

    LDX Notable Member Plugin Developer

    Joined:
    Oct 2, 2013
    Posts:
    1,397
    Plugins:
    14
    Is it possible to see who placed water? I try to IP ban the people who flood my spawn, but I'm not always on when they do it.
    iJoshuaHD likes this.
  13. MegaSamNinja
    Offline

    MegaSamNinja Active Member

    Joined:
    Sep 13, 2013
    Posts:
    138
    Minecraft User:
    Bamuel
    :D that happened ti me so I used banitem and baned I banned water lava bucket waterbucket lavabucket and it never happened again
    Andrey Nazarchuk likes this.
  14. Andrey Nazarchuk
    Offline

    Andrey Nazarchuk Active Member

    Joined:
    Dec 30, 2013
    Posts:
    332
    Minecraft User:
    digita1eclipse
    same :D
  15. Sakkz
    Offline

    Sakkz New Member

    Joined:
    Nov 20, 2013
    Posts:
    47
    Minecraft User:
    Sakkz
    I don't run my server through my phone I pay a server host monthly but I guess it depends if the host offers SQL?
  16. ljyloo
    Offline

    ljyloo Active Member Plugin Developer

    Joined:
    Aug 24, 2013
    Posts:
    94
    Plugins:
    2
    LDX and iJoshuaHD like this.
  17. tnpxxsheepdog
    Offline

    tnpxxsheepdog Notable Member

    Joined:
    Dec 31, 2013
    Posts:
    350
    Minecraft User:
    TNPXXSHEEPDOG
    FATAL ERROR. Logging does not work and every time someone places a block, this message comes though the console:

    [ERROR] A E_WARNING error happened: "SQLite3::query(): The SQLite3 object has not been correctly initialised" in "/mcpeadventure/plugins/KillBearBoys3.0beta3.php" at line 224
    10:49:08 [ERROR] [SQL Error] library routine called out of sequence. Query: INSERT INTO logs VALUES (NULL, 'tnpxxsheepdog', 'break', 'Dirt', '3', '0', 'world', '80', '68', '149', 1401846548)


    Again the logging DOES NOT WORK.
  18. ljyloo
    Offline

    ljyloo Active Member Plugin Developer

    Joined:
    Aug 24, 2013
    Posts:
    94
    Plugins:
    2
    Please delete /plugin/killbearboys/database.db and update to 3.0beta5:)
  19. tnpxxsheepdog
    Offline

    tnpxxsheepdog Notable Member

    Joined:
    Dec 31, 2013
    Posts:
    350
    Minecraft User:
    TNPXXSHEEPDOG
    The download link is for the beta 3, Check your link and confirm it is the fixed version
  20. Sakkz
    Offline

    Sakkz New Member

    Joined:
    Nov 20, 2013
    Posts:
    47
    Minecraft User:
    Sakkz
    Everytime I do /co to check who griefed, it gives me this message everytime.[​IMG]
    wonnerbee, LDX and tnpxxsheepdog like this.

Share This Page

Advertisement