Forum Home Enhancements - Advertise Page

Advertise Page

vBulletin 3.5.x and vBulletin 3.6
www.vBHackers.com

Demo Here: http://www.vbhackers.com/advertise.php

What this does
Creates an Advertise page with changable variables. For example if you look at the demo the spots available, rotation, price and paypal button is changable. But if you really want to see it all then press install

(cool, it rhymes :p)

To do list...

Time to install: As long as it takes you to import an xml and upload a file
New Templates: 1
Template Edits: 0
New Files: 1
New Phrases: 10
New Plugins: 1

Help & Support
Before asking for support Please make sure you have done all necessary changes! If you still need support please post a reply here.

Note
Done by Rex's request so he'd better use it or i'll mug him :bandit:

Instructions
Import the attached XML and then Upload advertise.php to forum root.

Hope you like, feedback welcomed.

Remember to Press:

This is a install button for vbhackers

Nick R · 07-04-2006, 06:02 PM

Oh yeah, planned update: automatically add text link to the footer once the admin verifies the paypal payment

webgroup · 07-23-2006, 06:32 PM

I get this error when I try to load any page on the forum after installing the product:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT userid, username FROM vbnewuser WHERE vbnewuserid=49190;

MySQL Error : Unknown column 'vbnewuserid' in 'where clause'
Error Number : 1054
Date : Sunday, July 23rd 2006 @ 05:28:21 PM
Script : http://www.forum.net/forum/advertise.php
Referrer :

Thanks God I uninstalled the hack and all is fine again.

Any help?

MaxM · 07-24-2006, 03:51 AM

Don't know whats happening..but on my board no. of queries (before installing this hack) used were: 12 and after installing this advertise hack, its saying no. of queries used: 18 !!

When i disable this advertise hack, then no. of queries used 12

Nick R · 07-24-2006, 12:36 PM

ok, guys, lets all stay calm,

first bug: there is nothing in this hack that would change this, the only thing that looks like it has gone worng is it misses out the "." so it should be:

You must first be a registered member to view any code.

Nick R · 07-24-2006, 12:37 PM

second bug: the query's it uses for the advertise page are all set globally, you just need to make a new plugin for it and change the location. Hold on a sec and i'll tell you what to do

Ark · 07-26-2006, 02:50 PM

Quote:

Originally Posted by webgroup

I get this error when I try to load any page on the forum after installing the product:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT userid, username FROM vbnewuser WHERE vbnewuserid=49190;

MySQL Error : Unknown column 'vbnewuserid' in 'where clause'
Error Number : 1054
Date : Sunday, July 23rd 2006 @ 05:28:21 PM
Script : http://www.forum.net/forum/advertise.php
Referrer :

Thanks God I uninstalled the hack and all is fine again.

Any help?

Get the same error

Nick R · 07-26-2006, 02:52 PM

this just uses global variables, if you disable the plugin and then hardcode it manually it will work fine.

There is no-reason while you should get that error it is just your forums messing up..

whwebsolutions · 07-28-2006, 07:36 AM

Hello I am getting a database error that looks ike this:

Invalid SQL:
SELECT userid, username FROM forum_user WHERE forum_userid=1;

MySQL Error : Unknown column 'forum_userid' in 'where clause'
Error Number : 1054

Can you tell me what the problem is and how I can fix it?

Nick R · 07-28-2006, 07:48 AM

let me guess forum_ is your table prefix? The problem is my dodgy coding :p

It had a stray table prefix on one of the where's so it was adding the table prefix to the column which made it pop up as an error.

Nick R · 07-28-2006, 07:51 AM

updated main post, reduced 4 queries across the forums, fixed table prefix errors and lowered 1 query on the advertise page. If you get errors on every page of the forums before using this, you no longer will you will only get it on the advertise page + i have fixed all known errors so it should work fine now.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Advertise Page	Rex	vBulletin Modification Requests	7	07-01-2006 10:30 AM
Only certian users can view this page	salman	General vBulletin Support	6	03-19-2006 08:16 AM
Ony Logged in memebrs can view the page	salman	General vBulletin Support	14	02-02-2006 04:17 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)