Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Question Search for users by IP

More
15 years 6 months ago #67765 by Bob Britt
Search for users by IP was created by Bob Britt
Is there anyway short of going to the SQLquery to find a user by IP address? I have some stuff popping up in error logs that are associate with someone's profile and I'd like to find them.

Please Log in or Create an account to join the conversation.

More
15 years 6 months ago - 15 years 6 months ago #67776 by sozzled
Replied by sozzled on topic Re: Search for users by IP
As a general SQL query, you can find all the IP addresses used in messages posted to your forum with the following statement:
Code:
SELECT ip, name FROM jos_kunena_messages GROUP BY ip ORDER BY ip;
If you want to find what user's names were associated with a specific IP address, you could use something like this:
Code:
SELECT ip, name FROM jos_kunena_messages WHERE ip='xxx.xxx.xxx.xxx' GROUP BY ip ORDER BY ip;
where xxx.xxx.xxx.xxx is a specific IP address.

Does that answer your question?
Blue Eagle vs. Crypsis reference guide
Read my blog and
[img
Last edit: 15 years 6 months ago by sozzled.
The following user(s) said Thank You: Bob Britt

Please Log in or Create an account to join the conversation.

More
15 years 6 months ago - 15 years 6 months ago #67885 by Bob Britt
Replied by Bob Britt on topic Re: Search for users by IP
It would if I really felt good about doing SQL stuff...I bet a really smart person could make a module that would do that for us huh?

Thanks, I'll give it a shot. the SQL, not the module...:woohoo:
Last edit: 15 years 6 months ago by Bob Britt.

Please Log in or Create an account to join the conversation.

More
15 years 6 months ago #67888 by Bob Britt
Replied by Bob Britt on topic Re: Search for users by IP
Kinda sorta related questions. How can two users who are on opposite sides of the world, have the same IP logged?

Please Log in or Create an account to join the conversation.

More
15 years 6 months ago #67892 by sozzled
Replied by sozzled on topic Re: Search for users by IP
Your last question does not have anything to do with Kunena.
Blue Eagle vs. Crypsis reference guide
Read my blog and
[img

Please Log in or Create an account to join the conversation.

Time to create page: 0.261 seconds