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