[phpMyChat CVS] CVS: phpMyChat - 0.14/chat usersL.php3,1.3,1.4 usersH.php3,1.9,1.10

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/phpmychat/phpMyChat - 0.14/chat
In directory usw-pr-cvs1:/tmp/cvs-serv13796

Modified Files:
	usersL.php3 usersH.php3 
Log Message:
Updates the gender information feature

***** Bogus filespec: -
***** Bogus filespec: 0.14/chat
Index: usersL.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/usersL.php3,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** usersL.php3	2001/03/23 18:44:46	1.3
--- usersL.php3	2001/04/11 21:04:46	1.4
***************
*** 65,82 ****
  
  //** Display users list for the current room **
! $DbLink->query("SELECT username, latin1, status FROM ".C_USR_TBL." WHERE room='$R' ORDER BY username");
  echo("<B>".htmlspecialchars(stripslashes($R))."</B><SPAN CLASS=\"small\"><BDO dir=\"${textDirection}\"></BDO>&nbsp;(".$DbLink->num_rows().")</SPAN><BR>\n");
! while(list($User, $Latin1, $status) = $DbLink->next_record())
  {
  	// Put an icon when there is a profile for the user
  	if ($status != "u" && $status != "k" && $status != "d" && $status != "b")
  	{
- 		$ImgNum++;
  		$Cmd2Send = ($User == stripslashes($U) ? "'PROFILE',''" : "'WHOIS','".special_char2($User,$Latin1)."'");
! 		echo("<A HREF=\"#\" onClick=\"window.parent.runCmd($Cmd2Send); return false;\" CLASS=\"user\" onmouseover=\"document.images['whoisImg$ImgNum'].src = window.parent.imgWhoisOn.src\" onmouseout=\"document.images['whoisImg$ImgNum'].src = window.parent.imgWhoisOff.src\"><IMG NAME=\"whoisImg$ImgNum\" SRC=\"images/whoisOff.gif\" WIDTH=5 HEIGHT=9 BORDER=0 ALT=\"".L_PROFILE."\"></A>&nbsp;");
  	}
  	else
  	{
! 		echo("-&nbsp;");
  	};
  	if($User != $U)
--- 65,115 ----
  
  //** Display users list for the current room **
! if (C_DB_TYPE == 'mysql')
! {
! 	$currentRoomQuery	= 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
! 						. 'FROM ' . C_USR_TBL . ' usr LEFT JOIN ' . C_REG_TBL . ' reg ON usr.username = reg.username '
! 						. 'WHERE usr.room = \'' . $R . '\' '
! 						. 'ORDER BY usr.username';
! }
! else if (C_DB_TYPE == 'pgsql')
! {
! 	$currentRoomQuery	= 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
! 						. 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
! 						. 'WHERE usr.room = \'' . $R . '\' '
! 						. 'UNION '
! 						. 'SELECT usr.username, usr.latin1, usr.status, NULL '
! 						. 'FROM ' . C_USR_TBL . ' usr '
! 						. 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND usr.room = \'' . $R . '\' '
! 						. 'ORDER BY usr.username';
! }
! else
! {
! 	$currentRoomQuery	= 'SELECT usr.username, usr.latin1, usr.status, NULL '
! 						. 'FROM ' . C_USR_TBL . ' usr '
! 						. 'WHERE usr.room = \'' . $R . '\' '
! 						. 'ORDER BY usr.username';
! }
! 
! $DbLink->query($currentRoomQuery);
  echo("<B>".htmlspecialchars(stripslashes($R))."</B><SPAN CLASS=\"small\"><BDO dir=\"${textDirection}\"></BDO>&nbsp;(".$DbLink->num_rows().")</SPAN><BR>\n");
! while(list($User, $Latin1, $status, $gender) = $DbLink->next_record())
  {
  	// Put an icon when there is a profile for the user
+ 	if($gender == 0)
+ 		$gender = 'undefined';
+ 	elseif($gender == 1)
+ 		$gender = 'boy';
+ 	elseif($gender == 2)
+ 		$gender = 'girl';
+ 	else
+ 		$gender = 'none';
  	if ($status != "u" && $status != "k" && $status != "d" && $status != "b")
  	{
  		$Cmd2Send = ($User == stripslashes($U) ? "'PROFILE',''" : "'WHOIS','".special_char2($User,$Latin1)."'");
! 		echo('<a href="#" onClick="window.parent.runCmd('.$Cmd2Send.'); return false;" class="user"><img src="images/gender_'.$gender.'.gif" width="14" height="14" border="0" alt="'.L_PROFILE.'"></a>&nbsp;');
  	}
  	else
  	{
! 		echo('<img src="images/gender_none.gif" width="14" height="14" border="0" alt="' . L_NO_PROFILE . '">&nbsp;');
  	};
  	if($User != $U)
***************
*** 103,122 ****
  	while(list($Other) = $DbLink->next_record())
  	{
! 		$OthersUsers->query("SELECT username, latin1, status FROM ".C_USR_TBL." WHERE room = '".addslashes($Other)."' ORDER BY username");
  		if($OthersUsers->num_rows() > 0)
  		{
  			$notEmptyRooms[$Other] = 1;
  			echo("<A HREF=\"$From?Ver=L&L=$L&U=".urlencode(stripslashes($U))."$AddPwd2Link&R1=".urlencode($Other)."&T=1&D=$D&N=$N&E=".urlencode(stripslashes($R))."&EN=$T\" TARGET=\"_parent\">".htmlspecialchars($Other)."</A><SPAN CLASS=\"small\"><BDO dir=\"${textDirection}\"></BDO>&nbsp;(".$OthersUsers->num_rows().")</SPAN><BR>\n");
! 			while(list($OtherUser,$Latin1,$status) = $OthersUsers->next_record())
  			{
  				// Put an icon when there is a profile for the user
  				if ($status != "u" && $status != "k" && $status != "d" && $status != "b")
  				{
! 					$ImgNum++;
! 					echo("<A HREF=\"#\" onClick=\"window.parent.runCmd('WHOIS','".special_char2($OtherUser,$Latin1)."'); return false;\" CLASS=\"user\" onmouseover=\"document.images['whoisImg$ImgNum'].src = window.parent.imgWhoisOn.src\" onmouseout=\"document.images['whoisImg$ImgNum'].src = window.parent.imgWhoisOff.src\"><IMG NAME=\"whoisImg$ImgNum\" SRC=\"images/whoisOff.gif\" WIDTH=5 HEIGHT=9 BORDER=0 ALT=\"".L_PROFILE."\"></A>&nbsp;");
  				}
  				else
  				{
! 					echo("-&nbsp;");
  				};
  				echo("<A HREF=\"javascript:window.parent.userClick('".special_char2($OtherUser,$Latin1)."',false);\" CLASS=\"user\">".special_char($OtherUser,$Latin1,$status)."</A><BR>\n");
--- 136,188 ----
  	while(list($Other) = $DbLink->next_record())
  	{
! 		if (C_DB_TYPE == 'mysql')
! 		{
! 			$otherRoomsQuery	= 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
! 								. 'FROM ' . C_USR_TBL . ' usr LEFT JOIN ' . C_REG_TBL . ' reg ON usr.username = reg.username '
! 								. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
! 								. 'ORDER BY usr.username';
! 		}
! 		else if (C_DB_TYPE == 'pgsql')
! 		{
! 			$otherRoomsQuery	= 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
! 								. 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
! 								. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
! 								. 'UNION '
! 								. 'SELECT usr.username, usr.latin1, usr.status, 0 '
! 								. 'FROM ' . C_USR_TBL . ' usr '
! 								. 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND usr.room = \'' . addslashes($Other) . '\' '
! 								. 'ORDER BY usr.username';
! 		}
! 		else
! 		{
! 			$otherRoomsQuery	= 'SELECT usr.username, usr.latin1, usr.status, 0 '
! 								. 'FROM ' . C_USR_TBL . ' usr '
! 								. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
! 								. 'ORDER BY usr.username';
! 		}
! 
! 		$OthersUsers->query($otherRoomsQuery);
  		if($OthersUsers->num_rows() > 0)
  		{
  			$notEmptyRooms[$Other] = 1;
  			echo("<A HREF=\"$From?Ver=L&L=$L&U=".urlencode(stripslashes($U))."$AddPwd2Link&R1=".urlencode($Other)."&T=1&D=$D&N=$N&E=".urlencode(stripslashes($R))."&EN=$T\" TARGET=\"_parent\">".htmlspecialchars($Other)."</A><SPAN CLASS=\"small\"><BDO dir=\"${textDirection}\"></BDO>&nbsp;(".$OthersUsers->num_rows().")</SPAN><BR>\n");
! 			while(list($OtherUser, $Latin1, $status, $gender) = $OthersUsers->next_record())
  			{
  				// Put an icon when there is a profile for the user
+ 				if($gender == 0)
+ 					$gender = 'undefined';
+ 				elseif($gender == 1)
+ 					$gender = 'boy';
+ 				elseif($gender == 2)
+ 					$gender = 'girl';
+ 				else
+ 					$gender = 'none';
  				if ($status != "u" && $status != "k" && $status != "d" && $status != "b")
  				{
! 					echo('<a href="#" onClick="window.parent.runCmd(\'WHOIS\',\''.special_char2($OtherUser,$Latin1).'\'); return false;" class="user"><img src="images/gender_'.$gender.'.gif" width="14" height="14" border="0" alt="'.L_PROFILE.'"></a>&nbsp;');
  				}
  				else
  				{
! 					echo('<img src="images/gender_none.gif" width="14" height="14" border="0" alt="' . L_NO_PROFILE . '">&nbsp;');
  				};
  				echo("<A HREF=\"javascript:window.parent.userClick('".special_char2($OtherUser,$Latin1)."',false);\" CLASS=\"user\">".special_char($OtherUser,$Latin1,$status)."</A><BR>\n");
***************
*** 139,143 ****
  	if (strcasecmp($tmpRoom, stripslashes($R)) != 0 && (!isset($notEmptyRooms) || !isset($notEmptyRooms[$tmpRoom])))
  	{
! 		echo("<A HREF=\"$From?Ver=L&L=$L&U=".urlencode(stripslashes($U))."$AddPwd2Link&R0=".urlencode($tmpRoom)."&T=1&D=$D&N=$N&E=".urlencode(stripslashes($R))."&EN=$T\" TARGET=\"_parent\">".htmlspecialchars($Other)."</A><SPAN CLASS=\"small\"><BDO dir=\"${textDirection}\"></BDO>&nbsp;(0)</SPAN><BR>\n");
      };
  };
--- 205,209 ----
  	if (strcasecmp($tmpRoom, stripslashes($R)) != 0 && (!isset($notEmptyRooms) || !isset($notEmptyRooms[$tmpRoom])))
  	{
! 		echo("<A HREF=\"$From?Ver=L&L=$L&U=".urlencode(stripslashes($U))."$AddPwd2Link&R0=".urlencode($tmpRoom)."&T=1&D=$D&N=$N&E=".urlencode(stripslashes($R))."&EN=$T\" TARGET=\"_parent\">".htmlspecialchars($tmpRoom)."</A><SPAN CLASS=\"small\"><BDO dir=\"${textDirection}\"></BDO>&nbsp;(0)</SPAN><BR>\n");
      };
  };

Index: usersH.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/usersH.php3,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** usersH.php3	2001/03/29 19:05:29	1.9
--- usersH.php3	2001/04/11 21:04:46	1.10
***************
*** 85,90 ****
  }
  
- $ImgNum = "0";
- 
  $DbLink = new DB;
  
--- 85,88 ----
***************
*** 132,142 ****
  	if ($status != "u" && $status != "k" && $status != "d" && $status != "b")
  	{
- 		$ImgNum++;
  		$Cmd2Send = ($User == stripslashes($U) ? "'PROFILE',''" : "'WHOIS','".special_char2($User,$Latin1)."'");
! 		echo('<a href="#" onClick="window.parent.runCmd('.$Cmd2Send.'); return false;" class="user"><img name="whoisImg'.$ImgNum.'" src="images/gender_'.$gender.'.gif" width="14" height="14" border="0" alt="'.L_PROFILE.'"></a>&nbsp;');
  	}
  	else
  	{
! 		echo('<img name="whoisImg'.$ImgNum.'" src="images/gender_none.gif" width="14" height="14" border="0" alt="Pas de profil">&nbsp;');
  	}
  	if($User != stripslashes($U))
--- 130,139 ----
  	if ($status != "u" && $status != "k" && $status != "d" && $status != "b")
  	{
  		$Cmd2Send = ($User == stripslashes($U) ? "'PROFILE',''" : "'WHOIS','".special_char2($User,$Latin1)."'");
! 		echo('<a href="#" onClick="window.parent.runCmd('.$Cmd2Send.'); return false;" class="user"><img src="images/gender_'.$gender.'.gif" width="14" height="14" border="0" alt="'.L_PROFILE.'"></a>&nbsp;');
  	}
  	else
  	{
! 		echo('<img src="images/gender_none.gif" width="14" height="14" border="0" alt="' . L_NO_PROFILE . '">&nbsp;');
  	}
  	if($User != stripslashes($U))
***************
*** 215,224 ****
  				if ($status != "u" && $status != "k" && $status != "d" && $status != "b")
  				{
! 					$ImgNum++;
! 					echo('<a href="#" onClick="window.parent.runCmd(\'WHOIS\',\''.special_char2($OtherUser,$Latin1).'\'); return false;" class="user"><img name="whoisImg'.$ImgNum.'" src="images/gender_'.$gender.'.gif" width="14" height="14" border="0" alt="'.L_PROFILE.'"></a>&nbsp;');
  				}
  				else
  				{
! 					echo('<img name="whoisImg'.$ImgNum.'" src="images/gender_none.gif" width="14" height="14" border="0" alt="Pas de profil">&nbsp;');
  				}
  				echo("<A HREF=\"javascript:window.parent.userClick('".special_char2($OtherUser,$Latin1)."',false);\" CLASS=\"user\">".special_char($OtherUser,$Latin1,$status)."</A><BR>\n");
--- 212,220 ----
  				if ($status != "u" && $status != "k" && $status != "d" && $status != "b")
  				{
! 					echo('<a href="#" onClick="window.parent.runCmd(\'WHOIS\',\''.special_char2($OtherUser,$Latin1).'\'); return false;" class="user"><img src="images/gender_'.$gender.'.gif" width="14" height="14" border="0" alt="'.L_PROFILE.'"></a>&nbsp;');
  				}
  				else
  				{
! 					echo('<img src="images/gender_none.gif" width="14" height="14" border="0" alt="' . L_NO_PROFILE . '">&nbsp;');
  				}
  				echo("<A HREF=\"javascript:window.parent.userClick('".special_char2($OtherUser,$Latin1)."',false);\" CLASS=\"user\">".special_char($OtherUser,$Latin1,$status)."</A><BR>\n");

[phpMyChat CVS] CVS: phpMyChat - 0.14/chat usersL.php3,1.3,1.4 usersH.php3,1.9,1.10

Standalone chat system developed in php, mysql and javascript

[phpMyChat CVS] CVS: phpMyChat - 0.14/chat usersL.php3,1.3,1.4 usersH.php3,1.9,1.10