vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Update signature throughout all posts (https://vborg.vbsupport.ru/showthread.php?t=123906)

bbakes25 08-14-2006 03:31 AM

Update signature throughout all posts
 
Hello,

I used to know how to do this, but now I don't :(

What I need to do is how can I have a members signature updated throughout all posts, even ones that were posted before the member had a signature. Please help. Thanks! :)

Kirk Y 08-14-2006 07:30 PM

I believe as soon as a new post is made after the Signature is set, all old posts have the Signature as well -- at least, that's been my experience on my own site, however I could be wrong.

Paul M 08-14-2006 09:33 PM

A members signature is seperate from the posts (i.e. it only exists once) - so when it's updated it will display the same on all posts - previous as well as new.

bbakes25 08-16-2006 05:46 AM

Hello,

For example. This thread:
http://clashforums.com/showthread.php?p=15#post15

user: gtbakes89

1st one has a signature, 2nd one by me doesn't. How can I get that first one to have one?

MJM 08-16-2006 08:26 AM

Update users past posts without signatures:
Maintenance > Execute SQL Query > Manual Query >

UPDATE post
SET showsignature = 1
WHERE userid = X (enter user id #)

> Continue ... Done :)

pokerie 09-27-2006 07:28 AM

Just having this problem now myself, is there a query that can be used to update ALL users and not just one so that it will automatically update everyones signature in all posts as they create it?

For anyone else looking, this is the response to my above question I got from vbulletin.com support:)

Quote:

UPDATE post SET showsignature = 1

This will set signature = 1 on all posts. If the user doesn't have a sig set no sig will show.

daydie 03-17-2009 08:52 PM

im having this problem but i cant enter what he said, i get error, i know this is old post but, i got this problem

RLShare 03-17-2009 09:13 PM

Do you have a table prefix?

daydie 03-18-2009 06:10 PM

default prefix i think (if there is a default one, If not nope)

daydie 03-25-2009 10:28 PM

Can any1 help please?


All times are GMT. The time now is 02:57 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.00991 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)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)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