mYvBindex v3.1 [Archive] - Page 2

Tigga

12-19-2002, 09:43 PM

Yup, that can be done fairly easily. Just open up myvbindex.php and look for:
if ($showtodaysevents AND $event[eventdate]==vbdate("Y-m-d",time())) {

Replace that with:
if ($showtodaysevents AND $event[eventdate]>=vbdate("Y-m-d",time()) AND $event[eventdate]<=vbdate("Y-m-d",time()+604800)) {
That will display all events happening in the next week (the number 604800 there is the time limit in seconds). Though the only problem with that is once you get near the end of the month, it will only show the events happening within the next week and before the end of the month because of the way the query above it is set up. If you don't mind adding an extra query to the page I can play with it a bit and try to make it where that wouldn't happen.

DarkDraco07

12-22-2002, 07:10 PM

would be nice to add the shoutbox on the homepage

Tigga

12-22-2002, 07:39 PM

I just looked at the shoutbox hack and it should be fairly easy to add it to your myvbindex instead of your forums index. You would just follow the instructions there, and when you get to the part about adding some code in your forums/index file before
eval("dooutput(\"".gettemplate('forumhome')."\");");
You would add it before this part at the end of your myvbindex file instead:
$getbgrow=getrowcolor();
eval("dooutput(\"".gettemplate('index')."\");");

Then you would add the $the_shoutbox variable in your index template wherever you would like it to appear instead of your forumhome template.

I've never tried adding that feature and never even downloaded that hack until today, but those should be the only changes you would need to make. If for some reason that doesn't work let me know and I'll test it out.

Tigga

12-22-2002, 07:41 PM

By the way... Did you get the problem fixed with your news not showing up? I noticed you edited your original post so I assumed you fixed that, but if not let me know.

DarkDraco07

12-22-2002, 07:47 PM

i thought i did but it stil doesnt work :(

Tigga

12-22-2002, 08:00 PM

I just looked at your site and it looks like it would be because you made those news posts before you installed the script. Any posts you make afterwards should appear fine, but since those were made before you installed the script it has no way to know that those are news posts. If you're familiar with phpMyAdmin you could use that to manually set those posts so they will show up. You would just log into phpMyAdmin and go to your 'post' table. You would then find those posts and click the 'edit' link. At the bottom of that page you will see a column called 'isnews' and it should have a 'N' in the text box. You would simply change that to a 'Y' for each news post. If you're not familiar with phpMyAdmin I can see if I can make a quick re-indexing script for you. I don't mind doing that for you, but it may be a couple of hours before I can make it.

DarkDraco07

12-22-2002, 08:39 PM

would be nice to knwo what to do. in phpmyadmin what do i change to Y?

DarkDraco07

12-22-2002, 08:42 PM

btw, about that shoutbox. when i add the shoutbox it is REALLY big and messes up the whole page. is there a way to change the size yo like the calendar or to fit right under the news?

PS - would be REALLY nice if u could also tell me how to make the glow hack work on the myvbindex. the glow that allows you to glow a bunch of colors forma drop down menu

DarkDraco07

12-22-2002, 09:15 PM

i fixed my news part.

i have a 2 requests.
in the admin cp make an option for it to show sigs or not on the myvb page.

and also see if u can integrate the welcome panel

Tigga

12-22-2002, 10:31 PM

It looks like the shoutbox was designed more to go under one of the tables on the forum home, so to change it to fit in one of your columns you would just have to edit those templates.

Can you give me a link to the glow hack you're talking about so I can see exactly what it is?

The signatures are controlled per post just as when posting a normal message. You can remove them by editing the post and disabling them that way. If you want to control them via the admin cp I can give you some code to replace and a query to run that would add the option.

I think myvbindex has pretty much every feature the welcome panel has. You should be able to edit the templates index_welcometext and index_logincode to look more like the welcome panel, and then you would just move the $welcometext variable in your index template to right above the newsbits part or where ever you would like it.

DarkDraco07

12-22-2002, 11:14 PM

-i got rid of the sigs form the news by erasing the $signature or whatever from newbit.

-so i have to change the shoutbox templates?

-ill try that welcome panel right now

-glow dropdown is here
https://vborg.vbsupport.ru/showthread.php?s=&threadid=43679&highlight=glow+dropdown

reason i want it to glow is because i would like to change the text like User CP and online buddies to glow

Tigga

12-22-2002, 11:23 PM

All that glow hack does is add the option to make your text glow when posting. It would have nothing to do making your text glow when editing templates and such. To make that glow you would just have to use the HTML that's used under the vBcode section in your admin cp (something like <font style="filter:glow(color=red, strength=4);height=1px">your text here</font>)

DarkDraco07

12-22-2002, 11:34 PM

can i see u on AIM about some things?

Tigga

12-22-2002, 11:46 PM

Sorry, but to be honest I'm pretty busy right now working on some stuff for my business that has to be done tonight. If you're still having problems you can post them here and I will try to help, but I don't have the time to chat with anyone on AIM right now.

DarkDraco07

12-23-2002, 12:17 AM

glow works but my main problem is the welcome thingy

Tony DiMera

12-23-2002, 02:29 AM

Will I have to adjust my cookies with v 3.0?

Tigga

12-23-2002, 02:39 AM

Tony - Nope, the settings should be exactly the same and won't affect the cookies. Upgrading should be extremely easy, won't affect any of your current settings, and should take less than a minute unless you have heavilly modified your templates. Even then there is a list of each template that was changed in the readme file. :)

Tony DiMera

12-23-2002, 02:57 AM

Ok thanks a lot.

DarkDraco07

12-23-2002, 04:32 PM

hey plur, for the shoutbox, what part of the template do i have to edit?

SouledOut

12-23-2002, 06:49 PM

Damn this looks hard, espically for a PHP n00b! Good thing I have a friend who I hope is more then willing to help me install it and work it with our layout...

Tigga

12-24-2002, 05:07 AM

DarkDraco - I've never installed the hack so I don't know off hand what it would be. You really should be able to figure that out yourself by looking at the templates.

SouledOut - It really isn't hard at all to install. As long as you follow the instructions in the readme file you shouldn't have any problems. :)

Tony DiMera

12-24-2002, 07:43 PM

I am having a problem, I put in the correct forum ID for the news which is 17 but posts are not showing up on the vbindex. I also made sure it was the correct ID. The polls works fine, just not the news. The Max number of posts is set to 10 and there is an "isnews" under the posts table.

MartynJ

12-24-2002, 10:57 PM

Hello, this hack is working great so far (basically ironing out config probs on localhost before uploading to main site), one or two things I'd like to do/suggest. Would it be possible to have "Add news item" available in the Admin CP? Or perhaps a nice and simple link in the postbit that moves copies any thread to the (hidden) news forum (though I think I'd work on that one myself.)

The other thing I'd like to do is have the forumhome (below news items) as it is in default vB. If you look at the image, you'll see what I mean. Anyone know which parts of code and templates I should copy across to make that work?

EDIT: The clickable link in the postbit: I had this down:

<a href="postings.php?action=move&forumid=14&method=copy&s=$session[sessionhash]&threadid=$post[threadid]">#</a>

And as soon as I click it, I am prompted to select where I want to move it to (though my news forum is hidden and thus not selectable on the drop down). Is there any way to keep the news forum hidden (even from mods/admin) and yet allow the moving of threads this way?

Iezugod

12-25-2002, 01:51 AM

Ok, I have some questions..

first, the link:

www.crystalchronicle.com/myvbindex.php

I want to move alot of the stuff on the left, to the right.

Second:

The site is based off of an RPG Game, and I need to have stuff like:

Walkthroughs
Strategy
Characters
Items
Weapons
Levels
Creatures

And so on, and then have them link to pages that have all that info.

Question is... How do I do that?

Tigga

12-25-2002, 07:24 AM

Tony - Were you upgrading or doing a fresh install? Does it work when you post a new thread in your news forum? Here's the quckest, easiest way I can tell you to fix them for now. Just log into phpMyAdmin and run the following query:

UPDATE post SET isnews='Y' WHERE postid=XX;

XX would be the post id for your news post. You can find that easily by holding the mouse over the "edit" or "quote" buttons for that post and looking in your browsers status bar. At the end of the link you will see "postid=XX". Running that query for each news post will fix the problem for now.

Marty - Adding news through the Admin CP, adding the link to the postbit, and adding the forums homepage under the news would require a little hacking. I can most likely tell you what to change, but it might be a day or two since it's the holidays. ;)

Iezugod - Things can be moved around in the index template. I'm guessing you figured that out though from looking at your site. I'm not sure I follow you about adding the links... Where do you want them added? Are you saying you want to create more templates?

MartynJ

12-25-2002, 06:28 PM

Originally posted by PlurPlanet
Marty - Adding news through the Admin CP, adding the link to the postbit, and adding the forums homepage under the news would require a little hacking. I can most likely tell you what to change, but it might be a day or two since it's the holidays. ;)If you want, I'll contine working on the news Via Postbit thing. I think it would actually be a good deal easier if it was possible to have it such that NEWS on the front page could be read from any thread in any forum, so long as "isnews" was set, thus no longer requiring the special forums. The problem I have at the moment is that with the news forum being hidden, if a user wants to add a comment, they can't since they aren't allowed to post in hidden forums. It would be far easier if the NEWS thread was in a normal forum but simply had a special property attached to it that set it apart from normal threads (such as a sticky).

MartynJ

12-25-2002, 06:46 PM

Hmm, something very strange. Any thread I *start* in the news forum becomes news, but any thread I *move* to the news forum is not recognised as news. Anyone know what's causing this?

Tony DiMera

12-26-2002, 04:31 PM

Originally posted by PlurPlanet
Tony - Were you upgrading or doing a fresh install? Does it work when you post a new thread in your news forum? Here's the quckest, easiest way I can tell you to fix them for now. Just log into phpMyAdmin and run the following query:

UPDATE post SET isnews='Y' WHERE postid=XX;

XX would be the post id for your news post. You can find that easily by holding the mouse over the "edit" or "quote" buttons for that post and looking in your browsers status bar. At the end of the link you will see "postid=XX". Running that query for each news post will fix the problem for now.

It was a fresh installl. BTW I would put 17 inplace of the XX correct? If so, would i put anything inplace of where you have "Y"?

WSB

12-26-2002, 06:35 PM

I got the following error. Please help me out:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT thread.threadid,thread.title,thread.replycount,thr ead.postusername,thread.postuserid,thread.dateline ,thread.views,thread.iconid,thread.votenum,thread. votetotal,post.postid,post.pagetext,post.allowsmil ie,post.showsignature,user.signature,avatar.avatar path,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline AS avatardateline FROM thread LEFT JOIN post USING (threadid) LEFT JOIN user ON (user.userid=post.userid) LEFT JOIN avatar ON (avatar.avatarid=user.avatarid) LEFT JOIN customavatar ON (customavatar.userid=user.userid) WHERE thread.forumid= AND isnews='Y' GROUP BY thread.threadid ORDER BY thread.threadid DESC
mysql error: You have an error in your SQL syntax near 'AND isnews='Y' GROUP BY thread.threadid ORDER BY thread.threadid DESC ' at line 1

mysql error number: 1064

Date: Thursday 26th of December 2002 01:32:26 PM
Script: http://www.worldsoccerboard.com/myvbindex.php
Referer:

Tigga

12-26-2002, 07:00 PM

Marty - The reason that posts are not appearing as news if you move them is because only posts that are started in the news forum will have the 'isnews' column updated. I should have some time later this evening or tomorrow to play with it and tell you how to change it so that a post in any forum could become news.
The problem I have at the moment is that with the news forum being hidden, if a user wants to add a comment, they can't since they aren't allowed to post in hidden forums.
If you changed your news forum and set it so that it was not private and set "Is active?" to no, then your users would be able to reply to and read news posts, but the forum would not appear on your main forums index page.

Tony - Were the news posts made before you installed the hack? If so, then that's why the news wasn't working. It will only recognize news posts that have been posted after the hack has been installed. Either way running the query I gave you above will update the posts so they will appear on your homepage. Please re-read the instructions I gave. 17 is your fourmid, not the postid. You would need to find the postid for each news post and replace the XX in the query with that number. The 'Y' in that query should not be changed.

WSB - You have to set your News Forum ID in your admin options before it will work properly.

jarvis

12-27-2002, 05:44 PM

How hard would this be to add additional boxes within the index file to accomodate:

- Links
- Afilliates
- etc.

Can I just embed the html code within the PHP file? Are the templates that are called a fixed width so that I could emulate the size with respect to what is being drawn by myvbindex?

Has anyone already added these types of fields already and not make me recreate the wheel?

I was also thinking how nice it might be to have multiple instances of myvbindex running that could link multiple news areas of a site while pulling the articles from multiple forums.

For example, main page would show general news from forum xx, but there would be a link box on the side that held different interest areas like PC Games, MAC, etc. These links would pull up another instance of myvbindex that pull articles from the related forum.

Am I just a dreamer? :surprised: :)

Tigga

12-27-2002, 07:22 PM

Originally posted by jarvis
How hard would this be to add additional boxes within the index file to accomodate:

- Links
- Afilliates
- etc.

If you'll refer to posts 194 & 196 in this thread, there are 2 different explanations on how to do that. Either of those ways will work and should be pretty simple.

Can I just embed the html code within the PHP file? Are the templates that are called a fixed width so that I could emulate the size with respect to what is being drawn by myvbindex?
All the "boxes" are tables that have their width set to 100%, which are nested in a table cell with a with of 165. If you look in the index template for that table cell you can change the width there and that will affect all the boxes.

I was also thinking how nice it might be to have multiple instances of myvbindex running that could link multiple news areas of a site while pulling the articles from multiple forums.

For example, main page would show general news from forum xx, but there would be a link box on the side that held different interest areas like PC Games, MAC, etc. These links would pull up another instance of myvbindex that pull articles from the related forum.

Am I just a dreamer? :surprised: :).
That wouldn't be too hard to do... Would you want to have a seperate section with all the options in the admin CP for each, or use the same admin options for all of them and just different news forum id's?

jarvis

12-27-2002, 08:47 PM

Thanks for the quick response!!

This is truly the hack I have been looking for to integrate my site with vB!! Great job... would love to see the develpoment move forward, and oh yeah... the temp bug fixed. :classic:

Anyway, regarding:

That wouldn't be too hard to do... Would you want to have a seperate section with all the options in the admin CP for each, or use the same admin options for all of them and just different news forum id's?

Well, I think for the most part it would all be the same options from a "global" perspective, however, there could be one option that changes with each instance... the poll forum (and the news forum). Otherwise, the rest of the options should be pretty static.

If this type of scenario could happen, I think it would truly be a web-in-the-box scenario. /me drools :knockedout:

Tony DiMera

12-28-2002, 01:24 AM

I made the posts after the installation of the vbindex. The thread/post id was 57 and I tried updating the query like you said and it still isn't showing up? What else can I do to fix this problem :(

Tigga

12-28-2002, 01:58 AM

Tony - Check to see that you edited the newthread.php and newreply.php files correctly and uploaded them, and that your news forum id is set correctly in the admin options. If all that is correct, there is no reason the news posts shouldn't be showing up. If that still doesn't work, please post the url to your site here or PM me with it. Also, did you get any kind of error in phpMyAdmin when you ran those queries? If not, then the only possible problem I can think of is you have your news forum id set wrong. What version of myvbindex and vBulletin are you running?

MartynJ & Jarvis - I'll try to help you two out with your customization as soon as I can. With the combination of the holidays, having a lot of work to do with my business, and being sick for the last 3 days, I haven't had much time to work on this.

Tony DiMera

12-28-2002, 02:16 AM

I am running version 3.0. it appears to be working now. I guess my ftp didn't upload the new reply and new thread scripts when I had selected them. Thanks again. BTW in the options there isn't an option to turn on or off the weather hack.

Tigga

12-28-2002, 02:23 AM

I knew it had to be something like that. :)
The option to turn the weather on/off will only be added when you run the weather_install.php file. I did it that way because it will produce an sql error if the weather isn't installed and you turn it on. If you do have it installed and somehow that option wasn't added let me know and I can tell you how to add it.

Tony DiMera

12-28-2002, 02:26 AM

Because when I try to go to the url of the weather_install.php which is in my admin folder it says pagecannot be displayed

Tigga

12-28-2002, 02:33 AM

Odd... The only thing I can suggest is to double check that it is uploaded to the directory and that you are going to the right URL.

Tony DiMera

12-28-2002, 02:51 AM

It is correct. I also pmed you the url of the script.

Tigga

12-28-2002, 03:09 AM

That's really weird... I have no idea why it would give you that error if the file is in your admin folder. It shouldn't give you a "Page cannot be displayed" error if the file exists.
You could do the queries manually instead. This post has a zip file with the queries you can run though phpMyAdmin - https://vborg.vbsupport.ru/showthread.php?postid=318513#post318513

Just follow the instructions in the post and that way should work. Oh, before you run the weather_template.php file though, open it and look for:

$DB_site->query("INSERT INTO setting VALUES (NULL,50,'Show Weather?','showweather','0','Show the weather forcast on your homepage.','yesno','21');");

Change the '21' at the end of that to '27'

Tony DiMera

12-28-2002, 03:16 AM

Ok thanks, and will it automatically put the opotion inthe cp options to turn it on for the vbindex? Also could you try sending my the exact script you used to my e-mail at F_T_R@msn.com ?

Tigga

12-28-2002, 03:26 AM

Yes, that will add the option to turn the weather on/off. That part you need to edit in the file is actually the query that adds the option.
Do you mean the exact weather_install.php script I used, or the zip file with the manual queries?

Tony DiMera

12-28-2002, 03:28 AM

The exact weather_install.php file that you used for your site. Thanks again for you help.

Tigga

12-28-2002, 03:47 AM

Ok, well I tried to send the file but the email was returned saying it was too big. I'll just attach it here.

Tigga

12-28-2002, 04:02 AM

Ok MartyJ, here's at least half of what you wanted. :)
To make it so that you can make a news post in any forum:

You will need to run these queries in phpMyAdmin before uploading your changed files:
ALTER TABLE post DROP `isnews`;

Then this query:
ALTER TABLE post ADD isnews char(1) NOT NULL DEFAULT 'N';

Note that after you run those queries no news posts will be visible on your myvbindex page. This is necessary since you are in a sense completely changing the way the news part works.

Create a new template called newthread_newsopt with the following content:
<br><input type="checkbox" name="isnews" value="Y"> <b>Make News:</b> Make this post news?

Then edit your newthread template and look for:
<input type="checkbox" name="signature" value="yes" $signaturechecked> <b>Show Signature:</b> include your profile signature. Only registered users may have signatures.

Right Below that Add:
$newsoption

Edit your editpost template and find:
<input type="checkbox" name="signature" $signaturechecked value="yes"> <b>Show Signature:</b> include your profile signature. Only registered users may have signatures.

Right Below that Add:
$newsoption

Open myvbindex.php and find:
WHERE thread.forumid=$newsforum AND isnews='Y' GROUP BY thread.threadid ORDER BY thread.threadid DESC $newsmax");

Replace that with:
WHERE isnews='Y' GROUP BY thread.threadid ORDER BY thread.threadid DESC $newsmax");

Then open your newthread.php file and look for:
'$ipaddress','$iconid','1','Y')");

Replace that with:
'$ipaddress','$iconid','1','$isnews')");

Still in newthread.php, find:
if ($permissions[canpostattachment] and (!$safeupload or function_exists("is_uploaded_file"))) {
eval("\$attachmentoption = \"".gettemplate("newpost_attachment")."\";");
} else {
$attachmentoption="";
}

Above that Add:
$newsoption = '';
if (in_array($bbuserinfo['usergroupid'], array(5, 6))){
eval("\$newsoption .= \"".gettemplate('newthread_newsopt')."\";");
}

Open your editpost.php file and look for:
$editattachment = '';
if ($postinfo[attachmentid]!=0 and (!$safeupload or function_exists("is_uploaded_file"))) {
// show edit attachment options
// keep, delete, new upload
$attachmentinfo=$DB_site->query_first("SELECT filename FROM attachment WHERE attachmentid=$postinfo[attachmentid]");
$postinfo[filename] = htmlspecialchars($attachmentinfo['filename']);

Above that Add:
$newsoption = '';
if (in_array($bbuserinfo['usergroupid'], array(5, 6))){
eval("\$newsoption .= \"".gettemplate('newthread_newsopt')."\";");
}

Still in editpost.php, find:
$DB_site->query("UPDATE post SET title='".addslashes(htmlspecialchars($title))."',pagetext='".addslashes($message)."',allowsmilie='$allowsmilie',showsignature='$signa ture',iconid='$iconid'$editedbysql$attachmentsql WHERE postid='$postid'");

Replace that with:
$DB_site->query("UPDATE post SET title='".addslashes(htmlspecialchars($title))."',pagetext='".addslashes($message)."',allowsmilie='$allowsmilie',showsignature='$signa ture',iconid='$iconid',isnews='$isnews'$editedbysq l$attachmentsql WHERE postid='$postid'");

Upload the changed files and make sure you have ran the queries in phpMyAdmin. Now admins for your board will see an extra check box right under "Show Signature" with the option to make the thread news. If you don't want this option to be available to all admins let me know and I can tell you how to change who will see the option.

Tigga

12-28-2002, 04:30 AM

jarvis - Here is how you would go about using multiple myvbindex's.

First make a copy of your myvbindex.php file and rename it to whatever you would like it to be called. In the copy, look for:
WHERE thread.forumid=$pollsforum

Replace that with:
WHERE thread.forumid=$pollsforum2
(Just adding a 2 at the end of $pollsforum)

Then look for:
WHERE thread.forumid=$newsforum

Replace that with:
WHERE thread.forumid=$newsforum2
(Again, just adding a 2 at the end)

Then you will want to run the following queries with phpMyAdmin:

INSERT INTO setting VALUES (NULL,50,'2nd News Forum ID','newsforum2','','The ID number of your news forum.','','31');

INSERT INTO setting VALUES (NULL,50,'2nd Polls Forum ID','pollsforum2','','The ID number of your polls forum.','','32');

That should be everything you need to do to use another myvbindex with different news and poll id's. The News & Poll ID settings will be at the bottom of your myvbindex options in the Admin CP.
Then to add additional copies, you would change the number in the file modifications each time to 3, then 4, and so on. In each of the queries you should run, I marked in bold the parts that will change with each new copy. The first part marked in bold has '2nd News Forum ID'. That can say whatever you would like to distinguish which part of the forum that is for. Then the '2' that is marked in bold should be changed to 3, then 4, and so on. Then the last numbers (31 for the news query, 32 for the poll query) is the part that orders the options. Those numbers should increment for every new option, so the next copy you add should have 33 at the end of the news query, and 34 at the end of the poll query.

Ok, that should be it. I tried to explain all that the best I could, so hopefully it makes sense. If you have any problems or don't understand part of it let me know.

TECK

12-28-2002, 08:22 AM

Originally posted by PlurPlanet
mYvBindex 3.0 released!

Credits:
mYvBindex uses modified versions of the following hacks:
Mini Calendar from vbPortal (https://vborg.vbsupport.ru/showthread.php?s=&threadid=32087) - by wajones
vB Weather Mk. 2 (https://vborg.vbsupport.ru/showthread.php?s=&threadid=41842)- by JJR512
PlurPlanet, you also use my XX Latest Threads (https://vborg.vbsupport.ru/showthread.php?s=&threadid=43310) and some code technique borrowed from vbHome (lite) (https://vborg.vbsupport.ru/showthread.php?s=&threadid=36756) script.
You had that added before, but you decided to remove it.

Also you should mention to your users that the way you have set the script, it will add at least one query for every new article you display.
So if you have for instance 15-20queries (due to few options enabled) and you display 15 articles posted, your total queries will be 30-35. I'm sure if you enable all your options, you could endup easy with 40-50 queries easy on the front page.
40-50 queries on a busy site will kill your server, so you should be careful with the options and let the users know about it.

Tigga

12-28-2002, 08:28 AM

Originally posted by TECK PlurPlanet, you also use my XX Latest Threads (https://vborg.vbsupport.ru/showthread.php?s=&threadid=43310) and some code technique borrowed from vbHome (lite) (https://vborg.vbsupport.ru/showthread.php?s=&threadid=36756) script.
You had that added before, but you decided to remove it.
3.0 no longer uses your latest threads hack. Many parts of the coding were completely re-written.

Also you should mention to your users that the way you have set the script, it will add at least one query for every new article you display.
Um, no. The number of queries does not increase with the number of news posts. It will be the same whether you have 5 or 50.

So if you have your for instance 15-20queries (due to few options enabled) and you display 15 articles posted, your total queries will be 30-35. I'm sure if you enable all your options, you could endup easy with 40-50 queries easy on the front page.
40-50 queries on a busy site will kill your server, so you should be careful with the options and let the users know about it. [/B]
And no again. With every option turned on it will perform no more than 29 queries.

Smoothie

12-28-2002, 08:42 AM

PlurPlanet-

Hi. I just checked your page, the first time it loaded there were 35 queries, the second time, 33. Yet you say max 29 queries with your script and all options enabled?

Tigga

12-28-2002, 08:48 AM

Well if what Teck says is correct, then I would have to have more than one news post wouldn't I? My index page normally has 25 queries since I don't use all the options. If you'll look again, you'll notice a few things aren't working right now, and the reason it's displaying so many queries is because it's not caching the templates for some reason. I finally upgraded to 2.2.9 and I guess I did something wrong.

Tigga

12-28-2002, 08:59 AM

Btw, if you look again it's running the way it should (20 queries as guest, 25 when logged in). When I ran the vB upgrade script I guess it deleted my templates, which would explain why nothing was working right. :)

TECK

12-28-2002, 09:23 AM

Aha, post 2 more articles and let me know what's happening to the no. of queries. You will see that increases every time you post a new article, because you use queries in a loop.
Cheers.

PS. You still use my latest threads code. Hihi, bad boy. :p

Tigga

12-28-2002, 09:39 AM

Originally posted by TECK
Aha, post 2 more articles and let me know what's happening to the no. of queries. You will see that increases every time you post a new article, because you use queries in a loop.
Cheers.
My God, would you like me to make some more news posts on my site? Or would you like the url to my test server where there are about 8 news posts at the moment? You really have no idea what you're talking about. :rolleyes:

Cloud Strife

12-28-2002, 09:47 AM

Wow... I really like this one, i got rid of vbindex2 to put this one on...

Great job...

Clicks install

cloud

Tigga

12-28-2002, 09:59 AM

Thanks Cloud. Glad you like it. :)

Here's a couple of other sites you can compare as well Teck
http://killianboard.net/vbull/myvbindex.php
http://www.ls6.com/

TECK

12-28-2002, 10:04 AM

Originally posted by PlurPlanet

My God, would you like me to make some more news posts on my site? Or would you like the url to my test server where there are about 8 news posts at the moment? You really have no idea what you're talking about. :rolleyes:
Brian, quit being rude and listen instead. You obviously don't know that you perform a query in the loop for every article.
Let me explain to you where are the problems:
First, you use the getavatarurl() function that adds an extra query for each article you display.

Second, you really need to check your code syntax. I saw several mistakes there... like for example:
DESC LIMIT 1");{
Third, if you made your own code, why do you use the time() function, when in vBulletin is already defined? (not really important... but it shows if you know or not the vBulletin functions)

I could go on and on... but you get the idea. Why not be a nice guy and ask for help instead? And also post the credit where is due? Do you want me also to post here what php code and functions you used from vbHome?

Tigga

12-28-2002, 10:19 AM

Originally posted by TECK
First, you use the getavatarurl() function that performs an extra query for each article you display. Is better to ask instead of complaining...
Maybe you should take a look at the code again. The only place the getavatarurl function is used is to pull the users avatar in the welcome box. The way I pull the news avatar will not add any extra queries at all.
// News Avatar
if ($shownewsavatar) {
if ($news[avatarpath]!="") {
$newsavatarurl = "$bburl/$news[avatarpath]";
} else if ($news['hascustom']) {
$newsavatarurl = "$bburl/avatar.php?userid=$news[postuserid]&dateline=$news[avatardateline]";
} else {
$newsavatarurl = "https://vborg.vbsupport.ru/images/clear.gif";
}
eval("\$news[avatar] = \"".gettemplate("index_newsbits_avatar")."\";");
}

Second, you really need to check your code syntax. I saw several mistakes there... like for example:
DESC LIMIT 1");{
Thank you for pointing that out. I'm sure it's very possible that I have a typo or two in there, nobody's perfect. Something like that really isn't that big of a deal, but if saw other mistakes please point them out to me.

Third, if you made your own code, why do you use the time() function, when in vBulletin is already defined?
The time function is only used in the original vBulletin code.

Do you want me also to post here what php code and functions you used from vbHome?
Please do. I've learned quite a bit about PHP since the first version of this hack and v3.0 is all original code or code straight from vBulletin, with the exception of the calendar and weather parts in which full credit is given.

Not to mention that you infringe the Jelsoft copyright by copying several code segments onto your file...
If that's the case, then don't you as well? Where did the poll and online users part of your hack come from?

TECK

12-28-2002, 10:52 AM

1. Aha, I see.. I thought you did this from my previous vbHome versions (1.0 or 1.1).
Good to know you didn't make the same mistake like I did.

2. Glad I could help. :)

3. Use $ourtimenow instead.

4. So far, from what I see you got ideas from my script on the following areas:
- alternate colors on threads function (old vbHome version)
- threads permissions
- latest threads
- plural function
- article
Basically you copied the code and edited a little the variables to look different.

5. I removed that remark, but you were to fast for me, since is not my place to judge this but the mods here at vb.org. Sorry.
However, my poll and online users code is not the vBulletin one.
Feel free to compare it.

jeffj

12-28-2002, 03:17 PM

I just installed it and the instructions are very well done...

my only problem is that myvbindex.php hangs as soon as i add the forum ID that contain the polls if that forum has a POLL or a thread in it.

It does not hang if the forum is empty.

- jeff

jarvis

12-28-2002, 04:22 PM

Plur,

Thanks for the response. I will do the modifications for multiple myvbindex loads tonight.

Your support has been first rate! Hope you feel better...

FWIW... Teck, you really should take your comments offline. This petty conversations just seems like an attempt at one upping or proving who the better coder is.

I looked at your product as well and thought it was great, but I just liked the way I could play around with the formatting in this one a bit better. It's the add-on community that continues to make vB a great product, but this mine-is-better routine is wearing thin.

/me steps down off soap box.

Take care!

MartynJ

12-28-2002, 04:55 PM

Yes, I'd have to agree with jarvis. It is getting quite tedious. I've something to add to this thread (attachment wise) though I can't, because every time I click the "post reply" button I get the following error message:

Fatal error: Maximum execution time of 15 seconds exceeded in /www/vbulletin.org/htdocs/forum/admin/functions.php on line 1067

Anyone else got that?

Tigga

12-28-2002, 09:41 PM

1. Aha, I see.. I thought you did this from my previous vbHome versions (1.0 or 1.1).
Good to know you didn't make the same mistake like I did.
Yea, believe me I struggled with that one for a little while before I finally figured out it was the getavatarurl function that was adding the extra query. ;)

2. Glad I could help. :)
Again, thanks for pointing that out and if you happened to notice any other small mistakes, by all means please point them out.

3. Use $ourtimenow instead.
Ahhh, I hadn't really seen that function since it's not used much at all in vB. Thanks for pointing it out, it may be helpful for future versions. :)

4. So far, from what I see you got ideas from my script on the following areas:
- alternate colors on threads function (old vbHome version)
Ahhh... Yes, you are correct about this one. I had been using that for so long and it's been so long since you've used it in vBhome that I forgot where it came from. Obviously it's the same function and idea used in vB just changed around a little, so if it bothers you that it's in there I will gladly change it.

- threads permissions
Actually that was just taken from forumdisplay.php. I believe it was PPN who posted a while ago where to find that. ;)

- latest threads
As you know that was originally a modified version of your Latest XX Threads hack. You posted a while ago that you would prefer that it was not used, so I re-wrote that part for this version. I left the main variables the same so that people would not have to completely change their templates, but that part of the code was done from scratch.

- plural function
That idea actually came from a script called openreality. I believe (though I could be wrong) that I was actually using that on my personal site before you started using it in vBhome. The idea is so simple and basic, so of course the coding is going to be very similar.

- article
Basically you copied the code and edited a little the variables to look different.
The news part is all my code (and has been since 2.0) with parts from vBulletin files used (such as the part to pull the avatars). I did however check vBhome to see how you did the part near the top which will allow you set the news variable to 0 for no limit. I was playing with that a few months ago and for some reason could not figure out how to set the news limit where 0 would be no limit. Finally I checked to see how you had done it and felt pretty dumb afterwards since I was making such a simple mistake. (basically I didn't move the LIMIT part from the query to the part above). I didn't think it was a big deal since all I figured out from looking at your code was to move the LIMIT out of the query, which I'm sure I would have realized what a dumb mistake I was making eventually.

5. I removed that remark, but you were to fast for me, since is not my place to judge this but the mods here at vb.org. Sorry.
However, my poll and online users code is not the vBulletin one.
Feel free to compare it.
From reading the rules to posting a hack, I don't believe anything was done wrong. If so I would think an administrator would have said something by now. And I did compare the poll section again. Yes, there are quite a few changes, but the majority of the code is straight from vBulletin.

And I do apologize for being a bit rude at first, but you were wrong by saying it was adding so many queries. I couldn't understand why you were trying to say that when I knew exactly the way the script works, so I'm sure you can see why I was a bit irritated.

Tony DiMera

12-28-2002, 09:43 PM

Thankjs PlurPlanet, I'll let you know how it works.

Tigga

12-28-2002, 09:51 PM

jeffj - I'm not exactly sure what you mean by "hangs". Could you please explain what you mean in a little more detail?

Jarvis - You'll have to let me know how it went when you're finished. That's a very creative way to use the hack and I'd like to see the finished result. :) Note that I did not test this, but it really is quite simple so you shouldn't have any problems.

Tony DiMera

12-28-2002, 09:56 PM

Itstill does the samething. Iwonder why this is happening

Tigga

12-28-2002, 10:08 PM

That really is strange... I also tried going to yoursite.com/forums/admin/index.php (expecting to get the login screen) and got a page cannot be displayed error. The same with yoursite.com/forums/index.php. :confused:

Tony DiMera

12-28-2002, 10:17 PM

Try it again, it should work now.

Tigga

12-28-2002, 10:59 PM

Ok, the other url's work fine now. I just noticed that none of those were working, so thought that might be a problem as well.
I just uploaded the weather_install.php file to my site to double check that it was working properly and had no problems. At this point, there's really not much I can think of... You may want to compare the file sizes of the file on your hard drive and the file on your sever to make sure that the upload went though. Also be sure that the file was uploaded in ASCII and not Binary. Other than that, I can't think of any other reason it wouldn't be working. If none of that works the only other thing I can suggest is to run the queries through phpMyAdmin. Doing it that way is a little more work, but still shouldn't take more than about 10 minutes to complete.

Tony DiMera

12-28-2002, 11:10 PM

on the left side it shows 3.00MB but on the right side it shows 2.96MB after it is uploaded.

Tigga

12-28-2002, 11:24 PM

That sounds about right (my mistake, I forgot the size will be slightly less when uploaded in ASCII). I'm wondering if perhaps your server is having a problem handling a file that big. It doesn't seem like it should, but you never know with computers. I don't see why this would help, but you could maybe try renaming the file to something simple (like w.php) and try running that. I don't see why that would make a difference at all, but it might be worth a try. If that still doesn't work then I can only suggest to run the queries manually.

Tony DiMera

12-28-2002, 11:35 PM

Ok thanks a lot

Tigga

12-29-2002, 12:24 AM

No problem. Sorry the install script wasn't working for you.

Tony DiMera

12-29-2002, 12:40 AM

That's ok, I did it by doing the queries in the phpmyadmin. thankyou for the vbindex and for helping me with the news and other problems, and for trying to help with the install script. BTW, I know this is most likely a little early, but what new stuff do you plan on adding in future versions?

WSB

12-29-2002, 03:40 AM

PlurPlanet, thanks for your help; I got it working fine.

Is there anyway to put the first XX characters of the actual post in the latest threads section? Also, I want to be able to put "latest reply by X" in addition to "thread started by X". Thanks.

Tigga

12-29-2002, 04:29 AM

WSB - Adding the last poster is pretty simple. Just open your myvbindex file and look for:
$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");
Replace that with:
$threads=$DB_site->query("SELECT threadid,title,replycount,postusername,postuserid, dateline,views".iif($showthreadicon, ',thread.iconid','').",lastposter FROM thread WHERE open='1' AND open<>10 $iforumperms ORDER BY lastpost DESC LIMIT $maxlatethreads");

Then you would add this code in your index_threadbit template where you want the last poster's name to appear:

<a href="$bburl/member.php?action=getinfo&find=lastposter&threadid=$thread[threadid]">$thread[lastposter]</a>

Putting the first XX characters of the post would require a bit of hacking and some database changes. I may be able to tell you how to do that a little later.

jarvis

12-29-2002, 06:01 AM

Plur,

I implemented the changes to support multiple myvbidex calls. Things work like a charm. I am relaunching our gaming website using this method. Things are not done, but you can get a sense of how I'm using the multiple calls based on the site links.

The website is www.mhogaming.com

Works great! Great Help! Overall, top notch... thanks for the effort, and can't wait to see what else you come up with. Maybe it will be the temperature bug fix. ;)

Tigga

12-29-2002, 06:13 AM

Looks good so far, though I didn't see links anywhere to the other copies of myvbindex. Did I miss something, or are they just not linked yet? :confused:

And I wish I could find a fix for the temperature in the weather part too, or at least another site to get the stats from. It works ok on my site, but I've seen too many people that it doesn't work for. :(

jarvis

12-29-2002, 06:21 AM

though I didn't see links anywhere to the other copies of myvbindex

In the site links area, there is a Counter Strike section that has a link to "Main Page". This is the reference to my second instance of myvbindex. I will follow the same format for each area I add.

Thanks again, and I'll be patient for the weather thing. :nervous:

Tigga

12-29-2002, 06:26 AM

Ahhh ok. Looking very nice indeed. Hope you and your members enjoy the hack. :)

jeffj

12-29-2002, 02:07 PM

I found what's causing myvbindex to hang on polls.

it's that call to get_bbarraycookie

I'm running 2.2.5 and that function does not exist in 2.2.5...

any ideas???

====================================

never mind folks. I downloaded 2.9 and grabbed the function from functions.php. The function is isolated and has little effect on any other modules, so I was able to just paste it into 2.2.5 and polls work properly now..

:)

MartynJ

12-29-2002, 03:36 PM

There's something up with vB.org and I can't actually reply to this thread directly. So after editing the file manually on my own computer and trying it, I hope this actually uploads...

MartynJ

12-29-2002, 03:38 PM

There's something up with vB.org and I can't actually reply to this thread directly. So after editing the file manually on my own computer and trying it, I hope this actually uploads...

(File number 2)

DarkDraco07

12-29-2002, 04:51 PM

would be a challenge for someone to do this but i bet 99% of people installing this will want it:

make the myvbindex.php page stay open even though the forum is closed

MartynJ

12-29-2002, 05:10 PM

What, that page stays open even though the forum is closed as in, the vBulletin options page in Admin CP is set to close the board? Hmm, that *would* be a challenge I think...

jeffj

12-29-2002, 05:54 PM

Originally posted by MartynJ
What, that page stays open even though the forum is closed as in, the vBulletin options page in Admin CP is set to close the board? Hmm, that *would* be a challenge I think...

mine does not....

MartynJ

12-29-2002, 06:17 PM

The board (when closed) is still open for browsing by admins. What DarkDraco is suggesting is a reworking that allows the index to remain open to all users while the board is closed.

Tigga

12-30-2002, 03:03 AM

jeffj - Thanks for pointing out the problem with vB 2.2.5. I only had versions 2.6+ to test it on so it figures problems would arise with the version right before. I'll try to find a way to work around that or add something about it in the readme file for v3.1.

I'll see if I can make a 'mini-hack' to keep the index page open when the board is turned off. I don't think it would be too hard to do.

Tony DiMera

12-30-2002, 08:07 PM

I asked about handling large files on myserver and they said "FTP and e-mail do not have size restrictions"

Kamui Shirou

12-30-2002, 08:07 PM

really nice hack. good work. but one problem arised.
by clicking on Change Settings in the weather box, this sql error arises. hope ya can help me out.

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT accid,city_title FROM weather_city WHERE subdivid= ORDER BY city_title
mysql error: You have an error in your SQL syntax near 'ORDER BY city_title' at line 1

mysql error number: 1064

Date: Monday 30th of December 2002 11:00:55 PM
Script: http://www.mangaboard.com/forums/forums/weather.php?action=modifysettings
Referer: http://www.mangaboard.com/myvbindex.php

Tigga

12-30-2002, 08:31 PM

Tony - It would be more your server's capability to run the large file, not the ability to ftp it. And that still may not be the reason it wouldn't work at all, just one possibility...

Kamui - I just registered on your fourm to test it and got an error too. Did the weather_install file finish running? I'm not completely sure what would be causing that error, but I'll be glad to try and help you troubleshoot. Do you know what version of PHP and MySQL you're running?

This may help...

Open your weather.php file and look for:
$current_subdiv = $DB_site->query_first("SELECT subdivid FROM weather_city WHERE accid='$usersettings[accid]'");
$cities = $DB_site->query("SELECT accid,city_title FROM weather_city WHERE subdivid=$current_subdiv[subdivid] ORDER BY city_title");
Replace that with:
$current_subdiv = $DB_site->query_first("SELECT subdivid FROM weather_city WHERE accid='$usersettings[accid]'");
$currentsetting = $current_subdiv[subdivid];
$cities = $DB_site->query("SELECT accid,city_title FROM weather_city WHERE subdivid='$currentsetting' ORDER BY city_title");

If that doesn't work, you may want to log into phpMyAdmin and double check that your database contains the following tables - weather_city, weather_country, weather_region, weather_subdiv, weather_userdata, weather_usersettings

Tony DiMera

12-30-2002, 08:44 PM

I e-mailed them asking about the capability to run a large 3 MB in size php file.

Kamui Shirou

12-31-2002, 06:14 AM

i manuelly did the changes to the database cuz the install script didnt work. and i?ve downloaded that file on page 21.
i?ll try your suggestion. thankx a lot.

edit:
my database contains all tables. i did the changes in my database
once more but still doesnt work, also with your weahter.php change it causes the error

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT countryid FROM weather_subdiv WHERE subdivid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Tuesday 31st of December 2002 09:06:56 AM
Script: http://www.mangaboard.com/forums/forums/weather.php?action=modifysettings
Referer: http://www.mangaboard.com/myvbindex.php

my server runs with
PHP/4.2.3
mysql dont exactly know but this shows up in phpmyadmin
Connected with MySQL 3.23.54-log ................

PS: Does the myvbindex show up in the who?s online list?

Tigga

12-31-2002, 08:21 AM

Ok, it looks like that the change does fix the first problem, but you get a new error a couple of lines down in the script. It appears something on your server doesn't like the way the script is written. Try uploading the weather.php file I have attached here. It's the exact same, except it has ' ' marks around the variables that it doesn't seem to be pulling right, which should (hopefully) fix the problem. If that doesn't work then I can most likely fix it using a different method.

mYvBindex does not show up on the Who's Online, but it's not hard to change it so it will.

Open your forum/online.php file and look for:
case 'index':
$userinfo[where] = "$bbtitle <a href='index.php?s=$session[sessionhash]'>Main Index</a>";
break;
Right Above that Add:
case 'home':
$userinfo[where] = "$hometitle <a href='/index.php?s=$session[sessionhash]'>Main Index</a>";
break;

Then look for:
case 'index.php':
$userinfo[activity] = 'index';
break;
Directly Above that line Add:
$userinfo[activity] = 'home';
break;

Note that I'm assuming your myvbindex file is called "index.php" and it's in your root directory. If you've named it something else let me know as the instructions would be slightly different.

Kamui Shirou

12-31-2002, 09:54 AM

ok it fixed the main prob but there still a prob arising.
when i wanna choose the german cities there´re none to select.

Tigga

12-31-2002, 10:05 AM

There don't seem to be any cities to choose from, for any country. I'd reccomend logging in with phpMyAdmin and checking that your weather_city table is not empty. If so, you should run the weather_city1.sql - weather_city6.sql files there. If that table is not empty, let me know how many records it has in it.

Kamui Shirou

12-31-2002, 12:11 PM

yeah i reinstalled the changes in the sql severl times now but still germany and some other didnt want to show up. i think the sql files included in the weather.zip file i downloaded are incomplet.
my weather_city table in the databse has 2.627 records

thankx for helping me ^^

Tigga

12-31-2002, 12:17 PM

Yup, that would be your problem. There should be something like 37,000 cities. Where did you download the zip file from? If it wasn't from this thread, here's a link to the zip file I made - https://vborg.vbsupport.ru/attachment.php?s=&postid=318513
You should empty your weather_city table, then be sure to run the queries in all 6 weather_city.sql files.

Kamui Shirou

12-31-2002, 12:36 PM

thats exactly the one i downloaded before
i try to split it in more parts

Kamui Shirou

12-31-2002, 01:13 PM

k that was the misstake. my hoster database was not gonna suck all at once. so i split them to 3000 record steps.

Wells

01-01-2003, 09:53 AM

Happy New Year to all.
Please, I need help!
I do everything and everything is ok.
But myvbindex.php says
Database error in vBulletin 2.2.9:

Invalid SQL: SELECT thread.pollid, thread.open, thread.threadid, thread.replycount, poll.pollid, poll.question, poll.dateline, poll.options, poll.votes, poll.active, poll.numberoptions, poll.timeout, poll.multiple, poll.voters FROM thread LEFT JOIN poll ON (thread.pollid=poll.pollid) WHERE

etc

mysql error number: 1064

but with mysql everything is ok... So I do not know what to do...

Admin CP is ok. MySQL queries is ok, but myvbindex.php not working... [I made changes "full path to your forum on your server" correctly]

Tigga

01-01-2003, 09:59 AM

Without seeing the full error I can't tell for sure, but it looks like you have the poll turned on and no Poll Fourm ID specified (or the id isn't set correctly). Double check that and if that's not the reason please post the full error message you get here.

Kamui Shirou

01-01-2003, 10:23 AM

hum i nearly forgot to thank ya PurePlanet.
Thanx ^^

Wells

01-01-2003, 10:25 AM

So,
no, with Poll URL no problems. I set up it to http://www.mysite.net/forum/forumdisplay.php?s=&forumid=21 as you wish. Maby in some file....

So I have in my root directory file called index2.php [myvbindex.php] and full error [something with poll butwhat :(( ???]:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT thread.pollid, thread.open, thread.threadid, thread.replycount, poll.pollid, poll.question, poll.dateline, poll.options, poll.votes, poll.active, poll.numberoptions, poll.timeout, poll.multiple, poll.voters FROM thread LEFT JOIN poll ON (thread.pollid=poll.pollid) WHERE thread.forumid=http://www.mysite.net/forum/forumdisplay.php?forumid=21 ORDER BY thread.pollid DESC LIMIT 1
mysql error: You have an error in your SQL syntax near '://www.mysite.net/forum/forumdisplay.php?s=e2527ec4c416e553eaa3ef0471f35' at line 1

mysql error number: 1064

Date: Wednesday 01st of January 2003 02:13:43 PM
Script: http://www.mysite.net/forum/index2.php
Referer:

I change my server info to www.mysite.net [don't want to spam :) ]

So if you can help me i'll be very happy :)))

Tigga

01-01-2003, 10:29 AM

That's the problem. The polls forum id is supposed to be set to just the forum id, not the whole url. Try changing it to 21. ;)

No problem Kamui. Hope you enjoy the hack. :)

Wells

01-01-2003, 10:37 AM

I try to set Show Poll?
to no and go to next error:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT thread.threadid,thread.title,thread.replycount,thr ead.postusername,thread.postuserid,thread.dateline ,thread.views,thread.iconid,thread.votenum,thread. votetotal,post.postid,post.pagetext,post.allowsmil ie,post.showsignature,user.signature FROM thread LEFT JOIN post USING (threadid) LEFT JOIN user ON (user.userid=post.userid) WHERE thread.forumid=http://www.mysite.net/forum/forumdisplay.php?s=&forumid=20 AND isnews='Y' GROUP BY thread.threadid ORDER BY thread.threadid DESC LIMIT 10
mysql error: You have an error in your SQL syntax near '://www.mysite.net/forum/forumdisplay.php?s=&forumid=20 AND isnews='Y' GR' at line 1

mysql error number: 1064

Date: Wednesday 01st of January 2003 02:32:52 PM
Script: http://www.mysite.net/forum/index2.php
Referer:

Wells

01-01-2003, 10:41 AM

WOW-WOW-WOW
many thanks, I change and everything working. INCREDIBLE!

Thanx a lot.

Happy New.

Wells

01-01-2003, 11:00 AM

And one more question...
how can I change language in your hack?
Because all in english...

Tigga

01-01-2003, 11:23 AM

The only way to change the language would be to edit the templates. I think there's only 2 places any words are coded in the file. Those would be:

$replytext = 'Reply';
} else {
$replytext = 'Replies';
}

There should be 2 instances of that code, and other than that everything is in your index templates.

Tigga

01-01-2003, 12:43 PM

Ok, I think I might have found a fix for the weather temperature bug. If the temperature won't show up with your weather forcast, try doing this:

Open your admin/functions.php file and look for:
// ###################### Weather Functions #######################
function convert_temp($number,$tpc) {
$number *= 1;
if ($tpc == 0) {
$number = (5/9) * ($number-32);
$number = round($number);
return "$number?C";
} else {
return "$number?F";
}
}
Replace that with:
// ###################### Weather Functions #######################
function convert_temp($number,$tpc) {
$number *= 1;
if ($tpc == 0) {
$number = (5/9) * ($number-32);
$number = round($number);
return "$number";
} else {
return "$number";
}
}

Then download the attached zip file, upload the weather.php file to your forums directory, then change the index_weather_main and index_weather templates to the ones in the zip. Let me know if it works. :)

DarkDraco07

01-01-2003, 03:02 PM

*continues to wait for the mini-hack* :p

jarvis

01-01-2003, 04:57 PM

ding ding ding ding ding.... looks like we have a winner!! :D

The weather bug appears to have been squashed!!

Thanks for the continued great support... I'm really loving the hack and being able to modify it to handle all of my web pages.

Thanks again!

ChrisLohman

01-01-2003, 08:20 PM

This is an excellent hack. Thank you very much not only for the hack, but for the clean install, the clean layout using templates, and the overall high quality of this.

Ran into a problem with this in 2.2.9. When I first set it up, my polls forum was empty. Not having any polls to display would cause the myvbindex.php to crash. If I turned off the showing of polls, or just created a poll in my polls forum, then the front page worked.

That's the extent of my ability to do custom things so I have a question for you: Could you possibly provide some code that would allow me to specifify only certain forums to use when considering the "latest threads" on the front page? I am of course trying to do this on my own but; since I can't actually code php I'm certain it will take me years to figure out. It would be nice to have in the vBulletin options, where the other myvbindex stuff is, to have a text field where I can just list the forum ID's with some delimeter in-between them that I would like to use on the front page; and it would then ignore all other forums for the front page new threads listing. I hope it doesn't hurt to ask this and if this is viewed as inappropriate to ask for, I apologize.

Thanks again for this extremely usefule and very high quality hack.

Tony DiMera

01-01-2003, 10:36 PM

Ok, I asked about running large scripts and this is what they said:

"> REMOTE_HOST:
> HTTP_USER_AGENT: Mozilla/4.0 (compatible; MSIE 6.0; AOL 7.0; Windows NT
> 5.1; .NET CLR 1.0.3705)
>
>
Hi,

We do not have size-restricted limits.

Happy Holidays!

Please dont hesitate to contact me with any further questions you may have.

Regards,

John Dritsas"

Tigga

01-01-2003, 11:27 PM

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?

ChrisLohman

01-02-2003, 01:25 AM

Thanks for your response PlurPlanet. This hack is absolutely perfect for my needs. I just turned it on at http://www.sonsofvalor.com/

DarkDraco07

01-03-2003, 02:33 AM

Originally posted by PlurPlanet
jeffj - Thanks for pointing out the problem with vB 2.2.5. I only had versions 2.6+ to test it on so it figures problems would arise with the version right before. I'll try to find a way to work around that or add something about it in the readme file for v3.1.

I'll see if I can make a 'mini-hack' to keep the index page open when the board is turned off. I don't think it would be too hard to do.

that mini hack :rambo:

Zalbard

01-03-2003, 03:49 AM

Hmm, everything appears to be working, exept the index! I get a mysql error, here is the page: http://www.zeldaxtreme.com/extremegames/myvbindex.php The error reads:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT threadid,title,replycount,postusername,postuserid, dateline,views FROM thread WHERE open='1' AND open<>10 AND forumid=23 OR forumid=1 OR forumid=7 OR forumid=11 OR forumid=44 OR forumid=14 OR forumid=19 OR forumid=27 OR forumid=32 OR forumid=37 OR forumid=42 OR forumid=2 OR forumid=5 OR forumid=6 OR forumid=49 OR forumid=8 OR forumid=9 OR forumid=10 OR forumid=12 OR forumid=13 OR forumid=15 OR forumid=18 OR forumid=16 OR forumid=17 OR forumid=20 OR forumid=22 OR forumid=25 OR forumid=26 OR forumid=24 OR forumid=28 OR forumid=29 OR forumid=30 OR forumid=31 OR forumid=33 OR forumid=34 OR forumid=35 OR forumid=36 OR forumid=38 OR forumid=39 OR forumid=40 OR forumid=41 OR forumid=43 OR forumid=48 OR forumid=45 OR forumid=46 OR forumid=47 ORDER BY lastpost DESC LIMIT
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Friday 03rd of January 2003 12:44:49 AM
Script: http://www.zeldaxtreme.com/extremegames/forums/extremegames/myvbindex.php
Referer:
------------------------------------------------------------------------------------
Number one, it sais http://www.zeldaxtreme.com/extremegames/forums/extremegames/myvbindex.php, and its not that! it's really http://www.zeldaxtreme.com/extremegames/forums/myvbindex.php. Second, it's not their. The file myvbindex is not in that directory. Is that why, please help me! Thank you for your time!

Tigga

01-03-2003, 06:43 AM

DarkDraco07 - I'm not sure how hard that's going to be to do... I'll look into it when I get a chance.

Zalbard - It looks like you left your Latest Threads Maximum blank in your Admin CP. I guess I should add something to check for that too in v3.1. :)
As for it showing you the wrong path... What do you have your URL set to (3rd option under General Settings in the Admin CP)? You may want make sure that's set correctly as well as it could cause problems with links and such.

Zalbard

01-03-2003, 01:42 PM

My URL to the forums are set too: http://www.zeldaxtreme.com/extremegames/forums

Is this problem fixable!?!

Tigga

01-03-2003, 02:18 PM

To answer your PM... Log into your Admin CP. Click on "vBulletin Options". Scroll to the bottom of that screen to your mYvBindex options. Set your Latest Threads Maximum to whatever number of latest threads you would like displayed on your homepage.

Zalbard

01-03-2003, 02:31 PM

I disabled that, so now the error only reads:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT thread.pollid, thread.open, thread.threadid, thread.replycount, poll.pollid, poll.question, poll.dateline, poll.options, poll.votes, poll.active, poll.numberoptions, poll.timeout, poll.multiple, poll.voters FROM thread LEFT JOIN poll ON (thread.pollid=poll.pollid) WHERE thread.forumid= ORDER BY thread.pollid DESC LIMIT 1
mysql error: You have an error in your SQL syntax near 'ORDER BY thread.pollid DESC LIMIT 1' at line 1

mysql error number: 1064

Date: Friday 03rd of January 2003 11:27:10 AM
Script: http://www.zeldaxtreme.com/extremegames/forums/extremegames/myvbindex.php
Referer:

How do I fix this error? It seems pretty odd that it works for everyone else, and just this one wont. I know it's fixable.

Tigga

01-03-2003, 02:33 PM

You need to set your Poll Forum ID, or just turn off the poll option.

Zalbard

01-03-2003, 02:40 PM

Well, I disabled it and I am still getting the same error, and it's still asking for a strange url. O_O Here is the error again in case it did change at all:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT thread.threadid,thread.title,thread.replycount,thr ead.postusername,thread.postuserid,thread.dateline ,thread.views,thread.iconid,thread.votenum,thread. votetotal,post.postid,post.pagetext,post.allowsmil ie,post.showsignature,user.signature FROM thread LEFT JOIN post USING (threadid) LEFT JOIN user ON (user.userid=post.userid) WHERE thread.forumid= AND isnews='Y' GROUP BY thread.threadid ORDER BY thread.threadid DESC LIMIT 10
mysql error: You have an error in your SQL syntax near 'AND isnews='Y' GROUP BY thread.threadid ORDER BY thread.threadid DESC LIMIT 10' at line 1

mysql error number: 1064

Date: Friday 03rd of January 2003 11:36:42 AM
Script: http://www.zeldaxtreme.com/extremegames/forums/extremegames/myvbindex.php
Referer:

It's calling for http://www.zeldaxtreme.com/extremegames/forums/extremegames/myvbindex.php and thats not correct! how do I fix this error?

Tigga

01-03-2003, 09:53 PM

You left your News Forum ID blank... And I have no idea why the url would be wrong, but it is pulling the script from the right location otherwise you wouldn't get those errors.

Zalbard

01-04-2003, 12:24 AM

How do you know what the ID number is for the forum?

EvilLS1

01-04-2003, 04:53 AM

Originally posted by Zalbard
How do you know what the ID number is for the forum?

Go to that forum, then look at the URL at the top of your browser. The last number(s) in the URL is the forum ID.

Example:
http://www.yoursite.com/forum/forumdisplay.php?s=&forumid=4

vietres

01-04-2003, 05:38 AM

good

[hhhh]

01-04-2003, 06:23 AM

Hello PlurPlanet ! i want get multi forum on myvbindex page . Please help me

jarvis

01-04-2003, 06:37 PM

Hey Plur,

Things are working great with the hack. I've been modifying some of the templates to include some more intuitive interfaces and functionality, but a great hack for doing so.

It seems as though the weather bug is semi-squished. The temp field shows as "0" unless the user goes into the 5-day and then goes back to the main index and refreshes. Maybe I copied something wrong from the fix, or is this happening to you too?

Check it and the customizations out at www.mhogaming.com

Thanks again!! :banana:

jeffj

01-04-2003, 10:42 PM

weather bug.....same things happens on my site... I'm running 2.5 and just nuked the weather off the page until I have some time to debig the code...

EvilLS1

01-05-2003, 12:08 AM

The weather fix works perfectly for me. Thanks Plur!

Tigga

01-05-2003, 12:42 AM

hhhh - Do you mean you want to have multiple news forums?

Jarvis - Well I don't see why this makes a difference, but after you pointed it out I noticed the same problem on my test server. Try opening up your myvbindex.php file and look for:
if (substr($getbit,7,5) == "Temp") {
Replace that with:
if (substr($getbit,7,5) == "Temp ") {
(Just adding a space after Temp.)
That should fix the problem since that's the same way it's done in the weather.php file and it seems to work there.

jeffj - Did you try the fix i posted here? https://vborg.vbsupport.ru/showthread.php?postid=336976#post336976

Evils1 - Glad to hear it. :)

Tony DiMera

01-05-2003, 01:22 AM

Originally posted by PlurPlanet
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? [/B]

Yeah I ran the queries manually and they work, i'm just curious on why the weather_install script won't run.

Brahm

01-05-2003, 01:48 AM

Plurplanet, thanks for the hack, it looks great on my site:

ashkins.net (http://ashkins.net)

Brahm

01-05-2003, 08:29 PM

I just installed "Shoutbox" from TWTCommish and I was wondering if there is an easy way to include shoutbox on the MyVBindex page. I have seen this on other web pages.

Tigga

01-05-2003, 09:44 PM

If you'll look at the first post in this thread, there's a mini-hack that MartynJ put together which integrates the shoutbox w/ myvbindex.

Brahm

01-05-2003, 10:53 PM

If you'll look at the first post in this thread, there's a mini-hack that MartynJ put together which integrates the shoutbox w/ myvbindex.

I tried that one and the query killed my vbulletin. It was written for a different Shoutbox. MartinJ even admits he doesn't know which one in the notes.

Tigga

01-05-2003, 11:11 PM

Ahhh... I'll look at TWTCommish's shoutbox when I get the time and see what would need to be done to add it to the index page. I wouldn't imagine it would be very hard.

Brahm

01-05-2003, 11:17 PM

I know you're right, but my miniscule knowledge of PHP/mysql couldn't figure it out. I figured out how to get the shoutbox to display based on comments you made on or around page 18, but that was as far as I got.

it looked too weird (too big/wrong format) and after trying several different ways to present it in custom 1 template I never could get it.

Is the hack that MartinJ wrote a complete shoutbox? If so and it works, I could uninstall TWTCommish's and install MartinJs. He said that he may have used sinecure's shoutbox, but when I went to sinecure's shoutbox hack it was no longer available.

Tigga

01-05-2003, 11:40 PM

I've never really looked at the shoutbox hacks so I don't know for sure, but I would imagine you would put the code normally in your forum/index.php in your myvbindex.php, and then edit the templates to suite your index page better.

I'm not sure what the difference between Martin's and TWTCommish's is. If you install Martin's and it doesn't work the same way as the other, let me know and I'll convert TWTCommish's to work.

AmericanWoman

01-06-2003, 12:49 AM

Help! The index is working as a shell, but newthread.php must have something wrong - none of the form elements on the page are showing up when you try to add a new thread to any of the forums, nor are the "new thread" and "post reply" icons displayed (broken links or otherwise - just no clickable space whatsoever)...basically, NONE of the form elements, including the Quick Reply box, are working.

Ignore the graphics, please, as this is using a mirror of an existing site for development:

www.acuraworld.com/dev/myvbindex.php and for the forums: www.acuraworld.com/dev/forums/

ANY help would be appreciated. :( Thanks!

Mandi

Brahm

01-06-2003, 01:26 AM

Okay, I uninstalled TWTCOmmish's Shoutbox and installed the other one that is recommended on the first message. It worked flawlessly. So I guess I will forgo the advnced features of TWTCommish's hack until you guys figure out how to implement here. Thanks.

Tigga

01-06-2003, 02:50 AM

That's really weird... Editing the newreply.php and newthread.php files shouldn't cause anything like on those pages. Does it fix the problem if you remove the changes to those 2 files?

Tigga

01-07-2003, 11:43 AM

Brahm - Ok, I was able to check out the TWTCommish's shoutbox and get it to work with myvbindex. Just install the hack exactly as you normally would, except at the part where it tells you to place the code in your forums index.php, instead place it at the bottom of your myvbindex.php file right above:

$getbgrow=getrowcolor();
eval("dooutput(\"".gettemplate('index')."\");");

Also be sure to leave out the bottom part where it has:
eval("dooutput(\"".gettemplate('forumhome')."\");");

Then you would replace the content of the forumhome_shoutbox template with the content in the text file attached.

You will probably want to also edit your shoutbox_postshout template and remove the / before shoutbox.php on the 3rd line so the form will be pointing to the right place. ;)

That should be it. :)

Brahm

01-07-2003, 01:58 PM

Thanks! I will check this out in a little bit. If this works okay, you may want to stick iton your first posthere.

I had done everything you suggested before except comeupwith a different "forumhome_shoutbox" so I can't wait to try this.

Zalbard

01-07-2003, 08:16 PM

How do I costomize this to make it an actual site? I want to add affiliates, etc. How do I do that, and is it easier to do that in vbportal?

Tigga

01-07-2003, 08:55 PM

Zalbard - Do you mean instead of just using it as a homepage, having a portal where say something like the left bar will be on every page? I just moved to a new server so the DNS may not have updated yet, but if you go to my site (http://plurplanet.com) you can see an example of what I mean. I use a slightly modified version for my homepage, then if you click a link on the top navbar there, all the info in the left bar will appear on every page except for the forums and calendar. If you're trying to do something like I've done on my site, it's not that hard to do. It does require a little work, but I can try and explain to you how to do it.

Brahm

01-07-2003, 09:01 PM

Tigga

01-07-2003, 09:07 PM

Hehe... I guess that would probably help. ;)
You would put it in there where you'd like it just as the other variables are. It should look exactly the way the other 'boxes' do, except you'll probably want to change the 'title' since it will probably wrap around to a second line and look a little funny.

Zalbard

01-07-2003, 09:11 PM

Yes PlurPlanet, thats exactly what I need!

AZone

01-07-2003, 10:51 PM

Problem.
I replaced my forum from http://forum.mydomen.com to the http://mydomen.com/forum - just copied all files into other folder on the same server. And everythings works fine, except News - News is not showing in center of main page - what is problem? I changed all links in AdminCP and myvbindex.php...
Maybe I forgot something else?
News shows like usual threads in right panel...

Brahm

01-08-2003, 12:21 AM

Okay I made a few edits to my own tastes and put it all in a text file: Check it out Plurplanet and let me know what you think.

This is the addin info on how to integrate the TWTcommish "Shoutbox" hack onto the Myvbindex page.

Brahm

01-08-2003, 12:37 AM

Tigga

01-08-2003, 12:39 AM

Zalbard - I just moved servers a little while ago and have a few issues to straighten out, so as soon as I finish that I'll post instructions on how to turn it into a 'portal'.

AZone - Were the news posts made before or after you installed the script? If they were made after you installed the script, check your newthread.php and newreply.php files to make sure that you edited them right. If the posts were made before the script was installed, see this post for quick instructions on how you can update them - https://vborg.vbsupport.ru/showthread.php?postid=333825#post333825

Brahm - I'll check it out in a few and probably add it in with the mini-hacks on the first post. :)

AZone

01-08-2003, 02:48 AM

I determined the causal factor - it is Thread Preview Hack. After I uninstall it - News works nice.

Zalbard

01-08-2003, 08:45 PM

I do need a portal type site, so please help as soon as possible. Thanks!

Tigga

01-08-2003, 10:16 PM

Zalbard - Ok, Here are instrutions to turn this hack into a portal. It will require a little work, but if you read carefully and follow these instructions you shouldn't have any problems.

First make a copy of the mYvBindex file and rename it "include.php" (of course you can call it whatever you'd like, that's just what I called mine). Then you should remove the parts of the script that are not used on those pages such as news, polls, weather, and calendar in my case. You don't really have to delete those parts, but it makes for a little faster loading time and less queries, so it really is best if you do. If you just start wherever the code for a specific function begins and remove all code up to where the next function begins it should work fine, and there are notes in the script telling where each part starts. Then you would want to create a new template in your Admin CP (I called mine "include"). You would put the same content in your include template that is in your index template, but you would cut out the $newsbits and everything below that. Then in your include.php file the last couple of lines looks like this:
$getbgrow=getrowcolor();
eval("dooutput(\"".gettemplate('index')."\");");
Change the template there to "include" (or whatever you named your new template). Then near the top of the file you will see a list of every template the scipt uses. Be sure to change the very first place it says index to the name of your include file. You can also delete any templates in that section that won't be used with this file. It's not that big of a deal if you don't, but again it would be better to do so and will result in faster page loading times.

Now you will pretty much have your header file made. Next you would want to edit your html pages that you would like this header to appear on. There are a couple of ways to do this, so here are the best/easiest two.

One way is with the php include function. You will need to remove everything above the top of your files so that the only thing before any content is something like this:
<?php

include('/home/path/to/your/include.php');

?>
Remember that should be the only code before any content of your pages. You will also have to rename any html files you change to have a php extension for that method to work. You do not need to have any <head> or <body > tags at the beginning as these will be pulled from the include template, but be sure to close them at the end of the files. Also be sure that the starting <hmtl> tag is not also in your include template. Then just upload the files to your server and it should work fine.

An alternative to using the PHP include function would be to use server side includes. You would do everything exactly the same except when editing your files to add the header, you would put some code like this at the very top of your file instead of the PHP tag:
<html>
You will also not have to rename your html files to have php extensions if you use that method. One note though... You will have to be sure you can include php files on your server. This is something that is usually controlled by your host, so if you're not sure if you can do this or how to change it so that you can, you should contact your host and ask them to change it for you.

That should be everything you need to do. If you have any problems let me know and I'll do my best to help you out.

Tigga

01-08-2003, 10:38 PM

Brahm - I added your shoutbox integration in with the mini-hacks on the first post. :)

AZone - Ahhh yes, a hack like that could affect your myvbindex page and vice versa. If you want to give me a link to the thread preview hack I can take a look at it and see if I can tell you what would need to be done differently so that both hacks would function properly.

Highlander

01-09-2003, 04:02 AM

the news forum is not showing up .. hugh .. any idea?

http://www.spieleplanet.org/forum/myvbindex.php

and is it possible to ge tmore than one news forums.. i need minimum 4 forums to be shown as news forum .. please help me with this.. nobody the last 4 motnh could helpo me to mak e portal news forums more than one !

Brahm

01-09-2003, 04:06 AM

Thanks Plurplanet, that's my first.

Tigga

01-09-2003, 04:34 AM

Highlander - Were the news posts made before or after you installed the script? If they were made after you installed the script, check your newthread.php and newreply.php files to make sure that you edited them right. If the posts were made before the script was installed, see this post for quick instructions on how you can update them - https://vborg.vbsupport.ru/show...3825#post333825

Showing the news from multiple fourms isn't hard. Just open your myvbindex.php file and look for:
thread.forumid=$newsforum
Replace that with:
forumid=X OR forumid=Y OR forumid=Z OR forumid=W
(replace x,y,z, & w with the id numbers of those forums)

papa

01-09-2003, 06:54 AM

I know almost everything is possible but can my users modify the myvbindex.php page to be a customized page based on their choices.

For example if I make a 5 custom templates and the users can choose which ones they want when they log in those are the only ones they see?

Thanks in advance

jundat

01-09-2003, 10:48 AM

help me about this error

Warning: Unable to access /forums/global.php in /home/skull/public_html/index.php on line 25

Thanks

Tigga

01-09-2003, 08:21 PM

Papa - Something like that is very possible, but would require some hacking. When I get the time I'll try to play around with the files to see what would have to be done, but I can't promise I'll be able to get to it any time soon.

jundat - You have your path set wrong in your myvbindex.php. Try setting it to /home/skull/public_html/forums ;)

papa

01-10-2003, 01:50 AM

I imagine it as a small control panel like the admin one but for them. I am not sure how this would work but I know it would be popular.

Thanks for all you have done. Do you have a pay pale account. I'd like to send you a few bucks for the hard work you have done. I really like the scripts and my users have found the new look very fun.

papa

papa

01-10-2003, 02:32 AM

Can you tell me how to add a jump menu of the existing forums on our site in one of the custom boxes?

I searched for this but came up with missing leads. This way the members don' t have to go to another page with the forums listed (original index page)

Thank man,
papa

Tigga

01-10-2003, 02:59 AM

I've actually thought about making the hack for users to customize their homepage for my own site as I think many users would like it as well. Again, it may be a little while before I get to work on it, but when I do I'll share it here.
I do have a PayPal account (tigga@plurplanet.com). Donations really aren't necessary, but would be graciously accepted. :)
For the jump menu, you mean just the regular forum jump that's at the bottom of pretty much every page on the forum, right? That wouldn't be too hard to do, but I'll have to post instructions tomorrow. I'm having a problem with my server crashing and am basically having to reconstruct my forums at the moment since I'm sure it's being caused by some hack I installed from here, but I have no idea which one. :(

Tigga

01-10-2003, 10:11 AM

Papa - Here's how to add the forum jump to your index page...

Open your myvbindex.php file and look at the very bottom for:
$getbgrow=getrowcolor();
eval("dooutput(\"".gettemplate('index')."\");");

Right above that add the code: makeforumjump();

Then edit your forumjump template. In that template, there are 2 places near the top of that template where you'll see forumdisplay.php. Change that to the full url to your forumdisplay.php file in both places.

Now edit your index template and place the variable $forumjump wherever you would like the forum jump to appear.

I played around a bit and allowing users to set their own options for the homepage really isn't that hard to do. I'll write up some instructions on what to edit and post them here for you later today or tomorrow. :)

ranger2kxlt

01-10-2003, 09:39 PM

ok i have a problem that hopefully can be fixed,
the latest forum topic, doesn't display the correct member who last posted! anyone help me on this??

Tigga

01-10-2003, 10:11 PM

Ranger - By default it shows who started the thread and the time/date that the thread was started. If you'd prefer for it to show the last poster and date of the last post, here's what you need to edit:

Open your myvbindex file and look for:
$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");
Replace that with:
$threads=$DB_site->query("SELECT threadid,title,replycount,postusername,postuserid, lastpost,views".iif($showthreadicon, ',thread.iconid','').",lastposter FROM thread WHERE open='1' AND open<>10 $iforumperms ORDER BY lastpost DESC LIMIT $maxlatethreads");

Then right below that find:
if ($showthreaddate) {
$thread['time'] = vbdate($timeformat, $thread['dateline']);
$thread['date'] = date("m-d-y", $thread['dateline']);
You would just change 'dateline' at the end of both of those lines to 'lastpost'.

Then edit your index_threadbits template and change the link to the poster to

<a href="$bburl/member.php?action=getinfo&find=lastposter&threadid=$thread[threadid]">$thread[lastposter]</a>

That's it. :)

ranger2kxlt

01-11-2003, 12:22 AM

alright will try that later tonight, and let you know how it goes

Thanks :-)

TMG

01-11-2003, 12:32 AM

when i post a message in the news section, or make a poll in its, they dont show up on myvbindex.php

Tigga

01-11-2003, 01:30 AM

TMG - Make sure you correctly edited your newreply.php and newthread.php and uploaded them to your server. If that was done right, be sure you have the correct value the News Fourm ID part of the admin options. If the poll's not showing up, the value in the Poll Fourm ID is wrong, or the option right below that is not set to yes.

ranger2kxlt

01-11-2003, 02:38 AM

plurplanet, one more for ya

we have added that pop-up script for new U2U's on our forums, and it seems to carry over to your prg as well...we like that idea, but when you click ok it takes us to like www.webaddress.com/private.php and it should be www.webaddress.com/vb/private.php

do you know a why to fix that for your home page only? we don't want to screw up the forums by changing this only your prg part....

Thanks

ranger2kxlt

01-11-2003, 02:45 AM

btw the last person post hack you have there works great!

Thanks

Tigga

01-11-2003, 03:14 AM

I'm not really sure what pop-up hack you're talking about, but if you look in the templates or files you changed for that hack, you should see a link or call to private.php somewhere. If you change it to either $bburl/private.php or /vb/private.php it should fix the problem. If you can't figure it out post a link to the hack here for me and I'll take a look at it.

ranger2kxlt

01-11-2003, 03:52 AM

found it and works now, thx for the help and info!

Kamui Shirou

01-11-2003, 08:19 AM

i need your help again purplanet. i just wanna include a html page into the myvbindex portal. i attached a screen. :banana:

Tigga

01-11-2003, 08:44 AM

Ranger - No problem. Hope you enjoy the hack. :)

Kamuri - Couldn't you just edit the index template and replace the $newsbits variable with html you want there? Nice page by the way. I really like the header graphic. :)

Tigga

01-11-2003, 12:15 PM

Incase anyone didn't notice, v3.1 has been released. See the first post for details. :)

Tigga

01-11-2003, 12:21 PM

Papa - Attached are instructions on how to allow users to customize their homepages. They're written based on v3.1, so you should upgrade before you try to install it (don't worry, upgrading should take less than 2 minutes). Let me know how it works for you. :)

Kamui Shirou

01-11-2003, 12:40 PM

your right. i didnt think that way.
oh by the way you're welcome to register at my forums but i think you wouldnt like speaking german. by the way. i also dont like it XD

Littlebit

01-11-2003, 02:17 PM

Plurplanet,
thanks for the work you did for the update :)
installing now
-littlebit

Littlebit

01-11-2003, 03:29 PM

I just noticed that the username in the usercp login part has black text or isn't showing. I didn't update the templates...is there something in the myvbindex.php that has text color?

Tigga

01-11-2003, 09:54 PM

Which version did you upgrade from Littlebit? In your index_welcometext template, be sure you have the code "Welcome back $bbuserinfo[username]".

marzlod_zyfus

01-11-2003, 10:54 PM

how do you add news blocks, i'm kinda stupid though. You know the news blocks or whatever you call them, anounment blocks i think hteir also called. how do you add them?

Tigga

01-11-2003, 11:04 PM

I'm not quite sure I follow what you mean... If you're asking how you make new news posts, you just create a new thread in your news forum after you have installed the hack.

marzlod_zyfus

01-11-2003, 11:35 PM

dosnt seem to work for me!

Tigga

01-11-2003, 11:41 PM

Did you set the options in your Admin CP? Specifically, your News Forum ID?

marzlod_zyfus

01-11-2003, 11:42 PM

yeah, i have 5 in the news one sine the end of my new forum is "forumid=5"

Tigga

01-11-2003, 11:54 PM

Did you edit your newthread.php file correctly and upload it to your server? If that was edited correctly and the News Forum ID is set correctly (which from what you said it should be correct) then there's no reason new posts shouldn't appear on the homepage. Double check your newthread.php file, upload it again, and try to make a news post. If that still doesn't work let me know.

Tony DiMera

01-12-2003, 12:04 AM

Thanks Plur for the upgrade. BTW How would I go about adding more custom templates?

Tigga

01-12-2003, 12:09 AM

Tony - If you'll refer to posts 194 and 196 of this thread there are 2 different explanations on how to add more templates. Either of those methods will work just fine, they're just 2 different ways of explaining it.

XtReMaTriX

01-12-2003, 06:17 AM

Hi, I was looking through the thread to try and find the fix fo rmy problem but couldnt find anything... 30 pages is alot... anyways, my problem is that when i go to myvbindex.php i get this error....

Warning: SAFE MODE Restriction in effect. The script whose uid is 583 is not allowed to access /var/www/html/vbulletin owned by uid 0 in /home/virtual/site79/fst/var/www/html/myvbindex.php on line 13

Warning: Unable to access ./global.php in /home/virtual/site79/fst/var/www/html/myvbindex.php on line 17

can u help me?

Tigga

01-12-2003, 07:02 AM

What did you set for your home directory in the myvbindex.php file?

XtReMaTriX

01-12-2003, 03:15 PM

Originally posted by PlurPlanet
What did you set for your home directory in the myvbindex.php file?

chdir('/var/www/html/vbulletin');

and the actualy file is in the html dir

AmericanWoman

01-12-2003, 07:13 PM

Ok, guys, still having my form elements issue, and I went back to base install of the forums and stepped through the hack procedures complete with documentation...

Maybe I screwed something else up, somehow? Either way, none of the form elements will display, my page bleeds off the right of the screen with no horizontal scrollbar...argh! It seems as easy as a < / table > and < / form > missing somewhere, but with all the bloated nested tables, it's hard to see.

Help, please?????

Index Page ---> use any article to get to forums (http://www.acuraworld.com/dev/myvbindex.php)

Thanks, guys. I really love this hack...if only I can make it WORK!

Tigga

01-12-2003, 11:22 PM

XtReMaTriX - Try /home/virtual/site79/fst/var/www/html/vbulletin ;)

AmericanWoman - I checked your page and don't see what you're talking about... Everything seems to be displayed fine. At first I thought you were talking about some missing buttons, but from looking at the source the 'search' button is the last one there. Are you still having a problem with it? If so could you maybe take a screen shot and show me what the problem is?

XtReMaTriX

01-12-2003, 11:27 PM

Thanx PlurPlanet... works like a charm... cant believe i didnt think of it :)

ranger2kxlt

01-13-2003, 03:06 AM

I would like to add a third customizable field to the homepage, how would i go about doing this. the present version only supports two (2) extra fields. thanks for any help.

Tigga

01-13-2003, 03:08 AM

Ranger - Check this thread, about 6-7 posts up. I just answered the question for someone else.

ranger2kxlt

01-13-2003, 04:01 AM

thanks... did that but how do i add it to the options menu in vb. The custom templates are not displaying and i think it is because they are not turned on. Thanks.

Tigga

01-13-2003, 04:15 AM

Ahhh, I didn't notice that in Chevy's version he has it where you would have to also create options to turn them on and off... If you don't care about adding the option to disable them in the Admin CP, you can just remove this bit of code at the beginning of each custom one:

if ($showcustom2) {

And also the last } right below the call to the template.

If you want to add options to turn them on and off, just log into phpMyAdmin and run this query:

INSERT INTO setting VALUES (NULL,50,'Show Custom Template 2?','showcustom2','0','Show your second customized template.','yesno','30');

You would change the two places you see the number 2 in that query to 3, then 4, and so on for more templates. You would also need to change the last number (30) to incriment by one for each one you add (that's the part that tells it what order the option should be displayed).

papa

01-13-2003, 04:31 AM

I am very greatful for your work on this. You are an unsung hero to the vBulletin community.

I have never done any work on the tables or log in using phpmyadmin... do you have any links to learn how to do this?

Papa

Tigga

01-13-2003, 04:48 AM

Just running queries isn't too hard. I know there's a small tutorial on here somewhere, but I'm not exactly sure where...
To run the queries you would just log in to phpMyAdmin. You should see a drop down box or something to that effect where you can choose which database you want (assuming you have more than 1). After you choose the database you should see a link "SQL" at the top of the right frame. Click on that and you will see a textarea where you past the code to run the query. Then hit the go button and it will tell you the query was successfull or if there was a problem.

papa

01-13-2003, 05:31 AM

Someone also asked this earlier but how can you use an include in the template?

I used frontpage to build my site and I have it made up of a bunch of pieces so I can just change the content with out messing with the interface (makes adding pages easy)

I wanted to use the myvbindex page as the main page but I need more than the forum news and latest threads, instead I wanted to include our main page data. I could just add the html code but we change it very often with new updates and content.

Do you know how I can use an include statement to include test.htm for example in to the index template for myvbindex?

papa

01-13-2003, 05:39 AM

I ran the query and this is what I got:

Error
SQL-query : [Edit]

ALTER TABLE `user` ADD bbshowcalendar smallint(6) NOT NULL default \'1\';

MySQL said:

You have an error in your SQL syntax near '\'1\'' at line 1

Tigga

01-13-2003, 05:47 AM

Unfortunatly you can't use SSI within vBulletin templates. Couldn't you just add some more custom templates and change the content that way?

That's strange the query didn't work... It may be something with your version of phpMyAdmin. Try this one instead:

ALTER TABLE `user` ADD bbshowcalendar smallint(6) NOT NULL default 1;

(just removing the ' marks around the 1)

papa

01-13-2003, 06:00 AM

worked like a champ. I'll get started on this hack.

papa

01-13-2003, 06:40 AM

I got the changes updated but now the index page does not show if you are logged in or not. Also do the options radio buttons created need to have a form on it so it is saved when you make the choices???

Tigga

01-13-2003, 06:47 AM

Oh crap, sorry about that. It was late when I did that and I didn't think about guests. Give me a few minutes to work around that and I'll post the fix for ya.

Tigga

01-13-2003, 06:57 AM

Ok, this should be a quick/easy way to fix that. Just open your myvbindex.php file and look for:

require('./global.php');

Right below that add:

if ($bbuserinfo['userid']==0) {
$bbuserinfo[bbshowonline]=1;
$bbuserinfo[bbshowonline]=1;
$bbuserinfo[bbshowstats]=1;
$bbuserinfo[bbshowpoll]=1;
$bbuserinfo[bbshowsearch]=1;
$bbuserinfo[bbshowcustom1]=1;
$bbuserinfo[bbshowcustom2]=1;
}

If for some reason that doesn't work for you let me know.

Oh, and I'm not sure I follow you about the buttons having a form on them... There is a <form> tag started earlier in that template and the new options use that same form. If you were trying to move them to another template or something like that you would just use the same <form> tag as near the top of that file.

papa

01-13-2003, 07:07 AM

AWESOME!!!
I will get the form code added and show you my beta page.

papa

01-13-2003, 07:21 AM

Here is the start
http://www.digital-tutors.com/digital_tutors/index2_beta.php

Is there a simple recipe to add custom boxes to the options? Can I just search for the custom1 and duplicate it to make custom 3, 4 and so on?

Thanks so much. My page is really getting together.

Papa

Tigga

01-13-2003, 07:38 AM

Looks very nice so far. :)

I looked over the file edits to be sure and searching for custom1 and duplicating for each additional option should work just fine.

By the way, I was planning on making a mini-hack that would move the latest threads part to the center (similar to yours) and would add a little additional info like the forum, last poster, time, and etc. I'll probably post it tomorrow or the next day so be sure to check back here if that's something you'd like. ;)

jjj0923

01-13-2003, 10:26 AM

I'm not sure if anyone else has experienced this but this morning out of the clear blue I started getting a mysql error on the following code in myvbindex.php. I've been using myvbindex for about 2 weeks.
----------------------------------------------
SELECT thread.threadid,thread.title,thread.replycount,thr ead.postusername,thread.postuserid,thread.dateline ,thread.views,thread.iconid,thread.votenum,thread. votetotal,post.postid,post.pagetext,post.allowsmil ie,post.showsignature,user.signature FROM thread LEFT JOIN post USING (threadid) LEFT JOIN user ON (user.userid=post.userid)
WHERE thread.forumid=81 AND isnews='Y'
GROUP BY thread.threadid ORDER BY thread.threadid DESC LIMIT 1

so I pasted the query into mysqladmin and ran it and got the following error...

Got error 28 from table handler

When I removed the GROUP BY clause it ran fine...

I checked the integrity of the data in the thread tables and post table and everything checks out just fine.

Like I said - this just started happening after two weeks of running fine.

ideas?

Tigga

01-13-2003, 10:30 AM

Can you check your myvbindex.php file and look for this line:

// Latest Forum Topics

Copy the next 5-6 lines after that and paste them here for me.

Also what version of myvbindex do you have?

ranger2kxlt

01-13-2003, 06:56 PM

plurplanet, got something for ya

we want another page, but want the menus on left and right to be the same, just don't want the news in the middle we want a different template there, is there an easy way to make this
??

Tigga

01-13-2003, 10:36 PM

Ranger - Something like this should be pretty simple and should work...

Open your myvbindex.php file and look for:

// News
if ($newsforum!='') {

Right above that add:

if ($action=="newpage") {
eval("\$newsbits = \"".gettemplate('index_newpage')."\";");
} else {

Then look for:

$DB_site->free_result($getnews);
unset($news);
}

And add another } right below that.

You can change "newpage" in the first part ($action=="newpage") to whatever you want, and also of course name the template to whatever you'd like. You would then add the content you'd like in your new template, and then to display that template instead of the news, you would link to http://yoursite.com/myvbindex.php?s=$session[sessionhash]&action=newpage

Tony DiMera

01-15-2003, 01:44 PM

For the weather part, is there anyway to set the city you want to be the default city for guests instead of New York? Say I wanted it to be Midhurst for the default? Also I have another question. I am always getting a white box with an X in it for the icon. This is the URL of the icon, http://www.mysite.com/forums/images/weather/.gif As you can see it is always trying to find an image icon that is .gif no matter what the weather is, and I don't have a .gif image icon.

Tigga

01-15-2003, 01:58 PM

Tony - If you look in the readme file, right under the section that explains the Admin CP options, there are instructions on how to change the default city.
I'm not quite sure why the image wouldn't be working... Did you upload the weather icons to your forum/images folder? Also, does the rest of the info display properly?

Tony DiMera

01-15-2003, 02:26 PM

Yes I uploaded all the other images, and everyone show up except for this one that appears to be just .gif not 1.gif, 10.gif, 30.gif, etc.

Tigga

01-15-2003, 02:47 PM

Hmm... That's strange. The only reason I can think of that it would do that is it wouldn't be recording the icon value in the database, but it doesn't make sense why that wouldn't work if everything else does. Does it ever show the icon? Have you tried using the "force update" link to update the info in the database?

Tony DiMera

01-15-2003, 04:00 PM

Yeah, I have and it still shows a white box with an x in it. I just sent you pm with my site and weather.php file so that way as long as you don't mind you can see what I mean. Thanks for your help.

Tony DiMera

01-15-2003, 04:08 PM

Sorry I forgot to mention that I use Midhurst for the name of the city in Canada.

Tigga

01-15-2003, 04:23 PM

Well I just signed up on your forum and everything worked fine, until I changed the settings to Midhurst. I also tried using Midhurst on my site and it doesn't display the icon there either. Every other city I tried worked fine though, so it has to be something to do with msnbc.com.

Tony DiMera

01-15-2003, 07:11 PM

ok, then thankyou for your help.

Bison

01-15-2003, 11:49 PM

The News Section (Middle Column) doesn't show up on the home page ... I know I placed the right forumID under the options pages. :paranoid:

Tony DiMera

01-16-2003, 01:19 AM

Did you make sure you edited the newthread and newreply php scripts?

Bison

01-16-2003, 01:44 AM

Sure did ... the 3.1 instructions didn't show modifications to the newreply.php ... the 3.0 version did though ...

I knew something was missing in the 3.1 version ... and I know there's a mistake in the code somewhere.

Tigga

01-16-2003, 02:09 AM

The reason there are no instructions to edit the newreply.php file for v3.1 is because it's really not necessary. During the installation process, it modifies your post table to add an extra column which is used to determine if the post is the first in the thread. Once the newthread.php file is modified, it will always insert a 'Y' into that column indicating that the post is the first in the thread. Since the column is set to have an "N" by default, it's really not necessary to also edit the newreply file.

Rolodex - Did you make the news posts before or after installing the script? If the posts were made before you installed the script, then that is the reason they are not showing up. If you'll refer to this post (https://vborg.vbsupport.ru/showthread.php?postid=333825#post333825) there are instructions on how you can manually update those posts.
If that's not the case and the posts were made after the script was installed, please post or PM me a link to your website, and let me know what you have your News Forum ID set to and I'll take a look to figure out what's wrong.

Bison

01-16-2003, 03:11 AM

No ... the forum didn't have any posts in it. I'm on my company intranet, so I can't give you a link. I can show you a screenshot, if that will help.

Tigga

01-16-2003, 03:25 AM

Hmm... If the newthread.php file was edited correctly & uploaded, and the News Forum ID is set correctly, then there's no reason the news part shouldn't work. Do you have access to phpMyAdmin? If so, you could log in with that and check your 'post' table. First make sure that the last column there is called 'isnews', and then find a post that was made in that forum and make sure that it has a 'Y' in that field. If the post doesn't have a 'Y' in that field, try changing it there and see what the result is. Also, what do you have set for your News Forum ID and News Posts Maximum?

Bison

01-16-2003, 03:39 AM

My new forumid is "54" ... and the news post "max" is set to zero (unlimited).

The Polls work fine (I Had polls already posted there).

Tigga

01-16-2003, 03:43 AM

Did you check to see if the isnews column has a 'Y'?

Bison

01-16-2003, 03:44 AM

Here's a snapshot of my admincp settings:

Bison

01-16-2003, 03:47 AM

I checked the post table but I don't have any posts in that forum. I set it so that the forum cannot be seen on the main forum index page but can accept new posts from the vbindex page.

Did I do this right?

Tigga

01-16-2003, 04:03 AM

Ok, this is strange... I checked my test server and set the News Limit to 0, and it resulted with no news being displayed. I had changed a couple of things on that one though, so I uploaded a fresh version and setting it to 0 worked fine... Try setting the news limit to something other than 0 and see if that changes anything.

Bison

01-16-2003, 04:10 AM

Nothing ... I even changed every post column in the database under isnews to "Y" and still nothing!

Bison

01-16-2003, 04:14 AM

Is it possible that there's an misspelled variable in the v3.1 template code?

Here's a dump of the index_newsbits template:

<table cellpadding="0" cellspacing="0" border="0" bgcolor="#0A293E" width="100%"><tr><td>

<table cellpadding="4" cellspacing="1" border="0" width="100%">
<tr id="cat"><td bgcolor="#1D6AA0">$newsicon <normalfont color="#000000"><b>
$news[title]</b></normalfont></td></tr>

<tr><td bgcolor="#1C5780">

<table width="100%"><tr><td align="left"><smallfont>- by <a href="$bburl/member.php?s=$session[sessionhash]&action=getinfo&userid=$news[postuserid]">$news[postusername]</a> on $dateposted</smallfont></td>$newsrating</tr></table></td></tr>

<tr><td bgcolor="#13486D">$news[avatar]<normalfont>$news[message]<br>$signature</normalfont></td></tr>

<tr bgcolor="#1C5780"><td>
<table width="100%" cellpadding="0" cellspacing="0"><td align="left"><smallfont>$adminopts  </smallfont></td><td align="right"><nobr><smallfont>  $news[views] Views, $newscomments</smallfont></nobr></td>$sendtofriend $printable</tr></table></td></tr></table></td></tr></table><p>

I personally think it's a variable that's not getting called from your template changes in your last version upgrade.

Tigga

01-16-2003, 04:36 AM

Are you sure you have your News Forum ID set correctly? 54 does seem a little high unless that is the 54th forum you have created.

The entire middle column where the news should be is blank, right? With it working fine on my site and many others, it wouldn't be something such as a variable mispelled. Even if something was mispelled in that template, it would result with the tables around the news post showing up, just not the message.

If the News Forum ID is correct, here is something you can try...

First set your News Limit to something other than 0.

Then open your myvbindex.php file and look for this line:
// News
if ($newsforum!='') {
if ($newslimit!=0) {
$newsmax = "LIMIT $newslimit";
}
Remove that part, then look for this line right below it:
ORDER BY thread.threadid DESC $newsmax
Change that to:
ORDER BY thread.threadid DESC LIMIT $newslimit
Then look for:
$DB_site->free_result($getnews);
unset($news);
}
Remove the } at the end of that line and upload the file.

Doing that will remove the parts that make sure the News Forum ID and News Limit aren't set to 0. It should still work fine with that, but it's always possible that there's something with the version of PHP you're running that would cause it to behave differently, so it's worth a try.