[geeklog-devel] An observation as a semi-developer/user

Sat Feb 22 09:47:15 EST 2003

Here is a small start. I created a new category and then used this sql to
add one story and there comments to the forum. For multiple stories a xref
table would need to be created to get all the ids correct. Since the
comments and forum use a parent child model it isn't all that hard(easier
than converting vbulletin).

Obviously this is a mass import and no long term hack.

Insert into gl_forum_topic( uid, subject, comment,forum,date,name )
SELECT s.uid, s.title, CONCAT(s.introtext, " ", s.bodytext),2,s.date,
u.username
FROM gl_stories s, gl_users u
WHERE s.uid=u.uid
and s.tid = "Help";

INSERT INTO gl_forum_topic(subject, comment, date, uid, id, pid, name,
forum)
SELECT c.title, c.comment, c.date, c.uid, c.cid, c.pid, u.username, 2
FROM gl_comments c, gl_users u, gl_stories s
where c.uid=u.uid
and s.sid = c.sid
and s.tid="Help";

Dwight
----- Original Message -----
From: "Blaine Lang" <langmail at sympatico.ca>
To: <geeklog-devel at lists.geeklog.net>
Sent: Friday, February 21, 2003 11:18 PM
Subject: Re: [geeklog-devel] An observation as a semi-developer/user

> Totally agree!
>
> Do we have a forum that we can use?
>
> How about a FAQ Plugin to organize the most recent questions as well that
is
> integrated into the GL search?
> I am just putting the finishing touches on this one - see my site
> (www.langfamily.ca) for a demo. It's 99% done just testing now.
>
> I know one reason we were holding back was that we would need to convert
all
> the existing stories to forum topics.
> I could write such a tool - but do we really need to wait.
>
> Blaine
> ----- Original Message -----
> From: "Jason Whittenburg" <me at jasonwhittenburg.com>
> To: <geeklog-devel at lists.geeklog.net>
> Sent: Saturday, February 22, 2003 12:15 AM
> Subject: Re: [geeklog-devel] An observation as a semi-developer/user
>
>
> > I wouldn't kill him...  I do agree...
> >
> > I never liked the fact the the geeklog.net (aka geeklog.sourceforge.net)
> > was posting peoples problems will Geeklog.  A forum would be better for
> > that.
> >
> > To say again in PHP terms "+1"
> >
> > -Jason
> >
> >
> > Simon Lord said:
> > > Secret is out Tony, should we kill Rob?
> > >
> > > On Friday, February 21, 2003, at 09:36 PM, Rob Griffiths wrote:
> > >
> > >> Greeting, GL Dev Team...
> > >>
> > >> Something's been bugging me about www.geeklog.net for a while, but I
> > >> couln't quite figure out what it was.  Tonight, though, I believe
I've
> > >>  identified what the source of my bother was:  I do not think
> > >> www.geeklog.net is sending a good message about the program to any
> > >> casual browsers of the site -- that is, potential users of Geeklog.
> > >> Most days, 90% of the content of the site is about bugs, glitches,
> > >> install problems, basic questions, etc.
> > >>
> > >> I would think a better use for the main site would be to restrict it
> > >> to news of Geeklog, new hacks, official bug fixes from the Dev Team
> > >> members only, PR announcing sites that have been Geeked, etc.  With
> > >> the Forum 2.0 plug-in available, support questions would be better
> > >> served in that environment, would they not?
> > >>
> > >> It's almost like we've got this amazing car, but when we talk to
> > >> people about it, all we tell them about is that it's sometimes hard
to
> > >>  start, it may break down if it's not treated right, and to get the
> > >> most out of it, you really need to RTFM.  Shouldn't we be publicizing
> > >> what Geeklog >can< do instead of focusing on what troubles people are
> > >> having with it?
> > >>
> > >> I took a quick look at the home pages for phpnuke, mambo, phpslash,
> > >> phpwebsite, webgenerator-x, drupal, e107, LDU, and ovidentia (thanks
> > >> to opensourcecms.com :-).  Of those, only one or two have any sort of
> > >> troubleshooting stuff on their homepages at all (phpwebsite had some
> > >> random support questions and postnuke had a section called
"Support").
> > >>
> > >>  The main focus of the pages is not help or questions, but rather,
> > >> announcements and information.  Geeklog is the only CMS homepage that
> > >> I visited that seemed to emphasize bugs and help directly on the
> > >> homepage...
> > >>
> > >> Not that anyone asked me, but ... ... I would think a "staticpage"
> > >> homepage with a full center pane of info about Geeklog -- what it is,
> > >> how it works, top 10 sites its installed on, newest "Geekings," a
link
> > >>  for the support forum, a link to a sample site (opensourcecms.org),
> > >> etc. would be a much better "selling" tool than the current
collection
> > >>  of help requests and "failed to RTFM" bug reports.
> > >>
> > >> <asbestos>
> > >>   Flame away....
> > >> </asbestos>
> > >>
> > >> -rob.
> > >>
> > >> _______________________________________________
> > >> geeklog-devel mailing list
> > >> geeklog-devel at lists.geeklog.net
> > >> http://lists.geeklog.net/listinfo/geeklog-devel
> > >>
> > >>
> > > Sincerely,
> > > Simon
> > >
> > > _______________________________________________
> > > geeklog-devel mailing list
> > > geeklog-devel at lists.geeklog.net
> > > http://lists.geeklog.net/listinfo/geeklog-devel
> >
> >
> > --
> > Jason Whittenburg, Sr
> > Web: http://jasonwhittenburg.com
> > AIM: jwhitten00
> > ICQ: 9012034
> > MSN: jason at whittenburgs.com
> >
> >
> > _______________________________________________
> > geeklog-devel mailing list
> > geeklog-devel at lists.geeklog.net
> > http://lists.geeklog.net/listinfo/geeklog-devel
>
> _______________________________________________
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net
> http://lists.geeklog.net/listinfo/geeklog-devel
>
>
>