try these 2 new queries:
[sql]
ALTER TABLE affiliates_settings ADD perpage int(3) NOT NULL, ADD bbsmilies tinyint(4) NOT NULL, ADD bbimage tinyint(4) NOT NULL, ADD moment tinyint(4) NOT NULL, ADD most_hitsout tinyint(4) NOT NULL, ADD most_hitsin tinyint(4) NOT NULL, ADD most_votes tinyint(4) NOT NULL, ADD imagelink varchar(250) NOT NULL, ADD senderemail varchar(255) NOT NULL, ADD module_position tinyint(4) NOT NULL, ADD cantview varchar(50) NOT NULL, ADD cantapply varchar(50) NOT NULL, ADD cantrate varchar(50) NOT NULL, ADD disclaimer tinyint(4) NOT NULL, ADD validate tinyint(4) NOT NULL, ADD reporting tinyint(4) NOT NULL, ADD reportemail varchar(255) NOT NULL, ADD cantreport varchar(50) NOT NULL, ADD delay int(3) NOT NULL;
[/sql]
and
[sql]
ALTER TABLE affiliates CHANGE clicks clicksout INT( 20 ) NOT NULL ;
ALTER TABLE affiliates2 ADD clicksin INT(20) DEFAULT '0' NOT NULL, ADD approved tinyint(4) NOT NULL;
[/sql]

for the template edit, those changes need to be made in the AFFILIATE template.

im not sure what your putting for your cron so can you post the title your giving the scheduled task?

Sorry for this problem and oh yes, zip has been updated:)

for those who have already downloaded, here is an updated upgrade_instruct.txt

First query worked, but the second one didnt and i got this back:

SQL-query :

ALTER TABLE affiliates CHANGE clicks clicksout INT( 20 ) NOT NULL

MySQL said:

Unknown column 'clicks' in 'affiliates'

Also, what title can i use for the scheduled task?

i named my scheduled task: Empty Affiliates Records

for query there must be sumthing wrong with your table, because in the original version of this there was a clicks column in the affiliates table. i even ran that query on a test table.

well this hack doesnt require table prefixes since the queries and the creation of tables dont use any;)

the minimum queries with all modules off,validation off, and bb code parse off, is 11 queries(base is usally 8). With everything on the maximum is 22. with the 4 new modules off you have about 14 queries. Validation doesnt add query just a rarely shown extra load time and server load. so basically with all the enhanced features off you cut the queries in half. this is why i made this hack so customizable so you can out fit it to your boards needs:)

each module adds about 1 query

Err, im a big novice, on hacks. So, how can i fix this?

kk, i've sorted that out.

But look: http://www.game-realms.net/vb/affili...ates&styleid=5 and http://www.game-realms.net/vb/affili...ates&styleid=6 and http://www.game-realms.net/vb/affili...ates&styleid=3

There very distorted, how do i fix that??

Also, whats that error at the top?

Also, im still having that problem, that i cant add any affiliates. :(.

I get this:

to fix the table run this query:
[sql]
ALTER TABLE affiliates ADD clicksout INT( 20 ) NOT NULL;
[/sql]

i dont understand wut u mean by distorted?

for the error, you must setup your settings and perpage values via admincp. you are getting that error because you dont have a perpage value set:)

you must provide an email,name, url for the site