PDA

View Full Version : Looking for an SQL query


Polo
06-17-2004, 05:56 PM
What would be the sql query needed to be exectuted in phpmyadmin to make all the forums show the posts since the begining...

every time i click on a forum there is a message that says "There have been no posts in the last 30 days in this forum" what would be the query so that all the forums will show the posts since the begining...

is this even possible?

thanks in advance...

CarCdr
06-17-2004, 06:29 PM
If you are looking to change this behaviour in vBulletin, there are three applicable settings:

Administrative:
Change the default thread cutoff for a forum via the Admin Control Panel :: Forums & Moderators :: Forum Manager :: Some Forum :: Default View Age.

User option:
A user can set their own "Default Thread Age Cut Off" in the User Control Panel.

One-time display:
When viewing a forum listing (i.e., the thread titles), you can change the default date cutoff, toward the bottom of the page under "Display Options".

NTLDR
06-17-2004, 08:24 PM
UPDATE forum
SET daysprune = -1


This will change the setting of every forum to show all the threads (unless you have overrided it with a profile option). You may have to edit and save a forum (no need to make any edits) for the changes to take effect.

Polo
06-18-2004, 12:46 PM
UPDATE forum
SET daysprune = -1


This will change the setting of every forum to show all the threads (unless you have overrided it with a profile option). You may have to edit and save a forum (no need to make any edits) for the changes to take effect.

thank you so much, this is exactly what i was looking for, i appreciate it

Polo
06-21-2004, 01:21 PM
mmm... ok, i think this one should be as simple... but what would be the query to update a users join date?

Dean C
06-21-2004, 03:38 PM
A user or all users?

Polo
06-21-2004, 05:05 PM
A user or all users?
A single user.

Dean C
06-21-2004, 05:21 PM
Hmm I'm not sure of the mysql equivalent of mktime - i'm sorry :(

Polo
06-21-2004, 05:53 PM
Hmm I'm not sure of the mysql equivalent of mktime - i'm sorry :(
oh dont worry, thanks for trying to help i appreciate it... anyone else?

Dean C
06-21-2004, 06:37 PM
Tell me the date you want to set their join date too and the userid and i'll write you a quick PHP script to run to sort it out :)

Polo
06-21-2004, 07:21 PM
actually dean, i managed to change the date by going into the admin pannel, searching for the specific users and changing the date there...

anyways, i really appreciate your help....

thanks.