• Registered: 2004-02-12
  • Posts: 32

Topic: óäàëåíèå ïîëüçîâàòåëåé

Âñåì ïðèâåò,
íàðîä ìîæåò êòî ïîäñêàæåò êàê ìîæíî áûñòðî óäàëèòü
íå àêòèâíûõ ïîëüçîâàòåëåé?
èëè òåõ ó êàâî ïîñòîâ íîëü...
õî÷ó ïî÷èñòèòü ôîðóì... à êàê òî âñå äåëàòü ðóêàìè íå õîööà
... èñêàë êàê ñäåëàòü ýòî àâòîìàòîì - íå íàøåë...
ïîèñêàë ìîä êàêîé íèòü... òîæå íå íàøåë...
ìîæåò êòî ïîäåëèòñÿ êàê äåëàåò ýòî?
çàðàíèå ñïàñèáî.

2 Reply by R@

  • R@
  • Junior Member
  • Offline
  • From: Belarus
  • Registered: 2004-08-05
  • Posts: 9

Re: óäàëåíèå ïîëüçîâàòåëåé

ß íå çíàþ êàê â ýòîì ôîðóìå ñ òàáëèöàìè, íî äåëàåööà ýòî çàïðîñîì òèïà òîêîãî:
DELETE FROM pun_users WHERE posts_count = 0;

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: óäàëåíèå ïîëüçîâàòåëåé

I don't understand what you're saying, but if you're talking about deleting unverified users, there's a script for that called prune_unverified_users.php. It's in the scripts directory of the download archive.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2004-06-25
  • Posts: 26

Re: óäàëåíèå ïîëüçîâàòåëåé

Rickard they are saying about script which can delete users with 0 posts

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: óäàëåíèå ïîëüçîâàòåëåé

Aha, ok. Then he'll have to run a query manually like R@ suggested (at least I think he did).

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2004-02-12
  • Posts: 32

Re: óäàëåíèå ïîëüçîâàòåëåé

hmz alright thnx u guys for ur replies smile