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

@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

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.......

Ok cool:)

Satan

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??...

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:

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....

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?

bump

some assistance please?

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

@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

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.

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:

Did you update the vBulletin Options?:)

Satan

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

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

What is X-Cart?:)

Satan

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

You mean like a "site comment" field?

I could include it for the next version:)

Satan

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)

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

Satan

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*

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

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

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

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

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

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

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

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.....

Anyone can help please!!!!

Hello!. Anyone there?

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!