Tarih: 2009-04-25, 18:27:06 Mesaj konusu: Avatar altı başlıklar
Avatar altında yani kayıt tarihi gönderdiği mesajlar felan o bölüme bir üyenin kaç başlık açtığını gösterebilirmiyiz? Bir sitede gördüm bu mümkün yani.Nasıl yapılacağı hakkında fikri olan söylerse sevinirim.
Tarih: 2009-04-26, 09:49:14 Mesaj konusu: Re: Avatar altı başlıklar
Natt :
Avatar altında yani kayıt tarihi gönderdiği mesajlar felan o bölüme bir üyenin kaç başlık açtığını gösterebilirmiyiz? Bir sitede gördüm bu mümkün yani.Nasıl yapılacağı hakkında fikri olan söylerse sevinirim.
Kayıt: Jun 14, 2006 Mesajlar: 190 Konum: weStanbuL
Tarih: 2009-04-26, 14:20:13 Mesaj konusu:
s.a
Görünüm :
Kod :
Kod:
##############################################################
## MOD Title: Topics a user has started
## MOD Author: Manipe <admin> (N/A) http://www.manipef1.com
## MOD Description: Shows the number of topics a user has started in the profile page just under total posts and also enables you to search for the topics that that user started. Additionally, it displays statistics about the number of topics, and also displays the number of topics that user started in the Memberlist and in the viewtopic page under the avatar and total posts.
## MOD Version: 2.0.2a
##
## Installation Level: Easy
## Installation Time: ~ 20 Minutes
## Files To Edit:
## includes/functions_post.php
## includes/page_header.php
## includes/usercp_viewprofile.php
## language/lang_english/lang_main.php
## templates/subSilver/index_body.tpl
## templates/subSilver/memberlist_body.tpl
## templates/subSilver/profile_view_body.tpl
## templates/subSilver/viewtopic_body.tpl
## index.php
## memberlist.php
## modcp.php
## search.php
## viewtopic.php
##
##
## Included Files:
## db_update.php
##
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
##############################################################
## For security purposes, please check: http://www.phpbb.com/mods/
## 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.com/mods/
##############################################################
## Author Notes:
##
##
## If you have installed Version 1.0.0 previously, please use update_to_1.1.3.txt to update to version 1.1.3.
## If you have installed Version 1.1.3 previously, please use update_to_1.2.0.txt to update to version 1.2.0.
## If you have installed Version 1.2.0 previously, please use update_to_1.3.2.txt to update to version 1.3.2.
## If you have installed Version 1.3.2 previously, please use update_to_1.4.0.txt to update to version 1.4.0.
## If you have installed Version 1.4.0 previously, please use update_to_1.6.0.txt to update to version 1.6.0.
## If you have installed Version 1.6.0 previously, please use update_to_2.0.0a.txt to update to version 2.0.0a.
## If you have installed Version 2.0.0a previously, please use update_to_2.0.0e.txt to update to version 2.0.0e.
## If you have installed Version 2.0.0e previously, please use update_to_2.0.2a.txt to update to the most recent version.
##
##############################################################
## MOD History:
##
##
## 2006-02-08 - Version 2.0.2a
## - Changed one wrong find in page_header.php
##
## 2006-02-08 - Version 2.0.2
## - Fixed bug with deleting shadow topics
##
## 2006-02-04 - Version 2.0.1
## - Added "View your topics" link on index
##
## 2005-12-11 - Version 2.0.0e
## - Altered DIY INSTRUCTIONS
## - Altered one sql command
##
## 2005-11-19 - Version 2.0.0d
## - Changed SQL syntax for better compatibility
## - Changed db_update.php file to a more secure one
##
## 2005-11-14 - Version 2.0.0c
## - Update MOD file for phpbb 2.0.18 (Changed find in memberlist.php) There is no need to update from version 2.0.0b
##
## 2005-08-30 - Version 2.0.0b
## - Failed to write new $lang variable in previous version. Now fixed
## - Fixed update files
##
## 2005-08-21 - Version 2.0.0a
## - Changed location of db_update.php
## - Fixed error in MOD syntax
## - Fixed license error
## - Un-urlencoded user id for searching
##
## 2005-07-12 - Version 2.0.0
## - Totally re-wrote code. Now the MOD edits functions_post.php so that it writes the number of topics of a user to the
## database, just like they have done for posts. It is a lot easier on certain files, like viewtopic and memberlist
## because it only needs one sql query, instead of one for each user. Highly recommended to upgrade.
##
## 2005-03-09 - Version 1.6.0
## - Added French lanugage version, thanks to: [Fewe <a_ferre> (N/A) http://hamac.hostonet.org]
##
## 2004-12-18 - Version 1.5.2
## - Fixed another minor error in mod syntax
##
## 2004-12-11 - Version 1.5.1
## - Fixed a few minor errors in the coding
##
## 2004-12-05 - Version 1.5.0
## - Now shows the number of topics the user has started in viewtopic.php, just under the avatar, and post total.
##
## 2004-12-04 - Version 1.4.0
## - Now shows the total amount of topics started on the homepage (index.php)
##
## 2004-11-29 - Version 1.3.2
## - Changed the position of the topics started column in the memberlist
##
## 2004-11-27 - Version 1.3.1
## - Forgot to modify the colspan at the bottom of the memberlist
##
## 2004-11-24 - Version 1.3.0
## - Now shows in the memberlist the number of topics the user had started
##
## 2004-11-20 - Version 1.2.0
## - Added statistics, showing the percentage of topics the user posted to the total topics, and the average topics per day.
##
## 2004-11-19 - Version 1.1.3
## - Some more minor mistakes fixed
##
## 2004-11-13 - Version 1.1.2
## - Fixed problem with dangerous retrieving of $user variable
##
## 2004-11-03 - Version 1.1.1
## - Tried to fix problem with dangerous retrieving of $user variable
##
## 2004-10-28 - Version 1.1.0
## - Added function to search for the topics started by the user
##
## 2004-10-23 - Version 1.0.0
## - First version, seems to work fine.
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ SQL ]-------------------------------------------------
#
ALTER TABLE `phpbb_users` ADD `user_topics` MEDIUMINT (8) UNSIGNED DEFAULT '0' NOT NULL;
#
#-----[ DIY INSTRUCTIONS ]------------------------------------
#
Upload "db_update.php" to "install/db_update.php" and run it. This updates your database, setting the number of topics a user has. Delete the file once you've run it.
#
#-----[ OPEN ]------------------------------------------------
#
includes/functions_post.php
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Topics a user has started MOD, By Manipe (Begin)
if ($mode == 'newtopic')
{
$sql = "UPDATE " . USERS_TABLE . "
SET user_topics = user_topics + 1
WHERE user_id = " . $userdata['user_id'];
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
}
}
// Topics a user has started MOD, By Manipe (End)
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Topics a user has started MOD, By Manipe (Begin)
$sql = "UPDATE " . USERS_TABLE . "
SET user_topics = user_topics - 1
WHERE user_id = $user_id";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in deleting post', '', __LINE__, __FILE__, $sql);
}
// Topics a user has started MOD, By Manipe (End)
#
#-----[ OPEN ]------------------------------------------------
#
includes/page_header.php
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Topics a user has started MOD, BY Manipe (Begin)
'L_SEARCH_SELF_TOPICS' => $lang['Search_your_topics'],
'U_SEARCH_SELF_TOPICS' => append_sid('search.'.$phpEx.'?search_id=egotopicsearch'),
// Topics a user has started MOD, By Manipe (End)
#
#-----[ OPEN ]------------------------------------------------
#
includes/usercp_viewprofile.php
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Topics a user has started MOD, By Manipe (Begin)
$topics_per_day = $profiledata['user_topics'] / $memberdays;
// Get the users percentage of total topics
if ( $profiledata['user_topics'] != 0 )
{
$total_topics = get_db_stat('topiccount');
$topics_percentage = ( $total_topics ) ? min(100, ($profiledata['user_topics'] / $total_topics) * 100) : 0;
}
else
{
$topics_percentage = 0;
}
// Topics a user has started MOD, By Manipe (End)
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Topics a user has started MOD, By Manipe (Begin)
'TOPICS' => $profiledata['user_topics'],
'L_TOPICS' => $lang['Topics_Started'],
'L_SEARCH_USER_TOPICS' => sprintf($lang['Search_user_topics'], $profiledata['username']),
'U_SEARCH_USER_TOPICS' => append_sid("search.$phpEx?search_id=usertopics&user=" . $profiledata['user_id']),
'TOPIC_DAY_STATS' => sprintf($lang['User_topic_day_stats'], $topics_per_day),
'TOPIC_PERCENT_STATS' => sprintf($lang['User_topic_pct_stats'], $topics_percentage),
// Topics a user has started MOD, By Manipe (End)
#
#-----[ OPEN ]------------------------------------------------
#
language/lang_english/lang_main.php
#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Topics a user has started MOD, By Manipe (Begin)
$lang['Posted_topics_zero_total'] = ' in <b>0</b> topics'; // Number of topics
$lang['Posted_topics_total'] = ' in <b>%d</b> topics'; // Number of topics
$lang['Posted_topic_total'] = ' in <b>%d</b> topic'; // Number of topics
$lang['Topics_Started'] = 'Topics started';
$lang['Search_user_topics'] = 'Find all topics started by %s'; // Find all topics started by username
$lang['User_topic_pct_stats'] = '%.2f%% of total'; // 1.25% of total
$lang['User_topic_day_stats'] = '%.2f topics per day'; // 1.5 topics per day
$lang['Sort_Topics'] = 'Total topics';
$lang['Search_your_topics'] = 'View your topics';
// Topics a user has started MOD, By Manipe (End)
#
#-----[ OPEN ]------------------------------------------------
#
templates/subSilver/index_body.tpl
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Topics a user has started MOD, By Manipe (Begin)
'TOPICS' => $topics,
// Topics a user has started MOD, By Manipe (End)
#
#-----[ OPEN ]------------------------------------------------
#
modcp.php
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Topics a user has started MOD, By Manipe (Begin)
$sql = "SELECT COUNT(topic_poster) AS topics, topic_poster
FROM " . TOPICS_TABLE . "
WHERE topic_id IN ($topic_id_sql)
AND forum_id = $forum_id
AND topic_moved_id = 0
GROUP BY topic_poster";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get topic poster information', '', __LINE__, __FILE__, $sql);
}
while ($row = $db->sql_fetchrow($result))
{
$sql1= "UPDATE " . USERS_TABLE . "
SET user_topics = user_topics - " . $row['topics'] . "
WHERE user_id = " . $row['topic_poster'];
if ( !$db->sql_query($sql1) )
{
message_die(GENERAL_ERROR, 'Could not update user topic count information', '', __LINE__, __FILE__, $sql1);
}
}
// Topics a user has started MOD, By Manipe (End)
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Topics a user has started MOD, By Manipe (Begin)
$sql = "UPDATE " . USERS_TABLE . "
SET user_topics = user_topics + 1
WHERE user_id = $first_poster";
if (!($db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Could not update user topic count information', '', __LINE__, __FILE__, $sql);
}
// Topics a user has started MOD, By Manipe (End)
#
#-----[ OPEN ]------------------------------------------------
#
search.php
#
#-----[ FIND ]------------------------------------------------
#
# Note: Full line is longer
if ( $search_id == 'newposts' || $search_id == 'egosearch' || $search_id == 'unanswered'
#
#-----[ FIND ]------------------------------------------------
#
# Note: Full line is longer
if ( $search_id == 'newposts' || $search_id == 'egosearch'
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Topics a user has started MOD, By Manipe (Begin)
$poster_topics = ( $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Topics'] . ': ' . (( $postrow[$i]['user_topics'] ) ? $postrow[$i]['user_topics'] : '0') : '';
// Topics a user has started MOD, By Manipe (End)
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Topics a user has started MOD, By Manipe (Begin)
'POSTER_TOPICS' => $poster_topics,
// Topics a user has started MOD, By Manipe (End)
#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM
Türkçe Dil dosyası phpbbmod.com
Kod: Tümünü seç
#-----[ AÇ ]------------------------------------------------
#
language/lang_turkish/lang_main.php
// Topics a user has started MOD, By Manipe, çeviri cupra (Begin)
$lang['Posted_topics_zero_total'] = 'Açılan <b>0</b> başlıkların sayısı '; // Number of topics
$lang['Posted_topics_total'] = ' Açılan başlıklar <b>%d</b> adet'; // Number of topics
$lang['Posted_topic_total'] = ' Açılan başlık <b>%d</b> adet '; // Number of topics
$lang['Topics_Started'] = 'Başlık açıldı';
$lang['Search_user_topics'] = '%s tarafından açılan başlıkları bul'; // Find all topics started by username
$lang['User_topic_pct_stats'] = 'Toplamdaki oran %.2f%%'; // 1.25% of total
$lang['User_topic_day_stats'] = 'Her gün ortalama %.2f başlık'; // 1.5 topics per day
$lang['Sort_Topics'] = 'Toplam başlıklar';
$lang['Search_your_topics'] = 'Kendi başlıklarını gör';
// Topics a user has started MOD, By Manipe, çeviri cupra (End)
// Topics a user has started MOD, By Manipe, çeviri cupra (Begin)
$lang['Posted_topics_zero_total'] = 'Açılan <b>0</b> başlıkların sayısı '; // Number of topics
$lang['Posted_topics_total'] = ' Açılan başlıklar <b>%d</b> adet'; // Number of topics
$lang['Posted_topic_total'] = ' Açılan başlık <b>%d</b> adet '; // Number of topics
$lang['Topics_Started'] = 'Başlık açıldı';
$lang['Search_user_topics'] = '%s tarafından açılan başlıkları bul'; // Find all topics started by username
$lang['User_topic_pct_stats'] = 'Toplamdaki oran %.2f%%'; // 1.25% of total
$lang['User_topic_day_stats'] = 'Her gün ortalama %.2f başlık'; // 1.5 topics per day
$lang['Sort_Topics'] = 'Toplam başlıklar';
$lang['Search_your_topics'] = 'Kendi başlıklarını gör';
// Topics a user has started MOD, By Manipe, çeviri cupra (End)
Şimdi söylenen her şeyi yaptım sql'u felan sorgulattım.Dedikleri gibi db_update.php
dosyasını install'ın içine attım.Tıkladığım zaman bir sürü hata veriyor.
Warning: include() [function.include]: Unable to access ../extension.inc in /home/***/public_html/install/db_update.php on line 32
Bunun gibi 8-10 tane uyarı.
Forumda ise görünüm şu.Bir sürü başlık açmama rağmen 0 olarak gösteriyor.
Şimdi bir şey farkettim yeni başlık açınca başlıklar bölümünde gösteriyor ama eski açılan başlıkları göstermiyor.Bir çözüm bulmak lazım *YASAK KELİME** bir şekilde...
Bu forumda yeni başlıklar açamazsınız Bu forumdaki başlıklara cevap veremezsiniz Bu forumdaki mesajlarınızı değiştiremezsiniz Bu forumdaki mesajlarınızı silemezsiniz Bu forumdaki anketlerde oy kullanamazsınız
Arama
Rütbeliler
Profil
Giriş
