vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Banner ad on forum Home (https://vborg.vbsupport.ru/showthread.php?t=63994)

webrats 05-04-2004 03:36 AM

would be cool if we could have both hack on the same admin page say small banner for forum home
and big banner for top of forums

Beermonster 05-04-2004 05:33 AM

Quote:

Originally Posted by webrats
would be cool if we could have both hack on the same admin page say small banner for forum home
and big banner for top of forums


You can all you need to do is install them both ;)

hooolala 05-06-2004 06:16 AM

what does add field to forum table means?

Beermonster 05-06-2004 07:43 AM

Quote:

Originally Posted by hooolala
what does add field to forum table means?

You need to go to phpmyadmin and Run SQL query/queries on database just paste this code in the box and press "go"

Code:

ALTER TABLE `forum` ADD `fhbanner` VARCHAR( 50 ) NOT NULL AFTER `description` ;
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanner` ;
ALTER TABLE `forum` ADD `fhmessage` VARCHAR( 50 ) NOT NULL AFTER `fhbannerlink` ;


sneakyc2e 05-30-2004 03:27 PM

I did the banner hack and checked it three times to make sure I did every thing right and the banner is not showing up. Everything shows up in the user cp fine. This is the first time I have run a sql query but I went back to phpmyadmin and they show in there.

Any ideas. I really need this hack and it looks awesome in your screenshots.

I am on vBulletin Version 3.0.1

Thanks,
Dan

Beermonster 05-31-2004 12:40 PM

Quote:

Originally Posted by sneakyc2e
I did the banner hack and checked it three times to make sure I did every thing right and the banner is not showing up. Everything shows up in the user cp fine. This is the first time I have run a sql query but I went back to phpmyadmin and they show in there.

Any ideas. I really need this hack and it looks awesome in your screenshots.

I am on vBulletin Version 3.0.1

Thanks,
Dan

I've sent you a pm, not sure what could be wrong, AFAIK no one else has had problems

sneakyc2e 06-02-2004 02:10 AM

Any ideas?

paul_r 06-04-2004 09:25 AM

just ran the query and heres what i got

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanne' at line 1

any ideas ? :ermm: :surprised:

Beermonster 06-04-2004 09:51 AM

I don't think you've pasted it in right, if you look at it it says "NOT NULL AFTER `fhbanne' " it should be fhbanner

paul_r 06-04-2004 10:01 AM

i dont think so m8

here the query error window copied and pasted ;)



Query
ALTER TABLE `forum` ADD `fhbanner` VARCHAR( 50 ) NOT NULL AFTER `description` ;
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanner` ;
ALTER TABLE `forum` ADD `fhmessage` VARCHAR( 50 ) NOT NULL AFTER `fhbannerlink`



vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanne' at line 1


All times are GMT. The time now is 11:36 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01098 seconds
  • Memory Usage 1,739KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete