当前位置: 首页>>代码示例>>PHP>>正文

PHP tic_mysql_query函数代码示例

本文整理汇总了PHP中tic_mysql_query函数的典型用法代码示例。如果您正苦于以下问题：PHP tic_mysql_query函数的具体用法？PHP tic_mysql_query怎么用？PHP tic_mysql_query使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。


在下文中一共展示了tic_mysql_query函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: addGalaxieSekScans

function addGalaxieSekScans($galaxiemitglieder)
{
    global $Benutzer;
    global $SQL_DBConn;
    for ($i = 0; $i < sizeof($galaxiemitglieder); $i++) {
        echo $galaxiemitglieder[$i]["galaxie"] . ":" . $galaxiemitglieder[$i]["planet"] . " " . $galaxiemitglieder[$i]["name"] . " -> " . $galaxiemitglieder[$i]["punkte"] . "<br>\n";
        addgnuser($galaxiemitglieder[$i]["galaxie"], $galaxiemitglieder[$i]["planet"], $galaxiemitglieder[$i]["name"]);
        $delcommand = "DELETE FROM `gn4scans` WHERE rg='" . $galaxiemitglieder[$i]["galaxie"] . "' AND rp='" . $galaxiemitglieder[$i]["planet"] . "' AND type='0';";
        $SQL_Result = tic_mysql_query($delcommand, $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error());
        $addcommand = "INSERT INTO `gn4scans` (type, zeit, g, p, rg, rp, gen, pts, s, d, me, ke, a)\n\t\tVALUES ('0', '" . date("H:i d.m.Y") . "', '" . $Benutzer['galaxie'] . "', '" . $Benutzer['planet'] . "', '" . $galaxiemitglieder[$i]["galaxie"] . "', '" . $galaxiemitglieder[$i]["planet"] . "', '99', '" . $galaxiemitglieder[$i]["punkte"] . "', '" . $galaxiemitglieder[$i]["flotte"] . "', '" . $galaxiemitglieder[$i]["geschuetze"] . "', '" . $galaxiemitglieder[$i]["mextraktoren"] . "', '" . $galaxiemitglieder[$i]["kextraktoren"] . "', '" . $galaxiemitglieder[$i]["asteroiden"] . "');";
        $SQL_Result = tic_mysql_query($addcommand, $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error());
    }
}
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:13，代码来源:function.addscan.php

示例2: print_table

function print_table($query)
{
    global $Benutzer;
    global $AllianzTag;
    $SQL_Result = tic_mysql_query($query, $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error());
    $SQL_Num = mysql_num_rows($SQL_Result);
    if ($SQL_Num == 0) {
        echo '<tr><td colspan="4"><i>Keine Eintr&auml;ge gefunden</i></td></tr>';
    } else {
        for ($n = 0; $n < $SQL_Num; $n++) {
            $ftype = 'normal';
            if (mysql_result($SQL_Result, $n, 'umod') != '') {
                $ftype = 'umode';
            }
            if (mysql_result($SQL_Result, $n, 'id') == $Benutzer['id']) {
                $ftype = 'myself';
            }
            if (mysql_result($SQL_Result, $n, 'value') > 0) {
                if ($n < 9) {
                    $s = "0" . ($n + 1);
                } else {
                    $s = $n + 1;
                }
                $gala = mysql_result($SQL_Result, $n, 'gala');
                $planet = mysql_result($SQL_Result, $n, 'planet');
                if (strlen($planet) == 1) {
                    $planet = "0" . $planet;
                }
                echo '<tr>';
                echo '<td class="field' . $ftype . 'light">' . $s . '.</td>';
                echo '<td class="field' . $ftype . 'dark" align="center">[' . $AllianzTag[mysql_result($SQL_Result, $n, 'allianz')] . ']</td>';
                echo '<td class="field' . $ftype . 'light" align="right">' . $gala . ':' . $planet . '</td>';
                echo '<td  class="field' . $ftype . 'dark">' . '<a href="./main.php?modul=anzeigen&amp;id=' . mysql_result($SQL_Result, $n, 'id') . '">' . mysql_result($SQL_Result, $n, 'name') . '</a></td>';
                echo '<td class="field' . $ftype . 'light" align="right">' . ZahlZuText(mysql_result($SQL_Result, $n, 'value')) . '</td>';
                echo '</tr>';
            }
        }
    }
}
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:39，代码来源:inc_rankings.php

示例3: icq_auslesen

function icq_auslesen()
{
    global $RangName;
    global $Benutzer;
    $icq_lnk_about = "http://www.icq.com/people/about_me.php?uin=";
    $icq_lnk_online = "http://web.icq.com/whitepages/online?icq=";
    $bild = 5;
    $breite = 18;
    $hoehe = 18;
    $qry = "SELECT gn4accounts.name AS name, " . "messangerID AS icq, " . "gn4allianzen.name AS allianz, " . "galaxie, " . "planet, " . "rang " . "FROM gn4accounts JOIN gn4allianzen ON gn4accounts.allianz = gn4allianzen.id " . "WHERE gn4accounts.ticid = '{$Benutzer['ticid']}' AND messangerID != '' " . "ORDER BY gn4accounts.allianz,galaxie,planet;";
    $result = tic_mysql_query($qry);
    $row = mysql_fetch_array($result);
    for ($i = 0; $row != FALSE; $row = mysql_fetch_array($result), $i++) {
        $row['icq'] = preg_replace("/[^0-9]+/", '', $row['icq']);
        if (!preg_match('/^[0-9]{6,9}$/', $row['icq'])) {
            $i--;
            continue;
        }
        if ($i % 2 == 0) {
            echo "<tr class=\"fieldnormallight\">\n";
        } else {
            echo "<tr class=\"fieldnormaldark\">\n";
        }
        echo '<td align="middle">';
        echo "<img src=\"{$icq_lnk_online}{$row['icq']}&img={$bild}\" width=\"{$breite}\" height=\"{$hoehe}\" border=\"0\"></a>";
        echo "</td>\n";
        echo '<td align="middle">';
        echo "<a href=\"{$icq_lnk_about}{$row['icq']}\" target=\"_blank\" class=\"nlink\">" . number_format($row['icq'], 0, ',', '-');
        echo "</td>\n";
        echo "<td align=\"middle\">{$row['allianz']}</td>\n";
        echo "<td align=\"middle\">{$row['galaxie']}</td>\n";
        echo "<td align=\"middle\">{$row['planet']}</td>\n";
        echo "<td align=\"middle\">{$row['name']}</td>\n";
        echo "<td align=\"middle\">{$RangName[$row['rang']]}</td>\n";
        echo "</tr>\n";
    }
}
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:37，代码来源:inc_icq.php

示例4: tic_mysql_query

 echo '</TR>';
 //            }
 ?>
 <TR>
   <TD><font size="-1"><BR>
     </font></TD>
 </TR>
 <TR>
   <TD>
     <P CLASS="dunkel"><B><font size="-1">Rückflug:</font></B></P>
   </TD>
 </TR>
 <TR>
   <TD> <font size="-1">
     <?php 
 $SQL_Result = tic_mysql_query('SELECT * FROM `gn4flottenbewegungen` WHERE ( modus="0" or modus="3" or modus="4" ) AND angreifer_galaxie="' . $zeig_galaxie . '" AND angreifer_planet="' . $zeig_planet . '" ORDER BY eta;', $SQL_DBConn) or $error_code = 4;
 $SQL_Num = mysql_num_rows($SQL_Result);
 if ($SQL_Num == 0) {
     echo '<P CLASS="hell">Es befindet sich keine Flotte auf dem Rückflug.</P>';
 } else {
     echo '<CENTER><P CLASS="hell">';
     echo '  Folgende Flotten sind auf dem Rückflug:';
     echo '  <TABLE>';
     for ($n = 0; $n < $SQL_Num; $n++) {
         echo '<TR><TD><font size="-1">Name: <B>' . mysql_result($SQL_Result, $n, 'verteidiger_galaxie') . ':' . mysql_result($SQL_Result, $n, 'verteidiger_planet') . '</B></font></TD>';
         $disptime = mysql_result($SQL_Result, $n, 'eta') * $Ticks['lange'] - $tick_abzug;
         $disptime = getime4display($disptime);
         echo '<TD><font size="-1">ETA: <B>' . $disptime . '</B></font></TD>';
         echo '<TD><font size="-1">Flotte: ' . $flottennr[mysql_result($SQL_Result, $n, 'flottennr')] . '</font></TD>';
         echo '<TD>';
         //                            if ($Benutzer['rang'] > $Rang_GC || !($Benutzer['rang'] <= $Rang_GC && $Benutzer['galaxie'] != $zeig_galaxie)) echo '<A HREF="./main.php?modul=anzeigen&id='.$id.'&action=flotteloeschen&flottenid='.mysql_result($SQL_Result, $n, 'id').'">Löschen</A>, <A HREF="./main.php?modul=flotteaendern&id='.$id.'&flottenid='.mysql_result($SQL_Result, $n, 'id').'">Ändern</A></TD>';
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:31，代码来源:inc_anzeigen.php

示例5: tic_mysql_query

<?php

$SQL_Result = tic_mysql_query('SELECT * FROM `gn4accounts` WHERE id="' . $_SESSION['userid'] . '" and ticid="' . $Benutzer['ticid'] . '";', $SQL_DBConn);
$rang = mysql_result($SQL_Result, 0, 'rang');
if ($rang == $Rang_STechniker) {
    $SQL_Result = tic_mysql_query('UPDATE `gn4vars` SET value="' . $_POST['newmeta'] . '" WHERE name="ticeb" and ticid="' . $Benutzer['ticid'] . '";', $SQL_DBConn);
    $SQL_Result = tic_mysql_query('UPDATE `gn4vars` SET value="' . $_POST['newsystemnachricht'] . '" WHERE name="systemnachricht" and ticid="' . $Benutzer['ticid'] . '";', $SQL_DBConn);
    $SQL_Result = tic_mysql_query('UPDATE `gn4vars` SET value="' . $_POST['newbotpw'] . '" WHERE name="botpw" and ticid="' . $Benutzer['ticid'] . '";', $SQL_DBConn);
    $systemnachricht = $_POST['newsystemnachricht'];
}
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:10，代码来源:function.ticeinstellung.php

示例6: LogAction

    $action = $_POST['action'];
} else {
    if (isset($_GET['action']) && $_GET['action'] != "") {
        $action = $_GET['action'];
    } else {
        $action = "";
    }
}
// Incoming makieren
if (isset($_GET['need_planet']) && isset($_GET['need_galaxie'])) {
    LogAction($_GET['need_galaxie'] . ":" . $_GET['need_planet'] . " -> Unsafe", LOG_SETSAFE);
    tic_mysql_query("UPDATE `gn4flottenbewegungen` SET save='0' WHERE verteidiger_galaxie='" . $_GET['need_galaxie'] . "' AND verteidiger_planet='" . $_GET['need_planet'] . "'") or die(tic_mysql_error(__FILE__, __LINE__));
}
if (isset($_GET['needno_planet']) && isset($_GET['needno_galaxie'])) {
    LogAction($_GET['needno_galaxie'] . ":" . $_GET['needno_planet'] . " -> Safe", LOG_SETSAFE);
    tic_mysql_query("UPDATE `gn4flottenbewegungen` SET save='1' WHERE verteidiger_galaxie='" . $_GET['needno_galaxie'] . "' AND verteidiger_planet='" . $_GET['needno_planet'] . "'") or die(tic_mysql_error(__FILE__, __LINE__));
}
if (isset($irc_log)) {
    if ($irc_log) {
        include 'irc-scans.inc.php';
    }
}
// Funktion einbinden
if ($action != "") {
    include "./function." . $action . ".php";
}
?>
<!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="de" lang="de" dir="ltr">
	<head>
		<title>TIC - <?php
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:31，代码来源:main.php

示例7: tic_mysql_query

      <td>ICQ</td>
      <td>Zusatzinfos</td>
      <?php 
if ($Benutzer['rang'] > $Rang_GC) {
    // vize admiral oder mehr
    echo '<td>Aktion</td>';
}
?>
    </tr>
        <?php 
$sql = 'SELECT name, galaxie, planet, handy, ';
$sql .= 'messangerID, infotext, id ';
$sql .= 'FROM `gn4accounts`';
$sql .= 'where ticid="' . $Benutzer['ticid'] . '" ORDER BY galaxie, planet';
$color = 0;
$SQL_Result = tic_mysql_query($sql, $SQL_DBConn);
for ($i = 0; $i < mysql_num_rows($SQL_Result); $i++) {
    $color = !$color;
    $name = mysql_result($SQL_Result, $i, 'name');
    $gala = mysql_result($SQL_Result, $i, 'galaxie');
    $gala = $gala . ':' . mysql_result($SQL_Result, $i, 'planet');
    $telno = mysql_result($SQL_Result, $i, 'handy');
    $icq = mysql_result($SQL_Result, $i, 'messangerID');
    $infotext = mysql_result($SQL_Result, $i, 'infotext');
    $teleid = mysql_result($SQL_Result, $i, 'id');
    // used later, to delete the record
    echo '<tr align="left" class="fieldnormal' . ($color ? 'light' : 'dark') . '">';
    echo '<td align="center">' . $gala . '</td>';
    echo '<td>' . $name . '</td>';
    echo '<td>' . $telno . '</td>';
    echo '<td>' . $icq . '</td>';
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:31，代码来源:inc_telelist.php

示例8: tic_mysql_query

         $start = 0;
     }
     $SQL_Result = tic_mysql_query("SELECT name, accid, rang, allianz, zeit, aktion, ip FROM gn4log WHERE" . $SQL_where . " AND type='" . $_GET['type'] . "' ORDER BY id DESC LIMIT " . $start . "," . LOG_PER_PAGE) or die(tic_mysql_error(__FILE__, __LINE__));
     echo "<div style=\"font-size:9pt;font-weight:bold;\">T.I.C Log - " . $typetostring[$_GET['type']] . "</div><table class=\"datatable\" align=\"center\"><tr class=\"datatablehead\"><th>Zeit</th><th>Meta</th><th>Benutzer</th><th>Meldung</th><th>IP</th></tr>";
     $i = 0;
     while ($row = mysql_fetch_assoc($SQL_Result)) {
         echo "<tr class=\"fieldnormal" . $style[$i % 2] . "\">\n\t\t\t\t\t\t<td>" . $row['zeit'] . "</td>\n\t\t\t\t\t\t<td>" . (isset($AllianzInfo[$row['allianz']]['metaname']) ? $AllianzInfo[$row['allianz']]['metaname'] : "") . "</td><td>" . (isset($RangImage[$row['rang']]) ? "<img src=\"" . $RangImage[$row['rang']] . "\" alt=\"" . $RangName[$row['rang']] . "\" width=\"20\" height=\"20\" />" : $row['rang']) . "<a href=\"?modul=anzeigen&amp;id=" . $row['accid'] . "\">" . (isset($AllianzTag[$row['allianz']]) ? "[" . $AllianzTag[$row['allianz']] . "]" : "") . $row['name'] . "</a></td><td>" . $row['aktion'] . "</td><td>" . $row['ip'] . "</td></tr>";
         $i++;
     }
     if ($i == 0) {
         echo "<tr class=\"fieldnormallight\"><td colspan=\"4\">Es sind keine Logeinträge fr diesen Typ vorhanden.</td></tr>";
     }
     echo "<tr><td colspan=\"4\">Seite: " . constructPageIndex("?modul=log&amp;type=" . $_GET['type'], $start, $count[0], LOG_PER_PAGE) . "</td></tr>\n";
     echo "</table>[<a href=\"?modul=log\">Zurück</a>]";
 } else {
     $SQL_Result = tic_mysql_query("SELECT type, COUNT(type) FROM gn4log WHERE" . $SQL_where . " GROUP BY type") or die(tic_mysql_error(__FILE__, __LINE__));
     while ($row = mysql_fetch_row($SQL_Result)) {
         $count[$row[0]] = $row[1];
     }
     $i = 0;
     echo "<table cellpadding=\"5\" align=\"center\"><tr><th colspan=\"3\">T.I.C Log</th></tr>";
     foreach ($typetostring as $type => $string) {
         if ($i == 0) {
             echo "<tr>";
         }
         $i++;
         echo "<td><a href=\"?modul=log&amp;type=" . $type . "\"><img src=\"bilder/icons/folder.gif\" alt=\"\" border=\"0\" /> " . $string . "(" . (isset($count[$type]) ? $count[$type] : "0") . ")</a></td>";
         if ($i == 3) {
             echo "</tr>";
             $i = 0;
         }
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:31，代码来源:inc_log.php

示例9: addgnuser

        }
        if (!isset($_POST['txtAccGalaxie'])) {
            $_POST['txtAccGalaxie'] = '';
        }
        if (!isset($_POST['txtAccPlanet'])) {
            $_POST['txtAccPlanet'] = '';
        }
        if (!isset($_POST['txtAccPasswort'])) {
            $_POST['txtAccPasswort'] = '';
        }
        if (!isset($_POST['lstAllianz'])) {
            $_POST['lstAllianz'] = '';
        }
        if (!isset($_POST['lstRang'])) {
            $_POST['lstRang'] = 0;
        }
        if ($_POST['txtAccName'] == '' || $_POST['txtAccGalaxie'] == '' || $_POST['txtAccPlanet'] == '' || $_POST['txtAccPasswort'] == '' || $_POST['lstAllianz'] == '') {
            $error_code = 6;
        } else {
            if ($Benutzer['rang'] <= $_POST['lstRang']) {
                $error_code = 5;
            } else {
                addgnuser($_POST['txtAccGalaxie'], $_POST['txtAccPlanet'], $_POST['txtAccName']);
                $SQL_Result = tic_mysql_query('INSERT INTO `gn4accounts` (ticid, name, passwort, galaxie, planet, rang, allianz) VALUES ("' . $AllianzInfo[$_POST['lstAllianz']]['meta'] . '", "' . $_POST['txtAccName'] . '", "' . md5($_POST['txtAccPasswort']) . '","' . $_POST['txtAccGalaxie'] . '", "' . $_POST['txtAccPlanet'] . '", "' . $_POST['lstRang'] . '", "' . $_POST['lstAllianz'] . '")', $SQL_DBConn) or $error_code = 7;
                if ($error_code == 0) {
                    LogAction("Account erstellt: Name=" . $_POST['txtAccName'] . "; Koordinaten=" . $_POST['txtAccGalaxie'] . ":" . $_POST['txtAccPlanet'] . "; Rang=" . $_POST['lstRang'] . "; Allianz=" . $_POST['lstAllianz'] . ";");
                }
            }
        }
    }
}
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:31，代码来源:function.accounterstellen.php

示例10: mili_edit

function mili_edit()
{
    global $SQL_DBConn;
    $qry = 'sf0j, sf0b, sf0f, sf0z, sf0kr, sf0sa, sf0t, sf0ko, sf0ka, sf0su,';
    $qry = $qry . 'sf1j, sf1b, sf1f, sf1z, sf1kr, sf1sa, sf1t, sf1ko, sf1ka, sf1su,';
    $qry = $qry . 'sf2j, sf2b, sf2f, sf2z, sf2kr, sf2sa, sf2t, sf2ko, sf2ka, sf2su';
    $SQL_Result2 = tic_mysql_query('SELECT ' . $qry . ' FROM `gn4scans` WHERE rg="' . $_POST['galakoord'] . '" AND rp="' . $_POST['planetkoord'] . '" AND type="2";', $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error());
    $SQL_Num = mysql_num_rows($SQL_Result2);
    if ($SQL_Num == 0) {
        // keine scans da
        $scan_rn = gnuser($_POST['galakoord'], $_POST['planetkoord']);
        // J�er
        $scan_sf0j = 0;
        $scan_sf1j = 0;
        $scan_sf2j = 0;
        // bomber
        $scan_sf0b = 0;
        $scan_sf1b = 0;
        $scan_sf2b = 0;
        // fregs
        $scan_sf0f = 0;
        $scan_sf1f = 0;
        $scan_sf2f = 0;
        // zerries
        $scan_sf0z = 0;
        $scan_sf1z = 0;
        $scan_sf2z = 0;
        // kreuzer
        $scan_sf0kr = 0;
        $scan_sf1kr = 0;
        $scan_sf2kr = 0;
        // schlachter
        $scan_sf0sa = 0;
        $scan_sf1sa = 0;
        $scan_sf2sa = 0;
        // tr�er
        $scan_sf0t = 0;
        $scan_sf1t = 0;
        $scan_sf2t = 0;
        // Kaper
        $scan_sf0ka = 0;
        $scan_sf1ka = 0;
        $scan_sf2ka = 0;
        // schutzies
        $scan_sf0su = 0;
        $scan_sf1su = 0;
        $scan_sf2su = 0;
    } else {
        // scan ist in db vorhanden
        $scan_rn = gnuser($_POST['galakoord'], $_POST['planetkoord']);
        // J�er
        $scan_sf0j = mysql_result($SQL_Result2, 0, 'sf0j');
        $scan_sf1j = mysql_result($SQL_Result2, 0, 'sf1j');
        $scan_sf2j = mysql_result($SQL_Result2, 0, 'sf2j');
        // bomber
        $scan_sf0b = mysql_result($SQL_Result2, 0, 'sf0b');
        $scan_sf1b = mysql_result($SQL_Result2, 0, 'sf1b');
        $scan_sf2b = mysql_result($SQL_Result2, 0, 'sf2b');
        // fregs
        $scan_sf0f = mysql_result($SQL_Result2, 0, 'sf0f');
        $scan_sf1f = mysql_result($SQL_Result2, 0, 'sf1f');
        $scan_sf2f = mysql_result($SQL_Result2, 0, 'sf2f');
        // zerries
        $scan_sf0z = mysql_result($SQL_Result2, 0, 'sf0z');
        $scan_sf1z = mysql_result($SQL_Result2, 0, 'sf1z');
        $scan_sf2z = mysql_result($SQL_Result2, 0, 'sf2z');
        // kreuzer
        $scan_sf0kr = mysql_result($SQL_Result2, 0, 'sf0kr');
        $scan_sf1kr = mysql_result($SQL_Result2, 0, 'sf1kr');
        $scan_sf2kr = mysql_result($SQL_Result2, 0, 'sf2kr');
        // schlachter
        $scan_sf0sa = mysql_result($SQL_Result2, 0, 'sf0sa');
        $scan_sf1sa = mysql_result($SQL_Result2, 0, 'sf1sa');
        $scan_sf2sa = mysql_result($SQL_Result2, 0, 'sf2sa');
        // tr�er
        $scan_sf0t = mysql_result($SQL_Result2, 0, 'sf0t');
        $scan_sf1t = mysql_result($SQL_Result2, 0, 'sf1t');
        $scan_sf2t = mysql_result($SQL_Result2, 0, 'sf2t');
        // Kaper
        $scan_sf0ka = mysql_result($SQL_Result2, 0, 'sf0ka');
        $scan_sf1ka = mysql_result($SQL_Result2, 0, 'sf1ka');
        $scan_sf2ka = mysql_result($SQL_Result2, 0, 'sf2ka');
        // schutzies
        $scan_sf0su = mysql_result($SQL_Result2, 0, 'sf0su');
        $scan_sf1su = mysql_result($SQL_Result2, 0, 'sf1su');
        $scan_sf2su = mysql_result($SQL_Result2, 0, 'sf2su');
    }
    ?>
<form name="form1" method="post" action="./main.php?modul=scans">
  <input type="hidden" name="action" value="scan_edit" />
  <input type="hidden" name="scanart" value="mili">
  <input type="hidden" name="galakoord" value="<?php 
    echo $_POST['galakoord'];
    ?>
" />
  <input type="hidden" name="planetkoord" value="<?php 
    echo $_POST['planetkoord'];
    ?>
" />
  <input type="hidden" name="txtScanGalaxie" value="<?php 
//.........这里部分代码省略.........
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:101，代码来源:inc_scan_editor.php

示例11: tic_mysql_query

                $eintrag_eta = (int) (($ankunft - $akt_time) / $tsec);
                $SQL_Result2 = tic_mysql_query('UPDATE `gn4flottenbewegungen` SET eta="' . $eintrag_eta . '" WHERE id="' . $eintrag_id . '" ;', $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error());
                //echo "Hin: UPDATE `gn4flottenbewegungen` SET eta='$eintrag_eta' WHERE id='$eintrag_id';<br />";
            } elseif ($flugzeit_ende > $akt_time) {
                $eintrag_flugzeit = (int) (($flugzeit_ende - $akt_time) / $tsec);
                $SQL_Result2 = tic_mysql_query('UPDATE `gn4flottenbewegungen` SET flugzeit="' . $eintrag_flugzeit . '", eta=0 WHERE id="' . $eintrag_id . '" ;', $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error());
                //echo "Ang/Vert: UPDATE `gn4flottenbewegungen` SET flugzeit='$eintrag_flugzeit', eta=0 WHERE id='.$eintrag_id.';'<br />";
            } elseif ($ruckflug_ende <= $akt_time) {
                $SQL_Result2 = tic_mysql_query('DELETE FROM `gn4flottenbewegungen` WHERE id=' . $eintrag_id, $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error());
                //echo "ENDE: DELETE FROM `gn4flottenbewegungen` WHERE id=$eintrag_id<br />";
            } elseif ($ruckflug_ende > $akt_time) {
                if ($eintrag_modus == 1) {
                    $eintrag_eta = (int) (($ruckflug_ende - $akt_time) / $tsec);
                    $SQL_Result2 = tic_mysql_query('UPDATE `gn4flottenbewegungen` SET modus="3", flugzeit="0", eta="' . $eintrag_eta . '" WHERE id="' . $eintrag_id . '";', $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error());
                    //echo "Rück: UPDATE `gn4flottenbewegungen` SET modus='0', flugzeit='0', eta='$eintrag_eta' WHERE id='$eintrag_id';'<br />";
                }
                if ($eintrag_modus == 2) {
                    $eintrag_eta = (int) (($ruckflug_ende - $akt_time) / $tsec);
                    $SQL_Result2 = tic_mysql_query('UPDATE `gn4flottenbewegungen` SET modus="4", flugzeit="0", eta="' . $eintrag_eta . '" WHERE id="' . $eintrag_id . '";', $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error());
                    //echo "Rück: UPDATE `gn4flottenbewegungen` SET modus='0', flugzeit='0', eta='$eintrag_eta' WHERE id='$eintrag_id';'<br />";
                }
            }
        }
    }
    //echo 'UPDATE `gn4vars` SET value="'.$minute_naechste.'" WHERE name="lasttick_minute";<br>';
    //	echo 'UPDATE `gn4vars` SET value="'.date('H').':'.date('i').':'.date('s').'" WHERE name="lasttick";';
    //	$SQL_Result = tic_mysql_query('UPDATE `gn4vars` SET value="'.$minute_naechste.'" WHERE name="lasttick_minute";', $SQL_DBConn) or $error_code = 7;
    $time = $null_ticks * $tsec;
    $SQL_Result = tic_mysql_query('UPDATE `gn4vars` SET value="' . date("H:i:s", $time) . '" WHERE name="lasttick";', $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error());
    include "cleanscans.php";
}
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:31，代码来源:cron.php

示例12: elseif

        }
    }
}
if ($md_orderby == "sektor") {
    $orderstring = "galaxie " . $md_orderdir . ", planet " . $md_orderdir;
} elseif ($md_orderby == "rang") {
    $orderstring = "rang " . $md_orderdir . ", galaxie , planet";
} elseif ($md_orderby == "name") {
    $orderstring = "name " . $md_orderdir;
}
switch ($mode) {
    case 1:
    case 2:
    case 3:
        $SQL_Query = "\n\t\t\t\tSELECT gn4accounts.* FROM gn4accounts\n\t\t\t\tLEFT JOIN gn4allianzen ON gn4accounts.allianz = gn4allianzen.id\n\t\t\t\tWHERE gn4allianzen.ticid='" . $_SESSION['metanr'] . "' ORDER BY " . $orderstring . ";";
        break;
    case 4:
        $SQL_Query = "SELECT * FROM gn4accounts WHERE allianz=" . $allianz . " ORDER BY " . $orderstring . ";";
        break;
    case 5:
        $SQL_Query = "SELECT * FROM gn4accounts WHERE galaxie=" . $Benutzer['galaxie'] . " ORDER BY " . $orderstring . ";";
        break;
}
$SQL_Result_user = tic_mysql_query($SQL_Query, $SQL_DBConn);
// or error("Error while bilding 'taktik' (step 1).<br>".$SQL_Query, ERROR_SQL, false);
$SQL_Num_user = mysql_num_rows($SQL_Result_user);
$time_online = time() - 300;
include './inc_taktikbildschirm' . $Benutzer['tcausw'] . '.php';
?>
<!-- ENDE: inc_taktikbildschirm -->
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:30，代码来源:inc_taktikbildschirm.php

示例13: tic_mysql_query

<?php

if ($Benutzer['rang'] >= RANG_TECHNIKER) {
    if (isset($_POST['newmeta']) && $Benutzer['rang'] == RANG_STECHNIKER) {
        tic_mysql_query('insert INTO `gn4meta` (name,duell,wars,naps,bnds,sysmsg) VALUES ("' . $_POST['meta'] . '", "' . $_POST['duell'] . '", "' . $_POST['wars'] . '", "' . $_POST['naps'] . '","' . $_POST['bnds'] . '" , "' . $_POST['sysmsg'] . '");', __FILE__, __LINE__);
        $newmetaid = mysql_insert_id();
        //		echo $_POST['meta'].' angelegt!';
    }
    if (isset($_POST['metaspeichern'])) {
        if ($Benutzer['rang'] == RANG_TECHNIKER) {
            $_POST['metaid'] == $Benutzer['ticid'];
        }
        tic_mysql_query('Update `gn4meta` set name="' . $_POST['meta'] . '", duell="' . $_POST['duell'] . '", naps="' . $_POST['naps'] . '", bnds="' . $_POST['bnds'] . '", wars="' . $_POST['wars'] . '", sysmsg="' . $_POST['sysmsg'] . '" where id="' . $_POST['metaid'] . '" ;', __FILE__, __LINE__);
        //	echo '�derung gespeichert';
    }
    if (isset($_POST['metadelet']) && $Benutzer['rang'] == RANG_STECHNIKER) {
        $SQL_Result = tic_mysql_query('Select id FROM `gn4allianzen` where ticid="' . $_POST['metaid'] . '";', __FILE__, __LINE__);
        if (mysql_num_rows($SQL_Result) != '0') {
            LogAction($Benutzer['name'] . ' hat Versucht den Meta mit der id ' . $_POST['metaid'] . ' zul&ouml;schen ohne die Allianzen vorher zu l&ouml;schen !');
            $metaerror = "Es m&uuml;ssen erst die Allianzen gel&ouml;scht werden bevor das Meta gel&ouml;scht werdne kann!";
        } else {
            tic_mysql_query('DELETE FROM `gn4meta` WHERE id="' . $_POST['metaid'] . '"', __FILE__, __LINE__);
            unset($_POST['metaid']);
        }
    }
}
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:26，代码来源:function.management_meta.php

示例14: htmlentities

<?php

$handy = htmlentities($_POST['handy']);
$messangerID = htmlentities($_POST['icq']);
$ticscreen = htmlentities($_POST['ticscreen']);
$infotext = htmlentities($_POST['infotext']);
$authnick = htmlentities($_POST['authnick']);
$incfreigabe = htmlentities($_POST['check']);
$lstZeitformat = htmlentities($_POST['lstZeitformat']);
if ($incfreigabe == '') {
    $incfreigabe = 0;
} else {
    $incfreigabe = 1;
}
$sql = "Update gn4accounts set handy='{$handy}', infotext='{$infotext}', authnick='{$authnick}', tcausw='{$ticscreen}', zeitformat='{$lstZeitformat}', messangerID='{$messangerID}', help='{$incfreigabe}' where id=" . $Benutzer["id"] . ";";
$SQL_Result = tic_mysql_query($sql);
$Benutzer["zeitformat"] = $lstZeitformat;
$Benutzer["help"] = $incfreigabe;
$Benutzer['tcausw'] = $ticscreen;
//echo $sql;
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:20，代码来源:function.personlich.php

示例15: tic_mysql_query

<?php

$SQL_Result = tic_mysql_query('SELECT * FROM `gn4vars` ORDER BY id;');
for ($n = 0; $n < mysql_num_rows($SQL_Result); $n++) {
    $var = mysql_result($SQL_Result, $n, 'name');
    ${$var} = mysql_result($SQL_Result, $n, 'value');
}
$SQL_Result = tic_mysql_query("SELECT * FROM gn4meta WHERE id = '" . $Benutzer['ticid'] . "'") or die(tic_mysql_error(__FILE__, __LINE__));
$MetaInfo = mysql_fetch_assoc($SQL_Result);
// Allianzen
$SQL_Result = tic_mysql_query("SELECT a.*, b.name as metaname FROM `gn4allianzen` as a LEFT JOIN gn4meta as b ON(a.ticid = b.id) ORDER BY tag;", $SQL_DBConn) or $error_code = 4;
$SQL_Num = mysql_num_rows($SQL_Result);
if ($SQL_Num == 0) {
    $error_code = 12;
} else {
    for ($n = 0; $n < $SQL_Num; $n++) {
        $AllianzName[mysql_result($SQL_Result, $n, 'id')] = mysql_result($SQL_Result, $n, 'name');
        $AllianzTag[mysql_result($SQL_Result, $n, 'id')] = mysql_result($SQL_Result, $n, 'tag');
        $AllianzInfo[mysql_result($SQL_Result, $n, 'id')]['name'] = mysql_result($SQL_Result, $n, 'name');
        $AllianzInfo[mysql_result($SQL_Result, $n, 'id')]['tag'] = mysql_result($SQL_Result, $n, 'tag');
        $AllianzInfo[mysql_result($SQL_Result, $n, 'id')]['meta'] = mysql_result($SQL_Result, $n, 'ticid');
        $AllianzInfo[mysql_result($SQL_Result, $n, 'id')]['metaname'] = mysql_result($SQL_Result, $n, 'metaname');
        $AllianzInfo[mysql_result($SQL_Result, $n, 'id')]['info_bnds'] = mysql_result($SQL_Result, $n, 'info_bnds');
        $AllianzInfo[mysql_result($SQL_Result, $n, 'id')]['info_naps'] = mysql_result($SQL_Result, $n, 'info_naps');
        $AllianzInfo[mysql_result($SQL_Result, $n, 'id')]['info_inoffizielle_naps'] = mysql_result($SQL_Result, $n, 'info_inoffizielle_naps');
        $AllianzInfo[mysql_result($SQL_Result, $n, 'id')]['info_kriege'] = mysql_result($SQL_Result, $n, 'info_kriege');
        $AllianzInfo[mysql_result($SQL_Result, $n, 'id')]['code'] = mysql_result($SQL_Result, $n, 'code');
        $AllianzInfo[mysql_result($SQL_Result, $n, 'id')]['blind'] = mysql_result($SQL_Result, $n, 'blind');
    }
}
$tick_abzug = intval(date('i') / $Ticks['lange']);
开发者ID:albertlast，项目名称:ticenter_tic，代码行数:31，代码来源:vars.php


注：本文中的tic_mysql_query函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。