vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Profile Enhancements - Activity Streams (https://vborg.vbsupport.ru/showthread.php?t=256071)

shanevas2 04-08-2011 04:00 PM

Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.prefixid, post.attach, post.userid AS postuserid, post.username AS postusername,
thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost, thread.lastposterid, thread.lastposter, thread.replycount,
forum.forumid, forum.title_clean as forumtitle,
post.pagetext AS message, post.allowsmilie, post.postid,
user.userid, user.username, thread.lastposter AS lastpostername
FROM thread AS thread
INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
WHERE 1=1
AND (thread.forumid IN(11,12,13,14,15,19,20,21,22,23,24,25,26,1,3,16,1 7,4,5,6,30,2,18,7,8,9,10,27,28,29)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline > 1300467552



AND thread.postuserid IN (1)
ORDER BY thread.dateline DESC
LIMIT 0,1;

MySQL Error : 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 'ORDER BY thread.dateline DESC
LIMIT 0,1' at line 20
Error Number : 1064
Request Date : Friday, April 8th 2011 @ 09:59:12 AM
Error Date : Friday, April 8th 2011 @ 09:59:12 AM
Script : http://texasperformanceforums.com/member.php?1-Shane
Referrer : http://texasperformanceforums.com/forum.php
IP Address : 75.1.52.44
Username : Shane
Classname : vB_Database
MySQL Version : 5.0.91-log

madshark 04-11-2011 04:40 PM

Quote:

Originally Posted by shanevas2 (Post 2182359)
Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.prefixid, post.attach, post.userid AS postuserid, post.username AS postusername,
thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost, thread.lastposterid, thread.lastposter, thread.replycount,
forum.forumid, forum.title_clean as forumtitle,
post.pagetext AS message, post.allowsmilie, post.postid,
user.userid, user.username, thread.lastposter AS lastpostername
FROM thread AS thread
INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
WHERE 1=1
AND (thread.forumid IN(11,12,13,14,15,19,20,21,22,23,24,25,26,1,3,16,1 7,4,5,6,30,2,18,7,8,9,10,27,28,29)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline > 1300467552



AND thread.postuserid IN (1)
ORDER BY thread.dateline DESC
LIMIT 0,1;

MySQL Error : 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 'ORDER BY thread.dateline DESC
LIMIT 0,1' at line 20
Error Number : 1064
Request Date : Friday, April 8th 2011 @ 09:59:12 AM
Error Date : Friday, April 8th 2011 @ 09:59:12 AM
Script : http://texasperformanceforums.com/member.php?1-Shane
Referrer : http://texasperformanceforums.com/forum.php
IP Address : 75.1.52.44
Username : Shane
Classname : vB_Database
MySQL Version : 5.0.91-log


If you went a few pages back ;) : https://vborg.vbsupport.ru/showpost....7&postcount=26

K4GAP 04-19-2011 11:18 AM

Just added to 4.1.3. running great!!

Thanks

EquinoxWorld 06-18-2011 06:18 PM

Confirmed 4.1.4 working great!

8thos 06-21-2011 10:12 PM

Quote:

Originally Posted by yahooooh (Post 2148516)
plz this suggestions i hope they will be exist :

1.ability for user to hide his activity streams or make it only for his friends but not for others

2.abiliy for user to remove single stream , or to remove one type of streams , like :
user1 do not want to show his repies activities but he like to show other activities streams

Milad has a stream like this that does the things you asked called Social Feeds.

You can see it in action after you add someone to your friends list on my site.

exxxir 07-11-2011 02:54 PM

hi
i deleted
\sas\streams\cms.php
\sas\streams\cms_comment.php

but:
Code:

Database error in vBulletin 4.1.3:

Invalid SQL:

                SELECT thread.postusername as firstpostusername, thread.postuserid as firstpostuserid, post.dateline, post.pagetext, post.allowsmilie, post.postid,
                        thread.threadid, thread.title, thread.prefixid, post.attach, thread.replycount,
                        forum.forumid, post.title AS posttitle, post.dateline AS postdateline,
                        user.userid as postuserid, user.username as postusername
                FROM post AS post
                JOIN thread AS thread ON (thread.threadid = post.threadid)
                JOIN forum AS forum ON(forum.forumid = thread.forumid)
                LEFT JOIN user AS user ON (post.userid = user.userid)
                WHERE 1=1
                        AND ( thread.forumid IN(1,690,689,3,469,696,653,470,209,753,754,4,638,550,5,639,641,577,87,695,67,531,97,116,389,795,171,327,388,482,514,523,526,565,567,586,589,537,691,7,692,8,122,123,712,705,9,798,10,465,50,51,48,466,335,336,49,362,11,41,40,42,43,44,812,476,820,12,801,52,53,56,55,84,161,164,165,166,162,163,54,78,467,57,59,751,60,64,66,124,69,216,68,541,361,258,540,72,800,659,669,679,681,680,711,671,685,714,686,668,682,683,684,670,713,752,660,662,827,664,663,826,666,665,661,823,259,667,672,688,674,673,676,675,677,678,824,825,13,552,14,431,446,453,430,391,15,432,443,447,454,16,433,442,448,455,17,434,441,449,456,390,125,435,440,450,457,104,436,439,451,458,105,437,438,452,459,693,172,142,19,126,140,385,141,386,132,387,143,144,145,146,18,195,468,483,20,138,657,174,173,179,178,316,176,784,180,177,175,818,25,331,484,763,762,764,765,766,28,217,704,218,702,703,219,223,509,706,707,708,27,306,699,700,88,697,698,709,576,701,802,803,806,807,808,809,813,819,814,815,816,830,804,817,805,831,694,21,23,318,319,324,22,330,139,24,109,321,332,333,222,460,193,799,462,490,491,492,475,498,464,30,496,771,424,770,29,554,82,557,312,313,314,841,427,553,461,485,756,489,487,488,486,792,622,796,797,480,494,493,497,575,307,310,822,182,183,184,185,214,211,213,186,593,594,595,596,597,598,212,374,375,377,376,380,378,379,381,599,579,620,652,654,619,651,621,573,582,583,584,578,585,581,656,580,600,603,773,775,774,616,632,633,630,631,628,629,635,624,617,626,636,602,590,758,760,757,759,761,768,618,627,769,601,604,648,649,650,794,772,605,655,606,607,608,776,777,778,779,780,33,34,548,546,547,781,549,35,556,786,787,785,551,788,789,790,833,834,835,836,837,838,839,840,555,38,558,106,828,192,338,191,563,168,89,224,39,564,561,560,559,588,562,73,80,342,350,355,356,339,343,341,344,348,347,340,353,345,351,349,352,346,642,81,357,358,658,90,92,91,170,93,94,169,110,114,113,111,95,383,261,269,571,572,517,518,568,277,519,520,521,569,283,522,524,525,288,535,536,534,527,566,302,532,533,528,289,529,530,384,473,515,516,710,715,720,721,722,716,723,724,725,726,717,729,733,727,735,730,731,734,728,732,736,718,738,739,737,719,745,742,747,748,746,743,744,740,741,755,791,31,121,120,257,181,260,543,545,793,643,644,645,832,646,647,479,539,71,6,821,782)
                       
                        AND thread.visible = 1
                        AND post.visible = 1
                        AND thread.open <> 10
                        AND post.dateline > 1308584605
                        AND post.parentid > 0
                       
                       
                        AND post.userid IN (1)
                ORDER BY post.dateline DESC
                LIMIT 0,1;

MySQL Error  : 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 'ORDER BY post.dateline DESC
                LIMIT 0,1' at line 20
Error Number  : 1064
Request Date  : Monday, July 11th 2011 @ 07:43:25 PM
Error Date    : Monday, July 11th 2011 @ 07:43:26 PM
Script        : http://www.parsiniak.com/forum2/member.php?1-Admin
Referrer      :
IP Address    : 46.19.141.250
Username      : Admin
Classname    : vB_Database
MySQL Version : 5.0.92-community


LisaArnold 07-24-2011 02:49 AM

Thanks, but had to uninstall due to it throwing up errors when trying to enter into a profile.

I might try this one again at a later date.

World have been a good mod, so Thanks anyway. :)

Krusty1231 07-24-2011 11:39 AM

Agreed - same error as above. Uninstalled!

kylek 07-31-2011 05:34 PM

Quote:

Originally Posted by Furcal15 (Post 2181662)
How can I keep the activity streams tab but make my visitor messages tab default tab when viewing a users profile?

Thanks and marked as installed :)

Quote:

Originally Posted by Antidepresiv (Post 2150201)
Thanks for this mod.. How could i put the Activity Streams after the Friends tab ? Thanks again..

Quote:

Originally Posted by tattooz (Post 2148151)
How can I change the hook order in the profile. When a profile is viewed, I do not want the activity stream to be the first this someone views. I would like the default, visitor message to be seen first.


I would like to ask the same thing, need to move activity stream out of the first tab position.

Gemma 08-05-2011 11:37 AM

Quote:

Originally Posted by kylek (Post 2227317)
I would like to ask the same thing, need to move activity stream out of the first tab position.

Try this

AdminCP > Plugins & Products > Add New Plugin

Product: vBulletin
Hook Location: member_build_blocks_start
Title: Load Visitor Messages Tab By Default
Execution Order: 1
Plugin PHP code:
Code:

if (!$vbulletin->GPC_exists['tab'])
{
    $vbulletin->GPC['tab'] = 'visitor_messaging';
}

Plugin is Active: Yes

There is probably a way to do it by modifying one of the Activity Stream plugins but I don't use this so can't check. ;)

I use a similar method on my site to load the About Me tab first.


All times are GMT. The time now is 07:39 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02009 seconds
  • Memory Usage 1,762KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete