Re: BlackJack for Yuna Scatari v2.0 PRE7 [req]
in database pu this
Code:
CREATE TABLE `blackjack` (
`userid` int(11) NOT NULL default '0',
`points` int(11) NOT NULL default '0',
`status` enum('playing','waiting') NOT NULL default 'playing',
`cards` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM;
CREATE TABLE `cards` (
`id` int(11) NOT NULL auto_increment,
`points` int(11) NOT NULL default '0',
`pic` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
INSERT INTO `cards` VALUES (1, 2, '2p.bmp');
INSERT INTO `cards` VALUES (2, 3, '3p.bmp');
INSERT INTO `cards` VALUES (3, 4, '4p.bmp');
INSERT INTO `cards` VALUES (4, 5, '5p.bmp');
INSERT INTO `cards` VALUES (5, 6, '6p.bmp');
INSERT INTO `cards` VALUES (6, 7, '7p.bmp');
INSERT INTO `cards` VALUES (7, 8, '8p.bmp');
INSERT INTO `cards` VALUES (8, 9, '9p.bmp');
INSERT INTO `cards` VALUES (9, 10, '10p.bmp');
INSERT INTO `cards` VALUES (10, 10, 'vp.bmp');
INSERT INTO `cards` VALUES (11, 10, 'dp.bmp');
INSERT INTO `cards` VALUES (12, 10, 'kp.bmp');
INSERT INTO `cards` VALUES (13, 1, 'tp.bmp');
INSERT INTO `cards` VALUES (14, 2, '2b.bmp');
INSERT INTO `cards` VALUES (15, 3, '3b.bmp');
INSERT INTO `cards` VALUES (16, 4, '4b.bmp');
INSERT INTO `cards` VALUES (17, 5, '5b.bmp');
INSERT INTO `cards` VALUES (18, 6, '6b.bmp');
INSERT INTO `cards` VALUES (19, 7, '7b.bmp');
INSERT INTO `cards` VALUES (20, 8, '8b.bmp');
INSERT INTO `cards` VALUES (21, 9, '9b.bmp');
INSERT INTO `cards` VALUES (22, 10, '10b.bmp');
INSERT INTO `cards` VALUES (23, 10, 'vb.bmp');
INSERT INTO `cards` VALUES (24, 10, 'db.bmp');
INSERT INTO `cards` VALUES (25, 10, 'kb.bmp');
INSERT INTO `cards` VALUES (26, 1, 'tb.bmp');
INSERT INTO `cards` VALUES (27, 2, '2k.bmp');
INSERT INTO `cards` VALUES (28, 3, '3k.bmp');
INSERT INTO `cards` VALUES (29, 4, '4k.bmp');
INSERT INTO `cards` VALUES (30, 5, '5k.bmp');
INSERT INTO `cards` VALUES (31, 6, '6k.bmp');
INSERT INTO `cards` VALUES (32, 7, '7k.bmp');
INSERT INTO `cards` VALUES (33, 8, '8k.bmp');
INSERT INTO `cards` VALUES (34, 9, '9k.bmp');
INSERT INTO `cards` VALUES (35, 10, '10k.bmp');
INSERT INTO `cards` VALUES (36, 10, 'vk.bmp');
INSERT INTO `cards` VALUES (37, 10, 'dk.bmp');
INSERT INTO `cards` VALUES (38, 10, 'kk.bmp');
INSERT INTO `cards` VALUES (39, 1, 'tk.bmp');
INSERT INTO `cards` VALUES (40, 2, '2c.bmp');
INSERT INTO `cards` VALUES (41, 3, '3c.bmp');
INSERT INTO `cards` VALUES (42, 4, '4c.bmp');
INSERT INTO `cards` VALUES (43, 5, '5c.bmp');
INSERT INTO `cards` VALUES (44, 6, '6c.bmp');
INSERT INTO `cards` VALUES (45, 7, '7c.bmp');
INSERT INTO `cards` VALUES (46, 8, '8c.bmp');
INSERT INTO `cards` VALUES (47, 9, '9c.bmp');
INSERT INTO `cards` VALUES (48, 10, '10c.bmp');
INSERT INTO `cards` VALUES (49, 10, 'vc.bmp');
INSERT INTO `cards` VALUES (50, 10, 'dc.bmp');
INSERT INTO `cards` VALUES (51, 10, 'kc.bmp');
INSERT INTO `cards` VALUES (52, 1, 'tc.bmp');
then creat BlackJack.php
Code:
<?
require_once("include/bittorrent.php");
dbconn(false);
loggedinorreturn();
function get_user_name($userid){
$r = mysql_query("select username from users where id=$userid");
$a = mysql_fetch_array($r);
return "$a[username]";
}
/*function playerexists($userid){
$r = mysql_query("select count(*) from casino where userid=$userid");
$a = mysql_fetch_array($r);
if ($a[0] > 0) return true;
else return false;
}*/
$mb = 1024*1024*100;//bet size
if ($_POST["game"]){
$cardcountres = mysql_query("select count(id) from cards") or sqlerr(__FILE__, __LINE__);
$cardcountarr = mysql_fetch_array($cardcountres);
$cardcount = $cardcountarr[0];
if ($_POST["game"] == 'start'){
if($CURUSER["uploaded"] < $mb)
stderr("Sorry ".$CURUSER["username"],"You didn't uploaded ".mksize($mb));
$required_ratio = 0.3;
if ($CURUSER["downloaded"] > 0)
$ratio = number_format($CURUSER["uploaded"] / $CURUSER["downloaded"], 2);
else
if ($CURUSER["uploaded"] > 0)
$ratio = 999;
else
$ratio = 0;
if($ratio < $required_ratio)
stderr("???????? ".$CURUSER["username"],"??? ??????? ?????? ??????????? ?????? ".$required_ratio);
$res = mysql_query("select count(*) from blackjack where userid=$CURUSER[id] and status='waiting'");
$arr = mysql_fetch_array($res);
if ($arr[0] > 0) {
stderr("?? ?????? ?????????, ???? ???-?????? ?? ??????? ? ????..");
}else{
$res = mysql_query("select count(*) from blackjack where userid=$CURUSER[id] and status='playing'");
$arr = mysql_fetch_array($res);
if ($arr[0] > 0)
stderr("?? ??? ?? ????????? ?????????? ????. <form method=post name=form action=$phpself><input type=hidden name=game value=cont><input type=submit value='????????? ? ????'></form>");}
$cardid = rand(1,$cardcount);
$cardres = mysql_query("select * from cards where id=$cardid") or sqlerr(__FILE__, __LINE__);
$cardarr = mysql_fetch_array($cardres);
mysql_query("insert into blackjack (userid, points, cards) values($CURUSER[id], $cardarr[points], $cardid)") or sqlerr(__FILE__, __LINE__);
stdhead();
print("<h1>??????, <a href=userdetails.php?id=$CURUSER[id]>$CURUSER[username]</a>. ????? ????????? ???? mb?!</h1>\n");
print("<table cellspacing=0 cellpadding=3 width=600>\n");
print("<tr><td colspan=2 cellspacing=0 cellpadding=5 >");
print("<form name=blackjack method=post action=$phpself>");
print("<table class=message width=100% cellspacing=0 cellpadding=5 bgcolor=white>\n");
print("<tr><td align=center><img src=pic/cards/".$cardarr["pic"]." border=0></td></tr>");
print("<tr><td align=center>???? = $cardarr[points]</td></tr>");
print("<tr><td align=center><input type=hidden name=game value=cont><input type=submit value='??? ?????'></td></tr>");
print("</table>
");
print("</form>");
print("</td></tr></table>
");
stdfoot();
}
elseif ($_POST["game"] == 'cont'){
$playeres = mysql_query("select * from blackjack where userid=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
$playerarr = mysql_fetch_array($playeres);
$showcards = "";
$cards = $playerarr["cards"];
$usedcards = explode(" ", $cards);
$arr = array();
foreach($usedcards as $array_list)
$arr[] = $array_list;
foreach($arr as $card_id)
{
$used_card = mysql_query("SELECT * FROM cards WHERE id='$card_id'") or sqlerr(__FILE__, __LINE__);
$used_cards = mysql_fetch_array($used_card);
$showcards .= "<img src=pic/cards/".$used_cards["pic"]." border=0> ";
$i++;
}
$cardid = rand(1,$cardcount);
while (in_array($cardid, $arr))
{
$cardid = rand(1,$cardcount);
}
$cardres = mysql_query("select * from cards where id=$cardid") or sqlerr(__FILE__, __LINE__);
$cardarr = mysql_fetch_array($cardres);
$showcards .= "<img src=pic/cards/".$cardarr["pic"]." border=0> ";
$points = $playerarr["points"] + $cardarr["points"];
$mysqlcards = "$playerarr[cards] $cardid";
mysql_query("update blackjack set points=points+$cardarr[points], cards='$mysqlcards' where userid=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
if ($points == 21){
$waitres = mysql_query("select count(*) from blackjack where status='waiting'");
$waitarr = mysql_fetch_array($waitres);
if ($waitarr[0] > 0){
$r = mysql_query("select * from blackjack where status='waiting' order by date asc LIMIT 1");
$a = mysql_fetch_assoc($r);
if ($a["points"] != 21){
$winorlose = "?? ???????? ".mksize($mb);
mysql_query("update users set uploaded = uploaded + $mb where id=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
mysql_query("update users set uploaded = uploaded - $mb where id=$a[userid]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set win = win + $mb where userid=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set lost = lost + $mb where userid=$a[userid]") or sqlerr(__FILE__, __LINE__);
mysql_query("delete from blackjack where userid=$CURUSER[id]");
mysql_query("delete from blackjack where userid=$a[userid]");
$dt = sqlesc(get_date_time());
$msg = sqlesc("?? ????????? ".mksize($mb)." $CURUSER[username] (? ??? $a[points], ? $CURUSER[username] 21 ????). ?????? ????");
mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $a[userid], $dt, $msg, 0)") or sqlerr(__FILE__, __LINE__);
}else{
$winorlose = "?????";
}
stderr("???? ????????", "? ??? 21 ????, ????? ????????? ??? ".get_user_name($a["userid"]).", ? $a[points] ?????? ?? ?????, $winorlose. <a href=blackjack.php>?????? ????</a>");
}
else{
mysql_query("update blackjack set status = 'waiting', date='".get_date_time()."' where userid = $CURUSER[id]") or sqlerr(__FILE__, __LINE__);
stderr("???? ????????", "? ??? 21 ????, ???? ??? ??? ?????? ???????. ??? ???????? ????????? ?????????. ?? ???????? ?? ? ??????????? ????");
}
}
elseif ($points > 21) {
$waitres = mysql_query("select count(*) from blackjack where status='waiting'");
$waitarr = mysql_fetch_array($waitres);
if ($waitarr[0] > 0){
$r = mysql_query("select * from blackjack where status='waiting' order by date asc LIMIT 1");
$a = mysql_fetch_assoc($r);
if ($a["points"] == $points){
$winorlose = "?????!";
mysql_query("delete from blackjack where userid=$CURUSER[id]");
mysql_query("delete from blackjack where userid=$a[userid]");
$dt = sqlesc(get_date_time());
$msg = sqlesc("????? ?????????? ??? $CURUSER[username], ???????? ??????! ?????? ????");
mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $a[userid], $dt, $msg, 0)") or sqlerr(__FILE__, __LINE__);}
elseif ($a["points"] > $points){
$winorlose = "?? ???????? ".mksize($mb);
mysql_query("update users set uploaded = uploaded + $mb where id=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
mysql_query("update users set uploaded = uploaded - $mb where id=$a[userid]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set win = win + $mb where userid=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set lost = lost + $mb where userid=$a[userid]") or sqlerr(__FILE__, __LINE__);
mysql_query("delete from blackjack where userid=$CURUSER[id]");
mysql_query("delete from blackjack where userid=$a[userid]");
$dt = sqlesc(get_date_time());
$msg = sqlesc("?? ????????? ".mksize($mb)." $CURUSER[username] (? ??? $a[points], ? $CURUSER[username] $points). ?????? ????");
mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $a[userid], $dt, $msg, 0)") or sqlerr(__FILE__, __LINE__);
}
elseif ($a["points"] < $points){
$winorlose = "?? ????????? ".mksize($mb);
mysql_query("update users set uploaded = uploaded - $mb where id=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
mysql_query("update users set uploaded = uploaded + $mb where id=$a[userid]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set win = win + $mb where userid=$a[userid]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set lost = lost + $mb where userid=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
mysql_query("delete from blackjack where userid=$CURUSER[id]");
mysql_query("delete from blackjack where userid=$a[userid]");
$dt = sqlesc(get_date_time());
$msg = sqlesc("?? ???????? ".mksize($mb)." ? $CURUSER[username] (? ??? $a[points], ? $CURUSER[username] $points). ?????? ???? ");
mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $a[userid], $dt, $msg, 0)") or sqlerr(__FILE__, __LINE__);
}
stderr("???? ????????", "? ??? $points, ????? ?????????? ??? ".get_user_name($a["userid"]).", ? $a[points] ?????? ?? ?????, $winorlose. <a href=blackjack.php>?????? ????</a>");
}
else
{
mysql_query("update blackjack set status = 'waiting', date='".get_date_time()."' where userid = $CURUSER[id]") or sqlerr(__FILE__, __LINE__);
stderr("???? ????????", "? ??? $points, ???? ??? ??? ?????? ???????. ??? ???????? ????????? ?????????. ?? ???????? ?? ? ??????????? ????");
}
}
else{
stdhead();
print("<h1>??????, <a href=userdetails.php?id=$CURUSER[id]>$CURUSER[username]</a>. ????? ????????? ???? mb?!</h1>\n");
print("<table cellspacing=0 cellpadding=3 width=600>\n");
print("<tr><td colspan=2 cellspacing=0 cellpadding=5 >");
print("<table class=message width=100% cellspacing=0 cellpadding=5 bgcolor=white>\n");
print("<tr><td align=center>$showcards</td></tr>");
print("<tr><td align=center>Points = $points</td></tr>");
print("<form name=blackjack method=post action=$phpself>");
print("<tr><td align=center><input type=hidden name=game value=cont><input type=submit value='??? ?????'></td></tr>");
print("</form>");
print("<form name=blackjack method=post action=$phpself>");
print("<tr><td align=center><input type=hidden name=game value=stop><input type=submit value='??????'></td></tr>");
print("</form>");
print("</table>
");
print("</td></tr></table>
");
stdfoot();
}
}elseif ($_POST["game"] == 'stop')
{
$playeres = mysql_query("select * from blackjack where userid=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
$playerarr = mysql_fetch_array($playeres);
$waitres = mysql_query("select count(*) from blackjack where status='waiting'");
$waitarr = mysql_fetch_array($waitres);
if ($waitarr[0] > 0){
$r = mysql_query("select * from blackjack where status='waiting' order by date asc LIMIT 1");
$a = mysql_fetch_assoc($r);
if ($a["points"] == $playerarr[points]){
$winorlose = "?????";
mysql_query("delete from blackjack where userid=$CURUSER[id]");
mysql_query("delete from blackjack where userid=$a[userid]");
$dt = sqlesc(get_date_time());
$msg = sqlesc("????? ?????????? ??? $CURUSER[username], ???????? ??????! ?????? ????");
mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $a[userid], $dt, $msg, 0)") or sqlerr(__FILE__, __LINE__);}
elseif ($a["points"] < $playerarr[points] && $a[points] < 21){
$winorlose = "?? ???????? ".mksize($mb);
mysql_query("update users set uploaded = uploaded + $mb where id=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
mysql_query("update users set uploaded = uploaded - $mb where id=$a[userid]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set win = win + $mb where userid=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set lost = lost + $mb where userid=$a[userid]") or sqlerr(__FILE__, __LINE__);
mysql_query("delete from blackjack where userid=$CURUSER[id]");
mysql_query("delete from blackjack where userid=$a[userid]");
$dt = sqlesc(get_date_time());
$msg = sqlesc("?? ????????? ".mksize($mb)." $CURUSER[username] (? ??? $a[points], ? $CURUSER[username] $playerarr[points]). ?????? ????");
mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $a[userid], $dt, $msg, 0)") or sqlerr(__FILE__, __LINE__);
}
elseif ($a["points"] > $playerarr[points] && $a[points] < 21){
$winorlose = "?? ????????? ".mksize($mb);
mysql_query("update users set uploaded = uploaded - $mb where id=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
mysql_query("update users set uploaded = uploaded + $mb where id=$a[userid]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set win = win + $mb where userid=$a[userid]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set lost = lost + $mb where userid=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
mysql_query("delete from blackjack where userid=$CURUSER[id]");
mysql_query("delete from blackjack where userid=$a[userid]");
$dt = sqlesc(get_date_time());
$msg = sqlesc("Ds dsquhfkb ".mksize($mb)." ? $CURUSER[username] (? ??? $a[points], ? $CURUSER[username] $playerarr[points]). ?????? ????");
mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $a[userid], $dt, $msg, 0)") or sqlerr(__FILE__, __LINE__);
}
elseif ($a["points"] == 21){
$winorlose = "?? ????????? ".mksize($mb);
mysql_query("update users set uploaded = uploaded - $mb where id=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
mysql_query("update users set uploaded = uploaded + $mb where id=$a[userid]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set win = win + $mb where userid=$a[userid]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set lost = lost + $mb where userid=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
mysql_query("delete from blackjack where userid=$CURUSER[id]");
mysql_query("delete from blackjack where userid=$a[userid]");
$dt = sqlesc(get_date_time());
$msg = sqlesc("?? ???????? ".mksize($mb)." ? $CURUSER[username] (? ??? $a[points], ? $CURUSER[username] $playerarr[points]). ?????? ????");
mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $a[userid], $dt, $msg, 0)") or sqlerr(__FILE__, __LINE__);
}
elseif ($a["points"] < $playerarr[points] && $a[points] > 21){
$winorlose = "?? ????????? ".mksize($mb);
mysql_query("update users set uploaded = uploaded - $mb where id=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
mysql_query("update users set uploaded = uploaded + $mb where id=$a[userid]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set win = win + $mb where userid=$a[userid]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set lost = lost + $mb where userid=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
mysql_query("delete from blackjack where userid=$CURUSER[id]");
mysql_query("delete from blackjack where userid=$a[userid]");
$dt = sqlesc(get_date_time());
$msg = sqlesc("?? ???????? ".mksize($mb)." ? $CURUSER[username] (? ??? $a[points], ? $CURUSER[username] $playerarr[points]). ?????? ????");
mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $a[userid], $dt, $msg, 0)") or sqlerr(__FILE__, __LINE__);
}
elseif ($a["points"] > $playerarr[points] && $a[points] > 21){
$winorlose = "?? ???????? ".mksize($mb);
mysql_query("update users set uploaded = uploaded + $mb where id=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
mysql_query("update users set uploaded = uploaded - $mb where id=$a[userid]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set win = win + $mb where userid=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
//mysql_query("update casino set lost = lost + $mb where userid=$a[userid]") or sqlerr(__FILE__, __LINE__);
mysql_query("delete from blackjack where userid=$CURUSER[id]");
mysql_query("delete from blackjack where userid=$a[userid]");
$dt = sqlesc(get_date_time());
$msg = sqlesc("?? ????????? ".mksize($mb)." $CURUSER[username] (? ??? $a[points], ? $CURUSER[username] $playerarr[points]). ?????? ????");
mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $a[userid], $dt, $msg, 0)") or sqlerr(__FILE__, __LINE__);
}
stderr("???? ????????", "? ??? $playerarr[points], ????? ?????????? ??? ".get_user_name($a["userid"]).", ? ???? $a[points], $winorlose <a href=blackjack.php>?????? ????</a>");
}
else
{
mysql_query("update blackjack set status = 'waiting', date='".get_date_time()."' where userid = $CURUSER[id]") or sqlerr(__FILE__, __LINE__);
stderr("???? ????????", "? ??? $points, ???? ??? ??? ?????? ???????. ??? ???????? ????????? ?????????. ?? ???????? ?? ? ??????????? ????");
}
}
}
else
{
//if (playerexists($CURUSER[id]) == false)
//mysql_query("insert into casino (userid, win, lost) values($CURUSER[id], 0, 0)") or sqlerr(__FILE__, __LINE__);
stdhead();
print("<h1>21 ????</h1>\n");
print("<table cellspacing=0 cellpadding=3 width=400>\n");
print("<tr><td colspan=2 cellspacing=0 cellpadding=5 align=center>");
//print("<h3><a href=players.php>Stats</a></h3>");
print("<table class=message width=100% cellspacing=0 cellpadding=10 bgcolor=white>\n");
print("<tr><td align=left><h3>???????</h3>?? ?????? ??????? ??????? ?????????? ?????, ??? ? ????????? (21)</td></tr>");
print("</table>
");
print("<form name=form method=post action=$phpself><input type=hidden name=game value=start><input type=submit class=btn value='?????!'>");
print("</td></tr></table>");
stdfoot();
}
?>
then download this and put in /pic/
[attachment=0:1uvqbcsq]cards.rar[/attachment:1uvqbcsq]
Sory but this is Russian.
|