The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
mysql record pruning
Hi folks,
Just wondering if somebody can have a look at the queries in Jake's post in [this thread] and possibly come up with another query I can run? I'm getting quite desperate with this. Cheers, Robert |
#2
|
|||
|
|||
Code:
DELETE FROM pm, pmtext, pmreceipt USING pm, pmtext, pmreceipt WHERE pmtext.dateline < '1032632190' AND pmtext.pmtextid=pm.pmtext AND pm.pmid = pmreceipt.pmid; |
#3
|
|||
|
|||
Your reply is much appreciated but I've since gone through the db and removed the entries manually, thanks anyway
Cheers, Robert |
#4
|
|||
|
|||
too bad I wasn't on here sooner, would have saved you the trouble...
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|