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>"); }