![]() |
Okay i thought i'd start a new thread ... how did tech talk do the today's active topics code hack to include it on a non vb page..
i have added most of the includes that tech talk released on my test index page at now all i am missing are 1. active topics includes 2. displaying total threads 3. displaying total posts 4. displaying total registered members 5. displaying most recent registered member any help is appreciated :D [Edited by eva2000 on 01-04-2001 at 12:43 PM] |
[Edited by eva2000 on 01-04-2001 at 12:44 PM]
|
Ok ill try to help a little here. To show the newest registered member make a new file called "newestmember.inc.php" and place the code below into it.
See it in action here: http://www.extremeforums.com/include...member.inc.php Here is the code: Code:
<?php For the total number of members make a file called "totalmembers.inc.php" and place the following code into it: Code:
<?php http://www.extremeforums.com/include...embers.inc.php ------------------------------------------------------------ For the total posts make a new file called "totalposts.inc.php" and include the following: Code:
<?php http://www.extremeforums.com/include/totalposts.inc.php ------------------------------------------------------------ For the total threads make a file called "totalthreads.inc.php" and include the following: Code:
<?php http://www.extremeforums.com/include...hreads.inc.php ------------------------------------------------------------ Hope this helps ;) If you have any questions just let me know ~Chris |
Oh and BTW....your active topics looks nice ;) Mine will show you any threads that were posted to today. If you want it here is the code:
Code:
<?php |
thanks techtalk it works perfectly and can be seen at http://www.animeboards.net :D
the only thing i had to do was add the chdir before require command in each php file you had above Code:
<?php |
Glad you got it working ;) Strange about the change dir thingy...I never had to do that before :confused:
~Chris |
*** dances around *** thanks again tech talk... just amazing what you can do with vbulletin :D
|
whoops... forgot one slight addition... how do you display the Active users ?
just the top part which says Currently there are x members and x guests on the forums. |
nice hack, but i want to exclude the private forums (TechTalk's active hack).
is this possible? |
that's what i did i excluded forums by not specifying them
i.e. for me Code:
<? forumid='1' or forumid='2' etc... it tells which forums to show... so leaving it out, hides the private forums :) |
thanks, works perfect!
|
well you have to thank shri, tech talk and jimf :D
|
oh yeah 1 last thing is i need is the code to make the ctive users show up on a non vb page
something like Currently there are x members and x guests on the forums. |
Hi eva2000,
I tried your .txt examples but they were redirecting to your main forums page. I need Code help on the following stuff please? 1. Show Most Active Posters (number of active posters as variable) example: Most Active Posters POster 1 (number of posts) Poster 2 (number of posts) etc. 2. Show Last ($UNANSWERED TOPICS) 3. Show Forum Categories and Forums in Directory Tree Form example: Category 1 Forum 1 (number of posts) Forum 2 (number of posts) Forum 3 (number of posts) Category 2 Forum 4 (number of posts) Thanks and you guys rock!!! |
okay here it is thanks to techtalk for these :D
1. http://animeboards.net/topposters.txt 2. http://animeboards.net/deadtopics.txt 3. don't know about that one but you could add the forum display one that techtalk did http://animeboards.net/forumlist.txt several times and select which forums you want each php include to display in the above example Code:
AND forumid != 21 AND forumid != 22 etc you could do 2 includes for 2 categories and specify only the forums within that category |
For the active Forums hack above you could change the SQL statement from
Code:
$querylatest="select * from thread where forumid='1' or Code:
$querylatest="select * from thread where forumid in Code:
$querylatest="select * from thread where select private != '1' from forum and thread.forumid=forum.forumid Now I just have to learn PHP so I can understand what the rest of it does. :) [Edited by wluke on 08-30-2000 at 01:04 AM] |
Hi everyone.
This is my first post ever, and I'm very new to PHP and MySQL, though I'm good enough to be dangerous. That's why I need your help. Let's say I have a forum in which only I post news items for my site. No postings by public allowed, though I don't know if that will make a difference to the hack. I see the code you guys have been slinging around here, but cannot make enough progress in hacking it. I want to take the very last item that's posted in my "private" forum for site news, and pull it into my homepage, with the headline and post time above it. Possible? I know so. How, though? Please help. |
Quote:
so does the below Code:
$querylatest="select * from thread where select private != '1' from forum and thread.forumid=forum.forumid |
I need the active topics .txt for the 12 last active topics you have down the middle of your page Eva2000
Please. Thanks. |
somehow all those links i did above are valid ? strange oh well
here's the last 12 active threads in the middle column Code:
<? Code:
$querylatest="select * from thread where select private != '1' from forum and thread.forumid=forum.forumid |
I just want to add that I have not tested it yet and it is based entirely on my knowledge of SQL because I don't have any PHP knowledge yet but I am learning because I have a few hacks of my own in mind including integration with an PHP driven IRC chat client.
I will be willing to work with you though on making queries more efficient if you want. |
I tried it and it did not work. I might have done it wrong though.
These additions seem to slow down MySQL a good amount. DO you find that to be the case? http://www.paintballcity.com/index.php [Edited by VirtueTech on 09-08-2000 at 11:27 AM] |
Ok let me work on it some more and actually test it because there has to be a better way than listing every forum you want to show, which would require changing the hack if you expand.
|
Quote:
i do notice my front page slows down with the hacks added to the front page... |
Just all the add ons in general...that kind of sucks. Cause they look cool
Maybe there is a way to lower the calls to mysql |
yeah it does look cool... i have been thinking of changing my frontpage again and maybe remove some of those hacks...
|
I think the slowness is related to MySQL.
If it supported stored procedures than most of these hacks could be run as native SQL code and that would decrease response time plus make upgrades easier. |
Eva-
How did you tie all these pieces together to get to what you have on your front page? Did you put each section of code inside it's own .php file and include them into a frame set? Thanks, -Chris |
yeah i put each hack into a php file and used a php include command to add them to the index page
|
Can someone help me create this hack and modify so that will list the top 25 posters that have visited within the last (XX) days? I have some very active posters that haven't visited in months, and I would like to have them not show up in this.
|
anybody knows how to make top posters in specific forum?
|
Quote:
Canb I include these hacks (and by the way, I need them :)) into an html page or do they have to be on a php page? if they have to be in a php page. Any help would be great. |
Yes they need to be in a PHP page, if your server doesn't parse .html for PHP code. Just copy any of the code snippets here that you need, and save them as something.php. Then your name your portal page index.php and inside there just use the include command to call something.php. It should look something like this:
Code:
<html> -Chris |
Quote:
Another point where I'm lost is: I don't have a template in my list (from the admin control panel) for Index.php Should I be using the Forumhome.php file for this? Also, I copied the code for the topposts list that I want (one that I see on Eva2000's site and on Paintball.com) and created a template called Toppost. I then tried to insert the include command you gave me in the Forumhome file, but nothing showed up. I changed the "something.php" to toppost.php of course, but nothing, not even a bit of code showing through. I really like the paintball home page, as it has everything I want to include in mine. But...... |
Thanks for your help.
I was thinking in totally the wrong terms. I started looking around my server at the php files and realized what I have to do. I was thinking I had to do this through the template files that are in the admin section. My bad. All straight now. :) |
Quote:
|
Any way to display members currently on the boards?
|
Hi! Can me anybody pleas send the "Active topics" File? Thank you!
Tho |
Quote:
If I run the above script I get this error Warning: 0 is not a MySQL result index in /www/tuffsports/forum/test1.php3 on line 15 I keep will keep playing around but any guidence is appreciated. |
Ok - dumb me
didnt have the require command in for some reason |
All times are GMT. The time now is 04:41 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|