проблем с mysql заявка

cmsfan · 14 Януари 2012

Код:

<?php
include('forum/config.php');
$username =  $phpbb_user->data['username'];
$conn = @mysql_connect("$dbhost","$dbuser","$dbpasswd");
@mysql_select_db($dbname);
mysql_query("SET NAMES UTF8"); 
if (!$_POST['changenick'])
{
$our = mysql_query("SELECT * FROM phpbb_forums AND phpbb_moderator_cache AND phpbb_privmsgs AND phpbb_search_wordlist AND phpbb_topics AND phpbb_users where topic_first_poster_name='$username' AND topic_last_poster_name='$username' AND username='$username' AND username_clean='$username' ");
while($r=mysql_fetch_array($our)){
?>
<form method="POST">
<b>Настоящт ник:</b><br /> <input type="text" name="oldnick" maxlength="30" style='width:200px;'  value="<?PHP echo"$r[oldnick]"; ?>"/><br />
<b>Нов ник:</b><br /> <input type="text"  name="newnick" style='width:200px;'><br />
<input name="changenick" type="submit" value="Промени!" class="button">
</form>
<?
}
}
else{
$oldnick = $_POST['oldnick'];
$newnick = $_POST['newnick'];
$oldnick = htmlspecialchars($oldnick);
$newnick = htmlspecialchars($newnick);
echo ("<center><b>Успешно променен линк!</b></center>");
echo "<meta http-equiv=\"refresh\" content=\"1; url=changenick.php\">";
$update = mysql_query("Update phpbb_forums AND phpbb_moderator_cache AND phpbb_privmsgs AND phpbb_search_wordlist AND phpbb_topics AND phpbb_users set topic_first_poster_name = '$newnick' , topic_last_poster_name = '$newnick', username = '$newnick', username_clean='$newnick' where topic_first_poster_name = '$oldnick' AND topic_last_poster_name='$oldnick' AND username ='$oldnick' AND username_clean='$oldnick'");
}
?>

Ето и какво ми изкарва при инклуд:
[phpBB Debug] PHP Notice: in file /var/www/clients/client435/web1405/web/changenick.php on line 192: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

192 лайн:

Код:

while($r=mysql_fetch_array($our)){

eddyy93 · 14 Януари 2012

PHP:

<?php
include('forum/config.php');
$username =  $phpbb_user->data['username'];
$conn = @mysql_connect("$dbhost","$dbuser","$dbpasswd");
@mysql_select_db($dbname);
mysql_query("SET NAMES UTF8");
if (!$_POST['changenick'])
{
$our = mysql_query("SELECT * FROM
        phpbb_forums,
        phpbb_moderator_cache,
        phpbb_privmsgs,
        phpbb_search_wordlist,
        phpbb_topics,
        phpbb_users

        WHERE 
        
        phpbb_forums.topic_first_poster_name='$username' 
        AND phpbb_forums.topic_last_poster_name='$username' 
        AND phpbb_forums.username='$username' 
        AND phpbb_forums.username_clean='$username'
       
        AND phpbb_moderator_cache.topic_first_poster_name='$username' 
        AND phpbb_moderator_cache.topic_last_poster_name='$username' 
        AND phpbb_moderator_cache.username='$username' 
        AND phpbb_moderator_cache.username_clean='$username'
       
        AND phpbb_privmsgs.topic_first_poster_name='$username' 
        AND phpbb_privmsgs.topic_last_poster_name='$username' 
        AND phpbb_privmsgs.username='$username' 
        AND phpbb_privmsgs.username_clean='$username'
       
        AND phpbb_search_wordlist.topic_first_poster_name='$username' 
        AND phpbb_search_wordlist.topic_last_poster_name='$username' 
        AND phpbb_search_wordlist.username='$username' 
        AND phpbb_search_wordlist.username_clean='$username'
        
        AND phpbb_topics.topic_first_poster_name='$username' 
        AND phpbb_topics.topic_last_poster_name='$username' 
        AND phpbb_topics.username='$username' AND phpbb_topics.username_clean='$username'
       
        AND phpbb_users.topic_first_poster_name='$username' 
        AND phpbb_users.topic_last_poster_name='$username' 
        AND phpbb_users.username='$username' 
        AND phpbb_users.username_clean='$username'

        ");


while($r=mysql_fetch_assoc($our)){
?>
<form method="POST">
<b>Настоящт ник:</b><br /> <input type="text" name="oldnick" maxlength="30" style='width:200px;'  value="<?PHP echo"$r[oldnick]"; ?>"/><br />
<b>Нов ник:</b><br /> <input type="text"  name="newnick" style='width:200px;'><br />
<input name="changenick" type="submit" value="Промени!" class="button">
</form>
<?
}
}
else{
$oldnick = $_POST['oldnick'];
$newnick = $_POST['newnick'];
$oldnick = htmlspecialchars($oldnick);
$newnick = htmlspecialchars($newnick);
echo ("<center><b>Успешно променен линк!</b></center>");
echo "<meta http-equiv=\"refresh\" content=\"1; url=changenick.php\">";
$update = mysql_query("Update
        
        phpbb_forums,
        phpbb_moderator_cache,
        phpbb_privmsgs,
        phpbb_search_wordlist,
        phpbb_topics,
        phpbb_users
        
        SET



        phpbb_forums.topic_first_poster_name = '$newnick' ,
        phpbb_forums.topic_last_poster_name = '$newnick',
        phpbb_forums.username = '$newnick',
        phpbb_forums.username_clean='$newnick',

        phpbb_moderator_cache.topic_first_poster_name = '$newnick' ,
        phpbb_moderator_cache.topic_last_poster_name = '$newnick',
        phpbb_moderator_cache.username = '$newnick',
        phpbb_moderator_cache.username_clean='$newnick',

        phpbb_privmsgs.topic_first_poster_name = '$newnick' ,
        phpbb_privmsgs.topic_last_poster_name = '$newnick',
        phpbb_privmsgs.username = '$newnick',
        phpbb_privmsgs.username_clean='$newnick',

        phpbb_search_wordlist.topic_first_poster_name = '$newnick' ,
        phpbb_search_wordlist.topic_last_poster_name = '$newnick',
        phpbb_search_wordlist.username = '$newnick',
        phpbb_search_wordlist.username_clean='$newnick',

        phpbb_topics.topic_first_poster_name = '$newnick' ,
        phpbb_topics.topic_last_poster_name = '$newnick',
        phpbb_topics.username = '$newnick',
        phpbb_topics.username_clean='$newnick',

        phpbb_users.topic_first_poster_name = '$newnick' ,
        phpbb_users.topic_last_poster_name = '$newnick',
        phpbb_users.username = '$newnick',
        phpbb_users.username_clean='$newnick'

        WHERE

        phpbb_forums.topic_first_poster_name = '$oldnick'
        AND phpbb_forums.topic_last_poster_name='$oldnick'
        AND phpbb_forums.username ='$oldnick'
        AND phpbb_forums.username_clean='$oldnick'

        AND phpbb_moderator_cache.topic_first_poster_name = '$oldnick'
        AND phpbb_moderator_cache.topic_last_poster_name='$oldnick'
        AND phpbb_moderator_cache.username ='$oldnick'
        AND phpbb_moderator_cache.username_clean='$oldnick'

        AND phpbb_privmsgs.topic_first_poster_name = '$oldnick'
        AND phpbb_privmsgs.topic_last_poster_name='$oldnick'
        AND phpbb_privmsgs.username ='$oldnick'
        AND phpbb_privmsgs.username_clean='$oldnick'

        AND phpbb_search_wordlist.topic_first_poster_name = '$oldnick'
        AND phpbb_search_wordlist.topic_last_poster_name='$oldnick'
        AND phpbb_search_wordlist.username ='$oldnick'
        AND phpbb_search_wordlist.username_clean='$oldnick'

        AND phpbb_topics.topic_first_poster_name = '$oldnick'
        AND phpbb_topics.topic_last_poster_name='$oldnick'
        AND phpbb_topics.username ='$oldnick'
        AND phpbb_topics.username_clean='$oldnick'

        AND phpbb_users.topic_first_poster_name = '$oldnick'
        AND phpbb_users.topic_last_poster_name='$oldnick'
        AND phpbb_users.username ='$oldnick'
        AND phpbb_users.username_clean='$oldnick'

");
}
?>

cmsfan · 14 Януари 2012

Благодаря, +1

проблем с mysql заявка

cmsfan

Registered

eddyy93

Registered

cmsfan

Registered