, txlkey 22 $txlkey = 19; //Needed for include_head because otherwise group 22 will be taken include ("/var/www/html/robotigs/includes/include_head.php"); //Entire header //*** PART DATA ---------------------------------------------------------------- $qrybd = ("SELECT onderdelen.prt_icon_link , tblsystext.txtname , onderdelen.selectable , onderdelen.status , onderdelen.idsrtodd , onderdelen.sketchtext , onderdelen.sketchlink , onderdelen.keywords , onderdelen.part_master , onderdelen.pinouttext , onderdelen.pinoutlink , onderdelen.codetext , onderdelen.codelink , onderdelen.prijseurinclbtw , onderdelen.urlprijs , onderdelen.werkspanningvoltdc , onderdelen.stroomverbruikmax , onderdelen.opmerking , onderdelen.lanid FROM tblsystext LEFT JOIN onderdelen ON tblsystext.recordid = onderdelen.partid WHERE tblsystext.recordid = $part AND tblsystext.lanid = onderdelen.lanid AND tblsystext.txlid = 19 AND partid=$part ;"); $resultbd = pg_query($con1, $qrybd); $rowbd = pg_fetch_array($resultbd); $lankey = $lan; //Rename this variable if ($lankey > 0){ //Still needed since the cookie will work from next time $koekje[2] = $lankey; //Force the language to be changed in spite of cookie }else{ $lankey = $rowbd[18]; } //End of if ($lankey > 0) End adapting user language //*** FROM HERE ON THE NORMAL USER SCREEN STARTS ------------------------------- echo ('

'); echo (""); echo (""); include ("/var/www/html/robotigs/includes/include_menu.php"); echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo (""); echo ("'); echo (""); echo ("'); echo ('

	"); //Show name of the screen echo (""); echo ("$txttit
"); //****************************************************** ICON $tmp = get_txt($con1, 9, $koekje[2], 3733); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo (""); echo ("
"); //**************************************************** STATUS $tmp = get_txt($con1, 9, $koekje[2], 3734); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo ("
"); //*************************************************** KY-CODE $tmp = get_txt($con1, 9, $koekje[2], 3739); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo (""); echo ("
"); //*********************************************** KY-CODE URL $tmp = get_txt($con1, 9, $koekje[2], 3740); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo (""); echo ("
"); //****************************************** PRICE INDICATION $tmp = get_txt($con1, 9, $koekje[2], 3741); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo (""); echo ("
"); //************************************************* PRICE URL $tmp = get_txt($con1, 9, $koekje[2], 3742); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo (""); echo ("
"); //*********************************************** SKETCH NAME $tmp = get_txt($con1, 9, $koekje[2], 3738); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo (""); echo ("
"); //************************************************ SKETCH URL $tmp = get_txt($con1, 9, $koekje[2], 3743); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo (""); echo ("
"); //*********************************************** PINOUT NAME $tmp = get_txt($con1, 9, $koekje[2], 3744); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo (""); echo ("
"); //************************************************ PINOUT URL $tmp = get_txt($con1, 9, $koekje[2], 3745); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo (""); echo ("
"); //************************************************ MENU GROUP $tmp = get_txt($con1, 9, $koekje[2], 3735); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo ("
"); //************************************************** KEYWORDS $tmp = get_txt($con1, 9, $koekje[2], 3746); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo (""); echo ("
"); //**************************************** LANGUAGE SELECTION $tmp = get_txt($con1, 9, $koekje[2], 3918); //Fieldname at screen if ($koekje[3]=="1") { //If this user wants to translate then echo ("$tmp"); //Class for colour }else{ //So you are not allowed to translate echo $tmp; //Show screenname of this field in user language } //End of If you want to translate this fieldname at screen echo ("	"); echo ("

'); echo (''); echo (""); echo ('

'); echo (""); echo (""); exit; //////////////////////////////////////////////////////////////////////////////// function echo_options_language($conid, $lan, $defrec){ $qry = ("SELECT * FROM tblsystext WHERE txlid = 1 AND lanid = $lan ORDER BY txtname"); $result = pg_query($conid, $qry); while($row = pg_fetch_array($result)){ //Make the fields accesible foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } if ($rstid==2 or $recordid==$defrec){ echo (""); } } return ("ok"); } //////////////////////////////////////////////////////////////////////////////// function echo_options_srtonderdeel($conid, $lan, $defrec){ /* if($def_rec=="0"){ echo (""); }else{ echo (""); } */ $qry = ("SELECT * FROM tblsystext WHERE txlid = 26 AND lanid = $lan ORDER BY txtname"); $result = pg_query($conid, $qry); while($row = pg_fetch_array($result)){ //Make the fields accesible foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } if ($rstid==2 or $recordid==$defrec){ echo (""); } } return ("ok"); } //////////////////////////////////////////////////////////////////////////////// function echo_options_onderdelen($conid, $lan, $defrec){ if($defrec=="0"){ echo (""); }else{ echo (""); } $qry = ("SELECT * FROM tblsystext WHERE txlid = 19 AND lanid = $lan ORDER BY txtname"); $result = pg_query($conid, $qry); while($row = pg_fetch_array($result)){ //Make the fields accesible foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } if ($rstid==2 or $recordid==$defrec){ echo (""); } } return ("ok"); } //////////////////////////////////////////////////////////////////////////////// function echo_options_status($conid, $lan, $defrec){ $qry = ("SELECT tblsystext.txtname , tblsystext.recordid , status.nr FROM tblsystext LEFT JOIN status ON tblsystext.recordid = status.id WHERE txlid = 61 AND lanid = $lan ORDER BY status.nr"); $result = pg_query($conid, $qry); while($row = pg_fetch_array($result)){ //Make the fields accesible echo (""); } return ("ok"); } //////////////////////////////////////////////////////////////////////////////// function echo_options_users($conid, $defrec){ $qry = ("SELECT tblsysuser.*, tblperson.* FROM tblsysuser LEFT JOIN tblperson ON tblsysuser.tblpersonid = tblperson.prsid WHERE tblsysuser.robotigs_status > 51 OR tblsysuser.usrid = '$defrec' ORDER BY tblperson.prsname ;"); $result = pg_query($conid, $qry); while($row = pg_fetch_array($result)){ //Make the fields accesible foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } if ($rstid==2 or $usrid==$defrec){ echo (""); } } return; } //////////////////////////////////////////////////////////////////////////////// function get_person_name($con1, $usrkey, $lankey){ $qry=("SELECT tblsysuser.*, tblperson.*, tblsystext.* FROM tblsysuser LEFT JOIN tblperson ON tblsysuser.tblpersonid = tblperson.prsid LEFT JOIN tblsystext ON tblsystext.recordid = tblperson.genid WHERE tblsysuser.usrid = $usrkey AND tblsystext.txlid = 4 AND tblsystext.lanid = $lankey ;"); $result = pg_query($con1, $qry); while($row = pg_fetch_array($result)){ //Make fields accesible by their name foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } } $tmp = ""; if ($genid < 3){ //genid $tmp = ("$txtname"); } if ($prscallname>""){ //prscallname if ($tmp > ""){ $tmp = "$tmp $prscallname"; }else{ $tmp = "$prscallname"; } }else{ if ($prsprename>""){ if ($tmp > ""){ $tmp = "$tmp $prsprename"; }else{ $tmp = "$prsprename"; } } } if ($prsmiddlename>""){ //prsmiddlename if ($tmp > ""){ $tmp = "$tmp $prsmiddlename"; }else{ $tmp = "$prsmiddlename"; } } if ($tmp > ""){ $tmp = "$tmp $prsname"; //prsname }else{ $tmp = "$prsname"; } return ("$tmp"); } ?>