PHP - Send Messages Over Lan

I am working on a phpmailer script that sends an order confirmation email to the customer AND the client at the same time.  If I have the customer email and client email set both to the originating domain's email addresses (myname@myserver.com), then it sends fine.  However, if I try to send to an outside mail server (eg. someone@gmail.com), I get the following errors:

Code: [Select]
SMTP -> FROM SERVER:220 myserver.com ESMTP Exim 4.63 Sat, 18 Sep 2010 15:08:21 -0700
SMTP -> FROM SERVER: 250 myserver.com Hello localhost [127.0.0.1] 250-SIZE 52428800 250-PIPELINING 250-AUTH LOGIN PLAIN 250-STARTTLS 250 HELP
SMTP -> FROM SERVER:250 OK
SMTP -> FROM SERVER:250 Accepted
SMTP -> FROM SERVER:
SMTP -> ERROR: RCPT not accepted from server:
SMTP Error: The following recipients failed: someone@gmail.com Message could not be sent.
Mailer Error: SMTP Error: The following recipients failed: someone@gmail.com

SMTP server error:
I'm not sure what's going on here.  Any SMTP or phpmailer geniuses here that can shed some light on what needs to happen here for this to send to any address?

Hi,

I'm trying to setup a quick PHP script that will grab the email from the url (see below) and after inserting into MySQL db - which is working fine - the script will complete two additional tasks:

1. send that same captured email out to a external db as in shown via http://domain1.com/insert.php?email=$lead (example), but then send to a DIFFERENT source - the originator of the lead - a portback acknowledgement using Header (sending the status and email to http://domain2.com/check.php?e=$lead&s=$status for their records).

See the code below:
-------------------------

Code: [Select]

$lead = $_REQUEST['e_mail'];                // will grab email from posted url string and assign to local variable
$result = mysql_query($command);      // this is just to execute the MySQL insert which works just fine but included here to explain validation below

// Create API Call string to insert lead into iContact folder
$requestURL = "http://domain1.com/insert.php?email=$lead";

// Execute API Call to CAKE
$xml = simplexml_load_file($requestURL) or die("feed not loading");


if ($result) {
    $status = 1;       // mark lead as sucess

    // send postback on lead status
    header("Location: http://domain2.com/check.php?e=$lead&s=$status");
}

--------

Problem: I'm getting all sorts of errors with the simplexml_load_file() function and can't figure out why it won't work.
Any input appreciated as this the only way I know how to pass the lead onward and then inform/update the other party of receipt of information.

thanks!

I have two messages in my PHP code, and one is displayed depending on whether or not an INSERT succeeds...


// Verify Insert.
if (mysqli_stmt_affected_rows($stmt)==1){
// Insert Succeeded.
echo '<div id="box_Content_700b">';
echo '<h1>Member Account Created</h1>';
echo '<p>Congratulations!</p>
<p>Your account has been created, and a confirmation e-mail sent to: "' . $email . '"</p>
<p>Please click on the link in that e-mail to activate your account.</p>';
echo '</div>';
// Send Email.

}else{
// Insert Failed.
echo '<div id="box_Content_700b">';
echo '<h1>Account Creation Failed</h1>';
echo '<p>You could not be registered due to a system error.</p>';
echo '<p>Please contact the System Administrator.</p>';
echo '</div>';
}// End of VERIFY INSERT.



Questions:
1.) Would it be better if I put those messages in MySQL and just queried the one I needed?

2.) If so, can I put the entire message and markup in the database, so everything is ready to display?

3.) Should I use VARCHAR() or TEXT()?

Thanks,


Debbie

I have to get the error messages to appear...but for some reason they're not showing up if I leave the forms blank and click submit.

Code: [Select]
  <?
  $PROVINCES = array( "--" => "--- Please Select Provinces ---",
"nf"=>"Newfoundland",
"pe"=>"Prince Edward Island",
"nb"=>"New Brunswick",
"ns"=>"Nova Scotia",
"qc"=>"Quebec",
"on"=>"Ontario",
"mb"=>"Manitoba",
"sk"=>"Saskatchewan",
"ab"=>"Alberta",
"bc"=>"British Columbia",
"nt"=>"Northwest Territories");
 
  if ($_SERVER['REQUEST_METHOD'] == 'GET')
  {
  $dimwelcomeMsg = TRUE;
  }
 
  if ($_SERVER['REQUEST_METHOD'] == 'POST')
  {
  if ($_POST['uname'] == ''){
$errMsg['uname'] = "Username must not be blank!!!"; 
$unameInError = true;
  }
  if (empty($_POST['year']) == TRUE){
  $errMsg['year'] = "Year must not be blank!!";
  }
  if (count($errMsg) > 0 ):
  $dispErrorMsg = TRUE;
else:

foreach ($_POST as $key => $val):
$key = strtoupper($key);
$successMsg[$key] = $val;
endforeach;

$dispSuccessMsg = TRUE;


endif;
  }
  ?>
<html  >

<head>
<title>Comp10065 - Simple Form Validatioon</title>

 
<style type="text/css">


body { margin: 0; padding: 0; font: 80%/1.5 Arial,Helvetica,sans-serif; color: #111; background-color: green; }
h2 { margin: 0px; padding: 10px; font-family: Georgia, "Times New Roman", Times, serif; font-size: 200%; font-weight: normal; color: #FFF; background-color: #CCC; border-bottom: #BBB 2px solid; }
h1 {color:#006600}
p#copyright { margin: 20px 10px; font-size: 90%; color: #999; }
div.form-container { margin: 10px; padding: 5px; background-color: #FFF; border: #EEE 1px solid; }
p.legend { margin-bottom: 1em; }
p.legend em { color: #C00; font-style: normal; }
div.errors { margin: 0 0 10px 0; padding: 5px 10px; border: #FC6 1px solid; background-color: #FFC; }
div.errors p { margin: 0; }
div.errors p em   { color: #C00; font-style: normal; font-weight: bold; }
div.success { margin: 0 0 10px 0; padding: 5px 10px; border: #FC6 1px solid; background-color: #FFC; }
div.success p { margin: 0; color:#006633}
div.success li {list-style-type: none; }
div.form-container form p { margin: 0; }
div.form-container form p.note { margin-left: 170px; font-size: 90%; color: #333; }
div.form-container form fieldset { margin: 10px 0; padding: 10px; border: #DDD 1px solid; }
div.form-container form legend { font-weight: bold; color: #666; }
div.form-container form fieldset div { padding: 0.25em 0; }
div.form-container label,
div.form-container span.label { margin-right: 10px; padding-right: 10px; width: 150px; display: block; float: left; text-align: right; position: relative; }
div.form-container label.error,
div.form-container span.error { color: #000; }
div.form-container select.error, div.form-container div.error {background-color: #FEF;}
div.form-container label em,
div.form-container span.label em { position: absolute; right: 0; font-size: 120%; font-style: normal; color: #C00; }
div.form-container input.error { border-color: #C00; background-color: #FEF; }
div.form-container input:focus,
div.form-container input.error:focus,
div.form-container textarea:focus { background-color: #FFC; border-color: #FC6; }
div.form-container div.controlset {margin: 3px}
div.form-container div.controlset label,
div.form-container div.controlset input { display: inline; float: none; }
div.form-container div.controlset div { margin-left: 170px; }
div.form-container div.buttonrow { padding-left: 430px; border: 1px solid #CCCCCC }
div#wrapper {width: 700px ; margin-left: auto; margin-right: auto}
pre {color:black; font-size: 10pt; font-weight: bold; margin-left: 30px}
</style>

</head>

<body>

<div id="wrapper">

<h1> Form Validation Lab</h1>

<div class="form-container">
 <? if ($_SERVER['REQUEST_METHOD'] == 'GET') : ?>
 <? if (displayWelcomeMsg) : ?>
 <p>Please fill in the form........</p>
 <? endif; ?>
 
<? endif; ?>

<? if ($displaySuccessMsg): ?>
<div class="success">
<p>Thank you for your submission.</p>
<ol>
<? foreach($successMsgs as $key => $successMsg): ?>
<li><?= $key ?> = <?= $successMsg ?> </li>
<? endforeach; ?>
</ol>
</div>
<? endif; ?>

<? if ($dispErrorMsg) : ?>
<div class="errors">
<p><em>Oops...the following errors were encountered</em></p>
<ul>
<? foreach ($errMsgs as $key => $errMsg): ?>
<li><?= $errMsg ?> </li>
<? endforeach; ?>
</ul>
<p>Please correct the errors and re-submit this form.</p>
</div>
<? endif; ?>




<form action="<?= $_SERVER['PHP_SELF'] ?>" method="post">
<input type="hidden" name="act" value="post">
<div class="buttonrow">
<input type="submit" value="Submit This Form " class="button" />
<a href="<?= $_SERVER['PHP_SELF'] ?>" >Start Again</a>
</div>

<p class="legend"><strong>Note:</strong> Required fields are marked with an asterisk (<em>*</em>)</p>
<fieldset>
<legend>User Details</legend>
<div>
<label for="uname" >User Name <em>*</em></label>
<? if (isset($errMsgs['uname'])) echo 'class = "errors"' ?>
           
<input id="uname" type="text" name="uname"  value="<?=$_POST['uname'] ?>"  />
(must be greater than 5 chars)</div>
<div>
<label for="email">Email Address </label>
<input id="email" type="text" name="email" value="" />
</div>
</fieldset>

<fieldset>

<legend>Submission</legend>
<div>
<label for="year">Year (YYYY) <em>*</em></label>
<input id="year" type="text" name="year"
            <? if (isset($errMsgs['year'])) echo 'class = "errors"' ?>
value="" size="4" maxlength="4"  />
(4 digit number)</div>
<div>
<label for="date">Month (MM)</label>
<input id="date" type="text" name="month" value="" size="4" maxlength="2" />

(number ranging from 1-12)</div>
</fieldset>

<fieldset>
<legend>Preferences</legend>
<div>
<label for="type" >Province (Multiple Select) <em>*</em></label>
<select name = "province[]" multiple size = "12" id="type"  >
                <? foreach ($PROVINCES as $abbreviation => $longname); ?>
                <option value = "<?=$abbreviation ?> "></option>
                <? enfgoreach; ?>
</select>

</div>
<div class= 'controlset'   >
<span class="label">Status (Mult Select)<em>*</em></span>
<input name="status[]" id="approved" value="approved" type="checkbox"  /> <label for="approved">Approved</label>
<input name="status[]" id="pending" value="pending" type="checkbox"  /> <label for="pending">Pending Application</label> <input name="status[]" id="actives" value="actives" type="checkbox"  /> <label for="actives">Active Service</label>

</div>

<div class= 'controlset'>
<span class="label">  Location  <em>*</em></span>
<input name="location" id="radio1" value="Garage" type="radio" /> <label for="radio1">Garage</label>
<input name="location" id="radio2" value="Attic" type="radio" /> <label for="radio2">Attic</label>
<input name="location" id="radio3" value="House" type="radio" /> <label for="radio3">House</label>

</div>
</fieldset>

</form>
<p>This debug info is here to help you. You are only required to display the POST array</p>
<pre><?= print_r($_POST,true) ?> </pre>
</div>

</div>

</body>
</html>

this is my first post (besides introduction and a comment in introduction) so im not 100% sure what all i am suppose to post for you guys so i will give it my best shot.. i have read 90% of rules though so i know what NOT to post lol here it goes:

i am trying to get new messages to appear on header of my site but the alert (number) is not showing up..


this is in the <head>

Code: [Select]


<?
include('inc.settings.php');
include('inc.networth.php');
@mysql_connect($dbhost,  $dbuser,  $dbpass);
@mysql_select_db($dbname) or die("Error opening database");
$sqld = "SELECT * from og_userinfo where id=$userid";
$resultd = @mysql_query($sqld);
$myrowd = @mysql_fetch_array($resultd);
$networthck = $myrowd[networth];
$sqlornk = "SELECT count(*) from og_userinfo where networth > $networthck";
$resultornk = @mysql_query($sqlornk);
$myrowornk = @mysql_fetch_array($resultornk);
$orank = $myrowornk[0] + 1;
$netstate = $myrowd[state];
$sqlornk2 = "SELECT count(*) from og_userinfo where networth > $networthck AND state=$netstate";
$resultornk2 = @mysql_query($sqlornk2);
$myrowornk2 = @mysql_fetch_array($resultornk2);
$orank2 = $myrowornk2[0] + 1;
$pc_rank = $orank2 - 1;
$pchk_rank = floor($pc_rank / 20);
$plimit = $pchk_rank * 20;
?>





--this is in the body--

Code: [Select]


     <table id="center" width="393" height="104" align="center" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="5">
<img src="images/center_01.gif" width="393" height="13" alt=""></td>
</tr>
<tr>
<td rowspan="6">
<img src="images/center_02.gif" width="10" height="91" alt=""></td>
<td width="372" height="28" colspan="3" align="center" bgcolor="#000000" alt="round time">round ends in: <? echo $dleft?> days, <? echo $hleft?> hours, <? echo $mleft?> minutes, <? echo $sleft?> seconds</td>
<td rowspan="6">
<img src="images/center_04.gif" width="11" height="91" alt=""></td>
</tr>
<tr>
<td colspan="3">
<img src="images/center_05.gif" width="372" height="8" alt=""></td>
</tr>
<tr>
<td width="152" height="23" align="center" bgcolor="#000000" alt="messages"><a href="messages.php?uid=<? echo $uid ?>&amp;secid=<? echo $secid ?>&amp;type=1">messages</a> (<? echo  $mmyrow[0] ; ?>)</td>
<td rowspan="3">
<img src="images/center_07.gif" width="68" height="49" alt=""></td>
<td width="152" height="23" align="center" bgcolor="#000000" alt="cartel messages"><a href="view.cartel.messages.php?uid=<? echo $uid ?>&amp;secid=<? echo $secid ?>&amp;type=1">cartel messages</a> (x)</td>
</tr>
<tr>
<td>
<img src="images/center_09.gif" width="152" height="4" alt=""></td>
<td>
<img src="images/center_10.gif" width="152" height="4" alt=""></td>
</tr>
<tr>
<td width="152" height="22" align="center" bgcolor="#000000" alt="message board"><a href="cafe.messages.php?uid=<? echo $uid ?>&amp;secid=<? echo $secid ?>&amp;type=1">message board</a></td>
<td width="152" height="22" align="center" bgcolor="#000000" alt="attacks"><a href="messages.php?uid=<? echo $uid ?>&amp;secid=<? echo $secid ?>&amp;type=2">attacks</a> (<? echo  $mmyrow1[0] ; ?>)</td>
</tr>
<tr>
<td colspan="3">
<img src="images/center_13.gif" width="372" height="6" alt=""></td>
</tr>
</table>



i would really like the new messages to be in javascript so they show in real time instead of refreshing page but i know even less about that and all i can find info on on google is popup alerts which i dont want


this is an image of the look im going for:

Hi,

I am creating a cms using php and my sql for my website. I have managed to create the majority of it but am having trouble added a menu on each page.

It appears on the homepage with the following code:

      <ul id="headlines">

<?php foreach ( $results['articles'] as $article ) { ?>

        <li>
          <h2>
         <a href=".?action=viewArticle&amp;articleId=<?php echo $article->id?>"><?php echo htmlspecialchars( $article->title )?></a>
          </h2>
        </li>

<?php } ?>

      </ul>

Once I click on a selection from the menu it takes me to the correct article but there is no menu now.

If I try to copy and paste the code from homepage into my viewArticle file it gives me the error messages 'undefined index articles on line 6' and 'invalid argument supplied for for each'.

This is the viewArticle code after I pasted in the code from homepage:

      <ul id="headlines">

<?php foreach ( $results['articles'] as $article ) { ?>

        <li>
          <h2>
         <a href=".?action=viewArticle&amp;articleId=<?php echo $article->id?>"><?php echo htmlspecialchars( $article->title )?></a>
          </h2>
        </li>

<?php } ?>

      </ul>

      <h1 style="width: 75%;"><?php echo htmlspecialchars( $results['article']->title )?></h1>
      <div style="width: 75%;"><?php echo $results['article']->content?></div>


I would really appreciate anybody helping me figure out how I can add the menu onto the viewArticle page.

Thanks in advance

i am having issues returning all sent messages.  it will only return one for some reason.

Code: [Select]
//If there are sent messages, display them
if ($row = mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result) or die(mysql_error());

    //Open table and create headers
    echo "<table border=\"1\">\n";
    echo "  <tr>\n";
echo "    <th>Recipient</th>\n";
    echo "    <th>Subject</th>\n";
    echo "  </tr>\n";

while(mysql_fetch_array($result))
{
//Show messages
$userIDTo = $row['userIDTo']; // Get the recipient's ID number
$recipient = checkRecipient($userIDTo); // Get the sender's Username
$messageID = $row['ID'];
        echo "  <tr>\n";
echo "    <td>{$recipient}</td>\n";
        echo "    <td><a href='messageDetails.php?messageID=$messageID' target='_blank'>{$row['subject']}</a></td>\n";
        echo "  <tr>\n";
}
thanks in advance.

Hello,
I have a client with a "contact us" form who has recently been receiving a lot of spam emails from the form.  I already have a session set in place so the form is only active one time.  I am now creating a filter for the message to look for things like a url or bb style codes etc.  What I've got seems to be working but would like your thoughts on maybe a better way of doing it or if you see something I may be missing.  IF an offending text is detected the ip address is sent to me and I can block ip from the site.  If the message passes it is sent to the client.  This is the related code.
Code: [Select]
<?php
$themessage=str_replace("\r",'<br>',$_POST['message']);

$badwords=array("[", "url", "http", "link", ".com", ".net", ".org", ".biz", "<");
$o=0;
foreach($badwords as $key2 => $value2){
    $pos = strpos($themessage, $value2); 
if ($pos==0) {
}
else{ 
$o=$o+1;
}
} 
if ($o==0) {
//compose and send email to client
}
else{
$useraddress=$_SERVER['REMOTE_ADDR'];
//compose and send email to me containing offending address
}
?>

i am trying to retrieve messages with some code.  It seems to be a bit more complicated that i thought it would be.  so here it goes:

Code: [Select]
$query = "SELECT * FROM memberMail WHERE userIDFrom='92' AND unread='1'"; 
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result) or die(mysql_error());

$num_rows = mysql_num_rows($result);

echo "You have (" . $num_rows . ") unread message(s).";

$i = 0;
for($i; $i<$num_rows; ++$i) {
if($row[$i[unread]] == "1") {
echo $row[$i[message]] . "<p>";
}
}

}
what i am trying to do, is print out the messages from the records that are unread, and are from a certain user.  i don't think this for statement will pick up the record numbers that got matches though.  and i am not entirely sure about the $row statements in the for statement either.

hello  , i have this code:


<?php

function error_table($err){
echo"<p><span class='textborder'>$err</span></p>";
}


?>

in a separate php file and then call it from another php file , like this :


$msg_err='bla bla';
error_table($msg_err);


when i click the button it shows the text with its border(the class has a border ,color and 1px)
but when i have the code inside other if functions it shows it 2 or 3 times...

Hey guys just wandered if you can help me on my website in the mailbox section next to the message there is a delete button to obviously delete that current message.   However as I am sure you can appreciate it get tedious when you have 20 messages to do them all at once.   So I am after putting a button at the top of this column in the table that will delete all the messages in there with one click.   Below is the coding of where all this takes place:

function mailbox($mes,$page)
{
global $config;


if(!$page)
{
$page="1";
}


$page=($page - 1);


$totalmes=mysql_query("SELECT COUNT(*) FROM messages WHERE toid='".$_SESSION['tid']."' AND rcvddel=0");
$totalmes=mysql_result($totalmes,0);


$out[body].="
<div style='float:left;width:69%;margin:5px;'>
<table cellspacing='1' cellpadding='1' border='0' width='100%'>
<tr>
<td width='100%'  class='blk_tcon' colspan='5'><b>" . LANG_MAI_MAILBOX . "</b></td>
</tr>
<tr>
<td width='50%' colspan='2' class='blk_tcon_top'>" . LANG_MAI_SUBJECT . "</td>
<td width='20%' class='blk_tcon_top'>" . LANG_MAI_FROM . "</td>
<td width='25%' class='blk_tcon_top'>" . LANG_MAI_DATE . "</td>
<td width='5%' class='blk_tcon_top'></td>
</tr>";


$fmail=mysql_query("SELECT id,fromid,subject,active,sent FROM messages WHERE toid='".$_SESSION['tid']."' AND  grid='1' AND rcvddel=0 ORDER BY sent DESC LIMIT $page, 15");
while(list($id,$fromid,$subject,$active,$sent)=mysql_fetch_row($fmail))
{


$from=mysql_query("SELECT name FROM members WHERE id='$fromid'");
$from=mysql_fetch_array($from);


if($fromid == '01')
{
$froma="Site Challenge";
}else{
$froma="<a href='./profile.php?account=$fromid'>$from[name]</a>";
}


if($active == 1)
{
$icon="<img src='./images/unread.gif' border='0' alt='' />";
$title="<a href='./mailbox.php?action=readmail&mailtype=received&mid=$id'><b>$subject</b></a>";


}else if($active == 2){
$icon="<img src='./images/read.gif' border='0' alt='' />";
$title="<a href='./mailbox.php?action=readmail&mailtype=received&mid=$id'>$subject</a>";
}else{
$icon="<img src='./images/replied.gif' border='0' alt='' />";
$title="<a href='./mailbox.php?action=readmail&mailtype=received&mid=$id'>$subject</a>";
}


$out[body].="
<tr>
<td width='5%' align='center' class='blk_tcon'>$icon</td>
<td width='45%' align='left' class='blk_tcon'>$title</td>
<td width='20%' align='center' class='blk_tcon'>$froma</td>
<td width='25%' align='center' class='blk_tcon'>$sent</td>
<td width='5%' align='center' class='blk_tcon'>
<form method='post'>
<input type='hidden' name='mail[id]' value='$id' />
<input type='hidden' name='mail[mailtype]' value='received' />
<input type='hidden' name='action' value='delete' />
<input type='submit' class='button' name='submit' value='X' style='color:red; font-weight:bold;' title='" . LANG_MAI_DELETE . "' />
</form>
</td>
</tr>";


}


if($totalmes == 0)
{
$out[body].="
<tr>
<td width='100%' align='center' colspan='5' class='blk_tcon'>" . LANG_MAI_MAILBOX_EMPTY . "</td>
</tr>";
}


$pagenow=($page + 1);
$pages=1;
if($pagenow==1)
{
$skipranks.="[$pages] ";
}else{
$skipranks.="<a href='./mailbox.php?page=1'>$pages</a> ";
}


$arank=1;
$brank=15;
while($brank < $totalmes)
{
$arank=($arank + 15);
$brank=($brank + 15);
$pages++;


if($pagenow==$arank)
{
$skipranks.="[$pages] ";
}else{
$skipranks.="<a href='./mailbox.php?page=$arank'>$pages</a> ";
}
}


$out[body].="
<tr>
<td width='100%'  align='center' class='blk_tcon' colspan='5'>$skipranks</td>
</tr>
</table>
</div>


".TOP_MENU."";


include("$config[html]");
}


</tr>";

Hey all, I've been coding a thing for my website which allows Users to apply for a crew via the Crew Profile Page. The code all works just when the User applys I want the Crew Staff to get a message just to let them know.

I've tryed things of which I though could work but none of them did. I also tryed with a function, witch didn't work but I'm not to sure on Functions at the moment.

My Code so far:

<?php
session_start();
include "includes/config.php";
include "includes/functions.php";
include "includes/bb-codes.php";
logincheck();
$username= $_SESSION['username'];
$viewcrew= $_GET['viewcrew'];

$fetch=mysql_fetch_object(mysql_query("SELECT * FROM crews WHERE name='$viewcrew'"));

$mysql1 = mysql_query("SELECT * FROM `users` WHERE username = '$username'") or die ("Error, Line 13 " . mysql_error()); // Doing User Query
$userfetch = mysql_fetch_object($mysql1); // Getting User Object

$needcrewstaff = mysql_query("SELECT * FROM crews WHERE name='$viewcrew'");

$pleasework = mysql_fetch_object($needcrewstaff);

// Start Send Staff Message Function

function sendstaffmessage(){
$message = "You have an Crew Application. Click <a href='crewapp.php' target='mainFrame'>here</a> to Accept or Decline it!";
if ($pleasework->owner == $username){
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` )
VALUES (
'', '$pleasework->owner', '$username', '$message', '$date', '0', '0', '0'
)");
} 
if ($pleasework->coowner == $username){
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` )
VALUES (
'', '$pleasework->owner', '$username', '$message', '$date', '0', '0', '0'
)");
}
if ($pleasework->underboss == $username){
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` )
VALUES (
'', '$pleasework->underboss', '$username', '$message', '$date', '0', '0', '0'
)");
}
if ($pleasework->recruiter == $username){
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` )
VALUES (
'', '$pleasework->recruiter', '$username', '$message', '$date', '0', '0', '0'
)");
}
if ($pleasework->recruiterone == $username){
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` )
VALUES (
'', '$pleasework->recruiterone', '$username', '$message', '$date', '0', '0', '0'
)");
}
}

// End the Function!

if (strip_tags($_POST['apply'])){
if ($userfetch->crew != "0"){
echo ("You can not Apply for <strong>$viewcrew</strong> when already being in <strong>$get->crew</strong>!");
}else{
sendstaffmessage();
mysql_query("UPDATE users SET crewapp='$viewcrew' WHERE username='$username'");
echo ("$viewcrew Applied for! - Note: If you Apply for a different Crew this App will be Deleted.");
}
}
?>


Is there any way to change my code which will send the Crew Boss etc.. a Message when somebody has applyed?

Thanks for any help.

I would like to create a script that can login to my account on xbox.com, check my messages, and store messages into my database (only messages that have not been stored yet).

The purpose for this is: I want my users to register their accounts using their Xbox Live Username. To make them verify their Username they send a message to my Xbox Account with a message saying 'Verify" or something. My script will check my xbox account's messages for new messages with the body saying 'Verify' to verify the username, and store it in a database that it has been successfully verified.

How do I go about doing this?

Hey there

I've adapted the search code from the tutorial on this site here

http://www.phpfreaks.com/tutorial/simple-sql-search

for a project I've been working on but have an error.

The search works just fine but if either of the messages I've included are tripped (zero search characters or nothing found) then I get a blank screen and the error message is not echoed. (The vanilla code works fine - the error has arisen through the changes I needed to make).

I don't know why this is happening and would appreciate some help please.

Thanks in advance for any help.

Code: [Select]
session_start();

// check session variable

if (isset($_SESSION['first_name']))
  {
include ('includes/header_loggedin.html');

//db connection info deleted 

$error = array();

//get search term, strip it

if (isset($_GET['search'])) {
$searchTerms = trim($_GET['search']);
$searchTerms = strip_tags($searchTerms); // remove any html/javascript.

   
   if (strlen($searchTerms) < 1) {
      $error[] = 'Search terms must be longer than 1 character.';
   }else {
      $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
   }
   
//formulate query
   if (count($error) < 1) {
$query = "SELECT * FROM table WHERE row LIKE '%{$searchTermDB}%'";

//make the query

$result = mysql_query($query) or die(mysql_error());

//display the results
 if (mysql_num_rows($result) < 1) {
         $error[] = "Your search term yielded no results.";
      } else {
while ($endresult = mysql_fetch_array($result)) {
  echo '<br />';
  echo 'This is what we found';
  echo '<br />';
      echo '<a href="newpage.php?w=' . $endresult['row'] . '">' . $endresult['row'] . '</a>';
  }
}
}
}
}