PDA

View Full Version : simple query please


Automated
12-14-2002, 02:34 PM
Hi guys,

Simple problem i have a few members complaining that they have got new pm's and they dont shwo up. The reason is becuase i have installed a quick registration hack from vb.org and lost all the forum default registration settings when people signed up via that form.

SO, could one of you write the query i would run on my DB so it changes every users preferences to show pm's "from the beggining" instead of the last 2 day's.

Thanks a lot!

Matthew

Logician
12-19-2002, 11:08 AM
There is no independent setting for this. "Show PM of last X day" setting is same with "Show threads of last X days" so if you update this, both will change. After this reminder, here is the query:


UPDATE user SET daysprune="1000"