PDA

View Full Version : Short Question


Salva47
07-13-2007, 09:48 AM
How can I make a user upload more than one image into their signature? I can't find it and they can upload just one and introduce it lice sigpic /sigpic, but just one.

:confused:

deezelpope
07-13-2007, 10:20 AM
Use a separate uploader off-site, like tinypic.com, xs.to, or photobucket.com.

And to avoid confusion, I disabled that sig pic uploader entirely.

Salva47
07-13-2007, 10:57 AM
Use a separate uploader off-site, like tinypic.com, xs.to, or photobucket.com.

And to avoid confusion, I disabled that sig pic uploader entirely.

Thanks. Another question:

How can I make that when I change a signature in the future, it will change for all the posts I've written in the past and not only for the posts I write from then onwards?

deezelpope
07-13-2007, 11:15 AM
No problem!:)

All your posts should change by default.

cyberphr
07-13-2007, 11:36 AM
Thanks. Another question:

How can I make that when I change a signature in the future, it will change for all the posts I've written in the past and not only for the posts I write from then onwards?

That will be done by default, but you will have to wait for the cache to clear.

Dismounted
07-14-2007, 06:08 AM
Thanks. Another question:

How can I make that when I change a signature in the future, it will change for all the posts I've written in the past and not only for the posts I write from then onwards?
To add to the others, only posts that you have marked "Show your signature" will have your signature on them.

Salva47
07-15-2007, 02:37 PM
It seems like it isn't set by default. I had my signature blank, with posts in which there was no signature. I changed my signature, wrote a post and the new signature appeared but just in the new post, not in the other ones, which continued with the blank signature.

Is there an option in the admincp to control that?

:confused:

Kirk Y
07-15-2007, 03:00 PM
vBulletin Options -> Maintenance (Very bottom of AdminCP) -> Select "On - Display Signatures" from the Automatic Query dropdown.

Salva47
07-15-2007, 03:09 PM
vBulletin Options -> Maintenance (Very bottom of AdminCP) -> Select "On - Display Signatures" from the Automatic Query dropdown.

Is that: "Ejecutar Consulta SQL" in spanish?

I emptied the signature cache, but it doesn't work with that. Can explain what you said again please? I am not sure of where it is :confused::rolleyes:

Kirk Y
07-15-2007, 03:12 PM
I didn't mean to put vBulletin Options there, it's habit, lol.

In your AdminCP's Left Menu, scroll all the way to the bottom; you'll see "Maintenance"; click that and you'll see Execute SQL Query (Or Ejecutar Consulta SQL), click that; and then in the Automatic Query dropdown, select "On - Display Signatures".

Salva47
07-15-2007, 03:30 PM
I didn't mean to put vBulletin Options there, it's habit, lol.

In your AdminCP's Left Menu, scroll all the way to the bottom; you'll see "Maintenance"; click that and you'll see Execute SQL Query (Or Ejecutar Consulta SQL), click that; and then in the Automatic Query dropdown, select "On - Display Signatures".

Okay, I didn't search into the vbulletin options anyway hahha. I can't execute sql queries so I guess I'll have to change it in config.php. Let's see :)

It doesn't work

I did what you said, execute sql queries, "habilitado-mostrar firmas" and it says: "Fila afectada: 0" and then it doesn't show in the forum the new signature... :confused:

Kirk Y
07-15-2007, 03:47 PM
4 years of Spanish and I still don't understand much. :o

It's the 15th query in the dropdown box.

Salva47
07-15-2007, 03:52 PM
4 years of Spanish and I still don't understand much. :o

It's the 15th query in the dropdown box.

Sorry, I thought you'd understand me. Apologies.

I run the 15th option--- continue---- and I get: Message from vbulletin: Row affected: 0

:confused:

Kirk Y
07-15-2007, 03:57 PM
Hmm, give this a try:
UPDATE post SET showsignature = 1 WHERE showsignature = 0;

Salva47
07-15-2007, 04:01 PM
perfect! thanks to you! ;):up:

Kirk Y
07-15-2007, 04:02 PM
Glad it worked. I thought the Query I was having you select did the same thing, but evidently it does not.