\n"; echo "\n".$locale['423']."\n\n\n\n\n"; $user_groups = (strpos($data['user_groups'], ".") == 0 ? explode(".", substr($data['user_groups'], 1)) : explode(".", $data['user_groups'])); for ($i = 0;$i < count($user_groups);$i++) { echo "".getgroupname($user_groups[$i]).""; if ($i != (count($user_groups)-1)) { echo ",\n"; } else { echo "\n"; } } echo "\n\n\n"; } // Medal Mod $medal_settings = get_medal_settings(); if( $medal_settings['m_status'] == '1' && $medal_settings['display_profile'] == '1' ) { $result = $db->sql_query("SELECT cat_id, cat_title FROM ".$db_prefix."medal_cat ORDER BY cat_order"); $category_rows = array(); while ( $row = $db->sql_fetchrow($result) ) { $category_rows[] = $row; } $result = $db->sql_query("SELECT m.medal_id, mu.user_id FROM ".$db_prefix."medal m, ".$db_prefix."medal_user mu WHERE mu.user_id = '" . $lookup . "' AND m.medal_id = mu.medal_id ORDER BY m.medal_name"); $medal_list = $db->sql_fetchrowset($result); $medal_count = count($medal_list); $i_a = 1; if ( $medal_count ) { tablebreak(); echo "
".$locale['Medal_Information']."
".$locale['Medals'].": ".$medal_count."

"; for ($i = 0; $i <= count($category_rows); $i++) { $cat_id = $category_rows[$i]['cat_id']; $cat_title = $category_rows[$i]['cat_title']; $issue = "SELECT m.*, mu.issue_reason, mu.issue_time, c.cat_id, c.cat_title FROM ".$db_prefix."medal m, ".$db_prefix."medal_user mu, ".$db_prefix."medal_cat c WHERE mu.user_id = '" . $lookup . "' AND m.cat_id = c.cat_id AND m.medal_id = mu.medal_id ORDER BY c.cat_order, m.medal_name, mu.issue_time"; $result = $db->sql_query($issue); if (dbrows($result)) { $row = array(); $rowset = array(); $medal_time = $locale['Medal_time'] . ': '; $medal_reason = $locale['Medal_reason'] . ': '; while ($row = $db->sql_fetchrow($result)) { if (empty($rowset[$row['medal_name']])) { $rowset[$row['medal_name']]['cat_id'] = $row['cat_id']; $rowset[$row['medal_name']]['cat_title'] = $row['cat_title']; $rowset[$row['medal_name']]['medal_description'] .= $row['medal_description']; $rowset[$row['medal_name']]['medal_image'] = $row['medal_image']; $row['issue_reason'] = ( $row['issue_reason'] ) ? $row['issue_reason'] : $locale['Medal_no_reason']; $rowset[$row['medal_name']]['medal_issue'] = ""; $rowset[$row['medal_name']]['medal_count'] = '1'; } else { $row['issue_reason'] = ( $row['issue_reason'] ) ? $row['issue_reason'] : $locale['Medal_no_reason']; $rowset[$row['medal_name']]['medal_issue'] .= ""; $rowset[$row['medal_name']]['medal_count'] += '1'; } } $medal_name = array(); $data = array(); $display_medal = 0; $last_cat_id = 0; while (list($medal_name, $data) = @each($rowset)) { if ( $cat_id == $data['cat_id'] ) { $display_medal = 1; } if($cat_id != $last_cat_id) { echo ""; } } echo "
" . $medal_time . showdate('longdate', $row['issue_time']) . "
" . $medal_reason . $row['issue_reason'] . "
" . $medal_time . showdate('longdate', $row['issue_time']) . "
" . $medal_reason . $row['issue_reason'] . "
";} if ( !empty($display_medal) ) { echo "" . $medal_name . ""; echo ""; $display_medal = 0; $i_a++; } $last_cat_id = $cat_id; } echo "
"; } } // Medal Mod //profile.php settings # max items for Threads/Posts/News on the normal profile page $profile_index_limit = 5; # max items for the profile page Threads/Posts/News listing $profile_list_limit = 20; # width of the profile $profile_width = 600; # include the right side panels, set to true or 1 if you want include the right side $profile_include_rightside = false; if ((isset($lookup)) && (!isset($group_id)) && (isNum($lookup))) { if ((isset($list)) && ($list != 'threads') && ($list != 'posts') && ($list != 'news')) redirect("index.php"); //mf_mod require_once INFUSIONS."mf_addon/includes/mf_libs.php"; if (!isset($list)) $list = "profile"; $result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id='$lookup'"); if (dbrows($result)) $data = dbarray($result); else redirect("index.php"); if ($list == 'profile') { echo "\n"; } opentable($locale['420']); echo "\n\n\n\n
\n
\n"; // Start of Profile echo "\n" ."\n\n\n\n
\n"; if ($list == 'profile') { echo ($data['user_avatar'] ? "".$locale[

\n
\n" : "") .($data['user_hide_email'] != 1 || iADMIN ? "
\n" : "") .($data['user_web'] ? "
\n" : "") .(!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id'] ? "
\n" : "") .($data['user_aim'] || $data['user_icq'] || $data['user_msn'] || $data['user_yahoo'] ? "
\n" : "") .($data['user_aim'] ? "
\n" : "") .($data['user_icq'] ? "
\n" : "") .($data['user_msn'] ? "
\n" : "") .($data['user_yahoo'] ? "
\n" : "") .(iSUPERADMIN ? "
\n
\n
\n" : ""); } else { echo ($data['user_avatar'] ? "".$locale[" : " "); } echo "		\n" ."".$data['user_name']."
\n" .""; if ($data['user_level'] == 103) $color = "CC0000"; elseif ($data['user_level'] == 102) $color = "006600"; else $color = "006600"; echo "".getuserlevel($data['user_level']).""; echo "\n"; $lvisit = time() - $data['user_lastvisit']; if ($lvisit < 60) echo "".$locale['pe000'].""; elseif ($lvisit < 300) echo "".$locale['pe001'].""; else echo "".$locale['pe002'].""; echo "\n" ."

\n"; if ($list == 'profile') { echo "
\n\n" ."\n" ."\n\n" ."
".$locale['u009']."".($data['user_location'] ? $data['user_location'] : $locale['u048'])."
".$locale['u010'].""; if ($data['user_birthdate'] != "0000-00-00") { $months = explode("|", $locale['months']); $user_birthdate = explode("-", $data['user_birthdate']); echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0']; } else { echo $locale['u048']; } echo "
\n
\n" ."
\n\n" ."\n" ."\n" ."\n" ."\n" ."\n" ."
".$locale['u040']."".showdate("longdate", $data['user_joined'])."
".$locale['u044']."".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."
".$locale['u041']."".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."
".$locale['u042']."".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."
".$locale['u043']."".number_format($data['user_posts'])."
\n"; echo "
Kita informacija
Lytis: ".get_gender($data['user_id'],"icon")."
\n"; if ($data['user_groups']) { echo "
\n\n" ."" ."\n" ."
".$locale['423'].":"; $user_groups = (strpos($data['user_groups'], ".") == 0 ? explode(".", substr($data['user_groups'], 1)) : explode(".", $data['user_groups'])); for ($i = 0;$i < count($user_groups);$i++) { echo "".getgroupname($user_groups[$i]).""; if ($i != (count($user_groups)-1)) { echo ","; } } echo "
\n
\n"; } } else { echo "
\n" .($data['user_hide_email'] != 1 || iADMIN ? " \n" : "") .($data['user_web'] ? " \n" : "") .(!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id'] ? " \n" : "") .(iSUPERADMIN ? "
\n" : ""); } echo "
\n
\n"; // End of Profile // Start of Threads/Posts/News listing $limit = $list == 'profile' ? $profile_index_limit : $profile_list_limit; if (!isset($rowstart) || !isNum($rowstart) || $list == 'profile') $rowstart = 0; // Forum Threads listing if (($list == 'profile') || ($list == 'threads')) { $pagenav = false; $result = dbquery( "SELECT tt.*, tf.*, tu.user_id,user_name FROM ".$db_prefix."threads tt INNER JOIN ".$db_prefix."forums tf USING(forum_id) INNER JOIN ".$db_prefix."users tu ON tt.thread_lastuser=tu.user_id WHERE ".groupaccess('forum_access')." AND thread_author='$lookup' LIMIT 100" ); $numrows = dbrows($result); $alttitle = $numrows == 0 ? $locale['pe200'] : $locale['pe201']; echo "\n" ."\n" ."\n" ."\n"; if ($numrows != 0) { $result = dbquery( "SELECT tt.*, tf.*, tu.user_id,user_name FROM ".$db_prefix."threads tt INNER JOIN ".$db_prefix."forums tf USING(forum_id) INNER JOIN ".$db_prefix."users tu ON tt.thread_lastuser=tu.user_id WHERE ".groupaccess('forum_access')." AND thread_author='$lookup' ORDER BY thread_lastpost DESC LIMIT $rowstart,$limit" ); while ($row = dbarray($result)) { $replies = dbcount("(thread_id)", "posts", "thread_id='".$row['thread_id']."'"); $row2 = dbarray(dbquery("SELECT post_id FROM ".$db_prefix."posts WHERE thread_id='".$row['thread_id']."' ORDER BY post_id DESC LIMIT 1")); $rstart = ($replies > 20 ? "rowstart=".((ceil($replies / 20)-1)*20)."&" : ""); echo "" ."" ."" ."" ."" ."\n"; } if (($numrows > $limit) && ($list == 'profile')) echo ""; elseif ($numrows > $limit) $pagenav = makePageNav($rowstart,$limit,$numrows,3,FUSION_SELF."?lookup=$lookup&list=threads&"); } else { echo ""; } echo "\n
".$locale['pe100'].$data['user_name']."".($list == 'profile' ? "".$alttitle.$data[" : "")."
".$locale['pe103']."".$locale['pe104']."".$locale['pe105']."".$locale['pe106']."
".trimlink($row['forum_name'], 30)."".trimlink($row['thread_subject'], 30)."".$row['thread_views']."".ceil($replies-1)."
".$locale['pe112']."
".$data['user_name']." ".$locale['pe109']."
\n
\n"; if ($list != 'profile') echo "
".$locale['pe113']."".$pagenav."
\n
\n"; } // Forum Posts listing if (($list == 'profile') || ($list == 'posts')) { $pagenav = false; $result = dbquery( "SELECT tp.*, tf.* FROM ".$db_prefix."posts tp INNER JOIN ".$db_prefix."forums tf USING(forum_id) WHERE ".groupaccess('forum_access')." AND post_author='$lookup' LIMIT 100" ); $numrows = dbrows($result); $alttitle = $numrows == 0 ? $locale['pe202'] : $locale['pe203']; echo "\n" ."\n" ."\n" ."\n"; if ($numrows != 0) { $result = dbquery( "SELECT tp.*, tf.* FROM ".$db_prefix."posts tp INNER JOIN ".$db_prefix."forums tf USING(forum_id) WHERE ".groupaccess('forum_access')." AND post_author='".$data['user_id']."' ORDER BY post_datestamp DESC LIMIT $rowstart,$limit" ); while ($row = dbarray($result)) { $replies = dbcount("(thread_id)", "posts", "thread_id='".$row['thread_id']."'"); $rstart = ($replies > 20 ? "rowstart=".((ceil($replies / 20)-1)*20)."&" : ""); echo "" ."" ."" ."" ."\n"; } if (($numrows > $limit) && ($list == 'profile')) echo "\n"; elseif ($numrows > $limit) $pagenav = makePageNav($rowstart,$limit,$numrows,3,FUSION_SELF."?lookup=$lookup&list=posts&"); } else { echo "\n"; } echo "\n
".$locale['pe101'].$data['user_name']."".($list == 'profile' ? "".$alttitle.$data[" : "")."
".$locale['pe103']."".$locale['pe107']."".$locale['pe108']."
".trimlink($row['forum_name'], 30)."".trimlink($row['post_subject'], 30)."".showdate("forumdate", $row['post_datestamp'])."
".$locale['pe112']."
".$data['user_name']." ".$locale['pe110']."
\n
\n"; if ($list != 'profile') echo "
".$locale['pe113']."".$pagenav."
\n
\n"; } // News Items listing if (($list == 'profile') || ($list == 'news')) { $pagenav = false; $result = dbquery( "SELECT * FROM ".$db_prefix."news WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_name='".$data['user_id']."' LIMIT 100" ); $numrows = dbrows($result); $alttitle = $numrows == 0 ? $locale['pe204'] : $locale['pe205']; echo "\n" ."\n" ."\n" ."\n"; if ($numrows != 0) { $result = dbquery( "SELECT * FROM ".$db_prefix."news WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_name='".$data['user_id']."' ORDER BY news_datestamp DESC LIMIT $rowstart,$limit" ); while ($row = dbarray($result)) { echo "" ."" ."" ."\n"; } if (($numrows > $limit) && ($list == 'profile')) echo ""; elseif ($numrows > $limit) $pagenav = makePageNav($rowstart,$limit,$numrows,3,FUSION_SELF."?lookup=$lookup&list=news&"); } else { echo ""; } echo "\n
".$locale['pe102'].$data['user_name']."".($list == 'profile' ? "".$alttitle.$data[" : "")."
".$locale['pe107']."".$locale['pe108']."
".trimlink($row['news_subject'], 50)."".showdate("forumdate", $row['news_datestamp'])."
".$locale['pe112']."
".$data['user_name']." ".$locale['pe111']."
\n
\n"; if ($list != 'profile') echo "
".$locale['pe113']."".$pagenav."
\n
\n"; } echo "
\n"; closetable(); } elseif ((isset($group_id)) && (!isset($lookup)) && (isNum($group_id))) { $profile_include_rightside = true; $result = dbquery("SELECT * FROM ".$db_prefix."user_groups WHERE group_id='$group_id'"); if (dbrows($result)) { $data = dbarray($result); $result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_groups REGEXP('^\\\.{$group_id}$|\\\.{$group_id}\\\.|\\\.{$group_id}$') ORDER BY user_level DESC, user_name"); opentable($locale['410']); echo "\n\n\n\n
\n
\n"; echo "\n" ."\n\n\n
" ."".$data['group_name']."" ."(".sprintf((dbrows($result)==1?$locale['411']:$locale['412']), dbrows($result)).")

\n" ."\n"; while ($data = dbarray($result)) { echo "" ."\n"; } echo "
".$data['user_name']."".getuserlevel($data['user_level'])."
\n"; echo "
\n
\n"; echo "
\n"; closetable(); } else { fallback(BASEDIR."index.php"); } } else fallback("index.php"); echo "\n"; include_once INCLUDES."exp_include.php"; showexp($data['user_id'],$data['user_posts'], "1"); include INCLUDES."comments_include.php"; showcomments("U","users","user_id",$lookup,FUSION_SELF."?lookup=$lookup"); if ($profile_include_rightside) require_once "side_right.php"; else echo "\n"; require_once "footer.php"; ?>