Database Table Definitions

[lionheart53]

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

[Andreas]

AFAIK there is none.

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

[lionheart53]

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?

[Andreas]

You mean thread/forum subscriptions?

Tables subscribeforum and subscribethread

[lionheart53]

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

[Andreas]

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

[lionheart53]

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.

[Andreas]

Hook
mail_send
might help.

[lionheart53]

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.

[Andreas]

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

[hapbird]

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

[lionheart53]

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.

[Andreas]

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).