SQL = " . $query); $status="Folder created"; } // delete folder? if (isset($HTTP_POST_VARS["folderDelete"])) { $user=$_COOKIE["UKSMMSUser"]; // get username from the cookie $title=$_POST["efolder"]; $query="delete from folders where foldername='$title' and username='$user'"; $sth=mysql_query($query) or die("Delete failed: " . mysql_error() . "
SQL = " . $query); $query="update images set folder='' where folder='$title' and username='$user'"; $sth=mysql_query($query) or die("Update failed: " . mysql_error() . "
SQL = " . $query); $status="Folder deleted"; } // move resource into new folder? if (isset($HTTP_POST_VARS["imageMove"])) { $user=$_COOKIE["UKSMMSUser"]; // get username from the cookie $title=$_POST["cfolder"]; // get selected folder $rid=$_POST["rid"]; $query="update images set folder='$title' where id=$rid and username='$user'"; $sth=mysql_query($query) or die("Update failed: " . mysql_error() . "
SQL = " . $query); $status="File moved"; } // upload Images? if (isset($HTTP_POST_VARS["imageUpload"])) { //open1 $user=$_COOKIE["UKSMMSUser"]; // get username from the cookie if (($_FILES['imagefile']['type'] == "image/gif") or ($_FILES['imagefile']['type'] == "image/jpg") or ($_FILES['imagefile']['type'] == "image/jpeg")) { //open2 copy ($_FILES['imagefile']['tmp_name'], "resources/$user/".$_FILES['imagefile']['name']) or die ("Could not copy"); $status = '

'; $status .= "Name: ".$_FILES['imagefile']['name']."
"; $status .= "Size: ".$_FILES['imagefile']['size']."
"; $status .= "Type: ".$_FILES['imagefile']['type']."
"; $status .= 'Upload completed....

'; $cdate=date("Y-m-d H:m:s"); // format the current date/time $title=$_POST["title"]; $url="/members/resources/$user/".$_FILES['imagefile']['name']; $folder=$_POST["tfolder"]; $query="insert into images (title,url,username,folder,date_added) values ('$title','$url','$user','$folder','$cdate')"; $sth=mysql_query($query) or die("Insert failed: " . mysql_error() . "
SQL = " . $query); } else { $status = ""; $status .= "Could not upload, wrong filetype (".$_FILES['imagefile']['type'].")"; } //close2 } //close1 // Registration form submitted? if (isset($HTTP_POST_VARS["formtype"])) { if ($HTTP_POST_VARS["formtype"]==="register") { // get data from reg form $user=$HTTP_POST_VARS["name"]; $forename=$HTTP_POST_VARS["fname"]; $surname=$HTTP_POST_VARS["lname"]; $email=$HTTP_POST_VARS["email"]; $pword1=$HTTP_POST_VARS["password1"]; $pword2=$HTTP_POST_VARS["password2"]; $cdate=date("Y-m-d H:m:s"); // format the current date/time if ($pword1===$pword2) { // see if record already exists for this user $query="select * from members where username='$user'"; $sth=mysql_query($query) or die("Query failed: " . mysql_error() . "
SQL = " . $query); $num_rows = mysql_num_rows($sth); // if there is a user record, display error if ($num_rows>0) { $status="The username already exists. Please choose another."; $user=""; } else { $query="insert into members (username,firstname,lastname,email,password,date_registered,last_loggedin) values ('$user','$forename','$surname','$email','$pword1','$cdate','$cdate')"; $sth=mysql_query($query) or die("Insert failed: " . mysql_error() . "
SQL = " . $query); // now read the new record off the database $query="select * from members where username='$user'"; $sth=mysql_query($query) or die("Query failed: " . mysql_error() . "
SQL = " . $query); $row=mysql_fetch_array($sth, MYSQL_ASSOC); setcookie ("UKSMMSUser", $user , 0 , "/"); $status="Your details have been stored in our database"; $res = mkdir ("resources/$user"); // create our resource folder } } else { $status="The passwords did not match!"; $user=""; } } } // Login form submitted? if (isset($HTTP_POST_VARS["formtype"])) { if ($HTTP_POST_VARS["formtype"]==="login") { // get data from login form $user=$HTTP_POST_VARS["name"]; $pword=$HTTP_POST_VARS["password"]; // see if record exists for this user $query="select * from members where username='$user'"; $sth=mysql_query($query) or die("Query failed: " . mysql_error() . "
SQL = " . $query); $num_rows = mysql_num_rows($sth); $status=""; // if there is a user record, get the details if ($num_rows>0) { $row=mysql_fetch_array($sth, MYSQL_ASSOC); if ($pword==$row["password"]) { $forename=$row["firstname"]; $surname=$row["lastname"]; $cdate=date("Y-m-d H:m:s"); // format the current date/time setcookie ("UKSMMSUser", $user , 0 , "/"); } else { $forename=""; $surname=""; $status="Invalid password"; $user=""; } } else { $forename=""; $surname=""; $status="Username not found"; $user=""; } } } // eof main if // output our xml header echo ''."\n"; ?> UK Surveillance - Multimedia Messaging Services - Members Area

Powered by:

Powered by Now SMS

SQL = " . $query); $row=mysql_fetch_array($sth, MYSQL_ASSOC); } else { if (!isset($row["username"]) and ($status=="")) { $status="You are not logged in!"; } // error } if ($user!="") { print "

Members Area of " . $row["firstname"] . " " . $row["lastname"] . "

\n"; print "

$status

\n"; } else { // there was a problem print "

Error: $status

\n"; print "

\n"; } ?>

In this area of the site you can upload images, SMS and MMS messages to the site and organise them into folders for easy management. Any messages sent to you automatically via our MMS server will also appear here.

Please select the folder whose contents you wish to display:

Existing folders:

\n\n"; print "\n"; // see if any images exist for this user $query="select * from images where username='" . $user . "' and folder='$title'"; $sth=mysql_query($query) or die("Query failed: " . mysql_error() . "
SQL = " . $query); $num_rows = mysql_num_rows($sth); # if there is a centre record, display the details if ($num_rows>0) { while ($row=mysql_fetch_array($sth, MYSQL_ASSOC)) { print ""; } } else { print ""; } print "

Below is a list of your existing images/messages
Folder Name	Title/Thumbnail	Date/time added	Move
" . $row["folder"] . "	" . $row["title"] . " -	" . $row["date_added"] . "
No images or messages found

\n

To move an item into another folder, select the target folder from the drop-down menu above, click the radio button next to the item to be moved and then press the 'Add to folder' button below.

\n"; print "\n

\n"; } ?>

Manage folders:

Upload images:

Copyright © 2003, UK Surveillance Ltd.