Dieses Script kann nur von anderen Scripten aus aufgerufen werden!
'); $smarty->display ('standard.tpl'); exit; } $query = "SELECT * FROM $wordstable w, $transtable tr, $typestable typ WHERE tr.translation = '$trans_old' AND tr.tid = '$tid' AND typ.tid = '$tid' AND typ.wid = '$wid' AND w.wid = '$wid' ORDER BY word"; $result = mysql_db_query($dbName, $query); $res = mysql_fetch_array($result); $smarty->assign ('caption', 'eintrag bearbeiten'); $content = ""; if (($processed != 1) || !$trans || !$type) { // no translation or type given if ((!$trans || !$type) && ($processed == 1)) { $content .= "Es wurde keine Übersetzung oder Wortart angegeben!
"; $content .= ""; } $nom_selected = ""; $ver_selected = ""; $adj_selected = ""; if ($res[type] == "Nomen") $nom_selected = " selected"; if ($res[type] == "Verb") $ver_selected = " selected"; if ($res[type] == "Adjektiv") $adj_selected = " selected"; $content .= '
ACHTUNG: Wenn eine Übersetzung sowohl groß als auch klein geschrieben ein und demselben Wort zugeordnet ist, werden beide durch diesen Befehl geändert!
'; } else { // all needed fields have been passed, so edit the entry $tid_old = $tid; $exists = false; if ($res[type] != $type) { // types are differnet, so look if the new type exists $query = "SELECT * FROM $typestable WHERE type = '$type' AND wid = '$wid'"; $result = mysql_db_query($dbName,$query); if ($result && mysql_num_rows($result) > 0) { $rtype2 = mysql_fetch_array($result); $query2 = "SELECT * FROM $transtable WHERE tid = '$rtype2[tid]' AND translation = '$trans'"; $result2 = mysql_db_query($dbName,$query2); if ($result2 && mysql_num_rows($result2) > 0) { // translation with this type already exists! $content .= "Diese Übersetzung mit dieser Wortart existiert bereits!
"; $exists = true; } else { // it's already there and translations are different, so reasign the $tid $tid = $rtype2[tid]; } } else { // isn't there, so insert a new type and reasign the $tid $query = "INSERT INTO $typestable VALUES(NULL, '$wid', '$type')"; $result1 = mysql_db_query($dbName,$query); // look up the new tid $query = "SELECT * FROM $typestable WHERE wid = '$wid' AND type = '$type'"; $result = mysql_db_query($dbName,$query); $rtype2 = mysql_fetch_array($result); $tid = $rtype2[tid]; } } // now update the $transtable if (!$exists) { $query = "UPDATE $transtable SET translation = '$trans', comment = '$comment', tid = '$tid' WHERE tid = '$tid_old' AND translation = '$trans_old'"; $result2 = mysql_db_query($dbName,$query); // now check if the old type is still used by another word $query = "SELECT * FROM $typestable typ, $transtable tr WHERE tr.tid = typ.tid AND typ.tid = '$tid_old'"; $result = mysql_db_query($dbName,$query); if ($result && mysql_num_rows($result) == 0) { // no, so delete it $query = "DELETE FROM $typestable WHERE tid = '$tid_old'"; $delresult = mysql_db_query ($dbName,$query); } if (!$result2) { $content .= 'Es ist ein Fehler beim Schreiben der bearbeiteten Daten aufgetreten. Bitte kontaktieren sie den Webmaster!
'; } else { $content .= "Bearbeitete Daten wurden erfolgreich übernommen.
"; } } } $smarty->assign ('content', $content); $smarty->display ('standard.tpl'); ?>