External connection outside of Nuke

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I am wanting to move my MILPACS tables outside of the nuke database for a separate backup purpose.

I have seen several ways to do this but am asking what is the preferred way?

Do I need to create an includes folder and separate config.php for database connectivity outside of Nuke?

What is a config.inc.php, and how is it different from a config.php

Here is what I am thinking and what I have found in other modules.

Code:

<?php
if(eregi("_config.inc.php", $_SERVER["PHP_SELF"]) || eregi("_config.inc.php", $HTTP_SERVER_VARS["PHP_SELF"])) die("Access denied!");

// ################################### DATABASE SETTINGS ##############################
$sql["hostname"] = "localhost"; // Hostname of the MySQL-Database
$sql["username"] = "xxxxxxx"; // MySQL Username
$sql["password"] = "xxxxxxx"; // MySQL Password
$sql["database"] = "xxxxxxx"; // MySQL Database Name

?>

Would I then have to code in include(config.php) to each of my pages?

Raven · Posted: Sun Jan 30, 2005 12:09 pm

config.inc.php is just "standard" way of letting the programmer (and user) know that it is an included file and means nothing as stand alone. Functionally there is no difference; you could call your config file "donovan.php" if you wanted to.

Now, on the other, a bit more detail is needed.

What exactly is your goal and why?
Will it still run under nuke?
If it will still run under nuke, why not use nuke's config.php?
Any other detailed information that might help.

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

Backup of the modules database tables as well as a cleaner install of Nuke as to not have so many "aftermarket" tables that are added with different modules.

vWar is such an application that runs in Nuke just fine with an external database as well as Nuke Treasury. I have both of their tables in their own db.

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I made a db.inc.php file just for this purpose and was going to include this in each of my files.

Code:

<?php

/************************************************************************/
/* MILPACS */
/* =========================== */
/* */
/* Copyright (c) 2005 by Steven Donovan */
/* http://www.3rd-infantry-division.net */
/* */
/* */
/************************************************************************/

//connection string to MILPACS database
$db = mysql_connect( "localhost", "username", "password");
mysql_select_db( "database_name", $db);
?>

But now when I try to pull up my roster it was giving me a same crap as before

Quote:

Fatal error: Call to a member function on a non-object

Is there a specific place I have to write my include statement if it is not in a function?

include("db.inc.php");

Here is the line the error referred to.
$result = $db->sql_query($sql);

It has to be this variable $db that is not geting passed or something.