How to Make an Improved Rank Page? Help Me Out!! [SOLVED]

Gunner · Post by **Gunner** » Sat Oct 15, 2011 12:22 am

I am having trouble to make a search box. See image below

Do I need to put "Use Ctrl F to Search manually your targetted player"?
I think not, because some big game site like Travian already put a searchbox on their rank page. Now my question is how to limiting the rank page? So per page is player rank 1-20, and then the next page rank 21-40, and how to put a searchbox?

Thank you very much if you're willing to help.

Gunner · Post by **Gunner** » Sat Oct 15, 2011 12:35 am

Ok now I have my next question/problem....

Why do line breaks are not visible on my profile page?
see, when I'm editing text

now here is the result

AND SOMETIMES IT GOES LIKE THIS

PLEASE HELP ME WITH THIS CASE....
THIS IS MY PROFILE.PHP

Code: Select all

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><? include "conf/title.php"; ?></title>
<? include_once "conf/additional_header.php"; ?>
<? include_once "conf/javascript.php"; ?>
<? include_once "conf/icon.php"; ?>
<link rel="stylesheet" type="text/css" href="gpack/style.css" />
<script type="text/javascript" src="jscript/bullet.js">
</script>
</head>

<body ondragstart="return 
false" onselectstart="return false">
<?php
 session_start();
include "conf/connect.php";
if (isset($_SESSION['player']))
{
  $player=$_SESSION['player'];
}
else
{
  header('Location: login.php');
  exit;
}
?><? include "conf/player_status.php"; ?>
<script type="text/javascript" language="javascript" src="jscript/wz_tooltip.js">
</script>
<div align="center">
<div id="HeaderImage"><? include "navbar.php"; ?>
</div>
<br />
<? include_once "conf/javascript_body.php"; ?>
<table width="1110" border="0">
  <tr>
    <td style="border-right: 1px dashed grey;" width="167" height="602" class="tdTop"><? include "game_sidebar.php"; ?></td>
    <td class="tdTop" width="622"><div align="center"><? include "resource.php"; ?></div><div class="Heading"><h1>Profile</h1></div><div class="Link" align="center"><a href="#">Links goes here...</a></div><br /><div align="center"><table class="gridtable" width="446" border="1">
  <tr>
    <th colspan="2">Player's Profile</th>
  </tr>
  <tr>
    <td width="222" height="358" class="tdTop"><table width="228" border="0" class="normal">
      <tr>
        <td width="76">UID:</td>
        <td width="142"><?
		if (isset($_GET['id']))
		{
		$id = $_GET['id'];
		$playerinfo="SELECT * from players where id='$id'";
$playerinfo2=mysql_query($playerinfo) or die("could not get player stats!");
$playerinfo3=mysql_fetch_array($playerinfo2);
$uid = $playerinfo3['id'];
$name = $playerinfo3['name'];
$population = $playerinfo3['population'];
$ally = $playerinfo3['ally'];
$class = $playerinfo3['class'];
$tribe = $playerinfo3['tribes'];
echo "$uid";
		}
		else
		{
		echo "$playerid";
		}

		 ?></td>
      </tr>
      <tr>
        <td width="76">Nickname:</td>
        <td width="142"><? if (isset($_GET['id']))
		{
		echo "$name";
		 }
		 else
		 {
		 echo "$playername";
		 }
		  ?></td>
      </tr>
      <tr>
        <td width="76">Population:</td>
        <td width="142"><? if (isset($_GET['id']))
		{
		echo "$population";
		 }
		 else
		 {
		 echo "$playerpop";
		 }
		  ?></td>
      </tr>
      <tr>
        <td width="76">Alliance:</td>
        <td width="142"><?

		if (isset($_GET['id']))
		{
		 
		if ($playerinfo3['ally'] == '-')
		{
		 echo "$ally";
		 }
		 else
		 {
		 $allyinfo="SELECT * from ally where name='$ally'";
$allyinfo2=mysql_query($allyinfo) or die("could not get player stats!");
$allyinfo3=mysql_fetch_array($allyinfo2);
		 echo "<span class='Link'><a href='ally.php?$allyinfo3[id]'>$ally</a></span>";
		 }
		 }
		 else
		 {
		 echo "$playerally";
		 }
		  ?></td>
      </tr>
      <tr>
        <td width="76">Tribe</td>
        <td width="142"><? if (isset($_GET['id']))
		{
		echo "$tribe";
		 }
		 else
		 {
		 echo "$playertribes";
		 }
		  ?></td>
      </tr>
      <tr>
        <td width="76"></td>
        <td width="142"><? if (isset($_GET['id']))
		{
		echo " ";
		}
		if (isset($_GET['id']))
		{
		$id = $_GET['id'];
		if ($id == $playerid)
		{
		echo "<span class='Link'><a href='?action=edit'>» Edit Profile</a></span>";
		}
		}
		else
		{
		echo "<span class='Link'><a href='?action=edit'>» Edit Profile</a></span>";
		} ?></td>
      </tr>
      <tr>
        <td height="209" colspan="2"><hr color="#009900" noshade="noshade" />
        <?
		if (isset($_GET['action']))
		{
		$action = $_GET['action'];
		if ($action == 'edit')
		{

		$profileinfo="SELECT * from profile where pid='$playerid'";
$profileinfo2=mysql_query($profileinfo) or die("could not get player stats!");
$profileinfo3=mysql_fetch_array($profileinfo2);
		echo "<form action='?action=done' method='post'><textarea class='InputProfile' name='profileText1' cols='34' rows='13'>$profileinfo3[text1]</textarea>";
		}
		}
		 ?><?
		 if (isset($_GET['id']))
		 {
		 $pid = $_GET['id'];
		 		$profileinfo="SELECT * from profile where pid='$pid'";
$profileinfo2=mysql_query($profileinfo) or die("could not get player stats!");
$profileinfo3=mysql_fetch_array($profileinfo2);
echo "<div align='center' class='Standard'>$profileinfo3[text1]</div>";
		 }
		 else if (isset($_GET['action']))
		 {
		 $action = $_GET['action'];
		 if ($action == 'edit')
		 {
		 echo "";
		 }
		 }
		 
		 else
		 {
		 $profileinfo="SELECT * from profile where pname='$playername'";
$profileinfo2=mysql_query($profileinfo) or die("could not get player stats!");
$profileinfo3=mysql_fetch_array($profileinfo2);
echo "<div align='center' class='Standard'>$profileinfo3[text1]</div>";
		 }
		  ?>        </td>
      </tr>
    </table></td>
    <td width="208" class="tdTop"><?
		 if (isset($_GET['id']))
		 {
echo "<div align='center' class='Standard'>$profileinfo3[text2]</div>";
		 }
		 else if (isset($_GET['action']))
		 {
		 $action = $_GET['action'];
		 if ($action == 'edit')
		 {
		 echo "<textarea class='InputProfile' name='profileText2' cols='35' rows='26'>$profileinfo3[text2]</textarea>";
		 }
		 }
		 else
		 {
echo "<div align='center' class='Standard'>$profileinfo3[text2]</div>";
		 }
		  ?><?
		   if (isset($_GET['action']))
		 {
		 $action = $_GET['action'];
		 if ($action = 'edit')
		 {
		 if (isset($_POST['submit']))
		 {
		 $text1 = $_POST['profileText1'];
		 $text2 = $_POST['profileText2'];
$updateprofile1="update profile set text1='$text1' where pname='$player'";
                  mysql_query($updateprofile1) or die("Could not update player");
				  
				  $updateprofile2="update profile set text2='$text2' where pname='$player'";
                  mysql_query($updateprofile2) or die("Could not update profile");
				  
				  echo "<span class='Link'><div align='center'><a href='profile.php'>Click here to refresh, to see your updated profile</a></div></span>";
				  
		 }
		 }
		 }
		  
		   ?></td>
  </tr>
</table>
</div><?
if (isset($_GET['action']))
		{
		$action = $_GET['action'];
		if ($action == 'edit')
		{
		echo "<br /><div align='center'><input type='submit' name='submit' id='submit' class='Button' value='Save' /></div></form>";
		}
		}
 ?></td>
    <td class="tdTop" style="border-left: 1px dashed grey;" width="307"><? include "game_rightbar.php"; ?></td>
  </tr>
</table>
<? include "footer.php"; ?>
</div>
</body>
</html>

Gunner · Post by **Gunner** » Fri Nov 11, 2011 1:45 pm

ZZZZ
can somebody help me out!!!

Winawer · Post by **Winawer** » Fri Nov 11, 2011 2:26 pm

The textarea uses \n for new lines, not <br />. You can use nl2br when outputting the text to get the line breaks.

The update failing is probably caused by not sanitizing your inputs. See http://php.net/manual/en/function.mysql ... string.php

You can use LIMIT in MySQL to limit the amount of players on the rank page. See http://dev.mysql.com/doc/refman/5.0/en/select.html

Gunner · Post by **Gunner** » Thu Nov 17, 2011 10:26 am

I have look the nl2br, but where do I supposed to put this?
string nl2br ( string $string [, bool $is_xhtml = true ] )
On my database? How?

Chris · Post by **Chris** » Thu Nov 17, 2011 12:57 pm

Somewhere in your code you have this... I don't know what line, do a search:

Code: Select all

echo "<div align='center' class='Standard'>$profileinfo3[text1]</div>";

This is how you want to use nl2br:

Code: Select all

echo '<div align="center" class="Standard">' . nl2br($profileinfo3['text1']) . '</div>';

Gunner · Post by **Gunner** » Sun Nov 20, 2011 9:57 am

OMG thank you so much, It really works!!!

but can you tell me, why it cannot update profile? How do I fix that?
and how to make a searchbox on the rankpage? thank you...
btw, you can talk with me on Yahoo! Messenger
YM: rafli_diaz
We can talk more about this...

dbest · Post by **dbest** » Sun Nov 20, 2011 1:04 pm

http://lmgtfy.com/?q=php+search+box+tutorial

Gunner · Post by **Gunner** » Tue Nov 22, 2011 9:13 am

Hi...
I'm still confused having inputs to be sanitized. Can you help me sanitizing the input? Yes, I am pretty new in PHP. I would like to thank to all of you who have helped me out...

metacatdud · Post by **metacatdud** » Tue Nov 22, 2011 9:54 pm

Here is my full-proof function that will keep you out of trouble

Code: Select all

function sanitize($var)
{
	return addslashes (htmlentities (prepreq(utf8_decode ($var)), ENT_QUOTES));
}

Now there is function there called prepreq that you will not recognize. Here it is:

Code: Select all

function prepreq($var)
{
	return isset ($_REQUEST [$var]) ? $_REQUEST [$var] : "";
}

Now that is for form, i use _REQUEST to save time on who post and who get and to avoid errors that some of those functions will output if no argument is provided.

For passed strings that you my need this (Well is paranoia but ...)

Code: Select all

function sanitizestr($var)
{
	return addslashes (htmlentities (utf8_decode($var), ENT_QUOTES));
}

Use them but google about those function to proper understand this functions

How to Make an Improved Rank Page? Help Me Out!! [SOLVED]

How to Make an Improved Rank Page? Help Me Out!! [SOLVED]

Re: How to Make an Improved Rank Page? Help Me Out!!

Re: How to Make an Improved Rank Page? Help Me Out!!

Re: How to Make an Improved Rank Page? Help Me Out!!

Re: How to Make an Improved Rank Page? Help Me Out!!

Re: How to Make an Improved Rank Page? Help Me Out!!

Re: How to Make an Improved Rank Page? Help Me Out!!

Re: How to Make an Improved Rank Page? Help Me Out!!

Re: How to Make an Improved Rank Page? Help Me Out!!

Re: How to Make an Improved Rank Page? Help Me Out!!