MOD mini modifications
[euphorik.git] / modules / erl / euphorik_protocole.erl
1 % coding: utf-8
2 % Copyright 2008 Grégory Burri
3 %
4 % This file is part of Euphorik.
5 %
6 % Euphorik is free software: you can redistribute it and/or modify
7 % it under the terms of the GNU General Public License as published by
8 % the Free Software Foundation, either version 3 of the License, or
9 % (at your option) any later version.
10 %
11 % Euphorik is distributed in the hope that it will be useful,
12 % but WITHOUT ANY WARRANTY; without even the implied warranty of
13 % MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 % GNU General Public License for more details.
15 %
16 % You should have received a copy of the GNU General Public License
17 % along with Euphorik. If not, see <http://www.gnu.org/licenses/>.
18 %
19 % Ce module gére les différents messages envoyés par le client (javascript) via AJAX.
20 % Les messages donnés ainsi que les réponses sont au format JSON.
21 % @author G.Burri
22
23
24 -module(euphorik_protocole).
25 -export([
26 register/2,
27 login/2,
28 logout/1,
29 profile/1,
30 wait_event/1,
31 put_message/1,
32 ban/1,
33 slap/1,
34 put_troll/1,
35 mod_troll/1,
36 del_troll/1,
37 unban_ip/1,
38 list_banned_ips/1,
39 erreur/1
40 ]).
41 -include("../include/euphorik_bd.hrl").
42 -include("../include/euphorik_defines.hrl").
43
44
45 % Une utilisateur s'enregistre avec un tuple {Login, Password}.
46 register([{login, Login}, {password, Password}], IP) ->
47 Can_register = euphorik_bd:can_register(IP),
48 if Can_register ->
49 case euphorik_bd:user_by_login(Login) of
50 {ok, _} ->
51 erreur("Login déjà existant");
52 _ ->
53 User = euphorik_bd:nouveau_user(Login, Password, generer_cookie()),
54 euphorik_bd:update_ip(User#user.id, IP),
55 json_reponse_login_ok(User)
56 end;
57 true ->
58 erreur_register_flood()
59 end;
60 % Enregistrement sans {Login, Password}
61 register([], IP) ->
62 Can_register = euphorik_bd:can_register(IP),
63 if Can_register ->
64 User = euphorik_bd:nouveau_user("<nick>", generer_cookie()),
65 euphorik_bd:update_ip(User#user.id, IP),
66 json_reponse_login_ok(User);
67 true ->
68 erreur_register_flood()
69 end.
70
71 erreur_register_flood() ->
72 erreur("Trop de register (flood)").
73
74
75 % Un utilisateur se logge (avec un couple {login, mot de passe})
76 login([{login, Login}, {password, Password}], IP) ->
77 loginUser(euphorik_bd:user_by_login_password(Login, Password), IP);
78 % Un utilisateur se logge (avec un cookie)
79 login([{cookie, Cookie}], IP) ->
80 loginUser(euphorik_bd:user_by_cookie(Cookie), IP).
81
82 loginUser({ok, User}, IP) ->
83 euphorik_bd:update_ip(User#user.id, IP),
84 euphorik_bd:update_date_derniere_connexion(User#user.id),
85 json_reponse_login_ok(User);
86 loginUser(_, _) ->
87 % ajoute un délais d'attente
88 timer:sleep(?TEMPS_ATTENTE_ERREUR_LOGIN),
89 erreur("Couple login/pass introuvable").
90
91
92 % Renvoie un string() représentant un cookie en base 36. Il y a 10^32 possibillités.
93 generer_cookie() ->
94 {A1, A2, A3} = now(),
95 random:seed(A1, A2, A3),
96 erlang:integer_to_list(random:uniform(math:pow(10, 32)), 36).
97
98
99 % Un utilisateur se délogge.
100 logout(_) ->
101 do_nothing.
102
103
104 % Modification du profile.
105 profile(
106 [
107 {cookie, Cookie},
108 {login, Login},
109 {password, Password},
110 {nick, Pseudo},
111 {email, Email},
112 {css, Css},
113 {nick_format, Nick_format_str},
114 {view_times, View_times},
115 {view_tooltips, View_tooltips},
116 {main_page, Main_page},
117 {conversations, {array, Conversations_json}}
118 ]
119 ) ->
120 % est-ce que les messages auquel on répond existent ?
121 Conversations = lists:foldr(
122 fun({struct, [{root, Root}, {page, Page}]}, Acc) ->
123 Message_existe = euphorik_bd:message_existe(Root),
124 if Message_existe ->
125 [{Root, Page} | Acc];
126 true ->
127 Acc
128 end
129 end,
130 [],
131 Conversations_json
132 ),
133 % TODO : pas très beau, mieux vaut construire un #user
134 case euphorik_bd:set_profile(
135 Cookie,
136 Login,
137 Password,
138 Pseudo,
139 Email,
140 Css,
141 list_to_atom(Nick_format_str),
142 View_times,
143 View_tooltips,
144 Main_page,
145 Conversations) of
146 ok ->
147 json_reponse_ok();
148 login_deja_pris ->
149 erreur("Login déjà pris");
150 _ ->
151 erreur("Impossible de mettre à jour le profile")
152 end.
153
154
155 % Renvoie les messages appropriés.
156 % last_message id et cookie sont facultatifs
157 wait_event([{page, "chat"} | Data]) ->
158 % traitement des inputs
159 Cookie = case lists:keysearch(cookie, 1, Data) of {value, {_, C}} -> C; _ -> inconnu end,
160 Last_message_id = case lists:keysearch(last_message_id, 1, Data) of {value, {_, Id}} -> Id; _ -> 0 end,
161 {value, {_, Message_count}} = lists:keysearch(message_count, 1, Data),
162 Main_page = case lists:keysearch(main_page, 1, Data) of {value, {_, P}} -> P; _ -> 1 end,
163 Troll_id = case lists:keysearch(troll_id, 1, Data) of {value, {_, T}} -> T; _ -> 0 end,
164 {value, {_, {array, Conversations_json}}} = lists:keysearch(conversations, 1, Data),
165 Racines_conversations = lists:map(
166 fun({struct, [{root, Racine}, {page, Page} | Reste]}) ->
167 Last_mess_conv = case Reste of [{last_message_id, L}] -> L; _ -> 0 end,
168 {Racine, Page, Last_mess_conv}
169 end,
170 Conversations_json
171 ),
172 User = case euphorik_bd:user_by_cookie(Cookie) of
173 {ok, U} -> U;
174 _ -> inconnu
175 end,
176 case {mnesia:subscribe({table, minichat, detailed}), mnesia:subscribe({table, troll, detailed})} of
177 {{error, E}, _} -> E;
178 {_, {error, E}} -> E;
179 _ ->
180 % attente d'événements
181 R = wait_event_page_chat(User, Racines_conversations, Message_count, Last_message_id, Main_page, Troll_id),
182 mnesia:unsubscribe({table, minichat, detailed}),
183 mnesia:unsubscribe({table, troll, detailed}),
184 R
185 end;
186 wait_event([{page, "admin"}, {last_troll, Last_troll}]) ->
187 case wait_event_page_admin(Last_troll) of
188 banned_ips_refresh ->
189 {struct,
190 [
191 {reply, "banned_ips_refresh"}
192 ]
193 };
194 {mod, Troll} ->
195 {struct,
196 [
197 {reply, "troll_modified"},
198 {troll_id, Troll#troll.id},
199 {content, Troll#troll.content}
200 ]
201 };
202 {add, Trolls} ->
203 {struct,
204 [
205 {reply, "troll_added"},
206 {trolls, {array,
207 lists:map(
208 fun(T) ->
209 {ok, User} = euphorik_bd:user_by_id(T#troll.id_user),
210 {struct,
211 [
212 {troll_id, T#troll.id},
213 {content, T#troll.content},
214 {author, User#user.pseudo},
215 {author_id, User#user.id}
216 ]
217 }
218 end,
219 Trolls
220 )
221 }}
222 ]
223 };
224 {del, Troll_id} ->
225 {struct,
226 [
227 {reply, "troll_deleted"},
228 {troll_id, Troll_id}
229 ]
230 };
231 _ ->
232 erreur("timeout")
233 end;
234 wait_event(_) ->
235 erreur("Page inconnue").
236
237
238 wait_event_page_chat(User, Racines_conversations, Message_count, Last_message_id, Main_page, Troll_id) ->
239 % est-ce que le troll est à jour ?
240 case euphorik_bd:current_troll() of
241 Current when is_record(Current, troll), Current#troll.id =/= Troll_id ->
242 {struct, [
243 {reply, "new_troll"},
244 {troll_id, Current#troll.id},
245 {message_id, euphorik_bd:message_id_associe(Current#troll.id)},
246 {content, Current#troll.content}
247 ]};
248 _ ->
249 % est-ce qu'il y a des nouveaux messages ?
250 case euphorik_minichat_conversation:conversations(Racines_conversations, Message_count, Last_message_id, Main_page) of
251 vide ->
252 wait_event_bd_page_chat(),
253 wait_event_page_chat(User, Racines_conversations, Message_count, Last_message_id, Main_page, Troll_id);
254 Conversations ->
255 % accrochez-vous ca va siouxer ;)
256 {struct, [
257 {reply, "new_messages"},
258 {conversations, {array,
259 lists:map(
260 fun({Conv, Plus}) ->
261 {struct, [
262 {last_page, not Plus},
263 {messages, {array,
264 lists:map(
265 fun({Mess, Repond_a}) ->
266 Est_proprietaire = User =/= inconnu andalso User#user.id =:= Mess#minichat.auteur_id,
267 A_repondu_a_message = User =/= inconnu andalso euphorik_bd:a_repondu_a_message(User#user.id, Mess#minichat.id),
268 Est_une_reponse_a_user = User =/= inconnu andalso euphorik_bd:est_une_reponse_a_user(User#user.id, Mess#minichat.id),
269 {ok, User_mess } = euphorik_bd:user_by_id(Mess#minichat.auteur_id),
270 {struct, [
271 {id, Mess#minichat.id},
272 {user_id, User_mess#user.id},
273 {date, format_date(Mess#minichat.date)},
274 {system, Mess#minichat.auteur_id =:= 0},
275 {owner, Est_proprietaire},
276 {answered, A_repondu_a_message},
277 {is_a_reply, Est_une_reponse_a_user},
278 {nick, Mess#minichat.pseudo},
279 {login, User_mess#user.login},
280 {content, Mess#minichat.contenu},
281 {answer_to, {array, lists:map(
282 fun(Id_mess) ->
283 {ok, M} = euphorik_bd:message_by_id(Id_mess),
284 {ok, User_reponse} = euphorik_bd:user_by_mess(M#minichat.id),
285 {struct, [{id, M#minichat.id}, {nick, M#minichat.pseudo}, {login, User_reponse#user.login}]}
286 end,
287 Repond_a
288 )}},
289 {ek_master, User_mess#user.ek_master}
290 ]}
291 end,
292 Conv
293 )
294 }}
295 ]}
296 end,
297 Conversations
298 )
299 }}
300 ]}
301 end
302 end.
303
304
305 % Attend un événement lié à la page 'chat'.
306 wait_event_bd_page_chat() ->
307 receive % attente d'un post
308 {mnesia_table_event, {write, minichat, _Message, [], _}} ->
309 ok;
310 {mnesia_table_event, {write, troll, Troll, [Old_troll | _], _}} when Troll#troll.date_post =/= undefined, Old_troll#troll.date_post == undefined ->
311 ok;
312 {tcp_closed, _} ->
313 exit(normal);
314 _ ->
315 wait_event_bd_page_chat()
316 % 60 minutes de timeout (on ne sais jamais)
317 % Après 60 minutes de connexion, le client doit donc reétablir une connexion
318 after 1000 * 60 * 60 ->
319 timeout
320 end.
321
322
323 % Attent un événement concernant la page admin
324 % Renvoie les trolls manquants posté après Last_id ou banned_ips_refresh.
325 % Si pas de trolls alors attend un événement tel qu'un ajout, une modification ou une suppression.
326 % renvoie :
327 % {mod, Troll}
328 % ou {add, [Trolls]}
329 % ou {del, Troll_id}
330 % ou banned_ips_refresh
331 % ou timeout
332 wait_event_page_admin(Last_id) ->
333 case {mnesia:subscribe({table, troll, detailed}), mnesia:subscribe({table, ip_table, detailed})} of
334 {{error, E}, _ } -> E;
335 {_, {error, E}} -> E;
336 _ ->
337 R = case euphorik_bd:trolls(Last_id) of
338 [] -> % pas de trolls
339 wait_event_page_admin();
340 Trolls ->
341 {add, Trolls}
342 end,
343 mnesia:unsubscribe({table, troll, detailed}),
344 mnesia:unsubscribe({table, ip_table, detailed}),
345 R
346 end.
347
348 wait_event_page_admin() ->
349 % s'il n'y a pas de trolls que l'utilisateur n'a pas connaissance alors on attend un événement
350 receive
351 % cas où un troll est choisit comme courant
352 {mnesia_table_event, {write, troll, Troll, [Old_troll | _], _}}
353 when Old_troll#troll.date_post =:= undefined, Troll#troll.date_post =/= undefined ->
354 {del, Troll#troll.id};
355 {mnesia_table_event, {write, troll, Troll, [_Old_troll | _], _}} ->
356 {mod, Troll};
357 {mnesia_table_event, {write, troll, Troll, [], _}} ->
358 {add, [Troll]};
359 {mnesia_table_event, {delete, troll, {troll, Id}, _, _}} ->
360 {del, Id};
361 {mnesia_table_event, {write, ip_table, IP, [Old_IP | _], _}}
362 when Old_IP#ip_table.ban =/= IP#ip_table.ban; Old_IP#ip_table.ban_duration =/= IP#ip_table.ban_duration ->
363 banned_ips_refresh;
364 {tcp_closed, _} ->
365 exit(normal);
366 _ ->
367 wait_event_page_admin()
368 % 60 minutes de timeout (on ne sais jamais)
369 % Après 60 minutes de connexion, le client doit donc reétablir une connexion
370 after 1000 * 60 * 60 ->
371 timeout
372 end.
373
374
375 % Un utilisateur envoie un message
376 put_message(
377 [
378 {cookie, Cookie},
379 {nick, Nick},
380 {content, Content},
381 {answer_to, {array, Answer_to}}
382 ]
383 ) ->
384 case euphorik_bd:user_by_cookie(Cookie) of
385 {ok, User} ->
386 case euphorik_bd:est_banni(User#user.id) of
387 {true, Temps_restant} ->
388 erreur("Vous êtes banni pour encore " ++ format_minutes(Temps_restant));
389 _ ->
390 Strip_content = string:strip(Content),
391 if Strip_content =:= [] ->
392 erreur("Message vide");
393 true ->
394 % TODO : non-atomique (update_pseudo+nouveau_message)
395 euphorik_bd:update_pseudo_user(User#user.id, Nick),
396 case euphorik_bd:nouveau_message(Strip_content, User#user.id, Answer_to) of
397 {erreur, R} -> erreur("Impossible d'ajouter un nouveau message. Raison : " ++ R);
398 _ ->
399 json_reponse_ok()
400 end
401 end
402 end;
403 _ ->
404 erreur("Utilisateur inconnu")
405 end.
406
407
408 % bannissement d'un utilisateur (son ip est bannie)
409 ban(
410 [
411 {cookie, Cookie},
412 {duration, Duration},
413 {user_id, User_id},
414 {reason, Reason}
415 ]) ->
416 % controle que l'utilisateur est un admin
417 case euphorik_bd:user_by_cookie(Cookie) of
418 {ok, User1 = #user{ek_master = true}} ->
419 case euphorik_bd:user_by_id(User_id) of
420 {ok, User1} ->
421 erreur("Il n'est pas possible de s'auto bannir");
422 {ok, User2 = #user{ek_master = false}} ->
423 euphorik_bd:ban(User2#user.last_ip, Duration),
424 euphorik_bd:nouveau_message_sys(lists:flatten(io_lib:format("''~s~s'' est ~s pour ~s.~s",
425 [
426 User2#user.pseudo,
427 if User2#user.login =:= [] -> ""; true -> " (" ++ User2#user.login ++ ")" end,
428 if Duration =< 15 -> "kické"; true -> "banni" end,
429 format_minutes(Duration),
430 if Reason =/= [] -> " - Raison: " ++ Reason; true -> "" end ++ "."
431 ]
432 ))),
433 json_reponse_ok();
434 {ok, _} ->
435 erreur("L'utilisateur est lui même un ekMaster");
436 _ ->
437 erreur("Utilisateur à bannir inconnu")
438 end;
439 _ ->
440 erreur("Utilisateur inconnu ou non ek master")
441 end.
442
443
444 % slapage d'un user (avertissement)
445 slap(
446 [
447 {cookie, Cookie},
448 {user_id, User_id},
449 {reason, Reason}
450 ]) ->
451 % controle que l'utilisateur est un admin
452 case euphorik_bd:user_by_cookie(Cookie) of
453 {ok, User1 = #user{ek_master = true}} ->
454 case euphorik_bd:user_by_id(User_id) of
455 {ok, User1} ->
456 euphorik_bd:nouveau_message_sys(lists:flatten(io_lib:format("~s s'auto slap~s.",
457 [
458 User1#user.pseudo,
459 if Reason =/= [] -> " - Raison: " ++ Reason; true -> "" end
460 ]
461 ))),
462 json_reponse_ok();
463 {ok, User2 = #user{ek_master = false}} ->
464 euphorik_bd:nouveau_message_sys(lists:flatten(io_lib:format("~s se fait slaper par ~s.~s",
465 [
466 User2#user.pseudo,
467 User1#user.pseudo,
468 if Reason =/= [] -> " - Raison: " ++ Reason; true -> "" end ++ "."
469 ]
470 ))),
471 json_reponse_ok();
472 {ok, _} ->
473 erreur("L'utilisateur est lui même un ekMaster");
474 _ ->
475 erreur("Utilisateur à slaper inconnu")
476 end;
477 _ ->
478 erreur("Utilisateur inconnu ou non ek master")
479 end.
480
481
482 put_troll(
483 [
484 {cookie, Cookie},
485 {content, Content}
486 ]
487 ) ->
488 % controle que l'utilisateur est un admin
489 case euphorik_bd:user_by_cookie(Cookie) of
490 {ok, User = #user{ek_master = true}} ->
491 case euphorik_bd:put_troll(User#user.id, Content) of
492 max_troll_reached_per_user ->
493 erreur(lists:flatten(io_lib:format("Le nombre de troll maximum par utilisateur est atteint : ~w ", [?NB_MAX_TROLL_WAITING_BY_USER])));
494 max_troll_reached ->
495 erreur(lists:flatten(io_lib:format("Le nombre de troll maximum en attente est atteint : ~w ", [?NB_MAX_TROLL_WAITING])));
496 _Id ->
497 json_reponse_ok()
498 end;
499 _ ->
500 erreur("Seul les ekMaster peuvent proposer des trolls")
501 end.
502
503
504 mod_troll(
505 [
506 {cookie, Cookie},
507 {troll_id, Troll_id},
508 {content, Content}
509 ]
510 ) ->
511 % controle que l'utilisateur est un admin
512 case euphorik_bd:user_by_cookie(Cookie) of
513 {ok, User = #user{ek_master = true}} ->
514 User_id = User#user.id,
515 case euphorik_bd:troll_by_id(Troll_id) of
516 {ok, #troll{id_user = User_id}} ->
517 euphorik_bd:mod_troll(Troll_id, Content),
518 json_reponse_ok();
519 _ ->
520 erreur("Vous ne posséder pas ce troll")
521 end;
522 _ ->
523 erreur("Seul les ekMaster peuvent proposer des trolls")
524 end.
525
526
527 del_troll(
528 [
529 {cookie, Cookie},
530 {troll_id, Troll_id}
531 ]
532 ) ->
533 % controle que l'utilisateur est un admin
534 case euphorik_bd:user_by_cookie(Cookie) of
535 {ok, User = #user{ek_master = true}} ->
536 User_id = User#user.id,
537 case euphorik_bd:troll_by_id(Troll_id) of
538 {ok, #troll{id_user = User_id}} ->
539 euphorik_bd:del_troll(Troll_id),
540 json_reponse_ok();
541 _ ->
542 erreur("Vous ne posséder pas ce troll")
543 end;
544 _ ->
545 erreur("Seul les ekMaster peuvent proposer des trolls")
546 end.
547
548
549 unban_ip(
550 [
551 {cookie, Cookie},
552 {ip, IP}
553 ]
554 ) ->
555 case euphorik_bd:user_by_cookie(Cookie) of
556 {ok, #user{ek_master = true}} ->
557 euphorik_bd:deban(euphorik_common:unserialize_ip(IP)),
558 json_reponse_ok();
559 _ ->
560 erreur("Seul les ekMaster peuvent connaitre la liste des ips bannies")
561 end.
562
563
564 list_banned_ips(
565 [
566 {cookie, Cookie}
567 ]
568 ) ->
569 case euphorik_bd:user_by_cookie(Cookie) of
570 {ok, #user{ek_master = true}} ->
571 {
572 struct,
573 [
574 {reply, "list_banned_ips"},
575 {list, {array, lists:map(
576 fun({IP, T, Users}) ->
577 {struct,
578 [
579 {ip, euphorik_common:serialize_ip(IP)},
580 {remaining_time, format_minutes(T)},
581 {users, {array, lists:map(
582 fun({Pseudo, Login}) ->
583 {struct,
584 [
585 {nick, Pseudo},
586 {login, Login}
587 ]
588 }
589 end,
590 Users
591 )}}
592 ]
593 }
594 end,
595 euphorik_bd:list_ban()
596 )}}
597 ]
598 };
599 _ ->
600 erreur("Seul les ekMaster peuvent connaitre la liste des ips bannies")
601 end.
602
603
604 % Construit une erreur
605 erreur(Message) ->
606 {
607 struct, [
608 {reply, "error"},
609 {error_message, Message}
610 ]
611 }.
612
613
614 % Formatage de minutes.
615 % par exemple : "1min", "45min", "1h23min", "1jour 2h34min"
616 format_minutes(Min) ->
617 Jours = Min div (60 * 24),
618 Heures = Min rem (60 * 24) div 60,
619 Minutes = Min rem (60),
620 if Jours =/= 0 -> integer_to_list(Jours) ++ " Jour" ++ if Jours > 1 -> "s"; true -> "" end ++ " "; true -> "" end ++
621 if Heures =/= 0 -> integer_to_list(Heures) ++ " heure" ++ if Heures > 1 -> "s"; true -> "" end; true -> "" end ++
622 if Minutes == 0 ->
623 "";
624 true ->
625 " " ++ integer_to_list(Minutes) ++ " minute" ++ if Minutes > 1 -> "s"; true -> "" end
626 end.
627
628
629 % Formatage d'une heure
630 % local_time() -> string
631 format_date(Date) ->
632 DateLocal = calendar:now_to_local_time(Date),
633 DateNowLocal = calendar:local_time(),
634 {{Annee, Mois, Jour}, {Heure, Minute, Seconde}} = DateLocal,
635 {{AnneeNow, _, _}, {_, _, _}} = DateNowLocal,
636 Hier = calendar:date_to_gregorian_days(element(1, DateLocal)) =:= calendar:date_to_gregorian_days(element(1, DateNowLocal)) - 1,
637 lists:flatten(
638 if element(1, DateLocal) =:= element(1, DateNowLocal) ->
639 "";
640 Hier ->
641 "Hier ";
642 Annee =:= AnneeNow ->
643 io_lib:format("~2.10.0B/~2.10.0B ", [Jour, Mois]);
644 true ->
645 io_lib:format("~2.10.0B/~2.10.0B/~B ", [Jour, Mois, Annee])
646 end ++
647 io_lib:format("~2.10.0B:~2.10.0B:~2.10.0B", [Heure, Minute, Seconde])
648 ).
649
650
651 json_reponse_ok() ->
652 {struct, [{reply, "ok"}]}.
653
654
655 json_reponse_login_ok(User) ->
656 {
657 struct, [
658 {reply, "login"},
659 {status, if (User#user.password =/= []) and (User#user.login =/= []) -> "auth_registered"; true -> "auth_not_registered" end},
660 {cookie, User#user.cookie},
661 {id, User#user.id},
662 {nick, User#user.pseudo},
663 {login, User#user.login},
664 {email, User#user.email},
665 {css, User#user.css},
666 {nick_format, atom_to_list(User#user.nick_format)},
667 {view_times, User#user.view_times},
668 {view_tooltips, User#user.view_tooltips},
669 {main_page, User#user.page_principale},
670 {conversations,
671 {array,
672 lists:map(
673 fun(C) ->
674 {struct,
675 [
676 {root, element(1, C)},
677 {page, element(2, C)}
678 ]
679 }
680 end,
681 User#user.conversations
682 )
683 }
684 },
685 {ek_master, User#user.ek_master}
686 ]
687 }.