• Lots of bug fixes
• Extra security
• New forum codes such as [Quote], [Code], and also the use of hex colours ie [color=#000000]
• Simpler to set group permisisons over multiple forums
• Shorter registration form
• Image security code on registration and login pages
  
• Next and previous links on posts over multiple pages
• WYSIWYG Editor now supported under multiple platforms and browsers including IE5+, Mozilla 1.3+, Netscape 7.1+
• Post spell checker for IE
  
• Improved browser and OS detection for Active Topics page
• Login test to see if the user has cookies enabled and display a message if not
• Long text strings in messages now wrap at the 60th character to keep the formatting of tables correct to prevent left and right scrolling in a browser window
• Uploaded files now placed in a folder in the uploads director named after the users username
• View topics that you have subscribed to email notification on from the page you edit your profile on
• Only once users are registered may they upload avatars
• Flash files in signatures
• Compact and repair access database from the admin area (Access only)
• SQL server stats from admin area (SQL Server only)
• View the first 100 characters of a post by placing the mouse over the topic title in the topic page, also shows date started by placing the mouse over the topic starter name
• Forward PM to your email address so you can have a copy of the PM locally
• PM percentage bar in your inbox indicating how many more PM's you can receive
• PM inbox, delete all button
• Support fro Flash files in PM's
  
• Resend activation email function
• More options when deleting or locking topics from the admin area
• Choose if you wish to display a moved icon in old forum when moving topic between forums
• Topic admin can be bought up from active topics page
• Buddy list now indicates if a buddy is online in the forum at that time
• and loads of other changes

I haven't downloaded this yet -- but thanks for all your hard work!  I've learned more about ASP from you logical and well documented products!

Job well done!

Kita 

Thanks for all your hard work!

Wait for the formal edition......

Just testing 7.5 and have found that when I click on my subscriptions link in the control panel i get the following error. http://www.otrader.com.au/forum1/forum_posts.asp?TID= -

Line 318 is not a comment, it calls the fields Subject and Topic_ID and both fields are selected on the SQL query so I don't see how you could get that error unless you modified the file.

<edit> that comment is on line 314 on the files i just downloaded.

I have used Dreamweaver to check line number and that commet line is on line 319 and 318 in Frontpage.

I have not modified the file and have uploaded it twice to make sure it was not an upload error.

What program are you using to check your line number?

There is another issue. in the sql statement above line 318 around line 289, the Select statement calls fields from 2 tables. tblTopic & tblEmailNotify as below.

strSQL = "SELECT " & strDbTable & "Topic.Topic_ID, " & strDbTable & "Topic.Subject, " & strDbTable & "Topic.Last_entry_date, " & strDbTable & "EmailNotify.Topic_ID, " & strDbTable & "EmailNotify.Watch_ID "
strSQL = strSQL & "FROM " & strDbTable & "Topic, " & strDbTable & "EmailNotify "
strSQL = strSQL & "WHERE " & strDbTable & "Topic.Topic_ID=" & strDbTable & "EmailNotify.Topic_ID AND " & strDbTable & "EmailNotify.Author_ID=" & lngEmailUserID & " "
strSQL = strSQL & "ORDER BY " & strDbTable & "Topic.Last_entry_date  DESC;"

I'm not running MSSQL Server so I dont know how it behaves with it, but if you are using Access you will have a problem. As you see from the red color fields we are trying to get 2 fields with the same name from 2 different tables. That will generate an error with asp/access. What I did to get it to work was simply to change

"EmailNotify.Topic_ID, " to "EmailNotify.Topic_ID As eTopic_ID, "

That will give the fields 2 distinctive names. And you wont have any ambiguity in the call.

Note: If you were to run the query from access and not asp, it will also work as is and you dont need to change it. But with ASP calling access you will get that error.

Good job -borg-!

I didn't think the forum could get much better, but your new additions are awesome!

I am testing 7.5 (access)  on local with WinMe

When clic on "search" or "new topic" I get a white web page

why

i'm unable to open the sql version zip file. winzip tells me it's not a valid zip file. never had this problem before. tried the us mirror, uk mirror and the original link. any ideas anyone?

i like the new security number on the log in. i'm curious as to what prompted that new feature.

In this release will the Active Topics and the Search show only forum corresponding to the user's definition ? In another words so far when clicking on "Active Users" my users see forums which are "hidden" for them.

jean-luc

I am also having a problem with the database. I am running the SQL version. the error I get is this.

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forum_topics.asp, line 424

best I can tell it is because you have added
strFirstPostMsg = Mid(rsTopic("Message"), 1, 275)
and
dtmFirstEntryDate = CDate(rsTopic("Message_date"))

so it is looking for fields I do not currently have in my 7.01 version database.

I maybe totally wrong in that, but that looks like it the best I can tell. I am guessing this is going to come up in other pages as well. What is the best way to fix this. Thank you.

Sweet -borg-!!...Very Nice!

can you tell when the FINAL version will be out? i cant wait!!

-boRg- wrote: You need to change the stored procedure for the SQL server version on this page. It should be mentioned in the version.txt file what the change was as I can not remember. Also you need to create a new stored procedure for the SQL server statistics in the admin area.

As always you are both helpful and timely. Thanks again boRg. I will try this.

-boRg- wrote: ctscott wrote: i'm unable to open the sql version zip file. winzip tells me it's not a valid zip file. never had this problem before. tried the us mirror, uk mirror and the original link. any ideas anyone? i like the new security number on the log in. i'm curious as to what prompted that new feature. Use winRAR it's much better than WinZip which is very dated now. You can get it from http://www.rarlab.com/ - http://www.rarlab.com/

i'm good to go. thanks.

T313C0mun1s7 wrote: -boRg- wrote: You need to change the stored procedure for the SQL server version on this page. It should be mentioned in the version.txt file what the change was as I can not remember. Also you need to create a new stored procedure for the SQL server statistics in the admin area. As always you are both helpful and timely. Thanks again boRg. I will try this.

OK, so I am clueless as how to do this. I have been attempting to get somewhere for about 4 hours now. At least I understand somewhat what a stored procedure is now. I also understand the why for the strBdTable = "tbl" and strDbProc = "wwfSp" in the msSQL_server_Setup.asp page. I just don't know how to go about making the changes.

Is it safe to run the msSQL_server_Setup.asp script to do an upgrade? I am guessing it is not. If not would it be possible to get a script that would do the upgrade?

Thank you in advance for any assistance you can provide.

Hey Borg, very nice. well done on 7.5.. I have installed this and had a quick play. What I have noticed at first glance is that when you administer user groups all the groups appear to appear twice. Is this  by design or some other error. See below.

User Group	Stars	Minimum Num of Posts (for Ladder Groups only)	Starting Group	Delete
http://localhost:8081/wwf75/admin/group_details.asp?mode=edit&GID=1 - Admin Group		Non Ladder Group
http://localhost:8081/wwf75/admin/group_details.asp?mode=edit&GID=2 - Guest Group		Non Ladder Group
http://localhost:8081/wwf75/admin/group_details.asp?mode=edit&GID=3 - Moderator Group		Non Ladder Group	< = value=3 name=start>
http://localhost:8081/wwf75/admin/group_details.asp?mode=edit&GID=4 - Newbie		0	< = value=4 name=start>
http://localhost:8081/wwf75/admin/group_details.asp?mode=edit&GID=5 - Groupie		40	< = value=5 name=start>
http://localhost:8081/wwf75/admin/group_details.asp?mode=edit&GID=6 - Senior Member		100	< = value=6 name=start>
http://localhost:8081/wwf75/admin/group_details.asp?mode=edit&GID=7 - Admin Group		Non Ladder Group	< = value=7 name=start>
http://localhost:8081/wwf75/admin/group_details.asp?mode=edit&GID=8 - Guest Group		Non Ladder Group	< = value=8 name=start>
http://localhost:8081/wwf75/admin/group_details.asp?mode=edit&GID=9 - Moderator Group		Non Ladder Group	< = value=9 name=start>
http://localhost:8081/wwf75/admin/group_details.asp?mode=edit&GID=10 - Newbie		0	< = value=10 name=start>
http://localhost:8081/wwf75/admin/group_details.asp?mode=edit&GID=11 - Groupie		40	< = value=11 name=start>

T313C0mun1s7 wrote: Is it safe to run the msSQL_server_Setup.asp script to do an upgrade? I am guessing it is not. If not would it be possible to get a script that would do the upgrade? Thank you in advance for any assistance you can provide. Looking at the thread above I would say - Don't run the script again. I found the two sections in the script that creates the stored procedures in question. I just can not decipher them. I also have access to my database through a Access Data Project. Could you just post or PM me a screenshot of what it should look like in design mode? I could then replicate it from there. Thank you again. P.S. I am running a temp forum in a different webspace on the same server using the same database. This way I can just change my host headers on the server to roll it over once I have it running right. I am guessing that when I make the change to the LastAndFirstThreadAuthor procedure it will break the old version forum and therefore I should lock it first. I know how to log into the admin area of a locked forum. If there is anything else I should also be aware of please let me know.

-boRg- wrote: You must have run the MS SQL server setup file twice, you need to delete the secound entries.   OOps yes, I think thats what I did come to think of it.. ------------- If you dont want my peaches, dont shake my tree

T313C0mun1s7 wrote: T313C0mun1s7 wrote: Is it safe to run the msSQL_server_Setup.asp script to do an upgrade? I am guessing it is not. If not would it be possible to get a script that would do the upgrade? Thank you in advance for any assistance you can provide. Looking at the thread above I would say - Don't run the script again. I found the two sections in the script that creates the stored procedures in question. I just can not decipher them. I also have access to my database through a Access Data Project. Could you just post or PM me a screenshot of what it should look like in design mode? I could then replicate it from there. Thank you again. P.S. I am running a temp forum in a different webspace on the same server using the same database. This way I can just change my host headers on the server to roll it over once I have it running right. I am guessing that when I make the change to the LastAndFirstThreadAuthor procedure it will break the old version forum and therefore I should lock it first. I know how to log into the admin area of a locked forum. If there is anything else I should also be aware of please let me know. I am SO sorry to be taking up so much of this thread, but I need to get this working. I really appreciate your time boRg as I know it is valuable. I added "Message" to the output and both forums seem to work now. The old one is not broke -YEA! - However, am still going to need assistance to get the "DBinfo" procedure entered manually. I almost popped my gourd figuring out all I had to do was add one thing to the output on the last one, this procedure looks much more involved.

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

-boRg- wrote: For the dbInfo stored procedure in the SQL server Enterprise manager go to the stored procedures for the database containing the forums, right click on stored procedures and select new stored procedure. From the new stored procedure dialog box clear what is in there and copy and paste the following:- As always boRg you are absolutely awesome. Thank you again.

-boRg- wrote: ripcurlsurf this has been posted on a number of times and a fix to this known problem with the subscriptions page in the access version. I'm not sure if this was in answer to my question regarding the subscriptions page problem.  I've been attempting to find the fix, but must be searching wrong.  Is there a link (or a way that I am not doing for the search)? Thanks, Rob

-boRg- wrote: The auto login uses cookies so should work when clicking an email link unless you have cleaned your cookie cache. Hmm. It works on your forum but on mine I get... Sorry, only members with sufficient permission can access this page. -boRg- wrote: The security will be able to be turned off in the next version by chaging a boolean value in the common.asp file. That would be good - I do like it but I think it is over egging the cake in my circumstances.