function User_setSID($hsid, $id)
{
$q = "UPDATE Users\n\t\t\t\tSET hsid = ?s\n\t\t\t\tWHERE id = ?i";
$result = Database_query(User_db(), $q, $hsid, $id);
if (Database_affectedRows() > 0) {
return true;
} else {
return false;
}
}
/**
* Money transaction
*/
function Orders_makeTransaction($user_id, $order_id, $value)
{
$q = "INSERT INTO Transactions\n\t\t\t\t(order_id, user_id, value)\n\t\t\t\tVALUES \n\t\t\t\t(?i, ?i, ?d)";
$result = Database_query(Orders_db(), $q, $order_id, $user_id, $value);
$id = Database_insertID();
$q = "UPDATE Users\n\t\t\t\tSET account = account + ?d\n\t\t\t\tWHERE id = ?i";
$result = Database_query(Orders_db(), $q, $value, $user_id);
$count = Database_affectedRows();
if (!$id || $count == 0) {
Database_rollbackTransaction(Orders_db());
Database_rollbackTransaction(Orders_transactions_db());
return getError('database_error');
}
return $id;
}
