Database Table Definitions
 

I'm working on some coding that needs to interact direct with the database from a standalone application. I can probably make sense of a lot of it but is there any posting or information that explains the different database tables and their columns and what they're used for?

Thanks in advance.

Don

AFAIK there is none.

But most stuff should be self-explanatory.
If you come across smth, you can't figure out, ask.

Thanks. Thought I'd try. I'm a database geek so can probably figure most out but it's always nice when someone else has already.

I'll open a new thread if needed but do you know where the coding is that sends the instant email notifications of new posts?

You mean thread/forum subscriptions?

Tables subscribeforum and subscribethread

Thanks. Actually I'm trying to find the actual PHP code that sends the messages to those who get instant notifications.

exec_send_notification(), functions_newpost.php
digestweekly.php
digestdaily.php

I should say that what I want to do is basically set the reply to address of the message to something that changes with each sent message.

Hook
mail_send
might help.

Thanks. Do you know if exec_send_notification in the functions_newpost.php is used by anything other than the instant post notifications? Just want to figure out if I can change that function directly or need to copy it and change the calls.

Dang your quick.

There are 2 calls for exec_send_notification()

- in build_new_post(), functions_newpost.php for unmoderated posts
- in moderate.php after a moderated post has been approved

where is build_new post called?

whats an example usage of build_new_post look like?

Thanks

Okay, I'm starting to understand a lot more (looking at hooks, etc). I see the mailqueue gets all the queued messages, can you tell me where I find the code that actually ends up processing the queue. I do see exec_mail_queue which fires off exec_queue but the only place I see exec_mail_queue being called is in exec_shut_down which I'd imagine there is somewhere else it's being called. Or a cron job to send (but can't seem to find it).

I have to say, the hooks system is pretty nice and overall I'm really impressed with a lot of this now that I'm starting to understand more.

exec_shut_down() is being called on every frontend-page (either though a registered shutdown function or from print_output(),and in some cases directly).