08-18-10 08:47 PM - Post#84455    

The user is actually me with one of my alternative admin logins. Any post - reply or new topic shows in the forum but in omitted from recent topics.

I can't think of or find a setting that would cause that.

09-25-10 11:17 AM - Post#84621    

    In response to sb1963

Not a one off - still happening

09-25-10 01:09 PM - Post#84622    

    In response to sb1963

well try this.. go to the recent_activity script and go to about line 481 after the closing of the $sql put this

print_r($sql);

then run the script and see what the sql query is actually saying.. then remove that line and run that query in phpMyAdmin or any other form of it..

see if there are any posts showing up.. look at the query and try to figure out why..

The artist formerly known as scroungr Couch-Tomatoe

09-25-10 01:40 PM - Post#84624    

    In response to Couchtomatoe

• Couchtomatoe Said:

I will - once I figure out what you mean!

09-25-10 02:04 PM - Post#84626    

    In response to sb1963

your talking about recent posts not showing up for someone in the recent_activity.php script right? well look about line 480 in that script and you will see the SQL query... put the print_r($sql) after the closing "; and run the script you will see at the top the query it is trying to use.. then look at said query and see if that user is excluded.. then remove that print_r($sql) so no one else sees it..

The artist formerly known as scroungr Couch-Tomatoe

09-25-10 03:57 PM - Post#84628    

    In response to Couchtomatoe

This is what I got. The user ID of the poster (1) isn't on the list. However there are loads of member ID's missing from that list - including 15, my main account & I can see posts from user 15

Code:



 SELECT p.forum_id,p.post_id,p.post_body,p.post_subject,p.post_posted,p.post_is_topic,u.info_display_name,u.info_reg_date,u.info_total_posts,u.info_title,u.info_title_custom,u.info_location,u.info_sharebirthday,u.info_birthday,p.user_id,u.info_signature,info_name_color,info_group_flag,p.post_include_sig,p.post_icon,p.post_has_files,p.post_has_polls,p.post_edited,p.post_edited_by,p.post_edited_reason,p.post_parent,p.post_reply_name,p.post_ip,u.info_group_flag,u.info_no_ignore,u.info_name_color,t.topic_subject,t.topic_is_closed,t.topic_id,t.topic_preview,t.topic_replies,t.topic_views,f.forum_title,f.forum_gallery,f.forum_thumbnail,f.forum_med_image,u.info_attitude,t.topic_prefix,f.forum_ad FROM fbb_forums AS f, fbb_topics AS t, fbb_posts AS p, fbb_user_info AS u WHERE p.user_id = u.user_id AND p.topic_id = t.topic_id AND p.forum_id = f.forum_id AND p.is_moderated != 1 AND t.topic_moved = 0 AND p.post_posted BETWEEN '1285369200' AND '1285455599' AND f.forum_id IN (14,17,18,19,20,22,23,24,25,27,28,29,31,32,34,35,37,44,61,66,67,68,69,70,71,72,73,74,75,76,78,79,94,96,98,99,100,105,107,109,113,114,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,144,145,146,147,148,149,150,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,168,171,172,174,175,177,179,180,181,183,184,186,188,189,190,191,193,194,195,196,198,199,202,204,205,206,207,208,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,231,232,233,234,235,236,237,238,239,240,241,242,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,290,291,292,293,294,295,296,297,298,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,317,318,319,320,321,322,323,324,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,393,394,395,396,397,399,400,401,402,403,406,408,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,451,452,453,454,455,456,457,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,510,511,512,513,514,515,516,517,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,557,558,559,560,561,562,563,564,565,566,567,568,569,570,572,573,574,575,576,577,578,579,580,582,583,584,586,587,588,589) AND p.user_id != '1' ORDER BY p.post_posted DESC LIMIT 20  

09-25-10 06:16 PM - Post#84629    

    In response to sb1963

ok next take that query and run it in phpMyAdmin and see if the posts show there

but lets pull it apart to explain it

its telling you to get this stuff

[code]SELECT p.forum_id,p.post_id,p.post_body,p.post_subject,p.post_posted,p.post_is_topic,u.info_display_name,u.info_reg_date,u.info_total_posts,u.info_title,u.info_title_custom,u.info_location,u.info_sharebirthday,u.info_birthday,p.user_id,u.info_signature,info_name_color,info_group_flag,p.post_include_sig,p.post_icon,p.post_has_files,p.post_has_polls,p.post_edited,p.post_edited_by,p.post_edited_reason,p.post_parent,p.post_reply_name,p.post_ip,u.info_group_flag,u.info_no_ignore,u.info_name_color,t.topic_subject,t.topic_is_closed,t.topic_id,t.topic_preview,t.topic_replies,t.topic_views,f.forum_title,f.forum_gallery,f.forum_thumbnail,f.forum_med_image,u.info_attitude,t.topic_prefix,f.forum_ad
[/code]


from these tables

[code]FROM fbb_forums AS f, fbb_topics AS t,
fbb_posts AS p,
fbb_user_info AS u
[/code]

link these tables by

[code]WHERE p.user_id = u.user_id
AND p.topic_id = t.topic_id
AND p.forum_id = f.forum_id
[/code]

then its telling you not to grab moderated posts

[code]AND p.is_moderated != 1
[/code]

so first I would check one of his posts and see what the is_moderated is set to.. a one means his posts are being moderated and you wont see them til you approve them

then its also telling you not to grab moved topics

[code]AND t.topic_moved = 0[/code]

and to grab it all between

[code]AND p.post_posted BETWEEN '1285369200' AND '1285455599'[/code]

which is between Fri, 24 Sep 2010 23:00:00 GMT and Sat, 25 Sep 2010 22:59:59 GMT

from all these forums

[code]AND f.forum_id IN (14,17,18,19,20,22,23,24,25,27,28,29,31,32,34,35,37,44,61,66,67,68,69,70,71 ,72,73,74,75,76,78,79,94,96,98,99,100,105,107,109,113,114,120,121,122,123,1 24,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142, 144,145,146,147,148,149,150,152,153,154,155,156,157,158,159,160,161,162,163 ,164,165,166,168,171,172,174,175,177,179,180,181,183,184,186,188,189,190,19 1,193,194,195,196,198,199,202,204,205,206,207,208,212,213,214,215,216,217,2 18,219,220,221,222,223,224,225,226,231,232,233,234,235,236,237,238,239,240, 241,242,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260 ,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,27 9,280,281,282,283,284,285,286,287,288,290,291,292,293,294,295,296,297,298,3 00,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,317,318,319, 320,321,322,323,324,326,327,328,329,330,331,332,333,334,335,336,337,338,339 ,340,341,342,343,344,345,346,347,348,349,350,353,354,355,356,357,358,359,36 0,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,3 79,380,381,382,383,384,385,386,387,388,389,390,391,393,394,395,396,397,399, 400,401,402,403,406,408,413,414,415,416,417,418,419,420,421,422,423,424,425 ,426,427,428,429,431,432,433,434,435,436,437,438,439,440,441,442,443,444,44 5,446,447,448,449,451,452,453,454,455,456,457,459,460,461,462,463,464,465,4 66,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484, 485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503 ,504,505,506,507,508,510,511,512,513,514,515,516,517,520,521,522,523,524,52 5,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,5 44,545,546,547,548,549,550,551,552,553,554,555,557,558,559,560,561,562,563, 564,565,566,567,568,569,570,572,573,574,575,576,577,578,579,580,582,583,584 ,586,587,588,589)
[/code]

but not for user_id

[code]AND p.user_id != '1'
[/code]

finaly only return 20 at a time and order them on post time

[code]ORDER BY p.post_posted DESC LIMIT 20[/code]

The artist formerly known as scroungr Couch-Tomatoe

09-25-10 06:23 PM - Post#84630    

    In response to Couchtomatoe

Ah - forums, not users.

Thing is they are posted by me using another ID which I use when posting items on behalf of outside contributors. That account is not set for moderated posting.

Interesting contradiction though as it looks like that user is moderated from your breakdown.

Interesting, because when I HAVE put a user on moderated posting their posts appear in 'recent posts' even before they are approved which is not good.

09-25-10 08:40 PM - Post#84633    

    In response to sb1963

yeah but this there

AND p.is_moderated != 1

should not allow moderated posts through

The artist formerly known as scroungr Couch-Tomatoe