[ Поиск ] - [ Пользователи ] - [ Календарь ]
Полная Версия: Требуется помощь!!!!
Страницы: 1, 2
ipkpot
Здравствуйте Уважаемы программисты помогите пожалуйста....
Я в php и БД полный ноль, а исправить скрипт надо....
У меня скрипт старенький еще писался под php 4 и вот выдает такие ошибки

Warning: mysql_query() [function.mysql-query]: Access denied for user 'damoz'@'localhost' (using password: NO) in /home/damoz/......../headfoot.php on line 15

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/damoz/......./headfoot.php on line 15

Warning: mysql_result() expects parameter 1 to be resource, boolean given in /home/damoz/....../headfoot.php on line 15

Warning: mysql_query() [function.mysql-query]: Access denied for user 'damoz'@'localhost' (using password: NO) in /home/damoz/......./headfoot.php on line 16

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/damoz/....../headfoot.php on line 16

Warning: mysql_result() expects parameter 1 to be resource, boolean given in /home/damoz/......../headfoot.php on line 16


Вот сам код:
$mode = mysql_result(mysql_query("select value from adminprops where field='stmode'"), 0);
$ver = mysql_result(mysql_query("select value from admin where field='ver'"), 0) . ' ('.$sitemode[$mode].')';


Может кто подскажет как исправить ?
PHP 5.3
kristall
У тебя ошибка раньше, еще на этапе подключения к БД.

_____________
echo '<pre>',print_r($var, 1);die;

root@server# make love && war
fenixxx
и после select *
ipkpot
Вот весь код страницы
<?php
function
get_main_content() {
$mncontent = mysql_result(mysql_query("select content from html where type='1page'"), 0);
echo($mncontent);
}
function uheader() {
global $m_header, $ref, $strtm;
$strtm = getmicrotime();
include($m_header);
}
function ufooter() {
global $m_footer, $ref,$strtm;
$endtm = getmicrotime();
$sitemode = array("0"=>"АВТОСЕРФИНГ", "1"=>"САР");
$mode = mysql_result(mysql_query("select value from adminprops where field='stmode'"), 0);
$ver = mysql_result(mysql_query("select value from admin where field='ver'"), 0) . ' ('.$sitemode[$mode].')';
include($m_footer);
}
function secheader() {
global $mem_header, $usrid,$strtm;
$strtm = getmicrotime();
include($mem_header);
}
function members_main_menu() {
global $title, $fontface, $server_clock, $usrid;
$rus_months = array("January"=>"Января", "February"=>"Февраля", "March"=>"Марта", "April"=>"Апреля", "May"=>"Мая", "June"=>"Июня", "July"=>"Июля", "August"=>"Августа", "September"=>"Сентября", "October"=>"Октября", "November"=>"Ноября", "December"=>"Декабря");
$en_month = date('F');
$s_vals = file_reader("/memlinks.html");
$s_vals = str_replace('[show_server_time]', $server_clock, $s_vals);
$s_vals = str_replace($en_month, $rus_months[$en_month], $s_vals);
echo($s_vals);
}
function secfooter() {
global $mem_footer, $usrid,$strtm;
$endtm = getmicrotime();
$sitemode = array("0"=>"АВТОСЕРФИНГ", "1"=>"САР");
$mode = mysql_result(mysql_query("select value from adminprops where field='stmode'"), 0);
$ver = mysql_result(mysql_query("select value from admin where field='ver'"), 0) . ' ('.$sitemode[$mode].')';
include($mem_footer);
}
function file_reader($fileurl) {
global $_SERVER;
$fileurl = $_SERVER['DOCUMENT_ROOT'] . $fileurl;
$file=fopen($fileurl,'r') or die("Файл не существует");
$contents=fread($file,filesize($fileurl));
fclose($file);
return $contents;
}
function checkPTCdata($dateis) {
$qres = mysql_query("UPDATE ptc_orders SET date_done='$dateis' WHERE clicks_remain=0 && date_done='0000-00-00'");
return;
}
function text() {
$res = mysql_query("select text from tads order by rand() limit 1");
if (mysql_num_rows($res) > 0) {
$text = mysql_result($res, 0);
echo("<p align=center>$text</p>");
}
}

function get_referral($vid) {
$query = "select ref_id from member_refs where mem_id=$vid";
if($res = mysql_query($query)) {
if($res1 = mysql_fetch_array($res)) {
return $res1[0];
}
}
}

function credit_ref_bonuses($par_id) {
for ($i=0; $i < count($par_id); $i++) {
$get_ref_data = mysql_query("SELECT acctype FROM user WHERE id=$par_id[$i] && status='Активный'");
if (mysql_num_rows($get_ref_data) != 0) {
$refacc = mysql_result($get_ref_data, 0);
$get_bonuses = mysql_result(mysql_query("SELECT rbonuses FROM acctype WHERE id=$refacc"), 0);
$bonuses = explode(",", $get_bonuses);
$givebonus = $bonuses[$i];
if (!is_numeric($givebonus)) {$givebonus = 0; }
$upd_ref_acc = mysql_query("UPDATE user SET credits=credits+$givebonus, rbon_credits=rbon_credits+$givebonus, lifetime_credits=lifetime_credits+$givebonus WHERE id=$par_id[$i]");
$surpres = mysql_query("update adminprops set value=value+$givebonus where field='surplu'");
}
}
}

function get_ref_levels($mid,$z) {
global $tier;
$squery = "select count(*),mem_id from member_refs where ref_id in ($mid) group by mem_id";
if ($res = mysql_query($squery)) {
$tier[$z] = mysql_num_rows($res);
$res = mysql_fetch_array($res);
$mquery = "select mem_id from member_refs where ref_id in ($mid)";
if ($resultx = mysql_query($mquery)) {
$z = 1;
while ($rsvz = mysql_fetch_array($resultx)){
$rr_id[$z] = $rsvz[0];
$z++;
}
}

return $rr_id;
}
}

function credit_r_bonuses($par_id,$type,$ammt) {
$zzz = 0;
for ($i=0; $i < count($par_id); $i++) {
$zzz++;
$get_ref_data = mysql_query("SELECT acctype FROM user WHERE id=$par_id[$i] && status='Активный'");
if (mysql_num_rows($get_ref_data) != 0) {
$refacc = mysql_result($get_ref_data, 0);
if ($type == 'credits') {
$get_bonuses = mysql_result(mysql_query("SELECT levels FROM acctype WHERE id=$refacc"), 0);
} else {
$get_bonuses = mysql_result(mysql_query("SELECT ptc_levels FROM acctype WHERE id=$refacc"), 0);
}
$bonuses = explode(",", $get_bonuses);
$givebonus = $bonuses[$i] / 100;
$givebonus = round($givebonus, 2);
$givebonus = $givebonus * $ammt;
if ($zzz == 1) {
$return_val = $givebonus;
}
if (!is_numeric($givebonus)) {$givebonus = 0; }
if ($type == 'credits') {
$upd_ref_acc = mysql_query("UPDATE user SET credits=credits+$givebonus, crdsfrmallrefs=crdsfrmallrefs+$givebonus, lifetime_credits=lifetime_credits+$givebonus WHERE id=$par_id[$i]");
$surpres = mysql_query("update adminprops set value=value+$givebonus where field='surplu'");
} else {
$update_ref_earnings = mysql_query("UPDATE user SET lifetime_cshfrmallrefs=lifetime_cshfrmallrefs+$givebonus, cshfrmallrefs=cshfrmallrefs+$givebonus, roi_cash=roi_cash+$givebonus, lifetime_cash=lifetime_cash+$givebonus WHERE id=$par_id[$i]");
$surpres = mysql_query("update adminprops set value=value-$givebonus where field='csurpl'");
}
}
}

return $return_val;
}
function ref_shunt($memb_id) {
$par_id=member_referral($memb_id);
$query="SELECT mem_id FROM member_refs WHERE ref_id=$memb_id";
$chv_id=Array();
$i=0;
if ($res=mysql_query($query)) {
while($id=mysql_fetch_array($res)) {
$chv_id[$i] = $id[0];
$i++;
}
$queryv="UPDATE member_refs SET ref_id=$par_id WHERE mem_id=";
for($i=0;$i<count($chv_id);$i++) {
mysql_query($queryv.$chv_id[$i]);
}
}

@mysql_query("DELETE from member_refs WHERE mem_id=$memb_id");
return 1;
}

function member_referral($memb_id) {
@extract(mysql_fetch_array(mysql_query("select ref_id from member_refs where mem_id=$memb_id")));
return $ref_id;
}

function usercount() {
@extract(mysql_fetch_array(mysql_query("SELECT count(*) as users FROM user")));
return $users;
}
function users_today() {
$tadaydate=date("Y-m-d");
@extract(mysql_fetch_array(mysql_query("SELECT count(*) as todayusers FROM user where joindate LIKE '%$tadaydate%'")));
return $todayusers;
}
function totalupgradedmembers() {
@extract(mysql_fetch_array(mysql_query("SELECT count(*) as upgradedusers FROM user WHERE acctype=2")));
return $upgradedusers;
}
function totalupgrade() {
@extract(mysql_fetch_array(mysql_query("SELECT sum(amount) as upgrades FROM investment_history WHERE processor!='Система' AND is_from!='Бонус Регистрации' AND is_from!='Доход Счета' AND is_from!='Доход реферера'")));
return $upgrades;
}
function totalactiveupgrade() {
@extract(mysql_fetch_array(mysql_query("SELECT sum(amount) as activeupgrades FROM investment_history WHERE processor!='Система' AND is_from!='Бонус Регистрации' AND is_from!='Доход Счета' AND is_from!='Доход реферера' AND expired='no'")));
return $activeupgrades;
}
function pendingcashout() {
@extract(mysql_fetch_array(mysql_query("SELECT sum(amount) as pendingcashout FROM cashout_history WHERE status='ожидает'")));
return $pendingcashout;
}
function pendingprize() {
@extract(mysql_fetch_array(mysql_query("SELECT sum(amount) as pendingprize FROM draw_cashout_history WHERE status='ожидает' AND usrid!=1")));
return $pendingprize;
}
function paidprize() {
@extract(mysql_fetch_array(mysql_query("SELECT sum(amount) as paidprize FROM draw_cashout_history WHERE status='выплачено' AND usrid!=1")));
return $paidprize;
}
function totalpayout() {
@extract(mysql_fetch_array(mysql_query("SELECT sum(amount) as payout FROM cashout_history WHERE status='выплачено'")));
return $payout;
}
function totalsite() {
@extract(mysql_fetch_array(mysql_query("SELECT count(*) as totalsites FROM site WHERE state='Разрешен'")));
return $totalsites;
}
function upgrade_each_system($pay_system) {
@extract(mysql_fetch_array(mysql_query("SELECT sum(amount) as upgrade_amount FROM investment_history WHERE processor LIKE '%$pay_system%' AND expired='no'")));
return $upgrade_amount;
}
function img_chk($id) {
$file_name=$_SERVER['DOCUMENT_ROOT'] . "/img_ad/ad$id.gif";
if(!file_exists($file_name)) {
$imgchk="";
}
else {$imgchk="<img src=\"/img_ad/ad$id.gif\">";}
return $imgchk;
}
function getmicrotime()
{
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}
?>
Быстрый ответ:

 Графические смайлики |  Показывать подпись
Здесь расположена полная версия этой страницы.
Invision Power Board © 2001-2024 Invision Power Services, Inc.