session_start(); include "shared.php"; initialise(); ?> insertHead("CRUMB - View Discussion List Item Detail"); ?>
Latest | Archive | Search Discussion global $useText; $months=array("January","February","March","April","May","June","July","August","September","October","November","December"); $m=date("m"); $y=date("y"); $raw="20$y$m"; //$m="03"; $A1="ind$y$m"; $m=$months[$m-1]; ?> global $useText; //A2=ind0412&L=new-media-curating&T=0&F=&S=&P=451 $A2=$_GET[A2]; $L=$_GET[L]; $T=$_GET[T]; $F=$_GET[F]; $S=$_GET[S]; $P=$_GET[P]; if ($_GET['useArch']<>1){ getText("http://www.jiscmail.ac.uk/cgi-bin/webadmin?A2=$A2&L=$L&T=$T&F=$F&S=$S&P=$P"); }else{ global $useText; $itemID=$_GET[archID]; //echo("using archive"); selectDatabase('jiscDiscussionDatabase'); $SQL="SELECT * FROM jiscDiscussionTable WHERE id=$itemID"; //echo($SQL); $result=mysql_query($SQL); $thisRow=mysql_fetch_row($result); $useText=URLDecode($thisRow[5]); echo($useText); $transcript=$useText; } //echo($useText); //getText("http://www.jiscmail.ac.uk/cgi-bin/webadmin?A2=ind04&L=new-media-curating&P=R18324&I=-1");//root level (months/years) //first just get the month urls //getText("http://www.jiscmail.ac.uk/cgi-bin/webadmin?A1=ind0412&L=new-media-curating"); //next level - read month //getText("http://www.jiscmail.ac.uk/cgi-bin/webadmin?A2=ind0105&L=new-media-curating&P=R1416&I=-1"); //last level - get a message //getText("http://www.jiscmail.ac.uk/cgi-bin/webadmin?A2=ind0105&L=new-media-curating&P=R1416&I=-1"); //last level - get a message //$spacer=urlencode("a"); //from here $stpos=strpos ($useText,''); //echo("stpos=$stpos "); $stage1=substr($useText, $stpos); //echo($stage1); $stpos2=strpos ($stage1,''); $stage2=substr($stage1, 0,$stpos2); $stage3=str_replace("".chr(13) ," ", $stage2); $stage4=str_replace("" ,"", $stage3); $stage5=str_replace("" ,"", $stage4); global $stage6, $storeDat; $stage6=str_replace(chr(13)," ", $stage5); $storeDat=urlEncode($stage6); // now substitute $rootIndex $detailIndex"); selectDatabase('jiscDiscussionDatabase'); //mysql_query("DROP TABLE jiscDiscussionTable"); $SQL="CREATE TABLE jiscDiscussionTable (id INT AUTO_INCREMENT PRIMARY KEY, rootIndex TEXT, detailIndex TEXT, ord TEXT, dStamp TEXT, content TEXT, visible TEXT)"; if (mysql_query($SQL)){ //echo "success in table creation."; } else { //echo "no table created this time around - process failed because item already exists."; } $SQL="SELECT COUNT(*) FROM jiscDiscussionTable WHERE detailIndex='$detailIndex'"; $result=mysql_query($SQL); $thisRow=mysql_fetch_row($result); if ($thisRow[0]<1){ $SQL="INSERT INTO jiscDiscussionTable (rootIndex, detailIndex, ord, dStamp, content, visible) VALUES ('$rootIndex','$detailIndex','$ordinal','$dStamp','$storeDat','1')"; //$SQL="INSERT INTO jiscDiscussionTable (rootIndex, detailIndex, ord, dStamp, content, visible) VALUES ('1','1','1','1','1','1')"; //echo($SQL); $RESULT=mysql_query($SQL); //echo("result = $RESULT"); } $stage7=str_replace("[log in to unmask]>","",$stage7); $stage7=str_Replace("<[log in to unmask]>","",$stage7); $stage7=str_Replace("<"); global $scanText; $scanText=$stage7; $alltext=$scanText; ?> |