WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė cropp· 2013 Gru. 8 12:12:32

Sveiki, reikia jūsų pagalbos turiu modą ant v6 fusioną jį pasiredagavęs pasileidau ant v7, tačiau nerodo vienos užklausos. Iš pradžių rodo fantasy sport ir latest game opentable, paspaudžius ant komandų nieko neišmeta

<a href='".FUSION_SELF."?game_id=".$data['game_id']."'>".$guest['team_name']." vs. ".$home['team_name']."</a>

, o turėtų išmesti šią dalį,

redirect(FUSION_SELF."?game_id=".$data['game_id']."&st=b");

} elseif(isset($game_id) && is_numeric($game_id)){

if($st == "b") echo "<b>Your bet was placed</b><br><br>";

opentable("Fantasy Sportsss");

$result = dbquery("SELECT * FROM ".DB_PREFIX."fs_games WHERE game_id='$game_id'");

if(!dbrows($result)) fallback(FUSION_SELF);

$data = dbarray($result);

$guest = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fs_teams WHERE team_id='".$data['game_guest']."'"));

$home = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fs_teams WHERE team_id='".$data['game_home']."'"));

echo "<table cellpadding='0' cellspacing='0' width='100%' class='tbl'>\n<tr>\n";

echo "<td>Namu Komanda:</td><td><a href='".FUSION_SELF."?team_id=".$home['team_id']."'>".$home['team_name']."</a></td></tr>";

echo "<tr>\n";

echo "<td>Sveciu Komanda:</td><td><a href='".FUSION_SELF."?team_id=".$guest['team_id']."'>".$guest['team_name']."</a></td></tr>";

echo "<tr>\n";

echo "<td>Laikas:</td><td>".$data['game_time']."</td></tr>";

echo "<tr>\n";

if($data['game_winner']){

$winner = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fs_teams WHERE team_id='".$data['game_winner']."'"));

echo "<td>Nugaletojas:</td><td>".$winner['team_name']."</td></tr>";

echo "<tr>\n";

}

echo "<td>Pagrindinis Laimejimas:</td><td>";

$jp = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fs_jackpot WHERE jackpot_game='".$data['game_id']."'"));

echo $jp['jackpot_jackpot']." pts.";

echo "</td></tr>";

echo "<tr>\n";

echo "</table>";

closetable();

if(iMEMBER){

tablebreak();

opentable("Bet");

if(!$data['game_winner']){

$ha = dbquery("SELECT * FROM ".DB_PREFIX."fs_bets WHERE bet_user='".$userdata['user_id']."' AND bet_game='".$data['game_id']."'");

if(dbrows($ha)) $had = dbarray($ha);

echo "<center><form action='".FUSION_SELF."' method='post'>";

echo "<input type='submit' name='guest' class='textbox' value='Bet 20pts on Guest";

if($had['bet_bet'] == $data['game_guest']) echo " √";

if($had) echo "' disabled='true";

echo "'> ";

echo "<input type='hidden' name='guest_id' value='".$data['game_guest']."'>";

echo "<input type='submit' name='home' class='textbox' value='La˛ybai 20tašku Namu Komandai";

if($had['bet_bet'] == $data['game_home']) echo " √";

if($had) echo "' disabled='true";

echo "'>";

echo "<input type='hidden' name='home_id' value='".$data['game_home']."'>";

echo "<input type='hidden' name='game_id' value='".$data['game_id']."'>";

echo "</form></center>";

} else {

echo "Statyti u˛drausta, laimetojas paskelbtas.";

}

closetable();

}

<?php
/*---------------------------------------------------+
| <span style="border-bottom: 1px dotted black;">PHP</span>-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2005 Nick Jones
| <a href='http://www.php-fusion.co.uk/' target='_blank'><span style='color:005C5B'>http://www.php-fusion.co.uk/</span></a>
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit <a href='http://gnu.org' target='_blank'><span style='color:005C5B'>http://gnu.org</span></a>
+----------------------------------------------------*/
require_once "../../maincore.php";
require_once THEMES."templates/header.php";
 
if(isset($_POST['home_id']) && is_numeric($_POST['home_id']) && isset($_POST['guest_id']) && is_numeric($_POST['guest_id']) && isset($_POST['game_id']) && is_numeric($_POST['game_id'])){
$result = dbquery("SELECT * FROM ".DB_PREFIX."fs_games WHERE game_id='".$_POST['game_id']."'");
if(!dbrows($result)) fallback(FUSION_SELF);
$data = dbarray($result);
if($_POST['guest']) $bet = $_POST['guest_id'];
if($_POST['home']) $bet = $_POST['home_id'];
$haha = dbquery("UPDATE ".DB_PREFIX."users SET user_points=user_points-20 WHERE user_id='".$userdata['user_id']."'");
$haha = dbquery("UPDATE ".DB_PREFIX."fs_jackpot SET jackpot_jackpot=jackpot_jackpot+20 WHERE jackpot_game='".$data['game_id']."'");
$query = dbquery("INSERT INTO ".DB_PREFIX."fs_bets VALUES('', '".$data['game_sport']."', '".$data['game_id']."', '".$userdata['user_id']."', '$bet')");
redirect(FUSION_SELF."?game_id=".$data['game_id']."&st=b");
} elseif(isset($game_id) && is_numeric($game_id)){
	if($st == "b") echo "<b>Your bet was placed</b><br><br>";
	opentable("Fantasy Sportsss");
	$result = dbquery("SELECT * FROM ".DB_PREFIX."fs_games WHERE game_id='$game_id'");
	if(!dbrows($result)) fallback(FUSION_SELF);
	$data = dbarray($result);
	$guest = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fs_teams WHERE team_id='".$data['game_guest']."'"));
	$home = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fs_teams WHERE team_id='".$data['game_home']."'"));
	echo "<table cellpadding='0' cellspacing='0' width='100%' class='tbl'>\n<tr>\n";
	echo "<td>Namu Komanda:</td><td><a href='".FUSION_SELF."?team_id=".$home['team_id']."'>".$home['team_name']."</a></td></tr>";
	echo "<tr>\n";
	echo "<td>Sveciu Komanda:</td><td><a href='".FUSION_SELF."?team_id=".$guest['team_id']."'>".$guest['team_name']."</a></td></tr>";
	echo "<tr>\n";
	echo "<td>Laikas:</td><td>".$data['game_time']."</td></tr>";
	echo "<tr>\n";
	if($data['game_winner']){
	$winner = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fs_teams WHERE team_id='".$data['game_winner']."'"));
	echo "<td>Nugaletojas:</td><td>".$winner['team_name']."</td></tr>";
	echo "<tr>\n";
	}
	echo "<td>Pagrindinis Laimejimas:</td><td>";
	$jp = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fs_jackpot WHERE jackpot_game='".$data['game_id']."'"));
	echo $jp['jackpot_jackpot']." pts.";
	echo "</td></tr>";
	echo "<tr>\n";
	echo "</table>";
	closetable();
	if(iMEMBER){
		tablebreak();
		opentable("Bet");
		if(!$data['game_winner']){
			$ha = dbquery("SELECT * FROM ".DB_PREFIX."fs_bets WHERE bet_user='".$userdata['user_id']."' AND bet_game='".$data['game_id']."'");
			if(dbrows($ha)) $had = dbarray($ha);
			echo "<center><form action='".FUSION_SELF."' method='post'>";
			echo "<input type='submit' name='guest' class='textbox' value='Bet 20pts on Guest";
			if($had['bet_bet'] == $data['game_guest']) echo " &radic;";
			if($had) echo "' disabled='true";
			echo "'> ";
			echo "<input type='hidden' name='guest_id' value='".$data['game_guest']."'>";
			echo "<input type='submit' name='home' class='textbox' value='La˛ybai 20tašku Namu Komandai";
			if($had['bet_bet'] == $data['game_home']) echo " &radic;";
			if($had) echo "' disabled='true";
			echo "'>";
			echo "<input type='hidden' name='home_id' value='".$data['game_home']."'>";
			echo "<input type='hidden' name='game_id' value='".$data['game_id']."'>";
			echo "</form></center>";
		} else {
			echo "Statyti u˛drausta, laimetojas paskelbtas.";
		}
		closetable();
	}	
 
} elseif(isset($team_id) && is_numeric($team_id)){
 
	$result = dbquery("SELECT * FROM ".DB_PREFIX."fs_games WHERE game_home='$team_id' OR game_guest='$team_id'");
	opentable("Fantasy Sports");
	if(dbrows($result)){
 
		$counter = 0; $columns = 2;
		echo "<table cellpadding='0' cellspacing='0' width='100%' class='tbl'>\n<tr>\n";
		while ($data = dbarray($result)) {
			$guest = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fs_teams WHERE team_id='".$data['game_guest']."'"));
			$home = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fs_teams WHERE team_id='".$data['game_home']."'"));
			if ($counter != 0 && ($counter % $columns == 0)) echo "</tr>\n<tr>\n";
			echo "<td align='center' valign='top' width='50%'><a href='".FUSION_SELF."?game_id=".$data['game_id']."'>".$guest['team_name']." vs. ".$home['team_name']."</a>";
			echo "</td>\n";
			$counter++;
		}
		echo "</tr>\n</table>\n";
 
	} else {
 
		echo "<center>Nera jokiu rungtyniu su šia komanda</center>";
 
	}
	closetable();
 
} elseif(isset($sport_id) && is_numeric($sport_id)){
 
	$result = dbquery("SELECT * FROM ".DB_PREFIX."fs_teams WHERE team_sport='$sport_id'");
	opentable("Fantasy Sports");
	if(dbrows($result)){
 
		$counter = 0; $columns = 2;
		echo "<table cellpadding='0' cellspacing='0' width='100%' class='tbl'>\n<tr>\n";
		while ($data = dbarray($result)) {
			if ($counter != 0 && ($counter % $columns == 0)) echo "</tr>\n<tr>\n";
			echo "<td align='center' valign='top' width='50%'><a href='".FUSION_SELF."?team_id=".$data['team_id']."'>".$data['team_name']."</a>";
			echo "</td>\n";
			$counter++;
		}
		echo "</tr>\n</table>\n";
 
	} else {
 
		echo "<center>Nera jokiu komandu šioje kategorijoje.</center>";
 
	}
	closetable();
 
} else {
 
	$result = dbquery("SELECT * FROM ".DB_PREFIX."fs_sports");
	opentable("Fantasy Sports");
	if(dbrows($result)){
 
		$counter = 0; $columns = 2;
		echo "<table cellpadding='0' cellspacing='0' width='100%' class='tbl'>\n<tr>\n";
		while ($data = dbarray($result)) {
			if ($counter != 0 && ($counter % $columns == 0)) echo "</tr>\n<tr>\n";
			echo "<td align='center' valign='top' width='50%'>";
			echo "<img src='icons/".$data['sport_icon']."'> ";
			echo "<a href='".FUSION_SELF."?sport_id=".$data['sport_id']."'>".$data['sport_name']."</a>";
			echo "</td>\n";
			$counter++;
		}
		echo "</tr>\n</table>\n";
 
	} else {
 
		echo "<center>Nera jokiu sporto kategoriju</center>";
 
	}
	closetable();
 
}
 
tablebreak();
opentable("Latest Games");
if(isset($sport_id) && is_numeric($sport_id)) $game = "WHERE game_sport='$sport_id'";
if(isset($team_id) && is_numeric($team_id)) $game = "WHERE game_home='$team_id'";
$result = dbquery("SELECT * FROM ".DB_PREFIX."fs_games ".$game." ORDER BY game_id DESC");
if(dbrows($result)){
 
	$counter = 0; $columns = 1;
	echo "<table cellpadding='0' cellspacing='0' width='100%' class='tbl'>\n<tr>\n";
	while ($data = dbarray($result)) {
		$guest = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fs_teams WHERE team_id='".$data['game_guest']."'"));
		$home = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fs_teams WHERE team_id='".$data['game_home']."'"));
		if ($counter != 0 && ($counter % $columns == 0)) echo "</tr>\n<tr>\n";
		echo "<td align='center' valign='top' width='50%'><a href='".FUSION_SELF."?game_id=".$data['game_id']."'>".$guest['team_name']." vs. ".$home['team_name']."</a>";
		echo "</td>\n";
		$counter++;
	}
	echo "</tr>\n</table>\n";
 
} else {
 
	echo "<center>Nera jokiu artejanciu rungtyniu</center>";
 
}
closetable();
 
require_once THEMES."templates/footer.php";
?>