1 Topic by luca

  • luca
  • Member
  • Offline
  • Registered: 2012-07-12
  • Posts: 49

Topic: Users deleted

Maybe i had something wrong ...
Last month I inserted manually in table users a lot of users, by inserting group_id, username, password.
Now I  control table and i found that these users was deleted sad
Someone know if there is a in PunBB some automatism that clean table user and, if this exist, how can I prevent or by which rules this is made?
Thanks in advanced

2 Reply by keeshii (edited by keeshii 2013-09-26 12:57)

  • keeshii
  • Extension Developer
  • Offline
  • From: Poland
  • Registered: 2013-04-04
  • Posts: 170

Re: Users deleted

Have you inserted users using gid "0" (zero)? Maybe it was this mechanism (see register.php):

        // Clean old unverified registrators - delete older than 72 hours
        $query = array(
            'DELETE'    => 'users',
            'WHERE'        => 'group_id='.FORUM_UNVERIFIED.' AND activate_key IS NOT NULL AND registered < '.(time() - 259200)
        );

Code above removes users, which gid is equal zero and are 72 hours old. It is executed when someone is registering.

How to prevent it?
a) don't set gid to zero,
b) set activate_key to something else than NULL

regards,
keeshii

If you want to contact me quickly - send e-mail, not PM.
<?php $t='<?php $t=%c%s%c; printf($t,39,$t,39,10);%c'; printf($t,39,$t,39,10);

3 Reply by luca

  • luca
  • Member
  • Offline
  • Registered: 2012-07-12
  • Posts: 49

Re: Users deleted

keeshii wrote:

Have you inserted users using gid "0" (zero)? Maybe it was this mechanism (see register.php):

        // Clean old unverified registrators - delete older than 72 hours
        $query = array(
            'DELETE'    => 'users',
            'WHERE'        => 'group_id='.FORUM_UNVERIFIED.' AND activate_key IS NOT NULL AND registered < '.(time() - 259200)
        );

Code above removes users, which gid is equal zero and are 72 hours old. It is executed when someone is registering.

How to prevent it?
a) don't set gid to zero,
b) set activate_key to something else than NULL

regards,
keeshii

very useful, thank you very much

4 Reply by luca

  • luca
  • Member
  • Offline
  • Registered: 2012-07-12
  • Posts: 49

Re: Users deleted

keeshii wrote:

Have you inserted users using gid "0" (zero)? Maybe it was this mechanism (see register.php):

        // Clean old unverified registrators - delete older than 72 hours
        $query = array(
            'DELETE'    => 'users',
            'WHERE'        => 'group_id='.FORUM_UNVERIFIED.' AND activate_key IS NOT NULL AND registered < '.(time() - 259200)
        );

Code above removes users, which gid is equal zero and are 72 hours old. It is executed when someone is registering.

How to prevent it?
a) don't set gid to zero,
b) set activate_key to something else than NULL

regards,
keeshii


Thanks for explanation, I understand  U help me so much wink