+- Sponsor-Board.de (https://www.sponsor-board.de)
+-- Forum: Webmaster (/forumdisplay.php?fid=44)
+--- Forum: Script-Check (/forumdisplay.php?fid=91)
+--- Thema: Webspell Template Install Fehler (/showthread.php?tid=28366)
Webspell Template Install Fehler - team-dynamix - 30.07.2012 17:41
Hallo leute habe soebend mal eine test website erstellt uns sehe das ich das phgstats net installieren kan ner sagt mir an
Fatal error: Call to undefined function safe_query() in /users/myreaction/www/install_phgstats.php on line 3
das template ist von hier
[Link: Registrierung erforderlich]
test website: [Link: Registrierung erforderlich]
spricht ich kann es erst garnet installieren hoffe mir kann einer helfen
ja ich weiß er kann die datenbank nicht finden da die install ja ein fehler hatt
Query failed:
errorno=1146
error=Table 'myreaction.ws_UkR_phgstats' doesn't exist
query=SELECT * FROM ws_UkR_phgstats WHERE sc='1' ORDER BY sort
phgstats.php
Zitat:
<?php
$query = safe_query("DROP TABLE IF EXISTS `".PREFIX."phgstats`");
$query = safe_query("CREATE TABLE `".PREFIX."phgstats` (
`serverID` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL default '',
`ip` varchar(255) NOT NULL default '',
`port` varchar(255) NOT NULL default '',
`query` varchar(255) NOT NULL default '',
`game` varchar(255) NOT NULL default '',
`sort` int NOT NULL default '1',
`sc` int(1) NOT NULL default '0',
PRIMARY KEY (`serverID`)
) AUTO_INCREMENT=1 ");
$query = safe_query("DROP TABLE IF EXISTS `".PREFIX."phgstats_games`");
$query = safe_query("CREATE TABLE `".PREFIX."phgstats_games` (
`gameID` int(3) NOT NULL AUTO_INCREMENT,
`tag` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
PRIMARY KEY (`gameID`)
) PACK_KEYS=0 AUTO_INCREMENT=8 ");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (1, 'aa', 'America`s Army')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (2, 'atron', 'Armagetronad')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (3, 'bf', 'Battlefield 1942')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (4, 'bfv', 'Battlefield Vietnam')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (5, 'bf2', 'Battlefield 2')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (6, 'bf2142', 'Battlefield 2142')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (7, 'cod', 'Call of Duty')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (8, 'cod2', 'Call of Duty 2')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (9, 'descent3', 'Descent 3 (without gamespy)')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (10, 'des3gs', 'Descent 3 (gamespy)')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (11, 'd3', 'Doom 3')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (12, 'et', 'Enemy Territory')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (13, 'fear', 'FEAR')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (14, 'halo', 'HALO')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (15, 'hl', 'Half-Life')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (16, 'hl2', 'Half-Life 2')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (17, 'hd2', 'Hidden & Dangerous 2')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (18, 'jedi', 'Jedi Knight: Jedi Academy')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (19, 'jedi2', 'Jedi knight II')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (20, 'mohaa', 'Medal of Honor')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (21, 'nolf', 'No One Lives Forever')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (22, 'pk', 'Painkiller')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (23, 'ro', 'Red Orchestra')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (24, 'rtcw', 'Return to Castle Wolfenstein')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (25, 'rune', 'Rune')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (26, 'sof2', 'Soldier of Fortune 2')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (27, 'swat', 'SWAT 4')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (28, 'ts', 'Teamspeak')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (29, 'ut', 'Unreal Tournament')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (30, 'ut2003', 'Unreal Tournament 2003')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (31, 'ut2004', 'Unreal Tournament 2004')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (32, 'qw', 'Quakeworld')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (33, 'q1', 'Quake 1')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (34, 'q2', 'Quake 2')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (35, 'q3', 'Quake 3')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (36, 'q4', 'Quake 4')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (37, 'warsow', 'Warsow')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (38, 'cs', 'Counter-Strike')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (39, 'cs_cz', 'Counter-Strike: Condition Zero')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (40, 'css', 'Counter-Strike: Source')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (41, 'vc', 'Vietcong')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (42, 'ut3', 'Unreal Tournament 3')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (43, 'efqw', 'Enemy Territory Quake Wars')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (44, 'ef', 'Elite Force')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (45, 'il2', 'IL-2 Shturmovik')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (46, 'cod4', 'Call of Duty 4')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (47, 'cod5', 'Call of Duty 5')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (48, 'cry', 'Crysis')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (49, 'dod', 'Day of Defeat: Source')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (50, 'dods', 'Day of Defeat')");
if($query) {
echo ' Install complete!. Please delete the install_phgstats.php from your Webspace!.';
}
else {
echo ' Install not complete!.';
}
?>
$query = safe_query("DROP TABLE IF EXISTS `".PREFIX."phgstats`");
$query = safe_query("CREATE TABLE `".PREFIX."phgstats` (
`serverID` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL default '',
`ip` varchar(255) NOT NULL default '',
`port` varchar(255) NOT NULL default '',
`query` varchar(255) NOT NULL default '',
`game` varchar(255) NOT NULL default '',
`sort` int NOT NULL default '1',
`sc` int(1) NOT NULL default '0',
PRIMARY KEY (`serverID`)
) AUTO_INCREMENT=1 ");
$query = safe_query("DROP TABLE IF EXISTS `".PREFIX."phgstats_games`");
$query = safe_query("CREATE TABLE `".PREFIX."phgstats_games` (
`gameID` int(3) NOT NULL AUTO_INCREMENT,
`tag` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
PRIMARY KEY (`gameID`)
) PACK_KEYS=0 AUTO_INCREMENT=8 ");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (1, 'aa', 'America`s Army')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (2, 'atron', 'Armagetronad')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (3, 'bf', 'Battlefield 1942')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (4, 'bfv', 'Battlefield Vietnam')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (5, 'bf2', 'Battlefield 2')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (6, 'bf2142', 'Battlefield 2142')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (7, 'cod', 'Call of Duty')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (8, 'cod2', 'Call of Duty 2')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (9, 'descent3', 'Descent 3 (without gamespy)')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (10, 'des3gs', 'Descent 3 (gamespy)')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (11, 'd3', 'Doom 3')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (12, 'et', 'Enemy Territory')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (13, 'fear', 'FEAR')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (14, 'halo', 'HALO')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (15, 'hl', 'Half-Life')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (16, 'hl2', 'Half-Life 2')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (17, 'hd2', 'Hidden & Dangerous 2')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (18, 'jedi', 'Jedi Knight: Jedi Academy')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (19, 'jedi2', 'Jedi knight II')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (20, 'mohaa', 'Medal of Honor')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (21, 'nolf', 'No One Lives Forever')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (22, 'pk', 'Painkiller')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (23, 'ro', 'Red Orchestra')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (24, 'rtcw', 'Return to Castle Wolfenstein')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (25, 'rune', 'Rune')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (26, 'sof2', 'Soldier of Fortune 2')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (27, 'swat', 'SWAT 4')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (28, 'ts', 'Teamspeak')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (29, 'ut', 'Unreal Tournament')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (30, 'ut2003', 'Unreal Tournament 2003')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (31, 'ut2004', 'Unreal Tournament 2004')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (32, 'qw', 'Quakeworld')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (33, 'q1', 'Quake 1')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (34, 'q2', 'Quake 2')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (35, 'q3', 'Quake 3')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (36, 'q4', 'Quake 4')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (37, 'warsow', 'Warsow')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (38, 'cs', 'Counter-Strike')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (39, 'cs_cz', 'Counter-Strike: Condition Zero')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (40, 'css', 'Counter-Strike: Source')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (41, 'vc', 'Vietcong')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (42, 'ut3', 'Unreal Tournament 3')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (43, 'efqw', 'Enemy Territory Quake Wars')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (44, 'ef', 'Elite Force')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (45, 'il2', 'IL-2 Shturmovik')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (46, 'cod4', 'Call of Duty 4')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (47, 'cod5', 'Call of Duty 5')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (48, 'cry', 'Crysis')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (49, 'dod', 'Day of Defeat: Source')");
$query = safe_query("INSERT IGNORE INTO `".PREFIX."phgstats_games` (`gameID`, `tag`, `name`) VALUES (50, 'dods', 'Day of Defeat')");
if($query) {
echo ' Install complete!. Please delete the install_phgstats.php from your Webspace!.';
}
else {
echo ' Install not complete!.';
}
?>
RE: Webspell Template Install Fehler - Tobias - 30.07.2012 17:59
Edit, sorry falsch gelesen.
entweder manuell die tabellen in der datenbank eintragen oder dich an den verkäufer wenden.
RE: Webspell Template Install Fehler - team-dynamix - 30.07.2012 18:01
ja wenn ich url.de/install_phgstats.php mache kommt ja die fehlermeldung
Fatal error: Call to undefined function safe_query() in /users/myreaction/www/install_phgstats.php on line 3
url.de/index.php?site=install_phgstats
passiert garnix
RE: Webspell Template Install Fehler - Tobias - 30.07.2012 18:04
hast du auch die richtige webspell version installiert 4.2.2 a ? bzw die, die für das template ist? ist aber schon veraltet.
RE: Webspell Template Install Fehler - team-dynamix - 30.07.2012 18:10
ja habe ich (; die clan version
RE: Webspell Template Install Fehler - Tobias - 30.07.2012 18:12
hm kann dir da schlecht helfen, da ich mcih mit dend atenbank zeuchs nicht perfekt auskenne. Wie gesagt versuch mal die tables manuell ein zu tragen, oder am verkäufer wenden, oder was auch geht, auf webspell.org die community fragen, die sind sehr freundlich und hilfsbereit. Da bekommst du auch innerhalb von kürzester zeit eine antwort.
RE: Webspell Template Install Fehler - team-dynamix - 30.07.2012 18:14
webspell.org weiß auch nix xDDDD deswegen versuchte ich es hier
RE: Webspell Template Install Fehler - DebianDEV - 30.07.2012 18:14
Hi,
hast du in Betracht gezogen das es an Square7 liegt?
RE: Webspell Template Install Fehler - team-dynamix - 30.07.2012 18:15
ne
kann auch möglich sein wie gesagt ist test website xDD
RE: Webspell Template Install Fehler - crocKster - 30.07.2012 18:35
Naja dieses Template und andere Free Templates von Clandesigns habe ich schon ausprobiert, bei mir ging ebenfalls keines!
Alles verschoben und was weiß ich, warum wird es wohl kostenlos dort angeboten, wo eigentlich alle ihre Designs verkaufen?
Weil Fehler drinnen sind!