phpBB.de

Code: Alles auswählen

Fehler 
Could not query words table

DEBUG MODE

SQL Error : 1146 Table 'chrishyp.ADMINBANNERS_TABLE' doesn't exist

SELECT * FROM ADMINBANNERS_TABLE ORDER BY word_id

Line : 190
File : /usr/export/www/vhosts/funnetwork/hosting/chrishyp/admin/admin_banners.php

Code: Alles auswählen

## EasyMod 0.0.7 compliant
##############################################################
## MOD Title: Forum Random Advertising Banners
## MOD Author: AWSW <  > (AWSW) http://www.awsw.de
## MOD Description: With this mod you can display Advertising Banners in the forum in a random sorting.<br><br>Mit diesem MOD kannst Du Werbe Banner im Forum in zufälliger Reihenfolge anzeigen.
## MOD Version: 1.00
##
## Installation Level: easy
## Installation Time: 5 Minutes
##
## Generator: phpBB2 Mod Maker 0.1.67
##############################################################
## This MOD is released under the GPL License. Intellectual Property is retained by the MOD Author(s) listed above. http://www.gnu.org
##############################################################
## For Security Purposes, Please Check: http://www.awsw.de/ for the latest version of this MOD. Downloading this MOD from other sites could cause malicious code to enter into your phpBB Forum. You´ll find support to this MOD at http://www.phpbb.de/
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up Your Complete Database And All Files Related To This MOD !
##############################################################

#
#-----[ COPY TO FOLDER ]------------------------------------------
#

COPY db_update_admin_banners.php TO db_update_admin_banners.php
COPY admin_banners.php TO admin/admin_banners.php
COPY admin_banners_edit_body.tpl TO templates/subSilver/admin/admin_banners_edit_body.tpl
COPY admin_banners_list_body.tpl TO templates/subSilver/admin/admin_banners_list_body.tpl
COPY adminbanners/index.html TO images/adminbanners/index.html
COPY adminbanners/1.gif TO images/adminbanners/1.gif
COPY adminbanners/2.gif TO images/adminbanners/2.gif
COPY adminbanners/3.gif TO images/adminbanners/3.gif
COPY adminbanners/4.gif TO images/adminbanners/4.gif
COPY adminbanners/5.gif TO images/adminbanners/5.gif

#
#-----[ SQL ]------------------------------------------
#

- RUN db_update_admin_banners.php FROM YOUR FORUMROOT AFTER THE INSTALLATION AND DELETE IT AFTER THAT FROM YOUR FORUMROOT !!!

- FÜHRE DIE db_update_admin_banners.php AUS DEM FORUMROOT NACH DER INSTALLATION AUS UND LÖSCHE SIE DANACH WIEDER AUS DEM FORUMROOT !!!

#
#-----[ OPEN ]------------------------------------------
#

includes/constants.php

#
#-----[ FIND ]------------------------------------------
#

?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#

define('ADMINBANNERS_TABLE', $table_prefix.'adminbanners');

#
#-----[ OPEN ]------------------------------------------
#

includes/page_tail.php

#
#-----[ FIND ]------------------------------------------
#

'PHPBB_VERSION' => '2' . $board_config['version'],

#
#-----[ AFTER, ADD ]------------------------------------------
#

'ADMINBANNERS' => $lang['AdminBanner'],

#
#-----[ FIND ]------------------------------------------
#

$template->pparse('overall_footer');

#
#-----[ BEFORE, ADD ]------------------------------------------
#

// ADMINBANNERS START
    $sql = "SELECT word, replacement FROM " . ADMINBANNERS_TABLE . " ORDER BY RAND() LIMIT 1";
    if ( !($result = $db->sql_query($sql)) )
    {
            message_die(GENERAL_ERROR, 'Could not obtain ADMINBANNERS information', '', __LINE__, __FILE__, $sql);
    }
    while ($row = $db->sql_fetchrow($result))
    {
    $word = $row['word'];
    $replacement = $row['replacement'];
            $template->assign_block_vars("adminbanners", array(
            'word' => $word,
            'adminbannersImg' => $replacement
            ));
    }
// ADMINBANNERS END

#
#-----[ OPEN ]------------------------------------------
#

templates/subSilver/overall_footer.tpl

#
#-----[ FIND ]------------------------------------------
#

<div align="center"><span class="copyright"><br />{ADMIN_LINK}<br />

#
#-----[ BEFORE, ADD ]------------------------------------------
#

<!-- ##### ADMINBANNERS START ##### -->
<br><center><table border="0" cellpadding="1" cellspacing="1" style="border-collapse: collapse" class="forumline">
  <tr>
        <td class="catHead" height="25"><span class="cattitle"><center><b>{ADMINBANNERS}:</b></center></span></td>
  </tr>
  <tr>
        <td colspan="{amazonbox_limit}" height="1" class="row3"><img src="images/spacer.gif" width="1" height="1" alt="."></td>
  </tr>
  <tr>
  <!-- BEGIN adminbanners -->
		<td class="row1" align="center"><a href="{adminbanners.adminbannersImg}" target="_blank" class="gensmall"><img src="{adminbanners.word}" border="0"></a></td>
  <!-- END adminbanners -->
  </tr>
</table></center><br>
<!-- ##### ADMINBANNERS END ##### -->

#
#-----[ OPEN ]------------------------------------------
#

language/lang_english/lang_admin.php

#
#-----[ FIND ]------------------------------------------
#

?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#

$lang['AdminBanner'] = 'Advertising banner';
$lang['AdminBannerWords_title'] = 'Advertising banner';
$lang['AdminBannerWords_explain'] = 'Here you can determine advertising banners, which are to be indicated in the forum in coincidental order.';
$lang['AdminBannerEdit_word_censor'] = 'Update Advertising banner';
$lang['AdminBannerReplacement'] = 'Imagelink';
$lang['AdminBannerresult'] = 'Result';
$lang['AdminBannerAdd_new_word'] = 'Add a new advertising banner';
$lang['AdminBannerUpdate_word'] = 'Update advertising banner';
$lang['AdminBannerMust_enter_word'] = 'A imagelink and an link are necessary';
$lang['AdminBannerNo_word_selected'] = 'No advertising banner selected for editing';
$lang['AdminBannerWord_updated'] = 'The advertising banner was updated';
$lang['AdminBannerWord_added'] = 'The advertising banner was added';
$lang['AdminBannerWord_removed'] = 'The advertising banner was removed';
$lang['AdminBannerClick_return_admin'] = 'Klick %shere%s, to get back to the advertising banner-Administration';
$lang['AdminBannerWord'] = 'Advertising banner imagelink';

#
#-----[ OPEN ]------------------------------------------
#

language/lang_english/lang_main.php

#
#-----[ FIND ]------------------------------------------
#

?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#

$lang['AdminBanner'] = 'Advertising banner';

#
#-----[ OPEN ]------------------------------------------
#

language/lang_german/lang_admin.php

#
#-----[ FIND ]------------------------------------------
#

?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#

$lang['AdminBanner'] = 'Werbe Banner';
$lang['AdminBannerWords_title'] = 'Werbe Banner';
$lang['AdminBannerWords_explain'] = 'Hier kannst Du Werbe Banner bestimmen, die im Forum in zufälliger Reihenfolge angezeigt werden sollen.';
$lang['AdminBannerEdit_word_censor'] = 'Werbe Banner &auml;ndern';
$lang['AdminBannerReplacement'] = 'Link';
$lang['AdminBannerresult'] = 'Ergebnis';
$lang['AdminBannerAdd_new_word'] = 'Neues Werbe Banner hinzuf&uuml;gen';
$lang['AdminBannerUpdate_word'] = 'Werbe Banner aktualisieren';
$lang['AdminBannerMust_enter_word'] = 'Eine Bildlink und ein zugeh&ouml;riger Link sind n&ouml;tig';
$lang['AdminBannerNo_word_selected'] = 'Kein Werbe Banner zum Editieren ausgew&auml;hlt';
$lang['AdminBannerWord_updated'] = 'Das Werbe Banner wurde aktualisiert';
$lang['AdminBannerWord_added'] = 'Das Werbe Banner wurde eingerichtet';
$lang['AdminBannerWord_removed'] = 'Das Werbe Banner wurde entfernt';
$lang['AdminBannerClick_return_admin'] = 'Klicke %shier%s, um zur Werbe Banner-Administration zur&uuml;ckzukehren';
$lang['AdminBannerWord'] = 'Werbe Banner Bildlink';

#
#-----[ OPEN ]------------------------------------------
#

language/lang_german/lang_main.php

#
#-----[ FIND ]------------------------------------------
#

?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#

$lang['AdminBanner'] = 'Werbe Banner';

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM

Code: Alles auswählen

SQL-DB-Installer - Forum Random Advertising Banners

--------------------------------------------------------------------------------
An error occurred ! Changes have not been entered successfully !

Es Fehler ist aufgetreten ! Änderung nicht erfolgreich eingetragen !

Table 'phpbb_adminbanners' already exists

Code: Alles auswählen

SQL-DB-Installer - Forum Random Advertising Banners 

-------------------------------------------------------------------------------- 
An error occurred ! Changes have not been entered successfully ! 

Es Fehler ist aufgetreten ! Änderung nicht erfolgreich eingetragen ! 

Table 'phpbb_adminbanners' already exists