php_library_path . "database_library.php"; include $xerte_toolkits_site->php_library_path . "url_library.php"; function normal_date($string){ $temp = explode("-", $string); return $temp[2] . "/" . $temp[1] . "/" . $temp[0]; } $database_id = database_connect("rss page.php database connect success worked","rss failed"); $query_modifier = "rss"; $action_modifder = "play"; if(isset($_GET['export'])){ $query_modifier = "export"; $action_modifder = "export"; } if(!isset($_GET['username'])){ /* * Change this to reflect site settings */ echo "" . $xerte_toolkits_site->site_url . "A feed containing all the public learning objects from " . $xerte_toolkits_site->name . "en-gb" . $xerte_toolkits_site->site_url . "website_code/images/xerteLogo.jpg" . $xerte_toolkits_site->site_url . ""; }else{ if(!$database_id){ die("Sorry, the system cannot connect to the database at present. The mysql error is " . mysql_error() ); } $temp_array = explode("_",mysql_real_escape_string($_GET['username'])); $query_created_by = "select login_id from " . $xerte_toolkits_site->database_table_prefix . "logindetails where (firstname=\"" . $temp_array[0] . "\" AND surname =\"" . $temp_array[1] . "\")"; $query_create = mysql_query($query_created_by); if(mysql_num_rows($query_create)==0){ header("HTTP/1.0 404 Not Found"); }else{ if(!isset($_GET['folder_name'])){ echo "" . $xerte_toolkits_site->site_url . "A feed containing all of " . $temp_array[0] . " " . $temp_array[1] . "'s public learning objects from the " . $xerte_toolkits_site->name . "en-gb" . $xerte_toolkits_site->site_url . "website_code/images/xerteLogo.jpg" . $xerte_toolkits_site->site_url . ""; }else{ echo "" . $xerte_toolkits_site->site_url . "A feed containing all of " . $temp_array[0] . " " . $temp_array[1] . "'s learning objects - " . str_replace("_"," ",$_GET['folder_name']) . " from the " . $xerte_toolkits_site->name . "'s siteen-gb" . $xerte_toolkits_site->site_url . "/website_code/images/xerteLogo.jpg" . $xerte_toolkits_site->site_url . ""; } $row_create = mysql_fetch_array($query_create); } } if(!isset($_GET['username'])){ $query = "select " . $xerte_toolkits_site->database_table_prefix . "templatedetails.template_id,creator_id,date_created,template_name,description from " . $xerte_toolkits_site->database_table_prefix . "templatedetails, " . $xerte_toolkits_site->database_table_prefix . "templatesyndication where " . $query_modifier . "=\"true\" and " . $xerte_toolkits_site->database_table_prefix . "templatedetails.template_id = " . $xerte_toolkits_site->database_table_prefix . "templatesyndication.template_id"; }else{ if(!isset($_GET['folder_name'])){ $query = "select " . $xerte_toolkits_site->database_table_prefix . "templatedetails.template_id,creator_id,date_created,template_name,description from " . $xerte_toolkits_site->database_table_prefix . "templatedetails, " . $xerte_toolkits_site->database_table_prefix . "templatesyndication where " . $query_modifier . "=\"true\" AND creator_id=\"" . $row_create['login_id'] . "\" and " . $xerte_toolkits_site->database_table_prefix . "templatedetails.template_id = " . $xerte_toolkits_site->database_table_prefix . "templatesyndication.template_id"; }else{ $query_folder = "select folder_id from " . $xerte_toolkits_site->database_table_prefix . "folderdetails where folder_name=\"" . str_replace("_", " ",mysql_real_escape_string($_GET['folder_name'])) . "\""; $query_folder_response = mysql_query($query_folder); $row_folder = mysql_fetch_array($query_folder_response); $query = "select * from " . $xerte_toolkits_site->database_table_prefix . "templaterights, " . $xerte_toolkits_site->database_table_prefix . "templatedetails, " . $xerte_toolkits_site->database_table_prefix . "templatesyndication where folder = \"" . $row_folder['folder_id'] . "\" and " . $xerte_toolkits_site->database_table_prefix . "templaterights.template_id = " . $xerte_toolkits_site->database_table_prefix . "templatedetails.template_id and " . $xerte_toolkits_site->database_table_prefix . "templatesyndication.template_id = " . $xerte_toolkits_site->database_table_prefix . "templaterights.template_id and rss = \"true\""; //$query = "select " . $xerte_toolkits_site->database_table_prefix . "templatedetails.template_id,creator_id,template_name,folder,description from " . $xerte_toolkits_site->database_table_prefix . "templatedetails," . $xerte_toolkits_site->database_table_prefix . "templaterights," . $xerte_toolkits_site->database_table_prefix . "templatesyndication where " . $query_modifier . "=\"true\" AND creator_id=\"" . $row_create['login_id'] . "\" and " . $xerte_toolkits_site->database_table_prefix . "templaterights.template_id = " . $xerte_toolkits_site->database_table_prefix . "templatedetails.template_id and folder_id=\"" . $row_folder['folder_id'] . "\""; } } $query_response = mysql_query($query); //echo $query . "
"; while($row = mysql_fetch_array($query_response)){ if(!isset($_GET['username'])){ $query_creator = "select firstname,surname from " . $xerte_toolkits_site->database_table_prefix . "logindetails where login_id=\"" . $row['creator_id'] . "\""; $query_creator_response = mysql_query($query_creator); $row_creator = mysql_fetch_array($query_creator_response); $user = $row_creator['firstname'] . " " . $row_creator['surname']; }else{ $user = $temp_array[0] . " " . $temp_array[1]; } if(isset($_GET['export'])){ echo "site_url . url_return("export", $row['template_id']) . "]]>
" . str_replace("_"," ",$row['template_name']) . " was developed by " . $user . "]]>" . date('D, d M Y', strtotime($row['date_created'])) . " 12:00:00 GMTsite_url . url_return("export", $row['template_id']) . "]]>"; }else{ echo "site_url . url_return("play", $row['template_id']) . "]]>
" . str_replace("_"," ",$row['template_name']) . " was developed by " . $user . "]]>" . date('D, d M Y', strtotime($row['date_created'])) . " 12:00:00 GMTsite_url . url_return("play", $row['template_id']) . "]]>"; } } echo ""; mysql_close($database_id); ?>