I was messing around with SQL Profiler and noticed that if I run a trace on the admin_home.asp page, it returns the following queries:
SELECT GROUP_ID, GROUP_NAME, GROUP_ICON, GROUP_IMAGE FROM FORUM_GROUP_NAMES WHERE GROUP_ID = 1
go
SELECT MEMBER_ID, M_LEVEL, M_NAME, M_PASSWORD FROM FORUM_MEMBERS WHERE M_NAME = 'xxx' AND M_PASSWORD = 'xxx' AND M_STATUS = 1
go
SELECT COUNT(*) AS MySubCount FROM FORUM_SUBSCRIPTIONS WHERE MEMBER_ID = 1
go
SELECT COUNT(*) AS SubCount FROM FORUM_SUBSCRIPTIONS
go
SELECT GROUP_ID, GROUP_CATID FROM FORUM_GROUPS WHERE GROUP_ID = 1
go
these queries are all for general pages, but since they're located in inc_header.asp they're run in the admin area, as well. These aren't necessary in the admin area, are they?
Topic Locked
Posted - 10 October 2002 : 13:12:01
