" .intval($_GET['newpost']). " ORDER BY postid, posted") or die(mysql_error()); $last_post_query = mysql_query("SELECT postid, belongs FROM forum_posts WHERE belongs = " .intval($_GET['threadID']). " ORDER BY postid DESC LIMIT 1") or exit(mysql_error()); $last_posts = mysql_fetch_assoc($last_post_query); $thread_info = mysql_query("SELECT p.posted AS created, p.title, p.belongs AS threadid, h.category AS father, r.rubrik AS grandpa FROM forum_posts AS p JOIN forum_threads AS t ON t.id = p.belongs JOIN forum_heads AS h ON t.belongs = h.catid JOIN forum_rubriker AS r ON r.titlesid = h.belongs WHERE p.belongs = ". intval($_GET['threadID']) ." AND p.first = 1") or exit(mysql_error()); function protect($what){ $what = htmlspecialchars(htmlspecialchars($what)); return $what; } if(mysql_num_rows($q) > 0 || mysql_num_rows($thread_info) > 0){ while($r = mysql_fetch_assoc($q)){ $extra_lank = ''; echo "
\"wally\"
Medlem sedan: ". $r['joined']. "

Antal inlägg: ". $r['num_posts'] ."
Ort: ". $r['city']. "

Antal skrivna guider: 4
\n" .htmlspecialchars($r['title']). "
Skrivet: " .$r['posted']. "
" .htmlspecialchars($r['content']). "

"; } //stänger > 0 }else echo "Tomtar!"; } //stänger första else echo "Tomt!"; ?> /* Adressen till XML-dokumentet där vi hämtar inläggen */ //var adress = "http://www.guida.nu/nytt/visa_alla/ajax.php?threadID="; //var bild_url = "http://www.guida.nu/nytt/visa_alla/"; var bild_url = ""; var adress = "ajax_ready.php?threadID="; var xmlResponse2, xmlRoot2; var lastpost; var notify = document.getElementById("notify"); /* the XMLHTTP object för att samarbeta med servern */ var xmlHttp = createXmlHttpRequestObject(); function createXmlHttpRequestObject() { //Håller XMLHTTPRequest object var xmlHttp; try { xmlHttp = new XMLHttpRequest(); } catch(e) { //anta IE6 eller äldre var XmlHttpVersions = new Array("MSXML2.XMLHTTP.6.0", "MSXML2.XMLHTTP.5.0", "MSXML2.XMLHTTP.4.0", "MSXML2.XMLHTTP.3.0", "MSXML2.XMLHTTP", "Microsoft.XMLHTTP"); //prova varje XmlHttp version tills en funkar for (var i = 0; i last_post){ try { handleServerResponse(); } catch(e) { alert(e.name + " / " + e.message); } }else if(lastpost == last_post){ notify.innerHTML = "Inga nya inlägg!"; } } else alert("Error fetching the data:\n" + xmlHttp.statusText + "\n" + xmlHttp.status); }else if(xmlHttp.readyState == 1 || xmlHttp.readyState == 2 || xmlHttp.readyState == 3) { target.innerHTML = "\"Laddar\""; } } function handleServerResponse(){ var html = ""; var xmlResponse = xmlHttp.responseText; html = xmlResponse; var target = document.getElementById("ajax_forum_start"); target.innerHTML = html; //Gör så att det senaste inlägget är lastpost last_post = lastpost; } function addpost(postid){ if(!xmlHttp) alert("No XMLHttpRequest object created! Please update to a more modern browser like firefox.\n You can get it at www.getfirefox.com"); else{ xmlHttp.open("GET", "makepost.php?threadID=" + encodeURIComponent(postid)); xmlHttp.onreadystatechange = handlemakenewpost; xmlHttp.send(null); } } function handlemakenewpost(){ if(xmlHttp.readyState == 4){ if(xmlHttp.status == 200){ if(xmlHttp.responseText == "Ok") alert("Ditt inlägg skapades!\nProva nu att hämta nya inlägg. Det gör du längst ner!"); else alert("Fel"); }else alert("Something got wrong!\n" + xmlHttp.statusText); } }