vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   DevBox Work - Online Users Today, Latest Threads, Top Posters, Newest Members (https://vborg.vbsupport.ru/showthread.php?t=63109)

2HostMe 10-18-2005 06:09 AM

Is there someone how get it work with version v3.5 ?
A reinstall in 3.5 don't work.

hawgjaw 10-19-2005 07:10 PM

devbox-latest_threads_bit--{<b>$data[counter].</b>
<b><a href=\"showthread.php?$session[sessionurl]t=$data[threadid]\">$data[title]</a></b><br /> devbox-newest_members_bit-----{<b>$data[counter].</b> <a href=\"member.php?$session[sessionurl]u=$data[userid]\">$data[username]</a> on $data[date]<br /> devbox-online_today_bit--{<a href=\"member.php?$session[sessionurl]u=$data[userid]\">$data[opentag]$data[username]$data[closetag]$data[invisible]</a> devbox-top_posters_bit----{<b>$data[counter].</b> <a href=\"member.php?$session[sessionurl]$data[userid]\">$data[username]</a> with $data[posts] posts<br /> <?php
// +-----------------------------------------------------------------------------+
// | devbox_work.php |
// +-----------------------------------------------------------------------------+
// | Written by Christopher Nadeau |
// | - www.DevBox.net, www.DevBoxForums.com [chris@devbox.net] |
// +-----------------------------------------------------------------------------+
// | Copyright 2004 by Christopher Nadeau |
// +-----------------------------------------------------------------------------+
// | RELEASED UNDER THE EvB license: |
// | => Standard Attribution |
// | => Limited Derivs |
// | => Limited Translation |
// | MORE INFO HERE: |
// | => http://www.everythingvb.com/licenses/sa-ld-lt/1.0/ |
// +-----------------------------------------------------------------------------+
// | TABLE OF CONTENTS |
// | 1. CONFIGURATION: Config area, you should edit this area. |
// | |
// | 2. INTERPRETATION: Handles config, you should NOT edit ths area. |
// | |
// | 3. ADV. CONFIGURATION: Edit the SQL to use. You should only edit this |
// | area if you know what your doing. |
// | |
// | 4. SCRIPT: The actual script. You should NOT edit this area. |
// | |
// | 5. MISC: Misc functions. You should NOT edit this area. |
// +-----------------------------------------------------------------------------+

/************************************************** *******************************
1. CONFIGURATION
Each configuration value can be set to 'on', 'off', 1, 0, true or false.
=> 'on' - Activated
=> 'off' - Deactivated
=> 1 - Activated
=> 0 - Deactivated
=> true - Activated
=> false - Deactivated

*_*_num: the number of values to retrieve.

forum_ids: the forumid's of the forums you want to grab the latest threads
from. You can set this to 'auto' to include all forums that the
user has permission to see. Serparate each with a comma. Ex:
- '1,8,19,20'
- 'auto'
************************************************** *******************************/
$devbox_config = array( 'latest_threads' => 'on',
'latest_threads_num' => 10,

'newest_members' => 'on',
'newest_members_num' => 5,

'top_posters' => 'on',
'top_posters_num' => 5,

'online_today' => 'on',

'forum_ids' => 'auto',
);





/************************************************** *******************************
2. INTERPRETATION
This section just interprets the config options, and ensures they're alright.
You should skip this section and go onto #3 if you want.
************************************************** *******************************/
// Ensure all the right numbers are in place
$devbox_config['latest_threads_num'] = (int) $devbox_config['latest_threads_num'];
$devbox_config['newest_members_num'] = (int) $devbox_config['newest_members_num'];
$devbox_config['top_posters_num'] = (int) $devbox_config['top_posters_num'];

// Handle forum id's
if($devbox_config['forum_ids'] == 'auto')
{
$devbox_config['forum_ids'] = array();

foreach(array_keys($forumcache) AS $forumid)
{
$fp = &$bbuserinfo['forumpermissions']["$forumid"];
if ($fp & CANVIEW AND $fp & CANVIEWOTHERS)
{
$devbox_config['forum_ids'][] = $forumid;
}
}

$devbox_config['forum_ids'] = implode(',', $devbox_config['forum_ids']);
unset($fp);
}

$TP = TABLE_PREFIX;





/************************************************** *******************************
3. ADVANCED CONFIGURATION
These config values define what SQL should be used to grab the info from the
database. Don't touch these if you don't know what your doing! You have
to change these if you want information other then what is already
provided. Use the variable $TP for table prefix if you don't want to get out
of the quotes.
************************************************** ********************************/
$devbox_config['latest_threads_sql'] = "### devbox_work.php - grabbing latest threads ###
SELECT
t.threadid, t.title, t.replycount, t.views, t.lastposter, t.postusername, t.postuserid,
f.forumid, f.title AS forumtitle
FROM
{$TP}thread t,
{$TP}forum f
LEFT JOIN {$TP}deletionlog AS del ON (del.primaryid = t.threadid AND del.type = 'thread')
WHERE
f.forumid = t.forumid
AND f.forumid IN({$devbox_config['forum_ids']})
AND t.visible = 1
AND del.primaryid IS NULL
ORDER BY t.threadid DESC
LIMIT {$devbox_config['latest_threads_num']}";


$devbox_config['newest_members_sql'] = "### devbox_work.php - grabbing newest members ###
SELECT
u.userid, u.username, u.joindate, u.posts,
g.opentag, g.closetag
FROM
{$TP}user u,
{$TP}usergroup g
WHERE
g.usergroupid = u.usergroupid
ORDER BY u.userid DESC
LIMIT {$devbox_config['newest_members_num']}";

$devbox_config['top_posters_sql'] = "### devbox_work.php - grabbing top posters ###
SELECT
u.userid, u.username, u.posts,
g.opentag, g.closetag
FROM
{$TP}user u,
{$TP}usergroup g
WHERE
g.usergroupid = u.usergroupid
ORDER BY u.posts DESC
LIMIT {$devbox_config['top_posters_num']}";

$devbox_config['online_today_sql'] = "### devbox_work.php - grabbing online today ###
SELECT
u.userid, u.username, (u.options & {$_USEROPTIONS['invisible']}) AS invisible,
g.opentag, g.closetag
FROM
{$TP}user u,
{$TP}usergroup g
WHERE
g.usergroupid = u.usergroupid AND
u.lastactivity >= " . (mktime(0, 0, 0) + (($bbuserinfo['timezoneoffset'] - $vboptions['timeoffset']) * 3600)) . "
ORDER BY u.username ASC";





/************************************************** *******************************
4. SCRIPT
You shouldn't need to edit anything below this!
************************************************** *******************************/

$devbox = array('latest_threads' => '',
'newest_members' => '',
'online_today' => '',
'top_posters' => '',
);

//--------------------------------------------------------------------------------
// Grab the 'latest threads'
if(isOn('latest_threads'))
{
$devbox_latest_threads = $DB_site->query($devbox_config['latest_threads_sql']);
$devbox_config['latest_threads_num'] = $DB_site->num_rows($devbox_latest_threads);
$devbox_counter = 0;

if($devbox_config['latest_threads_num'] < 1)
{
$devbox['latest_threads'] = 'No threads.';
}

else
{
while($data = $DB_site->fetch_array($devbox_latest_threads))
{
$data['counter'] = ++$devbox_counter;
eval('$devbox[\'latest_threads\'] .= "' . fetch_template('devbox-latest_threads_bit') . '";');
}
}

$DB_site->free_result($devbox_latest_threads);
unset($devbox_latest_threads, $devbox_counter, $data);
}

//--------------------------------------------------------------------------------
// Grab the 'lastest members'
if(isOn('newest_members'))
{
$devbox_newest_members = $DB_site->query($devbox_config['newest_members_sql']);
$devbox_config['newest_members_num'] = $DB_site->num_rows($devbox_newest_members);
$devbox_counter = 0;

while($data = $DB_site->fetch_array($devbox_newest_members))
{
$data['counter'] = ++$devbox_counter;
$data['date'] = vbdate($vboptions['dateformat'], $data['joindate'], false, true, false);
eval('$devbox[\'newest_members\'] .= "' . fetch_template('devbox-newest_members_bit') . '";');
}

$DB_site->free_result($devbox_newest_members);
unset($devbox_newest_members, $devbox_counter, $data);
}

//--------------------------------------------------------------------------------
// Grab the 'online today'
if(isOn('online_today'))
{
$devbox_online_today = $DB_site->query($devbox_config['online_today_sql']);
$devbox_counter = 0;

while($data = $DB_site->fetch_array($devbox_online_today))
{
$data['counter'] = ++$devbox_counter;

if($data['invisible'])
{
if(!($permissions['genericpermissions'] & CANSEEHIDDEN))
continue;
else
$data['invisible'] = '*';
}

else
$data['invisible'] = '';

eval('$devbox[\'online_today\'] .= "' . fetch_template('devbox-online_today_bit') . '";');
$devbox['online_today'] .= ', ';
}

$devbox['online_today'] = substr($devbox['online_today'], 0, (strlen($devbox['online_today']) - 3));
$devbox['online_today_num'] = $devbox_counter;

$DB_site->free_result($devbox_online_today);
unset($devbox_online_today, $devbox_counter, $data);

////////////////////

if(!isset($datastore['maxonlinetoday']))
{
$devbox['online_today_max'] = $devbox['online_today_num'];
$devbox['online_today_maxwhen'] = mktime();

$devbox_ot['online_today_max'] = $devbox['online_today_max'];
$devbox_ot['online_today_maxwhen'] = $devbox['online_today_maxwhen'];
$devbox_ot = serialize($devbox_ot);

$DB_site->query("### devbox_work.php - insert online today into datastore ###
INSERT INTO {$TP}datastore (title, data) VALUES ('maxonlinetoday', '$devbox_ot')");
}

else
{
$devbox_ot = unserialize($datastore['maxonlinetoday']);
if($devbox_ot['online_today_max'] < $devbox['online_today_num'])
{
$devbox['online_today_max'] = $devbox['online_today_num'];
$devbox['online_today_maxwhen'] = mktime();

$devbox_ot['online_today_max'] = $devbox['online_today_max'];
$devbox_ot['online_today_maxwhen'] = $devbox['online_today_maxwhen'];
$devbox_ot = serialize($devbox_ot);

$DB_site->query("### devbox_work.php - update online today ###
UPDATE {$TP}datastore SET data='$devbox_ot' WHERE title='maxonlinetoday'");
}

else
{
$devbox['online_today_max'] = $devbox_ot['online_today_max'];
$devbox['online_today_maxwhen'] = $devbox_ot['online_today_maxwhen'];
}
}

$devbox['online_today_maxwhen'] = vbdate($vboptions['dateformat'], $devbox['online_today_maxwhen'], true, true, false);
unset($devbox_it);
}

//--------------------------------------------------------------------------------
// Grab the 'top posters'
if(isOn('top_posters'))
{
$devbox_top_posters = $DB_site->query($devbox_config['top_posters_sql']);
$devbox_config['top_posters_num'] = $DB_site->num_rows($devbox_top_posters);
$devbox_counter = 0;

while($data = $DB_site->fetch_array($devbox_top_posters))
{
$data['counter'] = ++$devbox_counter;
eval('$devbox[\'top_posters\'] .= "' . fetch_template('devbox-top_posters_bit') . '";');
}

$DB_site->free_result($devbox_top_posters);
unset($devbox_top_posters, $devbox_counter, $data);
}





/************************************************** *******************************
5. MISC
Misc functions. You shouldnt edit this area.
************************************************** *******************************/
// check if config value to see if we should do something or not
function isOn($what)
{
global $devbox_config;

if(!isset($devbox_config["$what"]))
return false;

$val = $devbox_config["$what"];

if(is_string($val))
$val = strtolower($val);

if($val === 'on' OR $val === 1 OR $val === true)
{
$devbox_config["$what"] = true;
return true;
}
else
{
$devbox_config["$what"] = false;
return false;
}
}

?> The boxes are on the side but it did not remove the default ones at the bottom and they are not updating but they do look like they are supposed to, I posted all I thought was needed any help would be great. Here is a link to my site if you need to look at it. http://www.bedrocksoriginaltavern.com/forums/index.php?

Crazy Serb 12-03-2005 03:54 AM

Quote:

Originally Posted by 2HostMe
Is there someone how get it work with version v3.5 ?
A reinstall in 3.5 don't work.

yeah, is there anything similar to this for version 3.5?

Oleks 04-16-2006 04:54 PM

Quote:

Originally Posted by sirblack
Hi duno if any one has had this i installed the hack as the instrutions said and leaft every thing default all installed fine said it was ok but its not there and not showing in admin cp ither any idears guys

all the best sirblack

Hi,
I have the same problem. :cross-eyed:
It's supposed to be at the bottom. But, there is no box at all. :tired:

Where to look and to check?


All times are GMT. The time now is 05:41 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01380 seconds
  • Memory Usage 1,805KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete