prepare( "SELECT record_id FROM $table_name WHERE textTitle = %s LIMIT 1",$m_inputTitle);
$m_checkResult = $wpdb->get_var($m_checkHadThere);
if (!(empty($m_checkResult)))
{
/*
$m_mysql = "UPDATE `$table_name` SET `agreementRequired` = '".$wpdb->escape($m_agreementRequired)
."' , `withoutAgreement`='".$wpdb->escape($m_withoutAgreement)
."', `showCountdown`='".$wpdb->escape($m_showCountdown)
."', `textTitle`='".$wpdb->escape($m_inputTitle)
."', `textareaMessage`='".$wpdb->escape($m_textareaMessage)
."', `inputDays`='".$wpdb->escape($m_inputDays)
."', `selectCountDown`='".$wpdb->escape($m_selectCountDown)
."', `inputReminderText`='".$wpdb->escape($m_inputReminderText)
."', `inputAdminEmail`='".$wpdb->escape($m_inputAdminEmail)
."', `inputCheckboxLabel`='".$wpdb->escape($m_inputCheckboxLabel)
."', `inputDate`='".$wpdb->escape($m_inputDate)
."', `valid`='YES' WHERE `record_id`='".$m_checkResult."'";
*/
$m_mysql = $wpdb->prepare( "UPDATE $table_name SET agreementRequired = %s , withoutAgreement= %s, showCountdown=%s, textTitle=%s, textareaMessage=%s
, inputDays=%s, selectCountDown=%s, inputReminderText=%s, inputAdminEmail=%s, inputCheckboxLabel=%s, inputDate=%s, valid='YES'
WHERE record_id=%d"
,$wpdb->escape($m_agreementRequired),$wpdb->escape($m_withoutAgreement),$wpdb->escape($m_showCountdown)
,$wpdb->escape($m_inputTitle),$wpdb->escape($m_textareaMessage),$wpdb->escape($m_inputDays),$wpdb->escape($m_selectCountDown)
,$wpdb->escape($m_inputReminderText),$wpdb->escape($m_inputAdminEmail),$wpdb->escape($m_inputCheckboxLabel),$wpdb->escape($m_inputDate),$m_checkResult
);
$wpdb->query($m_mysql);
echo "";
echo "Your mssage has updated and will shown to your users!";
echo "
";
echo "
";
}
else
{
/*
$m_mysql = "INSERT INTO `$table_name` (`agreementRequired`,`withoutAgreement`,`showCountdown`, `textTitle`, `textareaMessage`, `inputDays`, `selectCountDown`, `inputReminderText`,`inputAdminEmail`,`inputCheckboxLabel`,`inputDate`,`valid`) VALUES ('".
$wpdb->escape($m_agreementRequired).
"', '".$wpdb->escape($m_withoutAgreement).
"', '".$wpdb->escape($m_showCountdown).
"', '".$wpdb->escape($m_inputTitle).
"', '".$wpdb->escape($m_textareaMessage).
"', '".$wpdb->escape($m_inputDays)."', '".$wpdb->escape($m_selectCountDown).
"','".$wpdb->escape($m_inputReminderText)."','".$wpdb->escape($m_inputAdminEmail)."','".
$wpdb->escape($m_inputCheckboxLabel)."','".$wpdb->escape($m_inputDate)."','YES')";
*/
$m_mysql = $wpdb->prepare("INSERT INTO $table_name (agreementRequired,withoutAgreement,showCountdown, textTitle, textareaMessage, inputDays, selectCountDown, inputReminderText,inputAdminEmail,inputCheckboxLabel,inputDate,valid)
VALUES (%s, %s, %s, %s, %s, %s, %s,%s,%s,%s,%s,'YES')",
'YES',$wpdb->escape($m_withoutAgreement),$wpdb->escape($m_showCountdown),
$wpdb->escape($m_inputTitle),$wpdb->escape($m_textareaMessage),$wpdb->escape($m_inputDays),$wpdb->escape($m_selectCountDown)
,$wpdb->escape($m_inputReminderText),$wpdb->escape($m_inputAdminEmail),$wpdb->escape($m_inputCheckboxLabel),$wpdb->escape($m_inputDate)
);
$wpdb->query($m_mysql);
echo "";
echo "Your new message has been updated and will shown to your users!";
echo "
";
}
}
if ((!(empty($_POST['submitUpdateSetting']))) || (!(empty($_POST['hiddenUpdateing']))))
{
if(!(empty($_POST['hiddenRecordId'])))
{
$m_hiddenRecordId = sanitize_text_field($_POST['hiddenRecordId']);
}
if(!(empty($_POST['selectValid'])))
{
$m_valid = sanitize_text_field($_POST['selectValid']);
}
//$m_mysql = "UPDATE `$table_name` SET `selectInfoType` = '$m_selectInfoType' , `textareaMessage`='$m_textareaMessage', `inputDays`='$m_inputDays', `selectCountDown`='$m_selectCountDown', `inputReminderText`='$m_inputReminderText',`inputAdminEmail`='$m_inputAdminEmail',`inputCheckboxLabel`='$m_inputCheckboxLabel',`inputDate`='$m_inputDate',`valid`='$m_valid' WHERE `record_id`='$m_hiddenRecordId'";
$m_mysql = $wpdb->prepare("UPDATE $table_name SET selectInfoType = %s , textareaMessage=%s, inputDays=%s, selectCountDown=%s, inputReminderText=%s,inputAdminEmail=%s,inputCheckboxLabel=%s,inputDate=%s,valid=%s WHERE record_id=%d"
,$m_selectInfoType,$m_textareaMessage,$m_inputDays,$m_selectCountDown,$m_inputReminderText,$m_inputAdminEmail,$m_inputCheckboxLabel,$m_inputDate,$m_valid,$m_hiddenRecordId
);
$wpdb->query($m_mysql);
}
}
if ('Delete it' == $_POST['submitOneToDelete'])
{
check_admin_referer( 'tomas_insert_messagebox' );
$table_name = $table_prefix . "announcement";
if (!(empty($_POST['selectNewOrUpdate'])))
{
//$m_mysql = "DELETE FROM `$table_name` WHERE `record_id` = ".sanitize_text_field($_POST['selectNewOrUpdate']);
$m_mysql = $wpdb->prepare("DELETE FROM $table_name WHERE record_id = %d",sanitize_text_field($_POST['selectNewOrUpdate']));
$wpdb->query($m_mysql);
}
}
?>
prepare("SELECT * FROM $table_announce WHERE record_id = %d LIMIT 1",$now_editID);
$m_editResult = $wpdb->get_row($m_sqlNowRecord,ARRAY_A);
?>