function createTitleLink(titleStr) {
titleStr = replaceNoCase(titleStr,"&","and","all"); //replace &
titleStr = replaceNoCase(titleStr,"&","and","all"); //replace &
titleStr = replaceNoCase(titleStr,"'","","all"); //remove apostrophe
titleStr = reReplaceNoCase(trim(titleStr),"[^a-zA-Z]","-","ALL");
titleStr = reReplaceNoCase(titleStr,"[\-\-]+","-","all");
if(len(titleStr) gt 1) {
//Remove trailing dashes
if(right(titleStr,1) eq "-") {
titleStr = left(titleStr,len(titleStr) - 1);
}
if(left(titleStr,1) eq "-") {
titleStr = right(titleStr,len(titleStr) - 1);
}
}
return lcase(titleStr);
}
select distinct posts.postID, title, postDate, postPassword, sticky from posts, postCatJoin where posts.postID = postCatJoin.postID and active = 1 order by sticky, postDate desc, posts.postID desc
Elysium Productions Blog
http://#cgi.SERVER_NAME#/
Elysium Productions Blog
en-us
select postPartID, body, filename, filetype from postParts where postID = #postID#
-
#XmlFormat(title)#
http://#cgi.SERVER_NAME#/?postID=#postID#&#createTitleLink(title)#
http://#cgi.SERVER_NAME#/?postID=#postID#&#createTitleLink(title)#
#DateFormat(postDate, "ddd, dd mmm yyyy")# #TimeFormat(postDate, "HH:mm:ss")# GMT
This post requires a password. Please login here.#Replace(Replace(Replace(Replace(Replace(body, chr(147), '"', "all"), chr(148), '"', "all"), chr(145), "'", "all"), chr(146), "'", "all"), chr(10), "
", "all")#
download #filename#
]]>