Jump to content

Php scripting


Infernalx

Recommended Posts

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

[m]<?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>";

 

?>

Link to comment
Share on other sites

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

    Echo "<img src='{$v}.jpg' />";
}
however the space in the names might cause a problem. I would advise adding an underscore or some connecting character instead

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.