Banner Change by ACP first release.

[MasterOfAll]

Ok, i have doing a first release of rebuild Mod.
you can fint the zip at http://www.masterofall.it/nbsmod/nbs_banner_mod.zip.

That's all folks.

[MasterOfAll]

Please respond at the poll.
And for the old forum's update see the other tread about update forum's table.

Weppa ^_^ = :chomp:

[memorex]

Just put the SQL in nbs/new_forum_sql.php, and execute those queries on the execute query page in the admincp if there are forums that already exist. Simply put {accessname}_ for the prefix when executing on that page and it will do it for every forum.

Derek

Hi, please tell me what exacly i need to do, to add the sql in all my forums. Because i can`t understand what i need to do in the admincp an in who admincp and wher in admincp. Please explane me.

[MasterOfAll]

Ok, I understand ... Open nbs_config.php and change the value

$config['SpecialUsers']['canrunqueries'] = ''; in
$config['SpecialUsers']['canrunqueries'] = '1'; And after open the SACP (Super Admin Controll Pannel) and put the query under Maintenance --> Execute SQL Query (http://chooseforum.it/forum/nbs/admin.php?do=query) this code ...


INSERT INTO phpbb_config values ('banner_source', 'banners/logo_phpBB.gif' );
INSERT INTO {accessname}_config values ('banner_path', 'the_ur_lwhere_is_your_banner' ); // E.G. http://www.chooseforum.it/images/chooseforum.gif !
INSERT INTO {accessname}_config values ('banner_link', 'index.php' ); // this is the redirect url where the user are send if click up te banner!
INSERT INTO {accessname}_config values ('banner_cols', '2' ); // this are the colums of the banner, if you whant youcan change!
INSERT INTO {accessname}_config values ('banner_width', '200' ); //This is the width strandard of the banner, you can change!
INSERT INTO {accessname}_config values ('banner_height', '91' );
//This is the height strandard of the banner, you can change!


That's All Folks ^_^ Weppa ^_^ ^_^ ^_^

I have say just right, derek?

[copy112]

it´s right. I have tested it and it work.

[memorex]

Ok, I understand ... Open nbs_config.php and change the value

$config['SpecialUsers']['canrunqueries'] = ''; in
$config['SpecialUsers']['canrunqueries'] = '1'; And after open the SACP (Super Admin Controll Pannel) and put the query under Maintenance --> Execute SQL Query (http://chooseforum.it/forum/nbs/admin.php?do=query) this code ...


INSERT INTO phpbb_config values ('banner_source', 'banners/logo_phpBB.gif' );
INSERT INTO {accessname}_config values ('banner_path', 'the_ur_lwhere_is_your_banner' ); // E.G. http://www.chooseforum.it/images/chooseforum.gif !
INSERT INTO {accessname}_config values ('banner_link', 'index.php' ); // this is the redirect url where the user are send if click up te banner!
INSERT INTO {accessname}_config values ('banner_cols', '2' ); // this are the colums of the banner, if you whant youcan change!
INSERT INTO {accessname}_config values ('banner_width', '200' ); //This is the width strandard of the banner, you can change!
INSERT INTO {accessname}_config values ('banner_height', '91' );
//This is the height strandard of the banner, you can change!
That's All Folks ^_^ Weppa ^_^ ^_^ ^_^

I have say just right, derek?
But i haven`t this option Execute SQL Query (http://chooseforum.it/forum/nbs/admin.php?do=query) in Maintenance i have only this options => PHP Info ; Update Category Total Forums ; Repair / Optimize Tables ; Backup Database. Why i haven`t this option Execute SQL Query?

[Derek]

What version are you running? It was added in Beta 8...

[memorex]

What version are you running? It was added in Beta 8...
I use Beta 8

[Derek]

Well it should show up then...

[MasterOfAll]

But i haven`t this option Execute SQL Query (http://chooseforum.it/forum/nbs/admin.php?do=query) in Maintenance i have only this options => PHP Info ; Update Category Total Forums ; Repair / Optimize Tables ; Backup Database. Why i haven`t this option Execute SQL Query?

If you don't see the Execute SQL Query you HAVE open nbs_config.php and change the VALUE!!!

How Value? Read the my topic up! ^_^
After you have change the value upload again the nbs/nbs_config.php and put its in chmod 644

[memorex]

If you don't see the Execute SQL Query you HAVE open nbs_config.php and change the VALUE!!!

How Value? Read the my topic up! ^_^
After you have change the value upload again the nbs/nbs_config.php and put its in chmod 644
Big thanks now i see it!

Hmmm when i paste all the code INSERT INTO phpbb_config values ('banner_source', 'banners/logo_phpBB.gif' );
INSERT INTO {accessname}_config values ('banner_path', 'http://*****.us/img/banner2.jpg' );
INSERT INTO {accessname}_config values ('banner_link', 'index.php' ); // this is the redirect url where the user are send if click up te banner!
INSERT INTO {accessname}_config values ('banner_cols', '2' ); // this are the colums of the banner, if you whant youcan change!
INSERT INTO {accessname}_config values ('banner_width', '186' ); //This is the width strandard of the banner, you can change!
INSERT INTO {accessname}_config values ('banner_height', '85' );
It`s show me Confirm Are you sure you want to execute this query?

INSERT INTO phpbb_config values (\'banner_source\', \'banners/logo_phpBB.gif\' ); INSERT INTO {accessname}_config values (\'banner_path\', \'http://*****.us/img/banner2.jpg\' ); INSERT INTO {accessname}_config values (\'banner_link\', \'index.php\' ); // this is the redirect url where the user are send if click up te banner! INSERT INTO {accessname}_config values (\'banner_cols\', \'2\' ); // this are the colums of the banner, if you whant youcan change! INSERT INTO {accessname}_config values (\'banner_width\', \'186\' ); //This is the width strandard of the banner, you can change! INSERT INTO {accessname}_config values (\'banner_height\', \'85\' );

And when i push the Yes it doesn`t happend anything. But when i write only one Query and i push Yes it write me Error Sorry, you left one or more fields empty.

Please go back and try again.

[MasterOfAll]

Sorry I have doing a Mistake.
Change ...

INSERT INTO phpbb_config values ('banner_source', 'banners/logo_phpBB.gif' );
into

INSERT INTO {accessname}_config values ('banner_source', 'banners/logo_phpBB.gif' );
The Other Code ...

INSERT INTO {accessname}_config values ('banner_path', 'http://*****.us/img/banner2.jpg' );
INSERT INTO {accessname}_config values ('banner_link', 'index.php' );
INSERT INTO {accessname}_config values ('banner_cols', '2' );
INSERT INTO {accessname}_config values ('banner_width', '186' );
INSERT INTO {accessname}_config values ('banner_height', '85' );

Is Right ... (I hope, I don't have test but in Derek I'm trust).

Exactly All code Right is ...


INSERT INTO {accessname}_config values ('banner_source', 'banners/logo_phpBB.gif' );
INSERT INTO {accessname}_config values ('banner_path', 'http://*****.us/img/banner2.jpg' );
INSERT INTO {accessname}_config values ('banner_link', 'index.php' );
INSERT INTO {accessname}_config values ('banner_cols', '2' );
INSERT INTO {accessname}_config values ('banner_width', '186' );
INSERT INTO {accessname}_config values ('banner_height', '85' );
.

That's all do! :chomp:

[copy112]

Yes it only to copy and past now. It wasen´t hard before.

[memorex]

I have the same problem yet

[MasterOfAll]

Stay tunned for a few days ... I'm Make a test.
I hope that you have to update manualy the table.
If I find the solution I put Here the god mode ^_^.
Derek any solution? You know your script how your "Pockets of the pants".

[memorex]

Ste tunned for a few days ... I'm Make a test.
I hope that you have to update manualy the table.
If I find the solution I put Here the god mode ^_^.
Derek any solution? You know your script how your "Pockets of the pants".
I have more than 1400 forums, i can`t update manualy!

[MasterOfAll]

Yes, I know. Stay Tunned. Please ^_^ ... I'm Under Work.


Only One query At Time (Note Of MasterOfAll)

INSERT INTO {accessname}_config values ('banner_source', 'http://www.chooseforum.it/images/chooseforum.gif' );

After ....

The query you tried executing has failed. The following error was returned:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{accessname}_config values ('banner_source', 'http://www.chooseforum.it/images/c' at line 1

Please go back, review the query, and try again.

But the INSERT INTO is a good syntax. ... ?


I must do some test for find how don't Work.

[kloden1]

When a new user try to add a new forum i get database error.

[MasterOfAll]

Only because the query isn't do. I have test to create a Forum from the Scrath and work.
Be patience but here we need Derek for Help, because the script in reality don't understand {accessname}_ with jolly word for all query.
Infact if you try to put a single sql Work with no problem.
E.G.
INSERT INTO creato_config values ('banner_source', 'http://www.chooseforum.it/images/chooseforum.gif' );WORK!

Under here is the code of admin.php for accessname.

if (strpos($_POST['query'], '{accessname}_'))
{
// we are executing this query on every forum.
$forums1 = "SELECT `accessname`
FROM " . TABLE_PREFIX . "users
WHERE `user_level` = 0";
$forums2 = $db->query($forums1);

$errors = '';

while ($forums3 = $db->fetch_array($forums2))
{
$result = $db->query(stripslashes(str_replace('{accessname}', $forums3['accessname'], stripslashes(urldecode($_REQUEST['query'])))));

if (!$result)
{
$errors .= $db->error() . '<br />';
}
}
}

[MasterOfAll]

When a new user try to add a new forum i get database error.

Put here the code of sql Error complete.
I know how append.

[Wasuup]

I have this installed ok without any errors but when I log into a forum admin panel and click on the banner mod I just get 2 blank text inout boxes and 2 boxes for height & width.

Is there a way to label these boxes so people know what they're for?

edit: Found it - missed out some page edits.

Problem is I now have just a text link where the banner should be

[MasterOfAll]

Where is your banner URL? I have understant that if don't put the right url the mod don't work.

[DR_GIGGULS]

So, does it work?
And what's the final version?

[MasterOfAll]

The mod work, but don't work if you don't update all the query by phpmyadmin, because for now the {accessname}_ for all forum created with nbs don't work.
I have do in this mode. I have take all the forum table and I have update by phpmyadmin. Is Hard but neccessary.
Sorry :/ :'-(

[joebeonekenobe]

Good script thanks

[MasterOfAll]

I had only Re-Build and added to the Big NBS. I don't have make alone.

[frycook]

Yea I was wondering if someone can install this for me my yahoo messenger is sk8terjames13@yahoo.com my xfire is frycook15

[MasterOfAll]

But is easy to install!

Try to use notepad ++ if you don't understand the php code ^_^.

[Choas]

Can Someone put a description of this mode ?

[DR_GIGGULS]

Allows users to change their logo image.

[MasterOfAll]

And You can put a redirect page (E.G. index.php) when a user click up the logo's ^_^

[marcovit]

hmm thats funny, your mod is the SAME as this one.. http://www.phpbb.com/community/viewtopic.php?t=243348?

>.>

[MasterOfAll]

I had only Re-Build and added to the Big NBS. I don't have make alone.

Re-Build. Only Re-build and test. Nothig of script

################################################## ################################################## #########
## This mod is a rebuild of the mod that you an find at http://www.phpbb.com/community/viewtopic.php?f=15&t=243348
## REMOD Title: Change Forum Banner URL + link for NBS_MFscript
## REMOD Author: MasterOfAll < MASTEROFALL@masterofall.it > http://www.masterofall.it
## REMOD Author: MasterOfAll < MASTEROFALL@masterofall.it > http://www.dungeonsgame.masterofall.it
## REMOD Author: MasterOfAll < MASTEROFALL@masterofall.it > http://www.chooseforum.it
## REMOD Description: Allows the admin to change the forum banner in the admin panel WITH LINK.

[Funky]

hi

where i add the code
cuz i open new_forum_sql
and i dont know where I add the codes


}
?>



plz anyone can help me

[Funky]

oh oh soory I find it in bannermodbyACP_install
thanks Master of all
but i have Question
when I try to add another mod
can I add it after this code

$sql[] = "INSERT INTO " . $accessname . "_config (config_name, config_value) VALUES ('default_lang', 'english');";

thanks again ^_&