Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Bėdelė.

Parašė Bruksnys· 2011 Rugp. 27 14:08:30
#16

<?php
/*--------------------------- ------+

+----------------------------------*/
require_once "../../maincore.php";
require_once "../../subheader.php";
require_once "../../side_left.php";


function addpts1($zaidejas, $pts)
{
   $rez1 = mysql_query("SELECT t.id, t.zaidejas FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas1 = t.zaidejas) where s.date = '".date("Y-m-d")."' and s.zaidejas1  = '$zaidejas' group by t.id");
   $zaidejas = @mysql_fetch_array($rez1);
   
   $rez1 = mysql_query("SELECT * FROM 1x1_mvp where zaidejas = {$zaidejas['id']} and kada = '" . date("Y-m-d") . "'");
   $q = @mysql_num_rows($rez1);
   if($q == 0)
   {
      dbquery("insert into 1x1_mvp (zaidejas, pts, kada) values ({$zaidejas['id']}, {$pts}, '" . date("Y-m-d") . "')");
   }
   else
   {
      dbquery("update 1x1_mvp set pts = pts + {$pts} where zaidejas = '{$zaidejas['id']}' and kada = '" . date("Y-m-d") . "'");
   }   
}

function addpts2($zaidejas, $pts)
{
   $rez1 = mysql_query("SELECT t.id, t.zaidejas FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas2 = t.zaidejas) where s.date = '".date("Y-m-d")."' and s.zaidejas2  = '$zaidejas' group by t.id");
   $zaidejas = @mysql_fetch_array($rez1);
   
   $rez1 = mysql_query("SELECT * FROM 1x1_mvp where zaidejas = {$zaidejas['id']} and kada = '" . date("Y-m-d") . "'");
   $q = @mysql_num_rows($rez1);
   if($q == 0)
   {
      dbquery("insert into 1x1_mvp (zaidejas, pts, kada) values ({$zaidejas['id']}, {$pts}, '" . date("Y-m-d") . "')");
   }
   else
   {
      dbquery("update 1x1_mvp set pts = pts + {$pts} where zaidejas = '{$zaidejas['id']}' and kada = '" . date("Y-m-d") . "'");
   }   
}

function addreb1($zaidejas, $reb)
{
   $rez1 = mysql_query("SELECT t.id, t.zaidejas FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas1 = t.zaidejas) where s.date = '".date("Y-m-d")."' and s.zaidejas1  = '$zaidejas' group by t.id");
   $zaidejas = @mysql_fetch_array($rez1);
   
   $rez1 = mysql_query("SELECT * FROM 1x1_mvp where zaidejas = {$zaidejas['id']} and kada = '" . date("Y-m-d") . "'");
   $q = @mysql_num_rows($rez1);
   if($q == 0)
   {
      dbquery("insert into 1x1_mvp (zaidejas, reb, kada) values ({$zaidejas['id']}, {$reb}, '" . date("Y-m-d") . "')");
   }
   else
   {
      dbquery("update 1x1_mvp set reb = reb + {$reb} where zaidejas = '{$zaidejas['id']}' and kada = '" . date("Y-m-d") . "'");
   }   
}

function addreb2($zaidejas, $reb)
{
   $rez1 = mysql_query("SELECT t.id, t.zaidejas FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas2 = t.zaidejas) where s.date = '".date("Y-m-d")."' and s.zaidejas2  = '$zaidejas' group by t.id");
   $zaidejas = @mysql_fetch_array($rez1);
   
   $rez1 = mysql_query("SELECT * FROM 1x1_mvp where zaidejas = {$zaidejas['id']} and kada = '" . date("Y-m-d") . "'");
   $q = @mysql_num_rows($rez1);
   if($q == 0)
   {
      dbquery("insert into 1x1_mvp (zaidejas, reb, kada) values ({$zaidejas['id']}, {$reb}, '" . date("Y-m-d") . "')");
   }
   else
   {
      dbquery("update 1x1_mvp set reb = reb + {$reb} where zaidejas = '{$zaidejas['id']}' and kada = '" . date("Y-m-d") . "'");
   }   
}


function addblk1($zaidejas, $blk)
{
   $rez1 = mysql_query("SELECT t.id, t.zaidejas FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas1 = t.zaidejas) where s.date = '".date("Y-m-d")."' and s.zaidejas1  = '$zaidejas' group by t.id");
   $zaidejas = @mysql_fetch_array($rez1);
   
   $rez1 = mysql_query("SELECT * FROM 1x1_mvp where zaidejas = {$zaidejas['id']} and kada = '" . date("Y-m-d") . "'");
   $q = @mysql_num_rows($rez1);
   if($q == 0)
   {
      dbquery("insert into 1x1_mvp (zaidejas, blk, kada) values ({$zaidejas['id']}, {$blk}, '" . date("Y-m-d") . "')");
   }
   else
   {
      dbquery("update 1x1_mvp set blk = blk + {$blk} where zaidejas = '{$zaidejas['id']}' and kada = '" . date("Y-m-d") . "'");
   }   
}

function addblk2($zaidejas, $blk)
{
   $rez1 = mysql_query("SELECT t.id, t.zaidejas FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas2 = t.zaidejas) where s.date = '".date("Y-m-d")."' and s.zaidejas2  = '$zaidejas' group by t.id");
   $zaidejas = @mysql_fetch_array($rez1);
   
   $rez1 = mysql_query("SELECT * FROM 1x1_mvp where zaidejas = {$zaidejas['id']} and kada = '" . date("Y-m-d") . "'");
   $q = @mysql_num_rows($rez1);
   if($q == 0)
   {
      dbquery("insert into 1x1_mvp (zaidejas, blk, kada) values ({$zaidejas['id']}, {$blk}, '" . date("Y-m-d") . "')");
   }
   else
   {
      dbquery("update 1x1_mvp set blk = blk + {$blk} where zaidejas = '{$zaidejas['id']}' and kada = '" . date("Y-m-d") . "'");
   }   
}

function addkof1($zaidejas, $kof)
{
   $rez1 = mysql_query("SELECT t.id, t.zaidejas FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas1 = t.zaidejas) where s.date = '".date("Y-m-d")."' and s.zaidejas1  = '$zaidejas' group by t.id");
   $zaidejas = @mysql_fetch_array($rez1);
   
   $rez1 = mysql_query("SELECT * FROM 1x1_mvp where zaidejas = {$zaidejas['id']} and kada = '" . date("Y-m-d") . "'");
   $q = @mysql_num_rows($rez1);
   if($q == 0)
   {
      dbquery("insert into 1x1_mvp (zaidejas, kof, kada) values ({$zaidejas['id']}, {$kof}, '" . date("Y-m-d") . "')");
   }
   else
   {
      dbquery("update 1x1_mvp set kof = kof + {$kof} where zaidejas = '{$zaidejas['id']}' and kada = '" . date("Y-m-d") . "'");
   }   
}

function addkof2($zaidejas, $kof)
{
   $rez1 = mysql_query("SELECT t.id, t.zaidejas FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas2 = t.zaidejas) where s.date = '".date("Y-m-d")."' and s.zaidejas2  = '$zaidejas' group by t.id");
   $zaidejas = @mysql_fetch_array($rez1);
   
   $rez1 = mysql_query("SELECT * FROM 1x1_mvp where zaidejas = {$zaidejas['id']} and kada = '" . date("Y-m-d") . "'");
   $q = @mysql_num_rows($rez1);
   if($q == 0)
   {
      dbquery("insert into 1x1_mvp (zaidejas, kof, kada) values ({$zaidejas['id']}, {$kof}, '" . date("Y-m-d") . "')");
   }
   else
   {
      dbquery("update 1x1_mvp set kof = kof + {$kof} where zaidejas = '{$zaidejas['id']}' and kada = '" . date("Y-m-d") . "'");
   }   
}


function addstl1($zaidejas, $stl)
{
   $rez1 = mysql_query("SELECT t.id, t.zaidejas FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas1 = t.zaidejas) where s.date = '".date("Y-m-d")."' and s.zaidejas1  = '$zaidejas' group by t.id");
   $zaidejas = @mysql_fetch_array($rez1);
   
   $rez1 = mysql_query("SELECT * FROM 1x1_mvp where zaidejas = {$zaidejas['id']} and kada = '" . date("Y-m-d") . "'");
   $q = @mysql_num_rows($rez1);
   if($q == 0)
   {
      dbquery("insert into 1x1_mvp (zaidejas, stl, kada) values ({$zaidejas['id']}, {$stl}, '" . date("Y-m-d") . "')");
   }
   else
   {
      dbquery("update 1x1_mvp set stl = stl + {$stl} where zaidejas = '{$zaidejas['id']}' and kada = '" . date("Y-m-d") . "'");
   }   
}

function addstl2($zaidejas, $stl)
{
   $rez1 = mysql_query("SELECT t.id, t.zaidejas FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas2 = t.zaidejas) where s.date = '".date("Y-m-d")."' and s.zaidejas2  = '$zaidejas' group by t.id");
   $zaidejas = @mysql_fetch_array($rez1);
   
   $rez1 = mysql_query("SELECT * FROM 1x1_mvp where zaidejas = {$zaidejas['id']} and kada = '" . date("Y-m-d") . "'");
   $q = @mysql_num_rows($rez1);
   if($q == 0)
   {
      dbquery("insert into 1x1_mvp (zaidejas, stl, kada) values ({$zaidejas['id']}, {$stl}, '" . date("Y-m-d") . "')");
   }
   else
   {
      dbquery("update 1x1_mvp set stl = stl + {$stl} where zaidejas = '{$zaidejas['id']}' and kada = '" . date("Y-m-d") . "'");
   }   
}



if(isset($status) && $status != '') {
if($status == 'pateikta') { /*kazkas jeigu pridejo*/ }
elseif($status == 'atmesta') { /*Kazkas jei nepridejo*/}
}

if (isset($_POST['submit'])) {
$ip = $_SERVER['REMOTE_ADDR'];

$_POST['zaidejas1'] = str_replace("\'", "", $_POST['zaidejas1']);
$_POST['zaidejas2'] = str_replace("\'", "", $_POST['zaidejas2']);

$result = dbquery("INSERT INTO 1x1_rez (zaidejas1, rez1, zaidejas2, rez2, ip, time, datea, date, pts1, pts2, reb1, reb2, stl1, stl2, ast1, ast2, blk1, blk2, kof1, kof2) VALUES ('{$_POST['zaidejas1']}', '".$_POST['rez1']."', '{$_POST['zaidejas2']}', '".$_POST['rez2']."', '".$ip."', '".time()."', '".date("H:i")."', '".date("Y-m-d")."', '".$_POST['pts1']."', '".$_POST['pts2']."', '".$_POST['reb1']."', '".$_POST['reb2']."', '".$_POST['stl1']."', '".$_POST['stl2']."', '".$_POST['ast1']."', '".$_POST['ast2']."', '".$_POST['blk1']."', '".$_POST['blk2']."', '".$_POST['kof1']."', '".$_POST['kof2']."')");
if($result) {
   if($_POST['pts1'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set pts = pts + {$_POST['pts1']} where zaidejas = '{$_POST['zaidejas1']}'");
      addpts1($_POST['zaidejas1'], $_POST['pts1']);
   }
   
   if($_POST['pts2'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set pts = pts + {$_POST['pts2']} where zaidejas = '{$_POST['zaidejas2']}'");
      addpts2($_POST['zaidejas2'], $_POST['pts2']);
   }
   
   if($_POST['reb1'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set reb = reb + {$_POST['reb1']} where zaidejas = '{$_POST['zaidejas1']}'");
      addreb1($_POST['zaidejas1'], $_POST['reb1']);
   }

   if($_POST['reb2'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set reb = reb + {$_POST['reb2']} where zaidejas = '{$_POST['zaidejas2']}'");
      addreb2($_POST['zaidejas2'], $_POST['reb2']);
   }

   
   if($_POST['stl1'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set stl = stl + {$_POST['stl1']} where zaidejas = '{$_POST['zaidejas1']}'");
      addstl1($_POST['zaidejas1'], $_POST['stl1']);
   }

   
   if($_POST['stl2'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set stl = stl + {$_POST['stl2']} where zaidejas = '{$_POST['zaidejas2']}'");
      addstl2($_POST['zaidejas2'], $_POST['stl2']);
   }

   if($_POST['blk1'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set blk = blk + {$_POST['blk1']} where zaidejas = '{$_POST['zaidejas1']}'");
      addblk1($_POST['zaidejas1'], $_POST['blk1']);
   }

   
   if($_POST['blk2'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set blk = blk + {$_POST['blk2']} where zaidejas = '{$_POST['zaidejas2']}'");
      addblk2($_POST['zaidejas2'], $_POST['blk2']);
   
   }
   if($_POST['kof1'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set kof = kof + {$_POST['kof1']} where zaidejas = '{$_POST['zaidejas1']}'");
      addkof1($_POST['zaidejas1'], $_POST['kof1']);
   }
   
   if($_POST['kof2'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set kof = kof + {$_POST['kof2']} where zaidejas = '{$_POST['zaidejas2']}'");
      addkof2($_POST['zaidejas2'], $_POST['kof2']);
   }   
if($_POST['rez1'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set imete = imete + {$_POST['rez1']} where zaidejas = '{$_POST['zaidejas1']}'");
      
   }   
   if($_POST['rez2'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set imete = imete + {$_POST['rez2']} where zaidejas = '{$_POST['zaidejas2']}'");
      
   }   
if($_POST['rez1'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set praleido = praleido + {$_POST['rez2']} where zaidejas = '{$_POST['zaidejas1']}'");
      
   }   
   if($_POST['rez2'] != '')
   {
      dbquery("update fsb_1x1_zaidejai set praleido = praleido + {$_POST['rez1']} where zaidejas = '{$_POST['zaidejas2']}'");
      
   }   
   
   if($_POST['rez1'] == $_POST['rez2'])
   {
      dbquery("update fsb_1x1_zaidejai set suzaide = suzaide + 1, taskai = taskai + 1 where zaidejas = '{$_POST['zaidejas1']}'");      
      dbquery("update fsb_1x1_zaidejai set suzaide = suzaide + 1, taskai = taskai + 1 where zaidejas = '{$_POST['zaidejas2']}'");
   }
   elseif ($_POST['rez1'] > $_POST['rez2'])
   {
                dbquery("update 1x1_mvp set suzaide = suzaide + 1 where zaidejas = '{$_POST['zaidejas1']}' OR zaidejas = '{$_POST['zaidejas2']}'");
      dbquery("update fsb_1x1_zaidejai set suzaide = suzaide + 1, pergales = pergales + 1, taskai = taskai + 2 where zaidejas = '{$_POST['zaidejas1']}'");      
      dbquery("update fsb_1x1_zaidejai set suzaide = suzaide + 1, pralaimejimai = pralaimejimai + 1, taskai = taskai + 1 where zaidejas = '{$_POST['zaidejas2']}'");
   }
   else
   {
      dbquery("update fsb_1x1_zaidejai set suzaide = suzaide + 1, pergales = pergales + 1, taskai = taskai + 2 where zaidejas = '{$_POST['zaidejas2']}'");      
      dbquery("update fsb_1x1_zaidejai set suzaide = suzaide + 1, pralaimejimai = pralaimejimai + 1 where zaidejas = '{$_POST['zaidejas1']}'");
                dbquery("update 1x1_mvp set suzaide = suzaide + 1 where zaidejas = '{$_POST['zaidejas1']}' OR zaidejas = '{$_POST['zaidejas2']}'");   
   }
   
   $zaidejas1 = mysql_query("SELECT zaidejas FROM fsb_1x1_zaidejai where name  = '{$_POST['zaidejas1']}'");
   $zaidejas1 = @mysql_fetch_array(1);
   
   $zaidejas2 = mysql_query("SELECT zaidejas FROM fsb_1x1_zaidejai where name  = '{$_POST['zaidejas2']}'");
   $zaidejas2 = @mysql_fetch_array(2);

   $played = 0;   
   $rez1 = mysql_query("SELECT t.zaidejas count(*) as played  FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas1 = t.zaidejas) where s.date = '".date("Y-m-d")."' and s.zaidejas1  = '{$_POST['zaidejas']}' group by t.zaidejas");
   if(@mysql_num_rows($rez1) > 0)
   {
      $zaidejas = mysql_fetch_array($rez1);
      $played += $zaidejas['suzaide'];
   }
   
   $rez1 = mysql_query("SELECT t.zaidejas, count(*) as played  FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas2 = t.zaidejas) where s.date = '".date("Y-m-d")."' and s.zaidejas2  = '{$_POST['zaidejas']}' group by t.zaidejas");
   if(mysql_num_rows($rez1) > 0)
   {
      $zaidejas = mysql_fetch_array($rez1);
      $played += $zaidejas['suzaide'];
   }
   
   
   $rez1 = mysql_query("SELECT t.zaidejas, count(*) as played  FROM `1x1_rez` s left join fsb_1x1_zaidejai t on (s.zaidejas2 = t.zaidjeas) where s.date = '".date("Y-m-d")."' and s.zaidejas2  = '{$_POST['zaidejas2']}' group by t.zaidejas");
   if(@mysql_num_rows($rez1) > 0)
   {
      $zaidejas = mysql_fetch_array($rez1);
      $played += $zaidejas['suzaide'];
   }
   

   opentable('Varþybø registravimas');
   echo "<center><b>Dëkojame, varþybos sëkmingai uþregistruotos.</b></center>";
   closetable();
 }

else { echo "Varþybø uþregistruoti nepavyko."; }
}
else {
opentable('Varþybø registravimas');


$zaidejass = "";
$rez1 = mysql_query("SELECT zaidejas FROM fsb_1x1_zaidejai order by zaidejas");
while ($q = mysql_fetch_array($rez1))
{
   $zaidejass .= "<option value=\"{$q['zaidejas']}\">{$q['zaidejas']}</option>";
}
$players = "<option value=\"0\" selected=\"selected\">-< Pasirinkite þaidëjà >-</option>";
$rez1 = mysql_query("SELECT zaidejas FROM fsb_1x1_zaidejai order by zaidejas");
while ($q = mysql_fetch_array($rez1))
{
   $players .= "<option value=\"{$q['zaidejas']}\">{$q['zaidejas']}</option>";
}

echo "

<center><b>Varþybø registravimas</b></center><br><br>

<center>
<form method='POST' action='".FUSION_SELF."'>

<select class='textbox' name='zaidejas1'>
{$zaidejass}
</select>
&nbsp;
 <input format='NNN' class='textbox' name='rez1' size='12' maxlength='3'/> -
 <input format='NNN' class='textbox' name='rez2' size='12' maxlength='3'/>
&nbsp;
<select class='textbox' name='zaidejas2'>
{$zaidejass}
</select>
<br>


<br>
<table border='0' width='100%'>




</table>


<br>
<input type='submit' name='submit' value='Uþregistruoti varþybas'>

</form></center>
";

include_once "irasymas2.php";
closetable();


}




require_once "../../side_right.php";
require_once "../../footer.php";
?>




Dėkui.