Changeset 4 for www/sunrisechat/sunrisechat2.php

Timestamp:

Jan 14, 2008, 9:48:39 PM (16 years ago)

Author:

george

Message:

Upraveno: Změna přístupu k databázi na třídu rozšířenou mysqli.
Upraveno: Sjednocení
Upraveno: Změna kódování všech stránek na UTF-8.
Odstraňeno: Staré nepotřebné soubory.

Location:

www

Files:

• . (modified) (1 prop)
• sunrisechat/sunrisechat2.php (modified) (4 diffs)

www/sunrisechat/sunrisechat2.php

@@ -1 @@
-<?
+<?php
 
-include_once('/a/html/is/db.php');
-include_once('/a/html/sunrisechat/webchatsend.php');
-DB_Init('localhost','root','','is');
-DB_Query('SET NAMES latin2');
+include_once('../global.php');
+include_once('webchatsend.php');
   
 $Debug = 0;
@@ -10 +8 @@
 function Packet($Text2)
 {
-  global $Debug;
+  global $Debug, $Database;
   //echo("{".$Text2."}".ord($Text2[1]).".".strlen($Text2)."\n");
   //echo($Text2.strlen($Text2)."\n");
@@ -29 +27 @@
     $RoomType = $Parts[10];
     if($Debug == 1) echo('Message: '.$Text."\n");
-    DB_Select('sunrisechat_onlinelist','*','sender_id='.$SenderID.' AND sender_ip="'.$SenderIP.'"');
-    if(DB_NumRows()>0)
+    $DbResult = $Database->select('sunrisechat_onlinelist','*','sender_id='.$SenderID.' AND sender_ip="'.$SenderIP.'"');
+    if($DbResult->num_rows > 0)
     {
-      $Row = DB_Row();
+      $Row = $DbResult->fetch_array();
       $Nick = $Row['nick'];
     } else $Nick = '';
     echo('<'.$Nick.'>'.$Text." ".addslashes($Text)."\n");
-    DB_Insert('sunrisechat_history',array('time' => 'NOW()', 'nick' => $Nick, 'text' => $Text, 'color' => $Color,
+    $Database->insert('sunrisechat_history',array('time' => 'NOW()', 'nick' => $Nick, 'text' => $Text, 'color' => $Color,
     'roomname' => $RoomName, 'roomtype' => $RoomType));
   }
   if($Command == 'Alive')
   {
-    DB_Select('sunrisechat_onlinelist','*','sender_id='.$SenderID.' AND sender_ip="'.$SenderIP.'"');
-    if(DB_NumRows()>0)
+    $Result = $Database->select('sunrisechat_onlinelist','*','sender_id='.$SenderID.' AND sender_ip="'.$SenderIP.'"');
+    if($DbResult->num_rows() > 0)
     {
-      $Row = DB_Row();
-      DB_Update('sunrisechat_onlinelist','sender_ip="'.$SenderIP.'" AND sender_id='.$SenderID,array('lasttime' => 'NOW()'));
-    } else DB_Insert('sunrisechat_onlinelist',array('lasttime' => 'NOW()', 'sender_ip' => $SenderIP, 'sender_id' => $SenderID));  
+      $Row = $DbResult->fetch_array();
+      $Database->update('sunrisechat_onlinelist','sender_ip="'.$SenderIP.'" AND sender_id='.$SenderID,array('lasttime' => 'NOW()'));
+    } else $Database->insert('sunrisechat_onlinelist',array('lasttime' => 'NOW()', 'sender_ip' => $SenderIP, 'sender_id' => $SenderID));  
   }
   if($Command == 'GoOnline')
   {
-    DB_Select('sunrisechat_onlinelist','*','sender_id='.$SenderID.' AND sender_ip="'.$SenderIP.'"');
-    if(DB_NumRows()>0)
+    $Result = $Database->select('sunrisechat_onlinelist','*','sender_id='.$SenderID.' AND sender_ip="'.$SenderIP.'"');
+    if($DbResult->num_rows() > 0)
     {
-      $Row = DB_Row();
-      DB_Update('sunrisechat_onlinelist','sender_ip="'.$SenderIP.'" AND sender_id='.$SenderID,array('lasttime' => 'NOW()', 'status' => 'Online'));
-    } else DB_Insert('sunrisechat_onlinelist',array('lasttime' => 'NOW()', 'sender_ip' => $SenderIP, 'sender_id' => $SenderID, 'status' => 'Online'));  
+      $Row = $DbResult->fetch_array();
+      $Database->update('sunrisechat_onlinelist','sender_ip="'.$SenderIP.'" AND sender_id='.$SenderID,array('lasttime' => 'NOW()', 'status' => 'Online'));
+    } else $Database->insert('sunrisechat_onlinelist',array('lasttime' => 'NOW()', 'sender_ip' => $SenderIP, 'sender_id' => $SenderID, 'status' => 'Online'));  
   }
   if($Command == 'GoAway')
   {
-    DB_Select('sunrisechat_onlinelist','*','sender_id='.$SenderID.' AND sender_ip="'.$SenderIP.'"');
-    if(DB_NumRows()>0)
+    $Result = $Database->select('sunrisechat_onlinelist','*','sender_id='.$SenderID.' AND sender_ip="'.$SenderIP.'"');
+    if($DbResult->num_rows() > 0)
     {
-      $Row = DB_Row();
-      DB_Update('sunrisechat_onlinelist','sender_ip="'.$SenderIP.'" AND sender_id='.$SenderID,array('lasttime' => 'NOW()', 'status' => 'Away'));
-    } else DB_Insert('sunrisechat_onlinelist',array('lasttime' => 'NOW()', 'sender_ip' => $SenderIP, 'sender_id' => $SenderID, 'status' => 'Away'));  
+      $Row = $DbResult->fetch_array();
+      $Database->update('sunrisechat_onlinelist','sender_ip="'.$SenderIP.'" AND sender_id='.$SenderID,array('lasttime' => 'NOW()', 'status' => 'Away'));
+    } else $Database->insert('sunrisechat_onlinelist',array('lasttime' => 'NOW()', 'sender_ip' => $SenderIP, 'sender_id' => $SenderID, 'status' => 'Away'));  
   }
   if($Command == 'UserInfo')
@@ -70 +68 @@
     $Nick = $Parts[7];
     echo('UserInfo: '.$Nick."\n");
-    DB_Select('sunrisechat_onlinelist','*','sender_id='.$SenderID.' AND sender_ip="'.$SenderIP.'"');
-    if(DB_NumRows()>0)
+    $Result = $Database->select('sunrisechat_onlinelist','*','sender_id='.$SenderID.' AND sender_ip="'.$SenderIP.'"');
+    if($DbResult->num_rows() > 0)
     {
-      $Row = DB_Row();
-      DB_Update('sunrisechat_onlinelist','sender_ip="'.$SenderIP.'" AND sender_id='.$SenderID,array('lasttime' => 'NOW()', 'nick' => $Nick, 'operating_system' => $Parts[12], 'status' => $Parts[10]));
-    } else DB_Insert('sunrisechat_onlinelist',array('lasttime' => 'NOW()', 'nick' => $Nick, 'sender_ip' => $SenderIP, 'sender_id' => $SenderID, 'operating_system' => $Parts[12], 'status' => $Parts[10]));
+      $Row = $DbResult->fetch_array();
+      $Database->update('sunrisechat_onlinelist','sender_ip="'.$SenderIP.'" AND sender_id='.$SenderID,array('lasttime' => 'NOW()', 'nick' => $Nick, 'operating_system' => $Parts[12], 'status' => $Parts[10]));
+    } else $Database->insert('sunrisechat_onlinelist',array('lasttime' => 'NOW()', 'nick' => $Nick, 'sender_ip' => $SenderIP, 'sender_id' => $SenderID, 'operating_system' => $Parts[12], 'status' => $Parts[10]));
   }
   if($Command == 'WhoIs')   // for WebSunriseChat support
   {
-    DB_Select('sunrisechat_onlinelist','*','sender_id='.$TargetID.' AND sender_ip="'.$TargetIP.'" AND operating_system="Fedora Core 2"');
-    if(DB_NumRows()>0)
+    $Result = $Database->select('sunrisechat_onlinelist','*','sender_id='.$TargetID.' AND sender_ip="'.$TargetIP.'" AND operating_system="Fedora Core 2"');
+    if($DbResult->num_rows() > 0)
     { 
-      $Row = DB_Row();
+      $Row = $DbResult->fetch_array();
       $_SESSION['DetailInfo'] = $Row['info'];
       $Nick = $Row['nick'];