[BarHopper]

I'm having quite a few problems with the SQL.

When i try:

ALTER TABLE affiliates_settings ADD perpage int(3) NOT NULL, ADD bbsmilies tinyint(4) NOT NULL, ADD bbimage tinyint(4) NOT NULL, ADD moment tiny(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;,

I get:

Originally Posted by My SQL

SQL-query :

ALTER TABLE affiliates_settings ADD perpage int( 3 ) NOT NULL ,
ADD bbsmilies tinyint( 4 ) NOT NULL ,
ADD bbimage tinyint( 4 ) NOT NULL ,
ADD moment tiny( 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

MySQL said:


You have an error in your SQL syntax near 'tiny( 4 ) NOT NULL ,
ADD most_hitsout tinyint( 4 ) NOT NULL ,
ADD most_h' at line 4

When i try:

ALTER TABLE affiliates CHANGE `clicks` `clicksout` INT( 20 ) DEFAULT '0' NOT NULL ;
ALTER TABLE affiliates2 ADD clicksin INT(20) DEFAULT '0' NOT NULL, ADD approved tinyint(4) NOT NULL;

I get:

Originally Posted by MySQL

SQL-query :

ALTER TABLE affiliates CHANGE `clicks` `clicksout` INT( 20 ) DEFAULT '0' NOT NULL

MySQL said:


Unknown column 'clicks' in 'affiliates'

And where do i edit this? ::

Originally Posted by Affiiliate Install file

-----------------------------------
Find:
<table class="galcat" style="border: 1px solid;" align="center" width="100%">
-----------------------------------
Replace with:
<table class="tcat" style="border: 1px solid;" align="center" width="100%">
-----------------------------------

Also, what title can my Shedule Task be? As i tried Affiliate, and a numbe rof others, and it keep saying:

Invalid title Specified

Please help, as i really wnat this hack.