| Author |
 Topic  |
|
slemieux
Junior Member
USA
234 Posts |
|
|
blkrogue
New Member
USA
79 Posts |
 Posted - 08 August 2000 : 11:31:36
|
If anyone is interested I could post the db_profile_setup.asp page I wrote to upgrade the MEMBERS table with all the extra fields. This way you don't have to take the database offline to make the changes.
So far it's only an Access version and I wanna test it again, but if you're interested let me know.
Blkrogue
In the darkness of my soul a sparkling light has appeared |
 |
|
|
Lord Maverick
New Member
Norway
92 Posts |
Posted - 08 August 2000 : 11:42:44
|
blkrogue,
I'd really like this setup...
Is it the same code that goes with both Acc97 and Acc2000?
|
|
|
|
heptite
Average Member
USA
547 Posts |
Posted - 08 August 2000 : 12:26:03
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Is it the same code that goes with both Acc97 and Acc2000?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
The version of Access should make no difference to this code.
Sue
<center><font color=purple>
ASPDiva Forum - http://www.aspdiva.com/forum/default.asp
</font id=purple></center> |
|
|
|
heptite
Average Member
USA
547 Posts |
Posted - 08 August 2000 : 12:27:18
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
If anyone is interested I could post the db_profile_setup.asp page I wrote to upgrade the MEMBERS table with all the extra fields. This way you don't have to take the database offline to make the changes.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Please do post! Thanks in advance.
<center><font color=purple>
ASPDiva Forum - http://www.aspdiva.com/forum/default.asp
</font id=purple></center> |
|
|
|
animedj
Junior Member
USA
190 Posts |
|
|
webshorts
New Member
USA
96 Posts |
|
|
slemieux
Junior Member
USA
234 Posts |
Posted - 08 August 2000 : 18:00:24
|
Thanks animedj! That was a great idea!
Nope Daniel. Wrong LeMieux. Although I do live outside of Seattle Washington <img src=icon_smile.gif border=0 align=middle>
|
|
|
|
blkrogue
New Member
USA
79 Posts |
Posted - 09 August 2000 : 03:38:59
|
just in case anyone was still interested in the code:
http://www.geocities.com/blkrogue99/forumhacks/db_profile_setup.zip (or just go to http://www.geocities.com/blkrogue99/forumhacks/ to see the list of zips)
It makes the changes needed for the extended profile to your database step by step (names taken from scot's install.txt) and also renames the M_RECIEVE_MAIL field (last one in the list, so if it doesn't exists it'll give you an error, but it's no critical error.
Sorry if the link is posted too late and I kept you waited.
Blkrogue
In the darkness of my soul a sparkling light has appeared
Edited by - blkrogue on 09 August 2000 03:40:25 |
|
|
|
phishyDev
Starting Member
USA
6 Posts |
Posted - 13 August 2000 : 14:16:15
|
Am I missing something? How about the changes to the register.asp page so that the extended profile can be filled out at registration time.
Steve |
|
|
|
slemieux
Junior Member
USA
234 Posts |
Posted - 29 August 2000 : 13:13:19
|
Yep your missing something <img src=icon_smile.gif border=0 align=middle>
register.asp includes inc_profile.asp, since the changes are made in in_profile.asp they don't need to be done twice.
Scott LeMieux |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 29 August 2000 : 21:03:19
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
register.asp includes inc_profile.asp, since the changes are made in in_profile.asp they don't need to be done twice.
Scott LeMieux
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Hey scott,
What about the initial registration? isn't the insert to the database done in register.asp?
In order to use your profile hack, I had to go into the register.asp and add the field and values to sql insert string myself.
It's a great Hack btw. and I like the layout of members_profile.
- Alan <img src="http://smilecwm.tripod.com/net3/smileJap.gif" border=0>
<pre id=code><font face=courier size=2 id=code><%On Error goto Hell%></font id=code></pre id=code>
Edited by - aznknight on 29 August 2000 23:48:28 |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 29 August 2000 : 22:52:54
|
Anyone know why this code is at the top of register.asp?
<pre id=code><font face=courier size=2 id=code>
<head>
<meta http-equiv="Refresh" content="2; URL=<% =Request.Form("refer")%>">
</head>
</font id=code></pre id=code>
inc.top writes the HTML head.
Oh, yes the SQL for the DB insert is in register.asp
======
Doug G
======
Edited by - Doug G on 29 August 2000 22:53:57 |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 29 August 2000 : 23:21:12
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Anyone know why this code is at the top of register.asp?
<pre id=code><font face=courier size=2 id=code>
<head>
<meta http-equiv="Refresh" content="2; URL=<% =Request.Form("refer")%>">
</head>
</font id=code></pre id=code>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Yeah I know . I just figured it out like half an hour ago <img src=icon_smile_big.gif border=0 align=middle> looking at the registration process in the code.
That code is there so that the page automatically redirects to the page the user was on right before s/he hit the register button.
Say a new user enter your forum and is reading topic "blah blah" in category "MY Category". He then decides to register so he can post, so he hits register which takes you to policy.asp. In policy.asp, when that user clicks submit, that page takes the server variable http-reffer and places it in hidden field "refer" in the form and goes to register.asp. When the user finishes registration, the page redirects to the "blah blah" topic that user was on.
I think this works pretty well and makes the forum more user friendly <img src=icon_smile.gif border=0 align=middle>.
- Alan <img src="http://smilecwm.tripod.com/net3/smileJap.gif" border=0>
Edited by - aznknight on 29 August 2000 23:23:20 |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 30 August 2000 : 00:48:17
|
Well, just as I was thinking FrontPage was OK, here it goes and screws up a page if you use it.
Referring to my previous post, the distributed code for 3.1 B2 <b>does not</b> contain the following:
<pre id=code><font face=courier size=2 id=code>
<head>
<meta http-equiv="Refresh" content="2; URL=<% =Request.Form("refer")%>">
</head>
</font id=code></pre id=code>
The W3C specification for HTML 4.01 has this to say about <META> tags:
"User agents are not required to support meta data mechanisms. For those that choose to support meta data, this specification does not define how meta data should be interpreted."
Which I read to say "if you put a <META> tag outside the header, who knows what will happen". It seems most browsers will interpret a META Refresh tag.
The Frontpage editor, however, looks at register.asp, sees a <META> tag way down in the code but doesn't see a <HEAD> tag anywhere (it's in the included inc_top.asp), so in it's infinite wisdom moves the <META> tag to the top of the page and wraps it in <head> tags!!!!! <img src=icon_smile_evil.gif border=0 align=middle>
I guess I won't be as quick to use FP2K to edit asp pages in the future, although it's technically not violating any rules by what it's doing it will mess up register.asp.
I checked 3 times, the distributed copy of register.asp doesn't have the <head> tags, but they display as soon as I open the HTML view of register.asp in FP2K. FP doesn't save this change, though, until you do some other edit to the page!!!
It's possible InterDev may have some similar glitches but I believe it's a more accurate asp editor. The big difference is that FP can't (or doesn't) interpret the asp code in a page, and InterDev can.
======
Doug G
======
Edited by - Doug G on 30 August 2000 00:49:44 |
|
|
|
slemieux
Junior Member
USA
234 Posts |
Posted - 30 August 2000 : 01:40:55
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hey scott,
What about the initial registration? isn't the insert to the database done in register.asp?
In order to use your profile hack, I had to go into the register.asp and add the field and values to sql insert string myself.
It's a great Hack btw. and I like the layout of members_profile.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Well I'll be!! You are correct! lol I orignially did this when registration was done in a popup.. guess I should keep my eyes open further <img src=icon_smile_blackeye.gif border=0 align=middle> Thanks for the compliment, glad you like this<img src=icon_smile.gif border=0 align=middle>
Scott LeMieux |
|
|
|
Topic |
|
Topic Locked
