I'm sure I can set it up so you would be able to specify a particular group to pull from. I'm plugging away on IIP 5.0 and will add that in when I get to those boxes.
As for a quick fix... hmmmm... let me look...
For the random profile find this query:
$query = " SELECT U_Picture,U_Bio,U_Name,U_Username,U_Location,U_Hobbies,U_PicWidth,U_PicHeight FROM w3t_Users WHERE U_Number >= 2 LIMIT $RandNum,1 ";
and change it to this:
$query = " SELECT U_Picture,U_Bio,U_Name,U_Username,U_Location,U_Hobbies,U_PicWidth,U_PicHeight FROM w3t_Users WHERE U_Number >= 2 AND U_Groups LIKE '%-3-%' LIMIT $RandNum,1 ";
For top posters find this:
$query = " SELECT U_Username,U_Totalposts FROM w3t_Users WHERE U_Number >= 2 ORDER BY U_Totalposts DESC $limit ";
and change it to this:
$query = " SELECT U_Username,U_Totalposts FROM w3t_Users WHERE U_Number >= 2 AND U_Groups LIKE '%-3-%' ORDER BY U_Totalposts DESC $limit ";
There is a few more things I would like to do with that box. I took the lesser server load route but will be looking into building on what's there at some point.
I think I would have to add an additional query to the boxes to avoid banned users. It would be easier if the w3t_Users table had a field that could be used to signify that the user is banned. This would be a bit more involved as far as setting up.
Would it be just as difficult to specify the group to pull from? We have banned users in a group by themselves, so we limit what they can see/do. We pull them out of the group 3 for members.
The change you posted for the top posters is perfect and working.
I had thought about just taking out their post numbers, but when they left they emailed as many members as they could with a huge list of allegations saying how deceptive we were -- basically targeting our members who weren't computer savvy enough to know they were full of it -- so we feel like we're walking on eggshells on some issues. Changing post counts wouldn't look cool to some people. I know, I know, it's our site. But it's a commercial site, so we try to keep them happy.
I haven't tried the other one yet, but will in just a few. (I have a teething baby who is grumpier than crap right now. )
Thank you! I was doing it similar, but I didn't have the "%" in there (I didn't think about it, even though I always use it in mysql ), and I had an = in there somewhere. I basically have no clue what I'm doing. Now if we were talking about probate estates or corporation law, that would be another thing!
Thanks Dave! I had just tried to login to my boards from work and discovered I was unable from the entrance page. This is very timely since I have had users that were unable to login and I assumed they had cookie issues.
Dave, thanks for doing this and offering it. Forgive me, but I'm too lazy to go through the zillions of postings to see if you attached a more recent version therein.
I'm assuming the attachment to this thread starter (47069-IIP.4.3.zip) has not dynamically updated as you've tweaked....if that's correct, where does one go to find the latest? I don't see it on the "V6 Finished Modifications" board.
I don't think there is a 'latest' but there are a couple fixes for issues and ubbt ubgrades posted throughout this thread as well as setup and speed issue discussions. I would recommend reading through it all and taking what you need for your site.
Also, there is reported to be a new 5.0 version coming out soon, so you might want to wait for that. This 4.3 with the fixes works great
ok, thanks for taking time to reply. I'll gladly de-laze myself and hunt through. I just didn't want to undertake that if there was a more direct way to grab the latest which I hadn't fathomed!
I'm still working on 5.0, which is being converted over for template/language file/control panel setup. Right now I am pushing 16 hour days to get a project done by this coming Monday. Today I cut it short to 14 hours and had enough motivation to turn the computer on when I got home. LoL
I know that your forums are huge, with 300,000 postings if I recall correctly. A site such as that will be best served by 5.0 do to the caching abilities it will offer with the information being displayed. As it stands, there are at least 4 pal boxes that will query your them 300,000 posts and this will take time. I'm going to put together an archive system that will move older posts out of the w3t_Posts table into an archive table to help speed things up also. The index page drawing from 20,000 most recent posts will be much more quicker than drawing from all 300,000 of them.
Once Monday comes and goes I'll be able to breath easier and will have some time to spend on IIP 5.0
thanks for the explanation (and the work you're putting in). If you ever need chow tips....
I'd not even considered that this add-on might add to wear/tear re: server assets. I'm already completely unconfident that ubbt will work at my site's scale, and am not real eager to add to the load. But at very least I'll definitely wait for the next version before even considering adding it on.
Hi there I have been using the IIP for a while, its great thank you. Just to point out something which threw me with this latest upgrade. If you happen to be pulling a post with javascript in it to the middle column (a window popup in my case), it can cause things to go a bit hey-wire in the right hand column, it was a bit of a cludge anyway - yes it did take me a while to figure out what had gone wrong
code: <form> <br><INPUT TYPE="button" VALUE="Talk to Sid" onClick="window.open('http://arachnid.mweb.co.za:2001/CHAT?template=use','Sid','toolbar=no,locationbar=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width=510,height=260,left=100,top=10'); win.focus();"> <br></form>
At the very end of your config file there is a variable you have to change to activate the index page. Its setup that way you can temporarily turn it off while making changes Hope that helps.
my homeurl is set correct, so I can't understand why it's sticking, /ubbthreads on the end, also when you use the recommend to a friend option via email it comes up with [] The host you are trying to send the input from is not a valid host.
Please use your back button to return to the previous page. but it doesn't on the rest of the site?????
Also I still don't understand what I need to do to get the news announcements up???
// Set this to the board's key word. (blanks will not be displayed) $postdisplay[0] = "newsnstuff"; $postdisplay[1] = "ramblings"; $postdisplay[2] = "imsolost";
// Set this to the maximum number of posts to display. $postmax[0] = 1; $postmax[1] = 3; $postmax[2] = 3;
// Set this to full for displaying all or a number for // X number of characters or none for none of course. $postbody[0] = "200"; $postbody[1] = "200"; $postbody[2] = "200";
// Include date posted? 1=yes 0=no $postdate[0] = 1; $postdate[1] = 1; $postdate[2] = 1;
// Include who posted it? 1=yes 0=no $postwho[0] = 1; $postwho[1] = 1; $postwho[2] = 1;
// Include posters picture? (if yes 'include who' must also be yes) 1=yes 0=no $includepic[0] = 0; $includepic[1] = 0; $includepic[2] = 0;
// Strip HTML? 1=yes 0=no // Disabling this for boards that do not allow html or mark up will help // speed things up here. (enabling on boards that do may break this display) $postcodestrip[0] = 1; $postcodestrip[1] = 1; $postcodestrip[2] = 1;
// What header style should be used for this board's articles? $phclass[0] = "tdheader"; $phclass[1] = "tdheader"; $phclass[2] = "tdheader";
// What table style should be used for this board's articles? $ptclass[0] = "lighttable"; $ptclass[1] = "lighttable"; $ptclass[2] = "lighttable";
// Display how many past news/reviews links? (0 disables) $postpastmax[0] = 5; $postpastmax[1] = 5; $postpastmax[2] = 5;
Thanks for the fix Dave. I'd been having the same problem with the "Call Us Home" function since my UBB.threads is in its own directory. Worked like a charm.
You will need to place your own board's key words in place of mine as your site does not have any boards using my key words.
// Set this to the board's key word. (blanks will not be displayed) $postdisplay[0] = "newsnstuff"; $postdisplay[1] = "ramblings"; $postdisplay[2] = "imsolost";
By the looks of it you have imported from .classic? Some of your boards key words are UBB1, UBB2 and so on.
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.