PDA

View Full Version : mYvBindex v3.1


Pages : [1] 2 3 4 5 6 7 8 9

Tigga
17 Oct 2002, 09:20
mYvBindex 3.2.2 released! (5/22/03)

mYvBindex 3.2 will allow you to include different options from your vBulletin message board on your website's index page. Everything is completely template based so it is very easy to customize and change everything through your Admin CP.

Features:
Login box for members to log in to your site on the homepage.
Post News in a forum you specify and have it appear on your homepage.
Show the latest threads started in your forum on your homepage.
Show a poll and allow users to vote and see the results on your homepage.
Shows users avatar, new private messages, and buddy list for members who are logged in.
Shows a list of active users.
Shows statistics such as total members, threads, posts, top poster, newest member, and today's birthday's.
Shows a mini calendar with links to days with scheduled events, and a box with today's scheduled events.
Search box to allow users to quickly search your forums.
Current weather and updates on your homepage.
Set and change all options via the Admin CP.
Ability to easily switch on/off the polls, users avatar, buddy list, online users, search box, calendar, weather, custom templates, news icons, news comments, smilies, set the maximum number of news posts, and many other options via the Admin CP.
Everything is completely template based so it is very easy to customize.
Install file that will make all database queries and templates for you in seconds.
Uninstalls in seconds.
Tested and stable with vBulletin v2.6+

Screen Shots:
Guest Homepage (http://www.vbulletin.org/forum/attachment.php?s=&postid=310699)
Admin Homepage (http://www.vbulletin.org/forum/attachment.php?s=&postid=310700)
User Homepage (http://www.vbulletin.org/forum/attachment.php?s=&postid=310701)
Admin CP (http://www.vbulletin.org/forum/attachment.php?s=&postid=310702)


Queries:
A nice feature of mYvBindex is that it performs only 11 queries with all the options turned off, no matter how many news articles or latest threads you choose to display. Some options will cause the script to perform extra queries, but even with all the options turned on it still performs only 29 queries at max.

Here is a list of each extra function that will cause extra queries: Poll - 2 queries
User's Avatar - 1 query
Private Messages - 1 query
Buddy List - 1 query
Online Users - 3 queries
Mini Calendar - 1 query
Weather - 2 queries
Poll and/or News Smilies - 1 query
Stats - 5 queries

*Mini Hacks:*
Adding More Custom Templates
To add more custom templates to your mYvBindex, please see this post (http://www.vbulletin.org/forum/showthread.php?postid=327859#post327859).

Stylin' Buddy List - by MartynJ
This will add your the users avatar and usertitle to the buddy list (Similar to and inspired by velocd's Stylin' Buddy List hack), and adds no extra queries to your homepage.
Download (http://www.vbulletin.org/forum/attachment.php?s=&postid=335825) (Screen shot included in zip)

Shoutbox Integration - by MartynJ
This hack integrates the ever popular Shoutbox hack with your mYvBindex.
Download (http://www.vbulletin.org/forum/attachment.php?s=&postid=335827) (Screen shot included in zip)

TWCommish's vB Shoutbox Integration - by Brahm
This is a slightly different shout box made by TWCommish. His hack is required and can be found here (http://www.vbulletin.org/forum/showthread.php?s=&threadid=38698&highlight=shoutbox). After downloading his hack, use Brahm's instructions here (http://www.vbulletin.org/forum/attachment.php?s=&postid=339786) to integrate it with mYvBindex.

Attachments in News Posts - by Tigga
This hack allows attachments posted in news posts to be viewed in the news section on your homepage.
Download (http://www.vbulletin.org/forum/attachment.php?s=&postid=343179)

Allow users to set homepage options - by Tigga
This mini-hack will allow your users to set which options they would like displayed on the homepage. They will be able to turn on/off avatars, weather, custom templates, and etc on a per user basis.
Download (http://www.vbulletin.org/forum/attachment.php?s=&postid=340947) *Note* It may be necessary to open this file in a text editor (other than notepad) to get it to display properly.

Multiple News forums from different links - by Tigga
This hack allows allows you to have a link to a "different index file" which will pull news posts from a different forum.
Instructions can be found here (http://www.vbulletin.org/forum/showthread.php?postid=397671#post397671)


Credits:
mYvBindex uses modified versions of the following hacks:
Mini Calendar from vbPortal (http://www.vbulletin.org/forum/showthread.php?s=&threadid=32087) - by wajones
vB Weather Mk. 2 (http://www.vbulletin.org/forum/showthread.php?s=&threadid=41842)- by JJR512


Copyright:
This hack is NOT to be re-distributed or placed on website for download without permission. All copyright notes in the script itself must remain unchanged.

Please don't forget to hit the Install Button (http://www.vbulletin.org/forum/misc.php?s=&action=install&threadid=44691)


Updates from version 3.2.1
After the release of v3.2.1 a couple of small bugs were found. They affected the ability to edit a news post from the link on the homepage, pulling the wrong post from a thread for the news section, and updating your most users ever online if a new record is set. The changes from v3.2 to 3.2.1 were minimal, so those should be the only bugs found. Upgrading once again is very easy. Just download the new files, change the path in the myvbindex.php file, and upload it over your existing one.

Updates from version 3.2
v3.2.1 is again just a small maintenance release. The main change in this version is the way the forum permissions are done. Before, the forum permissions would cause the latest threads query to take much longer than it should (mostly on larger forums). Now with the new permissions system in place, the query to pull the latest threads should take less than 0.01 seconds. Other than the permissions section, the only other changes were a few optimizations to the code syntax. Upgrading from v3.2 is simple - Just upload the new myvbindex.php file over your existing one and you're done.

Updates from version 3.1
v3.2 is mostly another maintenance release, and will hopefully be the last release for vBulletin 2.X (unless any bugs are found). Here are a list of all the changes.
Fixed a bug where setting the "Show Latest Threads Icon?" option to "No" could disable the latest threads section.
Fixed a bug where signatures with vBcode were not displayed properly in the news section.
Fixed a bug where the icons in the news and latest thread parts weren't displaying the right icon for some users.
Added an option to completely disable signatures in news posts.
Added an option to select a random poll from any forum for the poll part of the hack.
Further optimized parts of the code and slightly changed part of the structure.
Now shows "No Buddies Online" in the buddy list if no buddies are online.
Changed so it will no longer show a default icon for the news and latest threads unless your options are also set to show a default icon on the forumdisplay page.
Now shows the last poster and last post time when you hold your mouse over the title of a thread in the Latest Threads part.
The install script has been re-written so you can install, upgrade, uninstall, update your news posts (useful for first time installations where a news forum already exists), or install just the templates (useful after upgrading vBulletin to a new version) all from one file.
Significantly reduced the size of the weather_install.php file (from 3.0 MB to 1.25 MB) so it will not take so long to upload to your server.
Fixed a couple of small spacing issues in the poll templates.
Fixed a problem with JJR512's weather hack not pulling the weather forcast.
Added a FAQ section to the readme file to help common problems.

Upgrading should take no longer than 2 minutes and instructions can be found at the bottom of the readme file.


Updates from version 3.0
v3.1 is mostly a maintenance release to help cut down on first time installation problems. Other than that, the biggest difference you will notice is the template "style" has changed to mesh better with vBulletin (see screenshots above). You do not have to install the new templates as you will have the option to install the new templates or to skip that step in the install file. Other than the templates, here is a list of the other changes:
A few more "error checking" features have been added to ensure you won't get a nasty sql error if you leave your News or Poll Forum ID, or any of the other fields blank.
The problem some users were experiencing with the temperature for the weather part of the hack should be fixed for good.
The "Show Poll" option in the Admin CP is removed as this can now be disabled simply by leaving the "Poll Fourm ID" filed blank.
Fixed a small typo and optimized parts of the code a little further.
Slightly changed the position of the days and numbers in the calendar part.
Fixes a bug where the Today's Birthday part wouldn't point to the correct url.

Upgrading should take no longer than 2 minutes and instructions can be found at the bottom of the readme file.


Updates from version 2.0
Removed the option from the Admin CP to allow smilies in News posts as this can now be set per post just as you would when making a regular post.
Added a stats section with info such as total members, threads, posts, newest member, top poster, and today's birthdays.
Added a "Today's Events" section under the calendar that will display any events that are scheduled for the current day, and will only be visible if there are events listed for the current day.
Added an option to show the poster's avatar with the news post.
You can now have your signature displayed with the news post. This is controlled when posting the message just as you would with a regular post.
Added an option to display the news post's rating with the news.
Added options to show small icons to allow users to show a printable version of the news post and an option to allow users to email their friends a link to the news post.
Added an option to allow/disable HTML in news posts.
Added an option to allow/disable the [img] tag in news posts.
Shows the number of times a news post has been viewed.
Shows the number of new posts since the users last visit.
Shows the number of replies to the poll if poll discussions are allowed.
Fixed a bug where the search box would take you to the search page rather than displaying the results.
Fixed a bug where setting the News Posts Maximum to 0 would disable the news rather than giving it no limit.
Optimized the code a little more to increase performance.


Help & Support
Before asking for support Please read the F.A.Q in the readme.html file! Most common problems are answered there! If you have any problems or questions that are not covered in the F.A.Q. please please post them here. I will be more than happy to help in any way I can if the request for help is made here. Anyone trying to contact me via email, private message, my website, or any other means will be ignored.

Tigga
17 Oct 2002, 09:22
Guest Homepage

Tigga
17 Oct 2002, 09:23
Admin Homepage

Tigga
17 Oct 2002, 09:23
Regular User's homepage

Tigga
17 Oct 2002, 09:24
Admin CP

NTLDR
17 Oct 2002, 09:45
Looks like a rip of of vBhome from the code, I hope you asked TECK's and everyone elses permission to distribute the code?

Origional name too :rolleyes:

Preech
17 Oct 2002, 09:46
I hate to say this. But to me. This is the best looking one I've seen yet. In my view...look's a little better than the one from php portals. I'll install sometime tomorrow.

Tigga
17 Oct 2002, 09:53
Originally posted by NTLDR
Looks like a rip of of vBhome from the code, I hope you asked TECK's and everyone elses permission to distribute the code?

Origional name too :rolleyes:

As shown in the credits, the hack uses modified versions of Teck's "Latest XX Threads on Fourmshome" and Kurafire's Simple Newsportal" hack for the news section (with permission from both). It looks similar to vBhome because I was inspired from Teck's hack to make my own. vBhome is the best hack I've seen so far and has a lot of nice features, but it's not quite what I wanted... So I made my own. I thought others might like it and it's features, so I tweaked it up a bit and got it ready to release.
And I agree, the name mYvBindex isn't very original, but I'm not that creative and that's about the best I could think of. If anyone can think of a better name I'll gladly change it. :)

NTLDR
17 Oct 2002, 09:58
Also, you need to remove that huge chunk of origional vB code, you will find that your not allowed to include it in that file.

Tigga
17 Oct 2002, 09:59
Ok, I wasn't really sure if that would be "excessive" vBcode or not. I'll upadate the files and re-upload in a minute.

Marv
17 Oct 2002, 10:12
oups....am i gone blind ? where is the dl-link ?

NexDog
17 Oct 2002, 10:44
I guess it's been removed while the file is updated minus the vB code. ;)

Tigga
17 Oct 2002, 10:46
Yup. The files are updated now. :)

TECK
17 Oct 2002, 11:25
Originally posted by Preech
I hate to say this. But to me. This is the best looking one I've seen yet. In my view...look's a little better than the one from php portals. I'll install sometime tomorrow.
when you will learn that beauty is not important while coding maybe you will understand something about PHP.
to people like you what is important is that it has nice boxes and colors, not that it's ruining your server.
did you know that 50% of the hacks here are just crap? from over 1500hacks released here, i could say that about 50-70 are written without any mistakes on it. not to count the security issues some of them pose, bad queries, terrible code skills, etc.

plurplanet, did you noticed how i did it me? i posted in my vbHome the links to the people who made the hacks to be added as addons to my original code. many people ripped my code and changed few variables, while "renaming it".
i got used to this, and moderators dont really care about it, so is ok.
throwing a bunch of hacks toghether, made by others and rename that to another name is not something to be proud of.

now, plur, if you want only (i dont force you), i want you to make me a favor. please remove the latest threads code and add instead instructions how to install the hack onto your portal. i looked at your code and it's identical to my hack, with the exception of some variable names.

i recommend you to take a look at my vbHome (lite) (http://www.vbulletin.org/forum/showthread.php?s=&threadid=36756) aproach:
- i write my original code by myself (as i do in all my hacks)
- i place links for add-ons so people can install those addons onto their portal.

thanks for understanding.
all the best,
TECK.

Tigga
17 Oct 2002, 11:48
Teck - I will replace the code if you really want me to. I PM'd you about this last week asking permission though so I wouldn't have to worry about something like this. If you would prefer that it wasn't in there then I will simply replace it with the Latest Threads part in KuraFire's Simple News Portal hack. I would just point people to your hack and let them make the modifications themselves, but I think most people would be annoyed by this. That's the main reason I included the Mini Calendar and Weather Mk hacks with the file too, so that people wouldn't have to spend too much time adding on everything.
As for your comment in your thread about the number of queries the weather install script does - Your right, the installation does make a lot of queries to your database, as it would if you were installing the original. That is why I made it as a seperate script and made notes to skip the steps to install it if you weren't planning on using it.

TECK
17 Oct 2002, 11:57
is up to you. as i said before, i dont force you.
do it only if you find it ethical and fair.

about the queries, i didnt refer to your script.
i was simply pointing an issue to Preech that many people here neglect the code for the look, wich is totally wrong.

if i would be an admin here i would install a review system, so people can read the problems the hack generates in general and the coder to learn from his mistakes.

thanks.

Kiraly
17 Oct 2002, 13:13
there are a problems?

FleaBag
17 Oct 2002, 15:31
Looks good, but I just finished getting vBindex 2.1 to work, so I won't be switching anytime soon.

Goldknight
17 Oct 2002, 15:54
PlurPlanet

This hack have everything but miss one featrure, (poll) however excellent work :)

Kiraly
18 Oct 2002, 13:34
infact! Poll
can you make this change?

MalaK_3araby
18 Oct 2002, 14:26
Hiya PlurPlanet

good job indeed and many thanks for sharing with us ..

i think i will wait for the Poll ...

thanks

irn-bru
18 Oct 2002, 17:40
best looking vb index made by members to date in
my words. nice work :)

Brad
18 Oct 2002, 18:23
Its easy to add polls to this. I would post the code but i dont wanna make anyone mad :)

Tigga
18 Oct 2002, 19:18
Glad to see everyone is liking this so far. :)
I'll see if I can get a poll included in the next version. As anime said, it wouldn't be that hard if someone wanted to add in the poll from another hack. ;)

LightBringer
18 Oct 2002, 20:32
Hmm, vbindex, vbhome, now mYvBindex...

when will the madness stop?

xxxsaint
18 Oct 2002, 21:28
hopefully it won't ;)

Kiraly
18 Oct 2002, 22:14
Originally posted by LightBringer
Hmm, vbindex, vbhome, now mYvBindex...

when will the madness stop?
yesss , next is yourpersonalvbulletindex! :D

TheSaint-AeD
19 Oct 2002, 14:33
Originally posted by Kiraly

yesss , next is yourpersonalvbulletindex! :D

And after That mypersonalvbulletinindex :)

nghiasi
19 Oct 2002, 20:51
heheeheh well all I can say is nice hacks! :D
It is so difficult to choose which one teh vbindex or the
my ones....
:P

LightBringer
20 Oct 2002, 02:26
Originally posted by nghiasi
heheeheh well all I can say is nice hacks! :D
It is so difficult to choose which one teh vbindex or the
my ones....
:P

Functionality beats visual any day in my book. :)

It's kind of like buying a used car, only there's no money transferred here.

You walk up to a beauty of a car and can't believe how shiny and new it looks on the outside, until you pop your head in under the hood or peek at the interior.

I'd rather have a pos jalopee that looks like it came out of a bad bladerunner parody, but it runs like a kitten. ;)

Vivi Ornitier
20 Oct 2002, 12:54
Hmm, the borders are a bit too thick. I'll change that when I use this, ;).

Graphics
20 Oct 2002, 13:15
Great work, I won't use this myself. But a nice addition all the same. ;)

Delmon
21 Oct 2002, 20:00
i am getting this error


Warning: ChDir: No such file or directory (errno 2) in /home/delmon/public_html/forums/myvbindex.php on line 21

Warning: Cannot add header information - headers already sent by (output started at /home/delmon/public_html/forums/myvbindex.php:21) in /home/delmon/public_html/forums/admin/functions.php on line 1573

Tigga
21 Oct 2002, 22:53
Hi Delmon. That error means you've got the path to your forums wrong in your myvbindex.php file. It should be set to "/home/delmon/public_html/forums". Also, your myvbindex file should be in your root directory instead of your forums directory, unless there's some particular reason you prefer to have it in your forums directory. If you do want to leave it in your forums directory you can simply delete that line and that should fix the problem too. ;)

I'm working on the next version of mYvBindex now too. The next version will include an option for polls plus a few other things, and the coding will be much cleaner. :)

TECK
22 Oct 2002, 04:09
Originally posted by LightBringer
Hmm, vbindex, vbhome, now mYvBindex...
when will the madness stop? you're so wrong. vbHome is the one and only original portal, coded entirely by me. the rest are all copycats, "improved" (actually deproved, since the no. of queries is doubled) with borrowed hacks from other people work.

if you look at the code everyone conviniently decided to use parts of my code, buddy.
not to talk that some of you are "amased" by nice html code but neglect the most important thing: the code.

Erwin
22 Oct 2002, 04:24
FWIW, vBHome is almost entirely original. vBIndex "borrowed" a lot from vBPortal. mYvBIndex "borrows" from all the predecessors. :) From what I can see, vBHome has the most elegant code, with the least queries. That doesn't mean it's wrong, as long as credit is given where it's due.

NTLDR
22 Oct 2002, 20:08
Originally posted by Erwin
vBIndex "borrowed" a lot from vBPortal.

That is true but from v2.1 I have re-written a majority of the PHP code for it and all credit has been given where its due. However vBindex will be repaced by a full portal written by scratch by me eventally anyway.

LightBringer
22 Oct 2002, 20:43
Originally posted by TECK
you're so wrong. vbHome is the one and only original portal, coded entirely by me. the rest are all copycats, "improved" (actually deproved, since the no. of queries is doubled) with borrowed hacks from other people work.

if you look at the code everyone conviniently decided to use parts of my code, buddy.
not to talk that some of you are "amased" by nice html code but neglect the most important thing: the code.

First of all "TECK" or should I call you nakkid, I never made any claim as to the nature or origin of any of these portals/front page hacks so I'm not sure where I am "wrong".

Second of all, I'm not your buddy TECK/nakkid. Hell I don't even know you and after this post, I don't think I want to either.

I don't care which one is the original, I don't care where the code was borrowed copied, and frankly, I could care less where even the most remote spark of creativity came from. The point is, instead of taking this attitude that your product is better, your code is better, all hail i'm the creator, bow before my l33tness, you should understand that while some of us enjoy the variety of hacks, we still reserve the right to pick and choose which hacks we want to install.

Your hack vbhome lite was Closed by request of nakkid.
on 5-28-02. 3 months later (08-27-02), when you decided to reopen it with the help of your friend James Tingle who wrote the commercial version, vbindex was already alive by 08-04-02 and I was all over it as an alternative to both vbportal and vbhome.

Maybe instead of spreading yourselves (plural for ALL hackers) thin, a joint effort on projects like this would yield some amazing results, since they are in fact meant for US, the community.

Just my $0.02, take it for what it's worth.

TECK
22 Oct 2002, 22:18
Originally posted by LightBringer
1. Second of all, I'm not your buddy TECK/nakkid. Hell I don't even know you and after this post, I don't think I want to either.

2. I don't care which one is the original, I don't care where the code was borrowed copied, and frankly, I could care less where even the most remote spark of creativity came from. The point is, instead of taking this attitude that your product is better, your code is better, all hail i'm the creator, bow before my l33tness, you should understand that while some of us enjoy the variety of hacks, we still reserve the right to pick and choose which hacks we want to install.

3. Your hack vbhome lite was on 5-28-02. 3 months later (08-27-02), when you decided to reopen it with the help of your friend James Tingle who wrote the commercial version, vbindex was already alive by 08-04-02 and I was all over it as an alternative to both vbportal and vbhome.

4. Maybe instead of spreading yourselves (plural for ALL hackers) thin, a joint effort on projects like this would yield some amazing results, since they are in fact meant for US, the community.

Just my $0.02, take it for what it's worth.
1. i dont need to know also, i have enough friends.

2. that remark show how ignorant you are, related to php. yes it is important the code, how well written it is. that's what makes the difference between vBulletin and other bulletin boards out there who ripped their code, for example.

3. James Tingle never helped me with the code. in fact, i was helping him with certain aspects related to the commercial script. the script was closed due to ignorance of some people, not worth mentioning even their name, then reopen at a few vb.org friends request.

4. there is nothing to join in it. i'm not the type of person who take someone else's work(hacks) and stick them inside my hack. all my code is written by me and it will stay like that.

Delmon
22 Oct 2002, 22:28
thanks
it is working fine with me

tingle
22 Oct 2002, 23:34
Originally posted by TECK
3. James Tingle never helped me with the code. in fact, i was helping him with certain aspects related to the commercial script. the script was closed due to ignorance of some people, not worth mentioning even their name, then reopen at a few vb.org friends request.

Hi,

Teck is right, i did not help on vbhome at all, he helped me by doing some graphics for me, but nothing else

Tingle

LightBringer
23 Oct 2002, 00:03
1. i dont need to know also, i have enough friends.

2. that remark show how ignorant you are, related to php. yes it is important the code, how well written it is. that's what makes the difference between vBulletin and other bulletin boards out there who ripped their code, for example.

3. James Tingle never helped me with the code. in fact, i was helping him with certain aspects related to the commercial script. the script was closed due to ignorance of some people, not worth mentioning even their name, then reopen at a few vb.org friends request.

4. there is nothing to join in it. i'm not the type of person who take someone else's work(hacks) and stick them inside my hack. all my code is written by me and it will stay like that.


1. Then don't refer to me as "buddy".
2. You know nothing about me or what I know or don't know about PHP Teck, so do not label me as ignorant. I never said it wasn't important you arrogant jacka$$, I said instead of riding your high horse with that egomaniacal chip on your shoulder, to get off of it and realize that there are much bigger things out there than YOUR hack(s).
3. My apologies for assuming you helped him, but I stated my reason for not using your hack so you can drop the "butthurt" act.
4. I never claimed that you were this type of person, the only thing you're doing here is drawing straws.


If you're going to attempt to continue this childish diatribe, then I suggest you and I take this offline. You started this meandering waffle, by misreading a post by someone you know nothing of. When you get your facts aligned, then maybe we can discuss them like adults.

Until then... /ignore

Erwin
23 Oct 2002, 00:58
Wow... calm down guys, it's not worth wasting sweat over a misunderstanding. :) Both of you are respected members of this site liked by many. Lightbringer is right though - take it off the site if you have further issues, and leave this thread for the support of the hack.

Keta
23 Oct 2002, 10:13
hmm i use vb index i kinda like this better but there is no poll feature? i guess i gotta stick with vbindex :(

Tigga
23 Oct 2002, 19:01
I'm releasing a new version tonight that includes a poll, fixes a bug or 2, and adds a few other nice options. Just have a few more things to do to the coding and need to finish up the install file before it'll be done. :)

madhouse
24 Oct 2002, 01:33
I got a nice issue with your myvbindex , after modifing the templates to my liking I was not totally satisfied(spelling) with it.
So I go to the uninstall and there was a query missing index_news_readmore.
So I went in to the uninstall file and added it to it cause it was causing a mysql error, now the problem still exsist and I cannot get rid of it.
I am afraid I might have to totally delete my database just to fix this issue unless someone else has some idea on how to fix this.
With only 185 members some people might not think that its not that many, but there is also over 11,000 post on it so that makes a lil more differnce.
Can someone please help me out here cause I really dont want to redo my board from scratch!

Tigga
24 Oct 2002, 01:42
Madhouse - What problem are you having exactly? The un-install script removes the database edits first, so a missing template shouldn't be a problem. If the problem your having is users can't post new threads, you should make sure you edited your newthread.php and newreply.php files to remove the modifications for mYvBindex. If that doesn't help or that's not the problem you're having please post more info and the exact error you're getting and I will help you to get things running again.

Tigga
24 Oct 2002, 02:00
User (top)

Tigga
24 Oct 2002, 02:01
User (bottom)

Smoothie
24 Oct 2002, 02:25
Looks good. Nice work.

madhouse
24 Oct 2002, 04:00
nm.... i got i fixed after about 4 hours lol

Preech
25 Oct 2002, 01:43
I"m having problems. It won't allow me to view this page period.
http://hiphopairplay.audiooutbreak.com/myvbindex.php

Tigga
25 Oct 2002, 03:31
Preech - What do you have the path set to in your myvbindex.php file? Are you running the forum on the same server as the myvbindex file?

madhouse
25 Oct 2002, 03:58
Plur, i think the weather is not in the template install....cause it didnt install the template for it.

Preech
25 Oct 2002, 03:59
This is how it looks.
chdir('http://hiphopairplay.audiooutbreak.com/airplay');

I hope I don't get in any trouble for doing this.

Tigga
25 Oct 2002, 04:11
Madhouse - The templates for the weather is now installed with the weather_install.php script as it's kinda pointless for someone to install those templates if they're not using the weather. If you upgraded from 1.0 and didn't want to run the weather installer again I can attach just the templates here for you.

Preech - The path is your problem. It should be set to the path to your forums, not the url. If you're not sure what the path is, you can create a file with just this content:

<?php phpinfo(32); ?>

Save it as info.php and upload it into your forums folder.
Then go to that file in your browser and you will see a list of options that were set by your host. One of them is called:

_SERVER["PATH_TRANSLATED"]

Copy that path, paste it over what you currently have and it should work fine. :)

Preech
25 Oct 2002, 04:31
Thank you very much. That worked grate

Tigga
25 Oct 2002, 04:32
Glad to hear it. Hope you enjoy the hack. :)

madhouse
25 Oct 2002, 15:17
That would be great Plur if u could do that for me...Thanks!

Tigga
25 Oct 2002, 15:40
Here's a template install script for ya Madhouse. :)
Just upload it to your admin directory and run it from your browser. Before you run the script, check to see if your mYvBindex options in your Admin CP has an option to turn the weather on (it should be the 3rd from the last option). If not, run step 3 of this installer (where it asks if you want to log into your Admin CP or add the option to show the weather). If you already have the weather button under your options you can skip that step and just log into your Admin CP.

madhouse
25 Oct 2002, 16:53
Thanks and if i ever get done with modifing the templates I will place my site's link here so u can see it. :)

Tigga
26 Oct 2002, 20:28
I actually already checked it out from the link in your profile. It looks very nice. :)

Units
03 Nov 2002, 18:40
I am getting a parse error:

Parse error: parse error in /home/rap-conc/public_html/index.php on line 24

Tigga
03 Nov 2002, 23:53
What do you have your path set to? From looking at your site, it looks like it should be set to /home/rap-conc/public_html/forums

BlueHawk
04 Nov 2002, 03:30
Hmm i seem to be having a little problem, ive followed all the instructions for installing, but for some reason i get a mySQL error

http://www.4u-servers.net/myvbindex.php

Me wants this to work, looks great.

Tigga
04 Nov 2002, 03:37
I went to the link, but all I see is "This board is closed at the moment. Please call back later."
The MySQL error is probably a simple mistake in editing the files. If you'll post the error message here I'm sure I can help you get it working. :)

Tigga
04 Nov 2002, 03:42
By the way... If anyone has any suggestions for features they'd like, please post them here. I'm working on the next version, but I'm running out of idea's for stuff to add.

BlueHawk
04 Nov 2002, 03:46
eeeep lol what a n00b, didnt realise it was still closed :/

The error is

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT thread.threadid,thread.title,thread.replycount,thread.postusername,thread.postus erid,thread.dateline as dateline,post.pagetext,thread.iconid,post.postid FROM thread LEFT JOIN post USING (threadid) LEFT JOIN user ON (user.userid=thread.postuserid) WHERE thread.forumid=http://www.4u-servers.net/forumdisplay.php?s=&forumid=5 AND isnews='Y' GROUP BY thread.threadid ORDER BY thread.threadid DESC LIMIT 10
mysql error:

mysql error number:

Date: Monday 04th of November 2002 04:45:24 AM
Script: http://www.4u-servers.net/myvbindex.php
Referer:


Damn fast response by they way :)

Tigga
04 Nov 2002, 03:53
Hmmm... That looks like you put in the wrong info for the News ID under your mYvBindex options. Judging by the error, it looks like you have http://www.4u-servers.net/forumdisplay.php?s=&forumid=5, when all you should have in there is the number 5.
If that's not the case, double check that you made the correct modifications to your newthread.php and newreply.php files.
Let me know if that helps. :)

BlueHawk
04 Nov 2002, 04:26
Yep your right, i put the full address instead of just the number + for some reason when i used the search and replace function on my software, it left the code in strange places.

All is working now except for me changing the header area and getting the banner script and stuff on it. Should it not do that anyway? Im getting a bit at the top of Admin area when i look at templates

$only['getinfo'] = 'User Info Display'; $only['index'] = 'mYvBindex';


Thanks for the help, better get some kip now as its nearly 5.30am and i got to be up again at 7am :(

Tigga
04 Nov 2002, 04:42
Looking good. :)
After you get some sleep, you may want to check that you have the following lines of code in the file...

$recorddate = vbdate($dateformat,$maxusers[1]);
$recordtime = vbdate($timeformat,$maxusers[1]);

I noticed that it's not showing the date for your "Most users ever online" part. I looked at my install file and I wasn't very clear about that part. I said to copy all lines between another one and the code above, but I guess I should have said to include those lines as well. ;)
Just put that code above right before this code and it should work fine.

$getbgrow=getrowcolor();
eval("\$loggedinusers = \"".gettemplate('index_online')."\";");

Goldknight
04 Nov 2002, 04:52
PlurPlanet, I tried your hack and it s great but unfortunately I have two issues.. well maybe three issues..

At first, your hack didnt show who's online even though I turn it on...

Second, it fixed on date (12-31-1969) all of time, but any date like create thread, post, and more work normal..

Third, I wonder is it possible for you to create divide weather_install hack? I kept got time out every time I try weather_install due.. I cannot add the weather feature which I really want.

Thanks, if need the url, I ll more than glad to provide you thur PM, I prefer to have it private.

Edit: Add attachment for quick look..

Tigga
04 Nov 2002, 04:52
Ahh... You're sneaky. Editing your post while I was replying. :p
For the header, you can do one of 2 things...
1) Copy your original vBulletin header template and replace the code in your index_header template with that. You will then have to add $bburl in front of each link so that they will point to the right place.

2) If you want it to use your regular forums header, look in your myvbindex.php file for the following code:
eval("\$index_header .= \"".gettemplate('index_header')."\";");
And replace it with
eval("\$index_header .= \"".gettemplate('header')."\";");
Then you will also have to add $bburl in front of each link in your original header template to ensure the links will point to the right place. This will change it so it looks for your original vB header instead of the index_header template. If you do that, you should also look near the top of the myvbindex.php file for "index_header" in the $templatesused section. Replace that with just "header" to avoid adding an unnecessary query to that page. Then in your index template, look for "$index_header" and replace that with "$header".

Tigga
04 Nov 2002, 04:55
Goldknight - Yes, please PM me with the url to the file so I can have a look and see exactly what you mean. Those are some strange errors I haven't encountered before, but I'll be glad to help you get them straightned out. :)

Actually... Could you email me (brian@plurplanet.com) the contents of your myvbindex.php file? It looks like you may have missed a little code when copying and pasting. If it's what I think it was, I should have been a little clearer in the install instructions, so it's really my fault.

Goldknight
04 Nov 2002, 04:58
Ok, I PM you my url thanks!

I email you the index.php (myvbindex.php) by your recent request

Tigga
04 Nov 2002, 05:13
Goldknight - I emailed you with the correct code for the index file. There was a section where you had to copy original vB code which wasn't done correctly. :)

For the weather... Do you know which step you made it to in the install file? Let me know and I'll see if I can help you get that working as well.

Goldknight
04 Nov 2002, 05:14
Hmm thats where I miss lol.. sorry =\ anyway I got your email and I upload it up then I got error:

Parse error: parse error, unexpected T_VARIABLE in /home/virtual/site57/fst/var/www/html/index.php on line 278

Tigga
04 Nov 2002, 05:21
Did you perhaps edit something in the file when trying to get the online users part to work before? I'll compair the 2 files and see if I can figure out what's different...

Goldknight
04 Nov 2002, 05:23
? no, I didnt modify anything with (myvb)index.php at all. After I found out that it didnt display online and date so I come and post about it.

Goldknight
04 Nov 2002, 05:30
I got your email and I email you back. Anyway online is working now =D Thanks! but date feature is not.

Tigga
04 Nov 2002, 05:30
That's really odd... I took the file you sent me, replaced the path with my test server's info, and got the same error. Somehow something had to have been changed, but I'm not sure what or how. I emailed you with my original file with all the correct code added and your server info in place. Try that out and if it still doesn't work let me know.

Tigga
04 Nov 2002, 05:33
Grrr! Sorry about that... I took out a piece of code when you first posted to see if I could recreate your problem and forgot I had done that. In your myvbindex file search for this code:

$recordusers = $maxusers[0];

Right below that add:

$recorddate = vbdate($dateformat,$maxusers[1]);
$recordtime = vbdate($timeformat,$maxusers[1]);

Upload the file and it'll work fine. :)

Goldknight
04 Nov 2002, 05:40
Yeah, I undy why I miss it, I misunderstand your instruction.. it s hard for me to undy some instruction since english is not my first lanuage. Anyway thanks for taking your time and help me out. It s solve! Thanks!

Oh about weather, I cannot install at all, whenever I browse admin/weather_install.php and it just pop up error page with time out. I didnt make any step at all, I think it is too much for my host, it work well on my local server but not at host. If it is hassle for you to make "divide" install, you dont have to.

In any way, thanks for help ^_^

Tigga
04 Nov 2002, 05:40
Oh, and if you would still like to get the weather installed I'll be glad to help. I just need to know how far you made it in the install script so I know what has and hasn't been done. I would assume the last thing you saw would have been "Adding city values 1-10,000..." but want to make sure. Let me know that, and if you have phpMyAdmin there is another way to install the script.

Hehe... Posting at the same time. Just let me know the above questions and I'll help ya out. :)

Goldknight
04 Nov 2002, 05:44
I test it at local server and I know what you re talking about. But unfortunately I cannot make any steps at all with weather_install.php, not even open the page of weather_install.php itself.

As for phpmyadmin, yeah I have it on the net, so what do I need to get your weather hack to work? Thanks for being patience with me :D

Tigga
04 Nov 2002, 05:46
No problem at all. :)
Give me a minute or two and I will get the manual file edits and attach them here.

Goldknight
04 Nov 2002, 05:50
Ok :)

:banana:

Tigga
04 Nov 2002, 05:58
Ok, here is a zip file with all the queries that you can do in phpMyAdmin. You will want to open each text file included, copy and paste them into phpMyAdmin and run the queries.
Be sure to run the queries in the "create_tables.txt" file FIRST. Then run the queries listed in the other .txt files (it doesn't matter what order) individually. Each of those queries will probably take a few minutes to execute. After those are finished you should upload the weather_template.php to your fourms/admin folder and run that in your browser. That is just a small file that will install all the templates for you. After that you can go into your Admin CP and turn the weather on under your mYvBindex options.

Goldknight
04 Nov 2002, 06:11
Thanks! =D I ll let you how it is, it ll take a while.. my girlfriend have only 56k modem =\ So take a break =D You deserve it.

Goldknight
04 Nov 2002, 06:32
Done install database and weather_templates.php but unfortunately error come out after I turn weather feature on =\

Error:
Fatal error: Call to undefined function: convert_temp() in /home/virtual/site57/fst/var/www/html/index.php on line 599

I left it on so you can check it out. Thanks

Tigga
04 Nov 2002, 06:38
Looks like you forgot to make the changes in admin/functions.php that were listed in the instructions. ;)

Find:
// ###################### Start doshutdown #######################

And above that add:
// ###################### 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";
}
}

function convert_press($number,$tps) {
$number *= 1;
if ($tps == 0) {
$number = $number *33.86;
$number = round ($number);
return "$number mbar";
} else {
return "$number inHg";
}
}

function convert_length($number,$tps) {
$number *= 1;
if ($tps == 0) {
$number = $number * 1.609;
$number = round ($number);
return "$number km";
} else {
return "$number mi";
}
}

function convert_speed($number,$tps) {
$number *= 1;
if ($tps == 0) {
$number = $number * 1.609;
$number = round ($number);
return "$number km/h";
} else {
return "$number mph";
}
}

function getdayofweek($numbers) {
if ($numbers == "1") {
$dayofweek="Sunday";
return "$dayofweek";
} elseif ($numbers == "2") {
$dayofweek="Monday";
return "$dayofweek";
} elseif ($numbers == "3") {
$dayofweek="Tuesday";
return "$dayofweek";
} elseif ($numbers == "4") {
$dayofweek="Wednesday";
return "$dayofweek";
} elseif ($numbers == "5") {
$dayofweek="Thursday";
return "$dayofweek";
} elseif ($numbers == "6") {
$dayofweek="Friday";
return "$dayofweek";
} else {
$dayofweek="Saturday";
return "$dayofweek";
}
}

function getweathertype($type) {
if ($type == '1') {
$weathertype="Cloudy";
return "$weathertype";
} elseif ($type == '3') {
$weathertype="Mostly Cloudy";
return "$weathertype";
} elseif ($type == '4') {
$weathertype="Partly Cloudy";
return "$weathertype";
} elseif ($type == '13') {
$weathertype="Light Rain";
return "$weathertype";
} elseif ($type == '14') {
$weathertype="Showers";
return "$weathertype";
} elseif ($type == '18') {
$weathertype="Rain";
return "$weathertype";
} elseif ($type == '19') {
$weathertype="AM Showers";
return "$weathertype";
} elseif ($type == '20') {
$weathertype="Scattered Showers";
return "$weathertype";
} elseif ($type == '21') {
$weathertype="Few Showers";
return "$weathertype";
} elseif ($type == '22') {
$weathertype="Mostly Sunny";
return "$weathertype";
} elseif ($type == '24') {
$weathertype="Sunny";
return "$weathertype";
} elseif ($type == '26') {
$weathertype="AM Clouds/ PM Sun";
return "$weathertype";
} elseif ($type == '27') {
$weathertype="Isolated T-Storms";
return "$weathertype";
} elseif ($type == '28') {
$weathertype="Sct T-Storms";
return "$weathertype";
} elseif ($type == '29') {
$weathertype="PM Showers";
return "$weathertype";
} elseif ($type == '32') {
$weathertype="Few Snow Showers";
return "$weathertype";
} elseif ($type == '33') {
$weathertype="Cloudy/ Wind";
return "$weathertype";
} elseif ($type == '36') {
$weathertype="Rain/ Thunder";
return "$weathertype";
} elseif ($type == '37') {
$weathertype="Partly Cloudy/ Wind";
return "$weathertype";
} elseif ($type == '40') {
$weathertype="Light Rain/ Wind";
return "$weathertype";
} elseif ($type == '41') {
$weathertype="Showers/ Wind";
return "$weathertype";
} elseif ($type == '43') {
$weathertype="T-Showers";
return "$weathertype";
} elseif ($type == '44') {
$weathertype="Mostly Sunny/ Wind";
return "$weathertype";
} elseif ($type == '49') {
$weathertype="Sct Flurries/ Wind";
return "$weathertype";
} elseif ($type == '51') {
$weathertype="PM T-Storms";
return "$weathertype";
} elseif ($type == '53') {
$weathertype="T-Storms";
return "$weathertype";
} elseif ($type == '55') {
$weathertype="Sunny/ Wind";
return "$weathertype";
} elseif ($type == '56') {
$weathertype="AM T-Storms";
return "$weathertype";
} elseif ($type == '80') {
$weathertype="AM Light Rain";
return "$weathertype";
} elseif ($type == '84') {
$weathertype="Snow Showers";
return "$weathertype";
} elseif ($type == '90') {
$weathertype="Snow/ Wind";
return "$weathertype";
} elseif ($type == '98') {
$weathertype="Light Snow";
return "$weathertype";
} elseif ($type == '100') {
$weathertype="PM Snow";
return "$weathertype";
} elseif ($type == '103') {
$weathertype="Light Snow/ Wind";
return "$weathertype";
} elseif ($type == '106') {
$weathertype="Light Wintry Mix";
return "$weathertype";
} elseif ($type == '109') {
$weathertype="Snow";
return "$weathertype";
} elseif ($type == '133') {
$weathertype="PM Snow Showers/ Wind";
return "$weathertype";
} elseif ($type == '153') {
$weathertype="PM Light Snow/ Wind";
return "$weathertype";
} elseif ($type == '155') {
$weathertype="PM Snow Showers";
return "$weathertype";
} elseif ($type == '175') {
$weathertype="PM Light Snow";
return "$weathertype";
} elseif ($type == '181') {
$weathertype="AM Snow/ Wind";
return "$weathertype";
} else {
$weathertype="Unknown Type";
return "$weathertype";
}
}

Goldknight
04 Nov 2002, 06:40
...... I should not stay up so late.. sorry for put up with me.. I m going to use that right away

Goldknight
04 Nov 2002, 06:51
Okey dokey it works now =D but whats up with disappear temperature? Both in weather setting and frontpage.

Thanks =D

Edit: Also I wonder if can you add uninstall weather if it cause problems or troubles so I can uninstall only weather instead of all in uninstall_myvbindex.php. Thanks

Tigga
04 Nov 2002, 07:00
Actually, I'm not completely sure about that one. As you see in the file, that's a hack created by JJR512 that I added in with my script. It works fine on my personal site and another I did, but I have the same problem on my "test" server. I read through JJR512's thread earlier and saw that one other person posted with the same problem, but nobody has posted a fix yet. I'll play around with it a bit and see if I can figure out why it doesn't display correctly for some people, but I can't guarantee I'll find a fix for this one...

Goldknight
04 Nov 2002, 07:08
Oh ok, I ll turn it off for now, Thanks for everything ^_^ Also I wonder will you do the uninstall weather or ? If not, then I ll undy and I think I can do manual, I m not sure =D

Tigga
04 Nov 2002, 07:23
Well so far I'm not having much luck figuring out why it doesn't work. I've looked over the code and everything seems ok, but I'll play with it a bit more tonight.
For now you can just turn it off, or you could edit out the temperature parts (though in my opinion that's one of it's main features). Maybe I'll figure it out or someone will post a fix in the original thread soon. If you decide you want to uninstall it, you can just upload the myvbindex_uninstall.php file to your admin folder. Then you would go to http://yoursite.com/forum/admin/myvbindex_uninstall.php?step=3. That will remove all the weather templates and database fields. Just be sure not to do that unless you're positive you want to uninstall it because there won't be a conformation screen and you'll have to re-do everything for the weather if you decide you want it back. ;)

Goldknight
04 Nov 2002, 07:31
Great, many thanks! I ll save it when and if weather is still not work. As you said, temperature is one of its main feature.

Thanks for everything =D

BlueHawk
04 Nov 2002, 08:07
Is it supposed to auto use the settings i have for the rest of the forum? Do i have to edit and put info in manually?

Tigga
04 Nov 2002, 08:11
Which part exactly? If you're referring to the news, please look at the part in the install file that tells you how to set the permissions for the forum. If you're talking about something else please explain what you mean a little more. :)

BlueHawk
04 Nov 2002, 08:18
Basicly its not using the header settings, not showing the php banner script at the top and is using old button links accross top instead of those in the php file. The buttons are turned off for the normal forum.

Take any thread eg. http://www.4u-servers.net/showthread.php?s=&threadid=224 you wil see whats missing :)

Tigga
04 Nov 2002, 08:24
Ahhh... Yes, that made it much more obvious. :)
By default it uses the index_header template for the header since some people may want a different header for their homepage. See post # 73 (http://www.vbulletin.org/forum/showthread.php?postid=318482#post318482) to see how to change it.

BlueHawk
04 Nov 2002, 08:43
lol now the buttons have gone :) but its not using the template "phpinclude" this has the whole php file with banner script, logo and link pictures.

(you must be getting annoyed with me now, sorry).

Tigga
04 Nov 2002, 08:55
Which method did you use to change it? If you used the 2nd way so it would just call your regular header, I forgot that you would need to change "$index_header" to "$header" in your index template (sorry, it's late ;)).
If you used the first method, I'm not completely sure why it wouldn't have worked. You said you used a php file for your header... Is there maybe a place to set a path to the file or something like that? If you could post the header & phpinclude templates or email them to me (brian@plurplanet.com) so I can have a look I'll see if I can figure it out. Or you could try the 2nd method to include it, which really is better if you want to have the same header for your forums and index page. That way you don't have to edit both anytime you change it. ;)

Tigga
04 Nov 2002, 09:04
Ok, it's late... Scratch that part about changing $index_header to $header. It's still using the $index_header variable to call the header, so that's not the problem.

Graphics
05 Nov 2002, 02:50
http://advance.clawz.com/myvbindex.php
can u help me, the myvBIndex doesnt show up its come to a blank screen - Help!

Tigga
05 Nov 2002, 02:53
Hmm... What do you have set for your path? Also double check that the index templates are listed in your Admin CP.

Graphics
05 Nov 2002, 04:55
hmm...

Home Directory: /var/www/advance.clawz.com/

this?



EDIT: problem solved, forogtten to put /vb/ at end Stupiod Me!

Tigga
05 Nov 2002, 05:05
LOL! Let me know if you have any other problems. :)

Graphics
05 Nov 2002, 06:18
the news thingy did not show up so pls help me the id number is 2

Tigga
05 Nov 2002, 06:27
The post was made after you installed myvbindex, right?
Do you have only the number 2 in the box for the News Forum ID?
Did you make the changes to newthread.php and newreply.php and upload them?

Graphics
05 Nov 2002, 06:48
i made the post AFTER i installed the hack. and number 2 is the ID for the news forums

Tigga
05 Nov 2002, 06:58
Did the install file run correctly? I'm assuming it did since it created the templates and such... The only other thing it could be is you didn't make the right changes to newthread.php and newreply.php. Double check that you made the 2 changes in each of those files, upload them again, and make another news post. There's no reason that shouldn't work, but if it doens't let me know and we'll get the problem solved. :)

Graphics
05 Nov 2002, 06:59
i have done it correctly but what is the problem?

Tigga
05 Nov 2002, 07:07
If it's not showing up something had to have been missed... If you have phpMyAdmin, you can log into there and check your "post" table to make sure it has a column called "isnews" (it should be the last one in the post table). There's really not a reason that shouldn't be there since it's the first step in the installer, but it wouldn't hurt to double check that it's there.
Could you email me (brian@plurplanet.com) with your newthread.php and newreply.php files so I can have a look at them?

Graphics
05 Nov 2002, 07:12
email sent with the two files.

Tigga
05 Nov 2002, 07:24
Ok, I looked over those files and both of them were modified correctly. Do you have phpMyAdmin where you could check to make sure the "isnews" column is there? I don't see a reason it wouldn't be if the installer ran correctly, but then again I don't really see a reason the news wouldn't be working. You could also try re-uploading your newreply & newthread files and then try making another news post.
If it's still not working, I could take a look at things for you if you would like to make a temporary account on your forums and give me access to your admin pages. Of course I understand if you don't want to give some stranger access to your admin pages, but it would be easier to locate the problem if I could look through the pages.

Graphics
05 Nov 2002, 07:28
according to my phpmyadmin, its has the table in it
edituserid int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
editdate int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
isnews char(1) No N

Graphics
05 Nov 2002, 07:32
its still not working but you need to go on aim to chat with me

my aim is DigiPowerX

Tigga
05 Nov 2002, 07:34
Ok, I may have found the problem... What do you have your "News Posts Maximum" set to? If it's set to 0 try changing it to something else. That was a bug in v1.0 that I thought I had fixed, but apparently I missed it. I just tried it on my personal site and when I set that to 0 the news didn't appear.

Goldknight
05 Nov 2002, 09:43
PlurPlanet

Everything work great so far, I m curious which replacements in which vbmyindex template to change the highlight on "today date" on calendar at vbmyindex.php? I want to increase the color since my background color is dark and I cannot see any highlight at all. Thanks

Goldknight
05 Nov 2002, 16:10
Edit: Never mind.. I m such idiot about border... thanks in case

Tigga
05 Nov 2002, 17:33
Just incase you decide you'd like to change it later, here's what you'd do...

Open myvbindex.php and look for this line:

$calendarbits.="<td bgcolor=\"{ firstaltcolor}\"><smallfont color=\"{ caldaycolor}\">$daylink</font></td>";

(Be sure to remove the space in front of { firstaltcolor} and { caldaycolor} when you search for that)

Then you'd just change { firstaltcolor} to whatever you'd like it to be, and if you'd like to change the font color you'd just change the { caldaycolor}.

chipheodeptrai
06 Nov 2002, 02:47
Hi Plurplanet

Great hack

I want to ask about login? i wish when i put username and password...login to forum, not myvbindex? you can fix it?

Thanks

Tigga
06 Nov 2002, 03:30
Hi Chip,
It should already take you back to the homepage when you log in. Be sure you followed the instructions, specifically the part where you edit the 2 lines in your member.php file, and make sure you uploaded that file to your forums directory. If for some reason that doens't work let me know.

chipheodeptrai
06 Nov 2002, 10:15
yes i done...it is working ...but to my home... i mean when i put user & pass, it will log in direct to my forum...the same vbulletintemplates.com

Thanks so much good man

Tigga
06 Nov 2002, 10:23
Ahhh, sorry if I misunderstood you the first time. If you would prefer for your user to be redirected straight to your forums page after logging in instead of the myvbindex page, just undo the changes you made to your member.php file. :)

chipheodeptrai
06 Nov 2002, 11:16
OH...you mean i undo edit member.php...Ok i will try.

You can add info about forum as total member, total thread...newest members, new post...

regards

Goldknight
06 Nov 2002, 16:25
PlurPlanet, thanks for codes. I drop the calendar anyway and will change a bit...

I wonder is it possible to add the avatar to news post? Id like to have that one so how? Thanks in advance.

Graphics
06 Nov 2002, 20:59
Just add the $postbit[avatar]

NTLDR
06 Nov 2002, 21:05
Originally posted by Graphics
Just add the $postbit[avatar]

That won't do anything anywhere.

chipheodeptrai
07 Nov 2002, 17:47
Hi

When i quote...have erorr in newreply :

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/myweb/public_html/vtf/newreply.php(47) : eval()'d code on line 1

whats happen

Thanks

Tigga
07 Nov 2002, 20:44
chipheodeptrai - Do you have any other hacks installed where you modified newreply.php? The only modification made for this hack is one to add a field to the database to determine if the post is news, which shouldn't affect quoting a post.
For your question about adding forum info... Yes, it can be added fairly easily. Keep in mind though that for each thing you add (total posts, total threads, newest member, etc) it will add an additional query to your database. To add these, open your myvbindex.php file and look for :
// Welcome Text & Buddy List or Logincode

Then right above that add:
// total members
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$numbermembers=number_format($numbersmembers['users']);

// get total posts
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
$totalposts=number_format($countposts['posts']);

// get total threads
$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');
$totalthreads=number_format($countthreads['threads']);

// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid'];

Then you would just add the variables $numbermembers, $totalposts, $totalthreads, and (for newest member) <a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$newuserid">$newusername</a> to the template where you would like them to appear.


Goldknight - I should be able to release v2.1 by this weekend which will include news avatars plus a couple of other new features. And don't worry, upgrading will be easy. :)

If anyone has some suggestions for features they'd like added in future versions please let me know.

Goldknight
07 Nov 2002, 21:03
Originally posted by PlurPlanet

Goldknight - I should be able to release v2.1 by this weekend which will include news avatars plus a couple of other new features. And don't worry, upgrading will be easy. :)

If anyone has some suggestions for features they'd like added in future versions please let me know.
Great! I gotta marry you :p I ll ask few members to see if there is any more to add. Will be back with suggestions or nothing.

speaking of avatar, is it individual avatar or just one news avatar? It ll be nice to have individual avatar normal just like postbit.

Graphics
08 Nov 2002, 06:03
will u put the colour onlines addons in fortoday online and currently online

Goldknight
13 Nov 2002, 05:10
PlurPlanet, any luck with avatar?

There is one concern that I need your help with. I have two different style and selectable for members to use. Anyway after I change to different style and I modify style a bit to add home (wwwurl.com/index.php) to access myvbindex instead of delete in url in IE or whatever to access. And myvbindex kept old style even after I change the style. Not only that I tried to use url in IE to access and found it still keep old style too.

Is it possible for me to change that to work with multiple style to access myvbindex with whatever style I select? Thanks

Tigga
13 Nov 2002, 11:46
Sorry, I haven't had as much time to work on this lately. I've been doing a lot of work on my site, plus I've starting work on a bigger project. :)
It's not a problem getting it to display the news poster's avatar, but I've had problems getting it out of a query loop (basically for every news post it will add one query to the page). If you'd still like to add the avatars despite the loop let me know and I'll post the code to change. I'm not going to release the new version though until I can get that loop fixed.
For the styles - I just looked at it and it appears that the colors, images, and such are changing as they should, just not the header. Since your header is the same for your forums and your index, you should be able to look in your index template and replace "$index_header" with "$header". Then it will just pull your regular header templates instead of the index_header template. If for some reason that doesn't work let me know.

Oh, and Graphics... You should be able to do that using the hack on here. Just make the changes to myvbindex.php instead of your forums index.php file. I haven't really looked at that hack but it should work.

Goldknight
13 Nov 2002, 17:36
Replace $index_header with $header in index seem work =) Thanks also about avatar and queries, yeah I aint mind due to numbers of members anyway for present. Many thanks

Tigga
13 Nov 2002, 23:56
Ok, here's a quick & easy way to add the news avatars. I wouldn't recommend adding it if you have a couple of dozen news posts, but otherwise it won't really have an effect on performance.

In your myvbindex.php find:

// News Comments

Right above that add:

$newsavatar='';
$newsavatarurl=getavatarurl($news[userid]);
if ($newsavatarurl=='') {
$newsavatarurl='images/clear.gif';
} else {
$newsavatarurl=''.$newsavatarurl.'';
}
eval("\$newsavatar = \"".gettemplate('index_news_avatar')."\";");

Then create a new template called index_news_avatar with the following content:
<img src="$bburl/$newsavatarurl" border="0">
(Of course you can edit that if you would like it to link to the news posters profile or something like that)

Then in your index_newsbits template add $newsavatar wherever you'd like the avatar to appear.
That's it. :)


I should have a little more time to work on the hack and release the next version by next week. After that I probably won't be releasing any future versions for a while as I'm going to be concentrating on a much bigger project that will combine myvbindex with a bunch of other options. Assuming everything goes well I'll be looking for beta testers in a few weeks, so I'll post more info about it then. :)

Goldknight
14 Nov 2002, 00:21
Great, thanks I m going to do that right away in an hour. Good luck about your project =) If you need a beta testers, lemme know, I d love to try yours =D Thanks for everything.

Tigga
14 Nov 2002, 04:41
Well it may be anywhere between a few weeks and a few months before it's done, but if everything goes well it's going to be very nice once I'm finished. I will most likely charge a little for this one, but as soon as it's ready for beta testing you'll be the first to get a copy. :)

Tony DiMera
19 Nov 2002, 02:16
Is the weather hack any good to canadians? Or will it only show american cities?

Tony DiMera
19 Nov 2002, 03:37
I am having a problem getting the Calendar to work. Also i upload the weather_install.php to my admin directory, but when I try to go to the url it says cannot display page.

Tigga
19 Nov 2002, 05:13
Yes, the calendar will work for Canada or pretty much any country.
What problem exactly are you having with the calendar? Can you post or PM me the url to your myvbindex so I can take a look?

Tony DiMera
19 Nov 2002, 05:16
No I was asking if the weather will work for canada. Also Iupload the weather_install.php to my admin directory and when I try to run the script to install it, it says cannot display page.

Tigga
19 Nov 2002, 05:29
Yes, the weather will work for Canada. (sorry, that's what i meant in the first post)
Are you sure the weather_install.php was uploaded completely and you're going to the right URL?
What is the URL to your myvbindex?

Goldknight
19 Nov 2002, 06:43
Originally posted by PlurPlanet
Well it may be anywhere between a few weeks and a few months before it's done, but if everything goes well it's going to be very nice once I'm finished. I will most likely charge a little for this one, but as soon as it's ready for beta testing you'll be the first to get a copy. :)
I m in =D Thanks

Visionray
21 Nov 2002, 19:15
Hi,

This seems like a great hack, but I'm really only interested in displaying the latest threads on my main page, nothing else...no polls, no news, no nothing.

How would I go about doing this? I just want to have a section on a regular php page (my main index page, not my forum index page) that just displays the latest threads.

Is this possible?
Thanks

Goldknight
21 Nov 2002, 20:01
Visionray, yeah it is possible. You can turn off these features at AdminCP right after you install this hack.

Tigga
21 Nov 2002, 20:09
He could do it that way, but it would be pretty pointless to have all the extra code if it wasn't being used. If you look on here for TECK's "Latest XX Threads on Fourmhome", you should be able to edit that pretty easily to change it for use on a homepage. (I think all you would do is add the chdir('/path/to/your/fourm'); above the coding, though I haven't looked at it in a while). If you're not that good with PHP or can't figure it out let me know and I can make a file for you.

chipheodeptrai
22 Nov 2002, 15:59
Hye plurPlanet

i dont know why i cant login from myVBindex?

plz help
thanks

Tigga
22 Nov 2002, 19:25
Did you set the cookie path to your domain name as instructed in the install file? What is the url to your site?

Tony DiMera
23 Nov 2002, 23:27
Originally posted by PlurPlanet
Ok, here is a zip file with all the queries that you can do in phpMyAdmin. You will want to open each text file included, copy and paste them into phpMyAdmin and run the queries.
Be sure to run the queries in the "create_tables.txt" file FIRST. Then run the queries listed in the other .txt files (it doesn't matter what order) individually. Each of those queries will probably take a few minutes to execute. After those are finished you should upload the weather_template.php to your fourms/admin folder and run that in your browser. That is just a small file that will install all the templates for you. After that you can go into your Admin CP and turn the weather on under your mYvBindex options.

I did that but for what was in this txt file:

CREATE TABLE weather_country (
countryid smallint(6) NOT NULL auto_increment,
regionid smallint(6) NOT NULL default '0',
country_title varchar(50) NOT NULL default '',
PRIMARY KEY (countryid)
) TYPE=MyISAM;

I got this error:

Error
SQL-query : [Edit]

CREATE TABLE `weather_country` (`countryid` SMALLINT(6) NOT NULL AUTO_INCREMENT, `regionid` SMALLINT(6) DEFAULT '0' NOT NULL, `country_title` VARCHAR(50) NOT NULL ) TYPE = MYISAM comment = 'PRIMARY KEY (countryid)'

MySQL said:


Incorrect table definition; There can only be one auto column and it must be defined as a key

Back

Tony DiMera
26 Nov 2002, 20:49
*bump*

snout
30 Nov 2002, 15:44
Thanks for the hack m8... Ill check it out, look loads better than version 1 !!

*hits install*

Tigga
01 Dec 2002, 04:49
Tony - Those queries should work. The only other thing I can suggest is checking the Weather Mk thread and downloading the queries from there. One note though - I've had the weather turned off for my homepage for the last 2 weeks now. It's hardly been working, and even when it did it would cause my homepage to take 10-20 seconds to load. I think they changed the settings at theweatherchannel.com because their site's still working, but not the script. Once I have the time I may see if I can write a new one.

Snout - Thanks for installing. :)

3dfly
01 Dec 2002, 05:22
PlurPlanet thank you for the hack!!!
BEST ! And without hysterics about (Đ) and pirates ........ §ň§ň :)
Ill check it out tomorow.

corsacrazy
01 Dec 2002, 19:40
no news showing up and yes i followed every step and have uploaded new thread and reply, however when i do upload these files i cant post a reply nor a thread i hav double checked and the file mods have been done correctly and the isnews row does exist i just cant work it out, could it be something to do with other hacks i have installed in these two files ? cheers in advance

Tigga
01 Dec 2002, 20:16
Hmm, that's odd... I noticed in your profile that you have 40 hacks installed, so it is possible that something else could be affecting it. If you would like to email me (brian@plurplanet.com) with your newreply.php and newthread.php files I'll be glad to take a look and see if I can figure it out.
Also, what do you have set for News Forum ID and News Posts Maximum in the admin options? Could you post the url to your myvbindex.php file on the server so I can take a look there too?

Tony DiMera
01 Dec 2002, 23:05
Actually I tried that and it didn't work, could it be my phpMyAdmin version?

Welcome to phpMyAdmin 2.2.0
MySQL 3.23.41 running on localhost

Tigga
02 Dec 2002, 03:07
Try running this query instead...

CREATE TABLE weather_country (
countryid smallint(6) NOT NULL auto_increment,
regionid smallint(6) NOT NULL default '0',
country_title varchar(50) NOT NULL default '',
PRIMARY KEY (countryid)
) TYPE=MyISAM

corsacrazy
02 Dec 2002, 15:51
Originally posted by PlurPlanet
Hmm, that's odd... I noticed in your profile that you have 40 hacks installed, so it is possible that something else could be affecting it. If you would like to email me (brian@plurplanet.com) with your newreply.php and newthread.php files I'll be glad to take a look and see if I can figure it out.
Also, what do you have set for News Forum ID and News Posts Maximum in the admin options? Could you post the url to your myvbindex.php file on the server so I can take a look there too?

no problem mate i appriciate it, i will do as u requested asap !


here is what i hav in my options

News Forum ID : 15

News Posts Maximum : 1

News Maximum Characters : 5000

Tigga
02 Dec 2002, 16:44
Ok, your settings are fine so I would guess it's something with another hack. Were you able to post a new news topic after you installed the hack? If so, could you check with phpMyAdmin to see if the news column has an "N" or a "Y" in it for that column? Whenever you email me your files I'll test them on one of my servers and hopefully find out what's causing the conflict.
Also, if you already had a news forum before you installed the hack those posts will not show up, only new ones. If you did already have that section I can give you a query to run that will update those posts once everything's working right.

Tony DiMera
02 Dec 2002, 22:47
Actually I upgraded my phpmyadmin to 2.3.3 RC and I wasable to run the queries. So that was my prob I have to lold of a version.

350Chevy
03 Dec 2002, 03:24
installed.. although the Top xx Posters add-on would be nice. And it takes about 4 times longer to load than my last index.. And I'm on Cable! :D

350Chevy
03 Dec 2002, 03:32
Hmm, also the weather add-on is not working correctly.. it shows the city, the images, humitidy and everything except the weather...??

http://www.ls6.com

Tigga
03 Dec 2002, 03:32
I think there's a hack for the top xx posters here that could probably be integrated with this. If not let me know and I can probably make a quick one for you.
The page shouldn't take more than about 1/2 second to load though (usually closer to 1/10 of a second). Do you have the weather part of the hack turned on? If so then that would be the cause. I actually had to take that off my personal website because it was causing my homepage to take 10-20 seconds to load!

Tigga
03 Dec 2002, 03:36
Originally posted by 350Chevy
Hmm, also the weather add-on is not working correctly.. it shows the city, the images, humitidy and everything except the weather...??

http://www.ls6.com
Do you mean the temperature? That's something that I never could figure out... It works just fine on most servers, but for some reason it won't show the temperature on others. That part isn't my hack, but I've looked at the coding and everything looks good, so my only guess would be it's something to do with the way certain servers are configured.

350Chevy
03 Dec 2002, 03:44
Originally posted by PlurPlanet
I think there's a hack for the top xx posters here that could probably be integrated with this. If not let me know and I can probably make a quick one for you.
The page shouldn't take more than about 1/2 second to load though (usually closer to 1/10 of a second). Do you have the weather part of the hack turned on? If so then that would be the cause. I actually had to take that off my personal website because it was causing my homepage to take 10-20 seconds to load!

10-20 seconds! Ouch!

Yup, Taking that out helped a little. :)

I think I'll put it back in and play around with it some more. Looks great though! :)

350Chevy
03 Dec 2002, 03:44
Originally posted by PlurPlanet

Do you mean the temperature? That's something that I never could figure out... It works just fine on most servers, but for some reason it won't show the temperature on others. That part isn't my hack, but I've looked at the coding and everything looks good, so my only guess would be it's something to do with the way certain servers are configured.

Yup, sorry. I'm a bit tired.. hehe.. I'll check the weather mod thread and see what I can dig up. ;)

Thanks a bunch for the super quick replies!

350Chevy
03 Dec 2002, 21:08
Is there a way to get it to show the last person who posted in a thread instead of the thread starter? Or would that create too many queries? Just wondering.

Tigga
03 Dec 2002, 21:51
That's not hard to do at all and won't affect the queries one way or another. Just open up your myvbindex.php file and look for:
$threads=$DB_site->query("SELECT thread.threadid,thread.title,thread.replycount,thread.postusername
You would just replace "thread.postusername" at the end of that with "thread.lastposter". Then you would want to edit your index_threadbit template and replace this:

by <a href="$bburl/member.php?s=$session[sessionhash]&action=getinfo&userid=$thread[postuserid]">$thread[postusername]</a>

with this:

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

350Chevy
03 Dec 2002, 22:34
hmm, my threads string looks completely different in myvbindex.php


$threads=$DB_site->query("SELECT * FROM thread WHERE open='1' AND open<>10 $iforumperms ORDER BY lastpost DESC LIMIT $maxlatethreads");
while ($thread=$DB_site->fetch_array($threads)) {
$title = unhtmlspecialchars($thread['title']);
if (strlen($thread['title']) > $maxthreadchars and $maxthreadchars!=0) {
$title = substr($thread['title'], 0, $maxthreadchars - 3) . '...';
}
if ($showthreaddate) {
$thread['time'] = vbdate($timeformat, $thread['dateline']);
$thread['date'] = date("m-d-y", $thread['dateline']);
}



The news string looks simular to what you posted but that's for the news.. not the recent threads. ;)

Tigga
03 Dec 2002, 22:43
Ahhh, sorry about that. I changed that query a little when I was working on things and didn't realize it wasn't like that for the version on here. Really though, it makes your job a little easier. Just make the template modification above and it should work fine. :)

350Chevy
03 Dec 2002, 22:48
Gotcha! Thanks again! :)

I'm still trying to figure out why the weather temperatures don't show.

The front page now takes about 6 seconds or longer to load now too. There's not a lot of queries and the server and site are very fast. It's just the main page that takes a while to load. I've noticed other people with slower servers on sites that have low bandwidth and they load much faster than mine. Something doesn't add up...??

Tigga
03 Dec 2002, 22:56
No problem at all. :)
I'm still puzzled as to why the temperature doesn't work on some servers too... It works fine on my personal site, but not on my test server.
Does the page load ok if the weather is turned off? I was having that problem with mine too. It's nothing to do with the queries or anything like that, it's because it's now taking forever for it to get the weather info from theweatherchanel.com's server. That wasn't a problem a few moths ago, but for some reason it's now taking forever to get that info. I'm going to try to find another solution to display the weather when I get the time because I really like that feature, but I can't deal with my homepage taking 10-20 seconds to load.

350Chevy
03 Dec 2002, 23:30
nah.. with it turned off it still takes the same amount of time. The old index page was loading in 0.2 seconds or there abouts. Really fast.. I wonder how it loads on dialup.. lol

Maybe because it's grabbing a bunch of different templates where as my old index was only a few templates that did almost the same as your myvbindex. Yours looks better so I went with yours. ;)

Tigga
03 Dec 2002, 23:43
It really should take less than 1/2 second to load. Do you know how to put vBulletin in debug mode? If not, just open up your admin/config.php file and add $debug="1"; somewhere in there. Then upload that file, go to your index page and add ?explain=1 at the end of the url. That will show a breakdown of each query performed, how long it took, and etc. If you'd like to do that and post the results here I'll be glad to take a look and find out what's causing your page to take so long. Oh, and be sure not to leave it in debug mode afterwards because it could be a security risk. ;)

Oh, and it wouldn't have anything to do with the number of templates it's calling. It would have to be a query somewhere that's taking a while to execute.

350Chevy
03 Dec 2002, 23:51
hmm.. looks to be the poll...

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

Query: SELECT poll.*,thread.* FROM poll LEFT JOIN thread ON (thread.pollid = poll.pollid) WHERE thread.forumid='108' ORDER BY poll.dateline DESC LIMIT 1
Time before: 0.20745205879211
Time after: 3.5907980203629

table type possible_keys key key_len ref rows Extra
poll ALL 94 Using temporary; Using filesort
thread ALL 5231 where used


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

350Chevy
03 Dec 2002, 23:54
Yup.. I disabled the poll and check it out now..

Page generated in 0.32854795 seconds (54.16% PHP - 45.84% MySQL) with 25 queries.
[Debug Mode OFF] [PHP v4.2.3] [GZIP enabled - level 1] [Server Load: 1.18 ╗ 1.35 : 1.18]

Tigga
03 Dec 2002, 23:57
Query: SELECT poll.*,thread.* FROM poll LEFT JOIN thread ON (thread.pollid = poll.pollid) WHERE thread.forumid='108' ORDER BY poll.dateline DESC LIMIT 1
Time before: 0.20745205879211
Time after: 3.5907980203629
Well that would be the problem... Right there it took 3.3 seconds just to load the poll. Now that I know what the cause is I'll look over the files and see if I can figure out why it would be taking that long.

350Chevy
03 Dec 2002, 23:59
No problem.. I had another poll running before that didn't use the vB software and worked fine. If anything I'll just slap that puppy in there in place of the current poll.. ;)

Thanks for the suggestion. I never would have thought of that. And I must say you've helped me greatly. Much more help from you than anyone on any other forum! Many thanks! :D

350Chevy
04 Dec 2002, 00:23
I added your name and a link to your website in the footer on the main page to give you credit for the main page and for all the help. :)

Tigga
04 Dec 2002, 00:35
No problem at all. I never mind helping when I have the time. And thanks for the link. :)

When I checked the time it takes for a poll on my test server that query was done in about 0.002 seconds. The only thing I can think of at the moment is maybe you have another hack installed that's affecting it?
You can try replacing the query:
$pollinfo=$DB_site->query_first("SELECT poll.*,thread.* FROM poll LEFT JOIN thread ON (thread.pollid = poll.pollid) WHERE thread.forumid='$pollsforum' ORDER BY poll.dateline DESC LIMIT 1");{
With this one here:
$pollinfo=$DB_site->query_first("SELECT poll.pollid,poll.question,poll.dateline,poll.options,poll.votes,poll.active,poll .numberoptions,poll.timeout,poll.multiple,poll.voters,thread.pollid,thread.open FROM poll LEFT JOIN thread ON (thread.pollid = poll.pollid) WHERE thread.forumid='$pollsforum' ORDER BY poll.dateline DESC LIMIT 1");{
The original query tells the script to select all columns from the thread and poll tables. The new one tells it to only select the fields that are really necessary. Normally it selecting a couple of extra fields shouldn't be a problem, but I guess it could be in this case. Anyways, try that and see if it helps any and if not I'll try to figure out something else.

350Chevy
04 Dec 2002, 00:41
nah.. still at 3.6 seconds.. no problem.. I'll add the code in there to show my old poll.. I think it may have something to do when I upgraded from phpBB to vB. My forums and threads are way off as you could tell with the forum ID's being in the 100's. My post ID's are in the 100,000's! :D

Everything runs fine it's just the post and forum ID's are set really really high and I have no idea on how to drop them down. More than likely that's the cause. I'll play around with adding the old poll. For now I need to throw some steaks on the Bar-B. :)

Tigga
04 Dec 2002, 00:56
I was kind of wondering why the forumid #'s were so high. I still don't see why that would affect the way the poll functions, but then again I've never imported phpbb into vb, so I don't know much about the way it does it. Oh well, enjoy your steaks! :)

350Chevy
04 Dec 2002, 02:57
with your new changes...

Query: SELECT poll.pollid,poll.question,poll.dateline,poll.options,poll.votes,poll.active,poll .numberoptions,poll.timeout,poll.multiple,poll.voters,thread.pollid,thread.open FROM poll LEFT JOIN thread ON (thread.pollid = poll.pollid) WHERE thread.forumid='108' ORDER BY poll.dateline DESC LIMIT 1
Time before: 0.20889496803284
Time after: 2.7886350154877

table type possible_keys key key_len ref rows Extra
poll ALL 94 Using temporary; Using filesort
thread ALL 5235 where used


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

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


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

Query: SELECT * FROM thread WHERE open='1' AND open<>10 AND forumid=85 OR forumid=88 OR forumid=93 OR forumid=96 OR forumid=101 OR forumid=86 OR forumid=87 OR forumid=89 OR forumid=90 OR forumid=91 OR forumid=92 OR forumid=94 OR forumid=95 OR forumid=97 OR forumid=98 OR forumid=99 OR forumid=100 OR forumid=107 OR forumid=102 OR forumid=103 OR forumid=104 OR forumid=105 ORDER BY lastpost DESC LIMIT 10
Time before: 2.8690160512924
Time after: 3.2530399560928

350Chevy
04 Dec 2002, 03:01
hmm.. it's still using all 5000+ threads...??

Tigga
04 Dec 2002, 03:37
I'm not quite sure if I follow you about it using all 5000 threads... The first query looks the way it should, though I'm still not sure why it would be taking so long to execute. The other query there is from the latest threads part of the hack where it is checking each forum.

If you want to try something else, you can try replacing the poll query with this on here:
$pollinfo=$DB_site->query_first("SELECT poll.pollid,poll.question,poll.dateline,poll.options,poll.votes,poll.active,poll .numberoptions,poll.timeout,poll.multiple,poll.voters FROM poll ORDER BY poll.dateline DESC LIMIT 1");{

See what the time is like with that one and if it isn't improved, then try this one here:
$pollinfo=$DB_site->query_first("SELECT thread.pollid,thread.open FROM thread WHERE thread.forumid='$pollsforum' ORDER BY thread.dateline DESC LIMIT 1");{

Neither of those will actually fix the problem or let the poll work properly, but the first one leaves out the call to the thread table, and the second one leaves out the call to the poll table. If either of those improves the time then we know which table it's taking so long to query and will at least know a little more about what's causing it. Also, if the first query reduces the time, I may be able to work around calling the thread table.

350Chevy
04 Dec 2002, 04:01
ok.. I'll post the times in a second. :)

350Chevy
04 Dec 2002, 04:07
Results of the first line were quick...

Query: SELECT poll.pollid,poll.question,poll.dateline,poll.options,poll.votes,poll.active,poll .numberoptions,poll.timeout,poll.multiple,poll.voters FROM poll ORDER BY poll.dateline DESC LIMIT 1
Time before: 0.20555102825165
Time after: 0.20668196678162

table type possible_keys key key_len ref rows Extra
poll ALL 94 Using filesort

350Chevy
04 Dec 2002, 04:08
Results of the second one were fast as well..

Query: SELECT thread.pollid,thread.open FROM thread WHERE thread.forumid='108' ORDER BY thread.dateline DESC LIMIT 1
Time before: 0.20433604717255
Time after: 0.20571005344391

alkatraz
04 Dec 2002, 04:16
Hate to interrupt your guys troubleshooting session here but I'm curious if there's a way to add more custom templates? =)

I'm using a portal page write now that I did in html, and I have 5 sections that I would need to add.

Thanks!

Tigga
04 Dec 2002, 04:20
Ok, since both of those seem ok I guess it's not a problem with it querying the table, so maybe it's something with the way they are joined.

Try this query and see if it's any better...
$pollinfo=$DB_site->query_first("SELECT poll.pollid,poll.question,poll.dateline,poll.options,poll.votes,poll.active,poll .numberoptions,poll.timeout,poll.multiple,poll.voters,thread.pollid,thread.open FROM poll LEFT JOIN thread USING (pollid) WHERE thread.forumid=$pollsforum ORDER BY poll.dateline DESC LIMIT 1");{

350Chevy
04 Dec 2002, 04:20
alkatraz,

I would imagine you would just change this


// Custom Boxes
$custom1='';
$custom2='';
if ($showcustom1) {
$getbgrow=getrowcolor();
eval("\$custom1 .= \"".gettemplate('index_custom1')."\";");
}
if ($showcustom2) {
$getbgrow=getrowcolor();
eval("\$custom2 .= \"".gettemplate('index_custom2')."\";");
}


to something like this...


// Custom Boxes
$custom1='';
$custom2='';
$custom3='';
$custom4='';
$custom5='';
if ($showcustom1) {
$getbgrow=getrowcolor();
eval("\$custom1 .= \"".gettemplate('index_custom1')."\";");
}
if ($showcustom2) {
$getbgrow=getrowcolor();
eval("\$custom2 .= \"".gettemplate('index_custom2')."\";");
}
if ($showcustom3) {
$getbgrow=getrowcolor();
eval("\$custom3 .= \"".gettemplate('index_custom3')."\";");
}
if ($showcustom4) {
$getbgrow=getrowcolor();
eval("\$custom4 .= \"".gettemplate('index_custom4')."\";");
}
if ($showcustom5) {
$getbgrow=getrowcolor();
eval("\$custom5 .= \"".gettemplate('index_custom5')."\";");
}


And create templates for each.

Then edit the 'index' template located under mYvBindex Templates and add $custom3, $custom4, $custom5 where ever you want the templates to be displayed.

350Chevy
04 Dec 2002, 04:22
Originally posted by PlurPlanet
Ok, since both of those seem ok I guess it's not a problem with it querying the table, so maybe it's something with the way they are joined.


A little better...

Page generated in 2.58082700 instead of 3.6 - 4 seconds. :)

Tigga
04 Dec 2002, 04:29
To add more custom templates to your homepage, follow the instructions below...

Look in your myvbindex.php file look inbetween the following lines of code:
if ($showcustom2) {
$getbgrow=getrowcolor();
eval("\$custom2 = \"".gettemplate('index_custom2')."\";");
}
And:
$getbgrow=getrowcolor();
eval("dooutput(\"".gettemplate('index')."\");");

?>

In that space you can add code for it to call more custom templates. You would just add something like the following:

eval("\$custom3 = \"".gettemplate('index_custom3')."\";");

Or, if you would prefer to have the option to turn these templates on/off in the Admin CP like the first two, you would add something like this:
if ($showcustom3) {
$getbgrow=getrowcolor();
eval("\$custom3 = \"".gettemplate('index_custom3')."\";");
}

Then, only if you want to add the options to turn them on/off you would run the following queries via phpMyAdmin.

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 template you add (that's the part that tells it what order the option should be displayed).


The variable $custom3 in the code above can be called whatever you would like and would be what you would place in your index template to display your new custom template. Then the part index_custom3 in the above code may be renamed to whatever you would like to call your new template. Also, if you would like to be able to use the $getbgrow variable in that template to alternate between your firstaltcolor & secondaltcolor, you should add the following above that code as it is with the others.

$getbgrow=getrowcolor();

Tigga
04 Dec 2002, 04:39
Ok... I don't see where either of these queries would make a difference, but then again I don't see why it would be taking that one so long, so it's worth a shot, right? :)

Try this one:
$pollinfo=$DB_site->query_first("SELECT thread.pollid, thread.open, 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 USING (pollid) WHERE thread.forumid=$pollsforum ORDER BY thread.pollid DESC LIMIT 1");{

And if that doesn't help maybe this one:
$pollinfo=$DB_site->query_first("SELECT thread.pollid, thread.open, 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=$pollsforum ORDER BY thread.pollid DESC LIMIT 1");{

350Chevy
04 Dec 2002, 04:41
First one did it...

Page generated in 0.54202199 seconds

There's no link for discuss this poll but everything else works like a charm. :)

Tigga
04 Dec 2002, 04:47
Alright! All I did was basically have it call to the thread table rather than the poll table first. Don't see why that made a difference, but hey it works now. ;)

To fix the discuss this poll link just change the first part of the query to "SELECT thread.pollid, thread.open, thread.threadid," adding the thread.thredid in there. It figures I'd forget one small part when changing it. :)

350Chevy
04 Dec 2002, 04:50
LOL

Thanks a million.. :)

Tigga
04 Dec 2002, 04:54
No problem. At least now I know to make the query that way in future versions and hopefully prevent anyone else from having a problem. :)

mv540
05 Dec 2002, 03:12
On my portal page, the threads on the right, the private threads are showing up there as well, the link just goes to the you don't have permission page, but is there a way to make them not show up at all???
Thanks

Tigga
05 Dec 2002, 03:30
Are you sure all your forum permissions are set correctly in the Permissions part under "Forums & Moderators" in your admin CP? There's no reason they should be visible to anyone that doesn't have permission to view them. Double check those settings and let me know if it's still showing them.

mv540
05 Dec 2002, 03:42
Thanks for the response, I had the catagory set properly and thought that the sub forums would inherit the settings, but they didn't seem to in the portal, I set all reg users to no all down the list in all the sub forums, and it worked.

While I've got you here, I have the myvbindex all set up and ready to go, but I don't understand how to make it work with the login. I have placed the file myvbindex in the root folder and renamed it to index.php, but the login goes directly to the forums/index.php??

Tigga
05 Dec 2002, 03:49
That sounds like you missed the step to edit member.php in the install file, or maybe you forgot to upload it?
Check your member.php file and make sure it has these changes...

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

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



Find:
eval("standarderror(\"".gettemplate("error_cookieclear")."\");");

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

mv540
05 Dec 2002, 03:53
Here's what I got, looks like its ok

if ($url!="" and $url!="index.php" and $url!=$HTTP_REFERER) {

if (strpos($url,"?")>0) {
$url.="&s=$session[dbsessionhash]";
} else {
$url.="?s=$session[dbsessionhash]";
}
//header("Location: $url");

$url = str_replace("\"", "", $url);
eval("standardredirect(\"".gettemplate("redirect_login")."\",\"\$url\");");
} else {
$bbuserinfo=getuserinfo($userid);
eval("standardredirect(\"".gettemplate("redirect_login")."\",\"\$url\");");
}

}

mv540
05 Dec 2002, 03:57
correction, that doesn't look ok, I will change it

mv540
05 Dec 2002, 04:06
Guess it does look ok, I redid the code again and uploaded it and tried again, still the same, I go to forums/index.php

Tigga
05 Dec 2002, 04:16
Hmm... Can you either post here or PM me with the url to your site? Also, what version of vB are you running?

mv540
06 Dec 2002, 18:14
Maybe ill get an answer here, ive been completely ignored for tha past 4 hours....Im using this hack for my forum..its been installed but i have a question....I would like to know how to add more areas on the portal so that i can add more/other info manually....

for example..in the middle i have news and on either end i have the navigations...i would like to add more boxes to fill it up abit with information on the right and on the left of the page..

Please answer in detail for i am very new at this...let me know step by step where to go and what to do

Thanks

I~

Tigga
06 Dec 2002, 18:22
mv540 - If you'll refer to posts 194 & 196 in this thread that's already been explained. Either of those ways will work and should be pretty simple, but if you have any problems let me know.

mv540
06 Dec 2002, 20:17
this question i just asked recently is diferent, i got the index forum to work so when people register or sign in the see the portal...i just want to know basickly how to add more tables if thats what they are called..but ill have a looks see and check if thats what im looking for..

thanks for the help..

mv540
06 Dec 2002, 20:29
Originally posted by 350Chevy
alkatraz,

I would imagine you would just change this


// Custom Boxes
$custom1='';
$custom2='';
if ($showcustom1) {
$getbgrow=getrowcolor();
eval("\$custom1 .= \"".gettemplate('index_custom1')."\";");
}
if ($showcustom2) {
$getbgrow=getrowcolor();
eval("\$custom2 .= \"".gettemplate('index_custom2')."\";");
}


to something like this...


// Custom Boxes
$custom1='';
$custom2='';
$custom3='';
$custom4='';
$custom5='';
if ($showcustom1) {
$getbgrow=getrowcolor();
eval("\$custom1 .= \"".gettemplate('index_custom1')."\";");
}
if ($showcustom2) {
$getbgrow=getrowcolor();
eval("\$custom2 .= \"".gettemplate('index_custom2')."\";");
}
if ($showcustom3) {
$getbgrow=getrowcolor();
eval("\$custom3 .= \"".gettemplate('index_custom3')."\";");
}
if ($showcustom4) {
$getbgrow=getrowcolor();
eval("\$custom4 .= \"".gettemplate('index_custom4')."\";");
}
if ($showcustom5) {
$getbgrow=getrowcolor();
eval("\$custom5 .= \"".gettemplate('index_custom5')."\";");
}


And create templates for each.

Then edit the 'index' template located under mYvBindex Templates and add $custom3, $custom4, $custom5 where ever you want the templates to be displayed.

ok i really dont understand this, in the INDEX template of myvbindex i dont see // custom boxes...

Tigga
06 Dec 2002, 20:34
That would be because it's in the myvbindex.php file, not a template. ;)

mv540
06 Dec 2002, 20:36
DAMIT!...lol

mv540
06 Dec 2002, 20:45
k found the php file, how do i rename it or open it to edit it..??

Tigga
06 Dec 2002, 20:50
What do you mean? You would open it or rename it with a text editor just like you would any other file.

mv540
06 Dec 2002, 20:59
i would just rename it like the config.php file..when i need to edit that i name it config.php.new correct?

mv540
06 Dec 2002, 21:00
its ok im gonna use the 2 custom index ones that are already in there...much easier..lol..thanks

Tony DiMera
07 Dec 2002, 01:03
How would you set up the cookie domain if the vbindex homepage is at www.yoursite.com and your board is it forums.yoursite.com Most likely .yoursite.com correct? What if later on I put in a second board(witha second license of course) at <u>subdomain.yoursite.com/forums/</u> and a vbindex at <u>subdomain.yoursite.com</u>, how would i set up the cookie domains for both boards and what would i put in place where it has a / for both boards?

350Chevy
07 Dec 2002, 02:08
Originally posted by mv540


ok i really dont understand this, in the INDEX template of myvbindex i dont see // custom boxes...

Sorry, guess I should've been a little more clear. ;)

350Chevy
07 Dec 2002, 07:39
Originally posted by PlurPlanet
That's not hard to do at all and won't affect the queries one way or another. Just open up your myvbindex.php file and look for:
$threads=$DB_site->query("SELECT thread.threadid,thread.title,thread.replycount,thread.postusername
You would just replace "thread.postusername" at the end of that with "thread.lastposter". Then you would want to edit your index_threadbit template and replace this:

by <a href="$bburl/member.php?s=$session[sessionhash]&action=getinfo&userid=$thread[postuserid]">$thread[postusername]</a>

with this:

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

Since I have the last user who posted would it be hard to also slow the last date and time posted instead of the date and time the thread started? :D

Tigga
07 Dec 2002, 18:03
Tony - I would think that the cookie domain should still be set to .yoursite.com, but I don't know that much about the way cookies and subdomains work. You may want to search vb.com or here for something like "cookie domian subdomain" and you can probably find a better answer.

350Chevy - I knew I should have mentioned how to do that too since it makes more sense to do it that way... All you'd do is look for this line in the threads section:
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'.

350Chevy
07 Dec 2002, 21:07
LOL.. I was looking and looking and knew it was something simple. I can't believe I passed that up. Thanks once again. You da man!

And I'd have to say that this one is 10x's better than ANY other portal Pay or Free! It looks nice, runs nice, and has all the options needed!

Tony DiMera
07 Dec 2002, 23:48
Thanks Plur

Graphics
13 Dec 2002, 14:53
i got the error Warning: ChDir: No such file or directory (errno 2) in /home/virtual/site139/fst/home/da_real_rpg/public_html/myvbindex.php on line 21
but i entered my forum

could you please say exactly what i should put there is my url to my forum is host.com/~[myname]/forum

please help

Tigga
13 Dec 2002, 21:45
Thanks for the compliment Chevy. Glad you're enjoying the hack. :)

Graphics - The path should be /home/virtual/site139/fst/home/da_real_rpg/public_html/forum

RavenBeauty
14 Dec 2002, 03:52
I marvel at how hateful some reply's are to certain things that are done here. How are people to learn if they don't experiament? Is there not a nice way to ask a question or make a comment without being catty and insulting? I don't care what you think someone has done right or wrong, there is no cause for what I see on these helps and how to boards.

PlurPlanet I do need some help of course.. I wonder what would happen if I EVER did any of these hacks right the first time :(

I have done all but do not see this new created page anywhere... it has not replaced my home page nor has it replaced the index of the forum which Im glad of..but anyway can you help me? or somebody ... anybody?

and guys.. lifes too short to be anything but kind to one another :)

350Chevy
14 Dec 2002, 05:40
Originally posted by RavenBeauty
I marvel at how hateful some reply's are to certain things that are done here. How are people to learn if they don't experiament? Is there not a nice way to ask a question or make a comment without being catty and insulting? I don't care what you think someone has done right or wrong, there is no cause for what I see on these helps and how to boards.

Who's being rude? :)

Originally posted by RavenBeauty
I have done all but do not see this new created page anywhere... it has not replaced my home page nor has it replaced the index of the forum which Im glad of..but anyway can you help me? or somebody ... anybody?

You need to upload the myvbindex.php to the root of your site. Once you have it working the way you wish just rename your old index to something like index.bak and rename myvbindex.php to index.php. :)

350Chevy
14 Dec 2002, 05:42
Plur,

Seems a friend of mine has stumbled upon something. He's testing this mod out on his site and he noticed if you place text in the search box then press search it just takes you to the search.php page without atcually performing the search.

I've tested this on my site with the same results but see nothing wrong with the code. Are we missing something? TIA

:D

350Chevy
14 Dec 2002, 07:25
Nevermind.

Thanks to EvilLS1, he found the fix.

You need to add this

<input type="hidden" name="action" value="simplesearch">

in the index_search template. :)

Graphics
14 Dec 2002, 11:48
THX ALLOT

EvilLS1
14 Dec 2002, 12:31
Nice one. Thanks. :) *installed*

Tigga
14 Dec 2002, 21:56
RavenBeauty - If you followed the instructions and uploaded the myvbindex.php file to your server then you should be able to go to http://yoursite.com/myvbindex.php. Then after you've done that and made sure it's working correctly you would just rename it to index.php and it would of course become your homepage. If you're still having problems let me know exactly what you did and I'll help you out.

Chevy - Thanks for pointing that out. I don't use the search box on my site at the moment, so I never noticed it wasn't working correctly. I'll be sure to include that with the release of v2.1, which I will try to go ahead and finish this week.

Oh, and if anyone else has some suggestions for some new features to be added please let me know. There will be a couple of new features with 2.1, but I'm just about out of ideas. ;)

BaBa2002
15 Dec 2002, 10:49
damm i'm having probs whit installing the weather_install file
when i'm trying to run it it says "The page cannot be displayed"

anybody? who canb help my

EvilLS1
15 Dec 2002, 12:11
Originally posted by PlurPlanet


Oh, and if anyone else has some suggestions for some new features to be added please let me know. There will be a couple of new features with 2.1, but I'm just about out of ideas. ;)

The top posters would definitely be a good add-on for the next release..

I also added a forum info box that shows total members, threads, posts, newest member, etc. (screen-shot attached).. And in the UserCP box, I added "new posts since last visit".. Those might be a good addition aswell.

Tigga
15 Dec 2002, 19:46
BaBa - Did you upload the weather_install.php file to forums/admin folder and are you sure you're going to the right url?

EvilS1 - Not a bad idea at all. I'll most likely include that and maybe a few other stats with 2.1. Thanks for the feedback. :)

Tony DiMera
15 Dec 2002, 23:14
Originally posted by BaBa2002
damm i'm having probs whit installing the weather_install file
when i'm trying to run it it says "The page cannot be displayed"

anybody? who canb help my

I have the exact same problem. I had to put it in manually.

Tigga
16 Dec 2002, 21:57
Well I'm just about done with v2.1. I still have to set all the new options so they can be turned on/off via the Admin CP, update the install file, create an update file so 2.0 users can easilly update, test and try to break it a little more, and then try the upgrade process with my personal site. After all that, it'll be ready for release here. :)

Here are some of the new features...

Forum Stats (Total members, threads, posts, newest member, top poster, and today's birthdays).
Today's event's under the calender.
Ability to allow or disable smilies and your signature per post in the news section (just as you would with a regular post).
Ability to allow or disable vB image code and HTML on your forums homepage (not affecting the settings for the forum).
Number of times a news post has been viewed and the news posts rating (if any).
Users Avatar with news posts (with no extra queries ;)).
"Show Printable Version" & "Send to Friend" features for news posts.
Fixed a couple of small bugs and cleaned the coding up a bit more.


I think that's everything I've added for now, so if anyone has any suggestions for some more features please let me know. :)

Goldknight
17 Dec 2002, 07:55
PlurPlanet, very nice! =D You seem cover everything what I need. Thanks!

350Chevy
17 Dec 2002, 08:00
Great work.. I have a suggestion.. :)

In the Poll section how about adding the option to display how many posts are in the topic.

For example it now says: "╗Discuss This Poll"

How about changing that to "╗Discuss This Poll (xx Replies)"

or adding "╗This Poll Has XX Replies" under it. Just a thought.

I know it's kinda nit-pickie but heck you've got everything else practically in there already! :D

Tigga
17 Dec 2002, 15:27
Thanks Goldknight. :)

I just added the number of replies for the poll Chevy. Thanks for the idea.
It looks like I may be able to release the new version this evening. New installations are working perfectly, so now I just have to finish up the upgrade script and upgrade my own site. :)
And I'm still open for more suggestions if anyone has any other ideas before I release this.

Dean C
17 Dec 2002, 15:35
This hack is pretty awesome :)

- miSt

mv540
18 Dec 2002, 17:07
this hack is great indeed, but im having trouble at the moment, moved everything to a new server and now i get this error..do i have to reinstall or something,???

some help would be greatly appreciated...

thanks


Database error in vBulletin 2.2.9:

Invalid SQL: SELECT thread.threadid,thread.title,thread.replycount,thread.postusername,thread.postus erid,thread.dateline as dateline,post.pagetext,thread.iconid,post.postid FROM thread LEFT JOIN post USING (threadid) LEFT JOIN user ON (user.userid=thread.postuserid) 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: Wednesday 18th of December 2002 12:59:14 PM
Script: http://xxxxxxxx.com/forums/index.php
Referer:

Tigga
18 Dec 2002, 17:11
It looks like your News Forum ID isn't set in the Admin CP. If it is already set, try saving the options so that will kind of kick it in. If that doesn't work let me know.

And thanks Mist. :D

mv540
18 Dec 2002, 17:20
Originally posted by PlurPlanet
It looks like your News Forum ID isn't set in the Admin CP. If it is already set, try saving the options so that will kind of kick it in. If that doesn't work let me know.

And thanks Mist. :D

thx for the quick reply, i checked my admin cp and it looks like my news is there. Im not quite clear on what to look for from here

Tigga
18 Dec 2002, 17:26
Even if the News Forum ID is set, you may still have to save the options to make sure it's "kicked in". Did you try saving the options?

mv540
18 Dec 2002, 17:35
im not sure im understanding you sorry, im fairly new at this where do i look to see if this info you said is saved?

Tigga
18 Dec 2002, 17:41
It's cool... I'll give you better instructions. :)
Just go in your Admin CP and click on vBulletin Options in the top left frame. Then Scroll all the way to the bottom where you mYvBindex options are. If you haven't already, check to see that the News Forum ID there is set. Then just click on "Save Changes" at the bottom of that page. Sometimes, even if everything appears to be set there, it won't kick in until you hit the Save button.

mv540
18 Dec 2002, 17:44
ill try that..brb...lol