Jump to content

gaogier

Members
  • Posts

    84
  • Joined

  • Last visited

Everything posted by gaogier

  1. 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]
  2. 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?
  3. 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?
  4. IT is an attachment in the first post. Any ideas on how to fix this?
  5. 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]
  6. 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.
  7. 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
  8. 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
  9. Yes, I know, I have put back the old totals.inc file
  10. 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)
  11. still no difference. I may note, I am a complete novice at php. Never could get it undermy belt.
  12. 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.
  13. 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?
  14. 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
  15. 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?
  16. 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.
  17. 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(); ?>
  18. 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'); ?>
  19. 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"> &
  20. 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?
  21. im going to get my self banned soon... can anyone help me?
  22. 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`
  23. 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?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.