[ABD] User Details

[Puchahawa]

I noticed this the other day on my test board David. I only have two members. The founder and a registered user for testing at that level. You can see in this pic the only one that shows up is the founder. If I log in the reg user, log out and back into the founder account, and do the same inquiry the reg user shows up.



running apache 2.4.9, php 5.5.12 on wampserver and 3.2.0 with "version": "2.1.0-rc1" of the ext,

Showing 2 members

[</Solidjeuh>]

It doesn't show all users. I see this [ Total users:103 ] and 5 pages.
But I only see 30 users and 2 pages. The other 3 pages are empty ..

This is fixed via PM thanks to the author!
Problem was not with this EXT, I f*cked something up

[david63]

This is fixed via PM thanks to the author!
Problem was not with this EXT, I f*cked something up

At least we got there in the end

[archivar]

Thanks for this very helpful extension!
PHP Version 7.0.17
MySQL(i) 5.5.54-0+deb7u2-log
PHPBB Version3.2.0
When listing the web pages I get this error:

General error
SQL ERROR [ mysqli ]

Unknown column 'u.pf_phpbb_website' in 'order clause' [1054]

SQL

SELECT g.group_name, g.group_type, pf.*, s.style_name, u.* FROM (phpbb_users u) LEFT JOIN phpbb_groups g ON (u.group_id = g.group_id) LEFT JOIN phpbb_styles s ON (u.user_style = s.style_id) LEFT JOIN phpbb_profile_fields_data pf ON (u.user_id = pf.user_id) WHERE u.user_type <> 2 ORDER BY u.pf_phpbb_website DESC, u.username_clean ASC LIMIT 25

[david63]

@archivar - thanks, bug fixed in next version

[wkuzma]

Thanks for this extension
your extensions always work great

[sakkiotto]

and custom profile fields??

[david63]

and custom profile fields??

The default CPFs are included

[epi4dogs]

David, I'm currently setting up a forum for a non-profit run by non-technical folks and this extension is GOLD Anything that means I don''t have to be rummaging around in databases running scripts to mine data is the duck's nuts. You Sir, deserve a phpKnighthood!

I thank you.

[Parroco]

Hi David,

I can´t get the Custom Profiles Fields listed to select. Did I miss something?

Thank you for your great extension and your support.

[david63]

Hi David,

I can´t get the Custom Profiles Fields listed to select. Did I miss something?

Thank you for your great extension and your support.

There is a small but with CPFs that will be fixed in the next version

[Parroco]

Thanks. Anxiously waiting...

[david63]

Updated to RC3

This extension has been reworked to fully handle all CPFs correctly. Previously it only handled the phpBB default CPFs which were hard coded - now it will handle all CPFs dynamically.

A few minor bugs have been fixed.

[Parroco]

Hi David, thank you so much for providing a solution so fast. Now it works great!

Just in case, if you want it to be PERFECT, I suggest a couple of other improvements you may want to work in: a) it would be nice to be able to change the order in which the fields are listed, and b) dates are now exported as text, and that doesn't allow to order them; having them converted into numbers (the standard date format for Excel) would be much more useful.

Thank you again for your support. Good job!!

[david63]

a) it would be nice to be able to change the order in which the fields are listed,

It would be nice but it would make this too complicated - I might look at it one day.

b) dates are now exported as text, and that doesn't allow to order them;

I can look at that but I am restricted as to how they are stored, for example CPF dates are in text format so there is nothing I can do about those.