[PHP] Search.php

[Merchant]

I want the script to show, vocation, residence and position.
But it seems that it shows the vocation ID, and nothing atht eresidence and position.

This is my codes:

<?

////////////////////////////////////
//	Script
////////////////////////////////////

	if(empty($_GET["name"])){
		echo "<script src=\"ajax/javascript_search.js\"></script>\n";
		echo "<h3>Search player:</h3>\n";
		echo "<form method=\"post\">\n";
		echo "<p>Name: <input name=\"search_name\" OnKeyUp=\"showHint(this.value)\"></p>\n";
		echo "<p>Suggestions: <span id=\"txtHint\"></span></p> ";
		echo "<p><input type=\"submit\" value=\"Search\"></p>\n";
		echo "</form>\n";
		echo $player_dont_exist;
	}else{
		$name = preg_replace("/_/", " ", $_GET["name"]);
		$player_data = mysql_query("SELECT * FROM players WHERE name='$name'") or die(mysql_error());
		if (mysql_num_rows($player_data) == 0){
			echo "<h3>Player dont exist!</h3>\n";
		}else{
			$data = mysql_fetch_array( $player_data );
			echo "<h3>".$name.": </h3>\n";
			echo "<p>Level: ".$data['level']."</p>\n";
			echo "<p>Vocation: ".$data['vocation']."</p>\n";
			echo "<p>Magic level: ".$data['maglevel']."</p>\n";
			echo "<p>Recidence: Under Construction ".$data['townid']."</p>\n";
			echo "<p>Position: <red>Under Construction<red> ".$data['groupid']."</p>\n";
			$id = $data['id'];
			$player_skills = mysql_query("SELECT * FROM player_skills WHERE player_id='$id'") or die(mysql_error());
				while($data = mysql_fetch_array( $player_skills)){
					switch($data['skillid']){
					

					}
				}
				



		}
	}
?>

I'll be glad for some help as fast as possible!
Merchant.

 

[Chris]

<?

////////////////////////////////////
//    Script
////////////////////////////////////

    if(empty($_GET["name"])){
        echo "<script src=\"ajax/javascript_search.js\"></script>\n";
        echo "<h3>Search player:</h3>\n";
        echo "<form method=\"post\">\n";
        echo "<p>Name: <input name=\"search_name\" OnKeyUp=\"showHint(this.value)\"></p>\n";
        echo "<p>Suggestions: <span id=\"txtHint\"></span></p> ";
        echo "<p><input type=\"submit\" value=\"Search\"></p>\n";
        echo "</form>\n";
        echo $player_dont_exist;
    }else{
        $name = preg_replace("/_/", " ", $_GET["name"]);
        $player_data = mysql_query("SELECT * FROM players WHERE name='$name'") or die(mysql_error());
        if (mysql_num_rows($player_data) == 0){
            echo "<h3>Player dont exist!</h3>\n";
        }else{
            $data = mysql_fetch_array( $player_data );
            echo "<h3>".$name.": </h3>\n";
            echo "<p>Level: ".$data['level']."</p>\n";
            echo "<p>Vocation: ".$data['vocation']."</p>\n";
            echo "<p>Magic level: ".$data['maglevel']."</p>\n";
            echo "<p>Recidence: ".$data['town_id']."</p>\n";
            echo "<p>Position: X: ".$data['posx'].", Y: ".$data['posy'].", Z: ".$data['posz']."</p>\n";
            $id = $data['id'];
            $player_skills = mysql_query("SELECT * FROM player_skills WHERE player_id='$id'") or die(mysql_error());
                while($data = mysql_fetch_array( $player_skills)){
                    switch($data['skillid']){
                    

                    }
                }
                



        }
    }
?>

Try that, although it will only show the town ID, not the name of it. If you'd like that, tell me all your town names (including their ID obviously).

 

[Merchant]

I ment position such as "tutor, gamemaster" or only a normal "player". GROUP ID.

Also, the vocation still shows "0"

 

[Chris]

Oooh hahah, sorry 'bout that.

<?

////////////////////////////////////
//    Script
////////////////////////////////////

    if(empty($_GET["name"])){
        echo "<script src=\"ajax/javascript_search.js\"></script>\n";
        echo "<h3>Search player:</h3>\n";
        echo "<form method=\"post\">\n";
        echo "<p>Name: <input name=\"search_name\" OnKeyUp=\"showHint(this.value)\"></p>\n";
        echo "<p>Suggestions: <span id=\"txtHint\"></span></p> ";
        echo "<p><input type=\"submit\" value=\"Search\"></p>\n";
        echo "</form>\n";
        echo $player_dont_exist;
    }else{
        $name = preg_replace("/_/", " ", $_GET["name"]);
        $player_data = mysql_query("SELECT * FROM players WHERE name='$name'") or die(mysql_error());
        if (mysql_num_rows($player_data) == 0){
            echo "<h3>Player dont exist!</h3>\n";
        }else{
            if ( $data['vocation'] == 0 )
                $vocation = 'None';
            elseif ( $data['vocation'] == 1 )
                $vocation = 'Sorcerer';
            elseif ( $data['vocation'] == 2 )
                $vocation = 'Druid';
            elseif ( $data['vocation'] == 3 )
                $vocation = 'Paladin';
            elseif ( $data['vocation'] == 4 )
                $vocation = 'Knight';
            elseif ( $data['vocation'] == 5 )
                $vocation = 'Master Sorcerer';
            elseif ( $data['vocation'] == 6 )
                $vocation = 'Elder Druid';
            elseif ( $data['vocation'] == 7 )
                $vocation = 'Royal Paladin';
            elseif ( $data['vocation'] == 8 )
                $vocation = 'Elite Knight';
            if ( $data['group_id'] == 2 )
                $position = "Gamemaster";
            elseif ( $data['group_id'] == 3 )
                $position = "GOD";
            else
                $position = "None";
            
            $data = mysql_fetch_array( $player_data );
            echo "<h3>".$name.": </h3>\n";
            echo "<p>Level: ".$data['level']."</p>\n";
            echo "<p>Vocation: ".$vocation."</p>\n";
            echo "<p>Magic level: ".$data['maglevel']."</p>\n";
            echo "<p>Recidence: ".$data['town_id']."</p>\n";
            echo "<p>Position: ".$position."</p>\n";
            $id = $data['id'];
            $player_skills = mysql_query("SELECT * FROM player_skills WHERE player_id='$id'") or die(mysql_error());
                while($data = mysql_fetch_array( $player_skills)){
                    switch($data['skillid']){
                    

                    }
                }
                



        }
    }
?>