Search found 12 matches

by KungFuJosh
Thu Nov 15, 2018 12:31 pm
Forum: Extensions in Development
Topic: [DEV] Post Love
Replies: 726
Views: 100031

Re: [DEV] Post Love

I installed this extension (via git clone) in August - which as far as tell is the latest version. First off, it's great - thanks. The only issue I have is that we only get notifications sometimes. i.e. Sometimes when someone likes my post, there is a notification. Other times there isn't. The like...
by KungFuJosh
Thu Nov 15, 2018 12:31 pm
Forum: Extensions in Development
Topic: [DEV] Post Love
Replies: 726
Views: 100031

Re: [DEV] Post Love

I installed this extension (via git clone) in August - which as far as tell is the latest version. First off, it's great - thanks. The only issue I have is that we only get notifications sometimes. i.e. Sometimes when someone likes my post, there is a notification. Other times there isn't. The like...
by KungFuJosh
Fri Aug 25, 2017 8:00 pm
Forum: [3.2.x] Support Forum
Topic: Pruning Non-activated Users
Replies: 10
Views: 359

Re: Pruning Non-activated Users

I changed it to this, but I probably won't keep the user_type = 1 in there: SELECT * FROM `phpbb_users` WHERE `user_id` != '1' AND `user_id` != '2' AND `user_lastpage` = '' AND `user_lastvisit` = '' AND `user_new` = '1' AND `user_type` = '1' AND `user_posts` = '0' AND (`user_email` LIKE '%.ru' OR `u...
by KungFuJosh
Fri Aug 25, 2017 7:58 pm
Forum: [3.2.x] Support Forum
Topic: Pruning Non-activated Users
Replies: 10
Views: 359

Re: Pruning Non-activated Users

Brf wrote:
Thu Aug 24, 2017 8:27 pm
No. You have it written like this:
Hehe, I edited my post when I realized what you were saying, I guess you didn't see it in time. :)

Thanks again.
by KungFuJosh
Thu Aug 24, 2017 8:20 pm
Forum: [3.2.x] Support Forum
Topic: Pruning Non-activated Users
Replies: 10
Views: 359

Re: Pruning Non-activated Users

stevemaury wrote:
Thu Aug 24, 2017 7:15 pm
User_type 1 is inactive users. User_type 0 is active users. 2 is bots and Anonymous and 3 is Founder.
You could delete all inactive users with no posts with this SQL
Thanks, that helps. It appears I'm going to have to prune some "active" accounts too.
by KungFuJosh
Thu Aug 24, 2017 8:19 pm
Forum: [3.2.x] Support Forum
Topic: Pruning Non-activated Users
Replies: 10
Views: 359

Re: Pruning Non-activated Users

Brf wrote:
Thu Aug 24, 2017 5:00 pm
You need a parenthesis around that "OR". Otherwise you are catching everyone with a ".cn" email.
Thanks!
by KungFuJosh
Thu Aug 24, 2017 3:36 pm
Forum: [3.2.x] Support Forum
Topic: Pruning Non-activated Users
Replies: 10
Views: 359

Re: Pruning Non-activated Users

In your answer, are you suggesting it's required to remove users separately from the group table as well as the users table? Looking at the table, that seems accurate as the user_ids are all listed in the group table. I have over 30K users on my board, most of which are legit, so this is a little da...
by KungFuJosh
Thu Aug 24, 2017 2:16 pm
Forum: [3.2.x] Support Forum
Topic: Pruning Non-activated Users
Replies: 10
Views: 359

Pruning Non-activated Users

Hi, Does anybody have any cool tricks to delete non-activated user accounts? Most people suggest using the "inactive" list - but I have no interest in deleting activated, legitimate accounts that haven't logged on in a while (many of which have posts in the inactive list). My board is fairly large, ...
by KungFuJosh
Tue Aug 23, 2016 8:36 pm
Forum: Extension Writers Discussion
Topic: Piwigo bridge
Replies: 22
Views: 3467

Re: Piwigo bridge

I decided to go ahead and do a test install of Piwigo, first replacing user_id with pwg_user_id in all the source code. Then I did a fresh install of my modified Piwigo version. I did the same string replace of user_id with pwg_user_id on the Community plugin that was also causing errors. I then exp...
by KungFuJosh
Tue Aug 23, 2016 7:28 pm
Forum: Extension Writers Discussion
Topic: Piwigo bridge
Replies: 22
Views: 3467

Re: Piwigo bridge

SIDE NOTE: For anybody implementing this, you should make sure to also set the following: $conf['insensitive_case_logon'] = true; That way it doesn't matter whether you use username or username_clean from the phpBB database, and users don't have to worry about case-sensitivity with their usernames....
by KungFuJosh
Sun Aug 21, 2016 6:15 pm
Forum: Extension Writers Discussion
Topic: Piwigo bridge
Replies: 22
Views: 3467

Re: Piwigo bridge

For anybody paying attention, there are a ton of conflicts arising from the user of user_id throughout both scripts. The column being titled "user_id" in phpbb_users causes some other issues depending on how much you actually plan on using Piwigo's admin. The method used here: $conf['user_fields'] =...
by KungFuJosh
Sun Aug 21, 2016 1:27 am
Forum: Extension Writers Discussion
Topic: Piwigo bridge
Replies: 22
Views: 3467

Re: Piwigo bridge

For compatibility with phpBB 3.1 (and probably 3.2) you need to change the password hash line to support bcrypt instead of md5:

Code: Select all

$conf['password_hash'] = create_function('$s', 'return password_hash($s);');
That works for me with phpBB 3.1.9 and PHP 5.6

Go to advanced search