} 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);