\n"; echo "
Please specify the database admin user at Admin
\n"; echo "\n"; die(""); } if(!mysql_select_db(Settings::value("DBNAME"))){ echo "
\n"; echo "
Could not select the specified database ". Settings::value("DBNAME") .".
\n"; echo "
\n"; mysql_close($connId); die(""); } if($mintype > 0){ if($mintypesid > 0){ # $mintype is the same mintype as the already stored one at $mintypesid if(!mysql_query("UPDATE mintypes_queue SET mintypesId=". $mintypesid ." WHERE id=". $mintype)) echo "Could not associate the selected MIN-Types.
\n"; else{ echo "\n"; } echo "\n"; echo ""; mysql_close($connId); exit; } if(array_key_exists("storemintype", $_POST)){ include("helpers.php"); # store new mintype $query = sprintf("INSERT INTO mintypes (name, description) VALUES('%s', '%s')", mysql_real_escape_string(stripText($_POST["mintypename"])), mysql_real_escape_string(stripText($_POST["mintypedescription"])) ); if(!mysql_query($query)){ echo "Could not store MIN-Type (Could not insert)"; mysql_close($connId); echo "\n"; echo ""; exit; } # get id of new manufacturer $name = mysql_real_escape_string($_POST["mintypename"]); $result = mysql_query("SELECT id FROM mintypes WHERE name='". $name ."'"); if(!$result){ echo "Could not store MIN-Type (Could not fetch new id)"; mysql_close($connId); echo "\n"; echo ""; exit; } $id = 0; $result = mysql_fetch_object($result); if($result){ if($result->id > 0) $id = $result->id; } if($id < 1){ echo "Could not store MIN-Type (New id < 1)"; mysql_close($connId); echo "\n"; echo ""; exit; } # set the new id as manufacturersId at the manufacturer_queue # $manu is the same as $manufacturersid if(!mysql_query("UPDATE mintypes_queue SET mintypesId=". $id ." WHERE id=". $mintype)){ echo "Could not store the selected MIN-Type.
\n"; } else{ echo "\n"; } echo "\n"; echo ""; mysql_close($connId); exit; } $res = mysql_query("SELECT * FROM mintypes_queue WHERE id=". $mintype); if(!$res) die(""); $mintype = mysql_fetch_object($res); if(!$mintype) die(""); # fetch possible other mintypes $res = mysql_query("SELECT * FROM mintypes WHERE name LIKE '%". $mintype->name ."%'"); if(!$res) die(""); $resCount = mysql_num_rows($res); if($resCount > 0){ echo "Found ". $resCount ." possible MIN-Types:\n"; echo "\n"; while($type = mysql_fetch_object($res)){ echo " \n"; echo " \n"; echo " \n"; } echo "
\n"; echo " ". $type->name; echo " ("; echo "Use"; echo ")\n"; echo "
\n"; } echo "
\n"; echo " id ."\">\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
". _("Name") .":name ."\" autofocus required>
". _("Description") .":
\n"; echo "
\n"; echo "\n"; echo ""; mysql_close($connId); exit; } ?>