| Main | |
| getPath( 'class' ) );
require_once( $mainframe->getPath( 'front_html' ) );
echo("");
echo("");
$task = mosGetParam( $_REQUEST, 'task' ); //Doesn't work with any of the $_GET parameters
if(!$task) {
$task = $_GET[task];
}
$act = mosGetParam( $_REQUEST, 'act' ); //Doesn't work with any of the $_GET parameters
$eid = mosGetParam( $_REQUEST, 'eid' ); //Doesn't work with any of the $_GET parameters
$check4paypal1 = mosGetParam( $_REQUEST, 'txn_type' );
$check4paypal2 = mosGetParam( $_REQUEST, 'payment_type' );
if($check4paypal1 == "web_accept" && $check4paypal2 == "instant") {
$task = "ipnWebAccept";
}
if($_GET[task] == "returnToReg" && $_GET[invnum] && $_GET[eid] && $_GET[parid]) {
$task = "returnToReg";
$invnum = $_GET[invnum];
$eid = $_GET[eid];
$parid = $_GET[parid];
}
switch($task) {
case 'registerSelectGuests':
HTML_gorseddregistry::registerSelectGuests($eid);
break;
case 'registerPrimaryGuestInfo':
$adultcnt = mosGetParam( $_REQUEST, 'adultcnt' );
$childcnt = mosGetParam( $_REQUEST, 'childcnt' );
$toddlercnt = mosGetParam( $_REQUEST, 'toddlercnt' );
HTML_gorseddregistry::registerPrimaryGuestInfo($eid,$adultcnt,$childcnt,$toddlercnt);
break;
case 'registerSecondaryGuestsInfo':
$adultcnt = mosGetParam( $_REQUEST, 'adultcnt' );
$childcnt = mosGetParam( $_REQUEST, 'childcnt' );
$toddlercnt = mosGetParam( $_REQUEST, 'toddlercnt' );
cachePrimary($eid,$adultcnt,$childcnt,$toddlercnt);
break;
case 'selectHousingInfo':
$adultcnt = mosGetParam( $_REQUEST, 'adultcnt' );
$childcnt = mosGetParam( $_REQUEST, 'childcnt' );
$toddlercnt = mosGetParam( $_REQUEST, 'toddlercnt' );
$parid = mosGetParam( $_REQUEST, 'parid' );
createMembers($eid,$adultcnt,$childcnt,$toddlercnt,$parid);
break;
case 'selectPaymentInfo':
$adultcnt = mosGetParam( $_REQUEST, 'adultcnt' );
$childcnt = mosGetParam( $_REQUEST, 'childcnt' );
$toddlercnt = mosGetParam( $_REQUEST, 'toddlercnt' );
$parid = mosGetParam( $_REQUEST, 'parid' );
insertHousingOptions($eid,$adultcnt,$childcnt,$toddlercnt,$parid);
break;
case 'doEditPrimary':
$adultcnt = mosGetParam( $_REQUEST, 'adultcnt' );
$childcnt = mosGetParam( $_REQUEST, 'childcnt' );
$toddlercnt = mosGetParam( $_REQUEST, 'toddlercnt' );
$parid = mosGetParam( $_REQUEST, 'parid' );
$invnum = mosGetParam( $_REQUEST, 'invnum' );
$mid = mosGetParam( $_REQUEST, 'mid' );
HTML_gorseddregistry::showEditPrimary($eid,$adultcnt,$childcnt,$toddlercnt,$parid,$invnum,$mid);
break;
case 'doEditPrimarySave':
$adultcnt = mosGetParam( $_REQUEST, 'adultcnt' );
$childcnt = mosGetParam( $_REQUEST, 'childcnt' );
$toddlercnt = mosGetParam( $_REQUEST, 'toddlercnt' );
$parid = mosGetParam( $_REQUEST, 'parid' );
$invnum = mosGetParam( $_REQUEST, 'invnum' );
$mid = mosGetParam( $_REQUEST, 'mid' );
editPrimarySave($eid,$invnum,$adultcnt,$childcnt,$toddlercnt,$parid,$mid);
break;
case 'doEditMember':
$adultcnt = mosGetParam( $_REQUEST, 'adultcnt' );
$childcnt = mosGetParam( $_REQUEST, 'childcnt' );
$toddlercnt = mosGetParam( $_REQUEST, 'toddlercnt' );
$parid = mosGetParam( $_REQUEST, 'parid' );
$invnum = mosGetParam( $_REQUEST, 'invnum' );
$mid = mosGetParam( $_REQUEST, 'mid' );
HTML_gorseddregistry::showEditMember($eid,$adultcnt,$childcnt,$toddlercnt,$parid,$invnum,$mid);
break;
case 'doEditMemberSave':
$adultcnt = mosGetParam( $_REQUEST, 'adultcnt' );
$childcnt = mosGetParam( $_REQUEST, 'childcnt' );
$toddlercnt = mosGetParam( $_REQUEST, 'toddlercnt' );
$parid = mosGetParam( $_REQUEST, 'parid' );
$invnum = mosGetParam( $_REQUEST, 'invnum' );
$mid = mosGetParam( $_REQUEST, 'mid' );
editMemberSave($eid,$invnum,$adultcnt,$childcnt,$toddlercnt,$parid,$mid);
break;
case 'doDeleteMember':
$adultcnt = mosGetParam( $_REQUEST, 'adultcnt' );
$childcnt = mosGetParam( $_REQUEST, 'childcnt' );
$toddlercnt = mosGetParam( $_REQUEST, 'toddlercnt' );
$parid = mosGetParam( $_REQUEST, 'parid' );
$invnum = mosGetParam( $_REQUEST, 'invnum' );
$mid = mosGetParam( $_REQUEST, 'mid' );
HTML_gorseddregistry::showDeleteMember($eid,$adultcnt,$childcnt,$toddlercnt,$parid,$invnum,$mid);
break;
case 'deleteMemberConf':
$adultcnt = mosGetParam( $_REQUEST, 'adultcnt' );
$childcnt = mosGetParam( $_REQUEST, 'childcnt' );
$toddlercnt = mosGetParam( $_REQUEST, 'toddlercnt' );
$parid = mosGetParam( $_REQUEST, 'parid' );
$invnum = mosGetParam( $_REQUEST, 'invnum' );
$mid = mosGetParam( $_REQUEST, 'mid' );
deleteMemberConf($eid,$adultcnt,$childcnt,$toddlercnt,$parid,$invnum,$mid);
break;
case 'payByCheck':
$parid = mosGetParam( $_REQUEST, 'parid' );
$invnum = mosGetParam( $_REQUEST, 'invnum' );
$eid = mosGetParam( $_REQUEST, 'eid' );
holdingForCheck($eid,$parid,$invnum);
break;
case 'cancelReg':
$parid = mosGetParam( $_REQUEST, 'parid' );
$invnum = mosGetParam( $_REQUEST, 'invnum' );
$eid = mosGetParam( $_REQUEST, 'eid' );
cancelRegistration($eid,$parid,$invnum);
break;
case 'returnToReg':
$parid = $_GET[parid];
$invnum = $_GET[invnum];
$eid = $_GET[eid];
HTML_gorseddregistry::registerConfirmPayment($eid,$parid,$invnum);
break;
case 'ipnWebAccept':
$invnum = mosGetParam( $_REQUEST, 'invoice' );
ipnWebAccept($invnum);
break;
case 'wilsOverrides':
$parid = mosGetParam( $_REQUEST, 'parid' );
$invnum = mosGetParam( $_REQUEST, 'invnum' );
$eid = mosGetParam( $_REQUEST, 'eid' );
wilsOverrides($eid,$parid,$invnum);
break;
case 'showevent':
// Show the event details
if(is_numeric($eid)) {
HTML_gorseddregistry::displayEvent($eid);
} else {
exit;
}
break;
default:
// Perhaps display some data, etc
HTML_gorseddregistry::listPublished($message=0);
break;
}
function cachePrimary($eid,$adultcnt,$childcnt,$toddlercnt) {
global $database;
$row = new GorseddRegistryMembers($database);
// bind it to the table
if (!$row -> bind($_POST)) {
echo "\n";
exit();
}
// store it in the db
if (!$row -> store()) {
echo "\n";
exit();
}
$storeid = mysql_insert_id();
$row->load( $storeid );
$row->set( 'parid', $storeid );
$row->store();
if($adultcnt >= 2 || $childcnt >= 1 || $toddlercnt >= 1) {
HTML_gorseddregistry::registerSecondaryGuestsInfo($eid,$adultcnt,$childcnt,$toddlercnt,$storeid);
} else {
HTML_gorseddregistry::registerSelectHousing($eid,$adultcnt,$childcnt,$toddlercnt,$storeid);
}
}
function createMembers($eid,$adultcnt,$childcnt,$toddlercnt,$parid) {
global $database, $_REQUEST, $_POST;
$database->setQuery("SELECT * FROM #__gorseddregistry_members WHERE mid = '$parid' LIMIT 1");
$primaryrows = $database->loadObjectList();
$primaryrow = $primaryrows[0];
if($adultcnt >= 2) {
$newadultcnt = ($adultcnt-1);
for($i=0; $i<$newadultcnt; $i++) {
$alabel = ($i + 2);
$ADULTGUEST = Array(
"parid" => $parid,
"firstname" => $_POST['Adult'.$alabel.'_firstname'],
"lastname" => $_POST['Adult'.$alabel.'_lastname'],
"akaname" => $_POST['Adult'.$alabel.'_akaname'],
"address" => $_POST['Adult'.$alabel.'_address'],
"city" => $_POST['Adult'.$alabel.'_city'],
"state" => $_POST['Adult'.$alabel.'_state'],
"zipcode" => $_POST['Adult'.$alabel.'_zipcode'],
"email" => $_POST['Adult'.$alabel.'_email'],
"phone" => $_POST['Adult'.$alabel.'_phone'],
"relation" => $_POST['Adult'.$alabel.'_relation'],
"physicallimits" => $_POST['Adult'.$alabel.'_physicallimits'],
"instrument" => $_POST['Adult'.$alabel.'_instrument'],
"othertalent" => $_POST['Adult'.$alabel.'_othertalent'],
"storyteller" => $_POST['Adult'.$alabel.'_storyteller'],
"groveseed" => $_POST['Adult'.$alabel.'_groveseed'],
"obod" => $_POST['Adult'.$alabel.'_obod'],
"obodyrs" => $_POST['Adult'.$alabel.'_obodyrs'],
"obodgrade" => $_POST['Adult'.$alabel.'_obodgrade'],
"otherorder" => $_POST['Adult'.$alabel.'_otherorder'],
"othertrads" => $_POST['Adult'.$alabel.'_othertrads'],
"housing" => "",
"agerange" => "adult",
"eid" => $eid
);
$row = new GorseddRegistryMembers($database);
// bind it to the table
if (!$row -> bind($ADULTGUEST)) {
echo "\n";
echo(" ".$row->getError()); exit(); } // store it in the db if (!$row -> store()) { echo "\n"; exit(); } } } if($childcnt >= 1) { for($i=0; $i<$childcnt; $i++) { $clabel = ($i + 1); $CHILDGUEST = Array( "parid" => $parid, "firstname" => $_POST['Child'.$clabel.'_firstname'], "lastname" => $_POST['Child'.$clabel.'_lastname'], "akaname" => $_POST['Child'.$clabel.'_akaname'], "address" => $_POST['Child'.$clabel.'_address'], "city" => $_POST['Child'.$clabel.'_city'], "state" => $_POST['Child'.$clabel.'_state'], "zipcode" => $_POST['Child'.$clabel.'_zipcode'], "email" => "No Email", "phone" => $primaryrow->phone, "relation" => $_POST['Child'.$clabel.'_relation'], "physicallimits" => $_POST['Child'.$clabel.'_physicallimits'], "instrument" => $_POST['Child'.$clabel.'_instrument'], "othertalent" => $_POST['Child'.$clabel.'_othertalent'], "storyteller" => "0", "groveseed" => $primaryrow->groveseed, "obod" => "0", "obodyrs" => "0", "obodgrade" => "None", "otherorder" => "None", "othertrads" => "None", "housing" => "", "agerange" => "child", "eid" => $eid ); $row = new GorseddRegistryMembers($database); // bind it to the table if (!$row -> bind($CHILDGUEST)) { //echo "\n"; echo(" ".$row->getError()); exit(); } // store it in the db if (!$row -> store()) { echo "\n"; exit(); } } } if($toddlercnt >= 1) { for($i=0; $i<$toddlercnt; $i++) { $tlabel = ($i + 1); $TODDLERGUEST = Array( "parid" => $parid, "firstname" => $_POST['Toddler'.$tlabel.'_firstname'], "lastname" => $_POST['Toddler'.$tlabel.'_lastname'], "akaname" => $_POST['Toddler'.$tlabel.'_akaname'], "address" => $primaryrow->address, "city" => $primaryrow->city, "state" => $primaryrow->state, "zipcode" => $primaryrow->zipcode, "email" => "No Email", "phone" => $primaryrow->phone, "relation" => $_POST['Toddler'.$tlabel.'_relation'], "physicallimits" => $_POST['Toddler'.$tlabel.'_physicallimits'], "instrument" => "", "othertalent" => "", "storyteller" => "0", "groveseed" => $primaryrow->groveseed, "obod" => "0", "obodyrs" => "0", "obodgrade" => "None", "otherorder" => "None", "othertrads" => "None", "housing" => "", "agerange" => "toddler", "eid" => $eid ); $row = new GorseddRegistryMembers($database); // bind it to the table if (!$row -> bind($TODDLERGUEST)) { echo "\n"; echo(" ".$row->getError()); exit(); } // store it in the db if (!$row -> store()) { echo "\n"; exit(); } } } HTML_gorseddregistry::registerSelectHousing($eid,$adultcnt,$childcnt,$toddlercnt,$parid); } function insertHousingOptions($eid,$adultcnt,$childcnt,$toddlercnt,$parid) { global $database, $_REQUEST, $_POST; //Build invoice number $database->setQuery("SELECT * FROM #__gorseddregistry_events WHERE eid = '$eid' LIMIT 1"); $eventrows = $database->loadObjectList(); $eventrow = $eventrows[0]; $yrsplit = split(" ",$eventrow->startdate); $eventyear = split("-",$yrsplit[0]); $myReg = new GorseddRegistryRegister( $database ); $REGISTRATION = Array( "rid" => "", "invnum" => "", "eid" => $eid, "parid" => $parid, "guests" => "", "total" => "", "paypal" => "", "housenotes" => "", "status" => "started" ); if (!$myReg -> bind($REGISTRATION)) { echo "\n"; echo(" ".$myReg->getError()); //exit(); } // store it in the db if (!$myReg -> store()) { echo "\n"; //exit(); } $regid = mysql_insert_id(); $invnum = $eventyear[0] * 10000 + 1000 + $regid; $myReg->load($regid); $myReg->set( 'invnum', $invnum ); $myReg->store(); $myTbl = new GorseddRegistryMembers( $database ); $myTbl->load( $parid ); $myTbl->set( 'housing', $_POST[primaryhousing] ); $myTbl->store(); $myBask = new GorseddRegistryBaskets( $database ); $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $parid, "pid" => $parid, "eid" => $eid, "type" => "registration", "itemname" => "adult", "price" => $eventrow->adultcost ); $invtotal = ($invtotal + $eventrow->adultcost); if (!$myBask -> bind($basket)) { echo $myBask -> getError(); exit; } if (!$myBask -> store()) { echo $myBask -> getError(); exit; } $housing = $_POST[primaryhousing]; if($housing == "Upgrade to a bed in a lodge (add $".$eventrow->lodgebedcost.")") { $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $parid, "pid" => $parid, "eid" => $eid, "type" => "housing", "itemname" => "lodge", "price" => $eventrow->lodgebedcost ); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + $eventrow->lodgebedcost); } elseif($housing == "Upgrade to a bed in a cabin (add $".$eventrow->cabinbedcost.")") { $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $parid, "pid" => $parid, "eid" => $eid, "type" => "housing", "itemname" => "cabin", "price" => $eventrow->cabinbedcost ); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + $eventrow->cabinbedcost); } elseif($housing == "Upgrade to a bed in a room (add $".$eventrow->roombedcost.")") { $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $parid, "pid" => $parid, "eid" => $eid, "type" => "housing", "itemname" => "room", "price" => $eventrow->roombedcost ); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + $eventrow->roombedcost); } if($_POST[addshuttle]) { $shuttlecost = $eventrow->shuttlecost * $_POST[addshuttle]; $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $parid, "pid" => $parid, "eid" => $eid, "type" => "additional", "itemname" => "shuttle", "price" => $shuttlecost); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + $shuttlecost); } if($_POST[addparking]) { $parkingcost = $eventrow->parkingcost * $_POST[addparking]; $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $parid, "pid" => $parid, "eid" => $eid, "type" => "additional", "itemname" => "parking", "price" => $parkingcost); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + $parkingcost); } $guestlist = ""; //Primary is finished. Reduce adultcnt. $adultcnt--; $newadultcnt = $adultcnt; for($i=0; $i<$newadultcnt; $i++) { $alabel = ($i + 2); $myTbl = new GorseddRegistryMembers( $database ); $myTbl->load( $_POST['Adult_'.$alabel] ); $housing = $_POST['Adult_'.$alabel.'_housing']; $myTbl->set( 'housing', $housing ); $myTbl->store(); $mid = $_POST['Adult_'.$alabel]; $myBask = new GorseddRegistryBaskets( $database ); $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $mid, "pid" => $parid, "eid" => $eid, "type" => "registration", "itemname" => "adult", "price" => $eventrow->adultcost ); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + $eventrow->adultcost); if($housing == "Upgrade to a bed in a lodge (add $".$eventrow->lodgebedcost.")") { $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $mid, "pid" => $parid, "eid" => $eid, "type" => "housing", "itemname" => "lodge", "price" => $eventrow->lodgebedcost ); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + $eventrow->lodgebedcost); } elseif($housing == "Upgrade to a bed in a cabin (add $".$eventrow->cabinbedcost.")") { $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $mid, "pid" => $parid, "eid" => $eid, "type" => "housing", "itemname" => "cabin", "price" => $eventrow->cabinbedcost ); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + $eventrow->cabinbedcost); } elseif($housing == "Upgrade to a bed in a room (add $".$eventrow->roombedcost.")") { $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $mid, "pid" => $parid, "eid" => $eid, "type" => "housing", "itemname" => "room", "price" => $eventrow->roombedcost ); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + $eventrow->roombedcost); } $guestlist.= $mid.","; } //Done with adults increase adultcnt to where it was. $adultcnt++; $newchildcnt = $childcnt; for($i=0; $i<$newchildcnt; $i++) { $clabel = ($i + 1); $myTbl = new GorseddRegistryMembers( $database ); $myTbl->load( $_POST['Child_'.$clabel] ); $housing = $_POST['Child_'.$clabel.'_housing']; $myTbl->set( 'housing', $housing ); $myTbl->store(); $mid = $_POST['Child_'.$clabel]; $myBask = new GorseddRegistryBaskets( $database ); $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $mid, "pid" => $parid, "eid" => $eid, "type" => "registration", "itemname" => "child", "price" => $eventrow->childcost ); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + $eventrow->childcost); if($housing == "Upgrade to a bed in a lodge (add $".($eventrow->lodgebedcost / 2).".00)") { $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $mid, "pid" => $parid, "eid" => $eid, "type" => "housing", "itemname" => "lodge", "price" => ($eventrow->lodgebedcost / 2) ); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + ($eventrow->lodgebedcost / 2)); } elseif($housing == "Upgrade to a bed in a cabin (add $".($eventrow->cabinbedcost / 2).".00)") { $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $mid, "pid" => $parid, "eid" => $eid, "type" => "housing", "itemname" => "cabin", "price" => ($eventrow->cabinbedcost / 2) ); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + ($eventrow->cabinbedcost / 2)); } elseif($housing == "Upgrade to a bed in a room (add $".($eventrow->roombedcost / 2).".00)") { $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $mid, "pid" => $parid, "eid" => $eid, "type" => "housing", "itemname" => "room", "price" => ($eventrow->roombedcost / 2) ); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + ($eventrow->roombedcost / 2)); } $guestlist.= $mid.","; } $newtoddlercnt = $toddlercnt; for($i=0; $i<$newtoddlercnt; $i++) { $tlabel = ($i + 1); $myTbl = new GorseddRegistryMembers( $database ); $myTbl->load( $_POST['Toddler_'.$tlabel] ); $myTbl->set( 'housing', $_POST['Toddler_'.$tlabel.'_housing'] ); $myTbl->store(); $mid = $_POST['Toddler_'.$tlabel]; $myBask = new GorseddRegistryBaskets( $database ); $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $mid, "pid" => $parid, "eid" => $eid, "type" => "registration", "itemname" => "toddler", "price" => $eventrow->toddlercost ); $myBask -> bind($basket); $myBask -> store(); $invtotal = ($invtotal + $eventrow->toddlercost); $guestlist.= $mid.","; } $guests = chop($guestlist, ","); $myReg->load($regid); $myReg->set( 'guests', $guests ); $myReg->set( 'total', $invtotal ); $myReg->set( 'housenotes', $_POST[housecomments]); $myReg->store(); HTML_gorseddregistry::registerConfirmPayment($eid,$parid,$invnum); /*echo(" ");
print_r($_POST);
echo("");*/
}
function editPrimarySave($eid,$invnum,$adultcnt,$childcnt,$toddlercnt,$parid,$mid) {
global $database, $_REQUEST, $_POST;
$PRIMARY = Array(
"parid" => $mid,
"firstname" => $_POST[firstname],
"lastname" => $_POST[lastname],
"akaname" => $_POST[akaname],
"address" => $_POST[address],
"city" => $_POST[city],
"state" => $_POST[state],
"zipcode" => $_POST[zipcode],
"email" => $_POST[email],
"phone" => $_POST[phone],
"relation" => $_POST[relation],
"physicallimits" => $_POST[physicallimits],
"instrument" => $_POST[instrument],
"othertalent" => $_POST[othertalent],
"storyteller" => $_POST[storyteller],
"groveseed" => $_POST[groveseed],
"obod" => $_POST[obod],
"obodyrs" => $_POST[obodyrs],
"obodgrade" => $_POST[obodgrade],
"otherorder" => $_POST[otherorder],
"othertrads" => $_POST[othertrads],
"housing" => $_POST[housing],
"agerange" => $_POST[agerange],
"eid" => $eid
);
$myMem = new GorseddRegistryMembers($database);
$myMem->load( $_POST[mid] );
if (!$myMem -> bind($PRIMARY)) {
echo "\n";
echo("".$myMem->getError()); //exit(); } // store it in the db if (!$myMem -> store()) { echo "\n"; //exit(); } $mid = $_POST[mid]; $housing = $_POST[housing]; if($_POST[housing] != $_POST[prehousing]) { $database->setQuery("SELECT baskid FROM #__gorseddregistry_baskitems WHERE mid = '$mid' AND type = 'housing' AND eid = '$eid'"); $delbaskets = $database->loadObjectList(); foreach($delbaskets as $delbask) { $delrow = new GorseddRegistryBaskets( $database ); if (!$delrow->delete( $delbask->baskid )) { mosErrorAlert( $delrow->getError()); } } $database->setQuery("SELECT * FROM #__gorseddregistry_events WHERE eid = '$eid' LIMIT 1"); $eventrows = $database->loadObjectList(); $eventrow = $eventrows[0]; $myBask = new GorseddRegistryBaskets( $database ); if($housing == "Upgrade to a bed in a lodge (add $".$eventrow->lodgebedcost.")") { $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $mid, "pid" => $mid, "eid" => $eid, "type" => "housing", "itemname" => "lodge", "price" => $eventrow->lodgebedcost ); $myBask -> bind($basket); $myBask -> store(); } elseif($housing == "Upgrade to a bed in a cabin (add $".$eventrow->cabinbedcost.")") { $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $mid, "pid" => $mid, "eid" => $eid, "type" => "housing", "itemname" => "cabin", "price" => $eventrow->cabinbedcost ); $myBask -> bind($basket); $myBask -> store(); } elseif($housing == "Upgrade to a bed in a room (add $".$eventrow->roombedcost.")") { $basket = Array("baskid" => "", "invnum" => $invnum, "mid" => $mid, "pid" => $mid, "eid" => $eid, "type" => "housing", "itemname" => "room", "price" => $eventrow->roombedcost ); $myBask -> bind($basket); $myBask -> store(); } $database->setQuery("SELECT price FROM #__gorseddregistry_baskitems WHERE invnum = '$invnum' AND eid = '$eid'"); $baskprices = $database->loadObjectList(); foreach($baskprices as $price) { $newregtotal = ($newregtotal + $price->price); } $database->setQuery("SELECT rid FROM #__gorseddregistry_register WHERE invnum = '$invnum' AND eid = '$eid' LIMIT 1"); $thisregister = $database->loadObjectList(); $thisregnumber = $thisregister[0]; $myReg = new GorseddRegistryRegister($database); $myReg->load($thisregnumber->rid); $myReg->set( 'total', $newregtotal ); $myReg->store(); } HTML_gorseddregistry::registerConfirmPayment($eid,$mid,$invnum); } function editMemberSave($eid,$invnum,$adultcnt,$childcnt,$toddlercnt,$parid,$mid) { global $database, $_REQUEST, $_POST; $database->setQuery("SELECT * FROM #__gorseddregistry_members WHERE mid = '$parid' LIMIT 1"); $primaryrows = $database->loadObjectList(); $primaryrow = $primaryrows[0]; if($_POST[agerange] == "adult") { $MEMBER = Array( "parid" => $_POST[parid], "firstname" => $_POST[firstname], "lastname" => $_POST[lastname], "akaname" => $_POST[akaname], "address" => $_POST[address], "city" => $_POST[city], "state" => $_POST[state], "zipcode" => $_POST[zipcode], "email" => $_POST[email], "phone" => $_POST[phone], "relation" => $_POST[relation], "physicallimits" => $_POST[physicallimits], "instrument" => $_POST[instrument], "othertalent" => $_POST[othertalent], "storyteller" => $_POST[storyteller], "groveseed" => $_POST[groveseed], "obod" => $_POST[obod], "obodyrs" => $_POST[obodyrs], "obodgrade" => $_POST[obodgrade], "otherorder" => $_POST[otherorder], "othertrads" => $_POST[othertrads], "housing" => $_POST[housing], "agerange" => $_POST[agerange], "eid" => $eid ); } elseif($_POST[agerange] == "child") { $MEMBER = Array( "parid" => $_POST[parid], "firstname" => $_POST[firstname], "lastname" => $_POST[lastname], "akaname" => $_POST[akaname], "address" => $_POST[address], "city" => $_POST[city], "state" => $_POST[state], "zipcode" => $_POST[zipcode], "email" => "No Email", "phone" => $_POST[phone], "relation" => $_POST[relation], "physicallimits" => $_POST[physicallimits], "instrument" => $_POST[instrument], "othertalent" => $_POST[othertalent], "storyteller" => "0", "groveseed" => $primaryrow->groveseed, "obod" => "0", "obodyrs" => "0", "obodgrade" => "None", "otherorder" => "None", "othertrads" => "None", "housing" => $_POST[housing], "agerange" => $_POST[agerange], "eid" => $eid ); } elseif($_POST[agerange] == "toddler") { $MEMBER = Array( "parid" => $_POST[parid], "firstname" => $_POST[firstname], "lastname" => $_POST[lastname], "akaname" => $_POST[akaname], "address" => $primaryrow->address, "city" => $primaryrow->city, "state" => $primaryrow->state, "zipcode" => $primaryrow->zipcode, "email" => "No Email", "phone" => $primaryrow->phone, "relation" => $_POST[relation], "physicallimits" => $_POST[physicallimits], "instrument" => "", "othertalent" => "", "storyteller" => "0", "groveseed" => $primaryrow->groveseed, "obod" => "0", "obodyrs" => "0", "obodgrade" => "None", "otherorder" => "None", "othertrads" => "None", "housing" => $_POST[housing], "agerange" => $_POST[agerange], "eid" => $eid ); } $myMem = new GorseddRegistryMembers($database); $myMem->load( $mid ); if (!$myMem -> bind($MEMBER)) { echo "\n"; echo(" ".$myMem->getError()); //exit(); } // store it in the db if (!$myMem -> store()) { echo "\n"; //exit(); } $housing = $_POST[housing]; if($_POST[housing] != $_POST[prehousing]) { $database->setQuery("SELECT baskid FROM #__gorseddregistry_baskitems WHERE mid = '$mid' AND type = 'housing' AND eid = '$eid'"); $delbaskets = $database->loadObjectList(); foreach($delbaskets as $delbask) { $delrow = new GorseddRegistryBaskets( $database ); if (!$delrow->delete( $delbask->baskid )) { mosErrorAlert( $delrow->getError()); } } $database->setQuery("SELECT * FROM #__gorseddregistry_events WHERE eid = '$eid' LIMIT 1"); $eventrows = $database->loadObjectList(); $eventrow = $eventrows[0]; $myBask = new GorseddRegistryBaskets( $database ); $childlodgecost = ($eventrow->lodgebedcost / 2); $childlodgecost = sprintf("%01.2f", $childlodgecost); $childcabincost = ($eventrow->cabinbedcost / 2); $childcabincost = sprintf("%01.2f", $childcabincost); $childroomcost = ($eventrow->roombedcost / 2); $childroomcost = sprintf("%01.2f", $childroomcost); if($housing == "Upgrade to a bed in a lodge (add $".$eventrow->lodgebedcost.")" || $housing == "Upgrade to a bed in a lodge (add $".$childlodgecost.")") { if($_POST[agerange] == "child") { $lodgeprice = sprintf("%01.2f", ($eventrow->lodgebedcost / 2)); } else { $lodgeprice = sprintf("%01.2f", $eventrow->lodgebedcost); } $basket = Array("invnum" => $invnum, "mid" => $mid, "pid" => $mid, "eid" => $eid, "type" => "housing", "itemname" => "lodge", "price" => $lodgeprice ); $myBask -> bind($basket); $myBask -> store(); $changetotal = ($changetotal + $eventrow->lodgebedcost); } elseif($housing == "Upgrade to a bed in a cabin (add $".$eventrow->cabinbedcost.")" || $housing == "Upgrade to a bed in a cabin (add $".$childcabincost.")") { if($_POST[agerange] == "child") { $cabinprice = sprintf("%01.2f", ($eventrow->cabinbedcost / 2)); } else { $cabinprice = sprintf("%01.2f", $eventrow->cabinbedcost); } $basket = Array("invnum" => $invnum, "mid" => $mid, "pid" => $mid, "eid" => $eid, "type" => "housing", "itemname" => "cabin", "price" => $cabinprice ); $myBask -> bind($basket); $myBask -> store(); $changetotal = ($changetotal + $eventrow->cabinbedcost); } elseif($housing == "Upgrade to a bed in a room (add $".$eventrow->roombedcost.")" || $housing == "Upgrade to a bed in a room (add $".$childroomcost.")") { if($_POST[agerange] == "child") { $roomprice = sprintf("%01.2f", ($eventrow->roombedcost / 2)); } else { $roomprice = sprintf("%01.2f", $eventrow->roombedcost); } $basket = Array("invnum" => $invnum, "mid" => $mid, "pid" => $mid, "eid" => $eid, "type" => "housing", "itemname" => "room", "price" => $roomprice ); $myBask -> bind($basket); $myBask -> store(); $changetotal = ($changetotal + $eventrow->roombedcost); } $database->setQuery("SELECT price FROM #__gorseddregistry_baskitems WHERE invnum = '$invnum' AND eid = '$eid'"); $baskprices = $database->loadObjectList(); foreach($baskprices as $price) { $newregtotal = ($newregtotal + $price->price); } $database->setQuery("SELECT rid FROM #__gorseddregistry_register WHERE invnum = '$invnum' AND eid = '$eid' LIMIT 1"); $thisregister = $database->loadObjectList(); $thisregnumber = $thisregister[0]; $myReg = new GorseddRegistryRegister($database); $myReg->load($thisregnumber->rid); $myReg->set( 'total', $newregtotal ); $myReg->store(); } HTML_gorseddregistry::registerConfirmPayment($eid,$parid,$invnum); } function deleteMemberConf($eid,$adultcnt,$childcnt,$toddlercnt,$parid,$invnum,$mid) { global $database, $_POST; if ($_POST[submit] == "delete" && $_POST[yesdelete]) { //Deleting Registration from Baskets..... $database->setQuery("SELECT baskid FROM #__gorseddregistry_baskitems WHERE mid = '$mid' AND type = 'registration' AND eid = '$eid' AND pid = '$parid' LIMIT 1"); $delrbaskets = $database->loadObjectList(); $delrbask = $delrbaskets[0]; $delrrow = new GorseddRegistryBaskets( $database ); $delrrow->delete( $delrbask->baskid ); //Deleting Housing From Baskets..... $database->setQuery("SELECT baskid FROM #__gorseddregistry_baskitems WHERE mid = '$mid' AND type = 'housing' AND eid = '$eid' AND pid='$parid' LIMIT 1"); $delhbaskets = $database->loadObjectList(); $delhbask = $delhbaskets[0]; $delhrow = new GorseddRegistryBaskets( $database ); $delhrow->delete( $delhbask->baskid ); //Deleting Member from gorseddregistry_register Table $myMem = new GorseddRegistryMembers($database); $myMem->delete( $mid ); //Adjusting 'guests' Field In 'gorseddregistry_register' Table..... $database->setQuery("SELECT rid,guests FROM #__gorseddregistry_register WHERE eid = '$eid' AND invnum = '$invnum' LIMIT 1"); $guestlists = $database->loadObjectList(); $guestlist = $guestlists[0]; $newlist = ""; $parselist = explode(",",$guestlist->guests); foreach($parselist as $item) { if($item != $mid) { $newlist.= $item.","; } } $guests = chop($newlist, ","); //Storing the new list $myReg = new GorseddRegistryRegister( $database ); $myReg->load($guestlist->rid); $myReg->set( 'guests', $guests ); $myReg->store(); //Adjusting head counts.... if($_POST[agerange] == 'adult') { $adultcnt--; } elseif($_POST[agerange] == 'child') { $childcnt--; } elseif($_POST[agerange] == 'toddler') { $toddlercnt--; } } HTML_gorseddregistry::registerConfirmPayment($eid,$parid,$invnum); } function holdingForCheck($eid,$parid,$invnum) { global $database; //Set registration date //Change status Check_Holding $database->setQuery("SELECT rid,total FROM #__gorseddregistry_register WHERE invnum = '$invnum' AND eid='$eid' AND parid='$parid' LIMIT 1"); $regrows = $database->loadObjectList(); $regrow = $regrows[0]; $myReg = new GorseddRegistryRegister( $database ); $myReg->load($regrow->rid); $myReg->set( 'regdate', date("Y-m-d") ); $myReg->set( 'status', 'Check_Holding' ); $myReg->store(); //Deplete housing inventory //TO BE DONE $database->setQuery("SELECT lodgebeds,cabinbeds,campsites,roombeds FROM #__gorseddregistry_events WHERE eid = '$eid' LIMIT 1"); $eventrows = $database->loadObjectList(); $eventrow = $eventrows[0]; $database->setQuery("SELECT COUNT(*) as lodge FROM #__gorseddregistry_baskitems WHERE invnum = '$invnum' AND eid = '$eid' AND type='housing' AND itemname='lodge'"); $housing = $database->loadObjectList(); $hcount = $housing[0]; if($hcount->lodge) { $myEvent = new GorseddRegistryEvent( $database ); $myEvent->load($eid); $newlodgecount = $eventrow->lodgebeds - $hcount->lodge; $myEvent->set( 'lodgebeds', $newlodgecount ); $myEvent->store(); } $database->setQuery("SELECT COUNT(*) as cabin FROM #__gorseddregistry_baskitems WHERE invnum = '$invnum' AND eid = '$eid' AND type='housing' AND itemname='cabin'"); $housing = $database->loadObjectList(); $hcount = $housing[0]; if($hcount->cabin) { $myEvent = new GorseddRegistryEvent( $database ); $myEvent->load($eid); $newcabincount = $eventrow->cabinbeds - $hcount->cabin; $myEvent->set( 'cabinbeds', $newcabincount ); $myEvent->store(); } $database->setQuery("SELECT COUNT(*) as room FROM #__gorseddregistry_baskitems WHERE invnum = '$invnum' AND eid = '$eid' AND type='housing' AND itemname='room'"); $housing = $database->loadObjectList(); $hcount = $housing[0]; if($hcount->room) { $myEvent = new GorseddRegistryEvent( $database ); $myEvent->load($eid); $newroomcount = $eventrow->roombeds - $hcount->room; $myEvent->set( 'roombeds', $newroomcount ); $myEvent->store(); } $database->setQuery("SELECT COUNT(*) as campsites FROM #__gorseddregistry_members WHERE eid = '$eid' AND housing LIKE '%camping%' "); $housing = $database->loadObjectList(); $hcount = $housing[0]; if($hcount->campsites) { $myEvent = new GorseddRegistryEvent( $database ); $myEvent->load($eid); $newcampingcount = $eventrow->campsites - $hcount->campsites; $myEvent->set( 'campsites', $newcampingcount ); $myEvent->store(); } //Print out invoice and send emails sendRegistrantEmail($eid,$parid,$invnum); sendAdminEmails($eid,$parid,$invnum); HTML_gorseddregistry::printInvoiceDone($eid,$parid,$invnum); } function cancelRegistration($eid,$parid,$invnum) { global $database; $database->setQuery("SELECT rid FROM #__gorseddregistry_register WHERE invnum = '$invnum' AND eid='$eid' AND parid='$parid' LIMIT 1"); $regrows = $database->loadObjectList(); $regrow = $regrows[0]; if($regrow->rid >= 1) { $database->setQuery("SELECT baskid FROM #__gorseddregistry_baskitems WHERE invnum = '$invnum' AND eid = '$eid'"); $delbaskets = $database->loadObjectList(); foreach($delbaskets as $delbask) { $delrow = new GorseddRegistryBaskets( $database ); if (!$delrow->delete( $delbask->baskid )) { mosErrorAlert( $delrow->getError()); } } $database->setQuery("SELECT mid FROM #__gorseddregistry_members WHERE parid = '$parid' AND eid = '$eid'"); $delmembers = $database->loadObjectList(); foreach($delmembers as $delmemb) { $delrow = new GorseddRegistryMembers( $database ); if (!$delrow->delete( $delmemb->mid )) { mosErrorAlert( $delrow->getError()); } } $database->setQuery("SELECT mid FROM #__gorseddregistry_members WHERE mid = '$parid' AND parid = '$parid'"); $delprimary = $database->loadObjectList(); $primaryrow = $delprimary[0]; if($primaryrow->mid) { $delrow = new GorseddRegistryMembers( $database ); if (!$delrow->delete( $primaryrow->mid )) { mosErrorAlert( $delrow->getError()); } } $delrow = new GorseddRegistryRegister( $database ); if (!$delrow->delete( $regrow->rid )) { mosErrorAlert( $delrow->getError()); } } $message = "Registration Cancelled"; HTML_gorseddregistry::listPublished($message); } function ipnWebAccept($invnum) { global $database; $sandbox = 0; $x = fopen ("./components/com_gorseddregistry/last_transaction.txt", "w"); $sec = fopen ("./components/com_gorseddregistry/security_logfile.txt", "a"); fwrite ($x, print_r($_POST, true)); // read the post from PayPal system and add 'cmd' $req = 'cmd=_notify-validate'; foreach ($_POST as $key => $value) { $value = urlencode(stripslashes($value)); $req .= "&$key=$value"; } if ($sandbox == 0) { $url = "www.paypal.com:443"; $fp = fsockopen ("ssl://www.paypal.com", 443, $errno, $errstr, 30); } else { $url = "www.sandbox.paypal.com:443"; $fp = fsockopen ("ssl://www.sandbox.paypal.com", 443, $errno, $errstr, 30); } // post back to PayPal system to validate $header .= "POST /cgi-bin/webscr HTTP/1.0\r\n"; $header .= "Host: ".$url."\r\n"; $header .= "Content-Type: application/x-www-form-urlencoded\r\n"; $header .= "Content-Length: " . strlen($req) . "\r\n\r\n"; // assign posted variables to local variables $item_name = $_POST['item_name']; $item_number = $_POST['item_number']; $payment_status = $_POST['payment_status']; $payment_amount = $_POST['mc_gross']; $handling_amount = $_POST['handling_amount']; $payment_currency = $_POST['mc_currency']; $txn_id = $_POST['txn_id']; $receiver_email = $_POST['receiver_email']; $payer_email = $_POST['payer_email']; if($_POST[merchant_return_link]) { $returnbutton = 1; } if (!$fp) { // HTTP ERROR I'll add something here later } else { fputs ($fp, $header . $req); while (!feof($fp)) { $res = fgets ($fp, 1024); if (strcmp ($res, "VERIFIED") == 0) { // Check that txn_id has not been previously processed /*$database->setQuery("SELECT txn_id FROM #__gorseddregistry_pptrans WHERE txn_id = '$_POST[txn_id]' LIMIT 1"); $txnrows = $database->loadObjectList(); $txnrow = $txnrows[0]; if(!$_POST[merchant_return_link] && $txnrow->txn_id >= 1) { $sec_error = "TXN_ID ".$_POST[txn_id]." Already Exists! - PayPal: ".$payer_email." - IP: ".$_SERVER[REMOTE_ADDR]."\n"; echo("Error: $sec_error Security info logged and exiting!"); fwrite ($sec, "[".date("M j Y H:i:s")."] ".$sec_error); exit; } */ // Check that receiver_email is your Primary PayPal email if($sandbox) { $database->setQuery("SELECT value FROM #__gorseddregistry_conf WHERE name = 'sandboxpaypal' LIMIT 1"); } else { $database->setQuery("SELECT value FROM #__gorseddregistry_conf WHERE name = 'realtimepaypal' LIMIT 1"); } $confrows = $database->loadObjectList(); $confrow = $confrows[0]; if($confrow->value != $_POST[receiver_email]) { $sec_error = "RECEIVER_EMAIL ".$_POST[receiver_email]." Not Ours! - PayPal: ".$payer_email." - IP: ".$_SERVER[REMOTE_ADDR]."\n"; echo("Error: $sec_error Security info logged and exiting!"); fwrite ($sec, "[".date("M j Y H:i:s")."] ".$sec_error); exit; } $database->setQuery("SELECT rid,eid,parid,total FROM #__gorseddregistry_register WHERE invnum = '$invnum' LIMIT 1"); $regrows = $database->loadObjectList(); $regrow = $regrows[0]; // check that payment_amount/payment_currency are correct $thistotal = sprintf("%01.2f", $payment_amount - $handling_fee); /*if(!$sandbox) { if($regrow->total != $thistotal) { $sec_error = "TOTAL MISMATCH Spoof or Invoice Doesn't Exist! - PayPal: ".$payer_email." - IP: ".$_SERVER[REMOTE_ADDR]."\n"; echo("Error: $sec_error Security info logged and exiting!"); fwrite ($sec, "[".date("M j Y H:i:s")."] ".$sec_error); exit; } }*/ if($payment_currency != 'USD') { $sec_error = "CURRENCY SPOOF Not USD! - PayPal: ".$payer_email." - IP: ".$_SERVER[REMOTE_ADDR]."\n"; echo("Error: $sec_error Security info logged and exiting!"); fwrite ($sec, "[".date("M j Y H:i:s")."] ".$sec_error); exit; } // Check if this is a second return because the user actually clicked the return button $database->setQuery("SELECT transid FROM #__gorseddregistry_pptrans WHERE invoice = '$invnum' LIMIT 1"); $transrows = $database->loadObjectList(); $transrow = $transrows[0]; if($transrow->transid) { $myTrans = new GorseddRegistryPayPal( $database ); $myTrans->load($transrow->transid); $myTrans->set( 'return_sign', $_POST[verify_sign] ); $myTrans->store(); $transid = $transrow->transid; } else { // Insert transaction record into PayPal trans table $row = new GorseddRegistryPayPal($database); // bind it to the table if (!$row -> bind($_POST)) { fwrite ($x, $row -> getError()."\n\n"); $binderror = $row -> getError(); //exit(); } // store it in the db if (!$row -> store()) { fwrite ($x, $row -> getError()."\n\n"); $storeerror = $row -> getError(); //exit(); } $transid = mysql_insert_id(); } // check the payment_status is Completed or Pending and process payment if($payment_status == "Pending") { $myReg = new GorseddRegistryRegister( $database ); $myReg->load($regrow->rid); $myReg->set( 'regdate', date("Y-m-d") ); $myReg->set( 'handling_amount', $handling_amount ); $myReg->set( 'paypal', $payer_email ); $myReg->set( 'transid', $transid ); $myReg->set( 'status', 'PPPending' ); $myReg->store(); } elseif($payment_status == "Completed") { $myReg = new GorseddRegistryRegister( $database ); $myReg->load($regrow->rid); $myReg->set( 'regdate', date("Y-m-d") ); $myReg->set( 'handling_amount', $handling_amount ); $myReg->set( 'paypal', $payer_email ); $myReg->set( 'transid', $transid ); $myReg->set( 'status', 'Completed' ); $myReg->store(); } $myMem = new GorseddRegistryMembers( $database ); $myMem->load($regrow->parid); $myMem->set( 'paypal', $payer_email ); $myMem->store(); if(!$returnbutton) { $mail_From = "From: webmaster@houseofdanu.com"; $mail_To = "webmaster@houseofdanu.com"; $mail_Subject = "VERIFIED IPN (".$invnum.")"; $mail_Body = $req; foreach ($_POST as $key => $value){ $emailtext .= $key . " = " .$value ."\n\n"; } $emailtext.= "\n\n".$binderror."\n\n".$storeerror."\n\n"; mail($mail_To, $mail_Subject, $emailtext . "\n\n" . $mail_Body, $mail_From); } } elseif (strcmp ($res, "INVALID") == 0) { // log for manual investigation $mail_From = "From: webmaster@houseofdanu.com"; $mail_To = "webmaster@houseofdanu.com"; $mail_Subject = "INVALID IPN (".$invnum.")"; $mail_Body = $req; foreach ($_POST as $key => $value){ $emailtext .= $key . " = " .$value ."\n\n"; } $emailtext.= "\n\n".$binderror."\n\n".$storeerror."\n\n"; mail($mail_To, $mail_Subject, $emailtext . "\n\n" . $mail_Body, $mail_From); } } fclose ($fp); } fclose ($sec); fclose ($x); if($returnbutton) { // They returned so print the invoice out for them! $eid = $regrow->eid; $parid = $regrow->parid; if($sandbox) { sendRegistrantEmail($eid,$parid,$invnum); sendAdminEmails($eid,$parid,$invnum); } HTML_gorseddregistry::printInvoiceDone($eid,$parid,$invnum); } else { //Deplete any housing inventory //TO BE DONE $database->setQuery("SELECT lodgebeds,cabinbeds,campsites,roombeds FROM #__gorseddregistry_events WHERE eid = '$eid' LIMIT 1"); $eventrows = $database->loadObjectList(); $eventrow = $eventrows[0]; $database->setQuery("SELECT COUNT(*) as lodge FROM #__gorseddregistry_baskitems WHERE invnum = '$invnum' AND eid = '$eid' AND type='housing' AND itemname='lodge'"); $housing = $database->loadObjectList(); $hcount = $housing[0]; if($hcount->lodge) { $myEvent = new GorseddRegistryEvent( $database ); $myEvent->load($eid); $newlodgecount = $eventrow->lodgebeds - $hcount->lodge; $myEvent->set( 'lodgebeds', $newlodgecount ); $myEvent->store(); } $database->setQuery("SELECT COUNT(*) as cabin FROM #__gorseddregistry_baskitems WHERE invnum = '$invnum' AND eid = '$eid' AND type='housing' AND itemname='cabin'"); $housing = $database->loadObjectList(); $hcount = $housing[0]; if($hcount->cabin) { $myEvent = new GorseddRegistryEvent( $database ); $myEvent->load($eid); $newcabincount = $eventrow->cabinbeds - $hcount->cabin; $myEvent->set( 'cabinbeds', $newcabincount ); $myEvent->store(); } $database->setQuery("SELECT COUNT(*) as room FROM #__gorseddregistry_baskitems WHERE invnum = '$invnum' AND eid = '$eid' AND type='housing' AND itemname='room'"); $housing = $database->loadObjectList(); $hcount = $housing[0]; if($hcount->room) { $myEvent = new GorseddRegistryEvent( $database ); $myEvent->load($eid); $newroomcount = $eventrow->roombeds - $hcount->room; $myEvent->set( 'roombeds', $newroomcount ); $myEvent->store(); } $database->setQuery("SELECT COUNT(*) as campsites FROM #__gorseddregistry_members WHERE parid='$parid' AND eid = '$eid' AND housing LIKE '%camping%' "); $housing = $database->loadObjectList(); $hcount = $housing[0]; if($hcount->campsites) { $myEvent = new GorseddRegistryEvent( $database ); $myEvent->load($eid); $newcampingcount = $eventrow->campsites - $hcount->campsites; $myEvent->set( 'campsites', $newcampingcount ); $myEvent->store(); } sendRegistrantEmail($eid,$parid,$invnum); sendAdminEmails($eid,$parid,$invnum); } } function sendRegistrantEmail($eid,$parid,$invnum) { global $database; $database->setQuery("SELECT * FROM #__gorseddregistry_members WHERE mid='$parid' AND eid='$eid'"); $primaryrows = $database->loadObjectList(); $primaryrow = $primaryrows[0]; $database->setQuery("SELECT * FROM #__gorseddregistry_events WHERE eid='$eid'"); $eventrows = $database->loadObjectList(); $eventrow = $eventrows[0]; $mail_From = "From: \"House of Danu\"
| |