Forum Home Enhancements - SponsorIt

Due to the pricing and yearly fee of vBulletin I am no longer creating mods for vBulletin, instead I have stepped out of the shadow of vBulletin to create my own stand alone mods. I wish to thank everyone who downloaded and installed my mods but as of now with not being able to afford hosting and vBulletin, I decided to drop vBulletin so hopes of me returning would only happen if my newest venture brings me a nice profit.

Thank you all again
Steve

[SLY LS1]

1. Yeah another error when editing a sponsor

MySQL Error : Unknown column 'sclicks' in 'field list'

2. Deleting seems to work ok now...

3. Adding a sponsor works but now nothing is showing up..

4. You really need to add an instruction page with the download

5. Surely you are running/testing it on your own site before releasing it?

[principino1984]

When i try to upgrade from 1.2 ...

Database error in vBulletin 3.6.7:

Invalid SQL:
ALTER TABLE `vb_usergroup` ADD `sponsors` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';;

MySQL Error  : Duplicate column name 'sponsors'
Error Number : 1060

Marco

[principino1984]

now it gaves me this error...

MySQL Error : Unknown table 'vb_tfw_sponsors'

Could you please do something that instead of tryin to modify the vb_tfw_sponsor if it doensn't exist it create a new table?

Cause I dont' have that table in my db...thats why I cannot neither uninstall it or upgrade it.

thanks a lot!

Marco

[waller99]

Same for me.

Invalid SQL:

MySQL Error  : Unknown column 'sclicks' in 'field list'
Error Number : 1054

[BadgerDog]

Well , installed v1.3 .... but it has issues when trying to edit an entry ....

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE tfw_sponsors SET title="Riflechair\'s Links", url="http://xxxxx.com/", image="http://www.xxxx.com/sponsors/xxxx.jpg", description="", sclicks="", inactive="0" WHERE sid=2;

MySQL Error : Unknown column 'sclicks' in 'field list'
Error Number : 1054
Date : Monday, July 23rd 2007 @ 09:57:42 AM
Script : http://www.xxxx.com/admincp/tfw.php?do=editsave
Referrer :
IP Address : xxx.xxx.xxx.xxx
Username : Badger
Classname : vB_Database

How do I uninstall this mod without screwing up things?

Thanks....

Regards,
Badger

[BadgerDog]

This is brutal ....

I managed to get it to show image by not leading with a path... hope that helps someone...

However, once displayed in forums and you click on image, I get:

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE `tfw_sponsors` SET sclicks=sclicks + 1 WHERE sid='4';

MySQL Error : Unknown column 'sclicks' in 'field list'
Error Number : 1054
Date : Monday, July 23rd 2007 @ 10:17:07 AM
Script : http://www.xxxxx.com/sponsor.php?id=...riflechair.com
Referrer :
IP Address : xxxxx.xxxx.xxxx.xxxx
Username : Badger
Classname : vB_Database

For some reason, it will accept a new entry, but as soon as you go back to test an existing entry, it starts giving database errors. In trying to figure out what it wants in the fields, I have been only able to get this far by adding new entires, then deleting them to start over with new tests, as the edit doesn't seem to work all....

Has anyone got this working? :erm:

Regards,
Badger

[BadgerDog]

UNINSTALLED ...........

Besides all of the errors, we found that it corrupted our VBadvanced Home Page "News" display. For some reason, when this mod is turned ON, it creates an inability to find attachment images, when turned OFF, the "News" display instantly returns to normal. The news display slideshow I'm referring to can be seen here: www.milsurps.com

Anyway, nice idea , but I'm not sure it's ready for prime time, although thanks for the coder's efforts... :up:

Can anyone recommend another mod that can do something similar to this, locating a sponsor page at the bottom of the Forum Home Page?

Regards,
Badger

[principino1984]

how did you uninstall it?

[Yours]

Originally Posted by BadgerDog

UNINSTALLED ...........

Besides all of the errors, we found that it corrupted our VBadvanced Home Page "News" display. For some reason, when this mod is turned ON, it creates an inability to find attachment images, when turned OFF, the "News" display instantly returns to normal. The news display slideshow I'm referring to can be seen here: www.milsurps.com

Anyway, nice idea , but I'm not sure it's ready for prime time, although thanks for the coder's efforts... :up:

Can anyone recommend another mod that can do something similar to this, locating a sponsor page at the bottom of the Forum Home Page?

Regards,
Badger

Most of the issues should have been fixed in 1.3
The mod is an independent mod so it is not supported by nor possibly integratable with vBAdvanced. The issue may be something to do with your vBAdvanced settings. For News/recent posts make sure you select a category instead of it just pulling things from all categories as it may be reading the Sponsors as a whole other Forum Category, which it should not be

[BadgerDog]

Originally Posted by principino1984

how did you uninstall it?

There were no instructions on how to remove it, so I simply used the standard AdminCP function for un-installng the XML file, then deleted all of the uploaded files that came with the mod. There was some vague references in the INSTALL.TXT file about the FORUMHOME template, but it seemed to be related to what the author called "upgrading". Since I never did those template mods, I never bothered with the FORUMHOME template as the hack didn't seem to be in it anyway....

Regards,
Badger