Menu
▾
▴
phpmychat-cvs-commited — All the commits of the cvs code repository are posted to this list automatically
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
(51) |
Apr
(688) |
May
(260) |
Jun
(108) |
Jul
(42) |
Aug
|
Sep
(2) |
Oct
|
Nov
(74) |
Dec
(217) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
(4) |
May
(3) |
Jun
(6) |
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2005 |
Jan
|
Feb
(8) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
|
From: Lo?c C. <lo...@us...> - 2001-04-23 18:28:30
|
Update of /cvsroot/phpmychat/phpMyChat - 0.14/chat
In directory usw-pr-cvs1:/tmp/cvs-serv19232/chat
Modified Files:
messagesL.php3
Log Message:
Optimized a little bit
***** Bogus filespec: -
***** Bogus filespec: 0.14/chat
Index: messagesL.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/messagesL.php3,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** messagesL.php3 2001/03/23 18:44:46 1.3
--- messagesL.php3 2001/04/23 18:28:28 1.4
***************
*** 161,164 ****
--- 161,165 ----
{
$i = "1";
+ $today = date('j', time() + C_TMZ_OFFSET*60*60);
$MessagesString = "";
while(list($Time, $User, $Latin1, $Dest, $Message) = $DbLink->next_record())
***************
*** 194,198 ****
// Separator between messages sent before today and other ones
! if (!isset($day_separator) && date("j", $Time + C_TMZ_OFFSET*60*60) != date("j", time() + C_TMZ_OFFSET*60*60))
{
$day_separator = "<P CLASS=\"msg\"><SPAN CLASS=\"notify\">--------- ".($O == 0 ? L_TODAY_UP : L_TODAY_DWN)." ---------</SPAN></P>";
--- 195,199 ----
// Separator between messages sent before today and other ones
! if (!isset($day_separator) && date("j", $Time + C_TMZ_OFFSET*60*60) != $today)
{
$day_separator = "<P CLASS=\"msg\"><SPAN CLASS=\"notify\">--------- ".($O == 0 ? L_TODAY_UP : L_TODAY_DWN)." ---------</SPAN></P>";
|
|
From: Lo?c C. <lo...@us...> - 2001-04-23 18:22:17
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/index_libs
In directory usw-pr-cvs1:/tmp/cvs-serv17381/chat/lib/index_libs
Modified Files:
main_index.lib.php3
Log Message:
Improved for js disabled browsers
Index: main_index.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/index_libs/main_index.lib.php3,v
retrieving revision 1.21
retrieving revision 1.22
diff -C2 -r1.21 -r1.22
*** main_index.lib.php3 2001/04/21 19:37:40 1.21
--- main_index.lib.php3 2001/04/23 18:22:14 1.22
***************
*** 607,611 ****
echo("\t" . dbSessionSID('POST'));
?>
! <input type="hidden" name="jsVersion" value="low" />
<input type="hidden" name="isJsValidated" value="0" />
--- 607,611 ----
echo("\t" . dbSessionSID('POST'));
?>
! <input type="hidden" name="jsVersion" value="noJs" />
<input type="hidden" name="isJsValidated" value="0" />
|
|
From: Lo?c C. <lo...@us...> - 2001-04-23 18:22:17
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat
In directory usw-pr-cvs1:/tmp/cvs-serv17381/chat
Modified Files:
input.php3
Log Message:
Improved for js disabled browsers
Index: input.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/input.php3,v
retrieving revision 1.24
retrieving revision 1.25
diff -C2 -r1.24 -r1.25
*** input.php3 2001/04/21 19:37:40 1.24
--- input.php3 2001/04/23 18:22:14 1.25
***************
*** 250,258 ****
// Get the value to put in the message box :
// - previous message value for '/!' command;
! // - last submission if it was an erroneous command;
// - else nothing.
$msgValue = ($displayMessage) ? pmcSlashDoubleQuotes($prevMessage) : '';
! if (isset($error) && !($isCommand))
! $msgValue = pmcSlashDoubleQuotes($message);
?>
<!-- Message box -->
--- 250,273 ----
// Get the value to put in the message box :
// - previous message value for '/!' command;
! // - last submission if it was an erroneous command (prefixed by the error
! // message if the browser does not know JavaScript);
! // - a success message if a command defined one and the browser does not know
! // JavaScript (this message is also set in the $error variable);
! // message if the bowser does not know JavaScript);
// - else nothing.
$msgValue = ($displayMessage) ? pmcSlashDoubleQuotes($prevMessage) : '';
! if (isset($error))
! {
! if (!$isCommand)
! {
! $msgValue = ($dbSessionVars['jsVersion'] == 'noJs')
! ? '< ' . $error . ' > ' . pmcSlashDoubleQuotes($message)
! : pmcSlashDoubleQuotes($message);
! }
! else if ($dbSessionVars['jsVersion'] == 'noJs')
! {
! $msgValue = $error;
! }
! }
?>
<!-- Message box -->
***************
*** 262,266 ****
<?php
// Color of the message
! if ($dbSessionVars['jsVersion'] == 'low')
{
// Drop down list of colors for non-enabled JavaScript1.1+ browsers
--- 277,281 ----
<?php
// Color of the message
! if ($dbSessionVars['jsVersion'] == 'low' || $dbSessionVars['jsVersion'] == 'noJs')
{
// Drop down list of colors for non-enabled JavaScript1.1+ browsers
***************
*** 290,294 ****
<?php
// Define the colors picker for JavaScript1.1+ enabled browsers
! if ($dbSessionVars['jsVersion'] != 'low')
{
?>
--- 305,309 ----
<?php
// Define the colors picker for JavaScript1.1+ enabled browsers
! if ($dbSessionVars['jsVersion'] != 'low' && $dbSessionVars['jsVersion'] != 'noJs')
{
?>
***************
*** 323,326 ****
--- 338,356 ----
<?php
+ /**
+ * Stop parsing the script if the browser do not support javascript
+ */
+ if ($dbSessionVars['jsVersion'] == 'noJs')
+ {
+ ?>
+ </body>
+
+ </html>
+ <?php
+ flush();
+ exit();
+ }
+ echo("\n");
+
/**
* Refresh the messages frame if necessary
|
|
From: Lo?c C. <lo...@us...> - 2001-04-23 18:21:17
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat
In directory usw-pr-cvs1:/tmp/cvs-serv17108/chat
Modified Files:
users_low.php3 users.php3
Log Message:
Optimized a little bit
Index: users_low.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/users_low.php3,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -r1.14 -r1.15
*** users_low.php3 2001/04/22 18:43:55 1.14
--- users_low.php3 2001/04/23 18:21:14 1.15
***************
*** 150,159 ****
/**
* Get the users'list
*/
if (C_DB_TYPE == 'mysql')
{
$usersQuery = 'SELECT usr.room, usr.username, usr.latin1, usr.status, reg.gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg LEFT JOIN ' . C_REG_TBL . ' reg ON usr.username = reg.username '
! . 'WHERE usr.room = \'' . $slashedCurrentRoomName . '\' OR (usr.room = msg.room AND msg.type = 1) '
. 'GROUP BY room, username';
}
--- 150,166 ----
/**
* Get the users'list
+ *
+ * Check all the public rooms and possibly the private room the user is
+ * chatting into. The query depends on the database software because of
+ * the left outer join it requires.
*/
+ $roomsToCheck = ($dbSessionVars['roomType'] == 0)
+ ? 'usr.room = \'' . $slashedCurrentRoomName . '\' OR (usr.room = msg.room AND msg.type = 1)'
+ : 'usr.room = msg.room AND msg.type = 1';
if (C_DB_TYPE == 'mysql')
{
$usersQuery = 'SELECT usr.room, usr.username, usr.latin1, usr.status, reg.gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg LEFT JOIN ' . C_REG_TBL . ' reg ON usr.username = reg.username '
! . 'WHERE ' . $roomsToCheck . ' '
. 'GROUP BY room, username';
}
***************
*** 163,167 ****
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg, ' . C_REG_TBL . ' reg '
. 'WHERE usr.username = reg.username (+) '
! . 'AND (usr.room = \'' . $slashedCurrentRoomName . '\' OR (usr.room = msg.room AND msg.type = 1)) '
. 'GROUP BY room, username';
}
--- 170,174 ----
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg, ' . C_REG_TBL . ' reg '
. 'WHERE usr.username = reg.username (+) '
! . 'AND (' . $roomsToCheck . ') '
. 'GROUP BY room, username';
}
***************
*** 170,178 ****
$usersQuery = 'SELECT usr.room, usr.username, usr.latin1, usr.status, reg.gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg, ' . C_REG_TBL . ' reg '
! . 'WHERE usr.room = \'' . $slashedCurrentRoomName . '\' OR (usr.room = msg.room AND msg.type = 1) '
. 'UNION '
. 'SELECT usr.room, usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg '
! . 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND (usr.room = \'' . $slashedCurrentRoomName . '\' OR (usr.room = msg.room AND msg.type = 1)) '
. 'GROUP BY room, username';
}
--- 177,185 ----
$usersQuery = 'SELECT usr.room, usr.username, usr.latin1, usr.status, reg.gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg, ' . C_REG_TBL . ' reg '
! . 'WHERE ' . $roomsToCheck . ' '
. 'UNION '
. 'SELECT usr.room, usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg '
! . 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND (' . $roomsToCheck . ') '
. 'GROUP BY room, username';
}
***************
*** 181,185 ****
$usersQuery = 'SELECT usr.room, usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg '
! . 'WHERE usr.room = \'' . $slashedCurrentRoomName . '\' OR (usr.room = msg.room AND msg.type = 1) '
. 'GROUP BY room, username';
}
--- 188,192 ----
$usersQuery = 'SELECT usr.room, usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg '
! . 'WHERE ' . $roomsToCheck . ' '
. 'GROUP BY room, username';
}
Index: users.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/users.php3,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -r1.19 -r1.20
*** users.php3 2001/04/22 18:43:55 1.19
--- users.php3 2001/04/23 18:21:14 1.20
***************
*** 149,158 ****
/**
* Get the users'list
*/
if (C_DB_TYPE == 'mysql')
{
$usersQuery = 'SELECT usr.room, usr.username, usr.latin1, usr.status, reg.gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg LEFT JOIN ' . C_REG_TBL . ' reg ON usr.username = reg.username '
! . 'WHERE usr.room = \'' . $slashedCurrentRoomName . '\' OR (usr.room = msg.room AND msg.type = 1) '
. 'GROUP BY room, username';
}
--- 149,165 ----
/**
* Get the users'list
+ *
+ * Check all the public rooms and possibly the private room the user is
+ * chatting into. The query depends on the database software because of
+ * the left outer join it requires.
*/
+ $roomsToCheck = ($dbSessionVars['roomType'] == 0)
+ ? 'usr.room = \'' . $slashedCurrentRoomName . '\' OR (usr.room = msg.room AND msg.type = 1)'
+ : 'usr.room = msg.room AND msg.type = 1';
if (C_DB_TYPE == 'mysql')
{
$usersQuery = 'SELECT usr.room, usr.username, usr.latin1, usr.status, reg.gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg LEFT JOIN ' . C_REG_TBL . ' reg ON usr.username = reg.username '
! . 'WHERE ' . $roomsToCheck . ' '
. 'GROUP BY room, username';
}
***************
*** 162,166 ****
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg, ' . C_REG_TBL . ' reg '
. 'WHERE usr.username = reg.username (+) '
! . 'AND (usr.room = \'' . $slashedCurrentRoomName . '\' OR (usr.room = msg.room AND msg.type = 1)) '
. 'GROUP BY room, username';
}
--- 169,173 ----
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg, ' . C_REG_TBL . ' reg '
. 'WHERE usr.username = reg.username (+) '
! . 'AND (' . $roomsToCheck . ') '
. 'GROUP BY room, username';
}
***************
*** 169,177 ****
$usersQuery = 'SELECT usr.room, usr.username, usr.latin1, usr.status, reg.gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg, ' . C_REG_TBL . ' reg '
! . 'WHERE usr.room = \'' . $slashedCurrentRoomName . '\' OR (usr.room = msg.room AND msg.type = 1) '
. 'UNION '
. 'SELECT usr.room, usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg '
! . 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND (usr.room = \'' . $slashedCurrentRoomName . '\' OR (usr.room = msg.room AND msg.type = 1)) '
. 'GROUP BY room, username';
}
--- 176,184 ----
$usersQuery = 'SELECT usr.room, usr.username, usr.latin1, usr.status, reg.gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg, ' . C_REG_TBL . ' reg '
! . 'WHERE ' . $roomsToCheck . ' '
. 'UNION '
. 'SELECT usr.room, usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg '
! . 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND (' . $roomsToCheck . ') '
. 'GROUP BY room, username';
}
***************
*** 180,184 ****
$usersQuery = 'SELECT usr.room, usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg '
! . 'WHERE usr.room = \'' . $slashedCurrentRoomName . '\' OR (usr.room = msg.room AND msg.type = 1) '
. 'GROUP BY room, username';
}
--- 187,191 ----
$usersQuery = 'SELECT usr.room, usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg '
! . 'WHERE ' . $roomsToCheck . ' '
. 'GROUP BY room, username';
}
|
|
From: Lo?c C. <lo...@us...> - 2001-04-23 18:20:55
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat
In directory usw-pr-cvs1:/tmp/cvs-serv16998/chat
Modified Files:
messages_low.php3
Log Message:
Optimized a little bit
Index: messages_low.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/messages_low.php3,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -r1.13 -r1.14
*** messages_low.php3 2001/04/22 19:49:05 1.13
--- messages_low.php3 2001/04/23 18:20:53 1.14
***************
*** 156,159 ****
--- 156,160 ----
else
{
+ $today = date('j', time());
reset($grabedMessages);
for ($k = 0; $k < $grabedMessagesCnt; $k++)
***************
*** 172,176 ****
// Separator between messages sent before today and other ones
if (!isset($daySeparator)
! && date('j', $sentTime) != date('j', time()))
{
$daySeparatorMsg = ($dbSessionVars['msgOrder'] == 0) ? L_TODAY_UP : L_TODAY_DWN;
--- 173,177 ----
// Separator between messages sent before today and other ones
if (!isset($daySeparator)
! && date('j', $sentTime) != $today)
{
$daySeparatorMsg = ($dbSessionVars['msgOrder'] == 0) ? L_TODAY_UP : L_TODAY_DWN;
***************
*** 192,198 ****
$sender = '<a href="#" onclick="window.parent.pmcUserClick(\'' . $slashedSender . '\', true); return false" class="sender">' . $simpleSender . '</a>';
if ($addressee != '')
- {
$addressee = ']<bdo dir="' . $textDirection . '"></bdo>>[' . htmlspecialchars($addressee);
- }
$aMessage .= '<b>[' . $sender . $addressee . ']<bdo dir="' . $textDirection .'"></bdo></b> '
. '<font color="' . $msgColor . '">' . $message . '</font>';
--- 193,197 ----
***************
*** 209,215 ****
{
if ($addressee != '')
- {
$aMessage .= '<b>>[' . htmlspecialchars($addressee) . ']<bdo dir="' . $textDirection . '"></bdo></b> ';
- }
if (strpos($message, 'printf('))
{
--- 208,212 ----
|
|
From: Lo?c C. <lo...@us...> - 2001-04-23 18:20:31
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat
In directory usw-pr-cvs1:/tmp/cvs-serv16886/chat
Modified Files:
loader.php3
Log Message:
Fixed a bad js syntax a optimized a little bit
Index: loader.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/loader.php3,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -r1.14 -r1.15
*** loader.php3 2001/04/20 17:04:23 1.14
--- loader.php3 2001/04/23 18:20:28 1.15
***************
*** 210,213 ****
--- 210,214 ----
else
{
+ $today = date('j', time());
reset($grabedMessages);
for ($k = 0; $k < $grabedMessagesCnt; $k++)
***************
*** 226,230 ****
// Separator between messages sent before today and other ones
if (!isset($daySeparator)
! && date('j', $sentTime) != date('j', time()))
{
$newMessages[] = '<p class="msg"><span class="notify">--------- ' . L_TODAY_DWN . ' ---------<\/span><\/p>';
--- 227,231 ----
// Separator between messages sent before today and other ones
if (!isset($daySeparator)
! && date('j', $sentTime) != $today)
{
$newMessages[] = '<p class="msg"><span class="notify">--------- ' . L_TODAY_DWN . ' ---------<\/span><\/p>';
***************
*** 381,390 ****
// Scrolls to the bottom of the message frame
! if (typeof(scrollBy(0, 0)) != 'undefined')
{
scrollBy(0, 65000);
scrollBy(0, 65000);
}
! else if (typeof(scroll(0, 0)) != 'undefined')
{
scroll(0, 65000);
--- 382,391 ----
// Scrolls to the bottom of the message frame
! if (typeof(scrollBy) != 'undefined')
{
scrollBy(0, 65000);
scrollBy(0, 65000);
}
! else if (typeof(scroll) != 'undefined')
{
scroll(0, 65000);
|
|
From: Lo?c C. <lo...@us...> - 2001-04-22 20:21:08
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib
In directory usw-pr-cvs1:/tmp/cvs-serv4040/chat/lib
Modified Files:
check_and_kick_user.lib.php3
Log Message:
Forget to user the session data 'sataus' to update the users table
Index: check_and_kick_user.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/check_and_kick_user.lib.php3,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -r1.12 -r1.13
*** check_and_kick_user.lib.php3 2001/04/21 19:37:40 1.12
--- check_and_kick_user.lib.php3 2001/04/22 20:21:06 1.13
***************
*** 111,115 ****
. '(session_id, u_time, room, username, latin1, status, ip) '
. 'VALUES ('
! . "'$dbSessionId', " . time() . ", '$slashedCurrentRoomName', '$slashedNick', '$latin1', '$status', '$ip'"
. ')';
$checkLink->query($usrQuery);
--- 111,115 ----
. '(session_id, u_time, room, username, latin1, status, ip) '
. 'VALUES ('
! . "'$dbSessionId', " . time() . ", '$slashedCurrentRoomName', '$slashedNick', '$latin1', '" . $dbSessionVars['status'] . "', '$ip'"
. ')';
$checkLink->query($usrQuery);
|
|
From: Lo?c C. <lo...@us...> - 2001-04-22 20:20:12
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/index_libs
In directory usw-pr-cvs1:/tmp/cvs-serv3745/chat/lib/index_libs
Modified Files:
msg_colors.lib.js
Log Message:
There was a bad reference
Index: msg_colors.lib.js
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/index_libs/msg_colors.lib.js,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** msg_colors.lib.js 2001/04/21 09:45:36 1.1
--- msg_colors.lib.js 2001/04/22 20:19:43 1.2
***************
*** 106,112 ****
function pmcChangeColor(colorVal, colorRank)
{
if (jsSelectedColor != colorRank)
{
- var inputDoc = window.frames['input'].window.document;
// DOM enabled browser
if (typeof(document.getElementById) != 'undefined')
--- 106,112 ----
function pmcChangeColor(colorVal, colorRank)
{
+ var inputDoc = window.frames['input'].window.document;
if (jsSelectedColor != colorRank)
{
// DOM enabled browser
if (typeof(document.getElementById) != 'undefined')
|
|
From: Lo?c C. <lo...@us...> - 2001-04-22 19:49:07
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat
In directory usw-pr-cvs1:/tmp/cvs-serv31708/chat
Modified Files:
messages_low.php3
Log Message:
Fix a php3 bug with imbricated if...else
Index: messages_low.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/messages_low.php3,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -r1.12 -r1.13
*** messages_low.php3 2001/04/19 21:05:04 1.12
--- messages_low.php3 2001/04/22 19:49:05 1.13
***************
*** 192,196 ****
--- 192,198 ----
$sender = '<a href="#" onclick="window.parent.pmcUserClick(\'' . $slashedSender . '\', true); return false" class="sender">' . $simpleSender . '</a>';
if ($addressee != '')
+ {
$addressee = ']<bdo dir="' . $textDirection . '"></bdo>>[' . htmlspecialchars($addressee);
+ }
$aMessage .= '<b>[' . $sender . $addressee . ']<bdo dir="' . $textDirection .'"></bdo></b> '
. '<font color="' . $msgColor . '">' . $message . '</font>';
***************
*** 207,215 ****
--- 209,223 ----
{
if ($addressee != '')
+ {
$aMessage .= '<b>>[' . htmlspecialchars($addressee) . ']<bdo dir="' . $textDirection . '"></bdo></b> ';
+ }
if (strpos($message, 'printf('))
+ {
eval('$aMessage .= ' . $message . ';');
+ }
else
+ {
$aMessage .= $message;
+ }
}
$aMessage .= '</span>';
|
|
From: Lo?c C. <lo...@us...> - 2001-04-22 18:46:26
|
Update of /cvsroot/phpmychat/phpMyChat - 0.14/chat/lib
In directory usw-pr-cvs1:/tmp/cvs-serv22652/lib
Modified Files:
release.lib.php3
Log Message:
Oups, the release number wasn't updated :o
***** Bogus filespec: -
***** Bogus filespec: 0.14/chat/lib
Index: release.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/lib/release.lib.php3,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** release.lib.php3 2001/03/23 18:46:08 1.3
--- release.lib.php3 2001/04/22 18:46:23 1.4
***************
*** 1,4 ****
<?php
define("APP_NAME", "phpMyChat"); // Application name
! define("APP_VERSION", "0.14.3 - dev"); // Application version number
?>
--- 1,4 ----
<?php
define("APP_NAME", "phpMyChat"); // Application name
! define("APP_VERSION", "0.14.3 - beta 1"); // Application version number
?>
|
|
From: Lo?c C. <lo...@us...> - 2001-04-22 11:29:44
|
Update of /cvsroot/phpmychat/phpMyChat - 0.14/chat/lib
In directory usw-pr-cvs1:/tmp/cvs-serv19598/chat/lib
Modified Files:
connected_users.lib.php3
Log Message:
Some SQL optimizations
***** Bogus filespec: -
***** Bogus filespec: 0.14/chat/lib
Index: connected_users.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/lib/connected_users.lib.php3,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -r1.1.1.1 -r1.2
*** connected_users.lib.php3 2001/02/25 18:27:35 1.1.1.1
--- connected_users.lib.php3 2001/04/22 11:29:40 1.2
***************
*** 14,18 ****
else
{
! $query = "SELECT DISTINCT u.username, u.latin1 FROM ".C_USR_TBL." u, ".C_MSG_TBL." m WHERE u.room = m.room AND m.type = 1 ORDER BY u.username";
}
--- 14,18 ----
else
{
! $query = "SELECT DISTINCT u.username, u.latin1 FROM ".C_USR_TBL." u, ".C_MSG_TBL." m WHERE u.room = m.room AND m.type = 1 ORDER BY username";
}
|
|
From: Lo?c C. <lo...@us...> - 2001-04-22 11:29:44
|
Update of /cvsroot/phpmychat/phpMyChat - 0.14/chat
In directory usw-pr-cvs1:/tmp/cvs-serv19598/chat
Modified Files:
usersL.php3 usersH.php3 users_popupL.php3 users_popupH.php3
Log Message:
Some SQL optimizations
***** Bogus filespec: -
***** Bogus filespec: 0.14/chat
Index: usersL.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/usersL.php3,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** usersL.php3 2001/04/21 14:51:23 1.5
--- usersL.php3 2001/04/22 11:29:40 1.6
***************
*** 70,74 ****
. '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')
--- 70,74 ----
. 'FROM ' . C_USR_TBL . ' usr LEFT JOIN ' . C_REG_TBL . ' reg ON usr.username = reg.username '
. 'WHERE usr.room = \'' . $R . '\' '
! . 'ORDER BY username';
}
else if (C_DB_TYPE == 'pgsql')
***************
*** 81,85 ****
. '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
--- 81,85 ----
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND usr.room = \'' . $R . '\' '
! . 'ORDER BY username';
}
else
***************
*** 88,92 ****
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . $R . '\' '
! . 'ORDER BY usr.username';
}
--- 88,92 ----
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . $R . '\' '
! . 'ORDER BY username';
}
***************
*** 141,145 ****
. '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')
--- 141,145 ----
. 'FROM ' . C_USR_TBL . ' usr LEFT JOIN ' . C_REG_TBL . ' reg ON usr.username = reg.username '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
! . 'ORDER BY username';
}
else if (C_DB_TYPE == 'pgsql')
***************
*** 152,156 ****
. '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
--- 152,156 ----
. '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 username';
}
else
***************
*** 159,163 ****
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
! . 'ORDER BY usr.username';
}
--- 159,163 ----
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
! . 'ORDER BY username';
}
Index: usersH.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/usersH.php3,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -r1.11 -r1.12
*** usersH.php3 2001/04/21 14:51:23 1.11
--- usersH.php3 2001/04/22 11:29:40 1.12
***************
*** 93,97 ****
. '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')
--- 93,97 ----
. 'FROM ' . C_USR_TBL . ' usr LEFT JOIN ' . C_REG_TBL . ' reg ON usr.username = reg.username '
. 'WHERE usr.room = \'' . $R . '\' '
! . 'ORDER BY username';
}
else if (C_DB_TYPE == 'pgsql')
***************
*** 104,108 ****
. '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
--- 104,108 ----
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND usr.room = \'' . $R . '\' '
! . 'ORDER BY username';
}
else
***************
*** 111,115 ****
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . $R . '\' '
! . 'ORDER BY usr.username';
}
--- 111,115 ----
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . $R . '\' '
! . 'ORDER BY username';
}
***************
*** 164,168 ****
. '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')
--- 164,168 ----
. 'FROM ' . C_USR_TBL . ' usr LEFT JOIN ' . C_REG_TBL . ' reg ON usr.username = reg.username '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
! . 'ORDER BY username';
}
else if (C_DB_TYPE == 'pgsql')
***************
*** 175,179 ****
. '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
--- 175,179 ----
. '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 username';
}
else
***************
*** 182,186 ****
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
! . 'ORDER BY usr.username';
}
--- 182,186 ----
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
! . 'ORDER BY username';
}
Index: users_popupL.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/users_popupL.php3,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** users_popupL.php3 2001/03/23 18:44:46 1.3
--- users_popupL.php3 2001/04/22 11:29:40 1.4
***************
*** 88,92 ****
{
// ** count users **
! $DbLink->query("SELECT DISTINCT u.username, u.latin1 FROM ".C_USR_TBL." u, ".C_MSG_TBL." m WHERE u.room = m.room AND m.type = 1 ORDER BY u.username");
$NbUsers = $DbLink->num_rows();
if($NbUsers > 3)
--- 88,92 ----
{
// ** count users **
! $DbLink->query("SELECT DISTINCT u.username, u.latin1 FROM ".C_USR_TBL." u, ".C_MSG_TBL." m WHERE u.room = m.room AND m.type = 1 ORDER BY username");
$NbUsers = $DbLink->num_rows();
if($NbUsers > 3)
Index: users_popupH.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/users_popupH.php3,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** users_popupH.php3 2001/03/23 18:44:46 1.3
--- users_popupH.php3 2001/04/22 11:29:40 1.4
***************
*** 88,92 ****
{
// ** count users **
! $DbLink->query("SELECT DISTINCT u.username, u.latin1 FROM ".C_USR_TBL." u, ".C_MSG_TBL." m WHERE u.room = m.room AND m.type = 1 ORDER BY u.username");
$NbUsers = $DbLink->num_rows();
if($NbUsers > 3)
--- 88,92 ----
{
// ** count users **
! $DbLink->query("SELECT DISTINCT u.username, u.latin1 FROM ".C_USR_TBL." u, ".C_MSG_TBL." m WHERE u.room = m.room AND m.type = 1 ORDER BY username");
$NbUsers = $DbLink->num_rows();
if($NbUsers > 3)
|
|
From: Lo?c C. <lo...@us...> - 2001-04-22 08:35:07
|
Update of /cvsroot/phpmychat/phpMyChat - 0.14/chat/lib/commands
In directory usw-pr-cvs1:/tmp/cvs-serv31070/chat/lib/commands
Modified Files:
join.cmd.php3
Log Message:
Fix a bug reported by Victor Lvov (uncle_au)
***** Bogus filespec: -
***** Bogus filespec: 0.14/chat/lib/commands
Index: join.cmd.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/lib/commands/join.cmd.php3,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** join.cmd.php3 2001/04/11 21:10:51 1.3
--- join.cmd.php3 2001/04/22 08:35:04 1.4
***************
*** 132,137 ****
else
{
- $DbLink->query("INSERT INTO ".C_MSG_TBL." VALUES ($T, '$R', 'SYS exit', '', ".time().", '', 'sprintf(L_EXIT_ROM, \"".special_char($U,$Latin1)."\")')");
- $DbLink->query("DELETE FROM ".C_USR_TBL." WHERE username='$U' AND room='$R'");
?>
<SCRIPT TYPE="text/javascript" LANGUAGE="JavaScript">
--- 132,135 ----
|
|
From: Lo?c C. <lo...@us...> - 2001-04-21 21:23:28
|
Update of /cvsroot/phpmychat/phpMyChat - 0.14/docs
In directory usw-pr-cvs1:/tmp/cvs-serv14583/docs
Modified Files:
changes.txt
Log Message:
Added a word for the bug report form
***** Bogus filespec: -
***** Bogus filespec: 0.14/docs
Index: changes.txt
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/docs/changes.txt,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** changes.txt 2001/04/21 20:44:08 1.5
--- changes.txt 2001/04/21 21:23:25 1.6
***************
*** 11,16 ****
"""""""""""""""""""""
- ENHANCEMENT : an important security fix has been merged into this release thanks to a
- contributor we don't know the name.
ENHANCEMENT : clicking on the connection status button (at the 'exit' frame) if it turns
to red now frees the submit button at the 'input' frame.
--- 11,14 ----
***************
*** 18,21 ****
--- 16,22 ----
icon.
ENHANCEMENT : some translations have been completed and Malay has been added.
+ ENHANCEMENT : a bug report form has been added in the 'docs' directory.
+ BUG FIXED : an important security fix has been merged into this release thanks to a
+ contributor we don't know the name.
BUG FIXED : overlapped chat name rooms with Netscape 4+.
BUG FIXED : the 'refresh' header is not a valid one according to RFC specifications:
|
|
From: Lo?c C. <lo...@us...> - 2001-04-21 20:44:12
|
Update of /cvsroot/phpmychat/phpMyChat - 0.14/docs
In directory usw-pr-cvs1:/tmp/cvs-serv8253
Modified Files:
changes.txt
Log Message:
Updated with the security fix
***** Bogus filespec: -
***** Bogus filespec: 0.14/docs
Index: changes.txt
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/docs/changes.txt,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** changes.txt 2001/04/16 13:45:38 1.4
--- changes.txt 2001/04/21 20:44:08 1.5
***************
*** 8,14 ****
! v 0.14.3 - 16/04/2001
"""""""""""""""""""""
ENHANCEMENT : clicking on the connection status button (at the 'exit' frame) if it turns
to red now frees the submit button at the 'input' frame.
--- 8,16 ----
! v 0.14.3 - 21/04/2001
"""""""""""""""""""""
+ ENHANCEMENT : an important security fix has been merged into this release thanks to a
+ contributor we don't know the name.
ENHANCEMENT : clicking on the connection status button (at the 'exit' frame) if it turns
to red now frees the submit button at the 'input' frame.
|
|
From: Lo?c C. <lo...@us...> - 2001-04-21 19:38:30
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat
In directory usw-pr-cvs1:/tmp/cvs-serv424/chat
Modified Files:
users_popup_low.php3 users_popup.php3
Log Message:
Optimize a bit the first SQL query
Index: users_popup_low.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/users_popup_low.php3,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -r1.11 -r1.12
*** users_popup_low.php3 2001/04/19 21:05:04 1.11
--- users_popup_low.php3 2001/04/21 19:38:28 1.12
***************
*** 90,95 ****
$dbLink = new pmcDB;
$roomQueryPart = (dbSessionIsRegistered('currentRoom') && $dbSessionVars['roomType'] == 0)
! ? '(m.type = 1 OR (m.type = 0 AND m.room =\'' . pmcSlashSingleQuotes($dbSessionVars['currentRoom']) . '\'))'
! : 'm.type = 1';
--- 90,95 ----
$dbLink = new pmcDB;
$roomQueryPart = (dbSessionIsRegistered('currentRoom') && $dbSessionVars['roomType'] == 0)
! ? '(type = 1 OR (type = 0 AND room =\'' . pmcSlashSingleQuotes($dbSessionVars['currentRoom']) . '\'))'
! : 'type = 1';
***************
*** 108,117 ****
if ($isBeep > 0)
{
! $beepQuery = 'SELECT m.m_time FROM ' . C_MSG_TBL . ' m '
. ' WHERE '
! . 'm.m_time > ' . $lastCheck . ' AND '
! . 'm.username = \'SYS enter\' AND '
. $roomQueryPart . ' '
! . 'ORDER BY m.m_time DESC '
. 'LIMIT 1';
$dbLink->query($beepQuery);
--- 108,117 ----
if ($isBeep > 0)
{
! $beepQuery = 'SELECT m_time FROM ' . C_MSG_TBL . ' '
. ' WHERE '
! . 'm_time > ' . $lastCheck . ' AND '
! . 'username = \'SYS enter\' AND '
. $roomQueryPart . ' '
! . 'ORDER BY m_time DESC '
. 'LIMIT 1';
$dbLink->query($beepQuery);
Index: users_popup.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/users_popup.php3,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -r1.12 -r1.13
*** users_popup.php3 2001/04/19 21:05:04 1.12
--- users_popup.php3 2001/04/21 19:38:28 1.13
***************
*** 89,94 ****
$dbLink = new pmcDB;
$roomQueryPart = (dbSessionIsRegistered('currentRoom') && $dbSessionVars['roomType'] == 0)
! ? '(m.type = 1 OR (m.type = 0 AND m.room =\'' . pmcSlashSingleQuotes($dbSessionVars['currentRoom']) . '\'))'
! : 'm.type = 1';
--- 89,94 ----
$dbLink = new pmcDB;
$roomQueryPart = (dbSessionIsRegistered('currentRoom') && $dbSessionVars['roomType'] == 0)
! ? '(type = 1 OR (type = 0 AND room =\'' . pmcSlashSingleQuotes($dbSessionVars['currentRoom']) . '\'))'
! : 'type = 1';
***************
*** 107,116 ****
if ($isBeep > 0)
{
! $beepQuery = 'SELECT m.m_time FROM ' . C_MSG_TBL . ' m '
. ' WHERE '
! . 'm.m_time > ' . $lastCheck . ' AND '
! . 'm.username = \'SYS enter\' AND '
. $roomQueryPart . ' '
! . 'ORDER BY m.m_time DESC '
. 'LIMIT 1';
$dbLink->query($beepQuery);
--- 107,116 ----
if ($isBeep > 0)
{
! $beepQuery = 'SELECT m_time FROM ' . C_MSG_TBL . ' '
. ' WHERE '
! . 'm_time > ' . $lastCheck . ' AND '
! . 'username = \'SYS enter\' AND '
. $roomQueryPart . ' '
! . 'ORDER BY m_time DESC '
. 'LIMIT 1';
$dbLink->query($beepQuery);
|
|
From: Lo?c C. <lo...@us...> - 2001-04-21 19:37:42
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib
In directory usw-pr-cvs1:/tmp/cvs-serv32717/chat/lib
Modified Files:
check_and_kick_user.lib.php3
Log Message:
Some SQL queries has been rewriten in order to avois errors with customized tables
Index: check_and_kick_user.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/check_and_kick_user.lib.php3,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -r1.11 -r1.12
*** check_and_kick_user.lib.php3 2001/04/19 20:26:53 1.11
--- check_and_kick_user.lib.php3 2001/04/21 19:37:40 1.12
***************
*** 108,112 ****
// Gets the IP address
include('./lib/get_ip.lib.' . C_EXTENSION);
! $checkLink->query("INSERT INTO " . C_USR_TBL . " VALUES ('$dbSessionId', " . time() . ", '$slashedCurrentRoomName', '$slashedNick', '$latin1', '$status', '$ip')");
} // end of the case where user should be in users table
--- 108,117 ----
// Gets the IP address
include('./lib/get_ip.lib.' . C_EXTENSION);
! $usrQuery = 'INSERT INTO ' . C_USR_TBL . ' '
! . '(session_id, u_time, room, username, latin1, status, ip) '
! . 'VALUES ('
! . "'$dbSessionId', " . time() . ", '$slashedCurrentRoomName', '$slashedNick', '$latin1', '$status', '$ip'"
! . ')';
! $checkLink->query($usrQuery);
} // end of the case where user should be in users table
|
|
From: Lo?c C. <lo...@us...> - 2001-04-21 19:37:42
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands
In directory usw-pr-cvs1:/tmp/cvs-serv32717/chat/lib/commands
Modified Files:
quit.cmd.php3 promote.cmd.php3 priv_msg.cmd.php3 me.cmd.php3
invite.cmd.php3 announce.cmd.php3
Log Message:
Some SQL queries has been rewriten in order to avois errors with customized tables
Index: quit.cmd.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands/quit.cmd.php3,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** quit.cmd.php3 2001/04/19 21:05:04 1.4
--- quit.cmd.php3 2001/04/21 19:37:39 1.5
***************
*** 45,48 ****
--- 45,49 ----
$msgQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
+ . '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
. 'VALUES ('
. $currentRoomType . ', '
Index: promote.cmd.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands/promote.cmd.php3,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** promote.cmd.php3 2001/04/19 21:05:04 1.4
--- promote.cmd.php3 2001/04/21 19:37:39 1.5
***************
*** 77,81 ****
$dbLink->query("UPDATE " . C_REG_TBL . " SET perms = 'moderator', rooms = '$slashedModeratedRooms' WHERE username = '$slashedTarget'");
$dbLink->query("UPDATE " . C_USR_TBL . " SET status = 'm' WHERE username = '$slashedTarget'");
! $dbLink->query("INSERT INTO " . C_MSG_TBL . " VALUES ($currentRoomType, '$slashedCurrentRoomName', 'SYS promote', $latin1, " . time() . ", NULL, '#666699', 'sprintf(L_MODERATOR, \'$targetForNotifications\')', 'sprintf(L_MODERATOR, \'$targetForNotifications\')')");
}
else
--- 77,86 ----
$dbLink->query("UPDATE " . C_REG_TBL . " SET perms = 'moderator', rooms = '$slashedModeratedRooms' WHERE username = '$slashedTarget'");
$dbLink->query("UPDATE " . C_USR_TBL . " SET status = 'm' WHERE username = '$slashedTarget'");
! $msgQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
! . '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
! . 'VALUES ('
! . "$currentRoomType, '$slashedCurrentRoomName', 'SYS promote', $latin1, " . time() . ", NULL, '#666699', 'sprintf(L_MODERATOR, \'$targetForNotifications\')', 'sprintf(L_MODERATOR, \'$targetForNotifications\')'"
! . ')';
! $dbLink->query($msgQuery);
}
else
Index: priv_msg.cmd.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands/priv_msg.cmd.php3,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** priv_msg.cmd.php3 2001/04/19 21:05:04 1.3
--- priv_msg.cmd.php3 2001/04/21 19:37:39 1.4
***************
*** 57,60 ****
--- 57,61 ----
// Put the message in the 'messages' table
$msgQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
+ . '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
. 'VALUES ('
. $currentRoomType . ', '
Index: me.cmd.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands/me.cmd.php3,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** me.cmd.php3 2001/04/19 21:05:04 1.5
--- me.cmd.php3 2001/04/21 19:37:39 1.6
***************
*** 43,46 ****
--- 43,47 ----
// Put the message in the 'messages' table
$msgQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
+ . '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
. 'VALUES ('
. $currentRoomType . ', '
Index: invite.cmd.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands/invite.cmd.php3,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -r1.6 -r1.7
*** invite.cmd.php3 2001/04/19 20:23:36 1.6
--- invite.cmd.php3 2001/04/21 19:37:39 1.7
***************
*** 56,59 ****
--- 56,60 ----
$invitedQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
+ . '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
. 'VALUES ('
. $currentRoomType . ', '
Index: announce.cmd.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands/announce.cmd.php3,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -r1.6 -r1.7
*** announce.cmd.php3 2001/04/19 21:05:04 1.6
--- announce.cmd.php3 2001/04/21 19:37:39 1.7
***************
*** 26,30 ****
/**
! * The current user is adminsitrator -> insert the message in the 'messages'
* table
*/
--- 26,30 ----
/**
! * The current user is administrator -> insert the message in the 'messages'
* table
*/
***************
*** 43,46 ****
--- 43,47 ----
// Put the message in the 'messages' table
$msgQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
+ . '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
. 'VALUES ('
. $currentRoomType . ', '
|
|
From: Lo?c C. <lo...@us...> - 2001-04-21 19:37:42
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/index_libs
In directory usw-pr-cvs1:/tmp/cvs-serv32717/chat/lib/index_libs
Modified Files:
main_index.lib.php3 do_enter_db_work.lib.php3
Log Message:
Some SQL queries has been rewriten in order to avois errors with customized tables
Index: main_index.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/index_libs/main_index.lib.php3,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -r1.20 -r1.21
*** main_index.lib.php3 2001/04/20 19:55:47 1.20
--- main_index.lib.php3 2001/04/21 19:37:40 1.21
***************
*** 214,218 ****
$exitedRoomType = $dbSessionVars['roomType'];
! $dbLink->query("INSERT INTO " . C_MSG_TBL . " VALUES ($exitedRoomType, '$exitedRoomName', 'SYS exit', '', " . time() . ", NULL, '#666699', 'sprintf($messageKind, \'$nickForNotifications\')', 'sprintf($messageKind, \'$nickForNotifications\')')");
unset($messageKind);
unset($nickForNotifications);
--- 214,223 ----
$exitedRoomType = $dbSessionVars['roomType'];
! $aQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
! . '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
! . 'VALUES ('
! . "$exitedRoomType, '$exitedRoomName', 'SYS exit', '', " . time() . ", NULL, '#666699', 'sprintf($messageKind, \'$nickForNotifications\')', 'sprintf($messageKind, \'$nickForNotifications\')'"
! . ')';
! $dbLink->query($aQuery);
unset($messageKind);
unset($nickForNotifications);
Index: do_enter_db_work.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/index_libs/do_enter_db_work.lib.php3,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -r1.12 -r1.13
*** do_enter_db_work.lib.php3 2001/04/19 21:05:04 1.12
--- do_enter_db_work.lib.php3 2001/04/21 19:37:40 1.13
***************
*** 142,146 ****
*/
if ($isRegUser)
! $dbLink->query("UPDATE " . C_REG_TBL . " SET reg_time = '$currentTime', ip = '$ip' WHERE username = '$slashedNick'");
--- 142,146 ----
*/
if ($isRegUser)
! $dbLink->query("UPDATE " . C_REG_TBL . " SET reg_time = $currentTime, ip = '$ip' WHERE username = '$slashedNick'");
***************
*** 161,165 ****
if ($targetRoom == $wasInRoom)
{
! $dbLink->query("UPDATE " . C_USR_TBL . " SET u_time = '$currentTime', ip = '$ip' WHERE session_id = '$dbSessionId'");
}
--- 161,165 ----
if ($targetRoom == $wasInRoom)
{
! $dbLink->query("UPDATE " . C_USR_TBL . " SET u_time = $currentTime, ip = '$ip' WHERE session_id = '$dbSessionId'");
}
***************
*** 174,182 ****
list($type) = $dbLink->nextRecord();
$dbLink->cleanResults();
! $dbLink->query("INSERT INTO " . C_MSG_TBL . " VALUES ($roomType, '$slashedRoomName', 'SYS exit', '', '$currentTime', NULL, '#666699', 'sprintf(L_EXIT_ROM, \'" . $nickForNotifications . "\')', 'sprintf(L_EXIT_ROM, \'" . $nickForNotifications . "\')')");
$slashedRoomName = pmcSlashSingleQuotes($targetRoom);
! $dbLink->query("INSERT INTO " . C_MSG_TBL . " VALUES ($roomType, '$slashedRoomName', 'SYS enter', '', '$currentTime', NULL, '#666699', 'sprintf(L_ENTER_ROM, \'" . $nickForNotifications . "\')', 'sprintf(L_ENTER_ROM, \'" . $nickForNotifications . "\')')");
! $dbLink->query("UPDATE " . C_USR_TBL . " SET session_id = '$dbSessionId', u_time = '$currentTime', room = '$slashedRoomName', status = '$status', ip = '$ip' WHERE session_id = '$previousId'");
if (C_WELCOME)
--- 174,192 ----
list($type) = $dbLink->nextRecord();
$dbLink->cleanResults();
! $aQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
! . '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
! . 'VALUES ('
! . "$roomType, '$slashedRoomName', 'SYS exit', '', $currentTime, NULL, '#666699', 'sprintf(L_EXIT_ROM, \'$nickForNotifications\')', 'sprintf(L_EXIT_ROM, \'$nickForNotifications\')'"
! . ')';
! $dbLink->query($aQuery);
$slashedRoomName = pmcSlashSingleQuotes($targetRoom);
! $aQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
! . '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
! . 'VALUES ('
! . "$roomType, '$slashedRoomName', 'SYS enter', '', $currentTime, NULL, '#666699', 'sprintf(L_ENTER_ROM, \'$nickForNotifications\')', 'sprintf(L_ENTER_ROM, \'$nickForNotifications\')'"
! . ')';
! $dbLink->query($aQuery);
! $dbLink->query("UPDATE " . C_USR_TBL . " SET session_id = '$dbSessionId', u_time = $currentTime, room = '$slashedRoomName', status = '$status', ip = '$ip' WHERE session_id = '$previousId'");
if (C_WELCOME)
***************
*** 184,188 ****
// Delete the old welcome messages sent to the current user
$dbLink->query("DELETE FROM " . C_MSG_TBL . " WHERE username = 'SYS welcome' AND address = '$slashedNick'");
! $dbLink->query("INSERT INTO " . C_MSG_TBL . " VALUES ($roomType, '$slashedRoomName', 'SYS welcome', '', '$currentTimePlus', '$slashedNick', '#666699', '" . $slashedWelcomeMsg . "', '" . $slashedWelcomeMsg . "')");
}
}
--- 194,203 ----
// Delete the old welcome messages sent to the current user
$dbLink->query("DELETE FROM " . C_MSG_TBL . " WHERE username = 'SYS welcome' AND address = '$slashedNick'");
! $aQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
! . '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
! . 'VALUES ('
! . "$roomType, '$slashedRoomName', 'SYS welcome', '', $currentTimePlus, '$slashedNick', '#666699', '$slashedWelcomeMsg', '$slashedWelcomeMsg'"
! . ')';
! $dbLink->query($aQuery);
}
}
***************
*** 195,199 ****
{
$slashedRoomName = pmcSlashSingleQuotes($targetRoom);
! $dbLink->query("UPDATE " . C_USR_TBL . " SET u_time = '$currentTime', room = '$slashedRoomName', ip = '$ip' WHERE session_id = '$dbSessionId'");
} // end of case where an is relogged because of NS4+ resize bug
--- 210,214 ----
{
$slashedRoomName = pmcSlashSingleQuotes($targetRoom);
! $dbLink->query("UPDATE " . C_USR_TBL . " SET u_time = $currentTime, room = '$slashedRoomName', ip = '$ip' WHERE session_id = '$dbSessionId'");
} // end of case where an is relogged because of NS4+ resize bug
***************
*** 206,213 ****
$slashedRoomName = pmcSlashSingleQuotes($targetRoom);
if (isset($reloading) && $reloading == 'joinCmd')
! $dbLink->query("UPDATE " . C_USR_TBL . " SET u_time = '$currentTime', room = '$slashedRoomName', status = '$status', ip = '$ip' WHERE session_id = '$dbSessionId'");
else
! $dbLink->query("INSERT INTO " . C_USR_TBL . " VALUES ('$dbSessionId', '$currentTime', '$slashedRoomName', '$slashedNick', $latin1, '$status', '$ip')");
! $dbLink->query("INSERT INTO " . C_MSG_TBL . " VALUES ($roomType, '$slashedRoomName', 'SYS enter', '', '$currentTime', NULL, '#666699', 'sprintf(L_ENTER_ROM, \'" . $nickForNotifications . "\')', 'sprintf(L_ENTER_ROM, \'" . $nickForNotifications . "\')')");
if (C_WELCOME)
--- 221,242 ----
$slashedRoomName = pmcSlashSingleQuotes($targetRoom);
if (isset($reloading) && $reloading == 'joinCmd')
! {
! $dbLink->query("UPDATE " . C_USR_TBL . " SET u_time = $currentTime, room = '$slashedRoomName', status = '$status', ip = '$ip' WHERE session_id = '$dbSessionId'");
! }
else
! {
! $aQuery = 'INSERT INTO ' . C_USR_TBL . ' '
! . '(session_id, u_time, room, username, latin1, status, ip) '
! . 'VALUES ('
! . "'$dbSessionId', $currentTime, '$slashedRoomName', '$slashedNick', $latin1, '$status', '$ip'"
! . ')';
! $dbLink->query($aQuery);
! }
! $aQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
! . '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
! . 'VALUES ('
! . "$roomType, '$slashedRoomName', 'SYS enter', '', $currentTime, NULL, '#666699', 'sprintf(L_ENTER_ROM, \'$nickForNotifications\')', 'sprintf(L_ENTER_ROM, \'$nickForNotifications\')'"
! . ')';
! $dbLink->query($aQuery);
if (C_WELCOME)
***************
*** 215,219 ****
// Deletes the old welcome messages sent to the current user
$dbLink->query("DELETE FROM " . C_MSG_TBL . " WHERE username = 'SYS welcome' AND address = '$slashedNick'");
! $dbLink->query("INSERT INTO " . C_MSG_TBL . " VALUES ($roomType, '$slashedRoomName', 'SYS welcome', '', '$currentTimePlus', '$slashedNick', '#666699', '" . $slashedWelcomeMsg . "', '" . $slashedWelcomeMsg . "')");
}
} // end of "all other cases"
--- 244,253 ----
// Deletes the old welcome messages sent to the current user
$dbLink->query("DELETE FROM " . C_MSG_TBL . " WHERE username = 'SYS welcome' AND address = '$slashedNick'");
! $aQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
! . '(type, room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
! . 'VALUES ('
! . "$roomType, '$slashedRoomName', 'SYS welcome', '', $currentTimePlus, '$slashedNick', '#666699', '$slashedWelcomeMsg', '$slashedWelcomeMsg'"
! . ')';
! $dbLink->query($aQuery);
}
} // end of "all other cases"
***************
*** 256,260 ****
while (list($sentTime) = $dbLink->nextRecord())
{
! $dbLink->query("DELETE FROM " . C_MSG_TBL . " WHERE m_time = '$sentTime' AND (username = 'SYS inviteFrom' OR (username = 'SYS inviteTo' AND address = '$slashedNick'))");
}
--- 290,294 ----
while (list($sentTime) = $dbLink->nextRecord())
{
! $dbLink->query("DELETE FROM " . C_MSG_TBL . " WHERE m_time = $sentTime AND (username = 'SYS inviteFrom' OR (username = 'SYS inviteTo' AND address = '$slashedNick'))");
}
|
|
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 . ', '
|
|
From: Lo?c C. <lo...@us...> - 2001-04-21 19:35:36
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib
In directory usw-pr-cvs1:/tmp/cvs-serv32521/chat/lib
Modified Files:
banish.lib.php3
Log Message:
Fix some bugs if rooms' names contain slash character
Index: banish.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/banish.lib.php3,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** banish.lib.php3 2001/04/19 21:05:04 1.4
--- banish.lib.php3 2001/04/21 19:35:33 1.5
***************
*** 119,123 ****
// Add the nick to the banished users table if necessary
if ($isBanished)
! $dbLink->query("INSERT INTO " . C_BAN_TBL . " VALUES ('$slashedNick', $latin1, '$ip', '$banishedFromRooms', '$banUntil')");
} // end of the case where IP is banished from some rooms
else
--- 119,123 ----
// Add the nick to the banished users table if necessary
if ($isBanished)
! $dbLink->query("INSERT INTO " . C_BAN_TBL . " (username, latin1, ip, rooms, ban_until) VALUES ('$slashedNick', $latin1, '$ip', '" . pmcSlashSingleQuotes($banishedFromRooms) . "', '$banUntil')");
} // end of the case where IP is banished from some rooms
else
|
|
From: Lo?c C. <lo...@us...> - 2001-04-21 19:35:36
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands
In directory usw-pr-cvs1:/tmp/cvs-serv32521/chat/lib/commands
Modified Files:
banish.cmd.php3
Log Message:
Fix some bugs if rooms' names contain slash character
Index: banish.cmd.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands/banish.cmd.php3,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -r1.7 -r1.8
*** banish.cmd.php3 2001/04/19 21:05:04 1.7
--- banish.cmd.php3 2001/04/21 19:35:33 1.8
***************
*** 79,84 ****
else
{
if ($cmd[1] == '* ' && $dbSessionVars['status'] != 'a')
! $cmd[1] = '';
// Define the duration of the banishment
--- 79,85 ----
else
{
+ $targetCurrentRoom = pmcHandleMagicQuotes($targetCurrentRoom, '', 1, 'del');
if ($cmd[1] == '* ' && $dbSessionVars['status'] != 'a')
! $cmd[1] = '';
// Define the duration of the banishment
***************
*** 104,108 ****
else
{
- $targetCurrentRoom = pmcHandleMagicQuotes($targetCurrentRoom, '', 1, 'del');
$targetOldBanRooms = pmcHandleMagicQuotes($targetOldBanRooms, '', 1, 'del');
$slashedOldBanRooms = pmcSlashSingleQuotes($targetOldBanRooms);
--- 105,108 ----
***************
*** 128,133 ****
$targetNewBanRooms = ($cmd[1] == '* ')
? '*'
! : $slashedCurrentRoomName;
! $dbLink->query("INSERT INTO " . C_BAN_TBL . " VALUES ('$slashedTarget', $targetLatin1, '$targetIp', '$targetNewBanRooms', '$banUntil')");
} // end of 'first banishment for the target user'
--- 128,133 ----
$targetNewBanRooms = ($cmd[1] == '* ')
? '*'
! : pmcSlashSingleQuotes($targetCurrentRoom);
! $dbLink->query("INSERT INTO " . C_BAN_TBL . " (username, latin1, ip, rooms, ban_until) VALUES ('$slashedTarget', $targetLatin1, '$targetIp', '$targetNewBanRooms', '$banUntil')");
} // end of 'first banishment for the target user'
***************
*** 137,141 ****
// banishment confirmation message when an user has been banished
// from an other room than the current one
- $targetCurrentRoom = pmcHandleMagicQuotes($targetCurrentRoom, '', 1, 'del');
if ($targetCurrentRoom != $dbSessionVars['currentRoom'])
$error = sprintf(L_BANISHED, $cmd[2]);
--- 137,140 ----
|
|
From: Lo?c C. <lo...@us...> - 2001-04-21 15:16:54
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database
In directory usw-pr-cvs1:/tmp/cvs-serv28953/chat/install/database
Modified Files:
pgsql.sql
Log Message:
Far more convincing version...
Index: pgsql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/pgsql.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** pgsql.sql 2001/04/17 11:55:42 1.2
--- pgsql.sql 2001/04/21 15:16:52 1.3
***************
*** 10,22 ****
CREATE TABLE pmc_ban_users (
! username varchar(30) NOT NULL DEFAULT '' ,
latin1 int2 NOT NULL DEFAULT '0' ,
ip varchar(16) NOT NULL DEFAULT '' ,
rooms varchar(100) NOT NULL DEFAULT '' ,
! ban_until int4 NOT NULL DEFAULT '0' ,
! PRIMARY KEY (username),
! KEY ip (ip),
! KEY ban_until (ban_until)
);
--- 10,21 ----
CREATE TABLE pmc_ban_users (
! username varchar(30) PRIMARY KEY,
latin1 int2 NOT NULL DEFAULT '0' ,
ip varchar(16) NOT NULL DEFAULT '' ,
rooms varchar(100) NOT NULL DEFAULT '' ,
! ban_until int4 NOT NULL DEFAULT '0'
);
+ CREATE INDEX ip ON pmc_ban_users (ip);
+ CREATE INDEX ban_until ON pmc_ban_users (ban_until);
***************
*** 34,41 ****
color varchar(7) NOT NULL DEFAULT '#000000' ,
msg_original text NOT NULL DEFAULT '' ,
! msg_enhanced text NOT NULL DEFAULT '' ,
! KEY type (type),
! KEY m_time (m_time)
);
--- 33,40 ----
color varchar(7) NOT NULL DEFAULT '#000000' ,
msg_original text NOT NULL DEFAULT '' ,
! msg_enhanced text NOT NULL DEFAULT ''
);
+ CREATE INDEX type ON pmc_messages (type);
+ CREATE INDEX m_time ON pmc_messages (m_time);
***************
*** 45,49 ****
CREATE TABLE pmc_reg_users (
! username varchar(30) NOT NULL DEFAULT '' ,
latin1 int2 NOT NULL DEFAULT '0' ,
password varchar(32) NOT NULL DEFAULT '' ,
--- 44,48 ----
CREATE TABLE pmc_reg_users (
! username varchar(30) PRIMARY KEY ,
latin1 int2 NOT NULL DEFAULT '0' ,
password varchar(32) NOT NULL DEFAULT '' ,
***************
*** 58,67 ****
reg_time int4 NOT NULL DEFAULT '0' ,
ip varchar(16) NOT NULL DEFAULT '' ,
! gender int2 NOT NULL DEFAULT '0' ,
! PRIMARY KEY (username),
! KEY reg_time (reg_time),
! KEY perms (perms)
);
INSERT INTO pmc_reg_users VALUES('admin', '', '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', 0, 'admin', '', '', '', '');
--- 57,65 ----
reg_time int4 NOT NULL DEFAULT '0' ,
ip varchar(16) NOT NULL DEFAULT '' ,
! gender int2 NOT NULL DEFAULT '0'
);
INSERT INTO pmc_reg_users VALUES('admin', '', '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', 0, 'admin', '', '', '', '');
+ CREATE INDEX reg_time ON pmc_reg_users (reg_time);
+ CREATE INDEX perms ON pmc_reg_users (perms);
***************
*** 71,80 ****
CREATE TABLE pmc_sessions (
! session_id varchar(32) NOT NULL DEFAULT '' ,
last int4 NOT NULL DEFAULT '0' ,
! data text ,
! PRIMARY KEY (session_id),
! KEY last (last)
);
--- 69,77 ----
CREATE TABLE pmc_sessions (
! session_id varchar(32) PRIMARY KEY ,
last int4 NOT NULL DEFAULT '0' ,
! data text
);
+ CREATE INDEX last ON pmc_sessions (last);
***************
*** 84,101 ****
CREATE TABLE pmc_users (
! session_id varchar(32) NOT NULL DEFAULT '' ,
u_time int4 NOT NULL DEFAULT '0' ,
room varchar(30) NOT NULL DEFAULT '' ,
! username varchar(30) NOT NULL DEFAULT '' ,
latin1 int2 NOT NULL DEFAULT '0' ,
status char(1) NOT NULL DEFAULT 'u' ,
! ip varchar(16) NOT NULL DEFAULT '' ,
! PRIMARY KEY (session_id),
! KEY room_id (room),
! KEY status (status),
! KEY u_time (u_time)
);
!
!
!
!
--- 81,93 ----
CREATE TABLE pmc_users (
! session_id varchar(32) PRIMARY KEY ,
u_time int4 NOT NULL DEFAULT '0' ,
room varchar(30) NOT NULL DEFAULT '' ,
! username varchar(30) PRIMARY KEY ,
latin1 int2 NOT NULL DEFAULT '0' ,
status char(1) NOT NULL DEFAULT 'u' ,
! ip varchar(16) NOT NULL DEFAULT ''
);
! CREATE INDEX room ON pmc_users (room);
! CREATE INDEX status ON pmc_users (status);
! CREATE INDEX u_time ON pmc_users (u_time);
|
|
From: Lo?c C. <lo...@us...> - 2001-04-21 15:16:25
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database
In directory usw-pr-cvs1:/tmp/cvs-serv28854/chat/install/database
Modified Files:
mysql.sql
Log Message:
The 'username' column is now a primary key
Index: mysql.sql
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/install/database/mysql.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** mysql.sql 2001/04/17 10:04:50 1.4
--- mysql.sql 2001/04/21 15:16:22 1.5
***************
*** 90,94 ****
ip varchar(16) NOT NULL DEFAULT '' ,
PRIMARY KEY (session_id),
! KEY room_id (room),
KEY status (status),
KEY u_time (u_time)
--- 90,95 ----
ip varchar(16) NOT NULL DEFAULT '' ,
PRIMARY KEY (session_id),
! PRIMARY KEY (username),
! KEY room (room),
KEY status (status),
KEY u_time (u_time)
|
|
From: Lo?c C. <lo...@us...> - 2001-04-21 14:51:27
|
Update of /cvsroot/phpmychat/phpMyChat - 0.14/chat
In directory usw-pr-cvs1:/tmp/cvs-serv25912/chat
Modified Files:
usersL.php3 usersH.php3
Log Message:
Improve db queries
***** Bogus filespec: -
***** Bogus filespec: 0.14/chat
Index: usersL.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/usersL.php3,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** usersL.php3 2001/04/11 21:04:46 1.4
--- usersL.php3 2001/04/21 14:51:23 1.5
***************
*** 78,82 ****
. '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 . '\' '
--- 78,82 ----
. 'WHERE usr.room = \'' . $R . '\' '
. 'UNION '
! . 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND usr.room = \'' . $R . '\' '
***************
*** 85,89 ****
else
{
! $currentRoomQuery = 'SELECT usr.username, usr.latin1, usr.status, NULL '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . $R . '\' '
--- 85,89 ----
else
{
! $currentRoomQuery = 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . $R . '\' '
***************
*** 149,153 ****
. '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) . '\' '
--- 149,153 ----
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
. 'UNION '
! . 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND usr.room = \'' . addslashes($Other) . '\' '
***************
*** 156,160 ****
else
{
! $otherRoomsQuery = 'SELECT usr.username, usr.latin1, usr.status, 0 '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
--- 156,160 ----
else
{
! $otherRoomsQuery = 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
Index: usersH.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/usersH.php3,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -r1.10 -r1.11
*** usersH.php3 2001/04/11 21:04:46 1.10
--- usersH.php3 2001/04/21 14:51:23 1.11
***************
*** 101,105 ****
. '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 . '\' '
--- 101,105 ----
. 'WHERE usr.room = \'' . $R . '\' '
. 'UNION '
! . 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND usr.room = \'' . $R . '\' '
***************
*** 108,112 ****
else
{
! $currentRoomQuery = 'SELECT usr.username, usr.latin1, usr.status, NULL '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . $R . '\' '
--- 108,112 ----
else
{
! $currentRoomQuery = 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . $R . '\' '
***************
*** 172,176 ****
. '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) . '\' '
--- 172,176 ----
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
. 'UNION '
! . 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND usr.room = \'' . addslashes($Other) . '\' '
***************
*** 179,183 ****
else
{
! $otherRoomsQuery = 'SELECT usr.username, usr.latin1, usr.status, 0 '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
--- 179,183 ----
else
{
! $otherRoomsQuery = 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
***************
*** 191,195 ****
$id = md5($Other);
if ($i == 1) $FirstOtherRoom = "Parent".$id;
! echo("<DIV ID=\"Parent${id}\" CLASS=\"parent\" STYLE=\"margin-top: 5px; CURSOR: hand\">");
echo("<A HREF=\"#\" onClick=\"window.parent.expandIt('${id}'); return false\">");
echo("<IMG NAME=\"imEx\" SRC=\"images/closed.gif\" WIDTH=9 HEIGHT=9 BORDER=0 ALT=\"".L_EXPCOL."\"></A>");
--- 191,195 ----
$id = md5($Other);
if ($i == 1) $FirstOtherRoom = "Parent".$id;
! echo("<DIV ID=\"Parent${id}\" CLASS=\"parent\" STYLE=\"margin-top: 10px; CURSOR: hand\">");
echo("<A HREF=\"#\" onClick=\"window.parent.expandIt('${id}'); return false\">");
echo("<IMG NAME=\"imEx\" SRC=\"images/closed.gif\" WIDTH=9 HEIGHT=9 BORDER=0 ALT=\"".L_EXPCOL."\"></A>");
***************
*** 241,245 ****
$FirstOtherRoom = "Parent".$id;
! echo("<DIV ID=\"Parent${id}\" CLASS=\"parent\" STYLE=\"margin-top: 5px; CURSOR: hand\">");
echo("<A HREF=\"$From?Ver=H&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> (0)</SPAN>");
echo("</DIV>\n");
--- 241,245 ----
$FirstOtherRoom = "Parent".$id;
! echo("<DIV ID=\"Parent${id}\" CLASS=\"parent\" STYLE=\"margin-top: 10px; CURSOR: hand\">");
echo("<A HREF=\"$From?Ver=H&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> (0)</SPAN>");
echo("</DIV>\n");
|
6 messages has been excluded from this view by a project administrator.
