[phpMyChat CVS] CVS: phpMyChat-0.15/chat profile_reg.php3,1.9,1.10 input.php3,1.23,1.24 handle_input.php3,1.19,1.20

[Lo?c C. <lo...@us...>]

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

Modified Files:
	profile_reg.php3 input.php3 handle_input.php3 
Log Message:
Some SQL queries has been rewriten in order to avois errors with customized tables

Index: profile_reg.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/profile_reg.php3,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** profile_reg.php3	2001/04/19 20:25:35	1.9
--- profile_reg.php3	2001/04/21 19:37:40	1.10
***************
*** 203,208 ****
  			// password to the sessions data
  			if (empty($error))
! 			{			
! 				$dbLink->query("INSERT INTO " . C_REG_TBL . " VALUES ('$slashedNick', '$latin1', '$pwdHash', '" . pmcSlashSingleQuotes($firstName) . "', '" . pmcSlashSingleQuotes($lastName) . "', '" . pmcSlashSingleQuotes($spokenLang) . "', '$webSite', '$email', $showEmail, 'user', '', " . time() . ", '$ip', '$gender')");
  				$message					= L_REG_9;
  				$isRegDone					= true;
--- 203,213 ----
  			// password to the sessions data
  			if (empty($error))
! 			{
! 				$regQuery	= 'INSERT INTO ' . C_REG_TBL . ' '
! 							. '(username, latin1, password, firstname, lastname, country, website, email, showemail, perms, rooms, reg_time, ip, gender) '
! 							. 'VALUES ('
! 							. "'$slashedNick', '$latin1', '$pwdHash', '" . pmcSlashSingleQuotes($firstName) . "', '" . pmcSlashSingleQuotes($lastName) . "', '" . pmcSlashSingleQuotes($spokenLang) . "', '$webSite', '$email', $showEmail, 'user', '', " . time() . ", '$ip', '$gender'"
! 							. ')';
! 				$dbLink->query($regQuery);
  				$message					= L_REG_9;
  				$isRegDone					= true;

Index: input.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/input.php3,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -r1.23 -r1.24
*** input.php3	2001/04/21 09:43:59	1.23
--- input.php3	2001/04/21 19:37:40	1.24
***************
*** 151,154 ****
--- 151,155 ----
  
  		$msgQuery	= 'INSERT INTO ' . C_MSG_TBL . ' '
+ 					. '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
  					. 'VALUES ('
  						. $currentRoomType . ', '

Index: handle_input.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/handle_input.php3,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -r1.19 -r1.20
*** handle_input.php3	2001/04/21 09:43:59	1.19
--- handle_input.php3	2001/04/21 19:37:40	1.20
***************
*** 150,153 ****
--- 150,154 ----
  
  		$msgQuery	= 'INSERT INTO ' . C_MSG_TBL . ' '
+ 					. '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
  					. 'VALUES ('
  						. $currentRoomType . ', '