DST Posted September 26, 2010 Report Share Posted September 26, 2010 (edited) 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§ion=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 Link to comment Share on other sites More sharing options...
SroHunt3r Posted September 26, 2010 Report Share Posted September 26, 2010 as ir drošvien tapēc ka ipb3 ir cits table prefix vai kā tur ieej iekš savas db un apskaties un tad izmaini. Link to comment Share on other sites More sharing options...
DST Posted September 26, 2010 Author Report Share Posted September 26, 2010 prefixu uzliku tadu pasu ka vecaja, Link to comment Share on other sites More sharing options...
Jameson's Posted October 2, 2010 Report Share Posted October 2, 2010 Nu tieši otrādāk vajag, liec prefix pēc jaunās tabulas Link to comment Share on other sites More sharing options...
SroHunt3r Posted October 2, 2010 Report Share Posted October 2, 2010 Es biju meiginājis man nekas nesanāca, mainot tos prefix'us. Tieši šim login skriptam. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now