public static function updateStatusAndPayChannel($reservationId, $status, $channel = NULL)
{
$connection = DBUtil::connectDB();
$ret = mysql_query("update reservation set status='{$status}',pay_channel='{$channel}' where id={$reservationId}", $connection);
mysql_close();
return $ret;
}
public static function deleteSet($setId)
{
$con = DBUtil::connectDB();
mysql_query("DELETE FROM consume_set where id={$setId}", $con);
mysql_close();
return mysql_errno() == 0;
}
public static function updateUser($username, $nick, $avatar, $gender)
{
$sentence = '';
if ($nick != NULL) {
$sentence = "nick='{$nick}'";
}
if ($avatar != NULL) {
if (!empty($sentence)) {
$sentence .= ',';
}
$sentence .= "avatar='{$avatar}'";
}
if ($gender != NULL) {
if (!empty($sentence)) {
$sentence .= ',';
}
$sentence .= "gender='{$gender}'";
}
if (empty($sentence)) {
return TRUE;
}
$conn = DBUtil::connectDB();
$result = mysql_query("update user set {$sentence} where username='******'", $conn);
mysql_close();
return $result;
}
public static function getMarkRecords($messageId, $userId)
{
$con = DBUtil::connectDB();
$result = mysql_query("select * from beento where messageId='{$messageId}' AND userId='{$userId}'", $con);
$records = [];
while ($row = mysql_fetch_array($result)) {
$r = [];
$r['destination'] = $row['destination'];
$r['id'] = $row['id'];
$records[] = $r;
}
mysql_close();
return $records;
}
public static function cancelJoinActivity($userId, $activityId)
{
$activity = self::getActivityById($activityId);
$userIds = $activity[0]['user_ids'];
foreach ($userIds as $key => $id) {
if ($id == $userId) {
unset($userIds[$key]);
break;
}
}
$newIds = json_encode($userIds);
$conn = DBUtil::connectDB();
$result = mysql_query("update activity set user_ids='{$newIds}' where id={$activityId}", $conn);
mysql_close();
return $result != FALSE ? TRUE : FALSE;
}
