Originally Posted by
papra
Good
here i release my simple ranking script
im not a aspx coder but i got a brain so this is how the script will work 
top.aspx
PHP Code:
<SCRIPT LANGUAGE="Javascript">
browser= navigator.appName;
if (browser == "Netscape")
window.location="http://127.0.0.1/mkztop/"; else window.location="http://127.0.0.1/mkztop/"
</SCRIPT>
index.php
PHP Code:
<body bgcolor="black">
<center>
<h1 class="style1"><p style='color: #ffffff; '> Ranking </p>
</h1>
<?php
$msconnect = mssql_connect("192.168.0.104,1433","as","");
$msdb = mssql_select_db("MKZStatDB", $msconnect);
$plist = "SELECT TOP 100 dwPlayerName,dwRank FROM [MKZ_UserTable] WHERE Admin = '0' AND dwRank > '0' order by dwExp desc";
$pplist = mssql_query($plist);
echo "<table width='400' height='1'><tr valign='top'>";
echo "
<td width='5%'><b>
<h3>
<p style='color: #0066ff; '>
Name
</p>
</h3>
</b>
</td>
<td></td><td></td>
<td width='5%'><b>
<h3>
<p style='color: #0066ff; '>
Rank
</p>
</h3>
</b></td></tr><tr valign='top'>
";
while($list = mssql_fetch_array($pplist)){
if($list[''] == "0"){
$char = "";
}
elseif($list[''] == "1"){
}
else
echo "
<td width='5%'>
<p style='color: #FFFFFF; '>
";
echo $list['dwPlayerName'];
echo "
</p>
</td>";
echo "<td></td><td></td><td width='5%'><p style='color: #FFFFFF; '>";
echo $list['dwRank'];
echo "</p></td></tr><tr>";
}
echo "</tr></table>";
?>
</center><br><br>
</body>
after that execute this Query
PHP Code:
USE [MKZStatDB]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_MKZ_UserTable_Admin]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MKZ_UserTable] DROP CONSTRAINT [DF_MKZ_UserTable_Admin]
END
GO
USE [MKZStatDB]
GO
/****** Object: Table [dbo].[MKZ_UserTable] Script Date: 06/30/2012 20:44:29 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MKZ_UserTable]') AND type in (N'U'))
DROP TABLE [dbo].[MKZ_UserTable]
GO
USE [MKZStatDB]
GO
/****** Object: Table [dbo].[MKZ_UserTable] Script Date: 06/30/2012 20:44:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MKZ_UserTable](
[dwGlobalID] [int] NULL,
[DwCoin] [bigint] NULL,
[dwPlayerName] [varchar](50) NULL,
[dwExp] [bigint] NULL,
[dwRank] [bigint] NULL,
[dwPoint] [bigint] NULL,
[Admin] [nchar](1) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MKZ_UserTable] ADD CONSTRAINT [DF_MKZ_UserTable_Admin] DEFAULT ((0)) FOR [Admin]
GO
Reply With Quote
