DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<{$xoops_langcode}>" lang="<{$xoops_langcode}>">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />
<meta http-equiv="Content-Language" content="<{$xoops_langcode}>" />
<meta name="robots" content="<{$xoops_meta_robots}>" />
<meta name="keywords" content="<{$xoops_meta_keywords}>" />
<meta name="description" content="<{$xoops_meta_description}>" />
<meta name="rating" content="<{$xoops_meta_rating}>" />
<meta name="author" content="<{$xoops_meta_author}>" />
<meta name="copyright" content="<{$xoops_meta_copyright}>" />
<meta name="generator" content="XOOPS" />
<title><{$xoops_sitename}> - <{$xoops_pagetitle}>title>
<link href="<{$xoops_url}>/favicon.ico" rel="SHORTCUT ICON" />
<link rel="stylesheet" type="text/css" media="all" href="<{$xoops_url}>/xoops.css" />
<link rel="stylesheet" type="text/css" media="all" href="<{$xoops_themecss}>" />
<{$xoops_module_header}>
<script type="text/javascript">
script>
head>
<body bgcolor="#F2F4F7">
body>
<div align="center">
<img src="<{$xoops_url}>/themes/ND_BlueVibe/images/logo.gif" border="0" width="900" height="99">
div>
<body bgcolor="#F2F4F7">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" id="okvir" width="894">
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td id="headerlogo">
<table class="head_main" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td > td>
<td class="bok"> <{if $xoops_isuser}> Hello <{$xoops_uname}> <a href="<{$xoops_url}>/user.php"><span lang="fr">Your Accountspan> a> <{else}> <a href="<
{$xoops_url}%3E/register.php">
<span lang="fr">Registerspan> a>- <{/if}> <span class="right"> <{if $xoops_isuser}>
<a href="<{$xoops_url}>/user.php?op=logout">Logouta> <{else}><a href="<{$xoops_url}>/user.php">Logina>
<{/if}> span>td>
tr>table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="menu_top">
<a href="<{$xoops_url}>/index.php"><span lang="fr">Homespan>a> |
<a href="<{$xoops_url}>/modules/ipboard/"><span lang="fr">Forumspan>a> |
<a href="<{$xoops_url}>/modules/PDdownloads/"><span lang="fr">
Downloadsspan>a> |
<a href="<{$xoops_url}>/modules/myalbum/"><span lang="fr">Galleryspan>a>
td>
<td class="menu_top_ura"><span id="clock">span> <script language="JavaScript" type="text/javascript" src="<{$xoops_url}>/themes/ND_BlueVibe
/images/clock.js">
script> td>
tr>
table>
td>
tr>
table>
<table border="0" cellpadding="0" cellspacing="0" >
<td width="171" id="leftcolumn">
<{foreach item=block from=$xoops_lblocks}> <div class="<{cycle values="blockTitle"}>"><{$block.title}>div>
<div class="blockContent"><{$block.content}>div>
<img src="<{$xoops_imageurl}>images/160.gif" width="160" height="1" alt="" />
<{/foreach}>
<br /> <br />
td>
<td width="369" id="centercolumn" bgcolor="#e8f0f6">
<div align="center">
<script language="JavaScript">
images = new Array(2);
images[0] = "
";
images[1] = "
";
index = Math.floor(Math.random() * images.length);
document.write(images[index]);
script>
div>
<div align="right">Advertisingdiv>
<p align="left">
<{if $xoops_showcblock == 1}> p>
<table class="sadrzaj" cellspacing="0" bgcolor="#e8f0f6">
<tr>
<td id="centerCcolumn" colspan="2" bgcolor="#e8f0f6">
<{foreach item=block from=$xoops_ccblocks}> <table align="center" cellpadding="0" cellspacing="2" bgcolor="#e8f0f6">
<tr>
<td> <div class="blockTitle"><{$block.title}>div>
<div class="blockContent"><{$block.content}>div>td>
tr>
table>
<{/foreach}>
td>
tr>
<tr>
<td id="centerLcolumn">
<{foreach item=block from=$xoops_clblocks}> <table class="blok" align="center" cellpadding="3" cellspacing="2">
<tr>
<td> <div class="blockTitle"><{$block.title}>div>
<div class="blockContent"><{$block.content}>div>td>
tr>
table>
<{/foreach}>
td>
<td id="centerRcolumn">
<{foreach item=block from=$xoops_crblocks}> <table class="blok" align="center" cellpadding="3" cellspacing="2">
<tr>
<td> <div class="blockTitle"><{$block.title}>div>
<div class="blockContent"><{$block.content}>div>td>
tr>
table>
<{/foreach}>
td>
tr>
table>
<{/if}>
<div id="content"> <{$xoops_contents}> div>
<br /> <br /> <br /> td>
<{if $xoops_showrblock == 1}>
<td width="170" id="rightcolumn">
<{foreach item=block from=$xoops_rblocks}> <div class="blockTitle"><{$block.title}>div>
<div class="blockContent"><{$block.content}>div>
<img src="<{$xoops_imageurl}>images/160.gif" width="160" height="1" alt="" />
<{/foreach}>
<br /> <br /> td>
<{/if}> tr>
<tr>
<td colspan="3">td>
tr>
table>
<div align="center">
<TABLE width="100%"
border=0 cellPadding=0 cellSpacing=0 bgcolor="#F2F4F7">
<TBODY>
<TR>
<TD width=21><IMG
src="<{$xoops_url}>/themes/ND_BlueVibe
/images/bot_cat_left.gif"
border=0>TD>
<TD align=middle width="100%"
background="<{$xoops_url}>/themes/ND_BlueVibe
/images/bot_cat_bg.gif">TD>
<TD width=21><IMG
src="<{$xoops_url}>/themes/ND_BlueVibe
/images/bot_cat_right.gif"
border=0>TD>TR>TBODY>TABLE>div>
td>
tr>
table>
div>
<div class="privatnost">
<br />
<{$xoops_footer}>
<br />
div>
body>
html>
//Meta Redirect
echo "";
echo "";
echo "";
//Get XOOPS Stuff
include "../../../include/cp_header.php";
xoops_cp_header();
//Retrieve Data from Form
$cid = $_POST['cid'];
$pic = $_POST['pic'];
//Set MySQL Table
$table = $xoopsDB->prefix( "bf2stats" ) ;
//Update Table
if (isset($cid)) {
$xoopsDB->query("UPDATE `$table` SET `cid` = '$cid', `pic` = '$pic' WHERE `wid` = '1' LIMIT 1");
}
if (empty($cid)) {
$cid = "Value Empty!";
$emp = "1";
}
if (empty($pic)) {
$pic = "Value Empty!";
$emp = "1";
}
OpenTable();
?>
Battlefield 2 Stats Supplied By bf2tracker.com
You will be redirected back to the main page in 5 seconds.
echo "$pic" ;
echo "$cid" ;
?>
if ($emp === '1') { echo "Database Was Not Updated because one or more
variables are missing."; }
if (empty($emp)) { echo "Database Was successfully updated."; }
?>
BF2 Tracker Clan ID
echo $cid ?>
Display Pictures on Side
echo $pic ?>
CloseTable();
xoops_cp_footer();
?>
Now i know the data gets to it from the other form, and it all works, except it doesn't update the database.
Any Ideas?