Выдает ошибки на сайте: Warning: mysqli_query() expects at least 2 parameters, 1 given in /home/./public_html/sfb.php on line 88 Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in /home/./public_html/sfb.php on line 88 Warning: mysqli_query() expects at least 2 parameters, 1 given in /home/./public_html/sfb.php on line 170 Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/./public_html/sfb.php on line 170 Код (PHP): <?php session_start(); //запуск сессии include('config.php'); $nowdate = date('d.m.Y'); //задаём дату $nowtime = date(time()); //задаём время $nameus = $_SESSION["username"]; //определяем пользователя include('blocks/inf.php'); require('sfbstat.php'); if($lastupd+600 < time()) { ///в один запрос $ld=date("d.m.Y", time()-86400); $res=mysqli_fetch_assoc(mysqli_query("SELECT (SELECT price FROM tb_config WHERE item='spam') spam, (select price from tb_config where item='runblock') runblock, (select price from tb_config where item='runacc') runacc, (select price from tb_config where item='ban88') ban88, (SELECT price FROM tb_config WHERE item='cloudwm') cloudwm, (SELECT price FROM tb_config WHERE item='mprice') mprice, (SELECT price FROM tb_config WHERE item='mobper') mobper, (SELECT price FROM tb_config WHERE item='mhighlight') mhighlight, (SELECT price FROM tb_config WHERE item='mtimer') mtimer, (SELECT price FROM tb_config WHERE item='cloudma') cloudma, (SELECT price FROM tb_config WHERE item='ban1') ban1, (SELECT price FROM tb_config WHERE item='ban2') ban2, (SELECT price FROM tb_config WHERE item='ban3') ban3, (SELECT price FROM tb_config WHERE item='ban4') ban4, (SELECT price FROM tb_config WHERE item='ban5') ban5, (SELECT price FROM tb_config WHERE item='banl') banl, (SELECT price FROM tb_config WHERE item='ddosmaxhits') ddosmaxhits, (SELECT price FROM tb_config WHERE item='ddosperiod') ddosperiod, (SELECT price FROM tb_config WHERE item='ddoscrits') ddoscrits, (SELECT price FROM tb_config WHERE item='click') click, (SELECT price FROM tb_config WHERE item='referalclick') referalclick, (SELECT price FROM tb_config WHERE item='referalclick2') referalclicktwo, (SELECT howmany FROM tb_config WHERE item='recordonline') recordonline, (SELECT price FROM tb_config WHERE item='hits') hits, (SELECT price FROM tb_config WHERE item='payment') payment, (SELECT price FROM tb_config WHERE item='payment' AND howmany='1') minpay, (SELECT price FROM tb_config WHERE item='advbanner') advbanner, (SELECT price FROM tb_config WHERE item='advbanner100') advbanner100, (SELECT price FROM tb_config WHERE item='advstatlink') advstatlink, (SELECT price FROM tb_config WHERE item='mfabanner') mfabanner, (SELECT price FROM tb_config WHERE item='mfastatlink') mfastatlink, (SELECT price FROM tb_config WHERE item='obperehod') obperehod, (SELECT price FROM tb_config WHERE item='mfadyn') mfadyn, (SELECT price FROM tb_config WHERE item='mfahldyn') mfahldyn, (SELECT price FROM tb_config WHERE item='hldyn') hldyn, (SELECT price FROM tb_config WHERE item='adblock') adblock, (SELECT price FROM tb_config WHERE item='taskminprice') taskminprice, (SELECT price FROM tb_config WHERE item='taskmincount') taskmincount, (SELECT price FROM tb_config WHERE item='textads') textads, (SELECT price FROM tb_config WHERE item='timer5') timer5, (SELECT price FROM tb_config WHERE item='wmframeads') wmframeads, (SELECT price FROM tb_config WHERE item='frameads') frameads, (SELECT price FROM tb_config WHERE item='chatmess') chatmess, (SELECT price FROM tb_config WHERE item='dopsec') dopsec, (SELECT price FROM tb_config WHERE item='leftblock') leftblock, (SELECT price FROM tb_config WHERE item='vipblock') vipblock, (SELECT price FROM tb_config WHERE item='vipcount') vipcount, (SELECT price FROM tb_config WHERE item='wmchatads') wmchatads, (SELECT price FROM tb_config WHERE item='maxautopay') maxautopay, (select price from tb_config where item='psevdoweek1') psevdoweek1, (select price from tb_config where item='psevdoweek2') psevdoweek2, (select price from tb_config where item='psevdoweek3') psevdoweek3, (select price from tb_config where item='psevdoweek4') psevdoweek4, (select price from tb_config where item='refmax' and howmany='0') refmax0, (select price from tb_config where item='refmax' and howmany='1') refmax1, (SELECT price FROM tb_config WHERE item='refbirjcomm') refbirjcomm, (SELECT price FROM tb_config WHERE item='autodeluser') autodeluser, (SELECT price FROM tb_config WHERE item='refbirjminclick') refbirjminclick, (SELECT price FROM tb_config WHERE item='captcha') captcha, (SELECT price FROM tb_config WHERE item='taskcomm') taskcomm, (SELECT price FROM tb_config WHERE item='taskhl') taskhl, (SELECT price FROM tb_config WHERE item='refererbonus') refererbonus, (SELECT price FROM tb_config WHERE item='actwin') actwin, (SELECT count(id) FROM tb_users WHERE joindate='$nowdate') newtoday, (SELECT count(id) FROM tb_users WHERE joindate='$ld') vchera, (SELECT sum(visits) FROM tb_users) allvis, (SELECT sum(amount) FROM tb_history) totalpaid, (SELECT count(id) FROM tb_payme) waitpay, (SELECT sum(money) FROM tb_users WHERE user_status='user') moneytoaccs, (SELECT count(id) FROM tb_history) viplat, (SELECT count(id) FROM tb_users) nasvsego, (SELECT price FROM tb_config WHERE item='mpay') mpay, (SELECT price FROM tb_config WHERE item='mrefpay') mrefpay, (SELECT username FROM tb_users WHERE user_status='admin' order by id desc limit 1) admin LIMIT 1"));$allsqls++; $newtoday=$res["newtoday"]; $worked=$res["worked"]; $allvis=$res["allvis"]; if($res["totalpaid"]=='') $res["totalpaid"]="0.00"; $totalpaid=round($res["totalpaid"],2); $waitpay=$res["waitpay"]; //////////////////// $admindynpercent=25; //////////////////// if($res["moneytoaccs"]=='') $res["moneytoaccs"]="0.00"; $moneytoaccs=round($res["moneytoaccs"],2); $viplat=$res["viplat"]; $admin=$res["admin"]; $spam=$res["spam"]; $cloudwm=$res["cloudwm"]; $cloudma=$res["cloudma"]; $ban1=$res["ban1"]; $ban2=$res["ban2"]; $mpay=$res["mpay"]; $mrefpay=$res["mrefpay"]; $ban3=$res["ban3"]; $ban4=$res["ban4"]; $ban5=$res["ban5"]; $banl=$res["banl"]; $mprice=$res["mprice"]; $pmhighlight=$res["mhighlight"]; $pmobper=$res["mobper"]; $pmtimer=$res["mtimer"]; $vipmest1=$res["vipmest1"]; $vipmest2=$res["vipmest2"]; $runblock=$res["runblock"]; $runacc=$res["runacc"]; $ban88=$res["ban88"]; $maxhits=$res["ddosmaxhits"]; $period=$res["ddosperiod"]; $maxcrit=$res["ddoscrits"]; $obperehod=$res["obperehod"]; $click=$res["click"]; $rclick=$res["referalclick"]; $rclick2=$res["referalclicktwo"]; $hits=$res["hits"]; $recordonline=$res["recordonline"]; $payment=$res["payment"]; $minpay=$res["minpay"]; $advbanner=$res["advbanner"]; $advbanner100=$res["advbanner100"]; $advstatlink=$res["advstatlink"]; $mfabanner=$res["mfabanner"]; $mfastatlink=$res["mfastatlink"]; $mfadyn=$res["mfadyn"]; $hldyn=$res["hldyn"]; $mfahldyn=$res["mfahldyn"]; $adblock=$res["adblock"]; $textads=$res["textads"]; $psevdoweek1=$res["psevdoweek1"]; $psevdoweek2=$res["psevdoweek2"]; $psevdoweek3=$res["psevdoweek3"]; $psevdoweek4=$res["psevdoweek4"]; $taskminprice=$res["taskminprice"]; $taskmincount=$res["taskmincount"]; $timer5=$res["timer5"]; $wmframeads=$res["wmframeads"]; $frameads=$res["frameads"]; $vhatmess=$res["chatmess"]; $dopsec=$res["dopsec"]; $leftblock=$res["leftblock"]; $vipblock=$res["vipblock"]; $vipcount=$res["vipcount"]; $wmchatads=$res["wmchatads"]; $maxautopay=$res["maxautopay"]; $refmax0=$res["refmax0"]; $refmax1=$res["refmax1"]; $autodeluser=$res["autodeluser"]; $refbirjcomm=$res["refbirjcomm"]; $refbirjminclick=$res["refbirjminclick"]; $captcha=$res["captcha"]; $taskcomm=$res["taskcomm"]; $taskhl=$res["taskhl"]; $vchera=$res["vchera"]; $refererbonus=$res["refererbonus"]; $actwin=$res["actwin"]; $sql1=mysqli_query("SELECT * FROM tb_site WHERE id='1'") or die(mysqli_error());$allsqls++; $o=mysqli_fetch_assoc($sql1); $sitename = $o["sitename"]; $sitewmid = $o["wmid"]; $siteicq = $o["icq"]; $siteemail = $o["email"]; $sitepurse = $o["purse"]; $siteval = $o["valuta"]; $sitetak = $o["sitetak"]; $x2 = $o["x2"]; $x6=$o["x6"]; $rpass1 = $o["robopass1"]; $rpass2 = $o["robopass2"]; $rlogin = $o["robologin"]; $sitevalname = $o["valutaname"]; $sitestartdate = $o["startdate"]; $merchant = $o["merchant"]; $timerpay = $o["timerpay"]; $payvisits = $o["visits"]; $payforday = $o["payforday"]; $takclick = $o["takclick"]; $sitehost=$_SERVER["HTTP_HOST"]; $siteurl="http://$sitehost"; $paycomm = $o["comment"]; $nasvsego=$res["nasvsego"]; include('moneyfortimer.php'); // } $ip=getrealip(); $res=mysqli_query("select count(*) as kolvo from tb_accessblock where ip like '$ip%'"); $allsqls++; $res=mysqli_fetch_assoc($res); if($res["kolvo"]>0) { echo "<img src=\"/mfs/error.png\" align=middle> Вашему IP заблокирован доступ к сайту"; exit(); } if(isset($_SESSION["username"])) { $sql2=mysqli_query("SELECT * FROM tb_users WHERE id='$_SESSION[iduser]'") or die(mysqli_error());$allsqls++; $byme=mysqli_fetch_assoc($sql2); $passwd=$byme["password"]; $pemail=$byme["pemail"]; $referer=$byme["referer"]; $country=$byme["country"]; $user_status=$byme["user_status"]; $chatmoder=$byme["chatmoder"]; $visits=$byme["visits"]; $maccess=$byme["mailaccess"]; $family=$byme["family"]; $doing=$byme["doing"]; $lastpay=$byme["lastpay"]; $obrr=mysqli_query("SELECT (SELECT count(id) FROM tb_users WHERE referer='$_SESSION[iduser]') refov, (SELECT sum(visits) FROM tb_users WHERE referer='$_SESSION[iduser]') visitov1");$allsqls++; $obrr=mysqli_fetch_assoc($obrr); $referalvisits=$obrr["visitov1"]; if($referalvisits==NULL) $referalvisits=0; $referalvisits2=$obrr["visitov2"]; if($referalvisits2==NULL) $referalvisits2=0; $referals=$obrr["refov"]; $referals2=$obrr["refov2"]; $money=round($byme["money"],3); $moneynoround=round($byme["money"],2)-0.01; $blockpay=$byme["blockpay"]; $lastcook=$byme["lastcook"]; $paid=$byme["paid"]; $email=$byme["email"]; $joindate=$byme["joindate"]; $lastlogdate=$byme["lastlogdate"]; $lastiplog=$byme["lastiplog"]; $wmid=$byme["wmid"]; $blockip=$byme["blockip"]; $chatpaid=$byme["chatpaid"]; $avatar=$byme["avatar"]; $avatar="avp/$avatar"; $chatmessages=$byme["chatmessages"]; if($chatmessages==NULL) $chatmessages=0; } if($lastupd+600<time()) { $res=mysqli_query("select count(*) as kolvo from users_online where user IN(SELECT username FROM tb_users WHERE user_status='admin')");$allsqls++; $res=mysqli_fetch_assoc($res); if($res["kolvo"]>0) { $adminonline="<center><b>Администрация: <span style=color:#00dd00>on-line</span><br></b>"; }else{ $adminonline="<center><b>Администрация: <span style=color:#ff0000>off-line</span><br></b>"; } $d0=strtotime($sitestartdate); $d1=time(); $d=($d1-$d0)/(24*3600); $vozrast=ceil($d); /////////////**статистики разобраны**///// $printnew="select * from tb_news order by id desc limit 1"; $printnew=mysqli_query($printnew);$allsqls++; $printnew=mysqli_fetch_assoc($printnew); $datenew=$printnew["data"]; $textnew=$printnew["newstext"]; $temanew=$printnew["tema"]; $newid=$printnew["id"]; $newcomms=mysqli_num_rows(mysqli_query("SELECT id FROM afbcomments WHERE idnew='$newid'"));$allsqls++; // } ///последнюю новость вывели if($lastupd+600<time()) { $lastupd=time(); $content_stats = "<?\n \$lastupd = \"{$lastupd}\";\n \$spam = \"{$spam}\";\n \$ban1 = \"{$ban1}\";\n \$ban2 = \"{$ban2}\";\n \$ban3 = \"{$ban3}\";\n \$ban4 = \"{$ban4}\";\n \$ban5 = \"{$ban5}\";\n \$banl = \"{$banl}\";\n \$maxhits = \"{$maxhits}\";\n \$period = \"{$period}\";\n \$maxcrit = \"{$maxcrit}\";\n \$click = \"{$click}\";\n \$rclick2 = \"{$rclick2}\";\n \$rclick = \"{$rclick}\";\n \$hits = \"{$hits}\";\n \$recordonline = \"{$recordonline}\";\n \$payment = \"{$payment}\";\n \$minpay = \"{$minpay}\";\n \$advbanner = \"{$advbanner}\";\n \$advbanner100 = \"{$advbanner100}\";\n \$advstatlink = \"{$advstatlink}\";\n \$mfabanner = \"{$mfabanner}\";\n \$mfastatlink = \"{$mfastatlink}\";\n \$mfadyn = \"{$mfadyn}\";\n \$hldyn = \"{$hldyn}\";\n \$mfahldyn = \"{$mfahldyn}\";\n \$adblock = \"{$adblock}\";\n \$textads = \"{$textads}\";\n \$taskminprice = \"{$taskminprice}\";\n \$taskmincount = \"{$taskmincount}\";\n \$timer5 = \"{$timer5}\";\n \$wmframeads = \"{$wmframeads}\";\n \$frameads = \"{$frameads}\";\n \$chatmess = \"{$chatmess}\";\n \$dopsec = \"{$dopsec}\";\n \$leftblock = \"{$leftblock}\";\n \$vipblock = \"{$vipblock}\";\n \$vipcount = \"{$vipcount}\";\n \$wmchatads = \"{$wmchatads}\";\n \$maxautopay = \"{$maxautopay}\";\n \$refmax0 = \"{$refmax0}\";\n \$refmax1 = \"{$refmax1}\";\n \$autodeluser = \"{$autodeluser}\";\n \$refbirjcomm = {$refbirjcomm};\n \$refbirjminclick = \"{$refbirjminclick}\";\n \$captcha = \"{$captcha}\";\n \$taskcomm = \"{$taskcomm}\";\n \$taskhl = \"{$taskhl}\";\n \$sitename = \"{$sitename}\";\n \$sitewmid = \"{$sitewmid}\";\n \$siteemail = \"{$siteemail}\";\n \$sitepurse = \"{$sitepurse}\";\n \$siteval = \"{$siteval}\";\n \$sitetak = '{$sitetak}';\n \$x2 = \"{$x2}\";\n \$x6 = \"{$x6}\";\n \$rpass1 = \"{$rpass1}\";\n \$rpass2 = \"{$rpass2}\";\n \$rlogin = \"{$rlogin}\";\n \$sitevalname = \"{$sitevalname}\";\n \$sitestartdate = \"{$sitestartdate}\";\n \$merchant = \"{$merchant}\";\n \$timerpay = \"{$timerpay}\";\n \$payvsits = \"{$payvisits}\";\n \$payforday = \"{$payforday}\";\n \$takclick = \"{$takclick}\";\n \$siteurl = \"{$siteurl}\";\n \$paycomm = \"{$paycomm}\";\n \$newtoday = \"{$newtoday}\";\n \$worked = \"{$worked}\";\n \$allvis = \"{$allvis}\";\n \$totalpaid = \"{$totalpaid}\";\n \$waitpay = \"{$waitpay}\";\n \$moneytoaccs = \"{$moneytoaccs}\";\n \$viplat = \"{$viplat}\";\n \$admin = \"{$admin}\";\n \$adminonline = \"{$adminonline}\";\n \$vozrast = \"{$vozrast}\";\n \$datenew = \"{$datenew}\";\n \$textnew = \"{$textnew}\";\n \$temanew = \"{$temanew}\";\n \$newid = \"{$newid}\";\n \$refererbonus = \"{$refererbonus}\";\n \$actwin = \"{$actwin}\";\n \$cloudwm = \"{$cloudwm}\";\n \$siteicq = \"{$siteicq}\";\n \$psevdoweek1 = \"{$psevdoweek1}\";\n \$psevdoweek2 = \"{$psevdoweek2}\";\n \$psevdoweek3 = \"{$psevdoweek3}\";\n \$psevdoweek4 = \"{$psevdoweek4}\";\n \$ban88 = \"{$ban88}\";\n \$runblock = \"{$runblock}\";\n \$vipmest1 = \"{$vipmest1}\";\n \$vipmest2 = \"{$vipmest2}\";\n \$payfor5 = \"{$payfor5}\";\n \$payfor10 = \"{$payfor10}\";\n \$payfor15 = \"{$payfor15}\";\n \$payfor20 = \"{$payfor20}\";\n \$payfor25 = \"{$payfor25}\";\n \$payfor30 = \"{$payfor30}\";\n \$payfor35 = \"{$payfor35}\";\n \$payfor40 = \"{$payfor40}\";\n \$payfor45 = \"{$payfor45}\";\n \$payfor50 = \"{$payfor50}\";\n \$payfor55 = \"{$payfor55}\";\n \$payfor60 = \"{$payfor60}\";\n \$refpayfor5 = \"{$refpayfor5}\";\n \$refpayfor10 = \"{$refpayfor10}\";\n \$refpayfor15 = \"{$refpayfor15}\";\n \$refpayfor20 = \"{$refpayfor20}\";\n \$refpayfor25 = \"{$refpayfor25}\";\n \$refpayfor30 = \"{$refpayfor30}\";\n \$refpayfor35 = \"{$refpayfor35}\";\n \$refpayfor40 = \"{$refpayfor40}\";\n \$refpayfor45 = \"{$refpayfor45}\";\n \$refpayfor50 = \"{$refpayfor50}\";\n \$refpayfor55 = \"{$refpayfor55}\";\n \$refpayfor60 = \"{$refpayfor60}\";\n \$dyn5 = \"{$dyn5}\";\n \$dyn10 = \"{$dyn10}\";\n \$dyn15 = \"{$dyn15}\";\n \$dyn20 = \"{$dyn20}\";\n \$dyn25 = \"{$dyn25}\";\n \$dyn30 = \"{$dyn30}\";\n \$dyn35 = \"{$dyn35}\";\n \$dyn40 = \"{$dyn40}\";\n \$dyn45 = \"{$dyn45}\";\n \$dyn50 = \"{$dyn50}\";\n \$dyn55 = \"{$dyn55}\";\n \$dyn60 = \"{$dyn60}\";\n \$mpay = \"{$mpay}\";\n \$mrefpay = \"{$mrefpay}\";\n \$runacc = \"{$runacc}\";\n \$nasvsego = \"{$nasvsego}\";\n \$vchera = \"{$vchera}\";\n \$newcomms = \"{$newcomms}\";\n \$obperehod = \"{$obperehod}\";\n \$mprice = \"{$mprice}\";\n \$pmhighlight = \"{$pmhighlight}\";\n \$pmtimer = \"{$pmtimer}\";\n \$pmobper = \"{$pmobper}\";\n ?>"; $fstats = @fopen("sfbstat.php","w+"); @fwrite($fstats,$content_stats); @fclose($fstats); } ?> PHP, JavaScript, SQL и другой код пишите внутри тегов Код ( (Unknown Language)): [b]php][/b]Тут код[b][/[/b][b]code][/b][/color]
Re: Подскажите,где вывести дополнительные параметры на MySQL Warning: mysqli_query() expects at least 2 parameters, 1 given in /home/./public_html/sfb.php on line 88 предупреждение что всего один параметр передан в функцию mysqli_query() а нужно их два, это произошло на 88 строке. так вот я не вижу там mysqli_query() на 88 строке, либо файл не тот ты выложил или ещё что.
понял, вписал) но появилась новая ошибка Parse error: syntax error, unexpected '}' in /home/./public_html/sfb.php on line 198 Код (PHP): include('moneyfortimer.php'); // } $ip=getrealip(); Убирая скобку-появляются предыдущие ошибки...Я новичек в этом деле,но всё же пытаюсь разобраться.Помогите пожалуйста,весь сайт зависит от правильного кода
Re: Подскажите,где вывести дополнительные параметры на MySQL кол-во { и } совпадает? Очень сложное задание для новичка. В книгах пишут как ошибки читать и документацию. Стоит с учебников начать. http://phpfaq.ru/debug https://netbeans.org/kb/docs/php/debugging_ru.html
Re: Подскажите,где вывести дополнительные параметры на MySQL Совпадают, но код не тот, номера строк не совпадают с предупреждениями
мда,головоломка ещё та... Я вот отладчиком проверял,измаялся...куча ошибок( Синтаксические ошибки находились,но другие сразу же появлялись... Дело в том,что этот файл был на другом сервере,который работал на mysql и там этот код работал отлично, а перейдя на новый сервер-приходится подстраиваться под mysqli php 5.2 Добавлено спустя 1 минуту 27 секунд: Re: Подскажите,где вывести дополнительные параметры на MySQLi Существуют ли программы,чтоб автоматически сами конвертировали php код под другие версии?) Добавлено спустя 5 минут 21 секунду: Re: Подскажите,где вывести дополнительные параметры на MySQLi может выписка с базы данных mysql поможет? Код (PHP): -- Структура таблицы `tb_config` -- CREATE TABLE IF NOT EXISTS `tb_config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `item` varchar(19) NOT NULL, `howmany` varchar(15) NOT NULL, `price` varchar(150) NOT NULL, KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=150 ; -- -- Дамп данных таблицы `tb_config` -- INSERT INTO `tb_config` (`id`, `item`, `howmany`, `price`) VALUES (1, 'click', '1', '0.25'), (1, 'referalclick', '1', '0.06'), (1, 'hits', '1', '0.02'), (1, 'payment', '1', '2'), (2, 'recordonline', '307', '0'), (7, 'advbanner', '1', '0.1'), (8, 'advstatlink', '1', '0.025'), (9, 'mfabanner', '1', '100'), (10, 'mfastatlink', '1', '40'), (11, 'mfadyn', '1', '4'), (12, 'hldyn', '1', '0.002'), (13, 'mfahldyn', '1', '30'), (18, 'adblock', '1', '50'), (19, 'textads', '1', '50'), (20, 'taskminprice', '1', '0.1'), (21, 'taskmincount', '1', '10'), (22, 'timer5', '1', '0.003'), (23, 'wmframeads', '1', '30'), (24, 'frameads', '1', '30'), (145, 'advbanner100', '', '0.17'), (148, 'chatmess', '1', '0.01'), (95, 'viprefclick2', '1', '0.0005'), (1, 'referalclick2', '1', '0.05'), (33, 'dopsec', '1', '30'), (34, 'leftblock', '1', '50'), (59, 'psevdoweek4', '', '4000'), (58, 'psevdoweek3', '', '3000'), (37, 'vipblock', '1', '100'), (38, 'vipcount', '1', '10'), (39, 'wmchatads', '1', '30'), (57, 'psevdoweek2', '', '2000'), (56, 'psevdoweek1', '', '1000'), (42, 'maxautopay', '1', '10'), (43, 'refmax', '0', '999999999999999999999999'), (44, 'refmax', '1', '70'), (45, 'autodeluser', '1', '999999999999999999999999'), (46, 'refbirjcomm', '1', '15'), (47, 'refbirjminclick', '1', '0'), (48, 'ddosmaxhits', '1', '2'), (49, 'ddosperiod', '1', '1'), (50, 'ddoscrits', '1', '10'), (51, 'captcha', '1', '40'), (54, 'taskcomm', '1', '15'), (55, 'taskhl', '1', '10'), (98, 'banl', '', '150'), (99, 'ban1', '', '80'), (100, 'ban2', '', '85'), (101, 'ban3', '', '90'), (102, 'ban4', '', '95'), (103, 'ban5', '', '100'), (104, 'spam', '', '0.5'), (105, 'ban88', '', '50'), (106, 'refererbonus', '', '0.0'), (107, 'offsite', '', '0'), (108, 'actwin', '', '0.05'), (109, 'cloudwm', '', '10'), (110, 'cloudma', '', '20'), (111, 'autolink', '', '87'), (112, 'runblock', '', '50'), (113, 'runacc', '', '50'), (117, 'obperehod', '', '0.003'), (114, 'antiauto', '', '15052'), (116, 'autotime', '', '1282636943'), (118, 'mobper', '', '0.002'), (119, 'mhighlight', '', '0.002'), (120, 'mprice', '', '0.031'), (121, 'mtimer', '', '0.003'), (121, 'lastupdate', '', '1316362247'), (122, 'mpay', '', '0.025'), (123, 'mrefpay', '', '0.0025'), (124, 'sbprice', '', '0.005'), (131, 'prizovemestolot', '2', '5'), (130, 'prizovemestolot', '1', '10'), (127, 'kolvotrlot', '10', ''), (128, 'kolvotdlot', '10', ''), (129, 'cenabilletalot', '', '0.25'), (132, 'prizovemestolot', '3', '2.5'), (133, 'taskvip', '', '1'), (134, 'mintask', '', '0.2'), (135, 'taskup', '', '1'), (136, 'tasktobalans', '', '10'), (137, 'deltask', '', '10'), (138, 'taskvip', '', '1'), (139, 'taskref1pr', '', '1'), (120, 'cepochka', '', '1'), (138, 'cepmode', '1', '2'), (139, 'cepprice', '1', '3'), (139, 'cepcount', '1', '100'), (139, 'cepfon', '1', 'F5F5F5'), (139, 'cepbord', '1', 'E0E0E0'), (140, 'cepmoder', '1', '0'), (144, 'cepall', '1', '29'), (141, 'testprice', '1', '1'), (142, 'testoplata', '1', '0.5'), (143, 'testref1', '1', '10'), (145, 'testmoder', '1', '0'), (146, 'testoff', '1', '1'), (147, 'testall', '1', '0'), (70, 'mfabanner2', '1', '0.5'), (71, 'advbanner2', '1', '0.5'), (30, 'advbanner300', '1', '0.3'); -- -------------------------------------------------------- -- -- Структура таблицы `tb_users` -- CREATE TABLE IF NOT EXISTS `tb_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ipblock` varchar(20) NOT NULL, `rating` double NOT NULL DEFAULT '2', `ban_ip` varchar(30) NOT NULL, `ban_res` varchar(30) NOT NULL, `text_board` text NOT NULL, `board` int(1) NOT NULL DEFAULT '0', `datere` varchar(10) NOT NULL DEFAULT '0', `lastlogdatee` varchar(15) NOT NULL, `username` varchar(20) NOT NULL, `password` varchar(100) NOT NULL, `status_user` int(1) NOT NULL DEFAULT '0', `status_user_text` varchar(20) NOT NULL DEFAULT 'Прохожий', `ip` varchar(15) NOT NULL, `autoprocnew` int(3) NOT NULL, `pemail` varchar(13) NOT NULL, `referer` int(10) NOT NULL, `referer2` int(10) NOT NULL DEFAULT '0', `referals2` int(10) NOT NULL DEFAULT '0', `toref2` float(12,4) NOT NULL DEFAULT '0.0000', `country` varchar(30) NOT NULL, `visits` int(11) NOT NULL DEFAULT '0', `referals` int(5) NOT NULL DEFAULT '0', `referalvisits` int(10) NOT NULL DEFAULT '0', `money` double NOT NULL DEFAULT '0', `paid` double NOT NULL DEFAULT '0', `joindate` varchar(15) NOT NULL, `lastiplog` varchar(15) NOT NULL, `account` varchar(8) NOT NULL DEFAULT 'Базовый', `user_status` varchar(8) NOT NULL DEFAULT 'user', `wmid` varchar(12) NOT NULL, `blockip` varchar(15) NOT NULL, `chatpaid` double NOT NULL DEFAULT '0', `chatmoder` int(1) NOT NULL DEFAULT '0', `chatmessages` int(5) DEFAULT NULL, `avatar` varchar(50) NOT NULL DEFAULT 'no.png', `reyting` int(11) NOT NULL DEFAULT '0', `referalvisits2` int(6) DEFAULT '0', `views_mails` int(11) NOT NULL DEFAULT '0', `money_mails` double NOT NULL DEFAULT '0', `email` varchar(30) DEFAULT NULL, `lastpay` int(11) DEFAULT NULL, `blockpay` varchar(3) DEFAULT NULL, `lastcook` varchar(50) DEFAULT NULL, `rek` varchar(50) DEFAULT NULL, `curlink` varchar(150) NOT NULL, `chitor` varchar(150) NOT NULL, `bayref` varchar(150) NOT NULL, `dayvisit` varchar(150) NOT NULL, `timerec` varchar(150) NOT NULL, `finset` int(11) NOT NULL DEFAULT '0', `auth` varchar(10) NOT NULL, `lastlogdate` varchar(150) DEFAULT NULL, `actcode` varchar(15) NOT NULL, `passtype` varchar(5) NOT NULL, `lastver` varchar(50) NOT NULL, `taskabuses` varchar(5) NOT NULL DEFAULT '0', `timereg` int(15) NOT NULL, `sell` varchar(10) NOT NULL, `popal` varchar(3) NOT NULL DEFAULT '0', `popadostime` varchar(50) NOT NULL, `lastmail` int(15) NOT NULL, `autoproc` int(3) NOT NULL DEFAULT '0', `toref` double DEFAULT '0', `doing` int(1) DEFAULT '0', `family` int(1) DEFAULT '0', `mailaccess` int(1) DEFAULT '0', `taskreyt` int(5) NOT NULL DEFAULT '0', `ban_forum` int(1) NOT NULL DEFAULT '0', `post_forum` int(11) NOT NULL DEFAULT '0', `forum_status` varchar(5) NOT NULL DEFAULT 'user', `doxtaskr1` varchar(50) NOT NULL DEFAULT '0', `autorefback` tinyint(2) unsigned NOT NULL DEFAULT '0', `refwelcome` text NOT NULL, `ipc` int(1) NOT NULL DEFAULT '0', `stat` varchar(200) NOT NULL DEFAULT '0~0~0:0:0:0:0:0:0~0~0:0:0:0:0:0:0~0~0:0:0:0:0:0:0~', `came` varchar(50) NOT NULL DEFAULT 'Странник', KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Структура таблицы `tb_history` -- CREATE TABLE IF NOT EXISTS `tb_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user` varchar(150) NOT NULL, `date` varchar(150) NOT NULL, `amount` double DEFAULT '0', `method` varchar(150) NOT NULL, `status` varchar(150) NOT NULL, KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Структура таблицы `tb_payme` -- CREATE TABLE IF NOT EXISTS `tb_payme` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(20) NOT NULL, `pasword` varchar(20) NOT NULL, `pemail` varchar(13) NOT NULL, `country` varchar(150) NOT NULL, `money` float NOT NULL, `ip` varchar(15) NOT NULL, `datetime` int(11) NOT NULL, KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=838 ; -- -------------------------------------------------------- -- -- Структура таблицы `tb_site` -- CREATE TABLE IF NOT EXISTS `tb_site` ( `id` varchar(11) NOT NULL, `sitename` varchar(30) NOT NULL, `wmid` varchar(12) NOT NULL, `purse` varchar(13) NOT NULL, `valuta` varchar(1) NOT NULL, `valutaname` varchar(10) NOT NULL, `startdate` varchar(150) NOT NULL DEFAULT '01.01.2009', `comment` varchar(150) NOT NULL DEFAULT 'Выплата с :sitename: пользователю :username:', `blockip` varchar(15) NOT NULL, `ctrlword` varchar(150) NOT NULL, `email` varchar(30) DEFAULT NULL, `merchant` varchar(2) DEFAULT NULL, `secretkey` varchar(50) DEFAULT NULL, `visits` varchar(3) DEFAULT NULL, `payforday` varchar(3) DEFAULT NULL, `takclick` varchar(3) DEFAULT NULL, `sitetak` varchar(150) DEFAULT NULL, `x2` varchar(3) DEFAULT NULL, `robopass1` varchar(50) DEFAULT NULL, `robopass2` varchar(50) DEFAULT NULL, `robologin` varchar(50) DEFAULT NULL, `timerpay` varchar(3) DEFAULT NULL, `x6` varchar(3) DEFAULT NULL, `clrmail` varchar(10) NOT NULL, `icq` int(15) NOT NULL, `seoeditkey` varchar(40) NOT NULL, KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; -- -- Дамп данных таблицы `tb_site` -- INSERT INTO `tb_site` (`id`, `sitename`, `wmid`, `purse`, `valuta`, `valutaname`, `startdate`, `comment`, `blockip`, `ctrlword`, `email`, `merchant`, `secretkey`, `visits`, `payforday`, `takclick`, `sitetak`, `x2`, `robopass1`, `robopass2`, `robologin`, `timerpay`, `x6`, `clrmail`, `icq`, `seoeditkey`) VALUES ('1', 'Teritorian', '296117676167', '', 'R', 'руб', '', 'Выплата с :sitename: пользователю :username:', '', '', 'lossst@ukr.net', '1', '', '', '0', '0', 'tak ru', '0', 'pass1', 'pass2', 'robologin', '1', '0', '1278283203', 643780703, ''); -- -------------------------------------------------------- -- -- Структура таблицы `tb_comp` -- CREATE TABLE IF NOT EXISTS `tb_comp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `startdate` varchar(10) NOT NULL, `enddate` varchar(10) NOT NULL, `deldate` varchar(10) NOT NULL, `lidername` varchar(1) NOT NULL DEFAULT '0', `param` varchar(2) NOT NULL DEFAULT '0', `min` varchar(10) NOT NULL DEFAULT '0', `descr` varchar(1000) NOT NULL, `pris1type` varchar(1) NOT NULL DEFAULT '0', `pris1value` varchar(10) NOT NULL, `pris2type` varchar(1) NOT NULL DEFAULT '0', `pris2value` varchar(10) NOT NULL, `pris3type` varchar(1) NOT NULL DEFAULT '0', `pris3value` varchar(10) NOT NULL, `pris1status` varchar(1) NOT NULL DEFAULT '0', `pris2status` varchar(1) NOT NULL DEFAULT '0', `pris3status` varchar(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Структура таблицы `tb_compdata` -- CREATE TABLE IF NOT EXISTS `tb_compdata` ( `id` int(11) NOT NULL AUTO_INCREMENT, `idk` int(11) NOT NULL, `user` varchar(50) NOT NULL, `resvalue` int(10) NOT NULL DEFAULT '0', `purse` varchar(13) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Структура таблицы `tb_auctions` -- CREATE TABLE IF NOT EXISTS `tb_auctions` ( `id` int(10) NOT NULL AUTO_INCREMENT, `prname` varchar(50) NOT NULL DEFAULT '', `refname` varchar(50) NOT NULL DEFAULT '', `inforef` varchar(100) NOT NULL DEFAULT 'отсутствует....', `active` int(1) NOT NULL DEFAULT '1', `timer` int(15) NOT NULL DEFAULT '0', `stavka` varchar(10) NOT NULL DEFAULT '', `kolstv` int(10) NOT NULL DEFAULT '0', `lider` varchar(50) NOT NULL DEFAULT '', `dateend` int(15) NOT NULL DEFAULT '0', `iduser` int(7) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Структура таблицы `tb_news` -- CREATE TABLE IF NOT EXISTS `tb_news` ( `id` int(10) NOT NULL AUTO_INCREMENT, `data` varchar(150) NOT NULL, `newstext` text NOT NULL, `tema` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Структура таблицы `afbcomments` -- CREATE TABLE IF NOT EXISTS `afbcomments` ( `id` int(10) NOT NULL AUTO_INCREMENT, `idnew` int(10) NOT NULL, `data` varchar(16) NOT NULL, `user` varchar(20) NOT NULL, `comment` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
Re: Подскажите,где вывести дополнительные параметры на MySQL Думаю проще на новом хостинге переключится на те же версии ПО(php, mysql) что были на старом хостинге, сейчас это на многих хостинга делается прямо из панели управления хостингом.
Впринципе,я понял,что все страницы сайта под mysqli переписывать,что и сделал в течении дня...Кстати,ошибки по параметрам исчезли,т.к. переменные по примеру сидел печатал в нотпаде! а вот здесь в коде решаю задачку и чё то не сходится Код (PHP): <? session_start(); $sql="select price from tb_config where item='offsite'"; $res=$db->query($sql) or die(mysql_error()); $count=$db->num_rows($res); $res=$db->get_row($res); $off=$res["price"]; Fatal error: Call to a member function query() on a non-object in /home/./public_html/profilaction.php on line 4 Где же эта ошибка?
Re: Подскажите,где вывести дополнительные параметры на MySQL точно! нету... опять же нужен коннект файла config на mysqli/// у меня исходники только mysql
Re: Подскажите,где вывести дополнительные параметры на MySQL Есть!Но я проверил, не в этом вопросе проблема... Перередактировал по примерам этот файл php.Вывел все таки параметры по mysqli/)) Нашел ошибки с скобками-устранил! И погнало новую ошибку Parse error: syntax error, unexpected $end на линии 506 это символ ?> в конце всего кода...
Вылаживаю исправленный код,может где то ошибся? Код (PHP): <? session_start(); //запуск сессии require('config.php'); //единственное подключение к бд!о закрытии соединения можно забыть аш до самого футера до тега </html> $nowdate = date('d.m.Y'); //задаём дату $nowtime = date(time()); //задаём время $nameus = $_SESSION["username"]; //определяем пользователя include('blocks/inf.php'); include('funciones2.php'); require('sfbstat.php'); if($lastupd+600 < time()) { ///в один запрос $ld=date("d.m.Y", time()-86400); $res=$db->query("SELECT (SELECT price FROM tb_config WHERE item='spam') spam, (select price from tb_config where item='runblock') runblock, (select price from tb_config where item='runacc') runacc, (select price from tb_config where item='ban88') ban88, (SELECT price FROM tb_config WHERE item='cloudwm') cloudwm, (SELECT price FROM tb_config WHERE item='mprice') mprice, (SELECT price FROM tb_config WHERE item='mobper') mobper, (SELECT price FROM tb_config WHERE item='mhighlight') mhighlight, (SELECT price FROM tb_config WHERE item='mtimer') mtimer, (SELECT price FROM tb_config WHERE item='cloudma') cloudma, (SELECT price FROM tb_config WHERE item='ban1') ban1, (SELECT price FROM tb_config WHERE item='ban2') ban2, (SELECT price FROM tb_config WHERE item='ban3') ban3, (SELECT price FROM tb_config WHERE item='ban4') ban4, (SELECT price FROM tb_config WHERE item='ban5') ban5, (SELECT price FROM tb_config WHERE item='banl') banl, (SELECT price FROM tb_config WHERE item='ddosmaxhits') ddosmaxhits, (SELECT price FROM tb_config WHERE item='ddosperiod') ddosperiod, (SELECT price FROM tb_config WHERE item='ddoscrits') ddoscrits, (SELECT price FROM tb_config WHERE item='click') click, (SELECT price FROM tb_config WHERE item='referalclick') referalclick, (SELECT price FROM tb_config WHERE item='referalclick2') referalclicktwo, (SELECT howmany FROM tb_config WHERE item='recordonline') recordonline, (SELECT price FROM tb_config WHERE item='hits') hits, (SELECT price FROM tb_config WHERE item='payment') payment, (SELECT price FROM tb_config WHERE item='payment' AND howmany='1') minpay, (SELECT price FROM tb_config WHERE item='advbanner') advbanner, (SELECT price FROM tb_config WHERE item='advbanner100') advbanner100, (SELECT price FROM tb_config WHERE item='advbanner300') advbanner300, (SELECT price FROM tb_config WHERE item='advstatlink') advstatlink, (SELECT price FROM tb_config WHERE item='mfabanner') mfabanner, (SELECT price FROM tb_config WHERE item='mfastatlink') mfastatlink, (SELECT price FROM tb_config WHERE item='obperehod') obperehod, (SELECT price FROM tb_config WHERE item='mfadyn') mfadyn, (SELECT price FROM tb_config WHERE item='mfahldyn') mfahldyn, (SELECT price FROM tb_config WHERE item='hldyn') hldyn, (SELECT price FROM tb_config WHERE item='adblock') adblock, (SELECT price FROM tb_config WHERE item='taskminprice') taskminprice, (SELECT price FROM tb_config WHERE item='taskmincount') taskmincount, (SELECT price FROM tb_config WHERE item='textads') textads, (SELECT price FROM tb_config WHERE item='timer5') timer5, (SELECT price FROM tb_config WHERE item='wmframeads') wmframeads, (SELECT price FROM tb_config WHERE item='frameads') frameads, (SELECT price FROM tb_config WHERE item='chatmess') chatmess, (SELECT price FROM tb_config WHERE item='dopsec') dopsec, (SELECT price FROM tb_config WHERE item='leftblock') leftblock, (SELECT price FROM tb_config WHERE item='vipblock') vipblock, (SELECT price FROM tb_config WHERE item='vipcount') vipcount, (SELECT price FROM tb_config WHERE item='wmchatads') wmchatads, (SELECT price FROM tb_config WHERE item='maxautopay') maxautopay, (select price from tb_config where item='psevdoweek1') psevdoweek1, (select price from tb_config where item='psevdoweek2') psevdoweek2, (select price from tb_config where item='psevdoweek3') psevdoweek3, (select price from tb_config where item='psevdoweek4') psevdoweek4, (select price from tb_config where item='refmax' and howmany='0') refmax0, (select price from tb_config where item='refmax' and howmany='1') refmax1, (SELECT price FROM tb_config WHERE item='refbirjcomm') refbirjcomm, (SELECT price FROM tb_config WHERE item='autodeluser') autodeluser, (SELECT price FROM tb_config WHERE item='refbirjminclick') refbirjminclick, (SELECT price FROM tb_config WHERE item='captcha') captcha, (SELECT price FROM tb_config WHERE item='taskcomm') taskcomm, (SELECT price FROM tb_config WHERE item='taskhl') taskhl, (SELECT price FROM tb_config WHERE item='refererbonus') refererbonus, (SELECT price FROM tb_config WHERE item='actwin') actwin, (SELECT count(id) FROM tb_users WHERE joindate='$nowdate') newtoday, (SELECT count(id) FROM tb_users WHERE joindate='$ld') vchera, (SELECT sum(visits) FROM tb_users) allvis, (SELECT sum(amount) FROM tb_history) totalpaid, (SELECT count(id) FROM tb_payme) waitpay, (SELECT sum(money) FROM tb_users WHERE user_status='user') moneytoaccs, (SELECT count(id) FROM tb_history) viplat, (SELECT count(id) FROM tb_users) nasvsego, (SELECT price FROM tb_config WHERE item='mpay') mpay, (SELECT price FROM tb_config WHERE item='mrefpay') mrefpay, (SELECT username FROM tb_users WHERE user_status='admin' order by id desc limit 1) admin LIMIT 1"); $allsqls++; $newtoday=$res["newtoday"]; $worked=$res["worked"]; $allvis=$res["allvis"]; if($res["totalpaid"]=='') { $res["totalpaid"]="0.00"; $totalpaid=round($res["totalpaid"],2); $waitpay=$res["waitpay"]; //////////////////// $admindynpercent=25; //////////////////// if($res["moneytoaccs"]==='') { $res["moneytoaccs"]="0.00"; $moneytoaccs=round($res["moneytoaccs"],2); $viplat=$res["viplat"]; $admin=$res["admin"]; $spam=$res["spam"]; $cloudwm=$res["cloudwm"]; $cloudma=$res["cloudma"]; $ban1=$res["ban1"]; $ban2=$res["ban2"]; $mpay=$res["mpay"]; $mrefpay=$res["mrefpay"]; $ban3=$res["ban3"]; $ban4=$res["ban4"]; $ban5=$res["ban5"]; $banl=$res["banl"]; $mprice=$res["mprice"]; $pmhighlight=$res["mhighlight"]; $pmobper=$res["mobper"]; $pmtimer=$res["mtimer"]; $vipmest1=$res["vipmest1"]; $vipmest2=$res["vipmest2"]; $runblock=$res["runblock"]; $runacc=$res["runacc"]; $ban88=$res["ban88"]; $maxhits=$res["ddosmaxhits"]; $period=$res["ddosperiod"]; $maxcrit=$res["ddoscrits"]; $obperehod=$res["obperehod"]; $click=$res["click"]; $rclick=$res["referalclick"]; $rclick2=$res["referalclicktwo"]; $hits=$res["hits"]; $recordonline=$res["recordonline"]; $payment=$res["payment"]; $minpay=$res["minpay"]; $advbanner=$res["advbanner"]; $advbanner100=$res["advbanner100"]; $advbanner300=$res["advbanner300"]; $advstatlink=$res["advstatlink"]; $mfabanner=$res["mfabanner"]; $mfastatlink=$res["mfastatlink"]; $mfadyn=$res["mfadyn"]; $hldyn=$res["hldyn"]; $mfahldyn=$res["mfahldyn"]; $adblock=$res["adblock"]; $textads=$res["textads"]; $psevdoweek1=$res["psevdoweek1"]; $psevdoweek2=$res["psevdoweek2"]; $psevdoweek3=$res["psevdoweek3"]; $psevdoweek4=$res["psevdoweek4"]; $taskminprice=$res["taskminprice"]; $taskmincount=$res["taskmincount"]; $timer5=$res["timer5"]; $wmframeads=$res["wmframeads"]; $frameads=$res["frameads"]; $vhatmess=$res["chatmess"]; $dopsec=$res["dopsec"]; $leftblock=$res["leftblock"]; $vipblock=$res["vipblock"]; $vipcount=$res["vipcount"]; $wmchatads=$res["wmchatads"]; $maxautopay=$res["maxautopay"]; $refmax0=$res["refmax0"]; $refmax1=$res["refmax1"]; $autodeluser=$res["autodeluser"]; $refbirjcomm=$res["refbirjcomm"]; $refbirjminclick=$res["refbirjminclick"]; $captcha=$res["captcha"]; $taskcomm=$res["taskcomm"]; $taskhl=$res["taskhl"]; $vchera=$res["vchera"]; $refererbonus=$res["refererbonus"]; $actwin=$res["actwin"]; $sql1=$db->query("SELECT * FROM tb_site WHERE id='1'") or die(mysql_error());$allsqls++; $o=$db->get_row($sql1); $sitename = $o["sitename"]; $sitewmid = $o["wmid"]; $siteicq = $o["icq"]; $siteemail = $o["email"]; $sitepurse = $o["purse"]; $siteval = $o["valuta"]; $sitetak = $o["sitetak"]; $x2 = $o["x2"]; $x6=$o["x6"]; $rpass1 = $o["robopass1"]; $rpass2 = $o["robopass2"]; $rlogin = $o["robologin"]; $sitevalname = $o["valutaname"]; $sitestartdate = $o["startdate"]; $merchant = $o["merchant"]; $timerpay = $o["timerpay"]; $payvisits = $o["visits"]; $payforday = $o["payforday"]; $takclick = $o["takclick"]; $sitehost=$_SERVER["HTTP_HOST"]; $siteurl="http://$sitehost"; $paycomm = $o["comment"]; $nasvsego=$res["nasvsego"]; include('moneyfortimer.php'); // $kon=$db->query("select * from tb_comp");$allsqls++; while($res=$db->get_row($kon)) { $t=time(); $ed=strtotime($res["enddate"]); $dd=strtotime($res["deldate"]); if($t>$ed && $t<$dd) { $idk=$res["id"]; $minvalue=$res["min"]; $res1=$db->query("select * from tb_compdata where idk='$idk' and resvalue>='$minvalue' order by resvalue desc limit 3"); $allsqls++; for($place=1;$place<=$db->num_rows($res1);$place++) { $row1=$db->get_row($res1); $iduser=$row1["iduser"]; if($res["pris".$place."status"]=='0') { if($res["pris".$place."type"]=='0') { $prisvalue=$res["pris".$place."value"]; if($res["lidername"]=='0'){$lidertype='username';}else{$lidertype='wmid';} $lidername=$row1["user"]; $purse=$row1["purse"]; $res2=$db->query("select money from tb_users where $lidertype='$lidername'");$allsqls++; if($db->num_rows($res2)>0) { $res2=$db->get_row($res2); $money=$res2["money"]+$prisvalue; $db->query("update tb_users set money='$money' where $lidertype='$lidername'");$allsqls++; $db->query("update tb_comp set pris".$place."status='1' where id='$idk'");$allsqls++; } }else{ $prisvalue=$res["pris".$place."value"]; if($res["lidername"]=='0'){$lidertype='username';}else{$lidertype='wmid';} $lidername=$row1["user"]; $res2=$db->query("select referals,username from tb_users where $lidertype='$lidername'");$allsqls++; if($db->num_rows($res2)>0) { $res2=$db->get_row($res2); $refs=$res2["referals"]+$prisvalue; $login=$res2["username"]; $allsqls++; $res2=$db->query("select * from tb_users where referer='' and username!='$login' order by visits desc limit $prisvalue"); if($db->num_rows($res2)==$prisvalue) { while($row2=$db->get_row($res2)) { $allsqls++; $db->query("update tb_users set referer='$login', buying='4' where id='".$row2["id"]."'"); } $allsqls++;$db->query("update tb_users set referals='$refs' where $lidertype='$lidername'"); $allsqls++;$db->query("update tb_comp set pris".$place."status='1' where id='$idk'"); } } } } } } } // $ip=getrealip(); $res=$db->query("select count(*) as kolvo from tb_accessblock where ip like '$ip%'"); $allsqls++; $res=$db->get_row($res); if($res["kolvo"]>0) { echo "<img src=\"/mfs/error.png\" align=middle> Вашему IP заблокирован доступ к сайту"; exit(); } if(isset($_SESSION["username"])) { $sql2=$db->query("SELECT * FROM tb_users WHERE id='$_SESSION[iduser]'") or die(mysql_error());$allsqls++; $byme=$db->get_row($sql2); $passwd=$byme["password"]; $pemail=$byme["pemail"]; $referer=$byme["referer"]; $country=$byme["country"]; $user_status=$byme["user_status"]; $chatmoder=$byme["chatmoder"]; $visits=$byme["visits"]; $maccess=$byme[mailaccess]; $family=$byme[family]; $doing=$byme[doing]; $lastpay=$byme["lastpay"]; $obrr=$db->query("SELECT (SELECT count(id) FROM tb_auctions WHERE active='1' and prname!='$nameus') auctions, (SELECT count(id) FROM tb_users WHERE referer='$_SESSION[iduser]') refov, (SELECT sum(visits) FROM tb_users WHERE referer='$_SESSION[iduser]') visitov1");$allsqls++; // был $obrr=$db->get_row($obrr) // $colauction=$obrr["auctions"]; $referalvisits=$obrr["visitov1"]; if($referalvisits===NULL) { $referalvisits=0; $referalvisits2=$obrr["visitov2"]; if($referalvisits2===NULL) { $referalvisits2=0; $referals=$obrr["refov"]; $referals2=$obrr["refov2"]; $money=round($byme["money"],3); $moneynoround=round($byme["money"],2)-0.01; $blockpay=$byme["blockpay"]; $lastcook=$byme["lastcook"]; $paid=$byme["paid"]; $email=$byme["email"]; $joindate=$byme["joindate"]; $lastlogdate=$byme["lastlogdate"]; $lastiplog=$byme["lastiplog"]; $wmid=$byme["wmid"]; $blockip=$byme["blockip"]; $chatpaid=$byme["chatpaid"]; $avatar=$byme["avatar"]; $avatar="avp/$avatar"; $chatmessages=$byme["chatmessages"]; if ($chatmessages === NULL) { $chatmessages = 0; } if($lastupd+600<time()) { $res=$db->query("select count(*) as kolvo from users_online where user IN(SELECT username FROM tb_users WHERE user_status='admin')");$allsqls++; $res=$db->get_row($res); if($res["kolvo"]>0) { $adminonline="<center><b>Администрация: <span style=color:#00dd00>on-line</span><br></b>"; }else{ $adminonline="<center><b>Администрация: <span style=color:#ff0000>off-line</span><br></b>"; } $d0=strtotime($sitestartdate); $d1=time(); $d=($d1-$d0)/(24*3600); $vozrast=ceil($d); /////////////**статистики разобраны**///// $printnew="select * from tb_news order by id desc limit 1"; $printnew=$db->query($printnew);$allsqls++; // был $printnew=$db->get_row($printnew) // $datenew=$printnew["data"]; $textnew=$printnew["newstext"]; $temanew=$printnew["tema"]; $newid=$printnew["id"]; $newcomms=$db->num_rows($db->query("SELECT id FROM afbcomments WHERE idnew='$newid'"));$allsqls++; // } ///последнюю новость вывели if($lastupd+600<time()) { $lastupd=time(); $content_stats = "<?\n \$lastupd = \"{$lastupd}\";\n \$spam = \"{$spam}\";\n \$ban1 = \"{$ban1}\";\n \$ban2 = \"{$ban2}\";\n \$ban3 = \"{$ban3}\";\n \$ban4 = \"{$ban4}\";\n \$ban5 = \"{$ban5}\";\n \$banl = \"{$banl}\";\n \$maxhits = \"{$maxhits}\";\n \$period = \"{$period}\";\n \$maxcrit = \"{$maxcrit}\";\n \$click = \"{$click}\";\n \$rclick2 = \"{$rclick2}\";\n \$rclick = \"{$rclick}\";\n \$hits = \"{$hits}\";\n \$recordonline = \"{$recordonline}\";\n \$payment = \"{$payment}\";\n \$minpay = \"{$minpay}\";\n \$advbanner = \"{$advbanner}\";\n \$advbanner100 = \"{$advbanner100}\";\n \$advbanner300 = \"{$advbanner300}\";\n \$advstatlink = \"{$advstatlink}\";\n \$mfabanner = \"{$mfabanner}\";\n \$mfastatlink = \"{$mfastatlink}\";\n \$mfadyn = \"{$mfadyn}\";\n \$hldyn = \"{$hldyn}\";\n \$mfahldyn = \"{$mfahldyn}\";\n \$adblock = \"{$adblock}\";\n \$textads = \"{$textads}\";\n \$taskminprice = \"{$taskminprice}\";\n \$taskmincount = \"{$taskmincount}\";\n \$timer5 = \"{$timer5}\";\n \$wmframeads = \"{$wmframeads}\";\n \$frameads = \"{$frameads}\";\n \$chatmess = \"{$chatmess}\";\n \$dopsec = \"{$dopsec}\";\n \$leftblock = \"{$leftblock}\";\n \$vipblock = \"{$vipblock}\";\n \$vipcount = \"{$vipcount}\";\n \$wmchatads = \"{$wmchatads}\";\n \$maxautopay = \"{$maxautopay}\";\n \$refmax0 = \"{$refmax0}\";\n \$refmax1 = \"{$refmax1}\";\n \$autodeluser = \"{$autodeluser}\";\n \$refbirjcomm = {$refbirjcomm};\n \$refbirjminclick = \"{$refbirjminclick}\";\n \$captcha = \"{$captcha}\";\n \$taskcomm = \"{$taskcomm}\";\n \$taskhl = \"{$taskhl}\";\n \$sitename = \"{$sitename}\";\n \$sitewmid = \"{$sitewmid}\";\n \$siteemail = \"{$siteemail}\";\n \$sitepurse = \"{$sitepurse}\";\n \$siteval = \"{$siteval}\";\n \$sitetak = '{$sitetak}';\n \$x2 = \"{$x2}\";\n \$x6 = \"{$x6}\";\n \$rpass1 = \"{$rpass1}\";\n \$rpass2 = \"{$rpass2}\";\n \$rlogin = \"{$rlogin}\";\n \$sitevalname = \"{$sitevalname}\";\n \$sitestartdate = \"{$sitestartdate}\";\n \$merchant = \"{$merchant}\";\n \$timerpay = \"{$timerpay}\";\n \$payvsits = \"{$payvisits}\";\n \$payforday = \"{$payforday}\";\n \$takclick = \"{$takclick}\";\n \$siteurl = \"{$siteurl}\";\n \$paycomm = \"{$paycomm}\";\n \$newtoday = \"{$newtoday}\";\n \$worked = \"{$worked}\";\n \$allvis = \"{$allvis}\";\n \$totalpaid = \"{$totalpaid}\";\n \$waitpay = \"{$waitpay}\";\n \$moneytoaccs = \"{$moneytoaccs}\";\n \$viplat = \"{$viplat}\";\n \$admin = \"{$admin}\";\n \$adminonline = \"{$adminonline}\";\n \$vozrast = \"{$vozrast}\";\n \$datenew = \"{$datenew}\";\n \$textnew = \"{$textnew}\";\n \$temanew = \"{$temanew}\";\n \$newid = \"{$newid}\";\n \$refererbonus = \"{$refererbonus}\";\n \$actwin = \"{$actwin}\";\n \$cloudwm = \"{$cloudwm}\";\n \$siteicq = \"{$siteicq}\";\n \$psevdoweek1 = \"{$psevdoweek1}\";\n \$psevdoweek2 = \"{$psevdoweek2}\";\n \$psevdoweek3 = \"{$psevdoweek3}\";\n \$psevdoweek4 = \"{$psevdoweek4}\";\n \$ban88 = \"{$ban88}\";\n \$runblock = \"{$runblock}\";\n \$vipmest1 = \"{$vipmest1}\";\n \$vipmest2 = \"{$vipmest2}\";\n \$payfor5 = \"{$payfor5}\";\n \$payfor10 = \"{$payfor10}\";\n \$payfor15 = \"{$payfor15}\";\n \$payfor20 = \"{$payfor20}\";\n \$payfor25 = \"{$payfor25}\";\n \$payfor30 = \"{$payfor30}\";\n \$payfor35 = \"{$payfor35}\";\n \$payfor40 = \"{$payfor40}\";\n \$payfor45 = \"{$payfor45}\";\n \$payfor50 = \"{$payfor50}\";\n \$payfor55 = \"{$payfor55}\";\n \$payfor60 = \"{$payfor60}\";\n \$refpayfor5 = \"{$refpayfor5}\";\n \$refpayfor10 = \"{$refpayfor10}\";\n \$refpayfor15 = \"{$refpayfor15}\";\n \$refpayfor20 = \"{$refpayfor20}\";\n \$refpayfor25 = \"{$refpayfor25}\";\n \$refpayfor30 = \"{$refpayfor30}\";\n \$refpayfor35 = \"{$refpayfor35}\";\n \$refpayfor40 = \"{$refpayfor40}\";\n \$refpayfor45 = \"{$refpayfor45}\";\n \$refpayfor50 = \"{$refpayfor50}\";\n \$refpayfor55 = \"{$refpayfor55}\";\n \$refpayfor60 = \"{$refpayfor60}\";\n \$dyn5 = \"{$dyn5}\";\n \$dyn10 = \"{$dyn10}\";\n \$dyn15 = \"{$dyn15}\";\n \$dyn20 = \"{$dyn20}\";\n \$dyn25 = \"{$dyn25}\";\n \$dyn30 = \"{$dyn30}\";\n \$dyn35 = \"{$dyn35}\";\n \$dyn40 = \"{$dyn40}\";\n \$dyn45 = \"{$dyn45}\";\n \$dyn50 = \"{$dyn50}\";\n \$dyn55 = \"{$dyn55}\";\n \$dyn60 = \"{$dyn60}\";\n \$mpay = \"{$mpay}\";\n \$mrefpay = \"{$mrefpay}\";\n \$runacc = \"{$runacc}\";\n \$nasvsego = \"{$nasvsego}\";\n \$vchera = \"{$vchera}\";\n \$newcomms = \"{$newcomms}\";\n \$obperehod = \"{$obperehod}\";\n \$mprice = \"{$mprice}\";\n \$pmhighlight = \"{$pmhighlight}\";\n \$pmtimer = \"{$pmtimer}\";\n \$pmobper = \"{$pmobper}\";\n ?>"; $fstats = fopen('sfbstat.php','w+'); fwrite($fstats,$content_stats); fclose($fstats); } ?>
Re: Подскажите,где вывести дополнительные параметры на MySQL C отладчиком у меня не очень получается-приходится писать вручную-полюбому много чего упустил(( Не поможете определить места?
Re: Подскажите,где вывести дополнительные параметры на MySQL Как? Запустил, нет ошибок, вроде всё нормально. Тестируй. Я даже не знаю что должен делать скрипт. И если ты не хочешь сам проверять скрипт, думаешь кто-то за тебя захочет? А что там с отладчиком? Можно и без него, просто проверить каждую строчку, что куда попадает.
Re: Подскажите,где вывести дополнительные параметры на MySQL Я на синтаксические ошибки и проверял-ошибок кода сначала не было! Ладно...буду тестировать...может что и получится!