vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Hidden Posts (https://vborg.vbsupport.ru/showthread.php?t=27179)

Goldfinger 09-14-2001 08:48 PM

The script works great when i post a new thread but when i try to post a new reply it comes up with this error:

Database error in vBulletin: Invalid SQL:
SELECT IF(post.userid=0,post.username,user.username) AS username,
post.pagetext,post.allowsmilie,post.userid FROM post
post.pagetext,post.allowsmilie,post.userid,post.hi dden FROM post
LEFT JOIN user ON user.userid=post.userid
WHERE post.visible=1 AND post.threadid='2'
ORDER BY dateline DESC
mysql error: You have an error in your SQL syntax near '.pagetext,post.allowsmilie,post.userid,post.hidde n FROM post
LEFT JOIN u' at line 4
mysql error number: 1064


Any ideas on how to fix it ?

tubedogg 09-14-2001 10:59 PM

Find
post.pagetext,post.allowsmilie,post.userid FROM post
and delete that whole line.

The instructions are fixed, sorry :(

Goldfinger 09-14-2001 11:54 PM

works like a charm now :cool:

excellent hack :)

DarkReaper 09-15-2001 06:01 PM

What about allowing a user to make only part of the post hidden, inside a [hidden] tag or someting.

If you can't do that, could there be an option for the user to specify why they hid the post?

Dakota 09-19-2001 04:01 AM

Nice hack, very useful for the anime forum that I help on.

Dakota 09-20-2001 04:49 AM

Ok, the users gave me this idea, like when you select the option to use a poll, have it take you to another page where you can specify what is in the post, like what the spoiler is about, so you can specify the reason the post it hidden in detail.

maverick1236 09-21-2001 12:22 AM

This person has specified this post as Hidden. It may contain some type of spoiler or less-than-family-friendly language, among other things. To view this post click [here]
when i click the "here" link, i get another window which says...

This person has specified this post as Hidden. It may contain some type of spoiler or less-than-family-friendly language, among other things. To view this post click [here]

the same window!!lol

any ideas?

maverick1236 09-22-2001 01:26 PM

^bump^

maverick1236 09-24-2001 10:22 PM

^bump^

slice 09-25-2001 10:56 AM

i have not installed it all all. how do i install it from scratch? your direction in the first post are for upgrade instructions? are there any instructions for 1st time installation of this hack?

thanks


All times are GMT. The time now is 05:53 PM.

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.01070 seconds
  • Memory Usage 1,727KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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