Navigation

Changeset 6534

Timestamp:

09/01/08 15:43:37 (3 months ago)

Author:

ethans

Message:

I think I got all the instances of LIKE _'s that need to be escaped properly in sqlite3

Fixes #3129

Files:

r6533	r6534
3474	3474	// see if they're still using the old dialprefix method
3475	3475	if ($amp_conf["AMPDBENGINE"] == "sqlite3") {
3476		$sql ="SELECT variable,value FROM globals WHERE variable LIKE 'DIAL~~_OUT_%~~'";
	3476	$sql ="SELECT variable,value FROM globals WHERE variable LIKE 'DIAL\_OUT\_%' ESCAPE '\'";
3477	3477	}
3478	3478	else {
…	…
3535	3535	// delete old values
3536	3536	if ($amp_conf["AMPDBENGINE"] == "sqlite3") {
3537		$sql = "DELETE FROM globals WHERE (variable LIKE 'DIAL~~_OUT_%')~~ OR (variable = 'OUT') ";
	3537	$sql = "DELETE FROM globals WHERE (variable LIKE 'DIAL\_OUT\_%') ESCAPE '\' OR (variable = 'OUT') ";
3538	3538	}
3539	3539	else {
…	…
3655	3655
3656	3656	//Retrieve each trunk tech for later lookup
3657		$sql="select * from globals WHERE variable LIKE 'OUT\\_%'";
	3657	if ($amp_conf["AMPDBENGINE"] == "sqlite3") {
	3658	$sql="select * from globals WHERE variable LIKE 'OUT\_%' ESCAPE '\'";
	3659	}
	3660	else {
	3661	$sql="select * from globals WHERE variable LIKE 'OUT\\_%'";
	3662	}
3658	3663	$result = $db->getAll($sql);
3659	3664	if(DB::IsError($result)) {