po dohode s vedoucim TO vas timto zadam o povoleni poskytovat strojove zpracovatelna otevrena data tykajici palcovani na piratskem foru.
Navrh usneseni:
Technicke reseni zahrunje pravidelne jednodenni provadeni nasledujich SQL prikazu a publikovani vysledku techto dotazu na stranickem webi ve formatu csv. Rozsireni GraphAPI by byl pozdejisi bonus.
Kód: Vybrat vše
select forum_id, parent_id, forum_name from phpbb_forums;
select topic_id, forum_id, topic_poster, topic_time from phpbb_topics;
select * from phpbb_thanks;
select user_id, username, user_posts from phpbb_users;
select group_id, group_name from phpbb_groups where group_id in (47,74);
select group_id,user_id from phpbb_user_group where user_pending = 0 and group_id in (47,74);
