SQL Question

[CurtyCat]

I'm attempting to create a hook in /Includes/Hooks that will perform an action after an order has been accepted. Part of this means pulling information that was created in a table under a provisioning module that had fields populated.

 

I'm not quite sure about the query system in Capsule (even with the guide to prevent SQL injections). Will calling the query on the table mean that Capsule doesn't require a specific directory to reach that table? How does it know where the table is? Can I just reference any table in any Database on my WHMCS account?

 

Also, for example if you had something like:

 

$all = Capsule::table('tblcustomfieldvalues')->get();

 

Would $all now be an array of all fieldid's relids and values? How is the information being stored? I'm using my browser to look at the php file I made for the hook to test it and I can't seem to figure out the SQL part. Any help appreciated!

 

Best Regards.