1
I am installing a Chatroom and Instant Messenager program and I am trying to use XOOPS membership's database so that the chatroom and IM can put there user name automatically in the (NickName) field, rather than have the members type it in and hit the submit button.
I am using a php file:
//BUDDYLIST.PHP//
$DB_USR = "myDataUser";
$DB_PWD = "******";
$DB_NAME = "myDataName";
$DB_HOST = "localhost";
$db = mysql_connect($DB_HOST, $DB_USR, $DB_PWD)
or die ("Could not connect to database");
mysql_select_db($DB_NAME, $db);
if ($request=="add"){
$query2 = "INSERT INTO `buddylist`(`user`,`buddy`) VALUES('$user','$buddy')";
$result = mysql_query($query2);
if (!$result) {
die('Invalid query: ' . mysql_error());
}
}
if ($request=="remove"){
$query2 = "DELETE FROM `buddylist` WHERE user='$user' and buddy='$buddy'";
$result = mysql_query($query2);
if (!$result) {
die('Invalid query: ' . mysql_error());
}
}
[color=CC0000]$query3 = "SELECT `buddy` FROM `buddylist` WHERE user='$user_username'";[/color]
$result3 = mysql_query($query3);
$numofrows=mysql_num_rows($result3);
for($ii=0;$ii<$numofrows;$ii++)
{
mysql_fetch_row($result3);
if($ii==$numofrows-1)
{
$budy.=mysql_result($result3,$ii,"buddy");
}
else
{
$budy.=mysql_result($result3,$ii,"buddy").",";
}
}
echo("$buddy");
?>
And to find the username and their ID the following file:
include("connect.php");
?>
welcome
