vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   mYvBindex v3.1 (https://vborg.vbsupport.ru/showthread.php?t=44691)

CodeDawg 08-19-2003 09:33 PM

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 08-19-2003 09:50 PM

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

Tigga 08-19-2003 11:26 PM

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 08-20-2003 06:34 AM

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 08-20-2003 11:26 AM

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

Shadow_NL 08-20-2003 03:14 PM

Quote:

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)
Quote:

08-17-03 at 03:45 PM Shadow_NL said this in Post #1621
This did not work for me, only the news from XX is showing up. What else can I try?
Can anyone help me?

livewars 08-20-2003 07:06 PM

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 08-20-2003 07:25 PM

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 08-20-2003 08:22 PM

Hi,

i got a problem with the portal.

Once on two there is this error :

Code:

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 08-20-2003 09:25 PM

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

NeRilkA 08-20-2003 09:34 PM

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 08-21-2003 12:51 AM

Quote:

Today at 10:14 AM Shadow_NL said this in Post #1646
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-21-2003 12:59 AM

Quote:

08-12-03 at 08:27 AM Tigga said this in Post #1594
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 08-21-2003 03:57 AM

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 08-21-2003 03:59 AM

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

it seems im gettin better with helping

livewars 08-21-2003 05:00 AM

...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 08-21-2003 05:03 AM

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 08-21-2003 05:09 AM

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 08-21-2003 05:13 AM

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

Replace with:
eval("standardredirect(\"".gettemplate("redirect_l ogin")."\",\"\$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 08-21-2003 05:16 AM

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

Zachery 08-21-2003 05:30 AM

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


Quote:

(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 08-21-2003 05:45 AM

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 08-21-2003 05:47 AM

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

livewars 08-21-2003 07:49 AM

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

Zachery 08-21-2003 08:09 AM

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 08-21-2003 11:18 AM

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

eval("standardredirect(\"".gettemplate("redirect_l ogin")."\",\"/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 08-21-2003 01:44 PM

im running vb 2.3.0 and im fine :\

livewars 08-21-2003 06:44 PM

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 08-22-2003 11:39 PM

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 08-23-2003 10:14 PM

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 08-24-2003 04:44 AM

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 08-24-2003 04:56 AM

<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 08-24-2003 05:55 AM

<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 08-24-2003 02:29 PM

Quote:

Today at 06:56 AM Faranth said this in Post #1672
https://vborg.vbsupport.ru/showthrea...050#post412050


try that

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

Zachery 08-24-2003 02:32 PM

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 08-24-2003 02:32 PM

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 08-24-2003 02:38 PM

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 08-24-2003 02:41 PM

Ok, I got it. open your index file.

Find this:
PHP Code:

// Latest Forum Topics
$threadbits '';
if (
$maxlatethreads!='') {
  
$threads=$DB_site->query("SELECT
threadid,thread.title,replycount,postusername,postuserid,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:
PHP Code:

// Latest Forum Topics
$threadbits '';
if (
$maxlatethreads!='') {
  
$threads=$DB_site->query("SELECT
threadid,thread.title,replycount,postusername,postuserid,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 08-24-2003 02:42 PM

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

zeidlern 08-24-2003 02:44 PM

Quote:

Today at 04:42 PM Faranth said this in Post #1679
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.


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

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

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

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

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