Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Fix forum edit function speed

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
kyodai Posted - 03 April 2011 : 20:01:20
Well if you have a forum with over 10,000 members you will notice that it takes ages to load the "edit forum" page. Usually you (the admin) loads this page to edit a forum, you will do that when you add moderators or edit the description of a sub-forum.


What takes ages to load is actually the "allowed members" list, which is a rather stupid function for larger commercial forumsanyways, with many thousands of users noone wanna keep such lists anyways, the administrative overhead would be too large.

In the end it took like 30 seconds to load the page due to the ridiculous long list of members available. So i kinda "sacrificed" the list, but made it so if you encounter the rare condition that you need it you can add "&memberlist=1" to the url to get it back.



So here is my fix:


1. Edit "post.asp"

2. Find the following:


"if Request.QueryString("method") <> "" then"


(approx. line 50)

3. ABOVE insert the following:




if Request.QueryString("memberlist") <> "" then
	strMemberlist = 1
end if


4. Find the following:


		'## Allowed User - listbox Code


(approx line 1400)

5. Below this line search for:



		strSql = strSql & " WHERE M_STATUS = " & 1


6. REPLACE with the following:




		'kyodai edit allowed member list
		if strMemberlist = 1 then
		strSql = strSql & " WHERE M_STATUS = " & 1
		else
		response.write "<br>NOTE: Add &memberlist=1 to url if you wanna use this! <br>"
		strSql = strSql & " WHERE M_STATUS = " & 4
		
		end if
		'end kyodai allowed member list







That's it.


Enjoy!
1   L A T E S T    R E P L I E S    (Newest First)
SiSL Posted - 07 April 2011 : 17:22:04
Tell me about it over 200K users! :(

As another approach, you might add small AJAX function as filling droplist as you type to an input box...

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000 Version 3.4.07