Thanks Ciaran - I might just diable the account like you suggested. My guess is that this was a "drive-by" account anyway and I won't be seeing it used again. - Keith
On Thu, Apr 2, 2009 at 9:43 AM, Ciaran Gultnieks <[email protected]> wrote: > > 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 > > -- Keith Erskine tel: +1 978 884 8113 skype: keith.erskine
_______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
