Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
3 registered (Ruben, Dunny, Matthias1976), 34 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
<span class='adminname'>SD</span>
SD
Registered: 04/19/07
Posts: 4205
Top Posters (30 Days)
Ruben 33
Gizmo 18
Rob Provencher 12
SD 9
Rimex 9
Bert 8
sw55 7
Eugene 5
TCS1 4
Matthias1976 4
Latest Photos
Uhm...
Mayan End of World
Gas Station Disco Video Shoot
Test Pictures
Audrey Kate
Page 2 of 4 < 1 2 3 4 >
Topic Options
#177440 - 02/04/07 11:10 AM Re: Delete all PMs with 'Welcome' Subject [Re: Gizmo]
24hourcampfire Offline
journeyman
Registered: 11/02/06
Posts: 96
Like me.

I just upgraded and found that every single PM the site has ever generated are back. Purged PMs, weren't. Everybody's mailbox is full, full, full.

Any way to delete everything before a certain date, or let's not be picky, by ANY orderly means en masse???

Rick
_________________________
Rick
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#177465 - 02/04/07 04:00 PM Re: Delete all PMs with 'Welcome' Subject [Re: 24hourcampfire]
Gizmo Offline

Registered: 06/05/06
Posts: 15452
Loc: Portland, OR; USA
Well, theres a reason they're "back"; they never where gone...

Keep in mind that there are 2 parties in a PM, not just one. So when one person deletes, it's still there for the other user, until they delete the message as well.

There where two differant ways to go about pm importing:
A. Don't import them, gone forever.
B. Import all pm's and assign them to the users who had posted in them.

Seeing as most users use pm's, we all harassed rick till he went with B :x...

And you could purge pm's by using the datestamp and a unix epoch date...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Top
#184511 - 05/20/07 05:12 AM Re: Delete all PMs with 'Welcome' Subject [Re: 24hourcampfire]
cclapper Offline
stranger
Registered: 05/20/07
Posts: 3
hmm.. I hope Rick can fix it..
_________________________
http://www.you-switch.org - Youswitch provides advice on switching utility bills.
http://www.broardband.net - broadband advice
Top
#184512 - 05/20/07 06:13 AM Re: Delete all PMs with 'Welcome' Subject [Re: cclapper]
Gizmo Offline

Registered: 06/05/06
Posts: 15452
Loc: Portland, OR; USA
the only real "fix" would be to not import PM's... Theres not much of a grey area, as in there isn't really a way to check if they exist for both or one user with the import scripts.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Top
#184523 - 05/21/07 12:15 AM Re: Delete all PMs with 'Welcome' Subject [Re: Gizmo]
ntdoc Offline
Registered: 11/08/06
Posts: 3386
I'm not sure and have not looked, but don't ALL messages regardless of type or area contain a unique id ? If not perhaps it would be a good idea to implement a unique ID for all messages that way in the future it could be used for multiple purposes of tracking or other uses.
Top
#184525 - 05/21/07 12:42 AM Re: Delete all PMs with 'Welcome' Subject [Re: ntdoc]
Gizmo Offline

Registered: 06/05/06
Posts: 15452
Loc: Portland, OR; USA
All messages do have a unique id; it'd be their index id in the database
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Top
#184548 - 05/21/07 09:24 PM Re: Delete all PMs with 'Welcome' Subject [Re: Gizmo]
ntdoc Offline
Registered: 11/08/06
Posts: 3386
Well then perhaps I'm off base but if he's trying to keep out duplicates can't some type of query be written to ignore duplicates based on the unique id ?
Top
#184557 - 05/21/07 10:31 PM Re: Delete all PMs with 'Welcome' Subject [Re: ntdoc]
Gizmo Offline

Registered: 06/05/06
Posts: 15452
Loc: Portland, OR; USA
just becuse it's the same content in the message doesn't mean it's the same message; a new message is created when a user signs up, it's not the same message at all, so each message would have it's own id
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Top
#184563 - 05/22/07 12:03 AM Re: Delete all PMs with 'Welcome' Subject [Re: Gizmo]
ntdoc Offline
Registered: 11/08/06
Posts: 3386
True, I get ya
Top
#192931 - 07/26/07 11:11 AM Re: Delete all PMs with 'Welcome' Subject [Re: Gizmo]
Taylor Offline
journeyman
Registered: 10/06/06
Posts: 85
Thank you for the script Gizmo.
I am one of the large site owners that does not have a clue about MySQL that welcomes anything that can make my look like if I did :-)
Top
Page 2 of 4 < 1 2 3 4 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Express hosting.
by Ruben
05/16/13 03:54 PM
Level of detail in new user registration emails
by Mitch P.
05/15/13 10:20 PM
Approving users
by Bert
05/15/13 09:22 PM
Users randomly added to other group
by Bert
05/15/13 09:15 PM
Posting and other problems with 7.5.7
by Matthias1976
05/15/13 02:58 PM
Forum Stats
10964 Members
36 Forums
33956 Topics
183369 Posts

Max Online: 978 @ 06/24/07 10:19 PM
Random Image