systemtek
-
Posts
12 -
Joined
-
Last visited
Never
Posts posted by systemtek
-
-
in the fsockopen bit remove the http:// from the address so it just says www.domain.com rarther than http://www.domain.com
-
Hi, in the modules on the left side, currently by default there is home, faq topics etc that point to pages on my site, say for example i want one to say Services and rarther than open a page on my site i want it to take me to a url say 123.com/forum and open it in a new window.
Still trying to get used to phpnuke - getting there slowly....
Thanks -
same error
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
-
Hi thanks for the reply, tried as suggested and get the following error
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
Any ideas ?
Here is my code i just changed it and called it products :
#
# Table structure for table `nuke_products`
#
CREATE TABLE nuke_products (
id tinyint(4) NOT NULL auto_increment,
id_cat tinyint(4) NOT NULL default '0',
question varchar(255) default ",
answer text,
PRIMARY KEY (id),
KEY id (id),
KEY id_cat (id_cat)
) TYPE=MyISAM;
#
# Dumping data for table `nuke_products`
#
# --------------------------------------------------------
#
# Table structure for table `nuke_products`
#
CREATE TABLE nuke_products (
id_cat tinyint(3) NOT NULL auto_increment,
categories varchar(255) default NULL,
flanguage varchar(30) NOT NULL default ",
PRIMARY KEY (id_cat),
KEY id_cat (id_cat)
) TYPE=MyISAM;
#
# Dumping data for table `products`
#
# -------------------------------------------------------- -
I am using phpnuke and i have read in the manual about Duplicating the PHP-Nuke FAQ module, this is section 22.1.
Here : http://www.karakas-online.de/EN-Book/duplicating-php-nuke-faq-module.html
This is just what i need to do, but reading about it, it says about doing stuff from the command line to the MySQL.
I dont have command line access i just have mysql and phpnuke via cPanel, do i need to do any of that, if so how do i go about doing it as dont have ssh access.
Are the files anywhere i acn access them ?
Thanks -
I have just found out from my host that passthru and system is disabled in server, is there any way around this for the above script ?
-
#!/usr/local/bin/php
<?php
// configure your database variables below:
$dbhost = 'localhost'; // Server address of your MySQL Server
$dbuser = 'XXXXX'; // Username to access MySQL database
$dbpass = 'XXXXX'; // Password to access MySQL database
$dbname = 'systemte_phpbb1'; // Database Name
// Optional Options You May Optionally Configure
$use_gzip = "yes"; // Set to No if you don't want the files sent in .gz format
$remove_sql_file = "yes"; // Set this to yes if you want to remove the .sql file after gzipping. Yes is recommended.
$remove_gzip_file = "no"; // Set this to yes if you want to delete the gzip file also. I recommend leaving it to "no"
// Configure the path that this script resides on your server.
$savepath =
"/home/systemtek/public_html/dbsender"; // Full path to this directory. Do not use trailing slash!
$send_email = "yes"; // Do you want this database backup sent to your email? Fill out the next 2 lines
$to = "admin@XXXXXX.co.uk"; // Who to send the emails to
$from = "admin@XXXXXX.co.uk"; // Who should the emails be sent from?
$senddate = date("j F Y");
$subject = "MySQL Database Backup - $senddate"; // Subject in the email to be sent.
$message = "Your MySQL database has been backed up and is attached to this email"; // Brief Message.
$use_ftp = "no"; // Do you want this database backup uploaded to an ftp server? Fill out the next 4 lines
$ftp_server = "localhost"; // FTP hostname
$ftp_user_name = "ftp_username"; // FTP username
$ftp_user_pass = "ftp_password"; // FTP password
$ftp_path = "/"; // This is the path to upload on your ftp server!
// Do not Modify below this line! It will void your warranty!
$date = date("mdy-hia");
$filename = "$savepath/$dbname-$date.sql";
passthru("mysqldump --opt -h$dbhost -u$dbuser -p$dbpass
$dbname >$filename");
if($use_gzip=="yes"){
$zipline = "tar -czf ".$dbname."-".$date."_sql.tar.gz
$dbname-$date.sql";
shell_exec($zipline);
}
if($remove_sql_file=="yes"){
exec("rm -r -f $filename");
}
if($use_gzip=="yes"){
$filename2 =
"$savepath/".$dbname."-".$date."_sql.tar.gz";
} else {
$filename2 = "$savepath/$dbname-$date.sql";
}
if($send_email == "yes" ){
$fileatt_type = filetype($filename2);
$fileatt_name = "".$dbname."-".$date."_sql.tar.gz";
$headers = "From: $from";
// Read the file to be attached ('rb' = read binary)
$file = fopen($filename2,'rb');
$data = fread($file,filesize($filename2));
fclose($file);
// Generate a boundary string
$semi_rand = md5(time());
$mime_boundary =
"==Multipart_Boundary_x{$semi_rand}x";
// Add the headers for a file attachment
$headers .= "\nMIME-Version: 1.0\n" ."Content-Type:
multipart/mixed;\n" ." boundary=\"{$mime_boundary}\"";
// Add a multipart boundary above the plain message
$message = "This is a multi-part message in MIME
format.\n\n" ."--{$mime_boundary}\n" ."Content-Type: text/plain;
charset=\"iso-8859-1\"\n" ."Content-Transfer-Encoding: 7bit\n\n" .
$message . "\n\n";
// Base64 encode the file data
$data = chunk_split(base64_encode($data));
// Add file attachment to the message
$message .= "--{$mime_boundary}\n" ."Content-Type:
{$fileatt_type};\n" ." name=\"{$fileatt_name}\"\n"
."Content-Disposition: attachment;\n" ."
filename=\"{$fileatt_name}\"\n" ."Content-Transfer-Encoding:
base64\n\n" .
$data . "\n\n" ."--{$mime_boundary}--\n";
// Send the message
$ok = @mail($to, $subject, $message, $headers);
if ($ok) {
echo "<h4><center>Database backup created and sent! File name $filename2</center></h4>";
} else {
echo "<h4><center>Mail could not be sent. Sorry!</center></h4>";
}
}
if($use_ftp == "yes"){
$ftpconnect = "ncftpput -u $ftp_user_name -p
$ftp_user_pass -d debsender_ftplog.log -e dbsender_ftplog2.log -a -E
-V $ftp_server $ftp_path $filename2";
shell_exec($ftpconnect);
echo "<h4><center>$filename2 Was created and uploaded to your FTP server!</center></h4>";
}
if($remove_gzip_file=="yes"){
exec("rm -r -f $filename2");
}
?>
-
Hi All
I am trying to setup a cron to run dbsender.php, i get the following error email back when it tried to run, it also puts this in the error log in the /home/systemte/public_html/dbsender directory. Any ideas ? I dont own the server. ??
[03-Aug-2006 18:00:01] PHP Warning: passthru() has been disabled for security reasons in /home/systemte/public_html/dbsender/dbsender.php on line 50
[03-Aug-2006 18:00:02] PHP Warning: filetype(): Lstat failed for (null) (errno=2 - No such file or directory) in /home/systemte/public_html/dbsender/dbsender.php on line 72
[03-Aug-2006 18:00:02] PHP Warning: fopen(/home/systemtek/public_html/dbsender/systemte_phpbb1-080306-0600pm_sql.tar.gz): failed to open stream: No such file or directory in /home/systemte/public_html/dbsender/dbsender.php on line 80
[03-Aug-2006 18:00:02] PHP Warning: filesize(): Stat failed for /home/systemtek/public_html/dbsender/systemte_phpbb1-080306-0600pm_sql.tar.gz (errno=2 - No such file or directory) in /home/systemte/public_html/dbsender/dbsender.php on line 81
[03-Aug-2006 18:00:02] PHP Warning: fread(): supplied argument is not a valid stream resource in /home/systemte/public_html/dbsender/dbsender.php on line 81
[03-Aug-2006 18:00:02] PHP Warning: fclose(): supplied argument is not a valid stream resource in /home/systemte/public_html/dbsender/dbsender.php on line 82
-
Hi, sorry i am new to MySQL !, OK i read up and sucessfully created a username and password in mysql, so i try to install the XMB as per the instructions by running the install.html file, the first bit goes ok then i get this error :
Notice: Undefined variable: list in c:inetpubwwwrootforumxmb.php on line 65
Database connection error!!!
A connection to the Database could not be established.
Please check your username, password, database name and host.
Also make sure config.php is rightly configured!
When connecting, the database returned:
Error 1045: Access denied for user: \'systemtek2@localhost\' (Using password: YES)
The username and password in config.php match that i created as a mysql user.....what can be wrong here ?
Thanks
Duncan
-
Hi and thanks for reply, i have been looking into this past few days, can anyone tell me, on a server win 2000 on IIS5 with PHP enabled and mysql if i install a forum such as XMB or whatever will i have to manually create tables etec in mysql how does it work ? thanks
-
Hi All, i am never used MySql before and need a littel bit of help. I have a web server that i have enabled php on as i wish to do a forum and this uses the php and MySql to run. I think the php has installed ok. I am having problems with the MySql part, i am not familiar with SQL at all. I have installed MySql ver 4.0.16 for windows and i am unsure how to configure it, when i point my browser at my php code i get this :
Database connection error!!!
A connection to the Database could not be established.
Please check your username, password, database name and host.
Also make sure config.php is rightly configured!
When connecting, the database returned:
Error 1045: Access denied for user: \'systemtek2@localhost\' (Using password: YES)
I have got a my.cnf in root of drive on the web box but really need help if possibe how to get this going, i dont know where in mysql i add my username and password etc etc or how to set it up, could not understand the guide i read.
Any help would be apreciated
Duncan
simple cookie question
in Third Party Scripts
Posted
http://www.websitepublisher.net/article/php_cookies/