Add Signature in Non-Signatured Posts?

[forumsoup.com]

I noticed that if you post a post/thread (etc) without having a signature and then add a signature in your user cp and make a new post/thread (etc), the signature of course is there. If you look at one of your old post/thread (etc) that was posted before you added your signature, the signature has not been updated their. If you update your signature, the post/thread (etc) with the older signature will be updated but the post/thread (etc) that was made before the signature was made, will never be updated. Is there a mod/hack/ext. (etc) to enable adding signatures to posts that never had signatures?

[ajmboy]

There was by running an SQL query..I saw in another post....

[CyberAlien]

In profile.php find this:

		$userdata->set('signature', $signature);

and add before it:

		if(empty($vbulletin->userinfo['signature']))
		{
			$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "post SET showsignature = '1' WHERE userid='" . $vbulletin->userinfo['userid'] . "'");
		}

This will automatically add signature to old posts if user has just set a signature and signature was empty before.

[fordp]

Where do you edit this?

[Kirk Y]

In your "profile.php" file, located in your forum's root directory. Download it from your FTP, perform the above edits, and then re-upload the file.

[fordp]

Thanks for your help.
I downloaded the php, modified it as stated, uploaded it back, refreshed old post with no sig, still no sig. The poster has a sig enabled/set.
??

[Kirk Y]

The above edits will only work from this point forward. To show signatures retroactively, perform the following SQL Query:

[sql]UPDATE post SET showsignature = 1 WHERE showsignature = 0;[/sql]

[fordp]

Just received:

"vBulletin Message

You are not authorized to execute SQL queries"

Any ideas?

[Kirk Y]

You can either execute the query through PHPMyAdmin or give yourself permission to execute queries through vBulletin by editing your includes/config.php file.

Search for the following in your includes/config.php file if you wish to do the latter:

****** USERS WITH QUERY RUNNING PERMISSIONS ******

[MediaHound]

Thanks CyberAlien and Kirk, much appreciated, exactly what I needed too!