[go: up one dir, main page]
Menu ▾ ▴

[r18]: / tags / 0.1 / ratchat.php  Maximize  Restore  History

Download this file

40 lines (32 with data), 1.1 kB 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<?php

$settings = array();

$settings['dbhost'] = 'localhost';

$settings['dbuser'] = 'root';

$settings['dbpass'] = '';

$settings['dbname'] = 'ratchat';



@include_once("config.php");



mysql_connect($settings['dbhost'], $settings['dbuser'], $settings['dbpass']);

mysql_selectdb($settings['dbname']);



function getNick() { return $_SESSION['nick']; }



function setNick($nick) {

	$_SESSION['nick'] = $nick;

	return $_SESSION['nick'];

}



function getMessages($channel, $lastmsg=null) {

	$r = mysql_query('select userid, time, msg, (select max(msgid) from msg) as lastmsg from msg where 1=1 '.

		(($lastmsg==null)?' and msgid>(select max(msgid)-20 from msg) ':" and msgid>$lastmsg").

		" order by time asc");

	$ret = array();

	$ret['length'] = 0;

	while ( $msg = mysql_fetch_assoc($r) ) {

		$ret[$ret['length']] = $msg;

		$ret['length']++;

	}

	return $ret;

}



function postMessage($channel, $msg) {

	if ( $msg == "" ) return;

	$r = mysql_query("insert into msg (userid,chanid,msg) ".

		"values ('$_SESSION[nick]','$channel','$msg');");

}



?>