Contact:
|
|
Event Type:
|
|
About:
|
|
$dbcnx = @mysql_connect('mysql.plainhost.com','ecosmar_ecosmart','ecoman1');
mysql_select_db('ecosmar_friendly', $dbcnx);
$oky = @mysql_query("SELECT time,min,dtnum FROM dates WHERE time='$tid' AND dtnum='$dtnum'");
if (!$oky){
echo("Error Checking for Duplicate!".
"Error:" . mysql_error() . " |
");
}else{
$numrows = mysql_num_rows($oky);
if($numrows < 1){
mysql_select_db('ecosmar_contacts', $dbcnx);
$ok = @mysql_query("DELETE FROM con_reactivity WHERE CID='$CONID' AND dtnum='$olddtnum' LIMIT 1");
if (!$ok){
echo("Error Moving Reactivity!".
"Error:" . mysql_error() . " |
");
}
$okb = @mysql_query("INSERT INTO con_reactivity SET CID='$CONID',react_year='$year',react_month='$mo',react_day='$day',dtnum='$dtnum'");
if (!$okb){
echo("Error Adding New Date to Contact Report!".
"Error:" . mysql_error() . " |
");
}
mysql_select_db('ecosmar_friendly', $dbcnx);
$ok2 = @mysql_query("DELETE FROM calendar WHERE usrn='$usrn' and dtnum='$olddtnum' LIMIT 1");
if (!$ok2){
echo("Could not change Calendar Info".
"Error:" . mysql_error() . " |
");
}
$ok3 = @mysql_query("INSERT INTO calendar SET yearnum='$year',monthnum='$mo',daynum='$day',dtnum='$dtnum',dtup='$dtnum',usrn='$usrn'");
if (!$ok3){
echo("Error Changing Calendar Info!".
"Error:" . mysql_error() . " |
");
}
$GID = mysql_result($ok3);
$ok4 = @mysql_query("UPDATE dates SET CALID='$GID',PID='$PID',CONID='$CONID',title='$title',note='$upnote',time='$tid',min='$min',dtnum='$dtnum',usrn='$usrn' WHERE ID='$ID'");
if (!$ok4){
echo("Error Setting Event!".
"Error:" . mysql_error() . " |
");
}else{
echo("Success! |
");
}
}else{
echo("Duplicate Event! |
");
}
}
?>
Return
|