public static function putProperty($key, $value)
{
$cnt = self::getCountPropertyValue($key);
if (0 == cnt) {
$query = "UPDATE `sys_properties` SET `value`=? WHERE `name`=?";
} else {
$query = "INSERT INTO `sys_properties` (`value`, `name`) VALUES (?, ?)";
}
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "ss", $value, $key);
}
public static function deleteImgAlbumByID($imgAlbumID, $withPictures)
{
$query = "DELETE FROM `img_album` WHERE `id` = ?";
if ($withPictures) {
$pict_query = "DELETE FROM `img_picture` WHERE `album_id` = ?";
} else {
$pict_query = "UPDATE `img_picture` SET `album_id` = NULL WHERE `album_id` = ?";
}
DBUtil::getLastInsertedIdOfPrepatedQuery($pict_query, "i", $imgAlbumID);
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $imgAlbumID);
}
public static function deleteSysStaticPageById($sysStaticPageId)
{
$query = "DELETE FROM `sys_static_pages` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $sysStaticPageId);
}
public static function setSendedOrder($order_id)
{
$query = "UPDATE `order` SET `sended`=1 WHERE `id`=?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $order_id);
}
public static function deleteImgBlogArtById($imgBlogArtId)
{
$queryBlock = "DELETE FROM `img_blog_art_block` WHERE `img_blog_art_id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($queryBlock, "i", $imgBlogArtId);
$queryArt = "DELETE FROM `img_blog_art` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($queryArt, "i", $imgBlogArtId);
}
public static function deleteGDSById($imgGdsId)
{
$query = "DELETE FROM `img_gds` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $imgGdsId);
}
public static function deleteSysNewsCatById($sysNewsCatId)
{
$query = "DELETE FROM `sys_news_cat` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $sysNewsCatId);
}
public static function deleteImgAddressById($imgAddressId)
{
$query = "DELETE FROM `img_address` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $imgAddressId);
}
public static function deleteImgBlogCatById($imgBlogCatId)
{
$query = "DELETE FROM `img_blog_cat` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $imgBlogCatId);
}
public static function deleteImgPictureById($imgPictureId)
{
$query = "DELETE FROM `img_picture` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $imgPictureId);
}
public static function insertOrderGds($order_gds)
{
$query = "INSERT INTO `order_gds` (`order_id`, `img_gds_id`, `count_gds`) VALUES (?, ?, ?)";
return DBUtil::getLastInsertedIdOfPrepatedQuery($query, "iii", $order_gds['order_id'], $order_gds['img_gds_id'], $order_gds['count_gds']);
}
public static function deleteSysNewsArtBlocksByNewsArtId($sysNewsArtId)
{
$query = "DELETE FROM `sys_news_art_block` WHERE `sys_news_art_id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $sysNewsArtId);
}
public static function updateOrderAccountRelation($orderID, $accountID, $sended)
{
$query = "UPDATE `order_account_sended` SET `sended`=? WHERE `order_id`=? AND `img_account_id`=?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "iii", $sended, $orderID, $accountID);
}
public static function updateSysAdmin($sysAdmin)
{
$query = "UPDATE `sys_admins` SET `login`=?, `password`=?, `lastuuid`=? WHERE `id`=?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "sssi", $sysAdmin['login'], $sysAdmin['password'], $sysAdmin['lastuuid'], $sysAdmin['id']);
}
