public function respondToItem(Item $item, $uid) { $exists = parent::execQuery("SELECT 1 AS flag FROM public.aspid_user_inventory WHERE uid = ? and item_id = ?", array($uid, $item->id)); if (isset($exists[0]['flag'])) { parent::execUpdate("UPDATE public.aspid_user_inventory SET respond_comment = ?, have_status = ?, ins_date = CURRENT_TIMESTAMP WHERE uid = ? and item_id = ?", array($item->respondcomment, $item->ihave, $uid, $item->id)); } else { parent::execInsert("INSERT INTO public.aspid_user_inventory(uid,item_id,respond_comment,have_status)values(?,?,?,?)", array($uid, $item->id, $item->respondcomment, $item->ihave)); } }
public function setUserAvatar($uid, $path) { $query = "select * from public.user_avatar where uid = ?"; $set = parent::execQuery($query, array($uid)); if (!empty($set)) { $query = "update public.user_avatar set path = ? where uid = ?"; parent::execUpdate($query, array($path, $uid)); } else { $query = "insert into public.user_avatar(uid,path) values (?,?)"; parent::execInsert($query, array($uid, $path)); } }