phpBB2 by Przemo

[jovica888]

I have warez forum and i have a problem with 4 banners located in footer. I want to delete this 4 banners but i cant find HTML Codes. Actualy i forget where i put them. I was looking in overal_footer.tpl Index_body.tpl Index.php but i did not find HTML Codes. Please Help me becase i have inbound link to page thats are dead and i can't delete this banners

I am sorry for my bad english but i don't know polish

this is my index.php

Kod:

http://rapidshare.com/files/127491608/index.php.html

and my index_body.tpl

Kod:

http://rapidshare.com/files/127492405/index.php.html

[Gadatliwa Kasia]

[joli]

Codes are in base, in prefix_advertisement table. You must delete them from table, use phpmyadmin .

[jovica888]

And how I do that?

[warna]

Hm, maybe U have those banners in Administration Panel » General Admin » Configuration » Main Page » Banner in copyright note of forum?

[jovica888]

No it's not there.

Please help

[joli]

In phpmyadmin you find your database. Find by left table advertisement and klick on them.

On right push "browse" and delete your banners from table

[Help-me]

If you have added an entry, which for unknown reasons does not show up in the Administration Panel, you can remove it by hand. For this purpose, to enter phpmyadmin.
Then choose when left to its database. Going options browse ( ) at the table phpbb_advertisement. Will show you a list of entries ads. When you click on selected items on the erasing ( ) and confirming the operation.


I hope the text is understandable

[jovica888]

I do that and nothing hapen

mejbi its in some file or in cashe or something like that

I found HTML codes and i delethed them but banners are still there

[joli]

clean cache on fto

[jovica888]

I do that i now my forum don't work!!!!

Thank you very much my problem has been solved.

Banners are gone.

Kod:

Could not get entries list DEBUG MODE SQL Error : 1146 Table 'jorgovan_forum.phpbb_advertisement' doesn't exist SELECT id, html, email, position, expire, notify, type FROM phpbb_advertisement WHERE position <> 0 ORDER by porder Line : 522 File : page_header.php

Actualy its ok I edit page_header.php and everything looks fine

my MSN is

Kod:

jovica323@hotmail.com

[Gadatliwa Kasia]

[warna]

Eh, run this query in phpmyadmin (using pma).

Kod:

CREATE TABLE phpbb_advertisement (   id mediumint(9) NOT NULL auto_increment,   html text DEFAULT '' NULL,   email varchar(128) default '' NULL,   clicks int(9) default '0' NOT NULL,   position tinyint(1) default '0' NOT NULL,   porder mediumint(4) default '0' NOT NULL,   added int(11) default '0' NOT NULL,   expire int(11) default '0' NOT NULL,   last_update int(11) default '0' NOT NULL,   notify tinyint(1) default '0' NOT NULL,   type tinyint(1) default '0' NOT NULL,   PRIMARY KEY (id) );