decid(addslashes($cid)):''; $key=$db->singlerec("select * from company where id='$cid'"); ?> view_int($crnturlstr); $cid= isset($cid)?$com_obj->decid($cid):''; } if(empty($cid)){ echo ""; exit; } $cinfo = $db->singlerec("select company.*,register.lname,register.fname,register.img,register.country as ucon,register.email from company,register where company.user_id = register.id AND company.id = '$cid'"); $fcat=$db->singlerec("select category_name from category where id='".$cinfo['category']."'"); $cat=ucwords($fcat['category_name']); if(empty($cinfo)){ //echo ""; //exit; } $cat_name = $db->singlerec("select category_name from category where id='".$cinfo['category']."'"); $userid = $cinfo['user_id']; //include "include/hideCompany.php"; $country = $db->singlerec("select nicename,iso from countries where id = '".$cinfo['country']."'"); $prodque = "select * from product where userid='$userid'"; $sellque="select a.id,a.offer_name,a.prod_category, a.photo1,a.base_price,a.user_id,b.phone,b.start_date,a.price_unit,a.currency,a.keyword1,a.keyword2,a.keyword3,a.keyword4,a.brief_description,a.delivery_time,a.valid_until,a.post_date,b.name,c.category_name,d.country,d.email,d.fname,d.mem_pack,a.pay_method,a.min_order_quantity from selling_leads as a inner join company as b on a.user_id=b.user_id left join category as c on a.prod_category=c.id inner join register as d on a.user_id=d.id where a.active_status='1' and a.user_id='$userid'"; $buyque="select a.id,a.offer_name,a.user_id, b.start_date,b.phone,a.businesstype,a.pay_method,a.quan_unit,a.photo1,a.price,a.currency,a.keyword1,a.keyword2,a.keyword3,a.keyword4,a.det_desc,a.delivery_time,a.valid_until,a.maxbuy_capacity,a.exquantity,a.contact_desc,a.post_date,b.name,c.category_name,d.country,d.email,d.fname,d.mem_pack from buying_leads as a inner join company as b on a.user_id=b.user_id inner join category as c on a.prod_category=c.id inner join register as d on a.user_id=d.id where a.active_status='1' and a.user_id='$userid'"; include("companyheader.php"); ?>

:

:

:

:

:

:

:

( : )

:

: :

: (getCountry($cinfo['country']));?> )

get_all_asso($prodque); if(empty($prod_Lst)) { echo "

".$lang['nrecs']."..!!


"; } foreach($prod_Lst as $prd){ // check is the user is existe in db start $isThereC = $db->singlerec("select count(*) from company where user_id = '".$prd['userid']."'"); $isThereR = $db->singlerec("select count(*) from register where id = '".$prd['userid']."'"); if((int)$isThereC[0]===0 || (int)$isThereR[0]===0){continue;} //end $ccode = $db->singlerec("select currencycode from currency_code where id ='".$prd['prod_currency_loc']."' LIMIT 1"); $price=$prd['prod_minprice']; if($price) $price=$price.' '.$ccode[0]; else $price=" "; $exp_dt=date("d/m/Y", strtotime($prd['prod_expdate'])); $post_dt=date("d M Y", strtotime($prd['prod_crtdate'])); $bcap=explode('/', $prd['max_supply_quantity']); $b_cap=$bcap[0]; if($b_cap=="") $b_cap="None Specified"; $fcat=$db->singlerec("select category_name from category where id='".$prd['prod_category']."'"); $cat=ucwords($fcat['category_name']); $pname=ucwords($prd['prod_name']); if(41<(strlen($pname))) $pname=substr($pname,0,42)."..."; $encid=$com_obj->encid($prd['id']); $perma=strtolower(str_replace(" ", "-", $prd['prod_name'])); $keyword1=$prd['keyword1']; $keyword2=$prd['keyword2']; $keyword3=$prd['keyword3']; $keyword4=$prd['keyword4']; $mem_pack = $db->singlerec("select mem_pack from register where id='".$prd['userid']."'"); $mem_pack_name = $db->singlerec("select name,logo_package from membership where id = '".$mem_pack[0]."'"); $country = $db->singlerec("select country from register where id = '".$prd['userid']."'"); $prod_no=$prd['prod_no']; $prod_quantitytype=$prd['prod_quantitytype']; $supply_duration=$prd['supply_duration']; $briefdes=$prd['prod_briefdes']; $payment_type=$prd['payment_type']; $cemail = $db->singlerec("select email,fname from register where id = '".$prd['userid']."'"); $prodid = $prd['id']; $vcount=$db->singlerec("select count(id) from votes where product_id='$prodid' AND type='1' AND action = 'vote'"); $revcount=$db->singlerec("select count(id) from reviews where item_id='$prodid' AND active_status='1'"); ?>

:

:

: NIL');?>

:

: $paymethod){ $COM = $db->singlerec("select * from payment_methods where id ='$paymethod'"); if($ini==0){ } else { echo ","; } echo $COM['name'];$ini++;} ?>

:

|

: /

get_all_asso($sellque); if(empty($SL_Lst)) { echo "

".$lang['nrecs']."..!!


"; } else { foreach($SL_Lst as $SL) { if(file_exists("uploads/SL_images/banner1/".$SL['photo1'])){ $logourl = "$siteurl/uploads/SL_images/banner1/".$SL['photo1']; }else{ $logourl = "$siteurl/uploads/SL_images/banner1/noimage.jpg"; } $ccode = $db->singlerec("select currencycode from currency_code where id ='".$SL['currency']."'"); $price=$SL['base_price']; if($price) $price=$price.' '.$ccode[0]; else $price=" "; $des=substr($SL['brief_description'],0,210); $durat=$SL['delivery_time']; $payt = $SL['pay_method'];//substr($SL['pay_method'],0,11).'..'; $key=$SL['keyword1'].','.$SL['keyword2'].','.$SL['keyword1'].','.$SL['keyword3'].','.$SL['keyword4']; $mem_pack_name = $db->singlerec("select name,logo_package from membership where id = '".$SL['mem_pack']."'"); $cat = $db->singlerec("select category_name from category where id = '".$SL['prod_category']."'"); $cemail = $db->singlerec("select email,fname from register where id = '".$SL['user_id']."'"); $vcount=$db->singlerec("select count(id) from votes where product_id='".$SL['id']."' AND type='3' AND action = 'vote'"); ?>

:

:

:

:

: $paymethod){ $COM = $db->singlerec("select * from payment_methods where id ='$paymethod'"); if($ini==0){ } else { echo ","; } echo $COM['name'];$ini++;} ?>

:

:

: /

get_all_asso($buyque); if(!empty($BL_all)){ foreach($BL_all as $BL){ $BL_img = !empty($BL['photo1'])?$BL['photo1']:'noimage.jpg'; if(file_exists("uploads/BL_images/banner1/$BL_img")){ $logourl = "$siteurl/uploads/BL_images/banner1/$BL_img"; }else{ $logourl = "$siteurl/uploads/BL_images/banner1/noimage.jpg"; } $ccode = $db->singlerec("select currencycode from currency_code where id ='".$BL['currency']."'"); $price=$BL['price']; $perm=str_replace(" ", "-", $BL['offer_name']); $perm=strtolower($perm); $cat=$BL['category_name']; $mem_pack_name = $db->singlerec("select name,logo_package from membership where id = '".$BL['mem_pack']."'");; $country_name = $db->singlerec("select nicename from countries where id='".$BL['country']."'"); $cemail = $db->singlerec("select email,fname from register where id = '".$BL['user_id']."'"); $vcount=$db->singlerec("select count(id) from votes where product_id='".$BL['id']."' AND type='2' AND action = 'vote'"); ?>

15)?ucfirst(substr($BL['offer_name'],0,16).'...'):$BL['offer_name'];?>

:

: 24)?substr($BL['maxbuy_capacity'],0,25).' ...':$BL['maxbuy_capacity'];?>

:

: 24)?substr($BL['exquantity'],0,25).' ...':$BL['exquantity'];?>

: singlerec("select name from payment_methods where id=$payid"); echo $payt['name']; } } else{ echo "Not Specified"; } ?>

:

:

:

:


..!!!