Хаблист

CREATE TABLE `hublist_hubs` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `Adres` varchar(80) character set utf8 collate utf8_bin NOT NULL,
  `Port` varchar(10) character set latin1 collate latin1_general_ci NOT NULL default '411',
  `Name` text NOT NULL,
  `Owner` varchar(64) character set utf8 collate utf8_bin NOT NULL,
  `Descr` varchar(666) NOT NULL,
  `Soft` varchar(64) character set utf8 collate utf8_bin NOT NULL,
  `Maxusers` varchar(64) NOT NULL default '0',
  `MinShare` varchar(64) character set utf8 collate utf8_bin NOT NULL,
  `MinSlots` int(10) NOT NULL,
  `MaxHubs` varchar(64) NOT NULL default '0',
  `Lang` varchar(64) character set utf8 collate utf8_bin NOT NULL,
  `Sity` varchar(64) character set utf8 collate utf8_bin NOT NULL,
  `Users` int(10) NOT NULL default '0',
  `Userspeak` int(10) NOT NULL default '0',
  `Share` float NOT NULL default '0',
  `Sharepeak` float NOT NULL default '0',
  `Status` varchar(64) character set utf8 collate utf8_bin NOT NULL,
  `UserAdd` varchar(128) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `address` (`Adres`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20

CREATE TABLE `hublist_usersearch` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `Nick` varchar(64) collate utf8_bin NOT NULL,
  `Descr` varchar(128) collate utf8_bin NOT NULL,
  `EMail` varchar(64) collate utf8_bin NOT NULL,
  `Connect` varchar(64) collate utf8_bin default NULL,
  `Share` varchar(64) collate utf8_bin default NULL,
  `HubID` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1

$off = "<b>Статус:</b> <FONT COLOR=red>Offline</b></FONT>";
$online = "<b>Статус:</b> <FONT COLOR=lime>Online</b></FONT>";
$ip = "АЙПИ ХАБА";
$port = "411";
if (! $sock = @fsockopen($ip, $port, $num, $error, 3))
echo $off;
else{
echo $online;
fclose($sock);}

$_mysql_db="hublist"; // Baza de date

$_mysql_user="root"; // User baza de date

$_mysql_password="з=pass"; // Parola baza de date