Beiträge von Synergy

DROP TABLE `achievements`;
CREATE TABLE IF NOT EXISTS `achievements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL DEFAULT '',
  `levels` int(11) NOT NULL DEFAULT '1',
  `dynamic_badgelevel` enum('0','1') NOT NULL DEFAULT '1',
  `badge` varchar(100) NOT NULL,
  `pixels_base` int(5) NOT NULL DEFAULT '50',
  `score_base` int(5) NOT NULL DEFAULT '10',
  `pixels_multiplier` double NOT NULL DEFAULT '1.25',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=26 ;
INSERT INTO `achievements` (`id`, `type`, `levels`, `dynamic_badgelevel`, `badge`, `pixels_base`, `score_base`, `pixels_multiplier`) VALUES
(1, 'identity', 1, '0', 'ACH_AvatarLooks1', 50, 10, 0.5),
(2, 'identity', 10, '1', 'ACH_Spr', 50, 10, 1.25),
(5, 'identity', 1, '0', 'ACH_Motto1', 100, 10, 0.5),
(8, 'social', 1, '0', 'ACH_RespectGiven1', 50, 10, 0.5),
(13, 'explore', 10, '1', 'ACH_RoomEntry', 5, 10, 0.5),
(14, 'social', 10, '1', 'ACH_RespectEarned', 50, 10, 0.5),
(15, 'identity', 1, '0', 'X1115', 50, 10, 1.25),
(16, 'identity', 20, '1', 'ACH_AllTimeHotelPresence', 50, 10, 0.5),
(24, 'social', 10, '1', 'ACH_GiftGiver', 50, 10, 0.5),
(25, 'social', 10, '1', 'ACH_GiftReceiver', 50, 10, 0.5);

DROP TABLE IF EXISTS `achievements`;
CREATE TABLE IF NOT EXISTS `achievements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL DEFAULT '',
  `levels` int(11) NOT NULL DEFAULT '1',
  `dynamic_badgelevel` enum('0','1') NOT NULL DEFAULT '1',
  `badge` varchar(100) NOT NULL,
  `pixels_base` int(5) NOT NULL DEFAULT '50',
  `score_base` int(5) NOT NULL DEFAULT '10',
  `pixels_multiplier` double NOT NULL DEFAULT '1.25',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=26 ;


INSERT INTO `achievements` (`id`, `type`, `levels`, `dynamic_badgelevel`, `badge`, `pixels_base`, `score_base`, `pixels_multiplier`) VALUES
(1, 'identity', 1, '0', 'ACH_AvatarLooks1', 50, 10, 0.5),
(2, 'identity', 10, '1', 'ACH_Spr', 50, 10, 1.25),
(5, 'identity', 1, '0', 'ACH_Motto1', 100, 10, 0.5),
(8, 'social', 1, '0', 'ACH_RespectGiven1', 50, 10, 0.5),
(13, 'explore', 10, '1', 'ACH_RoomEntry', 5, 10, 0.5),
(14, 'social', 10, '1', 'ACH_RespectEarned', 50, 10, 0.5),
(15, 'identity', 1, '0', 'X1115', 50, 10, 1.25),
(16, 'identity', 20, '1', 'ACH_AllTimeHotelPresence', 50, 10, 0.5),
(24, 'social', 10, '1', 'ACH_GiftGiver', 50, 10, 0.5),
(25, 'social', 10, '1', 'ACH_GiftReceiver', 50, 10, 0.5);

<style>
ul {
  width: BREITE;
  margin: 0px auto;
  padding: 0px;
}


ul li {
  display: inline-block;
  float: left;
  margin: 0px 10px;
}
</style>


<ul>
  <li><a href="#"><img src="#"></a></li>
  <li><a href="#"><img src="#"></a></li>
  <li><a href="#"><img src="#"></a></li>
</ul>

<style>
ul {
  margin: 0px;
  padding: 0px;
}


ul li {
  display: inline-block;
  float: left;
  margin: 0px 10px;
}
</style>


<ul>
  <li><img src="#"></li>
  <li><img src="#"></li>
  <li><img src="#"></li>
</ul>

<?php


$dbhost = 'localhost'; 
$dbuser = 'root'; 
$dbpass = '*****'; 
$dbname = '*****'; 


mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql'); 
mysql_select_db($dbname); 


$query = mysql_query('SELECT users_online FROM server_status');
$r = mysql_fetch_object($query);


echo $r->users_online . ' Mitglieder Online';