phpBB.sk

huli · od **huli** » Str Júl 02, 2008 3:43 pm

Na funkciu dss_rand() ktoru som tu kedysi popisoval som nasiel jednoduchsie riesenie...

## EasyMod 0.3.0 Compatible
##############################################################
## MOD Title: dss_rand no query
## MOD Author: Huli < huli0401@gmail.com >
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

#
#-----[ OPEN ]------------------------------------------
#
includes/functions.php

#
#-----[ FIND ]------------------------------------------
#
function dss_rand()

#
#-----[ REPLACE WITH ]------------------------------------------
# Nahradíme celú funkciu dss_rand
#
function dss_rand()
{
return substr(mt_rand(1,999999999999), 4, 16);
}

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
# by Huli < huli0401@gmail.com >

Pre tych co nevedia o co islo tak pisem znova, zbytocna funkcia ktora generuje nahodne cisla a nasledne zapisuje do databazy tymto usetrite 1 sql dopyt na kazdej stranke...

huli · od **huli** » Str Júl 02, 2008 3:49 pm

Dalsia dobra vec a hned usetrime na indexe 3 dopyty... ale jedine ak mate na webhostingu cron alebo nejaku webovy script ktory cron nahradi... ide o cachovanie statistik... kolko prispevkov je na fore, kolko tem, kolko uzivatelov, a ktory je najnovsi uzivatel...

Odporucam v dat do cronu funckiu ktora bude mazat nasledovne subory kazdych 5 minut..

cache/cache_usercount.php
cache/cache_newestuser.php
cache/cache_postcount_topiccount.php

subor by mal vyzerat nasledovne
nazov suboru: delete.php
ceska k suboru: / (cize do roota kde je aj config, index, viewtopic atd..)

<?php
unlink('cache/cache_usercount.php');
unlink('cache/cache_newestuser.php');
unlink('cache/cache_postcount_topiccount.php');
?>

v crone vyplnime podla obrazku (ak mate hosting od websupport tak to mate lahsie)
http://image.dayphorum.eu/images/46823914526331.png

a tu je mod (2.7.2008)

## EasyMod 0.3.0 Compatible
##############################################################
## MOD Title: get_db_stat caching
## MOD Author: Huli < huli0401@gmail.com >
##############################################################
## Author notes:
## I add function to cron to delete this file every 5 minutes.
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

#
#-----[ OPEN ]------------------------------------------
#
includes/functions.php

#
#-----[ FIND ]------------------------------------------
#
function get_db_stat($mode)

#
#-----[ REPLACE WITH ]------------------------------------------
# Nahradíme celú funkciu get_db_stat
#
function get_db_stat($mode)
{
global $db, $phpbb_root_path, $phpEx;

switch( $mode )
{
case 'usercount':
if ( file_exists($phpbb_root_path . 'cache/cache_usercount.'.$phpEx) )
{
include($phpbb_root_path . 'cache/cache_usercount.'.$phpEx);
}
else{
$sql = "SELECT COUNT(user_id) AS total
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS;

if ( !($result = $db->sql_query($sql)) )
{
return false;
}
//$row = $db->sql_fetchrow($result);
$file_data = '<? $row = ' . format_array($db->sql_fetchrow($result)) . '; ?>';
$db->sql_freeresult($result);
$handle = fopen($phpbb_root_path . 'cache/cache_usercount.'.$phpEx, 'w');
@flock($handle, LOCK_EX);
fwrite($handle, $file_data);
@flock($handle, LOCK_UN);
fclose($handle);
include($phpbb_root_path . 'cache/cache_usercount.'.$phpEx);

}
return $row['total'];
break;

case 'newestuser':
if ( file_exists($phpbb_root_path . 'cache/cache_newestuser.' .$phpEx) )
{
include($phpbb_root_path . 'cache/cache_newestuser.' .$phpEx);
}
else{
$sql = "SELECT user_id, username
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
ORDER BY user_id DESC
LIMIT 1";
if ( !($result = $db->sql_query($sql)) )
{
return false;
}
//$row = $db->sql_fetchrow($result);
$file_data = '<? $row = ' . format_array($db->sql_fetchrow($result)) . '; ?>';
$db->sql_freeresult($result);
$handle = fopen($phpbb_root_path . 'cache/cache_newestuser.'.$phpEx, 'w');
@flock($handle, LOCK_EX);
fwrite($handle, $file_data);
@flock($handle, LOCK_UN);
fclose($handle);
include($phpbb_root_path . 'cache/cache_newestuser.'.$phpEx);
}
return $row;
break;

case 'postcount':
if ( file_exists($phpbb_root_path . 'cache/cache_postcount_topiccount.' .$phpEx) )
{
include($phpbb_root_path . 'cache/cache_postcount_topiccount.' .$phpEx);
}
else{
$sql = "SELECT SUM(forum_posts) AS post_total, SUM(forum_topics) AS topic_total
FROM " . FORUMS_TABLE;
if ( !($result = $db->sql_query($sql)) )
{
return false;
}
//$row = $db->sql_fetchrow($result);
$file_data = '<? $row = ' . format_array($db->sql_fetchrow($result)) . '; ?>';
$db->sql_freeresult($result);
$handle = fopen($phpbb_root_path . 'cache/cache_postcount_topiccount.'.$phpEx, 'w');
@flock($handle, LOCK_EX);
fwrite($handle, $file_data);
@flock($handle, LOCK_UN);
fclose($handle);
include($phpbb_root_path . 'cache/cache_postcount_topiccount.'.$phpEx);
}
return $row['post_total'];
break;
case 'topiccount':
if ( file_exists($phpbb_root_path . 'cache/cache_postcount_topiccount.' .$phpEx) )
{
include($phpbb_root_path . 'cache/cache_postcount_topiccount.' .$phpEx);
}
return $row['topic_total'];
break;
}
return false;
}

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
# by Huli < huli0401@gmail.com >

Welwet · od **Welwet** » Str Júl 02, 2008 11:16 pm

Ak pracuje spravne tak toto moze byt celkom uzitocny cache. Statistky vseobecne dost zatazuju databazu.

huli · od **huli** » Štv Júl 03, 2008 10:13 am

Welwet píše:Ak pracuje spravne tak toto moze byt celkom uzitocny cache. Statistky vseobecne dost zatazuju databazu.

Samozrejme ze pracuje ale pridat do cronu aby sa ten cache subor mazal v casovych intervaloch odporucujem najviac 5 minut pre fakt velke fora aj 10....