• User list & happynet

    From Tiny@21:1/130.4 to Apam on Mon Dec 10 18:53:48 2018
    Hey Apam (and all),

    Quick question I know you have told me before, but what is the
    procedure for removing a user from the userlist? ie: I have obvious fake accounts (names like NO and 1234) and just want to get rid of them.

    Also, what's the procedure for adding this echo on the happynet side?

    Shawn

    --- MagickaBBS v0.12alpha (Linux/armv7l)
    * Origin: A Tiny slice o pi (21:1/130.4)
  • From apam@21:1/125 to Tiny on Tue Dec 11 10:15:51 2018
    Hey Apam (and all),

    Quick question I know you have told me before, but what is the
    procedure for removing a user from the userlist? ie: I have obvious
    fake accounts (names like NO and 1234) and just want to get rid of
    them.

    At present you need to use the sqlite3 utility. You would type:

    sqlite3 users.sq3

    DELETE FROM users WHERE loginname = NO;

    .quit

    If you want to wait a bit, I'll look at doing a utility this afternoon to
    make it easier, as I imagine it's something more people might like to be
    able to do.

    Also, what's the procedure for adding this echo on the happynet
    side?

    ./utils/mnet/mnetsubunsub mnet.cfg ADD 401 4 /path/to/jambase

    Andrew

    --- MagickaBBS v0.12alpha (Linux/x86_64)
    * Origin: The Fat Sandwich - sandwich.hopto.org:2023 (21:1/125)
  • From apam@21:1/125 to Tiny on Tue Dec 11 10:50:24 2018
    Quick question I know you have told me before, but what is the
    procedure for removing a user from the userlist? ie: I have obvious
    fake accounts (names like NO and 1234) and just want to get rid of
    them.

    Just committed a userdel utility.

    ./utils/userdel/userdel users.sq3 NO

    Will delete NO from your userbase, along with any subscription data he
    might have.

    Andrew

    --- MagickaBBS v0.12alpha (Linux/x86_64)
    * Origin: The Fat Sandwich - sandwich.hopto.org:2023 (21:1/125)
  • From Tiny@21:1/130.4 to apam on Tue Dec 11 17:36:50 2018
    Quoting apam to Tiny <=-

    If you want to wait a bit, I'll look at doing a utility this afternoon
    to make it easier, as I imagine it's something more people might like
    to be able to do.

    Sweet. I see from the next message you did it. ;0

    ./utils/mnet/mnetsubunsub mnet.cfg ADD 401 4 /path/to/jambase

    Right. <sigh> Writing notes. ;)

    Shawn

    ... I want to be what I was when I started to be what I am now.
    --- Blue Wave/386
    * Origin: A Tiny slice o pi (21:1/130.4)
  • From Tiny@21:1/130.4 to apam on Tue Dec 11 17:38:18 2018
    Quoting apam to Tiny <=-

    Just committed a userdel utility.
    ./utils/userdel/userdel users.sq3 NO
    Will delete NO from your userbase, along with any subscription data he might have.

    Perfect thank yoU!

    Shawn

    ... Aviation Lie Ä I thought YOU took care of that.
    --- Blue Wave/386
    * Origin: A Tiny slice o pi (21:1/130.4)
  • From Vk3jed@21:1/109 to apam on Wed Dec 12 08:29:00 2018
    On 12-11-18 10:50, apam wrote to Tiny <=-

    Quick question I know you have told me before, but what is the
    procedure for removing a user from the userlist? ie: I have obvious
    fake accounts (names like NO and 1234) and just want to get rid of
    them.

    Just committed a userdel utility.

    ./utils/userdel/userdel users.sq3 NO

    Will delete NO from your userbase, along with any subscription data he might have.

    Cool. :) I was thinking of whipping up a script, if the sqlite utility accepts STDIO. I recall doing something similar for MySQL years ago. :) The script would just take care of the repetitive syntax and accept the username to delete as a parameter. Same could be done for changing user levels. :)


    ... Very funny Scotty, now beam down my clothes!
    === MultiMail/Win v0.51
    --- SBBSecho 3.03-Linux
    * Origin: Freeway BBS Bendigo,Australia freeway.apana.org.au (21:1/109)
  • From apam@21:1/125 to Vk3jed on Wed Dec 12 13:17:04 2018
    Cool. :) I was thinking of whipping up a script, if the sqlite
    utility accepts STDIO. I recall doing something similar for MySQL
    years ago. :) The script would just take care of the repetitive
    syntax and accept the username to delete as a parameter. Same could
    be done for changing user levels. :)

    Yeah, I'd like to have an actual curses based user editor that allowed deleting, modifying etc. Which is why I've put off making command line
    tools, I just haven't gotten around to making the editor.

    Andrew

    --- MagickaBBS v0.12alpha (Linux/x86_64)
    * Origin: The Fat Sandwich - sandwich.hopto.org:2023 (21:1/125)
  • From Vk3jed@21:1/109 to apam on Wed Dec 12 17:38:00 2018
    On 12-12-18 13:17, apam wrote to Vk3jed <=-

    Yeah, I'd like to have an actual curses based user editor that allowed deleting, modifying etc. Which is why I've put off making command line tools, I just haven't gotten around to making the editor.

    I don't mind hacking scripts, so you can work on a curses based user editor. :)


    ... These mating rituals you humans indulge in are quite disgusting.
    === MultiMail/Win v0.51
    --- SBBSecho 3.03-Linux
    * Origin: Freeway BBS Bendigo,Australia freeway.apana.org.au (21:1/109)
  • From Vk3jed@21:1/109 to Tiny on Wed Dec 12 18:08:00 2018
    On 12-11-18 17:36, Tiny wrote to apam <=-

    ./utils/mnet/mnetsubunsub mnet.cfg ADD 401 4 /path/to/jambase

    Right. <sigh> Writing notes. ;)

    Not particularly difficult, just a bit of syntax to remember. :)


    ... Hypochondriac: someone who enjoys bad health.
    === MultiMail/Win v0.51
    --- SBBSecho 3.03-Linux
    * Origin: Freeway BBS Bendigo,Australia freeway.apana.org.au (21:1/109)