rugk / xenforo-threema-gateway

        // conditionally add data from other tables depending on message

        // type

        switch ($messageType) {

            case ThreemaGateway_Model_Messages::TYPE_DELIVERY_MESSAGE:

                $existing[ThreemaGateway_Model_Messages::DB_TABLE_MESSAGES . '_delivery_receipt'] = [

                    'message_id' => $messageId

                ];

                $existing[ThreemaGateway_Model_Messages::DB_TABLE_DELIVERY_RECEIPT] = [

                    'message_id' => $messageId

                ];

                break;

            case ThreemaGateway_Model_Messages::TYPE_FILE_MESSAGE:

                $existing[ThreemaGateway_Model_Messages::DB_TABLE_MESSAGES . '_file'] = [

                ];

                break;

            case ThreemaGateway_Model_Messages::TYPE_FILE_MESSAGE:

                $existing[ThreemaGateway_Model_Messages::DB_TABLE_MESSAGES . '_file'] = [

                    'message_id' => $messageId

                ];

                $existing[ThreemaGateway_Model_Messages::DB_TABLE_FILES] = [

                    'message_id' => $messageId

                ];

                break;

            case ThreemaGateway_Model_Messages::TYPE_IMAGE_MESSAGE:

                $existing[ThreemaGateway_Model_Messages::DB_TABLE_MESSAGES . '_image'] = [

                ];

                break;

            case ThreemaGateway_Model_Messages::TYPE_IMAGE_MESSAGE:

                $existing[ThreemaGateway_Model_Messages::DB_TABLE_MESSAGES . '_image'] = [

                    'message_id' => $messageId

                ];

                $existing[ThreemaGateway_Model_Messages::DB_TABLE_FILES] = [

                    'message_id' => $messageId

                ];

                break;

            case ThreemaGateway_Model_Messages::TYPE_TEXT_MESSAGE:

                $existing[ThreemaGateway_Model_Messages::DB_TABLE_MESSAGES . '_text'] = [

                ];

                break;

            case ThreemaGateway_Model_Messages::TYPE_TEXT_MESSAGE:

                $existing[ThreemaGateway_Model_Messages::DB_TABLE_MESSAGES . '_text'] = [

                    'message_id' => $messageId

                ];

                $existing[ThreemaGateway_Model_Messages::DB_TABLE_FILES] = [

                    'message_id' => $messageId

                ];

                break;

            default:

                throw new XenForo_Exception(new XenForo_Phrase('threemagw_unknown_message_type'));