SOME ISSUES I WROTE DOWN

CMPUT391Image / proj1

0 stars 0 forks source link

SOME ISSUES I WROTE DOWN #3

Open heykevin opened 9 years ago

heykevin commented 9 years ago

Issues:

Make sure all pages check userName and redirect to login if null
Consistently use db.java class to connect to database
Groups should be it's own menu, delete/add/edit are then submenus
Top five unique users for browse
- Create new table, views -> when click on big pic -> store user/increment count into views table.
Group privacy details on search
OLAP dating/chart - see eclass forum
Logout errywhere

heykevin commented 9 years ago

%%%%%%% stuff

heykevin commented 9 years ago

Fix score formula, add index updating

heykevin commented 9 years ago

Make sure sessions close

heykevin commented 9 years ago

check inclusive on search

telbohtimy commented 9 years ago

You should be able to go to browse gallery and the sql statements for top and all viewable

telbohtimy commented 9 years ago

add the sql*

telbohtimy commented 9 years ago

Here is an sql statement that gets all viewable pictures "select photo_id from images where permitted in( select group_id from groups where user_name='"+userName+"' UNION select group_id from group_lists where friend_id='"+userName+"') UNION select photo_id from images where permitted='2' and owner_name='"+userName+"'"

I didnt add it to the code yet in case you have something better