Log in

View Full Version : i need SQL help on affiliates hack


VBUsers
04-27-2005, 10:04 PM
ok i am trying to add the affiliates hack to my forum and im having issues with the last SQL query i have to run. here it is:

INSERT INTO phrase VALUES('64585', '-1', 'saved_affiliate_x_successfully', '<i>{1}\'s</i> has been updates!', '9000');
INSERT INTO phrase VALUES('64584', '-1', 'deleted_affiliate_x_successfully', '<i>{1}</i> has been deleted!', '9000');
INSERT INTO phrase VALUES('64586', '-1', 'deleted_affiliate_x_unsuccessfully', '<i>{1}</i> was not deleted due to your choice selection.', '9000');
INSERT INTO phrase VALUES('64587', '-1', 'inserted_affiliate_x_successfully', '<i>{1}</i> has been successfully added to the data base.', '9000');
INSERT INTO phrase VALUES('64589', '-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 VALUES('64590', '-1', 'saved_affiliate_settings_successfully', 'Settings for Affiliates Addon Updated.', '9000');
INSERT INTO phrase VALUES('64593', '-1', 'updated_affiliate_type_successfully', '<i>{1}</i> was updated successfully.', '9000');
INSERT INTO phrase VALUES('64592', '-1', 'updated_affiliate_type_unsuccessfully', 'The type was <u>not</u> updated because the types name was left blank.', '9000');
INSERT INTO phrase VALUES('64594', '-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 VALUES('64595', '-1', 'saved_affiliate_type_successfully', '<i>{1}</i> was added to the database successfully.', '9000');


the others went thru simple but this last one keeps giving me errors. can anyone help me out?

Adrian Schneider
04-27-2005, 10:05 PM
What error does it give you?

VBUsers
04-27-2005, 10:07 PM
i think it might be the prefix i have on the tables , im not sure. the others went fine because i created a table then inserted the extra sql's. so please let me know what you think

SQL-query:

INSERT INTO phrase
VALUES (

'64585', '-1', 'saved_affiliate_x_successfully', '<i>{1}\'s</i> has been updates!', '9000'
)
MySQL said:

#1146 - Table 'smora_forum.phrase' doesn't exist

bump for this please help