vBaffiliates5 - Allow Users to Add & Edit their Own Affiliate Links!!!

[Chris M]

Please do the following before attempting to install:

1.) Backup your Files before doing anything
2.) Be aware that although I have tested this myself, there may still be problems...If you do not backup your files, I cannot condone your install of this hack...
3.) If you want to Backup your Database, You can - There shouldn't be any need to...

The file you should have is:

vBaffiliates5.zip

Install Info:
Hack Version: 5.0 [Final]
Files to edit: 2
Templates to add:13 (New Install) / 0 (Upgrade from v4)
Templates to edit: As Many as needed (New Install) / Minimum of 1 (Upgrade)
Queries to Run: 6 (New Install) / 0 (Upgrade from v4)
Time to install: Approx 8-10 Minutes
Included files: There are 2 install files included - One is for upgrading from v4, and the other is for a new install - Do not mix them up;)

Credits
Requested by - DarkDraco07 here (https://vborg.vbsupport.ru/showthread.php?s=&threadid=47001) & Sinecure

Support - I am offering Support in this Thread ONLY...I unfortunately cannot be here during the coming weeks (Mon-Fri), so therefore you will have to rely on others for assitance, should it be urgent...If you do require assitance, please - Only reply in this thread

Hack info

What does it do? - Basically, you can allow registered board users to add Affiliation Links to the database, which have to be moderated by you...You can then display a Random Banner generated totally at random wherever you like, and it will be linked to the site of the submitter...Also it stores the Image Height and Width in the database, and you can limit the size of the Banners they can upload...If they change the image (located on their server) without editing their Banner, then it will not show up their Banner, Link, Hit Count, Edit Link or Site Name...They must then ask an Admin to update the Banner...Now there is also a List of the Banners on the site, and their Moderated Status...You can also choose how many Banners to show in the list;)

Testing

You can see the BETA Release here (https://vborg.vbsupport.ru/showthread.php?s=&threadid=47004)...

Changes since BETA


Changed the way that Links are shown
Added another Template to add


Changes since 1.0[Final]


Added missing re-direct template
Added another Template to add
Added image size restriction
Changed a template
Added an intelligent Image check to see if they changed the size of the image in an attempt to cheat the system


Changes since 2.0[Final]


Corrected forum/global.php mishap
Added a Hit Counter
Added a "User Edit" Screen
Changed a template
Update the Intelligent Image check to see if they changed the size of the image in an attempt to cheat the system


Changes since 3.0[Final]


Updated forum/global.php to show a Admin CP Options controlled number of Banners
Added a Banner List page, showing all the Banners and their Moderated Status
Added a Banner List page Banner Limit, to show only the number of Banners Randomnly that you want
Update the Intelligent Image check to see if they changed the size of the image in an attempt to cheat the system and put it in a while loop


Changes since 4.0[Final]


Updated forum/vbaffiliates.php to work with register_globals off, and modified code structure slightly
Updated admin/affiladmin.php to work with register_globals off, and modified code structure slightly


Additional Info/Updates

2.0[Final] - 2.0[Final] has just been released...This includes an Image Size restriction, and a clever system for those who think they can get around the system - It stores the image's height and width, and uses HTML to code the width and height of the image - If they change it, it will show a red "no image found" image instead...

3.0[Final] - 3.0[Final] has just been released...This includes an update to the Image Size restriction, and an update for the clever system for those who think they can get around the system - It stores the image's height and width, and uses HTML to code the width and height of the image - If they change it, it will not show their Banner, Link, Site Name, Edit Link or Hit Count...

4.0[Final] - 4.0[Final] has just been released...This includes an update to the Image Size restriction, and an update for the clever system for those who think they can get around the system - It stores the image's height and width, and uses HTML to code the width and height of the image - If they change it, it will not show their Banner, Link, Site Name, Edit Link or Hit Count...Now there is also a List of the Banners on the site, and their Moderated Status...You can also choose how many Banners to show in the list;)

5.0[Final] - 5.0[Final] has just been released...This release includes a new set of .php files which have been re-coded to work with register_globals off, and also the coding structure has been changed...

The next release is a List of "User's Banners" page, and a then a Timed function to set the Moderated status to 0 (No) when the time period expires...

Screenshots/Live Demo

There are NEW screenshots provided in the next post, in vBaffiliates5-screenshots.zip:)

Enjoy!:)

Satan

[Chris M]

Screenshots of vBaffiliates5:)

Satan

[assassingod]

Mega coolness:D
Finally the final release:D

Great hack hellsatan:D Will install on my board very soon:)

[Chris M]

Heh thanks Ag:)

I am gonna install this on DarkBlazes soon:)

Satan

[Mystis]

I'm working on something semi-similar to this, this looks absolutely fantastic though :) Great job!

[DarkDraco07]

would be nice to add a option that allows unregistered members to affiliate. cuz we are a gaming clan and we get allies and stuff. and adding a email field would hurt >.>

[Mystic Gohan]

this seems very kool. I like this concept I will most definatly install on my forum *clicks Install*

[zajako]

by moderate, do you mean admin approve it before it shows up?

[Smoothie]

anyone have a live screenshot of this installed?

[DarkDraco07]

<a href="http://www.darknemesis.com/myvbindex.php" target="_blank">www.darknemesis.com/myvbindex.php</a> is a working version

[DarkDraco07]

also, if anyone wants to do what i did heres how to do it:

if you want unregistered people to be able to affiliate without registering do this:

open vbaffiliates.php and find:
--------------------------------------
if ($bbuserinfo['usergroupid']=="1") {
show_nopermission();
}
--------------------------------------

erase it and upload :p

[Smoothie]

Originally posted by DarkDraco07
www.darknemesis.com/myvbindex.php is a working version Cool. Thanks. :classic:

[Smoothie]

Another question. How are you controlling the size of the banner?

[DarkDraco07]

um, the banners are originally 88x31. i dont know if hellsatan made it so its 88x31 only. and for the topsites i just edited the image height and width in the html coding

[assassingod]

Originally posted by zajako
by moderate, do you mean admin approve it before it shows up?

Yes, thats correct

[jjj0923]

this hack functions similarly to:

https://vborg.vbsupport.ru/showthread.php?s=&threadid=44551

[colicab-d]

is there a way to show the links on a page in rows etc?

Also could it be possible to categorize them?

[Chris M]

@jj0923 - I suppose you could look at it that way...But this shows the Banners, and was coded differently to Arunan's hack;)

@colicab-d - I'm not sure what you mean by rows:s It would be possible to Categorise them, but I don't see the need when you only get to see a Randomnly chosen one...

If, by rows, you mean more than one Banner, then just change the Query in global.php, and change:

LIMIT 1
to the number of banners you want to show, i.e.
LIMIT 3

:)

@Smoothie - Controlling the Banner is proving to be difficult - Seeing as the url is stored, not the image, it is hard to find a way to limit the size of the banner...

Satan

[NTLDR]

Originally posted by hellsatan
@Smoothie - Controlling the Banner is proving to be difficult - Seeing as the url is stored, not the image, it is hard to find a way to limit the size of the banner..

I'm helping Chris come up with some solutions so that users can't cheat the system :p

[Chris M]

Yes:)

Thanks NTLDR:)

We have worked out a way to do it...They still can cheat the system (:(), but their banner will look screwed up if they do:p

Releasing 2.0 in a few minutes!:)

Satan

[NTLDR]

I've an idea to rectify that ;)

[Smoothie]

Does the current system link the banner? I'd rather upload the banner to my own server, and have it displayed from there.

[Smoothie]

Just looked at the screen shots, very nice.

[Chris M]

Yes it does link the banner...I am working on the Hits version (v3) next, and then the "timed banner" addon for you:)

Satan

[alkatraz]

Cool hack!

[Smoothie]

Originally posted by hellsatan
Yes it does link the banner...I am working on the Hits version (v3) next, and then the "timed banner" addon for you:)

Satan I was wondering, would it be possible to allow an upload of the banner, instead of linking?

Something like this hack, which allows banner uploads. I really don't want someones banner slowing our site down.

Check it out:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=12815&highlight=vblinks

[Chris M]

Thanks alkatraz - v3 is very near to release:)

I just need to test the major new feature, which is "User Editability";)

Satan

[Chris M]

@Smoothie - It is possible...I just need to learn how to do a good Upload script that complies with the limitations set by each board...

Satan

[Dean C]

This looks nice satan... :p

[Mystis]

Originally posted by hellsatan
@Smoothie - Controlling the Banner is proving to be difficult - Seeing as the url is stored, not the image, it is hard to find a way to limit the size of the banner...

Satan

That would be a simple one to get around.


/* Add to functions.php */
function checkimagesize($imageurl){
global $maxwidth, $maxheight;
$size = getimagesize($imageurl);
if($size[0]>=$maxwidth&&$size[1]>=$maxheight){
return true;
}else{
return false;
}
}

/* Usage */
if(checkimagesize($image)){
//display
}else{
//skip this ad and get another one
}

Code's untested, but it should work.

[Chris M]

It's ok Mystis...

v2 has the Size limiter in;):)

I used code a little bit different to that;)

@Mist - Thanks:p

Satan

[Chris M]

v3

v3 will be released tomorrow:)

v3 includes:

User edit Link
Hit counter
v2 bug fixes


:)

Satan

[kevo]

Good cant wait.. V2.. When someone tries to add their link. It always says that the banner is too big.. How do i fix that.

[DarkDraco07]

how do u make it show more than 1 banner

[Chris M]

@kevo - I myself had this problem...In the vBulletin Options, be sure to read what Value you are setting for Height and Width restrictions...

If you do not want restrictions, just set them both to something like 900:)

@DarkDraco - This is untested, but:

Open forum/global.php
Find:
$affillink = $DB_site->query_first("SELECT linkid,name,link,b_link,height,width FROM vbaffiliates WHERE moderated='1' ORDER BY RAND() LIMIT 1");
Replace with:
$affillink = $DB_site->query_first("SELECT linkid,name,link,b_link,height,width FROM vbaffiliates WHERE moderated='1' ORDER BY RAND() LIMIT X");

Change the X to a value you want to show...I wouldn't recommend more than 3...

Satan

[colicab-d]

i would like to see it be able to display all the links on a page in rows and categorized :D thats what i mean , that would be so cool :D

[Chris M]

Hmm...Like a List of Affiliates? Hmmm...Maybe v4 or v5;)

Satan

[Chris M]

v3 released

v3 is released:) Check the First Post for Installation file, and 2nd post for Screenshots:)

Satan

[DrkFusion]

COol Great job Satan!

[Chris M]

Heh thanks Arunan:)

Satan

[DarkDraco07]

can anyone tell me how to make it show more than 1 banner?
i changed the LIMIT 1 but it still shows 1

[C.Birch]

im having a really big prob adding anything to my database via phpmyadmin

eg try adding:

INSERT INTO settinggroup (settinggroupid,title,displayorder) VALUES (32,'vBaffiliates','99')


Get:
Error
SQL-query : [Edit]

INSERT INTO settinggroup (settinggroupid,title,displayorder) VALUES (32,\'vBaffiliates\',\'99\')

MySQL said:


You have an error in your SQL syntax near '\'vBaffiliates\',\'99\')' at line 1


Try:
CREATE TABLE `vbaffiliates` (
`linkid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(100) NOT NULL,
`link` VARCHAR(150) NOT NULL,
`b_link` VARCHAR(150) NOT NULL,
`moderated` smallint(6) DEFAULT '0' NOT NULL,
`height` smallint(6) NOT NULL,
`width` smallint(6) NOT NULL,
`hits` smallint(6) DEFAULT '0' NOT NULL,
`userid` smallint(6) NOT NULL
) TYPE = MYISAM;


Get:
Error
SQL-query : [Edit]

CREATE TABLE `vbaffiliates` (
`linkid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(100) NOT NULL,
`link` VARCHAR(150) NOT NULL,
`b_link` VARCHAR(150) NOT NULL,
`moderated` smallint(6) DEFAULT \'0\' NOT NULL,
`height` smallint(6) NOT NULL,
`width` smallint(6) NOT NULL,
`hits` smallint(6) DEFAULT \'0\' NOT NULL,
`userid` smallint(6) NOT NULL
) TYPE = MYISAM;

MySQL said:


You have an error in your SQL syntax near '\'0\' NOT NULL,
`height` smallint(6) NOT NULL,
`width` smallint(6) NOT NULL,
' at line 6


can someone help its doing it for almost everything i try that needs database work but it never used to :(

[Chris M]

Hmmm...

Perhaps you should install FireFly's "SQL Query via Admin CP" Hack...

All I can say is that the queries worked for me, but it looks like your phpmyadmin may have a problem...

Is it just this hack, or does it do it for others?

@DarkDraco07 - I am sure that changing the LIMIT value should work...

Satan

[DarkDraco07]

i changed the limit to 99 and it still only shows 1 banner

[DarkDraco07]

btw, i put the $affiliate var on the myvbindex page. does that have anything to do with my prob?

[Chris M]

Indeed...

I shall look into it...

Satan

[DarkDraco07]

i tried puttin it on my forumhome template but it still shows 1

[Chris M]

@DarkDraco07 - I am releasing v4 soon, which has the option for this and much more:)

Satan

[Chris M]

v4 Released!

vBaffiliates4 has been released!

It includes a Banner List Page (with randomnly generated banners), a Limit to the Number of Banners to List on the page, and the Support for an Admin Options controlled Number of Banners to show:)

Satan

[kevo]

::clicks install::.. This looks great.. Is there going to be any other future versions?

[NTLDR]

*lol* A version a day it seems hellsatan is going for ;)

[kevo]

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT * FROM vbaffiliates ORDER BY linkid LIMIT
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Sunday 29th of December 2002 05:22:53 PM
Script: http://www.enactive.net/forums/forums/vbaffiliates.php?action=list
Referer: http://www.enactive.net/forums/


I get this error. Any help?

[DrkFusion]

Originally posted by NTLDR
*lol* A version a day it seems hellsatan is going for ;)
So you noticed too? heh

[Chris M]

@kevo - Yup...There should be at least one more version;)

That file you've got looks wrong:(

Send it to me in a PM;)

Satan

[DarkDraco07]

works now :)

[Chris M]

Goody good:)

Satan

[C.Birch]

Originally posted by C.Birch
im having a really big prob adding anything to my database via phpmyadmin

eg try adding:

INSERT INTO settinggroup (settinggroupid,title,displayorder) VALUES (32,'vBaffiliates','99')


Get:
Error
SQL-query : [Edit]

INSERT INTO settinggroup (settinggroupid,title,displayorder) VALUES (32,\'vBaffiliates\',\'99\')

MySQL said:


You have an error in your SQL syntax near '\'vBaffiliates\',\'99\')' at line 1


Try:
CREATE TABLE `vbaffiliates` (
`linkid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(100) NOT NULL,
`link` VARCHAR(150) NOT NULL,
`b_link` VARCHAR(150) NOT NULL,
`moderated` smallint(6) DEFAULT '0' NOT NULL,
`height` smallint(6) NOT NULL,
`width` smallint(6) NOT NULL,
`hits` smallint(6) DEFAULT '0' NOT NULL,
`userid` smallint(6) NOT NULL
) TYPE = MYISAM;


Get:
Error
SQL-query : [Edit]

CREATE TABLE `vbaffiliates` (
`linkid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(100) NOT NULL,
`link` VARCHAR(150) NOT NULL,
`b_link` VARCHAR(150) NOT NULL,
`moderated` smallint(6) DEFAULT \'0\' NOT NULL,
`height` smallint(6) NOT NULL,
`width` smallint(6) NOT NULL,
`hits` smallint(6) DEFAULT \'0\' NOT NULL,
`userid` smallint(6) NOT NULL
) TYPE = MYISAM;

MySQL said:


You have an error in your SQL syntax near '\'0\' NOT NULL,
`height` smallint(6) NOT NULL,
`width` smallint(6) NOT NULL,
' at line 6


can someone help its doing it for almost everything i try that needs database work but it never used to :(

I worked out what it was i already have in the data base useing the settings number 32 and 99 so i just edited them to 33 and 98 and it works fine now.

[Chris M]

Hmmm...

I'm glad that it worked, but you don;t usually get an SQL Syntax error for a duplicate Setting:confused:

Ah well...As long as it worked for you:)

Satan

[cklaszlo]

I'm getting an error now too:

Invalid SQL: SELECT linkid,name,link,b_link,height,width,hits,userid FROM vbaffiliates WHERE moderated='1' ORDER BY RAND() LIMIT
mysql error: You have an error in your SQL syntax near '' at line 1


I restored a backup Global.php :)

[NTLDR]

Originally posted by hellsatan
Hmmm...

I'm glad that it worked, but you don;t usually get an SQL Syntax error for a duplicate Setting:confused:

You should set the script so that it uses the next avalible ids and use $DB_site->insert_id() to get the id to use in the rest of the settings.

[Chris M]

@cklaszlo - The upgrade script only works from v3 to v4 - Any prior versions to v3, such as for v2 or v1, you should use the New Install file for instructions;)

@NTLDR - Good idea:)

Satan

[DarkDraco07]

i got somethin for ya to do, instead of having someone go through the whole registering process, have them go through a quick register. like user name, password, email, site link, banner link

[Chris M]

Hmmmm...

But g-force made a Quick Register hack;)

Satan

[DarkDraco07]

can u make the quick register just for this though :p

[Chris M]

I suppose I could;)

Satan

[colicab-d]

would it poss to make this into a self installing script :p so that folk dont need to install it manually (i.e adding sql queries etc)

[Chris M]

Sure:)

I've been trying to work a script to do this, and I reckon I can get it to:)

Gimme till next weekend to sort it;) (Knowing me it will be done tomorrow:p)

Satan

[colicab-d]

lol kool cause im really wantin to use this hack on me site :D

also how would i go about displaying say 5 links on my home (vbindex) is there a way to do it and can i have them listed horizontally?

I think also this would be kool (dont mean to sound rude its already an excellent hack)

If u can set it up so its displayed on a page in categories with maybe the top ten (maybe set in admin) of each showing a banner (in rows) and the rest in just plain link form :D

thnx again lol

[Chris M]

You mean all of them?

I can do a page with the "Top 10 visited" banners, and then others ordered by number of Hits:)

Satan

[colicab-d]

i just thought it may be good to display certain links as text as if its a high amount of images it may be upsetting for 56k users :p

Tho for the text links it may be a good idea to show a random set amount :S

[Chris M]

I see:)

Maybe the Top 5 should be Images (the banners), the 6-10 should be Bolded links, and the rest are randomnly generated?:)

Satan

[Logik]

That would be great. but what i think hes saying is. On his forum home. VBINDEX.. He wants to have the top 5 displayed on there in text.. I believe thats what hes saying.

[Chris M]

That is doable:)

As long as it is vBindex not vBhome - I'm not sure how to integrate it now...

Satan

[colicab-d]

no i just need say a random 5 on my home :D and its vbindex ;)

[Chris M]

Ok:)

Let me check the file and post a modification for you:)

Satan

[colicab-d]

great dude thnx hey add me on msn if u got it :)

[Chris M]

Added you:)

Satan

[DarkDraco07]

how come this is adding 2 queries per page? how can i make it only add queries to my homepage, not all

[Chris M]

@DarkDraco07 - It depends where you want it to show...;)

By default, I made it globalised, so you can add it to your header template:)

If you want it to only add to index, revert the global.php change, remove the variable from the header template, and add it to the forumhome template...

Then open forum/index.php (this is untested)
Find:
// if user is know, then welcome
if ($bbuserinfo['userid']!=0) {
$username=$bbuserinfo['username'];
eval("\$welcometext = \"".gettemplate('forumhome_welcometext')."\";");
eval("\$logincode = \"".gettemplate('forumhome_logoutcode')."\";");
eval("\$newposts = \"".gettemplate('forumhome_newposts')."\";");

} else {
$welcometext = "";
eval("\$newposts = \"".gettemplate('forumhome_todayposts')."\";");
eval("\$logincode = \"".gettemplate('forumhome_logincode')."\";");
}
add below:
// ###################### vBaffiliates Stuff #########################

// vBaffiliates stuff

$affillinky = $DB_site->query("SELECT linkid,name,link,b_link,height,width,hits,userid FROM vbaffiliates WHERE moderated='1' ORDER BY RAND() LIMIT $maxbannernumbers");
while ($affillink=$DB_site->fetch_array($affillinky)) {

if ($bbuserinfo[userid]==$affillink[userid]) {
$editlink = " <a href=\"vbaffiliates.php?s=$session[sessionhash]&action=useredit&linkid=$affillink[linkid]\">Edit</a>";
}else{
$editlink = "";
}

if ($imginfo=@getimagesize($affillink[b_link])) {
if ($imginfo[0]>$affillink[width] or $imginfo[1]>$affillink[height]) {
$affiliate = "";
}else{
eval("\$affiliate .= \"".gettemplate('affiliate')."\";");
}
}
}
:)

Satan

[DarkDraco07]

there was a variable in the header template??

[squawell]

hello Satan...i got this error

Invalid SQL: SELECT linkid,name,link,b_link,height,width,hits,userid FROM vbaffiliates WHERE moderated='1' ORDER BY RAND() LIMIT
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

can u tell me what the problem is??

PS:i install the version 4.0

[Chris M]

@squawell - I am assuming that this refers to the global.php file modification...Please can you post what you have got in that file...:)

@Dark Draco - I assumed that you put it there...If you didnt, then ignore the bit to remove it from the header template:)

Satan

[squawell]

Originally posted by hellsatan
@squawell - I am assuming that this refers to the global.php file modification...Please can you post what you have got in that file...:)
Satan
Satan..

i remove the code in global.php than it works....so i think maybe we dont need to add the code in that file....

anyway it works now.......

[Chris M]

Ok cool:)

Satan

[squawell]

i have a problem now

i set one page show five banner list..when i add the sixth banner

it did not show up...why?is it should have page(2):<< [1]2

something like this...so what is that problem??...

[Chris M]

Because it was designed to show only a certain amount of banners...

Just set the showable amount of banners higher;)

If you want a page system, I am sure I can code something next week:)

Satan

[squawell]

Originally posted by hellsatan
Because it was designed to show only a certain amount of banners...

Just set the showable amount of banners higher;)

If you want a page system, I am sure I can code something next week:)

Satan
i will wait u release page system that will make forum better...

thankz Satan.......... :bunny:

[squawell]

another question~~

can just add the moderate option in banner list but only show it to

who have permission to moderate? that will be easy and fast to

moderated.and do not need goto admin cp....

[DarkDraco07]

for somereason it doesnt show more than 1 banner on my homepage now. 2 of the banners are broken links right now and it doesnt show broken images. im thinking that might be the reason. heres how it is right now:

3 banners, 2 are broken and 1 isnt. the 1 shows and the other 2 dont. Someone adds a affiliate link with a working banner. i moderate it and then the 1 that did work doesnt work anymore. whats wrong?

[DarkDraco07]

bump

[DarkDraco07]

some assistance please?

[Logik]

Man o man, this is old, didnt think i'd see another post.

[Chris M]

@Dark Draco - Sorry...I haven't got a clue as to what is wrong with it...

Have you tried installing version4?

If you have already installed it, re-apply the database queries, after dropping the existing tables...

Other than that, you can PM me the url to look at, and I will see if I can determine the problem:)

Satan

[Yaxio]

i get this when i go to my forum:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT linkid,name,link,b_link,height,width,hits,userid FROM vbaffiliates WHERE moderated='1' ORDER BY RAND() LIMIT
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

i added everything correctly in the global.php file and everything.

[Yaxio]

i get this when i go to my forum:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT linkid,name,link,b_link,height,width,hits,userid FROM vbaffiliates WHERE moderated='1' ORDER BY RAND() LIMIT
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

i added everything correctly in the global.php file and everything.

[squawell]

Today at 01:18 AM Yaxio said this in Post #95 (https://vborg.vbsupport.ru/showthread.php?postid=375973#post375973)
i get this when i go to my forum:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT linkid,name,link,b_link,height,width,hits,userid FROM vbaffiliates WHERE moderated='1' ORDER BY RAND() LIMIT
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

i added everything correctly in the global.php file and everything.
u can try do not add the code in global.php maybe it will work~

because thats work for me..... :bunny:

[Chris M]

Did you update the vBulletin Options?:)

Satan

[Chris M]

v5 Released!

vBaffiliates5 has been released!

This update allows vBaffiliates to work with register_globals off, and also has a little script-structure update:)

Satan

[gmarik]

Great - If somebody thinks, he could integrate it with X-Cart, I could send you the code needed.

[Chris M]

What is X-Cart?:)

Satan

[DarkDraco07]

i know this is in final but could you add a comment into this? like when someone wants to put up a banner, the add a comment on why they should be affiliates

[Chris M]

You mean like a "site comment" field?

I could include it for the next version:)

Satan

[gmarik]

http://x-cart.com/ - shopping cart software
If you would need some coding tips from it, I could give a look at it. Because I have one. :o)

[Chris M]

I'm sorry - What has that got to do with this?:confused:

Satan

[XtReMaTriX]

Hey guys... does this work with version 2.2.8???

*UPDATE* well i got it to work, I set it up do just display the names... very simple, no redirects or anything... Thanx for the hack!!! :)

*Clicks Install*

[cindyd]

03-02-03 at 04:04 PM hellsatan said this in Post #86 (https://vborg.vbsupport.ru/showthread.php?postid=360230#post360230)
Because it was designed to show only a certain amount of banners...

Just set the showable amount of banners higher;)

If you want a page system, I am sure I can code something next week:)

Satan


Could someone tell me if the last version is a page system? That is what I am looking for. Thanks for the help.
Cindy

[Veg]

Im getting this error.

Invalid SQL: SELECT linkid,name,link,b_link,height,width,hits,userid FROM vbaffiliates WHERE moderated='1' ORDER BY RAND() LIMIT
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

[Veg]

Nevermind ive fixed. You should add a note in the readme about sizes.

[MuSuL]

Ok, this is the problem Im having...Firs the affiliate.php was making the site extremly slow!, then I removed the script for the global.php and now its like normal, but before any of this happend, not one banner would show up, no matter where I put the $affiliate at!...Still no banner...HELP!!!!!...thanks

[MuSuL]

Now I re-installed the script back into global.php..The banner showed up just once...then never again...HELP!

[MindTrix]

i got the same error that VEG got, can someone tell me how to fix it plzzz? ma sites dead until i do

[MindTrix]

yahh fixed it had to change settings thing in cp. Butttt, ima dumbass i cnt see no where at all that lets u mod the banners and let them be shown kinda thing

found it soz :S

[MuSuL]

Im still having the problem when I add $affiliate anywhere, it slows down the index.php or loading of the index.php....What gives...I have installed and delete and re-installed with the same problem, then when I delete the global.php script which I was told to add, the site runs fine, but the banners don't show up on any of the pages!....HELP!!!.... Please....thanks.....

[MuSuL]

Anyone can help please!!!!

[MuSuL]

Hello!. Anyone there?

[MuSuL]

Well time has run out on this hack, I just don't understand why I can't get help to a great hack if it does not work...Thanks for the help, Ill now delete the hack and try a different one.....

Soo, if you are looking for help here, it appears its not availble at this time...sad to see a hack go wasted!