#
# Tabellenstruktur für Tabelle `nuke_bbmedal`
#

DROP TABLE IF EXISTS `nuke_bbmedal`;
CREATE TABLE `nuke_bbmedal` (
  `medal_id` mediumint(8) NOT NULL auto_increment,
  `medal_name` varchar(40) NOT NULL default '',
  `medal_description` varchar(255) NOT NULL default '',
  `medal_image` varchar(40) default NULL,
  PRIMARY KEY  (`medal_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Daten für Tabelle `nuke_bbmedal`
#

INSERT INTO `nuke_bbmedal` VALUES (1, 'Site Admin', 'Site Admin Madalyasi', 'images/medals/medal-blue-bronze.gif');

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `nuke_bbmedal_mod`
#

DROP TABLE IF EXISTS `nuke_bbmedal_mod`;
CREATE TABLE `nuke_bbmedal_mod` (
  `mod_id` mediumint(8) unsigned NOT NULL auto_increment,
  `medal_id` mediumint(8) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (`mod_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Daten für Tabelle `nuke_bbmedal_mod`
#

INSERT INTO `nuke_bbmedal_mod` VALUES (1, 1, 2);

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `nuke_bbmedal_user`
#

DROP TABLE IF EXISTS `nuke_bbmedal_user`;
CREATE TABLE `nuke_bbmedal_user` (
  `issue_id` mediumint(8) NOT NULL auto_increment,
  `medal_id` mediumint(8) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `issue_reason` varchar(255) NOT NULL default '',
  `issue_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`issue_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Daten für Tabelle `nuke_bbmedal_user`
#

INSERT INTO `nuke_bbmedal_user` VALUES (1, 1, 2, 'Site Admin Madalyasi', 1126627989);

#-----[ ARA ]------------------------------------------
#
   //
   // Again this will be handled by the templating
   // code at some point
   //

#
#-----[ ÖNCESİNE EKLE ]------------------------------------------
#

/********************************************************************/
/* Madalya Mod v.2.0.1    nuke.pehaspe.com                BAŞLANGIC */
/********************************************************************/
   $medal ='';
   $sql = "SELECT m.medal_id, m.medal_name, m.medal_image
      FROM " . MEDAL_TABLE . " m, " . MEDAL_USER_TABLE . " mu
      WHERE mu.user_id = '" . $postrow[$i]['user_id'] . "'
      AND m.medal_id = mu.medal_id
      ORDER BY m.medal_name";
   
   if(!$result = $db->sql_query($sql))
      message_die(GENERAL_ERROR, "Error getting medal information", "", __LINE__, __FILE__, $sql);
      
   $medal_list = $db->sql_fetchrowset($result);
   $medal_count = count($medal_list);

   if ( $postrow[$i]['user_id'] == ANONYMOUS )
   {
      $medal_count = '';
   }
   else
   {
      $medal_count = ($medal_count) ? $lang['Medals'] . ': <a href="modules.php?name=Forums&file=profile&mode=viewprofile&u=' . $postrow[$i]['user_id'] .'#medal" class="gensmall">' . $medal_count . '</a>' . ' (<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $postrow[$i]['user_id']) .'#medal" class="gensmall">' . $lang['View_More'] . '</a>)' : $lang['Medals'] . ': 0';
   }
   
/********************************************************************/
/* Madalya Mod v.2.0.1    nuke.pehaspe.com                      SON */
/********************************************************************/