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