 |
Tüm Özel Mesajları Silme
|
 |
#6277 |
|
Kaan
User is:
  Posts: 2772
Ülke:
 İstanbul - 34Meslek: Serbest Meslek
Age: 43
|
Clean the private messages
On popular sites the count of private messages can go high, it's often the second biggest SQL table after the posts in forums. So to ... - Delete ALL the PM older than 1 year (including the archives). - Delete the PM older than 6 month and not archived (yet read and still in the inbox). - Delete the PM older than 3 month and not read by the recipient. Run this with phpMyAdmin, tab "SQL" : : ysql]DELETE FROM sed_pm WHERE pm_date < UNIX_TIMESTAMP(NOW()) - 86400 * 365; DELETE FROM sed_pm WHERE pm_date < UNIX_TIMESTAMP(NOW()) - 86400 * 180 AND pm_state=1; DELETE FROM sed_pm WHERE pm_date < UNIX_TIMESTAMP(NOW()) - 86400 * 90 AND pm_state=0; OPTIMIZE TABLE sed_pm; 1. 365 g?nden eski Ar?ivlenmi? ?zel mesajlar? silme 2. 180 g?nden eski Okunmu? ve ar?ivlenmi? ?zel mesajlar? silme 3. 90 g?nden eski okunmam?? ?zel mesajlar? silme Kodlar? ister tek tek isterseniz hepsini birlikte phpmyadmin sayfan?zdan import ediniz. |
Emlak, Oto Galeri, Rent A Car, ?iir, Edebiyat Script Sipari?lerinizi Verebilirsiniz. Detaylar ??in: kaan@ntka.org Seditio 170 ?ndir Capte M?zik ?ndir Seditio Toolbar ?ndir |
 |
 |
