asta este pagina completa care o afiseaza :(((
\n"; echo " body { font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;}\n"; echo "\n"; echo "\n"; echo "
Database instalation for Mysql-NetAcct 0.75 and NetStat 3.03
\n"; if(!isset($go)) { echo "This script will create if doesn't exist
database ".$dbname.".
\n"; echo "He will added mysql user ".$MYSQL_USER." for netacct and netstat
usage, with password ".$MYSQL_PASS.".
\n"; echo "Default users language will be
".$languages[$DEFAULT_LANG][0].".\n"; echo "If you want to use others
base,user, password or language
\n"; echo "then edit ".$config_file." set a new values and then RELOAD this
page again!
\n"; echo "If you ready then ...
\n"; echo "
\n"; echo "> I'm READY to install <<\">"; echo "
\n"; } else { $cnx = mysql_connect($dbhost, $dbuser, $dbpasswd) or
die("Unable to connect to database server."); if(!mysql_select_db($dbname,
$cnx)) { $sql = 'CREATE DATABASE '.$dbname; $result = mysql_query($sql);
if(!$result) echo "Database ".$dbname." can\'t to created
"; if (mysql_error()) { echo "Error Report: ".mysql_error()."
"; } else { echo "Successful created, new Database ".$dbname.".
"; } $sql = 'GRANT USAGE ON '.$dbname.'.* TO '.$MYSQL_USER.'@localhost' ;
$result = mysql_query($sql); $sql = 'GRANT select,insert,update ON
'.$dbname.'.* TO '.$MYSQL_USER.'@localhost' ; $result = mysql_query($sql);
$sql = 'SET PASSWORD FOR
\"'.$MYSQL_USER.'\"@\"localhost\"=PASSWORD(\"'.$MYSQL_PASS.'\")'; $result =
mysql_query($sql); } $sql = "SELECT * FROM ipallow"; $result =
mysql_query($sql); if($result) { echo "Table ipallow allready exist! We
don\'t make it again for now.
\n"; } else { $sql = "CREATE TABLE ipallow ( ip_host varchar(255) NOT NULL
default '', PRIMARY KEY (ip_host) )"; $result = mysql_query($sql);
if(!$result) echo "Install failed
"; if (mysql_error()) { echo "Error Report: ".mysql_error()."
"; } else { echo "Successful complete, new table ipallow was added.
"; } $sql = "INSERT INTO ipallow (ip_host) VALUES ('127.0.0.1')"; $result =
mysql_query($sql); } $sql = "SELECT * FROM logins"; $result =
mysql_query($sql); if($result) { echo "Table logins allready exist! We don't
make it again for now.
\n"; } else { $sql = "CREATE TABLE logins ( uid int(10) unsigned NOT NULL
default '0', date datetime NOT NULL default '0000-00-00 00:00:00', ip
char(20) NOT NULL default '', PRIMARY KEY (uid,date) )"; $result =
mysql_query($sql); if(!$result) echo "Install failed
"; if (mysql_error()) { echo "Error Report: ".mysql_error()."
"; } else { echo "Successful complete, new table logins was added.
"; } } $sql = "SELECT id FROM traffic WHERE MIN(id)"; $result =
mysql_query($sql); if($result) { echo "Table traffic allready exist! We
don't make it again for now.
\n"; } else { $sql = "CREATE TABLE traffic ( id int(11) unsigned NOT NULL
auto_increment, ip varchar(15) NOT NULL default '', time datetime NOT NULL
default '0000-00-00 00:00:00', input int(20) unsigned NOT NULL default '0',
output int(20) unsigned NOT NULL default '0', peer_input int(20) unsigned
NOT NULL default '0', peer_output int(20) unsigned NOT NULL default '0',
direct_input int(20) unsigned NOT NULL default '0', direct_output int(20)
unsigned NOT NULL default '0', local_input int(20) unsigned NOT NULL default
'0', local_output int(20) unsigned NOT NULL default '0', PRIMARY KEY (id),
KEY ip (ip), KEY time (time) )"; $result = mysql_query($sql); if(!$result)
echo "Install failed
"; if (mysql_error()) { echo "Error Report: ".mysql_error()."
"; } else { echo "Successful complete, new table traffic was added.
"; } } $sql = "SELECT * FROM users"; $result = mysql_query($sql);
if($result) { echo "Table users allready exist! We don't make it again for
now.
\n"; } else { $sql = "CREATE TABLE users ( uid int(10) NOT NULL
auto_increment, login varchar(15) NOT NULL default '', password varchar(35)
NOT NULL default '', status enum('client','pclient','admin') NOT NULL
default 'client', email varchar( 100 ) NOT NULL default '', language
varchar(10) NOT NULL default '".$DEFAULT_LANG."', input_traffic_price
float(5,2) unsigned default '0.00', output_traffic_price float(5,2) unsigned
default '0.00', input_peering_price float(5,2) unsigned default '0.00',
output_peering_price float(5,2) unsigned default '0.00', input_direct_price
float(5,2) unsigned default '0.00', output_direct_price float(5,2) unsigned
default '0.00', input_local_price float(5,2) unsigned default '0.00',
output_local_price float(5,2) unsigned default '0.00', PRIMARY KEY
(uid,login), UNIQUE KEY login (login), UNIQUE KEY uid (uid) )"; $result =
mysql_query($sql); if(!$result) echo "Install failed
"; if (mysql_error()) { echo "Error Report: ".mysql_error()."
"; } else { echo "Successful complete, new table users was added.
"; } $sql = "INSERT INTO users (login, password, status) VALUES ('admin',
'21232f297a57a5a743894a0e4a801fc3', 'admin')"; $result =
mysql_query($sql); } $sql = "SELECT * FROM users_ip"; $result =
mysql_query($sql); if($result) { echo "Table users_ip allready exist! We
don't make it again for now.
\n"; } else { $sql = "CREATE TABLE users_ip ( ipid bigint(40) NOT NULL
auto_increment, uid int(10) NOT NULL default '0', ip varchar(15) NOT NULL
default '', PRIMARY KEY (ipid), KEY uid (uid) )"; $result =
mysql_query($sql); if(!$result) echo "Install failed
"; if (mysql_error()) { echo "Error Report: ".mysql_error()."
"; } else { echo "Successful complete, new table users_ip was added.
"; } } $sql = 'GRANT delete ON '.$dbname.'.* TO '.$MYSQL_USER.'@localhost' ;
$result = mysql_query($sql); echo "
Upgrade was finished.
"; echo "
Please remember to delete this upgrade file!!!"; exit; } ?>
----- Original Message -----
From: "Tarhon-Onu Victor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 24, 2003 12:37 PM
Subject: [rlug] Re: problema php
> On Sun, 24 Aug 2003, Vlad Radu wrote:
>
> > stie cumva careva din ce motiv?
>
> Problema e de mysql, nu php. Sau mai degraba de net-acct. Nu ai
> creata baza de date pentru accounting sau nu i-ai spus lui unde s-o
> gaseasca.
>
> --
> Any views or opinions presented within this e-mail are solely those of
> the author and do not necessarily represent those of any company, unless
> otherwise expressly stated.
>
> ---
> Detalii despre listele noastre de mail: http://www.lug.ro/
>
>
---
Detalii despre listele noastre de mail: http://www.lug.ro/
