PHP Code:
case $ACT_SEND_CHAT :
$data = explode ( ';', $action_extra );
$msg = $data[0];
$time = new DateTime ();
$time = $time->getTimestamp ();
$recid = "0";
$qry = $db->prepare ( "SELECT user_name, user_id, guild_id FROM user_data WHERE ssid = :ssid" );
$qry->bindParam ( ':ssid', $SSID );
$qry->execute ();
$ids = $qry->fetchAll ();
$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 ();
$ret = array ("162".$ids [0] ['user_name'].":" . $msg . ";" . $recid );
break;
