URGENT: Robb, Admin or Arianna Please Read and Respond

[Lib]

Robb or Arianna,

Although recently trashed with vulgarities and obscenities, the original forum is a great treasure house of information, a grand library that should not be lost.

There are links, articles, and most of all thoughtful essays and debates that deserve to be preserved where they can be accessed all the time. Countless hours of research and reflection have gone into many of the original pieces that have been posted here. I turn to the archives often when needing to find a particularly cogent reference or argument.

Please, I plead with you, do not flush this grand trove into the bit bucket. It is much too important and useful for that. Preserve it please, where it can be accessed by all.

If the disgusting posts by our spammer(s) are too much to keep on hand, I think you could dump the last couple of weeks and take care of that.

As a long time participant in this terrific public forum, I will be very grateful for your willingness to retain archives of the previous wide open forum and make them available read only. Many, many people will agree with me.

Thank you sincerely.

Best regards,

Lib

[Bluecoller-eddie]

I concur :!:

----- bluecoller -- the grumpy old kraut ---- :evil:

[maria]

YES!!!! please please please!!! :D :D

[Mark]

Add me to the list of those who wish to see the old forum archived for reference.

Mark

[Kim]

Yes, Robb. Archiving the old Forum would be great.

Sometimes it's really nice to be able to search for past quotes that someone wrote and throw them in their face :wink:

[Whitey]

Definitely, archive the old forum(s); all knowledge is memory. Is that conservative, or what? 8)

[donni]

i think that's a good idea too.-donni

[illcommandante]

Would be a tragedy of considerable proportions. :(

[illcommandante]

would be a national disaster. There, that's better.

[Alexx]

I concur. I didn't know what this topic post was about prior to starting another topic about this very issue.

http://www.ariannaonline.com/phpBB2/viewtopic.php?t=376

[Bertrand]

If possible, I am also in favor of keeping the archive for reference.

No doubt, there are quite a number of valuable posts among the trash, profane language and spamming.

It may also be relevant to keep some documentation about abusive posters like Kehvan, Michael Feinberg, etc., who acted out abusively and out of control... in a free, unmoderated, and conveniently accessible forum and used it as a platform to spread hatred using profane and ugly language even against Arianna, who graciously provided the forum as a service to promote dialogue and debate of the important issues of our times.

[cricket]

Robb, rather than delete such garbage...you might move those offensive posts to a "garbage pail" part of the forum..so that if someone wanted to actual pick through such garbage they could. I don't know..just a thought.

[Michael Feinberg]

Bertrand (aka Jeremy the spammer) and Cricket want the Feinberg's post to be separated from the others? Coool. I think I have a best selling book there and it would help if somebody edited it out of the morass of liberal inanity for me. Of course, you would also have to include my brilliant responses to threads posted by other writers, so it would take a lot of work, but I'll cite you in the acknowledgement section.


I think it's a great idea, Bert and Cricket. I would agree to pay some small remuneration to anyone who does it.

[cricket]

Finey, I don't recall referring to you but if the shoe fits wear it. Garbage in...garbage in the garbage pail. Then you can click on that part of the forum and read yourself anytime you wish. Kehvan and Iron Man might en"join" you what do ya think?

[kehvan]

Robb,
Here's a little something that might put you in the right direction:
[code:1:0559567847]<?php
/* Connecting, selecting database */
$link = mysql_connect("mysql_host", "mysql_user", "mysql_password") or die("Could not connect : " . mysql_error());
print "Connected successfully";
mysql_select_db("my_database") or die("Could not select database");


/* Performing SQL query */
$query = "SELECT * FROM my_table";
$result = mysql_query($query) or die("Query failed : " . mysql_error());


/* Open file for writing */
$path_name = "file path/name";
$out_file = fopen($path_name, "w") or die("Could not open file");


/* Printing results in HTML */
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
foreach ($line as $col_value)
{
fwrite($out_file, $col_value);
}
}


/* Closing file */
fclose($out_file);


/* Free resultset */
mysql_free_result($result);


/* Closing connection */
mysql_close($link);
?>[/code:1:0559567847]

[admin]

Robb,
Here's a little something that might put you in the right direction:

Thanks. I'm looking for something that will break each posting into a flat file and also create an index of all those flat files at the same time. Then I would place a search engine on top of all that.

-r

[kehvan]

Robb,
Here's a little something that might put you in the right direction:

Thanks. I'm looking for something that will break each posting into a flat file and also create an index of all those flat files at the same time. Then I would place a search engine on top of all that.

-r
Cool - a few small modifications and that script will put things in their own file. If you want I can rewrite it to do just that.

[admin]

Robb,
Here's a little something that might put you in the right direction:

Thanks. I'm looking for something that will break each posting into a flat file and also create an index of all those flat files at the same time. Then I would place a search engine on top of all that.

-r
Cool - a few small modifications and that script will put things in their own file. If you want I can rewrite it to do just that.

That would be great. Here is a link to a the dd for the old forum:

http://www.ariannaonline.com/sandbox/old_forum_dd.pdf

-r

[kehvan]

Here are some assumptions I'm going to operate on...correct me if I'm wrong.
a separate set of files for the columnsforum table and another set of files for the columnsforum_bodies table 1 record per file import all fields fields are | (pipe character) delimited
I may be missing something or are going a bit overboard. I could combine these two tables into one super table (a bit slower to work with). I can write this to do anything you need.

Just what do you need chief?

[admin]

Here are some assumptions I'm going to operate on...correct me if I'm wrong.
a separate set of files for the columnsforum table and another set of files for the columnsforum_bodies table 1 record per file import all fields fields are | (pipe character) delimited
I may be missing something or are going a bit overboard. I could combine these two tables into one super table (a bit slower to work with). I can write this to do anything you need.

Just what do you need chief?

Actually, the two tables work together to create the 'forum.' The first, columnsforum, contains all the poster data and stuff like that, and the second, columnsforum_bodies, contains the actual message.

The scrip should read each posting from columnsforum, pull the corresponding message from the columnsforum_bodies and then write that message to a flat file. Then add that message title and date, author, etc to a master index file. Maybe we should also break out each month as it's own index file so that the indexes don't become 50 pages long.

-r

[Peter Angelo]

I saved all my stuff on disc anyway, but saving it it only makes sense. Can't you just delete the idiot's putrid bile?