// Is an array so we can run it through
foreach ($keys_array as $key) {
// First check if it does exist
- $result_media = SQL_QUERY_ESC("SELECT
+ $result_media = sqlQueryEscaped("SELECT
`media_key`
FROM
`{?_MYSQL_PREFIX?}_mediadata`
`media_key`='%s'
LIMIT 1", array($key), __FUNCTION__, __LINE__);
//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'key=' . $key . ',SQL_NUMROWS()=' . SQL_NUMROWS($result_media));
- if (SQL_NUMROWS($result_media) == 0) {
+ if (sqlNumRows($result_media) == 0) {
// Not found so we create it (mode will be ignored here!)
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_mediadata` (`media_key`, `media_value`) VALUES ('%s', '%s')",
+ sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_mediadata` (`media_key`, `media_value`) VALUES ('%s', '%s')",
array($key, $value), __FUNCTION__, __LINE__);
} else {
// Update entry
if ($mode == 'init') {
// Initialize entry
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_mediadata` SET `media_value`=%s WHERE `media_key`='%s' LIMIT 1",
+ sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_mediadata` SET `media_value`=%s WHERE `media_key`='%s' LIMIT 1",
array($value, $key), __FUNCTION__, __LINE__);
} else {
// Update entry
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_mediadata` SET `media_value`=`media_value`".$mode."%s WHERE `media_key`='%s' LIMIT 1",
+ sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_mediadata` SET `media_value`=`media_value`".$mode."%s WHERE `media_key`='%s' LIMIT 1",
array($value, $key), __FUNCTION__, __LINE__);
}
}
//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'added=' . intval($added));
- $added = (!SQL_HASZEROAFFECTED());
+ $added = (!ifSqlHasZeroAffectedRows());
//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'added=' . intval($added));
} // END - foreach
} // END - if
$value = '';
// Check for entry
- $result = SQL_QUERY_ESC("SELECT `media_value` FROM `{?_MYSQL_PREFIX?}_mediadata` WHERE `media_key`='%s' LIMIT 1",
+ $result = sqlQueryEscaped("SELECT `media_value` FROM `{?_MYSQL_PREFIX?}_mediadata` WHERE `media_key`='%s' LIMIT 1",
array($key), __FUNCTION__, __LINE__);
// Is there one?
- if (SQL_NUMROWS($result) == 1) {
+ if (sqlNumRows($result) == 1) {
// Load data
- list($value) = SQL_FETCHROW($result);
+ list($value) = sqlFetchRow($result);
} // END - if
// Return data