DB calls using SMF connection?

[gmc1]

I've been searching this site and the docs - and finding pieces of what I need... but missing something to tie it all together... Hoping you can point me in the right direction...

I have a new install of SMF 2.0.6 with SimplePortal and bridged to Coppermine.
I am trying to write/incorporate some custom code to be invoked from SimplePortal Blocks/Pages that need to access some non-SMF tables contained in the same MySQL database...

I could certainly use my own code to connect to the database, and query - but thought if I could take advantage of an (already existing?) connection, and use the SMF functions ($smcFunc['db_query'], etc) - that it would be less overhead... and I'd learn more about SMF along the way...

First - is this possible/recommended?
Second - Can you point me to some doc on what I need to do to invoke...

- Just calling the db_query function results in a 'hacking attempt' message...
- Trying to include SSI.php into the block code results in:
"Fatal error: Cannot redeclare ssi_shutdown() (previously declared in /home/domain/www/subdomain/SSI.php:201) in /home/domain/www/subdomain/SSI.php on line 203"

Long time user of PHP... Coppermine... New to SMF and Simple Portal.
Thanks!
Greg

[hadesflames]

This is the documentation for smcFunc:

http://wiki.simplemachines.org/smf/$smcFunc

There is nothing wrong with using it to access your db.

[gmc1]

Thanks for the reply...
I had found that doc... but still seems to be missing a piece to make it work...
Attempting to invoke $smcFunc['db_query'] from my Simple Portal block or page results in a 'hacking attempt' message... and it appears SSI.php is already included as attempts to include it again result in duplicate function definitions...

How do I 'condition' my environment to be able to use the SMF DB functions without triggering the 'hacking attempt' messages?  That message comes out from dozens of places...
I'd venture a guess that for the moment the error is coming from Subs-Db-mysql.php?

Koodi [Valitse] Laajenna


if (!defined('SMF'))
    die('Hacking attempt...');

But since I am in an SMF mod - I would have thought that would already be set?

Tried looking for other postings or doc before slugging through it with code updates to find the location..

[Arantor]

What query, *exactly* are you trying to run? There are times a query will generate a 'Hacking attempt' error.