Page 4 of 4

PostPosted: Thu Mar 27, 2008 9:09 am
Author: krillmeed
no problem, you are obviously a very busy person <img>

Re: Roster/Medals Mod?

PostPosted: Tue Jun 17, 2008 3:32 am
Author: anth0ny
Installed with the extra tab in profile and the link was dead so i changed the following
just in case anyone has the same problem:

Code: Select all
# #-----[ OPEN ]------------------------------------------ # viewtopic.php  # #-----[ FIND ]------------------------------------------ #    //    // Again this will be handled by the templating    // code at some point    //  # #-----[ BEFORE, ADD ]------------------------------------------ #    // Medal MOD    $medal ='';    $sql = "SELECT m.medal_id, m.medal_name       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>)' : $lang['Medals'] . ': ' . $lang['None'];    }


to this From mr DSL's instructions but i modified the link as his was pointing to the base info tab where they originally are
Code: Select all
# #-----[ OPEN ]------------------------------------------ # viewtopic.php  # #-----[ FIND ]------------------------------------------ #    //    // Again this will be handled by the templating    // code at some point    //  # #-----[ BEFORE, ADD ]------------------------------------------ #  // Medal MOD$medal ='';$sql = "SELECT m.medal_id, m.medal_nameFROM " . MEDAL_TABLE . " m, " . MEDAL_USER_TABLE . " muWHERE mu.user_id = '" . $postrow[$i]['user_id'] . "'AND m.medal_id = mu.medal_idORDER 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'] . ']['user_id'] . "profilcp_medals_shortcut") . '" class="gensmall">' . $medal_count . '</a>' . ' (<a>' . $lang['View_More'] . '</a>)' : $lang['Medals'] . ': ' . $lang['None'];}

PostPosted: Tue Jun 17, 2008 7:52 am
Author: krillmeed
This mod has now been working on my forum for a while with no problems, except i have still yet to figure out how to change the background and font colors in the medal de.scription in the user profiles, our background is black and the font is white, at the moment it has the background white and the font is white, hence the de.scriptions have to be marked before anyone can read them. Still all in all well worth installing <img>