Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 mod search.asp to display member info.		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

silverman
Starting Member

4 Posts
Posted - 27 February 2005 :  18:46:21  Show Profile
Hello,

I used snitz for many years now.
Snitz is great for forums, but lack
code to be a dating site.

One day I did a search and I found this
cool dating site by Shaggy.

http://woo.ie/search.asp?action=quick

Shaggy would you be so kind to turn
woo.ie search.asp code into a mod.

I really like what you did with the
Quick Search code.

help please


Thanks,












Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 28 February 2005 :  07:49:52  Show Profile
That's not going to integrate directly into Snitz as the majority of Woo.ie is custom built from scratch. If it's any help, though, the SELECT (slimmed down a bit to remove the non-Snitz stuff) for the quick search looks a little something like this (replacing [FIELDS] with what you want to select from your members table):
strSexulaity=chkstring(request.form("gender1"),"sqlstring")
strGender=chkstring(request.form("gender2"),"sqlstring")
if strGender<>strSexuality then strSexuality="Homosexual" else strSexuality="Heterosexual"
set rs=my_conn.execute("SELECT [FIELDS] FROM MEMBERS,PHOTOS WHERE MEMBER_ID<>"&MemberId&" AND M_STATUS=1 AND M_SEX='"&strGender&"' AND M_SEXUALITY<>'"&strSexuality&"' AND M_DOB<='"&(left(DateToStr(strForumTimeAdjust),8)-(clng(request.form("age1"))*10000))&"' AND M_DOB>='"&(left(DateToStr(strForumTimeAdjust),8)-(clng(request.form("end"))*10000)-9999&"' AND M_STATE='"&chkstring(request.form("state"),"sqlstring")&"' ORDER BY M_LASTHEREDATE DESC")
And just FYI, Snitz was never intended to be used as the base code for a dating site!

Oh, M_SEXUALITY above is a custom field you'll need to add to your members table.
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

silverman
Starting Member

4 Posts
Posted - 01 March 2005 :  00:54:39  Show Profile
Hello Shaggy,

Thanks alot for the code.
Forgot to tell you, I am not a computer programmer.
I am not sure where to add your code.
Its way too hard to understand your code.
I guess I will have to wait until someone made a mod for snitz.

once again thanks.

bye
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 01 March 2005 :  08:23:32  Show Profile
No offense intended here, silver, but if you're not a programmer then maybe you should be thinking a little smaller than a dating site for your first project; you gotta learn to crawl before you can learn to walk. Start with the base code and spend a couple of weeks playing around with it to try and teach yourself ASP and back it up with a few online resources such as W3Schools.
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07