vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Statistics Modifications - Cyb - Advanced Forum Statistics (https://vborg.vbsupport.ru/showthread.php?t=177778)

Megatr 05-29-2008 03:52 AM

Hi again ;

http://www.vbulletin.com/forum/showthread.php?t=271187

vbulletin.com said that write to vbulletin.org but you dont help me about 6 times

I have Problem with Topx ( Cyb Forum Statistic 5.8 )

But problem just my forum

Other forum on this server running with TopX perfectly

Before I use 3.6.8 ı didn't problem with topX

After upgrade 3.6.10 and 3.7.0 I have problem with topx now

When Enabled Product topX Everythink OK

But When Enabled "Latest Post" This Query Running long time

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las

And Page loading 10-12 second After server load 6-15-20-25-30 ... etc.

http://img352.imageshack.us/img352/1906/47986465yz1.jpg

http://img144.imageshack.us/img144/5848/65598996xm6.jpg


And i used this command on phpmyadmin 6-7 Months ago

this command problem for me ?

Code:

ALTER TABLE `adminhelp` CHANGE `adminhelpid` `adminhelpid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `adminlog` CHANGE `adminlogid` `adminlogid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `announcement` CHANGE `announcementid` `announcementid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `attachment` CHANGE `attachmentid` `attachmentid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `attachmentpermission` CHANGE `attachmentpermissionid` `attachmentpermissionid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `avatar` CHANGE `avatarid` `avatarid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `bbcode` CHANGE `bbcodeid` `bbcodeid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `calendar` CHANGE `calendarid` `calendarid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `calendarcustomfield` CHANGE `calendarcustomfieldid` `calendarcustomfieldid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `calendarmoderator` CHANGE `calendarmoderatorid` `calendarmoderatorid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `calendarpermission` CHANGE `calendarpermissionid` `calendarpermissionid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cron` CHANGE `cronid` `cronid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cronlog` CHANGE `cronlogid` `cronlogid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `event` CHANGE `eventid` `eventid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `forum` CHANGE `forumid` `forumid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `forumpermission` CHANGE `forumpermissionid` `forumpermissionid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `holiday` CHANGE `holidayid` `holidayid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `icon` CHANGE `iconid` `iconid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `infraction` CHANGE `infractionid` `infractionid` INT ( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `infractionban` CHANGE `infractionbanid` `infractionbanid` INT ( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `infractiongroup` CHANGE `infractiongroupid` `infractiongroupid` INT ( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `infractionlevel` CHANGE `infractionlevelid` `infractionlevelid` INT ( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `imagecategory` CHANGE `imagecategoryid` `imagecategoryid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `language` CHANGE `languageid` `languageid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `mailqueue` CHANGE `mailqueueid` `mailqueueid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `moderator` CHANGE `moderatorid` `moderatorid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `moderatorlog` CHANGE `moderatorlogid` `moderatorlogid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `paymentapi` CHANGE `paymentapiid` `paymentapiid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `paymentinfo` CHANGE `paymentinfoid` `paymentinfoid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `paymenttransaction` CHANGE `paymenttransactionid` `paymenttransactionid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `phrase` CHANGE `phraseid` `phraseid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `plugin` CHANGE `pluginid` `pluginid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `pm` CHANGE `pmid` `pmid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `pmtext` CHANGE `pmtextid` `pmtextid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `poll` CHANGE `pollid` `pollid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `pollvote` CHANGE `pollvoteid` `pollvoteid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `post` CHANGE `postid` `postid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `productcode` CHANGE `productcodeid` `productcodeid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `productdependency` CHANGE `productdependencyid` `productdependencyid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `profilefield` CHANGE `profilefieldid` `profilefieldid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `ranks` CHANGE `rankid` `rankid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `reminder` CHANGE `reminderid` `reminderid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `reputation` CHANGE `reputationid` `reputationid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `reputationlevel` CHANGE `reputationlevelid` `reputationlevelid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `rssfeed` CHANGE `rssfeedid` `rssfeedid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `search` CHANGE `searchid` `searchid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `smilie` CHANGE `smilieid` `smilieid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `style` CHANGE `styleid` `styleid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `subscribeevent` CHANGE `subscribeeventid` `subscribeeventid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `subscribeforum` CHANGE `subscribeforumid` `subscribeforumid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `subscribethread` CHANGE `subscribethreadid` `subscribethreadid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `subscription` CHANGE `subscriptionid` `subscriptionid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `subscriptionlog` CHANGE `subscriptionlogid` `subscriptionlogid` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `subscriptionpermission` CHANGE `subscriptionpermissionid` `subscriptionpermissionid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `template` CHANGE `templateid` `templateid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `templatehistory` CHANGE `templatehistoryid` `templatehistoryid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `thread` CHANGE `threadid` `threadid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `threadrate` CHANGE `threadrateid` `threadrateid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `upgradelog` CHANGE `upgradelogid` `upgradelogid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `user` CHANGE `userid` `userid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `useractivation` CHANGE `useractivationid` `useractivationid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `usergroup` CHANGE `usergroupid` `usergroupid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `usergroupleader` CHANGE `usergroupleaderid` `usergroupleaderid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `usergrouprequest` CHANGE `usergrouprequestid` `usergrouprequestid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `usernote` CHANGE `usernoteid` `usernoteid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `usertitle` CHANGE `usertitleid` `usertitleid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `userpromotion` CHANGE `userpromotionid` `userpromotionid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `word` CHANGE `wordid` `wordid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;


sebaldus 05-29-2008 04:25 AM

:) Great hacks, thanks..
Installed..

just77me 05-29-2008 10:15 AM

Any solution available? for the problem with the big box in IE? i cant use this plugin because of this problem...

brasolino 05-29-2008 10:59 AM

i have installed the 5.8.1 on Vbulletin 3.6.10: the products seems works fine but the ADMINISTRATOR of the board DON'T SEE the TOP STATS [all others users view it normally]: any suggestions ?

Valter 05-29-2008 07:56 PM

Megatr,

Sorry, I really don't know what causes that problem.

fateL 05-29-2008 11:35 PM

my latest posts column shows no results. any fix for this? it happened suddenly, I upgraded the hack yesterday and it was fine for hours after, logged in today and found it empty.

Megatr 05-30-2008 05:44 AM

Quote:

Originally Posted by Cybernetec (Post 1535527)
Megatr,

Sorry, I really don't know what causes that problem.

I can send PM cPanel login - admin login - ssh login - or what do you want...

But the problem just my db other vB forums in this server running this hack and page loading 1 second when I enabled Query running 8-10 second

Sakai Ray 06-01-2008 05:08 AM

I got a question after installing it somehow when I click anything on the stats it says server can't be found at all.

Talaturen 06-01-2008 09:12 AM

Hello Cybernetec.
Seeing that you recently implented support for the latest blog entries (vBulletin Blog). I'd like to suggest Latest Bug Reports, Latest Feature Requests and Latest Tasks which should work with vBulletin Project Tools for the next version.

By the way, good job with this plugin, been using it for a long time now :).

Thanks for atleast reading my post,
Talaturen.

djlotus 06-01-2008 05:12 PM

Thanks

avensat 06-01-2008 06:37 PM

Quote:

Originally Posted by just77me (Post 1534906)
Any solution available? for the problem with the big box in IE? i cant use this plugin because of this problem...

After a good looking on the code of the "cyb_topstats_stats" template I have removed some values of the <tr> tags.

Save the code of your template "cyb_topstats_stats" on a text application and change for this:
Code:

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
                <thead>
                        <tr valign="top">
                                <td class="tcat" <if condition="($cybtopstats_t_colspan>'1')">colspan="$cybtopstats_t_colspan"</if>><a name="cyb_stats" style="float:$stylevar[right]" href="#top" onClick="return toggle_collapse('cyb_fh_stats')"><img id="collapseimg_cyb_fh_stats" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_cyb_fh_stats].gif" alt="" border="0" /></a>
                                <if condition="$bbuserinfo[userid]">
                                        <span id="cybstatsoptions"><phrase 1="$resultsnr">$vbphrase[cyb_top_x_stats]</phrase> <if condition="$cybtopstats_timecut_enabled"><span class="smallfont">(<phrase 1="$vboptions[cybtopstats_timecut]">$vbphrase[cyb_last_x_hours]</phrase>)</span></if><script language="Javascript" type="text/javascript"> vbmenu_register("cybstatsoptions"); </script></span>
                                        <div class="vbmenu_popup" id="cybstatsoptions_menu" style="display:none">
                                                <table cellpadding="4" cellspacing="1" border="0">
                                                        <tr valign="top">
                                                                <td class="thead">$vbphrase[options]</td>
                                                        </tr>
                                                        <if condition="($canviewmore AND ($_REQUEST['do']!='cybstats'))">
                                                                <tr valign="top">
                                                                        <td class="vbmenu_option" title="<phrase 1="$resultsnr">$vbphrase[cyb_afs_more_stats]</phrase>"><a href="$vboptions[bburl]/misc.php?$session[sessionurl]do=cybstats" rel="nofollow"><phrase 1="$resultsnr">$vbphrase[cyb_afs_more_stats]</phrase></a></td>
                                                                </tr>
                                                        </if>
                                                        <if condition="$cybstats_show">
                                                                <tr valign="top">
                                                                        <td class="vbmenu_option" title="$vbphrase[cyb_afs_turnoff_stats]"><a href="$vboptions[bburl]/misc.php?$session[sessionurl]do=disablestats" rel="nofollow">$vbphrase[cyb_afs_turnoff_stats]</a></td>
                                                                </tr>
                                                        </if>               
                                                </table>
                                        </div>
                                <else />
                                        <phrase 1="$resultsnr">$vbphrase[cyb_top_x_stats]</phrase>
                                </if>
                                </td>
                        </tr>
                </thead>
                <tbody id="collapseobj_cyb_fh_stats" style="$vbcollapse[collapseobj_cyb_fh_stats]">
                        <tr valign="top">
                                <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>" <if condition="($vboptions[cybtopstats_layout]=='2')">rowspan="4"<else />rowspan="2"</if> style="width:1px;height:$cybnpheight;max-height:$cybnpheight;display:none;"></td>
                                <if condition="($vboptions[cybtopstats_switch_latestposts]=='1')">
                                        <td class="thead" align="$stylevar[left]" nowrap="nowrap">$vbphrase[cyb_latest_posts]</td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s1]>'0')">
                                        <td class="thead" align="$stylevar[left]" nowrap="nowrap">$cyb_topstats_s1t</td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s3]>'0')">
                                        <td class="thead" align="$stylevar[left]" nowrap="nowrap">$cyb_topstats_s3t</td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s5]>'0')">
                                        <td class="thead" align="$stylevar[left]" nowrap="nowrap">$cyb_topstats_s5t</td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s7]>'0')">
                                        <td class="thead" align="$stylevar[left]" nowrap="nowrap">$cyb_topstats_s7t</td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s9]>'0')">
                                        <td class="thead" align="$stylevar[left]" nowrap="nowrap">$cyb_topstats_s9t</td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_latestposts]=='2')">
                                        <td class="thead" align="$stylevar[left]" nowrap="nowrap">$vbphrase[cyb_latest_posts]</td>
                                </if>
                        </tr>
                        <tr valign="top">
                                <if condition="($vboptions[cybtopstats_switch_latestposts]=='1')">
                                        <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>" <if condition="($vboptions[cybtopstats_layout]=='2')">rowspan="3"</if> style="height:$cybnpheight;max-height:$cybnpheight;">
                                                <table width="100%" cellpadding="0" cellspacing="0" border="0" style="height:<if condition="(THIS_SCRIPT!='misc')">100%<else />1%</if>" id="cybnp">
                                                        <tr valign="top">
                                                                <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">$vbphrase[thread]</td>
                                                                <td>&nbsp;</td>
                                                                <if condition="$vboptions[cybtopstats_lastpost_dateline]">
                                                                        <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">&nbsp;$vbphrase[date], $vbphrase[time]</td>
                                                                </if>
                                                                <if condition="$vboptions[cybtopstats_lastpost_poster]">
                                                                        <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">&nbsp;$vbphrase[posted_by]</td>
                                                                </if>
                                                                <if condition="($vboptions[cybtopstats_lastpost_rvcounts]=='1') OR ($vboptions[cybtopstats_lastpost_rvcounts]=='3')">
                                                                        <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">&nbsp;$vbphrase[replies]</td>
                                                                </if>
                                                                <if condition="($vboptions[cybtopstats_lastpost_rvcounts]=='2') OR ($vboptions[cybtopstats_lastpost_rvcounts]=='3')">
                                                                        <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">&nbsp;$vbphrase[views]</td>
                                                                </if>
                                                                <if condition="$vboptions[cybtopstats_lastpost_forums]">
                                                                        <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">&nbsp;&nbsp;$vbphrase[forum]</td>
                                                                </if>
                                                        </tr>
                                                        $cybtopstats_newposts
                                                </table>
                                        </td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s1]>'0')">
                                        <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>">
                                                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                                                        <if condition="($vboptions[cybtopstats_layout]=='1')">
                                                        <tr valign="top">
                                                                <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">$cyb_topstats_s1p1</td>
                                                                <td align="$stylevar[right]" nowrap="nowrap" class="smallfont">$cyb_topstats_s1p2</td>
                                                        </tr>
                                                        </if>
                                                        $cyb_topstats_s1
                                                </table>
                                        </td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s3]>'0')">
                                        <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>">
                                                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                                                        <if condition="($vboptions[cybtopstats_layout]=='1')">
                                                        <tr valign="top">
                                                                <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">$cyb_topstats_s3p1</td>
                                                                <td align="$stylevar[right]" nowrap="nowrap" class="smallfont">$cyb_topstats_s3p2</td>
                                                        </tr>
                                                        </if>
                                                        $cyb_topstats_s3
                                                </table>
                                        </td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s5]>'0')">
                                        <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>">
                                                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                                                        <if condition="($vboptions[cybtopstats_layout]=='1')">
                                                        <tr valign="top">
                                                                <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">$cyb_topstats_s5p1</td>
                                                                <td align="$stylevar[right]" nowrap="nowrap" class="smallfont">$cyb_topstats_s5p2</td>
                                                        </tr>
                                                        </if>
                                                        $cyb_topstats_s5
                                                </table>
                                        </td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s7]>'0')">
                                        <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>">
                                                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                                                        <if condition="($vboptions[cybtopstats_layout]=='1')">
                                                        <tr valign="top">
                                                                <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">$cyb_topstats_s7p1</td>
                                                                <td align="$stylevar[right]" nowrap="nowrap" class="smallfont">$cyb_topstats_s7p2</td>
                                                        </tr>
                                                        </if>
                                                        $cyb_topstats_s7
                                                </table>
                                        </td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s9]>'0')">
                                        <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>">
                                                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                                                        <if condition="($vboptions[cybtopstats_layout]=='1')">
                                                        <tr style="">
                                                                <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">$cyb_topstats_s9p1</td>
                                                                <td align="$stylevar[right]" nowrap="nowrap" class="smallfont">$cyb_topstats_s9p2</td>
                                                        </tr>
                                                        </if>
                                                        $cyb_topstats_s9
                                                </table>
                                        </td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_latestposts]=='2')">
                                        <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>" <if condition="($vboptions[cybtopstats_layout]=='2')">rowspan="3"</if> style="height:$cybnpheight;max-height:$cybnpheight;">
                                                <table width="100%" cellpadding="0" cellspacing="0" border="0" style="height:100%" id="cybnp">
                                                        <tr valign="top">
                                                                <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">$vbphrase[thread]</td>
                                                                <td>&nbsp;</td>
                                                                <if condition="$vboptions[cybtopstats_lastpost_dateline]">
                                                                        <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">&nbsp;$vbphrase[date], $vbphrase[time]</td>
                                                                </if>
                                                                <if condition="$vboptions[cybtopstats_lastpost_poster]">
                                                                        <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">&nbsp;$vbphrase[posted_by]</td>
                                                                </if>
                                                                <if condition="($vboptions[cybtopstats_lastpost_rvcounts]=='1') OR ($vboptions[cybtopstats_lastpost_rvcounts]=='3')">
                                                                        <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">&nbsp;$vbphrase[replies]</td>
                                                                </if>
                                                                <if condition="($vboptions[cybtopstats_lastpost_rvcounts]=='2') OR ($vboptions[cybtopstats_lastpost_rvcounts]=='3')">
                                                                        <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">&nbsp;$vbphrase[views]</td>
                                                                </if>
                                                                <if condition="$vboptions[cybtopstats_lastpost_forums]">
                                                                        <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">&nbsp;&nbsp;$vbphrase[forum]</td>
                                                                </if>
                                                        </tr>
                                                        $cybtopstats_newposts
                                                </table>
                                        </td>
                                </if>
                        </tr>
                <if condition="($vboptions[cybtopstats_layout]=='2')">
                        <tr valign="top">
                                <if condition="($vboptions[cybtopstats_switch_s2]>'0')">
                                        <td class="thead" align="$stylevar[left]" nowrap="nowrap">$cyb_topstats_s2t</td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s4]>'0')">
                                        <td class="thead" align="$stylevar[left]" nowrap="nowrap">$cyb_topstats_s4t</td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s6]>'0')">
                                        <td class="thead" align="$stylevar[left]" nowrap="nowrap">$cyb_topstats_s6t</td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s8]>'0')">
                                        <td class="thead" align="$stylevar[left]" nowrap="nowrap">$cyb_topstats_s8t</td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s10]>'0')">
                                        <td class="thead" align="$stylevar[left]" nowrap="nowrap">$cyb_topstats_s10t</td>
                                </if>
                        </tr>
                        <tr valign="top">
                                <if condition="($vboptions[cybtopstats_switch_s2]>'0')">
                                        <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>">
                                                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                                                        <if condition="($vboptions[cybtopstats_layout]=='1')">
                                                        <tr valign="top">
                                                                <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">$cyb_topstats_s2p1</td>
                                                                <td align="$stylevar[right]" nowrap="nowrap" class="smallfont">$cyb_topstats_s2p2</td>
                                                        </tr>
                                                        </if>
                                                        $cyb_topstats_s2
                                                </table>
                                        </td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s4]>'0')">
                                        <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>">
                                                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                                                        <if condition="($vboptions[cybtopstats_layout]=='1')">
                                                        <tr valign="top">
                                                                <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">$cyb_topstats_s4p1</td>
                                                                <td align="$stylevar[right]" nowrap="nowrap" class="smallfont">$cyb_topstats_s4p2</td>
                                                        </tr>
                                                        </if>
                                                        $cyb_topstats_s4
                                                </table>
                                        </td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s6]>'0')">
                                        <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>">
                                                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                                                        <if condition="($vboptions[cybtopstats_layout]=='1')">
                                                        <tr valign="top">
                                                                <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">$cyb_topstats_s6p1</td>
                                                                <td align="$stylevar[right]" nowrap="nowrap" class="smallfont">$cyb_topstats_s6p2</td>
                                                        </tr>
                                                        </if>
                                                        $cyb_topstats_s6
                                                </table>
                                        </td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s8]>'0')">
                                        <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>">
                                                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                                                        <if condition="($vboptions[cybtopstats_layout]=='1')">
                                                        <tr valign="top">
                                                                <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">$cyb_topstats_s8p1</td>
                                                                <td align="$stylevar[right]" nowrap="nowrap" class="smallfont">$cyb_topstats_s8p2</td>
                                                        </tr>
                                                        </if>
                                                        $cyb_topstats_s8
                                                </table>
                                        </td>
                                </if>
                                <if condition="($vboptions[cybtopstats_switch_s10]>'0')">
                                        <td class="<if condition="($vboptions[cybtopstats_tablebg]=='1')">alt1<else />alt2</if>">
                                                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                                                        <if condition="($vboptions[cybtopstats_layout]=='1')">
                                                        <tr valign="top">
                                                                <td align="$stylevar[left]" nowrap="nowrap" class="smallfont">$cyb_topstats_s10p1</td>
                                                                <td align="$stylevar[right]" nowrap="nowrap" class="smallfont">$cyb_topstats_s10p2</td>
                                                        </tr>
                                                        </if>
                                                        $cyb_topstats_s10
                                                </table>
                                        </td>
                                </if>
                        </tr>
                </if>       
                </tbody>
        </table>
        <br />


Sakai Ray 06-01-2008 07:15 PM

Nevermind I corrected my error.

Astrof 06-01-2008 07:50 PM

This a wonderful hack, definitely one of the most useful mods I've tried, but I have a question:

On the latest posts list, the yellow icon remains displayed and doesn't change to grey even after the post has been read. Only after a while does it turn grey, even if the post hasn't been read by the user.

Is this a normal thing to happen and is there a way to change it in order for the icons to change as soon as the post has been read by the user and not change until it has been read?

Thanks a lot in advance.

Megatr 06-02-2008 04:32 AM

Quote:

Originally Posted by Megatr (Post 1535933)
I can send PM cPanel login - admin login - ssh login - or what do you want...

But the problem just my db other vB forums in this server running this hack and page loading 1 second when I enabled Query running 8-10 second

Cybernetec ?

ChopBam 06-02-2008 05:50 AM

I'd like to know if a certain feature is possible.

I'd like to be able to have only a few things on the forumhome (latest news, latest blog entries, and latest posts only), but be able to have all the rest of the stats available on the special stats page you can open up.

g0dfather1984 06-02-2008 06:02 AM

Thank you!

katie hunter 06-02-2008 08:45 PM

Hi, how many queries does this mod generates ?

ALil'Hope 06-02-2008 11:15 PM

Installed and working fine on my vBulletin 3.7.1.

VanDaMe 06-03-2008 03:13 AM

marked installed :)

Terrasoft 06-03-2008 04:02 AM

Since I didnt really feel like going through all those pages, I apologize in advance for asking this question if it has been answered already. Is there a way to make it so it shows newest threads? In parallel to latest posts?

rickson7 06-03-2008 02:41 PM

Hello Cybernetec and all the rest,

I have disabled LATEST posts because my STYLE is fixed and that other column causes a problem. So - Can I put latest posts in a NEW ROW ???

That's a very important Statistic : )
BTW - Congrats on your great work on so many mods.
This one is among the VERY BEST !
I love it.

andreamarucci 06-04-2008 11:32 AM

Everything works but there is a little annoyance. Every time I click on a thread from the table of statistics, vbulletin ask me to login again but I'm yet logged in. I've updated to the last version just to see if this is solved but with no results.

If I click anywhere I go without problems, but if I clik on any link (new users, new thread, etc.) vb ask me to login again...

slmoney 06-04-2008 12:21 PM

I'm having an issue with this Modification.

I upgraded my forum to VB 3.7.1. This Mod does not work well with it.

What happens? When you go to a thread that has more than 1 page, you cannot get past the first page when this Mod is enabled. When it is disabled, everything on my forum works.

Any idea why it would affect viewing threads?

And yes, I know it is this Mod that is affecting my forum this way. I uninstalled EVERY product/plugin and added them all back 1 by 1. After this one was added is when I found the issue of not being able to go to page 2 of a thread.

Valter 06-04-2008 02:21 PM

Quote:

Originally Posted by andreamarucci (Post 1540519)
Everything works but there is a little annoyance. Every time I click on a thread from the table of statistics, vbulletin ask me to login again but I'm yet logged in. I've updated to the last version just to see if this is solved but with no results.

If I click anywhere I go without problems, but if I clik on any link (new users, new thread, etc.) vb ask me to login again...

vBulletin Options > Cookies and HTTP Header Options > Cookie Domain

Set this to suggested value (".yoursite.xyz"). When you log-out/re-log-in problem will gone.

Also ensure that setting "Forum URL" in "Site Name / URL / Contact Details" is properly set.

AdrianH 06-04-2008 04:07 PM

Quote:

Originally Posted by slmoney (Post 1540560)
I'm having an issue with this Modification.

I upgraded my forum to VB 3.7.1. This Mod does not work well with it.

What happens? When you go to a thread that has more than 1 page, you cannot get past the first page when this Mod is enabled. When it is disabled, everything on my forum works.

Any idea why it would affect viewing threads?

And yes, I know it is this Mod that is affecting my forum this way. I uninstalled EVERY product/plugin and added them all back 1 by 1. After this one was added is when I found the issue of not being able to go to page 2 of a thread.


This is not a problem on my forum with this mod installed.

slmoney 06-04-2008 04:19 PM

Thanks....wanted to read that.

paco58 06-04-2008 05:41 PM

Hello

I have a problem with the date, if I put it in English it(he,she) is OK, but if I put it in Spanish not.

I need help

Thank you

You excuse for a translator uses

Best regards

vBulletin 3.7.1

andreamarucci 06-04-2008 08:04 PM

Quote:

Originally Posted by Cybernetec (Post 1540649)
vBulletin Options > Cookies and HTTP Header Options > Cookie Domain

Set this to suggested value (".yoursite.xyz"). When you log-out/re-log-in problem will gone.

Suggested value is BLANK. Please note that I don't have another url for the forum. My url has always been www.mydomain.it/forum and never changed. I've noticed this behaviour once upgaded the forum to 3.7. With 3.6.8 everything was working.

Quote:

Originally Posted by Cybernetec (Post 1540649)
Also ensure that setting "Forum URL" in "Site Name / URL / Contact Details" is properly set.

Forum URL is set as before http://www.mydomain.it/forum

I've also noticed that the url of the links in AFS is pointing to

http://www.mydomain.it/forum/showthread.php?t=4778

and clicking on the threads or post, the url become

http://mydomain.it/forum/showthread.php?t=4778

without www.

The fact is that if I copy and paste the URL, the one without www work correctly and the other one ask me to login again.

Where is the problem? Where I've to look at?

Thanks again

andreamarucci 06-04-2008 08:21 PM

an update. My forum works with www.mydomain.it/forum and mydomain.it/forum. Fact is that if I go to the forum typing www.mydomain.it/forum, AFS works well and don't ask me to login, instead if I o to the forum typing mydomain.it/forum, every time I click on an AFS link, it ask me to login.

I don't know if this help you...

Valter 06-04-2008 08:56 PM

I would set "Cookie Domain" to .yoursite.xyz (note the domain begins with a dot).

Be careful when setting this as entering an invalid value can leave you unable to login to your forum.

Log-out/Log-in after updating this setting and check if problem is gone.

dieselpowered 06-05-2008 04:52 AM

I am curious, maybe this has already been asked, however, does this add a lot of extra queries?

Thanks!

Valter 06-05-2008 08:29 AM

Quote:

Originally Posted by xtremeoff-road (Post 1541255)
I am curious, maybe this has already been asked, however, does this add a lot of extra queries?

Thanks!

One query per statistic.

Top Posters = +1 query
Top Thread Starters = +1 query
Latest Posts = +1 query
etc...

Valter 06-05-2008 08:33 AM

Quote:

Originally Posted by Astrof (Post 1538111)
This a wonderful hack, definitely one of the most useful mods I've tried, but I have a question:

On the latest posts list, the yellow icon remains displayed and doesn't change to grey even after the post has been read. Only after a while does it turn grey, even if the post hasn't been read by the user.

Is this a normal thing to happen and is there a way to change it in order for the icons to change as soon as the post has been read by the user and not change until it has been read?

Thanks a lot in advance.

It's actually marked as "new", not "unread" which means it's posted after you last visit. When you mark forums as read (and update "last visit" info in your account) then those icons will change to grey.

furst 06-05-2008 01:32 PM

I want to combine Latest Posts and Latest Blog Entries and have them display on the right side as many sites do with Latest Posts. It would be nice if Latest Photo Comments could also be added to it. That way we could display virtually all activity in one neat little stats box.

paco58 06-06-2008 07:15 AM

Quote:

Originally Posted by paco58 (Post 1540811)
Hello

I have a problem with the date, if I put it in English it(he,she) is OK, but if I put it in Spanish not.


I need help

Thank you

You excuse for a translator uses

Best regards

vBulletin 3.7.1

https://vborg.vbsupport.ru/showpost....&postcount=187


Someone can help me

Thank you

OsideRida06 06-06-2008 07:41 AM

Installed. I have had this for a while, just forgot to post in here. Thanks for the great mod.

dealxa 06-06-2008 10:15 PM

I have problem "Forums excluded from stats (List IDs, separate with commas)"

When I write forum id in here "Forums excluded from stats (List IDs, separate with commas)"

Latest post is empty ???

https://vborg.vbsupport.ru/

SNATCH3R 06-07-2008 06:53 AM

thanks for this..upgraded from 3.6.8 to 3.7....wrks like charm.... :)

baghdad4ever 06-07-2008 05:50 PM

Quote:

Originally Posted by dealxa (Post 1542659)
I have problem "Forums excluded from stats (List IDs, separate with commas)"

When I write forum id in here "Forums excluded from stats (List IDs, separate with commas)"

Latest post is empty ???

https://vborg.vbsupport.ru/



so am i:confused:

SAT2M 06-07-2008 05:59 PM

I have a big froum with many user
www.best2m.org/main.php

I install this hook it take very very high server load


I remove it


All times are GMT. The time now is 02:25 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.01744 seconds
  • Memory Usage 2,013KB
  • 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_code_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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