Offline Instant Messaging with php Mysqli - Revision history

Steevithak: removing the delete request

2020-10-19T15:52:40Z

removing the delete request

2020-09-10T15:56:14Z

added delete request for duplicate, orphan page

2013-03-26T13:46:39Z

‎STEP 1: offline.sql

2013-03-26T13:46:17Z

‎STEP 2: offline.php

2013-03-24T14:16:36Z

‎STEP 2: offline.php

2013-03-24T14:11:23Z

‎STEP 2: offline.php

2013-03-24T14:09:25Z

‎STEP 2: offline.php

2013-03-24T13:29:12Z

‎STEP 1: offline.sql

2013-03-24T13:28:16Z

‎STEP 2: offline.php

2013-03-24T13:27:26Z

‎STEP 2: offline.php

← Older revision		Revision as of 15:52, 19 October 2020
Line 1:		Line 1:
−	~~{{delete\|Orphaned page with duplicate content}}~~
−	~~'''Purpose:''' Minor cleanup~~
−
−	~~'' This page was replaced by the [[Offline_Messaging]] page and is now an orphaned duplicate. The content here is also out of date. This page needs to be deleted.~~
−

	Offline Messaging makes it possible to send IM's to people who are not online.		Offline Messaging makes it possible to send IM's to people who are not online.

← Older revision		Revision as of 15:56, 10 September 2020
Line 1:		Line 1:
		+	{{delete\|Orphaned page with duplicate content}}
		+	'''Purpose:''' Minor cleanup
		+
		+	'' This page was replaced by the [[Offline_Messaging]] page and is now an orphaned duplicate. The content here is also out of date. This page needs to be deleted.
		+
		+
	Offline Messaging makes it possible to send IM's to people who are not online.		Offline Messaging makes it possible to send IM's to people who are not online.

@@ Line 17: / Line 17: @@
    `PrincipalID` char(36) NOT NULL DEFAULT '',
    `Message` text NOT NULL,
-   `TMStamp` char(14) NOT NULL DEFAULT '',
+   `TMStamp` INT,
    PRIMARY KEY  (`ID`),
    KEY `PrincipalID` (`PrincipalID`)
 ) ENGINE=MyISAM;
 </source >

@@ Line 59: / Line 59: @@
   * @author: Richardus Raymaker -> http:\\www.simsquaremetaverse.nl
   * @date: 2013-03-23
   */
 define("C_DB_HOST"      ,"localhost");
-define("C_DB_DATABASE"  ,"gridservices");
+define("C_DB_DATABASE"  ,"");
-define("C_DB_USER"      ,"offline");
+define("C_DB_USER"      ,"");
-define("C_DB_PASS"      ,"#off4me#");
+define("C_DB_PASS"      ,"");
 define("C_DB_TABLE"     ,"offline");

@@ Line 50: / Line 50: @@
 C_DB_USER = database user you are useing for accesing the offline table
 C_DB_PASS = user passwd that belongs to the use that you set in C_DB_USER
-C_DB_TABLE = table name for offline. default it's offline.
+C_DB_TABLE = table name for offline.
 </source >

@@ Line 98: / Line 98: @@
              /*Open offline database*/
              $link = mysqli_connect(C_DB_HOST, C_DB_USER, C_DB_PASS, C_DB_DATABASE);
-             if (!$link) { die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error()); error_log("SaveMessage died"); exit; }
+             if (!$link) { die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error()); exit; }
              mysqli_set_charset($link, "utf8");
@@ Line 131: / Line 131: @@
          /*Open offline database*/
          $link = mysqli_connect(C_DB_HOST, C_DB_USER, C_DB_PASS, C_DB_DATABASE);
-         if (!$link) { die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error()); error_log("RecieveMessage died"); exit; }
+         if (!$link) { die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error()); exit; }
          mysqli_set_charset($link, "utf8");

@@ Line 33: / Line 33: @@
 <pre>
 mysql> source offline.sql
 </pre>

@@ Line 155: / Line 155: @@
 ?>
 </source >
 === STEP 3: OfflineMessageModule ===

@@ Line 38: / Line 38: @@
 Copy this PHP script to a file called offline.php and upload the script file to your web server.
-Open the offline.php file to set the following parameters.
+Open the offline.php file to set the following parameters.<br>
-C_DB_HOST, C_DB_DATABASE, C_DB_USER, C_DB_PASS, C_DB_TABLE
+C_DB_HOST, C_DB_DATABASE, C_DB_USER, C_DB_PASS, C_DB_TABLE<br>
 Add the required data between the ""