global.php

Audio-visual system an online simulation of the film, when operations can be used by the

else:

mysql_pconnect($dbhost,$dbuser,$dbpasswd);
$sql = "INSERT INTO $down_sort1_table (sort1,description) VALUES ('$downort1','$description')";
mysql_db_query($dbname,$sql);

echo "<center><br><br><br><br><br>add succeed ";
echo "<a href=./sort.php>Click here to return</a>";

endif;

} // end addsort1

function addsort2($downort2,$description,$sort1id){
global $dbhost,$dbuser,$dbpasswd,$dbname,$down_sort2_table;

if ($downort2==""):

echo "<center><br><br><br><br><br>";
echo "Name can not be empty<br>";
echo "<a href=javascript:history.back(1)>Click here to return</a>";

elseif ($sort1id == ""):

echo "<center><br><br><br><br><br>";
echo "Not the largest category of their choice<br>";
echo "<a href=javascript:history.back(1)>Click here to return</a>";

else:

mysql_pconnect($dbhost,$dbuser,$dbpasswd);

$sql = "INSERT INTO $down_sort2_table (sort2,description,sort1id) VALUES ('$downort2','$description',$sort1id)";

mysql_db_query($dbname,$sql);

echo "<center><br><br><br><br><br>add succeed ";
echo "<a href=./sort.php>Click here to return</a>";

endif;

} // end addsort2

function editsort1($id,$sort1,$description){
global $dbhost,$dbuser,$dbpasswd,$dbname,$down_sort1_table;

if ($sort1==""):

echo "<center><br><br><br><br><br>";
echo "Name can not be empty<br>";
echo "<a href=javascript:history.back(1)>Click here to return</a>";

else:

mysql_pconnect($dbhost,$dbuser,$dbpasswd);
$sql = "UPDATE $down_sort1_table SET sort1='$sort1',description='$description' WHERE id=$id";
mysql_db_query($dbname,$sql);

echo "<center><br><br><br><br><br>amend succeed ";
echo "<a href=./sort.php>Click here to return</a>";

endif;

} // end editsort1

function editsort2($id,$sort2,$description,$sort1id){
global $dbhost,$dbuser,$dbpasswd,$dbname,$down_sort2_table;

if ($sort2==""):

echo "<center><br><br><br><br><br>";
echo "name can not empty<br>";
echo "<a href=javascript:history.back(1)>Click here to return</a>";

elseif ($sort1id == ""):

echo "<center><br><br><br><br><br>";
echo "Name can not be empty<br>";
echo "<a href=javascript:history.back(1)>Click here to return</a>";

else:

mysql_pconnect($dbhost,$dbuser,$dbpasswd);
$sql = "UPDATE $down_sort2_table SET sort1id=$sort1id, sort2='$sort2', description='$description' WHERE id=$id";
mysql_db_query($dbname,$sql);

echo "<center><br><br><br><br><br>amend succed ";
echo "<a href=./sort.php>Click here to return</a>";

endif;

} // end editsort2

function delsort1($id){
global $dbhost,$dbuser,$dbpasswd,$dbname,$down_table,$down_sort1_table,$down_sort2_table;

mysql_pconnect($dbhost,$dbuser,$dbpasswd);

$sql = "DELETE FROM $down_sort1_table WHERE id=$id";
mysql_db_query($dbname,$sql);

$sql = "SELECT COUNT(*) AS rcnt FROM $down_sort2_table WHERE sort1id=$id ORDER BY id";
$result = mysql_db_query($dbname, $sql);
$row = mysql_fetch_array($result);

$sql = "SELECT * FROM $down_sort2_table ORDER BY id";
$result = mysql_db_query($dbname, $sql);

while ($row=mysql_fetch_array($result)) {
$sql = "DELETE FROM $down_table WHERE sort2id=$row[id]";
mysql_db_query($dbname,$sql);
}

$sql = "DELETE FROM $down_sort2_table WHERE sort1id=$id";
mysql_db_query($dbname,$sql);


echo "<center><br><br><br><br><br>have been delete ";
echo "<a href=./sort.php>Click here to return</a>";



} // end delsort1

function delsort2($id){
global $dbhost,$dbuser,$dbpasswd,$dbname,$down_table,$down_sort2_table;

mysql_pconnect($dbhost,$dbuser,$dbpasswd);

$sql = "DELETE FROM $down_sort2_table WHERE id=$id";
mysql_db_query($dbname,$sql);

$sql = "DELETE FROM $down_table WHERE sort2id=$id";
mysql_db_query($dbname,$sql);

echo "<center><br><br><br><br><br>have been delete ";
echo "<a href=./sort.php>Click here to return</a>";


} // end delsort2

function islogin($username,$password){
global $dbhost,$dbuser,$dbpasswd,$dbname,$down_user_table;

if ($username=="" || $password==""):
header ("Location:index.php");
exit;
endif;

mysql_pconnect($dbhost,$dbuser,$dbpasswd);
$sql = "SELECT * FROM $down_user_table WHERE username='$username'";
$result = mysql_db_query($dbname,$sql);
$obj = mysql_fetch_object($result);
$user_password = $obj->password;

if ($user_password != $password):
header ("Location:index.php");
exit;
endif;


} // end checklogin

function login($username,$password){
global $dbhost,$dbuser,$dbpasswd,$dbname,$down_user_table,$cookie_name;

mysql_pconnect($dbhost,$dbuser,$dbpasswd);
$sql = "SELECT * FROM $down_user_table WHERE username='$username'";
$result = mysql_db_query($dbname, $sql);
$objresult = mysql_fetch_object($result);
$user_password = $objresult->password;

if ($username=="" || $password==""):
echo "user name or password can not empty";
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=index.php'>";
exit;
endif;

if ($user_password == ""):
echo "user name is wrong";
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=index.php'>";
exit;
endif;

if ($password != $user_password):
echo "password is wrong";
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=index.php'>";
exit;
endif;

setcookie ($cookie_name."_user",$username,time()+(1*24*3600));
setcookie ($cookie_name."_pass",$password,time()+(1*24*3600));

echo "Enter succeed";
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=list.php'>";

exit;

} // end login

function logout(){
global $cookie_name;

setcookie ($cookie_name."_user","");
setcookie ($cookie_name."_pass","");

echo "<a href=index.php>write off succeed</a>";
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=index.php'>";
exit;

} // end logout

function adduser($username,$password,$groupid){
global $dbhost,$dbuser,$dbpasswd,$dbname,$down_user_table;

mysql_pconnect($dbhost,$dbuser,$dbpasswd);
$sql = "INSERT INTO $down_user_table (username,password,groupid) VALUES ('$username','$password','$groupid')";
mysql_db_query($dbname,$sql);

} // end adduser

function edituser($username,$password,$groupid){
global $dbhost,$dbuser,$dbpasswd,$dbname,$down_user_table,$edit;

mysql_pconnect($dbhost,$dbuser,$dbpasswd);
$sql = "UPDATE $down_user_table SET username='$username',password='$password',groupid='$groupid' WHERE id='$edit'";
mysql_db_query($dbname,$sql);

} // end edituser

function deluser($id){
global $dbhost,$dbuser,$dbpasswd,$dbname,$down_user_table;

mysql_pconnect($dbhost,$dbuser,$dbpasswd);
$sql = "DELETE FROM $down_user_table WHERE id=$id";
mysql_db_query($dbname,$sql);

} // end deluser

function editpass($newusername,$oldpassword,$newpassword,$repassword){
global $dbhost,$dbuser,$dbpasswd,$dbname,$down_user_table,$id;

mysql_pconnect($dbhost,$dbuser,$dbpasswd);
$sql = "SELECT * FROM $down_user_table WHERE id='$id'";
$result = mysql_db_query($dbname, $sql);
$objresult = mysql_fetch_object($result);

$id = $objresult->id;
$password = $objresult->password;
$groupid = $objresult->groupid;

if ($oldpassword != $password):
echo "<br><center>The original password is wrong<br>";
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=user.php'>";
exit;
endif;

if ($newusername =="" || $oldpassword == "" || $newpassword == "" || $repassword == ""):
echo "<br><center>user name and password can not empty<br>";
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=user.php'>";
exit;
endif;

if ($newpassword != $repassword):
echo "<br><center>Two input password is not the same<br>";
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=user.php'>";
exit;
endif;

$sql = "UPDATE $down_user_table SET username='$newusername',password='$newpassword' WHERE id='$id'";
mysql_db_query($dbname,$sql);


} // end editpass

?>