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

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 :(

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

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

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

Indeed...

I shall look into it...

Satan

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

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

Satan

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

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