phpmyAdmin
Verfasst: 24.11.2004 09:10
also nachgesehen habe ich und die awswcal ist nicht angelegt die constant.php habe ich auch noch nicht bearbeitet - habe da aber auch echt keinen Durchblick
LG Dirk
LG Dirk
phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Hallo Markus , Ja ich schon wieder hab auch die gleichen meldungen !Markus67 hat geschrieben:Hi ...
Hast du denn auch die constants.php entsprechend editiert ?
Hast du mal mit KB:phpmyadmin in der Datenbank nachgesehen ob die Tabelle vorhanden ist ?
Markus
Code: Alles auswählen
Warning: mysql_connect(): Access denied for user: 'U103246@dee.store' (Using password: NO) in /mnt/be2/07/907/00000007/htdocs/marion/phpBB2/db/mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /mnt/be2/07/907/00000007/htdocs/marion/phpBB2/db/mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /mnt/be2/07/907/00000007/htdocs/marion/phpBB2/db/mysql4.php on line 331
phpBB : Kritischer Fehler
Could not connect to the database
Code: Alles auswählen
Could not query awswcal table
DEBUG MODE
SQL Error : 1146 Table 'DB103246.phpbb_awswcal' doesn't exist
SELECT * FROM phpbb_awswcal ORDER BY id
Line : 189
File : admin_awswcal.php
Code: Alles auswählen
## EasyMod 0.0.7 compliant
COPY phpbb2/db_update_awsw_calendar.php TO db_update_awsw_calendar.php
COPY phpbb2/awswcal.php TO awswcal.php
COPY phpbb2/awswcalload.php TO awswcalload.php
COPY phpbb2/admin/admin_awswcal.php TO admin/admin_awswcal.php
COPY phpbb2/templates/subSilver/admin/admin_awswcal_edit_body.tpl TO templates/subSilver/admin/admin_awswcal_edit_body.tpl
COPY phpbb2/templates/subSilver/admin/admin_awswcal_list_body.tpl TO templates/subSilver/admin/admin_awswcal_list_body.tpl
COPY phpbb2/images/awswcal/index.html TO images/awswcal/index.html
COPY phpbb2/images/awswcal/awswsnow_23122002.jpg TO images/awswcal/awswsnow_23122002.jpg
#
#-----[ SQL ]------------------------------------------
#
- RUN db_update_awsw_calendar.php FROM YOUR FORUMROOT AFTER THE INSTALLATION AND DELETE IT AFTER THAT FROM YOUR FORUMROOT !!!
- FÜHRE DIE db_update_awsw_calendar.php AUS DEM FORUMROOT NACH DER INSTALLATION AUS UND LÖSCHE SIE DANACH WIEDER AUS DEM FORUMROOT !!!
#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_admin.php
#
#-----[ FIND ]------------------------------------------
#
?>
#
#-----[ BEFORE, ADD ]------------------------------------------
#
// AWSW Calendar MOD:
$lang['awswcalWords_title'] = 'AWSW Calendar';
$lang['awswcalWords_explain'] = 'You can enter links here, which will be reacheble at the that day in month. The users can not reach the links before that date in month. So you wan´t be able to reach the link of the 15. at the 12. day in the month. So you can use this calendar as an XMAS-Calendar. If you enter a "-" as a link, the user will get a message, that there is no link entered for this day.';
$lang['awswcalWord'] = 'Day in this month';
$lang['awswcalEdit_word_censor'] = 'Change link';
$lang['awswcalReplacement'] = 'Link';
$lang['awswcalUpdate_word'] = 'Update link';
$lang['awswcalMust_enter_word'] = 'You have to enter a day and a link.<br><br>If you enter a "-" as a link, the user will get a message, that there is no link entered for this day.';
$lang['awswcalNo_word_selected'] = 'No link selected for editing';
$lang['awswcalWord_updated'] = 'The link was updated';
$lang['awswcalClick_return_wordadmin'] = 'Click %shere%s, to get back to the AWSW Calendar-Administration';
#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FIND ]------------------------------------------
#
?>
#
#-----[ BEFORE, ADD ]------------------------------------------
#
// AWSW Calendar MOD:
$lang['awswcal0'] = 'Calendar';
$lang['awswcal1'] = 'Go back to the calendar';
$lang['awswcal2'] = 'Sorry no link...';
$lang['awswcal3'] = 'Please be honest !!!';
#
#-----[ OPEN ]------------------------------------------
#
language/lang_german/lang_admin.php
#
#-----[ FIND ]------------------------------------------
#
?>
#
#-----[ BEFORE, ADD ]------------------------------------------
#
// AWSW Calendar MOD:
$lang['awswcalWords_title'] = 'AWSW Kalender';
$lang['awswcalWords_explain'] = 'Hier kannst Du Links bestimmen, die ab dem im Monat erreichten Tag Deinen Usern zur Verfügung stehen sollen. Ein Aufruf des Links vor Erreichen des entsprechenden Tages im Monat ist nicht möglich. Man kann also zum Beispiel nicht am 12. den Link vom 15. öffnen. Dazu eignet sich dieser Kalender auch als Adventskalender. Wenn Du als Link nur einen Bindestrich "-" einträgst, so erhält der User die Meldung, dass für diesen Tag kein Link hinterlegt ist.';
$lang['awswcalWord'] = 'Tag in diesem Monat';
$lang['awswcalEdit_word_censor'] = 'Link ändern';
$lang['awswcalReplacement'] = 'Link';
$lang['awswcalUpdate_word'] = 'Link aktualisieren';
$lang['awswcalMust_enter_word'] = 'Ein Tag und ein entsprechender Link sind nötig.<br><br>Wenn Du als Link nur einen Bindestrich "-" einträgst, so erhält der User die Meldung, dass für diesen Tag kein Link hinterlegt ist.';
$lang['awswcalNo_word_selected'] = 'Kein Link zum Editieren ausgewählt';
$lang['awswcalWord_updated'] = 'Der Link wurde aktualisiert';
$lang['awswcalClick_return_wordadmin'] = 'Klicke %shier%s, um zur AWSW Kalender-Administration zurückzukehren';
#
#-----[ OPEN ]------------------------------------------
#
language/lang_german/lang_main.php
#
#-----[ FIND ]------------------------------------------
#
?>
#
#-----[ BEFORE, ADD ]------------------------------------------
#
// AWSW Calendar MOD:
$lang['awswcal0'] = 'Kalender';
$lang['awswcal1'] = 'Zurück zum Kalender';
$lang['awswcal2'] = 'Leider kein Ziel eingetragen...';
$lang['awswcal3'] = 'Bitte nicht schummeln !!!';
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
Code: Alles auswählen
CREATE TABLE phpbb_awswcal (
id int(11) NOT NULL auto_increment,
word varchar(2) NOT NULL default '',
replacement Text NOT NULL default '',
PRIMARY KEY (id)
);
INSERT INTO phpbb_awswcal VALUES ( '1', '1', 'http://www.domainlinkurl1.de');
INSERT INTO phpbb_awswcal VALUES ( '2', '2', 'http://www.domainlinkurl2.de');
INSERT INTO phpbb_awswcal VALUES ( '3', '3', 'http://www.domainlinkurl3.de');
INSERT INTO phpbb_awswcal VALUES ( '4', '4', 'http://www.domainlinkurl4.de');
INSERT INTO phpbb_awswcal VALUES ( '5', '5', 'http://www.domainlinkurl5.de');
INSERT INTO phpbb_awswcal VALUES ( '6', '6', 'http://www.domainlinkurl6.de');
INSERT INTO phpbb_awswcal VALUES ( '7', '7', 'http://www.domainlinkurl7.de');
INSERT INTO phpbb_awswcal VALUES ( '8', '8', 'http://www.domainlinkurl8.de');
INSERT INTO phpbb_awswcal VALUES ( '9', '9', 'http://www.domainlinkurl9.de');
INSERT INTO phpbb_awswcal VALUES ( '10', '10', 'http://www.domainlinkurl10.de');
INSERT INTO phpbb_awswcal VALUES ( '11', '11', 'http://www.domainlinkurl11.de');
INSERT INTO phpbb_awswcal VALUES ( '12', '12', 'http://www.domainlinkurl12.de');
INSERT INTO phpbb_awswcal VALUES ( '13', '13', 'http://www.domainlinkurl13.de');
INSERT INTO phpbb_awswcal VALUES ( '14', '14', 'http://www.domainlinkurl14.de');
INSERT INTO phpbb_awswcal VALUES ( '15', '15', 'http://www.domainlinkurl15.de');
INSERT INTO phpbb_awswcal VALUES ( '16', '16', 'http://www.domainlinkurl16.de');
INSERT INTO phpbb_awswcal VALUES ( '17', '17', 'http://www.domainlinkurl17.de');
INSERT INTO phpbb_awswcal VALUES ( '18', '18', 'http://www.domainlinkurl18.de');
INSERT INTO phpbb_awswcal VALUES ( '19', '19', 'http://www.domainlinkurl19.de');
INSERT INTO phpbb_awswcal VALUES ( '20', '20', 'http://www.domainlinkurl20.de');
INSERT INTO phpbb_awswcal VALUES ( '21', '21', 'http://www.domainlinkurl21.de');
INSERT INTO phpbb_awswcal VALUES ( '22', '22', 'http://www.domainlinkurl22.de');
INSERT INTO phpbb_awswcal VALUES ( '23', '23', 'http://www.domainlinkurl23.de');
INSERT INTO phpbb_awswcal VALUES ( '24', '24', 'http://www.domainlinkurl24.de');
INSERT INTO phpbb_awswcal VALUES ( '25', '25', 'http://www.domainlinkurl25.de');
INSERT INTO phpbb_awswcal VALUES ( '26', '26', 'http://www.domainlinkurl26.de');
INSERT INTO phpbb_awswcal VALUES ( '27', '27', 'http://www.domainlinkurl27.de');
INSERT INTO phpbb_awswcal VALUES ( '28', '28', 'http://www.domainlinkurl28.de');
INSERT INTO phpbb_awswcal VALUES ( '29', '29', 'http://www.domainlinkurl29.de');
INSERT INTO phpbb_awswcal VALUES ( '30', '30', 'http://www.domainlinkurl30.de');
INSERT INTO phpbb_awswcal VALUES ( '31', '31', 'http://www.domainlinkurl31.de');
Code: Alles auswählen
<?php
define('IN_PHPBB', 1);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'config.'.$phpEx);
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/constants.'.$phpEx);
include($phpbb_root_path . 'includes/db.'.$phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//
//
//
// Restrict to members:
if( !$userdata['session_logged_in'] )
{
message_die(GENERAL_MESSAGE, $lang['Not_Authorised'], $lang['Not_Authorised']);
exit;
}
//
//
if ( $userdata['user_level'] == ADMIN )
{
}
else
{
message_die(GENERAL_MESSAGE, $lang['Not_Authorised'], $lang['Not_Authorised']);
exit;
}
echo '<html>
<head>
<title>SQL-DB-Installer - AWSW Calendar</title>
</head>
<body>
<h1>SQL-DB-Installer - AWSW Calendar</h1>
<hr />';
if (!isset($HTTP_GET_VARS['install'])) {
echo '<a href="?install=1">Please click here | Bitte hier klicken</a>';
}
else {
$queries = array(
"CREATE TABLE " . $table_prefix . "awswcal (
id int(11) NOT NULL auto_increment,
word varchar(2) NOT NULL default '',
replacement Text NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;",
"INSERT INTO " . $table_prefix . "awswcal VALUES (1, '1', 'http://www.domainlinkurl1.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (2, '2', 'http://www.domainlinkurl2.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (3, '3', 'http://www.domainlinkurl3.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (4, '4', 'http://www.domainlinkurl4.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (5, '5', 'http://www.domainlinkurl5.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (6, '6', 'http://www.domainlinkurl6.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (7, '7', 'http://www.domainlinkurl7.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (8, '8', 'http://www.domainlinkurl8.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (9, '9', 'http://www.domainlinkurl9.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (10, '10', 'http://www.domainlinkurl10.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (11, '11', 'http://www.domainlinkurl11.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (12, '12', 'http://www.domainlinkurl12.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (13, '13', 'http://www.domainlinkurl13.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (14, '14', 'http://www.domainlinkurl14.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (15, '15', 'http://www.domainlinkurl15.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (16, '16', 'http://www.domainlinkurl16.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (17, '17', 'http://www.domainlinkurl17.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (18, '18', 'http://www.domainlinkurl18.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (19, '19', 'http://www.domainlinkurl19.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (20, '20', 'http://www.domainlinkurl20.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (21, '21', 'http://www.domainlinkurl21.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (22, '22', 'http://www.domainlinkurl22.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (23, '23', 'http://www.domainlinkurl23.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (24, '24', 'http://www.domainlinkurl24.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (25, '25', 'http://www.domainlinkurl25.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (26, '26', 'http://www.domainlinkurl26.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (27, '27', 'http://www.domainlinkurl27.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (28, '28', 'http://www.domainlinkurl28.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (29, '29', 'http://www.domainlinkurl29.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (30, '30', 'http://www.domainlinkurl30.de');",
"INSERT INTO " . $table_prefix . "awswcal VALUES (31, '31', 'http://www.domainlinkurl31.de');"
);
$success = true;
foreach($queries as $query) {
if (!$db->sql_query($query)) {
echo '<font color="red">An error occurred ! Changes have not been entered successfully !<br /><br />Es Fehler ist aufgetreten ! Änderung nicht erfolgreich eingetragen !</font><br /><br />';
echo mysql_error();
$success = false;
break;
}
}
if ($success) {
echo '<font color="green">DB-Changes have been entered successfully. You should delete this SQL-DB-Installer as soon as possible !<br /><br />DB-Änderung wurde erfolgreich ausgeführt. Du solltest diesen SQL-DB-Installer sobald wie möglich löschen !';
}
}
?>