public static function getImgAddressById($id) { $query = "SELECT ia.id, r.id AS region_id, r.code AS rcode, r.name AS rname, ia.sity, ia.street, ia.house \n\t\t\tFROM img_address AS ia \n\t\t\tJOIN addr_region AS r on ia.region_id = r.id\n\t\t\tWHERE ia.id = ?"; $imgAddreses = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $id); return $imgAddreses[0]; }
public static function getSysNewsCatByID($sysNewsCatID) { $query = "SELECT `id`, `name`, `pid` FROM `sys_news_cat` WHERE `id` = ?"; $sysNewsCats = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $sysNewsCatID); return $sysNewsCats[0]; }
public static function getImgBlogCatsByAccountId($account_id) { $query = "SELECT `id`, `account_id`, `name`, `pid` FROM `img_blog_cat` WHERE `account_id` = ?"; $imgBlogCats = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $account_id); return $imgBlogCats; }
public static function getImgCurrencies() { $query = "SELECT `id`, `name`, `weight` FROM `img_currency`"; $imgCurrencies = DBUtil::getResultRowsOfPrepatedQuery($query); return $imgCurrencies; }
public static function getOrderById($orderID, $accountID) { $query = "SELECT o.id, o.u_email, o.u_name, o.u_phone, o.u_comment, o.c_date , oacc.sended\n FROM `order` as o\n JOIN order_account_sended as oacc ON oacc.order_id = o.id\n WHERE o.`id` = ? AND oacc.img_account_id = ?"; $orders = DBUtil::getResultRowsOfPrepatedQuery($query, "ii", $orderID, $accountID); return $orders[0]; }
public static function getSysNewsArtsByFilter($sys_news_cat_id, $ptile, $start, $lenght) { $query = "SELECT `id`, `sys_news_cat_id`, `title`, `preview`, `c_date`, `main_pict_id`\n\t\t\tFROM `sys_news_art` WHERE 1 = 1 "; $ptile = trim($ptile); if (NULL != $sys_news_cat_id) { $query .= "AND `sys_news_cat_id` = ? "; } if (0 != strcmp("", $ptile)) { $query .= "AND upper(`title`) LIKE upper(?) "; } $query .= "ORDER BY `c_date` DESC LIMIT ?, ?"; if (NULL != $sys_news_cat_id && 0 != strcmp("", $ptile)) { $ptile = "%" . $ptile . "%"; $sysNewsArts = DBUtil::getResultRowsOfPrepatedQuery($query, "isii", $sys_news_cat_id, $ptile, $start, $lenght); } else { if (NULL != $sys_news_cat_id) { $sysNewsArts = DBUtil::getResultRowsOfPrepatedQuery($query, "iii", $sys_news_cat_id, $start, $lenght); } else { if (0 != strcmp("", $ptile)) { $ptile = "%" . $ptile . "%"; $sysNewsArts = DBUtil::getResultRowsOfPrepatedQuery($query, "sii", $ptile, $start, $lenght); } else { $sysNewsArts = DBUtil::getResultRowsOfPrepatedQuery($query, "ii", $start, $lenght); } } } return $sysNewsArts; }
private static function findImgGdsCatIdByProductId($account_id, $productId) { $query = "SELECT igc.id as id FROM img_gds_cat igc JOIN img_gds ig ON igc.id = ig.img_gds_cat_id \n\t\tWHERE igc.account_id = ? AND ig.id = ?"; $imgGdsCatIds = DBUtil::getResultRowsOfPrepatedQuery($query, "ii", $account_id, $productId); return $imgGdsCatIds[0]['id']; }
public static function getPropertyValue($key) { $query = "SELECT `value` FROM `sys_properties` WHERE `name` = ?"; $props = DBUtil::getResultRowsOfPrepatedQuery($query, "s", $key); return $props[0]['value']; }
public static function getImgBlogArtBlocksByArtId($artId) { $query = "SELECT `id`, `img_blog_art_id`, `block_type`, `text_content`, \n `img_picture_id`, `pict_desc`, `order_in_art` \n FROM `img_blog_art_block`\n WHERE `img_blog_art_id` = ? ORDER BY `order_in_art` ASC"; $imgBlogArtBlocks = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $artId); return $imgBlogArtBlocks; }
public static function getOrderAccsToMailMessage($orderID) { $query = "select DISTINCT o.id as oid, iacc.id as accid, iacc.email as accemail, o.u_email as oemail from img_gds as igds \n join img_account iacc on igds.img_account_id = iacc.id\n join order_gds ogds on ogds.img_gds_id = igds.id\n join `order` o on ogds.order_id = o.id\n where o.id = ?"; $orderAccs = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $orderID); return $orderAccs; }
public static function getSysStaticPageBlocksByPageId($pageId) { $query = "SELECT `id`, `sys_static_page_id`, `block_type_id`, `image_id`, `image_title`, `text_content`, `order_in_page` FROM `sys_static_page_blocks` WHERE `sys_static_page_id` = ? ORDER BY `order_in_page` ASC"; $sysStaticPageBlocks = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $pageId); return $sysStaticPageBlocks; }
public static function getImgGdsProps($imgGdsId) { $query = "SELECT `id`, `img_gds_id`, `name`, `value` FROM `img_gds_prop` WHERE `img_gds_id` = ?"; $imgGdsProps = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $imgGdsId); return $imgGdsProps; }
public static function getSysAdminByLastUUID($lastUUID) { $query = "SELECT `id`, `login`, `password`, `lastuuid` FROM `sys_admins` WHERE `lastuuid` LIKE ?"; $sysAdmins = DBUtil::getResultRowsOfPrepatedQuery($query, "s", $lastUUID); return $sysAdmins[0]; }
public static function getImgGdssForOrder($accountID, $orderID) { $query = "select igds.id, igds.name, igds.UUID, igds.main_pict_id, igds.price, \n ic.name as price_name, ogds.count_gds from img_gds igds\n join order_gds ogds on igds.id = ogds.img_gds_id\n join `order` o on o.id = ogds.order_id\n join img_currency ic on ic.id = igds.currency_id\n where o.id = ? and igds.img_account_id = ?"; $imgGdss = DBUtil::getResultRowsOfPrepatedQuery($query, "ii", $orderID, $accountID); return $imgGdss; }
public static function getSysNewsArtBlockById($sysNewsArtId) { $query = "SELECT `id`, `sys_news_art_id`, `image_id`, `image_title`, `text_content`, `block_type`, `order_in_art` FROM `sys_news_art_block` WHERE `id` = ? "; $sysNewsArtBlocks = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $sysNewsArtId); return $sysNewsArtBlocks[0]; }
public static function getImgBlogArtById($img_account_id, $img_blog_art_id) { $query = "SELECT `id`, `img_blog_cat_id`, `name`, `creation_date`, `main_pict_id`, `preview`\n\t\t\tFROM `img_blog_art` WHERE `img_account_id` = ? AND `id` = ?"; $imgBlogArts = DBUtil::getResultRowsOfPrepatedQuery($query, "ii", $img_account_id, $img_blog_art_id); return $imgBlogArts[0]; }
public static function countImgPicturesByAlbumId($id) { $query = "SELECT COUNT(*) as cnt FROM `img_picture` WHERE `album_id` = ?"; $cntResults = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $id); return $cntResults[0]['cnt']; }
public static function getRegionByCode($code) { $query = "SELECT `id`, `name`, `code` FROM `addr_region` WHERE `code` = ?"; $regions = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $code); return $regions[0]; }
public static function getImgAlbumByID($album_id, $account_id) { $query = "SELECT `id`, `account_id`, `name`, `description` FROM `img_album` WHERE `id` = ? AND `account_id` = ?"; $imgAlbums = DBUtil::getResultRowsOfPrepatedQuery($query, "ii", $album_id, $account_id); return $imgAlbums[0]; }
public static function getSysStaticPageByName($namePage) { $query = "SELECT `id`, `name`, `title` FROM `sys_static_pages` WHERE upper(`name`) LIKE upper(?)"; $sysStaticPages = DBUtil::getResultRowsOfPrepatedQuery($query, "s", $namePage); return $sysStaticPages[0]; }
public static function getImgAccountByEmailAndHashPass($email, $hashpass) { $query = "SELECT `id`, `email`, `hashpass`, `show_email`, `check_code`, `active`, `cookie_code`, \n\t\t\t\t`img_name`, `img_slog`, `img_phone`, `show_phone`, `img_skype`, `show_skype`, \n\t\t\t\t`img_icq`, `show_icq`, `img_address_id`, `show_address` \n\t\t\t\tFROM `img_account` WHERE `email` = ? AND `hashpass` = ? AND NOT `active` = 0"; $imgAccounts = DBUtil::getResultRowsOfPrepatedQuery($query, "ss", $email, $hashpass); return $imgAccounts[0]; }