public static function deleteSecure($userId, $type = null) { $db = new Util\Data(); if (isset($type)) { $query = 'DELETE FROM core_user_security WHERE user_id = ? AND type = ?'; return $db->execute($query, [$userId, $type]); } $query = 'DELETE FROM core_user_security WHERE user_id = ?'; return $db->execute($query, [$userId]); }
public static function clear($code) { $db = new Util\Data(); if ($code != 0) { $query = 'DELETE FROM core_log WHERE code = ?'; return $db->execute($query, [$code]); } $query = 'DELETE FROM core_log ORDER BY id DESC LIMIT 200'; return $db->execute($query); }
public static function savePassword(\Rebond\Core\User\Model $user) { Util\Log::log(Util\Error::PASSWORD_CHANGE, $user->getId(), __FILE__, __LINE__); $db = new Util\Data(); $query = 'UPDATE core_user SET password = ?, modified_date = ? WHERE id = ?'; return $db->execute($query, [$user->getPassword(), Util\Format::date(time(), 'sqlDatetime'), $user->getId()]); }
private static function loadFriendlyUrl($pageId) { $db = new Util\Data(); $query = 'SELECT p.id, p.friendly_url, p.friendly_url_path FROM cms_page p WHERE p.id = ?'; return $db->execute($query, [$pageId]); }
/** * Delete Book by sequence * @param int $sequence * @return int */ public static function deleteBySequence($sequence) { if ($sequence == 0) { return 0; } $db = new Util\Data(); $query = 'DELETE FROM bus_book WHERE sequence = ? AND booking_date > NOW()'; return $db->execute($query, [$sequence]); }
public static function updateIsInMatchPlayers($tournament) { $db = new Util\Data(); $playerIds = []; foreach ($tournament->getTournamentPlayers() as $tp) { $playerIds[] = $tp->getPlayerId(); } if (count($playerIds) == 0) { return; } $sql = 'UPDATE bus_player SET is_in_match = true, is_in_tournament = true WHERE id IN (' . implode(',', $playerIds) . ')'; $db->execute($sql); }
public static function deleteByPublisherId($id) { $db = new Util\Data(); $query = 'DELETE FROM cms_content WHERE publisher_id = ?'; return $db->execute($query, [$id]); }
public static function deleteByModuleId($id) { $db = new Util\Data(); $query = 'DELETE FROM cms_module_media WHERE module_id = ?'; return $db->execute($query, [$id]); }
public static function removeAndAddPlayer() { $options = []; $options['clearSelect'] = true; $options['select'][] = \Own\Bus\Player\Data::getList(['id', 'username']); $options['where'][] = 'player.user_id = 0'; $options['where'][] = 'player.active = 1'; $players = \Own\Bus\Player\Data::loadAll($options); if (count($players) > 0) { $db = new Util\Data(); $pick = \Own\Bus\Engine::dice(0, count($players) - 1); $remove = 'UPDATE bus_player SET active = 0 WHERE id = ' . $players[$pick]->getId(); $db->execute($remove); Util\Log::log(Util\Code::CRON, 'player retired: ' . $players[$pick]->getUsername() . ' (' . $players[$pick]->getId() . ')', __FILE__, __LINE__); $leagues = \Own\Bus\League\Data::loadAll(); $player = new \Own\Bus\Player\Model(); $player->setRandom(1); $player->setActive(true); if (count($leagues) > 0) { $player->setLeagueId(\Own\Bus\Engine::findLeague($leagues, 1)); } $player->save(); Util\Log::log(Util\Code::CRON, 'new player: ' . $player->getUsername() . ' (' . $player->getId() . ')', __FILE__, __LINE__); } }
public static function deleteByParentId($id) { $db = new Util\Data(); $query = 'DELETE FROM core_folder WHERE parent_id = ?'; return $db->execute($query, [$id]); }
public static function cleanHasViewed() { $query = 'UPDATE bus_player_match SET has_viewed = 1 WHERE has_viewed = 0 AND modified_date < NOW() - INTERVAL ? HOUR'; $db = new Util\Data(); return $db->execute($query, [\Own\Bus\Engine::DAY * 7]); }
public static function clean() { $sql = 'DELETE FROM bus_notification WHERE has_read = 1 AND created_date < NOW() - INTERVAL ? HOUR'; $db = new Util\Data(); return $db->execute($sql, [\Own\Bus\Engine::DAY * 56]); }
public static function deleteByRoleId($id) { $db = new Util\Data(); $query = 'DELETE FROM core_user_role WHERE role_id = ?'; return $db->execute($query, [$id]); }
public static function clearFilter($filterId) { $query = 'UPDATE cms_content SET filter_id = 0 WHERE filter_id = ?'; $db = new Util\Data(); return $db->execute($query, [$filterId]); }
public static function deleteOldMatches() { $db = new Util\Data(); $query = 'DELETE FROM bus_log WHERE match_id IN (SELECT id FROM bus_match WHERE modified_date < NOW() - INTERVAL ? HOUR)'; return $db->execute($query, [\Own\Bus\Engine::DAY * 7]); }
public static function updatePlayerPoints($playerIds, $createdDate) { // tour $db = new Util\Data(); $sql = 'SELECT player_id, SUM(tp.points) as points, COUNT(player_id) as total FROM bus_tournament_player tp JOIN bus_tournament t ON t.id = tp.tournament_id WHERE t.start_date > NOW() - INTERVAL ' . Engine::DAY * 336 . ' HOUR AND tp.points > 0 AND player_id IN (' . implode(',', $playerIds) . ') GROUP BY player_id ORDER BY points DESC'; $result = $db->select($sql); if (count($result) == 0) { return; } while ($row = $result->fetch(\PDO::FETCH_ASSOC)) { if ($row['total'] <= 18) { \Own\Bus\Player\Data::updateTourPointsByPlayerId($row['player_id'], $row['points']); continue; } $sql = 'SELECT SUM(points) as points FROM ( SELECT points FROM bus_tournament_player tp JOIN bus_tournament t ON t.id = tp.tournament_id WHERE player_id = ? AND t.start_date > NOW() - INTERVAL ? HOUR ORDER BY points DESC LIMIT 18 ) AS subquery'; $subRow = $db->selectOne($sql, [$row['player_id'], Engine::DAY * 336]); if (isset($subRow)) { \Own\Bus\Player\Data::updateTourPointsByPlayerId($row['player_id'], $subRow['points']); } } // race $startYearDate = \Own\Bus\Engine::getStartYearDate($createdDate); $sql = 'SELECT player_id, SUM(tp.points) as points, COUNT(player_id) as total FROM bus_tournament_player tp JOIN bus_tournament t ON t.id = tp.tournament_id WHERE t.start_date > \'' . $startYearDate . '\' AND tp.points > 0 AND player_id IN (' . implode(',', $playerIds) . ') GROUP BY player_id ORDER BY points DESC'; $result = $db->execute($sql); if (count($result) == 0) { return; } while ($row = $result->fetch(\PDO::FETCH_ASSOC)) { if ($row['total'] <= 18) { \Own\Bus\Player\Data::updateRacePointsByPlayerId($row['player_id'], $row['points']); continue; } $sql = 'SELECT SUM(points) as points FROM ( SELECT points FROM bus_tournament_player tp JOIN bus_tournament t ON t.id = tp.tournament_id WHERE player_id = ? AND t.start_date > ? ORDER BY points DESC LIMIT 18 ) AS subquery'; $subRow = $db->selectOne($sql, [$row['player_id'], $startYearDate]); if (isset($subRow)) { \Own\Bus\Player\Data::updateRacePointsByPlayerId($row['player_id'], $subRow['points']); } } }
public static function updateGameplayBatch() { $db = new Util\Data(); $query = 'UPDATE bus_player SET gameplay = gameplay + ROUND((300 + (CAST(adaptation AS SIGNED) * 50) - CAST(gameplay AS SIGNED)) / 100), last_gameplay_update = NOW() WHERE active = 1 AND last_gameplay_update < NOW() - INTERVAL ' . Engine::DAY * 60 / 10 . ' MINUTE'; return $db->execute($query); }
private function addBookings(array $bookings) { $sql = "INSERT INTO bus_book (sequence, court_id, type, player1_id, player2_id, booking_date, title, color, guest, pay) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, 0)"; $count = 0; $bookingsCount = count($bookings); $db = new Util\Data(); for ($t = 0; $t < $bookingsCount; $t++) { $time = explode(':', $bookings[$t][0]['time']); $bookingDate = $this->date; $bookingDate->setTime($time[0], $time[1], 0); $bookingDate = $bookingDate->format('Y-m-d H:i:s'); for ($c = 1; $c < count($bookings[$t]); $c++) { if (isset($bookings[$t][$c]['players'])) { $playerIds = $bookings[$t][$c]['players']; $type = BookingType::PARTNER; $playerIds[1] = $playerIds[1] != 0 ? $playerIds[1] : 1; if ($playerIds[1] == 0) { // guest $type = BookingType::GUEST; } $db->execute($sql, ['', $bookings[$t][$c]['court'], $type, $playerIds[0], $playerIds[1], $bookingDate, '', '', '']); $count++; } else { if (isset($bookings[$t][$c]['text'])) { $text = $bookings[$t][$c]['text']; if (strcasecmp($text, 'ledig') != 0 && $text != '') { $color = $this->renderColor($text); $db->execute($sql, [uniqid(), $bookings[$t][$c]['court'], BookingType::ADMIN, 0, 0, $bookingDate, $text, $color, '']); $count++; } } else { echo 'nope'; exit; // should not happen } } } } return $count . ' bookings added. (' . $bookingsCount * (count($bookings[0]) - 1) . ')'; }
public static function deleteById($contentId) { if ($contentId === 0) { return 0; } $query = 'DELETE FROM app_standard WHERE app_id = ?'; $db = new Util\Data(); return $db->execute($query, [$contentId]); }
public static function updateSurfaceBatch() { $db = new Util\Data(); $query = 'UPDATE bus_league SET surface = FLOOR(RAND() * 3) + 1'; return $db->execute($query); }
public static function deleteByFilterId($id) { $db = new Util\Data(); $query = 'DELETE FROM cms_gadget WHERE filter_id = ?'; return $db->execute($query, [$id]); }
public static function deleteByPermissionId($id) { $db = new Util\Data(); $query = 'DELETE FROM core_role_permission WHERE permission_id = ?'; return $db->execute($query, [$id]); }
public static function deleteByUserId($id) { $db = new Util\Data(); $query = 'DELETE FROM core_log WHERE user_id = ?'; return $db->execute($query, [$id]); }
public static function deleteByLayoutId($id) { $db = new Util\Data(); $query = 'DELETE FROM cms_page WHERE layout_id = ?'; return $db->execute($query, [$id]); }
public static function deleteById($id) { if ($id === 0) { return 0; } $query = 'DELETE FROM core_user WHERE id = ?'; $db = new Util\Data(); return $db->execute($query, [$id]); }
public static function moveToRoot($folderId) { $query = 'UPDATE core_media SET folder_id = 1 WHERE folder_id = ?'; $db = new Util\Data(); return $db->execute($query, [$folderId]); }