vb.org Archive
Page 3 of 34 12 3 4513 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   vB.Sponsors - Forum and Category Sponsorship with Statistics (https://vborg.vbsupport.ru/showthread.php?t=103327)

Deviation 12-22-2005 01:11 AM
Quote:
Originally Posted by TundraSoul
When using the sub category code, forumbit_level1_post, the image aligns to the left, instead of to the right.
Template code has been fixed. :)

Zilvia 12-24-2005 04:37 AM
I am getting this when I try to save the sponsor info in the catagory. Any ideas? Thanks!

PHP Code:
Database error in vBulletin 3.5.2:

Invalid SQL:
UPDATE forum SET
    title_clean = 'Administration',
    title = 'Administration',
    description_clean = '',
    description = '',
    link = '',
    displayorder = 5,
    daysprune = 1,
    parentid = -1,
    newpostemail = '',
    newthreademail = '',
    ### Bitfield: forum.options ###
        options = IF(options & 8, options - 8, options),
        options = IF(options & 16, options - 16, options),
        options = IF(options & 32, options - 32, options),
        options = IF(options & 131072, options - 131072, options),
        options = IF(options & 32768, options, options + 32768),
        options = IF(options & 8192, options, options + 8192),
        options = IF(options & 4, options - 4, options),
        options = IF(options & 1, options, options + 1),
        options = IF(options & 2, options - 2, options),
        options = IF(options & 16384, options, options + 16384),
        options = IF(options & 256, options - 256, options),
        options = IF(options & 64, options - 64, options),
        options = IF(options & 128, options - 128, options),
        options = IF(options & 512, options - 512, options),
        options = IF(options & 1024, options - 1024, options),
        options = IF(options & 2048, options - 2048, options),
        options = IF(options & 4096, options, options + 4096),
        options = IF(options & 65536, options, options + 65536),
    styleid = 0,
    password = '',
    sponsor_enabled = '1',
    sponsor_name = 'Zilvia.net',
    sponsor_banner_enabled = '1',
    sponsor_banner = 'http://www.zilvia.net/images/forumsp1.gif',
    sponsor_url = 'http://www.zilvia.net'
WHERE forumid = 5;

MySQL Error  : Unknown column 'sponsor_enabled' in 'field list'
Error Number : 1054
Date         : Friday, December 23rd 2005 @ 11:36:25 PM
Script       : [url]http://www.zilvia.net/f/admincp/forum.php[/url]
Referrer     : [url]http://www.zilvia.net/f/admincp/forum.php?do=edit&f=5&s=[/url]
IP Address   : 
Username     : WeST
Classname    : vb_database 

kommuni 12-24-2005 08:37 AM
Quote:
Originally Posted by Zilvia
I am getting this when I try to save the sponsor info in the catagory. Any ideas? Thanks!

PHP Code:
Database error in vBulletin 3.5.2:

Invalid SQL:
UPDATE forum SET
    title_clean = 'Administration',
    title = 'Administration',
    description_clean = '',
    description = '',
    link = '',
    displayorder = 5,
    daysprune = 1,
    parentid = -1,
    newpostemail = '',
    newthreademail = '',
    ### Bitfield: forum.options ###
        options = IF(options & 8, options - 8, options),
        options = IF(options & 16, options - 16, options),
        options = IF(options & 32, options - 32, options),
        options = IF(options & 131072, options - 131072, options),
        options = IF(options & 32768, options, options + 32768),
        options = IF(options & 8192, options, options + 8192),
        options = IF(options & 4, options - 4, options),
        options = IF(options & 1, options, options + 1),
        options = IF(options & 2, options - 2, options),
        options = IF(options & 16384, options, options + 16384),
        options = IF(options & 256, options - 256, options),
        options = IF(options & 64, options - 64, options),
        options = IF(options & 128, options - 128, options),
        options = IF(options & 512, options - 512, options),
        options = IF(options & 1024, options - 1024, options),
        options = IF(options & 2048, options - 2048, options),
        options = IF(options & 4096, options, options + 4096),
        options = IF(options & 65536, options, options + 65536),
    styleid = 0,
    password = '',
    sponsor_enabled = '1',
    sponsor_name = 'Zilvia.net',
    sponsor_banner_enabled = '1',
    sponsor_banner = 'http://www.zilvia.net/images/forumsp1.gif',
    sponsor_url = 'http://www.zilvia.net'
WHERE forumid = 5;

MySQL Error  : Unknown column 'sponsor_enabled' in 'field list'
Error Number : 1054
Date         : Friday, December 23rd 2005 @ 11:36:25 PM
Script       : [url]http://www.zilvia.net/f/admincp/forum.php[/url]
Referrer     : [url]http://www.zilvia.net/f/admincp/forum.php?do=edit&f=5&s=[/url]
IP Address   : 
Username     : WeST
Classname    : vb_database 
Hi Deviation,

you did a great approach there. Love this idea and surely will implement it after holidays. I hope you will keep it in development and add further features. I'm just implementing some more sponsoring-features and this one will surely be loved by the sponsors.

Did you think about placing another sponsor image or text inside the forums? Would be good to have it additionally on top or bottom of the forumdisplay page or in the threads.

Great thing - keep up the good work.

Frank

Deviation 12-24-2005 12:24 PM
Quote:
Originally Posted by Zilvia
I am getting this when I try to save the sponsor info in the catagory. Any ideas? Thanks!

PHP Code:
Database error in vBulletin 3.5.2:

Invalid SQL:

MySQL Error  : Unknown column 'sponsor_enabled' in 'field list' 
It looks the columns didn't get added to the _forum table. Did you receive any errors when installing this? Do you have access to your database via phpMyAdmin (or some other tool)? If so, check the _forum table structure to see if it created the columns. You will need access to create & modify tables with the account used by vBulletin.

Try uninstalling the product and reinstalling. When reinstalling, be sure to choose Allow Overwrite. Make sure you are using the latest version (posted here).

Just want to check the basics first.

Deviation 12-24-2005 12:30 PM
Quote:
Originally Posted by kommuni
Hi Deviation,

you did a great approach there. Love this idea and surely will implement it after holidays. I hope you will keep it in development and add further features. I'm just implementing some more sponsoring-features and this one will surely be loved by the sponsors.

Did you think about placing another sponsor image or text inside the forums? Would be good to have it additionally on top or bottom of the forumdisplay page or in the threads.

Great thing - keep up the good work.

Frank
Thanks for the kind words. I hope to keep this around for some time. I find it enjoyable doing these types of things. Especially when I receive a warm welcome on my first release. :classic:

Do you mean a banner from the same sponsor on the top and/or bottom of the forum they sponsored? Sounds like a great idea to me. I'll add it to the feature requests list.

Zilvia 12-24-2005 02:30 PM
Installed without any errors, the product uploads fine and I have tried uninstalling it and reinstalling it about 5x now with no luck.

within the Table vbsponsors are these coulums

id
sponsor_name
forum_id
forum
date

as for the table forum:

it looks like its missing...

sponsor_enabled & sponsor_banner_enabled

Also, I donno if there are normal but within the forum table there coulums called...

sponsorname
sponsorimg
sponsorurl

Im pretty sure I dont have any simular hacks installed, although about two years ago I had a simular kind of hack installed. Should I remove those coulums? EDIT: I removed them and didnt seem to help.

Any ideas? Thanks!!

Merry Xmas too!

Deviation 12-24-2005 03:02 PM
Quote:
Originally Posted by Zilvia
Installed without any errors, the product uploads fine and I have tried uninstalling it and reinstalling it about 5x now with no luck.

within the Table vbsponsors are these coulums

id
sponsor_name
forum_id
forum
date

as for the table forum:

it looks like its missing...

sponsor_enabled & sponsor_banner_enabled

Also, I donno if there are normal but within the forum table there coulums called...

sponsorname
sponsorimg
sponsorurl

Im pretty sure I dont have any simular hacks installed, although about two years ago I had a simular kind of hack installed. Should I remove those coulums? EDIT: I removed them and didnt seem to help.

Any ideas? Thanks!!

Merry Xmas too!
vB.Sponsors should contain the following columns:
id
sponsor_name
forum_id
forum
date

So that one looks OK.

_forum should have the following added to it:
sponsor_enabled
sponsor_banner_enabled
sponsor_name
sponsor_banner
sponsor_url

I'm not sure what the other columns are, but they aren't mine. ;) If the old hack you had isn't in use, I would drop those columns. Try dropping those columns, uninstalling, verifying everything is gone from the table _forum and reinstalling.

Let me know if this works for you. If it still doesn't create the columns, I'll post up the manual SQL you can try.

...and a Merry X-Mas to you too!

Zilvia 12-24-2005 03:09 PM
Tried that just before you replied I guess, I edited my post. Your to quick to reply! :)

I tried to pull a manual SQL query from the xml file, but I figured I better not as Im not sure what im doing exactly.

If you could give me the manual sql to try. Thanks so much!

Deviation 12-25-2005 01:13 PM
PHP Code:
ALTER TABLE TABLE_PREFIX_forum ADD (sponsor_enabled INT(6) UNSIGNED NOT NULL DEFAULT '')

ALTER TABLE TABLE_PREFIX_forum ADD (sponsor_banner_enabled INT(6) UNSIGNED NOT NULL DEFAULT '')

ALTER TABLE TABLE_PREFIX_forum ADD (sponsor_name VARCHAR(250) NOT NULL DEFAULT '')

ALTER TABLE TABLE_PREFIX_forum ADD (sponsor_banner VARCHAR(250) NOT NULL DEFAULT '')

ALTER TABLE TABLE_PREFIX_forum ADD (sponsor_url VARCHAR(250) NOT NULL DEFAULT '') 
Replace TABLE_PREFIX with the prefix of your vB tables. Let me know the results.

Hornstar 12-25-2005 08:06 PM
thanks for the reply, I didnt think of that lol.


Also I just noticed you added your link on the bottom of the forum lol, very sly lol

Powered by vBulletin Version 3.5.2
Copyright ?2000 - 2005, Jelsoft Enterprises Ltd.
vB.Sponsors 0.1.0


All times are GMT. The time now is 05:38 AM.
Page 3 of 34 12 3 4513 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.01345 seconds
  • Memory Usage 1,851KB
  • 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
  • (4)bbcode_php_printable
  • (5)bbcode_quote_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