Autor Zpráva
p4n7h3r
Profil *
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.
nevimco
Profil *
Když nevíme jak ta funkce vypadá, nemůžeme říct jak jí editovat ...
p4n7h3r
Profil
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 :/
p4n7h3r
Profil
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 */;
Alphard
Profil
p4n7h3r:
Zdá se mi, že uvedené dumpy nijak nepomohou k řešení problému popsaného v [#1], nezálohujte prosím na diskusi celý váš systém.
muflix
Profil *
no sice nevím o jaký se jedná script a co to má konkrétně dělat, ale podle tvého popisu jsem pochopil, že na klik na stránce se má něco provést v databázi. K tomu bych využil jQuery knihovy a přikládám ukázkový kód

nejaka stranka, kterou vidi uzivatel
<script>
    $("misto").click(function () {
    
      $.post(
          "http://example.com/soubor.php",   
          { promenna1 : true },        
          function(data){                            
              alert('dotaz do db se provedl');
          }
      );

    });
</script>

soubor.php
<?php 
if(isset($_POST['promenna1'] {
    
    mysql_connect(...);
    mysql_query(...);
    
}
?>

pokud uzivatel klikne do <div id='misto'>klikni sem</div> tak se provede Ajax, tj php script ve kterém lze přistupovat k db.

Vaše odpověď


Prosím používejte diakritiku a interpunkci.

Ochrana proti spamu. Napište prosím číslo dvě-sta čtyřicet-sedm: