PDA

View Full Version : Can the previous forum be accessed?


Alexx
11-14-2003, 08:27 AM
I am wondering if the previous forum is gone for good.

I wrote a couple of Op ed pieces that I never saved anywhere else.

A searchable archive of the now defunct forum might be a nice touch.

cricket
11-14-2003, 08:43 AM
Alex...are you our pregnant woman and the cigarette Alex???? We have quoted you often. :D :P

Alexx
11-14-2003, 11:23 AM
Well, I'm not pregnant (it's a male thing). But I do still have the cigarette.

Alexx
11-14-2003, 09:13 PM
I tried to be responsible and thoughtful on the previous forum, as I'm sure many others did to.

I would like to think that some type of access to the previous forum would be possible out of respect to anyone who wrote in earnest. A search by name feature would be cool.

Any chance?

Am I the only one who cares?

Was the previous forum really just someone else's sandbox for everyone to take a dump in and then leave?

admin
11-15-2003, 12:32 AM
Hi All,

I'm trying to find a way to dump all the postings out in into flat text files. If anyone wants to help me (using php/perl and mysql) then I would gladly accept. :)

-r

kehvan
11-15-2003, 01:09 AM
Hi All,

I'm trying to find a way to dump all the postings out in into flat text files. If anyone wants to help me (using php/perl and mysql) then I would gladly accept. :)

-r
I actually think I have a script to do just that....what fields are we dealing with?

I'm trying to remember, I know there's the visible fields of Name, Subject and Message, but are there any others?

Alexx
11-15-2003, 02:35 PM
Hi All,

I'm trying to find a way to dump all the postings out in into flat text files. If anyone wants to help me (using php/perl and mysql) then I would gladly accept. :)

-r

Acknowledging this as an issue is amazingly generous of you. Besides help from competent computer types, can non computer software types actually help in some way?

Alexx
11-15-2003, 03:50 PM
And here is another topic post about this subject that I was unaware of when I started this topic post.

http://www.ariannaonline.com/phpBB2/viewtopic.php?p=3503#3503

kehvan
11-15-2003, 05:06 PM
Here's a little something that might put you in the right direction:
[code:1:38074ded28]<?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:38074ded28]

Peter Angelo
12-01-2003, 02:21 AM
I can access it now. Just click on the current events.