PHP variable designation

A1SURF.us · January 4, 2011

How do I designate or change 'id' in this class to 'user_id'?

<?php
include ("dbconnect.php");
include ("settings.php");

//make connection
$server = mysql_connect($host, $user, $password);
$connection = mysql_select_db($database, $server);

// CUSTOM SQL FUNCTIONS
function sql_quote($value) {

$value = str_replace('<?','',$value);
$value = str_replace('script','',$value);

if (get_magic_quotes_gpc()) {
	$value = stripslashes($value);
}
if (!is_numeric($value)) {
	$value = "'" . mysql_real_escape_string($value) . "'";
} else {
	if ((string)$value[0] == '0') {
		$value = "'" . mysql_real_escape_string($value) . "'";
}}
return $value;
}
function sql_lastinsertid() {
	$result = mysql_query("SELECT LAST_INSERT_ID()");
	$row = mysql_fetch_row($result);
	return $row[0];
}
function sql_getfield($table, $field, $where_cond = "") {
	$q = "SELECT ".$field." FROM ".$table." ".$where_cond;
	$r = mysql_query($q);
	$row = mysql_fetch_row($r);
	return $row[0];
}

?><?php

// <!-- ========================= -->
// <!-- = UNSUBSCRIBE ACTION ==== -->
// <!-- ========================= -->

if (isset($_GET['unsubscribe']) && sql_getfield($table_emails,'id','WHERE email = '.sql_quote($_GET['unsubscribe']))) {
	$q = "DELETE from $table_emails WHERE email = ".sql_quote($_GET['unsubscribe']);
	mysql_query($q);
	echo 'You have unsubscribed!';
	exit();
}

?><?php

// <!-- ======================= -->
// <!-- = PASSWORD PROTECTION = -->
// <!-- ======================= -->

if ($password_protection == true) {

session_name($session_name);
session_start();

// if (isset($_SESSION['last_ts'])) {$_SESSION['last_ts'];}

if (!isset($_SESSION['last_ts']) && !isset($_POST['login'])) {

	// LOGIN FORM 

	echo '
	<body style="background:url(images/background.png) repeat-x;">
	<div style="position:fixed;top:35%;left:35%;width:50%">
	<form action="index.php" method="post" accept-charset="utf-8">
		<img src="images/logo.png" alt="logo" id="logo" name="logo" align="left" style="margin-right:20px;" />
		<br /><h1 style="font-family: arial, verdana;font-size:20px;color:#222;margin:0;color:#777;display:inline;">Newsletter module </h1> <small> pre 0.9</small><br />
		<br /><input type="password" name="login" id="login" style="padding:5px;display:inline;" />
		<input type="submit" style="background-color:#E61056;color:#fff;border:0;padding:5px;-moz-border-radius:3px;" value="Login">
	</form>
	</div>
	</body>
	';
	exit(); 

}

if ($_POST['login'] && sha1($_POST['login'])==$password_hash) {

	$_SESSION['auth'] = substr(md5(microtime(true).mt_rand()), 0, 16);
	$_SESSION['last_ts'] = time();
	// to destroy the post variable
	header('Location: index.php');

}

if ($_POST['login'] && sha1($_POST['login'])!=$password_hash) {
	header('Location: index.php?info=invalidlogin');    
}

else if ((time() - $_SESSION['last_ts'] > $session_timeout) || isset($_GET['logout'])) {
	session_destroy();
	header('Location: index.php');
}

else if ((time() - $_SESSION['last_ts'] < $session_timeout)) {
	$_SESSION['last_ts'] = time();
}


}
?><?php

// <!-- ========================= -->
// <!-- = FILE: AJAX PROCESSING = -->
// <!-- ========================= -->

// Setup
$error='';

// DELETE E-MAILS

if ($_POST['action']=='delmail') {

	  $count = 0;
	  $category = $_POST["cat"];
	  $emails = $_POST["emails"];
	  if (!empty($emails)) {

		  $email = explode("|",$emails);
		  foreach ($email as $value) {

			  if (!empty($value) && sql_getfield($table_emails,'id','WHERE id = '.sql_quote($value))) {
				  $q = "DELETE from $table_emails WHERE id = ".sql_quote($value)." LIMIT 1";
				  mysql_query($q);
				  $count+=1;
			  }
		  }
	  }
	  else {
		$error = 'No emails are selected !';
	  }

	  echo "{";
	  echo "error: '" . $error . "',\n";
	  echo "count: '" . $count . "'\n";
	  echo "}";
	  
	  exit();

}

// ***

// DELETE CATEGORY

if ($_POST['action']=='delcat') {

	  $kategorie = $_POST["categories"];
	  if (!empty($kategorie)) {

		  $category = explode("|",$kategorie);
		  foreach ($category as $value) {
			  if (!empty($value) && sql_getfield($table_categories,'name','WHERE id = '.sql_quote($value))) {

					if (!in_array($value,$protected)) {				

						  $q = "DELETE from $table_categories WHERE id = ".sql_quote($value)." LIMIT 1";
						  mysql_query($q);
						  $q = "DELETE from $table_emails WHERE category = ".sql_quote($value);
						  mysql_query($q);
					}
					else {

						$error = 'This category is protected';

					}	
			  }
		  }
	  }
	  else {
		$error = 'Nie sú označené žiadne kategórie !';
	  }

	  echo "{";
	echo "error: '" . $error . "'\n";
	echo "}";

	exit();

}

// ***


// RENAME CATEGORY

if ($_POST['action']=='rncat') {

	  $category = $_POST["category"];
	  $newname = $_POST["newname"];

	  if (!empty($category) && !empty($newname) && sql_getfield($table_categories,'name','WHERE id = '.sql_quote($category)) ) {
		  $q = "UPDATE $table_categories SET name = ".sql_quote($newname)." WHERE id = ".sql_quote($category)." LIMIT 1";
		  mysql_query($q);
	  }
	  else {

		  $error = 'Chyba pri premenovaní !';

	  }

	  echo "{";
	  echo "error: '" . $error . "'\n";
	  echo "}";
	  
	  exit();

}

// ***



// NEW EMAIL

if ($_POST['action']=='newemail') {

		$category = $_POST["cat"];
		$emails = $_POST["emails"];
		$append ='';

		if (!empty($emails)) {

		  $emails = str_replace('"',"",$emails);
		  $emails = str_replace(','," ",$emails);
		  $emails = str_replace(';'," ",$emails);
		  $emails = str_replace('<'," ",$emails);
		  $emails = str_replace('>'," ",$emails);
		  $emails = str_replace("\n"," ",$emails);
		  $emails = str_replace("\t"," ",$emails);
		  $emails = str_replace("\r"," ",$emails);
		  $emails = str_replace("\0"," ",$emails);
		  
		  $email = explode(" ",$emails);

		  foreach ($email as $value) {

			if (stristr($value,'@') && !sql_getfield($table_emails,'email','WHERE email = '.sql_quote($value).' AND category = '.sql_quote($category))) {

			  $q = "INSERT into $table_emails (category,email) VALUES (".sql_quote($category).",".sql_quote($value).")";
			  if (!mysql_query($q)) {
				$error = 'ERR';
			  }
			  else  {
				$id = sql_lastinsertid();
				$append.= '<div><input value="'.$id.'" id="'.$id.'" name="'.$id.'" type="checkbox" /> '.$value.'</div>';

			}
		  }
		}
		}
		else {
		  $error = 'Zadajte emailové adresy';
		}

	  echo "{";
	  echo              "error: '" . $error . "',\n";
	  echo              "toappend: '" . $append . "'\n";
	  echo "}";
	  
	  exit();

}
// ***



// NEW CATEGORY

if ($_POST['action']=='newcategory') {

	  $newcat = $_POST["catname"];
	  if (!empty($newcat)) {

		$q = "INSERT into $table_categories (name) VALUES (".sql_quote($newcat).")";
		$result = mysql_query($q);
		if (!$result) {
		  $error = 'ERR';
		}
		else {
		  $name = $newcat;
		  $id = sql_lastinsertid();
		}
	  } else {
		$error = "Please, enter the name !";
	  }

	  echo "{";
	  echo              "error: '" . $error . "',\n";
	  echo              "name: '" . $name . "',\n";
	  echo              "id: '" . $id . "'\n";
	  echo "}";
	  
	  exit();

}
// ***


// SENDMAIL

if ($_POST['action']=='sendmail') {

	if ($use_template == false ) { $template_top = ''; $template_bottom = '';}

	  $emails = $_POST['adresses'];
	  $body = $_POST['ebody'];
	  $subject = $_POST['subject'];
	  $message = str_replace("\n","<br />",$body);

	/* ERRORS */
	if ($message == '') {$error = 'Please, fill the message field !';}
	if ($subject == '') {$error = 'Please, fill the subject field !';}
	if (empty($emails)) {$error = 'No recipient defined ! ';}

	if (!empty($emails) && empty($error)) {

		/* ZAPIS DO ODOSLANÝCH NEWSLETTROV */

			$q = "INSERT INTO $table_sent (time, subject, body, attachment) VALUES (
			".sql_quote(time()).",
			".sql_quote($subject).",
			".sql_quote($message).",
			".sql_quote($_POST["attachment"]).")";
			mysql_query($q);

		$from = "$your_name <$your_email>";

		if (!empty($_POST["attachment"])) {

			  $suffix  =strtolower(substr($dir.$_POST["attachment"], -3));
				  switch($suffix) {
					case 'gif': $typ = "image/gif"; break;
					case 'jpg': $typ = "image/jpg"; break;
					case 'peg': $typ = "image/jpeg";break;
					case 'png': $typ = "image/png"; break;
					case 'pdf': $typ = "application/pdf"; break;
					case 'zip': $typ = "application/zip"; break;
				  }
			  
			  $subject = $_POST['subject'];

			  $fileatt = $dir.$_POST["attachment"];
			  $fileatttype = $typ;
			  $fileattname = $_POST["attachment"];

			  $headers = "From: $from";

			  $file = fopen( $fileatt, 'rb' );
			  $data = fread( $file, filesize( $fileatt ) );
			  fclose( $file );

			  $semi_rand = md5( time() );
			  $mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";

			  $headers .= "\nMIME-Version: 1.0\n" .
						  "Content-Type: multipart/mixed;\n" .
						  " boundary=\"{$mime_boundary}\"";

			  $message = "This is a multi-part message in MIME format.\n\n" .
					  "--{$mime_boundary}\n" .
					  "Content-Type: text/html; charset=\"utf-8\"\n" .
					  "Content-Transfer-Encoding: 7bit\n\n" .
					  $template_top.$message.$template_bottom . "\n\n";

			  $data = chunk_split( base64_encode( $data ) );

			  $message .= "--{$mime_boundary}\n" .
					   "Content-Type: {$fileatttype};\n" .
					   " name=\"{$fileattname}\"\n" .
					   "Content-Disposition: attachment;\n" .
					   " filename=\"{$fileattname}\"\n" .
					   "Content-Transfer-Encoding: base64\n\n" .
					   $data . "\n\n" .
					   "--{$mime_boundary}--\n";

	  }
	  else
	  {

			  $subject = $subject." \n";

			  /* HEADERS */

				$headers = "MIME-Version: 1.0\n";
				$headers .= "Content-Type: text/html; charset=\"utf-8\"\n";
				$headers .= "Content-Transfer-Encoding: 7bit \n";
				$headers .= "From: ".$from." \n";
				$headers .= "Return-Path: ".$from." \n";
				$headers .= "X-Mailer: PHP/" . phpversion();

				$message = $template_top.$message.$template_bottom;

	  }

		if ($_POST['sendto']=='emails') {
	    	
			$email = explode(',',$emails);
			$email = array_unique($email);
    	}
    	else if ($_POST['sendto']=='categories') {

    		$query = "SELECT * from $table_emails WHERE category IN (".$emails.")";
    		$select = mysql_query($query);
    		while ($mail_row = mysql_fetch_assoc($select)) {
    			$email[] = $mail_row['id'];
    		}
    	}

		/* ADMIN CHECK */
		if ($mailcheck == true && !in_array($your_email,$email )) {
			$email[] = $your_email;
		}

		foreach ($email as $value) {
		  
			$emailaddress = sql_getfield($table_emails,'email','WHERE id = '.sql_quote($value));
			$unsubscribe_link = "<br /><br /><span style=\"font-size:14px;color:#000;\">If you prefer not to receive future promotional e-mails of this type, please click 
			<a href=\"".$script_url."?unsubscribe=".$emailaddress."\" style=\"color:#ED008C;\">here</a> to unsubscribe.";
			mail($emailaddress, "=?UTF-8?B?".base64_encode($subject)."?=", $message.$unsubscribe_link, $headers);
			$count+=1;

		}

	  }

		  echo "{";
		  echo "error: '" . $error . "',\n";
		  echo "count: '" . $count . "'\n";
		  echo "}";

	exit();
		  
}

// ***

?><?php
// <!-- ======================= -->
// <!-- = FILE: MAIN PHP FILE = -->
// <!-- ======================= -->
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
	<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
	<meta http-equiv="expires" content="mon, 22 jul 2002 11:12:01 gmt" />
	<title>
		Newsletter module
	</title>

	<!-- ================== -->
	<!-- = FILE: CSS FILE = -->
	<!-- ================== -->

<style type="text/css" media="screen">
/*<![CDATA[*/

		/* HERE GOES YOUR CUSTOM CSS */

		<?php echo $css; ?>

		/* THIS PART OF CSS SHOULD STAY UNTOUCHED TO PRESERVE ORIGINAL LAYOUT 
		   BUT - FEEL FREE TO CHANGE IT IF YOU KNOW WHAT YOU'RE DOING          */

		body {
			cursor:default;
		}

		h1, h2, h3, h4 {
			margin:0;
			padding:0;
		}
		#logo {vertical-align:middle;cursor:pointer;}
		a {
			cursor:pointer;
		}
		a:hover{
			text-decoration:underline;
		}
		input[type=password],input[type=text],textarea {
			padding:3px;
		}
		#categories{
			padding:10px;
		}
		.tiny {
			font-size:xx-small;color:#222;
			text-decoration:none;
			border:none;
		}
		.sign {
			font-size:xx-large;
			vertical-align:absmiddle;
			text-align:center;
			font-size:xx-large;
			display:inline;
			width:20px;
		}
		#processing {
			display:none;
			position:fixed;
			top:45%;
			left:45%;
			padding:10px 20px 10px 20px;
			margin:0 auto;
			text-align:center;
		}
		#filename {
			background:transparent;border:0;
		}
		#about {
			display:none;
			border:1px dotted #CCC;
			-moz-border-radius:10px;
			background-color:#3D3435;
			color:#fff;
			z-index:2;
			position:fixed;
			top:20%;
			left:32%;
			width:30%;
			padding:2%;
		}

/*]]>*/
</style>
</head>
<body>
	<!-- = PHP ARRAYS = -->
	<?php

			// LOAD DATA INTO ARRAYS
			$result = mysql_query("SELECT * from $table_categories");
			while ($row = mysql_fetch_assoc($result)) {

				$emails_result = mysql_query("SELECT * from $table_emails WHERE category = ".$row['id']);
				while ($subrow = mysql_fetch_assoc($emails_result)) {

					$row['emails'][] = $subrow;

				}
				mysql_free_result($emails_result);
				$categories[] = $row;
			}
			mysql_free_result($result);

			$result = mysql_query("SELECT * from $table_sent");
			while ($row = mysql_fetch_assoc($result)) {

				$sent[] = $row;
			}
			mysql_free_result($result);
		?><!-- LOADING INDICATOR -->
	<div id="processing">
		<img src="images/ajax-loader.gif" alt="loading" style="vertical-align:middle;margin-right:10px;" /> PROCESSING
	</div>
	<div style="clear:both;margin:0 auto;width:1000px;margin-top:60px;">
		<!-- HEADER / SUBHEADER -->
		<img src="images/logo.png" alt="logo" id="logo" onclick="$('.maincontainers').hide(300);$('#newsletter').show(300)" />
<a class="button" id="sent_mails_link" onclick="$('.maincontainers').hide(200);$('#sent_mails').show(200);" name="sent_mails_link">SENT E-MAILS</a>
		 | <a class="button" id="about_toggle" onclick="$('#about').fadeIn(300);">ABOUT</a>
		<?php if ($password_protection==true): ?>
		 | <a class="button" id="logout" onclick="top.location.href='?logout=true'">LOGOUT</a><br />
		<?php endif ?>
		</div>
		<br />
		<div id="newsletter" class="maincontainers" style="clear:both;">
			<!-- CATEFORIES CONTAINER -->
			<div id="categories_container" style="width:200px;float:left;margin-right:20px;">
				<h2>
					CATEGORIES
				</h2><br />
				<br />
				<div id="categories">
					<?php 
										if (isset($categories) && is_array($categories)) {
										foreach ($categories as $key => $value) {

											echo '
											<div id="cat_'.$value['id'].'">
												<input type="checkbox" value="'.$value['id'].'" />
												<h3 style="cursor:pointer;" onclick="adr_show(\'category_'.$value['id'].'\');">
													'.$value['name'].'
												</h3>
											</div>';

										}
										}
										?>
				</div><br />
				<br />
				<br />
				<!-- operations with categories -->
				 <a onclick="$('#newcategory').slideToggle(200)" class="tiny">ADD CATEGORY</a><br />
				<a onclick="delcat();" class="tiny">DELETE SELECTED</a><br />
				<a onclick="rncat();" class="tiny">RENAME CATEGORY</a><br />
				<div id="newcategory" style="text-align:left;display:none;">
					<br />
					<small>Create category with name:</small><br />
					<br />
					<input type="text" maxlength="40" id="newcategoryname" style="width:135px;border:1px solid #222;" /> <a onclick="newcategory()" class="tiny">OK</a><br />
				</div>
			</div><!-- EMAILS CONTAINER -->
			<div id="emails_container" style="float:left;">
				<?php 

									if (isset($categories) && is_array($categories)) {  
									foreach ($categories as $key => $value) {

									echo '
									<div id="category_'.$value['id'].'" class="mails">
										<h2 class="h2emails">E-MAILS</h2><br />

										<div id="category_'.$value['id'].'_emails"><br />

											<a style="font-size:small;margin-top:15px;" onclick="selectAll(\'category_'.$value['id'].'\',true);" ><small class="tiny">Select all</small></a> |
											<a style="font-size:small;margin-top:15px;" onclick="selectAll(\'category_'.$value['id'].'\',false);" ><small class="tiny">Select none</small></a><br /><br />';

											if (isset($value['emails'])) {

												foreach ($value['emails'] as $subkey => $subvalue) {

													// EMAILS ARE PROTECTED BY ROT13 ENCRYPTION

													echo '
														<div><input type="checkbox" name="'.$subvalue['id'].'" value="'.$subvalue['id'].'" />
														<script type="text/javascript">
														<!--
															document.write("'.str_rot13($subvalue['email']).'".replace(/[a-zA-Z]/g, function(c){return String.fromCharCode((c<="Z"?90:122)>=(c=c.charCodeAt(0)+13)?c:c-26);})); 
														-->
														</script>
														<br /></div>';
												}
											}
											else {

												echo '<span id="no_mails_'.$value['id'].'">No emails</span><br />';

											}

											echo '

										</div>

										<br />___<br /><br />

									<!-- operations with emails -->

										<a onclick="$(\'#new_emails_'.$value['id'].'\').slideToggle(200)" class="tiny"><font class="sign g">•</font> ADD E-MAILS</a>  
										<a onclick="delmail(\''.$value['id'].'\');" class="tiny"><font class="sign r">-</font> DELTE SELECTED</a>  

										<div id="new_emails_'.$value['id'].'" align="left" style="display:none;padding:15px;">
											enter e-mails to add:<br /><br />
											<textarea id="to_add_'.$value['id'].'" cols="30" rows="4" style="font-size:small;border:1px solid #222;"></textarea>  
											<a class="tiny" onclick="add_mails(\''.$value['id'].'\')">OK</a><br />
										</div>

									</div>';
									}
								}                        
							?>
			</div>
			<div style="float:right;">
				<img src="images/send.gif" onclick="$('#newsletter').hide(350);$('#mailform').show(350);serializeSelection();" alt="next" style="cursor:pointer;" />
			</div>
		</div><!-- NEXT PAGE - E-MAIL FORM -->
		<div id="mailform" class="maincontainers" style="display:none;float:left;">
			<h2>
				WRITE YOUR MESSAGE
			</h2>
			<div>
				<div style="float:left;padding:20px;border:1px dotted #ddd;">
					<br />
					<h3>
						SUBJECT
					</h3><br />
					<br />
					<input type="text" id="subject" style="width:400px;" /><br />
					<br />
					<h3>
						MESSAGE
					</h3><br />
					<br />
					<textarea id="emailbody" name="emailbody" cols="40" onfocus="if (this.value=='Write your message here ...') this.value='';" rows="8" style="width:400px;">Write your message here ...</textarea><br />
					<br />
					<input type="file" name="fileToUpload" id="fileToUpload" onchange="return ajaxFileUpload();" /> <input type="text" readonly="readonly" id="filename" style="color:#83B440;font-weight:bold;" value="" /><br />
					<br />
				</div>
				<div style="float:right;width:500px;text-align:center;padding-top:120px;">
					<a class="backlink"><img onclick="sendmail();" src="images/go.png" alt="send!" /></a><br />
					<br />
					<span id="info_msg" class="tiny"></span>
				</div>
			</div><br style="clear:both" />
			<br />
			<a class="backlink" onclick="$('#newsletter').show(350);$('#mailform').hide(350)"><img src="images/back.gif" alt="go back" /></a>
		</div>
		<div id="sent_mails" class="maincontainers" style="display:none;float:left;">
			<h2>
				SENT E-MAILS
			</h2>
			<div>
				<div style="float:left;padding:20px;border:0px dotted #ddd;">
					<?php 

									if (is_array($sent)) { foreach ($sent as $key => $value) {
										echo '<h3>'.$value['subject'].'</h3><br />';
										echo '<small>'.$value['body'].'</small><br />';
										echo '<small style="color:#ccc;">'.date('d.m.Y',$value['time']).'</small>';
										if(isset($value['attachment'])) {

											echo '  <a style="color:#f30;text-decoration:none;" href="'.$dir.$value['attachment'].'" target="_blank"><small style="color:#f30;text-decoration:none;">'.$value['attachment'].'</small><br /></a>';

										}
										echo '<br /><br />';
									}}

									?>
				</div>
			</div><br style="clear:both" />
			<br />
			<a class="backlink" onclick="$('.maincontainers').hide();$('#sent_mails_link').show(50);$('#newsletter').show(350);$('#mailform').hide(350)"><img src="images/back.gif" alt="go back" /></a>
		</div>
	</div><!-- JQUERY -->
	<p>

		<script type="text/javascript" src="<?php echo $jquery_src; ?>"></script>  


<!-- =========================== -->
<!-- = FILE: AJAXFILEUPLOAD.JS = -->
<!-- =========================== -->


		<script type="text/javascript" charset="utf-8">
<!--
//<![CDATA[

	jQuery.extend({

		createUploadIframe: function(id, uri)
		{
				//create frame
				var frameId = 'jUploadFrame' + id;

				if(window.ActiveXObject) {
					var io = document.createElement('<iframe id="' + frameId + '" name="' + frameId + '" />');
					if(typeof uri== 'boolean'){
						io.src = 'javascript:false';
					}
					else if(typeof uri== 'string'){
						io.src = uri;
					}
				}
				else {
					var io = document.createElement('iframe');
					io.id = frameId;
					io.name = frameId;
				}
				io.style.position = 'absolute';
				io.style.top = '-1000px';
				io.style.left = '-1000px';

				document.body.appendChild(io);

				return io           
		},
		createUploadForm: function(id, fileElementId)
		{
			//create form   
			var formId = 'jUploadForm' + id;
			var fileId = 'jUploadFile' + id;
			var form = $('<form  action="" method="POST" name="' + formId + '" id="' + formId + '" enctype="multipart/form-data"><\/form>'); 
			var oldElement = $('#' + fileElementId);
			var newElement = $(oldElement).clone();
			$(oldElement).attr('id', fileId);
			$(oldElement).before(newElement);
			$(oldElement).appendTo(form);
			//set attributes
			$(form).css('position', 'absolute');
			$(form).css('top', '-1200px');
			$(form).css('left', '-1200px');
			$(form).appendTo('body');       
			return form;
		},

		ajaxFileUpload: function(s) {
			// TODO introduce global settings, allowing the client to modify them for all requests, not only timeout        
			s = jQuery.extend({}, jQuery.ajaxSettings, s);
			var id = new Date().getTime()        
			var form = jQuery.createUploadForm(id, s.fileElementId);
			var io = jQuery.createUploadIframe(id, s.secureuri);
			var frameId = 'jUploadFrame' + id;
			var formId = 'jUploadForm' + id;        
			// Watch for a new set of requests
			if ( s.global && ! jQuery.active++ )
			{
				jQuery.event.trigger( "ajaxStart" );
			}            
			var requestDone = false;
			// Create the request object
			var xml = {}   
			if ( s.global )
				jQuery.event.trigger("ajaxSend", [xml, s]);
			// Wait for a response to come back
			var uploadCallback = function(isTimeout)
			{           
				var io = document.getElementById(frameId);
				try 
				{               
					if(io.contentWindow)
					{
						 xml.responseText = io.contentWindow.document.body?io.contentWindow.document.body.innerHTML:null;
						 xml.responseXML = io.contentWindow.document.XMLDocument?io.contentWindow.document.XMLDocument:io.contentWindow.document;

					}else if(io.contentDocument)
					{
						 xml.responseText = io.contentDocument.document.body?io.contentDocument.document.body.innerHTML:null;
						xml.responseXML = io.contentDocument.document.XMLDocument?io.contentDocument.document.XMLDocument:io.contentDocument.document;
					}                       
				}catch(e)
				{
					jQuery.handleError(s, xml, null, e);
				}
				if ( xml || isTimeout == "timeout") 
				{               
					requestDone = true;
					var status;
					try {
						status = isTimeout != "timeout" ? "success" : "error";
						// Make sure that the request was successful or notmodified
						if ( status != "error" )
						{
							// process the data (runs the xml through httpData regardless of callback)
							var data = jQuery.uploadHttpData( xml, s.dataType );    
							// If a local callback was specified, fire it and pass it the data
							if ( s.success )
								s.success( data, status );

							// Fire the global callback
							if( s.global )
								jQuery.event.trigger( "ajaxSuccess", [xml, s] );
						} else
							jQuery.handleError(s, xml, status);
					} catch(e) 
					{
						status = "error";
						jQuery.handleError(s, xml, status, e);
					}

					// The request was completed
					if( s.global )
						jQuery.event.trigger( "ajaxComplete", [xml, s] );

					// Handle the global AJAX counter
					if ( s.global && ! -jQuery.active )

						jQuery.event.trigger( "ajaxStop" );

					// Process result
					if ( s.complete )
						s.complete(xml, status);

					jQuery(io).unbind()

					setTimeout(function()
										{   try 
											{
												$(io).remove();
												$(form).remove();   

											} catch(e) 
											{
												jQuery.handleError(s, xml, null, e);
											}                                   

										}, 100)

					xml = null

				}
			}
			// Timeout checker
			if ( s.timeout > 0 ) 
			{
				setTimeout(function(){
					// Check to see if the request is still happening
					if( !requestDone ) uploadCallback( "timeout" );
				}, s.timeout);
			}
			try 
			{
			   // var io = $('#' + frameId);
				var form = $('#' + formId);
				$(form).attr('action', s.url);
				$(form).attr('method', 'POST');
				$(form).attr('target', frameId);
				if(form.encoding)
				{
					form.encoding = 'multipart/form-data';              
				}
				else
				{               
					form.enctype = 'multipart/form-data';
				}           
				$(form).submit();

			} catch(e) 
			{           
				jQuery.handleError(s, xml, null, e);
			}
			if(window.attachEvent){
				document.getElementById(frameId).attachEvent('onload', uploadCallback);
			}
			else{
				document.getElementById(frameId).addEventListener('load', uploadCallback, false);
			}       
			return {abort: function () {}}; 

		},

		uploadHttpData: function( r, type ) {
			var data = !type;
			data = type == "xml" || data ? r.responseXML : r.responseText;
			// If the type is "script", eval it in global context
			if ( type == "script" )
				jQuery.globalEval( data );
			// Get the JavaScript object, if JSON is used.
			if ( type == "json" )
				eval( "data = " + data );
			// evaluate scripts within html
			if ( type == "html" )
				jQuery("<div>").html(data).evalScripts();
				//alert($('param', data).each(function(){alert($(this).attr('value'));}));
			return data;
		}
	});

	function ajaxFileUpload()
	{
		//starting setting some animation when the ajax starts and completes

		// IMPORTANT DOM REFERENCE VALUE //

		$("#processing")
		.ajaxStart(function(){
			$(this).show();
		})
		.ajaxComplete(function(){
			$(this).hide();
		});

		$.ajaxFileUpload
		(
			{

		// !!!!!!!!!!!!!!!!//
		// IMPORTANT VALUE //
		// !!!!!!!!!!!!!!!!//

				url:'index.php',
				secureuri:false,
				fileElementId:'fileToUpload',
				dataType: 'json',
				success: function (data, status)
				{
					if(typeof(data.error) != 'undefined')
					{
						if(data.error != '')
						{
							alert(data.error);
						}else
						{
							var uplfilename = data.file;
							if (uplfilename.indexOf('.php')>(-1) || uplfilename.indexOf('.htm')>(-1)  || uplfilename.indexOf('.js')>(-1)) {
								alert('Filetype not allowed !');
							}
							else {
								$('#filename').val(data.file);
							}
						}
					}
				},
				error: function (data, status, e)
				{
					alert(e);
				}
			}
		)
	return false;
	}       
//]]>
-->
</script>

<!-- ============= -->
<!-- = FUNCTIONS = -->
<!-- ============= -->

		<script type="text/javascript">
<!--
//<![CDATA[	

var emails = new Array() ;
var adresses = new Array() ;
var sendto = '';

// display e-mails of selected category
function adr_show(adr_id) {
	$('.mails').hide();
	$('#emails_container :checkbox').attr('checked','');
	$('#'+adr_id).fadeIn(500);
}

// toggle checkboxes
function selectAll(id,state) {
	$( "#" + id + "_emails :checkbox").attr('checked', state);
}

// serialize selected emails
function serializeSelection() {

	var categories = new Array() ;
	$( "#categories_container :checkbox:checked").each(function(){
		categories.push($(this).val());
	});

	if (categories.length < 1) {

		$( "#emails_container :checkbox:checked").each(function(){
				emails.push($(this).val());
		});

		if (emails.length > 0) {
			$('#info_msg').text('Email will be sent to '+(emails.length)+' selected emails');
			adresses = emails.join(",");
			sendto = 'emails';
		}
		else {
			$('#info_msg').text('No recipients are selected !');
			sendto = '';
		}

	}
	else {
		$('#info_msg').text('Email will be sent to '+(categories.length)+' selected categories');
		sendto = 'categories';
		adresses = categories.join(",");
	}
}

/* //////////////////////////////////////  ADD EMAILS */
function add_mails(id) {

	// load new e-mails as string
	var newmails = $('#to_add_'+id).val();

	if (newmails) {

		$('#processing').fadeIn(500);

		$.post("index.php", {
			action: 'newemail', cat: id, emails: newmails }, function(response){
			// alert(response);
			var response = eval('(' + response + ')');
			// error
			if (response.error != '') {alert(response.error);}
			// else append new e-mails
			else {
				  
				$("#category_"+id+"_emails").append(response.toappend);    
				$('#new_emails_'+id).slideToggle();
				$('#no_mails_'+id).hide();
				$('#to_add_'+id).val('');

			}
		});

		$('#processing').fadeOut(800);
	}
	else {
		alert('Please write e-mails to add.');
	}
}
// ***

/* ////////////////////////////////////// DELETE EMAILS */
function delmail(id) {
	var emails_to_del = "", count = 0, word;

	// load checked emails to string separated by | and count them
	$( "#category_" + id + " :checkbox:checked").each(function() {
		emails_to_del+=$(this).val()+"|";
		count+=1;
	});

	// CHECK IF ANY MAILS ARE SELECTED AND CONSTRUT THE QUESTION
	if (count == 0) { alert('No emails are selected'); return false;}
	if (count == 1) { word = 'selected e-mail ?'; count = ''}
	if (count > 1) { word = 'selected e-mails ?';}

	if (confirm('Do your really want to remove '+count+' '+word) ) {

		// show processing dialog
		$('#processing').fadeIn(500);

		$.post("index.php", {
			action: 'delmail', cat: id, emails: emails_to_del }, function(response){
			var response = eval('(' + response + ')');
			// error
			if (response.error != '') {alert(response.error);}
			// else remove checked e-mails
			else {
				$( "#category_" + id + "_emails :checkbox:checked").parent().each(function(){
					$(this).remove();
				})
			}

		$('#processing').fadeOut(500);

		});
	}
}
// ***

/* //////////////////////////////////////  CREATE CATEGORY */
function newcategory() {
	if ($("#newcategoryname").val()!='') {
	$.post("index.php", {
		action: 'newcategory', catname: $("#newcategoryname").val() }, function(response){
			var response = eval('(' + response + ')');
			// error
			if (response.error != '') {alert(response.error);}
			// else reload page
			else { window.location.reload(); }
		});
	}
	else {
		alert ('Please select a name !');
	}
	}
// ***

/* ////////////////////////////////////// RENAME CATEGORIES */
function rncat() {

	var cat_to_rn = "", count = 0;

	$("#categories :checkbox:checked").each(function() {
		cat_to_rn+=$(this).val();
		count+=1;
	});

	if (count >= 2 ) {alert('Select one category only !'); return false;}
	if (count == 0 ) {alert('Select desired category !'); return false;}
	var newname = prompt('Zadajte nové meno:');

	if (newname) {

		$.post("index.php", {
			action: 'rncat', category: cat_to_rn, newname: newname }, function(response){
				var response = eval('(' + response + ')');
				// error
				if (response.error != '') {alert(response.error);}
				// else reload page
				else {history.go(0);}
		});
	}
}
// ***

/* ////////////////////////////////////// DELETE CATEGORIES */
function delcat() {

	var catz_to_del = "", count = 0, word;

	$("#categories :checkbox:checked").each(function() {
		catz_to_del+=$(this).val()+"|";
		count+=1;
	});

	// construct a question
	if (count == 0) { alert('Select desired category');return false;}
	if (count == 1) { word = 'selected category ?'; count = ''}
	if (count > 1 ) { word = 'selected categories ?';}

	if (confirm('Do you really want to delete '+word) ) {

		$.post("index.php", {

			action: 'delcat', categories: catz_to_del }, function(response){
			var response = eval('(' + response + ')');
			// error
			if (response.error != '') {alert(response.error);}
			// if no errors, remove checked categories
			else {
				$( "#categories :checkbox:checked").parent().each(function(){$(this).remove();})
				history.go(0);
			}
		});
	}
}
// ***

/* ////////////////////////////////////// DELETE CATEGORIES */
function sendmail() {
  $('#processing').fadeIn(500);
  $.post("index.php", {
		  action: 'sendmail', sendto: sendto, attachment: $('#filename').val(), subject: $('#subject').val(), ebody: $('#emailbody').val(), adresses: adresses }, function(response){

			var response = eval('(' + response + ')');
			if (response.error != '') {alert(response.error);}
			else {
			  var previoushtml = $('#processing').html();
			}
		  }
	);
  setTimeout("$('#processing').fadeOut(1000)",2500);
}   
// ***

// DOC READY
$(document).ready(function() {
	// hide processing div
		$('#processing').hide();
	// hide all e-mail divs
		$('.mails').hide();
	// show the first div
		$('#category_<?php echo $categories[0]['id'];?>').show();
});
//]]>
-->
</script><!-- CLOSE DB CONNECTION -->
		<?php mysql_close($server); ?>

</body>
</html>

A1SURF.us · January 4, 2011

I had to cut a bunch of the class out so that it would fit inside the post limit, but it wasn't important stuff I think..

trq · January 4, 2011

You might want to cut some more code out. We only need what's relevant, personally, that's far too much code for me to even bother with.

A1SURF.us · January 4, 2011

I attached a more cleaner version of the class.

[attachment deleted by admin]

A1SURF.us · January 4, 2011

Theirs actually only a few lines of code that need modified. I keep getting a blank page error when I try to modify it. There is also some dynamic javascript that might need modified. So I included it inside the class. I'm not sure if the java is relevant and if it contains actual data from the database. Their are 'id' tags inside the javascript and it is throwing me off. Let me know if you need the original.

A1SURF.us · January 4, 2011

Why doesn't this work? or is their something similar like this that needs to be done with a call to the database?

$id = $user_id

trq · January 4, 2011

Why doesn't this work? or is their something similar like this that needs to be done with a call to the database?
$id = $user_id

That will work, depending on what you want done obviously.

A1SURF.us · January 4, 2011

Well I thought this was a PHP help forum but it's looking more like flame fest. Your either gonna help or your not. Smart ass replies are not helping. Every time I have a problem I try to get some help here and I usually get ignored or smart ass replies like this and I end up solving the problem on my own. My signature was not spam. According to rules, images and links are allowed. I wasn't posting and replying all over the place in some unnatural way.. According to the rules, Flaming and or Trolling is prohibited and will result in course of action to be taken by Staff members. But you are a staff member and I guess the rules do not apply to you?

trq · January 5, 2011

I'm not sure I understand why you think my comment was smart arsed? I answered the previous question is all.

trq · January 5, 2011

As for your signature, see #5 of the forum rules.

http://www.phpfreaks.com/page/rules-and-terms-of-service

Sign In

PHP variable designation

Recommended Posts

A1SURF.us

Link to comment

Share on other sites

A1SURF.us

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

A1SURF.us

Link to comment

Share on other sites

A1SURF.us

Link to comment

Share on other sites

A1SURF.us

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

A1SURF.us

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information