• Hi, I need to create a dashboard where the admin user can see the list of attachments uploaded to your plugin. Can you tell me the structure of the database to make the correct query?
    Or is there a shortcode to display all the data?
    I bought the premium membership ??

    Thank you

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author smartypants

    (@smartypants)

    Hey there, you can check out the database by using a tool like phpmyadmin. Our tables are prefixed by cu_

    You can also check out our addons https://smartypantsplugins.com/plugins/plugin-addons/ to extend the plugin.

    Thread Starter inkoutsrl

    (@inkoutsrl)

    Hi,
    thx for response.

    Can you tell me how to link the tables? In the sense that I have to see, for each user, which documents have been uploaded and under which folder. I am browsing through the tables but I don’t understand how to join them.

    Thank you

    Plugin Author smartypants

    (@smartypants)

    Hey there, there is the main files _cu and then cu_projects for folders!

    Files have a pid (project ID) and folders have a parent relationship.

    Thread Starter inkoutsrl

    (@inkoutsrl)

    ok clear! Does the uid field in _cu represent the id of the user who uploaded it or the id of the user to whom the document was uploaded?
    thank you

    Plugin Author smartypants

    (@smartypants)

    Yes correct, that is the user who uploaded the document

    Thread Starter inkoutsrl

    (@inkoutsrl)

    perfect thanks!! Question: I uploaded from a user with a custom role. The file was uploaded successfully (I see it with both the query and the file was uploaded). When I go to the backend, users and select this user I don’t see the uploaded file. What could be the problem? I checked that this file is only available for this user.

    Thank you

    Plugin Author smartypants

    (@smartypants)

    Hey there, the user MUST own the file to view it on the shortcode [sp-client-document-manager]

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Custom Dashboard’ is closed to new replies.