";
$vis_logo = "";
} else {
$vis_logo = "![](http://www.abc--worldwide.com/site/resize.php?w=80&h=80&picture=../".$rows_vis[vi_logo].")
";
}
if($rows_vis[vi_business_photo]==""){
$vis_busphoto = "
";
}else{
$vis_busphoto = "![](http://www.abc--worldwide.com/site/imgsize.php?w=130&h=130&constrain=1&img=http://www.abc--worldwide.com/".$rows_vis[vi_business_photo].")
";
}
// contact_info
$sql_con = "SELECT contact_info.* FROM contact_info where contact_info.ID='$view_id' ";
mysqli_select_db($link, $Mysql_db);
$result_con = mysqli_query($link, $sql_con);
$rows_con = mysqli_fetch_array($result_con);
$ci_salutation = $rows_con[ci_salutation];
$ci_title = $rows_con[ci_title];
$ci_title2 = $rows_con[ci_title2];
$ci_name = $rows_con[ci_name];
$ci_lastname = $rows_con[ci_lastname];
$ci_business_name = $rows_con[ci_business_name];
$ci_birthdate = $rows_con[ci_birthdate];
$ci_occupation = $rows_con[ci_occupation];
$ci_position = $rows_con[ci_position];
$ci_dept = $rows_con[ci_dept];
$ci_email = $rows_con[ci_email];
$ci_tel = $rows_con[ci_tel];
$ci_fax = $rows_con[ci_fax];
$ci_msn = $rows_con[ci_msn];
$ci_skype = $rows_con[ci_skype];
$ci_icq = $rows_con[ci_icq];
$ci_yahoo = $rows_con[ci_yahoo];
$ci_voip = $rows_con[ci_voip];
$ci_web = $rows_con[ci_web];
$ci_apex_url = $rows_con[ci_apex_url];
$ci_language_corr = $rows_con[ci_language_corr];
$ci_contacted_by = $rows_con[ci_contacted_by];
$ci_webprofile = $rows_con[ci_webprofile];
//address_info
$sql_add = "SELECT address_info.* FROM address_info where address_info.ID='$view_id' ";
mysqli_select_db($link, $Mysql_db);
$result_add = mysqli_query($link, $sql_add);
$rows_add = mysqli_fetch_array($result_add);
$ai_business_address = $rows_add[ai_business_address];
$ai_state = $rows_add[ai_state];
$ai_province = $rows_add[ai_province];
$ai_region = $rows_add[ai_region];
$ai_location = $rows_add[ai_location];
$ai_street = $rows_add[ai_street];
$ai_building = $rows_add[ai_building];
$ai_num = $rows_add[ai_num];
$ai_zipcode = $rows_add[ai_zipcode];
$ai_po_box = $rows_add[ai_po_box];
$ai_map = $rows_add[ai_map];
//chk country
$sql_coun = "SELECT country.* FROM country where country.country_id='$rows_add[ai_country]' and country.lang ='$lang' ";
mysqli_select_db($link, $Mysql_country);
$result_coun = mysqli_query($link, $sql_coun);
$rows_coun = mysqli_fetch_array($result_coun);
$ai_country = $rows_coun[name];
//management_info
$sql_man = "SELECT management_info.* FROM management_info where management_info.ID='$view_id' ";
mysqli_select_db($link, $Mysql_db);
$result_man = mysqli_query($link, $sql_man);
$rows_man = mysqli_fetch_array($result_man);
$title_ceo = $rows_man[title_ceo];
$title_legal = $rows_man[title_legal];
$title_marketing = $rows_man[title_marketing];
$title_sale = $rows_man[title_sale];
$title_gm = $rows_man[title_gm];
$legal = $rows_man[legal];
$ceo = $rows_man[ceo];
$sale = $rows_man[sale];
$marketing = $rows_man[marketing];
$gm = $rows_man[gm];
$geo_market = $rows_man[geo_market];
$nbr_employee = $rows_man[nbr_employee];
$establish = $rows_man[establish];
$language = $rows_man[language];
$branch = $rows_man[branch];
$reference = $rows_man[reference];
$an_sale_rang = $rows_man[an_sale_rang];
$im_per = $rows_man[im_per];
$ex_per = $rows_man[ex_per];
$qc = $rows_man[qc];
$q_cert = $rows_man[q_cert];
$iso_cert = $rows_man[iso_cert];
$p_cash = $rows_man[p_cash];
$p_invoice = $rows_man[p_invoice];
$p_credit = $rows_man[p_credit];
$by_organization_type = $rows_man[by_organization_type];
$by_subject = $rows_man[by_subject];
$by_business_topic = $rows_man[by_business_topic];
$by_museum_type = $rows_man[by_museum_type];
$title_ch = $rows_man[title_ch];
$salutation_ch = $rows_man[salutation_ch];
$chancellor = $rows_man[chancellor];
$title_vice_ch = $rows_man[title_vice_ch];
$salutation_vice_ch = $rows_man[salutation_vice_ch];
$vice_chancellor = $rows_man[vice_chancellor];
$faculty = $rows_man[faculty];
$al_association = $rows_man[al_association];
$couse_offer = $rows_man[couse_offer];
$inter_cooperation = $rows_man[inter_cooperation];
$student = $rows_man[student];
$undergraduate = $rows_man[undergraduate];
$postgraduate = $rows_man[postgraduate];
$student_facility = $rows_man[student_facility];
$future_plan = $rows_man[future_plan];
$title_hc = $rows_man[title_hc];
$salutation_hc = $rows_man[salutation_hc];
$hc = $rows_man[hc];
$title_gp = $rows_man[title_gp];
$salutation_gp = $rows_man[salutation_gp];
$gp = $rows_man[gp];
$title_sta = $rows_man[title_sta];
$salutation_sta = $rows_man[salutation_sta];
$sta = $rows_man[sta];
$title_ssm = $rows_man[title_ssm];
$salutation_ssm = $rows_man[salutation_ssm];
$ssm = $rows_man[ssm];
$title_tsm = $rows_man[title_tsm];
$salutation_tsm = $rows_man[salutation_tsm];
$tsm = $rows_man[tsm];
$title_esm = $rows_man[title_esm];
$salutation_esm = $rows_man[salutation_esm];
$esm = $rows_man[esm];
$title_cl = $rows_man[title_cl];
$salutation_cl = $rows_man[salutation_cl];
$cl = $rows_man[cl];
$title_ta = $rows_man[title_ta];
$salutation_ta = $rows_man[salutation_ta];
$ta = $rows_man[ta];
$title_fsm = $rows_man[title_fsm];
$salutation_fsm = $rows_man[salutation_fsm];
$fsm = $rows_man[fsm];
$title_fta = $rows_man[title_fta];
$salutation_fta = $rows_man[salutation_fta];
$fta = $rows_man[fta];
$scientific = $rows_man[scientific];
$recent_research = $rows_man[recent_research];
$scientific_publications = $rows_man[scientific_publications];
$laboratory = $rows_man[laboratory];
$business_coporation = $rows_man[business_coporation];
$research_award = $rows_man[research_award];
$head_of_state = $rows_man[head_of_state];
$head_of_goverment = $rows_man[head_of_goverment];
$the_cabinet = $rows_man[the_cabinet];
$minister = $rows_man[minister];
$ministry = $rows_man[ministry];
$government_departments = $rows_man[government_departments];
$diplomatic = $rows_man[diplomatic];
$public_Civil = $rows_man[public_Civil];
$governments_programmes = $rows_man[governments_programmes];
$m_contacted_by = $rows_man[m_contacted_by];
//business_info
$sql_bus = "SELECT business_info.* FROM business_info where business_info.ID='$view_id' ";
mysqli_select_db($link, $Mysql_db);
$result_bus = mysqli_query($link, $sql_bus);
$rows_bus = mysqli_fetch_array($result_bus);
$bi_business_type2 = $rows_bus[bi_business_type];
$sql_btype="select * from business_type where business_type.type_id='$bi_business_type2'";
mysqli_select_db($link, $Mysql_db);
$result_btype = mysqli_query($link, $sql_btype);
$row_btype=mysqli_fetch_array($result_btype);
if($bi_business_type2 !=""){
$bi_business_type = $row_btype[name];
}else{
$bi_business_type = "-";
}
$bi_company_name = $rows_bus[bi_company_name];
$bi_company_desc = $rows_bus[bi_company_desc];
$bi_company_info2 = $rows_bus[bi_company_info];
$bi_legal_form = $rows_bus[bi_legal_form];
$bi_tax_id = $rows_bus[bi_tax_id];
$sql_business="select business_info.*,visual_info.vi_logo from business_info,visual_info where (business_info.ID=visual_info.ID) and business_info.ID='$_SESSION[ss_id]'";
mysqli_select_db($link, $Mysql_db);
$result = mysqli_query($link, $sql_business);
$rows=mysqli_fetch_array($result);
$type =$rows[bi_business_type];
$business_type = $rows[bi_legal_form];
$name_of_comp=$rows[bi_company_name];
$headline=$rows[bi_company_desc];
$str=$rows[bi_company_info];
$logo=$rows[vi_logo];
$bi_id=$rows[bi_id];
$bi_tax_id=$rows[bi_tax_id];
$show_badge=$rows[show_trusted_seller_badge];
if($rows_bus[bi_company_name]!=""){
$bi_name = $rows_bus[bi_company_name];
}else{
$bi_name = $rows_con[ci_title2]." ".$rows_con[ci_name]." ".$rows_con[ci_lastname];
}
if($rows_bus[bi_company_info]!=""){
$bi_company_info = $rows_bus[bi_company_info];
// $bi_company_info = substr($rows_bus[bi_company_info],0, 150)."... read more »";
}else{
$bi_company_info = "Not have company information please enter next »";
}
// bus look for
$sql_look="select * from business_lookfor where business_lookfor.ID='$view_id'";
mysqli_select_db($link, $Mysql_db);
$result_look = mysqli_query($link, $sql_look);
$row_look=mysqli_fetch_array($result_look);
$numrow_look = mysqli_num_rows($result_look);
if($row_look[new_business]!=""){
$look_business = "Generate new business";
}
if($row_look[interest_people]!=""){
$interest_people = "Get to know interesting people";
}
if($row_look[my_network]!=""){
$look_network = "Increase my network";
}
if($row_look[new_employee]!=""){
$look_employee = "Find new employees";
}
if($row_look[job_ad]!=""){
$job_look = "Post a job ad";
}
if($row_look[business_partners]!=""){
$look_partners = "Find business partners";
}
if($row_look[business_participation]!=""){
$look_participation = "Find business participation";
}
if($row_look[new_event]!=""){
$look_event = "Create and attend events";
}
if($row_look[find_friend]!=""){
$find_friend = "Locate old classmates, friends, collegues";
}
if($row_look[find_innovative]!=""){
$find_innovative = "Find innovative people who share same interests";
}
if($row_look[other]!=""){
$other_look = "Others: ".$row_look[other];
}
// bus want
$sql_want = "select * from business_details where ID='$view_id'";
$result_want = mysqli_query($link, $sql_want);
$row_want = mysqli_fetch_array($result_want);
$want_haves = $row_infom[bus_haves];
$want_wants = $row_infom[bus_wants];
$want_interest = $row_infom[bus_interest];
$want_org = $row_infom[bus_org];
/// check visit
$sql_ss = "SELECT member_info.* FROM member_info where member_info.ID='$_SESSION[ss_id]' ";
mysqli_select_db($link, $Mysql_db);
$result_ss = mysqli_query($link, $sql_ss);
$rows_ss = mysqli_fetch_array($result_ss);
$member_ss = $rows_ss[ID];
$type_ss = $rows_ss[type];
$mtype_ss = $rows_ss[membertype];
$sql_temp2 ="SELECT * FROM templete_user where ID = '$view_id' ";
mysqli_select_db($link, $Mysql_cmsContent);
$result_temp2 = mysqli_query($link, $sql_temp2);
$rows_temp2=mysqli_fetch_array($result_temp2);
$sql_temp ="SELECT * FROM templete where temp_id = '$rows_temp2[temp_id]' ";
mysqli_select_db($link, $Mysql_cmsContent);
$result_temp = mysqli_query($link, $sql_temp);
$rows_temp=mysqli_fetch_array($result_temp);
$FontColor = $rows_temp[font_color];
$BoderColor = $rows_temp[border_color];
if($rows_temp[bg_color]!=""){
$BgColor = $rows_temp[bg_color];
}else{
$BgImgs = $rows_temp[bg_imgs];
}
if($rows_temp[hd_color]!=""){
$HdBgColor = $rows_temp[hd_color];
}else{
$HdBgImgs = $rows_temp[hd_imgs];
}
if($rows_temp[mm_color]!=""){
$MmBgColor = $rows_temp[mm_color];
}else{
$MmBgImgs = $rows_temp[mm_imgs];
}
if($rows_temp[sb_color]!=""){
$SbBgColor = $rows_temp[sb_color];
}else{
$SbBgImgs = $rows_temp[sb_imgs];
}
if($rows_temp[lm_color]!=""){
$LmBgColor = $rows_temp[lm_color];
}else{
$LmBgImgs = $rows_temp[lm_imgs];
}
if($rows_temp[bd_color]!=""){
$BdBgColor = $rows_temp[bd_color];
}else{
$BdBgImgs = $rows_temp[bd_imgs];
}
if($rows_temp[ft_color]!=""){
$FtBgColor = $rows_temp[ft_color];
}else{
$FtBgImgs = $rows_temp[ft_imgs];
}
$Mysql_wp = 'aida936_wp';
$sql_event = "select `ID` from `wp_users` where `user_login`='$view_id' ";
mysqli_select_db($link, $Mysql_wp);
$result_event = mysqli_query($link, $sql_event);
$event_id = mysqli_fetch_array($result_event);
$event_id=$event_id['ID'];
$sql_article = "select * from `wp_posts` where `post_author`='$event_id' and `post_type`='post' and `post_status`='publish'";
mysqli_select_db($link, $Mysql_wp);
$result_article = mysqli_query($link, $sql_article);
$nums_article = mysqli_num_rows($result_article);
$rows_article = mysqli_fetch_array($result_article);
$sql_ads = "SELECT ID FROM `wp_posts` WHERE post_type IN ('property','product','ad') AND post_status = 'publish' AND post_author = $event_id ";
mysqli_select_db($link, $Mysql_wp);
$result_ads = mysqli_query($link, $sql_ads);
$nums_advertisements = mysqli_num_rows($result_ads);
$rows_ads = mysqli_fetch_array($result_ads);
$sql_event = "select * from `wp_posts` where `post_author`='$event_id' and `post_status`='publish' and `post_type`='event'";
mysqli_select_db($link, $Mysql_wp);
$result_event = mysqli_query($link, $sql_event);
$nums_event = mysqli_num_rows($result_event);
$rows_event = mysqli_fetch_array($result_event);
$sql_forum = "select * from `forum` where `ID`='$view_id' ";
mysqli_select_db($link, $Mysql_community);
$result_forum = mysqli_query($link, $sql_forum);
$nums_forum = mysqli_num_rows($result_forum);
$rows_forum = mysqli_fetch_array($result_forum);
$sql_group = "select * from `group` where `ID`='$view_id' ";
mysqli_select_db($link, $Mysql_community);
$result_group = mysqli_query($link, $sql_group);
$nums_group = mysqli_num_rows($result_group);
$rows_group = mysqli_fetch_array($result_group);
$sql_notice = "select * from `notice` where `ID`='$view_id' ";
mysqli_select_db($link, $Mysql_community);
$result_notice = mysqli_query($link, $sql_notice);
$nums_notice = mysqli_num_rows($result_notice);
$rows_notice = mysqli_fetch_array($result_notice);
$sql_photo = "select * from `photo` where `ID`='$view_id' ";
mysqli_select_db($link, $Mysql_community);
$result_photo = mysqli_query($link, $sql_photo);
$nums_photo = mysqli_num_rows($result_photo);
$rows_photo = mysqli_fetch_array($result_photo);
$sql_project = "select * from `project` where `ID`='$view_id' ";
mysqli_select_db($link, $Mysql_community);
$result_project = mysqli_query($link, $sql_project);
$nums_project = mysqli_num_rows($result_project);
$rows_project = mysqli_fetch_array($result_project);
$sql_video = "select * from `video` where `ID`='$view_id' ";
mysqli_select_db($link, $Mysql_community);
$result_video = mysqli_query($link, $sql_video);
$nums_video = mysqli_num_rows($result_video);
$rows_video = mysqli_fetch_array($result_video);
$sql_ans = "select * from `answer` where `ID`='$view_id' ";
mysqli_select_db($link, $Mysql_community);
$result_ans = mysqli_query($link, $sql_ans);
$nums_ans = mysqli_num_rows($result_ans);
$rows_ans = mysqli_fetch_array($result_ans);
$sql_blog = "select * from `blog` where `ID`='$view_id' ";
mysqli_select_db($link, $Mysql_community);
$result_blog = mysqli_query($link, $sql_blog);
$nums_blog = mysqli_num_rows($result_blog);
$rows_blog = mysqli_fetch_array($result_blog);
?>