function print_class_info()
{
// SQL
$fe = new FileEditor('login-info.txt');
$credentials = $fe->readFile();
$login = new Credentials("terrapintango.cgpkve9uh8yp.us-east-1.rds.amazonaws.com", $credentials[0], $credentials[1], "tangodb");
$connector = new SQLConnector($login);
$connector->connect();
$query = "SELECT r.fname, r.lname, c.classes, c.passtype\r\n FROM records r, classes c, confirmation f\r\n WHERE r.registerid = c.registerid and r.registerid = f.registerid and\r\n f.payment_status = 'Completed'";
try {
$result = $connector->retrieve($query);
} catch (Exception $e) {
echo $e->getMessage();
}
// END SQL
$person_classes = array();
$table = "<table border=\"1\">";
$table .= "<th>Name</th><th>Pass Type</th><th>Classes</th>";
echo "<h1>Class Mapping</h1>";
foreach ($result as $record) {
//print_r($record);
$person_classes[$record['fname'] . " " . $record['lname']] = array($record['passtype'], parse_class_string($record['classes']));
// print_r($translated_classes);
// echo "<br>";
}
//print_r($person_classes);
foreach ($person_classes as $person => $class_ary) {
$table .= "<tr><td>{$person}</td>";
$table .= "<td>" . $class_ary[0] . "</td><td>";
$table .= implode(", ", $class_ary[1]) . "</td><tr>";
}
echo $table;
}
-->
<?php
require_once "sqlconnector.php";
require_once "dbLogin.php";
require_once "fileEditor.php";
session_start();
// receive data
$selected_classes = implode(",", json_decode($_POST['class_string']));
$passtype = $_POST['passtype'];
$price = intval($_POST['price']);
$tax = round($price * 0.035 + 0.3, 2);
$id = $_SESSION['submission_id'];
// prep connecting to db
$fe = new FileEditor('login-info.txt');
$credentials = $fe->readFile();
$cred = new Credentials("terrapintango.cgpkve9uh8yp.us-east-1.rds.amazonaws.com", $credentials[0], $credentials[1], "tangodb", 3306);
//$cred = new Credentials("localhost", "tango", "tango", "test");
$connection = new SQLConnector($cred);
$connection->connect();
$query = "INSERT INTO `classes` (`registerid`, `classes`, `price`, `passtype`)\n VALUES ('{$id}', '{$selected_classes}', '{$price}', '{$passtype}');";
try {
$connection->insert($query);
} catch (Exception $e) {
$error = $e->getMessage();
header("Location: error.php?sql_error={$error}");
}
//print_r( $selected_classes);
//echo "<br />";
//echo $price;
if(is_dir($root.'/'.$item) && $item!='.' && $item!='..'){
array_push($dirs, $root.'/'.$item);
}
elseif(is_file($root.'/'.$item) && $item!='.' && $item!='..'){
array_push($files, $root.'/'.$item);
}
}
$str .= implode("|",$dirs).'#sl#'.implode("|",$files).'#sl#'.implode('#sl#',$terms);
}
elseif($what == 'file_editor'){
//get vars
$file = isset($_POST['file']) ? $_POST['file'] : false;
$line = isset($_POST['line']) ? $_POST['line'] : false;
$fileEditor = new FileEditor($file,$line);
if($fileEditor->opening()){
$str = $fileEditor->open();
}
}
elseif($what == 'count_files'){
$exclude = isset($_POST['exclude']) ? (substr_count($_POST['exclude'],"|") ? explode("|",$_POST['exclude']) : array($_POST['exclude'])) : array();
$root = isset($_POST['root']) ? $_POST['root'] : str_replace('\\','/',$_SERVER['DOCUMENT_ROOT']);
if(!is_dir($root)){
$root = str_replace('\\','/',$_SERVER['DOCUMENT_ROOT']);
}
$str .= count_files($root,$exclude);
}
elseif($what=='base64decode' || $what=='base64encode'){
$text = isset($_POST['text']) ? urldecode($_POST['text']) : '';
if($what=='base64decode'){
require_once 'ipn/ipnlistener.php';
require_once "fileEditor.php";
require_once "sqlconnector.php";
require_once "dbLogin.php";
ini_set('log_errors', true);
ini_set('error_log', dirname(__FILE__) . '/ipn_errors.log');
$listener = new IpnListener();
//$listener->use_sandbox = true;
$listener->use_curl = false;
$fe = new FileEditor('login-info.txt');
$credentials = $fe->readFile();
$cred = new Credentials("terrapintango.cgpkve9uh8yp.us-east-1.rds.amazonaws.com", $credentials[0], $credentials[1], "tangodb", 3306);
//$cred = new Credentials("localhost", "tango", "tango", "test");
$connection = new SQLConnector($cred);
$connection->connect();
$fe1 = new FileEditor("log.txt");
$fe1->writeToFile("Run");
try {
$verified = $listener->processIpn();
} catch (Exception $e) {
// fatal error trying to process IPN.
$fe1->writeToFile($e);
exit(0);
}
if (isset($_GET['submission_id'])) {
$id = $_GET['submission_id'];
} else {
$id = 22;
// debug
}
if ($verified) {
function Load()
{
$dataProvider = new FileEditor($this->TargetFile);
$dataProvider->Load();
$this->RateComment = $dataProvider->Result["s_rate_c"];
$this->RatePoliteness = $dataProvider->Result["s_rate_p"];
$this->RateQualification = $dataProvider->Result["s_rate_q"];
$this->Fullname = $dataProvider->Result["s_fullname"];
$this->Email = $dataProvider->Result["s_email"];
$this->Company = $dataProvider->Result["s_company"];
$this->InternId = $dataProvider->Result["s_internid"];
$this->UserId = $dataProvider->Result["s_userid"];
$this->Created = @filemtime($this->TargetFile);
}
