| | |
| Stránka: 1 z 1
| [ Príspevkov: 7 ] | |
Autor | Správa |
---|
Registrovaný: 01.05.05 Príspevky: 13348 Témy: 1496 Bydlisko: Bratislava | Napísal JanoF: 13.10.2006 9:12 | |
|
[ Vygenerované za: 0.2s ] :: [ 15 Queries ] :: [ 1,750 Page(s) Viewed Today. ] :: [ Dnes DB: 1,200 ] :: [ Max DB: 312,234 Queries ]
Readme.txt
Kód: //////////////////////////////////////////////////////////////////////////// /// ___ /// / /\ ___ /// ### ### / /::\ / /\ /// ## #### ## / /:/\:\ / /:/ /// ## ## ## ## / /:/~/::\ /__/::\ /// ## ## ## /__/:/ /:/\:\ \__\/\:\__ /// ## ## ## ## \ \:\/:/__\/ /ŻŻŻ/ \ \:\/\ /// ## #### ## \ \::/ \__\::/ /// ### ### \ \:\ /__/:/ /// \ \:\ \__\/ /// \__\/ ////////////////////////////////////////////////////////////////////////////
/*************************************************************************** * Footer Mod * --------------- * Version : 1.0.0 * Email : austin_inc@hotmail.com * Site : austin-inc.com/ * Copyright : © aUsTiN-Inc 2003/4 * ***************************************************************************/
There are two installs, one is for those who already have © Smartors Page generation time for Admin only Hack installed & the other is for those who dont. If you already have smartors hack installed please use Install Two, if you do not have any hacks for the footer that have to do with page load time & db queries, etc. please use Install One. Now if you have someone elses hack for the load time etc, find their install & reverse it, delete/undo everything you previosuly did refering to includes/page_tail.php and templates/YOUR_TEMPLATE/overall_footer.tpl. As you can see you wont be losing anything, its in this as well.
Any way you go, apply the following to your database. Replace DATE_HERE with todays date, in the date format YYYY-MM-DD.
# --------------------------------------------------------
# # 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');
# -------------------------------------------------------- Install One.txtKó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 Install Two.txtKó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ý: 16.06.06 Prihlásený: 22.08.07 Príspevky: 53 Témy: 7 Bydlisko: Slovakia | Napísal wix: 17.10.2006 19:53 | |
|
mna by zaujimalo ze ako zmenim preklad z anglictiny do slovenciny
|
|
Registrovaný: 02.07.06 Prihlásený: 30.01.20 Príspevky: 1635 Témy: 137 Bydlisko: Slovakia - ... | Napísal javo: 17.10.2006 19:55 | |
|
Wendor píše: mna by zaujimalo ze ako zmenim preklad z anglictiny do slovenciny
prelozis si to v zdrojaku
_________________ Zivot je jednoduchy , staci sa rozhodnut a neobzerat sa spat. Poriadok je pre blbcov, inteligent zvlada chaos. |
|
Registrovaný: 16.06.06 Prihlásený: 22.08.07 Príspevky: 53 Témy: 7 Bydlisko: Slovakia | Napísal wix: 17.10.2006 19:58 | |
|
myslis to co je v tom overall_footer.tpl? to som si uz prelozil ale niektore veci sa nedaju resp. som nenasiel ako by som ich prelozil tak sa pytam tu
|
|
Registrovaný: 02.07.06 Prihlásený: 30.01.20 Príspevky: 1635 Témy: 137 Bydlisko: Slovakia - ... | Napísal javo: 17.10.2006 20:14 | |
|
Wendor píše: myslis to co je v tom overall_footer.tpl? to som si uz prelozil ale niektore veci sa nedaju resp. som nenasiel ako by som ich prelozil tak sa pytam tu
skusal si prelozit instal?
_________________ Zivot je jednoduchy , staci sa rozhodnut a neobzerat sa spat. Poriadok je pre blbcov, inteligent zvlada chaos. |
|
Registrovaný: 16.06.06 Prihlásený: 22.08.07 Príspevky: 53 Témy: 7 Bydlisko: Slovakia | Napísal wix: 19.10.2006 19:23 | |
|
uz som to nasiel takze vyriesene ale aj tak dakujem za ochotu
|
|
Registrovaný: 09.07.06 Prihlásený: 13.03.18 Príspevky: 47 Témy: 16 |
AK chcete ja to mám spravené ..................
:: [ Vygenerované za 5.1 sekúnd ] :: [ 37 dotazov ] :: [ 240 zobrezených stránok za deň. ] :: :: [ Dnes DB dotazov: 5,644 ] :: [ Najviac dotazov: 11,465 dotazov v Oct. 14, 2006 @ 23:56:38 ] ::
je to na Kód: http://www.redpoint1.wz.cz/FTMSK.rar
samozrejme vlastný
|
|
| Stránka: 1 z 1
| [ Príspevkov: 7 ] | |
Podobné témy | Témy | Odpovede | Zobrazenia | Posledný príspevok |
---|
| Hladam mod - ako footer hack v Redakčné systémy | 2 | 465 | 22.10.2006 16:29 WEB LAMA | | aky je to mod?-Vygenerované za:...atd v Redakčné systémy | 3 | 907 | 13.07.2006 10:21 dado26 | | Micro-freezy SSD 0,5-2s v SSD disky | 13 | 468 | 25.05.2013 2:57 brmbo | | Color Groups a nadmerné queries v Redakčné systémy | 5 | 590 | 10.08.2006 10:16 rEnEeK | | Vymena USB 2.0 za USB 3.0 v Notebooky a netbooky | 8 | 1859 | 15.02.2011 12:15 prkyyynko | | Toshiba ALU 2S v Pevné disky a radiče | 1 | 737 | 13.01.2015 10:57 Mandy | | Xiaomi MI TV 2S v Monitory, televízory a projektory | 4 | 724 | 17.07.2015 9:14 Choleer | | footer v HTML, XHTML, XML, CSS | 3 | 336 | 19.10.2012 23:39 shaggy | | Myska za 0,01€? v Ostatné | 13 | 512 | 14.10.2013 14:37 liqua1 | | footer mod v Redakčné systémy | 1 | 484 | 14.01.2007 21:02 JanoF | | Náhrada za IE 3.0 v Ostatné | 11 | 427 | 19.06.2014 9:07 uNfEiL | | Footer uplne dole v HTML, XHTML, XML, CSS | 7 | 681 | 20.12.2008 19:13 dadmtb | | Náhrada za Asus M5A97 R2.0 v Základné dosky | 2 | 552 | 28.08.2017 19:59 reDo | | footer beha kam chce v HTML, XHTML, XML, CSS | 5 | 472 | 29.08.2008 21:03 dadmtb | | Ako spraviť editovateľný footer? v Redakčné systémy | 7 | 731 | 04.07.2012 23:47 m1roslav | | Footer prekryva pravy panel v HTML, XHTML, XML, CSS | 9 | 619 | 06.06.2011 22:17 johnny04501 |
| 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
|
|