web script : top25 GRB

bulgaria · 07/15/2011, 22:56

Hi guys , dont like to speek more that case in need of that.
Just use copy/paste !

PHP Code:


			
<?php
$server = '127.0.0.1';
$dbuser = 'Shaiya';
$dbpass = 'Shaiya123';
$count=1;


$conn = mssql_connect($server, $dbuser, $dbpass)
  or die("Couldn't connect to SQL Server on $myServer");
  
$query = "SELECT top 25* FROM PS_GameData.dbo.Guilds ORDER BY GuildPoint desc";

$result = mssql_query($query);

echo "<html><head><STYLE TYPE=\"text/css\">
<!--
td { background:url(image.png) no-repeat; }
td.i0{ background-position: 0 0; width: 28px; height: 16px; } 
td.i1{ background-position: 0 -26px; width: 28px; height: 16px; } 
td.i2{ background-position: 0 -52px; width: 28px; height: 16px; } 
td.i3{ background-position: 0 -78px; width: 29px; height: 16px; } 
td.i4{ background-position: 0 -104px; width: 29px; height: 15px; } 
td.i5{ background-position: 0 -129px; width: 28px; height: 18px; } 
td.i6{ background-position: 0 -157px; width: 30px; height: 17px; } 
td.i7{ background-position: 0 -184px; width: 29px; height: 17px; } 
td.i8{ background-position: 0 -211px; width: 28px; height: 16px; } 
td.i9{ background-position: 0 -237px; width: 28px; height: 18px; } 
td.i10{ background-position: 0 -265px; width: 29px; height: 18px; } 
td.i11{ background-position: 0 -293px; width: 29px; height: 24px; } 
td.i12{ background-position: 0 -327px; width: 29px; height: 18px; } 
td.i13{ background-position: 0 -355px; width: 29px; height: 18px; } 
td.i14{ background-position: 0 -383px; width: 29px; height: 18px; } 
td.i15{ background-position: 0 -411px; width: 29px; height: 18px; } 
td.i16{ background-position: 0 -439px; width: 29px; height: 18px; } 
td.i17{ background-position: 0 -467px; width: 24px; height: 24px; } 
td.i18{ background-position: 0 -501px; width: 24px; height: 24px; } 
td.i19{ background-position: 0 -535px; width: 24px; height: 24px; } 
td.i20{ background-position: 0 -569px; width: 24px; height: 24px; } 
td.i21{ background-position: 0 -603px; width: 24px; height: 24px; } 
td.i22{ background-position: 0 -637px; width: 24px; height: 24px; } 
</STYLE>
<title>GRB top25</title></head>";
echo "<body><center>
      <table cellspacing=10 cellpadding=0 border=0 bgcolor=\"black\">
      <td style=\"color:#FC9700\" bgcolor=\"black\">Rank</td>
      <td style=\"color:#FC9700\" bgcolor=\"black\">Guild Name</td>
      <td style=\"color:#FC9700\" bgcolor=\"black\">GRB Point</td>
      <td style=\"color:#FC9700\" bgcolor=\"black\">Faction";
      

while($row = mssql_fetch_array($result))
{    
  if($row[6] === 1)
    $fact= "UOF";
  else $fact= "AOL"; 
  echo "<tr style=\"color:white\">";
  echo "<td> $count</td><td>". $row[2]  ."</td><td>". $row[8] ."</td><td>  $fact</td><td>";
  echo "</tr>";
  $count++;
}
echo "</table>";
echo "</html>";

mssql_close($conn);
?>

Hope that script will be helpfull !
[GM]Joker

Bаne · 07/15/2011, 23:16

server = '127.0.0.1';
$dbuser = 'Shaiya';
$dbpass = 'Shaiya123';
$count=1;

That will need to be relapsed with your server info...lol

bulgaria · 07/16/2011, 00:04

sure

$server = '127.0.0.1';
$dbuser = 'Shaiya';
$dbpass = 'Shaiya123';

only

sondo81 · 07/16/2011, 03:23

um, what is that which is a nice request I want to f*** you or you just want to attract the newcomers to post their ip?

sry for that meaning.

Bаne · 07/16/2011, 03:34

Quote:

Originally Posted by sondo81

um, what is that which is a nice request I want to f*** you or you just want to attract the newcomers to post their ip?

sry for that meaning.

You missed the entire point, that's a PhP script, the player has to replace there DB information with the top part for it to work, then they load it into a web server...They never have to publicy post there IP.

sondo81 · 07/16/2011, 03:52

I've already noticed that this is a php script but I know him to ask the user here ... I've used it is not ***** but still does not work ... and I see no real use in this script except raise questions

Bаne · 07/16/2011, 03:59

Quote:

Originally Posted by sondo81

I've already noticed that this is a php script but I know him to ask the user here ... I've used it is not ***** but still does not work ... and I see no real use in this script except raise questions

He never asked for anything, and it's just a harmless script, I checked it..

sondo81 · 07/16/2011, 04:07

ok super mega boss to see only the last one to post the mod here cares brimgt jump to my heart.

in deutsch : alein zu sehen das es hier endlich einen mod gibt der auch aufpasst lässt mein herz höher schlagen!

RebeccaBlack · 07/16/2011, 07:21

Err, I wrote this for someone who requested on skype. It's a bit different to yours o.O

MSSQL function based:

PHP Code:


			
<?php
//Connection configuration
$Host = '127.0.0.1';
$User = 'Shaiya';
$Password = 'Shaiya123';
$conn = mssql_connect($Host,$User,$Password);

//Do not edit below this line unless you know what you're doing
$Rank=$Light=$Fury=1;
$Faction = array (0=>'Alliance',1=>'Fury');
$result = mssql_query("SELECT TOP 25* FROM PS_GameData.dbo.Guilds WHERE Del=0 ORDER BY GuildPoint DESC");

echo "<table border=1>";
echo "<tr><th>Rank</th>
        <th>Guild Name</th>
        <th>Members</th>
        <th>Leader</th>
        <th>Faction</th>
        <th>Faction Rank</th>
        <th>Points</th></tr>";

while($row = mssql_fetch_array($result))
{
  echo "<tr>";
  echo "<td>".$Rank."</td>";
  echo "<td>".$row['GuildName']."</td>";
  echo "<td>".$row['TotalCount']."</td>";
  echo "<td>".$row['MasterName']."</td>";
if($row['Country']==0){
  echo "<td>".$Faction[$row['Country']]. "</td>";
  echo "<td>".$Light."</td>";
}else{
  echo "<td>".$Faction[$row['Country']]. "</td>";
  echo "<td>".$Fury."</td>";
}
  echo "<td>".$row['GuildPoint']."</td>";
  echo "</tr>";
switch($row['Country']){
case 0: $Light++;break;
case 1: $Fury++;break;
}
  $Rank++;
}
echo "</table>";
?>

ODBC Function based:

PHP Code:


			
<?php
//Connection configuration
$Host = '127.0.0.1';
$User = 'Shaiya';
$Password = 'Shaiya123';
$conn = odbc_connect("Driver={SQL Server};Server=$Host", $User, $Password);

//Do not edit below this line unless you know what you're doing
$Rank=$Light=$Fury=1;
$Faction = array (0=>'Alliance',1=>'Fury');
$result = odbc_exec($conn,"SELECT TOP 25* FROM PS_GameData.dbo.Guilds WHERE Del=0 ORDER BY GuildPoint DESC");

echo "<table border=1>";
echo "<tr><th>Rank</th>
        <th>Guild Name</th>
        <th>Members</th>
        <th>Leader</th>
        <th>Faction</th>
        <th>Faction Rank</th>
        <th>Points</th></tr>";

while($row = odbc_fetch_array($result))
{
  echo "<tr>";
  echo "<td>".$Rank."</td>";
  echo "<td>".$row['GuildName']."</td>";
  echo "<td>".$row['TotalCount']."</td>";
  echo "<td>".$row['MasterName']."</td>";
if($row['Country']==0){
  echo "<td>".$Faction[$row['Country']]. "</td>";
  echo "<td>".$Light."</td>";
}else{
  echo "<td>".$Faction[$row['Country']]. "</td>";
  echo "<td>".$Fury."</td>";
}
  echo "<td>".$row['GuildPoint']."</td>";
  echo "</tr>";
switch($row['Country']){
case 0: $Light++;break;
case 1: $Fury++;break;
}
  $Rank++;
}
echo "</table>";
?>

zargon05 · 07/17/2011, 07:47

In your script on the die statement for mssql_connect, There is no $myServer variable.