2. PHPRunner General questions
  3. REQUEST["a"] value
This topic is locked

REQUEST["a"] value

 		11/8/2010 1:30:05 PM
PHPRunner General questions
C
 chaintm author

In 5.2. build everything worked fine in 5.3 after upgrading the project or even redoing in fresh, the following does not work anymore.


This is in the snippet.
-------------------------------------
if ($data["ItemID"]==2)

{

$value.= "<BR><INPUT class=button id=submit5 type=button value=Add_Panel name=submit6 onclick=\"var form = $('#frmAdmin1')[0];form.a.value='add a panel'; form.submit();\">";

}

else

if ($data["ItemID"]==511)

{

$value.= "<BR><INPUT class=button id=submit5 type=button value=Add_Panel name=submit6 onclick=\"var form = $('#frmAdmin1')[0];form.a.value='addpanel'; form.submit();\">";

}

else

{

$value = "<INPUT class=text id=\"quantity".$data["ItemID"]."\" type=text size=3 maxlength=3 value=1 name=\"quantity".$data["ItemID"]."\">";
$value.= "<INPUT class=button id=submit2 type=button value=Add name=submit2 onclick=\"var form = $('#frmAdmin1')[0];

form.a.value='".$data["ItemID"].",'+"."document.getElementById('quantity".$data["ItemID"]."').value; form.submit();\">";

}
--------------------------------------
This is in the event code, prior, again all worked in 5.2
--------------------------------------
// List page: Before process

//function BeforeProcessList(&$conn)
global $conn,$strTableName,$arr;

//-----------------------------------------------------------------------------------------------------------------------------------------------//

//============================= CHECK REQUEST===================================//

//-----------------------------------------------------------------------------------------------------------------------------------------------//

if (@$_REQUEST["a"]=="add a panel")

{

$str1 = "select event_time_start,event_time_end from event_times where Order_ID=".$_SESSION[$strTableName."_masterkey1"];

$rsh1 = db_query($str1,$conn);

while ($data1= db_fetch_array($rsh1))
$str3 = "select sum(Qty_Order) as total_qty from event_times where Order_ID!=".$_SESSION[$strTableName."_masterkey1"]."

and Item_ID='2'

and ".$data1["event_time_start"]." >= event_time_start

and ".$data1["event_time_start"]." <= event_time_end

and status ='1'

or Item_ID='2'

and ".$data1["event_time_end"]." >= event_time_start

and ".$data1["event_time_end"]." <= event_time_end

and status ='1'

or Item_ID='2'

and ".$data1["event_time_start"]." <= event_time_start

and ".$data1["event_time_end"]." >= event_time_end

and status ='1'";
$hrs3 = db_query($str3,$conn);

$rs3 = db_fetch_array($hrs3);
$str5 = "select ItemStockPhys from items where ItemID='2'";

$hrs5 = db_query($str5,$conn);

$rs5 = db_fetch_array($hrs5);
$data6["temp_total"] = (1+$rs3["total_qty"]);
{

if ($data6["temp_total"] > $rs5["ItemStockPhys"])

{

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=yellow><bold><MIDDLE><CENTER><big><b>NO ITEMS LEFT IN INVENTORY FOR RESERVATION FOR DATES WITHIN THIS ORDER </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=white><bold><MIDDLE><CENTER><big><b> for this order, please select another item or goto list to edit current</b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

return false;

}

else

{

$_SESSION["TEMPDATA"] = 2;

header("Location: order_items_add.php?mastertable=order_sales&masterkey1=".$_SESSION[$strTableName."_masterkey1"]);

exit();

}
}}
else
if (@$_REQUEST["a"]=="add_panel")

{

$str1 = "select event_time_start,event_time_end from event_times where Order_ID=".$_SESSION[$strTableName."_masterkey1"];

$rsh1 = db_query($str1,$conn);

while ($data1= db_fetch_array($rsh1))
$str3 = "select sum(Qty_Order) as total_qty from event_times where Order_ID!=".$_SESSION[$strTableName."_masterkey1"]."

and Item_ID='511'

and ".$data1["event_time_start"]." >= event_time_start

and ".$data1["event_time_start"]." <= event_time_end

and status ='1'

or Item_ID='511'

and ".$data1["event_time_end"]." >= event_time_start

and ".$data1["event_time_end"]." <= event_time_end

and status ='1'

or Item_ID='511'

and ".$data1["event_time_start"]." <= event_time_start

and ".$data1["event_time_end"]." >= event_time_end

and status ='1'";
$hrs3 = db_query($str3,$conn);

$rs3 = db_fetch_array($hrs3);
$str5 = "select ItemStockPhys from items where ItemID='511'";

$hrs5 = db_query($str5,$conn);

$rs5 = db_fetch_array($hrs5);
$data6["temp_total"] = (1+$rs3["total_qty"]);
{

if ($data6["temp_total"] > $rs5["ItemStockPhys"])

{

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=yellow><bold><MIDDLE><CENTER><big><b>NO ITEMS LEFT IN INVENTORY FOR RESERVATION FOR DATES WITHIN THIS ORDER </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=white><bold><MIDDLE><CENTER><big><b> for this order, please select another item or goto list to edit current</b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

return false;

}

else

{

$_SESSION["TEMPDATA"] = 511;

header("Location: order_items_add.php?mastertable=order_sales&masterkey1=".$_SESSION[$strTableName."_masterkey1"]);

exit();

}
}}
else
if (@$_REQUEST["a"]=="add_casino")

{

header("Location: order_items_casino_add.php?mastertable=order_sales&masterkey1=".$_SESSION[$strTableName."_masterkey1"]);
exit();

}
else
if (@$_REQUEST["a"]=="del")

{

echo "del disabled!";

}

else
if (@$_REQUEST["a"]=="cancel")
{

global $conn;

$str5 = "select Order_status from order_sales where Order_num =".$_SESSION[$strTableName."_masterkey1"];

$rs5 = db_query($str5,$conn);

$data5 = db_fetch_array($rs5);
if ($data5["Order_status"]!=2 or $data5["Order_status"]!=91)

//if ($data5["Order_status"]!=2)

{

global $conn;

$str = "select Order_num from order_items where Order_num =".$_SESSION[$strTableName."_masterkey1"];

$rs = CustomQuery($str);

while($data = db_fetch_array($rs))

{

//remove detail records for selected master record

$strDelete = "delete from order_items where Order_num =".$_SESSION[$strTableName."_masterkey1"];

db_exec($strDelete,$conn);

}

global $conn;

$str = "select Order_ID from event_times where Order_ID =".$_SESSION[$strTableName."_masterkey1"];

$rs = CustomQuery($str);

while($data = db_fetch_array($rs))

{

//remove detail records for selected master record

$strDelete = "delete from event_times where Order_ID =".$_SESSION[$strTableName."_masterkey1"];

db_exec($strDelete,$conn);

}

global $conn;

$str = "select Order_num from order_sales where Order_num =".$_SESSION[$strTableName."_masterkey1"];

$rs = CustomQuery($str);

while($data = db_fetch_array($rs))

{

//remove detail records for selected master record

$strDelete = "delete from order_sales where Order_num =".$_SESSION[$strTableName."_masterkey1"];

db_exec($strDelete,$conn);

}

echo "<script>alert('You Have Cancelled the Order')</script>";

echo "<script>window.location.href='order_sales_list.php?a=return';</script>";

//header("Location: order_sales_list.php?a=return");

exit();

}

else

{

echo "Unable to delete this invoice, invoice has been previously processed";

}
}
else

if (@$_REQUEST["a"]=="Make A Quote")

{

global $conn;

$str1 = "select from order_sales where Order_num=".$_SESSION[$strTableName."_masterkey1"];

$rs1 = CustomQuery($str1);

while($data1 = db_fetch_array($rs1))

$sql = "insert into quote_order_sales (Order_num,Delivery_cost) values

('".db_addslashes($_SESSION[$strTableName."_masterkey1"])."','".db_addslashes($data1["Delivery_cost"])."')";

db_exec($sql,$conn);
$str99 = "select from order_items where Order_num=".$_SESSION[$strTableName."_masterkey1"];

$rs99 = CustomQuery($str99);

while($data99 = db_fetch_array($rs99))

{

$sql99 = "insert into quote_order_items

(Order_num,ItemID,Qty_order,ItemRentalPrice,Line_comment,Sub_total,ItemThumb,Moduals) values

('".db_addslashes($data99["Order_num"])."'

,'".db_addslashes($data99["ItemID"])."'

,'".db_addslashes($data99["Qty_order"])."'

,'".db_addslashes($data99["ItemRentalPrice"])."'

,'".db_addslashes($data99["Line_comment"])."'

,'".db_addslashes($data99["Sub_total"])."'

,'".db_addslashes($data99["ItemThumb"])."'

,'".db_addslashes("1")."')";

db_exec($sql99,$conn);

}
$rs9 = CustomQuery("select sum(Sub_total) from order_items where Order_num=".$_SESSION[$strTableName."_masterkey1"]);

$data9 = db_fetch_numarray($rs9);

$strUpdate = "Update quote_order_sales set Order_sub_total=".$data9[0]." where Order_num =".$_SESSION[$strTableName."_masterkey1"];

db_exec($strUpdate,$conn);

//------------------update STATUS of ORDER_SALES------------------//

$strUpdate = "Update quote_order_sales set Order_status ='9'where Order_num =".$_SESSION[$strTableName."_masterkey1"];

db_exec($strUpdate,$conn);
//======================DELETE ORDER FROM ORDERS AS IT IS ADDED TO QUOTES ABOVE==================//

$str = "select Order_num from order_items where Order_num =".$_SESSION[$strTableName."_masterkey1"];

$rs = CustomQuery($str);

while($data = db_fetch_array($rs))

{

//remove detail records for selected master record

$strDelete = "delete from order_items where Order_num =".$_SESSION[$strTableName."_masterkey1"];

db_exec($strDelete,$conn);

}

global $conn;

$str = "select Order_ID from event_times where Order_ID =".$_SESSION[$strTableName."_masterkey1"];

$rs = CustomQuery($str);

while($data = db_fetch_array($rs))

{

//remove detail records for selected master record

$strDelete = "delete from event_times where Order_ID =".$_SESSION[$strTableName."_masterkey1"];

db_exec($strDelete,$conn);

}

global $conn;

$str = "select Order_num from order_sales where Order_num =".$_SESSION[$strTableName."_masterkey1"];

$rs = CustomQuery($str);

while($data = db_fetch_array($rs))

{

//remove detail records for selected master record

$strDelete = "delete from order_sales where Order_num =".$_SESSION[$strTableName."_masterkey1"];

db_exec($strDelete,$conn);

}

echo "<script>window.location.href='quote_order_sales_list.php';</script>";

exit();

}

else
if (@$_REQUEST["a"] && @$_REQUEST["a"]!="delete" && @$_REQUEST["a"]!="search" && @$_REQUEST["a"]!="advsearch" && @$_REQUEST["a"]!="showall")

{

$arr = explode(",",$_REQUEST["a"]);

if (count($arr)>1)

{

//-----------------------------------------------------------------------------------------------------------------------------------------------//

//============================= CHECK ORDER STATUS REQUEST===================================//

//-----------------------------------------------------------------------------------------------------------------------------------------------//

global $conn,$strTableName;

$str10 = "select Order_status from order_sales where Order_num =".$_SESSION[$strTableName."_masterkey1"];

$rs10 = CustomQuery($str10);

while($data10 = db_fetch_array($rs10))

if($data10["Order_status"]==3)

{

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=yellow><bold><MIDDLE><CENTER><big><b>ORDER WAS PREVIOUSLY CLOSED </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=white><bold><MIDDLE><CENTER><big><b>If Adjustments needed, please see managment </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

return false;

}

$str11 = "select Order_status from order_sales where Order_num =".$_SESSION[$strTableName."_masterkey1"];

$rs11 = CustomQuery($str11);

while($data11 = db_fetch_array($rs11))

if($data11["Order_status"]==4)

{

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=yellow><bold><MIDDLE><CENTER><big><b>ORDER WAS PREVIOUSLY CANCELLED </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=white><bold><MIDDLE><CENTER><big><b>If Adjustments needed, please see managment </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

return false;

}

$str12 = "select Order_status from order_sales where Order_num =".$_SESSION[$strTableName."_masterkey1"];

$rs12 = CustomQuery($str12);

while($data12 = db_fetch_array($rs12))

if($data12["Order_status"]==6)

{

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=yellow><bold><MIDDLE><CENTER><big><b>ORDER WAS PREVIOUSLY RAIN DATE CANCELLED </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=white><bold><MIDDLE><CENTER><big><b>If Adjustments needed, please see managment </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

return false;

}

$str13 = "select Order_status from order_sales where Order_num =".$_SESSION[$strTableName."_masterkey1"];

$rs13 = CustomQuery($str10);

while($data13 = db_fetch_array($rs13))

if($data13["Order_status"]==7)

{

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=yellow><bold><MIDDLE><CENTER><big><b>ORDER WAS PREVIOUSLY RAIN DATE USED </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=white><bold><MIDDLE><CENTER><big><b>If Adjustments needed, please see managment </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

return false;

}
//-----------------------------------------------------------------------------------------------------------------------------------------------//

//============================= carry over values from other tables===================================//

//-----------------------------------------------------------------------------------------------------------------------------------------------//

$str14 = "select ItemThumb from items where ItemID='".$arr[0]."'";

$rs14 = CustomQuery($str14);

$data14 = db_fetch_array($rs14);

$values ['ItemThumb'] = $data14['ItemThumb'];

$_SESSION["ItemThumb"] = $data14["ItemThumb"];
//-----------------------------------------------------------------------------------------------------------------------------------------------//

//===============query ItemID from order_items table to see if duplicate ItemID=========================***=//

//-----------------------------------------------------------------------------------------------------------------------------------------------//

$str10 = "select ItemID from order_items where Order_num=".$_SESSION[$strTableName."_masterkey1"]." and ItemID='".$arr[0]."'";

$rs10 = CustomQuery($str10);

while($data10 = db_fetch_array($rs10))

if($data10["ItemID"]!=2)

{

$str6 = "select ItemID from order_items where Order_num=".$_SESSION[$strTableName."_masterkey1"]." and ItemID='".$arr[0]."'";

$rs6 = db_query($str6,$conn);

if ($data6 = db_fetch_array($rs6))

{

{

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=white><bold><MIDDLE><CENTER><big><b>DUPLICATE ITEM for this order,

please select another item or goto list to edit current</b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

return false;

}

}

}

else
//-----------------------------------------------------------------------------------------------------------------------------------------------//

//============================= MAIN INVENTORY CHECK AVALIBILITY==============================//

//-----------------------------------------------------------------------------------------------------------------------------------------------//
//===========query from event_times for dates/inventory avaliblity when NO item is found in another order===========//

global $conn,$strTableName;

"select ItemID from order_items where Order_num=".$_SESSION[$strTableName."_masterkey1"]." and ItemID='".$arr[0]."'";
$str = "select ItemStockPhys from items where ItemID=".$arr[0]." and ItemStockPhys<'".$arr[1]."'";

$rs = db_query($str,$conn);

if ($data = db_fetch_array($rs))

{

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=white><bold><MIDDLE><CENTER><big><b>EXCEEDING CURRENT INVENTORY LEVEL for this order,

please select another item or goto list to edit current</b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

return false;

}

//===========query from event_times for dates/inventory avaliblity when item is found in another order==================//

{

$str1 = "select event_time_start,event_time_end from event_times where Order_ID=".$_SESSION[$strTableName."_masterkey1"];

$rsh1 = db_query($str1,$conn);

while ($data1= db_fetch_array($rsh1))
$str3 = "select sum(Qty_Order) as total_qty from event_times where Order_ID!=".$_SESSION[$strTableName."_masterkey1"]."

and Item_ID=".$arr[0]."

and ".$data1["event_time_start"]." >= event_time_start

and ".$data1["event_time_start"]." <= event_time_end

and status ='1'

or Item_ID=".$arr[0]."

and ".$data1["event_time_end"]." >= event_time_start

and ".$data1["event_time_end"]." <= event_time_end

and status ='1'

or Item_ID=".$arr[0]."

and ".$data1["event_time_start"]." <= event_time_start

and ".$data1["event_time_end"]." >= event_time_end

and status ='1'";
$hrs3 = db_query($str3,$conn);

$rs3 = db_fetch_array($hrs3);
$str5 = "select ItemStockPhys from items where ItemID='".$arr[0]."'";

$hrs5 = db_query($str5,$conn);

$rs5 = db_fetch_array($hrs5);
$data6["temp_total"] = ($arr[1]+$rs3["total_qty"]);
{

if ($data6["temp_total"] > $rs5["ItemStockPhys"])

{

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=yellow><bold><MIDDLE><CENTER><big><b>NO ITEMS LEFT IN INVENTORY FOR RESERVATION FOR DATES WITHIN THIS ORDER </b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=white><bold><MIDDLE><CENTER><big><b> for this order, please select another item or goto list to edit current</b></big></bold></MIDDLE></CENTER></font>";

echo "<font color=red><bold><MIDDLE><CENTER><big><b>XX____XX____XXXX </b></big></bold></MIDDLE></CENTER></font>";

return false;

}

}

}

//---------------------------------------------------------------------------------------------------------------------------------------------------//

//===============add "ORDER NUMBER / ITEM ID / QTY" into ORDER_ITEMS ============================//

//---------------------------------------------------------------------------------------------------------------------------------------------------//

{

$str117 = "select * from items where ItemID='".$arr[0]."'";

$rs117 = db_query($str117,$conn);

$data117= db_fetch_array($rs117);

$sql = "insert into order_items (Order_num,ItemID,Qty_order,ItemThumb,Moduals) values

('".db_addslashes($_SESSION[$strTableName."_masterkey1"])."','".$arr[0]."','".$arr[1]."','".$data117["ItemThumb"]."','".db_addslashes(1)."')";

db_exec($sql,$conn);

//----------------------------------------------------------------------------------------------------------------------------------------------------//

//==================================Delivery_cost added or not?=========================================//

//----------------------------------------------------------------------------------------------------------------------------------------------------//

$str7 = "select FlagID from items where ItemID='".$arr[0]."'";

$rs7 = db_query($str7,$conn);

$data7= db_fetch_array($rs7);

if($data7["FlagID"]==1)

//===========if item does have a delivery charge================//

{

$str5 = "select Delivery_cost from order_sales where Order_num=".$_SESSION[$strTableName."_masterkey1"];

$rs5 = db_query($str5,$conn);

$data5 = db_fetch_array($rs5);

$str6 = "select ItemRentalPrice from items where ItemID='".$arr[0]."'";

$rs6 = db_query($str6,$conn);

$data6 = db_fetch_array($rs6);

$strUpdate = "Update order_items set ItemRentalPrice=".$data6["ItemRentalPrice"]."

  • ".$data5["Delivery_cost"]." where ItemID=".$arr[0]." and Order_num=".$_SESSION[$strTableName."_masterkey1"];

    db_exec($strUpdate,$conn);

    //echo "delivery";//----test----//

    //echo $arr[0];

    }

    else

    //===========if item does not have a delivery charge===============//

    {

    $str7 = "select FlagID from items where ItemID='".$arr[0]."'";

    $rs7 = db_query($str7,$conn);

    $data7= db_fetch_array($rs7);

    $str2= "select ItemRentalPrice from items where ItemID='".$arr[0]."'";

    $rs2 = db_query($str2,$conn);

    $data2 = db_fetch_array($rs2);

    $strUpdate = "Update order_items set ItemRentalPrice=".$data2["ItemRentalPrice"]." where ItemID=

    ".$arr[0]." and Order_num=".$_SESSION[$strTableName."_masterkey1"];

    db_exec($strUpdate,$conn);

    //echo "no delivery";//----test----//

    //echo $arr[0];

    }

    // =========This function is used to get sub_total of items passed to the details order_items page.=======//

    $str5 = "select from order_sales where Order_num=".$_SESSION[$strTableName."_masterkey1"];

    $rs5 = db_query($str5,$conn);

    $data5 = db_fetch_array($rs5);

    if ($data5["event_time_end"]>$data5["event_time_start"])

    {

    $st["Date3"] = (($data5["event_time_end"])-($data5["event_time_start"]))/(60    6024);

    echo "positive";

    $st1["Date3"] = $st["Date3"]+1;

    echo $st1["Date3"];

    }

    else

    {

    echo "negative";

    $st1["Date3"]=1;

    }
    $data99= $arr[1];

    $str6 = "select ItemRentalPrice from order_items where ItemID=

    ".$arr[0]." and Order_num=".$_SESSION[$strTableName."_masterkey1"];

    $rs6 = db_query($str6,$conn);

    $data6 = db_fetch_array($rs6);

    $values["Sub_total"] = $data6["ItemRentalPrice"]     $arr[1] * $st1["Date3"];

    $strUpdate2 = "update order_items set Sub_total =".$values["Sub_total"]." where ItemID=

    ".$arr[0]." and Order_num=".$_SESSION[$strTableName."_masterkey1"];

    db_exec($strUpdate2,$conn);
    //--------------------------------------------------------------------------------------------------------------------------------------//

    //======================UPDATE ORDER_SALES sub total======================================//

    //--------------------------------------------------------------------------------------------------------------------------------------//

    $rs9 = CustomQuery("select sum(Sub_total) from order_items where Order_num=".$_SESSION[$strTableName."_masterkey1"]);

    $data9 = db_fetch_numarray($rs9);

    $strUpdate = "Update order_sales set Order_sub_total=".$data9[0]." where Order_num =".$_SESSION[$strTableName."_masterkey1"];

    db_exec($strUpdate,$conn);

    //------------------update STATUS of ORDER_SALES------------------//

    $strUpdate = "Update order_sales set Order_status ='9'where Order_num =".$_SESSION[$strTableName."_masterkey1"];

    db_exec($strUpdate,$conn);
    //--------------------------------------------------------------------------------------------------------------------------------------//

    //=============================UPDATE EVENT_TIMES ======================================//

    //--------------------------------------------------------------------------------------------------------------------------------------//
    //-------------------------------------insert current new record to event_times------------NO Line_Num, Modual_Type ---------------------------------//
    //---removed----('".db_addslashes($arr[0])."','".db_addslashes($arr[1])."','".db_addslashes($_SESSION[$strTableName."_masterkey1"])."','".db_addslashes($values["Line_num"])."','".db_addslashes($values["Moduals"])."')";---removed----//

    //---removed----(Item_ID,Qty_Order,Order_ID,Line_Num,Modual_type) ---removed----//

    $sql = "insert into event_times (Item_ID,Qty_Order,Order_ID,Modual_type) values

    ('".db_addslashes($arr[0])."','".db_addslashes($arr[1])."'

    ,'".db_addslashes($_SESSION[$strTableName."_masterkey1"])."'

    ,'".db_addslashes(1)."')";

    db_exec($sql,$conn);
    //============= update times on new table....... event_times table when any item is added===========//

    $str = "select event_time_start,event_time_end from order_sales where Order_num=".$_SESSION[$strTableName."_masterkey1"];

    $rs = db_query($str,$conn);

    while ($data = db_fetch_array($rs))

    {

    $str1 = "update event_times set event_time_start='".db_addslashes($data["event_time_start"])."'

    , event_time_end='".db_addslashes($data["event_time_end"])."' where Order_ID=".$_SESSION[$strTableName."_masterkey1"];

    db_exec($str1,$conn);

    }
    $str32 = "select Line_num from order_items where Order_num=".$_SESSION[$strTableName."_masterkey1"]." and ItemID='".$arr[0]."'";

    $rs32 = db_query($str32,$conn);

    while ($data32 = db_fetch_array($rs32))

    {

    $str1 = "update event_times set Line_Num='".db_addslashes($data32["Line_num"])."' where Order_ID=".$_SESSION[$strTableName."_masterkey1"];

    db_exec($str1,$conn);

    }
    //****NEEDS WORK BEFORE IMPLMENTED For MODUALS!!!!//

    //-----------------------update times event_times table when any item is added-------------------//

    //$str = "select     from order_sales where Order_num=".$_SESSION[$strTableName."_masterkey1"];

    //$rs = db_query($str,$conn);

    //while ($data = db_fetch_array($rs))

    //{

    //$str1 = "update event_times set event_time_start='".db_addslashes($data["event_time_start"])."'

    //, event_time_end='".db_addslashes($data["event_time_end"])."' where Order_ID=".$_SESSION[$strTableName."_masterkey1"];

    //db_exec($str1,$conn);

    //}

    //**    //
    //-----------------------update statues of sales-----------------------------------------------------------//

    //$strUpdate = "Update order_sales set Order_status ='9'where order_num =".$_SESSION[$strTableName."_masterkey1"];

    //db_exec($strUpdate,$conn);

    //----------------update order items line comment now start date of event----------------------//
    $str100 = "select * from order_sales where Order_num=".$_SESSION[$strTableName."_masterkey1"];

    $rs100 = db_query($str100,$conn);

    while ($data100 = db_fetch_array($rs100))

    {

    $str200 = "update order_items set Line_comment ='".db_addslashes($data100["event_time_start"])."' where Order_num =".$_SESSION[$strTableName."_masterkey1"];

    db_exec($str200,$conn);
    //-----------------update status for event_times tracking only!------------------------------------//

    $strUpdate1 = "Update event_times set Status ='1' where Order_ID=".$_SESSION[$strTableName."_masterkey1"]." and Item_ID='".$arr[0]."'";

    db_exec($strUpdate1,$conn);

    }
    //---------------------DELETE ITEMS FROM EVENT TIMES WHERE ORDER STATUS = 0----------------------//

    $str21 = "select Status from event_times where Status='0'";

    $rs21 = CustomQuery($str21);

    $data21 = db_fetch_array($rs21);

    if($data21["Status"]==0)
    $str10 = "select Order_ID from event_times where Status='0'";

    $rs10 = CustomQuery($str10);

    while($data10 = db_fetch_array($rs10))

    {

    $strDelete = "delete from event_times where Order_ID=".$data10["Order_ID"];

    db_exec($strDelete,$conn);

    }
    //=============update status and inform if order was changed======================//

    //------------------update statues of sales------------------//

    $strUpdate = "Update order_sales set Order_status ='9'where order_num =".$_SESSION[$strTableName."_masterkey1"];

    db_exec($strUpdate,$conn);
    //** Redirect to another page ****

    header("Location: order_sales_item_list_list.php?id=1&a=showall");
    //echo "subtotal done";//----test----//

    //echo $arr[0];

    return true;

    }}

    //echo "no action";//----test----//

    //echo $arr[0];

    return true;

    }
    ----------------------------------------
    Hitting the button does nothing , but rebuilding in 5.2 works fine. I bring this up to the devs here in hopes to understand what they have may changed (behind the scenes) that might have changed the issues here, be it the making a button or values of "a".
Sergey Kornilov admin 11/8/2010

I recommend to check the following articles that explains how to perform bulk actions with selected records on the list page in version 5.3.
http://xlinesoft.com/phprunner/docs/update_multiple_records.htm

http://xlinesoft.com/phprunner/docs/email_selected_records.htm
C
 		chaintm author 11/10/2010



I recommend to check the following articles that explains how to perform bulk actions with selected records on the list page in version 5.3.
http://xlinesoft.com/phprunner/docs/update_multiple_records.htm

http://xlinesoft.com/phprunner/docs/email_selected_records.htm


I hate to be the bearer of obvious news here, but what I did and the examples you are directing me to are the same thing but in a different format, both would arrive to same conclusion of the array values. Which in the end effects everything. If the arrays where changed in 5.3 along with the way jscripts work within the build this needs to be noted in release notes. We are developers here not some OS users. I didn't change anything on my side you guys changed your side. So alas guess what , it's not my problem.
If this is the new stance of replies (as it seems to be from most of the post I am reading latly) this is my last investment in this software as anything in the future will just end up being paste and copy replies with no actual thought. I can do that too, it's called MS support. Very disspointed how the quality of this product and support has gone done sense the new hire. sad, sad sad.
Thnx but no thx, back to 5.2.
Sergey Kornilov admin 11/10/2010

I'm sorry to see your disappointment, but what kind of answer you expected?
We had to change some things to make new functionality possible. Btw, what we have changed allows you to write more logical code. What was a hack in version 5.2 now is an API in version 5.3.
Instead of piling all the code in BeforeProcess event you can add a few buttons and paste your code there. You don't need to change the actual business logic code in fact.