800-962-4427 (800) 962-4427
chat my account track my order
shopping cart
Mikes Cigars
(800) 962-4427
Mikes Cigars Ships to APO/FPO
Shopping Cart: 0 items, $ 0.00

Mikes Cigars blog Twitter Facebook Google+ Pinterest You Tube Cigar Video Trip Advisor request catalog


Pick a prize, spin the wheel. Everyone's a winner at Mike's!

Welcome to Mike's Cigars Incredible Wheel of Deals, where you buy a box and get the perfect free gift every time.

To play, simply select the free gift you'd like to receive, and give the ole' wheel a spin Pat Sajak-style to learn what accompanying purchase lands you your free "surprise".

Not thrilled by the super selection our computer made for you, go ahead and keep spinning 'til you find one to your liking!

Sound simple? It is! With brands like Partagas, Montecristo, Macanudo and La Gloria plus torch lighters, cutters and other nice cigar swag, choosing a great gift for yourself or a friend couldn't be easier.

Don't hesitate on this one folks, the selection may change and stock will go fast, so grab'em while they last.

= "'.time().'" OR ps.`date_end`="") AND ps.`flag_application`="0" AND ps.`flag_type`="1" AND ps.flag_display="1" ORDER BY ps.special_title;'; //$q_cgrid = 'SELECT * FROM '.DB_PREFIX.'products_specials ps WHERE prspid=270 or prspid=271'; $r_cgridx = $mysql->execute_select($q_cgridx); $browseMe=array(); $res_items=array(); $res_items2=array(); while($rowx = $r_cgridx->fetch_assoc()){ //get special details $selItemID=$rowx['prspid']; $q_cgrid = 'SELECT * FROM '.DB_PREFIX.'products_specials ps WHERE ps.prspid="'.intval($selItemID).'";'; $r_cgrid = $mysql->execute_select($q_cgrid); $row = $r_cgrid->fetch_assoc(); //get special conditions $sSQL='SELECT * FROM '.DB_PREFIX.'products_specials_conditions ps WHERE ps.prspid="'.intval($selItemID).'";'; $q = $mysql->execute_select($sSQL); $conditions_list=array(); while($row_cond=$q->fetch_assoc()){ array_push($conditions_list,$row_cond); } $cont_=1; foreach($conditions_list as $condition){ //print_r($condition); $sql_where=''; if($condition['flag_range']==1){ //category $cat_id=$condition['id_special']; $sql_where.=" AND pi.pcatid like('%#".$cat_id."#%') "; }elseif($condition['flag_range']==2){ //brand $brand_id=$condition['id_special']; $sql_where.=" AND pbl.pbrpid='$brand_id' "; }elseif($condition['flag_range']==3){ //item $item_id=$condition['id_special']; $sql_where.=" AND pi.pritid='$item_id' "; }else{ //any $item_id=$condition['id_special']; $sql_where.=" AND (pi.pritid='$item_id' OR pi.pbrid='$item_id' OR pi.pcatid like('%#".$item_id."#%')) "; } //UM Qulifier if($condition['flag_um_comparison']==1){ //heigher $sql_where.=' AND pu.um_qty_basic >="'.$condition['um_qualifier'].'"'; }else{ //equal $sql_where.=' AND pu.um_qty_basic ="'.$condition['um_qualifier'].'"'; } //Item qualifier number of packs or sum must be = or >= than set value $quantity =$condition['quantity']; $q_items = 'SELECT pi.`pritid`, pi.`item_name`, pi.`sku`, pi.`url_key` as prod_url_key,pi.`flag_kit` ,pu.`um_photo`, pu.`umid`, pu.`flag_force_inventory`,pu.`um_msrp`,pu.`um_flag_msrp`,pu.`flag_show_you_save`,pu.`um_breakable_order`,pu.`um_qty_basic`,pu.`flag_show_um`,pu.`flag_status`,pu.`flag_web` ,asv.`atribute_value` as um_name, asv.`url_key` as um_url_key ,pb.`pbrid`,pb.`brand_name` ,pbl.`pl_name`,pbl.`pbrpid`,pbl.`meta_title`,pbl.`meta_description`,pbl.`meta_keywords`,pbl.`flag_display_mode`,pbl.`footer_links`,pbl.`no_inventory_force` ,pc.`cat_meta_title`,pc.`cat_meta_description`,pc.`cat_meta_keywords`,pc.`url_key` as cat_url_key, pc.`pcatid` ,pii.`item_units` FROM '.DB_PREFIX.'products_items pi LEFT JOIN '.DB_PREFIX.'products_brands_lines pbl ON pi.`pbrpid` = pbl.`pbrpid` LEFT JOIN '.DB_PREFIX.'products_brands pb ON pb.`pbrid` = pbl.`pbrid` LEFT JOIN '.DB_PREFIX.'products_um pu ON pi.`pritid` = pu.`pritid` LEFT JOIN '.DB_PREFIX.'attribute_sets_values asv ON pu.`atsid` = asv.`atsid` LEFT JOIN '.DB_PREFIX.'products_category_items pci ON pci.`pritid`=pi.`pritid` LEFT JOIN '.DB_PREFIX.'products_category pc ON pc.`pcatid`=pci.`pcatid` LEFT JOIN '.DB_PREFIX.'products_items_inventory pii ON pii.`pritid` = pu.`pritid` AND pii.`umid`=pu.`umid` WHERE `um_flag_available` != "2" AND pi.`flag_status` = "1" AND pu.`flag_status` = "1" AND pu.`flag_web` = "1"'.$sql_where; $r_items = $mysql->execute_select($q_items); while($row_item=$r_items->fetch_assoc()){ $row_item['qty_']=$quantity; $row_item['special_id']=$selItemID; if(!in_array($row_item['umid'],$res_items2)){ array_push($res_items,$row_item); array_push($res_items2,$row_item['umid']); }else{ $res_items3=array(); foreach($res_items as $rit){ if($rit['umid']==$row_item['umid']){ $rit['special_id']=$rit['special_id'].'-'.$selItemID; } array_push($res_items3,$rit); } $res_items=$res_items3; } } } } $browseMe=$res_items; }else{ $broButtonValue="Switch to browse product and get gift"; $process_text_1="Pick your gift"; $process_text_2="Spin the wheel"; $process_text_3="Buy the product"; $q_cgrid = 'SELECT * FROM '.DB_PREFIX.'products_specials ps WHERE ps.`flag_status`="1" AND ps.`date_start`<="'.time().'"AND (ps.`date_end` >= "'.time().'" OR ps.`date_end`="") AND ps.`flag_application`="0" AND ps.`flag_type`="1" AND ps.flag_display="1" ORDER BY rand();'; //$q_cgrid = 'SELECT * FROM '.DB_PREFIX.'products_specials ps WHERE prspid=270 or prspid=271'; $r_cgrid = $mysql->execute_select($q_cgrid); $browseMe=array(); $i=0; while($row = $r_cgrid->fetch_assoc()){ $row=array_map('stripslashes', $row); $browseMe[$i]=$row; $i++; } } $BrowCount=count($browseMe); ?>

3 ){ echo ' '; echo ' '; }else{ echo ''; echo ''; } ?>