Jump to content

Select Inet_Ntoa(Ip) From 'cometchat_Guests' Where 1


Recommended Posts

Hi guys.


I'm modifying my CometChat to display guest user IP addresses to moderators.


I've successfully got ip addresses of guests to save in the database in ip2long format.


Now I need to retrieve and print an IP address of a user to a moderator when they click the guest's username


The code I need to print the IP address is here:


if($owner == 1 || in_array($userid,$moderatorUserIDs)) {
 $options="<input type=button value='".$chatrooms_language[40]."' onclick=javascript:".$caller."kickUser($uid,0);$close class='invitebutton'>
 <input type=button value='".$chatrooms_language[41]."' onclick=javascript:".$caller."banUser($uid,0);$close class='invitebutton'>".$options;


This shows a KICK & BAN button. Either above or below them I need it to say IP: - the guest's IP-


The ip2long IP address is stored in cometchat_guests in the column 'ip'


I need to put:

SELECT INET_NTOA(ip) FROM 'cometchat_guests' WHERE 1



But I'm not sure what goes after WHERE...


WHERE what?


WHERE 1 = $uid

Or WHERE $uid = 1
echo $ip


Would be very grateful and appreciate any help here, thank you so much in advance I'm getting a migraine here

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.