[thesite] alternate color schemes
rudy
r937 at interlog.com
Sun Jan 21 11:16:31 CST 2001
sorry i bailed on that conversation last night jeff, i was pooped and had
to get some sleep
gettin' old, ya know...
anyhow...
> ... at least one of the schemes is selected as a favorite
> no matter what. this should be handled by the tool that
> facilitates the user's interaction with schemes and
> adding/editing/deleting favorites.
+1
> the easy way would generate *tons* of data rather
> quickly if this system gets used as much as i think
> it'll get used.
agree in principle, but it's no worse than the ratings records
what will we have more of, ratings or schemes?
no, don't answer that....
> it also is akin to plagiarizing another user's hardwork.
they could protect it with a high enough PRIV
which reminds me, any query that does privilege checking should use an OR
condition on the user himself -- i.e. where the viewer's privilege is equal
to or higher than the item's priv code, OR the viewer is the owner of the
item
that way i can set something as PRIV=4 (only evolt god admins can see) and
yet still see it myself
>scheme_favs
>
>pk id numeric(8) NOT NULL
>fk userid numeric(8) NOT NULL
>fk schemeid numeric(8) NOT NULL
>
>it's super easy to enforce a favorite now. if they don't pick any then we
>insert the schemeid of the default evolt scheme as their favorite.
DUDE!!
that rocks
let's give it a bit more thought, though, because we also have the foreign
key from scheme to user (i.e. the "owner" of the scheme)
the question is, do we need a FAV column in the scheme table, or will this
table do the trick
gotta go play football in the snow now
More information about the thesite
mailing list