YOURLS / YOURLS

 * Delete a link in the DB

 *

 */

function yourls_delete_link_by_keyword( $keyword ) {

	// Allow plugins to short-circuit the whole function

	$pre = yourls_apply_filter( 'shunt_delete_link_by_keyword', null, $keyword );

	if ( null !== $pre )

		return $pre;

	global $ydb;

	$table = YOURLS_DB_TABLE_URL;

    $keyword = yourls_sanitize_string($keyword);

    $delete = $ydb->fetchAffected("DELETE FROM `$table` WHERE `keyword` = :keyword", array('keyword' => $keyword));

	yourls_do_action( 'delete_link', $keyword, $delete );

	return $delete;

}

/**

 * SQL query to insert a new link in the DB. Returns boolean for success or failure of the inserting

 * Update a title link (no checks for duplicates etc..)

 *

 */

function yourls_edit_link_title( $keyword, $title ) {

	// Allow plugins to short-circuit the whole function

	$pre = yourls_apply_filter( 'shunt_edit_link_title', null, $keyword, $title );

	if ( null !== $pre )

		return $pre;

	global $ydb;

	$keyword = yourls_sanitize_keyword( $keyword );

	$title = yourls_sanitize_title( $title );

	$table = YOURLS_DB_TABLE_URL;

	$update = $ydb->fetchAffected("UPDATE `$table` SET `title` = :title WHERE `keyword` = :keyword;", array('title' => $title, 'keyword' => $keyword));

	return $update;

}

/**