$base=getenv("SCRIPT_FILENAME"); $dir=dirname($base); require($dir."/db.inc.php"); //Ausgabe der Spracherweiterung 2----------------------------------------------- $sql_lang= "Select * FROM se_texteein WHERE lang = '$language'"; $result_lang=mysqli_query($link_id, $sql_lang); $daten_lang=mysqli_fetch_array($result_lang); //Abfrage der Freunde bei den bereits anfragen gestartet wurden sind----------------------------------------------- // $sql4= "Select `user`.`uid`, `user`.`vn`, `user`.`nn`, `user`.`unter`, `user`.`persland`, `user`.`stnummer`, `friends`.`status`, `friends`.`uidf`, `friends`.`friend_id`, // IF(`friends`.`uidf`=$uid, 'out', 'in') as `REQUEST_DIRECTION` FROM `se_kontakte` as `friends` LEFT JOIN `se_user` as `user` ON (`user`.`uid`=IF(`friends`.`id`=$uid,`friends`.`friend_id`,`friends`.`uidf`)) WHERE `friend_id`= '$uid' OR `uidf`='$uid' LIMIT 3"; // $result4=mysqli_query($link_id, $sql4); //////////////baue schleife mit abfrage drueber // while AND wert } //Abfrage der Mitglieder die die selbe Steuernummer besitzen aber noch nicht kontaktiert wurden //$sql6= "Select `user`.`uid`, `user`.`vn`, `user`.`nn`, `user`.`unter`, `user`.`persland`, `user`.`stnummer`, `friends`.`status`, `friends`.`uidf`, `friends`.`friend_id`, IF(`friends`.`uidf`='$uid', 'out', 'in') as `REQUEST_DIRECTION` FROM `se_kontakte` as `friends` LEFT JOIN `se_user` as `user` ON (`user`.`uid`=IF(`friends`.`id`='$uid',`friends`.`friend_id`,`friends`.`uidf`)) WHERE `friends`.`uidf` != '$uid' AND `friends`.`friend_id` != '$uid' AND "; // $result6=mysqli_query($link_id, $sql6); //versand von Bestätigung----------------------------------------------- $ipi = getenv("REMOTE_ADDR"); $httprefi = getenv ("HTTP_REFERER"); $httpagenti = getenv ("HTTP_USER_AGENT"); $query2 = "SELECT * FROM se_test WHERE uid= '$benutzer' AND Online = 'Online'"; $result2=mysqli_query($link_id, $query2); $query3 = "SELECT * FROM se_test WHERE uid= '$benutzer' AND Online = 'Offline'"; $result3=mysqli_query($link_id, $query3); $query4 = "SELECT * FROM tri_slot WHERE per_uid= '$arra1[uid]' ORDER BY `tri_slot` ASC "; $result4=mysqli_query($link_id, $query4); $arra_zeit = mysqli_fetch_array($result4); $query5 = "SELECT se_user.vn AS vorname, se_user.nn AS nachname, se_user.uid AS startnummer, se_user.zugcode, se_user.strshow, se_user.tri_staff, se_user.ort, tri_slot.tri_slot AS gebuchteZeit FROM se_user LEFT JOIN tri_slot ON se_user.uid = tri_slot.per_uid WHERE tri_slot.per_uid != '' ORDER BY tri_slot.tri_slot ASC"; $result5=mysqli_query($link_id, $query5); //Zählt die Plätze----------------------------------------------- $sql6="SELECT COUNT(*) AS voll FROM `tri_slot` "; $result6=mysqli_query($link_id, $sql6); $daten6=mysqli_fetch_array($result6); //Zählt die Plätze----------------------------------------------- $sql7="SELECT COUNT(*) AS anzahl FROM `tri_slot` WHERE `per_uid`!='' "; $result7=mysqli_query($link_id, $sql7); $daten7=mysqli_fetch_array($result7); //$query6 = "SELECT COUNT( se_user.vn, se_user.nn, se_user.uid, se_user.ort, tri_slot.tri_slot FROM se_user LEFT JOIN tri_slot ON se_user.uid = tri_slot.per_uid WHERE tri_slot.tri_slot = '' ) AS total"; //$result6=mysqli_query($link_id, $query6); ?>