Keith Erskine wrote: > Good morning - we had some spammer set up an account on our server and > I'd like to remove it. Normally I might ignore, but as we're working > on SMS integration, accounts like these end up costing my company > money. > > I'm assuming that I'll have to go into the database to do this, so any > pointers to the right fields would be appreciated.
Off the top of my head, and assuming you have the user's ID, you need to delete at least: from notice where profile_id = ID from user where id = ID from profile where id = ID It gets more complicated where things like replies and favourites are involved. If you're using MySQL, you will get away with doing it 'wrong' though and just doing the above, because it won't be enforcing any of the constraints. On the other hand, you end up with a messy database. The delete account functionality really needs implemented properly: http://laconi.ca/trac/ticket/155 In the meantime, it might be easier to just disable the account. Cheers, Ciaran _______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
