AOZPO HISTORY

 

OUR SPONZORS AND PARTNERS 

 

 

THANK YOU ! 

Všeobecná diskusia

Hlavna stranka diskusie

Moderator:  forum

 

 
Temy Odpovede Autor Prezrete Posledny prispevok
Nebola najdena ziadna tema
 
 
Len prihlásený užívate¾ sa môže zapoji� do diskusie a písa� reakcie. Ak ešte nemáte vytvorený svoj profil, zaregistrujte sa.
 
  Zabudli ste heslo?
  Zaregistrujte sa.

PARTNERS

 

 



 

                                                                                                                                                                              

                                                                                                                                                                               

                                                                                                                                                                                

                                                                                                                                                                                

 

 

Debugging Information
ColdFusion Server Standard 10,0,0,283922
Template /index.cfm
Time Stamp 24-Aug-23 09:54 AM
Locale English (US)
User Agent Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
Remote IP 78.141.79.228
Host Name 78.141.79.228

Execution Time

Total Time Avg Time Count Template
140 ms 140 ms 1 top level D:\projects\aozpo\Site\wwwroot\index.cfm
125 ms 125 ms 1 D:/projects/aozpo/Site/modules/Default/objects/Default.cfm
93 ms 93 ms 1 D:/projects/aozpo/Site/modules/Forums/graphics/ForumList.cfm
63 ms 63 ms 1 D:/projects/aozpo/Site/modules/Forums/objects/ForumList.cfm
32 ms 32 ms 1 D:/projects/aozpo/Site/modules/Default/objects/LeftSection.cfm
16 ms 3 ms 5 C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/WebObjects/WebObject.cfm
16 ms 8 ms 2 D:/projects/aozpo/Site/modules/Forums/objects/ForumListFooter.cfm
16 ms 8 ms 2 D:/projects/aozpo/Site/modules/Utils/objects/ResultsListing.cfm
15 ms 15 ms 1 D:/projects/aozpo/Site/modules/Forums/main/SetRequestVariables.cfm
15 ms 15 ms 1 D:/projects/aozpo/Site/modules/Members/forms/LoginForm.cfm
0 ms 0 ms 1 C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/ActiveWeb/ActiveWebRequestSettings.cfm
0 ms 0 ms 1 C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/ActiveWeb/BrowseEdit.cfm
0 ms 0 ms 4 C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/ActiveWeb/Category.cfm
0 ms 0 ms 1 C:/ColdFusion10/cfusion/CustomTags/ActiveWeb3/ActiveWeb/NavigationVariablesSetup.cfm
0 ms 0 ms 14 D:/projects/aozpo/Site/functions/ShowLabel.cfm
0 ms 0 ms 2 D:/projects/aozpo/Site/modules/Default/objects/BodyObject.cfm
0 ms 0 ms 1 D:/projects/aozpo/Site/modules/Default/objects/FooterMenuObject.cfm
0 ms 0 ms 1 D:/projects/aozpo/Site/modules/Default/objects/FooterObject.cfm
0 ms 0 ms 2 D:/projects/aozpo/Site/modules/Default/objects/FormObject.cfm
0 ms 0 ms 1 D:/projects/aozpo/Site/modules/Default/objects/HeaderObject.cfm
0 ms 0 ms 1 D:/projects/aozpo/Site/modules/Default/objects/LeftMenuObject.cfm
0 ms 0 ms 1 D:/projects/aozpo/Site/modules/Default/objects/NavigationBarObject.cfm
0 ms 0 ms 1 D:/projects/aozpo/Site/modules/Default/objects/RightSection.cfm
0 ms 0 ms 1 D:/projects/aozpo/Site/modules/Default/objects/SearchObject.cfm
0 ms 0 ms 1 D:/projects/aozpo/Site/modules/Default/objects/TitleObject.cfm
0 ms 0 ms 1 D:/projects/aozpo/Site/modules/Default/objects/TopMenuObject.cfm
0 ms 0 ms 1 D:/projects/aozpo/Site/modules/Forums/objects/CheckForumPermission.cfm
0 ms 0 ms 1 D:/projects/aozpo/Site/wwwroot/Application.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
140 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

qCheckGroup (Datasource=aozpo, Time=0ms, Records=0) in D:\projects\aozpo\Site\wwwroot\Application.cfm @ 09:54:38.038
	SELECT a.Status, b.GroupID, b.GroupTitle
      FROM us_vUser a
      LEFT OUTER JOIN us_vUserGroup b ON (a.UserID = b.UserID)
     WHERE a.UserID = '0'
       AND a.ProjectID = '2'
	   AND b.GroupID IN (52, 51)
qGetForum (Datasource=aozpo, Time=15ms, Records=1) in D:\projects\aozpo\Site\modules\Forums\main\SetRequestVariables.cfm @ 09:54:38.038
        SELECT 
               a.ForumTitle
          FROM fo_vForum a
         WHERE a.ForumID = ?
           AND a.ProjectID = '2'
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 14

qGetCategory (Datasource=aozpo, Time=0ms, Records=4) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\ActiveWeb\Category.cfm @ 09:54:38.038
		SELECT 
			CategoryID, ParentCategoryID, CategoryTitleSys, CategoryType,
	        CategoryTitle, LanguageID, URL, URLTarget, RecordOrder, Status
			FROM ca_vCategory
			WHERE ProjectID = '2'
	
			
			  AND LanguageID = 'en'
			
			  AND ParentCategoryID = '156'
			
			  AND Status = 'active'
						
			

			ORDER BY RecordOrder ASC
qGetCategory (Datasource=aozpo, Time=0ms, Records=11) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\ActiveWeb\Category.cfm @ 09:54:38.038
		SELECT 
			CategoryID, ParentCategoryID, CategoryTitleSys, CategoryType,
	        CategoryTitle, LanguageID, URL, URLTarget, RecordOrder, Status
			FROM ca_vCategory
			WHERE ProjectID = '2'
	
			
			  AND LanguageID = 'en'
			
			  AND ParentCategoryID = '121'
			
			  AND Status = 'active'
						
			

			ORDER BY RecordOrder ASC
qGetCategory (Datasource=aozpo, Time=0ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\ActiveWeb\Category.cfm @ 09:54:38.038
		SELECT 
			CategoryID, ParentCategoryID, CategoryTitleSys, CategoryType,
	        CategoryTitle, LanguageID, URL, URLTarget, RecordOrder, Status
			FROM ca_vCategory
			WHERE ProjectID = '2'
	
			
			  AND LanguageID = 'en'
			
			  AND ParentCategoryID = '336'
			
			  AND Status = 'active'
						
			

			ORDER BY RecordOrder ASC
qGetWebObject (Datasource=aozpo, Time=16ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\WebObjects\WebObject.cfm @ 09:54:38.038
		SELECT 
			WebObjectID, WebObjectSystemTitle, LanguageID, Content
			FROM  aw_vWebObject a
			WHERE ProjectID = '2'

			
			  AND WebObjectSystemTitle = 'Left_Banner'
			
			  AND LanguageID = 'en'
			
			  AND Status = 'active'
			  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
			  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
			
	
			ORDER BY WebObjectSystemTitle
qGetWebObject (Datasource=aozpo, Time=0ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\WebObjects\WebObject.cfm @ 09:54:38.038
		SELECT 
			WebObjectID, WebObjectSystemTitle, LanguageID, Content
			FROM  aw_vWebObject a
			WHERE ProjectID = '2'

			
			  AND WebObjectSystemTitle = 'Left_Banner2'
			
			  AND LanguageID = 'en'
			
			  AND Status = 'active'
			  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
			  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
			
	
			ORDER BY WebObjectSystemTitle
qGetForum (Datasource=aozpo, Time=0ms, Records=1) in D:\projects\aozpo\Site\modules\Forums\graphics\ForumList.cfm @ 09:54:38.038
	SELECT 
    	   a.ProjectID, 
           a.CategoryID, 
           a.ForumTitle, 
           a.Status,
           a.ReadStatus
	  FROM fo_vForum a, ca_vCategory c
	 WHERE a.ForumID = ?
	   AND a.ProjectID = '2'
       AND a.CategoryID = c.CategoryID
       AND c.ProjectID = '2'
       AND c.LanguageID = 'en'
          
	
      AND a.Status = 'active'
      AND c.Status = 'active'
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 14

qGetThemes (Datasource=aozpo, Time=31ms, Records=0) in D:\projects\aozpo\Site\modules\Forums\objects\ForumList.cfm @ 09:54:38.038
	   SELECT 
       		  a.MessageID,
    		  a.ForumID,
              a.ParentMessageID,
              a.Subject AS Subject,
              a.AuthorID,
              a.AuthorUserName AS AuthorUserName,
              a.IsTop,
              a.Status,
              CASE 
                WHEN a.Status = 'approved' THEN '<img src="img/icons/ViewStatus_public.gif" width="11" height="11" alt="" />&nbsp;aktivna'
                WHEN a.Status = 'waiting'  THEN '<img src="img/icons/status.gif" width="11" height="11" alt="" />&nbsp;caka na schvalenie'
                WHEN a.Status = 'rejected'  THEN '<img src="img/icons/comment_no.gif" width="11" height="11" alt="" />&nbsp;neschvalena'
              END AS StatusTMP,
              ( SELECT Count(*) FROM fo_vMessage d WHERE d.L0 = a.MessageID AND d.Status = 'waiting' AND d.Depth > 0 ) AS MessageWaitingCount,
              
          
			  ( SELECT MAX(Created) FROM fo_tMessage d WHERE d.ForumID = a.ForumID AND d.Status = 'approved' AND d.L0 = a.MessageID ) AS LastAnswer,
              ( SELECT TOP 1 MessageID FROM fo_tMessage d WHERE d.ForumID = a.ForumID AND d.Status = 'approved' AND d.L0 = a.MessageID ORDER BY Created DESC ) AS LastMessageID,
              ( SELECT TOP 1 AuthorUserName FROM fo_vMessage d WHERE d.ForumID = a.ForumID AND d.Status = 'approved' AND d.L0 = a.MessageID ORDER BY Created DESC ) AS LastAnswerUserName,
              ( SELECT COUNT(*) FROM fo_tMessage d WHERE d.ForumID = a.ForumID AND d.Status = 'approved' AND d.L0 = a.MessageID AND d.Depth > 0 ) AS AnswerCount,  	
          
          
              ( SELECT Counter FROM aw_vHitSummary d WHERE d.EntityName = 'fo_tMessage' AND d.EntityID = a.MessageID AND d.ProjectID = '2' ) AS HitCounter,
              ( SELECT LastUpdated FROM fo_vReading d WHERE d.ForumID = a.ForumID AND d.MessageID = a.MessageID AND d.UserID = '0' ) AS ReadingDateTime,
              a.Created AS Created,
              
              b.PostStatus,
              b.ReadStatus
              
		 FROM fo_vMessage a, fo_vForum b, ca_vCategory c
		WHERE a.ForumID = '14'
          AND a.Depth = '0'
          AND a.ForumID = b.ForumID
         
          AND b.ProjectID = '2'
          AND b.LanguageID = 'en'
          AND b.CategoryID = c.CategoryID
          AND c.ProjectID = '2'
          AND c.LanguageID = 'en'
          
          
              AND b.Status = 'active'
              AND c.Status = 'active'
              
              AND a.Status = 'approved'
          
          
		ORDER BY a.IsTop ASC, LastAnswer DESC
qGetParticipants (Datasource=aozpo, Time=0ms, Records=1) in D:\projects\aozpo\Site\modules\Forums\objects\ForumList.cfm @ 09:54:38.038
	  SELECT UserID, UserName
		FROM fo_vForumParticipant
		WHERE ProjectID = '2'
		  AND ForumID = '14'
		  AND Status = 'approved'
          AND ParticipantType = 'moderator'
    ORDER BY ParticipantType DESC, UserName
qGetWebObject (Datasource=aozpo, Time=0ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\WebObjects\WebObject.cfm @ 09:54:38.038
		SELECT 
			WebObjectID, WebObjectSystemTitle, LanguageID, Content
			FROM  aw_vWebObject a
			WHERE ProjectID = '2'

			
			  AND WebObjectSystemTitle = 'RIGHT_Banner'
			
			  AND LanguageID = 'en'
			
			  AND Status = 'active'
			  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
			  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
			
	
			ORDER BY WebObjectSystemTitle
qGetWebObject (Datasource=aozpo, Time=0ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\WebObjects\WebObject.cfm @ 09:54:38.038
		SELECT 
			WebObjectID, WebObjectSystemTitle, LanguageID, Content
			FROM  aw_vWebObject a
			WHERE ProjectID = '2'

			
			  AND WebObjectSystemTitle = 'RIGHT_Banner2'
			
			  AND LanguageID = 'en'
			
			  AND Status = 'active'
			  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
			  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
			
	
			ORDER BY WebObjectSystemTitle
qGetWebObject (Datasource=aozpo, Time=0ms, Records=1) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\WebObjects\WebObject.cfm @ 09:54:38.038
		SELECT 
			WebObjectID, WebObjectSystemTitle, LanguageID, Content
			FROM  aw_vWebObject a
			WHERE ProjectID = '2'

			
			  AND WebObjectSystemTitle = 'Text_Copyright'
			
			  AND LanguageID = 'en'
			
			  AND Status = 'active'
			  AND (ValidFrom <= GETDATE() OR ValidFrom IS NULL)
			  AND (ValidTo >= GETDATE() OR ValidTo IS NULL)
			
	
			ORDER BY WebObjectSystemTitle
qGetCategory (Datasource=aozpo, Time=0ms, Records=0) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\ActiveWeb\Category.cfm @ 09:54:38.038
		SELECT 
			CategoryID, ParentCategoryID, CategoryTitleSys, CategoryType,
	        CategoryTitle, LanguageID, URL, URLTarget, RecordOrder, Status
			FROM ca_vCategory
			WHERE ProjectID = '2'
	
			
			  AND LanguageID = 'en'
			
			  AND ParentCategoryID = '122'
			
			  AND Status = 'active'
						
			

			ORDER BY RecordOrder ASC

Stored Procedures

ca_spCategoryPath (Datasource=aozpo, Time=0ms) in C:\ColdFusion10\cfusion\CustomTags\ActiveWeb3\ActiveWeb\NavigationVariablesSetup.cfm @ 09:54:38.038
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_integer  336    
 IN  CF_SQL_integer  2    
 IN  CF_SQL_varchar  en    
 OUT  CF_SQL_varchar    CategoryIDList = CategoryIDList  
 OUT  CF_SQL_varchar    CategoryTitleList = CategoryTitleList  
 OUT  CF_SQL_varchar    CategoryURLList = CategoryURLList  
 OUT  CF_SQL_integer    ReturnValue = ReturnValue  
 OUT  CF_SQL_varchar    ReturnMessage = ReturnMessage  
    
resultsets
nameresultset

Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\projects\aozpo\Site\wwwroot\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,image/png,image/jpeg,image/pjpeg,image/x-xbitmap,image/svg+xml,image/gif;q=0.9,*/*;q=0.1
HTTP_ACCEPT_ENCODING=gzip, identity;q=0.9
HTTP_ACCEPT_LANGUAGE=sk, *
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=$Version=1; CFID=18873284; $Path=/; CFTOKEN=14bb24440d0722fb-813FD46B-D3AA-8E13-D8E509BB2AE453AB; $Path=/; LANGUAGEID=en; $Path=/
HTTP_HOST=www.aozpooz.sk
HTTP_REFERER=http://www.aozpooz.sk/index.cfm?module=forums
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
PATH_INFO=
PATH_TRANSLATED=D:\projects\aozpo\Site\wwwroot\index.cfm
QUERY_STRING=module=Forums&page=ForumList&ForumID=14
REMOTE_ADDR=78.141.79.228
REMOTE_HOST=78.141.79.228
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.aozpooz.sk
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=

Cookie Variables:
CFID=18873284
CFTOKEN=14bb24440d0722fb-813FD46B-D3AA-8E13-D8E509BB2AE453AB
LANGUAGEID=en

Session Variables:
browseediton=no
cfid=18873284
cftoken=14bb24440d0722fb-813FD46B-D3AA-8E13-D8E509BB2AE453AB
labelmode=normal
sessionid=AOZPO_01912_18873284_14bb24440d0722fb-813FD46B-D3AA-8E13-D8E509BB2AE453AB
urltoken=CFID=18873284&CFTOKEN=14bb24440d0722fb-813FD46B-D3AA-8E13-D8E509BB2AE453AB
userid=0
username=

URL Parameters:
ForumID=14
module=Forums
page=ForumList
Debug Rendering Time: 187 ms