Štatistiky OCSK - marec-december 2013

Warning (2): Trying to access array offset on null [APP/controllers/pages_controller.php, line 58]

            )));
        }
        $output = call_user_func_array(array(&$controller, $params['action']), $params['pass']);

PagesController::show() - APP/controllers/pages_controller.php, line 58
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 86

Štatistiky OCSK - marec-december 2013

alcom1234 • 11.01.2014 • Čítané: 3567x

Rok 2013 sa nám pomaly, ale isto končí, no a tak by sa patrilo zhodnotiť dianie na servri Opelclubu.
Dňa 13.03.2013 došlo k zmene, na ktorú sa už nejaký ten čas čakalo.
Tou zmenou bola nová podoba samotného fóra, na ktorom sa odohráva drvivá väčšina udalostí z nášho klubu fanúšikov značky OPEL.

Pre užívateľov to znamenalo viac možností pri zverejňovaní svojich príspevkov. Taktiež sa inovoval systém, na ktorom fórum funguje a to na (vtedy) najaktuálnejšiu verziu PHPBB3. Pre administrátorov a moderátorov sa sprístupnili omnoho pokročilejšie funkcie uľahčujúce ich prácu. Spolu s novým fórom a zmenou webhostingu na Websupport.sk, bolo vynovené aj samotné logo Opelclubu.

Za tento čas sa nazbierali nejaké tie údaje, pomocou Google analytics, takže na týchto linkoch je možné vidieť, akým spôsobom sa menila návštevnosť stránok, ale aj ďalšie štatistické doplnky.

Snahou Opelclubu je v najbližšej dobe tieto čísla návštevnosti a tiež počet registrovaných členov klubu navýšiť a to krokmi, ktoré sú zatiaľ v pokročilejšom štádiu príprav. Veríme, že zmeny, ktoré nastanú, budú značku Opelclub.sk dostávať do pozornosti nových ľudí a potencionálnych reklamných partnerov.

Návštevnosť - pravidelní vs. noví užívatelia

Prehliadače a operačné systémy užívateľov

Zariadenia, z ktorých sa na stránku pripájate

Koľko stránok užívateľ otvoril

Ako často si užívatelia prezerajú stránky

Odkiaľ sa ľudia prihlasujú

Z akej siete sa ľudia prihlasujú

Prehľad

Návštevnosť jednotlivých podstránok

Rýchlosť načítavania stránok

Rýchlosť načítavania stránok-časť 2.

Doba zotrvania na stránkach

Warning (2): Trying to access array offset on null [APP/views/themed/2015/pages/show.ctp, line 124]Code
        if (Configure::read() > 0) {
            include ($___viewFn);
include - APP/views/themed/2015/pages/show.ctp, line 124
View::_render() - CORE/cake/libs/view/view.php, line 736
View::render() - CORE/cake/libs/view/view.php, line 431
Controller::render() - CORE/cake/libs/controller/controller.php, line 908
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 86

Warning: Trying to access array offset on null in /data/5/2/52a1d110-84e0-4abc-bf28-7b380ca35791/opelclub.sk/web/app/views/themed/2015/pages/show.ctp on line 124

(default) 34 queries took 46 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `pages`	16	16	1
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_slovak_ci';	1	1	1
3	SHOW FULL COLUMNS FROM `users`	12	12	2
4	SHOW FULL COLUMNS FROM `partners`	16	16	1
5	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	1
6	SHOW FULL COLUMNS FROM `memberinfos`	41	41	1
7	SHOW FULL COLUMNS FROM `ranks`	2	2	1
8	SHOW FULL COLUMNS FROM `paymentmethods`	4	4	2
9	SHOW FULL COLUMNS FROM `membercars`	17	17	1
10	SHOW FULL COLUMNS FROM `fueltypes`	4	4	1
11	SHOW FULL COLUMNS FROM `transmissions`	4	4	3
12	SHOW FULL COLUMNS FROM `axles`	4	4	2
13	SHOW FULL COLUMNS FROM `vipcards`	8	8	3
14	SHOW FULL COLUMNS FROM `categories`	10	10	1
15	SHOW FULL COLUMNS FROM `attachments`	7	7	1
16	SHOW FULL COLUMNS FROM `attachments_pages`	3	3	1
17	SHOW FULL COLUMNS FROM `menuitems`	13	13	1
18	SHOW FULL COLUMNS FROM `menus`	5	5	1
19	SHOW FULL COLUMNS FROM `settings`	5	5	7
20	SELECT `Setting`.`title`, `Setting`.`content` FROM `settings` AS `Setting` WHERE 1 = 1	1	1	1
21	SELECT `Page`.`id`, `Page`.`content`, `Page`.`highlight_content`, `Page`.`highlight_url`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) WHERE `Page`.`is_highlight` = 1 AND `Page`.`status` != 3 ORDER BY `Page`.`modified` desc	8	8	2
22	SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`saved_name`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`created`, `Attachment`.`modified`, `AttachmentsPage`.`id`, `AttachmentsPage`.`page_id`, `AttachmentsPage`.`attachment_id` FROM `attachments` AS `Attachment` JOIN `attachments_pages` AS `AttachmentsPage` ON (`AttachmentsPage`.`page_id` IN (274, 257, 261, 258, 256, 198, 195, 197) AND `AttachmentsPage`.`attachment_id` = `Attachment`.`id`)	0	0	1
23	SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`title`, `Menuitem`.`url`, `Menuitem`.`parent_id`, `Menuitem`.`lft`, `Menuitem`.`rght`, `Menuitem`.`status`, `Menuitem`.`emph`, `Menuitem`.`is_category_list`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified`, `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `menuitems` AS `Menuitem` LEFT JOIN `menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) WHERE `Menuitem`.`menu_id` = 2 AND `Menuitem`.`status` != 3 ORDER BY `Menuitem`.`sort` asc	8	8	1
24	SELECT `Category`.`id`, `Category`.`title`, `Category`.`status`, `Category`.`parent_id`, `Category`.`show_in_menu`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Category`.`id_old` FROM `categories` AS `Category` WHERE `Category`.`status` != 3 AND `Category`.`show_in_menu` = 1	5	5	1
25	SHOW FULL COLUMNS FROM `adpositions`	9	9	1
26	SHOW FULL COLUMNS FROM `advertisements`	13	13	1
27	SELECT `Adposition`.`id`, `Adposition`.`title`, `Adposition`.`comment`, `Adposition`.`position_width`, `Adposition`.`position_height`, `Adposition`.`ad_width`, `Adposition`.`ad_height`, `Adposition`.`visible_ads_count`, `Adposition`.`status` FROM `adpositions` AS `Adposition` WHERE `Adposition`.`status` = 1	2	2	0
28	SELECT `Advertisement`.`id`, `Advertisement`.`adposition_id`, `Advertisement`.`partner_id`, `Advertisement`.`valid_from`, `Advertisement`.`valid_to`, `Advertisement`.`saved_filename`, `Advertisement`.`alt`, `Advertisement`.`url`, `Advertisement`.`status`, `Advertisement`.`display_count`, `Advertisement`.`click_count`, `Advertisement`.`created`, `Advertisement`.`modified` FROM `advertisements` AS `Advertisement` WHERE `Advertisement`.`valid_from` <= '2024-10-04 12:58:52' AND `Advertisement`.`valid_to` >= '2024-10-04 12:58:52' AND `Advertisement`.`status` = 1 AND `Advertisement`.`adposition_id` IN (4, 5) ORDER BY RAND() ASC	0	0	1
29	UPDATE `advertisements` AS `Advertisement` LEFT JOIN `adpositions` AS `Adposition` ON (`Advertisement`.`adposition_id` = `Adposition`.`id`) SET `Advertisement`.`display_count` = Advertisement.display_count + 1 WHERE `Advertisement`.`id` IS NULL	0		0
30	SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`page_type`, `Page`.`layout_id`, `Page`.`title`, `Page`.`content`, `Page`.`status`, `Page`.`is_highlight`, `Page`.`highlight_content`, `Page`.`highlight_url`, `Page`.`user_id`, `Page`.`vip_only`, `Page`.`created`, `Page`.`modified`, `Page`.`view_count`, `Page`.`old_author_id`, `User`.`id`, `User`.`user`, `User`.`password`, `User`.`pwd_old`, `User`.`status`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`admin`, `User`.`partner_id`, `User`.`created`, `User`.`modified`, `Category`.`id`, `Category`.`title`, `Category`.`status`, `Category`.`parent_id`, `Category`.`show_in_menu`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Category`.`id_old` FROM `pages` AS `Page` LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) WHERE `Page`.`id` = 196 AND `Page`.`status` = 1 LIMIT 1	1	1	1
31	SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`saved_name`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`created`, `Attachment`.`modified`, `AttachmentsPage`.`id`, `AttachmentsPage`.`page_id`, `AttachmentsPage`.`attachment_id` FROM `attachments` AS `Attachment` JOIN `attachments_pages` AS `AttachmentsPage` ON (`AttachmentsPage`.`page_id` = 196 AND `AttachmentsPage`.`attachment_id` = `Attachment`.`id`)	0	0	1
32	UPDATE `pages` AS `Page` LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) SET `Page`.`view_count` = Page.view_count + 1 WHERE `Page`.`id` = 196	1		1
33	SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE `Category`.`id` = 25 LIMIT 1	1	1	1
34	SELECT `Category`.`id`, `Category`.`title` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 49 AND `Category`.`rght` >= 50 ORDER BY `Category`.`lft` asc	1	1	1

(default) 34 queries took 46 ms

Query

Error

Affected

Num. rows

Took (ms)

SHOW FULL COLUMNS FROM `pages`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_slovak_ci';

SHOW FULL COLUMNS FROM `users`

SHOW FULL COLUMNS FROM `partners`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';

SHOW FULL COLUMNS FROM `memberinfos`

SHOW FULL COLUMNS FROM `ranks`

SHOW FULL COLUMNS FROM `paymentmethods`

SHOW FULL COLUMNS FROM `membercars`

SHOW FULL COLUMNS FROM `fueltypes`

SHOW FULL COLUMNS FROM `transmissions`

SHOW FULL COLUMNS FROM `axles`

SHOW FULL COLUMNS FROM `vipcards`

SHOW FULL COLUMNS FROM `categories`

SHOW FULL COLUMNS FROM `attachments`

SHOW FULL COLUMNS FROM `attachments_pages`

SHOW FULL COLUMNS FROM `menuitems`

SHOW FULL COLUMNS FROM `menus`

SHOW FULL COLUMNS FROM `settings`

SELECT `Setting`.`title`, `Setting`.`content` FROM `settings` AS `Setting` WHERE 1 = 1

SELECT `Page`.`id`, `Page`.`content`, `Page`.`highlight_content`, `Page`.`highlight_url`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) WHERE `Page`.`is_highlight` = 1 AND `Page`.`status` != 3 ORDER BY `Page`.`modified` desc

SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`saved_name`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`created`, `Attachment`.`modified`, `AttachmentsPage`.`id`, `AttachmentsPage`.`page_id`, `AttachmentsPage`.`attachment_id` FROM `attachments` AS `Attachment` JOIN `attachments_pages` AS `AttachmentsPage` ON (`AttachmentsPage`.`page_id` IN (274, 257, 261, 258, 256, 198, 195, 197) AND `AttachmentsPage`.`attachment_id` = `Attachment`.`id`)

SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`title`, `Menuitem`.`url`, `Menuitem`.`parent_id`, `Menuitem`.`lft`, `Menuitem`.`rght`, `Menuitem`.`status`, `Menuitem`.`emph`, `Menuitem`.`is_category_list`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified`, `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `menuitems` AS `Menuitem` LEFT JOIN `menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) WHERE `Menuitem`.`menu_id` = 2 AND `Menuitem`.`status` != 3 ORDER BY `Menuitem`.`sort` asc

SELECT `Category`.`id`, `Category`.`title`, `Category`.`status`, `Category`.`parent_id`, `Category`.`show_in_menu`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Category`.`id_old` FROM `categories` AS `Category` WHERE `Category`.`status` != 3 AND `Category`.`show_in_menu` = 1

SHOW FULL COLUMNS FROM `adpositions`

SHOW FULL COLUMNS FROM `advertisements`

SELECT `Adposition`.`id`, `Adposition`.`title`, `Adposition`.`comment`, `Adposition`.`position_width`, `Adposition`.`position_height`, `Adposition`.`ad_width`, `Adposition`.`ad_height`, `Adposition`.`visible_ads_count`, `Adposition`.`status` FROM `adpositions` AS `Adposition` WHERE `Adposition`.`status` = 1

SELECT `Advertisement`.`id`, `Advertisement`.`adposition_id`, `Advertisement`.`partner_id`, `Advertisement`.`valid_from`, `Advertisement`.`valid_to`, `Advertisement`.`saved_filename`, `Advertisement`.`alt`, `Advertisement`.`url`, `Advertisement`.`status`, `Advertisement`.`display_count`, `Advertisement`.`click_count`, `Advertisement`.`created`, `Advertisement`.`modified` FROM `advertisements` AS `Advertisement` WHERE `Advertisement`.`valid_from` <= '2024-10-04 12:58:52' AND `Advertisement`.`valid_to` >= '2024-10-04 12:58:52' AND `Advertisement`.`status` = 1 AND `Advertisement`.`adposition_id` IN (4, 5) ORDER BY RAND() ASC

UPDATE `advertisements` AS `Advertisement` LEFT JOIN `adpositions` AS `Adposition` ON (`Advertisement`.`adposition_id` = `Adposition`.`id`) SET `Advertisement`.`display_count` = Advertisement.display_count + 1 WHERE `Advertisement`.`id` IS NULL

SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`page_type`, `Page`.`layout_id`, `Page`.`title`, `Page`.`content`, `Page`.`status`, `Page`.`is_highlight`, `Page`.`highlight_content`, `Page`.`highlight_url`, `Page`.`user_id`, `Page`.`vip_only`, `Page`.`created`, `Page`.`modified`, `Page`.`view_count`, `Page`.`old_author_id`, `User`.`id`, `User`.`user`, `User`.`password`, `User`.`pwd_old`, `User`.`status`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`admin`, `User`.`partner_id`, `User`.`created`, `User`.`modified`, `Category`.`id`, `Category`.`title`, `Category`.`status`, `Category`.`parent_id`, `Category`.`show_in_menu`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Category`.`id_old` FROM `pages` AS `Page` LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) WHERE `Page`.`id` = 196 AND `Page`.`status` = 1 LIMIT 1

SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`saved_name`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`created`, `Attachment`.`modified`, `AttachmentsPage`.`id`, `AttachmentsPage`.`page_id`, `AttachmentsPage`.`attachment_id` FROM `attachments` AS `Attachment` JOIN `attachments_pages` AS `AttachmentsPage` ON (`AttachmentsPage`.`page_id` = 196 AND `AttachmentsPage`.`attachment_id` = `Attachment`.`id`)

UPDATE `pages` AS `Page` LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) SET `Page`.`view_count` = Page.view_count + 1 WHERE `Page`.`id` = 196

SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE `Category`.`id` = 25 LIMIT 1

SELECT `Category`.`id`, `Category`.`title` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 49 AND `Category`.`rght` >= 50 ORDER BY `Category`.`lft` asc

(forum) 5 queries took 5 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `phpbb_posts`	29	29	1
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';	1	1	1
3	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';	1	1	1
4	SHOW FULL COLUMNS FROM `phpbb_topics`	38	38	1
5	SHOW FULL COLUMNS FROM `phpbb_forums`	50	50	1

(forum) 5 queries took 5 ms

Query

Error

Affected

Num. rows

Took (ms)

SHOW FULL COLUMNS FROM `phpbb_posts`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';

SHOW FULL COLUMNS FROM `phpbb_topics`

SHOW FULL COLUMNS FROM `phpbb_forums`

Partneri

Štatistiky OCSK - marec-december 2013

Klubové info

Fotografie

Kontakt

Sledujte nás