quote:

---

This will be done step by step depending on if it takes an extra recordset or not, for default.asp / forum.asp / topic.asp you don't need an extra recordset so that was "easy".
Check out http://forum.snitz.com/beta/v33/

---

I was getting ready to post this information later tonight, but I'm not going to bother if you guys are going to take care of it in the next release.

Here's my notes on the modification to the topics.asp for taking care of querystrings and some other stuff. See if it's similiar.

(I had posted this back in December/January - previous post)

I can't wait to see the code for the next release.

The Writer Community

"Do not go where the path may lead, go instead where there is no path and leave a trail."
-Ralph Waldo Emerson

Edited by - work mule on 03 June 2001 21:57:49

quote:

---

I was getting ready to post this information later tonight, but I'm not going to bother if you guys are going to take care of it in the next release.

Here's my notes on the modification to the topics.asp for taking care of querystrings and some other stuff. See if it's similiar.

---

quote:

---

quote:

---

When will you guys eliminate the placing of the Forum Title & Topic Title in the querystring? (Don't say it can't be done.)

---

This will be done step by step depending on if it takes an extra recordset or not, for default.asp / forum.asp / topic.asp you don't need an extra recordset so that was "easy".
Check out http://forum.snitz.com/beta/v33/

Pierre

---

quote:

---

I thought the original purpose for doing this was to eliminate so many database queries and speed up the system... Is that no longer important? Just curious.

---

Oh, it's important to reduce the number of database queries. But the thing is that there is presently a query being made to the database for forum.asp and topic.asp to check the status level. So by expanding the query to include the title, you now have access to the title via that db call and don't need to pass it along. Besides the database, think of how many times that links were being built on a page and the titles had to be passed through a function to prep it for URL's which can now be eliminated.

The Writer Community

"Do not go where the path may lead, go instead where there is no path and leave a trail."
-Ralph Waldo Emerson

quote:

---

quote:

---

I thought the original purpose for doing this was to eliminate so many database queries and speed up the system... Is that no longer important? Just curious.

---

Oh, it's important to reduce the number of database queries. But the thing is that there is presently a query being made to the database for forum.asp and topic.asp to check the status level. So by expanding the query to include the title, you now have access to the title via that db call and don't need to pass it along. Besides the database, think of how many times that links were being built on a page and the titles had to be passed through a function to prep it for URL's which can now be eliminated.

---

quote:

---

One thing that still is the same is that pages like post.asp get called using all the info.

---

If you have a chance, I would look at that file too. I haven't looked through it extensively, but there's quite a few cases where a recordset is being created already, so you may not need to pass the information there either.

Actually, I know you don't need it! On my site I'm just passing the id's - no titles and everything gets populated just fine.

The only thing is that you may want to open the recordset sooner to get the information for the thread at the top - where the folder icons are - unless you just make that generic text up there.

BTW, when you guys get ready to convert to CSS - let me know, I have a Perl script which will parse through all the files and convert them to support CSS.


The Writer Community

"Do not go where the path may lead, go instead where there is no path and leave a trail."
-Ralph Waldo Emerson

Edited by - work mule on 05 June 2001 10:43:49

function getForumName(fForum_ID)
	'## Forum_SQL
	strSql = "SELECT " & strTablePrefix & "FORUM.F_SUBJECT "
	strSql = strSql & " FROM " & strTablePrefix & "FORUM "
	strSql = strSql & " WHERE FORUM_ID = " & fForum_ID
 
	set rsChk = my_Conn.Execute (strSql)
 
	if rsChk.EOF or not(ChkQuoteOk(fForum_ID)) then
		getForumName = ""
		exit function
	end if
 
	getForumName = rsChk("F_SUBJECT")
 
	rsChk.close
	set rsChk = nothing
end function
 
function getCatName(fCat_ID)
	'## Forum_SQL
	strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_NAME "
	strSql = strSql & " FROM " & strTablePrefix & "CATEGORY "
	strSql = strSql & " WHERE CAT_ID = " & fCat_ID
 
	set rsChk = my_Conn.Execute (strSql)
 
	if rsChk.EOF or not(ChkQuoteOk(fCat_ID)) then
		getCatName = ""
		exit function
	end if
 
	getCatName = rsChk("CAT_NAME")
 
	rsChk.close
	set rsChk = nothing
end function

quote:

---

Maybe this was answered before, but my short term memory eludes me at times, so I apologize for asking it if it has.

This new version that's being worked on - the code found at beta v33 site - where does the Internationalization update fit into the picture? Will the v33 code be released to the public before or after the Internationalization update? I'm sort of confused as to which version that was going to happen with. I would hope that it's the version after v33 - so we don't have to wait longer. The Internationalization project seems sort of bogged down in the discussion of execution and how it should be done.

---