• From: Woodland Park , CO USA
  • Registered: 2006-12-23
  • Posts: 3

Topic: Modifying SQL tables directly

Is there any description of the SQL tables and the dependencies between them ?

Specifically I want to delete a bunch of users who've never posted and are probably spambots .
Can I just delete the records in , in my case ,  4thCoSyusers , or are there other tables I must also update ? I see "bans" links to userID . I guess the records must be deleted there also ?

Thanks ,

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Modifying SQL tables directly

Bans are not lined to specific users
Posts, authors, etc are: might I suggest deleting them through their profiles or (if there are too many) using the copy of the User Management plugin I posted in the topic

  • Registered: 2006-06-05
  • Posts: 410

Re: Modifying SQL tables directly

http://punbb.org/docs/dev.html#dbtables

  • From: Germany
  • Registered: 2007-02-14
  • Posts: 644

Re: Modifying SQL tables directly

Good point! Did anybody ever write down the purpose and the connections of all the files of a normal punBB installation?
I am trying to modify punBB to use it for different purposes. Therefore, that would be very helpful, so that I know where I have to change what...

FluxBB - v1.4.8

lie2815's Website

  • From: Woodland Park , CO USA
  • Registered: 2006-12-23
  • Posts: 3

Re: Modifying SQL tables directly

Thanks for the input .

I just went ahead and deleted the bouncing users directly from the users table using the phpMyAdmin interface .  No apparent problems . ( They had no posts anyway . )

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Modifying SQL tables directly

Bob Armstrong wrote:

Thanks for the input .

I just went ahead and deleted the bouncing users directly from the users table using the phpMyAdmin interface .  No apparent problems . ( They had no posts anyway . )

No subscriptions and no posts? Yeah, just deleting from the table works then