redirect($redirect);
}
else
{
//checking userinfo table for similiraty before adding
$dbconnect2 = new check;
if (isset($sesid) and $dbconnect2->verify_stonesavenum($stoneid,$s_u_num))
{
$alert_msg = "
This stone style is already saved in your storage, if you wish to add more sqft in your virtual save locate the stone style below
";
}
else
{
//adding to mysave list
$dbconnectmysave = new db_exchange;
$insertsave = "INSERT INTO userinfo (user_stone_id, user_savesize, user_savename, user_savenum, user_mem_id)
VALUES (" .
$stoneid. ", ".
str_or_null(trim($savesize)). ", ".
str_or_null(trim($savename)). ", ".
str_or_null(trim($s_u_num)). ", ".
$sesid. ")";
$dbconnectmysave->submit($insertsave);
}
}
}
else
{
if(!isset($sesid))
{
$dbconnect1 = new check;
$redirect = "../login.php?stoneid=$stoneid&stonenumber=$stonenumber&savesize=$savesize";
$dbconnect1->redirect($redirect);
}
else
{
//checking userinfo table for similiraty before adding
$dbconnect2 = new check;
if (isset($sesid) and $dbconnect2->verify_stonesave($stoneid))
{
$alert_msg = "
This stone style is already saved in your storage
";
}
else
{
//adding to mysave list
$dbconnectmysave = new db_exchange;
$insertsave = "INSERT INTO userinfo (user_stone_id, user_savesize, user_mem_id)
VALUES (" .
$stoneid. ", ".
str_or_null(trim($savesize)). ", ".
$sesid. ")";
$dbconnectmysave->submit($insertsave);
}
}
}
}
if ($delete)
{
//delete code
//echo $s_u_number;
if ($s_u_number)
{
$querydel = "DELETE FROM userinfo where user_stone_id ='" .$s_number. "' and user_savenum ='" .$s_u_number. "' and user_mem_id='" .$sesid ."'";
}
else
{
$querydel = "DELETE FROM userinfo where user_stone_id ='" .$s_number. "' and user_mem_id='" .$sesid ."'";
}
$dbconnect1 = new db_exchange;
$dbconnect1->delete($querydel);
}
if(!isset($sesid))
{
$dbconnect1 = new check;
$redirect = "../login.php";
$dbconnect1->redirect($redirect);
}
else
{
$dbconnect = new db_exchange;
$query = "SELECT * FROM stone,userinfo where stone.stone_id = userinfo.user_stone_id and userinfo.user_mem_id='" .$sesid ."' ORDER BY userinfo.user_stone_id";
$dbconnect->query($query);
}
//do not change the following code--this is for my content feature
if (isset($sesid))
{
$mydbconnect = new db_exchange;
$query = "SELECT * FROM userinfo where user_mem_id = '".$sesid."'";
$mydbconnect->query($query);
$numitems = $mydbconnect->num_rows;
//print $numitems;
}
// end of my content code
?>
<? echo $seslname ?>' Saved Items :: Mureks International
