public static function updateSysStaticPage($sysStaticPage)
{
$query = "UPDATE `sys_static_pages` SET `name` = ?, `title` = ? WHERE `id` = ?";
StringHelper::massiveSpecialChars($sysStaticPage, ENT_QUOTES);
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "ssi", $sysStaticPage['name'], $sysStaticPage['title'], $sysStaticPage['id']);
}
public static function updateImgBlogArt($imgBlogArt)
{
$query = "UPDATE `img_blog_art` SET `img_blog_cat_id` = ?, `name` = ?, `creation_date` = NOW(), `main_pict_id` = ?, `preview` = ? WHERE `id` = ?";
StringHelper::massiveSpecialChars($imgBlogArt, ENT_QUOTES);
return DBUtil::getLastInsertedIdOfPrepatedQuery($query, "isisi", $imgBlogArt['img_blog_cat_id'], $imgBlogArt['name'], $imgBlogArt['main_pict_id'], $imgBlogArt['preview'], $imgBlogArt['id']);
}
public static function insertOrder($order)
{
$query = "INSERT INTO `order` (`u_email`, `u_name`, `u_phone`, `u_comment`) VALUES (?, ?, ?, ?)";
StringHelper::massiveSpecialChars($order, ENT_QUOTES);
return DBUtil::getLastInsertedIdOfPrepatedQuery($query, "ssss", $order['u_email'], $order['u_name'], $order['u_phone'], $order['u_comment']);
}
public static function updateSysNewsCat($sysNewsCat)
{
$query = "UPDATE `sys_news_cat` SET `name` = ?, `pid` = ? WHERE `id` = ?";
StringHelper::massiveSpecialChars($sysNewsCat, ENT_QUOTES);
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "sii", $sysNewsCat['name'], $sysNewsCat['pid'], $sysNewsCat['id']);
}
public static function updateGDS($imgGds)
{
$query = "UPDATE `img_gds` SET `UUID`=?, `name`=?, `price`=?, `currency_id`=?, `main_pict_id`=?, \n `first_pict_id`=?, `second_pict_id`=?, `third_pict_id`=?, `img_account_id`=?, `img_gds_cat_id`=?, \n `in_stock`=?, `is_new`=?, `is_recommended`=?, `descr`=? WHERE `id`=?";
StringHelper::massiveSpecialChars($imgGds, ENT_QUOTES);
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "ssiiiiiiiiiiisi", $imgGds['UUID'], $imgGds['name'], $imgGds['price'], $imgGds['currency_id'], $imgGds['main_pict_id'], $imgGds['first_pict_id'], $imgGds['second_pict_id'], $imgGds['third_pict_id'], $imgGds['img_account_id'], $imgGds['img_gds_cat_id'], $imgGds['in_stock'], $imgGds['is_new'], $imgGds['is_recommended'], $imgGds['descr'], $imgGds['id']);
}
public static function updateImgAlbum($imgAlbum)
{
$query = "UPDATE `img_album` SET `account_id` = ?, `name` = ?, `description` = ? WHERE `id` = ?";
StringHelper::massiveSpecialChars($imgAlbum, ENT_QUOTES);
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "issi", $imgAlbum['account_id'], $imgAlbum['name'], $imgAlbum['description'], $imgAlbum['id']);
}
public static function updateImgAddress($imgAddress)
{
$query = "UPDATE `img_address` SET `region_id` = ?, `sity` = ?, `street` = ?, `house` = ? WHERE `id` = ?";
StringHelper::massiveSpecialChars($imgAddress, ENT_QUOTES);
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "isssi", $imgAddress['region_id'], $imgAddress['sity'], $imgAddress['street'], $imgAddress['house'], $imgAddress['id']);
}
public static function createImgPicture($imgPicture)
{
$query = "INSERT INTO `img_picture` (`account_id`, `album_id`, `name`, `path`) VALUES (?, ?, ?, ?)";
StringHelper::massiveSpecialChars($imgPicture, ENT_QUOTES);
return DBUtil::getLastInsertedIdOfPrepatedQuery($query, "iiss", $imgPicture['account_id'], $imgPicture['album_id'], $imgPicture['name'], $imgPicture['path']);
}
public static function updateSysNewsArtBlock($sysNewsArtBlock)
{
$query = "UPDATE `sys_news_art_block` SET `sys_news_art_id` = ?, `image_id` = ?, `image_title` = ?, `text_content` = ?, `block_type` = ?, `order_in_art` = ? WHERE `id` = ?";
StringHelper::massiveSpecialChars($sysNewsArtBlock, ENT_QUOTES);
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "iissiii", $sysNewsArtBlock['sys_news_art_id'], $sysNewsArtBlock['image_id'], $sysNewsArtBlock['image_title'], $sysNewsArtBlock['text_content'], $sysNewsArtBlock['block_type'], $sysNewsArtBlock['order_in_art'], $sysNewsArtBlock['id']);
}
public static function updateImgBlogArtBlock($imgBlogArtBlock)
{
$query = "UPDATE `img_blog_art_block` SET `img_blog_art_id` = ?, `block_type` = ?, `text_content` = ?, `img_picture_id` = ?, `pict_desc` = ?, `order_in_art` = ? WHERE `id` = ?";
StringHelper::massiveSpecialChars($imgBlogArtBlock, ENT_QUOTES);
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "iisisii", $imgBlogArtBlock['img_blog_art_id'], $imgBlogArtBlock['block_type'], $imgBlogArtBlock['text_content'], $imgBlogArtBlock['img_picture_id'], $imgBlogArtBlock['pict_desc'], $imgBlogArtBlock['order_in_art'], $imgBlogArtBlock['id']);
}
public static function updateSysNewsArt($sysNewsArt)
{
$query = "UPDATE `sys_news_art` SET `sys_news_cat_id` = ?, `title` = ?, `preview` = ?, `main_pict_id` = ? WHERE `id` = ?";
StringHelper::massiveSpecialChars($sysNewsArt, ENT_QUOTES);
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "issii", $sysNewsArt['sys_news_cat_id'], $sysNewsArt['title'], $sysNewsArt['preview'], $sysNewsArt['main_pict_id'], $sysNewsArt['id']);
}
public static function updateImgAccount($imgAccount)
{
$query = "UPDATE `img_account` SET `email` = ?, `hashpass` = ?, `show_email` = ?, `check_code` = ?, `active` = ?, \n `cookie_code` = ?, `img_name` = ?, `img_slog` = ?, `img_phone` = ?, `show_phone` = ?, `img_skype` = ?, \n `show_skype` = ?, `img_icq` = ?, `show_icq` = ?, `img_address_id` = ?, `show_address` = ? WHERE `id` = ?";
StringHelper::massiveSpecialChars($imgAccount, ENT_QUOTES);
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "ssisissssisisiiii", $imgAccount['email'], $imgAccount['hashpass'], $imgAccount['show_email'], $imgAccount['check_code'], $imgAccount['active'], $imgAccount['cookie_code'], $imgAccount['img_name'], $imgAccount['img_slog'], $imgAccount['img_phone'], $imgAccount['show_phone'], $imgAccount['img_skype'], $imgAccount['show_skype'], $imgAccount['img_icq'], $imgAccount['show_icq'], $imgAccount['img_address_id'], $imgAccount['show_address'], $imgAccount['id']);
}
