YAF.net communication with ASP.NET applications

I am going to host a website only for my family and extended family. right now it is local on my computer. I downloaded and installed YetAnotherForum.net and made it a sub-directory called "forums". I already set up the database. I want to know how I would read it from the database so that my family can use their usernames in the forum in the rest of the site, and, if they have any replys to threads they are subscribed to, it would show the 5 newest. If you need to analyze the forum for yourself, the name probably parsed itself as a link, so you should be able to click that. Thank you so much for all of yor help!
Woof Woof

 

does this forum use the ASP.NET Membership API?

 

I wish it did. It has it's own SQL database. I would know how to do it if it had the standard.

 

http://yetanotherforum.net/
If you can help me I wont be mad at u nemore

 

Erm.. the membership API isn't a database. It's a provider that allows access to the members info in the database via an API. So look in the web.config for the membership provider. If it's using it, then you're golden.

 

No. It does not use the API, homie! It has an SQL database named forum.sql which stores everything. I opened in VWD and it says that the usernames and passwords are stored in a table called yaf_users and usernames has a header user_id and password has a header passwords. Passwords is an MD5 hash. I am 100% sure it's MD5. Oh, and it is not a subdirectory anymore. The main website right now is on port 80 and the forum is on port 8080. The database can be accesed by both. I made an inetpub folder on my C:\ root. The main part of the website is located in C:\inetpub\main. The forum is located in C:\inetpub\forum. The databse is located in C:\inetpub\forum, so the connection string's location will be C:\inetpub\forum\App_Data\forum.sql even in the main website part.
Thanks!
zDawg32

 

a .SQL file is NOT a database. It is an SQL script file. The database will be an .MDF.

At any rate, if they have their own schema for things, I would write my own membership provider that mapped to their schema and you should have an easy way to get the details out an across your site.
see: http://www.asp.net/learn/videos/video-189.aspx

 

I ment MDF. Idk y I said SQL. Hmmmmm. Regardless, thank you.

 

That didn't work. I need to connect to C:\inetpub\forum\forum.mdf
Table: yaf_user then columns:Name is for username and password is for password
Thanks

 

This is where you need to learn ADO.NET

 

too confusing

 

You have to start someplace.

 

i can do my own auth, if you tell me how to convert string to MD5 hash.

 

http://msdn.microsoft.com/en-us/library/system.security.cryptography.md5.aspx

 

I know how to do the cookies and everything, but how would I check if the username and password's hash are in the same row?

 

look at the schema and write a T-SQL statement for it.

 

???? lookat the what?

 

???? lookat the what? i'm still a noobie.........