mssql/Odbc Connection

[Mslolita]

I found a top 100 ranking script including a mssql_connect

is there a way to make it a odbc connection instead of mssql?
if not can anyone tell me how this should be connected to the server like mssql_connect

<?php 
	$host="......";
    $user = "....."; 
    $pw = "..."; 
    $db = "..."; 
	$i="0";
	$counter=1;
           
    $connect = mssql_connect($host,$user,$pw)
    or die("Can't connect to the datebase."); 
     
    mssql_select_db($db,$connect) 
    or die("Can't select the datebase");
	  mssql_select_db($db,$connect);
	
	$Query="SELECT Top 100  name , exp, lv, job,jlv,permission, login_time,login_time,pkc from Telecaster . dbo.Character 
where permission ='0' and name not like '@%' order by exp desc";
	
	$Result = mssql_query($Query);
	?>

<table class="tabclass" >		
<tr bgcolor='#121212' align='center' height='40px'>
<td width='2%' bgcolor='#b41706'>¹</td>
<td width='82%' bgcolor='#b41706'>Èìÿ</td>
<td width='3%' bgcolor='#b41706'>Óðîâåíü</td>
<td width='3%' bgcolor='#b41706'>Óð.Ïð</td>
<td width='3%' bgcolor='#b41706'>Êîëè÷åñòâî óáèéñòâ</td>
<td width='3%' bgcolor='#b41706'>Ïðîôåññèÿ</td>
<?php
error_reporting( E_ERROR ); 
while($Row=mssql_fetch_array($Result)){
if ($counter % 2 == 0)
			 echo "<tr bgcolor='#e60f17' align='center'>";
	else     echo "<tr bgcolor='#c5632a' align='center'>";
			echo "<td>",$counter,"</td><td color='#1e1e1e'>",$Row["name"],"</td><td>",$Row["lv"],"</td><td>",$Row["jlv"],"</td><td>",$Row["pkc"],"</td><td>";

switch ($Row["job"])
{
 case 100 : echo "<div align='center'><img src='images/class/100.jpg' alt='Ñòðàííèê'>"; break;
 case 101 : echo "<div align='center'><img src='images/class/101.jpg' alt='Êàäåò'>"; break;
 case 102 : echo "<div align='center'><img src='images/class/102.jpg' alt='Øàìàí'>"; break;
 case 103 : echo "<div align='center'><img src='images/class/103.jpg' alt='Çàêëèíàòåëü'>"; break;
 case 110 : echo "<div align='center'><img src='images/class/110.jpg' alt='Ñîëäàò'>"; break;
 case 111 : echo "<div align='center'><img src='images/class/111.jpg' alt='Ñòðåëîê'>"; break;
 case 112 : echo "<div align='center'><img src='images/class/112.jpg' alt='Äðóèä'>"; break;
 case 113 : echo "<div align='center'><img src='images/class/113.jpg' alt='Çíàõàðü'>"; break;
 case 114 : echo "<div align='center'><img src='images/class/114.jpg' alt='Êîëäóí'>"; break;
 case 120 : echo "<div align='center'><img src='images/class/120.jpg' alt='(Ìàñòåð-Êëàññ Ñîëäàòà)'>"; break;
 case 121 : echo "<div align='center'><img src='images/class/121.jpg' alt='(Ìàñòåð-Êëàññ Ñòðåëêà)'>"; break;
 case 122 : echo "<div align='center'><img src='images/class/122.jpg' alt='(Ìàñòåð-Êëàññ Äðóèäà)'>"; break;
 case 123 : echo "<div align='center'><img src='images/class/123.jpg' alt='(Ìàñòåð-Êëàññ Çíàõàðÿ)'>"; break;
 case 124 : echo "<div align='center'><img src='images/class/124.jpg' alt='(Ìàñòåð-Êëàññ Êîëäóíà)'>"; break;
 case 200 : echo "<div align='center'><img src='images/class/200.jpg' alt='Ñëåäîïûò'>"; break;
 case 201 : echo "<div align='center'><img src='images/class/201.jpg' alt='Ïàëàäèí'>"; break;
 case 202 : echo "<div align='center'><img src='images/class/202.jpg' alt='Âîëøåáíèê'>"; break;
 case 203 : echo "<div align='center'><img src='images/class/203.jpg' alt='Çâåðîëîâ'>"; break;
 case 210 : echo "<div align='center'><img src='images/class/210.jpg' alt='Ðûöàðü'>"; break;
 case 211 : echo "<div align='center'><img src='images/class/211.jpg' alt='Êðåñòîíîñåö '>"; break;
 case 212 : echo "<div align='center'><img src='images/class/212.jpg' alt='Êàïåëëàí '>"; break;
 case 213 : echo "<div align='center'><img src='images/class/213.jpg' alt='Êëèðèê '>"; break;
 case 214 : echo "<div align='center'><img src='images/class/214.jpg' alt='Ñòðàííèê'>"; break;
 case 220 : echo "<div align='center'><img src='images/class/220.jpg' alt='(Ìàñòåð-Êëàññ Ðûöàðÿ)'>"; break;
 case 221 : echo "<div align='center'><img src='images/class/221.jpg' alt='(Ìàñòåð-Êëàññ Êðåñòîíîñöà)'>"; break;
 case 222 : echo "<div align='center'><img src='images/class/222.jpg' alt='(Ìàñòåð-Êëàññ Êàïïåëàíà)'>"; break;
 case 223 : echo "<div align='center'><img src='images/class/223.jpg' alt='(Ìàñòåð-Êëàññ Êëèðèêà)'>"; break;
 case 224 : echo "<div align='center'><img src='images/class/224.jpg' alt='(Ìàñòåð-Êëàññ Äðåññèðîâùèêà)'>"; break;
 case 300 : echo "<div align='center'><img src='images/class/300.jpg' alt='Áðîäÿãà'>"; break;
 case 301 : echo "<div align='center'><img src='images/class/301.jpg' alt='Íàåìíèê'>"; break;
 case 302 : echo "<div align='center'><img src='images/class/302.jpg' alt='Íåîôèò'>"; break;
 case 303 : echo "<div align='center'><img src='images/class/303.jpg' alt='Àäåïò'>"; break;
 case 310 : echo "<div align='center'><img src='images/class/310.jpg' alt='Àññàñèí '>"; break;
 case 311 : echo "<div align='center'><img src='images/class/311.jpg' alt='Îõîòíèê '>"; break;
 case 312 : echo "<div align='center'><img src='images/class/312.jpg' alt='Ìàã õàîñà'>"; break;
 case 313 : echo "<div align='center'><img src='images/class/313.jpg' alt='×åðíîêíèæíèê '>"; break;
 case 314 : echo "<div align='center'><img src='images/class/314.jpg' alt='×àðîäåé'>"; break;
 case 320 : echo "<div align='center'><img src='images/class/320.jpg' alt='(Ìàñòåð-Êëàññ Àññàñèíà)'>"; break;
 case 321 : echo "<div align='center'><img src='images/class/321.jpg' alt='(Ìàñòåð-Êëàññ Îõîòíèêà)'>"; break;
 case 322 : echo "<div align='center'><img src='images/class/322.jpg' alt='(Ìàñòåð-Êëàññ Ìàãà Õàîñà)'>"; break;
 case 323 : echo "<div align='center'><img src='images/class/323.jpg' alt='(Ìàñòåð-Êëàññ ×åðíîêíèæíèêà)'>"; break;
 case 324 : echo "<div align='center'><img src='images/class/324.jpg' alt='(Ìàñòåð-Êëàññ ×àðîäåÿ)'>"; break;
}
echo "</div></td></tr>";
if ($counter==100)
    break;
else
    $counter++;
	}
	echo "</table>";
mssql_close($connect);
?>

[marekrndr]

You should learn the basic PHP first.

[ismokedrow]

Google "SQLSRV PHP Driver 3.0"

It replaced the MSSQL API

[Sajital]

nulled

[Mslolita]

nice thanks !

i saw a online status on 1 of the pservers like this character (name) Online/Ofline Last login time 30 min example

you know how to insert this in the same script?

Originally Posted by Sajital

i did it for odbc, first of all;
You must active odbc;

ps: (Ekle = Add, Son= End, ileri = Next )



download:


-

[marekrndr]

Originally Posted by Mslolita

you know how to insert this in the same script?

<?php
$con = mysql_connect("server name","username","password");
if (!$con)
  {
  die('Error connecting: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query(SELECT TOP 10 account, name, lv, jlv, exp, huntaholic_point, chaos, gold FROM Telecaster.dbo.Character WHERE name NOT LIKE '%@%' AND lv < 170 AND permission = 0 ORDER by lv DESC");

echo "<table border='1'>
<tr>
<th>Account</th>
<th>Character</th>
<th>Level</th>
<th>Job level</th>
<th>Experience</th>
<th>Gen points</th>
<th>Lak points</th>
<th>Ruppee</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['account'] . "</td>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['lv'] . "</td>";
  echo "<td>" . $row['jlv'] . "</td>";
  echo "<td>" . $row['exp'] . "</td>";
  echo "<td>" . $row['huntaholic_point'] . "</td>";
  echo "<td>" . $row['chaos'] . "</td>";
  echo "<td>" . $row['gold'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>