vb.org Archive
Page 9 of 25 « First 78 9 101119 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Advert Management (https://vborg.vbsupport.ru/showthread.php?t=39074)

Scott MacVicar 06-10-2002 07:10 AM
Will be looking into this as soon as I get back from vacation.

My rough idea is add a variable in the vBulletin options asking how many banners to load. $advert_1 and $advert_2 etc

Slynderdale 06-11-2002 11:48 PM
works great now, i made a couple changes though, greak hack

Slynderdale 06-18-2002 06:40 PM
made more changes :)

Slynderdale 06-18-2002 06:40 PM
heres the modify list screenshot

X-Fan 06-19-2002 10:43 AM
Is there any way to adapt this hack for button ads and icon ads?

Andy R 06-21-2002 08:19 PM
OK, I have run the MySQL command via PHPMyAdmin. In order to run the comman, I had to remove the apostrophy marks (').

Here is the result I got:
PHP Code:
Your SQL-query has been executed successfully
 
SQL-query :
CREATE TABLE ads (
adid smallint(5) NOT NULL auto_increment,
name varchar(25) NOT NULL default '',
forumid smallint(5) NOT NULL default 0,
wholeforum smallint(1) NOT NULL default 0,
exposed smallint(10) NOT NULL default 0,
exposures smallint(10) NOT NULL default 0,
time int(10) NOT NULL default 0,
advert text NOT NULL,
KEY adid (adid)
) 
I have edited the /forums/admin/index.php file and all the admin features seem to be working. I can create ads and modify them.

When I ad the code to global.php and upload the modified file, I get a MySQL error:
PHP Code:
Database error in vBulletin 2.2.6:

Invalid SQL: SELECT * FROM ads WHERE wholeforum='1' AND time>=1024693619 AND (exposed<=exposures OR exposures=0) ORDER BY RAND()
mysql error: You have an error in your SQL syntax near 'RAND()' at line 1

mysql error number: 1064

Date: Friday 21st of June 2002 03:06:59 PM
Script: [url]http://www.airstreamforums.com/forums/forums/index.php?s=[/url]
Referer: [url]http://www.airstreamforums.com/forums/online.php?s=[/url] 
I have reverted back to the original gloabl.php for now.

Any clues on what I might be doing wrong?

Thanks,

Andy

inetd 06-28-2002 09:08 AM
PPN, when you release new version? :)

Scott MacVicar 06-28-2002 09:39 AM
organic-hosting what version of MySQL are you running?

inted i had to modify the forums.php and set in there how many times to invoke the banner code.

Slynderdale Ive stolen your who it should be shown to idea and Ive got the code written for that.

ladyfyre 06-28-2002 06:29 PM
Hey PPN, just wanted to let you know, i found a bug.

i have mine set to unlimited exposures...but the exposure count for all adverts only went to 32767 for Houston, Austin, and Dallas, and will not go any higher....so the counter has a bug somewhere....

Scott MacVicar 06-28-2002 07:56 PM
Its not a bug its the limit of mysql smallint.
Ill icq you the fix.


All times are GMT. The time now is 07:01 PM.
Page 9 of 25 « First 78 9 101119 Last »
Show 40 post(s) from this thread on one page

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.01368 seconds
  • Memory Usage 1,741KB
  • 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
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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