Top Posters (Forum Aktifleri)

bekirrr · Mesaj gönderen **bekirrr** » 26.10.2006, 00:42

Arkadaşlar acil aşagidaki gibi resimli top posters modu lazım.
Bu mod elinde olan varsa yada bulabilicek varsa minnettar olurum.
Saygılar..

[ resmi görüntülemek için tıklayın ]

crowzer · Mesaj gönderen **crowzer** » 26.10.2006, 01:12

Bi Bak Bakalım Bu Belki İşine yarar

http://www.phpbbhacks.com/download/675

XyronZ · Mesaj gönderen **XyronZ** » 26.10.2006, 10:29

crowzer yazdı:Bi Bak Bakalım Bu Belki İşine yarar
http://www.phpbbhacks.com/download/675

install dosyası yok

.

bekirrr · Mesaj gönderen **bekirrr** » 26.10.2006, 16:42

crowzer, ftpden attim dosyalari. herşey tmm ama blocktan top_posters'i aktif hale getirip forum anasayfasına dönünce aşagidaki gibi bir uyari veriyor. Acaba .php dosyasında değişiklik mi yapmamiz gerekiyor ? Oyuzdenmi veriyor bu hatayi aga ?

Kod: Tümünü seç

Genel Hata 
  
Couldn't retrieve users data

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5

SELECT user_id, username, user_posts FROM aes_users WHERE (user_id <> -1 ) AND (user_posts > 0) ORDER BY user_posts DESC LIMIT 

Line : 126
File : blocks_imp_top_posters.php

crowzer · Mesaj gönderen **crowzer** » 26.10.2006, 17:44

Kodlamalarda Bir hata Yapmış olabilirsin tekrar kontrol et sql sorgusunu gerçekleştirdinimi

kodlamalar şu şekilde

Kod: Tümünü seç

################################################################# 
## MOD Title: Top Posters on Index
## MOD Author: Spinebuster < Spinebuster27@hotmail.com > 
## MOD Description: This mod will add the top posting members to your index page.  You can set the amount of users in your board configuration.
## MOD Version: 1.0.1
## 
## Installation Level: Easy
## Installation Time: 5 Minutes
## Files To Edit: includes/page_header.php
##		  admin/admin_board.php
##		  language/lang_english/lang_main.php
##		  templates/*/admin/board_config_body.tpl
##		  templates/*/index_body.tpl
## Included Files: n/a
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2 
############################################################## 
## For security purposes, please check: http://www.phpbb-customs.com 
## for the latest version of this MOD. Although MODs are checked 
## before being allowed in the MODs Database there is no guarantee 
## that there are no security problems within the MOD. No support 
## will be given for MODs not found within the MODs Database which 
## can be found at http://www.phpbb-customs.com
############################################################## 
## Author Notes: Please run the SQL command that I have provided in this file prior to installing this mod.
## 
############################################################## 
## MOD History: 
##
##   2006-1-22 - Version 1.0.1 
##      - Fixed a few minor issues and added code for if you had aUsTiN's AUC mod installed. 
##   2005-12-29 - Version 1.0.0 
##      - Initial Release
## 
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
############################################################## 
#
#-----[ SQL ]---------------------------------------------
#
	INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters','10');
#
#-----[ OPEN ]---------------------------------------------
#
includes/page_header.php
#
#-----[ FIND ]---------------------------------------------
#
	if ( empty($online_userlist) )
	{
		$online_userlist = $lang['None'];
	}
#
#-----[ BEFORE, ADD ]---------------------------------------------
#
// Begin Top Posters on Index
if ($board_config['top_posters'])
{
	$top_posters = $board_config['top_posters'];

	$sql = "SELECT username, user_id, user_level, user_posts
        	FROM " . USERS_TABLE . "
        	WHERE user_id <> " . ANONYMOUS . "
        	ORDER BY user_posts DESC LIMIT $top_posters";
	if( !($result = $db->sql_query($sql)) )
	{
        message_die(GENERAL_ERROR, 'Could not Query Top Posting Users', '', __LINE__, __FILE__, $sql);
	}

	$user_count = $db->sql_numrows($result);
	$user_data = $db->sql_fetchrowset($result);

	$firstcount = $user_data[0]['user_posts'];
	$total_posts = get_db_stat('postcount');
	$total_top_posters = 0;
	$top_posters_userlist = '';
	$seperator 	= ', ';

	for ($i = 0; $i < $user_count; $i++)
	{
		if ($user_data[$i]['user_level'] == ADMIN)
		{
			$user_data[$i]['username'] = '<b><span style="color:#'. $theme['fontcolor3'] .'">'. $user_data[$i]['username'] .'</span></b>';
		}
		else if ($user_data[$i]['user_level'] == MOD)
		{
			$user_data[$i]['username'] = '<b><span style="color:#'. $theme['fontcolor2'] .'">'. $user_data[$i]['username'] .'</span></b>';
		}
		else
		{
			$user_data[$i]['username'] = '<b><span style="color:#'. $theme['fontcolor1'] .'">'. $user_data[$i]['username'] .'</span></b>';
		}
		
		$top_posters_userlist .= (( ($top_posters_userlist) && ($user_data[$i]['user_id']) ) ? $seperator : '') .'<a alt="'. $alt .'" title="'. $alt .'" href="profile.'. $phpEx .'?mode=viewprofile&u='. $user_data[$i]['user_id'] .'" class="copyright">'. $user_data[$i]['username'] .'</a>('. $user_data[$i]['user_posts'] .')';
		
		$total_top_posters++;
	}
}
// End Top Posters on Index
#
#-----[ FIND ]---------------------------------------------
#
	'PRIVMSG_IMG' => $icon_pm,
#
#-----[ AFTER, ADD ]---------------------------------------------
#
	// Top Posters on Index
	'L_TOP_POSTERS' => $lang['Top_Posters'],
	'TOP_POSTERS' => $top_posters_userlist,
#
#-----[ OPEN ]---------------------------------------------
#
#
	admin/admin_board.php
#
#-----[ FIND ]---------------------------------------------
#
	"S_CONFIG_ACTION" => append_sid("admin_board.$phpEx"),
#
#-----[ AFTER, ADD ]---------------------------------------------
#
	//Top Posters on Index
	'L_TOP_POSTERS'		=> $lang['Top_Posters'],
	'L_TOP_POSTERS_EXP'	=> $lang['Top_Posters_Exp'],
	'TOP_POSTERS'		=> $board_config['top_posters'],
#
#-----[ OPEN ]---------------------------------------------
#
#
	language/lang_english/lang_main.php
#
#-----[ FIND ]---------------------------------------------
#
//
// That's all, Folks!
#
#-----[ BEFORE, ADD ]---------------------------------------------
#
// Top Posters on Index
$lang['Top_Posters'] = 'Top Posting Members';
$lang['Top_Posters_Exp'] = 'Amount of Top Posting Members on Index Page.';
#
#-----[ OPEN ]---------------------------------------------
#
#
	templates/*/admin/board_config_body.tpl
#
#-----[ FIND ]---------------------------------------------
#
	<tr>
		<td class="row1">{L_ENABLE_PRUNE}</td>
		<td class="row2"><input type="radio" name="prune_enable" value="1" {PRUNE_YES} /> {L_YES}&nbsp;&nbsp;<input type="radio" name="prune_enable" value="0" {PRUNE_NO} /> {L_NO}</td>
	</tr>
#
#-----[ AFTER, ADD ]---------------------------------------------
#
	<!-- Begin: Top Posters on Index -->
	<tr>
		<td class="row1">{L_TOP_POSTERS}<br /><span class="gensmall">{L_TOP_POSTERS_EXP}</span></td>
		<td class="row2"><input type="text" class="post" size="3" maxlength="4" value="{TOP_POSTERS}" name="top_posters"></td>
	</tr>
	<!-- End: Top Posters on Index -->
#
#-----[ OPEN ]---------------------------------------------
#
#
	templates/*/index_body.tpl
#
#-----[ FIND ]---------------------------------------------
#
<table width="100%" cellpadding="1" cellspacing="1" border="0">
<tr>
	<td align="left" valign="top"><span class="gensmall">{L_ONLINE_EXPLAIN}</span></td>
</tr>
</table>
#
#-----[ AFTER, ADD ]---------------------------------------------
#
<!-- Begin: Top Posters on Index -->
<table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
<tr>
	<td class="catHead" align ="left" colspan="2" nowrap="nowrap"><span class="genmed"><b>{L_TOP_POSTERS}</b></span></td>
</tr>
<tr>
	<td class="row1" align="left" valign="middle" width="100%"><span class="genmed">{TOP_POSTERS}</span></td>
</tr>
</table>
<!-- End: Top Posters on Index -->
# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM

Kod: Tümünü seç

This is an add-on in case you have aUsTiN's AUC mod installed and you want the top posters block on
your index page to use the AUC colors.

#
#-----[ OPEN ]---------------------------------------------
#
includes/page_header.php
#
#-----[ FIND ]---------------------------------------------
#
// Begin Top Posters on Index
if ($board_config['top_posters'])
{
	$top_posters = $board_config['top_posters'];

	$sql = "SELECT username, user_id, user_level, user_posts
        	FROM " . USERS_TABLE . "
        	WHERE user_id <> " . ANONYMOUS . "
        	ORDER BY user_posts DESC LIMIT $top_posters";
	if( !($result = $db->sql_query($sql)) )
	{
        message_die(GENERAL_ERROR, 'Could not Query Top Posting Users', '', __LINE__, __FILE__, $sql);
	}

	$user_count = $db->sql_numrows($result);
	$user_data = $db->sql_fetchrowset($result);

	$firstcount = $user_data[0]['user_posts'];
	$total_posts = get_db_stat('postcount');
	$total_top_posters = 0;
	$top_posters_userlist = '';
	$seperator 	= ', ';

	for ($i = 0; $i < $user_count; $i++)
	{
		if ($user_data[$i]['user_level'] == ADMIN)
		{
			$user_data[$i]['username'] = '<b><span style="color:#'. $theme['fontcolor3'] .'">'. $user_data[$i]['username'] .'</span></b>';
		}
		else if ($user_data[$i]['user_level'] == MOD)
		{
			$user_data[$i]['username'] = '<b><span style="color:#'. $theme['fontcolor2'] .'">'. $user_data[$i]['username'] .'</span></b>';
		}
		else
		{
			$user_data[$i]['username'] = '<b><span style="color:#'. $theme['fontcolor1'] .'">'. $user_data[$i]['username'] .'</span></b>';
		}
		
		$top_posters_userlist .= (( ($top_posters_userlist) && ($user_data[$i]['user_id']) ) ? $seperator : '') .'<a alt="'. $alt .'" title="'. $alt .'" href="profile.'. $phpEx .'?mode=viewprofile&u='. $user_data[$i]['user_id'] .'" class="copyright">'. $user_data[$i]['username'] .'</a>('. $user_data[$i]['user_posts'] .')';
		
		$total_top_posters++;
	}
}
// End Top Posters on Index
#
#-----[ REPLACE WITH ]---------------------------------------------
#
// Begin Top Posters on Index
if ($board_config['top_posters'])
{
	$top_posters = $board_config['top_posters'];

	$sql = "SELECT username, user_id, user_color_gc, user_level, user_posts
        	FROM " . USERS_TABLE . "
        	WHERE user_id <> " . ANONYMOUS . "
        	ORDER BY user_posts DESC LIMIT $top_posters";
	if( !($result = $db->sql_query($sql)) )
	{
        message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
	}

	$user_count = $db->sql_numrows($result);
	$user_data = $db->sql_fetchrowset($result);

	$firstcount = $user_data[0]['user_posts'];
	$total_posts = get_db_stat('postcount');
	$total_top_posters = 0;
	$top_posters_userlist = '';
	$seperator 	= ', ';

	for ($i = 0; $i < $user_count; $i++)
	{
		if ($user_data[$i]['user_color_gc'])
		{
			$user_data[$i]['username'] = CheckUsernameColor($user_data[$i]['user_color_gc'], $user_data[$i]['username']);
		}
		else if ($user_data[$i]['user_level'] == ADMIN)
		{
			$user_data[$i]['username'] = '<b><span style="color:#'. $theme['fontcolor3'] .'">'. $user_data[$i]['username'] .'</span></b>';
		}
		else if ($user_data[$i]['user_level'] == MOD)
		{
			$user_data[$i]['username'] = '<b><span style="color:#'. $theme['fontcolor2'] .'">'. $user_data[$i]['username'] .'</span></b>';
		}
		else
		{
			$user_data[$i]['username'] = '<b><span style="color:#'. $theme['fontcolor1'] .'">'. $user_data[$i]['username'] .'</span></b>';
		}
		
		$top_posters_userlist .= (( ($top_posters_userlist) && ($user_data[$i]['user_id']) ) ? $seperator : '') .'<a alt="'. $alt .'" title="'. $alt .'" href="profile.'. $phpEx .'?mode=viewprofile&u='. $user_data[$i]['user_id'] .'" class="copyright">'. $user_data[$i]['username'] .'</a>('. $user_data[$i]['user_posts'] .')';
		
		$total_top_posters++;
	}
}
// End Top Posters on Index
# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM

bekirrr · Mesaj gönderen **bekirrr** » 26.10.2006, 19:49

crowzer, indirdigimiz dosyada bu kodlar yoqtu agam

oyusdn sql sorgusunu yapamamiştm. sadece ftp işlemlerini yapmiştm. bunlari şimdi yapicam ama install txt'si farkli yerden bizim kullandigimiz .php farkli yerden olunca sorun cıkmaz dimi ? Yani verdigin install txt'si download linkinde verdigin module'nin olmadigi için sorun cıkarmıki acaba ??

crowzer · Mesaj gönderen **crowzer** » 26.10.2006, 19:55

Nasıl Olsa Öbüründe Bir Editleme Yapmadınız. Ftp den yolladığınız dosyaları silebilirsiniz. Ama bunlar birbirine bağlantılı gibime geldi şimdi Verdiğim kodlamalarda index te görüntü alınmasını sağlayan kodlar Bir sorun Çıkacağını sanmıyorum

www.ferhatonair.com · 02.11.2006, 13:25

bu ezportal için...........
düzenlemeleri portal.php ve portal body tpl den yapın

phpBB Türkiye • phpBB Türkçe Destek

Top Posters (Forum Aktifleri)

Top Posters (Forum Aktifleri)

Kimler çevrimiçi