One Hat Cyber Team

View File Name : sort3.php3

<html>
<head>
</head>
<body>

<?
include("auth1.php3");
mysql_connect("",$user,$password);

$result=mysql_db_query("conference", "select * from $table where id=$id");
$row=mysql_fetch_array($result);

$lastname=$row["lastname"];
$firstname=$row["firstname"];
$middlename=$row["middlename"];
$institution=$row["institution"];
$position=$row["position"];
$city=$row["city"];
$country=$row["country"];
$talk=$row["talk"];
$abstract=$row["abstract"];
$email=$row["email"];
$fax=$row["fax"];
$phone=$row["phone"];
$address=$row["address"];

include("auth.php3");
mysql_connect("",$user,$password);

if ($todo=="ADD_THIS"){
       $sinstitution=AddSlashes($institution);
       $saddress=AddSlashes($address);
       $slastname=AddSlashes($lastname);
       $sfirstname=AddSlashes($firstname);
    mysql_db_query("conference",
       "insert into umc2001_local set
       lastname='$slastname',
       firstname='$sfirstname',
       middlename='$middlename',
       organization='$sinstitution',
       country='$country',
       city_region='$saddress',
       phone='$phone',
       email='$email',
       fax='$fax'");
	$stalk=AddSlashes($talk);
	$sabstract=AddSlashes($abstract);
    mysql_db_query("conference",
       "insert into umc2001_prefs set person=last_insert_id(),
        section='$secnumber',
	registered='1',
	talk='$stalk',
	abstract='$sabstract'");
} elseif ($todo=="ADD_FROM_W") {
       $wlastname=convert_cyr_string($lastname,"w","k");
       $wfirstname=convert_cyr_string($firstname,"w","k");
       $wmiddlename=convert_cyr_string($middlename,"w","k");
       $winstitution=convert_cyr_string($institution,"w","k");
       $wposition=convert_cyr_string($position,"w","k");
       $wcity=convert_cyr_string($city,"w","k");
       $wcountry=convert_cyr_string($country,"w","k");
       $wtalk=convert_cyr_string($talk,"w","k");
       $wabstract=convert_cyr_string($abstract,"w","k");
       $waddress=convert_cyr_string($address,"w","k");
    mysql_db_query("conference",
       "insert into umc2001_local set
       lastname='$wlastname',
       firstname='$wfirstname',
       middlename='$wmiddlename',
       organization='$winstitution',
       country='$wcountry',
       city_region='$waddress',
       phone='$phone',
       email='$email',
       fax='$fax'");
	$stalk=AddSlashes($wtalk);
	$sabstract=AddSlashes($wabstract);

    mysql_db_query("conference",
       "insert into umc2001_prefs set person=last_insert_id(),
        section='$secnumber',
	registered='1',
	talk='$stalk',
	abstract='$sabstract'");
} elseif ($todo=="ADD_FROM_I") {
       $ilastname=convert_cyr_string($lastname,"i","k");
       $ifirstname=convert_cyr_string($firstname,"i","k");
       $imiddlename=convert_cyr_string($middlename,"i","k");
       $iinstitution=convert_cyr_string($institution,"i","k");
       $iposition=convert_cyr_string($position,"i","k");
       $icity=convert_cyr_string($city,"i","k");
       $icountry=convert_cyr_string($country,"i","k");
       $italk=convert_cyr_string($talk,"i","k");
       $iabstract=convert_cyr_string($abstract,"i","k");
       $iaddress=convert_cyr_string($address,"i","k");
    mysql_db_query("conference",
       "insert into umc2001_local set
       lastname='$ilastname',
       firstname='$ifirstname',
       middlename='$imiddlename',
       organization='$iinstitution',
       country='$icountry',
       city_region='$iaddress',
       phone='$phone',
       email='$email',
       fax='$fax'");
	$stalk=AddSlashes($italk);
	$sabstract=AddSlashes($iabstract);

    mysql_db_query("conference",
       "insert into umc2001_prefs set person=last_insert_id(),
        section='$secnumber',
	registered='1',
	talk='$stalk',
	abstract='$sabstract'");
}  elseif ($todo=="ADD_FROM_A"){
       $alastname=convert_cyr_string($lastname,"a","k");
       $afirstname=convert_cyr_string($firstname,"a","k");
       $amiddlename=convert_cyr_string($middlename,"a","k");
       $ainstitution=convert_cyr_string($institution,"a","k");
       $aposition=convert_cyr_string($position,"a","k");
       $acity=convert_cyr_string($city,"a","k");
       $acountry=convert_cyr_string($country,"a","k");
       $atalk=convert_cyr_string($talk,"a","k");
       $aabstract=convert_cyr_string($abstract,"a","k");
       $aaddress=convert_cyr_string($address,"a","k");
    mysql_db_query("conference",
       "insert into umc2001_local set
       lastname='$alastname',
       firstname='$afirstname',
       middlename='$amiddlename',
       organization='$ainstitution',
       country='$acountry',
       city_region='$aaddress',
       phone='$phone',
       email='$email',
       fax='$fax'");
	$stalk=AddSlashes($atalk);
	$sabstract=AddSlashes($aabstract);

    mysql_db_query("conference",
       "insert into umc2001_prefs set person=last_insert_id(),
        section='$secnumber',
	registered='1',
	talk='$stalk',
	abstract='$sabstract'");
}

?>

<a href="sort1.php3"> GO TO LIST </a>

</body>