vb.org Archive
Page 10 of 55 « First 89 10 111220 Last »
Show 40 post(s) from this thread on one page

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

Kamui Shirou 01-01-2003 10:23 AM
hum i nearly forgot to thank ya PurePlanet.
Thanx ^^

Wells 01-01-2003 10:25 AM
So,
no, with Poll URL no problems. I set up it to http://www.mysite.net/forum/forumdis...?s=&forumid=21 as you wish. Maby in some file....

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

Database error in vBulletin 2.2.9:

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

mysql error number: 1064

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



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

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

Tigga 01-01-2003 10:29 AM
That's the problem. The polls forum id is supposed to be set to just the forum id, not the whole url. Try changing it to 21. ;)

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

Wells 01-01-2003 10:37 AM
I try to set Show Poll?
to no and go to next error:

Database error in vBulletin 2.2.9:

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

mysql error number: 1064

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

Wells 01-01-2003 10:41 AM
WOW-WOW-WOW
many thanks, I change and everything working. INCREDIBLE!

Thanx a lot.

Happy New.

Wells 01-01-2003 11:00 AM
And one more question...
how can I change language in your hack?
Because all in english...

Tigga 01-01-2003 11:23 AM
The only way to change the language would be to edit the templates. I think there's only 2 places any words are coded in the file. Those would be:

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

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

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

Open your admin/functions.php file and look for:
PHP Code:
// ###################### Weather Functions #######################
function convert_temp($number,$tpc) {
$number *= 1;
if ($tpc == 0) {
$number = (5/9) * ($number-32);
$number = round($number);
return "$number?C";
} else {
return "$number?F";
}
} 
Replace that with:
PHP Code:
// ###################### Weather Functions #######################
function convert_temp($number,$tpc) {
$number *= 1;
if ($tpc == 0) {
$number = (5/9) * ($number-32);
$number = round($number);
return "$number";
} else {
return "$number";
}
} 
Then download the attached zip file, upload the weather.php file to your forums directory, then change the index_weather_main and index_weather templates to the ones in the zip. Let me know if it works. :)

DarkDraco07 01-01-2003 03:02 PM
*continues to wait for the mini-hack* :p

jarvis 01-01-2003 04:57 PM
ding ding ding ding ding.... looks like we have a winner!! :D

The weather bug appears to have been squashed!!

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

Thanks again!

ChrisLohman 01-01-2003 08:20 PM
This is an excellent hack. Thank you very much not only for the hack, but for the clean install, the clean layout using templates, and the overall high quality of this.

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

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

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

Tony DiMera 01-01-2003 10:36 PM
Ok, I asked about running large scripts and this is what they said:

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

We do not have size-restricted limits.

Happy Holidays!

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

Regards,

John Dritsas"

Tigga 01-01-2003 11:27 PM
DarkDraco - What mini-hack?

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

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

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

ChrisLohman 01-02-2003 01:25 AM
Thanks for your response PlurPlanet. This hack is absolutely perfect for my needs. I just turned it on at http://www.sonsofvalor.com/

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

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

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

Database error in vBulletin 2.2.9:

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

mysql error number: 1064

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

Tigga 01-03-2003 06:43 AM
DarkDraco07 - I'm not sure how hard that's going to be to do... I'll look into it when I get a chance.

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

Zalbard 01-03-2003 01:42 PM
My URL to the forums are set too: http://www.zeldaxtreme.com/extremegames/forums

Is this problem fixable!?!

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

Zalbard 01-03-2003 02:31 PM
I disabled that, so now the error only reads:

Database error in vBulletin 2.2.9:

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

mysql error number: 1064

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

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

Tigga 01-03-2003 02:33 PM
You need to set your Poll Forum ID, or just turn off the poll option.

Zalbard 01-03-2003 02:40 PM
Well, I disabled it and I am still getting the same error, and it's still asking for a strange url. O_O Here is the error again in case it did change at all:

Database error in vBulletin 2.2.9:

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

mysql error number: 1064

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

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

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

Zalbard 01-04-2003 12:24 AM
How do you know what the ID number is for the forum?

EvilLS1 01-04-2003 04:53 AM
Quote:
Originally posted by Zalbard
How do you know what the ID number is for the forum?
Go to that forum, then look at the URL at the top of your browser. The last number(s) in the URL is the forum ID.

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

vietres 01-04-2003 05:38 AM
good

[hhhh] 01-04-2003 06:23 AM
Hello PlurPlanet ! i want get multi forum on myvbindex page . Please help me

jarvis 01-04-2003 06:37 PM
Hey Plur,

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

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

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

Thanks again!! :banana:

jeffj 01-04-2003 10:42 PM
weather bug.....same things happens on my site... I'm running 2.5 and just nuked the weather off the page until I have some time to debig the code...

EvilLS1 01-05-2003 12:08 AM
The weather fix works perfectly for me. Thanks Plur!

Tigga 01-05-2003 12:42 AM
hhhh - Do you mean you want to have multiple news forums?

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

jeffj - Did you try the fix i posted here? https://vborg.vbsupport.ru/showthrea...976#post336976

Evils1 - Glad to hear it. :)

Tony DiMera 01-05-2003 01:22 AM
Quote:
Originally posted by PlurPlanet
Tony - I'm not sure why the install script wouldn't work then. I'm sure there are many other possible reasons, just not sure exactly which one it would be. Didn't you already run the queries manually and get it working ok though? [/B]
Yeah I ran the queries manually and they work, i'm just curious on why the weather_install script won't run.

Brahm 01-05-2003 01:48 AM
Plurplanet, thanks for the hack, it looks great on my site:

ashkins.net

Brahm 01-05-2003 08:29 PM
I just installed "Shoutbox" from TWTCommish and I was wondering if there is an easy way to include shoutbox on the MyVBindex page. I have seen this on other web pages.

Tigga 01-05-2003 09:44 PM
If you'll look at the first post in this thread, there's a mini-hack that MartynJ put together which integrates the shoutbox w/ myvbindex.

Brahm 01-05-2003 10:53 PM
Quote:
If you'll look at the first post in this thread, there's a mini-hack that MartynJ put together which integrates the shoutbox w/ myvbindex.
I tried that one and the query killed my vbulletin. It was written for a different Shoutbox. MartinJ even admits he doesn't know which one in the notes.

Tigga 01-05-2003 11:11 PM
Ahhh... I'll look at TWTCommish's shoutbox when I get the time and see what would need to be done to add it to the index page. I wouldn't imagine it would be very hard.

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

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

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

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

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

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

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

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

ANY help would be appreciated. :( Thanks!

Mandi


All times are GMT. The time now is 11:34 AM.
Page 10 of 55 « First 89 10 111220 Last »
Show 40 post(s) from this thread on one page

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

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02084 seconds
  • Memory Usage 1,857KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete