Public feed #721537

Someone

public text v1 · immutable
Raw Edit
·published 2007-10-01 09:44 UTC
rendered paste body
$query = "
		SELECT webpage_id AS id, webspace_id, webpage_name AS name, concat_ws('index.php?wp=', webpage_name) AS link
		FROM " . $db->prefix . "_webpage
		WHERE webpage_body LIKE " . $db->qstr($pattern) . "
		UNION 
		SELECT stylesheet_id AS id, webspace_id, stylesheet_name AS name, 'stylesheet_editor.php?stylesheet_id=' AS link
		FROM " . $db->prefix . "_stylesheet
		WHERE stylesheet_body LIKE " . $db->qstr($pattern) . "
		UNION
		SELECT block_id AS id, webspace_id, block_name AS name, 'index.php?t=block_editor&block_id=' AS link
		FROM " . $db->prefix . "_block
		WHERE block_body LIKE " . $db->qstr($pattern) . "
		UNION
		SELECT subject_id AS id, webspace_id, subject_title AS name, concat('index.php?wp=', subject_title, '&subject_id=', subject_id) AS link
		FROM " . $db->prefix . "_plugin_forum_subject
		WHERE subject_body LIKE " . $db->qstr($pattern) . "";