|
@@ 43-45 (lines=3) @@
|
| 40 |
|
public function set($userID, $name, $lastStatus, $game, $lastSeen, $lastSpoke, $lastWritten) |
| 41 |
|
{ |
| 42 |
|
try { |
| 43 |
|
if (isset($lastStatus)) { |
| 44 |
|
$this->db->execute("INSERT INTO users (discordID, nickName, lastStatus) VALUES (:discordID, :nickName, :lastStatus) ON DUPLICATE KEY UPDATE lastStatus = :lastStatus", [":discordID" => $userID, ":nickName" => $name, ":lastStatus" => $lastStatus]); |
| 45 |
|
} |
| 46 |
|
|
| 47 |
|
if (isset($game)) { |
| 48 |
|
$this->db->execute("INSERT INTO users (discordID, nickName, game) VALUES (:discordID, :nickName, :game) ON DUPLICATE KEY UPDATE game = :game", [":discordID" => $userID, ":nickName" => $name, ":game" => $game]); |
|
@@ 52-54 (lines=3) @@
|
| 49 |
|
$this->db->execute("INSERT IGNORE INTO games (game) VALUES (:game)", array(":game" => $game)); |
| 50 |
|
} |
| 51 |
|
|
| 52 |
|
if (isset($lastSeen)) { |
| 53 |
|
$this->db->execute("INSERT INTO users (discordID, nickName, lastSeen) VALUES (:discordID, :nickName, :lastSeen) ON DUPLICATE KEY UPDATE lastSeen = :lastSeen", [":discordID" => $userID, ":nickName" => $name, ":lastSeen" => $lastSeen]); |
| 54 |
|
} |
| 55 |
|
|
| 56 |
|
if (isset($lastSpoke)) { |
| 57 |
|
$this->db->execute("INSERT INTO users (discordID, nickName, lastSpoke) VALUES (:discordID, :nickName, :lastSpoke) ON DUPLICATE KEY UPDATE lastSpoke = :lastSpoke", [":discordID" => $userID, ":nickName" => $name, ":lastSpoke" => $lastSpoke]); |
|
@@ 56-58 (lines=3) @@
|
| 53 |
|
$this->db->execute("INSERT INTO users (discordID, nickName, lastSeen) VALUES (:discordID, :nickName, :lastSeen) ON DUPLICATE KEY UPDATE lastSeen = :lastSeen", [":discordID" => $userID, ":nickName" => $name, ":lastSeen" => $lastSeen]); |
| 54 |
|
} |
| 55 |
|
|
| 56 |
|
if (isset($lastSpoke)) { |
| 57 |
|
$this->db->execute("INSERT INTO users (discordID, nickName, lastSpoke) VALUES (:discordID, :nickName, :lastSpoke) ON DUPLICATE KEY UPDATE lastSpoke = :lastSpoke", [":discordID" => $userID, ":nickName" => $name, ":lastSpoke" => $lastSpoke]); |
| 58 |
|
} |
| 59 |
|
|
| 60 |
|
if (isset($lastWritten)) { |
| 61 |
|
$this->db->execute("INSERT INTO users (discordID, nickName, lastWritten) VALUES (:discordID, :nickName, :lastWritten) ON DUPLICATE KEY UPDATE lastWritten = :lastWritten", [":discordID" => $userID, ":nickName" => $name, ":lastWritten" => $lastWritten]); |
|
@@ 60-62 (lines=3) @@
|
| 57 |
|
$this->db->execute("INSERT INTO users (discordID, nickName, lastSpoke) VALUES (:discordID, :nickName, :lastSpoke) ON DUPLICATE KEY UPDATE lastSpoke = :lastSpoke", [":discordID" => $userID, ":nickName" => $name, ":lastSpoke" => $lastSpoke]); |
| 58 |
|
} |
| 59 |
|
|
| 60 |
|
if (isset($lastWritten)) { |
| 61 |
|
$this->db->execute("INSERT INTO users (discordID, nickName, lastWritten) VALUES (:discordID, :nickName, :lastWritten) ON DUPLICATE KEY UPDATE lastWritten = :lastWritten", [":discordID" => $userID, ":nickName" => $name, ":lastWritten" => $lastWritten]); |
| 62 |
|
} |
| 63 |
|
} catch (\Exception $e) { |
| 64 |
|
throw new \Exception("There was an error setting data for {$name}: {$e->getMessage()}"); |
| 65 |
|
} |
sovereignbot /
citadel
