Yes, I was referring to ASP Protect.

I had about a dozen people access the same account, but it is highly unlikely that they would all try at the same time (unless there were several hundred people who had access). Having an enhanced login abuse would be nice.

Upgrade from V6 to v7.x with an MSSQL SERVER DATABASE

1st of all, backup your existing ASPProtect files and database before performing this upgrade. Please be really careful while performing this upgrade. Version 7.x  is a highly advanced application compared to any previous versions. CJWSoft under no circumstances is responsible if you lose information or have website downtime.

BOTTOM LINE: (PERFORM THIS UPGRADE AT YOUR OWN RISK)

To do this upgrade you're going to need to have SQL Enterprise Manager and SQL Query Analyzer

That being said, on with the upgrade..

Open your SQL database in SQL Enterprise Manager

Regarding the following Tables

Rename "Users" to "ASPP_Users"
Rename "Groups" to "ASPP_Groups"

If you do not have a "Groups" table do not worry about it right now.

Now right click and DELETE the Config Table.
Yes, delete it..

Now, go into Design View for the "ASPP_Users" Table.

Rename the "Password" field to "Old_Password"
Be sure to spell it perfectly using the Underscore

If you have a "Groups" Field... leave it alone
If you do not have a "Groups" Field add one and make it a "nvarchar" field with a lengh of 255.

Now, we are going to add a few more new fields.

Add a field called "Redirection_URL" make it a "nvarchar" field with a lengh of 150.
Add a field called "PayPal_Subscriber_ID" make it a "nvarchar" field with a lengh of 100.
Add a field called "Newsletter" and make it a "bit" field
Add a field called "Password" and make it a "nvarchar" field with a lengh of 100.

Now close that window and save the changes..

Download these scripts.
2005-02-23_171110_aspprotect_v7_sql_upgrade_scripts.zip

Now open up SQL Query Analyzer
Connect to your SQL server.

Then load the script  "aspprotect_v7_config_table.sql" into the Query Analyzer.  Click the green play button at the top. If everything goes well the response should read something like this.

******************************************************
(1 row(s) affected)
******************************************************

Now, if you had a Groups Table your done with the database changes.

If you didnt have a groups table.

Then load the script  "aspprotect_v7_groups_table.sql" into the Query Analyzer.  Click the green play button at the top.

Now, go back to your database in Enterprise Manager and make sure all 3 tables are there and look ok. You might need to do a refresh or two to see them.

Now make sure an existing or new SQL user has (public / datareader / datawriter) permissions for all three tables. You reference this user in the asp code connection string so this user must be set up correctly. You may need your SQL server admins or hosting company to help you on this step as you may not have access to do this. You may not need to create a user and set permissions as the sql user you were logged in as to use query analyzer may by default get the correct permissions on anything you create.

Regardless, as you can see from this screenshot I have a SQL user called "aspprotectuser" and proceeded to set the permissions for that user. Under database access giving him (public,datareader, and datewriter permissions).


Now, you are done upgrading your SQL Server Database.

The existing passwords still have to be encrytped and moved from the "Old_Password" to the "Password" field

To that we have a special page we run in the application that will take care of that.

So, for now... go install the application, but using the database we just created.
Follow these instructions for the most part...
http://support.cjwsoft.com/forum/forum_posts.asp?TID=181& ; ;PN=1

When you get to the part where you finally get into the admin area and need to make an admin account you will notice that your existing user database is there but none of the users have passwords if you look at them in the edit screen.

That is normal. Simply do what the instructions say and create and admin account using a username that does not exist..

Then log off... then back in as that new admin account. If that works you are ready to convert the passwords.

This part is very easy.

You want to run a special page via the browser.

http://www.mysite.com/password_admin/convert_to_encrypted.asp

Replacing the part in blue with your website info.

Once you get the page running you will see a login prompt and one form field just like before with the "get_me_in.asp" page

You will need to paste the "PasswordEncryptionKey" value that you used in the "config_inc.asp" file in the form field and hit enter.

If all goes well you will see a page telling you to click here to encrypt the passwords and copy them over.

So do what it says... dont click more than once and wait.

Eventually it should say it is finished. So go log in to the admin area of the system using the new admin account.

Now edit some users but dont save... you want to see if the passwords are showing up. If they are the conversion worked. If you see nothing or a garbled mess it did not work and you made a mistake during this whole process.

If things went well backup and delete the conversion file below.

http://www.mysite.com/password_admin/convert_to_encrypted.asp

You do not need it anymore.

Once you are positive every thing is running smoothly and everyone's passwords are ok you can go in and delete the "Old_Password" field as well.



If things didnt go well.. try again from scratch and go slowly.
If they still dont go well get ahold of us for help.

We are here to help, but if you really want us to we can be hired to do the conversion.

right..

I had to open up the permissions to get it to work.  I now have to go back and uncheck each one for directory listing.. :)

The company that hosts our business web site has been impossible to deal with in assisting me in getting asp protect to work. Getting the rights set correctly took 6 days and then getting parent paths enabled has been impossible. There last response was simply this:

The includes were changed so that if your server does not support "parent paths"
' and the "../" that you could easily change a few files like this and make the
' includes virtual includes instead of file includes. We didnt make them virtual
' includes by default because depending on where in your site you put the application
' the virtual include path would be different. They are also much different on a local
' development server than they would be on your real server
'
' Here are some examples of what you might change these includes to
'
' If you put the aspprotect folder in the root of your domain at your server
' example: www.mydomain.com/aspprotect
' then you would probably use
'
' #INCLUDE VIRTUAL="/aspprotect/dataconn_inc.asp"
' #INCLUDE VIRTUAL="/aspprotect/config_inc.asp"
' #INCLUDE VIRTUAL="/aspprotect/scripts/emailing_subs_inc.asp"
'
' Or if you didnt use the aspprotect folder and just put the contents of it in the root
' of your domain
' then you would probably use
'
' #INCLUDE VIRTUAL="/dataconn_inc.asp"
' #INCLUDE VIRTUAL="/config_inc.asp"
' #INCLUDE VIRTUAL="/scripts/emailing_subs_inc.asp"
'
' It really all depends on what works for your situation
' If you want more information on server side includes read this article at PowerASP
'
' http://www.powerasp.com/content/code-snippets/includes.asp

I am assuming that they will not enable parent paths and I need to modify some code. I do not know asp. WHere do I modify the code for a server that will not enable parent paths?

Thanks,

D

(FREE) Nov 23 2005 Update Files

If you purchased ASPProtect Version 7.x before Nov 23 2005 then you can download these Update Files.

(These are non-critical updates.. only update if you want the described changes below)

These updates do the following..

• Make the Tabs in the Admin area move up and down as you navigate around so they look more like tabs used in a file cabinet.
  
• Updates the import/export process so the tab delimited text files created now store the passwords in plain text instead of encrypted. I have been thinking about this one for a while now and I think it is better this way as it was confusing a lot of people. If can also kill the whole process if by chance the encrypted output of a password contains a line break of sorts. There is no way to deal with that scenario so this is way the import/export process is going to work from now on. This also means you should be VERY carfeful about leaving export files lying around as they will have the passwords in them.
  
• Updates the "expected_paths.asp" in the data folder because the paths it was generating had an extra "data/" in it.
  
• Updates the users page so it will not show the import/export link if you have not entered a path for the export files in the settings.
  
• Adds an Activity Tab if using the Activity Tracking features instead of the links it used to put on the users page that most people didn't see.

To install these just copy them in over the old files.

Now of course back up your existing files so can revert back if there is a problem or you do not like the changes. If you made any custom changes to any of your pages use your head and realize that copying these in over your existing files will overide any custom changes you made. (that is your business, I am just warning you)

2005-11-23_163025_ASPProtect_v7_11-23-2005_update.zip

Hi,

The source code comes with it.
They are the.vb files.

I don't give out any project files for reasons stated in the article below.

Please read this in full if you want to edit the application in Visual Studio.NET

http://support.cjwsoft.com/code/moreinfo85-1.htm

The only major usability issue I've found to date is multi-zone banners. Cloning is helpful to a point, but then if you have a change to that banner, you have to make the change 6 times or what have you. I think, even at the expense of speed, multi-zone capability for a single banner would be excellent addition. Of course, that supposes I haven't just missed it and it's already there.

Hallo,

What do I have to do for inserting around 6,000 new users?

I have all my user in an access file. I don't know the password of access database files. The same problem with the "aspprotect upgrade pack".

Sorry for my English

in the version you have changing it is not something we covered

I believe you will find it the "config_inc.asp" file in the root though... be careful with naming it though because if you use any spaces or weird characters it might cause issues with various functions in the application like emailing.. I recommend just using letter, numbers, and maybe dashes

Okay,  I deleted out the aspprotect folder and started over.  I also took out the dsn connection to the ecommerce database and deleted out the subweb that had it, I decided to use another provided where the database is resident on thier servers not mine.

I broke my txt file into groups and it's loading sort of.  The first 1000 users uploaded fine...the second said it timed out, but when I looked at the access database it showed 2000 people.   The login still times out and every page seems to load incredibly slow still.

i will probably end up doing this myself, but dropping all the log data in a sql table would be nice as it offers much more flexibility on how an admin can keep track and use the data. Browsing through each log file is very inconvenient. I can search for text in the files (server-side, others with a shared server would probably have to separately download all log files first), but with the current method I don't have the following important options:

• cannot sort by any criteria
• quickly see a list of all login attempts by a specific user (i need to search each log file individually for this info)

if you had an option during setup perhaps (or elsewhere) in a future version that allowed an admin to specify the preferred logging method (separate files or a table in sql) i'm sure many admins would find it very useful to have a database alternative of keeping track of users becuase it would offer the two benefits listed above, plus more.

when you get back to work.. your   "redirect.asp" needs the password include file at the top of it.. or that wont work either..

and of course those pages you send people to all need to be repaired

I have purchased ASPProtect to secure a web site that I administor for a soccer league.  I am having a hard time getting the code to execute.  the instructions are to include this code at the top of the web page under the Language identifier.  Like this I think:

<%@ LANGUAGE="VBSCRIPT" %>

<!-- Begin ASPProtect Code -->
<!-- Groups with access to this page. ( * Admins * ) -->
<% GROUPACCESS = "4" %>
<!--#INCLUDE FILE="check_user_inc.asp"-->
<!-- End ASPProtect Code -->

However, nothing happens.  I am not sure if I am missing something. 

FYI:  the "Check_user_inc.asp" file is in the root directory of the site which is actually two levels down on the d: drive of the server.
      The web page code is located below.

Any help is greatly appreciated.

<html>
<head>
<title>TeamManagers</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#006600">
<div id="Layer1" style="position:absolute; left:125px; top:109px; width:682px; height:597px; z-index:1">
  <table width="655" border="1" name="teambios" bgcolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" height="312">
    <tr bordercolor="#006600">
      <td bgcolor="#006600" width="154" height="33"><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Division
        1</font></b></td>
      <td bgcolor="#006600" width="160" height="33"><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Division
        2</font></b></td>
      <td bgcolor="#006600" width="148" height="33"><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Division
        3</font></b></td>
    </tr>
    <tr>
      <td width="154" height="26">&nbsp;</td>
      <td width="160" height="26">&nbsp;</td>
      <td width="148" height="26">&nbsp;</td>
    </tr>
    <tr>
      <td width="154" height="26"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/BHawks/BHawks_search.htm">Black
        Hawks</a></font></b></td>
      <td width="160" height="26"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Gunners/TFC_search.htm">Gunners</a ></font></b></td>
      <td width="148" height="26"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/InterFC/InterFC_search.htm">Inter
        FC </a></font></b></td>
    </tr>
    <tr>
      <td width="154" height="26"><font face="Arial, Helvetica, sans-serif"><img src="/Images/clearpixel.gif" width="1" height="1"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/DCove/DCove_search.htm">Deep
        Cove Brewers</a></font></b></font></td >
      <td width="160" height="29" valign="top"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NSReds/NSReds_search.htm">North
        Shore Reds</a></font></b></td>
      <td width="148" height="26"><font face="Arial, Helvetica, sans-serif"><img src="/Images/clearpixel.gif" width="1" height="1"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/BFC%20Blackhawks/BFC_search.htm">LV
        BFC Blackhawks</a></font></b></font>< /td>
    </tr>
    <tr>
      <td width="154" valign="top" height="28"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/FatBoys/FatBoys_search.htm">Fat
        Boys</a></font></b></td>
      <td width="160" valign="top" height="28"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NSIndians/NSIndians_search.htm">Squam ish
          Nation United</a></font></b></p></td>
      <td width="148" valign="top" height="28"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NSYoungGuns/NSYoungGuns_search.htm">N orth
        Shore Young Guns</a></font></b></font></b> </font></b></td>
    </tr>
    <tr>
      <td width="154" valign="top" height="29"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/LEI/LEI_search.htm">LEIFC</a>&l t;/font></b></td>
      <td width="160" valign="top" height="29"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/UFK/UFK_search.htm">UFK
        United</a></font></b></td>
      <td width="148" valign="top" height="29"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Saints/Saints_search.htm">Northland
        Saints</a></font></b></font></b&g t;</td>
    </tr>
    <tr>
      <td width="160" height="27" valign="top"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Lightning/Lightning_search.htm">Light ning</a></font></b></td>
      <td width="160" height="27" valign="top"><b><font face="Arial, Helvetica, sans-serif"><a href="/holding/UFK/UFK_search.htm">
        </a><a href="/TeamManagers/Warriors/Warriors_search.htm">Warrior s</a></font></b></td>
      <td width="148" height="29" valign="top"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/SoccerCityFC/SoccerCityFC_search.htm"> ;Soccer
        City FC</a></font></b> </font></b></td>
    </tr>
    <tr>
      <td width="154" valign="top" height="27"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/QCHawks/QCHawks_search.htm">Q.C.
          Hawks</a></font></b></p></td>
      <td width="160" valign="top" height="27">&nbsp;</td>
      <td width="148" valign="top" height="27"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/holding/Cougars/Cougars_search.htm">
          </a></font></b></p></td>
    </tr>
    <tr>
      <td width="154" valign="top" height="32"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/OdlumBrownFC/OdlumBrownFC_search.htm"> ;Odlum
        Brown </a></font></b></td>
      <td width="160" valign="top" height="32">&nbsp;</td>
      <td width="148" valign="top" height="32"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"></font></b></font></b> ;</td>
    </tr>
    <tr valign="top">
      <td width="154" height="27"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/WestwardFC/WestwardFC_search.htm">Wes tward
        Utd F.C.</a></font></b></td>
      <td width="160" height="27">&nbsp;</td>
      <td width="148" height="27"><b><font face="Arial, Helvetica, sans-serif"></font></b></td>
    </tr>
  </table>
  <table width="655" border="1" name="teambios" bgcolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" height="289" bordercolor="#000000">
    <tr bordercolor="#006600">
      <td bgcolor="#006600" height="29" colspan="2"> <p><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Over
          30's Division A</font></b></p></td>
      <td bgcolor="#006600" width="349" height="29" colspan="2"> <p><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Over
          30's Division B</font></b></p></td>
    </tr>
    <tr>
      <td height="15" colspan="2"><font face="Arial, Helvetica, sans-serif"><img src="/Images/clearpixel.gif" width="1" height="1"></font></td>
      <td width="349" height="15" colspan="2"><font face="Arial, Helvetica, sans-serif"><img src="/Images/clearpixel.gif" width="1" height="1"></font></td>
    </tr>
    <tr>
      <td valign="top" colspan="2" height="31"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/BBear/BBear_search.htm">Villa
        Roma FC</a></font></b></td>
      <td width="349" valign="top" colspan="2" height="31"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Comrades/Comrades_search.htm">Comrade s</a></font></b></td>
    </tr>
    <tr>
      <td valign="top" colspan="2" height="30"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/JESpurs/JESpurs_search.htm">Maplewood
        Spurs</a></font></b></td>
      <td width="349" valign="top" colspan="2" height="31"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NS%20Chiefs/NSChiefs_search.htm">NS
        Chiefs </a></font></b></td>
    </tr>
    <tr>
      <td height="29" valign="top" colspan="2"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NSRangers/NSRangers_search.htm">N.S.
        Rangers</a></font></b></td>
      <td width="349" valign="top" colspan="2" height="30"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/SVikings/SVikings_search.htm">Screami ng
        Vikings </a></font></b></td>
    </tr>
    <tr>
      <td height="29" valign="top" colspan="2"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/RGullStrikers/RGullStrikers_search.htm"& gt;Rusty
        Gull Strikers</a></font></b></td>
      <td width="349" height="29" valign="top" colspan="2"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Spareboy/Spareboy_search.htm">Sparebo y</a></font></b></td>
    </tr>
    <tr>
      <td colspan="2" valign="top" height="32"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Shysters/Shysters_search.htm">Shyster s</a></font></b></p></td>
      <td colspan="2" valign="top" height="32" width="349"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Titans/Titans_search.htm">Titans</ a></font></b></p></td>
    </tr>
    <tr>
      <td valign="top" colspan="2" height="30"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Wanderers/Wanderers_search.htm">Wande rers</a></font></b></td>
      <td width="349" valign="top" colspan="2" height="30"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/VeniceFC/VeniceFC_search.htm">Venice
        F.C.</a></font></b></td>
    </tr>
    <tr valign="top">
      <td height="30" colspan="2">&nbsp;</td>
      <td width="349" height="30" colspan="2">&nbsp;</td>
    </tr>
  </table>
  <h1>Suspended Player Information</h1>
  <table width="650" border="0" height="71">
    <tr>
      <td width="157" height="45">&nbsp;</td>
      <td width="148" height="45">&nbsp;</td>
      <td width="171" height="45">&nbsp;</td>
      <td width="157" height="45">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
  </table>
  <p>&nbsp;</p>
</div>
<p><img src="/Images/ateammanag.png" width="235" height="46"><img src="/Images/MILLERS5.gif" width="410" height="53"></p>
<p><img src="/Images/Millersmenu5.gif" width="90" height="25">
<p>
<p><a href="/index.html"><img src="/Images/buttonhome.gif" width="93" height="20" border="0"></a></p>
<p><a href="/newLeagueInfo.html"><img src="/Images/button1.gif" width="93" height="29" border="0"></a></p>
<p><a href="/Schedule/SchedulesMain.asp"><img src="/Images/button2.gif" width="93" height="20" border="0"></a></p>
<p><a href="/newFields.html"><img src="/Images/button5.gif" width="93" height="29" border="0"></a></p>
<p><a href="/newTeamContacts.html"><img src="/Images/button6.gif" width="93" height="29" border="0"></a></p>
<p><a href="/newTeamInfo.html"><img src="/Images/button7.gif" width="93" height="29" border="0"></a></p>
<p><a href="/TeamRosters/newTeamRoster.html"><img src="/Images/teamrosterbtn.png" width="93" height="29" border="0"></a></p>
<p><a href="/newStandings.html"><img src="/Images/button3.gif" width="93" height="20" border="0"></a></p>
<p><a href="/Stats/stats_input.asp"><img src="/Images/playerstatbutton.png" width="93" height="29" border="0"></a></p>
<p><a href="/newTeammangers.html"><img src="/Images/Managerbutton.png" width="93" height="29" border="0"></a></p>
<p><a href="/newAdministrators.html"><img src="/Images/adminbutton.png" width="93" height="29" border="0"></a></p>
<p><a href="/newRefs.html"><img src="/Images/refereebutton.png" width="93" height="29" border="0"></a></p>
<p><a href="/newLinks.html"><img src="/Images/soccerlinks.gif" width="86" height="25" border="0"></a></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>

Hi,

I don't fully understand what you are explaining ... the part about showing a user but not working???? but if you PM me the details I will glady go into your live webserver and see if I can get it working.

Christopher

Found this but I dont really know what to do with it or even if its the right thing.

<%
'=========================================================== ==================='

' Application:     Utiity Function
' Author:          ; John Gardner
' Date:         & nbsp;  20th December 2004
' Description:     Used to check the validity of a postcode
' QueryString:     None
' Version:         V1.0

' Required routines:        &nb sp; None
                    
'----------------------------------------------------------- -------------------'

function Check_Postcode (byRef strPostcode)

' This routine checks the value of the form element specified by the parameter
' for a valid postcode.

' The definition of a valid postcode has been taken from:
' http:'www.royalmail.com/docContent/other/Downloadable_Files/ PAF_Digest_Issue_5_0.pdf

' If the element is a valid postcode, the function value is returned as TRUE
' and the postcode is returned in uppercase with the separating space in the
' right place.

  Dim strPostcodeRegExp(2)   ' holds the regular expressions for valid postcodes
  Dim intCount        &nbs p;      ' For loop counter
  Dim strPostcodeCopy        ' Copy of postcode
 
  ' Variables used to hold regular expression object  
  Dim objRegExp, objMatches, objMatch
 
  ' Expression for postcodes: AN NAA, ANN NAA, AAN NAA, and AANN NAA
  strPostcodeRegExp(0) = "^([a-z]{1,2}[0-9]{1,2})([0-9]{1}[abdefghjlnpqrstuwxyz]{2})$"

  ' Expression for postcodes: ANA NAA, and AANA  NAA
  strPostcodeRegExp(1) = "^([a-z]{1,2}[0-9]{1}[a-z]{1})([0-9]{1}[abdefghjlnpqrstuwxyz]{2})$"
 
  ' Exception for the special postcode GIR 0AA
  strPostcodeRegExp(2) = "^(gir)(0aa)$"

  ' Copy the parameter and convert into lowercase
  strPostcodeCopy = Lcase(strPostCode)
 
  ' Assume we're not going to find a valid postcode
  Check_Postcode = false
 
  ' Strip out spaces
  strPostcodeCopy = Replace (strPostcodeCopy, " ", "")
  Check_Postcode = False
 
  Set objRegExp = New RegExp
 
  ' Check the string against valid types of post codes
  For intCount = 0 to Ubound(strPostCodeRegExp)
 
    ' Check next pattern in list
    objRegExp.Pattern =  strPostcodeRegExp(intCount)
    If objRegExp.Test (strPostcodeCopy) Then
   
      ' Post code found. Ensure input parameter is in correct format.
      Set objMatches = objRegExp.Execute (strPostcodeCopy)
      Set objMatch = objMatches(0)
      strPostcodeCopy = Ucase (objMatch.subMatches (0)) & " " &  Ucase (objMatch.subMatches (1))
     
      ' Show that we have found the postcode
      Check_Postcode = True
    End if
  Next
 
  ' Ensure that the uppercase postcode gets returned if valid
  If Check_Postcode Then strPostcode = strPostcodeCopy
 
End Function
%>

regards

John

Okay, thanks, I'm going to change the method tonight and see if it makes a difference

I'll report back

Dave

Ok nevermind that... i got by that wasn't paying attention...

The problem is even before this which i didn't know until now.

I placed the protect tag in a page i called members.aspx

When i go to this page is says ACCESS DENIED etc etc etc.

When i go to login to view this page i get the error..which i DIDNT know because i assumed it was working. This is the error im getting:

Server Error in '/MAP' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable.  Please review the following URL and make sure that it is spelled correctly.

Requested URL: /map/users/aspprotectlogin.aspx

btw it says /map because that is the subfolder within the root folder

More Info in Case Anyone is Interested:

This bug was mentioned by a couple people. The cause of it was never really understood until I recently re-wrote some of the banner code for an upcoming version.

The fix for this bug was very simple. It was just one of those weird situations where code should have worked but did not. I added some code to do it a bit differently and it worked as it should have..

It really still makes no sense to me why it didnt work the way it was, but at least there is a fix.

One is for paypal subscriptions (recurring billing) and the other is for single payments

http://support.cjwsoft.com/forum/forum_posts.asp?TID=185& ; ; ;PN=1

http://support.cjwsoft.com/forum/forum_posts.asp?TID=186& ; ; ;PN=1

You can delete any of the 3rd party payment directories you are not using including the the 2checkout one... (all those folders really are is a copy of the users folder specially modified to handle a certain payment processor)

Just Don't delete the "users" folder though as there are things you do there that you can not do anywhere else..  quite a few things..  editing existing account info, looking up passwords... etc etc

Okay, this also shows at the bottom of the import/export page

I've got the IUSR account with modify permissions on this data folder as well.  Is the "this directory needs change permission" line just a general reminder?

Files are being stored in "D:\missourirealtor.org\members\aspprotect\data\export\\"

This directory needs change permissions for the anonymouse webserver account.
Those permissions can only be set by your hosting company.
These features will not work without those permissions being set.

Hello cwilliams, and thank you for the fast reply.

Well, i have tryed with the ASPImage enabled and disabled, with the same results. I have used gifs and jpgs in the tests.
I have made some different test. Some with uploading the picture over an excisting picture and some as the first picture. Same results.
Everytime, itīs the 2nd thumbnail that wonīt show itself, but the large picture will show, if you press the thumbnail.

I have tryed to look in the code (view_ad.asp), but as far as i can see, everything seems just fine ?!

I know, it wasnīt much help i could give you, but i think i have tryed all the possibilities.

Best regards, Erling

Actually it would because you would just count records for that user that are also active

and yes, users cant delete albums.. they can only turn them off which really means the albums lose their active status

only the admin can truly delete an album the way the code is
(that's just the way I did it for some reason.. I don't remember why)

Hi Chris,

We installed our key onto the live server.

However, since our temp key has expired, we can't access our application on our development machine because the login won't work anywhere except on the live server.

Of course we can access the application on dev, if we remove the aspprotect tags, but if we need to log in to do something unique to the user, then we have a problem.

Can we get another temp key from you? And would there be a better long term solution to this debug/maintanence issue?

--JP

ADODB.Recordset error '800a0cc1'

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

/aspprotect/password_admin/default.asp, line 287

I'm doing an upgrade from an OOOOOOOOOOLD version (not sure if it was 6 or not) and it read my database OK prior to adding a new user. Now I get this error message. I was able to run the password encryption function OK, but I still get this error when I try to view the password_admin stuff. I can log in via the "get_me_in" asp page just fine, but I get the above error.

If I try to log in with my admin account, I get

ADODB.Recordset error '800a0cc1'

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

/aspprotect/password_admin/check_admin_inc.asp, line 166

*****

OK, my question is this... if I retype all the info from the old DB into a brand new one, never before used, that would work, right? I only have 108 users, so that's about an hour of work. Or is there a 5-minute fix that I can try? I've done some messing around that got nowhere and returned all edited files to their original state, with the exceptions of the ones calling the DB location.

I'll start the C&P process and await your reply...

On a side note, I really love the new format and am excited about the new features. I'm not married to upgrading the DB and if copy and paste is faster (I just need first name, last name, username, password, email, and expiration date), then I'm using v.7 that much faster.

I think its great to share a mod.

I will have  few with the new album.

Has any one used the aspmail function to send emails from within your site? If so what did you use as the AspMail_Host string in the connections database?

thank you

I uploaded the files designed for an aspprotect folder at the root of my site (mysite.com/aspprotect) and went to mysite.com/password_admin/get_me_in.asp and receive this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf54 Thread 0x908 DBC 0x90c41dc Jet'.

/aspprotect/scripts/populate_config_variables_inc.asp, line 11

I am assuming my host has still not set rights properly and that is why I receive this error. Am I correct?

 I will definitely recommend hosting company you suggested for our businees site.

Running in parallel for testing is actually a smart way to do it, but the truth is you don't use anything from version 6 except the upgraded database (we have a tutorial on how to upgrade the database)

Version 7 was a drastic change /rewrite to all of the asp files that come with the application. So you will be starting out with fresh version 7 ".asp" files and folders... You will also find that once you get version 7 running that editing certain things like the look of the users area and the login screens is much easier to do.

That being said any of your own ".asp" pages that you protect use the same protection code they always did, so there will be no drastic changes needed there when you do finalize the upgrade.



If using MSACCESS as the database I suggest installing the application somewhere in your web and using a fresh ASPProtect 7 database. Once you are familiar with the setup and everything is working fine. Attempt the database conversion and when your done stick your converted database in there and see if everything is ok.

Also, if you already purchased the application download the latest version before doing the install. It's the same download URL. If you don't have it email me and I can hook you up. I have added some new features and fixed a couple minor things since it's release.

So far the feedback on version 7 has been awesome..

I made the changes like you suggested, but now the page just times out before even loading. 

<%
ConnectionString = "DBQ=D:\clients\rklarman\DrWeisbergUsers.mdb;Driver={Microso ft Access Driver (*.mdb)}"
DatabaseType = "MSACCESS"
%>

ok, 1st we need to rule out the #1 reason people sometimes think that is not working.

Is is set up never to allow the same IP to increment the count more than once in a row so when testing it is real easy to think the count isn't working because unless you can change your ip you can not increment the count more than once per album

It's a poor mans spam abuse type of deal..
For the most part it will keep some Joker from hitting refresh 100 times and inflating the count of an album.

Do you think that is possible what is happening ?

Also, here is an older thread about the same issue?
http://support.cjwsoft.com/code/moreinfo54-2.htm

You really can not do something like that. You can not use client side code to change a server side session variable.

To make changes server side a form must be submitted or a link clicked on to another page. Then you can do whatever you like but you cant have an onlci event update a session variable like that.

Though I am not sure of exactly what you are trying to do I think you'll need to go about things a little differently.