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