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']); }