vb Sponsors

vB Sponsors
by Mist


Description:

Wow my first major hack is finally here. This hack allows you to add sponsors to forums via the administrators control panel. You can only have one sponsor per forum. The way in which this hack differs from all others is that it displays it inside the forum (in forumdisplay.php). It allows you to select a sponsor name, image, url, and log views and clicks for each banner (which are all editable via the administrators control panel).

Features:

• Sponsors on forumdisplay
• Easily edit your sponsors for each forum via the Admin CP
• Logs clicks and views for each sponsor
• A wide variety of customizable options via the Admin CP (coming soon)

Installation:

• Simply follow the instruction in the attachment

Credits:

• NanoEntity for guidance on the click logging.

[Dean C]

Sorry what do you mean skrueger?

- miSt

[MSX]

Edit: disregard this post please

[ryans]

Great hack. I'm curious though. In my forum display I do not user the moderator field. anyway to have it show up in that space instead?

[PurpleCow]

ryans...I was looking for a similiar thing.

Instead of showing up the image in the forum display...it could be shown in the mod column only.

Can this be done mist ??

Thanks for your time !

[Bulleh]

ok hacked installed, seems great
just a few opinions
1) Maybe it could have the box there when you dont have a sponsor saying "Sponsor This Forum - Click Here To Find Out How" or something like that,

2) in the Admin CP, when you add the sponsor, and it asks for image name, can you not make it so you can post the URL for that image, instead of having to upload it to your /images folder each time u add a sponsor,

as ive said , a great hack, just a few opinions,

[chad]

Wow thanks!

/me hits install

[clamcrusher]

when i try and run the last query:

ALTER TABLE forum ADD sponsorclicks MEDIUMINT(10) not null default '0' AFTER sponsorviews;


it sais this:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: ALTER TABLE forum ADD sponsorclicks MEDIUMINT(10) not null default '0' AFTER sponsorviews;

mysql error: You have an error in your SQL syntax near ';
' at line 1

mysql error number: 1064

Date: Thursday 14th of August 2003 03:21:09 AM
Script: http://www.anabolic-alchemy.com/admin/query.php
Referer: http://209.67.24.185/admin/query.php?t=0&s=


the others worked just fine

i finsihed the hcak install but i dont see anything in the admin panel to add banners, guess that query needs to be ran for it to work. help?

[clamcrusher]

ok when i try to make new forums i see the fields now. but i cant make a new forum cause when i try and save it it gives this error:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: INSERT INTO forum
(forumid,styleid,title,description,active,displayo rder,parentid,
parentlist,allowposting,cancontainthreads,sponsorn ame,sponsorimage,sponsorurl,sponsorviews,sponsorcl icks,
daysprune,newpostemail,newthreademail,
moderatenew,allowhtml,allowbbcode,allowimages,allo wsmilies,allowicons,
styleoverride,allowratings,countposts,moderateatta ch)
VALUES
(NULL,'1','Secure Questions','Ask questions in here that only the moderators and admins will be able to see. When you make posts in here only you and the mods will be able to view it, other members will not see it. DONT ASK FOR SOURCES, none will be given to you.','1','8','-1',
'','1','1','','','','','',
'30','','',
'0','0','1','0','1','1',
'0','0','0','0')
mysql error: Unknown column 'sponsorclicks' in 'field list'

mysql error number: 1054

Date: Saturday 16th of August 2003 03:49:34 AM
Script: http://www.anabolic-alchemy.com/admin/forum.php
Referer: http://209.67.24.185/admin/forum.php?action=add&s=

[Dean C]

You haven't run the queries as it asked in the file ^^

[FastAttack]

Hey mist are you going to update this for 3.0 ?