public function logex($xacttype, $description = NULL, $userix = NULL, $orderix = NULL, $eventix = NULL, $detail = NULL) { global $debug; $this->xacttype = $xacttype; if ($description) { $this->description = $description; } if ($userix) { $this->userix = $userix; } if ($orderix) { $this->orderix = $orderix; } if ($eventix) { $this->eventix = $eventix; } if ($detail) { $this->detail = $detail; } $sql = "INSERT INTO xactlog SET " . "xacttype = '{$xacttype}', "; if ($description) { $sql .= " description = '{$description}', "; } if ($userix) { $sql .= " userix = {$userix}, "; } if ($orderix) { $sql .= " orderix = {$orderix}, "; } if ($eventix) { $sql .= " eventix = {$eventix}, "; } if ($detail) { $sql .= " detail = '{$detail}', "; } $sql = substr($sql, 0, strlen($sql) - 2); if ($debug > 1) { dispsql($sql); } $result = mysql_query($sql) or die("Error logging to xactlog. " . mysql_error()); $this->xactix = mysql_insert_id(); $this->xacttime = dbgetsingleton("SELECT xacttime FROM xactlog WHERE xactix = {$this->xactix}", "xacttime"); if ($debug > 1) { echo "<pre>"; print_r($this); echo "</pre>\n"; } }
} if (!$passwd2) { $errlist .= "<li>Password again is required.</li>"; $errors++; } /* Repeat entry checks */ if ($usernm != $usernm2) { $errlist .= "<li>E-mail addresses do not match.</li>"; $errors++; } if ($passwd != $passwd2) { $errlist .= "<li>Passwords do not match.</li>"; $errors++; } /* User name uniqueness check */ $count = dbgetsingleton("SELECT COUNT(*) cnt FROM user WHERE usernm = '{$usernm}'", "cnt"); if ($count) { $errlist .= "<li>E-mail address \"{$usernm}\" has already been registered.</li>"; $errors++; } $errlist .= "</ul>\n"; if ($errors) { $presentform = 1; } else { $errlist = ""; /* Create user record */ $user = new User($usernm, $firstnm, $lastnm, $phonenbr, false, $passwd); $user->save(); $user->passwd = ""; $_SESSION["user"] = $user; echo "<p>Congratulations! You have been registered and are logged in.</p>\n";
function getEventTypeCount($eventcdptrn) { $sql = "SELECT COUNT(*) cnt FROM event WHERE eventcd LIKE '{$eventcdptrn}' AND active AND eventdt >= CURDATE()"; return dbgetsingleton($sql, "cnt"); }
$myreserved = 0; $mywaiting = 0; } /* Event header */ $price = $member ? $row->mbrprice : $row->guestprice; $eventcdpfx = substr($row->eventcd, 0, strlen($row->eventcd) - 1); if (!$row->eventgrouped) { $flag = $openings <= 0 ? "<span class='flag'>SOLD OUT</span>" : ""; printf("<h3>%s - %s %s</h3>\n", $row->eventnm, $row->fmteventdt, $flag); printf("<p style='font-size: small'>{$row->longDescription}</p>\n"); printResvPrice($member, $row->mbrprice, $row->guestprice); } else { # Special query to determine if the entire grouped event is sold out if ($eventcdpfx != $preveventcdpfx) { $gcapacity = dbgetsingleton("SELECT SUM(capacity) gcapacity " . " FROM event " . " WHERE eventcd LIKE '{$eventcdpfx}_'", "gcapacity"); $greserved = dbgetsingleton("SELECT COUNT(*) greserved " . " FROM registration r JOIN event e USING (eventix) " . " WHERE e.eventcd LIKE '{$eventcdpfx}_'", "greserved"); $flag = $greserved >= $gcapacity ? "<span class='flag'>SOLD OUT</span>" : ""; printf("<h3>%s - %s %s</h3>\n", $row->eventnm, $row->fmteventdt, $flag); $preveventcdpfx = $eventcdpfx; printf("<p>{$row->longDescription}</p>\n"); printResvPrice($member, $row->mbrprice, $row->guestprice); } } /* Event status table ** ** +----------+----------+----------+----------+----------+----------+ ** | | Reserved | Released | Openings | | Waiting | ** | Event +----------+----------+----------+ +----------+ ** | Time | Bargraph | Controls | Bargraph | ** | +--------------------------------+ +----------+ ** | | Personal Reservations | | PersWait |
$eventnm = $row['eventnm']; $eventdt = $row['eventdt']; $capacity = $row['capacity']; $mbrprice = $row['mbrprice']; $guestprice = $row['guestprice']; /* Get reservation counts */ $reserved = dbgetsingleton("SELECT COUNT(*) reserved " . " FROM registration " . " WHERE eventix = {$eventix} " . " AND NOT waiting " . " AND releasetime IS NULL", "reserved"); $released = dbgetsingleton("SELECT COUNT(*) released " . " FROM registration " . " WHERE eventix = {$eventix} " . " AND NOT waiting " . " AND releasetime IS NOT NULL", "released"); $openings = $capacity - $reserved; $waiting = dbgetsingleton("SELECT COUNT(*) waiting " . " FROM registration " . " WHERE eventix = {$eventix} AND waiting", "waiting"); /* Get personal reservation counts */ if ($usernm) { $myreserved = dbgetsingleton("SELECT COUNT(*) myreserved " . " FROM registration " . " WHERE eventix = {$eventix} " . " AND NOT waiting " . " AND userix = {$userix} " . " AND releasetime IS NULL", "myreserved"); $myreleased = dbgetsingleton("SELECT COUNT(*) myreleased " . " FROM registration " . " WHERE eventix = {$eventix} " . " AND NOT waiting " . " AND userix = {$userix} " . " AND releasetime IS NOT NULL", "myreleased"); if ($waiting) { $mywaiting = dbgetsingleton("SELECT COUNT(*) mywaiting " . " FROM registration " . " WHERE eventix = {$eventix} AND waiting AND userix = {$userix}", "mywaiting"); } } else { $myreserved = 0; $mywaiting = 0; } /* Put out one event section */ $price = $member ? $mbrprice : $guestprice; printf("<h3>%s - %s (Reservations: \$%.2f)</h3>\n", $eventnm, $eventdt, $price / $pricedivider); if (!$member) { warning(sprintf("If you were a member this reservation would only cost \$%.2f.", $mbrprice)); } echo "<table width=100%>\n"; echo "<tr><td width=50%>\n"; /* Entire event counts */ echo "<table><tr>\n";
require_once "{$TKTDIR}database.php"; require_once "{$TKTDIR}xactlog.php"; require_once "{$TKTDIR}order.php"; dbconnect(); $x = new XactLog(); $order = new Order(); $ipn = $_POST; $orderix = postvalue("invoice", NULL); $payment_status = postvalue("payment_status", NULL); $mc_gross = postvalue("mc_gross", 0.0); $userix = NULL; if ($orderix) { $order->loadByOrderIx($orderix); $userix = $order->userix; if ($userix) { $usernm = dbgetsingleton("SELECT usernm FROM user WHERE userix = {$userix}", "usernm"); } } $x->log("PP IPN Notificaton", "Unvalidated PP Notification", $userix, $orderix, NULL, print_r($_POST, true)); /* Form the response */ if (array_key_exists("test_ipn", $_POST) && $_POST["test_ipn"] == 1) { $ppurl = "https://www.sandbox.paypal.com/cgi-bin/webscr"; } else { $ppurl = "https://www.paypal.com/cgi-bin/webscr"; } $request = curl_init(); curl_setopt_array($request, array(CURLOPT_URL => $ppurl, CURLOPT_POST => TRUE, CURLOPT_POSTFIELDS => http_build_query(array("cmd" => "_notify-validate") + $_POST), CURLOPT_RETURNTRANSFER => TRUE, CURLOPT_HEADER => FALSE, CURLOPT_SSL_VERIFYPEER => TRUE)); /* Send the response */ $response = curl_exec($request); $status = curl_getinfo($request, CURLINFO_HTTP_CODE); curl_close($request);
require_once "{$TKTDIR}database.php"; require_once "DynHtmlPage2.php"; require_once "DynHtmlBlock.php"; $pageName = "Reports"; $debug = 0; $year = getvalue("year", 0); DynHtmlPage::docHeader($pageName); DynHtmlPage::header(); echo "<div class='colmask leftmenu'>\n"; loginprompt(); dbconnect(); # Report menu logic if (User::isAdmin()) { echo "<ul>\n"; echo "<li><a href='report.orderByUser.php'>Orders by User</a></li>\n"; $currseason = dbgetsingleton("SELECT season currseason FROM season WHERE startdt = (SELECT MAX(startdt) FROM season)", "currseason"); echo "<li><a href='report.membership.php?season={$currseason}'>Membership ({$currseason})</a></li>\n"; echo "<li>Event Registration\n"; echo "<ul>\n"; if ($year == 0) { $sql = "SELECT eventix, eventnm, eventdt \n\t\t\t\t\tFROM event \n\t\t\t\t\tWHERE eventdt > CURRENT_DATE - INTERVAL 7 DAY \n\t\t\t\t\tORDER BY eventdt, advstarttm"; } else { $sql = "SELECT eventix, eventnm, eventdt \n\t\t\t\t\tFROM event \n\t\t\t\t\tWHERE YEAR(eventdt) = {$year}\n\t\t\t\t\tORDER BY eventdt, advstarttm"; } $result = mysql_query($sql) or die("Error selecting from event. " . mysql_error()); while ($row = mysql_fetch_assoc($result)) { $url = "report.eventRegistration.php?eventix=" . $row['eventix']; printf("<li><a href='%s'>%s - %s</a></li>\n", $url, $row['eventdt'], $row['eventnm']); } echo "</ul></li>\n"; echo "<li>Event Registration - Historical\n";
$debug = 1; dbconnect(); /* Event table */ echo "<h1>Event Detail</h1>\n"; $sql = "SELECT r.eventix, r.userix, r.position, r.waiting, " . " e.eventnm, e.capacity, u.usernm \n" . " FROM registration r \n" . " JOIN event e ON (r.eventix = e.eventix) \n" . " JOIN user u ON (r.userix = u.userix) \n" . " ORDER BY r.eventix, r.position, r.waiting"; dispsql($sql); $res = mysql_query($sql) or die("Error during select. " . mysql_error()); $cbeventix = 0; while ($row = mysql_fetch_assoc($res)) { if ($cbeventix != $row['eventix']) { $cbeventix = $row['eventix']; $eventnm = $row['eventnm']; $capacity = $row['capacity']; $registered = dbgetsingleton("SELECT COUNT(*) registered FROM registration WHERE eventix = {$cbeventix} AND waiting = 0", "registered"); $openings = $capacity - $registered; $waiting = dbgetsingleton("SELECT COUNT(*) waiting FROM registration WHERE eventix = {$cbeventix} AND waiting = 1", "waiting"); echo "<h2>eventix {$cbeventix}, eventnm: {$eventnm}, registered: {$registered}, openings: {$openings}, waiting: {$waiting}</h2>\n"; } if ($debug) { echo "position: {$row['position']}, "; echo "userix: {$row['userix']}, "; echo "waiting: {$row['waiting']}, "; echo "usernm: {$row['usernm']}"; } else { echo $row['position'] . ": "; echo $row['usernm'] . " "; if ($row['waiting']) { echo " (waiting)"; } } echo "<br/>\n";
public function setPmtRejTime() { $sql = "UPDATE orderhdr SET \n" . " pmtrejtime = CURRENT_TIMESTAMP \n" . " WHERE orderix = {$this->orderix}"; dispsql($sql); $result = mysql_query($sql) or die("Error updating Order payment rejection timestamp. " . mysql_error()); $this->pmtrejtime = dbgetsingleton("SELECT pmtrejtime FROM orderhdr WHERE orderix = {$this->orderix}", "pmtrejtime"); return $this->pmtrejtime; }