1) {exit;} //Lšnder-Lookup $countries = array(); $query_country = mysql_query("select id, Name, IntName, `ISO-2` as iso from countries", $conn); while($res = mysql_fetch_assoc($query_country )) { $countries[$res['id']] = $res; } mysql_free_result($query_country); $res = mysql_fetch_assoc($query); $res_company = $res; mysql_free_result($query); //Logo $res['image_id'] = getFrontImageID('company_id', $res['company_id']); //Land $res['company_country'] = getCountryById($res['country_id'], $_SESSION['language']); //Kategorien $res['category_list'] = getCategoryTextList('P', $_SESSION['language'], 'company_id', $res['company_id']); //Lšnder-Icon $res['country'] = $countries[$res['country_id']]; $res['country_icon'] = strtolower($countries[$res['country_id']]['iso']).".gif"; $smarty->assign("company", $res); $smarty->assign("page_title", $res['company_name']); //---------------------------------------------------------------------------------------------- //Benutzer dieses Unternehmens, Member $company_users = array(); $members = array(); $query = mysql_query("select * from users where company_id = '".$res_company['company_id']."' and locked = 'N' and account_create_confirm_date is not null order by lastname, firstname", $conn); while($res = mysql_fetch_assoc($query)) { array_push($company_users, $res['user_id']); $res['image_id'] = getFrontImageID('user_id', $res['user_id']); array_push($members, $res); } mysql_free_result($query); if(count($company_users) == 0) {$company_users = array(0);} $company_users_list = implode(",", $company_users); $smarty->assign("members", $members); //History $query = mysql_query("select user_id from users where company_id = '".addslashes($_GET['company_id'])."'", $conn); while($res = mysql_fetch_assoc($query)) { addHistory("Ihr Unternehmensprofil", "Your company profile", $res['user_id'], addslashes($_GET['company_id'])); } mysql_free_result($query); //XAJAX-Funktionen $xajax = new xajax(); $xajax->setFlag('errorHandler', TRUE); $xajax->setFlag('debug', FALSE); $xajax->processRequest(); $smarty->assign("xajax_js", $xajax->getJavascript("/php/")); $smarty->assign("active_section", "contacts"); $smarty->assign("tplContent", "companies/company_view.tpl.html"); $smarty->display("main/main.tpl.html"); ?>