CREATE TABLE IF NOT EXISTS `guild_chat` ( `msg_id` int(11) NOT NULL AUTO_INCREMENT, `guild_id` int(11) NOT NULL, `sender_id` int(11) NOT NULL, `reciver_id` int(11) NOT NULL, `time` int(11) NOT NULL, `msg` text NOT NULL, PRIMARY KEY (`msg_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
case $ACT_SEND_CHAT :
break;
case $ACT_SEND_CHAT :
// the ususal stuff
// msg;0
// what the hell means 0??
$data = explode ( ';', $action_extra );
$msg = $data[0];
$time = new DateTime ();
$time = $time->getTimestamp ();
$recid = "0";
// get some ids
$qry = $db->prepare ( "SELECT user_id, guild_id FROM user_data WHERE ssid = :ssid" );
$qry->bindParam ( ':ssid', $SSID );
$qry->execute ();
$ids = $qry->fetchAll ();
// put into db
$qry = $db->prepare ("INSERT INTO guild_chat(guild_id, sender_id, reciver_id, time, msg)
VALUES(:guildid, :uid, :recid, :time, :msg)");
$qry->bindParam ( ':guildid', $ids [0] ['guild_id'] );
$qry->bindParam ( ':uid', $ids [0] ['user_id'] );
$qry->bindParam ( ':recid', $recid );
$qry->bindParam ( ':time', $time );
$qry->bindParam ( ':msg', $msg );
$qry->execute ();
break;
But you are at the right Way.Quote:
nope.. there no callback to the client.. thats why i need help
Still empty :(
[Only registered and activated users can see links. Click Here To Register...]
Quote:
I still don't know how the to communicate with the client, so i could need some help from now.. :handsdown:
SQL
ReplaceCode:CREATE TABLE IF NOT EXISTS `guild_chat` ( `msg_id` int(11) NOT NULL AUTO_INCREMENT, `guild_id` int(11) NOT NULL, `sender_id` int(11) NOT NULL, `reciver_id` int(11) NOT NULL, `time` int(11) NOT NULL, `msg` text NOT NULL, PRIMARY KEY (`msg_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
withPHP Code:case $ACT_SEND_CHAT :
break;
[Only registered and activated users can see links. Click Here To Register...]PHP Code:case $ACT_SEND_CHAT :
// the ususal stuff
// msg;0
// what the hell means 0??
$data = explode ( ';', $action_extra );
$msg = $data[0];
$time = new DateTime ();
$time = $time->getTimestamp ();
$recid = "0";
// get some ids
$qry = $db->prepare ( "SELECT user_id, guild_id FROM user_data WHERE ssid = :ssid" );
$qry->bindParam ( ':ssid', $SSID );
$qry->execute ();
$ids = $qry->fetchAll ();
// put into db
$qry = $db->prepare ("INSERT INTO guild_chat(guild_id, sender_id, reciver_id, time, msg)
VALUES(:guildid, :uid, :recid, :time, :msg)");
$qry->bindParam ( ':guildid', $ids [0] ['guild_id'] );
$qry->bindParam ( ':uid', $ids [0] ['user_id'] );
$qry->bindParam ( ':recid', $recid );
$qry->bindParam ( ':time', $time );
$qry->bindParam ( ':msg', $msg );
$qry->execute ();
break;
[Only registered and activated users can see links. Click Here To Register...]
Nice $ACT_SEND_CHAT but where is $ACT_PULL_CHAT_DATA, $ACT_GET_CHAT_HISTORY, $ERR_GUILD_CHAT_TEXT_ERROR, $RESP_CHAT_HISTORY, $RESP_CHAT_LINE
Quote:
@UP: me no work too
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
@EDIT:
cam someone upload request with gulid chat?