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));
}
}
