Previous Thread
Next Thread
Print Thread
Rating: 41
Page 3 of 11 1 2 3 4 5 10 11
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
After reading this a second time I'm not sure I understood the first time. I'll look the random profile box over again.

Sponsored Links
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
In reply to:


Nope wont work... still reading the code correctly... The code is wrong is the problem... Also the code for viewing the profile's pic is wrong... it has the /pals/palimage/ hard coded in... my images are in /images...





Your right, I forgot to replace $config['phpurl'] with the pals variable. Will make sure I didn't over look this next version. Thanks.

Joined: Aug 2001
Posts: 128
Member
Member
Joined: Aug 2001
Posts: 128
See I am not 100% insane :-P

Joined: Apr 2001
Posts: 45
Power User
Power User
Offline
Joined: Apr 2001
Posts: 45
Hi Dave, and thanks so much for this wonderful add-on. I don't know when I've seen something coded so clearly and to be so user friendly for a PHP amature as myself.
I am testing this with 6.0 br2 on a test forum and when I add the top rated threads include, my speed drops to - well- it doesn't go anywhere... Ocassionally timing out. Of course as this is an upgraded Db from 5.5.1 and a test forum, I have selected a random 10 or so threads and 'rated' them for the test. All other threads remain untouched - were talking thousands here. Is it possible that it's the quantity of threads this include is querying or could it be the default value on this field that might be upsetting the query causing the speed issue?

Awesome work Dave. Thanks again.

Gord

Joined: Mar 2002
Posts: 147
Member
Member
Offline
Joined: Mar 2002
Posts: 147
Can you provide a link to your install?
Thanks.

Sponsored Links
Joined: Apr 2001
Posts: 45
Power User
Power User
Offline
Joined: Apr 2001
Posts: 45
Sorry, No, I cannot post a link publicly.

Gord

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Hi ghubbell,

I'm glad you like the add-on

I am not sure why there would be such a drop as I thought the actual query was straight forward. I'll take a look over the code though and see what I can do to make it better. The "Top 10 Rated" (or how ever many your displaying) posts are pulled from the last 24 hours. How many posts are made in that period?

Is anyone else having simular problems with the Top Rated box also? If so is it with an upgraded 5.5.1 > 6.0 database or a fresh 6.0 database? Please let me know. Thanks.

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Ok let us see if this helps,

In the topratedpostspal.php script find this line:

AND B_RealRating != ''

and remove it.

The script should still work correctly. Sometimes I find myself defining things that probably didn't have to be just so I know that it's fetching what I want.

Let me know if that helped. Thanks.

Joined: Apr 2001
Posts: 45
Power User
Power User
Offline
Joined: Apr 2001
Posts: 45
Thanks very much Dave,
I'll give it a go and report back for all. Shouldn't be long...

Gord

Joined: Apr 2001
Posts: 45
Power User
Power User
Offline
Joined: Apr 2001
Posts: 45
Sorry for the delay...I'm on a two way satellite and I think 'Mars Attacked'
I 'rated' another dozen or so threads and for some reason was only receiving 1 top result - and I had at least 5 different ratings. $totalratedposts = 10; should have been fine? Perhaps it was just being grumpy.

Now, removing the line you recommended (I believe correctly) leaves:

SELECT B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Main,B_Replies,B_Counter,B_Board,B_Rates,B_RealRating
FROM w3t_Posts
WHERE B_Number = B_Main
AND B_Last_Post > '$date'
$boardquery
ORDER BY B_RealRating DESC
LIMIT $totalratedposts

and I now have 10 threads listed, however 8 of them are not rated and they're the 'sticky' ones that have been hit thousands of times. Weird.

Where do I go from here Dave?

Thanks in advance,

Gord

Sponsored Links
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Yeah I wanted to get back here and say don't remove that line... lol I must have been sleeping when I was thinking about it.

That line needs to be there but I have modified it to this one:

AND B_RealRating > 0


The query is about as simple as it can be I really am not sure what I could do to make it shorter. Is this still slowing things down for you?

Please let me know. Thanks.

Joined: Apr 2001
Posts: 45
Power User
Power User
Offline
Joined: Apr 2001
Posts: 45
Thanks Dave,
I'll give it a go today and post back.

Gord

Joined: Mar 2002
Posts: 147
Member
Member
Offline
Joined: Mar 2002
Posts: 147
Notice: Undefined variable: theme in C:\Inetpub\wwwroot\UnnecessaryRoughness\ubbt\pals\configpal.php on line 141

Notice: Undefined variable: theme in C:\Inetpub\wwwroot\UnnecessaryRoughness\ubbt\pals\configpal.php on line 143

Notice: Undefined variable: friendname in C:\Inetpub\wwwroot\UnnecessaryRoughness\ubbt\pals\configpal.php on line 387

Notice: Undefined variable: sendername in C:\Inetpub\wwwroot\UnnecessaryRoughness\ubbt\pals\configpal.php on line 387

Notice: Undefined variable: config in C:\Inetpub\wwwroot\UnnecessaryRoughness\ubbt\pals\configpal.php on line 387

Notice: Undefined variable: yourmessage in C:\Inetpub\wwwroot\UnnecessaryRoughness\ubbt\pals\configpal.php on line 387



I upgraded my php to 4.2.1 and this started happening.

If I recall correctly the $theme variable was an issue in previous releases and I thought it was fixed.

IIS 5.0
PHP 4.2.1
zlib enabled
UBBT 6.0 br2

Joined: Mar 2002
Posts: 147
Member
Member
Offline
Joined: Mar 2002
Posts: 147
I resolved my errors.

I overwrote the php.ini during the install and left out the option not to show notices.

[:"red"] Line 200: [/]
error_reporting = E_ALL & ~E_NOTICE



Joined: May 2002
Posts: 12
Newbie
Newbie
Offline
Joined: May 2002
Posts: 12
So, I've added this to my forum. Great work!!

But I cannot seem to be able to configure the news / spcial announcements up on the index.php

Here is what I set in configpal.php -

// Set this to the board's key word. (blanks will not be displayed)
$postdisplay[0] = "New Look";
$postdisplay[1] = "PICTORIAL :";
$postdisplay[2] = "Monthly Status Bulletin";

// Set this to the maximum number of posts to display.
$postmax[0] = 1;
$postmax[1] = 2;
$postmax[2] = 3;

// Ignore sticky posts? 1=yes 0=no
$ignoresticky[0] = 0;
$ignoresticky[1] = 0;
$ignoresticky[2] = 0;

-- So according to my understanding, all posts from visible forums containing the words 'New Look','PICTORIAL :' and 'Monthly Status Bulletin' should be visible on the front page. But it's not

On querying mysql> select Bo_Keyword from w3t_Boards;

I get -

+------------+
| Bo_Keyword |
+------------+
| UBB1 |
| UBB10 |
| UBB11 |
| UBB13 |
| UBB14 |
| UBB15 |
| UBB16 |
| UBB18 |
+------------+

Don't know what else shall be set. Also if this is possible -

I always want post from the user 'admin' during last 1 week to be flashed in the 'news' / 'announcement' section - sticky or non-sticky

Any advice highly solicited.

TIA,

nm

P.S. I run UBB 6 (br 2) where I've imported a UBB Classic 6.2 board a while back. URL is http://www.myhotboard.com

Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
Hi,

Welcome to threadsdev.

I think you will find the keyword section needs to be:-

$postdisplay[0] = "ubb1";
$postdisplay[1] = "ubb10";
$postdisplay[2] = "ubb11";

Try this, I think it will work...

Regards,

Ian


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Joined: May 2002
Posts: 12
Newbie
Newbie
Offline
Joined: May 2002
Posts: 12
But then what posts will be selected as 'announcements'? I mean I am just merely supplying the 'UBB*', so how does IIP select posts as 'announcements' or 'news'?

Or do I have to keep all such threads to a forum titled like 'Announcements' and supply the keyword for that to IIP?


Please excuse me if I sound terribly confused.

Thanks for your help. I am going to try this now.

~nm

Last edited by hotbabes; 05/15/2002 2:19 PM.
Joined: Mar 2002
Posts: 147
Member
Member
Offline
Joined: Mar 2002
Posts: 147
You will need to select the Board that is just used for Announcments and allow only specific users to post to that board.

Joined: Apr 2001
Posts: 45
Power User
Power User
Offline
Joined: Apr 2001
Posts: 45
Hi Dave, sorry for the delay to reply (see my location)

Scott is doing a wonderful job tuning the queries so it would probably be best to visit and review his comments:

https://ubbdev.com/threads/php/...view=expanded&sb=5&o=&fpart=

Everything seems to be improving!

Gord

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Hi ghubbell

Thanks for the post. I have replied. (I didn't quite understand things but this is not unusual for me LoL)

Hopefully I'll get to understanding it and be able to incorporate the changes to speed things up. I don't want to risk breaking information displays based on group access though.

Joined: Oct 2000
Posts: 2,667
Veteran
Veteran
Offline
Joined: Oct 2000
Posts: 2,667
and don't forget the language files (If you already made them please send me a copy so I can't start translating )


Do you believe in love at first sight,
or should I walk by again?
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
I have the language file finished with the exception of a couple variables I can't yet transfer untill I have a login script created for use by IIP. The login script threads uses has options with values based on languages and this throws things off for the login box in IIP.

I think I'll push 5.0 out here shortly and then start working on the templated version. (this will be taking me some time)

I'll post the language file as soon as possible.

Joined: Aug 1999
Posts: 184
Member
Member
Offline
Joined: Aug 1999
Posts: 184
I am just wondering if it is possible to link another page that is not related to the forums in hte menu and still keep the menu open? The new page would then open on the right like is done with the attachments, etc...


Silly ricer.. Wings are for airplanes!
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
That shouldn't be to hard to accomplish.

The link needs to have the the variable "paction" set to what ever you want. To load a page called "MYPAGE.php" you could add a link in the menu pal like such:

code:

if ($paction == "MYPAGE") {
echo "$rowStart<b>My Page</b>$palResize$rowEnd";
}
else {
echo "$rowStart<a href="$palurl?Cat=$Cat&paction=MYPAGE$insertSize">My Page</a>$rowEnd";
}



Then in the index.php script, just below this:

// create wide right column
echo "$widerightcolstart";


Add this:

code:

if ($paction == "MYPAGE") {
include "path/to/mypage.php";
}




And that should do it.


I do intend on making the addition of other pages easier at some point. Hope this helps for now.

Joined: May 2001
Posts: 33
Rio Offline
Junior Member
Junior Member
Offline
Joined: May 2001
Posts: 33
I tried everything to get this to work but I keep getting a blank page when I run index.php. Can someone please tell me what I am doing wrong?

Thanks Rio

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Check all of the variables in the configpal.php script. Make sure all paths and urls are correct. This is usually the cause of the blank screens.

Let me know how it goes.. Also, if you could post an URL it would help if I could see it too.

Joined: May 2001
Posts: 33
Rio Offline
Junior Member
Junior Member
Offline
Joined: May 2001
Posts: 33

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Yep that's very blank screen... lol

Look over the URL variables and the PATH variables in configpal.php and see if there are any mistakes. I can't say for sure what else could be causing this.

Joined: May 2001
Posts: 33
Rio Offline
Junior Member
Junior Member
Offline
Joined: May 2001
Posts: 33
I just sent you a pm with the config variables could you look at it for me please?

Joined: May 2001
Posts: 33
Rio Offline
Junior Member
Junior Member
Offline
Joined: May 2001
Posts: 33
Now I am getting this

Index page closed for maintenance.
Please check back later. Thanks.

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
At the bottom of the configpal.php script you will see something that looks like this:

// ------------ END OF CONFIGURE ----------------- //

// are we configured? (NOTE!!! Set this to 1 when your done setting
// the variables. Untill then the index page displays a box informing visitors
// that the page is down for maintenance. )
$configured = 0;



Change $configured = 0; to $configured = 1;
once you have the script completely configured.

I'm working on getting this set up via a control panel as you are not the first to have these problems.

Joined: May 2001
Posts: 33
Rio Offline
Junior Member
Junior Member
Offline
Joined: May 2001
Posts: 33
I am such a blind dumb azz I hate it when I over look stuff. Its work now. Thanks for your help Dave

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
LoL your welcome

And I've been down that road myself before...

Joined: May 2001
Posts: 33
Rio Offline
Junior Member
Junior Member
Offline
Joined: May 2001
Posts: 33
Everything works fine except that it won't stay logged in at the entrance... Any Ideas?

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Set your cookies site wide. The variable is for the cookie path located in the config.inc.php script in the threads package. Make sure you have it set to "/".

Joined: May 2001
Posts: 33
Rio Offline
Junior Member
Junior Member
Offline
Joined: May 2001
Posts: 33
Thank you sir

Joined: Feb 2002
Posts: 11
Newbie
Newbie
Offline
Joined: Feb 2002
Posts: 11
Hi,
Integrated Index Page does't run with 6 br5 ?
http://www.host2008.com/
Where is my error ?

Regards

D

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Hi delfo2000

Yes it should run just fine with 6.0 BR5

I'm not sure what could be causing those errors. Check and make sure you have all of the variables set in the configpal.php file. I can't tell for sure what the error would be from looking at the page though. One thing is to make sure you specified the board keywords and not their title when filling in the variables.

Joined: Feb 2002
Posts: 11
Newbie
Newbie
Offline
Joined: Feb 2002
Posts: 11
Hi,
this is my configpal:

<?
// VERSION
$palVersion = "4.3";

// ---------------- PATH VARIABLES ---------------- //

// full path to the pal directory (no trailing slash / )
$fullPath2pals = "/var/www/html/pals";

// path to threads directory from index.php
$index2threadsPath = "";

// path to threads directory from pals directory (no trailing slash / )
$pals2threadsPath = ".";

// url to index.php (no trailing slash / )
$url2indexpal = "http://www.host2008.com";

// url to pal directory (no trailing slash / )
$url2palsDirectory = "http://www.host2008.com/pals";

// full path to the palimages directory (no trailing slash / )
$fullPath2palimages = "/var/www/html/pals/palimages";

// url to palimages directory (no trailing slash / )
$url2palimagesDirectory = "http://www.host2008.com/pals/palimages";

// ------------------------------------------------ //

I'm using RH 7.2 and I can understand my error.
Any idea ??

D

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
That all looks to be ok.

I have a question though, have you created boards on this site? I went to the Main Index and I did not see any boards listed. If there are none then this may be the problem because there is nothing to select from?

Page 3 of 11 1 2 3 4 5 10 11

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)