[TYPO3] restore deleted pages

[Andre Dittmar]

Hello Raymond,

All deleted pages has the deleted-flag set to 1 in the table "pages". So a simple SQL-statement should work:

Simple:
=========
-> UPDATE pages SET deleted=0 where deleted=1;

Note: Every deleted page will be restored!


Extended:
=========
-> UPDATE pages SET deleted=0 where deleted=1 AND tstamp > UNIX_TIMESTAMP([date]);

Note: [date]: Fill in the approximately Date and Time _before_ you've deleted the pages to avoid to undelete older pages. See the mysql-manual for the proper Datetime format: http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html


Hope this helps....
Best regards
Andre

---
Andre Dittmar | hot bytes
 
Elbinger Stra?e 24
74226 Nordheim
Germany 

Fon : +49 (0) 71 33 / 20 46 43
Fax : +49 (0) 71 33 / 20 46 42
D1  : +49 (0) 1 60 / 97 22 03 03

Web : http://www.hotbytes.de
Mail: mail at hotbytes.de

____________
Virus checked by G DATA AntiVirusKit
Version: AVK 16.8590 from 19.07.2006
Virus news: www.antiviruslab.com