function kfm_search($keywords, $tags) { include_once KFM_BASE_PATH . 'includes/files.php'; return _search($keywords, $tags); }
<?php require '../config.php'; $get = GETPOST('get'); switch ($get) { case 'search': __out(_search(GETPOST('key')), 'json'); break; default: break; } function _search($keyword) { global $db, $conf, $langs; $Tab = array(); $TType = array('invoice', 'commande', 'propal', 'projet', 'task', 'company', 'contact', 'event', 'product', 'facture_fournisseur', 'commande_fournisseur', 'fichinter'); if (!empty($conf->of->enabled)) { $TType[] = 'ordre_fabrication'; } //$TType=array('facture_fournisseur', 'commande_fournisseur'); foreach ($TType as $type) { $Tab[$type] = _search_type($type, $keyword); } return $Tab; } function _search_type($type, $keyword) { global $db, $conf, $langs; $table = MAIN_DB_PREFIX . $type; $objname = ucfirst($type); $id_field = 'rowid';
// getmails $result[] = _search('mail', 'mail_get'); // dns zones $result[] = _search('dns', 'dns_soa'); // secondary dns zones $result[] = _search('dns', 'dns_slave'); // virtual machines $result[] = _search('vm', 'openvz_vm'); // virtual machines os templates $result[] = _search('vm', 'openvz_ostemplate'); // virtual machines vm templates $result[] = _search('vm', 'openvz_template'); // virtual machines ip addresses $result[] = _search('vm', 'openvz_ip'); // directive snippets $result[] = _search('admin', 'directive_snippets'); $json = $app->functions->json_encode($result); } //} function _search($module, $section, $additional_sql = '') { global $app, $q, $authsql, $modules; $result_array = array('cheader' => array(), 'cdata' => array()); if (in_array($module, $modules)) { $search_fields = array(); $desc_fields = array(); if (is_file('../' . $module . '/form/' . $section . '.tform.php')) { include_once '../' . $module . '/form/' . $section . '.tform.php'; $category_title = $form["title"]; $form_file = $form["action"]; $db_table = $form["db_table"];
$msg= "<p align ='center'>".sprintf(_Pilot_email_used_in_pre_reg_dif_civlid,$r['user_name'])." </p>"; } else if($r['user_civlid']==$civlid && $civlid ){ $msg= "<p align ='center'>".sprintf(_Pilot_civlid_used_in_pre_reg_dif_email,$r['user_name'])."</p>"; } else { $msg="<p align ='center'>"._Pilot_have_pre_registration."</p>"; } echo $msg; closeMain(); return; } if($r=_search($_POST['email'],$civlid,$username,'pilots') && $civlid!=0 ){ // var_dump($r); $msg= "<p align ='center'>".sprintf(_Pilot_already_registered, $r['CIVL_ID'], $r['CIVL_NAME']) ."</p>"; echo $msg; closeMain(); return; } if(!$r=_search($_POST['email'],$civlid,$username,'users')) { $actkey=md5(uniqid(rand(), true)); $session_time=time(); $sql="INSERT into ".$CONF['userdb']['users_temp_table']."( user_civlid,user_civlname,user_name,user_firstname,user_lastname,user_nickname, user_password,user_nation,user_gender,user_birthdate,user_session_time, user_regdate,user_email,user_actkey ) VALUES( '".$civlid."' , '".addslashes($_POST['civlname'])."' , '".addslashes($_POST['username'])."' , '".addslashes($_POST['firstname'])."' , '".addslashes($_POST['lastname'])."' , '".addslashes($_POST['nickname'])."' , '".addslashes($_POST['password'])."'
dol_include_once('/product/class/product.class.php'); dol_include_once('/societe/class/societe.class.php'); dol_include_once('/comm/propal/class/propal.class.php'); dol_include_once('/projet/class/project.class.php'); dol_include_once('/projet/class/task.class.php'); dol_include_once('/comm/action/class/actioncomm.class.php'); dol_include_once('/compta/facture/class/facture.class.php'); dol_include_once('/commande/class/commande.class.php'); dol_include_once('/fourn/class/fournisseur.commande.class.php'); dol_include_once('/expedition/class/expedition.class.php'); $langs->load('searcheverywhere@searcheverywhere'); $langs->load('orders'); $get = GETPOST('get'); switch ($get) { case 'search': _search(GETPOST('type'), GETPOST('keyword')); break; default: break; } function _search($type, $keyword) { global $db, $conf, $langs; $table = MAIN_DB_PREFIX . $type; $objname = ucfirst($type); $id_field = 'rowid'; $complete_label = true; $show_find_field = false; $sql_join = ''; if ($type == 'company') { $table = MAIN_DB_PREFIX . 'societe';
<input class="submit_button" type="button" name="Submit" value=" Submit " onclick="Submit_Form();"/> </div></td> </tr> </table> </form> </td></tr> </table> <?php closeMain(); } if ($_POST['registerForm'] == 1) { if (!($r = _search($_POST['email'], $_POST['civlid'], 'temp'))) { if (!($r = _search('', $_POST['civlid'], 'pilots'))) { if (!($r = _search($_POST['email'], $_POST['civlid'], 'users'))) { // founded none in our database // update tables $pilotsTable $CONF['userdb']['users_table'] whith posted form $sql1 = "update " . $CONF['userdb']['users_table'] . " set user_civlid='" . $_POST['civlid'] . "', \n user_email='" . $_POST['email'] . "' where user_id={$userID}"; if ($db->sql_query($sql1)) { $civlID = $_POST['civlid']; $sql2 = "select pilotID from {$pilotsTable} where pilotID={$userID}"; $result = $db->sql_query($sql2); $user_exist = $db->sql_numrows($result); if ($user_exist) { $sql3 = "update {$pilotsTable} set CIVL_ID='" . $_POST['civlid'] . "', CIVL_NAME='" . addslashes($_POST['name']) . "'WHERE pilotID='{$userID}' "; if ($db->sql_query($sql3)) { print "<p align='center'>" . _Success_login_civl_or_user . "</p>"; } } }