topix wrote:dequi wrote:Got the 'included' plugins already finished on the demo site:
Do you edit the list manually or have that list created automatically from a database? Would it be possible to extract the information from an .egplugin-file (zip-file)? I ask because maybe we could share the same list with the plugin-manager?
Currently it's a manual list, based upon the older lists available on the website and documentation, and the plugins in the
https://github.com/eventghost/eventghost repository
At this point I'm trying to figure out how to generate a list from all the forum posted plugins. I have a SQL database backup dated 03.09.2016 and with this query
Code: Select all
SELECT
phpbb_topics.forum_id,
phpbb_forums.forum_name,
phpbb_attachments.topic_id,
phpbb_topics.topic_title,
phpbb_attachments.post_msg_id,
phpbb_posts.post_subject,
phpbb_attachments.poster_id,
phpbb_users.username,
phpbb_attachments.attach_id,
phpbb_attachments.physical_filename,
phpbb_attachments.real_filename,
phpbb_attachments.extension,
phpbb_attachments.attach_comment,
phpbb_attachments.download_count,
phpbb_attachments.filesize,
phpbb_attachments.filetime,
CONCAT('http://www.eventghost.net/forum/download/file.php?id=', phpbb_attachments.attach_id) AS file_url,
CONCAT('http://www.eventghost.net/forum/viewtopic.php?f=', phpbb_topics.forum_id, '&t=',phpbb_attachments.topic_id) AS topic_url,
CONCAT('http://www.eventghost.net/forum/viewtopic.php?f=', phpbb_topics.forum_id, '&t=',phpbb_attachments.topic_id,'#p', phpbb_attachments.post_msg_id) AS post_url
FROM
phpbb_attachments
INNER JOIN phpbb_topics
ON phpbb_attachments.topic_id = phpbb_topics.topic_id
INNER JOIN phpbb_forums
ON phpbb_topics.forum_id = phpbb_forums.forum_id
INNER JOIN phpbb_users
ON phpbb_attachments.poster_id = phpbb_users.user_id
INNER JOIN phpbb_posts
ON phpbb_attachments.post_msg_id = phpbb_posts.post_id
WHERE
phpbb_attachments.extension NOT IN ('gif','jpg','png', 'jpeg', 'xml', 'cpp', 'h', 'log', 'txt', 'tiff')
ORDER BY
phpbb_attachments.topic_id ASC,
phpbb_attachments.physical_filename ASC,
phpbb_attachments.filetime ASC;
I have it at 1275 attachment posts that could be plugins (.py, .zip, .7z) some of them are patches, updates.
If I change the where clause to remove active plugin developers that could add their own plugins
Code: Select all
WHERE
phpbb_attachments.extension NOT IN ('gif','jpg','png', 'jpeg', 'xml', 'cpp', 'h', 'log', 'txt', 'tiff')
AND phpbb_users.username NOT IN ('Pako', 'Sem;colon', 'jonib', 'kgschlosser', 'krambriw', 'topix')
I get it down to 665 attachments I need to go trough, but actually this also weeds out all patches by the developers to other plugins too.
only then I can get some type of script build to run trough them.
have to put my thinking cap on
