[2.0.19] Topics a user has started

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
13
81%
Very Good
1
6%
Good
2
13%
Fair
0
No votes
Poor
0
No votes
 
Total votes: 16

Manipe
Former Team Member
Posts: 1146
Joined: Thu Jul 22, 2004 6:30 pm
Location: Éire
Contact:

Post by Manipe » Thu Mar 23, 2006 8:14 pm

Okay, please open viewtopic.php, find the line that begins with this:

Code: Select all

	$poster_topics = ( $postrow[$i]['user_id'] != ANONYMOUS )
and post it here, just so I can make sure it's correct.

Also, Can I ask if you updated from an older version, or if you installed from scratch with the most recent version?
My MODs: [ Topics a user has started ] , [ Profile views ] , [ Colour on poll results ] , [ Topic posters ] , [ Add number to PM ] , [ Default avatar ] , [ View category name ] , [ Null vote ] , [ Forum description in viewforum ] , [ Resync forum ids ] , [ View PM while replying ] , [ Quick poll insert ] , [ Limit login attempts ] , [ Track PMs ]

www.ManipeF1.com

Ivoman #7
Registered User
Posts: 64
Joined: Tue Mar 07, 2006 3:17 pm
Location: BELGIUM
Contact:

Post by Ivoman #7 » Fri Mar 24, 2006 12:52 am

After you've helped, brodus, can you look into a function to sort the list on forum?

Manipe
Former Team Member
Posts: 1146
Joined: Thu Jul 22, 2004 6:30 pm
Location: Éire
Contact:

Post by Manipe » Fri Mar 24, 2006 4:00 pm

Ivoman #7 wrote: After you've helped, brodus, can you look into a function to sort the list on forum?
what list?
My MODs: [ Topics a user has started ] , [ Profile views ] , [ Colour on poll results ] , [ Topic posters ] , [ Add number to PM ] , [ Default avatar ] , [ View category name ] , [ Null vote ] , [ Forum description in viewforum ] , [ Resync forum ids ] , [ View PM while replying ] , [ Quick poll insert ] , [ Limit login attempts ] , [ Track PMs ]

www.ManipeF1.com

Ivoman #7
Registered User
Posts: 64
Joined: Tue Mar 07, 2006 3:17 pm
Location: BELGIUM
Contact:

Post by Ivoman #7 » Fri Mar 24, 2006 6:05 pm

The search.php?search_id=usertopics&user= list you get to see when you click on 'Search for all topics by username'

Features to sort this list by both Date & Forum would be very handy. 8)
Especialy as Administrator, to quicky find and remove SOLD topics, etc.

valli
Registered User
Posts: 40
Joined: Wed Nov 27, 2002 2:47 am

Post by valli » Sun Apr 16, 2006 2:42 pm

I tried to install this mod and everything went fine except the User topics shows 0 for all posters.

I ran the Db_update.php and all I get is this message

Code: Select all

Please, be sure to delete your install directory and this file from your phpBB installation now.
Did the update run fine? I did not get any messages telling that update is OK.

I would really appreciate if you can help me on this

valli
Registered User
Posts: 40
Joined: Wed Nov 27, 2002 2:47 am

Post by valli » Sun Apr 16, 2006 2:44 pm

I also have another question. Ever since I installed this mod , it does not allow me to SEARCH immediately. i.e it says you cannot perform a search so soon.

Where can I find this time limitation?

User avatar
davids2004
Registered User
Posts: 191
Joined: Thu Dec 29, 2005 7:22 pm
Location: Houston
Contact:

Post by davids2004 » Sun Apr 30, 2006 5:15 pm

Worked fine with .20. Ran the update file first then used easy mod and all is well.

gLiTcH_
Registered User
Posts: 14
Joined: Wed Dec 28, 2005 3:08 am

Post by gLiTcH_ » Wed Jun 21, 2006 4:56 am

Hi! I found another bug relating the shadow topics that you previously fixed.

It seems when I run the db_update.php to resync the topic counts, it still counts the shadow topics.

I tested it in my test forum, I had 6 topics and 1 shadow. My statistics showed 6 topics, but then when I ran the SQL indicated in db_update.php:

Code: Select all

SELECT COUNT(*) AS `user_topics`, `topic_poster` AS `user_id` FROM `' . TOPICS_TABLE . '` GROUP BY `topic_poster`
My topics went to 7, how should the SQL be modified so that shadow topics won't be counted? Sorry I'm not very good with SQL. Thanks!

Also this MOD works perfectly fine with 2.0.21. :)

EDIT:

I modified the SQL and tried:

Code: Select all

SELECT COUNT(*) AS `user_topics`, `topic_poster` AS `user_id` FROM `' . TOPICS_TABLE . '` WHERE `topic_moved_id` = 0 GROUP BY `topic_poster`
and it seemed to of worked is this the correct code?

PTRACER
Registered User
Posts: 166
Joined: Sun Dec 07, 2003 2:54 am

Post by PTRACER » Sun Jul 02, 2006 7:31 pm

How compatible is this mod with 2.0.17? :oops:

fur
Registered User
Posts: 29
Joined: Sun Mar 28, 2004 12:14 pm
Contact:

Post by fur » Fri Jul 21, 2006 9:06 am

This mod does not work correctly in combination with the merge topics mod. The number of user_topics is not decreased while it should. Has someone already solved this?

fur
Registered User
Posts: 29
Joined: Sun Mar 28, 2004 12:14 pm
Contact:

Post by fur » Fri Jul 21, 2006 9:38 am

Ok it was pretty easy to adapt merge.php
I have changed

Code: Select all

// titles
$from_title = '';
if (!empty($from_topic_id))
{
	$sql = "SELECT topic_title FROM " . TOPICS_TABLE . " WHERE topic_id=$from_topic_id";
	if ( !($result = $db->sql_query($sql)) ) message_die(GENERAL_ERROR, 'Could not get from-topic informations', '', __LINE__, __FILE__, $sql);
	if ($row = $db->sql_fetchrow($result))
	{
		$from_title = $row['topic_title'];
	}
}
into

Code: Select all

// titles
$from_title = '';
if (!empty($from_topic_id))
{
	$sql = "SELECT topic_title, topic_poster FROM " . TOPICS_TABLE . " WHERE topic_id=$from_topic_id";
	if ( !($result = $db->sql_query($sql)) ) message_die(GENERAL_ERROR, 'Could not get from-topic informations', '', __LINE__, __FILE__, $sql);
	if ($row = $db->sql_fetchrow($result))
	{
		$from_title = $row['topic_title'];
		$from_topic_poster = $row['topic_poster'];
	}
}
and after

Code: Select all

		// process the posts
		$sql = "UPDATE " . POSTS_TABLE . " SET forum_id=$to_forum_id, topic_id=$to_topic_id WHERE topic_id=$from_topic_id";
		if ( !$db->sql_query($sql) ) message_die(GENERAL_ERROR, 'Could not update posts information', '', __LINE__, __FILE__, $sql);
I added:

Code: Select all

// Topics a user has started MOD (Begin)
		$sql = "UPDATE " . USERS_TABLE . "
			SET user_topics = user_topics - 1
			WHERE user_id = $from_topic_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 (End)

perfectcircle
Registered User
Posts: 75
Joined: Tue Jul 12, 2005 3:25 pm
Contact:

Post by perfectcircle » Wed Aug 02, 2006 3:03 pm

when i try and delete a topic i recieve this error.

Code: Select all

Error in deleting post

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 3

UPDATE phpbb_users SET user_topics = user_topics - 1 WHERE user_id =

Line : 576
File : functions_post.php
What should i do

User avatar
PaulusB
Registered User
Posts: 216
Joined: Sun May 28, 2006 2:08 pm
Location: Holland
Contact:

Post by PaulusB » Mon Aug 07, 2006 8:15 am

I have this mod installed but user topic counts stay`s at 0 how can i make the mod count al the previus topics i posted because i have post 143 topics. and when i post a new topic de topic count goes from 0 to 1 sow the mod works.

I have already used this mods to fix the bug but had no effect.

resync post accounts.
resync forum statics.

Any one know how the fix this problem :?:

User avatar
PaulusB
Registered User
Posts: 216
Joined: Sun May 28, 2006 2:08 pm
Location: Holland
Contact:

Post by PaulusB » Mon Aug 07, 2006 4:31 pm

any one :?:

or a mod like this one http://www.phpbbhacks.com/download/263 but than voor topic`s count :idea:

User avatar
PaulusB
Registered User
Posts: 216
Joined: Sun May 28, 2006 2:08 pm
Location: Holland
Contact:

Post by PaulusB » Wed Aug 09, 2006 12:42 pm

Still hope to solve the problem :roll:

Post Reply

Return to “[2.0.x] MOD Database Releases”