Prosim pomoc s editací skriptu zapisujícího do SQL

Zdravím stáhl jsem si demo script klikačky "YOB.v4.0" hodil bych i odkaz, ale to se nedělá.
Potřeboval bych přidat funkci do scriptu která bude připočítávat do SQL databáze po kliknutí na zadané místo nebo odkaz
a vůbec netuším jak můžete mi někdo poradit.

Trochu upřesnění je tam fce. časovače (TIMER), která připočítává po odečtení času. Stačilo by mi, kdyby jsem věděl jak ji editovat tak, aby hlídala místo času kliknutí tam kde potřebuji. Předem díky za odpovědi.

oka pokusím se poslat něco užitečnýho :) Ale jak říkám sem nejvíc beginner



CREATE TABLE IF NOT EXISTS `yob_ads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`ip` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`tipo` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`visitime` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`ident` int(11) DEFAULT NULL,
`fechainicia` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`paypalname` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`paypalemail` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`plan` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`bold` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`highlight` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`url` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`description` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`members` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
`outside` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
`total` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=11 ;

Řekl bych že toto to zapisuje do databáze
a taky, že důležitý budou fce tipo a ident, ale nwm kde najdu nějaký skripty a podobně (je možný, že jsou v db?)

Potom je tady soubor session status což bych řekl že bude nějaký potvrzení / status zápisu do db.

Struktura tabulky `SESSION_STATUS`
--

CREATE TEMPORARY TABLE `SESSION_STATUS` (
`VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
`VARIABLE_VALUE` varchar(1024) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

--
-- Vypisuji data pro tabulku `SESSION_STATUS`
--

INSERT INTO `SESSION_STATUS` (`VARIABLE_NAME`, `VARIABLE_VALUE`) VALUES
('ABORTED_CLIENTS', '6896'),
('ABORTED_CONNECTS', '22542582'),
('BINLOG_CACHE_DISK_USE', '0'),
('BINLOG_CACHE_USE', '0'),
('BYTES_RECEIVED', '555'),
('BYTES_SENT', '4318'),
('COM_ADMIN_COMMANDS', '0'),
('COM_ASSIGN_TO_KEYCACHE', '0'),
('COM_ALTER_DB', '0'),
('COM_ALTER_DB_UPGRADE', '0'),
('COM_ALTER_EVENT', '0'),
('COM_ALTER_FUNCTION', '0'),
('COM_ALTER_PROCEDURE', '0'),
('COM_ALTER_SERVER', '0'),
('COM_ALTER_TABLE', '0'),
('COM_ALTER_TABLESPACE', '0'),
('COM_ANALYZE', '0'),
('COM_BACKUP_TABLE', '0'),
('COM_BEGIN', '0'),
('COM_BINLOG', '0'),
('COM_CALL_PROCEDURE', '0'),
('COM_CHANGE_DB', '0'),
('COM_CHANGE_MASTER', '0'),
('COM_CHECK', '0'),
('COM_CHECKSUM', '0'),
('COM_COMMIT', '0'),
('COM_CREATE_DB', '0'),
('COM_CREATE_EVENT', '0'),
('COM_CREATE_FUNCTION', '0'),
('COM_CREATE_INDEX', '0'),
('COM_CREATE_PROCEDURE', '0'),
('COM_CREATE_SERVER', '0'),
('COM_CREATE_TABLE', '0'),
('COM_CREATE_TRIGGER', '0'),
('COM_CREATE_UDF', '0'),
('COM_CREATE_USER', '0'),
('COM_CREATE_VIEW', '0'),
('COM_DEALLOC_SQL', '0'),
('COM_DELETE', '0'),
('COM_DELETE_MULTI', '0'),
('COM_DO', '0'),
('COM_DROP_DB', '0'),
('COM_DROP_EVENT', '0'),
('COM_DROP_FUNCTION', '0'),
('COM_DROP_INDEX', '0'),
('COM_DROP_PROCEDURE', '0'),
('COM_DROP_SERVER', '0'),
('COM_DROP_TABLE', '0'),
('COM_DROP_TRIGGER', '0'),
('COM_DROP_USER', '0'),
('COM_DROP_VIEW', '0'),
('COM_EMPTY_QUERY', '0'),
('COM_EXECUTE_SQL', '0'),
('COM_FLUSH', '0'),
('COM_GRANT', '0'),
('COM_HA_CLOSE', '0'),
('COM_HA_OPEN', '0'),
('COM_HA_READ', '0'),
('COM_HELP', '0'),
('COM_INSERT', '0'),
('COM_INSERT_SELECT', '0'),
('COM_INSTALL_PLUGIN', '0'),
('COM_KILL', '0'),
('COM_LOAD', '0'),
('COM_LOAD_MASTER_DATA', '0'),
('COM_LOAD_MASTER_TABLE', '0'),
('COM_LOCK_TABLES', '0'),
('COM_OPTIMIZE', '0'),
('COM_PRELOAD_KEYS', '0'),
('COM_PREPARE_SQL', '0'),
('COM_PURGE', '0'),
('COM_PURGE_BEFORE_DATE', '0'),
('COM_RELEASE_SAVEPOINT', '0'),
('COM_RENAME_TABLE', '0'),
('COM_RENAME_USER', '0'),
('COM_REPAIR', '0'),
('COM_REPLACE', '0'),
('COM_REPLACE_SELECT', '0'),
('COM_RESET', '0'),
('COM_RESTORE_TABLE', '0'),
('COM_REVOKE', '0'),
('COM_REVOKE_ALL', '0'),
('COM_ROLLBACK', '0'),
('COM_ROLLBACK_TO_SAVEPOINT', '0'),
('COM_SAVEPOINT', '0'),
('COM_SELECT', '2'),
('COM_SET_OPTION', '5'),
('COM_SHOW_AUTHORS', '0'),
('COM_SHOW_BINLOG_EVENTS', '0'),
('COM_SHOW_BINLOGS', '0'),
('COM_SHOW_CHARSETS', '0'),
('COM_SHOW_CLIENT_STATISTICS', '0'),
('COM_SHOW_COLLATIONS', '0'),
('COM_SHOW_COLUMN_TYPES', '0'),
('COM_SHOW_CONTRIBUTORS', '0'),
('COM_SHOW_CREATE_DB', '0'),
('COM_SHOW_CREATE_EVENT', '0'),
('COM_SHOW_CREATE_FUNC', '0'),
('COM_SHOW_CREATE_PROC', '0'),
('COM_SHOW_CREATE_TABLE', '1'),
('COM_SHOW_CREATE_TRIGGER', '0'),
('COM_SHOW_DATABASES', '0'),
('COM_SHOW_ENGINE_LOGS', '0'),
('COM_SHOW_ENGINE_MUTEX', '0'),
('COM_SHOW_ENGINE_STATUS', '0'),
('COM_SHOW_EVENTS', '0'),
('COM_SHOW_ERRORS', '0'),
('COM_SHOW_FIELDS', '0'),
('COM_SHOW_FUNCTION_STATUS', '0'),
('COM_SHOW_GRANTS', '0'),
('COM_SHOW_INDEX_STATISTICS', '0'),
('COM_SHOW_KEYS', '0'),
('COM_SHOW_MASTER_STATUS', '0'),
('COM_SHOW_NEW_MASTER', '0'),
('COM_SHOW_OPEN_TABLES', '0'),
('COM_SHOW_PATCHES', '0'),
('COM_SHOW_PLUGINS', '1'),
('COM_SHOW_PRIVILEGES', '0'),
('COM_SHOW_PROCEDURE_STATUS', '0'),
('COM_SHOW_PROCESSLIST', '0'),
('COM_SHOW_PROFILE', '0'),
('COM_SHOW_PROFILES', '0'),
('COM_SHOW_SLAVE_HOSTS', '0'),
('COM_SHOW_SLAVE_STATUS', '0'),
('COM_SHOW_SLAVE_STATUS_NOLOCK', '0'),
('COM_SHOW_STATUS', '0'),
('COM_SHOW_STORAGE_ENGINES', '0'),
('COM_SHOW_TABLE_STATISTICS', '0'),
('COM_SHOW_TABLE_STATUS', '2'),
('COM_SHOW_TABLES', '0'),
('COM_SHOW_THREAD_STATISTICS', '0'),
('COM_SHOW_TEMPORARY_TABLES', '0'),
('COM_SHOW_TRIGGERS', '0'),
('COM_SHOW_USER_STATISTICS', '0'),
('COM_SHOW_VARIABLES', '0'),
('COM_SHOW_WARNINGS', '0'),
('COM_SLAVE_START', '0'),
('COM_SLAVE_STOP', '0'),
('COM_STMT_CLOSE', '0'),
('COM_STMT_EXECUTE', '0'),
('COM_STMT_FETCH', '0'),
('COM_STMT_PREPARE', '0'),
('COM_STMT_REPREPARE', '0'),
('COM_STMT_RESET', '0'),
('COM_STMT_SEND_LONG_DATA', '0'),
('COM_TRUNCATE', '0'),
('COM_UNINSTALL_PLUGIN', '0'),
('COM_UNLOCK_TABLES', '0'),
('COM_UPDATE', '0'),
('COM_UPDATE_MULTI', '0'),
('COM_XA_COMMIT', '0'),
('COM_XA_END', '0'),
('COM_XA_PREPARE', '0'),
('COM_XA_RECOVER', '0'),
('COM_XA_ROLLBACK', '0'),
('COM_XA_START', '0'),
('COMPRESSION', 'OFF'),
('CONNECTIONS', '45635841'),
('CREATED_TMP_DISK_TABLES', '1'),
('CREATED_TMP_FILES', '4779'),
('CREATED_TMP_TABLES', '7'),
('DELAYED_ERRORS', '0'),
('DELAYED_INSERT_THREADS', '0'),
('DELAYED_WRITES', '6645'),
('FLASHCACHE_ENABLED', 'OFF'),
('FLUSH_COMMANDS', '1'),
('HANDLER_COMMIT', '0'),
('HANDLER_DELETE', '0'),
('HANDLER_DISCOVER', '0'),
('HANDLER_PREPARE', '0'),
('HANDLER_READ_FIRST', '0'),
('HANDLER_READ_KEY', '0'),
('HANDLER_READ_NEXT', '0'),
('HANDLER_READ_PREV', '0'),
('HANDLER_READ_RND', '0'),
('HANDLER_READ_RND_NEXT', '33'),
('HANDLER_ROLLBACK', '0'),
('HANDLER_SAVEPOINT', '0'),
('HANDLER_SAVEPOINT_ROLLBACK', '0'),
('HANDLER_UPDATE', '0'),
('HANDLER_WRITE', '210'),
('KEY_BLOCKS_NOT_FLUSHED', '0'),
('KEY_BLOCKS_UNUSED', '4055'),
('KEY_BLOCKS_USED', '166647'),
('KEY_READ_REQUESTS', '3879283959'),
('KEY_READS', '37483376'),
('KEY_WRITE_REQUESTS', '301229874'),
('KEY_WRITES', '108609300'),
('LAST_QUERY_COST', '10.499000'),
('MAX_USED_CONNECTIONS', '86'),
('NOT_FLUSHED_DELAYED_ROWS', '0'),
('OPEN_FILES', '7797'),
('OPEN_STREAMS', '0'),
('OPEN_TABLE_DEFINITIONS', '3831'),
('OPEN_TABLES', '4000'),
('OPENED_FILES', '407274872'),
('OPENED_TABLE_DEFINITIONS', '0'),
('OPENED_TABLES', '0'),
('PREPARED_STMT_COUNT', '0'),
('QCACHE_FREE_BLOCKS', '22933'),
('QCACHE_FREE_MEMORY', '68772856'),
('QCACHE_HITS', '394154034'),
('QCACHE_INSERTS', '103285455'),
('QCACHE_LOWMEM_PRUNES', '30173474'),
('QCACHE_NOT_CACHED', '11315426'),
('QCACHE_QUERIES_IN_CACHE', '53746'),
('QCACHE_TOTAL_BLOCKS', '149670'),
('QUERIES', '1004974987'),
('QUESTIONS', '11'),
('RPL_STATUS', 'NULL'),
('SELECT_FULL_JOIN', '0'),
('SELECT_FULL_RANGE_JOIN', '0'),
('SELECT_RANGE', '0'),
('SELECT_RANGE_CHECK', '0'),
('SELECT_SCAN', '4'),
('SLAVE_OPEN_TEMP_TABLES', '0'),
('SLAVE_RETRIED_TRANSACTIONS', '0'),
('SLAVE_RUNNING', 'OFF'),
('SLOW_LAUNCH_THREADS', '0'),
('SLOW_QUERIES', '0'),
('SORT_MERGE_PASSES', '0'),
('SORT_RANGE', '0'),
('SORT_ROWS', '0'),
('SORT_SCAN', '0'),
('SSL_ACCEPT_RENEGOTIATES', '0'),
('SSL_ACCEPTS', '0'),
('SSL_CALLBACK_CACHE_HITS', '0'),
('SSL_CIPHER', ''),
('SSL_CIPHER_LIST', ''),
('SSL_CLIENT_CONNECTS', '0'),
('SSL_CONNECT_RENEGOTIATES', '0'),
('SSL_CTX_VERIFY_DEPTH', '0'),
('SSL_CTX_VERIFY_MODE', '0'),
('SSL_DEFAULT_TIMEOUT', '0'),
('SSL_FINISHED_ACCEPTS', '0'),
('SSL_FINISHED_CONNECTS', '0'),
('SSL_SESSION_CACHE_HITS', '0'),
('SSL_SESSION_CACHE_MISSES', '0'),
('SSL_SESSION_CACHE_MODE', 'NONE'),
('SSL_SESSION_CACHE_OVERFLOWS', '0'),
('SSL_SESSION_CACHE_SIZE', '0'),
('SSL_SESSION_CACHE_TIMEOUTS', '0'),
('SSL_SESSIONS_REUSED', '0'),
('SSL_USED_SESSION_CACHE_ENTRIES', '0'),
('SSL_VERIFY_DEPTH', '0'),
('SSL_VERIFY_MODE', '0'),
('SSL_VERSION', ''),
('TABLE_LOCKS_IMMEDIATE', '248129297'),
('TABLE_LOCKS_WAITED', '1390572'),
('TC_LOG_MAX_PAGES_USED', '0'),
('TC_LOG_PAGE_SIZE', '0'),
('TC_LOG_PAGE_WAITS', '0'),
('THREADS_CACHED', '9'),
('THREADS_CONNECTED', '5'),
('THREADS_CREATED', '96074'),
('THREADS_RUNNING', '1'),
('UPTIME', '5411396'),
('UPTIME_SINCE_FLUSH_STATUS', '5411396');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Ale co a kde měnit vůbec netuším :/

Teď se s tím tak nějak zkouším poprat. Zrovna edituju soubor z databáze jménem Session_variables.sql

Možná tam by se dalo něco změnit


-- phpMyAdmin SQL Dump
-- version 3.4.9
-- http://www.phpmyadmin.net
--
-- Počítač: sql.endora.cz:3312
-- Vygenerováno: Stř 29. srp 2012, 20:19
-- Verze MySQL: 5.1.61
-- Verze PHP: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Databáze: `information_schema`
--

-- --------------------------------------------------------

--
-- Struktura tabulky `SESSION_VARIABLES`
--

CREATE TEMPORARY TABLE `SESSION_VARIABLES` (
`VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
`VARIABLE_VALUE` varchar(1024) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

--
-- Vypisuji data pro tabulku `SESSION_VARIABLES`
--

INSERT INTO `SESSION_VARIABLES` (`VARIABLE_NAME`, `VARIABLE_VALUE`) VALUES
('MAX_PREPARED_STMT_COUNT', '16382'),
('CHARACTER_SETS_DIR', '/usr/share/mysql/charsets/'),
('HAVE_CRYPT', 'YES'),
('CONNECT_TIMEOUT', '30'),
('MYISAM_REPAIR_THREADS', '1'),
('AUTOMATIC_SP_PRIVILEGES', 'ON'),
('MAX_BINLOG_SIZE', '1073741824'),
('BINLOG_CACHE_SIZE', '32768'),
('LOG_BIN_TRUST_FUNCTION_CREATORS', 'OFF'),
('BACK_LOG', '50'),
('FT_MIN_WORD_LEN', '4'),
('MYISAM_USE_MMAP', 'OFF'),
('HAVE_OPENSSL', 'DISABLED'),
('FT_BOOLEAN_SYNTAX', '+ -><()~*:""&|'),
('LOG_BIN_TRUST_ROUTINE_CREATORS', 'OFF'),
('CHARACTER_SET_CONNECTION', 'utf8'),
('OPEN_FILES_LIMIT', '24000'),
('CHARACTER_SET_RESULTS', 'utf8'),
('IDENTITY', '0'),
('FAST_INDEX_CREATION', 'ON'),
('UPDATABLE_VIEWS_WITH_LIMIT', 'YES'),
('RPL_RECOVERY_RANK', '0'),
('SLOW_LAUNCH_TIME', '2'),
('NET_BUFFER_LENGTH', '16384'),
('SKIP_NAME_RESOLVE', 'OFF'),
('COMPLETION_TYPE', '0'),
('RELAY_LOG_INDEX', ''),
('READ_BUFFER_SIZE', '2097152'),
('SQL_QUOTE_SHOW_CREATE', 'ON'),
('EVENT_SCHEDULER', 'DISABLED'),
('SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP', 'OFF'),
('COLLATION_DATABASE', 'utf8_general_ci'),
('WAIT_TIMEOUT', '9000'),
('FT_MAX_WORD_LEN', '84'),
('LOCKED_IN_MEMORY', 'OFF'),
('CONCURRENT_INSERT', '1'),
('SSL_CAPATH', ''),
('KEY_CACHE_BLOCK_SIZE', '1024'),
('LOG_SLOW_SP_STATEMENTS', 'ON'),
('INIT_SLAVE', ''),
('SSL_KEY', ''),
('FLUSH', 'OFF'),
('QUERY_RESPONSE_TIME_RANGE_BASE', '10'),
('DELAYED_INSERT_LIMIT', '100'),
('SLAVE_SKIP_ERRORS', 'OFF'),
('FT_QUERY_EXPANSION_LIMIT', '20'),
('INSERT_ID', '0'),
('SQL_LOW_PRIORITY_UPDATES', 'OFF'),
('RELAY_LOG_PURGE', 'ON'),
('MAX_SEEKS_FOR_KEY', '18446744073709551615'),
('SKIP_SHOW_DATABASE', 'OFF'),
('FT_STOPWORD_FILE', '(built-in)'),
('GROUP_CONCAT_MAX_LEN', '1024'),
('JOIN_BUFFER_SIZE', '62914560'),
('RANGE_ALLOC_BLOCK_SIZE', '4096'),
('MAX_ERROR_COUNT', '64'),
('CHARACTER_SET_DATABASE', 'utf8'),
('QUERY_PREALLOC_SIZE', '8192'),
('LOG_SLOW_QUERIES', 'ON'),
('DELAYED_QUEUE_SIZE', '1000'),
('TRANSACTION_PREALLOC_SIZE', '4096'),
('INTERACTIVE_TIMEOUT', '28800'),
('VERSION_COMPILE_OS', 'unknown-linux-gnu'),
('DELAYED_INSERT_TIMEOUT', '300'),
('SQL_NOTES', 'ON'),
('LARGE_PAGES', 'OFF'),
('LOW_PRIORITY_UPDATES', 'OFF'),
('AUTO_INCREMENT_OFFSET', '1'),
('REPORT_PASSWORD', ''),
('MAX_CONNECT_ERRORS', '100'),
('MAX_INSERT_DELAYED_THREADS', '20'),
('VERSION_COMMENT', 'Percona Server (GPL), 13.2, Revision 430'),
('LOG_SLOW_SLAVE_STATEMENTS', 'OFF'),
('MAX_CONNECTIONS', '250'),
('TRANSACTION_ALLOC_BLOCK_SIZE', '8192'),
('SYSTEM_TIME_ZONE', 'CEST'),
('THREAD_CACHE_SIZE', '12'),
('LANGUAGE', '/usr/share/mysql/english/'),
('SYNC_FRM', 'ON'),
('PSEUDO_THREAD_ID', '46301198'),
('MAX_LONG_DATA_SIZE', '1048576'),
('BULK_INSERT_BUFFER_SIZE', '8388608'),
('LOG_SLOW_TIMESTAMP_EVERY', 'OFF'),
('LOWER_CASE_FILE_SYSTEM', 'OFF'),
('LOG_OUTPUT', 'FILE'),
('PRELOAD_BUFFER_SIZE', '32768'),
('LOG_WARNINGS', '1'),
('LOG_BIN', 'OFF'),
('PROTOCOL_VERSION', '10'),
('COLLATION_SERVER', 'utf8_general_ci'),
('HAVE_RESPONSE_TIME_DISTRIBUTION', 'YES'),
('CHARACTER_SET_SERVER', 'utf8'),
('TIME_ZONE', '+00:00'),
('MAX_LENGTH_FOR_SORT_DATA', '1024'),
('RAND_SEED2', ''),
('MAX_HEAP_TABLE_SIZE', '33554432'),
('LC_TIME_NAMES', 'en_US'),
('DELAY_KEY_WRITE', 'ON'),
('MYISAM_DATA_POINTER_SIZE', '6'),
('KEY_CACHE_AGE_THRESHOLD', '300'),
('HAVE_COMPRESS', 'YES'),
('NET_RETRY_COUNT', '10'),
('SQL_AUTO_IS_NULL', 'ON'),
('LOG_QUERIES_NOT_USING_INDEXES', 'OFF'),
('SLAVE_TRANSACTION_RETRIES', '10'),
('MAX_SORT_LENGTH', '1024'),
('LOG_ERROR', '/var/log/mysqld7.log'),
('LARGE_PAGE_SIZE', '0'),
('GENERAL_LOG', 'OFF'),
('LAST_INSERT_ID', '0'),
('TABLE_TYPE', 'MyISAM'),
('MAX_USER_CONNECTIONS', '35'),
('QUERY_CACHE_MIN_RES_UNIT', '4096'),
('MYISAM_MAX_SORT_FILE_SIZE', '9223372036853727232'),
('SORT_BUFFER_SIZE', '2097152'),
('INIT_FILE', ''),
('MAX_JOIN_SIZE', '18446744073709551615'),
('USERSTAT_RUNNING', 'ON'),
('PROFILING_HISTORY_SIZE', '15'),
('PID_FILE', '/var/run/mysqld/mysqld7.pid'),
('RELAY_LOG', ''),
('CHARACTER_SET_FILESYSTEM', 'binary'),
('READ_RND_BUFFER_SIZE', '8388608'),
('SQL_LOG_UPDATE', 'ON'),
('SECURE_AUTH', 'OFF'),
('CHARACTER_SET_CLIENT', 'utf8'),
('QUERY_CACHE_STRIP_COMMENTS', 'OFF'),
('BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES', 'OFF'),
('SQL_SELECT_LIMIT', '18446744073709551615'),
('LONG_QUERY_TIME', '5.000000'),
('DATE_FORMAT', '%Y-%m-%d'),
('NEW', 'OFF'),
('READ_ONLY', 'OFF'),
('OLD_PASSWORDS', 'ON'),
('RAND_SEED1', ''),
('NET_WRITE_TIMEOUT', '60'),
('LOG_SLOW_ADMIN_STATEMENTS', 'OFF'),
('BASEDIR', '/usr/'),
('HAVE_CSV', 'YES'),
('MAX_BINLOG_CACHE_SIZE', '18446744073709547520'),
('PROFILING', 'OFF'),
('QUERY_CACHE_LIMIT', '2097152'),
('FLUSH_TIME', '0'),
('SQL_WARNINGS', 'OFF'),
('KEY_CACHE_DIVISION_LIMIT', '100'),
('QUERY_CACHE_SIZE', '251658240'),
('GENERAL_LOG_FILE', '/dev/shm/sql7.log'),
('KEEP_FILES_ON_CREATE', 'OFF'),
('THREAD_STACK', '262144'),
('DEFAULT_WEEK_FORMAT', '0'),
('LOG_SLOW_VERBOSITY', 'microtime'),
('MYISAM_SORT_BUFFER_SIZE', '8388608'),
('TMPDIR', '/tmpSQL'),
('SSL_CERT', ''),
('EXPIRE_LOGS_DAYS', '0'),
('SQL_BIG_TABLES', 'OFF'),
('HAVE_PARTITIONING', 'YES'),
('QUERY_ALLOC_BLOCK_SIZE', '8192'),
('FOREIGN_KEY_CHECKS', 'ON'),
('QUERY_CACHE_TYPE', 'ON'),
('RELAY_LOG_INFO_FILE', 'relay-log.info'),
('THREAD_STATISTICS', 'OFF'),
('SLAVE_LOAD_TMPDIR', '/tmpSQL'),
('THREAD_HANDLING', 'one-thread-per-connection'),
('IGNORE_BUILTIN_INNODB', 'OFF'),
('OPTIMIZER_SWITCH', 'index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on'),
('MAX_TMP_TABLES', '32'),
('MYISAM_RECOVER_OPTIONS', 'OFF'),
('UNIQUE_CHECKS', 'ON'),
('MYISAM_STATS_METHOD', 'nulls_unequal'),
('ENABLE_QUERY_RESPONSE_TIME_STATS', 'OFF'),
('OPTIMIZER_PRUNE_LEVEL', '1'),
('SOCKET', '/home/mysql7/mysql.sock'),
('QUERY_CACHE_WLOCK_INVALIDATE', 'OFF'),
('LOG_SLOW_FILTER', ''),
('MAX_WRITE_LOCK_COUNT', '18446744073709551615'),
('COLLATION_CONNECTION', 'utf8_general_ci'),
('TIMED_MUTEXES', 'OFF'),
('HAVE_QUERY_CACHE', 'YES'),
('VERSION_COMPILE_MACHINE', 'x86_64'),
('MULTI_RANGE_COUNT', '256'),
('SLAVE_COMPRESSED_PROTOCOL', 'OFF'),
('SECURE_FILE_PRIV', ''),
('SERVER_ID', '0'),
('DIV_PRECISION_INCREMENT', '4'),
('SKIP_NETWORKING', 'OFF'),
('DATADIR', '/home/mysql7/'),
('CHARACTER_SET_SYSTEM', 'utf8'),
('PROFILING_SERVER', 'OFF'),
('INIT_CONNECT', ''),
('TABLE_DEFINITION_CACHE', '256'),
('SQL_LOG_OFF', 'OFF'),
('SQL_SLAVE_SKIP_COUNTER', ''),
('OPTIMIZER_SEARCH_DEPTH', '62'),
('TIME_FORMAT', '%H:%i:%s'),
('AUTOCOMMIT', 'ON'),
('MAX_ALLOWED_PACKET', '1048576'),
('PROFILING_USE_GETRUSAGE', 'OFF'),
('STORAGE_ENGINE', 'MyISAM'),
('SQL_SAFE_UPDATES', 'OFF'),
('ERROR_COUNT', '0'),
('TMP_TABLE_SIZE', '50331648'),
('HAVE_DYNAMIC_LOADING', 'YES'),
('TABLE_LOCK_WAIT_TIMEOUT', '50'),
('SYNC_BINLOG', '0'),
('SSL_CIPHER', ''),
('RELAY_LOG_SPACE_LIMIT', '0'),
('HOSTNAME', 'kasparek.miton.cz'),
('LOG_SLAVE_UPDATES', 'OFF'),
('BIG_TABLES', 'OFF'),
('OLD', 'OFF'),
('MAX_SP_RECURSION_DEPTH', '0'),
('HAVE_SSL', 'DISABLED'),
('SQL_BIG_SELECTS', 'ON'),
('SQL_MODE', ''),
('ENGINE_CONDITION_PUSHDOWN', 'ON'),
('KEY_BUFFER_SIZE', '209715200'),
('LARGE_FILES_SUPPORT', 'ON'),
('HAVE_NDBCLUSTER', 'NO'),
('OPTIMIZER_FIX', 'ON'),
('SQL_MAX_JOIN_SIZE', '18446744073709551615'),
('SLAVE_EXEC_MODE', 'STRICT'),
('SLOW_QUERY_LOG', 'ON'),
('TABLE_OPEN_CACHE', '4000'),
('SLOW_QUERY_LOG_FILE', '/var/log/mysqld/slow7.log'),
('HAVE_COMMUNITY_FEATURES', 'YES'),
('LOG_SLOW_RATE_LIMIT', '1'),
('REPORT_PORT', '3306'),
('SKIP_EXTERNAL_LOCKING', 'ON'),
('SQL_BUFFER_RESULT', 'OFF'),
('SLAVE_NET_TIMEOUT', '3600'),
('SSL_CA', ''),
('PLUGIN_DIR', '/usr/lib64/mysql/plugin'),
('AUTO_INCREMENT_INCREMENT', '1'),
('LOCAL_INFILE', 'OFF'),
('NET_READ_TIMEOUT', '30'),
('HAVE_RTREE_KEYS', 'YES'),
('REPORT_HOST', ''),
('BINLOG_FORMAT', 'STATEMENT'),
('SQL_LOG_BIN', 'ON'),
('OLD_ALTER_TABLE', 'OFF'),
('VERSION', '5.1.61-rel13.2-log'),
('MYISAM_MMAP_SIZE', '18446744073709551615'),
('HAVE_SYMLINK', 'YES'),
('EXPAND_FAST_INDEX_CREATION', 'OFF'),
('USE_GLOBAL_LONG_QUERY_TIME', 'OFF'),
('TIMESTAMP', '1346264376'),
('LOWER_CASE_TABLE_NAMES', '0'),
('MAX_DELAYED_THREADS', '20'),
('SUPPRESS_LOG_WARNING_1592', 'OFF'),
('DATETIME_FORMAT', '%Y-%m-%d %H:%i:%s'),
('HAVE_INNODB', 'DISABLED'),
('WARNING_COUNT', '0'),
('MIN_EXAMINED_ROW_LIMIT', '0'),
('MAX_RELAY_LOG_SIZE', '0'),
('USE_GLOBAL_LOG_SLOW_CONTROL', 'none'),
('LICENSE', 'GPL'),
('REPORT_USER', ''),
('HAVE_GEOMETRY', 'YES'),
('LOG', 'OFF'),
('PORT', '3312'),
('TX_ISOLATION', 'REPEATABLE-READ');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;