public static function update($listID, $post = array(), $whereQuery = '', $addWhere = '') { if (isset($post['content'])) { // $post['content']=Shortcode::toBBCode($post['content']); $post['content'] = String::encode(strip_tags($post['content'], '<p><br>')); } if (is_numeric($listID)) { $catid = $listID; unset($listID); $listID = array($catid); } $listIDs = "'" . implode("','", $listID) . "'"; $keyNames = array_keys($post); $total = count($post); $setUpdates = ''; for ($i = 0; $i < $total; $i++) { $keyName = $keyNames[$i]; $setUpdates .= "{$keyName}='{$post[$keyName]}', "; } $setUpdates = substr($setUpdates, 0, strlen($setUpdates) - 2); $whereQuery = isset($whereQuery[5]) ? $whereQuery : "commentid in ({$listIDs})"; $addWhere = isset($addWhere[5]) ? $addWhere : ""; Database::query("update " . Database::getPrefix() . "comments set {$setUpdates} where {$whereQuery} {$addWhere}"); // DBCache::removeDir('system/comment'); DBCache::removeCache($listIDs, 'system/comment'); if (!($error = Database::hasError())) { return true; } return false; }
public static function update($listID, $post = array(), $whereQuery = '', $addWhere = '') { if (is_numeric($listID)) { $catid = $listID; unset($listID); $listID = array($catid); } if (isset($post['title'])) { $post['title'] = String::encode(strip_tags($post['title'])); $post['friendly_url'] = String::makeFriendlyUrl(strip_tags($post['title'])); $loadPost = self::get(array('where' => "where friendly_url='" . $post['friendly_url'] . "'")); if (isset($loadPost[0]['catid']) && (int) $loadPost[0]['catid'] != (int) $listID[0]) { return false; } } $listIDs = "'" . implode("','", $listID) . "'"; $keyNames = array_keys($post); $total = count($post); $setUpdates = ''; for ($i = 0; $i < $total; $i++) { $keyName = $keyNames[$i]; $setUpdates .= "{$keyName}='{$post[$keyName]}', "; } $setUpdates = substr($setUpdates, 0, strlen($setUpdates) - 2); $whereQuery = isset($whereQuery[5]) ? $whereQuery : "catid in ({$listIDs})"; $addWhere = isset($addWhere[5]) ? $addWhere : ""; Database::query("update " . Database::getPrefix() . "categories set {$setUpdates} where {$whereQuery} {$addWhere}"); // DBCache::removeDir('system/category'); DBCache::removeCache($listIDs, 'system/category'); if (!($error = Database::hasError())) { return true; } return false; }
public static function update($listID, $post = array(), $whereQuery = '', $addWhere = '') { if (is_numeric($listID)) { $userid = $listID; unset($listID); $listID = array($userid); } $listIDs = "'" . implode("','", $listID) . "'"; $keyNames = array_keys($post); $total = count($post); $setUpdates = ''; for ($i = 0; $i < $total; $i++) { $keyName = $keyNames[$i]; $setUpdates .= "{$keyName}='{$post[$keyName]}', "; } $setUpdates = substr($setUpdates, 0, strlen($setUpdates) - 2); $whereQuery = isset($whereQuery[5]) ? $whereQuery : "userid in ({$listIDs})"; $addWhere = isset($addWhere[5]) ? $addWhere : ""; Database::query("update " . Database::getPrefix() . "address set {$setUpdates} where {$whereQuery} {$addWhere}"); // DBCache::removeDir('system/address'); DBCache::removeCache($listIDs, 'system/address'); if (!($error = Database::hasError())) { return true; } return false; }
public static function remove($post = array(), $whereQuery = '', $addWhere = '') { if (is_numeric($post)) { $id = $post; unset($post); $post = array($id); } $total = count($post); $listID = "'" . implode("','", $post) . "'"; $whereQuery = isset($whereQuery[5]) ? $whereQuery : "tagid in ({$listID})"; $addWhere = isset($addWhere[5]) ? $addWhere : ""; $command = "delete from " . Database::getPrefix() . "post_tags where {$whereQuery} {$addWhere}"; Database::query($command); // DBCache::removeDir('system/posttag'); DBCache::removeCache($listID, 'system/posttag'); return true; }