| | |
| Stránka: 1 z 1
| [ Príspevkov: 14 ] | |
Autor | Správa |
---|
Registrovaný: 12.11.05 Prihlásený: 18.11.05 Príspevky: 1 Témy: 1 | Napísal MeSo: 12.11.2005 9:28 | |
|
Ako sa vola ten mód co mate aj na vasej stranke ... ten co zobrazuje dole na päte stránky rychlost vygenerovania, databazu ..... ???
|
|
Registrovaný: 06.11.05 Prihlásený: 14.04.23 Príspevky: 57 Témy: 9 Bydlisko: Martin | Napísal RHS21: 12.11.2005 12:06 | |
|
ten mod by sa aj mne hodil
_________________ MB: Asus M4A785TD-V EVO CPU: AMD Phenom II X4 945 Quad-Core + ARCTIC Freezer 7 Rev.2 GPU: ASUS ENGTX550 TI DC TOP/DI/1GD5 RAM: KINGSTON HyperX Black Edition BOX DDR3 1600MHz CL9-9-9-27 HDD: Hitachi SATA 120GB PSU: CORSAIR VX450, 450W |
|
Registrovaný: 01.05.05 Príspevky: 13343 Témy: 1494 Bydlisko: Bratislava | Napísal JanoF: 12.11.2005 15:37 | |
|
Na nete som tuto verziu nikde nenasiel, da sa stiahnut novsia ale ta je zbytocna a v podstate nanic pre usera absolutne nepodstatna, ak by ho to zaujimalo
Tato co tu mame je Footer Statistics Hack, su dve upravy
Uprava 1
Kód: //////////////////////////////////////////////////////////////////////////// /// ___ /// / /\ ___ /// ### ### / /::\ / /\ /// ## #### ## / /:/\:\ / /:/ /// ## ## ## ## / /:/~/::\ /__/::\ /// ## ## ## /__/:/ /:/\:\ \__\/\:\__ /// ## ## ## ## \ \:\/:/__\/ /ŻŻŻ/ \ \:\/\ /// ## #### ## \ \::/ \__\::/ /// ### ### \ \:\ /__/:/ /// \ \:\ \__\/ /// \__\/ ////////////////////////////////////////////////////////////////////////////
/*************************************************************************** * Footer Mod * --------------- * Version : 1.0.0 * Email : austin_inc@hotmail.com * Site : austin-inc.com/ * Copyright : © aUsTiN-Inc 2003/4 * ***************************************************************************/
If your reading this, you have either deleted the previous hack to do this or its a first time install. If neither of those are true, please refer back to the ReadMe
# #-----[ OPEN ]------------------------------------------ #
extension.inc
# #-----[ FIND ]------------------------------------------ #
$starttime = 0;
# #-----[ REPLACE WITH ]---------------------------------- #
// Added by Smartor - BEGIN
$mtime = microtime(); $mtime = explode(" ",$mtime); $mtime = $mtime[1] + $mtime[0]; $starttime = $mtime;
// Added by Smartor - END
# #-----[ CLOSE & SAVE ]---------------------------------- #
# #-----[ OPEN ]------------------------------------------ #
includes/functions.php
# #-----[ FIND ]------------------------------------------ #
?>
# #-----[ BEFORE ADD ]------------------------------------ #
/* Start Page Views, Queries Today & Queries Top By aUsTiN (http://austin-inc.com/Blend) */
function UpdatePageView() { global $db, $table_prefix; $q1 = "UPDATE ". $table_prefix ."page_view_count SET views = views + 1"; $r1 = $db -> sql_query($q1); return; } function SelectPageViewDate() { global $db, $table_prefix; $q = "SELECT * FROM ". $table_prefix ."page_view_count"; $r = $db -> sql_query($q); $row = $db -> sql_fetchrow($r); $pvd = $row['date']; return $pvd; } function PageViewsToday() { global $db, $table_prefix; $q = "SELECT * FROM ". $table_prefix ."page_view_count"; $r = $db -> sql_query($q); $row = $db -> sql_fetchrow($r); $pvv = $row['views']; return $pvv; } function ResetPageViews($date) { global $db, $table_prefix; $q1 = "UPDATE ". $table_prefix ."page_view_count SET views = '1', date = '$date'"; $r1 = $db -> sql_query($q1); return; } function SelectQueries() { global $db, $table_prefix; $q = "SELECT * FROM ". $table_prefix ."todays_queries"; $r = $db -> sql_query($q); $row = $db -> sql_fetchrow($r); $tqd = $row['date']; $otq1 = $row['total']; $otq = number_format($otq1); $q = "SELECT * FROM ". $table_prefix ."top_queries"; $r = $db -> sql_query($q); $row = $db -> sql_fetchrow($r); $top_1 = $row['total']; $top_d = $row['day']; $set = strftime("%b. %d, %Y @ %H:%M:%S", $top_d); $top_q = number_format($top_1); $show_in_footer_today = "Todays DB Queries: $otq"; $show_in_footer_top = "Highest Query Load: $top_q Queries On $set"; $show_data = $show_in_footer_today ."/". $show_in_footer_top ."/". $tqd; return $show_data; } function UpdateQueryCount($excuted_queries) { global $db, $table_prefix; $q1 = "UPDATE ". $table_prefix ."todays_queries SET total = total + $excuted_queries"; $r1 = $db -> sql_query($q1); return; } function UpdateQueryTop($tqt, $excuted_queries) { global $db, $table_prefix; $q1 = "UPDATE ". $table_prefix ."top_queries SET total = '$tqt', day = '". time() ."'"; $r1 = $db -> sql_query($q1); return; } function ResetTodaysQueries($excuted_queries, $date) { global $db, $table_prefix; $q1 = "UPDATE ". $table_prefix ."todays_queries SET total = '$excuted_queries', date = '$date'"; $r1 = $db -> sql_query($q1); return; } function QueryDateCheck() { global $db, $table_prefix;
$q = "SELECT total FROM ". $table_prefix ."todays_queries"; $r = $db -> sql_query($q); $row = $db -> sql_fetchrow($r); $tqt = $row['total']; $q = "SELECT * FROM ". $table_prefix ."top_queries"; $r = $db -> sql_query($q); $row = $db -> sql_fetchrow($r); $tq = $row['total']; $qd = $row['day']; $show_data = "$tqt,$tq,$qd"; return $show_data; } /* Finished Page Views, Queries Today & Queries Top By aUsTiN (http://austin-inc.com/Blend) */
# #-----[ CLOSE & SAVE ]---------------------------------- #
# #-----[ OPEN ]------------------------------------------ #
includes/page_tail.php
# #-----[ FIND ]------------------------------------------ #
$template->set_filenames(array( 'overall_footer' => ( empty($gen_simple_header) ) ? 'overall_footer.tpl' : 'simple_footer.tpl') );
# #-----[ Add After ]------------------------------------- #
/* Start Page Views, Queries Today & Queries Top By aUsTiN (http://austin-inc.com/Blend) */
/* Start © Smartors Page generation time for Admin only Hack */ $excuted_queries = $db -> num_queries; $mtime = microtime(); $mtime = explode(" ",$mtime); $mtime = $mtime[1] + $mtime[0]; $endtime = $mtime; $gentime = round(($endtime - $starttime), 1); /* End © Smartors Page generation time for Admin only Hack */ $date = date("Y-m-d"); $pvd = SelectPageViewDate(); if($pvd == $date) { UpdatePageView(); } else { ResetPageViews($date); } $pvv = PageViewsToday(); $pvt = number_format($pvv); $spvt = "$pvt Page(s) Viewed Today."; $data_to_explode = SelectQueries(); $explode_it = explode("/", $data_to_explode); $show_in_footer_today = $explode_it[0]; $show_in_footer_top = $explode_it[1]; $tqd = $explode_it[2]; if($tqd == $date) { UpdateQueryCount($excuted_queries); $date_to_explode = QueryDateCheck(); $explode_it_2 = explode(",", $date_to_explode); $tqt = $explode_it_2[0]; $tq = $explode_it_2[1]; $qd = $explode_it_2[2]; if($tqt > $tq) { UpdateQueryTop($tqt, $excuted_queries); } } else { ResetTodaysQueries($excuted_queries, $date); } $template->assign_vars(array( 'GENERATION_TIME' => $gentime, 'NUMBER_QUERIES' => $excuted_queries, 'OVERALL_QUERIES_TODAY' => $show_in_footer_today, 'OVERALL_QUERIES_TOP' => $show_in_footer_top, 'OVERALL_PAGES_VIEWED' => $spvt, ) );
$template->assign_block_vars('generation_time_switch', array() ); /* Finished Page Views, Queries Today & Queries Top By aUsTiN (http://austin-inc.com/Blend) */
# #-----[ Close & Save ]---------------------------------- #
# #-----[ OPEN ]------------------------------------------ #
templates/YOUR_TEMPLATE/overall_footer.tpl
# #-----[ FIND / OR SIMILAR TO THIS ]--------------------- #
Powered by <a href="http://www.phpbb.com/" target="_phpbb" class="copyright">phpBB</a> {PHPBB_VERSION} © 2002
# #-----[ ADD AFTER ]------------------------------------- #
<br /> :: [ Load Time: {GENERATION_TIME} Seconds ] :: [ {NUMBER_QUERIES} Queries ] :: [ {OVERALL_PAGES_VIEWED} ] :: <br /> :: [ {OVERALL_QUERIES_TODAY} ] :: [ {OVERALL_QUERIES_TOP} ] ::
# #-----[ CLOSE & SAVE ]---------------------------------- #
EoM Uprava 2Kód: //////////////////////////////////////////////////////////////////////////// /// ___ /// / /\ ___ /// ### ### / /::\ / /\ /// ## #### ## / /:/\:\ / /:/ /// ## ## ## ## / /:/~/::\ /__/::\ /// ## ## ## /__/:/ /:/\:\ \__\/\:\__ /// ## ## ## ## \ \:\/:/__\/ /ŻŻŻ/ \ \:\/\ /// ## #### ## \ \::/ \__\::/ /// ### ### \ \:\ /__/:/ /// \ \:\ \__\/ /// \__\/ ////////////////////////////////////////////////////////////////////////////
/*************************************************************************** * Footer Mod * --------------- * Version : 1.0.0 * Email : austin_inc@hotmail.com * Site : austin-inc.com/ * Copyright : © aUsTiN-Inc 2003/4 * ***************************************************************************/
If your reading this, this means you already have © Smartors Page generation time for Admin only Hack installed.
# #-----[ OPEN ]------------------------------------------ #
includes/page_tail.php
# #-----[ FIND & DELETE ]---------------------------------
// Page generation time for Admin - BEGIN $gzip_text = ($board_config['gzip_compress']) ? "GZIP compression enabled" : "GZIP compression disabled"; $excuted_queries = $db->num_queries; $mtime = microtime(); $mtime = explode(" ",$mtime); $mtime = $mtime[1] + $mtime[0]; $endtime = $mtime; $gentime = round(($endtime - $starttime), 6); // You can adjust the number 6
if ($userdata['user_level'] == ADMIN) { $template->assign_vars(array( 'GENERATION_TIME' => $gentime, 'NUMBER_QUERIES' => $excuted_queries, 'GZIP_TEXT' => $gzip_text, ) );
$template->assign_block_vars('generation_time_switch', array() ); } // Page generation time for Admin - END
# #-----[ CLOSE & SAVE ]----------------------------------- #
# #-----[ OPEN ]------------------------------------------ #
templates/YOUR_TEMPLATE/overall_footer.tpl
# #-----[ FIND & DELETE ]--------------------------------- #
<!-- BEGIN generation_time_switch --> <br /> <table width="100%" align="center" border="0" cellpadding="3"> <tr> <td class="row1" align="center"> <span class="gensmall"> [ Page generation time: {GENERATION_TIME} seconds ] :: [ {NUMBER_QUERIES} queries excuted ] :: [ {GZIP_TEXT} ] </span> </td> </tr> </table> <br /> <!-- END generation_time_switch -->
# #-----[ CLOSE & SAVE ]----------------------------------- #
Please open the other install & do a fresh install of my version.
EoM
_________________ Streacom DA2 | SilverStone Titanium SX800-LTI 800W | ASRock X299E-ITX/ac | Intel Core i9-9980XE & be quiet! Dark Rock TF | Kingston HyperX Impact 64 GB DDR4 2666 MHz | NVIDIA Titan RTX 24 GB | Intel SSD Optane 905P 480 GB NVMe U.2 & Intel SSD 750 1,2 TB NVMe U.2 & Intel SSD 660p 2 TB NVMe M.2 & Seagate BackUp Plus Portable 56 TB USB | 55" 4K OLED Dell Alienware AW5520QF & 24" LCD EIZO FlexScan EV2451 | Ergotron LX Wall Mount Keyboard Arm | Logitech Craft | Logitech G603 | Logitech F710 | Harman Kardon Sabre SB 35 & Sennheiser RS 175 | Microsoft Windows 7 Ultimate | APC Back-UPS ES 700 | Lenovo ThinkPad X250 | iPhone X 256 GB & Pitaka Aramid | SilverStone ML05B Milo | Corsair SF600 SFX 600W | ASRock X99E-ITX/ac | Intel Xeon E5-2683 v4 & NOCTUA NH-L12S | Kingston HyperX Savage 32 GB DDR4 2400 MHz | NVIDIA GeForce GT 710 1 GB | Intel SSD Optane Memory 32 GB NVMe M.2 & Intel SSD 730 240 GB SATA | Ubuntu Server |
|
Registrovaný: 06.11.05 Prihlásený: 14.04.23 Príspevky: 57 Témy: 9 Bydlisko: Martin | Napísal RHS21: 12.11.2005 19:35 | |
|
tak som si nainstaloval tu druhu vezriu, no zobrazuje to len prve dve cisla, ostatne try su stale na nule
Kód: :: [ Vygenerované za: 0.3s ] :: [ 16 Queries ] :: [ 0 stránok za dnes ] :: [ DB za dnes: 0 ] :: [ Max. DB: 0 Queries ] ::
nahodu nechyba k tomu este niaky subor??? ci zase to blbne len mne
_________________ MB: Asus M4A785TD-V EVO CPU: AMD Phenom II X4 945 Quad-Core + ARCTIC Freezer 7 Rev.2 GPU: ASUS ENGTX550 TI DC TOP/DI/1GD5 RAM: KINGSTON HyperX Black Edition BOX DDR3 1600MHz CL9-9-9-27 HDD: Hitachi SATA 120GB PSU: CORSAIR VX450, 450W |
|
Registrovaný: 01.05.05 Príspevky: 13343 Témy: 1494 Bydlisko: Bratislava | Napísal JanoF: 12.11.2005 19:41 | |
|
aha sry
tieto tabulky treba vytvorit
Kód: # --------------------------------------------------------
# # Table structure for table `phpbb_page_view_count` #
CREATE TABLE `phpbb_page_view_count` ( `date` date NOT NULL default '0000-00-00', `views` int(20) NOT NULL default '0' ) TYPE=MyISAM;
# # Dumping data for table `phpbb_page_view_count` #
INSERT INTO `phpbb_page_view_count` VALUES ('DATE_HERE', '0');
# --------------------------------------------------------
# # Table structure for table `phpbb_todays_queries` #
CREATE TABLE `phpbb_todays_queries` ( `total` int(100) NOT NULL default '0', `date` date NOT NULL default '0000-00-00' ) TYPE=MyISAM;
# # Dumping data for table `phpbb_todays_queries` #
INSERT INTO `phpbb_todays_queries` VALUES ('0', 'DATE_HERE');
# --------------------------------------------------------
# # Table structure for table `phpbb_top_queries` #
CREATE TABLE `phpbb_top_queries` ( `total` int(100) NOT NULL default '0', `day` int(11) NOT NULL default '0' ) TYPE=MyISAM;
# # Dumping data for table `phpbb_top_queries` #
INSERT INTO `phpbb_top_queries` VALUES ('0', '1084654229');
# --------------------------------------------------------
_________________ Streacom DA2 | SilverStone Titanium SX800-LTI 800W | ASRock X299E-ITX/ac | Intel Core i9-9980XE & be quiet! Dark Rock TF | Kingston HyperX Impact 64 GB DDR4 2666 MHz | NVIDIA Titan RTX 24 GB | Intel SSD Optane 905P 480 GB NVMe U.2 & Intel SSD 750 1,2 TB NVMe U.2 & Intel SSD 660p 2 TB NVMe M.2 & Seagate BackUp Plus Portable 56 TB USB | 55" 4K OLED Dell Alienware AW5520QF & 24" LCD EIZO FlexScan EV2451 | Ergotron LX Wall Mount Keyboard Arm | Logitech Craft | Logitech G603 | Logitech F710 | Harman Kardon Sabre SB 35 & Sennheiser RS 175 | Microsoft Windows 7 Ultimate | APC Back-UPS ES 700 | Lenovo ThinkPad X250 | iPhone X 256 GB & Pitaka Aramid | SilverStone ML05B Milo | Corsair SF600 SFX 600W | ASRock X99E-ITX/ac | Intel Xeon E5-2683 v4 & NOCTUA NH-L12S | Kingston HyperX Savage 32 GB DDR4 2400 MHz | NVIDIA GeForce GT 710 1 GB | Intel SSD Optane Memory 32 GB NVMe M.2 & Intel SSD 730 240 GB SATA | Ubuntu Server |
|
Registrovaný: 06.11.05 Prihlásený: 14.04.23 Príspevky: 57 Témy: 9 Bydlisko: Martin | Napísal RHS21: 12.11.2005 20:14 | |
|
tie tabulky platia pre obydve verzie??? alebo len pre jednu??? a vlastne pre ktoru
sakris, som to napisal pekne chaoticky, hadam pochopis
_________________ MB: Asus M4A785TD-V EVO CPU: AMD Phenom II X4 945 Quad-Core + ARCTIC Freezer 7 Rev.2 GPU: ASUS ENGTX550 TI DC TOP/DI/1GD5 RAM: KINGSTON HyperX Black Edition BOX DDR3 1600MHz CL9-9-9-27 HDD: Hitachi SATA 120GB PSU: CORSAIR VX450, 450W |
|
Registrovaný: 06.11.05 Prihlásený: 14.04.23 Príspevky: 57 Témy: 9 Bydlisko: Martin | Napísal RHS21: 12.11.2005 20:18 | |
|
vlastne nahaj tak, uz som sa z toho vysomaril, vsak su tam nazvy tabuliek podla typu funkcie
_________________ MB: Asus M4A785TD-V EVO CPU: AMD Phenom II X4 945 Quad-Core + ARCTIC Freezer 7 Rev.2 GPU: ASUS ENGTX550 TI DC TOP/DI/1GD5 RAM: KINGSTON HyperX Black Edition BOX DDR3 1600MHz CL9-9-9-27 HDD: Hitachi SATA 120GB PSU: CORSAIR VX450, 450W |
|
Registrovaný: 01.05.05 Príspevky: 13343 Témy: 1494 Bydlisko: Bratislava | Napísal JanoF: 12.11.2005 20:19 | |
|
je to urcene pre prvu instalaciu, kedze ta druha vyhodi len
[ Vygenerované za: 1.6s ] :: [ 18 Queries ] :: [ GZIP ]
_________________ Streacom DA2 | SilverStone Titanium SX800-LTI 800W | ASRock X299E-ITX/ac | Intel Core i9-9980XE & be quiet! Dark Rock TF | Kingston HyperX Impact 64 GB DDR4 2666 MHz | NVIDIA Titan RTX 24 GB | Intel SSD Optane 905P 480 GB NVMe U.2 & Intel SSD 750 1,2 TB NVMe U.2 & Intel SSD 660p 2 TB NVMe M.2 & Seagate BackUp Plus Portable 56 TB USB | 55" 4K OLED Dell Alienware AW5520QF & 24" LCD EIZO FlexScan EV2451 | Ergotron LX Wall Mount Keyboard Arm | Logitech Craft | Logitech G603 | Logitech F710 | Harman Kardon Sabre SB 35 & Sennheiser RS 175 | Microsoft Windows 7 Ultimate | APC Back-UPS ES 700 | Lenovo ThinkPad X250 | iPhone X 256 GB & Pitaka Aramid | SilverStone ML05B Milo | Corsair SF600 SFX 600W | ASRock X99E-ITX/ac | Intel Xeon E5-2683 v4 & NOCTUA NH-L12S | Kingston HyperX Savage 32 GB DDR4 2400 MHz | NVIDIA GeForce GT 710 1 GB | Intel SSD Optane Memory 32 GB NVMe M.2 & Intel SSD 730 240 GB SATA | Ubuntu Server |
|
Registrovaný: 06.11.05 Prihlásený: 14.04.23 Príspevky: 57 Témy: 9 Bydlisko: Martin | Napísal RHS21: 12.11.2005 20:25 | |
|
JanoF píše: je to urcene pre prvu instalaciu, kedze ta druha vyhodi len [ Vygenerované za: 1.6s ] :: [ 18 Queries ] :: [ GZIP ] uz som asi dneska prepracovany
_________________ MB: Asus M4A785TD-V EVO CPU: AMD Phenom II X4 945 Quad-Core + ARCTIC Freezer 7 Rev.2 GPU: ASUS ENGTX550 TI DC TOP/DI/1GD5 RAM: KINGSTON HyperX Black Edition BOX DDR3 1600MHz CL9-9-9-27 HDD: Hitachi SATA 120GB PSU: CORSAIR VX450, 450W |
|
Registrovaný: 09.10.06 Prihlásený: 11.03.10 Príspevky: 167 Témy: 42 Bydlisko: Martin | Napísal koudy: 13.02.2007 19:45 | |
|
JanoF píše: aha sry tieto tabulky treba vytvorit Kód: # --------------------------------------------------------
# # Table structure for table `phpbb_page_view_count` #
CREATE TABLE `phpbb_page_view_count` ( `date` date NOT NULL default '0000-00-00', `views` int(20) NOT NULL default '0' ) TYPE=MyISAM;
# # Dumping data for table `phpbb_page_view_count` #
INSERT INTO `phpbb_page_view_count` VALUES ('DATE_HERE', '0');
# --------------------------------------------------------
# # Table structure for table `phpbb_todays_queries` #
CREATE TABLE `phpbb_todays_queries` ( `total` int(100) NOT NULL default '0', `date` date NOT NULL default '0000-00-00' ) TYPE=MyISAM;
# # Dumping data for table `phpbb_todays_queries` #
INSERT INTO `phpbb_todays_queries` VALUES ('0', 'DATE_HERE');
# --------------------------------------------------------
# # Table structure for table `phpbb_top_queries` #
CREATE TABLE `phpbb_top_queries` ( `total` int(100) NOT NULL default '0', `day` int(11) NOT NULL default '0' ) TYPE=MyISAM;
# # Dumping data for table `phpbb_top_queries` #
INSERT INTO `phpbb_top_queries` VALUES ('0', '1084654229');
# --------------------------------------------------------
Prosim ta mohol by mi niekdo povedat ako to mam presne urobit bo neviim
|
|
Registrovaný: 29.12.05 Prihlásený: 14.08.18 Príspevky: 539 Témy: 62 Bydlisko: 127.0.0.1 (... | Napísal qacer: 13.02.2007 19:50 | |
|
najlepsie cez phpmyadmin
|
|
Registrovaný: 09.10.06 Prihlásený: 11.03.10 Príspevky: 167 Témy: 42 Bydlisko: Martin | Napísal koudy: 13.02.2007 19:58 | |
|
tak to viem ale ako ju tam mam nahrat tak to neviem
|
|
Registrovaný: 29.12.05 Prihlásený: 14.08.18 Príspevky: 539 Témy: 62 Bydlisko: 127.0.0.1 (... | Napísal qacer: 13.02.2007 20:04 | |
|
tam musis najst textarea s niecim ako vykonat prikaz...cely prikaz tam skopirujes a das vykonaj
|
|
Registrovaný: 09.10.06 Prihlásený: 11.03.10 Príspevky: 167 Témy: 42 Bydlisko: Martin | Napísal koudy: 14.02.2007 7:52 | |
|
jadobre uz to mam fest diky
|
|
| Stránka: 1 z 1
| [ Príspevkov: 14 ] | |
| Nemôžete zakladať nové témy v tomto fóre Nemôžete odpovedať na témy v tomto fóre Nemôžete upravovať svoje príspevky v tomto fóre Nemôžete mazať svoje príspevky v tomto fóre
|
|