function sendmsg($data) { $outp = array("ec" => 1, "data" => 0); $recvlist = intexplode("-", $data["rid"]); $msgdata = Fun::getflds(array("msg"), $data); $msgdata["msg"] = trim($msgdata["msg"]); if ($data["msg"] != "") { $msgdata["time"] = time(); $msgid = Sqle::insertVal("msgdata", $msgdata); $msg_table_arr = array(); foreach ($recvlist as $i => $rid) { $msg_table_arr[] = array(User::loginId(), $rid, User::loginId(), $msgid, 'u'); //u for unseen $msg_table_arr[] = array(User::loginId(), $rid, $rid, $msgid, 'u'); } $outp["data"] = Sql::query("insert into msg (sid,rid,aid,msgid,isseen) " . Fun::makeDummyTableColumns($msg_table_arr, array("sid", "rid", "aid", "msgid", "isseen"), 'iiiis')); } return $outp; }
function f_handle_db_request($req) { $outp = 0; if ($req["autoinsert"]) { $outp = Sqle::insertVal($req["table"], $req["autodata"]); } if ($req["autodelete"]) { $outp = Sqle::deleteVal($req["table"], $req["autodata"]); } if ($req["autoupdate"]) { $outp = Sqle::updateVal($req["table"], $req["update"], $req["autodata"]); } return $outp; }
public static function prvnotf($uid, $sid, $mfile, $data, $url) { $content = Fun::rmsg(file_get_contents($mfile), $data); $nid = Sqle::insertVal("notf", array("uid" => $uid, "sid" => $sid, "content" => $content, "time" => time(), "isr" => "0", "url" => $url)); if (strpos($url, '?')) { $url = $url . "¬fid="; } else { $url = $url . "?notfid="; } Sql::query("update notf set url=concat(?,id) where id=?", 'si', array(&$url, &$nid)); return $nid; }
public static function signUp($data) { //email,password,type keys are compulsary !! global $_ginfo; $data = Fun::setifunset($data, "type", $_ginfo["default_user_type"]); $data['create_time'] = $data['update_time'] = time(); if (!self::isValidSignUp($data)) { return -3; } else { if (self::isUserExist($data['email'])) { return -16; } else { $data["username"] = $data["email"]; $ip = $_SERVER['REMOTE_ADDR']; $data['last_ip'] = $ip; $data['profilepic'] = "photo/human1.png"; $temp = array('id' => Sqle::insertVal('users', $data), 'type' => $data['type']); $_SESSION['login'] = $temp; return $temp; } } }