}
if ($_REQUEST[modfunc] == 'list' && ($_REQUEST[editor] == 'stubilling' || $_REQUEST[editor] == 'lunch')) {
if ($_REQUEST[editor] == 'stubilling') {
$debits_table = 'STU_BILLING_FEES';
$credits_cond = " (LUNCH_PAYMENT!='Y' OR LUNCH_PAYMENT IS NULL) ";
$letter_title = 'Student Billing Notification';
} else {
$debits_table = 'STU_BILLING_ACT_LUNCH';
$credits_cond = " LUNCH_PAYMENT='Y' ";
$letter_title = 'Lunch Billing Notification';
}
$sql = "select school,ADDRESS1,zipcode,area_code,telephone,city,state from schools";
$address_RET = DBGet(DBQuery($sql), array(), array('SCHOOL'));
foreach ($address_RET as $school => $address) {
$address = $address[1];
$school_address[$school] = '<font size=+1>' . GetTitle() . '</font><BR>' . $address['ADDRESS1'] . '<BR>' . $address['CITY'] . ', ' . $address['STATE'] . ' ' . $address['ZIPCODE'] . '<BR>(' . $address['AREA_CODE'] . ') ' . substr($address['TELEPHONE'], 0, 3) . '-' . substr($address['TELEPHONE'], 3);
}
$sql = "SELECT ssm.STUDENT_ID,ssm.SCHOOL,s.FIRST_NAME,s.LAST_NAME,s.MIDDLE_NAME,rm.PERSON_ID ";
if (($_REQUEST[balance_low] || $_REQUEST[balance_low] === '0') && ($_REQUEST[balance_high] || $_REQUEST[balance_high] === '0')) {
$sql .= ",(SELECT COALESCE((SELECT sum(AMOUNT) FROM STU_BILLING_ACT WHERE STUDENT_ID=ssm.STUDENT_ID AND {$credits_cond}),0) -\n\t\t\t\tCOALESCE((SELECT sum(AMOUNT) FROM {$debits_table} WHERE STUDENT_ID=ssm.STUDENT_ID),0) " . FROM_DUAL . ") as BALANCE ";
}
$sql .= "FROM STU_SCHOOL_MEETS ssm,STUDENTS s,RELATIONS_MEETS rm\n\t\t\tWHERE\n\t\t\t\tssm.SYEAR='{$_REQUEST['year']}' AND s.STUDENT_ID=ssm.STUDENT_ID \n\t\t\t\tAND rm.STUDENT_ID = ssm.STUDENT_ID AND rm.CUSTODY = 'Y'\n\t\t\t\t";
if (($_REQUEST[balance_low] || $_REQUEST[balance_low] === '0') && ($_REQUEST[balance_high] || $_REQUEST[balance_high] === '0')) {
$sql .= "AND (SELECT COALESCE((SELECT sum(AMOUNT) FROM STU_BILLING_ACT WHERE STUDENT_ID=ssm.STUDENT_ID AND {$credits_cond}),0) -\n\t\t\t\tCOALESCE((SELECT sum(AMOUNT) FROM {$debits_table} WHERE STUDENT_ID=ssm.STUDENT_ID),0) " . FROM_DUAL . ")\n\t\t\t\t BETWEEN '{$_REQUEST['balance_low']}' AND '{$_REQUEST['balance_high']}' ";
}
if ($_REQUEST[not_zero] == 'Y') {
$sql .= "AND (SELECT COALESCE((SELECT sum(AMOUNT) FROM STU_BILLING_ACT WHERE STUDENT_ID=ssm.STUDENT_ID AND {$credits_cond}),0) -\n\t\t\t\tCOALESCE((SELECT sum(AMOUNT) FROM {$debits_table} WHERE STUDENT_ID=ssm.STUDENT_ID),0) " . FROM_DUAL . ")\n\t\t\t\t != '0' ";
}
if ($_REQUEST[sch]) {
$sql .= "AND ssm.SCHOOL='{$_REQUEST['sch']}' ";
}
//універсалізувати
if($id==0)
{
$sqltmp = "SELECT * FROM $par->topmenutable WHERE url='/".addslashes($act)."'";
}
if($id!=0)
{
$sqltmp = "SELECT * FROM $tablename WHERE id=$id";
}
$restmp = mysql_query($sqltmp);
if($linetmp = mysql_fetch_array($restmp,MYSQL_ASSOC))
{
$titletitle = GetTitle($linetmp);
$titlekeywords = GetKeywords($linetmp);
}
}
//после первого совпадения прекращаем цикл
if($successflag) break;
}
if($act=="none")
{
$flag = 0;
if($myarr[1]=='') $flag = 1;
else if($myarr[1]=='lang')
{
foreach($par->langsarr['urllangsaddarr'] AS $key=>$value)
function Run()
{
$titles = GKP_PAGES . "__titles.php";
$header = GKP_PAGES . "__header.php";
$footer = GKP_PAGES . "__footer.php";
$currentPage = "index";
$currentPath = "";
$query = array_filter(explode("?", $_SERVER["REQUEST_URI"]), "strlen");
$query = array_filter(explode("/", array_values($query)[0]), "strlen");
if (count($query) == 1) {
$currentPage = strtolower(array_values($query)[0]);
}
$currentPath = GKP_PAGES . $currentPage . ".php";
if (file_exists($titles) && file_exists($header) && file_exists($footer) && file_exists($currentPath)) {
global $DOCUMENT_READY;
$DOCUMENT_READY = array();
include $titles;
$title = GetTitle($currentPage);
include $header;
include $currentPath;
include $footer;
} else {
E(404);
}
exit(0);
}
$result = mysql_query($query);
if (!$result) {
echo mysql_error();
exit;
}
$line = mysql_fetch_array($result, MYSQL_ASSOC);
$title = $line['title'];
return $title;
}
$action = $_GET['action'];
$blognum = $_GET['blog'];
$num = $_GET['num'];
if ($action == 'comment') {
$ancestor = $_GET['ancestor'];
$blog_name = GetBlogName($blognum);
$article_title = GetTitle($num);
print "<P dir=RTL><H2 dir=RTL><A HREF=blogs.php?blog={$blognum}>{$blog_name}</A></H2>\n";
print "<CENTER><H1><A HREF=blogs.php?action=show&blog={$blognum}&num={$num}>{$article_title}</A></H1>\n";
/* print contents of message we are responding to */
if (!$ancestor) {
/* This is comment to main article so display article */
$query = "SELECT contents,pic FROM blogs WHERE num='{$num}'";
} else {
$query = "SELECT comment,title FROM responses WHERE num='{$ancestor}'";
}
$result = mysql_query($query);
if (!$result) {
echo mysql_error();
exit;
}
$line = mysql_fetch_array($result, MYSQL_NUM);
