| Neuer Benutzer
Registriert seit: 25.11.2011
Beiträge: 2
PHP-Kenntnisse:
Anfänger
|  Sportwetten
ich hoffe das ich hier richtig bin.
bin noch Anfänger in den Sachen.
ich will mir eine Wette Seite aufbauen.
habe auch schon ein wette Skript gefunden.
das Pro. ist ich es mit ein Punktesystemist mit einer Rangliste haben aber ich bekomme es nicht hin könnt ihr mir helfen???
sql code PHP-Code: CREATE TABLE `betting_bet` (
`uid` int(10) NOT NULL DEFAULT '0',
`gid` int(10) NOT NULL DEFAULT '0',
`tip` int(1) NOT NULL DEFAULT '0',
`insert` int(18) NOT NULL DEFAULT '0',
`closed_gid` int(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
bet.php PHP-Code: <?php
require_once("datas/function.php");
dbconn();
loggedinorreturn();
function Tag($tag)
{
switch($tag)
{
case "Monday" : return "Mo";
break;
case "Tuesday" : return "Di";
break;
case "Wednesday" : return "Mi";
break;
case "Thursday" : return "Do";
break;
case "Friday" : return "Fr";
break;
case "Saturday" : return "Sa";
break;
case "Sunday" : return "So";
break;
}
}
/////Anfang Einsatz OK (nur diese Zeile)/////
if(($_POST["tippen"] == "ok") && ($_GET[bet]!="ok"))
{
/////Anfang Wette berprüfen und setzen/////
if($_POST[tip] != "" && $_POST[insert] != "")
{
$insert = str_replace(",",".",htmlentities($_POST[insert]));
/////Prüfen auf Ganzzahl/////
if($insert != round($insert,0))
{
header("Location: " . $GLOBALS["BASEURL"] . $_SERVER["PHP_SELF"] ."?err=1");
die();
}
/////Prüfen auf Positiv/////
if($insert <= 0)
{
header("Location: " . $GLOBALS["BASEURL"] . $_SERVER["PHP_SELF"] ."?err=5");
die();
}
if ($insert > 100) $insert = 100;
/////Prüfen auf genug Upload,Ratio usw/////
$req=mysql_query("SELECT wbpoints FROM users WHERE id = {$CURUSER['id']}") or sqlerr(__FILE__, __LINE__);
$upl=mysql_fetch_assoc($req);
if($upl['wbpoints'] == 0)
{
// Keine Punkte mehr!
header("Location: " . $GLOBALS["BASEURL"] . $_SERVER["PHP_SELF"] ."?err=2");
}
/////Prüfen der Zeit/////
$sql="SELECT time FROM betting_games WHERE gid=".$_POST[gid];
$req=mysql_query($sql);
$r=mysql_fetch_assoc($req);
if(time() > $r[time])
{
header("Location: " . $GLOBALS["BASEURL"] . $_SERVER["PHP_SELF"] ."?err=3");
die();
}
/////Prüfen auf Vorhanden/////
$sql="SELECT * FROM betting_bet WHERE gid=".$_POST[gid]." AND uid=".$CURUSER[id];
$req=mysql_query($sql);
if(mysql_num_rows($req)>0)
{
header("Location: " . $GLOBALS["BASEURL"] . $_SERVER["PHP_SELF"] ."?err=4");
die();
}
/////Setzen des Einsatzes/////
$sql="INSERT INTO `betting_bet` (`uid`,`gid`,`tip`,`insert`) VALUES ('".intval($CURUSER[id])."','".intval($_POST[gid])."','".intval($_POST[tip])."','".$insert."')";
mysql_query($sql);
/////Abziehen des Uploads/////
mysql_query("Update users SET wbpoints = wbpoints -1 WHERE id = {$CURUSER['id']}") or sqlerr(__FILE__, __LINE__);
///// Setzen der Werte in der users /////
$sql="UPDATE users SET `bet_out`=`bet_out`+".$insert." WHERE id=".$CURUSER[id];
mysql_query($sql);
///// Setzen der Werte in der users /////
$sql="UPDATE users SET `bet_games`=`bet_games`+1 WHERE id=".$CURUSER[id];
mysql_query($sql);
/////Eintragen der GBs/////
$sql=" UPDATE `betting_games` SET `in` = `in`+'".$insert."' WHERE `gid` =".$_POST[gid];
mysql_query($sql);
header("Location: " . $GLOBALS["BASEURL"] . $_SERVER["PHP_SELF"] ."?bet=ok");
die();
///// Modcomment eintragen /////
write_modcomment($CURUSER["id"], 0, "Hat beim Wetten $insert GB gesetzt.");
}
stdhead("Wettbüro");
/////Anfang Tabellen bei bet!=OK/////
?>
<table summary="" cellpadding="4" cellspacing="1" border="0" style="width:100%" class="tableinborder">
<tr>
<td class="tabletitle" colspan="10" width="100%">
<center><b>Wettbüro</b></center>
</td>
</tr>
<tr><td width="100%" class="tablea"><center>
<?
/////Errorausgaben/////
$error = intval($_GET["err"]);
if($error == 1)
echo "<font color=\"#FF0000\">Der Einsatz ist keine runde Zahl</font>";
if($error == 2)
echo "<font color=\"#FF0000\">Du besitzt nicht genügend Upload oder deine Ratio ist bzw wird nach dem Einsatz zu schlecht</font>";
if($error == 3)
echo "<font color=\"#FF0000\">Der Einsatz wurde zu spät abgegeben</font>";
if($error == 4)
echo "<font color=\"#FF0000\">Du hast bei dieser Wette schon gewettet</font>";
if($error == 5)
echo "<font color=\"#FF0000\">Das war wohl nix ;)</font>";
/////Ende Einsatz OK/////
}
else
{
stdhead("Wettbüro");
/////Anfang Tabellen bei bet==ok/////
?>
<table summary="" cellpadding="4" cellspacing="1" border="0" style="width:100%" class="tableinborder">
<tr>
<td class="tabletitle" colspan="10" width="100%">
<center><b>Wettbüro</b></center>
</td>
</tr>
<tr>
<td width="100%" class="tablea"><center>
<?
/////Errorausgaben/////
$error = intval($_GET["err"]);
if($error == 1)
echo "<font color=\"#FF0000\">Der Einsatz ist keine runde Zahl</font>";
if($error == 2)
echo "<font color=\"#FF0000\">Du besitzt nicht genügend Upload oder deine Ratio ist bzw wird nach dem Einsatz zu schlecht</font>";
if($error == 3)
echo "<font color=\"#FF0000\">Der Einsatz wurde zu spät abgegeben</font>";
if($error == 4)
echo "<font color=\"#FF0000\">Du hast bei dieser Wette schon gewettet</font>";
if($error == 5)
echo "<font color=\"#FF0000\">Das war wohl nix ;)</font>";
/////Ende Einsatz OK/////
if(($_GET[bet]=="ok"))
echo "<font color=\"#FF0000\">Einsatz erfolgreich</font>";
}
if (get_user_class() >= UC_USER){
?>
<br />
<table width="85%" border="0" cellspacing="1" cellpadding="3" class="tableinborder">
<tr>
<td class="tableb" width="100%"><div align="center"><a href="betedit.php"><font color="#FF0000">Wetten Bearbeiten</font></a> | <a href="betoverview.php"><font color="#FF0000">Wettübersicht</font></a> | <a href="betclosed.php"><font color="#FF0000">Wetten beenden</font></a></div></td>
</tr>
</table>
<br />
<?
}
?>
<table summary="" cellpadding="4" cellspacing="1" border="0" style="width:85%" class="tableinborder">
<tr>
<td class="tabletitle" colspan="10" width="100%">
<center><b>Verfügbare Wetten</b></center>
</td>
</tr>
<tr>
<td width="100%" class="tablea">
<center>
<table summary="" width="100%" border="0" cellspacing="1" cellpadding="3" align="center" class="tableinborder">
<tr>
<td class=tablecat width=15%><center><b>Typ</b></center></td>
<td class=tablecat width=15%><center><b>Spielbeginn</b></center></td>
<td class=tablecat width=40%><center><b>Heim</b></center></td>
<td class=tablecat width=1> Heim </td>
<td class=tablecat width=1> Unent. </td>
<td class=tablecat width=1>Auswärts</td>
<td class=tablecat width=40%><center><b>Auswärts</b></center></td>
<td class=tablecat width=5%><center><b>Einsatz</b></center></td>
<td class=tablecat width=5%><center><b>User</b></center></td>
</tr>
<?
/////Anfang Verfügbare Wetten/////
$zeit = time()+300;
$sql = "SELECT * FROM betting_games WHERE time > ".$zeit." AND end = '0' ORDER BY time ASC";
$sql = "SELECT * FROM betting_games WHERE end = '0' ORDER BY time ASC";
$req = mysql_query($sql);
while($row = mysql_fetch_assoc($req))
{
$sql1 = "SELECT * FROM betting_bet WHERE uid = ".$CURUSER[id]." AND gid= ".$row[gid];
$req2 = mysql_query($sql1);
if(mysql_num_rows($req2) < 1)
{
$sql2 = "SELECT * FROM betting_bet WHERE gid=".$row[gid];
$r3 = mysql_query($sql2);
$datum = getdate($row[time]);
?>
<tr>
<form action="<?= $_SERVER["PHP_SELF"] ?>" method="post">
<input type="hidden" name="gid" value="<?=$row[gid];?>">
<input type="hidden" name="tippen" value="ok">
<td class=tablea><center><b><?=$row[type]?></b></center></td>
<td class=tablea><center><b><?=Tag($datum[weekday]).date(" j.m.Y G:i",$row[time])?></b></center></td>
<td class=tablea><center><b><?=$row[home];?></b></center></td>
<td class=tablea><center><input type="radio" name="tip" value="1"><?=$row[quote1]?></center></td>
<td class=tablea><center><input type="radio" name="tip" value="0"><?=$row[quote0]?></center></td>
<td class=tablea><center><input type="radio" name="tip" value="2"><?=$row[quote2]?></center></td>
<td class=tablea><center><b><?=$row[guest];?></b></center></td>
<td class=tablea><center><input type="text" name="insert" size="5"><br><input type="submit" value="Wetten"></center></td>
<td class=tablea><center><b><?=mysql_num_rows($r3) ?> User</b></center></td>
</form>
</tr>
<?
}
}
?>
</table>
</center>
</td></tr>
</table>
<br>
<?
/////Ende Verfügbare Wetten/////
/////Anfang laufende Wetten/////
?>
<table summary="" cellpadding="4" cellspacing="1" border="0" style="width:85%" class="tableinborder">
<tr>
<td class="tabletitle" colspan="10" width="100%">
<center><b>Laufende Wetten</b></center>
</td>
</tr>
<tr>
<td width="100%" class="tablea"><center>
<table summary="" width="100%" border="0" cellspacing="1" cellpadding="3" align="center" class="tableinborder">
<tr>
<td class=tablecat width=10%><center><b>Typ</b></center></td>
<td class=tablecat width=10%><center><b>Spielbeginn</b></center></td>
<td class=tablecat width=30%><center><b>Heim</b></center></td>
<td class=tablecat width=1><center><b>Tipp</b></center></td>
<td class=tablecat width=30%><center><b>Auswärts</b></center></td>
<td class=tablecat width=5%><center><b>Einsatz</b></center></td>
<td class=tablecat width=10%><center><b>Mögl.Gewinn</b></center></td>
<td class=tablecat width=5%><center><b>User</b></center></td>
</tr>
<?
$sql="SELECT * FROM betting_bet WHERE uid=".$CURUSER[id];
$req=mysql_Query($sql);
while($r=mysql_fetch_assoc($req))
{
$sql="SELECT * FROM betting_games WHERE gid=".$r[gid]." AND end=0";
$req2=mysql_Query($sql);
while($r2=mysql_fetch_assoc($req2))
{
if($r[tip]=="0")
$tip="U";
if($r[tip]=="1")
$tip="H";
if($r[tip]=="2")
$tip="A";
$sql8="SELECT * FROM betting_games WHERE time>".$zeit." AND gid=".$r[gid]." AND end=0 ORDER BY time ASC";
$req8=mysql_query($sql8);
while($row8=mysql_fetch_assoc($req8))
{
$datum = getdate($r2[time]);
$sql="SELECT * FROM betting_bet WHERE gid=".$r2[gid];
$r3=mysql_query($sql);
$sql="SELECT quote".$r[tip]." FROM betting_games WHERE gid=".$r2[gid];
$r4=mysql_query($sql);
$r4=mysql_fetch_assoc($r4);
?>
<tr>
<td class=tablea><center><b><?=$row8[type]?></b></center></td>
<td class=tablea><center><b><?=Tag($datum[weekday]).date(" j.m.Y G:i",$r2[time])?></b></center></td>
<td class=tablea><center><b><?=$r2[home];?></b></center></td>
<td class=tablea><center><b><?=$tip;?></b></center></td>
<td class=tablea><center><b><?=$r2[guest];?></b></center></td>
<td class=tablea><center><b><?=$r[insert];?> GB</b></center></td>
<td class=tablea><center><b><?=($r[insert]*$r4["quote".$r[tip]]) ?> GB</b></center></td>
<td class=tablea><center><b><?=mysql_num_rows($r3) ?> User</b></center></td>
</tr>
<?
}
}
}
?>
</table>
</center>
</td></tr>
</table>
<br>
<?
/////Ende laufende Wetten/////
/////Anfang beendete Wetten/////
?>
<table summary="" cellpadding="4" cellspacing="1" border="0" style="width:85%" class="tableinborder">
<tr>
<td class="tabletitle" colspan="10" width="100%">
<center><b>Beendete Wetten</b></center>
</td>
</tr>
<tr>
<td width="100%" class="tablea"><center>
<table summary="" width="100%" border="0" cellspacing="1" cellpadding="3" align="center" class="tableinborder">
<tr>
<td class=tablecat width=15%><center><b>Typ</b></center></td>
<td class=tablecat width=32%><center><b>Heim</b></center></td>
<td class=tablecat width=10%><center><b>Ergebnis</b></center></td>
<td class=tablecat width=32%><center><b>Auswärts</b></center></td>
<td class=tablecat width=10%><center><b>Gewinner</b></center></td>
<td class=tablecat width=32%><center><b>Einnahmen</b></center></td>
<td class=tablecat width=10%><center><b>Ausgaben</b></center></td>
</tr>
<?
$sql="SELECT * FROM betting_games WHERE end=1 AND time>".(time()-(60*60*24*7));
$req=mysql_Query($sql);
while($r=mysql_fetch_assoc($req)){
?>
<tr>
<td class=tablea><center><b><?=$r[type]?></b></center></td>
<td class=tablea><center><b><?=$r[home];?></b></center></td>
<td class=tablea><center><b><?=$r[p_home].":".$r[p_guest];?></b></center></td>
<td class=tablea><center><b><?=$r[guest];?></b></center></td>
<?
if($r[p_home] == $r[p_guest]){
$tipp=0;
}
if($r[p_home] > $r[p_guest]){
$tipp=1;
}
if($r[p_home] < $r[p_guest]){
$tipp=2;
}
$sql="SELECT * FROM betting_bet WHERE gid=".$r[gid]." AND tip=".$tipp;
$wins=mysql_num_rows(mysql_query($sql));
?>
<td class=tablea><center><b><?=$wins;?> User</b></center></td>
<td class=tablea><center><b><?=$r[in];?> GB</b></center></td>
<td class=tablea><center><b><?=$r[out];?> GB</b></center></td>
</tr>
<?
}
echo "</table></center></td></tr></table><br>";
/////Ende beendete Wetten/////
?>
<table summary="" cellpadding="4" cellspacing="1" border="0" style="width:65%" class="tableinborder">
<tr>
<td class="tabletitle" colspan="10" width="100%">
<center><b>Regeln</b></center>
</td>
</tr><tr>
<td class=tablea>
Jeder User kann pro Spiel nur einmal Wetten
<br><br>
Der Mindesteinsatz beträgt 1GB und das Maximum 100GB
<br><br>
Der Einsatz wird sofort vom Upload abgezogen
<br><br>
Letzter möglicher Einsatz ist 5 Minuten vor Spielbeginn
<br><br>
Eine gesetzte Wette kann nicht zurückgezogen werden
<br><br>
Beendete Wetten werden 1 Woche lang angezeigt
<br><br>
Wenn ein User gewinnt wird der Einsatz mit der Quote multipliziert und bekommt es sofort gut geschrieben.
<br><br>
</td>
</tr>
</table>
</center>
</td></tr>
</table>
<?
stdfoot();
?> betclosed.php PHP-Code: <?php
require_once("datas/function.php");
dbconn();
loggedinorreturn();
if(get_user_class() < UC_SYSOP)
{
stderr("Error", "Wo willst du Knilch eigendlich hin?? Das geht Dich hier garnix an!!");
exit();
}
stdhead("Wettbüro-Auszahlung");
print("<table summary=\"\" cellpadding=\"4\" cellspacing=\"1\" border=\"0\" style=\"width:100%\" class=\"tableinborder\">\n");
print(" <tr>\n");
print(" <td class=\"tabletitle\" colspan=\"10\" width=\"100%\">\n");
print(" <center><b>Wettbüro -- Gewinnauszahlung</b></center>\n");
print(" </td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td class=\"tabletitle\"><center>Wette</center></td>\n");
print(" <td class=\"tabletitle\"><center>User</center></td>\n");
print(" <td class=\"tabletitle\"><center>Einsatz</center></td>\n");
print(" <td class=\"tabletitle\"><center>Gewinn</center></td>\n");
print(" <td class=\"tabletitle\"><center>Gutschrift</center></td>\n");
print(" </tr>\n");
$games = "SELECT * FROM betting_games WHERE end = 1";
$res_games = mysql_query($games) or sqlerr(__FILE__,__LINE__);
while ($arr_games = mysql_fetch_array($res_games))
{
if($arr_games[p_home] == $arr_games[p_guest])
$tipp=0;
elseif($arr_games[p_home] > $arr_games[p_guest])
$tipp=1;
elseif($arr_games[p_home] < $arr_games[p_guest])
$tipp=2;
$liste = "SELECT * FROM betting_bet WHERE gid = " . $arr_games["gid"]." AND tip=" . $tipp;
$res_liste = mysql_query($liste) or sqlerr(__FILE__,__LINE__);
while ($arr_liste = mysql_fetch_array($res_liste))
{
$user = "SELECT id, username, class, enabled, warned, donor, closed_gid FROM users WHERE id = " . $arr_liste["uid"] . " LIMIT 1";
$res_user = mysql_query($user) or sqlerr(__FILE__,__LINE__);
$arr_user = mysql_fetch_array($res_user);
switch ($arr_liste["tip"])
{
case 0 : $gewinn = $arr_liste["insert"] * $arr_games["quote0"];
$quote = $arr_games["quote0"];
break;
case 1 : $gewinn = $arr_liste["insert"] * $arr_games["quote1"];
$quote = $arr_games["quote1"];
break;
case 2 : $gewinn = $arr_liste["insert"] * $arr_games["quote2"];
$quote = $arr_games["quote2"];
break;
}
$link = $_SERVER["PHP_SELF"] . "?action=bonus&id=" . $arr_liste["uid"] . "&bonus=" . $gewinn . "&game=" . $arr_games["gid"] . "&einsatz=" . $arr_liste["insert"];
$icons = array("enabled" => $r1["enabled"], "warned" => $r1["warned"], "donor" => $r1["donor"]);
$name = "<a href=userdetails.php?id=".htmlentities($arr_user["id"]). "><font class=".get_class_color($arr_user["class"]).">".htmlentities($arr_user["username"])."</a> " .get_user_icons($icons). "";
print(" <tr>\n");
print(" <td class=\"tablea\">" . $arr_games["gid"] . "</td>\n");
print(" <td class=\"tablea\">" . $name . "</td>\n");
print(" <td class=\"tablea\">" . mksize($arr_liste["insert"] * 1024 * 1024 * 1024) . "</td>\n");
print(" <td class=\"tablea\">" . mksize($gewinn) . " ( <font color=\"#FF0000\">" . $quote ."</font> )</td>\n");
if ($arr_user["closed_gid"] == $arr_games["gid"] OR $arr_games["gid"] == $arr_liste["closed_gid"])
print(" <td class=\"tablea\"><center><font color=\"#FF0000\">Schon bekommen</font></center></td>\n");
else
print(" <td class=\"tablea\"><center><a href=\"" . $link ."\"><font color=\"#008000\">Gutschrift</font></a></center></td>\n");
print(" </tr>\n");
}
}
print("</table>\n");
print("<br />");
print("<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"3\" class=\"tableinborder\">");
print(" <tr>");
print(" <td class=\"tableb\" width=\"100%\"><div align=\"center\"><a href=\"betedit.php\"><font color=\"#FF0000\">Wetten Bearbeiten</font></a> | <a href=\"betoverview.php\"><font color=\"#FF0000\">Wettübersicht</font></a> | <a href=\"bet.php\"><font color=\"#FF0000\">Wetten</font></a></div></td>");
print(" </tr>");
print("</table>");
print("<br />");
if (htmlentities($_GET["action"]) == "bonus")
{
$userid = intval($_GET["id"]);
$bonus = floatval($_GET["bonus"]);
$out = intval($_GET["einsatz"]);
$game = intval($_GET["game"]);
$sql_user = "UPDATE users SET wbpoints = wbpoints + " . $bonus . ", closed_gid = " . $game . " WHERE id = " . $userid . " LIMIT 1"; $sql_bonus = "UPDATE `betting_games` SET `out` = `out` + '" . $out . "' WHERE `gid` = " . $game . " LIMIT 1";
$sql_game = "UPDATE `betting_bet` SET `closed_gid` = " . $game . " WHERE uid = " . $userid . " AND gid = " . $game . " LIMIT 1";
//$sql_game = "DELETE FROM betting_bet WHERE gid = " . $game . " AND uid = " . $userid . " LIMIT 1";
$sql_spiel = "SELECT home, guest FROM betting_games WHERE gid = " . $game . " LIMIT 1";
$res_spiel = mysql_query($sql_spiel) or sqlerr(__FILE__,__LINE__);
$spiel = mysql_fetch_array($res_spiel);
$partie = $spiel["home"] . " - " . $spiel["guest"];
$betreff = "Wettbüro";
$msg = "Du hast beim tippen " . $partie . " Glück gehabt und hast gewonnen, dein Gewinn (" . mksize($bonus) . ") wurde dir gutgeschrieben. mfg Staff!";
sendPersonalMessage(0, $userid, $betreff, $msg, PM_FOLDERID_INBOX, 0);
write_modcomment(htmlentities($userid), 0, "Hat beim Wetten " . $partie . " (" . mksize($bonus) . ") gewonnen.");
$userr = "SELECT id, username FROM users WHERE id = " . $userid;
$res_userr = mysql_query($userr) or sqlerr(__FILE__,__LINE__);
$arr_userr = mysql_fetch_array($res_userr);
print("<table summary=\"\" cellpadding=\"4\" cellspacing=\"1\" border=\"0\" style=\"width:100%\" class=\"tableinborder\">\n");
print(" <tr>\n");
print(" <td class=\"tabletitle\" width=\"100%\">\n");
print(" <center><b>Bonus für " . $arr_userr["username"] . "</b></center>\n");
print(" </td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td class=\"tablea\" width=\"100%\">\n");
$result = mysql_query($sql_user) or sqlerr(__FILE__,__LINE__);
if ($result) print("<font color=\"green\">OK: Bonus (" . mksize($bonus) . ") für User " . $arr_userr["username"] . " erfolgreich</font><br />\n");
else print("<font color=\"red\">FEHLER: Bonus (" . mksize($bonus) . ") für User " . $arr_userr["username"] . " fehlgeschlagen</font><br />" . $sql_user . "\n");
$result = mysql_query($sql_bonus) or sqlerr(__FILE__,__LINE__);
if ($result) print("<font color=\"green\">OK: Gesamtbonus upgedatet</font><br />\n");
else print("<font color=\"red\">FEHLER: Gesamtbonus-Update fehlgeschlagen</font><br />" . $sql_bonus . "\n");
$result = mysql_query($sql_game) or sqlerr(__FILE__,__LINE__);
if ($result) print("<font color=\"green\">OK: Spiel für den User (" . $userid . ") geschlossen</font><br />\n");
else print("<font color=\"red\">FEHLER: Spiel für den User (" . $userid . ") nicht geschlossen</font><br />" . $sql_game . "\n");
//$result = mysql_query($sql_game) or sqlerr(__FILE__,__LINE__);
//if ($result) print("<font color=\"green\">OK: Wetteinsatz gelöscht</font><br />\n");
//else print("<font color=\"red\">FEHLER: Löschen des Wetteinsatzes fehlgeschlagen</font><br />" . $sql_game . "\n");
print(" </td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td class=\"tabletitle\" width=\"100%\">\n");
print(" <center><b><a href=\"" . $_SERVER["PHP_SELF"] . "\">Weiter</a></b></center>\n");
print(" </td>\n");
print(" </tr>\n");
print(" <td class=\"tablea\">\n");
print("</table>");
stdfoot(true);
exit;
}
stdfoot(true);
?>
betedit.php PHP-Code: <?php
require_once("datas/function.php");
dbconn();
loggedinorreturn();
if(get_user_class() < UC_SYSOP)
{
stderr("Error", "Wo willst du Knilch eigendlich hin?? Das geht Dich hier garnix an!!");
exit();
}
if(intval($_GET["id"]) != 0)
{
$titel = "Wette editieren";
$neu = FALSE;
$action = $_SERVER["PHP_SELF"] . "?id=" . intval($_GET[id]);
$topic = "Details zu Spiel Nr.: " . intval($_GET[id]);
$box = "<input type=\"hidden\" name=\"edit\" value=\"true\">";
$button = "<input type=\"submit\" value=\"Editieren\"></center>";
}
else
{
$titel = "Wette neu anlegen";
$neu = TRUE;
$action = $_SERVER["PHP_SELF"];
$topic = "Spiel neu erstellen";
$box = "<input type=\"hidden\" name=\"neu\" value=\"true\">";
$button = "<input type=\"submit\" value=\"Spiel anlegen\"></center>";
}
stdhead($titel);
?>
<table summary="" cellpadding="4" cellspacing="1" border="0" style="width:100%" class="tableinborder">
<tr>
<td class="tabletitle" colspan="10" width="100%">
<center><b><?=$titel?></b></center>
</td>
</tr>
<tr>
<td width="100%" class="tablea">
<center>
<?
if(!empty($_POST[edit]) && ($_POST[edit] == "true"))
{
/////Anfang Eintragen der Wette/////
/////Quote formatieren/////
$quote1 = str_replace(",",".",htmlentities($_POST[quote1]));
$quote0 = str_replace(",",".",htmlentities($_POST[quote0]));
$quote2 = str_replace(",",".",htmlentities($_POST[quote2]));
/////Eingabe überprüfen////// ([0-9]|\.)/
if($_POST[home]!="" && $_POST[guest]!="")
{
if(!preg_match("/[0-9.]/", $quote1) or !preg_match("/[0-9.]/", $quote1) or !preg_match("/[0-9.]/", $quote1))
{
echo "Fehler in der Eingabe";
}
else
{
if($_POST[home]!="" && $_POST[guest]!="")
{
$sql="UPDATE `betting_games` SET home='".$_POST[home]."' , guest='".$_POST[guest]."' , time='".(strtotime($_POST[jahr]."-".$_POST[monat]."-".$_POST[tag]." ".$_POST[stunde].":".$_POST[minute].":00"))."' , quote1='$quote1', quote0='$quote0', quote2='$quote2' , type='".$_POST[type]."', madeby='".$CURUSER[id]."', end='".$_POST[end]."', p_home='".$_POST[p_home]."', p_guest='".$_POST[p_guest]."' WHERE gid=".$_GET[id].";";
// print($sql);
mysql_query($sql);
}
}
}
print("<p>Erfolgreich editiert</p>");
print("<p><a href=\"betoverview.php\">Zurück zur Übersicht</a></p>");
print("<p><a href=\"" . $_SERVER["PHP_SELF"] . "\">eine weitere Wette anlegen</a></p>");
print("</center></td></tr></table>");
stdfoot();
exit;
/////Ende Eintragen der Wette/////
}
if(!empty($_POST[neu]) && ($_POST[neu] == "true"))
{
/////Anfang Eintragen der Wette/////
/////Quote formatieren/////
$quote1 = str_replace(",",".",htmlentities($_POST[quote1]));
$quote0 = str_replace(",",".",htmlentities($_POST[quote0]));
$quote2 = str_replace(",",".",htmlentities($_POST[quote2]));
/////Eingabe überprüfen////// ([0-9]|\.)/
if($_POST[home]!="" && $_POST[guest]!="")
{
if(!preg_match("/[0-9.]/", $quote1) or !preg_match("/[0-9.]/", $quote1) or !preg_match("/[0-9.]/", $quote1))
{
echo "Fehler in der Eingabe";
}
else
{
if($_POST[home]!="" && $_POST[guest]!="")
{
$home = htmlentities($_POST[home]);
$guest = htmlentities($_POST[guest]);
$time = (strtotime($_POST[jahr]."-".$_POST[monat]."-".$_POST[tag]." ".$_POST[stunde].":".$_POST[minute].":00"));
$quote1 = htmlentities($quote1);
$quote0 = htmlentities($quote0);
$quote2 = htmlentities($quote2);
$type = htmlentities($_POST[type]);
$sql="INSERT INTO betting_games (home,guest,time,quote1,quote0,quote2,type,madeby) VALUES ('$home','$guest','$time','$quote1','$quote0','$quote2','$type','$CURUSER[id]')";
// print($sql);
mysql_query($sql);
}
}
}
print("<p>Erfolgreich eingefügt</p>");
print("<p><a href=\"betoverview.php\">Zurück zur Übersicht</a></p>");
print("<p><a href=\"" . $_SERVER["PHP_SELF"] . "\">eine weitere Wette anlegen</a></p>");
print("</center></td></tr></table>");
stdfoot();
exit;
/////Ende Eintragen der Wette/////
}
if (!$neu)
{
$sql = "SELECT * FROM betting_games WHERE gid=".intval($_GET[id]);
$req = mysql_query($sql);
$r0 = mysql_fetch_assoc($req);
}
//Erstellen der Auswahlfelder
for($var=1;$var<32;$var++)
{
if ($var <= 9) $var = "0" . $var;
if($var==date("d",$r0[time]))
$sel=" selected";
else
$sel="";
$day=$day."<option".$sel.">".$var."</option>";
}
$day="<select name='tag' size='1'>".$day."</select>";
$sel="";
for($var=1;$var<13;$var++)
{
if ($var <= 9) $var = "0" . $var;
if($var==date("n",$r0[time])){
$sel=" selected";
}else{
$sel="";
}
$mon=$mon."<option".$sel.">".$var."</option>";
}
$mon="<select name='monat' size='1'>".$mon."</select>";
$sel="";
for($var=date("Y");$var<(date("Y")+2);$var++)
{
if($var==date("Y",$r0[time]))
$sel=" selected";
else
$sel="";
$yea=$yea."<option".$sel.">".$var."</option>";
}
$yea="<select name='jahr' size='1'>".$yea."</select>";
$sel="";
for($var=0;$var<24;$var++)
{
if ($var <= 9) $var = "0" . $var;
if($var==date("H",$r0[time]))
$sel=" selected";
else
$sel="";
$hou=$hou."<option".$sel.">".$var."</option>";
}
$hou="<select name='stunde' size='1'>".$hou."</select>";
$sel="";
for($var=0;$var<60;$var++)
{
if ($var <= 9) $var = "0" . $var;
if($var==date("i",$r0[time]))
$sel=" selected";
else
$sel="";
$min=$min."<option".$sel.">".$var."</option>";
}
$min="<select name='minute' size='1'>".$min."</select>";
$sel="";
?>
<table summary="" cellpadding="4" cellspacing="1" border="0" style="width:50%" class="tableinborder">
<tr>
<td class="tabletitle" colspan="10" width="100%">
<center><b><?=$topic?></b></center>
</td></tr>
<tr><td width="100%" class="tablea"><center>
<form action="<?= $action ?>" method="POST">
<table summary="" width="100%" border="0" cellspacing="1" cellpadding="3" align="center" class="tableinborder">
<tr>
<td class=tablea><b>Spielbeginn</b></td>
<td class=tablea><b><?=$day."-".$mon."-".$yea." - ".$hou.":".$min?></b></td>
</tr>
<tr>
<td class=tableb><b>Heim</b></td>
<td class=tableb><b><input type=text value="<?=$r0[home];?>" name=home></b></td>
</tr>
<tr>
<td class=tablea><b>Auswärts</b></td>
<td class=tablea><b><input type=text value="<?=$r0[guest];?>" name=guest></b></td>
</tr>
<tr>
<td class=tableb><b>Typ</b></td>
<td class=tableb><b>
<select name="type">
<option value="1.Bundesliga"<?=($r0[type] == "1.Bundesliga") ? " selected" : "" ?>>1.Bundesliga</option>
<option value="2.Bundesliga"<?=($r0[type] == "2.Bundesliga") ? " selected" : "" ?>>2.Bundesliga</option>
<option value="Champions League"<?=($r0[type] == "Champions League") ? " selected" : "" ?>>Champions League</option>
<option value="DFB Pokal"<?=($r0[type] == "DFB Pokal") ? " selected" : "" ?>>DFB Pokal</option>
<option value="UEFA Cup"<?=($r0[type] == "UEFA Cup") ? " selected" : "" ?>>UEFA Cup</option>
<option value="EM 2008"<?=($r0[type] == "EM 2008") ? " selected" : "" ?>>EM 2008</option>
</select></b></td>
</tr>
<tr>
<td class=tablea><b>Quote Heim</b></td>
<td class=tablea><b><input type=text value="<?=$r0[quote1];?>" name=quote1></b></td>
</tr>
<tr>
<td class=tableb><b>Quote Unendschieden</b></center></td>
<td class=tableb><b><input type=text value="<?=$r0[quote0];?>" name=quote0></b></td>
</tr>
<tr>
<td class=tablea><b>Quote Auswärts</b></center></td>
<td class=tablea><b><input type=text value="<?=$r0[quote2];?>" name=quote2></b></td>
</tr>
<tr>
<td class=tablea><b>Wette Beenden</b></td>
<td class=tablea><b><input type=text value="<?=($_GET["close"] == 1) ? "1" : $r0[end];?>" name=end> (Zum beenden eine <font color="#FF0000">1</font> setzen ansonsten <font color="#FF0000">leer</font> lassen)</b></td>
</tr>
<tr>
<td class=tablea><b>Endstand Heim</b></td>
<td class=tablea><b><input type=text value="<?=$r0[p_home];?>" name=p_home></b></td>
</tr>
<tr>
<td class=tablea><b>Endstand Gast</b></td>
<td class=tablea><b><input type=text value="<?=$r0[p_guest];?>" name=p_guest></b></td>
</tr>
<tr>
<td class="tabletitle" colspan="2">
<center><?=$box . $button?>
</td>
</tr>
</table>
</form>
<br><a href="betoverview.php"><font color="#FF0000">Zurück zur Übersicht</font></a> | <a href="bet.php"><font color="#FF0000">Zurück zu den Wetten</font></a> | <a href="betclosed.php"><font color="#FF0000">Wetten beenden</font></a>
</center></td></tr>
</table>
</center></td></tr></table>
<br>
<?
stdfoot();
?> betoverview.php PHP-Code: <?php
require_once("datas/function.php");
dbconn();
loggedinorreturn();
function Tag($tag)
{
switch($tag)
{
case "Monday" : return "Mo";
break;
case "Tuesday" : return "Di";
break;
case "Wednesday" : return "Mi";
break;
case "Thursday" : return "Do";
break;
case "Friday" : return "Fr";
break;
case "Saturday" : return "Sa";
break;
case "Sunday" : return "So";
break;
}
}
stdhead("Wettbürodetails");
if(get_user_class() < UC_SYSOP)
{
stderr("Error", "Wo willst du Knilch eigendlich hin?? Das geht Dich hier garnix an!!");
exit();
}
?>
<table cellpadding="4" cellspacing="1" border="0" style="width:100%" class="tableinborder">
<tr class="tabletitle" width="100%">
<td colspan="10" width="100%"><center>
<b>Wettbürodetails</b>
</center></td></tr>
<tr><td width="100%" class="tablea"><center>
<?
if(htmlentities($_GET["action"]) == "delete")
{
begin_frame("Wette Löschen");
$id = intval($_GET["id"]);
mysql_query("DELETE FROM betting_games WHERE gid = '$id'") or sqlerr(__FILE__,__LINE__);
mysql_query("DELETE FROM betting_bet WHERE gid = '$id'") or sqlerr(__FILE__,__LINE__);
?>
<table width="100%" border="0" cellspacing="1" cellpadding="4" class="tableinborder">
<tr>
<td class="tableb"><font color="#FF0000">Wette erfolgreich gelöscht.....</font> [<a href="<?=$_SERVER["PHP_SELF"] ?>">Weiter</a>]</td>
</tr>
</table>
<?
end_frame();
}
if($_GET[id]!=""){
?>
<table cellpadding="4" cellspacing="1" border="0" style="width:65%" class="tableinborder">
<tr class="tabletitle" width="100%">
<td colspan="10" width="100%"><center>
<b>Details zu Spiel Nr.: <?=$_GET[id]?></b>
</center></td></tr>
<tr><td width="100%" class="tablea"><center>
<table width="100%" border="0" cellspacing="1" cellpadding="3" align="center" class="tableinborder">
<tr>
<td class=tablecat width=14%><center><b>Spielbeginn</b></center></td>
<td class=tablecat width=14%><center><b>Heim</b></center></td>
<td class=tablecat width=14%><center><b>Ergebnis</b></center></td>
<td class=tablecat width=14%><center><b>Auswärts</b></center></td>
<td class=tablecat width=14%><center><b>Quote Heim</b></center></td>
<td class=tablecat width=14%><center><b>Quote Unendschieden</b></center></td>
<td class=tablecat width=14%><center><b>Quote Auswärts</b></center></td>
<td class=tablecat width=14%><center><b>Erstellt von</b></center></td>
</tr>
<?
$sql="SELECT * FROM betting_games WHERE gid=".$_GET[id];
$req0=mysql_query($sql);
while($r0=mysql_fetch_assoc($req0)){
$datum = getdate($r0[time]);
?>
<tr>
<td class=tablea><center><b><?=Tag($datum[weekday]).date(" j.m.Y G:i",$r0[time])?></b></center></td>
<td class=tablea><center><b><?=$r0[home];?></b></center></td>
<?
if($r0[end]=="0"){
$status="Noch nicht beendet";
}else{
$status=$r0[p_home].":".$r0[p_guest];
}
?>
<td class=tablea><center><b><?=$status;?></b></center></td>
<td class=tablea><center><b><?=$r0[guest];?></b></center></td>
<td class=tablea><center><b><?=$r0[quote1];?></b></center></td>
<td class=tablea><center><b><?=$r0[quote0];?></b></center></td>
<td class=tablea><center><b><?=$r0[quote2];?></b></center></td>
<?
$sql="SELECT id, username, class, enabled, warned, donor FROM users WHERE id=".$r0[madeby];
$req=mysql_query($sql);
$req=mysql_fetch_assoc($req);
$icons = array("enabled" => $req["enabled"], "warned" => $req["warned"], "donor" => $req["donor"]);
$name = "<a href=userdetails.php?id=".htmlentities($r0["madeby"]). "><font class=".get_class_color($req["class"]).">".htmlentities($req["username"])."</a> " .get_user_icons($icons). "";
?>
<td class=tablea><center><b><?=$name;?></b></center></td>
</tr>
<?
}
?>
</table>
<table width="60%" border="0" cellspacing="1" cellpadding="3" align="center" class="tableinborder">
<tr>
<td class=tablecat width=33%><center><b>User</b></center></td>
<td class=tablecat width=33%><center><b>Tipp</b></center></td>
<td class=tablecat width=33%><center><b>Einsatz</b></center></td>
</tr>
<?
$sql="SELECT * FROM betting_bet WHERE gid=".$_GET[id];
$req0=mysql_query($sql);
while($r0=mysql_fetch_assoc($req0)){
?>
<tr>
<?
$sql="SELECT id, username, class, enabled, warned, donor FROM users WHERE id=".$r0[uid];
$req1=mysql_query($sql);
$r1=mysql_fetch_assoc($req1);
$icons = array("enabled" => $r1["enabled"], "warned" => $r1["warned"], "donor" => $r1["donor"]);
$namee = "<a href=userdetails.php?id=".htmlentities($r0["uid"]). "><font class=".get_class_color($r1["class"]).">".htmlentities($r1["username"])."</a> " .get_user_icons($icons). "";
?>
<td class=tablea><center><b><a href=userdetails.php?id=<?=$r0[uid];?>><?=$namee?></a></b></center></td>
<td class=tablea><center><b><?=$r0[tip];?></b></center></td>
<td class=tablea><center><b><?=$r0[insert];?> GB</b></center></td>
</tr>
<?
}
?>
</table>
</table>
<br>
<br>
<?
}
?>
<table cellpadding="4" cellspacing="1" border="0" style="width:65%" class="tableinborder">
<tr class="tabletitle" width="100%">
<td colspan="10" width="100%"><center>
<b>Verfügbare Wetten</b>
</center></td></tr><tr><td width="100%" class="tablea"><center>
<table width="100%" border="0" cellspacing="1" cellpadding="3" align="center" class="tableinborder">
<tr>
<td class=tablecat><center><b>Spielbeginn</b></center></td>
<td class=tablecat><center><b>Heim</b></center></td>
<td class=tablecat><center><b>Auswärts</b></center></td>
<td class=tablecat><center><b>Status</b></center></td>
<td class=tablecat><center><b>Einnahmen</b></center></td>
<td class=tablecat><center><b>Ausgaben</b></center></td>
<td class=tablecat><center><b>Ergebnis</b></center></td>
<td class=tablecat><center><b>User</b></center></td>
<td class=tablecat><center><b>Details</b></center></td>
<td class=tablecat><center><b>Schließen</b></center></td>
<td class=tablecat><center><b>Editieren</b></center></td>
<td class=tablecat><center><b>Löschen</b></center></td>
</tr>
<?
// $sql="SELECT * FROM betting_games ORDER BY gid DESC";
$sql="SELECT * FROM betting_games ORDER BY time ASC";
$req=mysql_query($sql);
while($r=mysql_fetch_assoc($req)){
$datum = getdate($r[time]);
/////Anfang Status/////
if($r[end]==0){
$status="Laufend";
}else{
$status="Ende";
}
/////Ende Status/////
?>
<tr>
<td class=tablea><center><b><?=Tag($datum[weekday]).date(" j.m.Y G:i",$r[time])?></b></center></td>
<td class=tablea><center><b><?=$r[home];?></b></center></td>
<td class=tablea><center><b><?=$r[guest];?></b></center></td>
<td class=tablea><center><b><?=$status;?></b></center></td>
<td class=tablea><center><b><?=$r[in];?> GB</b></center></td>
<td class=tablea><center><b><?=$r[out];?> GB</b></center></td>
<td class=tablea><center><b><?=$r[p_home].":".$r[p_guest];?></b></center></td>
<?
$sql="SELECT * FROM betting_bet WHERE gid=".$r[gid];
$req2=mysql_query($sql);
$r2=mysql_num_rows($req2);
?>
<td class=tablea><center><b><?=$r2;?> User</b></center></td>
<td class=tablea><center><b><a href=<?=$PHP_SELF?>?id=<?=$r[gid]?>>Details</a></b></center></td>
<?
if((($r[madeby] == $CURUSER[id]) || (get_user_class() >= UC_ADMINISTRATOR)) && ($r[end]==0)){
$close="<a href=betedit.php?id=".$r[gid]."&close=1>Schließen</a>";
}else{
$close="<font color=\"red\">Nicht erlaubt</font>";
}
if((($r[madeby] == $CURUSER[id]) || (get_user_class() >= UC_ADMINISTRATOR)) && ($r[end]==0)){
$edit="<a href=betedit.php?id=".$r[gid].">Editieren</a>";
}else{
$edit="<font color=\"red\">Nicht erlaubt</font>";
}
if(($r[madeby] == $CURUSER[id]) || (get_user_class() >= UC_ADMINISTRATOR)){
$delete="<a href=$PHP_SELF?action=delete&id=".$r[gid].">Löschen</a>";
}else{
$delete="<font color=\"red\">Nicht erlaubt</font>";
}
?>
<td class=tablea><center><b><?=$close;?></b></center></td>
<td class=tablea><center><b><?=$edit;?></b></center></td>
<td class=tablea><center><b><?=$delete;?></b></center></td>
</tr>
<?
}
?>
<br />
<table width="100%" border="0" cellspacing="1" cellpadding="3" class="tableinborder">
<tr>
<td class="tableb" width="100%"><div align="center"><a href="betedit.php"><font color="#FF0000">Wetten Bearbeiten</font></a> | <a href="bet.php"><font color="#FF0000">Wetten</font></a> | <a href="betclosed.php"><font color="#FF0000">Wetten beenden</font></a></div></td>
</tr>
</table>
<?
stdfoot();
?>
mfg
onkel |
19.01.2012, 14:18
