Need More Help Un-Doing Query

[dieselpowered]

Hey everyone, alright, I need to remove this query from my database...what would be the correct command to run??

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');

Thank you!!

[Marco van Herwaarden]

[sql]DELETE FROM phrase WHERE varname = 'saved_affiliate_x_successfully';[/sql]

Repeat that for each phrase. (changing the name ofcourse).

[Colin F]

Originally Posted by xtremeoff-road

Hey everyone, alright, I need to remove this query from my database...what would be the correct command to run??



Thank you!!

That would be more than one query

Run a query accordingly for each of the above.
[sql]DELETE FROM phrase WHERE varname = 'saved_affiliate_x_successfully' LIMIT 1;[/sql]

Exchange the varname each time

[Marco van Herwaarden]

Slooooooow Colin

PS That limit is not needed, and could even have undesired side effects.

[dieselpowered]

excellent...thank you guys!!! as always, appreciate the help I am sure I will have more questions, you must forgive my ignorance

[Colin F]

Originally Posted by MarcoH64

Slooooooow Colin

PS That limit is not needed, and could even have undesired side effects.

Oh bugger off

Why could it have undesired side effects?

[Marco van Herwaarden]

If you have translations into other languages for that phrase, those would not be deleted. Only 1 (and since no ORDER BY is given, this is arbitrary) phrase will get removed.

[dieselpowered]

Hi there...sorry me again...alright I need to undo a bunch of these:

$DB_site->query("INSERT INTO ".TABLE_PREFIX."phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'tratings', 'Trader Ratings', 1)");

So how would that look?? Like this:

DELETE FROM phrase WHERE varname = 'tratings', ;Trader Ratings';

Thanks for the help!!

[Marco van Herwaarden]

Just:
[sql]DELETE FROM phrase WHERE varname = 'tratings'[/sql]

[dieselpowered]

LOL I am sorry, what would these be?

$DB_site->query("ALTER TABLE ".TABLE_PREFIX."user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL");

$DB_site->query("ALTER TABLE ".TABLE_PREFIX."user ADD INDEX ratetradetotal (ratetradetotal)");

I very much appreciate your help!

I was thinking it would be:

ALTER TABLE user DROP ratetradetotal;

ALTER TABLE user DROP INDEX ratetradetotal ;