Order number on confirmation email not showing

9/24/2010 5:36 am | #1 rikaG_510

Hello,

On my shopping site confirmation email, there's a php code to echo the order number, but it shows just blank. No error message or nothing.

Could anyone look into the code and tell me what it wrong?
I attached txt file with coding for Store Summary in database and Order number bit on confirmation email.

Thank you for your help,

Rika

Attached Files

Code for summary and conf email.txt

9/24/2010 8:21 am | #3 rikaG_510

Hi Jason,

Sorry I guess I didn't explain enough (and I didn't past enough code either.)

The coding for order number in email which I copy & pasted on previously attached file was copied from confirm_WAUE_HTML_WA_Universal_Email_1.php.
From "confirm.php", I only copied the store summary bit.

From a sound of your comment, I needed to copy more from "confirm.php".
So this time I copied coding from the beginning up to store summary.

Hope this is enough to look through.

Rika

Attached Files

Code for summary and conf email2.txt

9/24/2010 9:02 am | #4 Jason ByrnesWebAssist

this part of the code sends the email:

php:

<?php

if (!isset($_SESSION))session_start();

if ((($_SERVER["REQUEST_METHOD"] == "POST") && (isset($_SERVER["HTTP_REFERER"]) && strpos(urldecode($_SERVER["HTTP_REFERER"]), urldecode($_SERVER["SERVER_NAME"].$_SERVER["PHP_SELF"])) > 0) && isset($_POST)))     {

  //WA Universal Email object="mail"

  set_time_limit(0);

  $EmailRef = "waue_confirm_1";

  $BurstSize = 200;

  $BurstTime = 1;

  $WaitTime = 1;

  $GoToPage = "";

  $RecipArray = array();

  $StartBurst = time();

  $LoopCount = 0;

  $TotalEmails = 0;

  $RecipIndex = 0;

  // build up recipients array

  $CurIndex = sizeof($RecipArray);

  $RecipArray[$CurIndex] = array();

  $RecipArray[$CurIndex ][] = "".$_SESSION['eCartCheckoutForm_postcode']  ."";

  $TotalEmails += sizeof($RecipArray[$CurIndex]);

  $RealWait = ($WaitTime<0.25)?0.25:($WaitTime+0.1);

  $TimeTracker = Array();

  $TotalBursts = floor($TotalEmails/$BurstSize);

  $AfterBursts = $TotalEmails % $BurstSize;

  $TimeRemaining = ($TotalBursts * $BurstTime) + ($AfterBursts*$RealWait);

  if ($TimeRemaining < ($TotalEmails*$RealWait) )  {

    $TimeRemaining = $TotalEmails*$RealWait;

  }

  $_SESSION[$EmailRef."_Total"] = $TotalEmails;

  $_SESSION[$EmailRef."_Index"] = 0;

  $_SESSION[$EmailRef."_Remaining"] = $TimeRemaining;

  while ($RecipIndex < sizeof($RecipArray))  {

    $EnteredValue = is_string($RecipArray[$RecipIndex][0]);

    $CurIndex = 0;

    while (($EnteredValue && $CurIndex < sizeof($RecipArray[$RecipIndex])) || (!$EnteredValue && $RecipArray[$RecipIndex][0])) {

      $starttime = microtime_float();

      if ($EnteredValue)  {

        $RecipientEmail = $RecipArray[$RecipIndex][$CurIndex];

      }  else  {

        $RecipientEmail = $RecipArray[$RecipIndex][0][$RecipArray[$RecipIndex][2]];

      }

      $EmailsRemaining = ($TotalEmails- $LoopCount);

      $BurstsRemaining = ceil(($EmailsRemaining-$AfterBursts)/$BurstSize);

      $IntoBurst = ($EmailsRemaining-$AfterBursts) % $BurstSize;

      if ($AfterBursts<$EmailsRemaining) $IntoBurst = 0;

      $TimeRemaining = ($BurstsRemaining * $BurstTime * 60) + ((($AfterBursts<$EmailsRemaining)?$AfterBursts:$EmailsRemaining)*$RealWait) - (($AfterBursts>$EmailsRemaining)?0:($IntoBurst*$RealWait));

      if ($TimeRemaining < ($EmailsRemaining*$RealWait) )  {

        $TimeRemaining = $EmailsRemaining*$RealWait;

      }

      $CurIndex ++;

      $LoopCount ++;

      session_commit();

      session_start();

      $_SESSION[$EmailRef."_Index"] = $LoopCount;

      $_SESSION[$EmailRef."_Remaining"] = round($TimeRemaining);

      session_commit();

      wa_sleep($WaitTime);

      include("webassist/email/waue_confirm_1.php");

      $endtime = microtime_float();

      $TimeTracker[] =$endtime - $starttime;

      $RealWait = array_sum($TimeTracker)/sizeof($TimeTracker);

      if ($LoopCount % $BurstSize == 0)  {

        $TimePassed = (time() - $StartBurst);

        if ($TimePassed < ($BurstTime*60))  {

          $WaitBurst = ($BurstTime*60) -$TimePassed;

          wa_sleep($WaitBurst);

        }

        else  {

          $TimeRemaining = ($TotalEmails- $LoopCount)*$RealWait;

        }

        $StartBurst = time();

      }

      if (!$EnteredValue)  {

        $RecipArray[$RecipIndex][0] =  mysql_fetch_assoc($RecipArray[$RecipIndex][1]);

      }

    }

    $RecipIndex ++;

  }

  $_SESSION[$EmailRef."_Total"] = 0;

  $_SESSION[$EmailRef."_Index"] = 0;

  $_SESSION[$EmailRef."_Remaining"] = 0;

  session_commit();

  session_start();

  if ($GoToPage!="")     {

    header("Location: ".$GoToPage);

  }

}

?>

it is before the store cart summary code.

This means the email is being sent before the cart summary is stored. the order number session is created when the record is stored, so the email code needs to be moved after the store cart summary code.

2/03/2011 4:26 pm | #7 danny405167

I am getting the same email twice

I moved the code that you suggested because the order id was not being added to my email. The only problem I have is that I am receiving the same email twice. They both contain the users and cart info. The only difference is that one adds the order id and the other does not.

Plus also noticed that your code has the following:
if ($LoopCount % $BurstSize == 0 {

and my is a little bit longer

if ($LoopCount % $BurstSize == 0 && $CurIndex < sizeof($RecipArray[$RecipIndex])) {

At home I get the same --> if ($LoopCount % $BurstSize == 0 { when I used my mac with cs 5. At work with my dell and cs4 I get the longer version.

The code that I generate with my mac makes the confirm to reload until I get a 500 error server. Are both code suppose to do the same function?

2/07/2011 7:49 am | #9 danny405167

I found the problem on why I was receiving the same email twice. There was a problem with the server. But I would like to know why Universal email code is written differently. On a pc with windows 7 pro and cs 4 I get this:

if ($LoopCount % $BurstSize == 0 && $CurIndex < sizeof($RecipArray[$RecipIndex])) {

but on a mac with snow leopard and cs 5 I get this:

if ($LoopCount % $BurstSize == 0 {

The second code does not work because it makes the confirm page to keep on loading and after a while it just stops working. Any ideas why?

and my is a little bit longer

if ($LoopCount % $BurstSize == 0 && $CurIndex < sizeof($RecipArray[$RecipIndex])) {

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Order number on confirmation email not showing

9/24/2010 5:36 am | #1 rikaG_510