Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
| Geschlossen | ||
Fr. 31.10.2014
20:08 Uhr
#1
Fr. 31.10.2014
20:17 Uhr
#2
werde mir das direkt mal downloaden 
Fr. 31.10.2014
20:29 Uhr
#3
Fr. 31.10.2014
20:35 Uhr
#4
Fr. 31.10.2014
20:46 Uhr
#5
Fr. 31.10.2014
20:53 Uhr
#6
Fr. 10.04.2015
14:09 Uhr
#7
MySQL Error: 1054 : Unknown column 'gegner' in 'field list' in Query: SELECT id,gegner,game FROM ic1_wars WHERE status = 1 ORDER BY id DESC Debug backtrace: @ mysql.php:46 -- debug_bt() @ mysql.php:64 -- db_check_error(...) @ wars.php:385 -- db_query(...) @ admin.php:20 -- require_once(...) Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vhosts/breathless-esports.ck-host.com/httpdocs/include/includes/func/db/mysql.php on line 72 MySQL Error: 1054 : Unknown column 'gegner' in 'field list' in Query: SELECT id,gegner,game FROM ic1_wars WHERE status = 2 ORDER BY id DESC LIMIT 0,20 Debug backtrace: @ mysql.php:46 -- debug_bt() @ mysql.php:64 -- db_check_error(...) @ wars.php:399 -- db_query(...) @ admin.php:20 -- require_once(...) Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vhosts/breathless-esports.ck-host.com/httpdocs/include/includes/func/db/mysql.php on line 72
MySQL Error:
1054 : Unknown column 'gegner' in 'field list'
in Query:
INSERT INTO ic1_wars (datime,`status`,gegner,tag,page,mail,icq,wo,tid,`mod`,game,mtyp,land,txt) VALUES ('2015-4-10 20:0:0',2,'test','','http://aaaa','abc@abc.de','123456789','93.186.198.82:27015','5','5on5','CS:GO','Clanwar','Albania.gif','Nachricht')
Debug backtrace:
@ mysql.php:46 -- debug_bt()
@ mysql.php:64 -- db_check_error(...)
@ wars.php:338 -- db_query(...)
@ admin.php:20 -- require_once(...)
Fr. 10.04.2015
14:12 Uhr
#8
Fr. 10.04.2015
14:34 Uhr
#9
-- phpMyAdmin SQL Dump -- version 4.1.12 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Erstellungszeit: 10. Apr 2015 um 14:33 -- Server Version: 5.5.35-0+wheezy1 -- PHP-Version: 5.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Datenbank: `breathless` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `ic1_wars` -- CREATE TABLE IF NOT EXISTS `ic1_wars` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `datime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `status` tinyint(2) NOT NULL DEFAULT '0', `wlp` tinyint(1) NOT NULL DEFAULT '0', `owp` mediumint(9) NOT NULL DEFAULT '0', `opp` mediumint(9) NOT NULL DEFAULT '0', `oid` int(11) NOT NULL, `tag` varchar(100) NOT NULL DEFAULT '', `page` varchar(100) NOT NULL DEFAULT '', `mail` varchar(100) NOT NULL DEFAULT '', `icq` varchar(100) NOT NULL DEFAULT '', `wo` varchar(100) NOT NULL DEFAULT '', `tid` smallint(6) NOT NULL DEFAULT '0', `mod` varchar(100) NOT NULL DEFAULT '', `game` varchar(100) NOT NULL DEFAULT '', `mtyp` varchar(100) NOT NULL DEFAULT '', `land` varchar(100) NOT NULL DEFAULT '', `txt` text, `mlink` varchar(200) NOT NULL, `lineupopp` varchar(200) NOT NULL, `lineupowp` varchar(200) NOT NULL, `oppstate` text NOT NULL, `owpstate` text NOT NULL, `maps` varchar(100) NOT NULL, `tv` varchar(100) NOT NULL, `pw` varchar(50) NOT NULL, `topmatch` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='powered by ilch.de' AUTO_INCREMENT=4 ; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Fr. 10.04.2015
17:11 Uhr
#10
<?php
// Copyright by Manuel
// Support www.ilch.de
defined ('main') or die ( 'no direct access' );
$akttime = date('Y-m-d');
$erg = @db_query("SELECT DATE_FORMAT(datime,'%d.%m.%y - %H:%i') as time,oid, id, game FROM prefix_wars WHERE status = 2 AND datime > '".$akttime."' ORDER BY datime");
if ( @db_num_rows($erg) == 0 ) {
echo '<ul class="list-group list-group-boxen text-center"><div class="alert alert-warning" role="alert">Aktuell kein War geplant<br><a class="text-warning" href="admin.php?wars-next"><strong>Next-War eintragen</strong></a></div></ul>';
} else {
echo '<ul class="list-group list-group-boxen text-left">';
while ($row = db_fetch_object($erg) ) {
$row->tag = ( empty($row->tag) ? $row->gegner : $row->tag );
$row->tag = get_opponent_details('tag', $row->oid);
echo '<a href="admin.php?wars-next&pkey='.$row->id.'" class="list-group-item"><strong><i class="fa fa-angle-double-right"></i> '.$row->tag.'</strong><span class="label label-success pull-right">'.$row->time.' Uhr</span></a>';
}
echo '</ul>';
}
?>
| Geschlossen | ||
 |
Zurück zu Design- und Projektvorstellungen | |