| Neuer Benutzer
Registriert seit: 17.01.2011
Beiträge: 1
PHP-Kenntnisse:
Anfänger
|  Auslesen aus dem SQL
Hey Leute,
hoffe ich bin hier im richtigen forum ^^
ich bin betreiber einer "Interaktiven Online Liga für FIFA11" !
Dort habe ich ein PHP Script welches es ermöglicht Ergebnise voll automatisch ins LMO ( Liga Manager Online ) einzutragen.
Dieses Script liest das Team welches man betreut aus dem SQL aus, jedoch liest es derzeit nur 1 Teams aus, ich würd es aber gerne so anpassen das 2. Teams ausgelesen werden ! Habs schon mit sämptlichen umschreibungs variablen probiert, bin auch nich so der pro und hoffe hier auf hilfe ...
Hier einmal die 2 Quellcodes : "myplace.php" <<< diese gibt die Teams aus PHP-Code: <?php session_start();
include "bb_result.cl.php";
include "various.cl.php";
?>
<script type="text/javascript" src="func.js" language="javascript"></script>
<?php
$neu = new bb_result();
$neu2 = new Various();
//gib team weiter.
$teamname = $neu->getTeam();
if ($teamname) {
$sperre = 0;
if ($sperre==0) {
$teamuser=$neu2->convertUM($teamname);
$team = $teamuser[0];
$user = $teamuser[1];
$gegnaz = $neu->jsicq($teamname);
echo '<div align="center"><img src="bootybounce/bilder/meinbereich.png" /></div>';
//LIGA BEGiNN-->
$liga = $neu->getMyLiga();
if ($liga!='0')
{
$stars = $neu2->getAnzStars($teamname);
echo "<div align='right'><a href='include.php?path=bootybounce/usergroups.php'>Adminteam</a> | <a href='include.php?path=bootybounce/mystats/mystats.php'>Meine Statistiken</a> | <a href='include.php?path=bootybounce/awaykalender.php'>Awayliste</a> | <a href='include.php?path=bootybounce/bb_result/tab_gef.php'>Gefährdete Trainer</a> | <a href='include.php?path=htm/terminkalender.php'>Terminkalender</a></div><br />
<table align='left' border='0' width='100%'>
<tr>
<td width='64'><img src='bootybounce/meinbereich/".$team.".png'></td>
<td><b>".$teamname."</b></td>
<td align='right'><img src='bootybounce/bilder/".$stars."sterne.png' title='".$stars." Sterne' height='25' />
</tr>
</table></div>";
echo '<u><h2><img src="bootybounce/bilder/'.$liga.'U.png" alt="'.$liga.'"/></u></h2>';
//ale spiele nun gespeichert
$spiele = $neu->OffeneMatches($liga,$teamname);
echo '<table border="0" rules="rows"><tr><td><u>Kontakt:</u></td><td><span id="js001" style="color:white;font-size:12px"><i>- -</i></span></td></tr></table><br />';
if (count($spiele)>0) {
echo '<form name="form" method="post" action="include.php?path=bootybounce/bb_result/myplace2.php">';
echo '<select name="games" onchange="checkicq(\''.$gegnaz.'\',this.value,\''.$teamname.'\',\'js001\')">
<option value="0">Bitte Wählen</option>';
foreach($spiele as $schluessel =>$wert)
{
$players = $neu->getPartiePlayer($wert);
echo '<option name="optionen" id='.($schluessel+1).' value="'.$liga.'| '.$wert.'">('.$players[0].') '.$wert.' ('.$players[1].')</option>';
}
echo '</select><input type="submit" name="result1" value="Auswählen" /></form>';
}
}
//<--LIGA ENDE "bb_result.cl.php" <<< aus dieser Datei werden die Teams mittels SQL ausgelesen PHP-Code: <?php
class bb_result {
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
//holt mir teamnummer+teamname zurück.
public function getTeamNum($liga,$team_name) {
$teamcheck=0;
$pfad = "lmo/ligen/".$liga.".l98";
if (file_exists($pfad)) {
$dat = file($pfad);
for ($f=1;$f<=count($dat);$f++)
{
//prüfe nach dem =teamname um die nummer davor zu holen
if( preg_match("/=".($team_name)."$/",$dat[$f]))
{
//flag
$teamcheck=1;
//teile es in nummer+team
$team_inf = explode("=",$dat[$f]);
$tm = str_replace("\n","",$team_inf[0]);
$team_num = $tm;
break;
}
//prüfe nach dem =teamname um die nummer davor zu holen
if( preg_match("/=".($team_name)."$/",$dat[$f]))
{
//flag
$teamcheck=2;
//teile es in nummer+team
$team_inf = explode("=",$dat[$f]);
$tm = str_replace("\n","",$team_inf[0]);
$team_num = $tm;
break;
}
}
if($teamcheck==0) {
return $teamcheck;
}else { return $team_num;}
}else echo "-";
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function getBB($string) {
$pfad = "bootybounce/bb_result/getfree/bb.inf";
if (!file_exists($pfad)) {exit("pfad existiert nicht."); }
$dat = file($pfad);
$x=0;
foreach ($dat as $spieltage) {
if (preg_match("/^".utf8_encode($string)."=/",$spieltage)) {
$sp = explode("=",$spieltage);
//mindestspieltage
$min = $sp[1];
//$min = explode("\r\n",$min);
$min = preg_replace("!(\r\n)|(\r)!","",$min);
//$min = str_replace("\r\n","",$min);
//$min = $min[1];
return $min;
break;
}
}
}
//////////////////////////////////////////////////////////////////////////////////////////////
//holt mir den Teamnamen
public function getTeamNameFile($liga,$team_no) {
$teamcheck=0;
$pfad = "lmo/ligen/".$liga.".l98";
if (file_exists($pfad)) {
$dat = file($pfad);
for ($f=0;$f<=count($dat);$f++)
{
//wenns nach dem = ist prüfe auf buchstaben, wenns vor ist prüfe normal
if( preg_match("/^".$team_no."=/",$dat[$f]))
{
//flag
$teamcheck=1;
//teile es in nummer+team
$team_inf = explode("=",$dat[$f]);
$tm = str_replace("\n","",$team_inf[1]);
$team_name = $tm;
break;
}
}
if($teamcheck==0) {
return $teamcheck;
}else { return $team_name;}
}else "-";
}
/////////////////////////////////////////////////////////////////////////////////////////
//holt mir die partien
public function OffeneMatches($liga,$teamname) {
//ini of bb
$dat = file("bootybounce/bb_result/getfree/bb.inf");
$x=0;
//freie spieltage wird ermittelt
foreach ($dat as $spieltage) {
if (preg_match("/".utf8_encode($liga)."=/",$spieltage)) {
$sp = explode("=",$spieltage);
$x = $sp[1];
if ($x!=0) {
echo nl2br("Frei bis Spieltag:<b>".$x."</b><br />");
break;
}
}
}
//nummer von team
$team_inf = $this->getTeamNum($liga,$teamname);
$pfad = "lmo/ligen/".$liga.".l98";
if (file_exists($pfad)) {
$dat = file($pfad);
$i=0;
$sp=0;
for ($f=0;$f<=count($dat);$f++)
{
//ermittle Spieltag
if ( preg_match('/^\[Round/',$dat[$f])) { $sp++;}
if ( $sp>$x) { break;}
//finde alle meine spiele die genau auf mich zutreffen(heim+gast)
if( preg_match('/^TA.{1,2}='.$team_inf.'$/',$dat[$f]) || preg_match('/^TB.{1,2}='.$team_inf.'$/',$dat[$f]))
{
if( preg_match('/^TA.{1,2}=/',$dat[$f])) {
//gegner zeile danach
$geg = $dat[$f+1];
//teile es vom vorderen stück ab
$geg = explode("=",$geg);
//ersetzte linefeed durch ""
$geg = str_replace("\n","",$geg[1]);
//hol mir gegner+ich die teams
$gegner = $this->getTeamNameFile($liga,$geg);
$ich = $teamname;
//hol die tore von heim
$tor = explode("=",$dat[$f+2]);
$tor1 = $tor[1];
//hol die tore von gast
$tor = explode("=",$dat[$f+3]);
$tor2 = $tor[1];
if ($tor1 && $tor2 ==-1)
{
$matches[$i] = $ich." - ".$gegner;
}
}
if( preg_match('/^TB.{1,2}=/',$dat[$f])) {
//gegner zeile davor
$geg = $dat[$f-1];
$geg = explode("=",$geg);
//ersetzte linefeed durch ""
$geg = str_replace("\n","",$geg[1]);
//hol mir gegner per geg=nummer den TeamNamen
$gegner = $this->getTeamNameFile($liga,$geg);
$ich = $this->getTeamNameFile($liga,$team_inf);
//hol die tore von heim
$tor = explode("=",$dat[$f+1]);
$tor1 = $tor[1];
//hol die tore von gast
$tor = explode("=",$dat[$f+2]);
$tor2 = $tor[1];
if ($tor1 && $tor2 ==-1)
{
$matches[$i] = $gegner." - ".$ich;
}
}
$i++;
}
if ($i==$x) break;
}
switch (count($matches)) {
case 0:
if ($team_inf==0 || $x==0) {
echo "..beginnt in Kürze...";
}else echo "<i><b>".$liga."</b>: Alle freigegebenen Spieltage gespielt.</i>";
break;
default:
return array_values($matches);
}
}else echo "-";
}
/////////////////////////////////////////////////////////////////////////////////////////
//Partie eintragen
public function setPartie($heim,$gast,$lig,$tor1,$tor2,$id,$spn) {
$team1 = $heim;
$team2 = $gast;
$sp = 0;
$pfad = "lmo/ligen/".$lig.".l98";
if (file_exists($pfad)) {
$team2num = $this->getTeamNum($lig,$team2);
$team1num = $this->getTeamNum($lig,$team1);
$dat = file($pfad);
//resultat wird eingetragen ins l98
for ($f=0;$f<=count($dat);$f++) {
//ermittle Spieltag
if ( preg_match('/^\[Round/',$dat[$f])) { $sp++; }
//finde partie
if( preg_match('/^TA.{1,2}='.$team1num.'$/',$dat[$f]) && preg_match('/^TB.{1,2}='.$team2num.'$/',$dat[$f+1]) && $spn==$sp) {
$cut = explode ("=",$dat[$f+2]);
$cut2 = explode ("=",$dat[$f+3]);
$cut[1] = str_replace("\n","",$cut[1]);
$cut2[1] = str_replace("\n","",$cut2[1]);
$z = explode ("=",$dat[$f+4]);
if ( preg_match('/^SP/',$z[0]))
{
$cut4 = explode ("=",$dat[$f+6]);
$cut3 = explode ("=",$dat[$f+8]);
$dat[$f+6] = $cut4[0]."=/include.php?path=bootybounce/bb_result/berichte.php&id=".$id."\r\n";
$timestamp = time();
$dat[$f+8] = $cut3[0]."=".$timestamp."\r\n";
}else {
$cut4 = explode ("=",$dat[$f+5]);
$cut3 = explode ("=",$dat[$f+7]);
$dat[$f+5] = $cut4[0]."=/include.php?path=bootybounce/bb_result/berichte.php&id=".$id."\r\n";
$timestamp = time();
$dat[$f+7] = $cut3[0]."=".$timestamp."\r\n";
}
$dat[$f+2] = $cut[0]."=".$tor1."\r\n";
$dat[$f+3] = $cut2[0]."=".$tor2."\r\n";
if ( $cut[1] && $cut2[1] ==-1 )
{
file_put_contents($pfad,$dat);
return true;
break;
}else {
echo "Ergebnis wurde bereits eingetragen.";
return false;
break;
}
}
}
}else echo "kein Pfad.";
}
/////////////////////////////////////////////////////////////////////////////////////////
//trägt statistik ein von spielern
public function setPlayerResults($lig,$player,$tor,$gelb,$rot,$gelbrot,$SdT) {
$pfad = "lmo/addon/spieler/stats/".$lig.".stat";
$dat = file($pfad);
for ($f=0;$f<count($dat);$f++) {
if ( preg_match('/^'.$player.'/',$dat[$f])) {
$zeichen = utf8_decode("§");
$zerleg = explode($zeichen,$dat[$f]);
$zerleg[2] = $zerleg[2] + $tor;
$zerleg[3] = $zerleg[3] + $gelb;
$zerleg[4] = $zerleg[4] + $rot;
$zerleg[5] = $zerleg[5] + $gelbrot;
$zerleg[6] = $zerleg[6] + $SdT;
$finish = implode($zeichen,$zerleg);
$dat[$f] = $finish."\r\n";
file_put_contents($pfad,$dat);
break;
}
}
}
/////////////////////////////////////////////////////////////////////////////////////////
//hole mir die spieler einer mannschaft im dropdownmenue
public function getPlayer($lig,$team,$betreff) {
$pfad = "lmo/addon/spieler/stats/".$lig.".stat";
if (file_exists($pfad)) {
$dat = file($pfad);
echo '<select name="'.$betreff.'[]">';
for ($f=0;$f<=count($dat);$f++) {
if ( preg_match('/'.$team.'/',$dat[$f])) {
$zerleg = explode(utf8_decode("§"),$dat[$f]);
$spieler = $zerleg[0];
echo '<option id='.$spieler.'>'.$spieler.'</option>';
}
}
echo '</select><br /><br />';
}else echo "Pfad existiert nicht.";
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//Hol meine liganame
public function getMyLiga() {
$session_id = session_id();
$sql= sprintf("SELECT team_liga FROM phpkit_team,phpkit_session WHERE session_id='%s' AND
team_userid=session_userid",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$liga = $datensatz[0];
return $liga;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//mein Team
public function getTeam() {
$session_id = session_id();
$sql= sprintf("SELECT team_name FROM phpkit_team,phpkit_session WHERE session_id='%s' AND
team_userid=session_userid AND team_status='aktiv'",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$team = $datensatz[0];
return $team;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//mein EM/WM Team
public function getWMEMLiga() {
$session_id = session_id();
$sql= sprintf("SELECT int_reg,int_group FROM kii_int,phpkit_session WHERE session_id='%s' AND
int_userid=session_userid",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
return $datensatz;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//Hol cl/uefa+group
public function getUEFACL() {
$session_id = session_id();
$sql= sprintf("SELECT team_inter,team_group FROM phpkit_team,phpkit_session WHERE session_id='%s' AND
team_userid=session_userid AND team_status='aktiv'",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
return $datensatz;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//Hol nat. Pokal
public function getNatCup() {
$session_id = session_id();
$sql= sprintf("SELECT team_nat FROM phpkit_team,phpkit_session WHERE session_id='%s' AND
team_userid=session_userid AND team_status='aktiv'",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$natcup = $datensatz[0];
return $natcup;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//Hol difcup
public function getDiffCup() {
$session_id = session_id();
$sql= sprintf("SELECT team_difcup FROM phpkit_team,phpkit_session WHERE session_id='%s' AND
team_userid=session_userid AND team_status='aktiv'",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$difcup = $datensatz[0];
return $difcup;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//Hol relegation
public function getREL() {
$session_id = session_id();
$sql= sprintf("SELECT team_country,team_difcup FROM phpkit_team,phpkit_session WHERE session_id='%s' AND
team_userid=session_userid AND team_status='aktiv' AND team_difcup='Relegation'",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
return $datensatz;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//Hol EM-WM Team
public function getSECTeam() {
$session_id = session_id();
$sql= sprintf("SELECT team_name FROM phpkit_team,phpkit_session WHERE session_id='%s' AND
team_userid=session_userid",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$team = $datensatz[0];
return $team;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//Hol EM-WM Partien
public function getSEC() {
$session_id = session_id();
$sql= sprintf("SELECT team_liga FROM php_team,phpkit_session WHERE session_id='%s' AND
team_userid=session_userid",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
return $datensatz;
//return $datensatz;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//Partie eintragen
public function getSpieltag($partie) {
$sp = 0;
//partie wird in lig,team1,team2 zerlegt
$zerleg = explode(" - ",$partie);
$team2 = $zerleg[1];
$zerleg = explode("| ",$zerleg[0]);
$team1 = $zerleg[1];
$lig = $zerleg[0];
$pfad = "lmo/ligen/".$lig.".l98";
if (file_exists($pfad)) {
$team2num = $this->getTeamNum($lig,$team2);
$team1num = $this->getTeamNum($lig,$team1);
$dat = file($pfad);
//resultat wird eingetragen ins l98
for ($f=0;$f<=count($dat);$f++) {
//ermittle Spieltag
if ( preg_match('/^\[Round/',$dat[$f])) { $sp++; }
//finde partie
if( preg_match('/^TA.{1,2}='.$team1num.'$/',$dat[$f]) && preg_match('/^TB.{1,2}='.$team2num.'$/',$dat[$f+1])) {
//hol die tore von heim
$tor = explode("=",$dat[$f+2]);
$tor1 = $tor[1];
//hol die tore von gast
$tor = explode("=",$dat[$f+3]);
$tor2 = $tor[1];
$esp = (int) $this->getBB($lig);
if (($tor1 && $tor2 ==-1) && ($esp>=$sp))
{
return $sp;
break;
}
}
}
}else echo "-";
}
/////////////////////////////////////////////////////////////////////////////////////////
//hole mir die spieler beider mannschaften in gleicher Liga im dropdownmenue
public function getINTERBothPlayer($partie) {
$zerleg = explode(" - ",$partie);
$team2 = $zerleg[1];
$zerleg = explode("| ",$zerleg[0]);
$team1 = $zerleg[1];
if ($team1=="") { $team1=$zerleg[0]; }
$lig = $zerleg[0];
//hol die ligen
$session_id = session_id();
$sql= sprintf("SELECT team_liga FROM phpkit_team WHERE team_name='%s' OR team_name='%s' group by team_liga",
mysql_real_escape_string($team1),
mysql_real_escape_string($team2));
$result= mysql_query($sql);
$anz = mysql_num_rows($result);
echo '<select name="spieler">';
for ($i=1;$i<=$anz;$i++)
{
$ligen= mysql_fetch_row($result);
foreach($ligen as $dieligen =>$wert) {
$pfad = "lmo/addon/spieler/stats/".$wert.".stat";
$dat = file($pfad);
for ($f=0;$f<=count($dat);$f++) {
if ( preg_match('/'.$team1.'/',$dat[$f]) || preg_match('/'.$team2.'/',$dat[$f])) {
$zerleg = explode(utf8_decode("§"),$dat[$f]);
$spieler = $zerleg[0];
echo '<option id='.$spieler.'>'.$spieler.'</option>';
}
}
}
}
echo '</select>';
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// db vorbereiten.
public function setPartieInfo($partie,$sp) {
$session_id = session_id();
$saison = $this->getBB("saison");
//author_id
$sql= sprintf("SELECT user_id FROM phpkit_user,phpkit_session WHERE session_id='%s' AND
user_id=session_userid AND user_id!=0",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$autor_id = $datensatz[0];
//heimteam-gastteam-liga
$zerleg = explode(" - ",$partie);
$team2 = $zerleg[1];
$zerleg = explode("| ",$zerleg[0]);
$team1 = $zerleg[1];
$lig = $zerleg[0];
$autor_team = $this->getTeam();
if ($autor_team==$team1)
{
$sec_team = $team2;
}elseif ($autor_team==$team2) { $sec_team = $team1; }
//sec_id
$sql= sprintf("SELECT team_userid FROM phpkit_team WHERE team_name='%s'",
mysql_real_escape_string($sec_team));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$sec_id = $datensatz[0];
if ($sec_id==0) {
echo utf8_decode("Um ein Ergebnis eintragen zu können muss das gegnerische Team einen Trainer haben.<br />
Möglicherweise wurde dieser entlassen. Bitte zurück zur ersten Seite <a href='include.php?path=bootybounce/bb_result/myplace.php' >Hier</a>.");
}else {
//prüfe ob dieses eintrag richtig ist/vorhanden is...
$sql_check= sprintf("SELECT ergz_author_id,ergz_id,ergz_sec_id FROM kii_ergz WHERE ergz_liga='%s' AND ergz_sp='%s' AND
ergz_heim_t='%s' AND ergz_gast_t='%s' AND ergz_status='onwork'",
mysql_real_escape_string($lig),
mysql_real_escape_string($sp),
mysql_real_escape_string($team1),
mysql_real_escape_string($team2));
$resultat= mysql_query($sql_check);
$self = mysql_fetch_row($resultat);
$self2 = $self[0];
$anz= mysql_num_rows($resultat);
if ($anz>0) {
if ($autor_id == $self2)
{ echo "-Tragen Sie ein-"; return $self[1];
}else {
echo "Das Ergebnis wird bereits vom Gegner eingetragen.<br />
Bitte warten bis das Ergebnis drin ist, ansonsten <i><b>den Liga Admin</b></i> kontaktieren.";
}
}else {
//heimteam-user
$sql= sprintf("SELECT team_userid FROM phpkit_team WHERE team_name='%s'",
mysql_real_escape_string($team1));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$heimteam_user = $datensatz[0];
$sql= sprintf("INSERT INTO kii_ergz (
ergz_liga,
ergz_sp,
ergz_author_id,
ergz_author_team,
ergz_sec_id,
ergz_sec_team,
ergz_heim_t,
ergz_gast_t,
ergz_saison,
ergz_heim_t_user
)
VALUES ('%s','%u','%u','%s','%u','%s','%s','%s','%s','%u')",
mysql_real_escape_string($lig),
mysql_real_escape_string($sp),
mysql_real_escape_string($autor_id),
mysql_real_escape_string($autor_team),
mysql_real_escape_string($sec_id),
mysql_real_escape_string($sec_team),
mysql_real_escape_string($team1),
mysql_real_escape_string($team2),
mysql_real_escape_string($saison),
mysql_real_escape_string($heimteam_user));
$result3= mysql_query($sql);
$mysql_insert_id = mysql_insert_id();
if ($mysql_insert_id>1)
{
return $mysql_insert_id;
}else { return false;}
}
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// eintrag und vollendung in db+file CL-UEFA schnellversion
public function setPartieInfo2($t1,$t2,$g1,$g2,$r1,$r2,$gr1,$gr2,$sdt,$bericht,$lig) {
$session_id = session_id();
//author_id
$sql= sprintf("SELECT user_id FROM phpkit_user,phpkit_session WHERE session_id='%s' AND
user_id=session_userid AND user_id!=0",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$autor_id = $datensatz[0];
//bericht auschecken
$bericht = base64_encode($bericht);
//eitnrag ins db - vollendung von author
$sql= sprintf("UPDATE kii_ergz SET ergz_ht='%u', ergz_gt='%u', ergz_hg='%u', ergz_gg='%u',ergz_hr='%u',
ergz_gr='%u', ergz_hgr='%u', ergz_ggr='%u', ergz_sdt='%s', ergz_author_bericht='%s' WHERE ergz_author_id='%u'
AND ergz_liga='%s' AND ergz_status='onwork' ORDER BY ergz_id DESC LIMIT 1",
mysql_real_escape_string($t1),
mysql_real_escape_string($t2),
mysql_real_escape_string($g1),
mysql_real_escape_string($g2),
mysql_real_escape_string($r1),
mysql_real_escape_string($r2),
mysql_real_escape_string($gr1),
mysql_real_escape_string($gr2),
mysql_real_escape_string($sdt),
mysql_real_escape_string($bericht),
mysql_real_escape_string($autor_id),
mysql_real_escape_string($lig));
$result= mysql_query($sql);
//hole id von dieser partie
$sql= sprintf("SELECT ergz_id, ergz_liga, ergz_heim_t, ergz_gast_t, ergz_sp FROM kii_ergz WHERE
ergz_author_id='%u' AND ergz_liga='%s' AND ergz_status='onwork' ORDER BY ergz_id DESC LIMIT 1",
mysql_real_escape_string($autor_id),
mysql_real_escape_string($lig));
$result = mysql_query($sql);
$datensatz = mysql_fetch_row($result);
$id = $datensatz[0];
$lig = $datensatz[1];
$heim = $datensatz[2];
$gast = $datensatz[3];
$sp = $datensatz[4];
//eintag in file
$eintrag = $this->setPartie($heim,$gast,$lig,$t1,$t2,$id,$sp);
if ($eintrag)
{
//abschluss
$sql= sprintf("UPDATE kii_ergz SET ergz_author_flag='1', ergz_author_time=NOW(), ergz_status='ended'
WHERE ergz_author_id='%u' AND ergz_liga='%s' AND ergz_status='onwork' ORDER BY ergz_id DESC LIMIT 1",
mysql_real_escape_string($autor_id),
mysql_real_escape_string($lig));
$result = mysql_query($sql);
}
//gibt datenstäze zurück
return array($lig,$heim,$gast,$sp);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function setFriendlyData($heim,$gast,$heimstar,$gaststar,$t1,$t2) {
//wenn positiv dann heim starker
$diff = $heimstar - $gaststar;
if ($diff>0) {
if ($t1>$t2) {
$punkte = (30+$diff)+$t1;
$hpunkte = ceil($punkte);
$gpunkte = $hpunkte-(2*$hpunkte);
}elseif ($t1<$t2) {
$punkte = (30*($diff+1))+$t2+15;
$gpunkte = ceil($punkte);
$hpunkte = $gpunkte-(2*$gpunkte);
}
}
if ($diff<0) {
$diff = abs($diff);
if ($t1<$t2) {
$punkte = (30+$diff)+$t1+15;
$gpunkte = ceil($punkte);
$hpunkte = $gpunkte-(2*$gpunkte);
}elseif ($t1>$t2) {
$punkte = (30*($diff+1))+$t2;
$hpunkte = ceil($punkte);
$gpunkte = $hpunkte-(2*$hpunkte);
}
}
if ($diff==0) {
if ($t1<$t2) {
$punkte = 30+$t2+15;
$gpunkte = ceil($punkte);
$hpunkte = $gpunkte-(2*$gpunkte);
}elseif ($t1>$t2) {
$punkte = 30+$t1;
$hpunkte = ceil($punkte);
$gpunkte = $hpunkte-(2*$hpunkte);
}
}
$saison = $this->getBB("saison");
$sql= sprintf("UPDATE kii_friendly SET friendly_p=friendly_p+'%s',friendly_sp=friendly_sp+1, friendly_t=friendly_t+'%s', friendly_gt=friendly_gt+'%s' WHERE friendly_team='%s' AND friendly_season='%s' LIMIT 1",
mysql_real_escape_string($hpunkte),
mysql_real_escape_string($t1),
mysql_real_escape_string($t2),
mysql_real_escape_string($heim),
mysql_real_escape_string($saison));
$result= mysql_query($sql);
$sql= sprintf("UPDATE kii_friendly SET friendly_p=friendly_p+'%s', friendly_sp=friendly_sp+1,
friendly_t=friendly_t+'%s', friendly_gt=friendly_gt+'%s' WHERE friendly_team='%s' AND friendly_season='%s' LIMIT 1",
mysql_real_escape_string($gpunkte),
mysql_real_escape_string($t2),
mysql_real_escape_string($t1),
mysql_real_escape_string($gast),
mysql_real_escape_string($saison));
$result= mysql_query($sql);
$punkte = abs($hpunkte);
return $punkte;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// eintrag und vollendung in db+file
public function setPartieInfo2Friendly($t1,$t2,$sdt,$bericht,$lig,$heimstar,$gaststar,$heimteam,$gastteam) {
$session_id = session_id();
//author_id
$sql= sprintf("SELECT user_id FROM phpkit_user,phpkit_session WHERE session_id='%s' AND
user_id=session_userid AND user_id!=0",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$autor_id = $datensatz[0];
//bericht auschecken
$bericht = base64_encode($bericht);
//eitnrag ins db - vollendung von author
$sql= sprintf("UPDATE kii_ergz SET ergz_ht='%u', ergz_gt='%u', ergz_sdt='%s',
ergz_author_bericht='%s' WHERE ergz_author_id='%u' AND ergz_heim_t='%s' AND ergz_gast_t='%s'
AND ergz_liga='Friendly' AND ergz_status='onwork' ORDER BY ergz_id DESC LIMIT 1",
mysql_real_escape_string($t1),
mysql_real_escape_string($t2),
mysql_real_escape_string($sdt),
mysql_real_escape_string($bericht),
mysql_real_escape_string($autor_id),
mysql_real_escape_string($heimteam),
mysql_real_escape_string($gastteam));
$result= mysql_query($sql);
$saison = $this->getBB("saison");
$punkte = $this->setFriendlyData($heimteam,$gastteam,$heimstar,$gaststar,$t1,$t2);
if ($punkte>0)
{
//abschluss
$sql= sprintf("UPDATE kii_ergz SET ergz_author_flag='1', ergz_author_time=NOW(), ergz_status='ended'
WHERE ergz_author_id='%u' AND ergz_liga='Friendly' AND ergz_status='onwork' AND ergz_saison='%s' AND ergz_gast_t='%s' AND ergz_heim_t='%s'
ORDER BY ergz_id DESC LIMIT 1",
mysql_real_escape_string($autor_id),
mysql_real_escape_string($saison),
mysql_real_escape_string($gastteam),
mysql_real_escape_string($heimteam));
$result = mysql_query($sql);
}
//gibt datenstäze zurück
return array($lig,$heimteam,$gastteam,$sp,$punkte);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// db vorbereiten.
public function setPartieInfoWMEM($partie,$sp) {
$session_id = session_id();
$saison = $this->getBB("saison");
//author_id
$sql= sprintf("SELECT int_userid FROM kii_int,phpkit_session WHERE session_id='%s' AND
int_userid=session_userid AND int_userid is NOT NULl",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$autor_id = $datensatz[0];
//heimteam-gastteam-liga
$zerleg = explode(" - ",$partie);
$team2 = $zerleg[1];
$zerleg = explode("| ",$zerleg[0]);
$team1 = $zerleg[1];
$lig = $zerleg[0];
$autor_team = $this->getINTTeam();
if ($autor_team==$team1)
{
$sec_team = $team2;
}elseif ($autor_team==$team2) { $sec_team = $team1; }
//sec_id
$sql= sprintf("SELECT int_userid FROM kii_int WHERE int_team='%s'",
mysql_real_escape_string($sec_team));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$sec_id = $datensatz[0];
if ($sec_id==0) {
echo utf8_decode("Um ein Ergebnis eintragen zu können muss das gegnerische Team einen Trainer haben.<br />
Möglicherweise wurde dieser entlassen. Bitte zurück zur ersten Seite <a href='include.php?path=bootybounce/bb_result/myplace.php' >Hier</a>.");
}else {
//prüfe ob dieses eintrag richtig ist/vorhanden is...
$sql_check= sprintf("SELECT ergz_author_id FROM kii_ergz WHERE ergz_liga='%s' AND ergz_sp='%s' AND
ergz_heim_t='%s' AND ergz_gast_t='%s' AND ergz_status='onwork'",
mysql_real_escape_string($lig),
mysql_real_escape_string($sp),
mysql_real_escape_string($team1),
mysql_real_escape_string($team2));
$resultat= mysql_query($sql_check);
$self = mysql_fetch_row($resultat);
$self = $self[0];
$anz= mysql_num_rows($resultat);
if ($anz>0) {
if ($autor_id == $self)
{ echo "-Tragen Sie ein-"; return true;
}else {
echo "Das Ergebnis wird bereits vom Gegner eingetragen.<br />
Bitte warten bis das Ergebnis drin ist, ansonsten <i><b>den Liga Admin</b></i> kontaktieren.";
return false;
}
}else {
$sql= sprintf("INSERT INTO kii_ergz (
ergz_liga,
ergz_sp,
ergz_author_id,
ergz_author_team,
ergz_sec_id,
ergz_sec_team,
ergz_heim_t,
ergz_gast_t,
ergz_saison
)
VALUES ('%s','%u','%u','%s','%u','%s','%s','%s','%s')",
mysql_real_escape_string($lig),
mysql_real_escape_string($sp),
mysql_real_escape_string($autor_id),
mysql_real_escape_string($autor_team),
mysql_real_escape_string($sec_id),
mysql_real_escape_string($sec_team),
mysql_real_escape_string($team1),
mysql_real_escape_string($team2),
mysql_real_escape_string($saison));
$result3= mysql_query($sql);
return true;
}
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function getResult($id) {
$sql= "SELECT ergz_liga, ergz_sp, ergz_heim_t, ergz_gast_t, ergz_ht, ergz_gt,
ergz_hg, ergz_gg, ergz_hr, ergz_gr, ergz_hgr, ergz_ggr, ergz_sec_flag, ergz_sdt, ergz_author_bericht, ergz_sec_bericht,
DATE_FORMAT( ergz_author_time, '%d.%m.%y %H:%i' ), DATE_FORMAT( ergz_sec_time, '%d.%m.%y %H:%i' ), ergz_author_team, ergz_sec_team, ergz_sch_ht, ergz_sch_gt, ergz_sch_hg, ergz_sch_gg, ergz_sch_hr, ergz_sch_gr, ergz_sch_hgr, ergz_sch_ggr,ergz_heim_t_user,ergz_author_id FROM kii_ergz WHERE ergz_id='".$id."'";
$result= mysql_query($sql);
$resultate= mysql_fetch_row($result);
return $resultate;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function getUserNames($id) {
$sql= sprintf("SELECT user_name FROM phpkit_user,kii_ergz WHERE ergz_id='%u'
AND (select if(ergz_author_team=ergz_heim_t,ergz_author_id,ergz_sec_id))=user_id ",
mysql_real_escape_string($id));
$result= mysql_query($sql);
$heim= mysql_fetch_row($result);
$heim = $heim[0];
$sql= sprintf("SELECT user_name FROM phpkit_user,kii_ergz WHERE ergz_id='%u'
AND (select if(ergz_sec_team=ergz_gast_t,ergz_sec_id,ergz_author_id))=user_id ",
mysql_real_escape_string($id));
$result= mysql_query($sql);
$gast= mysql_fetch_row($result);
$gast = $gast[0];
return array($heim,$gast);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function getUserNames2($id) {
$sql= sprintf("SELECT user_name FROM phpkit_user,kii_ergz WHERE ergz_id='%u'
AND ergz_author_id=user_id",
mysql_real_escape_string($id));
$result= mysql_query($sql);
$heim= mysql_fetch_row($result);
$heim = $heim[0];
$sql= sprintf("SELECT user_name FROM phpkit_user,kii_ergz WHERE ergz_id='%u'
AND ergz_sec_id=user_id",
mysql_real_escape_string($id));
$result= mysql_query($sql);
$gast= mysql_fetch_row($result);
$gast = $gast[0];
return array($heim,$gast);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function setSecBericht($id,$bericht) {
$id = (int) $id;
$bericht = base64_encode($bericht);
$sql= sprintf("UPDATE kii_ergz SET ergz_sec_flag='1', ergz_sec_bericht='%s', ergz_sec_time=NOW() WHERE ergz_id='%u' AND ergz_status='ended' LIMIT 1",
mysql_real_escape_string($bericht),
mysql_real_escape_string($id));
$result= mysql_query($sql);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function checkSEC($id) {
$session_id = session_id();
$id = (int) $id;
//orginal_sec_id
$sql= sprintf("SELECT ergz_sec_id FROM kii_ergz WHERE ergz_id='%u' ",
mysql_real_escape_string($id));
$result= mysql_query($sql);
$datensatz = mysql_fetch_row($result);
$real_sec = $datensatz[0];
//besucher_id
$sql= sprintf("SELECT session_userid FROM phpkit_session WHERE session_id='%s' AND session_userid!=0",
mysql_real_escape_string($session_id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$user_id = $datensatz[0];
//sec_flag
$sql= sprintf("SELECT ergz_sec_flag FROM kii_ergz WHERE ergz_id='%u'",
mysql_real_escape_string($id));
$result= mysql_query($sql);
$datensatz= mysql_fetch_row($result);
$secflag = $datensatz[0];
if (($user_id==$real_sec) && ($secflag!=1)) {
echo '<br /><i>Wenn du möchtest kannst du gern dein Kommentar zum Spiel geben.</i>
<form id="form4839" name="form1" method="post" action="include.php?path=bootybounce/bb_result/berichte.php">';
echo '<input type="hidden" name="the_id" id="the_id" value="'.$id.'"/>
<textarea name="bericht" cols="55" rows="6" onmouseover="this.focus()"></textarea><br />
<input type="submit" name="report" value="Eintragen" /></form>';
}else echo "<i>..noch kein Gegenbericht..</i>";
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function getKurzInfo($insert_id) {
$session_id = session_id();
//hole id von dieser partie
$sql= sprintf("SELECT ergz_liga, ergz_heim_t, ergz_gast_t, ergz_sp FROM kii_ergz WHERE
ergz_id='%u' AND ergz_status='onwork' LIMIT 1",
mysql_real_escape_string($insert_id));
$result = mysql_query($sql);
$datensatz = mysql_fetch_row($result);
$heim = $datensatz[1];
$gast = $datensatz[2];
$sp = $datensatz[3];
return array($heim,$gast,$sp);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function setPlayerDB($playerarray,$insert_id,$was,$was2,$team) {
$saison = $this->getBB("saison");
foreach($playerarray as $player)
{
$sql= sprintf("SELECT player_id FROM kii_player WHERE player_name='%s'
AND player_team='%s' AND player_saison='%s' LIMIT 1",
mysql_real_escape_string($player),
mysql_real_escape_string($team),
mysql_real_escape_string($saison));
$result = mysql_query($sql);
$daten = mysql_fetch_row($result);
if($daten[0]>0)
{
$sql= sprintf("UPDATE kii_player SET %s=%s+1 WHERE player_name='%s' AND player_team='%s' AND player_saison='%s'",
mysql_real_escape_string($was2),
mysql_real_escape_string($was2),
mysql_real_escape_string($player),
mysql_real_escape_string($team),
mysql_real_escape_string($saison));
$result = mysql_query($sql);
}else
{
$sql2= sprintf("INSERT INTO kii_player (
player_name,
player_team,
player_t,
player_g,
player_r,
player_gr,
player_sdt,
player_saison
)
VALUES ('%s','%s','0','0','0','0','0','%s')",
mysql_real_escape_string($player),
mysql_real_escape_string($team),
mysql_real_escape_string($saison));
$result3= mysql_query($sql2);
$sql= sprintf("UPDATE kii_player SET %s=%s+1
WHERE player_name='%s' AND player_team='%s' AND player_saison='%s'",
mysql_real_escape_string($was2),
mysql_real_escape_string($was2),
mysql_real_escape_string($player),
mysql_real_escape_string($team),
mysql_real_escape_string($saison));
$result = mysql_query($sql);
}
}
$komplett = implode("+",$playerarray);
$sql= sprintf("UPDATE kii_ergz SET %s='%s' WHERE ergz_id='%u'",
mysql_real_escape_string($was),
mysql_real_escape_string($komplett),
mysql_real_escape_string($insert_id));
$result = mysql_query($sql);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function setSDT_DB($player,$lig) {
$saison = $this->getBB("saison");
$sql= sprintf("UPDATE kii_player,phpkit_team SET player_sdt=player_sdt+1 WHERE (player_name='%s'
AND player_saison='%s' AND team_liga='%s' AND team_name=player_team)",
mysql_real_escape_string($player),
mysql_real_escape_string($saison),
mysql_real_escape_string($lig));
$result = mysql_query($sql);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function getPartiePlayer($begegnung) {
$zerleg = explode(" - ",$begegnung);
$team1 = $zerleg[0];
$team2 = $zerleg[1];
$sql= sprintf("SELECT (SELECT user_name FROM phpkit_team,phpkit_user WHERE user_id=team_userid AND team_name='%s' LIMIT 1),
(SELECT user_name FROM phpkit_team,phpkit_user WHERE user_id=team_userid AND team_name='%s' LIMIT 1)",
mysql_real_escape_string($team1),
mysql_real_escape_string($team2));
$result = mysql_query($sql);
$daten = mysql_fetch_row($result);
foreach ($daten as $schluessel => $wert)
{
if ($wert=='') { $daten[$schluessel] = "KEIN TRAINER";}
}
if ($daten[0]=='KEIN TRAINER' && $daten[1]=='KEIN TRAINER')
{
$sql= sprintf("SELECT (SELECT user_name FROM kii_int,
phpkit_user WHERE user_id=int_userid AND int_team='%s' LIMIT 1),
(SELECT user_name FROM kii_int,phpkit_user WHERE user_id=int_userid AND int_team='%s' LIMIT 1)",
mysql_real_escape_string($team1),
mysql_real_escape_string($team2));
$result = mysql_query($sql);
$daten = mysql_fetch_row($result);
foreach ($daten as $schluessel => $wert)
{
if ($wert=='') { $daten[$schluessel] = "KEIN TRAINER";}
}
}
return $daten;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function CheckIn($pokal_sieger)
{
$pokal_sieger = explode(" - ",$pokal_sieger);
$pokal = $pokal_sieger[0];
$sieger = $pokal_sieger[1];
$saison = $this->getBB("saison");
$sql= sprintf("SELECT count(*) FROM kii_trophy WHERE trophy_trophy='%s' AND trophy_saison='%s' LIMIT 1",
mysql_real_escape_string($pokal),
mysql_real_escape_string($saison));
$result= mysql_query($sql);
$data = mysql_fetch_row($result);
if ($data[0]=='0')
{
$sql2= sprintf("SELECT team_userid from phpkit_team where team_name ='%s' LIMIT 1",
mysql_real_escape_string($sieger));
$result2= mysql_query($sql2);
$data2 = mysql_fetch_row($result2);
$sieger_user = (int) $data2[0];
if ($sieger_user<1)
{
$sql2= sprintf("SELECT int_userid from kii_int where int_team ='%s' LIMIT 1",
mysql_real_escape_string($sieger));
$result2= mysql_query($sql2);
$data2 = mysql_fetch_row($result2);
$sieger_user = (int) $data2[0];
}
$sql= sprintf("INSERT INTO kii_trophy (
trophy_userid,
trophy_team,
trophy_trophy,
trophy_saison
)
VALUES ('%u','%s','%s','%s')",
mysql_real_escape_string($sieger_user),
mysql_real_escape_string($sieger),
mysql_real_escape_string($pokal),
mysql_real_escape_string($saison));
$result3= mysql_query($sql);
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function CheckIn2($team,$z)
{
$saison = $this->getBB("saison");
$sql2= sprintf("SELECT team_userid,team_liga from phpkit_team where team_name ='%s' LIMIT 1",
mysql_real_escape_string($team));
$result2= mysql_query($sql2);
$data2 = mysql_fetch_row($result2);
$sieger_user = $data2[0];
$liga = $data2[1]." - ".$z;
$sql= sprintf("SELECT count(*) FROM kii_trophy WHERE trophy_trophy='%s' AND trophy_saison='%s' LIMIT 1",
mysql_real_escape_string($liga),
mysql_real_escape_string($saison));
$result= mysql_query($sql);
$data = mysql_fetch_row($result);
if ($data[0]=='0')
{
$sql= sprintf("INSERT INTO kii_trophy (
trophy_userid,
trophy_team,
trophy_trophy,
trophy_saison
)
VALUES ('%u','%s','%s','%s')",
mysql_real_escape_string($sieger_user),
mysql_real_escape_string($team),
mysql_real_escape_string($liga),
mysql_real_escape_string($saison));
$result3= mysql_query($sql);
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function getBestFamousPlayer()
{
$saison = $this->getBB("saison");
$sql2= sprintf("SELECT player_team,player_name,player_t,
team_userid FROM kii_player, phpkit_team
WHERE
player_saison='%s' AND team_name=player_team ORDER BY player_t DESC LIMIT 1",
mysql_real_escape_string($saison));
$result2= mysql_query($sql2);
$data2 = mysql_fetch_row($result2);
$team = $data2[0];
$trophy = "Torschützenkönig der Saison - ".$data2[1]." - ".$data2[2];
$userid = $data2[3];
$sql= sprintf("SELECT count(*) FROM kii_trophy WHERE trophy_trophy='%s' AND trophy_saison='%s' LIMIT 1",
mysql_real_escape_string($trophy),
mysql_real_escape_string($saison));
$result= mysql_query($sql);
$data = mysql_fetch_row($result);
if ($data[0]=='0')
{
$sql= sprintf("INSERT INTO kii_trophy (
trophy_userid,
trophy_team,
trophy_trophy,
trophy_saison
)
VALUES ('%u','%s','%s','%s')",
mysql_real_escape_string($userid),
mysql_real_escape_string($team),
mysql_real_escape_string($trophy),
mysql_real_escape_string($saison));
$result3= mysql_query($sql);
echo "<br />".$trophy;
}
$sql2= sprintf("SELECT player_team,player_name,player_sdt,
team_userid FROM kii_player, phpkit_team
WHERE
player_saison='%s' AND team_name=player_team ORDER BY player_sdt DESC,player_t DESC LIMIT 1",
mysql_real_escape_string($saison));
$result2= mysql_query($sql2);
$data2 = mysql_fetch_row($result2);
$team = $data2[0];
$trophy = "Spieler der Saison - ".$data2[1]." - ".$data2[2];
$userid = $data2[3];
$sql= sprintf("SELECT count(*) FROM kii_trophy WHERE trophy_trophy='%s' AND trophy_saison='%s' LIMIT 1",
mysql_real_escape_string($trophy),
mysql_real_escape_string($saison));
$result= mysql_query($sql);
$data = mysql_fetch_row($result);
if ($data[0]=='0')
{
$sql= sprintf("INSERT INTO kii_trophy (
trophy_userid,
trophy_team,
trophy_trophy,
trophy_saison
)
VALUES ('%u','%s','%s','%s')",
mysql_real_escape_string($userid),
mysql_real_escape_string($team),
mysql_real_escape_string($trophy),
mysql_real_escape_string($saison));
$result3= mysql_query($sql);
echo "<br />".$trophy;
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public function jsicq($teamname){
$sql=sprintf("SELECT user_icqid,team_name,user_id FROM phpkit_user,phpkit_team WHERE user_id = team_userid AND
team_status='aktiv' AND team_name!='%s'
LIMIT 300",
mysql_real_escape_string($teamname),
mysql_real_escape_string($teamname));
$result= mysql_query($sql) or die("1444");
$anz = mysql_num_rows($result);
if ($anz>0) {
for ($i=1;$i<=$anz;$i++)
{
$datensatz= mysql_fetch_row($result);
foreach ($datensatz as $schluessel => $wert)
{
$t_icq .= $wert."_";
}
$t_icq .=" - ";
}
}
return $t_icq;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
}
?> Ich hoffe hier kann mir jemand helfen |
17.01.2011, 13:54
Ähnliche Themen 
