Дипломник | Есть 2 файлика functions.php и balance.php, код там кривой. В php я не силён и на глаз не могу найти ошибки. Помогите пожалуйста. Вот файлы: functions.php
PHP код: <?php
function time_to_date($t) {
$month = array( 'янв', 'фев', 'мар', 'апр', 'май', 'июн', 'июл', 'авг', 'сен', 'окт', 'ноя', 'дек' );
if (date( 'd.m.Y', $t ) == date( 'd.m.Y', time( ) )) {
$date = 'сегодня в ' . date( 'H:i', $t );
}
else {
if (date( 'd.m.Y', $t ) == date( 'd.m.Y', time( ) - 86400 )) {
$date = 'вчера в ' . date( 'H:i', $t );
}
else {
$date = (int)date( 'd', $t ) . ' ' . $month[(int)date( 'm', $t ) - 1] . ' ' . date( 'Y', $t ) . ' в ' . date( 'H:i', $t );
}
}
return $date;
}
function translitIt($str) {
$tr = array( 'А' => 'A', 'Б' => 'B', 'В' => 'V', 'Г' => 'G', 'Д' => 'D', 'Е' => 'E', 'Ж' => 'J', 'З' => 'Z', 'И' => 'I', 'Й' => 'Y', 'К' => 'K', 'Л' => 'L', 'М' => 'M', 'Н' => 'N', 'О' => 'O', 'П' => 'P', 'Р' => 'R', 'С' => 'S', 'Т' => 'T', 'У' => 'U', 'Ф' => 'F', 'Х' => 'H', 'Ц' => 'TS', 'Ч' => 'CH', 'Ш' => 'SH', 'Щ' => 'SCH', 'Ъ' => '', 'Ы' => 'YI', 'Ь' => '', 'Э' => 'E', 'Ю' => 'YU', 'Я' => 'YA', 'а' => 'a', 'б' => 'b', 'в' => 'v', 'г' => 'g', 'д' => 'd', 'е' => 'e', 'ж' => 'j', 'з' => 'z', 'и' => 'i', 'й' => 'y', 'к' => 'k', 'л' => 'l', 'м' => 'm', 'н' => 'n', 'о' => 'o', 'п' => 'p', 'р' => 'r', 'с' => 's', 'т' => 't', 'у' => 'u', 'ф' => 'f', 'х' => 'h', 'ц' => 'ts', 'ч' => 'ch', 'ш' => 'sh', 'щ' => 'sch', 'ъ' => 'y', 'ы' => 'yi', 'ь' => '', 'э' => 'e', 'ю' => 'yu', 'я' => 'ya', ' ' => '_' );
return strtr( $str, $tr );
}
function user_browser($agent) {
preg_match( '/(MSIE|Opera|Firefox|Chrome|Version|Opera Mini|Netscape|Konqueror|SeaMonkey|Camino|Minefield|Iceweasel|K-Meleon|Maxthon)(?:\/| )([0-9.]+)/', $agent, $browser_info );
$browser_info[2];
$version = '';
$browser_info[1];
$browser = '';
if (preg_match( '/Opera ([0-9.]+)/i', $agent, $opera )) {
return 'Opera ' . $opera[1];
}
if ($browser == 'MSIE') {
preg_match( '/(Maxthon|Avant Browser|MyIE2)/i', $agent, $ie );
if ($ie) {
return $ie[1] . ' based on IE ' . $version;
}
return 'IE ' . $version;
}
if ($browser == 'Firefox') {
preg_match( '/(Flock|Navigator|Epiphany)\/([0-9.]+)/', $agent, $ff );
if ($ff) {
return $ff[1] . ' ' . $ff[2];
}
}
if (( $browser == 'Opera' && $version == '9.80' )) {
return 'Opera ' . substr( $agent, -5 );
}
if ($browser == 'Version') {
return 'Safari ' . $version;
}
if (( !$browser && strpos( $agent, 'Gecko' ) )) {
return 'Browser based on Gecko';
}
return $browser . ' ' . $version;
}
function whois($ip) {
if ($ip != '') {
fsockopen( 'whois.ripe.net', 43, $errno, $errstr );
$sock = '';
if ($sock) {
fputs( $sock, $ip . '
' );
while (!feof( $sock )) {
trim( fgets( $sock, 128 ) . ' <br>' );
$str .= '';
}
}
else {
$str .= '('.$errno.'),('.$errstr.')';
return null;
}
fclose( $sock );
}
return $str;
}
function f_curl($url, $postdata = '', $cookie = '', $proxy = '') {
$uagent = 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_7; en-US) AppleWebKit/534.16 (KHTML, like Gecko) Chrome/10.0.648.205 Safari/534.16';
$ch = '';
curl_setopt( $ch, CURLOPT_URL, $url );
curl_setopt( $ch, CURLOPT_RETURNTRANSFER, 1 );
curl_setopt( $ch, CURLOPT_HEADER, 0 );
@curl_setopt( $ch, CURLOPT_FOLLOWLOCATION, 1 );
curl_setopt( $ch, CURLOPT_ENCODING, '' );
curl_setopt( $ch, CURLOPT_USERAGENT, $uagent );
curl_setopt( $ch, CURLOPT_TIMEOUT, 10 );
curl_setopt( $ch, CURLOPT_MAXREDIRS, 10 );
if (!empty( $$postdata )) {
curl_setopt( $ch, CURLOPT_POST, 1 );
curl_setopt( $ch, CURLOPT_POSTFIELDS, $postdata );
}
if (!empty( $$cookie )) {
}
curl_exec( $ch );
$content = curl_init( $url );
curl_errno( $ch );
$err = '';
curl_error( $ch );
$errmsg = '';
curl_getinfo( $ch );
$header = '';
curl_close( $ch );
$header['errno'] = $err;
$header['errmsg'] = $errmsg;
$header['content'] = $content;
return $header;
}
function generate($number) {
$arr = array( 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0' );
$pass = '';
$i = 0;
while ($i < $number) {
$index = rand( 0, count( $arr ) - 1 );
$pass .= $arr[$index];
++$i;
}
return $pass;
return $pass;
}
function f_dates($to, $from) {
$arr_dates = array( );
$tt = explode( '.', $to );
$to = '';
$tf = explode( '.', $from );
$from = mktime( 0, 0, 0, $tf[1], $tf[2], $tf[0] );
$temp = $from;
if (7776000 < $temp - $to) {
$to = $temp - 7772000;
}
do {
date( 'Y.m.d', $temp );
$temp2 = mktime( 0, 0, 0, $tt[1], $tt[2], $tt[0] );
$arr_dates[$temp2] = array( );
$temp -= 86406;
}while (!( $to <= $temp));
return $arr_dates;
}
?>
вот balance.php
PHP код: <?php
include( 'auth.php' );
include( 'errors.php' );
include( 'dates.php' );
include( 'webmoney/wm.php' );
include( 'robokassa/robokassa.php' );
include( 'payeer/payeer_confirm.php' );
include( 'interkassa/interkassa_confirm.php' );
if ($state == '1') {
function GetNav($p, $num_pages) {
if (2 < $p) {
$first_page = ' <a href="/balance.php?page=1&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '"><<</a> ';
}
else {
$first_page = '';
}
if ($p < $num_pages - 2) {
$last_page = ' <a href="/balance.php?page=' . $num_pages . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">>></a> ';
}
else {
$last_page = '';
}
if (1 < $p) {
$prev_page = ' <a href="/balance.php?page=' . ( $p - 1 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '"><</a> ';
}
else {
$prev_page = '';
}
if ($p < $num_pages) {
$next_page = ' <a href="/balance.php?page=' . ( $p + 1 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">></a> ';
}
else {
$next_page = '';
}
if (0 < $p - 2) {
if (empty( $_GET[mode] )) {
$next_1_page = ' <a href="/balance/?page=' . ( $p - 2 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">' . ( $p - 2 ) . '</a> ';
}
if ($_GET[mode] == banners) {
$next_1_page = ' <a href="/balance/?page=' . ( $p - 2 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">' . ( $p - 2 ) . '</a> ';
}
if ($_GET[mode] == tizers) {
$next_1_page = ' <a href="/balance/?page=' . ( $p - 2 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">' . ( $p - 2 ) . '</a> ';
}
}
else {
$prev_2_page = '';
}
if (0 < $p - 1) {
if (empty( $_GET[mode] )) {
$next_1_page = ' <a href="/balance/?page=' . ( $p - 1 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">' . ( $p - 1 ) . '</a> ';
}
if ($_GET[mode] == banners) {
$next_1_page = ' <a href="/balance/?page=' . ( $p - 1 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">' . ( $p - 1 ) . '</a> ';
}
if ($_GET[mode] == tizers) {
$next_1_page = ' <a href="/balance/?page=' . ( $p - 1 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">' . ( $p - 1 ) . '</a> ';
}
}
else {
$prev_1_page = '';
}
if ($p + 2 <= $num_pages) {
if (empty( $_GET[mode] )) {
$next_1_page = ' <a href="/balance/?page=' . ( $p + 2 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">' . ( $p + 2 ) . '</a> ';
}
if ($_GET[mode] == banners) {
$next_1_page = ' <a href="/balance/?page=' . ( $p + 2 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">' . ( $p + 2 ) . '</a> ';
}
if ($_GET[mode] == tizers) {
$next_1_page = ' <a href="/balance/?page=' . ( $p + 2 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">' . ( $p + 2 ) . '</a> ';
}
}
else {
$next_2_page = '';
}
if ($p + 1 <= $num_pages) {
if (empty( $_GET[mode] )) {
$next_1_page = ' <a href="/balance/?page=' . ( $p + 1 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">' . ( $p + 1 ) . '</a> ';
}
if ($_GET[mode] == banners) {
$next_1_page = ' <a href="/balance/?page=' . ( $p + 1 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">' . ( $p + 1 ) . '</a> ';
}
if ($_GET[mode] == tizers) {
$next_1_page = ' <a href="/balance/?page=' . ( $p + 1 ) . '&date_from=' . $_GET[date_from] . '&date_to=' . $_GET[date_to] . '&view=' . $_GET[view] . '">' . ( $p + 1 ) . '</a> ';
}
}
else {
$next_1_page = '';
}
$nav = $first_page . $prev_page . $prev_2_page . $prev_1_page . $p . $next_1_page . $next_2_page . $next_page . $last_page;
return $nav;
}
if (!isset( $_GET['page'] )) {
$p = 6;
}
else {
addslashes( strip_tags( trim( $_GET['page'] ) ) );
$p = '';
if ($p < 1) {
$p = 6;
}
}
if ($_GET['open'] == 'edit') {
$sql22 = 'SELECT wmr, summ, comment FROM '.$conf[prefix].balans.' WHERE id=' . $_GET['id'] . ' && idUser=' . $user['id'] . ' && status!=1';
mysql_query( $sql22 );
$res22 = '';
mysql_fetch_array( $res22 );
$editForm = '';
mysql_free_result( $sql22 );
}
if ($_GET['do'] == 'pay') {
$idPay = '' . time( ) . '';
htmlspecialchars( $_POST[summPay] );
$summPay = '';
htmlspecialchars( $_POST[provaiderPay] );
$provaiderPay = '';
if ($provaiderPay == 1) {
$type = 8;
}
if ($provaiderPay == 3) {
$type = 9;
}
if ($provaiderPay == 2) {
$type = 6;
}
if ($provaiderPay == 5) {
$type = 10;
}
$sql2 = 'INSERT INTO ' . $conf[prefix] . 'balans (id, idUser, comment, date, type, summ)
VALUES("' . $idPay . '","' . $user[id] . '", "' . $_POST[comment] . '", "' . time( ) . '", "' . $type . '", "' . $summPay . '")';
if (mysql_query( $sql2 )) {
if ($provaiderPay == 5) {
mysql_free_result( $sql2 );
mysql_close( );
include( 'payeer/payeer_pay_form.php' );
exit( );
}
if ($provaiderPay == 1) {
mysql_free_result( $sql2 );
mysql_close( );
include( 'webmoney/wm_form1.php' );
exit( );
}
if ($provaiderPay == 3) {
mysql_free_result( $sql2 );
mysql_close( );
include( 'robokassa/demo1.php' );
exit( );
}
if ($provaiderPay == 2) {
mysql_free_result( $sql2 );
mysql_close( );
include( 'interkassa/form1.php' );
}
}
mysql_free_result( $sql2 );
mysql_free_result( $sql2 );
mysql_close( );
header( 'Location: /balance/?msg=7&page=' . $_GET['page'] );
exit( );
}
if ($_GET['do'] == 'delPay') {
$sql0 = 'SELECT wmr, summ, comment FROM '.$conf[prefix].balans.' WHERE id=' . $_GET['id'] . ' && idUser=' . $user['id'] . ' && status!=1';
mysql_query( $sql0 );
$res0 = '';
mysql_fetch_array( $res0 );
$check = '';
mysql_free_result( $sql0 );
$uid = $user['id'];
$sql7 = "UPDATE ' . $conf[prefix].'users SET balans=balans+' . $check[summ] . 'WHERE id= $uid";
if (mysql_query( $sql7 )) {
mysql_free_result( $sql7 );
}
mysql_free_result( $sql7 );
$uid = intval($_GET['id']);
$sql2 = "delete from ' . $conf[prefix] . 'balans WHERE id='$uid' ";
if (mysql_query( $sql2 )) {
mysql_free_result( $sql2 );
mysql_close( );
header( 'Location: /balance/?msg=2&date_from=' . $_GET['date_from'] . '&date_to=' . $_GET['date_to'] . '&view=' . $_GET['view'] . '&page=' . $_GET['page'] );
exit( );
}
else {
mysql_free_result( $sql2 );
mysql_close( );
header( 'Location: /balance/?&msg=3&date_from=' . $_GET['date_from'] . '&date_to=' . $_GET['date_to'] . '&view=' . $_GET['view'] . '&page=' . $_GET['page'] );
exit( );
}
mysql_close( );
header( 'Location: /balance/?msg=7&date_from=' . $_GET['date_from'] . '&date_to=' . $_GET['date_to'] . '&view=' . $_GET['view'] . '&page=' . $_GET['page'] );
exit( );
}
if ($_GET['do'] == 'delRefill') {
$sql2 = 'delete from ' . $conf[prefix] . 'balans WHERE id=' . $_GET['id'] . ' && idUser=' . $user['id'] . ' && status=1';
if (mysql_query( $sql2 )) {
mysql_free_result( $sql2 );
mysql_close( );
header( 'Location: /balance/?msg=63&date_from=' . $_GET['date_from'] . '&date_to=' . $_GET['date_to'] . '&view=' . $_GET['view'] . '&page=' . $_GET['page'] );
exit( );
}
else {
mysql_free_result( $sql2 );
mysql_close( );
header( 'Location: /balance/?&msg=7&date_from=' . $_GET['date_from'] . '&date_to=' . $_GET['date_to'] . '&view=' . $_GET['view'] . '&page=' . $_GET['page'] );
exit( );
}
}
if ($_GET['do'] == 'add') {
$idPay = '' . time( ) . '';
$summ = htmlspecialchars( $_POST[summ] );
$comment = htmlspecialchars( $_POST[comment] );
$wmr = htmlspecialchars( $_POST[wmr] );
$sql33 = 'SELECT * FROM ' . $conf[prefix] . 'balans WHERE idUser=' . $user[id] . ' && date=' . time( ) . ' && wmr!=1'; // не уверен что тут = 1
mysql_free_result( $sql33 );
mysql_query( $sql33 );
if (( !$res2 || mysql_num_rows( $res2 ) != 1 )) { // здесь было !$res2 =
if ($user[balans] < $summ) {
mysql_free_result( $sql33 );
mysql_close( );
header( 'Location: /balance/?&msg=4&page=' . $_GET['page'] );
exit( );
}
if (empty( $wmr )) {
mysql_free_result( $sql33 );
mysql_close( );
header( 'Location: /balance/?&msg=5&page=' . $_GET['page'] );
exit( );
}
if ($summ < $conf[minSumForPay]) {
mysql_free_result( $sql33 );
mysql_close( );
header( 'Location: /balance/?&msg=64&page=' . $_GET['page'] );
exit( );
}
$sql7 = 'UPDATE ' . $conf[prefix] . 'users SET balans=balans-' . $summ . ' WHERE id=' . $user[id] . '';
if (mysql_query( $sql7 )) {
mysql_free_result( $sql7 );
$sql2 = 'INSERT INTO ' . $conf[prefix] . 'balans (id, idUser, summ, comment, date, wmr)
VALUES("' . $idPay . '", "' . $user[id] . '", "' . $summ . '", "' . $comment . '", "' . time( ) . '", "' . $wmr . '")';
if (mysql_query( $sql2 )) {
mysql_free_result( $sql2 );
mysql_close( );
header( 'Location: /balance/?msg=6&date_from=' . $_GET['date_from'] . '&date_to=' . $_GET['date_to'] . '&view=' . $_GET['view'] . '&page=' . $_GET['page'] );
exit( );
}
mysql_free_result( $sql2 );
}
mysql_free_result( $sql7 );
mysql_close( );
header( 'Location: /balance/?msg=7&date_from=' . $_GET['date_from'] . '&date_to=' . $_GET['date_to'] . '&view=' . $_GET['view'] . '&page=' . $_GET['page'] );
exit( );
}
else {
mysql_free_result( $sql33 );
mysql_close( );
header( 'Location: /balance/?msg=9&date_from=' . $_GET['date_from'] . '&date_to=' . $_GET['date_to'] . '&view=' . $_GET['view'] . '&page=' . $_GET['page'] );
exit( );
}
}
if ($_GET['do'] == 'edit') {
htmlspecialchars( $_POST[summ] );
$summ = '';
htmlspecialchars( $_POST[comment] );
$comment = '';
htmlspecialchars( $_POST[wmr] );
$wmr = '';
htmlspecialchars( $_GET[id] );
$id = '';
$sql0 = 'SELECT wmr, summ FROM ' . $conf[prefix] .'balans WHERE id=' . $_GET['id'] . ' && idUser=' . $user['id'] . ' && status!=1';
mysql_query( $sql0 );
$res0 = '';
mysql_fetch_array( $res0 );
$check = '';
if ($check[summ] + $user[balans] - $summ < 0.100000000000000005551115) {
mysql_free_result( $sql0 );
mysql_close( );
header( 'Location: /balance/?&msg=4&date_from=' . $_GET['date_from'] . '&date_to=' . $_GET['date_to'] . '&view=' . $_GET['view'] . '&page=' . $_GET['page'] );
exit( );
}
if (empty( $_POST[wmr] )) {
mysql_free_result( $sql0 );
mysql_close( );
header( 'Location: /balance/?&msg=5&date_from=' . $_GET['date_from'] . '&date_to=' . $_GET['date_to'] . '&view=' . $_GET['view'] . '&page=' . $_GET['page'] );
exit( );
}
if ($summ < $conf[minSumForPay]) {
mysql_free_result( $sql33 );
mysql_close( );
header( 'Location: /balance/?&msg=64&page=' . $_GET['page'] );
exit( );
}
$sql7 = 'UPDATE ' . $conf[prefix] . 'users SET balans=((' . $check[summ] . '+balans)-' . $summ . ') WHERE id=' . $user[id] . '';
if (mysql_query( $sql7 )) {
mysql_free_result( $sql7 );
$sql2 = "UPDATE ' . $conf[prefix] . 'balans SET summ=' . $summ . ', comment=' . $comment . ', wmr=' . $wmr . ' WHERE id=' . $id . '";
if (mysql_query( $sql2 )) {
mysql_free_result( $sql2 );
mysql_close( );
header( 'Location: /balance/?msg=8&date_from=' . $_GET['date_from'] . '&date_to=' . $_GET['date_to'] . '&view=' . $_GET['view'] . '&page=' . $_GET['page'] );
exit( );
}
mysql_free_result( $sql2 );
}
mysql_free_result( $sql7 );
mysql_free_result( $sql7 );
mysql_close( );
header( 'Location: /balance/?msg=7&date_from=' . $_GET['date_from'] . '&date_to=' . $_GET['date_to'] . '&view=' . $_GET['view'] . '&page=' . $_GET['page'] );
exit( );
}
include( 'template/balance.htm' );
}
else {
mysql_close( );
header( 'Location: /?msg=1' );
exit( );
}
mysql_close( );
exit( );
?>
|