[SM-Discuss] www.sourcemage.org

David Kowis dkowis at shlrm.org
Mon Mar 17 11:24:28 EDT 2008


Quoting David Kowis <dkowis at shlrm.org>:

> Jaka Kranjc wrote:
>> On Sunday 16 of March 2008 22:06:43 David Kowis wrote:
>>>>> You have until Sunday, June 15th 2008 to move your stuff.
>>>> Can you get us a list of all the content in it? Something like a linked
>>>> site map, so we can put it in the wiki and systematically check if
>>>> anything has yet to be transfered.
>>> I cannot. I don't know how to provide something like that for drupal. If
>>> someone can provide me the code or a module that will do it, I'll
>>> consider trying to get that in there.
>>>
>>> However, I'm not sure that there's that much useful information in
>>> there. Most of our useful developer information is on the wiki. it might
>>> be better not to transfer the old, decrepit data from there, but only
>>> the useful nuggets. Unfortunately it will require sifting through lots
>>> of useless data :(
>>>
>>> There's no good solution to this, so I'm open to options as long as they
>>> don't require a great deal of effort to enact.
>> Drupal has the pages stored in a database? Even if it is not in   
>> plaintext in some dir, the content of the pages or the titles   
>> should be easily queried out. We don't need much more than that.
>>
>> Another option would be to give some people write permissions on   
>> drupal and then they can delete pages as they find/compare them.
>>
>>
>
> it won't be that simple, Drupal's database isn't as straight-forward as that:
>
> Story pages:
> mysql> select count(*) from node where type = "story";
> +----------+
> | count(*) |
> +----------+
> |      405 |
> +----------+
>
> Forum nodes:
> mysql> select count(*) from node where type = "forum";
> +----------+
> | count(*) |
> +----------+
> |     1090 |
> +----------+
>
> Here's the comments that exist on the forum:
> mysql> select count(*) from comments where nid in (select nid from node
> where type = "forum");
> +----------+
> | count(*) |
> +----------+
> |     4441 |
> +----------+
>
> That's 1090 topics with 4441 comments. I can produce a url list that
> contains all 1090 topics. Then you can delete them from that list as
> they're deemed unuseful. Will that be sufficient?
>
> I'm not willing to turn on anything in drupal, as it's insecure...
>
> I've attached a textfile of all the topics that are the forum headers.
> Feel free to organize some effort to make it happen :)
> A git repo would probably work best so that you don't have mid-air
> collisions. A wiki page would probably work too.
>

Here's the list of all the story pages.

Have fun :D

-- 
David Kowis
==================================================================
|       www.ronpaul2008.com      |    www.sourcemage.org         |
|      Ron Paul for President!   |   SourceMage GNU/Linux        |
==================================================================
-------------- next part --------------
A non-text attachment was scrubbed...
Name: storyNodes
Type: application/octet-stream
Size: 15497 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/sm-discuss/attachments/20080317/9e88decd/attachment-0001.obj 


More information about the SM-Discuss mailing list