本文整理汇总了PHP中tic_mysql_query函数的典型用法代码示例。如果您正苦于以下问题:PHP tic_mysql_query函数的具体用法?PHP tic_mysql_query怎么用?PHP tic_mysql_query使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了tic_mysql_query函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的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ä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&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&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&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&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öschen ohne die Allianzen vorher zu löschen !');
$metaerror = "Es müssen erst die Allianzen gelöscht werden bevor das Meta gelö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
示例16: str_replace
$_POST['txtTitel'] = '';
}
if (!isset($_POST['txtText'])) {
$_POST['txtText'] = '';
}
if (!isset($_POST['txtHC'])) {
$_POST['txtHC'] = '';
}
if ($_POST['txtTitel'] == '' || $_POST['txtText'] == '') {
$error_code = 6;
} else {
$_POST['txtText'] = str_replace("\n", '<BR>', $_POST['txtText']);
$ticid = $Benutzer['ticid'];
if ($_POST['txtHC'] == 'HC') {
$ticid = "H" . $Benutzer['ticid'];
} else {
if ($_POST['txtHC'] == 'SHC') {
$ticid = "SHC";
} else {
if ($_POST['txtHC'] == 'alle') {
$ticid = "alle";
}
}
}
$SQL_Result = tic_mysql_query('INSERT INTO `gn4nachrichten` (ticid, name, zeit, titel, text) VALUES ("' . $ticid . '", "' . $Benutzer['galaxie'] . ':' . $Benutzer['planet'] . ' ' . $Benutzer['name'] . ' (' . $RangName[$Benutzer['rang']] . ' @ [' . $AllianzTag[$Benutzer['allianz']] . '])", "' . date("H") . ':' . date("i") . ' ' . date("d") . '.' . date("m") . '.' . date("Y") . '", "' . $_POST['txtTitel'] . '", "' . $_POST['txtText'] . '")', $SQL_DBConn) or $error_code = 7;
if ($error_code == 0) {
LogAction("Nachricht geschrieben: Titel='" . $_POST['txtTitel'] . "';");
}
}
}
}
开发者ID:albertlast,项目名称:ticenter_tic,代码行数:31,代码来源:function.nachrichtschreiben.php
示例17: tic_mysql_query
<?php
if ($_POST['action'] == 'settaktiksort') {
$SQL_command = 'UPDATE `gn4accounts` SET taktiksort="' . $_POST['taktik_sort'] . '" WHERE id="' . $Benutzer['id'] . '";';
$SQL_Result = tic_mysql_query($SQL_command, $SQL_DBConn) or $error_code = 7;
$Benutzer['taktiksort'] = $_POST['taktik_sort'];
}
开发者ID:albertlast,项目名称:ticenter_tic,代码行数:7,代码来源:function.settaktiksort.php
示例18: GetAllianzName
function GetAllianzName($id)
{
global $SQL_DBConn;
$SQL = 'SELECT * FROM `gn4accounts` WHERE id ="' . $id . '";';
$SQL_Result = tic_mysql_query($SQL) or die(tic_mysql_error(__FILE__, __LINE__));
$SQL_Num = mysql_num_rows($SQL_Result);
if ($SQL_Num == 0) {
return '';
} else {
$SQL = 'SELECT * FROM `gn4allianzen` WHERE ticid =' . mysql_result($SQL_Result, 0, "ticid") . ';';
$SQL_Result = tic_mysql_query($SQL) or die(tic_mysql_error(__FILE__, __LINE__));
$SQL_Num = mysql_num_rows($SQL_Result);
if ($SQL_Num == 0) {
return '';
} else {
return mysql_result($SQL_Result, 0, "tag");
}
}
}
开发者ID:albertlast,项目名称:ticenter_tic,代码行数:19,代码来源:functions.php
示例19: tic_mysql_query
if (!isset($_GET['txtChPlanet'])) {
$_GET['txtChPlanet'] = '';
}
if (!isset($_GET['lstChAllianz'])) {
$_GET['lstChAllianz'] = '';
}
if ($Benutzer['rang'] == $Rang_GC) {
$_GET['txtChGalaxie'] = $Benutzer['galaxie'];
}
if ($Benutzer['rang'] != $Rang_Techniker) {
$_GET['lstChAllianz'] = $Benutzer['allianz'];
}
if ($_GET['id'] != '' && $_GET['lstChRang'] != '' && $_GET['txtChGalaxie'] != '' && $_GET['txtChPlanet'] != '' && $_GET['lstChAllianz'] != '') {
$SQL_Result = tic_mysql_query('SELECT * FROM `gn4accounts` WHERE id="' . $_GET['id'] . '";', $SQL_DBConn) or $error_code = 4;
if (mysql_num_rows($SQL_Result) == 1) {
$tmp_rang = mysql_result($SQL_Result, 0, 'rang');
if ($tmp_rang >= $Benutzer['rang'] || $_GET['lstChRang'] >= $Benutzer['rang']) {
$error_code = 5;
} else {
$SQL_Result = tic_mysql_query('UPDATE `gn4accounts` SET rang="' . $_GET['lstChRang'] . '", galaxie="' . $_GET['txtChGalaxie'] . '", planet="' . $_GET['txtChPlanet'] . '", allianz="' . $_GET['lstChAllianz'] . '" WHERE id="' . $_GET['id'] . '" and ticid="' . $Benutzer['ticid'] . '";', $SQL_DBConn) or $error_code = 7;
if ($error_code == 0) {
LogAction("Accountdaten geändert: ID=" . $_GET['id'] . "; Koordinaten=" . $_GET['txtChGalaxie'] . ":" . $_GET['txtChPlanet'] . "; Rang=" . $_GET['lstChRang'] . "; Allianz=" . $_GET['lstChAllianz'] . ";");
}
}
} else {
$error_code = 8;
}
} else {
$error_code = 6;
}
}
开发者ID:albertlast,项目名称:ticenter_tic,代码行数:31,代码来源:function.chacc.php
示例20: TextZuZahl
if (!isset($_POST['txtExen_m'])) {
$_POST['txtExen_m'] = 0;
}
if (!isset($_POST['txtExen_k'])) {
$_POST['txtExen_k'] = 0;
}
$_POST['txtSVs'] = TextZuZahl($_POST['txtSVs']);
$_POST['txtSBs'] = TextZuZahl($_POST['txtSBs']);
$_POST['txtPunkte'] = TextZuZahl($_POST['txtPunkte']);
$_POST['txtSchiffe'] = TextZuZahl($_POST['txtSchiffe']);
$_POST['txtDefensiv'] = TextZuZahl($_POST['txtDefensiv']);
$_POST['txtExen_m'] = TextZuZahl($_POST['txtExen_m']);
$_POST['txtExen_k'] = TextZuZahl($_POST['txtExen_k']);
if ($_POST['lstScanTyp'] != '') {
$SQL_Result = tic_mysql_que
|
请发表评论