// Query for the network data
$result = SQL_QUERY_ESC("SELECT
- `network_id`, `network_short_name`, `network_title`, `network_reflink`, `network_data_seperator`, `network_row_seperator`, `network_request_type`, `network_charset`
+ `network_id`,`network_short_name`,`network_title`,`network_reflink`,`network_data_seperator`,`network_row_seperator`,`network_request_type`,`network_charset`
FROM
`{?_MYSQL_PREFIX?}_network_data`
WHERE
// Query for the network data
$result = SQL_QUERY_ESC("SELECT
- `network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`
+ `network_type_id`,`network_id`,`network_type_handle`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`
FROM
`{?_MYSQL_PREFIX?}_network_types`
WHERE
// Query for the network data
$result = SQL_QUERY_ESC("SELECT
- `network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`
+ `network_param_id`,`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`
FROM
`{?_MYSQL_PREFIX?}_network_request_params`
WHERE
// Query for all networks
$result = SQL_QUERY('SELECT
- `network_id`, `network_short_name`, `network_title`
+ `network_id`,`network_short_name`,`network_title`
FROM
`{?_MYSQL_PREFIX?}_network_data`
ORDER BY
// Query all types of this network
$result = SQL_QUERY_ESC("SELECT
- `network_type_id`, `network_type_handle`
+ `network_type_id`,`network_type_handle`
FROM
`{?_MYSQL_PREFIX?}_network_types`
WHERE
// Generator (somewhat getter) for network type options
function generateNetworkTypeOptions ($id) {
// Is this an array, then we just came back from edit/delete actions
- if (is_array($id)) $id = '';
+ if (is_array($id)) {
+ $id = '';
+ } // END - if
// Is this cached?
if (!isset($GLOBALS[__FUNCTION__][$id])) {
// Get all entries
$result = SQL_QUERY('SELECT
- `network_api_id`, `network_api_index`, `network_translation_name`
+ `network_api_id`,`network_api_index`,`network_translation_name`
FROM
`{?_MYSQL_PREFIX?}_network_api_translation`
INNER JOIN
SQL_QUERY('INSERT INTO
`{?_MYSQL_PREFIX?}_network_data`
(
- `' . implode('`, `', array_keys(postRequestArray())) . "`
+ `' . implode('`,`', array_keys(postRequestArray())) . "`
) VALUES (
'" . implode("','", array_values(postRequestArray())) . "'
)", __FUNCTION__, __LINE__);
SQL_QUERY('INSERT INTO
`{?_MYSQL_PREFIX?}_network_types`
(
- `' . implode('`, `', array_keys(postRequestArray())) . "`
+ `' . implode('`,`', array_keys(postRequestArray())) . "`
) VALUES (
'" . implode("','", array_values(postRequestArray())) . "'
)", __FUNCTION__, __LINE__);
// Fix empty network_type_banner_url to NULL
if (($key == 'network_type_banner_url') && (trim($entry[$id]) == '')) {
// Set it to NULL
- $entry[$id] = null;
+ $entry[$id] = NULL;
} // END - if
// Add this entry
// Fix empty request_param_default to NULL
if (($key == 'request_param_default') && (trim($entry[$id]) == '')) {
// Set it to NULL
- $entry[$id] = null;
+ $entry[$id] = NULL;
} // END - if
// Add this entry
SQL_QUERY('INSERT INTO
`{?_MYSQL_PREFIX?}_network_request_params`
(
- `' . implode('`, `', array_keys(postRequestArray())) . "`
+ `' . implode('`,`', array_keys(postRequestArray())) . "`
) VALUES (
'" . implode("','", array_values(postRequestArray())) . "'
)", __FUNCTION__, __LINE__);
SQL_QUERY('INSERT INTO
`{?_MYSQL_PREFIX?}_network_api_translation`
(
- `' . implode('`, `', array_keys(postRequestArray())) . "`
+ `' . implode('`,`', array_keys(postRequestArray())) . "`
) VALUES (
'" . implode("','", array_values(postRequestArray())) . "'
)", __FUNCTION__, __LINE__);