Go Back   vBulletin Setup > vBulletinSetup Information > vBulletin Questions


Please Register to get full access to the forums.
Post New Thread  Reply



#1   12-15-2006, 05:24 PM
Posts: n/a
Delete PM


run following query to delete PM as batch

PHP Code:
DELETE FROM `pmtextWHERE `pmtext`.`pmtextid` > 
run following query to be able to delete PMs content as batch
PHP Code:
UPDATE `pmtextSET `pmtextid` = NULL ,
`
fromuserid` = '',
`
fromusername` = '',
`
title` = '',
`
message` = '',
`
touserarray` = '',
`
iconid` = '',
`
dateline` = '',
`
showsignature` = '',
`
allowsmilie` = '' 
WHERE `pmtext`.`pmtextid` > 

Quote   |  
Post New Thread  Reply
vBulletin Setup > vBulletinSetup Information > vBulletin Questions


Thread Tools
Display Modes

 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT -6. The time now is 04:10 PM.

vBulletin Setup, vBulletin Setup Forums, vBulletin Services, vBulletin Blogs, vBulletin SEO, vBulletin Questions, vBulletin Skins, Styles, Templates
vBulletin Hacks / Modifications, vBulletin Monetization, Blogs, vBulletin Link Directory,Quality Link Directory