# |
Sep 23rd 2009, 08:58 |
Phally |
for instance that i chose to have a subject for the conversation and not for every message |
# |
Sep 23rd 2009, 08:57 |
alkemann |
afaics all those features can be implemented with 1 table and 1 row per message, i dont see why you need to use 3 tables and 4 rows to do it d |
# |
Sep 23rd 2009, 08:56 |
Phally |
not really, i just explained the entire inbox depends on it |
# |
Sep 23rd 2009, 08:55 |
alkemann |
2 conversations_users, 1 message, 1 converasation for one system message because someone could want to expand this to be a convestation between multiple users? |
# |
Sep 23rd 2009, 08:53 |
alkemann |
i guess i still dont understand then |
# |
Sep 23rd 2009, 08:53 |
Phally |
because this isn't? |
# |
Sep 23rd 2009, 08:53 |
alkemann |
but if they need a forum or a something like a google group, why would they nto use that instead? |
# |
Sep 23rd 2009, 08:53 |
Phally |
yet i failed, it seems :') |
# |
Sep 23rd 2009, 08:52 |
Phally |
i designed it to make it useful to anybody |
# |
Sep 23rd 2009, 08:52 |
Phally |
i'm not looking only at the bakery |
# |
Sep 23rd 2009, 08:51 |
alkemann |
what flood are you expected for this? moderators will give feedback and some clueless noobs will ask for 1on1 support from authors. or so i predict |
# |
Sep 23rd 2009, 08:50 |
Phally |
sure it is |
# |
Sep 23rd 2009, 08:49 |
alkemann |
reply_to_message_id field, null = first message, inbox could list only these, marking as new if a child message has new ta. it is possible |
# |
Sep 23rd 2009, 08:48 |
Phally |
i'd say, check it out first ;) |
# |
Sep 23rd 2009, 08:48 |
alkemann |
chill man, lets get some input from someone else |
# |
Sep 23rd 2009, 08:47 |
Phally |
very well, hold on while i backup it, normal IM didn't have a lot of happy users (where i'm from) because of the flood, there is no way to make an inbox like this with only one table... you can do a group by, but what title to use etc.. too bad of the work i put into that though, the system worked really nice |
# |
Sep 23rd 2009, 08:39 |
alkemann |
with collaborative articles and comments etc, there should be plenty oppertunities for multi-participant discusssions |
# |
Sep 23rd 2009, 08:37 |
alkemann |
tbh, unless you can come up with a better reason than "it would be nice to have or extend in the future" i would reather keep it as simple as possible. ie simple im system |
# |
Sep 23rd 2009, 08:37 |
Phally |
but if you wanted me to make e-mail, you just had to ask that... |
# |
Sep 23rd 2009, 08:36 |
Phally |
sure, i still find this way nicer, though one table will become a mess of duplicate unnormalized titles etc unless you decide every message needs a new title |
# |
Sep 23rd 2009, 08:32 |
alkemann |
yea i realise ur not using habtm, doesnt change anything |
# |
Sep 23rd 2009, 08:31 |
alkemann |
still feature that can be implemented with one table |
# |
Sep 23rd 2009, 08:31 |
Phally |
it was :p |
# |
Sep 23rd 2009, 08:31 |
Phally |
alkemann: http://thechaw.com/bakery/source/branches/usersplugin/plugins/users/models/conversation.php#numbers |
# |
Sep 23rd 2009, 08:30 |
Phally |
i made the 'join'table to paginate the inbox and to order new messages etc |
# |
Sep 23rd 2009, 08:30 |
alkemann |
so the conversations_users isnt a habtm between messages and users? |
# |
Sep 23rd 2009, 08:29 |
Phally |
well that isn't implemented, just see it as possible, i was just making that up because you mentioned habtm :p |
# |
Sep 23rd 2009, 08:28 |
alkemann |
but u can make IM and add conversation with multiple participants an optional feature at least? |
# |
Sep 23rd 2009, 08:25 |
Phally |
one, yeah, if you want IM |
# |
Sep 23rd 2009, 08:24 |
Phally |
but later on i decided to make three, because somehow it made more sense (still does to me) |
# |
Sep 23rd 2009, 08:24 |
alkemann |
but one is enough |
# |
Sep 23rd 2009, 08:24 |
Phally |
at first i started with two tables :p |
# |
Sep 23rd 2009, 08:23 |
alkemann |
the feature sounds nice, im jsut saying u dont need 3 tables to do it |
# |
Sep 23rd 2009, 08:23 |
Phally |
i remember thinking about this :p |
# |
Sep 23rd 2009, 08:23 |
Phally |
just make it up and running and see what i mean :p |
# |
Sep 23rd 2009, 08:22 |
Phally |
this way the messages wont be in the mailbox, but conversations |
# |
Sep 23rd 2009, 08:22 |
alkemann |
a conversation_id could do that equally well |
# |
Sep 23rd 2009, 08:22 |
Phally |
habit |
# |
Sep 23rd 2009, 08:21 |
Phally |
alkemann: yeah, but then your mailbox will be flooded with messages about the same subject |
# |
Sep 23rd 2009, 08:21 |
Phally |
the users_plugin_conversations_users isn't just a simple join table |
# |
Sep 23rd 2009, 08:21 |
alkemann |
sender_id, receiver_id, new could do that |