-
Logged In: YES
user_id=1088943
select count(ft.code)
from `forumtopics` as ft
left join `forummessages` as fm on fm.code = ft.code and
fm.userid = sInt('userid') and fm.time = ft.lastpost
where ft.lastpost < unix_timestamp() - 86400
group by fm.userid
Or do a left join with ft and fm being the main table.
2005-08-21 18:37:17 UTC by junkiez
-
Logged In: YES
user_id=1088943
1 = done
2 = will do
3 = will do
4 = 5 = 6 = no.
2005-08-21 18:32:24 UTC by junkiez
-
Logged In: YES
user_id=1088943
Partially done. When linkme.php is redone, just use out.php
for the link.
2005-08-21 18:29:30 UTC by junkiez
-
Logged In: YES
user_id=1088943
Fixed with the advanced link searching, added to topbar.
2005-08-21 18:26:56 UTC by junkiez
-
Logged In: YES
user_id=1088943
Private E-Mail address is used for this.
2005-08-21 18:25:49 UTC by junkiez
-
From: Bump | Posted: 6/14/2005 04:48:06 PM | Message Detail
Like "View My Posted Messages" in our options, but it
only shows what topics we created. We can sort them by
how many posts the topic got, when they were created,
simple stuff like that.
2005-08-03 08:55:49 UTC by sephiroth99999
-
The customizable homepage is a seriously awesome idea.
"Tagged Topics" would be a great option to add, because
usually people tag interesting topics before they
leave, and when they come back, they want to be able to
see them right away for any developments since they
left. junx or LG should be able to implement this
pretty easily - it isn't a major code overhaul or
anything, just another...
2005-08-01 01:59:13 UTC by shadow_tactics
-
For both board searches and link searches, this would
be SO HELPFUL. Since the search function is very strict
and searches for an exact match to what you put in,
even with a space, it would be great if after you
search, there is a box at the top of the results that
says "Search These Results" and you can input a second
word or phrase to narrow down your results.
-from sebulbaslovechild.
2005-06-30 07:57:14 UTC by sebulbaslovebug
-
Logged In: YES
user_id=1088943
Initial workings towards a better HTML layout.
2005-06-22 20:35:27 UTC by junkiez
-
Logged In: YES
user_id=1088943
Fixed in luelinx.
2005-06-22 20:25:52 UTC by junkiez
