banner

[funyboyke]

hallo iedereen
ik ben juist begonnen met een forum
en ik heb een probleempje met het toevoegen van de banner verandering mod
de mod komt van: http://www.phpbbhacks.com/download/1254

ik zou die graag handmatig installeren

de fout melding die ik krijg:

Algemene fout
Couldn't obtain ranks data

DEBUG MODE

SQL Error : 1146 Table 'gomalle.BANNERS_TABLE' doesn't exist

SELECT * FROM BANNERS_TABLE order by banner_spot

Line : 667
File : /var/www/virtual/gomalle.byethost3.com/htdocs/forum/admin/admin_banner.php


graag een beetje hulp

funyboyke

[Paul]

constants.php niet goed aangepast.

[funyboyke]

euh,
zoals ik al zei, ben ik nog maar net begonnen met een forum

ik heb dat nog niet aangepast,kan jij zeggen hoe je dat doet aub?

[Paul]

http://www.phpbb.nl/kb.php?mode=article&k=24

[funyboyke]

er zat een bestand bij waar op stond wat je moets veranderen
en dat heb ik gedaan,en ik krijg nog steeds een fout, maar ik heb niets veranderd aan constants.php
ik zal eens kijken opdie site die he gaf

[funyboyke]

daar vind ik er eigenlijk niets over

[Kielse Rat]

Er staat toch:

Code: Selecteer alles

## Installation Level: Easy
## Installation Time:  10 Minutes (1mn by EasyMOD of Nuttzy)
## Files To Edit:      10
##      viewonline.php
##      admin/admin_db_utilities.php
##      [b]includes/constants.php[/b]
##      includes/page_header.php
##      includes/page_tail.php
##	includes/functions.php
##      templates/subSilver/overall_footer.tpl
##      templates/subSilver/overall_header.tpl
##      templates/subSilver/viewforum_body.tpl
##      templates/subSilver/viewtopic_body.tpl

Dus dan moet je dit nog doen denk ik of je hebt een foutje gedaan:

Code: Selecteer alles

#-----[ OPEN ]------------------------------------------------
# 
includes/constants.php

# 
#-----[ FIND ]------------------------------------------------ 
# 
define('PAGE_GROUPCP', -11);

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

// Start add - Complete banner MOD
define('PAGE_REDIRECT', -1031);
// End add - Complete banner MOD

# 
#-----[ FIND ]------------------------------------------------ 
# 
define('USERS_TABLE', $table_prefix.'users');

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

// Start add - Complete banner MOD
define('BANNER_STATS_TABLE', $table_prefix.'banner_stats');
define('BANNERS_TABLE', $table_prefix.'banner');
// End add - Complete banner MOD

[funyboyke]

neen dieheb ik gedaan

[Kielse Rat]

neen dieheb ik gedaan

Heb je het bestandje 'complete_banner_db_update.php' laten lopen?

[funyboyke]

ja dan gaf die informatie weer

[Kielse Rat]

ja dan gaf die informatie weer

Heb je ondertussen het bestandje van de server verwijdert?

[funyboyke]

ja

[Paul]

Geef constants.php eens hier?

[funyboyke]

hier:

<?php
/***************************************************************************
* constants.php
* -------------------
* begin : Saturday', Feb 13', 2001
* copyright : ('C) 2001 The phpBB Group
* email : support@phpbb.com
*
* $Id: constants.php,v 1.47.2.4 2003/06/10 00:39:51 psotfx Exp $
*
*
***************************************************************************/

/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License', or
* ('at your option) any later version.
*
***************************************************************************/

if ( !defined('IN_PHPBB') )
{
die("Hacking attempt");
}

// Debug Level
//define('DEBUG', 1); // Debugging on
define('DEBUG', 1); // Debugging off


// User Levels <- Do not change the values of USER or ADMIN
define('DELETED', -1);
define('ANONYMOUS', -1);

define('USER', 0);
define('ADMIN', 1);
define('MOD', 2);


// User related
define('USER_ACTIVATION_NONE', 0);
define('USER_ACTIVATION_SELF', 1);
define('USER_ACTIVATION_ADMIN', 2);

define('USER_AVATAR_NONE', 0);
define('USER_AVATAR_UPLOAD', 1);
define('USER_AVATAR_REMOTE', 2);
define('USER_AVATAR_GALLERY', 3);


// Group settings
define('GROUP_OPEN', 0);
define('GROUP_CLOSED', 1);
define('GROUP_HIDDEN', 2);


// Forum state
define('FORUM_UNLOCKED', 0);
define('FORUM_LOCKED', 1);


// Topic status
define('TOPIC_UNLOCKED', 0);
define('TOPIC_LOCKED', 1);
define('TOPIC_MOVED', 2);
define('TOPIC_WATCH_NOTIFIED', 1);
define('TOPIC_WATCH_UN_NOTIFIED', 0);


// Topic types
define('POST_NORMAL', 0);
define('POST_STICKY', 1);
define('POST_ANNOUNCE', 2);
define('POST_GLOBAL_ANNOUNCE', 3);


// SQL codes
define('BEGIN_TRANSACTION', 1);
define('END_TRANSACTION', 2);


// Error codes
define('GENERAL_MESSAGE', 200);
define('GENERAL_ERROR', 202);
define('CRITICAL_MESSAGE', 203);
define('CRITICAL_ERROR', 204);


// Private messaging
define('PRIVMSGS_READ_MAIL', 0);
define('PRIVMSGS_NEW_MAIL', 1);
define('PRIVMSGS_SENT_MAIL', 2);
define('PRIVMSGS_SAVED_IN_MAIL', 3);
define('PRIVMSGS_SAVED_OUT_MAIL', 4);
define('PRIVMSGS_UNREAD_MAIL', 5);


// URL PARAMETERS
define('POST_TOPIC_URL', 't');
define('POST_CAT_URL', 'c');
define('POST_FORUM_URL', 'f');
define('POST_USERS_URL', 'u');
define('POST_POST_URL', 'p');
define('POST_GROUPS_URL', 'g');

// Session parameters
define('SESSION_METHOD_COOKIE', 100);
define('SESSION_METHOD_GET', 101);


// Page numbers for session handling
define('PAGE_INDEX', 0);
define('PAGE_LOGIN', -1);
define('PAGE_SEARCH', -2);
define('PAGE_REGISTER', -3);
define('PAGE_PROFILE', -4);
define('PAGE_VIEWONLINE', -6);
define('PAGE_VIEWMEMBERS', -7);
define('PAGE_FAQ', -8);
define('PAGE_POSTING', -9);
define('PAGE_PRIVMSGS', -10);
define('PAGE_GROUPCP', -11);
// Start add - Complete banner MOD
define('PAGE_REDIRECT', -1031);
// End add - Complete banner MOD
define('PAGE_TOPIC_OFFSET', 5000);


// Auth settings
define('AUTH_LIST_ALL', 0);
define('AUTH_ALL', 0);

define('AUTH_REG', 1);
define('AUTH_ACL', 2);
define('AUTH_MOD', 3);
define('AUTH_ADMIN', 5);

define('AUTH_VIEW', 1);
define('AUTH_READ', 2);
define('AUTH_POST', 3);
define('AUTH_REPLY', 4);
define('AUTH_EDIT', 5);
define('AUTH_DELETE', 6);
define('AUTH_ANNOUNCE', 7);
define('AUTH_STICKY', 8);
define('AUTH_POLLCREATE', 9);
define('AUTH_VOTE', 10);
define('AUTH_ATTACH', 11);


// Table names
define('AUTH_ACCESS_TABLE', $table_prefix.'auth_access');
define('BANLIST_TABLE', $table_prefix.'banlist');
define('CATEGORIES_TABLE', $table_prefix.'categories');
define('CONFIG_TABLE', $table_prefix.'config');
define('DISALLOW_TABLE', $table_prefix.'disallow');
define('FORUMS_TABLE', $table_prefix.'forums');
define('GROUPS_TABLE', $table_prefix.'groups');
define('POSTS_TABLE', $table_prefix.'posts');
define('POSTS_TEXT_TABLE', $table_prefix.'posts_text');
define('PRIVMSGS_TABLE', $table_prefix.'privmsgs');
define('PRIVMSGS_TEXT_TABLE', $table_prefix.'privmsgs_text');
define('PRIVMSGS_IGNORE_TABLE', $table_prefix.'privmsgs_ignore');
define('PRUNE_TABLE', $table_prefix.'forum_prune');
define('RANKS_TABLE', $table_prefix.'ranks');
define('SEARCH_TABLE', $table_prefix.'search_results');
define('SEARCH_WORD_TABLE', $table_prefix.'search_wordlist');
define('SEARCH_MATCH_TABLE', $table_prefix.'search_wordmatch');
define('SESSIONS_TABLE', $table_prefix.'sessions');
define('SMILIES_TABLE', $table_prefix.'smilies');
define('THEMES_TABLE', $table_prefix.'themes');
define('THEMES_NAME_TABLE', $table_prefix.'themes_name');
define('TOPICS_TABLE', $table_prefix.'topics');
define('TOPICS_WATCH_TABLE', $table_prefix.'topics_watch');
define('USER_GROUP_TABLE', $table_prefix.'user_group');
define('USERS_TABLE', $table_prefix.'users');// Start add - Complete banner MOD
define('BANNER_STATS_TABLE', $table_prefix.'banner_stats');
define('BANNERS_TABLE', $table_prefix.'banner');
// End add - Complete banner MOD
define('WORDS_TABLE', $table_prefix.'words');
define('VOTE_DESC_TABLE', $table_prefix.'vote_desc');
define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results');
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

?>

[funyboyke]

jhet is opgelost, ik heb het overgezet en het werkt plots,
raar ik dacht dat ik het al overgezet hep
blijkbaar daarna toch nog iets veranderd
bedankt voor de hulp

[funyboyke]

maar blijkbaar is dit om een tekst banner te maken
weet je misschien iets om de gewone banner te veranderen naar een ander prentje???

ik zal dit posten bij de vraag dingens