$rule = "where id=$id"; /* THAT IS THE GENERAL RULE */ @mysql_connect("localhost","wwwuser","$dbpassword") or die("Connection died or wrong database password!"); mysql_select_db("e136") ; if ($action=="passwd"): /* CHANGE PASSWD */ $result = mysql_query("select passwd $db $rule"); $pagetitle = "Change Password"; $pageheadline = "Change Password for $id $db database"; include "../e136header.phtml"?>
include "../e136footer.phtml"; exit; endif; if ($action=="makepasswd"): /* MAKE NEW PASSWD */ $pagetitle = "New Password"; $pageheadline = "New Password for $id $db database"; include "../e136header.phtml"; if ($db=="from stammgast"): $subdb="stammgast"; endif; mysql_query("update $subdb set passwd=password('$passwd') $rule")?> Password changed! include "../e136footer.phtml"; exit; endif; if ($action=="delete"): /* DELETE ENTRY */ $pagetitle = "Delete Entry"; $pageheadline = "Delete Entry $id $db database"; include "../e136header.phtml"; $subdb = "gastzeit"; mysql_query("delete from $subdb $rule") or die("Failure to delete from $subdb $r ule"); mysql_query("delete $db $rule") or die("Failure to delete $db $rule")?> Entry echo $id?> echo $db?> and from echo $subdb?> database successful deleted. include "../e136footer.phtml"; exit; endif; if ($action=="edit"): /* EDIT ENTRY */ $pagetitle = "Edit Entry"; $pageheadline = "Edit Entry $id $db database"; include "../e136header.phtml"; $result = mysql_query("select * $db $rule"); $vorname = mysql_result($result,0,"vorname"); $nachname = mysql_result($result,0,"nachname"); $tit = mysql_result($result,0,"tit"); $org = mysql_result($result,0,"org"); $ort = mysql_result($result,0,"ort"); $vortit = mysql_result($result,0,"vortit"); $l_code = mysql_result($result,0,"l_code"); $gastauf = mysql_result($result,0,"gastauf"); $gastvor = mysql_result($result,0,"gastvor"); $subresultA = mysql_query("select * from gastzeit $rule and type='A'"); $subresultV = mysql_query("select * from gastzeit $rule and type='V'"); if ($gastauf==1): $tag = mysql_result($subresultA,0,"v_tag"); $monat = mysql_result($subresultA,0,"v_monat"); $jahr = mysql_result($subresultA,0,"v_jahr"); $day = mysql_result($subresultA,0,"b_tag"); $month = mysql_result($subresultA,0,"b_monat"); $year = mysql_result($subresultA,0,"b_jahr"); endif; if ($gastvor==1): $tt = mysql_result($subresultV,0,"v_tag"); $mm = mysql_result($subresultV,0,"v_monat"); $jj = mysql_result($subresultV,0,"v_jahr"); endif; ?> include "../e136footer.phtml"; exit; endif; /* NOT ALLOWED */ ?>