";
drawMainTitle("Send A Text Message");
?>
";
}
function getNoteText($note_num) {
$row = retrieveRowByNotenum($note_num);
$temp_subject=getEncoded($row['subject']);
$temp_note=getEncoded($row['note']);
return $temp_subject." >".$temp_note;
}
function drawHeader() {
echo "";
echo "
";
}
function drawLoginInformation() {
echo "Currently logged in as: ";
echo $_SESSION['user'];
}
function redAlert($alert_text) {
echo "
";
echo $alert_text;
echo "
";
}
//############### LABELS #########################
function ifTextAddlabel($temp_id, $temp_title, $text, $label) {
if (strlen(strstr($temp_title,$text))>0) {
addLabel($temp_id, $label);
}
}
function ifExactTextAddlabel($temp_id, $temp_title, $text, $label) {
if ($temp_title == $text) {
addLabel($temp_id, $label);
}
}
function addLabel($t_noteid,$t_labelid) {
//echo "adding label ".$t_labelid." to event ".$t_eventid."
";
//check for duplicates INSERT IGNORE on primary key (which is two rows)
//add to database
$query = "INSERT IGNORE INTO labels (note_id, label_id) VALUES ('$t_noteid','$t_labelid')";
//echo $query;
mysql_query($query);
}
//############### END LABELS #########################
function submitContact() {
$c_user = verifyInput($_POST['new_username']);
$c_pass = md5(verifyInput($_POST['new_password']));
$c_fname = verifyInput($_POST['firstname']);
$c_lname = verifyInput($_POST['lastname']);
$c_number = verifyInput($_POST['contactnumber']);
$c_email = verifyInput($_POST['email']);
subscribeToTextmarks($c_number);
$query = "INSERT INTO users VALUES ('',now(),'$c_user','$c_pass','$c_fname','$c_lname','$c_number','$c_email','0','0')";
mysql_query($query);
}
function subscribeToTextmarks($phone_number)
{
try
{
// Try to subscribe a user to a TextMark:
$sMyApiKey = 'discussthing_com_8e49cd0b';
$sMyTextMarksUser = '6178880545'; // (or my TextMarks phone#)
$sMyTextMarksPass = 'wizzbone';
$sKeyword = 'TOOMEY';
$sPhone = $phone_number;
$tmapi = new TextMarksAPIClient_Messaging($sMyApiKey, $sMyTextMarksUser, $sMyTextMarksPass);
$tmapi->subscribe($sKeyword, $sPhone);
redAlert("Number successfully entered, subscription pending. You will receive a text message from 41411 soon, please reply with a \"Y\"");
}
catch (Exception $e)
{
redAlert("Subscription Error: " . $e);
}
}
function sendToTextmark($sms_message,$phone_number)
{
try
{
// Try to send a message to a user:
$sMyApiKey = 'discussthing_com_8e49cd0b';
$sMyTextMarksUser = '6178880545'; // (or my TextMarks phone#)
$sMyTextMarksPass = 'wizzbone';
$sKeyword = 'TOOMEY';
$sMessage = $sms_message;
$sPhone = $phone_number;
$tmapi = new TextMarksAPIClient_Messaging($sMyApiKey, $sMyTextMarksUser, $sMyTextMarksPass);
$tmapi->sendText($sKeyword, $sPhone, $sMessage);
redAlert("Successfully sent Text Message.");
}
catch (Exception $e)
{
redAlert("Sending Error: " . $e);
}
}
function drawFooter() {
## end mainbody_wrapper
echo "
";
echo "";
}
function drawRadioButtons($t_type) {
addRadioToForm("notetype","0", $t_type, "Standard");
addRadioToForm("notetype","2", $t_type, "Private");
addRadioToForm("notetype","1", $t_type, "Add to email");
}
function addRadioToForm($nam,$val,$t_type, $text) {
echo "
";
}
function retrieveRowByNotenum($notenum) {
$query = "SELECT * FROM notes WHERE note_num = $notenum LIMIT 1";
echo $query;
$result=mysql_query($query);
$row = mysql_fetch_array($result);
return $row;
}
function drawSettings() {
echo "
";
drawMainTitle("Settings");
drawUserSettings();
echo "
";
}
function drawUserSettings() {
echo "
";
echo "";
drawCurrentUsers();
drawAddUserForm();
echo "
";
}
/*
########## Labels
Also, use label system for 'requires followup' (#!) and 'add to email'
*/
function strpos_all($hs_haystack, $hs_needle, $hn_offset = 0, $hn_limit = 0) {
$ha_positions = array();
$hn_count = 0;
while (false !== ($pos = strpos($hs_haystack, $hs_needle, $hn_offset)) && ($hn_limit == 0 || $hn_count < $hn_limit)) {
$ha_positions[] = $pos;
$hn_offset = $pos + strlen($hs_needle);
++$hn_count;
}
return $ha_positions;
}
function scanForLabels($t_notenum, $str) {
$new_str = $str;
$query = "SELECT * FROM label_names";
$result=mysql_query($query);
$labelARRAY[0] = 0;
$rowcounter = 0;
while($row = mysql_fetch_array($result)) {
$labelARRAY[$rowcounter] = $row;
$rowcounter++;
}
// if $str contains # symbol, get location(s?)
$labelPositionARRAY = strpos_all($str, '#');
//print_r($labelPositionARRAY);
for ($i=count($labelPositionARRAY)-1; $i > -1; $i=$i-1) {
$currpos = $labelPositionARRAY[$i];
// if next character is !, add followup label
if (substr($str, $currpos+1, 1) == "!") {
addLabel($t_notenum, 3-1);
echo $labelARRAY[3-1]['name']."
";
$new_str = substr_replace($new_str, '', $currpos, 2);
} else {
// else get next three characters
$abbr = substr($str, $currpos+1, 3);
// check string against labels in database
$labelnum = getLabelNumFromAbbr($labelARRAY, $abbr);
if ($labelnum > 0) {
addLabel($t_notenum, $labelnum-1);
echo $labelARRAY[$labelnum-1]['name']."
";
$new_str = substr_replace($new_str, '', $currpos, 4);
} else {
echo "No label";
}
}
}
// Add label to notenum
// return string removing those 4 characters
return $new_str;
}
function getLabelNumFromAbbr($t_labelARRAY, $t_abbr) {
for ($k=0; $k < count($t_labelARRAY); $k++) {
if ($t_labelARRAY[$k]['abbr'] == $t_abbr) {
return $t_labelARRAY[$k]['id'];
}
}
return 0;
}
function scanForPhoneNumbers($notenum, $str) {
// if string contains ###?###?####
// can php search like that? I suspect so
// add label #pho to notenum
if (preg_match('/[0-9]{3}.[0-9]{3}.[0-9]{4}/', $str)) {
//redAlert("Has number!");
//addLabel("#pho", $notenum)
}
}
function scanForLinks($t_str) {
$str = $t_str;
$matchesarray[0] = 1;
if (preg_match('/(http)(.*)/', $str, $matchesarray)) {
//redAlert("Link found! ".$matchesarray[0]);
$str = str_replace($matchesarray[0], "
".$matchesarray[0]." ",$str);
}
return $str;
}
function drawCurrentUsers() {
echo "Current Users
";
$query = "SELECT * FROM users";
$result=mysql_query($query);
echo "
Name Phone # Email ";
echo "".$temp_first." ".$temp_last." ";
echo "".$temp_phone." ";
echo "".$temp_email." ";
echo " ";
}
echo "
";
}
function drawAddUserForm() {
?>
";
drawMainTitle("Edit Note");
?>
";
}
function updateChecks() {
#for loop on BOXARRAY2
#have old and new array, need to fill out new array to each blank spot is a zero
$checkboxesARRAY = $_POST['BOXARRAY'];
$OLDcheckboxesARRAY = $_POST['BOXARRAY2'];
foreach ($OLDcheckboxesARRAY as $k => $v) {
if($checkboxesARRAY[$k]) {
$checkboxesARRAY[$k] = 1;
} else {
$checkboxesARRAY[$k] = 0;
}
}
while (list($key, $val) = each($checkboxesARRAY)) {
#echo "$key => $val\n";
#echo "UPDATE notes SET type = '".$val."' WHERE note_num = '".$key."'";
$query = "UPDATE notes SET type = '".$val."' WHERE note_num = '".$key."'";
mysql_query($query);
}
}
function deleteNote($notenum) {
$query = "UPDATE notes SET active = '0' WHERE note_num = $notenum";
mysql_query($query);
}
function addNote($t_subject, $t_note, $t_type, $t_todo) {
# Database format: index, current date and time, subject, note, radio value
$secretPass = 'kljhflk73#OO#*U$O(*Y';
$enc_subject = makeSQLsafe(Encode($t_subject,$secretPass));
$enc_note = makeSQLsafe(Encode($t_note,$secretPass));
$query = "INSERT INTO notes VALUES ('','1',now(),now(),'$enc_subject','$enc_note',$t_type,$t_todo)";
mysql_query($query);
}
function verifyInput($text) {
$input = $text;
$input = htmlspecialchars($input);
if (get_magic_quotes_gpc())
{
// if magic quotes is enabled, get rid of those
// pesky slashes
$input = stripslashes($input);
}
$input = mysql_real_escape_string($input);
return $input;
}
function stripHTML($text) {
return htmlspecialchars($text);
}
function makeSQLsafe($text) {
$input = mysql_real_escape_string($text);
return $input;
}
function Encode($data,$pwd)
{
$pwd_length = strlen($pwd);
for ($i = 0; $i < 255; $i++) {
$key[$i] = ord(substr($pwd, ($i % $pwd_length)+1, 1));
$counter[$i] = $i;
}
for ($i = 0; $i < 255; $i++) {
$x = ($x + $counter[$i] + $key[$i]) % 256;
$temp_swap = $counter[$i];
$counter[$i] = $counter[$x];
$counter[$x] = $temp_swap;
}
for ($i = 0; $i < strlen($data); $i++) {
$a = ($a + 1) % 256;
$j = ($j + $counter[$a]) % 256;
$temp = $counter[$a];
$counter[$a] = $counter[$j];
$counter[$j] = $temp;
$k = $counter[(($counter[$a] + $counter[$j]) % 256)];
$Zcipher = ord(substr($data, $i, 1)) ^ $k;
$Zcrypt .= chr($Zcipher);
}
return $Zcrypt;
}
function hex2bin($hexdata) {
for ($i=0;$i
";
echo " ";
echo "
Last ".$numdaysback." Days
";
for ($k = 1; $k < $numdaysback; $k += 1) {
$query = "SELECT * FROM notes WHERE DATE(date) = DATE_SUB(CURDATE(), INTERVAL ".$k." DAY) ORDER BY note_num ASC";
$result=retrieveFromDatabase($query);
$num_rows = mysql_num_rows($result);
if ($num_rows > 0) {
$olddate = mktime(0,0,0,date("m"),date("d")-$k,date("Y"));
echo "
";
echo "";
while($row = mysql_fetch_array($result)) {
$temp_subject=getEncoded($row['subject']);
$temp_note=getEncoded($row['note']);
$temp_active=$row['active'];
$temp_type=$row['type'];
$temp_notenum=$row['note_num'];
$temp_todo=$row['todo'];
if ($temp_subject.$temp_note == "" || $temp_active == 0 ) {
} else {
$buttonColorARRAY = array("green", "purple", "yellow", "red");
$buttonTitleARRAY = array("Edit", "Copy to Today", "View Details", "Delete");
$buttonFunctionARRAY = array("edit", "copytotoday", "viewdetails", "delete");
drawNote($temp_notenum,$temp_subject,$temp_note,$temp_type,$temp_todo,$buttonColorARRAY, $buttonTitleARRAY, $buttonFunctionARRAY);
}
}
echo "
";
}
}
echo "
![\"Alternative](\"img/".$color.".gif\")
";
echo "".$action."";
echo "";
echo "