function mrr_update_quick_links_main($id,$name,$url,$private=0,$merchant=0,$store=0,$m_list="",$s_list="",$rownum=0,$colnum=0,$poser=0)
{
if($id==0)
{ //create the new link first
$sql="
insert into quick_links
(id,
linedate_added,
user_id,
access_level,
row_num,
col_num,
position_id,
active,
deleted)
values
(NULL,
NOW(),
'".sql_friendly($_SESSION['user_id'])."',
'".sql_friendly($_SESSION['access_level'])."',
1,
1,
1,
1,
0)
";
simple_query($sql);
$id=get_mysql_insert_id();
}
//update the link.
if($id > 0)
{
$sql="
update quick_links set
link_name='".sql_friendly(trim($name))."',
link_url='".sql_friendly(trim($url))."',
merchant_id='".sql_friendly($merchant)."',
store_id='".sql_friendly($store)."',
merchant_id_list='".sql_friendly($m_list)."',
store_id_list='".sql_friendly($s_list)."',
private_link='".sql_friendly($private)."',
row_num='".sql_friendly($rownum)."',
col_num='".sql_friendly($colnum)."',
position_id='".sql_friendly($poser)."'
where id='".sql_friendly($id)."'
";
simple_query($sql);
}
return $id;
}
function update_important_date()
{
$id=$_POST['id'];
$date0=$_POST['date'];
$sub=$_POST['title'];
$msg0=$_POST['msg'];
$type=$_POST['type'];
$date1=$_POST['date_remind1'];
$eml1=$_POST['email_remind1'];
$msg1=$_POST['msg_remind1'];
$date2=$_POST['date_remind2'];
$eml2=$_POST['email_remind2'];
$msg2=$_POST['msg_remind2'];
$use_merchant=0;
//find merchant template first...acts as a default.
if($_SESSION['merchant_id'] == 0 && $_SESSION['selected_merchant_id'] > 0)
{
$use_merchant=$_SESSION['selected_merchant_id'];
}
elseif($_SESSION['merchant_id'] > 0)
{
$use_merchant=$_SESSION['merchant_id'];
}
$use_store=0;
//find store template next...override merchant if set.
if($_SESSION['store_id'] == 0 && $_SESSION['selected_store_id'] > 0)
{
$use_store=$_SESSION['selected_store_id'];
}
elseif($_SESSION['store_id'] > 0)
{
$use_store=$_SESSION['store_id'];
}
if($id==0)
{
$sql="
insert into important_dates
(id,
user_id,
linedate_added,
date_description,
date_message,
msg_reminder1,
msg_reminder2,
date_type,
deleted,
merchant_id,
store_id,
archived,
sent_reminder1,
sent_reminder2)
values
(NULL,
'".sql_friendly($_SESSION['user_id'])."',
NOW(),
'',
'',
'',
'',
0,
0,
'".sql_friendly($use_merchant)."',
'".sql_friendly($use_store)."',
0,
0,
0)
";
simple_query($sql);
$id=get_mysql_insert_id();
}
$sql = "
update important_dates set
date_description='".sql_friendly($sub)."',
date_message='".sql_friendly($msg0)."',
date_type='".sql_friendly($type)."',
linedate='".date("Y-m-d", strtotime($date0))."',
".( strtotime($date1) > time() ? "sent_reminder1=0," : "")."
linedate_reminder1='".($date1!="" ? date("Y-m-d", strtotime($date1)) : "")."',
email_reminder1='".sql_friendly($eml1)."',
msg_reminder1='".sql_friendly($msg1)."',
".( strtotime($date2) > time() ? "sent_reminder2=0," : "")."
linedate_reminder2='".($date2!="" ? date("Y-m-d", strtotime($date2)) : "")."',
email_reminder2='".sql_friendly($eml2)."',
msg_reminder2='".sql_friendly($msg2)."'
where id='".sql_friendly($id)."'
";
simple_query($sql);
display_xml_response("<rslt>".$id."</rslt>");
}
