Ipb 3 Login

[DST]

Tātad man ir jaunais ipb forums 3 es gribētu uzināt kas man ir par sūūdiem ka met eiroru kip tas skripts ir taisiits uz vecaas ipb versijas bet es nesaprotu kas šeit vainas.

Erors:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\minigame\login.php on line 26

Skripts

<?
mysql_connect("localhost", "root", "parole")or die('<pre>OMG, mana oo.lv datubaze atkal nospraga</p>');
mysql_select_db("minigame")or die('<pre>OMG, mana oo.lv datubaze atkal nospraga</p>');
function draw_login(){
    echo '
    <form method="post" action="forum/index.php?app=core&module=global&section=login&do=process&return=../login.php">
        <p>
            <b>Lietotajvards:</b><br />
            <input id="username" class="input_text" name="username" size="25" type="text"><br />
            <b>Parole:</b><br />
            <input id="password" class="input_text" name="password" size="25" type="password"><br />
            <input id="remember" checked="checked" name="rememberMe" value="1" class="input_check" type="checkbox">
 <b>acereties mani?</b><br />
<input id="invisible" name="anonymous" value="1" class="input_check" type="checkbox">

 <b>anonims?</b><br />
            <input value="Ienakt" type="submit" /> <a href="/mans/superforums/index.php?act=Reg&CODE=00">Registreties</a>
        </p>
    </form>
    ';
}
if(!empty($_COOKIE['member_id']) && is_numeric($_COOKIE['member_id']) && !empty($_COOKIE['pass_hash'])){
    $sql = sprintf("SELECT m.id, m.members_display_name, m.email, m.member_login_key, m.joined, e.avatar_location FROM `ibf_members` m, `ibf_member_extra` e WHERE m.id=%d AND m.member_login_key='%s' AND e.id=m.id LIMIT 1", (int)$_COOKIE['member_id'], mysql_real_escape_string($_COOKIE['pass_hash']));
    $res = mysql_query($sql);
    if(mysql_num_rows($res)>0){
        $row = mysql_fetch_object($res);
        printf('
        <p style="text-align:center;">
            Sveiks %s%s
        </p>
        <ul>
            <li><a href="/mans/superforums/index.php?act=UserCP&CODE=00">Labot Profilu</a></li>
            <li><a href="/mans/superforums/index.php?act=Msg&CODE=01">Vestules</a></li>
            <li><a href="/mans/superforums/index.php?act=Members">Lietotaji</a></li>
            <li><a href="/mans/superforums/index.php?act=Search&f=0">Meklet foruma</a></li>
            <li><a href="/mans/superforums/index.php?act=Login&CODE=03&k=%s">[IZIET]</a></li>
        </ul>
        ', $row->members_display_name, !empty($row->avatar_location) ? '<br /><img src="'.$row->avatar_location.'" alt="" />' : '', md5($row->email.'&'.$row->member_login_key.'&'.$row->joined));
    }else{
        draw_login();
    }
}else{
    draw_login();
}
?>

Edited September 26, 2010 by DST

[SroHunt3r]

as ir drošvien tapēc ka ipb3 ir cits table prefix vai kā tur ieej iekš savas db un apskaties un tad izmaini.

[DST]

prefixu uzliku tadu pasu ka vecaja,

[Jameson's]

Nu tieši otrādāk vajag, liec prefix pēc jaunās tabulas

[SroHunt3r]

Es biju meiginājis man nekas nesanāca, mainot tos prefix'us. Tieši šim login skriptam.