[thesite] AnswerThis

Warden, Matt mwarden at odyssey-design.com
Sun Jun 3 12:07:49 CDT 2001


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> From: "Michele Foster" <michele at wordpro.on.ca>
> Subject: Re: [thesite] AnswerThis
> 

...
> The category exists, what needs to be done?

UPDATE categorys SET active=1 where categoryid=10047;
commit;

fwiw, rudy passed on what he did to create the category here:

http://lists.evolt.org/thesitearchive/2001-April/001263.html

> Just add it to the top navigation and also to article submission
> page?   

If I understand things correctly, this should happen as soon as the
above query is run (aside from query caching issues)

> This
> category will only be available for admins to submit to (like FAQ)
> [for the time being]? 

Well, any user can submit an article in the FAQ category (don't think
we've had one yet), but admins aren't gonna approve it. IOW, the FAQ
category isn't hidden in the dropdown on the submission page for
non-admins.

...
> How complex would it be to have this category also viewable on the
> site page (i.e. going against the FAQ and Job categories)?  

They are displayed like that by default. Extra stuff would have to be
added into queries to get them to NOT show up on the frontpage, etc.

> Important question ... timing ... will you have a chance to modify
> the above queries to implement this category before you leave?

I can't. I don't have access to the live DB. Rudy does. Dan does.
Dean does. Hopefully Dex doesn't *duck*

...just kiddin' texy.

...
> I'll write the problem .. you can review it ... no worries, I won't
> respond. Do we want to go so far as to provide a sample DB
> structure?
...

I'll get back to you on this stuff offlist.

> If you don't have time to implement the above before you go ..

Will only take two seconds. If one of the people with access doesn't
speak up, I'll just hit dan to run the query. But...

I don't want an empty category on the site. If you want some help on
the "what is AnswerThis?" article, you got it. More offlist...

> I would like to reiterate that I really don't think Admin should be
> answering .... at least not right away.  Give other site/list
> members a chance first, if nothing, then Admin can respond if they
> wish.

I wouldn't respond until I came back and no one wrote a solution
about data shaping. For some reason, not too many people seem to know
about it, let alone use it. Seriously, I was quite shocked when you
showed me your code and it had data shaping SQL in it (you rule)!

> I'll write the announcement email to be sent to thelist as well ..
> perhaps even drop it in as an FAQ or just as an article.

Yeah, again, more offlist, but...
If you look WAYYYYYYY back at the first article in each category,
you'll see an explanation of the category from an admin. Probably
still a good idea to go that route, as it will serve as a placeholder
until we have the problem ready to go.



Zoooo000000oooooooommmmmmz0rz!




- --
mattwarden
mattwarden.com

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBOxpu8ngH0dUmEhrcEQKSGwCeOCUUXJeqPUKXm2vnRxrwFYxBNfUAoI0A
TBXqUpJSB4wgtFbPMpDKNBHV
=8pey
-----END PGP SIGNATURE-----






More information about the thesite mailing list