|
From: Lo?c C. <lo...@us...> - 2001-04-21 19:37:42
|
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 . ', '
|