heres my config Code: tools: tool: defaultEnabled: true mode: LOOKUP aliases: - t params: area 0 all sum none limit 15 desc silent leftClickBehavior: NONE item: 270 rightClickBehavior: TOOL permissionDefault: 'TRUE' canDrop: true toolblock: params: area 0 all sum none limit 15 desc silent permissionDefault: 'TRUE' rightClickBehavior: BLOCK item: 7 mode: LOOKUP canDrop: false defaultEnabled: true aliases: - tb leftClickBehavior: TOOL mysql: user: a6123083_jammie port: 3306 password: *********** host: mysql6.000webhost.com database: a6123083_mcserv logging: hiddenBlocks: - 0 logCreeperExplosionsAsPlayerWhoTriggeredThese: false logPlayerInfo: false hiddenPlayers: [] logKillsLevel: PLAYERS consumer: timePerRun: 200 useBukkitScheduler: true forceToProcessAtLeast: 20 delayBetweenRuns: 6 lookup: linesLimit: 1500 defaultTime: 30 minutes defaultDist: 20 linesPerPage: 15 questioner: askClearLogs: true banPermission: mcbans.ban.local askRollbacks: true askRedos: true askClearLogAfterRollback: true askRollbackAfterBan: false updater: checkVersion: true loggedWorlds: - world - world_the_end clearlog: enableAutoClearLog: false auto: - world "world" before 365 days all - world "world" player lavaflow waterflow leavesdecay before 7 days all - world world_nether before 365 days all - world world_nether player lavaflow before 7 days all autoClearLogDelay: 6h dumpDeletedLog: false rollback: replaceAnyway: - 8 - 9 - 10 - 11 - 51 maxArea: 50 dontRollback: - 10 - 11 - 46 - 51 maxTime: 2 days version: '1.54' Ok and when i do /lb ingameit says MYSQL isnt connected (Im using 000Webhost.com for the MYSQL) Also how many fields does it need for my lb-world table?
CREATE TABLE `lb-players` (playerid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, playername varchar(32) NOT NULL DEFAULT '-', PRIMARY KEY (playerid), UNIQUE (playername)); CREATE TABLE `lb-chat` (id INT UNSIGNED NOT NULL AUTO_INCREMENT, date DATETIME NOT NULL, playerid SMALLINT UNSIGNED NOT NULL, message VARCHAR(255) NOT NULL, PRIMARY KEY (id), KEY playerid (playerid), FULLTEXT message (message)) ENGINE=MyISAM; CREATE TABLE `lb-main` (id INT UNSIGNED NOT NULL AUTO_INCREMENT, date DATETIME NOT NULL, playerid SMALLINT UNSIGNED NOT NULL, replaced TINYINT UNSIGNED NOT NULL, type TINYINT UNSIGNED NOT NULL, data TINYINT UNSIGNED NOT NULL, x SMALLINT NOT NULL, y TINYINT UNSIGNED NOT NULL, z SMALLINT NOT NULL, PRIMARY KEY (id), KEY coords (x, z, y), KEY date (date), KEY playerid (playerid)); CREATE TABLE `lb-main-sign` (id INT UNSIGNED NOT NULL, signtext VARCHAR(255) NOT NULL, PRIMARY KEY (id)); CREATE TABLE `lb-main-chest` (id INT UNSIGNED NOT NULL, itemtype SMALLINT UNSIGNED NOT NULL, itemamount SMALLINT NOT NULL, itemdata TINYINT UNSIGNED NOT NULL, PRIMARY KEY (id)); CREATE TABLE `lb-main-kills` (id INT UNSIGNED NOT NULL AUTO_INCREMENT, date DATETIME NOT NULL, killer SMALLINT UNSIGNED, victim SMALLINT UNSIGNED NOT NULL, weapon SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (id)); Im working off of that, but its not in the correct order...