Vaupell
12-05-2009, 05:09 PM
Original post at vb.com (http://www.vbulletin.com/forum/showthread.php?329348-Help-with-SQL-query-need-to-reset-colum-pmunread-from-user) but thinking this is proberly a better place..
Been haveing alot of problems with a old mod i removed along with upgradeing to vb4.
It was sending pms to users with arcade stuff, and such.. all removed now,
uninstalled succesfully. but now while uninstalling if left PMunreads with alot of people
howewer the message is gone, so unable to reset it, so when logging in it always says
you have x number of private messages..
We agreed to simply reset the count to 0..
So i went and found the table and colum i need to change to 0 for all.
but i need help formulating a query..
table is
<prefix>user
Colum is
pmunread
so i was thinking something like..
UPDATE '<prefix>user' SET 'pmunread' = 0
usually i would add "where" after new value, but im not sure if leaving it out like above
it would just update ALL records as wanted
havent tryed anything, wanted to hear first.. (no rush)
Been haveing alot of problems with a old mod i removed along with upgradeing to vb4.
It was sending pms to users with arcade stuff, and such.. all removed now,
uninstalled succesfully. but now while uninstalling if left PMunreads with alot of people
howewer the message is gone, so unable to reset it, so when logging in it always says
you have x number of private messages..
We agreed to simply reset the count to 0..
So i went and found the table and colum i need to change to 0 for all.
but i need help formulating a query..
table is
<prefix>user
Colum is
pmunread
so i was thinking something like..
UPDATE '<prefix>user' SET 'pmunread' = 0
usually i would add "where" after new value, but im not sure if leaving it out like above
it would just update ALL records as wanted
havent tryed anything, wanted to hear first.. (no rush)