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;
}
