mYvBindex v3.1

[Yuber]

Hey Tigga, did you ever fdigure out how to make it so Announcements would should up on the vBindex?

[CodeDawg]

OK, I made the changes....it is still only [pulling post from the first FID entered. Which makes sense if the first ID has the # of post I set in the AdminCP.

Tigga, are you sure there isn't a query change that could make it pull one post per forumid? I wish I knew PHP better, but I am truly just learning it, working with it to convert all my site from ColdFusion to PHP...ugh!!

[attroll]

Has anyone tried installing this with Version 3.0.0 Beta 4. I am trying to get it installed with it and keep getting the following error:

Warning: main(./config.php): failed to open stream: No such file or directory in /home/attroll/public_html/forum/admincp/myvb_install.php on line 5

Warning: main(): Failed opening './config.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/attroll/public_html/forum/admincp/myvb_install.php on line 5

Fatal error: Call to undefined function: cpheader() in /home/attroll/public_html/forum/admincp/myvb_install.php on line 6

Can someone help me?

[Tigga]

Yuber - No, I have not had the time to do much at all lately.

CodeDawg - Anything is possible, but there is not an easy way to acomplish what you are trying to do.

attroll - This script will not work with vB3.

[attroll]

Tigga

Are you planning on making it work with vB3?

[Zachery]

07-18-03 at 08:38 PM attroll said this in Post #1505 (https://vborg.vbsupport.ru/showthread.php?postid=418834#post418834)
Tigga

Are you planning on making it work with vB3?


read a few pages back

[P???t?l??k]

This is a very nice mod.
Keep up the good work fellas. :squareeyed:

[XanNemesis]

I'm trying to figure out how to have this script more customized. More specifically adding another newsbits piece but with it's own option's as well as character limiting etc. I'm not advertising the site or anything, but this is what I have so far as redoing the entire myvbindex templates.

www.xhibitreign.com/forums/portal.php

[CodeDawg]

My buddy did this with his site XanNemesis. Basically he copied all the news sections in the index and copied them, changed the variables of news to xxxx and then added the appopriate sections in the admin.

It takes a tad bit of effort, but can be done.

I am working on it for a picture of the day type section.

[Zachery]

Yesterday at 11:54 PM XanNemesis said this in Post #1508 (https://vborg.vbsupport.ru/showthread.php?postid=419883#post419883)
I'm trying to figure out how to have this script more customized. More specifically adding another newsbits piece but with it's own option's as well as character limiting etc. I'm not advertising the site or anything, but this is what I have so far as redoing the entire myvbindex templates.

www.xhibitreign.com/forums/portal.php
nice work, your forums look realy good except that you still have the vb logo there :\

but nice job

[Littlebit]

Tigga,
Will you help me out? I just got the database error:
Too many connections in /home/site/public_html/forums/admin/db_mysql.php on line 40
I can't access my admin...or database at the moment. Can I change something in the db_mysql and upload to temporarily get to the database again and fix this do you think? I'm still waiting to see if its a server thing, but thought to ask you too.

[Zachery]

looks like you have nix load on or sumthing like that, try loggint into the admin panel and change Simultaneous sessions limit to 0 to disable it, can you access your database via phpmyadmin?

[Littlebit]

Hi thanks for replying. It started working again and the server just said it needed restarted. I'm not sure what happened...it was weird. I checked the admin setting you were talking about and it is at 0. :) thanks again :bunny:

[Zachery]

np, always trying to help out :D

your server program might have goen down

[RS25com]

Okie, one more question.

I've got this up and running beautifully at www.rs25.com and have one little request:

Links are created and open with the target="_blank" attribute within the "news" text.

I don't want it to do that; I want it to open all links in the same page.

Is there any way to do that easily?

[Zachery]

it might be how it interprets the vbcode, but im not sure, intresting collection of buttons :\

[RS25com]

I'll do the buttons later, this is a recovered web site from a crash a few weeks ago and they are kinda last on my list.

So, anyone have an idea how to get rid of the target="_blank" attribute in hyperlinks in the forum text?

:banana:

[iJason]

We can we see this hack for Vb3? What would be really cool is to have it for VB3 Beta.. so I dont have to wait 10yrs before they finally go gold..

[Tigga]

RS25com - The links are controlled by vBcode, so if you removed the target="_blank" from the coding it would have any links posted on your forum open in the same window. Your best bet would probably be to create a new vB code to use for links on your homepage. Or, if you don't mind the links opening in the same window, you should be able to open your admin/functions.php file and look for:
return "<a href=\"$righturl\" target=\"_blank\">".str_replace('\"', '"', $hyperlink)."</a>";
Remove the target=\"_blank\" from that code. I haven't tested that but it should work. :)

dreamer - Well you can see somewhat of a vB3 version of the hack running on my site (just upgraded a couple of days ago :D). There is a LOT that is customized for my site at the moment and I still have some options (like the polls) that need to be added back. I've been extremely busy lately and haven't had much time to work on hacks, or a lot of other things I would like to do. I'm sure I'll have a version ready to release by the time vB3 RC is released though. :)

[Zachery]

so, i was right ? cool :D and nice job on your site brian

[Tigga]

Yup, thanks, and check your PMs. :)

[arracing]

Tigga, I need your help bad. I recently upgraded my forums to 2.3.0 and upgraded myvbindex to 3.2.2 and I got sooooo many bugs with all the old hacks i used to have. Basically I will list the problems which most are happening with myvbindex. As you know I have that include file we made a while back. Well as you can see by going to www.ar-racing.com
my polls doesnt work. (It supposed to take a random poll from the poll forum) Also I am having way way too many queries on myvbindex and forums now. My online buddies thing doesnt work. Basically if you have no buddies it works fine but if you have a buddy that is online it doenst show anytihng. Also for some reason my phpadsnew header is not working but my footer is on my forums at www.ar-racing.com/forums
I tried making new invocation code but still nothing. I have no clue why.

Oh back to myvbindex, the new index file right now only require's global. When I try to make it require include and of course the include file requires the global. Then when i try to bring up the page nothing happens. Totally white blank page.

I am lost as to what to do and need your help real bad. Please email me at randy@ar-racing.com or you can reply here or you can instant message me on AIM at TeamRevMA

Thanks,
randy

[Zachery]

you are aware when you upgrade, you need to make new file edits right?

your site seems to be working fine, as a guest
god thats annoyingly bad msuic

[Tigga]

Taken from the F.A.Q ;)

Q. I just upgraded to a new version of vBulletin and now my index page is blank or templates are missing!
A. Upgrading to a new version of vBulletin will remove any templates that were created for mYvBindex with the exception of any that you have customized. To re-install the templates, upload the myvb_install.php file to your forums/admin folder and go to it in your browser. Then select the option to install just the templates.

[Zachery]

hey tigga check your pms?

[arracing]

what if i picked the option to upgrade from 3.1? cause thats what i did?

[Tigga]

Faranth - Already replied. :)

arracing - Run this query through phpMyAdmin first:

DELETE FROM template WHERE title='index_welcometext' OR title='index_buddy_none' OR title='index_polldiscuss' OR title='index_polledit' OR title='index_polloptions' OR title='index_threadbit' OR title='index_welcometext' AND templatesetid='-1';

Then chose the option in the install file to install only the templates and it should fix the problem.

[arracing]

ok cool, I think I can figure out the rest from here. But I still dont understand why I am getting the high query count? Is this normal, 26 for myvbindex and 23 for my forums? With my old setup I know I was somewhere near 10 I thought.

Also tigga, Im not sure what you do for a living, but if I paid you to design websites for me and admin them. Would you do that, and how much is that worth to ya? My business is just starting to take off and by 2005 Iwill need a dedicated web guy who I am looking to hire. I have an entertainment company and we will be getting into many different markets in the future. Right now we are concentrating on the tuner scene.

Thx.

[arracing]

by the way your site is awsome. I was checking it out briefly. I also know that your everywhere helping people so thats why I am asking to see if you want a job. lol

[Zachery]

im not speaking for him but that would probally be failry expensive

[arracing]

Well I am willing to pay what a fair salary is for a web designer. This is if he wanted to be hired that is. Tigga email me about this, instead of replying here if you are interested.

[Tigga]

arracing - The query count does sound high since you don't have some of the more intensive options turned on. Once you have the templates re-installed though it should fix that.
Right now I'm working full time for a web design company, plus I also run a club/rave promotion company. I haven't had that much time to take on extra projects lately, but if you'd like to email me with some more details about the site, what you'd like done, and a timeframe of when/how fast the work needs to be done, then I can let you know if it's something I would be able to do and give you an estimate if so. :)

[iJason]

OMG Tigga I can't wait till it's released.. It's gonna be the first hack I install.. HURRRRRY. Your site looks great too.

[Zachery]

i assume you mean for vb3?

[arracing]

where is that white background coming from that is behind the main logo at the top left. I want it to be that baby blue color. I cannot find which template is calling that white background. Do u know?

Also I re-installed the templates but the query count still remained high.

[Zachery]

two ways to fix this, go to your templates find header. open it and copy it, then go to myvbindex > index_header i think and open that, and paste it in there, that should work

i belive the other is to change the gettemplate function at the top, instead of index_header, change it to header

try the top one first however

[Tigga]

Arracing - You should modify your index_header template as Faranth suggested, but if you copy your normal header be sure to add $bburl in front of each of the links, otherwise they'll be broken. ;)
As far as the queries, if you'd like to put your server in debug mode (Add $debug=1; somewhere in your admin/config.php file), then go to the url http://yoursite.com/index.php?explain=1
If you'll do that and post the results here I'll see what is causing the extra queries.

[Zachery]

im getting rather good with this one :D

[arracing]

I did what you guys said with the headers and it didnt remove the white stripe. The stripe shows up in my forums header anyways, I just dont want it to show on myvbindex page.

Query: SELECT template FROM template WHERE title='options'
Time before: 0.067090034484863
Time after: 0.069048047065735

table type possible_keys key key_len ref rows Extra
template ref title title 30 const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE lastactivity>1059162995 AND sessionhash='dc0592577954f6fe5d940af59f88d8c3' AND (host='68.41.47.235' OR (althash='' AND althash<>'')) AND useragent='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;'
Time before: 0.081784009933472
Time after: 0.082612991333008

table type possible_keys key key_len ref rows Extra
session const PRIMARY PRIMARY 32 const 1

--------------------------------------------------------------------------------

Query: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
Time before: 0.083825945854187
Time after: 0.085193991661072

table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
userfield const PRIMARY PRIMARY 4 const 1

--------------------------------------------------------------------------------

Query: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='1'
Time before: 0.087414979934692
Time after: 0.088251948356628

table type possible_keys key key_len ref rows Extra
style const PRIMARY PRIMARY 2 const 1

--------------------------------------------------------------------------------

Query: SELECT template,title
FROM template
WHERE (title IN ('index','index_header','index_footer','headinclud e','index_welcometext','index_ logincode','index_buddy','index_buddylist','index_ buddypmlink','forumhome_logged inuser','index_online','index_search','index_welco metext_avatar','index_calendar ','index_calendar_todaysevents','index_weather','i ndex_custom1','index_custom2', 'index_stats','index_birthdaybits','index_threadbi t','index_newsbits','index_new s_adminopts','index_news_comments','index_news_com mentnull','index_news_readmore ','index_newsbits_rating','index_newsbits_signatur e','index_newsbits_avatar','in dex_newsbits_sendtofriend','index_newsbits_printab le','showthread_ratingdisplay' ,'index_pollresult','index_polloption_multiple','i ndex_polloption','index_pollop tions','index_pollresults_voted','index_pollresult s_closed','index_pollreview',' index_pollresults','index_polldiscuss','index_poll edit','','gobutton','timezone' ,'username_loggedout','username_loggedin','phpincl ude','headinclude','header','f ooter','forumjumpbit','forumjump','nav_linkoff','n av_linkon','navbar','nav_joine r','pagenav','pagenav_curpage','pagenav_firstlink' ,'pagenav_lastlink','pagenav_n extlink','pagenav_pagelink','pagenav_prevlink','mi crostats')
AND (templatesetid=-1 OR templatesetid=1))
OR (title = 'maxloggedin')
OR (title = 'birthdays')
ORDER BY templatesetid
Time before: 0.089380025863647
Time after: 0.10731399059296

table type possible_keys key key_len ref rows Extra
template range title title 32 131 Using where; Using filesort

--------------------------------------------------------------------------------

Query: update vbstats_counter set count=count+1 where (type='total' and var='hits') or (var='MSIE' and type='browser') or (var='Windows' and type='os')
Time before: 0.1263689994812
Time after: 0.12737095355988

--------------------------------------------------------------------------------

Query: update vbstats_countries set hits = hits+1 where code = 'us'
Time before: 0.12776899337769
Time after: 0.12833797931671

--------------------------------------------------------------------------------

Query: Select date from vbstats_date WHERE date='2003-07-25'
Time before: 0.12861597537994
Time after: 0.12964296340942

table type possible_keys key key_len ref rows Extra
vbstats_date ALL 248 Using where

--------------------------------------------------------------------------------

Query: UPDATE vbstats_date set count = count+1 where date = '2003-07-25'
Time before: 0.13033998012543
Time after: 0.13225495815277

--------------------------------------------------------------------------------

Query: SELECT * FROM usergroup WHERE usergroupid=6
Time before: 0.13749396800995
Time after: 0.13856601715088

table type possible_keys key key_len ref rows Extra
usergroup const PRIMARY PRIMARY 2 const 1

--------------------------------------------------------------------------------

Query: SELECT count(*) AS count FROM post WHERE dateline>='1059152592'
Time before: 0.14228403568268
Time after: 0.35819399356842

table type possible_keys key key_len ref rows Extra
post ALL 26582 Using where

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid='1' AND messageread='0' AND folderid='0'
Time before: 0.35933005809784
Time after: 0.36073505878448

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 45 Using where

--------------------------------------------------------------------------------

Query: SELECT userid,username,invisible,lastactivity,lastvisit FROM user WHERE (user.userid='143' OR user.userid='134' OR user.userid='160' OR user.userid='121' OR user.userid='118') AND lastactivity > 1059162995 AND lastvisit!=lastactivity ORDER BY username
Time before: 0.36296999454498
Time after: 0.36397504806519

table type possible_keys key key_len ref rows Extra
user range PRIMARY PRIMARY 4 5 Using where; Using filesort

--------------------------------------------------------------------------------

Query: SELECT template FROM template WHERE title='index_buddy_none' AND (templatesetid=-1 OR templatesetid=1) ORDER BY templatesetid DESC LIMIT 1
Time before: 0.36498701572418
Time after: 0.36581897735596

table type possible_keys key key_len ref rows Extra
template range title title 32 2 Using where

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity>1059162995
Time before: 0.36761403083801
Time after: 0.36813902854919

table type possible_keys key key_len ref rows Extra
session ALL 3 Using where

--------------------------------------------------------------------------------

Query: SELECT DISTINCT session.userid,username,invisible,usergroupid
FROM session LEFT JOIN user ON (user.userid=session.userid)
WHERE session.userid>0 AND session.lastactivity>1059162995
ORDER BY invisible ASC, username ASC
Time before: 0.36893403530121
Time after: 0.36982703208923

table type possible_keys key key_len ref rows Extra
session ALL 3 Using where; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 session.userid 1

--------------------------------------------------------------------------------

Query: SELECT forumid,canview FROM forumpermission WHERE usergroupid='6'
Time before: 0.37197494506836
Time after: 0.37254595756531

table type possible_keys key key_len ref rows Extra
forumpermission ref ugid_fid ugid_fid 2 const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT forumid,parentid,displayorder FROM forum WHERE displayorder<>0 ORDER BY parentid,displayorder
Time before: 0.37338399887085
Time after: 0.37498998641968

table type possible_keys key key_len ref rows Extra
forum ALL 51 Using where; Using filesort

--------------------------------------------------------------------------------

Query: SELECT thread.pollid, open, threadid, replycount, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters
FROM thread
LEFT JOIN poll ON (thread.pollid=poll.pollid)
WHERE forumid='71' AND thread.pollid!='0' ORDER BY poll.pollid DESC LIMIT 1
Time before: 0.37878203392029
Time after: 0.38135600090027

table type possible_keys key key_len ref rows Extra
thread ref forumid forumid 2 const 12 Using where; Using temporary; Using filesort
poll eq_ref PRIMARY PRIMARY 4 thread.pollid 1

--------------------------------------------------------------------------------

Query: SELECT smilietext,smiliepath FROM smilie
Time before: 0.38301599025726
Time after: 0.38529205322266

table type possible_keys key key_len ref rows Extra
smilie ALL 193

--------------------------------------------------------------------------------

Query: SELECT pollvoteid FROM pollvote WHERE userid='1' AND pollid='92'
Time before: 0.4006199836731
Time after: 0.40136098861694

table type possible_keys key key_len ref rows Extra
pollvote ref userid userid 8 const,const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT
threadid,thread.title,replycount,postusername,post userid,dateline,views,lastpost er,lastpost,thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath
FROM thread
LEFT JOIN icon ON icon.iconid=thread.iconid
WHERE open<>10 ORDER BY lastpost DESC LIMIT 10
Time before: 0.43457794189453
Time after: 0.45274901390076

table type possible_keys key key_len ref rows Extra
thread ALL 2639 Using where; Using filesort
icon eq_ref PRIMARY PRIMARY 2 thread.iconid 1

--------------------------------------------------------------------------------

Query: SELECT thread.threadid,thread.title,replycount,postuserna me,postuserid,thread.dateline, views,thread.iconid,votenum,votetotal,postid,paget ext,allowsmilie,showsignature, signature ,thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath
FROM thread
LEFT JOIN post ON (thread.threadid=post.threadid)
LEFT JOIN user ON (user.userid=post.userid)

LEFT JOIN icon ON icon.iconid=thread.iconid
WHERE forumid='66' AND isnews='Y' AND open<>10
GROUP BY thread.threadid
ORDER BY thread.threadid DESC LIMIT 10
Time before: 0.46166598796844
Time after: 0.46672296524048

table type possible_keys key key_len ref rows Extra
thread ref forumid forumid 2 const 8 Using where; Using temporary; Using filesort
post ref threadid threadid 4 thread.threadid 11 Using where
user eq_ref PRIMARY PRIMARY 4 post.userid 1
icon eq_ref PRIMARY PRIMARY 2 thread.iconid 1

--------------------------------------------------------------------------------

Query: SELECT bbcodetag,bbcodereplacement,twoparams FROM bbcode
Time before: 0.48248398303986
Time after: 0.48327898979187

table type possible_keys key key_len ref rows Extra
bbcode ALL 9

--------------------------------------------------------------------------------

Query: SELECT eventdate,subject,eventid,public FROM calendar_events WHERE eventdate LIKE '2003-07-%' AND ((userid='1' AND public='0') OR (public='1'))
Time before: 0.76708197593689
Time after: 0.76792299747467

table type possible_keys key key_len ref rows Extra
calendar_events ALL userid 12 Using where

--------------------------------------------------------------------------------

Query: SELECT template FROM template WHERE title='index_rotm' AND (templatesetid=-1 OR templatesetid=1) ORDER BY templatesetid DESC LIMIT 1
Time before: 0.77690303325653
Time after: 0.77811396121979

table type possible_keys key key_len ref rows Extra
template range title title 32 2 Using where

--------------------------------------------------------------------------------

Query:
SELECT findword, replaceword, replacementsetid
FROM replacement
WHERE replacementsetid IN(-1, '1')
ORDER BY replacementsetid, replacementid DESC

Time before: 0.79495394229889
Time after: 0.79683399200439

table type possible_keys key key_len ref rows Extra
replacement ALL replacementsetid 56 Using where; Using filesort

--------------------------------------------------------------------------------

Page generated in 0.78423702716827 seconds with 27 queries,
spending 0.28480398654938 doing MySQL queries and 0.4994330406189 doing PHP things.
Query: UPDATE session SET lastactivity=1059163895,location='/index.php?explain=1' WHERE sessionhash='dc0592577954f6fe5d940af59f88d8c3' Time before: 0.82737004756927 Time after: 0.8279869556427
--------------------------------------------------------------------------------
Query: UPDATE user SET lastactivity=1059163895,inforum='0' WHERE userid='1' Time before: 0.82818400859833 Time after: 0.82877898216248

[arracing]

I also noticed that my poll is not picking random polls from the poll menu. And Also in my latest threads, they are taking threads from private forums.

[Zachery]

im not sure if you did, if you copied the header from header and copied it into index_header

it would display your header :P

and take that awful music off your page :\


if you dont want that white stripe, find

<td valign="top" align="left" background="/forums/images/menu_background.gif">
and replace it with <td valign="top" align="left" >


that is on your index_header

[arracing]

white stripe is still their. If I remove the logo the stripe goes away. But once a logo is inserted, it creates that table with the white background it.

I tried what you guys said but nothing has helped yet. I put the code back to the way it was so that is what you are seeing now.

[Tigga]

If you'll add 'index_rotm' and 'index_buddy_none' to the templatesused section at the top of the file, that will remove 2 of the queries. Apparently 4 others are coming from your vBstats hack in your global.php file...


--------------------------------------------------------------------------------

Query: update vbstats_counter set count=count+1 where (type='total' and var='hits') or (var='MSIE' and type='browser') or (var='Windows' and type='os')
Time before: 0.1263689994812
Time after: 0.12737095355988

--------------------------------------------------------------------------------

Query: update vbstats_countries set hits = hits+1 where code = 'us'
Time before: 0.12776899337769
Time after: 0.12833797931671

--------------------------------------------------------------------------------

Query: Select date from vbstats_date WHERE date='2003-07-25'
Time before: 0.12861597537994
Time after: 0.12964296340942

table type possible_keys key key_len ref rows Extra
vbstats_date ALL 248 Using where


--------------------------------------------------------------------------------

Query: UPDATE vbstats_date set count = count+1 where date = '2003-07-25'
Time before: 0.13033998012543
Time after: 0.13225495815277

--------------------------------------------------------------------------------



As for the polls, make sure that you have the poll templates and that you have "RAND" entered for the polls forum id.
The threads from you private forums will only be visible to those who have permission to view them, assuming you have your forum permissions set correctly. ;)

[Zachery]

this should get rid of your white line problem. altho if you like it on your forums it will cause a problem

[arracing]

where is the templates used section? Is it in the global.php file also under start templates

$templatesused.='gobutton,timezone,username_logged out,username_loggedin,phpinclu de,headinclude,header,footer,forumjumpbit,forumjum p,nav_linkoff,nav_linkon,navba r,nav_joiner';
$templatesused.=',pagenav,pagenav_curpage,pagenav_ firstlink,pagenav_lastlink,pag enav_nextlink,pagenav_pagelink,pagenav_prevlink,mi crostats';

[Zachery]

what are you trying to take out?

[arracing]

I figured out the templates thing was in myvbindex.

As far as the polls random thing I am confused. I only want the polls picked at random from the polls forum only. Dont I have to change some code in the myvbindex file for this?

[Zachery]

no idea on my part, as far as i know its not a built in thing :\

[arracing]

Also here is the explain thing for my forums, can you show me how to get rid of some queries their?

Query: SELECT template FROM template WHERE title='options'
Time before: 0.07497501373291
Time after: 0.07695198059082

table type possible_keys key key_len ref rows Extra
template ref title title 30 const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE lastactivity>1059168462 AND sessionhash='91adba9914cb16019f205696dda10b35' AND (host='68.41.47.235' OR (althash='' AND althash<>'')) AND useragent='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;'
Time before: 0.09148097038269
Time after: 0.092326998710632

table type possible_keys key key_len ref rows Extra
session const PRIMARY PRIMARY 32 const 1

--------------------------------------------------------------------------------

Query: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
Time before: 0.093616008758545
Time after: 0.095041990280151

table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
userfield const PRIMARY PRIMARY 4 const 1

--------------------------------------------------------------------------------

Query: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='1'
Time before: 0.097440004348755
Time after: 0.098170042037964

table type possible_keys key key_len ref rows Extra
style const PRIMARY PRIMARY 2 const 1

--------------------------------------------------------------------------------

Query: SELECT template,title
FROM template
WHERE (title IN ('forumhome_birthdaybit','error_nopermission','for umhome_pmloggedin','forumhome_ welcometext','forumhome_logoutcode','forumhome_new posts','forumhome_todayposts', 'forumhome_logincode','forumhome_loggedinuser','fo rumhome_loggedinusers','forumh ome_lastpostby','forumhome_moderator','forumhome_f orumbit_level1_nopost','forumh ome_forumbit_level1_post','forumhome_forumbit_leve l2_nopost','forumhome_forumbit _level2_post','forumhome','forumhome_unregmessage' ,'index_rotm','index_buddy_non e','gobutton','timezone','username_loggedout','use rname_loggedin','phpinclude',' headinclude','header','footer','forumjumpbit','for umjump','nav_linkoff','nav_lin kon','navbar','nav_joiner','pagenav','pagenav_curp age','pagenav_firstlink','page nav_lastlink','pagenav_nextlink','pagenav_pagelink ','pagenav_prevlink','microsta ts')
AND (templatesetid=-1 OR templatesetid=1))
OR (title = 'maxloggedin')
OR (title = 'birthdays')
ORDER BY templatesetid
Time before: 0.099313974380493
Time after: 0.11214196681976

table type possible_keys key key_len ref rows Extra
template range title title 32 87 Using where; Using filesort

--------------------------------------------------------------------------------

Query: update vbstats_counter set count=count+1 where (type='total' and var='hits') or (var='MSIE' and type='browser') or (var='Windows' and type='os')
Time before: 0.1307510137558
Time after: 0.13244700431824

--------------------------------------------------------------------------------

Query: update vbstats_countries set hits = hits+1 where code = 'us'
Time before: 0.13284802436829
Time after: 0.13345098495483

--------------------------------------------------------------------------------

Query: Select date from vbstats_date WHERE date='2003-07-25'
Time before: 0.13375794887543
Time after: 0.13481605052948

table type possible_keys key key_len ref rows Extra
vbstats_date ALL 248 Using where

--------------------------------------------------------------------------------

Query: UPDATE vbstats_date set count = count+1 where date = '2003-07-25'
Time before: 0.13570702075958
Time after: 0.13771498203278

--------------------------------------------------------------------------------

Query: SELECT * FROM usergroup WHERE usergroupid=6
Time before: 0.14379394054413
Time after: 0.14503705501556

table type possible_keys key key_len ref rows Extra
usergroup const PRIMARY PRIMARY 2 const 1

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1
Time before: 0.14890003204346
Time after: 0.14967596530914

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 45 Using where; Using index

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND dateline>1059165043 AND folderid=0
Time before: 0.15060794353485
Time after: 0.15190196037292

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 45 Using where

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND messageread=0 AND folderid=0
Time before: 0.15289795398712
Time after: 0.15412402153015

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 45 Using where

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user
Time before: 0.15628504753113
Time after: 0.15683901309967

table type possible_keys key key_len ref rows Extra


--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS posts FROM post
Time before: 0.15768694877625
Time after: 0.15807497501373

table type possible_keys key key_len ref rows Extra


--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS threads FROM thread
Time before: 0.15872097015381
Time after: 0.15909194946289

table type possible_keys key key_len ref rows Extra


--------------------------------------------------------------------------------

Query: SELECT userid,username FROM user WHERE userid=390
Time before: 0.15973997116089
Time after: 0.16027796268463

table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1

--------------------------------------------------------------------------------

Query: SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder
Time before: 0.16230797767639
Time after: 0.16545104980469

table type possible_keys key key_len ref rows Extra
forum ALL 51 Using where; Using filesort

--------------------------------------------------------------------------------

Query: SELECT forumid,canview,canpostnew FROM forumpermission WHERE usergroupid='6'
Time before: 0.17623496055603
Time after: 0.17706000804901

table type possible_keys key key_len ref rows Extra
forumpermission ref ugid_fid ugid_fid 2 const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT forumid,accessmask FROM access WHERE userid='1'
Time before: 0.17811703681946
Time after: 0.17866396903992

table type possible_keys key key_len ref rows Extra
access ref userid userid 4 const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT user.userid,user.username,moderator.forumid
FROM moderator
LEFT JOIN user
ON (moderator.userid=user.userid)
ORDER BY user.username
Time before: 0.17950904369354
Time after: 0.18144702911377

table type possible_keys key key_len ref rows Extra
moderator index userid 6 42 Using index; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 moderator.userid 1

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity>1059168462
Time before: 0.18493902683258
Time after: 0.18557298183441

table type possible_keys key key_len ref rows Extra
session ALL 4 Using where

--------------------------------------------------------------------------------

Query: SELECT DISTINCT session.userid,username,invisible,usergroupid
FROM session
LEFT JOIN user ON (user.userid=session.userid)
WHERE session.userid>0 AND session.lastactivity>1059168462
ORDER BY invisible ASC, username ASC
Time before: 0.29781603813171
Time after: 0.29889500141144

table type possible_keys key key_len ref rows Extra
session ALL 4 Using where; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 session.userid 1

--------------------------------------------------------------------------------

Query:
SELECT findword, replaceword, replacementsetid
FROM replacement
WHERE replacementsetid IN(-1, '1')
ORDER BY replacementsetid, replacementid DESC

Time before: 0.42030394077301
Time after: 0.42234098911285

table type possible_keys key key_len ref rows Extra
replacement ALL replacementsetid 56 Using where; Using filesort

--------------------------------------------------------------------------------

Page generated in 0.40744400024414 seconds with 24 queries,
spending 0.039765119552612 doing MySQL queries and 0.36767888069153 doing PHP things.
Query: UPDATE session SET lastactivity=1059169362,location='/forums/index.php?explain=1' WHERE sessionhash='91adba9914cb16019f205696dda10b35' Time before: 0.47847700119019 Time after: 0.47915899753571
--------------------------------------------------------------------------------
Query: UPDATE user SET lastactivity=1059169362,inforum='0' WHERE userid='1' Time before: 0.47937405109406 Time after: 0.48000800609589

[Zachery]

if you red the install it would tell you what options add querrys. and unless your server is under super high load, i wouldnt worry so much about your querie count

[arracing]

well, the thing is its not about added options. I think something is wrong cause the query counts seems to be significantly higher then before my upgrade. I had alot of hacks so I am unsure what is interfering with what. Just trying to clean up the mess a little.

[Zachery]

whats with that music, i dont think its making much of a difference
and i dont think its much to worry about, but that music is damn annoying :\

like i said i dont think its a big deal

[arracing]

It goes well with the concept of my forums. I like it.

[arracing]

why is it the random poll works say if you click one of the menu options. But on the main index it doenst work????

[arracing]

also how do i get that AR Racing image to size correctly with the rest of the index?

nevermind i got it.

[jbear6]

I saw this post https://vborg.vbsupport.ru/showthread.php?postid=397671#post397671 on page 84 of this thread, and I have a similar question please.

Is it possible to get the "News" or the "Latest Threads" to display results from an entire Category, instead of only one forum (news), or all forums (latest threads)?

Thanks
Jbear6

[Zachery]

well doing the entire forum, every time a new topic was posted it would display on the front page, i think this might add alot of queries but im not sure

[deano1]

sorry
i didn't read all 104 pages of this thread

but i just upgraded to VB3 beta 4
and it killed my myvbindex portal

is ther a way to make it work with VB 3 ??

thank you

[jbear6]

Today at 07:29 PM Faranth said this in Post #1557 (https://vborg.vbsupport.ru/showthread.php?postid=420678#post420678)
well doing the entire forum, every time a new topic was posted it would display on the front page, i think this might add alot of queries but im not sure

I might not have been clear on exactly what I meant. Instead of pulling "Latest Threads" from every forum on a vb, I was wondering if I could pull the "Latest Threads' from only one Category of a vb.

I have three main categories, each with sub categories, and postable forums under the sub categories. I would like to pull the Latest Threads from the postable forums located under one Category only, not the whole board.

Thanks,
Jbear6

[Zachery]

Yesterday at 10:38 PM deano1 said this in Post #1558 (https://vborg.vbsupport.ru/showthread.php?postid=420699#post420699)
sorry
i didn't read all 104 pages of this thread

but i just upgraded to VB3 beta 4
and it killed my myvbindex portal

is ther a way to make it work with VB 3 ??

thank you

note at this time

[Cal Poly Forum]

Parse error: parse error in /home/name/public_html/forums/admin/functions.php on line 889


Fatal error: Call to undefined function: vbsetcookie() in /home/name/public_html/forums/admin/sessions.php on line 205



Wonder where the hackers are.
All 3 portals have never been successful. :cry:

[deano1]

Today at 05:35 AM Faranth said this in Post #1560 (https://vborg.vbsupport.ru/showthread.php?postid=420715#post420715)
note at this time


ok
do you know when about it will be out ???

[Akex]

Thx for this portal, i may install it :)

[Zachery]

Today at 01:12 AM Cal Poly Forum said this in Post #1561 (https://vborg.vbsupport.ru/showthread.php?postid=420719#post420719)
Wonder where the hackers are.
All 3 portals have never been successful. :cry:


i have never had a singel problem using this hack. did you make sure you preformed the file edits adn your running vb 2.2.X or 2.3.0?


you should always backup files and the database, before you start anyhacks

[Zachery]

Today at 11:35 AM deano1 said this in Post #1562 (https://vborg.vbsupport.ru/showthread.php?postid=420795#post420795)
ok
do you know when about it will be out ???


not speaking for tigga, but probally when vb3 is rc/gold

as that is when vb3 coding will be final

[depthCORE]

I have just one problem...
I added a News Forum on my website, and went to www.mywebsite.com/vb/admin/myvb_install.php and ran the install script to re-index my News Forum ID.. well after I go back to the admincp and double check the Forumid number.. and its correct, I dont get anythin on the home page... like in this example www.liquid-area.com/vbindex.php

Any Ideas will be appricated.
Thanks

[Zachery]

well i cant help at all due to the fact you didnt give the right address to the script. i just get a 404 page

[mccollin]

I am in the process of converting a site that was based on phpBB to vB. The forums are moved, but I need to redo my portal pages. This script looks like a possibility, but I need to verify if it can do the things I need.

* multiple portal pages for a single vB installation (example, a car website might have a main portal page for its home, but then have a Ford page, a Chevy page, etc... )
* selecting more than one news forum for news on one page (this merges the news from the forums selected into one date sorted stream for the news on that page - example, the Ford page might have taurus, mustang, and explorer news forums included in Ford news.
* list of most popular threads in a forum
* list of most recently added threads in a forum
* list of most recently update threads in a forum
* ability to do multiple lists of news headlines per page.

What I need to do is currently in action at http://pdaphonehome.com/phpBB2/i700faq.php and http://pdaphonehome.com

Would this hack be a good base for me to recreate these pages? I don't mind making changes to it to get what I need, I just need a solid foundation.

[arracing]

i need help my latest threads are showing that the last poster is the thread starter. How to I correct this and make it show the username for the user posting last in that thread?

www.ar-racing.com

[mccollin]

Jensie180,

I have a mini hack that will "convert" this portal to a site that you can use with multiple pages. The pages are not templated, instead they are manually created by you (I found this much easier). Here it is:

OK, what exactly do I do here? Would I install myvbindex, and then do this hack, or is it something totally separate? I thought that myvbindex used the database for templates from what I read of the install instructions. So how does this separate them? I'm new to vb, so I wouldn't mind having files for templates. It would actually be the easiest way for me to get this going since I have files for templates with the existing pages.

[Jensie180]

I want to apologize for my mini hack post earlier. I didn't know I couldn't post mini hacks to it, sorry Tigga! mccollin, after testing that mini hack a little bit more I found out that it didn't work. I'm still working on it though!

[Zachery]

you always need to ask/get permission to modify a hackers code :)


well and release it that is

[Jensie180]

Yeah, now I know, again sorry!

Now, on a different subject. The newest threads thing is showing the newest threads in my private forums too! How can I stop this?

[Zachery]

try loggin out and checking, as from whqat i understood its based on premissions you shouldnt see them when you log out

[Jensie180]

Yeah I forgot to add that, I logged out and still saw the topic as a guest. I edited each forum with the permissions that they can't view the forums and all but that didn't work.

[Edit] Never mind, I had to login in the admin cp to change the permissions and I was still logged in when I checked if it was ok. Now I logged out and the topic didn't show :)

[Zachery]

<a href="https://vborg.vbsupport.ru/showthread.php?postid=412050#post412050" target="_blank">https://vborg.vbsupport.ru/showt...050#post412050</a>

take a look at that post

[Lacrosse Boy]

I installed the hack but later o nI decided I wanted to change the templates, but in my template list there are no myvbindex templates to be found!

What do I do?

[Lacrosse Boy]

Never mind.

[Zachery]

:D you found em i take it

[konstance]

I am trying to modify the Latest Forum Topics block on mYvBindex page... I'd like to add another variable to WHERE clause, but no matter how I change it, i do not see any changes. ok. here is the original code:

$threads=$DB_site->query("SELECT threadid,title,replycount,
postusername,postuserid,dateline,views"
.iif($showthreadicon, ',thread.iconid','')."
FROM thread WHERE open='1' AND open<>10
$iforumperms ORDER BY lastpost DESC LIMIT $maxlatethreads");

I'd like to say this:

$threads=$DB_site->query("SELECT threadid,title,replycount,
postusername,postuserid,dateline,views"
.iif($showthreadicon, ',thread.iconid','')."
FROM thread WHERE open='1' AND open<>10 AND forumid!='54'
$iforumperms ORDER BY lastpost DESC LIMIT $maxlatethreads");

i have no idea what i'm doing wrong. nothing changes on the display... please help. i'm starting to feel retarded :confused:

[Zachery]

uhh just looking at your code i dont think you are doing it right, but i wouldnt know what the right coding is

[Tigga]

You'll need to add that code to the forum permissions section (above the poll). The forum permissions are included in the threads query, so it's telling it to look in that forum, and also not to look in that forum. Apparently the first one overrides the second. Either way though if you add it in the forum permissions instead it will work. :)

[konstance]

sweet!!! thanks so much~ i played around with it a little more, and all i had to do was specify the permissions in the admin section of the forum. duh!

thanks for the help though! i'll know another solution next time!

[Guz2003]

Can You write a script for Headline view (archive of news)?
Thanks!

[Gohan]

I'll try install into vb3 :)

[Tigga]

Guz2003 - I may add something like this to the vB3 version, but no new options will be added to the current vB2 version here.

Gohan - Do you mean you're going to try to use this with vB3? If so, it would take a LOT of work to get everything converted.

[Goat Boy]

I notice the portal page takes a while to load alot of the times, here are my stats
vBulletin, Copyright ©2000 - 2002, Jelsoft Enterprises Limited
Page generated in 0.66982901 seconds (92.51% PHP - 7.49% MySQL) with 26 queries.
[Debug Mode OFF] [PHP v4.3.2] [GZIP enabled - level 1]

Is 26 queries high?
Mysql seems good
Could the weather feature cause it to slooooow down?

When I am already on the page and I reload it this is what I get

vBulletin, Copyright ©2000 - 2002, Jelsoft Enterprises Limited
Page generated in 52.29610598 seconds (99.91% PHP - 0.09% MySQL) with 26 queries.
[Debug Mode OFF] [PHP v4.3.2] [GZIP enabled - level 1]

Other than this problem I am experiencing the is a great hack Tigga

Thanks
GoatBoy

[Zachery]

yes, the weather feature grabs info from another website, if you disable it the page load time decerease

[Goat Boy]

Thanks for the input, I turned the weather off now it loads superfast.

GB

[Zachery]

it pulls from msn.com and depending on their load is how fast the user gets their weather info

[Guz2003]

Tigga - If you can, please make it. Thanks a lot.

[Littlebit]

Hey Tigga,
I'm not sure why it did it again, but a registered user replyed to a news thread and her post replaced the first...
I didn't upgrade anything.
What do you think I shoud try?
Thanks :o

[Cloud Strife]

All of a sudden myvbindex has started running really slowly. Sometimes it runs fast, but at other times it goes really slow and hangs.

Ive checked the processor usage aswell, it rockets up when this happens

Any ideas on whts going on???

[Tigga]

Littlebit - Can you email me your myvbindex.php file (bgunter@project8.com) so I can have a look?

Cloud Strife - Do you have the weather turned on? If so that's most likely the problem. If not please post here or PM me with a link to your site.

[Littlebit]

Tigga, I just emailed you it. Thanks again

Cloud, the weather was doing it to me too...as soon as I turned it off in the CP, the page loaded fine again.

[Zachery]

tigga, check your pms soon,

[musclebody]

I am using myvbindex on my site, but I don't know how to get the "Forums" to display when using this. I know this is a stupid question, but I am a little stupid :)

I would simply like the myvbindex page to display when you click on "HOME", and the "FORUMS" listing to display when you click on the "FORUM" button.

I have tried different settings, etc, but I can't figure it out.

Any help would be extremely appreciated.

THANKS!

[DeeperImage]

Does this work with VB3 beta 5?

[soccerclue]

Hi, I have just used the hack. I had problem with the font color of the category. How can I change the color or categoryfontcolor to tableheadtextcolor. I am not sure which templates should I change. Please check it at http://www.asianguild.com The font color right now is black almost the same as the background color. I would like to change to white color to every of the categoryfontcolor.

[soccerclue]

I also add the attachment add on for this hack so that when the post got attachment, it would be displayed in the homepage. But, the problem is when the post does not have attachment and the homepage would also show blank image. How can I get rid of this blank image?

[pjc420]

ive had problems getting vbhome to work the way i wanted to, im gunna give your script a try, it looks nice :)

ill give a shout here when its all installed

PJC

[pjc420]

wow, installs quick, without a hitch, and i didnt get any template problems i got with vbhome...both great scripts, but im deffinatly going to stick with yours :)

as far as all this controversy over who writes what, who wrote this and put this in that, i dont care....at all...whatever works, and does the job is what i care about

thanks for writing a great script :)

[Littlebit]

hey Tigga,
Well, I don't know what I did exactly, but it's fixed. I'll explain the steps I took, if you're curious, maybe you can see what the cause was if I tell you what I did .... hope things are going great for ya!

[Zachery]

Today at 12:53 AM DeeperImage said this in Post #1598 (https://vborg.vbsupport.ru/showthread.php?postid=426078#post426078)
Does this work with VB3 beta 5?


no

[tpearl5]

If anyone needs some reassurance that this hack works better then vbPortal... look over this:
http://www.midibuddy.net/webalizer/web/usage_200308.html

I installed the night of the 12th. Look at the bandwidth per day. I have weather installed also!

Thanks for making me see the light Tigga ;)

[Zachery]

vbportal (from phpportals.com im assuming) is a postnuke addon :\

[Cal Poly Forum]

Alright!

I had no problem installing this hack. Gotta love it.
I've tried the vbhome lite and was very difficult to customize and edit.

Anyways, how do we customize the index page:

1) From the default, I want to Search Site on the top right (replacing stats).

Thanks.

[Zachery]

if i remember right there should be a template called index under myvbindex template, theres all the variables in there if you play around with the placement you should get it :)


if not lemme know

[soccerclue]

All right..I have changed the categoryfontcolor to tableheadtextcolor in several templates..but several others still I cannot find where the template is...can you please help me? Please have a look at http://www.asianguild.com The 'User CP', 'Active Users', 'Online Buddies', and 'calendar date' color is still wrong. Hope you can help me.

[Zachery]

i dont see anything wrong with the colors :\

[Cal Poly Forum]

In the index, how would I edit so that my main banner will be in the center and the "usercp, register, calendar,etc." buttons will be right under the banner?

[Zachery]

find your header template, copy it, and paste it into index_header

[soccerclue]

I used header instead of index_header..and I used footer instead of index_footer.

[Cal Poly Forum]

How can I shrink my index page (using myvBindex porta) width ?
Like how www.asianguild.com has.

[Cal Poly Forum]

Where exactly do I insert the header template codes into the index page? On the myvB index page, there is not <logo and buttons> code.

[soccerclue]

U just need to set your forum width in Style section

[soccerclue]

just change the $index_header and $index_footer variable to $header and $footer in 'index' in myvbindex templates.

[soccerclue]

Faranth..can u help me check my forum again? The color is still wrong. Some of them fixed,...some of them i dont know which template to fix..hope u can help me..

ok..if you can't find out the wrong place..one of them is the calendar date..instead of making it dark blue font..i want it white color..but i dont know which template it is.

[soccerclue]

OK..I think i understand why i can't change the color..because it depends on my link color of my forum...do you have any idea how can i change the color without following the link color because it does not fit with the background color.

[soccerclue]

All right I think I have fixed it..don't mind anymore..anyway..great hack..

[Shadow_NL]

07-15-03 at 04:24 PM Tigga said this in Post #1496 (https://vborg.vbsupport.ru/showthread.php?postid=417954#post417954)
CodeDawg - Simply change your News Forum ID in your Admin CP to something like...
XX OR forumid = YY OR forumid = ZZ
(Replace XX, YY, & ZZ with the forum id's) This did not work for me, only the news from XX is showing up. What else can I try?

[Zachery]

lol

the reason i dont say to pull header and footer is some people may want their front page to look totaly differnt.

[livewars]

I recently installed this at: http://www.livewars.com/vbindex.php ... my problem is that the incorrect header/footer are loading (I setup everything correctly in the admin).. also when someone logs in from the main index, it returns the signed in user to the forums index.

Can you tell me how I can I fix these 2 issues?


P.S. - is there a way to add these boxes into an index.php HTML page?

thnx.

[AmericanWoman]

I could kill someone...

I've had an older version of this hack installed for almost a year, and it was working fantastic - but we had an accidental partial install of 2.3.2 (from 2.2.9 - long story - database has been updated, but only files governing registration have been changed), and now 2 things aren't working for this hack:

Poll images are not displaying (although poll thread title and vote button are) and, most importantly, user login isn't displaying (although if you're already logged in, your info shows fine).

Site's www.acuraworld.com - any ideas/suggestions would be greatly appreciated. The board's heavily hacked, so trying to do a fresh install and reinstate everything I have will take much longer than just a few hours.

Help. :( Please.

[AmericanWoman]

nm - I'm an idiot, and I shouldn't be allowed to touch a computer.

[Zachery]

Yesterday at 11:32 PM livewars said this in Post #1623 (https://vborg.vbsupport.ru/showthread.php?postid=426895#post426895)
I recently installed this at: http://www.livewars.com/vbindex.php ... my problem is that the incorrect header/footer are loading (I setup everything correctly in the admin).. also when someone logs in from the main index, it returns the signed in user to the forums index.

Can you tell me how I can I fix these 2 issues?


P.S. - is there a way to add these boxes into an index.php HTML page?

thnx.

1. open your template manager and copy your header template and paste it into your index_header template same with footer

2. check to make sure you changed the redirect

[soccerclue]

I wonder why the calendar in my homepage cannot have the different background color for today's date. I saw someone's homepage can have different background color. I did something wrong here?

[Zachery]

i belive it uses alt1 and alt 2 to display the calendar color, so, altho im not postive

[Littlebit]

I'm worried about Tigga...has anyone heard from him?

[Zachery]

i think hes gotten boged down with work... but i havent seen him as of late :\

ive been trying to support this as much as i can :)

i hope tigga will return shortly


altho he did post some time in the last 24 hours here

[CodeDawg]

08-15-03 at 07:30 AM Littlebit said this in Post #1603 (https://vborg.vbsupport.ru/showthread.php?postid=426186#post426186)
hey Tigga,
Well, I don't know what I did exactly, but it's fixed. I'll explain the steps I took, if you're curious, maybe you can see what the cause was if I tell you what I did .... hope things are going great for ya!


COuld you please post what you did, this problem just popped up on my site

[Littlebit]

Today at 12:09 PM CodeDawg said this in Post #1631 (https://vborg.vbsupport.ru/showthread.php?postid=427068#post427068)
COuld you please post what you did, this problem just popped up on my site
Oh sure! I thought mine was an isolated case because I have some minor different modifications...
I redownloaded the mYvBindex.php and made sure I changed the full path for the chdir first...
Then I uploaded it over the old one.
I ended up with an error, but I think this has to do with my special modification....so I re-uploaded the old index.php and it set the news posts back to the first post showing.
I know it doesn't make much sense to me either.
I have to say though, I just noticed yesterday, that one of my older news posts has a reply post showing...fortunately it's old and not as big a deal.
Something is still a little out of wack with it.
I can't figure it out, but maybe what I did will help you with a temp fix too until Tigga gets back from his gig.


:)

[Littlebit]

oh, I saved my old one somewhere else first ...don't just upload over it (just in case)...my bad for not saying that clearly. :speechless:

[CodeDawg]

Bummer, didn't work for me

[Zachery]

thats an odd problem.... are you still running the same version of vb when you installed myvbindex?

[CodeDawg]

Yep, it is a new install of both on a new server. I looked at the code and can't find where it specifies which post from the thread to use.

[Zachery]

it should just grab the first post, i think vb2's version works by pulling / putting the first new post into a differnt table and then displaying it, because i remember, when i had some announcments in my announcement thread they didnt show up unless i reposted them

[soccerclue]

Today at 04:41 AM Faranth said this in Post #1628 (https://vborg.vbsupport.ru/showthread.php?postid=426971#post426971)
i belive it uses alt1 and alt 2 to display the calendar color, so, altho im not postive

what do you mean by using alt1 and alt2..? is that set in Admin CP?

[Zachery]

yes.... under the sytle fonts colors and properties

[CodeDawg]

Hmmm...any idea what that table would be? I can't see it in the code. I am a PHP newbie so I may just be simply missing it, but I can't figure this out for the life of me.

Kinda need to get it fixed as it is messing up the current news items.

[CodeDawg]

I found the problem!!!!

In the get news query: WHERE forumid='$newsforum' AND isnews='Y' AND open<>10 Well in mine the isnews='Y' was missing.

I remember removing it for some reason (sure I could search and find it in this thread but...) but I added it back in and the news for all sections is now fine.

Ugh....need to make some notes on the changes I do from here on out :)

[Zachery]

oh good :) glad to see you fixed it lol, i wouldnt have guessed

[Tigga]

I'm still alive and kicking... Just been busy as HELL these last few weeks. We've had some major backend problems on the site I'm doing at work, and of course I'm the one that's had to fix most of it. I've also had a LOT of crazy stuff going on in my personal life, so I've barely had any time to read the posts here, let alone make many posts.

BTW Faranth, I really appreciate you taking the time to help others out with their problems. I did get your PM about the full install as well and I will get that to you once I have some free time. There's a few small issues I want to get worked out first though. I've also changed around the template system and removed well over half of the templates since I sent you the version you have.

[livewars]

Under "active users" panel, the links come up wrong (looks in my main dir, instead of ../forums/).. all other links seem fine however... please help!

thnx. ;)

[Tigga]

You didn't follow the install instructions and make the change to your forumhome_loggedin user template.

[Shadow_NL]

CodeDawg - Simply change your News Forum ID in your Admin CP to something like...
XX OR forumid = YY OR forumid = ZZ
(Replace XX, YY, & ZZ with the forum id's)08-17-03 at 03:45 PM Shadow_NL said this in Post #1621 (https://vborg.vbsupport.ru/showthread.php?postid=426599#post426599)
This did not work for me, only the news from XX is showing up. What else can I try? Can anyone help me?

[livewars]

Does anyone know what would be causing the page to direct to the /forums/index rather than the root index when a user logs in or out?... i am 100% sure I edited the member.php correctly.

Any help would be greatly appreciated... thanks!

[Zachery]

i think its a template edit you forgot


btw i sent you a pm and i hadent read your first post. glad to see you alive :D


i was thinking about combining a few templates as they seemd they couldnt be done more or less with some if statements


it is running live on my website now and weve had no problems

[NeRilkA]

Hi,

i got a problem with the portal.

Once on two there is this error :

Database error in vBulletin 2.3.2:

Invalid SQL:
SELECT findword, replaceword, replacementsetid
FROM replacement
WHERE replacementsetid IN(-1, '2')
ORDER BY replacementsetid, replacementid DESC

mysql error: Lost connection to MySQL server during query

mysql error number: 2013

can someone help me with this please ?

Thanks a lot

[Zachery]

to me(im not positive) it looks like your just loosing the connection to your db server

[NeRilkA]

it's what I thought but I preferred to have confirmation and try to find a solution before the members shout :)

thanks Faranth

(ps: did you read the books about Pern from AnneMcCaffrey ? I ask because of your nick :) )

[CodeDawg]

Today at 10:14 AM Shadow_NL said this in Post #1646 (https://vborg.vbsupport.ru/showthread.php?postid=427351#post427351)
Can anyone help me?


What I found is that if the first forum listed has as => the number of articles you have set to show then it only shows those articles from that forum.

The code does work, I set my number of articles to be 30 and it pulled from the other forums I set. Of course that is not how many articles I want to show so I just bagged it.

I would imagine that the code could be modified to pull only XX number of threads from each forum listed, but haven;t had the gumption to try to make it work.

I am just holding out for the vB3 version...TIGGA LET ME TEST PLEASE!!!!!!!!!!!

[Littlebit]

08-12-03 at 08:27 AM Tigga said this in Post #1594 (https://vborg.vbsupport.ru/showthread.php?postid=425419#post425419)
Littlebit - Can you email me your myvbindex.php file (bgunter@project8.com) so I can have a look?

Hey Tigga I sent it that day, but now I'm not sure if you ever got it.
I fixed the newer psts in a strange and not understood way, but an older news is still showing a response post.
What should I look at and did I send you my index okay or do you need me to send it again or are you busy and can't check it out....hope things are cool.
I'm going to be upgrading soon...probably just to 2.3.2 unless someone can talk me into going for beta 3 now...still nervous

[Tigga]

livewars - Not modifying (or forgetting to upload) your member.php file is the only thing I can think of that would cause that. If you're sure of that, the only other thing it could be is something with your version of PHP, MySQL, or the way your server is set up.

NeRilkA - As Farranth said, that means you lost connection to your MySQL server... Nothing to do with the hack. :)

Littlebit - Try downloading the latest version here, and then replace your news query with the one there. If that query is right then there shouldn't be any way it can pull any post but the first in the thread... If that doesn't work though let me know.

[Zachery]

glad to see you alive Tigga and responding....

it seems im gettin better with helping

[livewars]

...is it possible that it is a problem in my templates or admin cp options?... I re-did and uploaded the member.php with no success :( ...I dont see how the login redirect could be a mysql version problem, as everything else in the hack seems to be working fine. Any ideas of what else I could try?

thnx.

[Zachery]

while tigga is the offical guy for this hack, i did state that you probally missed a template mod some where.

im here to help :)

if you need me to, ill go and check my template mods and make tell you exctly where it is

[livewars]

Thanks for your help.. I have been going thru the installation instructions over and over trying to find where the error could be, with no success so far. Any help is very much appreciated.. thnx ;)

[Zachery]

Still in your forums directory, open the file "member.php".
Find:
eval("standardredirect(\"".gettemplate("redirect_login")."\",\"index.php?s=$sess ion[dbsessionhash]\");");

Replace with:
eval("standardredirect(\"".gettemplate("redirect_login")."\",\"\$url\");");

This will ensure your users are redirected to the proper place when they log in or out.

tigga was right

make sure thats right in member.php

[livewars]

I triple checked it, that IS what I have already... this is getting frustrating >:(

[Zachery]

i cant go to your site to check it so...

not being an ass, but you did make sure to upload the saved copy of member.php and your not looking at an offline copy...?


about my name i thought i had explained it in a post... i guess not



(ps: did you read the books about Pern from AnneMcCaffrey ? I ask because of your nick :)


but yes i did it was given to me by a friend while i was writing a book and she thought it fit my character, and no the book isnt aviable, it was lost during a windows me crash :P

i however have never read the serries

[livewars]

Yea, I am new to vb hacks...but I have been a web designer for years, so I am not that stupid.. the file is definately there because i pulled it off the ftp to edit it, then uploaded it back up 3 different times after looking at it over and over to see what I could have possibly done wrong.

Anyways, don't bother wasting your time on it... it is not a big deal, the hack is still fully functional and everything.. so I can live with it.

Thnx for your help anyways.

[Zachery]

i could take a look at your member.php file if you wish, :)

[livewars]

I PM'd it to you... let me know if you find anything... thanks! ;)

[Zachery]

i took a look at it and something eles occured to me....


if your site is defind in your root the it would point them back the www.mysite.ext/index.php,

or if $bburl and $url are the same thing... then it would point them back to the index

this is all that i could think of

your file is right, check to make sure your $url is www.mysite.com/
and $bburl points to your forums

[Tigga]

Well one thing you could do is replace the code in member.php with this instead:

eval("standardredirect(\"".gettemplate("redirect_login")."\",\"/index.php?s=$session[dbsessionhash]\");");

That will always redirect your members to your root index file. The other code *should* redirect the user to back to the page they logged out from, but since that's not working you could at least have them redirected to your homepage rather than your forums.

BTW, what version of vB are you running? I upgraded to vB3 from v2.3.0 and I haven't even looked at any vB2 code since then, so if your running a later version it could be possible that something else has changed in the code.

[Zachery]

im running vb 2.3.0 and im fine :\

[livewars]

Thanks for the tips guys... I am running 2.3.2 btw and I love this hack, it is just a minor problem and there is not much point going to too much trouble to try to fix it. I can live with it the way it is, it just frustrated me for awhile because I had gone thru the instructions 3 times just to try to get it right.

Anyways, aside from that... awesome hack, I would recommend it over vbportable, vbhome and others out there.

;)

[Mythril]

hey tigga have you made the portal working with vb3? Or are you still going to wait for RC because next is beta 6 :p No offence I really need a portal soon so if you need some testing or something I can do it for you on my site. :)

[mv540]

whew finally made it to the end, wanted to read through all 112 pages before posting the problem.....

didnt find an answer to the problem so here goes....

im having trouble installing this hack, the problem is in the install..I Got stuck on the older versions so uninstalled and reinstalled afew different times but i cant seem to get this to go....

i did everything step by step and uploaded to its required sections...and then running it using the url mysite.com/forum/admin/myvb_install.php
what happends when im trying to run the install is...well nothing is really happening..lol...

i see the prompt "hang on a sec" and noticed the url changes to mysite.com/forum/admin/index.php..and hangs.....im using vb 2.3.2, my PHP Version is 4.3.3RC1.....this thing does not want to install.......

all files have been put in the right sections
root folder - myvbindex.php
root/forums - member.php, newthread.php
root/forums/admin - template.php, myvb_install.php

any help is greatly appreciated...

was wondering if the code should be altered into unix mode or apache if it makes any difference???????

[zeidlern]

I know it's in here some where but I can't find it in 112 pages.

Is there a way to limit the threads that show up in the latest threads section?

For example I don't want my new forum to show up as well as some non-site realated forums.

[Zachery]

<a href="https://vborg.vbsupport.ru/showthread.php?postid=412050#post412050" target="_blank">https://vborg.vbsupport.ru/showt...050#post412050</a>

try that

[Cal Poly Forum]

<a href="https://vborg.vbsupport.ru/showthread.php?postid=412050#post412050" target="_blank">https://vborg.vbsupport.ru/showt...050#post412050</a> didn't work for me either.

[mv540]

Today at 06:56 AM Faranth said this in Post #1672 (https://vborg.vbsupport.ru/showthread.php?postid=428295#post428295)
https://vborg.vbsupport.ru/showthread.php?postid=412050#post412050


try that

sorry i cant seem to find anything pertaining to the myvbindex install in your provided link.

[Zachery]

i wasnt refering to you mv540, im sorry

honestly im not sure why its doing that,

you can attemtp to reupload all your files making sure its in ASCII mode

and try to re run the installer

i just preformed an install on 2.3.0 a while ago and i didnt have any problems

[zeidlern]

Yea, that doesn't work at all. Any other thoughts? I was looking at the lastest threads part of the vbindex.php file but lack the knowledge to do anything. lol

I currently run phpbb on my site http://www.insanejustice.com

So I'm trying to make the vBulletin look similar with some updated grahpics. http://test.insanejustice.com

I need to have the ability to only show a few forums on in the latest threads. Currentally, with that I have now, when I run the fetch command I can just pass the forum numbers that I want displayed.

like: phpbb_fetchthreads(1,2,3,4,7,8,9)

It would be neat if this was incorporated in the vb control panel where we could either list teh forums we want or don't want. it wouldn't matter either would ne nice.

[Zachery]

you could probally write somthing to only include, but excluding might be ezier in some facts :\

how im not sure i dont know enuf about how vb and php works, i tired my best :(

[zeidlern]

Ok, I got it. open your index file.

Find this:
// Latest Forum Topics
$threadbits = '';
if ($maxlatethreads!='') {
$threads=$DB_site->query("SELECT
threadid,thread.title,replycount,postusername,post userid,dateline,views,lastposter,lastpost".iif($showthreadicon,',thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath','')."
FROM thread
".iif ($showthreadicon,'LEFT JOIN icon ON icon.iconid=thread.iconid','')."
WHERE open<>10 $iforumperms ORDER BY lastpost DESC LIMIT $maxlatethreads");
while ($thread=$DB_site->fetch_array($threads)) {



And chagne it to this:
// Latest Forum Topics
$threadbits = '';
if ($maxlatethreads!='') {
$threads=$DB_site->query("SELECT
threadid,thread.title,replycount,postusername,post userid,dateline,views,lastposter,lastpost".iif($showthreadicon,',thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath','')."
FROM thread
".iif ($showthreadicon,'LEFT JOIN icon ON icon.iconid=thread.iconid','')."
WHERE forumid != 87 AND open<>10 $iforumperms ORDER BY lastpost DESC LIMIT $maxlatethreads");
while ($thread=$DB_site->fetch_array($threads)) {


You can add forumid != XX AND as many times as you want. These are the forums you DON'T want to see.

[Zachery]

wow quick edit, well if it works good i guess :\

[zeidlern]

Today at 04:42 PM Faranth said this in Post #1679 (https://vborg.vbsupport.ru/showthread.php?postid=428354#post428354)
wow quick edit, well if it works good i guess :\


Nope, look at my test site: http://test.insanejustice.com

Notice that the news and polls don't show up in the latest forum activity now.

So it's pulling everything other than those 2.

[Zachery]

well i didnt say it did :P

what i origilany showed was what to exclude not what to only include

[zeidlern]

Today at 04:49 PM Faranth said this in Post #1681 (https://vborg.vbsupport.ru/showthread.php?postid=428357#post428357)
well i didnt say it did :P

what i origilany showed was what to exclude not what to only include


You lost me.

This is just what forums to exclude.

[Zachery]

just ignore me :P

[zeidlern]

I have another problem. I made the things on the sides smaller, to 120 pix.

So now, when the poll is full size it doesn't fit.

Does anyone know where I can edit this? I played with the poll template as you can see but I can only seem to adjust the height not thw width.

I know the width depends on the votes but perhaps I could scale it down by 60% or something.

I'll attach a pic.

[Tigga]

mv540 - I'm really not sure why the install file wouldn't be working for you. If you'd like to pm me with your FTP info I'll be glad to see if I can figure out what the problem is.

zeidlern - If you'll look in your myvbindex.php file for:
$forums=$DB_site->query('SELECT forumid,parentid,displayorder FROM forum WHERE displayorder<>0 ORDER BY parentid,displayorder');
Change that to:
$forums=$DB_site->query('SELECT forumid,parentid,displayorder FROM forum WHERE forumid!='XX' AND forumid!='YY' AND displayorder<>0 ORDER BY parentid,displayorder');
Change XX and YY in that code to the forums you wish to exclude. If you need to exclude more than 2 forums, just add another "AND forumid!='ZZ'" after the other 2. And I probably will add an option to exclude forum id's in the vB3 version once I'm able to release it. ;)
As for the polls, if you'll look in the file for:
$option['barnumber'] = round($option[percent])*1.3;
The 1.3 at the end of that code determines how long the bar will be. It works perfectly for the default setup, but since your boxes are a little smaller you would need to change that (I would think 1.1 or so would work).

[zeidlern]

Tigga: Thanks, good call on 1.1, it was perfect. :)

For the latest topics, I orginally tried your method to block some forums and it didnt' seem to work for me.

Then I tried this. Is there a reason why this shouldn't work or I wouldn't want to do it this way. It seems to work for me.

https://vborg.vbsupport.ru/showthread.php?postid=428352#post428352

[zeidlern]

Tigga:

Ok, new question. I have some pages on my current site that just replace the middle part. So all the sides and top remain the same but I want to put something else in the middle where the news and latest threads go.

I was thinking I could create a new template file and someone have it call that but I'm not sure what to edit on the index file.

So basically I want to copy the index to something new. Then remove the middle and insert some new stuff in there.

EDIT: NVM I figured it out.

[Cal Poly Forum]

On the myvbindex page, when my main post is showing in the middle, how come my images do not show up?
Rather than the image, the url link shows up?

I have allowed bb image.

[zeidlern]

can you attach a screen shot for us?

[Cal Poly Forum]

Here ya go.

Notice it is a URL link instead of the image.

[Zachery]

that code is wrong :P

should be


path/to/file/name

[EzX5U]

it really looks great
good job :)

but should i edit the style to work with mYvBindex?

[mv540]

Yesterday at 04:32 PM Faranth said this in Post #1675 (https://vborg.vbsupport.ru/showthread.php?postid=428347#post428347)
i wasnt refering to you mv540, im sorry

honestly im not sure why its doing that,

you can attemtp to reupload all your files making sure its in ASCII mode

and try to re run the installer

i just preformed an install on 2.3.0 a while ago and i didnt have any problems

ive had no troubles at all either installing it myself before, this is mind blowing to me... im doing it for a friend who wants it on his site. How would i know or how would i make sure the files are in ASCII mode?

Tigga check your pms :glasses:

[zeidlern]

OK new problem. Currentally I have this on my homepage in the lower right: check it out live http://www.insanejustice.com or view the pic: http://www.insanejustice.com/images/servers.jpg

ok, here is the code for it:

<?php require("counterstrike.php");?> <?
$csinfo=new CounterStrike;

// Get The Players
$status=$csinfo->getServerPlayers("64.5.59.120","27015",1000);

// Get The Serverinfo $status=$csinfo->getServerInfo("146.20.83.196","27015",1000);

// Get The Serverrules $status=$csinfo->getServerRules("146.20.83.196","27015",1000);

if ($status) { ?> <table>
<?php if (is_array($csinfo->m_playerinfo)) { ?> <?php
$i=0;
while (list(,$player) = each ($csinfo->m_playerinfo)) { $i++;
?> <tr>
<td><font style="font-size: 5pt"> <?=$player["name"]?></font></td><td><font style="font-size: 5pt"><?=$player["frags"]?></font></td>
</tr>
<? } ?>
<? } else {?>empty<? } ?> <? } ?></table>


When I add that to myvbindex I get this error:

Parse error: parse error, unexpected T_CHARACTER, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\Inetpub\test.insanejustice.com\index.php(736) : eval()'d code on line 200

any reason why this wouldn't carry over from my other site? I've added this to the index_custom1 and the index where would I want to add this to make it show simlar to how it does now.

[Cal Poly Forum]

Oops. It worked. :lick:

edit: How can I make more gap between the header and the tables?

[Zachery]

add more <br />'s to either the index template or in the other templates them self

[Cal Poly Forum]

Thanks got that.


My board is turned off at the moment (www.calpolyforum.com) and on the index page, when I click on the buttons, it gives me the 404 error.

It is because the url (navigation buttons) does not contain /forum/ . If you lost me, go check it out and you will know right away.
Where would I adjust this?

[Zachery]

yes

add forums/

to your urls or the full url always works too

[Cal Poly Forum]

Here's the trick,

my board is turned off. When I log in (admin), all the navigation links (buttons) work perfectly.
But when I log off (no cookie), I get the "forum is closed" message and my navigation buttons do not work.

When I am loggin , the url of the buttons have "/forum/"
but when I am logged off, the url doesn't have "/forum/" :surprised:

Very strange, I just checked my index header, and it has /forum/ in the code. Don't know why it doesn't work when I am logged off.

[Zachery]

because its showing the $header not $index_header

[frankenberrie]

Excuse me for being lazy... There are an awful lot of pages to this post.

Is there a way to use more than one forum for the front page information?

News Forum ID
The ID number of your news forum.

Is there a way i can use a value like

3,4??

Thanks

[arracing]

my latest threads on the index portal is showing topics in my mod forum. I noticed that when i log out I can still see the thread titles from the mod forum on the latest threads list.

my site is www.teamrevolution.net

the mod forum is not private but the permisions are set so that only mods and leaders can view the threads inside. What do i do to hide the thread titles from specific forums on the latest thread section?

[Zachery]

look a few pages back for how to exclude speicif forums

[arracing]

i did a search and got the stuff i posted a long while back when i had vb 2.2.5 but my question now is for vb2.3.0 and myvbindex.

I dont know if its the same or not. The thing is when i had 2.2.5 I had made the hack to change this but when I upgraded its gone and Im not sure what to do again with the new version and if the code was different then from before. Can someone just repeat it here. I would really appreciate it.

Thanks

[arracing]

01-01-03 at 09:27 PM Tigga said this in Post #373 (https://vborg.vbsupport.ru/showthread.php?postid=337241#post337241)
DarkDraco - What mini-hack?

Jarvis - Glad it works for you too! The way it was written before, it would insert ?C or ?F in the database with the temperature. Now it just inserts the number, then later in the script it will see if it's supposed to be C or F. I guess some versions of mySQL don't like the ? symbol being in the database. ;)

Chris - Yea, I know about the problem when leaving a news or poll forum id blank. I added in a little more 'error checking' in v3.1 so that it will first make sure that field isn't blank before continuing with the database queries. That way the news or poll area will simply be blank rather than returning a nasty sql error. That should help cut down on the number of people having problems with fresh installs too since many go to check the page before setting all the options, and then think they have installed it wrong when they see the error.
As for the latest threads part... For now you can hard code it in the script what forum id's you would like it to check. You would just open mYvBindex.php and look for:
AND open<>10 $iforumperms
You would replace that with:
AND open<>10 AND forumid=X OR forumid=Y OR forumid=Z
Then of course just change X, Y, and Z to the forum id's you would like it to check. I may add this as an option in a future version, but that should help you for now. :) Oh, also note that this will not do any kind of permission checking, so if you have a private forum id specified, all users will be able to see that topic. Of course they won't actually be able to read it, but they will see the title of the post on the homepage.

Tony - I'm not sure why the install script wouldn't work then. I'm sure there are many other possible reasons, just not sure exactly which one it would be. Didn't you already run the queries manually and get it working ok though?

I just did this to my index by adding those lines of code but the titles of the threads are still showing and I am shur i correctly entered in the correct forum ids. By code is below, the only difference is the first AND is a WHERE but I tried both ways and it didnt help.

WHERE open<>10 AND forumid=49 OR forumid=59 OR forumid=47 OR forumid=64 OR forumid=40 $iforumperms ORDER BY lastpost DESC LIMIT $maxlatethreads");

[arracing]

I just noticed that what i did is making those forum ids show up only. I need to put a not command, I believe its the ! but I forget where it goes in the code. before or after the equal sign?

[arracing]

hmm its not before or after it seems. So how do i make it not show the specified forums?

[arracing]

i figured it out, the correct code uses AND not OR and for me starts with the WHERE

WHERE open<>10 AND forumid!=49 AND forumid!=59 AND forumid!=47 AND forumid!=64 AND forumid!=40 $iforumperms ORDER BY lastpost DESC LIMIT $maxlatethreads");

[EzX5U]

but should i edit the style to work with mYvBindex?


Waiting the answer :bored:

[Zachery]

EzXu5: the style is totally based off your style from vbulletin

arracing : if you upgraded you will need to reinstall and the code hasnt changed

[EzX5U]

thanks for answer :}

[Cal Poly Forum]

Is there a way I can remove the link buttons because my board is closed as of now (www.calpolyforum.com) and would like to get rid of the buttons, only when the board is closed.

Solution?

[Tigga]

Cal Poly - If you ask in the General Hacking Discussion forum someone there can probably help you.

[Littlebit]

Hey Tigga, I'm going to be upgrading, but I wanted to talk to you first when you get some down time. When you get a chance, will you check your PMs? I know you have your hands full... :)

[alqafelah]

hi all,
Tigga, i have big problem but not for this hack , in database ..
the query altering news id is very slowly after submit , only in the post table .
i tried to alter it in other table it is ok !
only post and thread ( my big tables ) .
in my personal server all things fine !

what's the problem ? do you have any idea ?

sory for bad english .
thanx.

[Tigga]

alqafelah - The query will not be any slower when submitting a post. It's only adding a 'Y' in the isnews column if the post is a new thread, so it would not affect the speed at all.

[Tigga]

Just a heads up to everyone - I'm moving tomorrow and I'm not sure when I'll have an internet connection again, so I will most likely be unavailable for at least a week. If anyone has problems please post them here as normal and hopefully Faranth or someone else will be able to help out. :)

[Zachery]

good luck with the move... try to check your pms and reply tonight if you can

i might not be able to help for a few days as my pc is acting up hopefully ill get this all fixed up by tommrow

[pixelpunk]

I know Tigga's moving but I'm hoping someone else might be able to help me out. My brain's fried, i've looked through everything I can and I'm not seeing the problem so here it is...

My frontpage news isn't being updated with the latest news but it will update with the latest poll. It's still got a news post from last month coming up so I know it's pulling from the right forum, it'll show 1 or 2 or how ever many posts I allow it to show but only starting from the one last month! It's so friggin weird.

Anyone? Anyone?

I know it's looking in the right place I just can't figure out why it won't show the new(er) posts.

[Zachery]

hmm my only thought as to why this might be happening is , have you upgraded your vB as of late?

[pixelpunk]

Nope. Still running 2.3.0, the version I was using when I installed it.

[Zachery]

have you edited the file at all?

[Guz2003]

Faranth: Whether can you help me? Ñan íou create a small script for mYvBindex or tell as to make it? Archive of news which shows heading only. Looks like on the screenshot at the attach! Please, help me.

Thanks a lot!

[Zachery]

im assuming Guz you dont speak english,

that honestly looks like a differnt portal :\ cuz ive seen it in oter placesl altho you might be able to get the same effect by editing the templates

[Guz2003]

>> im assuming Guz you dont speak english,
SO WHAT?

>>that honestly looks like a differnt portal :\ cuz ive seen it in oter placesl altho you might be able to get the same effect by editing the templates

How I make that so the last 5 of 10 item news looked similarly to screenshot?

[LightBringer]

Will this hack be ported to vbulletin 3.0 when it's released?

[Zachery]

it was just a statement :\ i wasnt trying to be mean, im not sure how to make just the last 5 of ten items look like that

[Zachery]

Today at 11:11 PM LightBringer said this in Post #1726 (https://vborg.vbsupport.ru/showthread.php?postid=431385#post431385)
Will this hack be ported to vbulletin 3.0 when it's released?


check out www.digitalkore.net :)

[LightBringer]

Today at 04:12 PM Faranth said this in Post #1728 (https://vborg.vbsupport.ru/showthread.php?postid=431387#post431387)
check out www.digitalkore.net :)


You've made me a happy user! =))
Now...spill the beans!

ohlmsjm@charter.net hehe

[Zachery]

no no :) i cant do that

dont worry RC1 will be out soo enuf

[LightBringer]

Today at 06:26 PM Faranth said this in Post #1730 (https://vborg.vbsupport.ru/showthread.php?postid=431414#post431414)
no no :) i cant do that

dont worry RC1 will be out soo enuf


LIES! =P

[Zachery]

im beta testing :) so far so good

[MikeWarner]

A few people have complained that this hack takes a while to load. I am also getting this problem. I switched on debug and this is the bit that is holding everything up:

Query: SELECT count(*) AS count FROM post WHERE dateline>='1062712329'
Time before: 0.077859044075012
Time after: 7.0326470136642


Here is a link to the full result:
http://www.migweb.co.uk/myvbindexphp.html

If you want to see how slow it loads:
http://www.migweb.co.uk/myvbindex.php

Any ideas on this? I can't find anything in the thread, but then it is a big thread. I love the hack, but I'm worried many people are leaving the site before it loads - so I may have to remove myvbindex if I can't get it to speed up.

Many thanks for any help given.

[Zachery]

if your still running weather turn it off, this should speed it up quite abit :)

[MikeWarner]

Weather is off and non of the hacks for it have been done.

[Zachery]

what do you mean non of the hacks for it have been done?

[MikeWarner]

During the install it says "only do this if you want the weather block". I didn't want the block, so I didn't do the hacks for it.

[Zachery]

thats the only thing i could think of to slow down the template :\

once i turned weather off i never had any slow problems :\

[MikeWarner]

Through SSH I did TOP and watched the server load and the other info there. I opened my myvbindex page and saw a mysql process take up 35% of CPU resourses. As soon as the page loaded this went away. I tried it again and the same happened. There is nothing else going happening on my site that is using more than a few % of CPU. Something strange is happening.

[Zachery]

try turning all the options off showing the extra templates and see what happens

[MikeWarner]

I've done that - still the long pause.

[Zachery]

i dont understand why it would be doing this, ive been running this script on differnt shared hosts for the longest time and never had a problem :\

[MikeWarner]

Right - I just logged out and tried it and it loads straight away.

I can't explain why, but maybe this will help narrow it down.

[MikeWarner]

Ok - from /myvbindex.php?explain=1 I see this:

Query: SELECT count(*) AS count FROM post WHERE dateline>='1062795588'
Time before: 0.075654983520508
Time after: 7.8819960355759

I know it is only something that effects logged in users.....

I am assuming the above is checking the number of posts since the last visit - which isn't a standard vBulletin figure right?

I removed the welsome box that holds this info but it still gets stuck on it, so I assume this is something that is checked if the user is logged in, regardless of which templates are being used.

I am quite happy to lose this figure from the script.

Assuming the above is correct, how would I go about removing the bit that does this post count check?

Thanks.

[MikeWarner]

Found it - I have removed this from myvbindex.php:

$getnewposts=$DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline>='$bbuserinfo[lastvisit]'");
$newposts = number_format($getnewposts['count']);

In the "Welcome" templete I changed:

<a href="$bburl/search.php?s=$session[sessionhash]&action=getnew">New Posts</a>: $newposts<br>

to

<a href="$bburl/search.php?s=$session[sessionhash]&action=getnew">Show New Posts</a><br>

If anyone can figure out what is causing this bit to slow things up, do let us all know.

It now loads within one second!

[arracing]

if I have more than 1 database and forum on my site and have the myvbindex page as a portal. How do I set the cookies so that both databases operate normally? Also how will that login panel work on the myvbindex portal, which database will it go to?

Any tips on how to do all this. Basically right now I just have the one database but Im trying to add another forum to the site.

[Zachery]

@arracing it will select whatever database for your site that it you have it set to change directorys for :\, about cookies im not sure :\ ive never goten it to work quite right personally.

@Mike, i asked if you turned all the options off and it looks like you havent, GO INTO the admin cp and turn on and off each setting and watch the load time for each one, this will help you figure out whats causing the drastic load times

my guess would be Latest Forum Topics(very active and l;arge forum)
Home Stats queerys the database for the top poster wich with your forums size could be a problem
and maybe acitve users, due to the fact that if your loged in it checks for buddys lists(i think)

[arracing]

I set the cookie domain for the forum affecting the myvbindex portal to teamrevolution.net and set the cookie to save in the forum directory that its using so /forums/

Then I set my other new forum (database) cookie domain to divisions.teamrevolution.net and the cookie to save in forum directory /divisions/

However when I log in using the individual forums it works fine but when I use the myvbindex login box it doesnt log me in.
I dont understand why because i set one of the settings to affect the entire domain so it should log me in.

Has anyone got more than 1 forum to work right with myvbindex. Please post if you do.

[MikeWarner]

Today at 12:56 AM Faranth said this in Post #1747 (https://vborg.vbsupport.ru/showthread.php?postid=431650#post431650)
@arracing it will select whatever database for your site that it you have it set to change directorys for :\, about cookies im not sure :\ ive never goten it to work quite right personally.


@Mike, i asked if you turned all the options off and it looks like you havent, GO INTO the admin cp and turn on and off each setting and watch the load time for each one, this will help you figure out whats causing the drastic load times

my guess would be Latest Forum Topics(very active and l;arge forum)
Home Stats queerys the database for the top poster wich with your forums size could be a problem
and maybe acitve users, due to the fact that if your loged in it checks for buddys lists(i think) See my posts above. I did turn everything off and the same happened. I've fixed it now (see above).

[arracing]

Okay I have been messing with these cookies and this is where I am at.

Forum1 (v2.3.0 forums includes the myvbindex)
Forum2 (V3 beta 5 forums)

Forum1 cookie domain is .teamrevolution.net and path is /forums

Forum2 cookie domain is blank and path is /divisions

Now both forums stay logged in and that works just fine.
The thing that doesnt work is the login box for myvbindex. When I try and log in to that login box it says thanks for logging in and then returns me to the myvbindex page and doesnt actually log me in. I want that log in box to control Forum1 since that is my big main forum. Forum 2 is an exclusive special forum for certain people.

It just doesnt make sense to me why those settings are not working. I mean Forum one domain says the cookie should effect the whole domain however it doesnt and only effects the /forums

Any help is appreciated. I dont want to have to do away with the login box on the myvbindex but I will if I have to because that is the only thing not working. I still think their should be some fix for this. I cant be the only person with more then 1 forum on a domain using a portal.