Signiture Question

[mark350]

I have already made several posts on my forum before I added a signiture (that appears on the bottom of each post).

Is there a way to make this signiture automatically appear on all my old posts/replies... or will it only appear on new threads/replies?

I guess I could delete all my posts and repost them now that the signiture is activated, however, that's a pain. Does anyone know the answer to this question?

Thanks in advance for any help!

[Dismounted]

UPDATE post
SET showsignature = 1
WHERE userid = X
Replace "X" with your userid.

[mark350]

I logged in as the administrator and went to 'Maintenance > Execute SQL Query.'

However, it said that I do not have permission to execute SQL Query...? Any idea what I am doing wrong?

Ultimately, all I want to do is add this phrase to the signiture:
"Ad Majorem Dei Gloriam!"

I don't want to risk messing up the database to accomplish this... can you please explain a little better what I need to do. Your help is much appreciated!

[Dismounted]

You need to add your user id into config.php, the part with "Users With Query Running Permissions". Clicking "how to run queries" also reveals this ;).

[mark350]

Ok, I added myself as a user and was able to "execute SQL Query" ... I then did the following:

1. went to the 'execute SQL Query"

2. Entered this information in the "Manual Query":
UPDATE post
SET showsignature = 1
WHERE userid = 27

3. Recieved the following error message:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'true350_buddy.post' doesn't exist

*Any more help will be greatly appreciated, thanks.

[King Kovifor]

Ok, I added myself as a user and was able to "execute SQL Query" ... I then did the following:

1. went to the 'execute SQL Query"

2. Entered this information in the "Manual Query":
UPDATE post
SET showsignature = 1
WHERE userid = 27


3. Recieved the following error message:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'true350_buddy.post' doesn't exist


*Any more help will be greatly appreciated, thanks.

Changed post to include your table prefix, as it appears you have one.

[mark350]

Thank you for responding... please forgive my ignorance. I do not understand the instructions....

"Changed post to include your table prefix, as it appears you have one."

What is a table prefix? How do I find this information? Where do I add it once I find it?

Here's what I understand so far:

1. Go to the "Execute SQL Query "

2. under the manual query, enter this:

UPDATE post
SET showsignature = 1
WHERE userid = 27

*** do you want me to change the word "post"... what should it look like? I'm sorry, but I'm not understanding the instructions. Thanks for your patience.

[King Kovifor]

Within your config file, you set the following PHP variable to something:

$config['Database']['tableprefix']

Whatever is found within the '' needs to be placed in front of post within the query. There should be no spaces.

So if you had bb_ within the quotes you would change post to bb_post.

[mark350]

That worked! Thanks for your patience and your help!