PHP
hallo ik heb een poker script gevonden op het internet maar nu heb ik het online gezet en ik heb een fout met de kamers die ik moet maken ik denk dat da aan de sql liegt maar ik weet het niet zeker
PHP
<?
require('includes/gen_inc.php');
require('includes/inc_lobby.php');
?>
<html>
<head>
<title><? echo TITLE; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="css/poker.css" type="text/css">
<script language="JavaScript" type="text/JavaScript" src="js/lobby.php"></script>
</head>
<body bgcolor="#000000" text="#CCCCCC" onLoad="games();">
<table width="772" border="0" cellspacing="0" cellpadding="2" align="center" bgcolor="#1B1B1B">
<tr>
<td rowspan="2" valign="top" bgcolor="#333333">
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td>
<? require('includes/scores.php'); ?>
</td>
</tr>
<tr>
<td>
<table border="0" cellspacing="0" cellpadding="1" width="98%" class="smllfontpink" align="center" height="55">
<tr onMouseOver="this.bgColor = '#330000'; this.style.color = 'FFFFFF'" onMouseOut="this.bgColor = ''; this.style.color = 'CC9999'" onClick="changeview('index.php')" class="hand">
<td>
<? echo MENU_HOME; ?>
</td>
</tr>
<? if (($valid == false) && (MEMMOD == 0)){ ?>
<tr onMouseOver="this.bgColor = '#330000'; this.style.color = 'FFFFFF'" onMouseOut="this.bgColor = ''; this.style.color = 'CC9999'" onClick="changeview('login.php')" class="hand">
<td>
<? echo MENU_LOGIN; ?>
</td>
</tr>
<? } ?>
<? if ($valid == false){ ?>
<tr onMouseOver="this.bgColor = '#330000'; this.style.color = 'FFFFFF'" onMouseOut="this.bgColor = ''; this.style.color = 'CC9999'" onClick="changeview('create.php')" class="hand">
<td>
<? echo MENU_CREATE; ?>
</td>
</tr>
<? } ?>
<? if ($valid == true){ ?>
<tr onMouseOver="this.bgColor = '#330000'; this.style.color = 'FFFFFF'" onMouseOut="this.bgColor = ''; this.style.color = 'CC9999'" onClick="changeview('lobby.php')" class="hand">
<td>
<? echo MENU_LOBBY; ?>
</td>
</tr>
<tr onMouseOver="this.bgColor = '#330000'; this.style.color = 'FFFFFF'" onMouseOut="this.bgColor = ''; this.style.color = 'CC9999'" onClick="changeview('rankings.php')" class="hand">
<td>
<? echo MENU_RANKINGS; ?>
</td>
</tr>
<tr onMouseOver="this.bgColor = '#330000'; this.style.color = 'FFFFFF'" onMouseOut="this.bgColor = ''; this.style.color = 'CC9999'" onClick="changeview('myplayer.php')" class="hand">
<td>
<? echo MENU_MYPLAYER; ?>
</td>
</tr>
<? } ?>
<tr onMouseOver="this.bgColor = '#330000'; this.style.color = 'FFFFFF'" onMouseOut="this.bgColor = ''; this.style.color = 'CC9999'" onClick="changeview('rules.php')" class="hand">
<td>
<? echo MENU_RULES; ?>
</td>
</tr>
<tr onMouseOver="this.bgColor = '#330000'; this.style.color = 'FFFFFF'" onMouseOut="this.bgColor = ''; this.style.color = 'CC9999'" onClick="changeview('faq.php')" class="hand">
<td>
<? echo MENU_FAQ; ?>
</td>
</tr>
<? if ($ADMIN == true){ ?>
<tr onMouseOver="this.bgColor = '#330000'; this.style.color = 'FFFFFF'" onMouseOut="this.bgColor = ''; this.style.color = 'CC9999'" onClick="changeview('admin.php')" class="hand">
<td>
<? echo MENU_ADMIN; ?>
</td>
</tr>
<? } ?>
<? if (($valid == true) && (MEMMOD != 1)){ ?>
<tr onMouseOver="this.bgColor = '#330000'; this.style.color = 'FFFFFF'" onMouseOut="this.bgColor = ''; this.style.color = 'CC9999'" onClick="changeview('index.php?action=logout')" class="hand">
<td>
<? echo MENU_LOGOUT; ?>
</td>
<? } ?>
</table>
</td>
</tr>
</table>
</td>
<td width="650" class="fieldsethead">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td bgcolor="#333333"><b><font size="3"><i><? echo LOBBY; ?></i></font></b></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="650" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr class="fieldsetheadlink">
<td width="120"><b><? echo TABLE_HEADING_NAME; ?></b></td>
<td align="center" width="50"><b><? echo TABLE_HEADING_PLAYERS; ?></b></td>
<td align="center" width="80"><b><? echo TABLE_HEADING_TYPE; ?></b></td>
<td align="center" width="90"><b><? echo TABLE_HEADING_BUYIN; ?></b></td>
<td align="center" width="90"><b><? echo TABLE_HEADING_SMALL_BLINDS; ?></b></td>
<td align="center" width="90"><b><? echo TABLE_HEADING_BIG_BLINDS; ?></b></td>
<td align="center" width="80"><b><? echo TABLE_HEADING_STATUS; ?></b></td>
</tr>
</table>
<div id="gamelist" style="border : solid 0px padding : 1px; width : 100%; height : 365px; overflow : auto; ">
</div ><br><?
$tableq = mysql_query("select p1name, p2name,p3name,p4name,p5name,p6name,p7name,p8name,p9name,p10name,tablename,tablelimit,tabletype,hand,tablelow from ".DB_POKER." order by tablelimit asc ");
while($tabler = mysql_fetch_array($tableq)){
$i = 1;
$x=0;
while($i < 11){
if($tabler['p'.$i.'name'] != '') $x++;
$i++;
}
$tableplayers = $x.'/10';
$tablestatus = (($tabler['hand'] == '')? 'New Game' : 'Playing');
$tabletype = (($tabler['tabletype'] == 't')? 'Tournament' : 'Sit \'n Go');
?>
<? } ?>
</td>
</tr>
</table>
<p> </p>
</body>
</html>dit is de lobby waar de kamers normaal gezien moet worden door de leden
dit is de sql poker
PHP
CREATE TABLE IF NOT EXISTS `poker` (
`gameID` int(15) NOT NULL auto_increment,
`tablename` varchar(64) default '',
`tabletype` varchar(1) default '',
`tablelow` int(7) default '0',
`tablelimit` varchar(15) default '',
`tablestyle` varchar(20) default '',
`move` varchar(2) default '',
`dealer` varchar(2) default '',
`hand` varchar(5) default '',
`pot` int(10) default '0',
`bet` int(10) default '0',
`lastbet` varchar(15) default '',
`lastmove` int(35) default '0',
`card1` varchar(40) default '',
`card2` varchar(40) default '',
`card3` varchar(40) default '',
`card4` varchar(40) default '',
`card5` varchar(40) default '',
`p1name` varchar(12) default '',
`p1pot` varchar(10) default '',
`p1bet` varchar(10) default '',
`p1card1` varchar(40) default '',
`p1card2` varchar(40) default '',
`p2name` varchar(12) default '',
`p2pot` varchar(10) default '',
`p2bet` varchar(10) default '',
`p2card1` varchar(40) default '',
`p2card2` varchar(40) default '',
`p3name` varchar(12) default '',
`p3pot` varchar(10) default '',
`p3bet` varchar(10) default '',
`p3card1` varchar(40) default '',
`p3card2` varchar(40) default '',
`p4name` varchar(12) default '',
`p4pot` varchar(10) default '',
`p4bet` varchar(10) default '',
`p4card1` varchar(40) default '',
`p4card2` varchar(40) default '',
`p5name` varchar(12) default '',
`p5pot` varchar(10) default '',
`p5bet` varchar(10) default '',
`p5card1` varchar(40) default '',
`p5card2` varchar(40) default '',
`p6name` varchar(12) default '',
`p6pot` varchar(10) default '',
`p6bet` varchar(10) default '',
`p6card1` varchar(40) default '',
`p6card2` varchar(40) default '',
`p7name` varchar(12) default '',
`p7pot` varchar(10) default '',
`p7bet` varchar(10) default '',
`p7card1` varchar(40) default '',
`p7card2` varchar(40) default '',
`p8name` varchar(12) default '',
`p8pot` varchar(10) default '',
`p8bet` varchar(10) default '',
`p8card1` varchar(40) default '',
`p8card2` varchar(40) default '',
`p9name` varchar(12) default '',
`p9pot` varchar(10) default '',
`p9bet` varchar(10) default '',
`p9card1` varchar(40) default '',
`p9card2` varchar(40) default '',
`p10name` varchar(12) default '',
`p10pot` varchar(10) default '',
`p10bet` varchar(10) default '',
`p10card1` varchar(40) default '',
`p10card2` varchar(40) default '',
`msg` varchar(150) default '',
PRIMARY KEY (`gameID`)
) ENGINE=MyISAM AUTO_INCREMENT=448 DEFAULT CHARSET=latin1;ik hoop dat jullie een fout vinden site staat online op http://wantstopoker.host22.com/ gratis host
dit is inc lobby
PHP
<? if($valid == false) header('Location: login.php'); $gameID = addslashes($_GET['gameID']); if($gameID != ''){ $gq = mysql_query("select gameID from ".DB_POKER." where gameID = '".$gameID."' "); if(mysql_num_rows($gq) == 1){ $result = mysql_query("update ".DB_PLAYERS." set vID = '".$gameID."' where username = '".$plyrname."' "); header('Location: poker.php'); } } ?>
en dit is js lobby.php
PHP
var filesadded=""; var state1 = '#000000'; var state2 = '#FF0000'; function avatar(ava) { for(var i = 1; i < 17; i++) { var thiscell = document.getElementById('avatar'+i); if(ava == i) { createplyr.av.value = i; thiscell.style.backgroundColor = state2; }else{ thiscell.style.backgroundColor = state1 ;}}} function checkthis(msg) { var answer = confirm(msg); if (answer){ return true; }else{ return false;}} function games(){ var url = document.location.href; var xend = url.lastIndexOf("/") + 1; var base_url = url.substring(0, xend); thisurl = base_url + 'includes/live_games.php'; checkloadfile(thisurl, "js"); setTimeout("games()", 3000);} function selectgame(url) { window.location.href = url;} function changeview(url) { window.location.href = url;} function newavatar(av) { var url = 'myplayer.php?newavatar='+av; window.location.href = url;} function checkloadfile(filename, filetype){ if (filesadded.indexOf("["+filename+"]")==-1){
loadfile(filename, filetype); filesadded+="["+filename+"]"; }else{ replacefile(filename, filename, filetype);}} function loadfile(filename, filetype){ if (filetype=="js"){ var fileref=document.createElement('script'); fileref.setAttribute("type","text/javascript") ; fileref.setAttribute("src", filename) ; } else if (filetype=="css"){ var fileref=document.createElement ("link"); fileref.setAttribute("rel", "stylesheet") ; fileref.setAttribute("type", "text/css") ; fileref.setAttribute("href", filename); } if (typeof fileref!="undefined") document.getElementsByTagName("head")[0].appendChild(fileref); } function createfile(filename, filetype){ if (filetype=="js"){ var fileref=document.createElement('script'); fileref.setAttribute("type","text/javascript") ; fileref.setAttribute("src", filename); } return fileref ;} function replacefile(oldfilename, newfilename, filetype){ var targetelement=(filetype=="js")? "script" : (filetype=="css")? "link" : "none"; var targetattr=(filetype=="js")? "src" : (filetype=="css")? "href" : "none"; var allsuspects=document.getElementsByTagName(targetelement); for (var i=allsuspects.length; i>=0; i--){ if (allsuspects[i] && allsuspects[i].getAttribute(targetattr)!=null && allsuspects[i].getAttribute(targetattr).indexOf(oldfilename)!=-1){ var newelement=createfile(newfilename, filetype); allsuspects[i].parentNode.replaceChild(newelement, allsuspects[i]); } } }