Question(about php Scripting

05/12/2011 04:17 cjm299#1
First of all hello, OK,there's my question first of all nothing its wrong with this php script but i want to know how to add a image as result of each classes example
$classes = array('0' => "Azure Knight", '1' => "Segita Hunter", '2' => "Incar Magician", '3' => "Vicious Summoner", '4' => "Segnale", '5' => "Bagi Warrior");
i want to change those result Azure,segita,etc for a image like azure.jpg ,dont know how to explain it better...Thanks for read
PHP Code:
<?php

    $msconnect = mssql_connect("localhost","sa","sacha29");

echo "<center>Top 50 List<br><font size='1'>Sortiert nach Level</font><br>";

echo "<table border='1'>
    <tr>
        <td align='center'>Pos.</td>
        <td align='center'>Char.Name</td>
        <td align='center'>Level</td>
        <td align='center'>Class</td>
        <td align='center'>Guild</td>
        <td align='center'>PK's</td>
        <td align='center'>PvP's</td>
    </tr>";

$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']) or die("Verbinndung zum MSSQL Server fehlgeschlagen,bitte zu einem späteren zeitpunkt erneut probieren.");

$result1 = mssql_query("
    SELECT c.character_name,c.wLevel,c.byPCClass,c.dwPVPPoint,c.wPKCount,
    (SELECT guild_code FROM character.dbo.GUILD_CHAR_INFO WHERE character_name = c.character_name) AS guildcode
    FROM character.dbo.user_character AS c
    WHERE character_name <> '[' AND character_name <> ']' AND user_no < '9999999999' 
    ORDER BY wLevel DESC,dwExp DESC",$con);

$i = '1';

$classes = array('0' => "Azure Knight", '1' => "Segita Hunter", '2' => "Incar Magician", '3' => "Vicious Summoner", '4' => "Segnale", '5' => "Bagi Warrior");  

while($row1 = mssql_fetch_row($result1)) {

    if($i >= '0' || $i <= '50') { 

        if(!preg_match("/[[]/i",$row1[0])) {

            if(empty($row1[5])) {
                $guildname = "No Guild";
            } else {
                $result2 = mssql_query("SELECT guild_name FROM character.dbo.GUILD_INFO WHERE guild_code = '".$row1[5]."'",$con);
                $row2 = mssql_fetch_row($result2);
                $guildname = $row2[0];
            }

            echo "<tr>
                <td align='center'>".$i."</td>
                <td align='center'>".$row1[0]."</td>
                <td align='center'>".$row1[1]."</td>
                <td align='center'>".$classes[$row1[2]]."</td>
                <td align='center'>".$guildname."</td>
                <td align='center'>".$row1[4]."</td>
                <td align='center'>".$row1[3]."</td>
            </tr>";

            $i++;

        }

    }

}

echo "</table></center>";

?>
05/13/2011 06:00 Vaidas B#2
#reported spam (#2) and wrong section (1#)
05/13/2011 11:01 ~Kakkarot~#3
#deleted
#moved
05/14/2011 03:26 Decima#4
PHP Code:
<?php 

    $msconnect = mssql_connect("localhost","sa","sacha29"); 

echo "<center>Top 50 List<br><font size='1'>Sortiert nach Level</font><br>"; 

echo "<table border='1'> 
    <tr> 
        <td align='center'>Pos.</td> 
        <td align='center'>Char.Name</td> 
        <td align='center'>Level</td> 
        <td align='center'>Class</td> 
        <td align='center'>Guild</td> 
        <td align='center'>PK's</td> 
        <td align='center'>PvP's</td> 
    </tr>"; 

$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']) or die("Verbinndung zum MSSQL Server fehlgeschlagen,bitte zu einem späteren zeitpunkt erneut probieren."); 

$result1 = mssql_query(" 
    SELECT c.character_name,c.wLevel,c.byPCClass,c.dwPVPPoint,c.wPKCount, 
    (SELECT guild_code FROM character.dbo.GUILD_CHAR_INFO WHERE character_name = c.character_name) AS guildcode 
    FROM character.dbo.user_character AS c 
    WHERE character_name <> '[' AND character_name <> ']' AND user_no < '9999999999'  
    ORDER BY wLevel DESC,dwExp DESC",$con); 

$i = '1'; 

$classes = array('0' => "Azure Knight", '1' => "Segita Hunter", '2' => "Incar Magician", '3' => "Vicious Summoner", '4' => "Segnale", '5' => "Bagi Warrior");   

$classimg = array('0' => "ak.jpg", '1' => "hunter.jpg", '2' => "mage.jpg", '3' => "summy.jpg", '4' => "seg.jpg", '5' => "bagi.jpg");   


while($row1 = mssql_fetch_row($result1)) { 

    if($i >= '0' || $i <= '50') {  

        if(!preg_match("/[[]/i",$row1[0])) { 

            if(empty($row1[5])) { 
                $guildname = "No Guild"; 
            } else { 
                $result2 = mssql_query("SELECT guild_name FROM character.dbo.GUILD_INFO WHERE guild_code = '".$row1[5]."'",$con); 
                $row2 = mssql_fetch_row($result2); 
                $guildname = $row2[0]; 
            } 

            echo "<tr> 
                <td align='center'>".$i."</td> 
                <td align='center'>".$row1[0]."</td> 
                <td align='center'>".$row1[1]."</td> 
                <td align='center'>".$classes[$row1[2]]."<br /><img src='images/".$classimg[$row1[2]]."'></td> 
                <td align='center'>".$guildname."</td> 
                <td align='center'>".$row1[4]."</td> 
                <td align='center'>".$row1[3]."</td> 
            </tr>"; 

            $i++; 

        } 

    } 

} 

echo "</table></center>"; 

?>
untested, but name ur images like so:

ak.jpg
hunter.jpg
mage.jpg
summy.jpg
seg.jpg
bagi.jpg

put them in a folder called images that should be in the same folder as this script.

then u should see ur image below the class name, if you dont want the class name showing, just take out this part:

PHP Code:
".$classes[$row1[2]]."<br />