gaogier
Members-
Posts
84 -
Joined
-
Last visited
Everything posted by gaogier
-
Hello I am trying to build a calculator for a fansite. However I can't seem to get the data from the site. here is the site url. Code is added to the topic. Here is the new URL, http://hiscore.runescape.com/index_lite.ws?player=YourUsername so example, http://hiscore.runescape.com/index_lite.ws?player=Gaogier How do I get this calc to process and get the data from here? [attachment deleted by admin]
-
Hello I started to learn php, but then never picked up on it. My question, how did you learn php? How long till you was good?
-
Hello I have a forum (ipb) of which I want to get the news to be displayed on my home page. Dose anyone have IPB and could help me create a news script?
-
IT is an attachment in the first post. Any ideas on how to fix this?
-
Hello I am trying to post, but can't so please bare with me. Every time I post, it says, The following error or errors occurred while posting this message: The message body was left empty. I have attached the code as a PDF. I am having problems viewing all news, found here, http://runehints.com at the bottom of the news, you will see the view all news dose not work. However, if you go here, http://www.runehints.com/oldestindex.php Our very old design I dug out, works fine. [attachment deleted by admin]
-
Hello I am looking to change my design over, from this, http://runehints.com/skills.php to this, http://runehints.com/quest.php what is the easiest and fastest way to do this? I have several pages to convert.
-
it seems the error has gone.
-
Yay, got that fixed but what dose this mean? Fatal error: Cannot redeclare escape_data3() (previously declared in /home/gaogier/mysql_connect212.php:11) in /home/gaogier/public_html/mysql_connect.php on line 23
-
getting this error now Fatal error: Cannot redeclare escape_data() (previously declared in /home/gaogier/mysql_connect.php:7) in /home/gaogier/mysql_connect.php on line 13
-
Yes, I know, I have put back the old totals.inc file
-
It has finally changed. [phpBB Debug] PHP Notice: in file /home/gaogier/public_html/totals.inc on line 4: mysql_query() [function.mysql-query]: Access denied for user 'gaogier'@'localhost' (using password: NO) [phpBB Debug] PHP Notice: in file /home/gaogier/public_html/totals.inc on line 4: mysql_query() [function.mysql-query]: A link to the server could not be established Access denied for user 'gaogier'@'localhost' (using password: NO)
-
still no difference. I may note, I am a complete novice at php. Never could get it undermy belt.
-
No difference.
-
100% accurate code. I have added the 2 lines to the totals, but no error. I have temp removed the tag, <?php include('totals.inc'); ?> and the rest of the footer works fine.
-
flibble in /home/gaogier/public_html/quest.php on line 255 I didn't mean though away the whole code, just the tag. <?php include('totals.inc'); ?> might be something else I could use?
-
You are right, I have removed the totals.inc code and it now works How should I get this working, what code should I use? This is the only error Notice: Undefined index: flibble in /home/gaogier/public_html/quest.php on line 255
-
so, if its in the totals.inc file. <?php require_once ('../mysql_connect.php');//connect to db $skills = mysql_query("SELECT * FROM skill", $dbh) or die(mysql_error()); $quests = mysql_query("SELECT * FROM quest", $dbh) or die(mysql_error()); $location = mysql_query("SELECT * FROM location", $dbh) or die(mysql_error()); $map = mysql_query("SELECT * FROM map", $dbh) or die(mysql_error()); $sp = mysql_query("SELECT * FROM sp", $dbh) or die(mysql_error()); $guild = mysql_query("SELECT * FROM guild", $dbh) or die(mysql_error()); $random = mysql_query("SELECT * FROM random", $dbh) or die(mysql_error()); $achi = mysql_query("SELECT * FROM achi", $dbh) or die(mysql_error()); $num_rows_skills = mysql_num_rows($skills); $num_rows_quests = mysql_num_rows($quests); $num_rows_location = mysql_num_rows($location); $num_rows_map = mysql_num_rows($map); $num_rows_sp = mysql_num_rows($sp); $num_rows_guild = mysql_num_rows($guild); $num_rows_random = mysql_num_rows($random); $num_rows_achi = mysql_num_rows($achi); echo "<center>We currently have "; echo $num_rows_skills + $num_rows_quests + $num_rows_location + $num_rows_map + $num_rows_sp + $num_rows_guild+ $num_rows_random+ $num_rows_achi; echo " guides.</center>"; ?> I don't see whats wrong?
-
I copied header.inc over directly, then edited after. quest.php is a direct copy, nothing changed. footer.inc is a direct copy, nothing changed. I can readd the header.inc and prove it dose not work. I have no idea where the code is broken.
-
Footer page is here </td> <td width="178"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="8" height="29"><img src="image/rightcol-th-01.jpg" width="8" height="30"></td> <td valign="top" class="right-col-th-bg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="30" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="30" height="29" align="center" valign="middle"><img src="image/arrow.jpg" width="17" height="9"></td> <td width="5"><img src="image/specer.png" width="1" height="1"></td> <td valign="middle" class="th_text">Recent Posts</td> </tr> </table></td> </tr> </table></td> <td width="8"><img src="image/rightcol-th-02.jpg" width="8" height="30"></td> </tr> </table></td> </tr> <tr> <td height="20" align="left" valign="top" class="rightcol-bg"><table width="100%" border="0" cellspacing="8" cellpadding="0"> <tr> <td align="left" valign="top" class="normal_text01"><p><center><marquee scrollamount="2" direction="up" height="200" scrolldelay="1" onMouseOver="this.stop()" onMouseOut="this.start()"> <?php require_once ('../mysql_connect1.php');//connect to db $forumQ=mysql_query("SELECT p.topic_id, p.forum_id, p.post_subject, u.user_id, u.username_clean, u.user_colour FROM phpbb_posts AS p INNER JOIN phpbb_users AS u ON p.poster_id = u.user_id WHERE p.post_approved=1 ORDER BY p.topic_id DESC LIMIT 20"); while($forumRow = mysql_fetch_assoc($forumQ)){ echo " <a href=forums/viewtopic.php?f=".$forumRow['forum_id']."&t=".$forumRow['topic_id'].">".$forumRow['post_subject']."</a><br> Author: <a href='./memberlist.php?mode=viewprofile&u=".$forumRow['user_id']."' style='color: ".$forumRow['user_colour'].";'>".$forumRow['username_clean']."</a><br><br> "; } ?> <br /><br /> <a href="/forums/">RuneHints<br /> The Solution to all your RuneScape Problems</a></marquee></center> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="10"><img src="image/leftcol-box1-bot-left.jpg" width="10" height="16"></td> <td class="leftcol-bot-mid-bg"> </td> <td width="10"><img src="image/leftcol-box1-bot-right.jpg" width="10" height="16"></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="5" align="left" valign="top"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="8" height="29"><img src="image/rightcol-th-01.jpg" width="8" height="30"></td> <td valign="top" class="right-col-th-bg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="30" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="30" height="29" align="center" valign="middle"><img src="image/arrow.jpg" width="17" height="9"></td> <td width="5"><img src="image/specer.png" width="1" height="1"></td> <td valign="middle" class="th_text">Forum Stats</td> </tr> </table></td> </tr> </table></td> <td width="8"><img src="image/rightcol-th-02.jpg" width="8" height="30"></td> </tr> </table></td> </tr> <tr> <td height="20" align="left" valign="top" class="rightcol-bg"><table width="100%" border="0" cellspacing="8" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="20" align="left" valign="middle" class="normal_text01"><?php include_once('fostats.php') ?></td> </tr> <tr> <td align="left" valign="top"> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="10"><img src="image/leftcol-box1-bot-left.jpg" width="10" height="16"></td> <td class="leftcol-bot-mid-bg"> </td> <td width="10"><img src="image/leftcol-box1-bot-right.jpg" width="10" height="16"></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="5" align="left" valign="top"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="8" height="29"><img src="image/rightcol-th-01.jpg" width="8" height="30"></td> <td valign="top" class="right-col-th-bg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="30" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="30" height="29" align="center" valign="middle"><img src="image/arrow.jpg" width="17" height="9"></td> <td width="5"><img src="image/specer.png" width="1" height="1"></td> <td valign="middle" class="th_text">Site Stats</td> </tr> </table></td> </tr> </table></td> <td width="8"><img src="image/rightcol-th-02.jpg" width="8" height="30"></td> </tr> </table></td> </tr> <tr> <td height="20" align="left" valign="top" class="rightcol-bg"><table width="100%" border="0" cellspacing="8" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="20" align="left" valign="middle" class="normal_text01"><?php include_once('aguestonline.php') ?><br><?php include('totals.inc'); ?></td> </tr> <tr> <td align="left" valign="top"> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="10"><img src="image/leftcol-box1-bot-left.jpg" width="10" height="16"></td> <td class="leftcol-bot-mid-bg"> </td> <td width="10"><img src="image/leftcol-box1-bot-right.jpg" width="10" height="16"></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="5" align="left" valign="top"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="8" height="29"><img src="image/rightcol-th-01.jpg" width="8" height="30"></td> <td valign="top" class="right-col-th-bg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="30" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="30" height="29" align="center" valign="middle"><img src="image/arrow.jpg" width="17" height="9"></td> <td width="5"><img src="image/specer.png" width="1" height="1"></td> <td valign="middle" class="th_text">Poll</td> </tr> </table></td> </tr> </table></td> <td width="8"><img src="image/rightcol-th-02.jpg" width="8" height="30"></td> </tr> </table></td> </tr> <tr> <td height="20" align="left" valign="top" class="rightcol-bg"><table width="100%" border="0" cellspacing="8" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="20" align="left" valign="middle" class="normal_text01"><?php require_once ('mysql_connect.php');//connect to db $current_query = "SELECT * FROM poll_current"; if ($current_result = mysql_query($current_query)) { $current_row = mysql_fetch_array($current_result); $current = $current_row['poll_num']; } if(isset($_POST['submit']) && ctype_digit($_POST['vote'])) { $query = 'UPDATE poll_answers SET votes=votes+1 WHERE choice=' . $_POST['vote'] .' && poll_num='.$current; $result = mysql_query($query); ob_end_clean(); setcookie ('vote', 'voted', time()+1209600, '/', 'runehints.com', '0'); ob_end_clean(); header("Location: http://runehints.com/"); require_once ('../mysql_connect.php');//connect to db } if (isset($_COOKIE['vote'])) { $question_query = 'SELECT * FROM poll_questions WHERE poll_num='.$current; if($question_result = mysql_query($question_query)) { $question_row = mysql_fetch_array($question_result); $question = $question_row['question']; $num_votes_query = 'SELECT SUM(votes) AS sumvotes FROM poll_answers WHERE poll_num='.$current; if ($result = mysql_query($num_votes_query)) { $row = mysql_fetch_array($result); $sum = $row['sumvotes']; } $totals_query = 'SELECT activity, votes FROM poll_answers WHERE poll_num='.$current.' ORDER BY choice ASC'; if ($result = mysql_query($totals_query)) { echo '<font class="small2">'.$question.'<br /><br />'; echo '<table width="100%" cellpadding="1" cellspacing="0" border="0" style="font-family: Verdana; font-size: 9px; color: #efefef">'; while($row = mysql_fetch_array($result)) { $percent = round($row['votes'] * 100 / $sum); echo '<tr><td width="3"></td><td width="100%" colspan="3">'. $row['activity']; echo '</td><td width="3"></td></tr><tr><td width="3"></td><td width="100%"><table width="100%"><tr><td height="9" width="'. $percent .'" background="http://www.runehints.com/images/bar.png"></td><td></td></tr></table></td><td width="3"></td><td width="0" align="right">'. $row['votes'] .'</td><td width="3"></td></tr>'; } echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td height="3"></td></tr></table><font style="font-size: 9px"><center><i>Votes: '.$sum.'</i></center></font>'; }else{ echo '<font class="small2">Sorry no polls are currently active</font>'; } } }else{ $question_query = 'SELECT * FROM poll_questions WHERE poll_num='.$current; if($question_result = mysql_query($question_query)) { $question_row = mysql_fetch_array($question_result); $question = $question_row['question']; $form_query = 'SELECT * FROM poll_answers WHERE poll_num='.$current; if($result = mysql_query($form_query)) { echo '<form action='.$_SERVER['PHP_SELF'].' method="post">'; echo '<font class="small2">'.$question.'<br />'; while($row = mysql_fetch_array($result)) { echo '<input type="radio" name="vote" value=' . $row['choice'] . '>'. $row['activity'] . '<br />'; } echo '<center><input name="submit" type="submit" value="Vote!"></form></center>'; } }else{ echo '<font class="small2">Sorry no polls are currently active </font>'; } } ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="10"><img src="image/leftcol-box1-bot-left.jpg" width="10" height="16"></td> <td class="leftcol-bot-mid-bg"> </td> <td width="10"><img src="image/leftcol-box1-bot-right.jpg" width="10" height="16"></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top"> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="10"><img src="image/footer_left-bg.jpg" width="10" height="90"></td> <td class="footer_bg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="30" align="center" valign="bottom"> <a href="#" class="link_text02">Home</a> | <a href="#" class="link_text02">Forums</a> | <a href="#" class="link_text02">Desktop</a> | <a href="#" class="link_text02">Dragon Knight RPG</a> | <a href="#" class="link_text02">Contact Us</a> | <a href="#" class="link_text02">Staff Info</a> | <a href="#" class="link_text02">Top Sites</a></td> </tr> <tr> <td align="center" valign="top" class="normal_text01">Copyright © 2004-2009 RuneHints.com. All Rights Reserved.<br>This site is not official and is in no ways affiliated with RuneScape. <br>All images related to Runescape are the property of Jagex Ltd.<br>Runescapeô is a trademark of Jagex Software © 1999-2009 Andrew Gower and JagexÆ, Ltd.</td> </tr> </table></td> <td width="10"><img src="image/footer_right-bg.jpg" width="10" height="90"></td> </tr> </table></td> </tr> </table></td> </tr> </table> </body> </html> <?php ob_flush(); ?>
-
Somehow the send page wont paste fully here. Here is the quest.php page <?php $use_jquery = true; include ('header.inc'); ?> <td width="5"><img src="image/specer.png" width="1" height="1"></td> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="8"><img src="image/th-midbody-left.jpg" width="8" height="29"></td> <td class="t-header-bg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="29" align="center" valign="middle" class="normal_text06">QUEST GUIDES</td> </tr> </table></td> <td width="8"><img src="image/th-midbody-right.jpg" width="8" height="29"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="1" bgcolor="#756649"><img src="image/specer.png" width="1" height="1"></td> <td width="1" bgcolor="#A18E6E"><img src="image/specer.png" width="1" height="1"></td> <td width="1" bgcolor="#474B48"><img src="image/specer.png" width="1" height="1"></td> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="1" align="left" valign="top" bgcolor="#474B48"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td align="left" valign="top" class="box_4"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <?php function questview($id) { require_once ('../mysql_connect.php');//connect to db include ('includes/steps.php'); /* query for item */ $query = "SELECT * FROM quest WHERE id=$id"; $result = mysql_query ($query); /* if we get no results back, error out */ $numrtn = mysql_num_rows($result); if ($numrtn == 0) { echo "The quest guide requested cannot be found\n"; echo $id; return; } $row = mysql_fetch_assoc($result); /* easier to read variables and * striping out tags */ $id = $row['id']; $name = $row['name']; $contributors = $row['contributors']; $guideby = $row['guideby']; $added = $row['added']; $location = $row['startinglocation']; $members = $row['members']; $description = $row['description']; $difficulty = $row['difficulty']; $requirements = $row['requirements']; $items = $row['items']; $reward = $row['reward']; $guide = $row['mainbody']; $length = $row['length']; $updated = $row['updated']; if ($members == "Y") { $mem = "members only quest</b>, so it can only be done on a <b>members</b> server."; }else{ $mem = "non-members quest</b>."; } if ($updated == 0){ $up = 'No-one has updated this quest guide'; }else{ $date2 = date("l jS F Y @ H:i:s ", $updated); $up = 'It was last updated on '.$date2; } if ($contributors != ""){ $con = 'Thanks also to <b>'.$contributors.'</b> for changes.'; }else{ $con = 'No-one else has contributed to this quest guide.'; } //$date = date("D M jS, Y g:i a", $added); $date = date("l jS F Y @ H:i:s ", $added); echo ' <div id="quest"><table width="100%" border="0"> <tr> <td> <h1 align="center">'.$name.'</h1> '; echo step_js(); echo pick_clue($id); echo toggle_reward(); echo toggle_clue(); echo '<br>'; echo ' <p class="text1">This quest guide was written by <b>'.$guideby.'</b> for use on Runehints and entered into the database on '.$date.'. '.$up.'. '.$con.' <br /></p> <p><span class="text1"><br />This quest is <b>'.$mem.'</span></p> <p> <span class="qtitle">Description: </span><span class="text1">'.$description.'</span></p> <p><span class="qtitle">Difficulty Level: </span><span class="text1">'.$difficulty.'</span></p> <p> <span class="qtitle">Requirements: </span><span class="text1">'.$requirements.'</span></p> <p> <span class="qtitle">Items Needed During Quest: </span><span class="text1">'.$items.'</span></p> <p> <span class="qtitle">Starting Location: </span><span class="text1">'.$location.'</span></p> <p><span class="qtitles">Quest Instructions:</span></p>'; echo list_steps($id, true); echo '<p> <div id="rewardwrap" style="display:none;"><span class="qtitle">Reward: </span><span class="text1">'.$reward.'</span></div></p> </td> </tr> </table></div> '; } function selectquest(){ require_once ('../mysql_connect.php');//connect to db global $sitestyle; ?> <?php $result = mysql_query("SELECT * FROM quest"); $num_rows = mysql_num_rows($result); ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top" class="normal_text02"><div align="justify">There are a total of <? echo $num_rows; ?> quest guides in our database. There are Free guides and Member guides. On RuneHints, all guides are free to use, but the Member guides require you to be on a RuneScape Member server to use them.</div></td> </tr> <tr> <td height="15" align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="16"><img src="image/011.jpg" width="16" height="26"></td> <td align="left" valign="top" class="quest_033"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="26" align="center" valign="middle" class="normal_text07">FREE QUEST GUIDES</td> </tr> </table></td> <td width="16"><img src="image/022.jpg" width="16" height="26"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top" class="box_5"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <?php /* query for quests */ $n_query = "SELECT id, name, difficulty, members, sorter FROM quest WHERE members='n' ORDER BY sorter ASC"; $n_result = mysql_query ($n_query); while ($n_row = mysql_fetch_assoc($n_result)) { $n_name = $n_row['name']; //$n_guideby = $n_row['guideby']; $n_difficulty = $n_row['difficulty']; $id = $n_row['id']; /* place table row data in * easier to use variables. * & display the data */ echo '<tr align="left" valign="top"><td width="275" class="normal_text05"><a href="quest.php?flibble=questview&id='.$id.'&ic=1" style="color:#EED8B4;"><b>'.$n_name.'</b></a></td><td> </td><td width="73" class="normal_text05">'.$n_difficulty.'</td></tr>'; } /* finish up table*/ ?> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="49"><img src="image/0022.jpg" width="49" height="17"></td> <td height="17" bgcolor="#69582D"><img src="image/specer.png" width="1" height="1"></td> <td width="49"><img src="image/0033.jpg" width="49" height="17"></td> </tr> </table></td> </tr> </table></td> <td width="20"><img src="image/specer.png" width="1" height="1"></td> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="16"><img src="image/011.jpg" width="16" height="26"></td> <td class="quest_033"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="26" align="center" valign="middle" class="normal_text07">MEMBER QUEST GUIDES</td> </tr> </table></td> <td width="16"><img src="image/022.jpg" width="16" height="26"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top" bgcolor="#675A45" class="box_5"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <?php /* query for quests */ $y_query = "SELECT id, name, difficulty, members, sorter FROM quest WHERE members='y' ORDER BY sorter ASC"; $y_result = mysql_query ($y_query); while ($y_row = mysql_fetch_assoc($y_result)) { $y_name = $y_row['name']; //$y_guideby = $y_row['guideby']; $y_difficulty = $y_row['difficulty']; $yid = $y_row['id']; /* place table row data in * easier to use variables. * & display the data */ echo '<tr align="left" valign="top"><td width="275" class="normal_text05"><a href="quest.php?flibble=questview&id='.$yid.'&ic=1" style="color:#EED8B4;"><b>'.$y_name.'</b></a></td><td> </td><td width="73" class="normal_text05">'.$y_difficulty.'</td></tr>'; } /* finish up table*/?> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="49"><img src="image/0022.jpg" width="49" height="17"></td> <td height="17" bgcolor="#69582D"><img src="image/specer.png" width="1" height="1"></td> <td width="49"><img src="image/0033.jpg" width="49" height="17"></td> </tr> </table></td> </tr> </table></td> </tr> </table></td> </tr> </table> <?php } switch($_GET['flibble']) { case 'selectquest': selectquest(); break; case 'questview': questview($_GET['id']); break; default: selectquest(); } ?> </td></tr></table> </td></tr></table> </td> <td width="1" bgcolor="#756649"><img src="image/specer.png" width="1" height="1"></td> <td width="1" bgcolor="#A18E6E"><img src="image/specer.png" width="1" height="1"></td> <td width="1" bgcolor="#474B48"><img src="image/specer.png" width="1" height="1"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="63"><img src="image/0a.jpg" width="63" height="20"></td> <td valign="bottom"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="17" align="left" valign="top" bgcolor="#746232"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td height="1" align="left" valign="top" bgcolor="#474B48"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td height="1" align="left" valign="top" bgcolor="#A18E6E"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td height="1" align="left" valign="top" bgcolor="#756649"><img src="image/specer.png" width="1" height="1"></td> </tr> </table></td> <td width="63"><img src="image/0b.jpg" width="63" height="20"></td> </tr> </table></td> </tr> <tr> <td height="5" align="left" valign="top"><img src="image/specer.png" width="1" height="1"></td> </tr> </table></td> <td width="5"><img src="image/specer.png" width="1" height="1"></td> </tr> </table> <? //include('difffooter.inc'); include('footer.inc'); ?>
-
the people I have spoken to say its a php error. There are a few things html different, but if you look on the main site (using the same footer) http://runehints.com it works. <?php ob_start(); session_start(); ?><?php $time = microtime(); $time = explode(" ", $time); $time = $time[1] + $time[0]; $start = $time; ?> <?php include('aguestonline.inc'); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title> .:RuneHints:. The Solution to all your RuneScape Problems</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META name="copyright" CONTENT="Copyright RuneHints 2009"> <META name="description" content="Runehints is a RuneScape tips site as the name suggests with dynamic sigs, hiscore based calculators and more"> <META name="revisit-after" content="5 days"> <META name="language" content="English"> <META name="rating" content="general"> <META name=distribution content=global> <META name="keywords" content="Rune scape,RuneScape,RuneHints,Rune hints, MMORPG, ORPG, MMO, MORPG, online games,games,multi-player games,guide,help,hints,forum,rpg,game player,map,guides,rune,reports "> <meta name="alexaVerifyID" content="FHJFf__R58EVRHH7m1E2faOtyZA" /> <link href="css/style.css" rel="stylesheet" type="text/css"> <? if (isset($use_jquery) && $use_jquery) { ?><script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js"></script><? } ?> </head> <body> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="2" align="left" valign="top"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="29" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="7"><img src="image/header_top-left.jpg" width="7" height="29"></td> <td class="header-top-bg"><table width="100%" border="0" align="right" cellpadding="0" cellspacing="0"> <tr align="left" valign="top"> <td> </td> <td width="356" align="center"><a href="/" class="link_text01">Home</a> <a href="/forums" class="link_text01">Forums</a> <a href="/topsites" class="link_text01">Topsites</a> <a href="http://runescape.com" class="link_text01">Play RuneScape</a></td> </tr> </table></td> <td width="7"><img src="image/header_top-right.jpg" width="7" height="29"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="1" bgcolor="#756649"><img src="image/specer.png" width="1" height="1"></td> <td width="100%" class="header"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="120" align="left" valign="top" class="logo"> </td> </tr> </table></td> <td width="1" align="right" bgcolor="#756649"><img src="image/specer.png" width="1" height="1"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="12" height="25"><img src="image/header-bot-left.jpg" width="12" height="25"></td> <td valign="middle" class="header-bot-bg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="780" align="left" valign="middle" class="normal_text04">.:RuneHints:. The Solution to all your RuneScape Problems</td> <td width="356" height="25" align="right" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="middle"> <td width="100%" height="25" class="normal_text04" align="right" >Today's Date: <?php echo date('l jS \of F Y h:i A'); ?></td> </tr> </table></td> </tr> </table></td> <td width="12" align="right"><img src="image/header-bot-right.jpg" width="12" height="25"></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="5" align="left" valign="top"><img src="image/specer.png" width="1" height="1"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr align="left" valign="top"> <td width="178"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="179" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="8" height="29"><img src="image/leftcol-box1-top-left.jpg" width="8" height="29"></td> <td class="t-header-bg"><div> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="29" align="left" valign="top" class="th"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="30" height="29" align="center" valign="middle"><img src="image/arrow.jpg" width="17" height="9"></td> <td width="5"><img src="image/specer.png" width="1" height="1"></td> <td valign="middle" class="th_text">Main Menu </td> </tr> </table></td> </tr> </table> </div></td> <td width="8"><img src="image/leftcol-box1-top-right.jpg" width="8" height="29"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><ul class="01"> <li ><a href="/">Home </a></li> <li ><a href="/forums">Forums </a></li> <li ><a href="/desktop">Desktop </a></li> <li ><a href="http://rpg.runehints.com/rpg2">Dragon Knight RPG </a></li> <li ><a href="/contact">Contact Us </a></li> <li ><a href="http://www.runehints.com/forums/memberlist.php?mode=leaders">Staff Info </a></li> <li ><a href="/topsites">Top Sites </a></li></ul> </td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="10"><img src="image/leftcol-box1-bot-left.jpg" width="10" height="16"></td> <td class="leftcol-bot-mid-bg"> </td> <td width="10"><img src="image/leftcol-box1-bot-right.jpg" width="10" height="16"></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="5" align="left" valign="top"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="8" height="29"><img src="image/leftcol-box1-top-left.jpg" width="8" height="29"></td> <td valign="middle" class="t-header-bg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="29" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="30" height="29" align="center" valign="middle"><img src="image/arrow.jpg" width="17" height="9"></td> <td width="5"><img src="image/specer.png" width="1" height="1"></td> <td valign="middle" class="th_text">RuneScape Hints </td> </tr> </table></td> </tr> </table></td> <td width="8"><img src="image/leftcol-box1-top-right.jpg" width="8" height="29"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><ul class="02" ><li ><a href="/quest.php">Quests </a></li> <li ><a href="/skills.php">Skills </a></li> <li ><a href="/sreport.php">Special Reports </a></li> <li ><a href="/location.php">Location Guides </a></li> <li ><a href="/map.php">Maps</a></li> <li ><a href="/guild.php">Guild</a></li> <li ><a href="/random.php">Random Events</a></li> <li ><a href="/achi.php">Achievement Diary</a></li> </ul> </td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="10"><img src="image/leftcol-box1-bot-left.jpg" width="10" height="16"></td> <td class="leftcol-bot-mid-bg"> </td> <td width="10"><img src="image/leftcol-box1-bot-right.jpg" width="10" height="16"></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="5" align="left" valign="top"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="8" height="29"><img src="image/leftcol-box1-top-left.jpg" width="8" height="29"></td> <td valign="middle" class="t-header-bg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="29" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="30" height="29" align="center" valign="middle"><img src="image/arrow.jpg" width="17" height="9"></td> <td width="5"><img src="image/specer.png" width="1" height="1"></td> <td valign="middle" class="th_text">RuneScape Data</td> </tr> </table></td> </tr> </table></td> <td width="8"><img src="image/leftcol-box1-top-right.jpg" width="8" height="29"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><ul class="02" ><li ><a href="/due.php">Item Database </a></li> <li ><a href="/due.php">NPC Database </a></li> <li ><a href="/due.php">Monster Database </a></li> <li ><a href="/due.php">Shop Database</a></li> </ul> </td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="10"><img src="image/leftcol-box1-bot-left.jpg" width="10" height="16"></td> <td class="leftcol-bot-mid-bg"> </td> <td width="10"><img src="image/leftcol-box1-bot-right.jpg" width="10" height="16"></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="5" align="left" valign="top"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="8" height="29"><img src="image/leftcol-box1-top-left.jpg" width="8" height="29"></td> <td valign="middle" class="t-header-bg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="29" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="30" height="29" align="center" valign="middle"><img src="image/arrow.jpg" width="17" height="9"></td> <td width="5"><img src="image/specer.png" width="1" height="1"></td> <td valign="middle" class="th_text">RuneScape Tools</td> </tr> </table></td> </tr> </table></td> <td width="8"><img src="image/leftcol-box1-top-right.jpg" width="8" height="29"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><ul class="02" ><li ><a href="/due.php">Skill Calculators</a></li> <li ><a href="/due.php">Combat Calculator </a></li> <li ><a href="/due.php">Max Hit Calculator </a></li> <li ><a href="/due.php">Hiscores </a></li> <li ><a href="/due.php">Skill Signatures </a></li> <li ><a href="/due.php">Goal Signatures </a></li> <li ><a href="/due.php">Race Signatures </a></li> </ul> </td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="10"><img src="image/leftcol-box1-bot-left.jpg" width="10" height="16"></td> <td class="leftcol-bot-mid-bg"> </td> <td width="10"><img src="image/leftcol-box1-bot-right.jpg" width="10" height="16"></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="5" align="left" valign="top"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td height="100" align="center" valign="middle"><br><br><a href="http://runehints.com/topsites/in.php?id=1"> <img src="http://runehints.com/topsites/button.php?id=1" border="0" alt="topsite"> </a><br> <a href="http://www.runescape100.com/"> <img src="http://www.runescape100.com/rankings.php?u=251" alt="Runescape Help & Tips" border="0" /></a><a href="http://www.runescape100.com/namestats-251.htm"> <img src="http://www.runescape100.com/st.gif" alt="Rune Hints" border="0" /><br> <a href="http://www.wizzonline.co.uk/topsitelistings/"> <img src="http://www.wizzonline.co.uk/topsitelistings/button.php?u=gaogier" alt="WizzOnline" border="0"> </a><br> <a href="http://www.zdzira.com/topsite/"> <img src="http://www.zdzira.com/topsite/button.php?u=1" alt="Z-100 Topsite - Runescape Topsite" border="0"> </a><br> <a href="http://www.monsterraids.com"> <img src="http://runehints.com/images/monsterraids.jpg" alt="Monster Raids" border="0"> </a><br> <a href="http://runetower.com/topsite/"> <img src="http://runetower.com/topsite/button.php?u=gaogier" alt="Runescape quests" border="0" /> </a><br></td> </tr> </table></td> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <?php $use_jquery = true; include ('header.inc'); ?> <td width="5"><img src="image/specer.png" width="1" height="1"></td> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="8"><img src="image/th-midbody-left.jpg" width="8" height="29"></td> <td class="t-header-bg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="29" align="center" valign="middle" class="normal_text06">QUEST GUIDES</td> </tr> </table></td> <td width="8"><img src="image/th-midbody-right.jpg" width="8" height="29"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="1" bgcolor="#756649"><img src="image/specer.png" width="1" height="1"></td> <td width="1" bgcolor="#A18E6E"><img src="image/specer.png" width="1" height="1"></td> <td width="1" bgcolor="#474B48"><img src="image/specer.png" width="1" height="1"></td> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="1" align="left" valign="top" bgcolor="#474B48"><img src="image/specer.png" width="1" height="1"></td> </tr> <tr> <td align="left" valign="top" class="box_4"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <?php function questview($id) { require_once ('../mysql_connect.php');//connect to db include ('includes/steps.php'); /* query for item */ $query = "SELECT * FROM quest WHERE id=$id"; $result = mysql_query ($query); /* if we get no results back, error out */ $numrtn = mysql_num_rows($result); if ($numrtn == 0) { echo "The quest guide requested cannot be found\n"; echo $id; return; } $row = mysql_fetch_assoc($result); /* easier to read variables and * striping out tags */ $id = $row['id']; $name = $row['name']; $contributors = $row['contributors']; $guideby = $row['guideby']; $added = $row['added']; $location = $row['startinglocation']; $members = $row['members']; $description = $row['description']; $difficulty = $row['difficulty']; $requirements = $row['requirements']; $items = $row['items']; $reward = $row['reward']; $guide = $row['mainbody']; $length = $row['length']; $updated = $row['updated']; if ($members == "Y") { $mem = "members only quest</b>, so it can only be done on a <b>members</b> server."; }else{ $mem = "non-members quest</b>."; } if ($updated == 0){ $up = 'No-one has updated this quest guide'; }else{ $date2 = date("l jS F Y @ H:i:s ", $updated); $up = 'It was last updated on '.$date2; } if ($contributors != ""){ $con = 'Thanks also to <b>'.$contributors.'</b> for changes.'; }else{ $con = 'No-one else has contributed to this quest guide.'; } //$date = date("D M jS, Y g:i a", $added); $date = date("l jS F Y @ H:i:s ", $added); echo ' <div id="quest"><table width="100%" border="0"> <tr> <td> <h1 align="center">'.$name.'</h1> '; echo step_js(); echo pick_clue($id); echo toggle_reward(); echo toggle_clue(); echo '<br>'; echo ' <p class="text1">This quest guide was written by <b>'.$guideby.'</b> for use on Runehints and entered into the database on '.$date.'. '.$up.'. '.$con.' <br /></p> <p><span class="text1"><br />This quest is <b>'.$mem.'</span></p> <p> <span class="qtitle">Description: </span><span class="text1">'.$description.'</span></p> <p><span class="qtitle">Difficulty Level: </span><span class="text1">'.$difficulty.'</span></p> <p> <span class="qtitle">Requirements: </span><span class="text1">'.$requirements.'</span></p> <p> <span class="qtitle">Items Needed During Quest: </span><span class="text1">'.$items.'</span></p> <p> <span class="qtitle">Starting Location: </span><span class="text1">'.$location.'</span></p> <p><span class="qtitles">Quest Instructions:</span></p>'; echo list_steps($id, true); echo '<p> <div id="rewardwrap" style="display:none;"><span class="qtitle">Reward: </span><span class="text1">'.$reward.'</span></div></p> </td> </tr> </table></div> '; } function selectquest(){ require_once ('../mysql_connect.php');//connect to db global $sitestyle; ?> <?php $result = mysql_query("SELECT * FROM quest"); $num_rows = mysql_num_rows($result); ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top" class="normal_text02"><div align="justify">There are a total of <? echo $num_rows; ?> quest guides in our database. There are Free guides and Member guides. On RuneHints, all guides are free to use, but the Member guides require you to be on a RuneScape Member server to use them.</div></td> </tr> <tr> <td height="15" align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td width="16"><img src="image/011.jpg" width="16" height="26"></td> <td align="left" valign="top" class="quest_033"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="26" align="center" valign="middle" class="normal_text07">FREE QUEST GUIDES</td> </tr> </table></td> <td width="16"><img src="image/022.jpg" width="16" height="26"></td> </tr> </table></td> </tr> <tr> <td align="left" valign="top" class="box_5"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <?php /* query for quests */ $n_query = "SELECT id, name, difficulty, members, sorter FROM quest WHERE members='n' ORDER BY sorter ASC"; $n_result = mysql_query ($n_query); while ($n_row = mysql_fetch_assoc($n_result)) { $n_name = $n_row['name']; //$n_guideby = $n_row['guideby']; $n_difficulty = $n_row['difficulty']; $id = $n_row['id']; /* place table row data in * easier to use variables. * & display the data */ echo '<tr align="left" valign="top"><td width="275" class="normal_text05"><a href="quest.php?flibble=questview&id='.$id.'&ic=1" style="color:#EED8B4;"><b>'.$n_name.'</b></a></td><td> </td><td width="73" class="normal_text05">'.$n_difficulty.'</td></tr>'; } /* finish up table*/ ?> </table></td> </tr> <tr> <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> &
-
First of all, both pages are exactly the same. http://systemmnew.runehints.com/quest.php http://runehints.com/quest.php The header is only slightly different. What pages do you need to see the code? DO you know why this is happening?
-
im going to get my self banned soon... can anyone help me?
-
the login page would use the data from the old phpbb2 forums. Then, it would allow you to login. What i have done, is change the login info, delete the part that checks if a user is active or not (not in phpbb3), then i attempted to login. I cant login, no errors, or anything comes up. I have done some research on this, and it appears that phpbb has changed its password encryption. some people have said they use their own encryption now. I have a few login scripts. They all use this line of code. if(phpbb_check_hash($password, $user->user_password)) They also use a hash.php file. Which i have, and added this to an includes file. This is now my code. <?php include ('diffhead.inc'); ?><img src="images/homepage13.jpg" alt="" width="727" height="48"></td> </tr> <tr> <td><table width="100%" border="0" cellspacing="0" cellpadding="0" id="box4" class="box"> <tr> <td class="content"> <center> <?php include('includes/hash.php'); if(isset($_POST['submit'])){ if(empty($_POST['username'])){ $username = FALSE; $message = '<table width=98% bgcolor=#faf5f4 class=logfail align=center><tr> <td width=40><img src=images/exclamation.gif></td> <td align=left> <b>Login Failed!</b> <br /> No username entered. <br />Please Try again<br /> </table><br /><br />'; }else{ $username = $_POST['username']; } if(empty($_POST['password'])){ $password = FALSE; $message1 = '<br /><table width=98% bgcolor=#faf5f4 class=logfail align=center><tr> <td width=40><img src=images/exclamation.gif></td> <td align=left> <b>Login Failed!</b> <br /> No password entered. <br />Please Try again<br /> </table><br /><br />'; }else{ $password = $_POST['password']; //$password = md5($password1); } //echo $password1 .' ' .$password. ' ' .$username; if($username && $password){ require_once ('../mysql_connect1.php'); $query = "SELECT user_id, username, user_email, user_password, user_sitemod FROM phpbb_users WHERE username='$username' AND user_password='$password' AND user_sitemod = '1'"; $result = mysql_query ($query) or DIE ("Error in query $query" . mysql_error()); $row = mysql_fetch_array ($result); if(mysql_num_rows($result) > 0) { $_SESSION['user_sitemod'] = $row['user_sitemod']; $_SESSION['user_avatar'] = $row['user_avatar']; $_SESSION['user_email'] = $row['user_email']; $_SESSION['username'] = $row['username']; $_SESSION['user_id'] = $row['user_id']; //ob_end_clean(); // include('diffhead.inc'); include ('admin.inc'); echo '<p align="center">You\'ve logged in successfully.</p>'; include('difffooter.inc'); }else{ $message = '<table width=98% bgcolor=#342d25 class=logfail align=center><tr> <td width=40><img src=images/exclamation.gif></td> <td align=left> <B>Login Failed!</B> <BR> The login combination you entered was not found. <BR>Please Try again<br /> </table><br /><br />'; } } } echo '<font face=verdana size=2> <b>Login</b></font><br /><br />'.$message.$message1.' Your browser must allow cookies in order to login.<br />'; ?> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <table width=98% bgcolor=#342d25 class=blueborder align=center> <tr> <td width=40><img src=images/keylogin.gif></td> <td align=right> <B>Username:</B> <br /><br /> <B>Password:</B> <br /></td> <td align=left> <input type="text" name="username" size="10" maxlength="20" class="login" value ="<?php if (isset($_POST['username'])) echo $_POST['username']; ?>" /> <small><i>Please enter your username</i></small><br /><br /> <input type="password" name="password" size="20" maxlength="20" class="login"/> <small><i>Please enter your password</i></small></td></tr> <tr><td width=40></td><td align="center"><input type="submit" name="submit" class="login" value="Login" /></td></tr> </table><br /><br /> </form></center> <?php include ('difffooter.inc'); ?> The code that I know works, but for something different. <html> <body> <?php include('generate_sig.php'); include('includes/hash.php'); include('mysql_connect_sig.php'); if(isset($_POST['submit'])){ if(empty($_POST['username'])){ $username = FALSE; $message = '<table width=98% bgcolor=#faf5f4 class=logfail align=center><tr> <td width=40><img src=images/exclamation.gif></td> <td align=left> <b>Login Failed!</b> <br /> No username entered. <br />Please Try again<br /> </table><br /><br />'; }else{ $username = $_POST['username']; } if(empty($_POST['password'])){ $password = FALSE; $message1 = '<br /><table width=98% bgcolor=#faf5f4 class=logfail align=center><tr> <td width=40><img src=images/exclamation.gif></td> <td align=left> <b>Login Failed!</b> <br /> No password entered. <br />Please Try again<br /> </table><br /><br />'; }else{ $password = $_POST['password']; //$password = md5($password1); } //echo $password1 .' ' .$password. ' ' .$username; if($username && $password){ /* Connect to the database and prepare the signature */ //require_once ('../mysql1_connect1.php'); //echo 'username: ' . USERNAME; $db_connection = mysql_connect(HOST, USERNAME, PASSWORD) or die("Could not connect to DB"); /* Select the database we need */ mysql_select_db(DBNAME, $db_connection) or die("Could not find DB"); $query = "SELECT u.user_id, u.username, u.user_posts, u.user_password, u.user_form_salt, p.pf_runescape_user FROM phpbb_users u, phpbb_profile_fields_data p WHERE u.username='$username' AND u.user_id=p.user_id"; $result = mysql_query($query, $db_connection); if (!$result) { die(mysql_error()); } $user = mysql_fetch_object($result); if($user != NULL) { if(phpbb_check_hash($password, $user->user_password)) { if($user->user_posts < 10) { // User MUST have 10 or more posts in order to get the signature $message = '<table width=98% bgcolor=#faf5f4 class=logfail align=center><tr> <td width=40><img src=images/exclamation.gif></td> <td align=left> <B>Signature Retrieval Failed!</B> <BR> You need to have made at least 10 posts before you can retrieve your signature. </table><br /><br />'; } else { if($user->pf_runescape_user != '') { ?> <form name="myform" action="/dynsig/image.php" method="post"> <input type="hidden" name="username" value="<?php if ($user->pf_runescape_user) echo $user->pf_runescape_user; ?>"> <input type="hidden" name="userid" value="<?php if ($user->user_id) echo $user->user_id; ?>"> </form> <script language="javascript"> document.myform.submit(); </script> <?php } else { $message = '<table width=98% bgcolor=#faf5f4 class=logfail align=center><tr> <td width=40><img src=images/exclamation.gif></td> <td align=left> <b>No Registered Runescape User!</b> <br /><br /> <form name="myform" action="/dynsig/image.php" method="post"> Please enter your Runescape username:<input type="text" name="rsuser" size="10" maxlength="20" class="login" value ="'.$_POST["pf_runescape_user"].'" /> <br /><br /> <input type="hidden" name="userid" value="'.$user->user_id.'"> <input type="submit" name="rs_submit" value="Submit" /> </form> </table><br /><br />'; } } } else { $message = '<table width=98% bgcolor=#faf5f4 class=logfail align=center><tr> <td width=40><img src=images/exclamation.gif></td> <td align=left> <B>Login Failed!</B> <BR> The login combination you entered was not found. <BR>Please Try again<br /> </table><br /><br />'; } } else { $message = '<table width=98% bgcolor=#faf5f4 class=logfail align=center><tr> <td width=40><img src=images/exclamation.gif></td> <td align=left> <B>Login Failed!</B> <BR> The login combination you entered was not found. <BR>Please Try again<br /> </table><br /><br />'; } } } if(!isset($_POST['submit'])){ echo '<font face=verdana size=2 color=#3FC7C9> <b>Login</b></font><br /><br />'.$message.$message1.' Login using your forum account.<br /> You must have a forum account and have set the "Username" field in order to use our dynamic sigs.<br />'; ?> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <table width=98% bgcolor=#f5f8ff class=blueborder align=center><tr> <td align=right> <B>Username:</B> <br /><br /> <B>Password:</B> <br /></td> <td align=left> <input type="text" name="username" size="10" maxlength="20" class="login" value ="<?php if (isset($_POST['username'])) echo $_POST['username']; ?>" /> <small><i>Please enter your forum username</small></i><br /><br /> <input type="password" name="password" size="10" maxlength="20" class="login" value ="<?php if (isset($_POST['password'])) echo $_POST['password']; ?>" /> <small><i>Please enter your forum password</small></i><br /><br /> <tr><td width=40></td><td align="center"><input type="submit" name="submit" class="login" value="Login" /></td></tr> </table><br /><br /> </form> <?php } else { echo($message); } ?> </body> </html> I just need that code somehow merged with my login script. Then it should work, but I dont know what I am doing, and im asking for help`
-
Hello Been looking at scripts that work. there is this line, that seems to pop up. if(phpbb_check_hash($password, $user->user_password)) how could i use that and put it into my script?