-- phpMyAdmin SQL Dump

-- version 3.1.3.2

-- http://www.phpmyadmin.net

--

-- Servidor: localhost

-- Tiempo de generaciуn: 01-08-2009 a las 13:21:21

-- Versiуn del servidor: 5.0.51

-- Versiуn de PHP: 5.2.5



SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";



--

-- Base de datos: `radmin`

--



-- --------------------------------------------------------



--

-- Estructura de tabla para la tabla `ban`

--



CREATE TABLE IF NOT EXISTS `ban` (

 `banid` int(11) NOT NULL auto_increment,

 `banned` varchar(30) NOT NULL default '',

 `bannedip` varchar(30) NOT NULL default '',

 `banner` varchar(30) NOT NULL default '',

 `bannerip` varchar(30) NOT NULL default '',

 `reason` varchar(100) NOT NULL default '',

 `time` varchar(30) NOT NULL default '',

 `date` varchar(30) NOT NULL default '',

 PRIMARY KEY (`banid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;



--

-- Volcar la base de datos para la tabla `ban`

--





-- --------------------------------------------------------



--

-- Estructura de tabla para la tabla `kick`

--



CREATE TABLE IF NOT EXISTS `kick` (

 `kickid` int(11) NOT NULL auto_increment,

 `kicked` varchar(30) NOT NULL default '',

 `kickedip` varchar(30) NOT NULL default '',

 `kicker` varchar(30) NOT NULL default '',

 `kickerip` varchar(30) NOT NULL default '',

 `reason` varchar(100) NOT NULL default '',

 `time` varchar(30) NOT NULL default '',

 `date` varchar(30) NOT NULL default '',

 PRIMARY KEY (`kickid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;



--

-- Volcar la base de datos para la tabla `kick`

--







-- --------------------------------------------------------



--

-- Estructura de tabla para la tabla `site`

--



CREATE TABLE IF NOT EXISTS `site` (

 `id` int(11) NOT NULL default '0',

 `pass` varchar(30) NOT NULL default '',

 `ip` varchar(30) NOT NULL default '',

 `port` int(11) NOT NULL default '0',

 `text` text NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;



--

-- Volcar la base de datos para la tabla `site`

--





-- --------------------------------------------------------



--

-- Estructura de tabla para la tabla `stats`

--



CREATE TABLE IF NOT EXISTS `stats` (

 `statid` int(11) NOT NULL default '0',

 `restarts` int(11) NOT NULL default '0',

 `visits` int(11) NOT NULL default '0',

 `timeouts` int(11) NOT NULL default '0',

 `deaths` int(11) NOT NULL default '0',

 `kills` int(11) NOT NULL default '0',

 `commands` int(11) NOT NULL default '0',

 `messages` int(11) NOT NULL default '0',

 `pmessages` int(11) NOT NULL default '0',

 `days` int(11) NOT NULL default '0',

 `hours` int(11) NOT NULL default '0',

 `minutes` int(11) NOT NULL default '0',

 `seconds` int(11) NOT NULL default '0'

) ENGINE=MyISAM DEFAULT CHARSET=latin1;



--

-- Volcar la base de datos para la tabla `stats`

--





-- --------------------------------------------------------



--

-- Estructura de tabla para la tabla `users`

--



CREATE TABLE IF NOT EXISTS `users` (

 `reg_id` int(11) NOT NULL auto_increment,

 `name` varchar(30) NOT NULL default '',

 `password` varchar(30) NOT NULL default '',

 `email` varchar(60) NOT NULL default '',

 `IP` varchar(30) NOT NULL default '',

 `admin_level` int(11) NOT NULL default '0',

 `player_kills` int(11) NOT NULL default '0',

 `player_deaths` int(11) NOT NULL default '0',

 `times_logged` int(11) NOT NULL default '0',

 `money` int(11) NOT NULL default '0',

 `score` int(11) NOT NULL default '0',

 PRIMARY KEY (`reg_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;



--

-- Volcar la base de datos para la tabla `users`

<?PHP

		$c = mysql_connect("localhost","root","password") or die("ERROR! 01");

		mysql_select_db("radmin",$c) or die("ERROR!! 02");

		$consulta = "SELECT name,player_kills,player_deaths from users ORDER BY player_kills DESC LIMIT 20";

		$resultado = mysql_query($consulta);

		print "<table border> <tr><th>puesto:</th><th>Nombre</th><th>Kills</th><th>Muertes:</th></tr><br />";

		if($resultado) {

		$cont = 0;

		while($topten = mysql_fetch_array($resultado)){

		$cont++;

		$usertop = $topten['name'];

		$kills = $topten['player_kills'];

		$muertes = $topten['player_deaths'];

		print("<tr><td> $cont</td><td> $usertop </td><td> $kills </td><td>$muertes</td></tr>");

		}

		print("</tr></TABLE>");

		}

		

		?>

C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(201) : warning 219: local variable "loginmsg" shadows a variable at a preceding level
C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(203) : warning 217: loose indentation
C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(207) : warning 225: unreachable code
C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(367) : warning 235: public function lacks forward declaration (symbol "OnPlayerPrivmsg")
C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(387) : warning 217: loose indentation
C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(401) : warning 217: loose indentation
C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(595) : warning 235: public function lacks forward declaration (symbol "OnPlayerInfoChange")
C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(943) : warning 217: loose indentation
C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(947) : warning 217: loose indentation
C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(949) : warning 217: loose indentation
C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(961) : warning 217: loose indentation
C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(998) : warning 225: unreachable code
C:\DOCUME~1\XX\ESCRIT~1\host\gmsql\FILTER~1\fssql.pwn(999) : warning 217: loose indentation
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


13 Warnings.