ISE PDF edition WORK IN PROGRESS

[smfadmin (OP)]

sample resuls page:

https://forum.drugs-and-users.org/The_ISE_Project/pdfresults.html

Results page palette:

ISE Colour Picker

Code: [Select]

[17:58:44]root@forum:/var/www/html/The_ISE_Project $ [b]py3 PDFsearch.py synaptogenesis[/b]
47 match(es) — showing top 20:
  attach-3218  page  28  [1 term(s): synaptogenesis]  attach-3218
  attach-3218  page  29  [1 term(s): synaptogenesis]  attach-3218
  attach-3218  page  35  [1 term(s): synaptogenesis]  attach-3218
  attach-3218  page  74  [1 term(s): synaptogenesis]  attach-3218
  attach-3218  page  75  [1 term(s): synaptogenesis]  attach-3218
  attach-4917  page   7  [1 term(s): synaptogenesis]  attach-4917
  attach-4960  page   9  [1 term(s): synaptogenesis]  attach-4960
  attach-5045  page   1  [1 term(s): synaptogenesis]  attach-5045
  attach-5045  page   2  [1 term(s): synaptogenesis]  attach-5045
  attach-5045  page   4  [1 term(s): synaptogenesis]  attach-5045
  attach-5045  page   5  [1 term(s): synaptogenesis]  attach-5045
  attach-5045  page   6  [1 term(s): synaptogenesis]  attach-5045
  attach-5045  page   7  [1 term(s): synaptogenesis]  attach-5045
  attach-5045  page   8  [1 term(s): synaptogenesis]  attach-5045
  attach-5045  page   9  [1 term(s): synaptogenesis]  attach-5045
  attach-5045  page  10  [1 term(s): synaptogenesis]  attach-5045
  attach-5045  page  11  [1 term(s): synaptogenesis]  attach-5045
  attach-5045  page  12  [1 term(s): synaptogenesis]  attach-5045
  attach-5045  page  14  [1 term(s): synaptogenesis]  attach-5045
  attach-5049  page  32  [1 term(s): synaptogenesis]  attach-5049
[18:00:05]root@forum:/var/www/html/The_ISE_Project $ mysql

Bash script:

Code: [Select]

#!/bin/bash

ATTACH_ID=$1

mysql -u root -pegerszegi smf209 -e "
SELECT a.*, m.id_msg, m.subject, m.id_topic, t.id_first_msg, t.id_last_msg
FROM smf209_attachments AS a
LEFT JOIN smf209_messages AS m ON a.id_msg = m.id_msg
LEFT JOIN smf209_topics AS t ON m.id_topic = t.id_topic
WHERE a.id_attach = ${ATTACH_ID}\G;
"


Code: [Select]

*************************** 1. row ***************************
      id_attach: 3218
       id_thumb: 0
         id_msg: 47468
      id_member: 0
      id_folder: 1
attachment_type: 0
       filename: 1.pdf
      file_hash: b8be60726af826299155c1de139b4266b77eecf7
        fileext: pdf
           size: 18433521
      downloads: 0
          width: 0
         height: 0
      mime_type:
       approved: 1
proper_rotation: 0
         id_msg: 47468
        subject: Notes backup
       id_topic: 5988
   id_first_msg: 47468
    id_last_msg: 47468


Code: [Select]

mysql> SELECT a.*, m.id_msg, m.subject, m.id_topic, t.id_first_msg, t.id_last_msg FROM smf209_attachments AS a LEFT JOIN smf209_messages AS m ON a.id_msg = m.id_msg LEFT JOIN smf209_topics AS t ON m.id_topic = t.id_topic WHERE a.id_attach = 93\G;
*************************** 1. row ***************************
      id_attach: 93
       id_thumb: 0
         id_msg: 745
      id_member: 0
      id_folder: 1
attachment_type: 0
       filename: Meth-Treatment-Options.pdf
      file_hash: 114438ca6fe72ae03d346705ee9788737c98c726
        fileext: pdf
           size: 493942
      downloads: 1373
          width: 0
         height: 0
      mime_type:
       approved: 1`
proper_rotation: 0
         id_msg: 745
        subject: Meth-Treatment-Options
       id_topic: 658
   id_first_msg: 745
    id_last_msg: 748
1 row in set (0.00 sec)




ISE PDF first hit was 93:

[pdf]https://forum.drugs-and-users.org/index.php?action=dlattach;topic=658;attach=93[/pdf]