szukam skryptu wyświetlającego listę użytkowników serwisu Opcje

[pomek2]

Potrzebuje skrypt wyświetlający listę użytkowników z poniższej bazy mysql. Proszę o pomoc

[SQL] pobierz, plaintext 
include("common.php"); 
$link = mysql_connect($dbhost, $dbuser, $dbpassword) OR die("Could not connect: " . mysql_error());
          mysql_select_db($dbname);
 
mysql_query("DROP TABLE IF EXISTS `t_Banners`") OR die("Oops t_Banners: ".mysql_error());
 
 mysql_query("CREATE TABLE `t_Banners` (
  `n_ID` bigint(20) NOT NULL auto_increment,
  `n_UserID` bigint(20) default NULL,
  `b_Authorised` tinyint(4) default '0',
  `s_URL` char(80) default NULL,
  `s_Graphic` char(80) default NULL,
  `n_Category` int(11) default NULL,
  `n_Displays` bigint(20) default '0',
  `n_Clicks` bigint(20) default '0',
  `n_ExpireViews` bigint(20) default '0',
  `n_ExpireClicks` bigint(20) default '0',
  `b_Paid` tinyint(4) default '0',
  PRIMARY KEY  (`n_ID`)
) TYPE=MyISAM;") OR die("Oops t_Banners: ".mysql_error());
 
mysql_query("DROP TABLE IF EXISTS `t_Categories`") OR die("Oops: ".mysql_error());
 
mysql_query("CREATE TABLE `t_Categories` (
  `n_ID` int(11) NOT NULL auto_increment,
  `n_ParentID` int(11) default NULL,
  `s_Name` char(32) default NULL,
  `b_Selectable` tinyint(4) default NULL,
  PRIMARY KEY  (`n_ID`)
) TYPE=MyISAM;") OR die("Oops: ".mysql_error());
 
mysql_query("DROP TABLE IF EXISTS `t_Stats`") OR die("Oops: ".mysql_error());
mysql_query("CREATE TABLE `t_Stats` (
  `n_ID` int(11) NOT NULL default '0',
  `s_Name` varchar(32) NOT NULL default '',
  `s_Description` varchar(64) NOT NULL default '',
  `n_Value` bigint(20) NOT NULL default '0',
  UNIQUE KEY `n_ID` (`n_ID`)
) TYPE=MyISAM;") OR die ("Oops: ".mysql_error());
 
mysql_query("INSERT INTO `t_Stats` VALUES (0, 'totalviews', 'Banners served to date', 0);") OR die ("Oops this: ".mysql_error());
 
mysql_query("DROP TABLE IF EXISTS `t_Users`") OR die("Oops: ".mysql_error());
mysql_query("CREATE TABLE `t_Users` (
  `n_ID` bigint(20) NOT NULL auto_increment,
  `s_Username` char(16) default NULL,
  `s_Password` char(16) default NULL,
  `n_Credits` float(20,2) default NULL,
  `s_Email` char(32) default NULL,
  `n_Views` bigint(20) default NULL,
  `n_Clicks` bigint(20) default NULL,
  `n_Rand` int(11) default NULL,
  `b_Authedban` tinyint(4) default '0',
  `b_Admin` tinyint(4) default '0',
  `b_Newsletter` tinyint(4) default NULL,
  `b_Activated` tinyint(4) default '0',
  `n_RefererID` bigint(20) default NULL,
  `logged_ip` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`n_ID`)
) TYPE=MyISAM;") OR die ("Oops: ".mysql_error());
 
mysql_query("INSERT INTO `t_Users` VALUES (1, 'admin', 'admin', '10000000.00', 'your@site.com', 0, 0, 905, 0, 1, 1, 1, 1, 1);") OR die ("Oops this: ".mysql_error());
 
$q1 = "DROP TABLE IF EXISTS job_banners_m";
mysql_query($q1) OR die(mysql_error()." job_banners_m drop: at line ".__LINE__);
 
$q1 = "CREATE TABLE job_banners_m (
  bc char(1) NOT NULL default '')";
mysql_query($q1) OR die(mysql_error()." job_banners_m: at line ".__LINE__);
 
$q1 = "DROP TABLE IF EXISTS job_banners_t";
mysql_query($q1) OR die(mysql_error()." job_banners_t drop: at line ".__LINE__);
 
$q1 = "CREATE TABLE job_banners_t (
  b_id varchar(10) NOT NULL default '',
  fn varchar(100) NOT NULL default '',
  burl varchar(100) NOT NULL default '',
  alt varchar(255) default NULL)";
mysql_query($q1) OR die(mysql_error()."job_banners_t: at line ".__LINE__);
[SQL] pobierz, plaintext