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