Active topics ? how did you do it tech talk ?

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


[Edited by eva2000 on 01-04-2001 at 12:43 PM]

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.

Originally posted by VirtueTech
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]

do you mean wluke's alterations slow it down or just the last 12 active hacks as is, slows down mysql ?

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.