that is sent through an email to them.

hello

am trying to install this now and has all gone to plan but im having trouble on the last query

im trying to add this query:
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_x_successfully', '<i>{1}\'s</i> has been updates!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_successfully', '<i>{1}</i> has been deleted!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_unsuccessfully', '<i>{1}</i> was not deleted due to your choice selection.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_successfully', '<i>{1}</i> has been successfully added to the data base.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_unsuccessfully', 'This affiliates could not be added to the database because you either did not enter an affiliate name or an affiliate url or an affiliate email.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_settings_successfully', 'Settings for Affiliates Addon Updated.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_successfully', '<i>{1}</i> was updated successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_unsuccessfully', 'The type was <u>not</u> updated because the types name was left blank.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_unsuccessfully', 'This type/category was not added to the database due to the name of this type/category not being filled in.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_successfully', '<i>{1}</i> was added to the database successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('0', 'approved_affiliate_x_successfully', '<i>{1}</i> has been approved successfully and an email has been dispatched to its admin\'s email.', '9000');

but it shows error saying table does not exist

my prefix is vb3_8 but dont know if or where i need to add that to make it work

can anyone help?

regards
dean

put it before the word phrase in INSERT INTO

works mate

thank you very much :D

great hack :D

How can I get it to show a random affiliate?

I have everything installed and no errors of any kind from where I can see. The problem I am having it in the AdminCP I check the areas to activate the addon, select the rest of my settings, and then when I save it, it shows that my information has been saved. (again no errors). However when the screen refreshes it shows the page if I had never made a selection at all. The addon also does not activate. In short it's not saving my selections. Any thoughts or ideas?

Thanks!

Just a quick inquiry...will we see this hack for vB3.5 :D

its been ported by Danny_vbt

When I add new template(affiliate_list), the following error occurred:

and When I run affiliate.php?do=listaffiliates, the following error occurred:
How can I resolved the problems?
BTW: my forum version is VB 3.0.9

Well I hope he took table prefixes into account then. I have installed this for someone tonight who uses them and had to edit ALL the queries because not one of them takes the use of table prefixes into account. :(