|
Just override the old files with the new files. (Take note on the mods youve done and the styles you've set)
To view your posts you will need to modify one of the stored procedures on MSSQL.
change your "wwfSpLastAndFirstThreadAuthor" to this one below
CREATE PROCEDURE [dbo].[wwfSpLastAndFirstThreadAuthor] ( @lngTopicID int ) AS SELECT tblThread.Thread_ID, tblThread.Author_ID, tblThread.Message, tblThread.Message_date, tblAuthor.Username FROM tblAuthor INNER JOIN tblThread ON tblAuthor.Author_ID = tblThread.Author_ID WHERE tblThread.Topic_ID = @lngTopicID ORDER BY tblThread.Message_date ASC;
GO
and if you want the SQL stats from the admin area, add the stored procedure below.
CREATE PROCEDURE [dbo].[wwfSpDBinfo]
As
Declare @low int
Declare @dbsize dec(10,2)
Declare @dbpath nvarchar(100)
Declare @logpath nvarchar(100)
Declare @dbfilesize dec(10,2)
Declare @logfilesize dec(10,2)
Declare @maxdbfilesize dec(10,2)
Declare @maxlogfilesize dec(10,2)
--Minimum Database Size
select @low = low from master.dbo.spt_values
where type = N'E' and number = 1
--Calculation of current Database Size in MB
select @dbsize = (convert(dec(15),sum(size)) * @low / 1048576)
from [sysfiles]
--Actual File Size of Log and Data File
Select TOP 1 @dbpath = [filename] from [sysfiles] where groupid = 1
Select TOP 1 @logpath = [filename] from [sysfiles] where groupid = 0
Select @dbfilesize = convert(dec(10,2),sum([size]))/128 from [sysfiles] where [filename] = @dbpath --in MB
Select @logfilesize = convert(dec(10,2),sum([size]))/128 from [sysfiles] where [filename] = @logpath --in MB
Select TOP 1 @maxdbfilesize = convert(dec(10,2),[maxsize])/128 from [sysfiles] where [filename] = @dbpath
Select TOP 1 @maxlogfilesize = convert(dec(10,2),[maxsize])/128 from [sysfiles] where [filename] = @logpath
If @maxdbfilesize = (-.01) Set @maxdbfilesize = -1
If @maxlogfilesize = (-.01) Set @maxlogfilesize = -1
---Creating Output Table
select @dbsize Databasesize, @dbpath DataLocation , @logpath LogLocation,
@dbfilesize DatabaseFileSize, @logfilesize Logfilesize,
@maxdbfilesize MaxDBSize, @maxlogfilesize MazLogSize,
ServerProperty('edition') Edition,
CASE ServerProperty('IsCluster')
WHEN 0 THEN 'No Cluster'
WHEN 1 THEN 'Cluster'
ELSE 'No Cluster/Unknown'
END Cluster,
CASE ServerProperty('License_Type')
WHEN 'PER_SEAT' THEN 'Seat Licensing (' + Convert(nvarchar(5),ServerProperty('NumLicenses')) + ')'
WHEN 'Per_Processor' THEN 'Processor Licensing (' + Convert(nvarchar(5),ServerProperty('NumLicenses')) + ')'
ELSE 'Licensing Disabled / Unknown'
END Licensing,
ServerProperty('ProductLevel') PLevel
GO
Thats all I've had to do so far, other than tweak the code here and there to fit my site. I'm a newbie and am just getting the hang of this forum. I've had it running for about 2 days now.
|