View Single Post
  #10 (permalink)  
Old 04-22-2008, 07:12 PM
RichAtVNS's Avatar
RichAtVNS RichAtVNS is offline
WebProWorld Member
 

Join Date: Jul 2003
Location: New York, USA
Posts: 62
RichAtVNS RepRank 1
Thumbs up Re: Need help with making a website

Ok now I get to use my 15 years as an independant systems designer, and Masters in compiler construction and the fact that I have programmed here... vs all these SEOs LOL

...

This is about the easiest thing I have ever seen to program in ASP and using a central processor filter.

1) An ODBC complient database
2) Microsofts personal webserver
3) and the most rudimentary knowledge of ASP

are all you will need to implement them.

Simply make an orthogonal database.
1 table of the users (unique id is auto incremented on insertion)
1 table of the daily views (pairs of user id that was viewed and user who viewed it)
1 table of the details the user will be storing on thier own personal pages kept in a memo field.
1 table of when was the last time the daily views table was cleared.
1 session variable of your id after you login.

Here's the pseudo code logic.
one function called at the top of every user page (place in an include file).
Every time a view goes on use the session variable and the page id
you check the date time to see if the daily views table was last cleared over 24 hours ago.
If it was clear the table and update the date time to 12:00 midnight (start of the day).
After that check to see if the user already has viewed that page (has an entry pair in the daily views table., If not add it.

Now you need 2 sql queries (if you use the wizards in access this is a canned query) to get a count of the records in your daily view table by ID of visitor and a second one for count of records by viewee's page.

both can be called and displayed on separate asp pages from 3 lines of code.

Need any more help just ring me up....


THAT WAS FUN.... considering I used to charge $125 an hour when I consulted you just got a lot! LOL

PS: Don't know asp this is one of the best online FREEEEEEEE tutorial books out there
LearnAsp.com - ASP ASP.net Free Lessons

Last edited by RichAtVNS : 04-22-2008 at 07:18 PM.
Reply With Quote