API Documentation and MySQL Interface

[triadwebzone]

This post has two questions in it:

 

1. The wiki doesn't seem to have a very comprehensive repository of all the functions available for use within the WHMCS API. Is there a more complete list available of the different types of hooks and function calls I can make?

 

2. I've been downloading Addons and hooks to try and see examples of the MySQL interface in use, since I'm pretty certain every addon doesn't have it's own MySQL interface. I've seen usage of MySQL commands like select_query, update_query, insert_query etc available for use within the system, which aren't standard MySQL commands. Is a similar command that's roughly equivalent to mysql_insert_id() or possibly any documentation on the connection interface?

 

Thanks!

[themime]

I've not found this either, I've been using the examples on how to use these but haven't found any unfortunately. Which is annoying, as some cases, like delete_query, seems like the last field is the id, but what if you have a table with more than one primary key? I'm about to experiment with that now, otherwise I'll be using mysql_query again... (even assuming that'll work...).

[laszlof]

You can use standard mysql_query() commands if you'd like. the select_query()/insert_query()/delete_query()/update_query() are just provided to make it a bit easier. Take a look at some of the reports within WHMCS for example usage.