123456789101112131415161718192021222324252627282930 |
- event.load("player_login");
- event.load("player_logout");
- executeOnce = databank.prepare("CREATE TABLE IF NOT EXISTS playtime (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, player_id INT NOT NULL, join_time BIGINT NOT NULL, leave_time BIGINT);");
- databank.workerExecute(executeOnce);
- msg("dev", "§bPlaytime §rloaded.");
- @wait
- wait();
- player_id = player.getId(player);
- igoto(event);
- goto("wait");
- @player_login
- deleteInvalidStatement = databank.prepare("DELETE FROM playtime WHERE player_id = ? AND leave_time IS NULL;", false);
- databank.setInt(deleteInvalidStatement, 1, player_id);
- databank.workerExecute(deleteInvalidStatement);
- joinTimeStatement = databank.prepare("INSERT INTO playtime (player_id, join_time) VALUES (?, ?);", false);
- databank.setInt(joinTimeStatement, 1, player_id);
- databank.setLong(joinTimeStatement, 2, time.getMillis());
- databank.workerExecute(joinTimeStatement);
- goto("wait");
- @player_logout
- leaveTimeStatement = databank.prepare("UPDATE playtime SET leave_time = ? WHERE player_id = ? AND leave_time IS NULL;", false);
- databank.setLong(leaveTimeStatement, 1, time.getMillis());
- databank.setInt(leaveTimeStatement, 2, player_id);
- databank.workerExecute(leaveTimeStatement);
- goto("wait");
|