|
|
if ($error) {
?>
| echo $error_msg ?> |
| |
} ?>
subway betting zone home |
|
| |
if ($someone_else) { ?>
| User Name: echo $name; ?> |
| Real Name: echo $firstname . " " . $lastname; ?> |
| |
Bets That echo $name ?> Has Not Accepted or Rejected... |
} else { ?>
Bets That You Have Not Accepted or Rejected... |
} ?>
$bet_sql = "SELECT bet_id, better_id, bettee_id, username, description, status, subways, timestamp FROM bets, users WHERE (bettee_id = " . $user . " AND status = 1 AND better_id = users.user_id) OR (status = 7 AND better_id = " . $user . " AND bettee_id = users.user_id)";
if ($someone_else) {
$bet_sql = $bet_sql . " AND private = '0'";
}
$bet_sql = $bet_sql . " ORDER BY timestamp DESC";
$bet_result = mysql_query($bet_sql) or die ('error finding bet: ' . mysql_error());
if (mysql_num_rows($bet_result) > 0) {
echo "| username | description | | # subways | date & time | action | ";
} else {
echo "| none | ";
}
while (list($bet_id, $better_id, $bettee_id, $username, $description, $status, $subways, $timestamp) = mysql_fetch_row($bet_result)) {
echo "| " . $username . " | " . substr($description, 0, 57) . "... | ";
} else {
echo $better_id . "'>" . $username . "" . substr($description, 0, 57) . "... | ";
}
if ($subways == '-99') {
$subways = 'INFINITE';
}
echo "" . $subways . " | " . $timestamp . " | " . $action . " | ";
}
mysql_free_result($bet_result);
?>
| |
if ($someone_else) { ?>
People Who Owe echo $name ?> Subway... |
} else { ?>
People Who Owe You Subway... |
} ?>
$bet_sql = "SELECT bet_id, better_id, bettee_id, username, description, subways, timestamp FROM bets, users WHERE better_id = " . $user . " AND status = 5 AND bets.bettee_id = users.user_id";
if ($someone_else) {
$bet_sql = $bet_sql . " AND private = '0'";
}
$bet_sql = $bet_sql . " ORDER BY timestamp DESC";
$bet_result = mysql_query($bet_sql) or die ('error finding bet: ' . mysql_error());
if (mysql_num_rows($bet_result) > 0) {
echo "| username | description | | # subways | date & time | action | ";
} else {
echo "| none | ";
}
while (list($bet_id, $better_id, $bettee_id, $username, $description, $subways, $timestamp) = mysql_fetch_row($bet_result)) {
if ($subways == '-99') {
$subways = 'INFINITE';
}
echo "| " . $username . " | " . substr($description, 0, 57) . "... | ";
echo "";
echo "" . $subways . " | " . $timestamp . " | ";
}
mysql_free_result($bet_result);
?>
| |
if ($someone_else) { ?>
People Who echo $name ?> Owes Subway... |
} else { ?>
People Who You Owe Subway... |
} ?>
$bet_sql = "SELECT bet_id, bettee_id, better_id, username, description, subways, timestamp FROM bets, users WHERE bettee_id = " . $user . " AND status = 5 AND bets.better_id = users.user_id";
if ($someone_else) {
$bet_sql = $bet_sql . " AND private = '0'";
}
$bet_sql = $bet_sql . " ORDER BY timestamp DESC";
$bet_result = mysql_query($bet_sql) or die ('error finding bet: ' . mysql_error());
if (mysql_num_rows($bet_result) > 0) {
echo "| username | description | | # subways | date & time | action | ";
} else {
echo "| none | ";
}
while (list($bet_id, $bettee_id, $better_id, $username, $description, $subways, $timestamp) = mysql_fetch_row($bet_result)) {
if ($subways == '-99') {
$subways = 'INFINITE';
}
echo "| " . $username . " | " . substr($description, 0, 57) . "... | ";
echo "";
echo "" . $subways . " | " . $timestamp . " | ";
if ($_SESSION['user_id'] == $bettee_id) {
echo "pay";
}
echo " | ";
}
mysql_free_result($bet_result);
?>
| |
if ($someone_else) { ?>
Bets echo $name ?> Has With Others... |
} else { ?>
Bets You Have With Others...(Outcome yet to be determined) |
} ?>
$bet_sql = "SELECT bet_id, better_id, bettee_id, description, subways, timestamp FROM bets WHERE (bettee_id = " . $user . " OR better_id = " . $user . ") AND status = 3";
if ($someone_else) {
$bet_sql = $bet_sql . " AND private = '0'";
}
$bet_sql = $bet_sql . " ORDER BY timestamp DESC";
$bet_result = mysql_query($bet_sql) or die ('error finding bet: ' . mysql_error());
if (mysql_num_rows($bet_result) > 0) {
echo "| username | description | | # subways | date & time | action | ";
} else {
echo "| none | ";
}
while (list($bet_id, $better_id, $bettee_id, $description, $subways, $timestamp) = mysql_fetch_row($bet_result)) {
if ($subways == '-99') {
$subways = 'INFINITE';
}
if ($_SESSION['user_id'] == $bettee_id) {
$action = "Review";
} else if ($_SESSION['user_id'] == $better_id) {
$action = "Review";
} else {
$action = "View";
}
echo "";
if ($user == $better_id) {
$user_sql = "SELECT username, user_id FROM users WHERE user_id = $bettee_id";
$user_result = mysql_query($user_sql) or die ('error finding user: ' . mysql_error());
list($username, $other_id) = mysql_fetch_row($user_result);
echo "| " . $username . " | " . substr($description, 0, 57). "... | ";
mysql_free_result($user_result);
} else {
$user_sql = "SELECT username, user_id FROM users WHERE user_id = $better_id";
$user_result = mysql_query($user_sql) or die ('error finding user: ' . mysql_error());
list($username, $other_id) = mysql_fetch_row($user_result);
echo "" . $username . " | " . substr($description, 0, 57). "... | ";
mysql_free_result($user_result);
}
echo "" . $subways . " | " . $timestamp . " | ";
if ($_SESSION['user_id'] == $better_id) {
echo "claim remove | ";
}
echo " ";
}
mysql_free_result($bet_result);
?>
| |
if ($someone_else) { ?>
Bets echo $name ?> Has With Others That They Have Not Accepted or Rejected... |
} else { ?>
Bets You Have With Others That They Have Not Accepted or Rejected... |
} ?>
$bet_sql = "SELECT bet_id, better_id, bettee_id, username, description, status, subways, timestamp FROM bets, users WHERE (better_id = " . $user . " AND status = 1 AND bettee_id = users.user_id) OR (status = 7 AND bettee_id = " . $user . " AND better_id = users.user_id)";
if ($someone_else) {
$bet_sql = $bet_sql . " AND private = '0'";
}
$bet_sql = $bet_sql . " ORDER BY timestamp DESC";
$bet_result = mysql_query($bet_sql) or die ('error finding bet: ' . mysql_error());
if (mysql_num_rows($bet_result) > 0) {
echo "| username | description | | # subways | date & time | action | ";
} else {
echo "| none | ";
}
while (list($bet_id, $better_id, $bettee_id, $username, $description, $status, $subways, $timestamp) = mysql_fetch_row($bet_result)) {
if ($subways == '-99') {
$subways = 'INFINITE';
}
echo "| " . $username . " | " . substr($description, 0, 57) . "... | ";
if ($user == $better_id) {
echo "";
} else {
echo "";
}
echo "" . $subways . " | " . $timestamp . " | ";
}
mysql_free_result($bet_result);
?>
|