# Mysql Config Stuff #

$dbhost = "by-limus24.de.mysql"; // MySQL HOST

$dbuser = "by_limus24_de"; // your Mysql Username

$dbpass = "**********"; // Your mysql password

$dbname = "by_limus24_de"; // the name of the database BANEX is on





# Site config stuff #

$cfg_siteurl = "http://www.by-limus24.de"; // your URL

$cfg_folder = "/banex"; // folder to BANEX

$cfg_sitename = "by-limus24"; // the name of your site

$cfg_bxcname = "My Exchange"; // the name of your banner exhange



# Header (optional) #

# If you want, make a file that includes your META tags, #

# CSS, or anything like that and tell me where it is at #

# (relative to the Banex directory) #

$header = "../header.php";

<?php

// database settings

$db_host = "by-limus24.de.mysql";

$db_user = "by_limus24_de";

$db_pass = "************";

$db_name = "by_limus24_de";

$db_prefix = "fusion_";

define("DB_PREFIX", "fusion_");

?>

if ( isset($_GET['step']) )

  {                        

    $step = $_GET['step']; 

  }

require "inc/lib.inc";

@include "$header";



$db = mysql_connect($dbhost, $dbuser, $dbpass)

      or die ("could not connect to MySQL");

      mysql_select_db($dbname, $db)

         or die ("could not connect to $dbname");



If (!isset($step)){

Echo "Welcome!<br>Make sure you have edited all of lib.inc before you run this script...<br>Also make sure you have a Database in MySQL named $dbname<br>";

Echo "<br><A href=\"install.php?step=1\">Start Installation</a>";

}



Elseif ($step==1){

Echo "<p>creating the users table in mysql... <br>";

mysql_query("DROP TABLE IF EXISTS users");

mysql_query("CREATE TABLE users (

  id tinyint(4) NOT NULL auto_increment,

  user_login varchar(25) NOT NULL default '',

  user_pass varchar(255) NOT NULL default '',

  name varchar(25) NOT NULL default '',

  email varchar(75) NOT NULL default '',

  site_url varchar(255) NOT NULL default '',

  site_name varchar(255) NOT NULL default '',

  impressions int(50) NOT NULL default '0',

  clicks int(50) NOT NULL default '0',

  imp_left text NOT NULL,

  lastip text NOT NULL,

  lastbannerid text NOT NULL,

  half text NOT NULL,

  act tinyint(1) NOT NULL default '0',

  numban tinyint(1) NOT NULL default '0',

  PRIMARY KEY  (id),

  UNIQUE KEY id (id),

  UNIQUE KEY user_login (user_login)

)");

Echo "Done</p>";



Echo "<p>creating the banners table in mysql... <br>";

mysql_query("DROP TABLE IF EXISTS banners");

mysql_query("CREATE TABLE banners (

  id tinyint(5) NOT NULL auto_increment,

  user varchar(75) NOT NULL default '',

  url varchar(255) NOT NULL default '',

  text text NOT NULL,

  act tinyint(1) NOT NULL default '0',

  PRIMARY KEY  (id),

  UNIQUE KEY id (id,url)

)");



Echo "Done</p>";

Echo "Good, Step one is complete, now move on to <a href=\"install.php?step=2\">Step 2</a>!";

}



ElseIf ($step==2){

echo "<center>";

include "templates/install.inc";

echo "</center>";

}



ElseIf ($step==3){

            $user_pw = md5($PHP_AUTH_PW);

Echo "inserting your default login stuff into mysql \n";

$result = mysql_query ("INSERT INTO users (id, user_login, user_pass, site_url, site_name, name, email, imp_left, act) VALUES (1, '$cfg_defaultusername', '$user_pw', '$cfg_siteurl', '$cfg_sitename', '$cfg_defaultname', '$cfg_defaultemail', 9999999999, '1')");

Echo "Done ($result)</p>";



Echo "BANEX installation is complete!<br><b>DELETE INSTALL.PHP</b><Br>You can now make a link to <a href=\"index.html\">index.html</a> (after you edit it) and let your users sign up and all.<br><a href=\"members.php\">[Login]</a> and add the default banners (you also have to accept them in Admin Mode)";

}



?>

// YOU MUST LEAVE ALL COPYRIGHT THINGS AND LINKS INPLACE // /* BANEX by TREY BRIGGS This program is free software; you can redistribute it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA Banex version 1, Copyright (C) 2002 trey briggs */ require "inc/lib.inc"; @include "$header"; if ( isset($_GET['step']) ) { $step = $_GET['step']; } $db = mysql_connect($dbhost, $dbuser, $dbpass) or die ("could not connect to MySQL"); mysql_select_db($dbname, $db) or die ("could not connect to $dbname"); Echo "Welcome!

Make sure you have edited all of lib.inc before you run this script...

Also make sure you have a Database in MySQL named $dbname

"; Echo "

Start Installation"; } Elseif ($step==1){ Echo "



creating the users table in mysql...

"; mysql_query("DROP TABLE IF EXISTS users"); mysql_query("CREATE TABLE users ( id tinyint(4) NOT NULL auto_increment, user_login varchar(25) NOT NULL default '', user_pass varchar(255) NOT NULL default '', name varchar(25) NOT NULL default '', email varchar(75) NOT NULL default '', site_url varchar(255) NOT NULL default '', site_name varchar(255) NOT NULL default '', impressions int(50) NOT NULL default '0', clicks int(50) NOT NULL default '0', imp_left text NOT NULL, lastip text NOT NULL, lastbannerid text NOT NULL, half text NOT NULL, act tinyint(1) NOT NULL default '0', numban tinyint(1) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id), UNIQUE KEY user_login (user_login) )"); Echo "Done

"; Echo "



creating the banners table in mysql...

"; mysql_query("DROP TABLE IF EXISTS banners"); mysql_query("CREATE TABLE banners ( id tinyint(5) NOT NULL auto_increment, user varchar(75) NOT NULL default '', url varchar(255) NOT NULL default '', text text NOT NULL, act tinyint(1) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id,url) )"); Echo "Done

"; Echo "Good, Step one is complete, now move on to Step 2!"; } ElseIf ($step==2){ echo "

"; include "templates/install.inc"; echo "

"; } ElseIf ($step==3){ $user_pw = md5($PHP_AUTH_PW); Echo "inserting your default login stuff into mysql \n"; $result = mysql_query ("INSERT INTO users (id, user_login, user_pass, site_url, site_name, name, email, imp_left, act) VALUES (1, '$cfg_defaultusername', '$user_pw', '$cfg_siteurl', '$cfg_sitename', '$cfg_defaultname', '$cfg_defaultemail', 9999999999, '1')"); Echo "Done ($result)



"; Echo "BANEX installation is complete!

DELETE INSTALL.PHP

You can now make a link to index.html (after you edit it) and let your users sign up and all.

[Login] and add the default banners (you also have to accept them in Admin Mode)"; } ?>

<?php



........



require "inc/lib.inc";

@include "$header";



if ( isset($_GET['step']) )

  {                       

    $step = $_GET['step'];

  }



$db = mysql_connect($dbhost, $dbuser, $dbpass)

      or die ("could not connect to MySQL");

      mysql_select_db($dbname, $db)

         or die ("could not connect to $dbname");



....



?>

require "inc/lib.inc";

@include "$header";



if ( isset($_GET['step']) )

  {                       

    $step = $_GET['step'];

   }



$db = mysql_connect($dbhost, $dbuser, $dbpass)

      or die ("could not connect to MySQL");

      mysql_select_db($dbname, $db)

         or die ("could not connect to $dbname");





If (!isset($step)){

Echo "Welcome!<br>Make sure you have edited all of lib.inc before you run this script...<br>Also make sure you have a Database in MySQL named $dbname<br>";

Echo "<br><A href="install.php?step=1">Start Installation</a>";

}

// If register_globals is turned off, extract super globals (php 4.2.0+)

if (ini_get('register_globals') != 1) {                                 

        if ((isset($_POST) == true) && (is_array($_POST) == true)) extract($_POST, EXTR_OVERWRITE);

        if ((isset($_GET) == true) && (is_array($_GET) == true)) extract($_GET, EXTR_OVERWRITE);   

}