";
echo "
";
echo "";
echo "
";
echo "";
echo "
";
echo "";
echo "
";
comment_section( "deals", $array_deal[ "deal_id" ] );
$array_moredeals = query_array_all( "SELECT * FROM ( SELECT * FROM `priv_deals` LEFT JOIN `priv_stores` ON `stor_id` = `deal_store` WHERE `deal_active` = '1' AND `deal_store` = '" . res( $array_deal[ "stor_id" ] ) . "' AND `deal_id` <> '" . res( $array_deal[ "deal_id" ] ) . "' ORDER BY `deal_insert` DESC LIMIT 50 ) AS `xxx` ORDER BY RAND() LIMIT 9" );
if ( count( $array_moredeals ) > 0 ) {
echo "";
echo "![" . htm( $array_deal[ "stor_name" ] ) . "](" . image_store( $array_deal[ "stor_logo_name" ] ) . " "\" . htm( $array_deal[ \"stor_name\" ] ) . \"")
"; echo "
"; echo "![" . htm( $array_deal[ "stor_name" ] ) . " coupon code](" . image_deal( $array_deal[ "deal_id" ] ) . " "\" . htm( $array_deal[ \"stor_name\" ] ) . \"")
"; echo "
" . tra( "Share in" ) . " "; echo " Facebook "; echo " Twitter "; echo " " . tra( "Mail" ) . " "; echo " Messenger "; echo " Whatsapp "; echo " " . tra( "Report" ) . " "; // echo " " . tra( "Report" ) . " "; if ( user_can( "admin_deal_insert.php" ) ) { echo " Add "; echo " Edit "; } $array_deal_votes = query_array_row( "SELECT SUM( IF( `vote_value` > 0, 1, 0 ) ) AS `positives`, SUM( IF( `vote_value` < 0, 1, 0 ) ) AS `negatives`, SUM( `vote_value` ) AS `diference`, COUNT( `vote_id` ) AS `total` FROM `priv_deals_votes` WHERE `vote_owner` = '" . res( $array_deal[ "deal_id" ] ) . "'" ); if ( isset( $_SESSION[ "user_id" ] ) ) { $array_deal_vote = query_array_row( "SELECT `vote_value` FROM `priv_deals_votes` WHERE `vote_user` = '" . res( $_SESSION[ "user_id" ] ) . "' AND `vote_owner` = '" . res( $array_deal[ "deal_id" ] ) . "'" ); } else { $array_deal_vote = array(); } echo " " . tra( "Dislike" ) . " "; echo " " . tra( "Like" ) . " "; $row_deal_follower = query_array_row( "SELECT IFNULL( SUM( 1 ), 0 ) AS `count` FROM `priv_deals_followers` WHERE `foll_owner` = '" . res( $array_deal[ "deal_id" ] ) . "' AND `foll_user` = '" . res( $_SESSION[ "user_id" ] ) . "'" ); echo " " . tra( "Follow" ) . " "; echo "
";
echo ""; echo "
" . htm( $array_deal[ "stor_name" ] ) . " " . tra( "Discount Coupons" ) . "
"; echo "" . htm( $array_deal[ "deal_title" ] ) . " " . tra( "at" ) ." " . htm( $array_deal[ "stor_name" ] ) . "
"; echo "" . tra( "COPY CODE" ) .": " . strtoupper( $array_deal[ "deal_code" ] ) . "
"; echo "
"; echo "
" . tra( "Share in" ) . " "; echo " Facebook "; echo " Twitter "; echo " " . tra( "Mail" ) . " "; echo " Messenger "; echo " Whatsapp "; echo " " . tra( "Report" ) . " "; // echo " " . tra( "Report" ) . " "; if ( user_can( "admin_deal_insert.php" ) ) { echo " Add "; echo " Edit "; } $array_deal_votes = query_array_row( "SELECT SUM( IF( `vote_value` > 0, 1, 0 ) ) AS `positives`, SUM( IF( `vote_value` < 0, 1, 0 ) ) AS `negatives`, SUM( `vote_value` ) AS `diference`, COUNT( `vote_id` ) AS `total` FROM `priv_deals_votes` WHERE `vote_owner` = '" . res( $array_deal[ "deal_id" ] ) . "'" ); if ( isset( $_SESSION[ "user_id" ] ) ) { $array_deal_vote = query_array_row( "SELECT `vote_value` FROM `priv_deals_votes` WHERE `vote_user` = '" . res( $_SESSION[ "user_id" ] ) . "' AND `vote_owner` = '" . res( $array_deal[ "deal_id" ] ) . "'" ); } else { $array_deal_vote = array(); } echo " " . tra( "Dislike" ) . " "; echo " " . tra( "Like" ) . " "; $row_deal_follower = query_array_row( "SELECT IFNULL( SUM( 1 ), 0 ) AS `count` FROM `priv_deals_followers` WHERE `foll_owner` = '" . res( $array_deal[ "deal_id" ] ) . "' AND `foll_user` = '" . res( $_SESSION[ "user_id" ] ) . "'" ); echo " " . tra( "Follow" ) . " "; echo "
" . tra( "More deals" ) . "
"; echo "";
foreach ( $array_moredeals as $array_moredeal ) {
echo "
";
}
echo "";
echo "
";
}
echo "";
echo "
";
echo "";
echo "![" . htm( $array_moredeal[ "stor_name" ] ) . " coupon code](" . image_deal( $array_moredeal[ "deal_id" ] ) . " "\" . htm( $array_moredeal[ \"stor_name\" ] ) . \"")
";
echo "
";
echo "" . htm( $array_moredeal[ "deal_title" ] ) . "
"; echo "" . tra( "Recommended stores" ) . "
"; echo "";
$array_stores = query_array_all( "SELECT `stor_id` FROM `priv_networks_affiliations` LEFT JOIN `priv_networks_stores` ON `nest_id` = `neaf_network_store` LEFT JOIN `priv_stores` ON `stor_id` = `nest_store` WHERE `neaf_approved` = '1' AND `neaf_coupon` IS NOT NULL AND `stor_active` = '1' ORDER BY RAND() LIMIT 16" );
if ( count( $array_stores ) > 0 ) {
foreach ( $array_stores as $array_store ) {
store_card( $array_store[ "stor_id" ] );
}
}
echo "
";
echo "" . tra( "New stores" ) . "
"; echo "";
$array_stores = query_array_all( "SELECT * FROM ( SELECT `stor_id` FROM `priv_stores` WHERE `stor_active` = '1' " . ( $array_system_site[ "site_networkonly" ] == 1 ? "AND ( SELECT SUM( 1 ) FROM `priv_networks_affiliations` LEFT JOIN `priv_networks_stores` ON `nest_id` = `neaf_network_store` WHERE `neaf_approved` = '1' AND `nest_store` = `stor_id` ) > 0 " : "" ) . "ORDER BY `stor_insert` DESC LIMIT 1000 ) AS `table1` ORDER BY RAND() LIMIT 4" );
if ( count( $array_stores ) > 0 ) {
foreach ( $array_stores as $array_store ) {
store_card( $array_store[ "stor_id" ] );
}
}
echo "
";
echo "