Spidean Forums

| Search | New Posts

Board Index > HTML/CSS > Pulling PN content into static html

< Last Thread Next Thread >

New Topic Post Reply

starteck2002

Newbie

Posts: 8
Registered: 11/12/2002
Status: Offline

posted on 11/2/2004 at 03:38 PM

This isn't Autotheme related but i'm hoping someone here will be able to help.

I have designed a static login screen and a user signup screen for PN in bog standard HTML.

I'd like to be able to include a line within my static html that says something like 'Welcome to MySite - XXXXXX users can't be wrong!' Where the 'XXXXX' is replaced by the actual number of users in the database. I'd like to be able to do similar things with the forums too.

The reason I don't want to do this directly with PostNuke is because the site is VERY customised and PN just gets in the way.

Anyone have any idea how to do this?

[Edited on 2/11/2004 by starteck2002]

AlarConcepts

Senior Member

Posts: 217
Registered: 7/31/2004
Status: Offline

posted on 11/7/2004 at 05:52 PM

Insert this code into theme.html where ever you want it to appear.

code:
<?php

    list($dbconn) = pnDBGetConn();

    $pntable = pnDBGetTables();

    $UsersTable = $pntable['users'];	

    $UsersColumn = &$pntable['users_column'];

    $sql = "SELECT  $UsersColumn[uname]

            FROM  $UsersTable

            WHERE $UsersColumn[uname]

            NOT LIKE 'Anonymous'

            ORDER BY $UsersColumn[uid] DESC";

    $result = $dbconn->Execute($sql);

    if ($dbconn->ErrorNo() != 0) { return; }

    $total = $result->PO_RecordCount();		

    $result->Close();

    echo 'Welcome to mysite.com! ' . ' ' . $total . ' users can\'t be
wrong!';

?>

I find it funny that you think PN gets in the way, but are willing to display a statistic in this way... to each his own.

John

____________________
»AlarConcepts«

starteck2002

Newbie

Posts: 8
Registered: 11/12/2002
Status: Offline

posted on 11/7/2004 at 05:59 PM

Hi John,

Thanks for the reply to my post. Just so that you understand, I have no problem with PostNuke - It's been the basis of my website now for around 3 years (i think).

What I am actually trying to do is have a static HTML page that is NOT related to postnuke in anyway but would like to pull info out of the PN DB and display it.

I want to be able to do this outside of postnuke. Is it possible?

AlarConcepts

Senior Member

Posts: 217
Registered: 7/31/2004
Status: Offline

posted on 11/7/2004 at 09:39 PM

The problem is that you need to call the pninit() function in order to get access to any variables...but you can't do this in your html file...

Is is absolutely necessary that your html page have an .html extension? You can just create a PostNuke "wrapper" for any HTML you need to display...and by jumping in and out of PHP (within the HTML portion,) you can use any of PostNukes variables...

Two things to watch for:
1. The page with the code below MUST have a .php extension.
2. The page MUST reside in your root to work properly.

code:
<?

    include 'includes/pnAPI.php';

    pnInit();

    include("header.php");

    OpenTable();

?>

ALL YOUR HTML FITS IN HERE...BUT DON'T FORGET THAT YOU CAN BREAK IN AND OUT
OF PHP AS YOU GO, FOR EXAMPLE:

My username is <?php echo pnUserGetVar('uname'); ?>!

<?php

    CloseTable();

    include 'footer.php';

?>