Hello,
I am trying to install this free script:
---------------
3. Installation
To install MyMail, follow these simple steps and you'll be creating lists in no time.
- Unzip file contents to a folder
- FTP into your server and upload MyMail
- CHMOD config.php to 777 and the admin directory to 777
- Run install.php by going to: http://www.yourdomain.com/MyMail/admin/install.php
Make sure to change the domain and paths to MyMail. - Once Installation is complete remove the install.php file
- If installation failed, observe the error message and try to fix the problem.
If you cannot solve the problem, go to: http://forum.codingclick.com to get support. - After you've complete installation and deleted the install.php file go to
http://www.yourdomain.com/MyMail/admin/ and enter your username and password then create
a list. - After creating a list, you can edit footers/headers for mail, and templates via the
template section. You also need to add the subscribe box to your page. You can get the
code via the 'Get HTML' section. - After this, you can promote your list and send email via the 'Send' function.
I think I already follow all the installation instruction:
install.php
<?php
include("files/g_header.php");
if(!$page) { ?>
<p><font size="2" face="Verdana">Before continuing with installation make sure
that the MyMail admin folder has been CHMOD'd to '777' (Read, Write and Execute
for all groups).</font></p>
<form name="settings" method="post" action="<?php echo $PHP_SELF; ?>">
<table border="0" cellspacing="0" cellpadding="0" width="309">
<tr>
<td width="207"><font face="Verdana" size="2">MySQL Username:</font></td>
<td width="86">
<input type="text" name="mysqluser">
</td>
</tr>
<tr>
<td width="207"><font face="Verdana" size="2">MySQL Password:</font></td>
<td width="86">
<input type="text" name="mysqlpass">
</td>
</tr>
<tr>
<td width="207"><font face="Verdana" size="2">MySQL Host:</font></td>
<td width="86">
<input type="text" name="mysqlhost" value="localhost">
</td>
</tr>
<tr>
<td width="207"><font face="Verdana" size="2">MySQL Database:</font></td>
<td width="86">
<input type="text" name="mysqldb">
</td>
</tr>
<tr>
<td width="207"><font face="Verdana" size="2">Path to MyMail Directory:
<font size="1">(Excluding Final Slash)</font></font></td>
<td width="86">
<input type="text" name="mymailpath" value="http://">
</td>
</tr><tr>
<td width="207"><font face="Verdana" size="2">Table Name Prefix:
</font></td>
<td width="86">
<input type="text" name="pre" value="mm_">
</td>
</tr>
<tr>
<td width="207">
<input type="hidden" name="page" value="2">
<input type="submit" name="Submit" value="Submit">
</td>
<td width="86"> </td>
</tr>
</table>
</form>
<?php
} elseif($page == 2) {
echo "<font face='Verdana' size='2'>";
$cnx = mysql_connect($mysqlhost, $mysqluser, $mysqlpass);
if(!$cnx) {
echo "Testing Database Connection: <b>FAILED</b><br>";
} else {
echo "Testing Database Conenction: Pass<br>";
$scnx = mysql_select_db($mysqldb);
}
$string = "<?php\n
ob_start();\n
\$mysqluser = \"$mysqluser\";\n
\$mysqlpass = \"$mysqlpass\";\n
\$mysqlhost = \"$mysqlhost\";\n
\$mysqldbname = \"$mysqldb\";\n
\$mymailpath = \"$mymailpath\";\n
\$pre = \"$pre\"\n
?>";
@unlink("config.php");
$handle = fopen("config.php",'w+');
$add = fputs($handle, $string);
@fclose($handle);
if(!$add) {
echo "Creating Config File: <b>FAILED</b><br";
echo "Look in the docs directory for directions under: config.txt";
} else {
echo "Creating Config File: Pass<br>";
}
echo "<br>If the above have failed, go back and correct the
information. Otherwise, click next to create the database.</font>";
?>
<form action="<?php echo $PHP_SELF; ?>">
<input type="submit" name="Submit" value="Next">
<input type="hidden" name="page" value="3">
</form>
<?php
} elseif($page == 3) {
include("config.php");
echo "<font face='verdana' size='2'>";
$cnx = mysql_connect($mysqlhost, $mysqluser, $mysqlpass);
if(!$cnx) {
echo "Cannot connect do the mysql. Please go back and change the details.";
} else {
$query = mysql_query("CREATE DATABASE $mysqldbname");
if(!$query) {
echo "Trying to Create Database: <b>FAILED</b><br>";
echo "Unable to create database. Please create it manually before clicking next.";
} else {
echo "Trying to Create Database: Pass<br>";
}
}
?>
<form action="<?php echo $PHP_SELF; ?>">
<input type="submit" name="Submit" value="Next">
<input type="hidden" name="page" value="4">
</form>
<?php
echo "</font>";
} elseif($page == 4) {
include("config.php");
echo "<font face='verdana' size='2'>";
$cnx = mysql_connect($mysqlhost, $mysqluser, $mysqlpass);
if(!$cnx) {
echo "Cannot connect to database. Please go back and change the details.";
} else {
mysql_select_db($mysqldbname);
$sqllist = "CREATE TABLE " . $pre . "lists (
ID int(11) NOT NULL auto_increment,
t_name varchar(20) NOT NULL,
Name varchar(50) NOT NULL,
Subject varchar(255) NOT NULL,
Email varchar(150) NOT NULL,
Description varchar(255) NOT NULL,
WelcomeTitle varchar(255),
Welcome text,
ConfirmTitle varchar(255),
Confirm text,
GoodbyeTitle varchar(255),
Goodbye text,
Send_Welcome tinyint(4) DEFAULT '0' NOT NULL,
Send_Goodbye tinyint(4) DEFAULT '0' NOT NULL,
Send_Confirm tinyint(4) DEFAULT '0' NOT NULL,
Send_UnConfirm tinyint(4) DEFAULT '0' NOT NULL,
UnConfirmTitle varchar(255) NOT NULL,
UnConfirm text NOT NULL,
archive tinyint(4) DEFAULT '0' NOT NULL,
archiveHeader varchar(150) NOT NULL,
archiveFooter varchar(150) NOT NULL,
use_name tinyint(4) DEFAULT '0' NOT NULL,
fontColor varchar(20) NOT NULL,
fontFace varchar(40) NOT NULL,
fontSize int(11) DEFAULT '0' NOT NULL,
use_html tinyint(4) DEFAULT '0' NOT NULL,
use_templates tinyint(4) DEFAULT '0' NOT NULL,
generalHeader varchar(255) NULL,
generalFooter varchar(255) NULL,
PRIMARY KEY (ID)
)";
$sqluser = "CREATE TABLE " . $pre . "users (
ID int(11) NOT NULL auto_increment,
Name varchar(50) NOT NULL,
Email varchar(150) NOT NULL,
Username varchar(20) NOT NULL,
Password varchar(20) NOT NULL,
a_list tinyint(4) DEFAULT '0' NOT NULL,
e_list tinyint(4) DEFAULT '0' NOT NULL,
d_list tinyint(4) DEFAULT '0' NOT NULL,
c_list tinyint(4) DEFAULT '0' NOT NULL,
t_list tinyint(4) DEFAULT '0' NOT NULL,
a_email tinyint(4) DEFAULT '0' NOT NULL,
d_email tinyint(4) DEFAULT '0' NOT NULL,
e_email tinyint(4) DEFAULT '0' NOT NULL,
v_email tinyint(4) DEFAULT '0' NOT NULL,
a_archive tinyint(4) DEFAULT '0' NOT NULL,
e_archive tinyint(4) DEFAULT '0' NOT NULL,
d_archive tinyint(4) DEFAULT '0' NOT NULL,
send_mail tinyint(4) DEFAULT '0' NOT NULL,
get_html tinyint(4) DEFAULT '0' NOT NULL,
users tinyint(4) DEFAULT '0' NOT NULL,
statistics tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (ID)
)";
$sqlarchive = "CREATE TABLE " . $pre . "archive (
ID int(11) NOT NULL auto_increment,
issueID int(11) DEFAULT '0' NOT NULL,
listID varchar(20) NOT NULL,
subject varchar(255) NOT NULL,
date date DEFAULT '0000-00-00' NOT NULL,
text text NOT NULL,
html text NOT NULL,
sent varchar(10) NOT NULL,
time varchar(20) NOT NULL,
archive int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (ID)
)";
$sqltemplate = "CREATE TABLE " . $pre . "templates (
ID int(11) NOT NULL auto_increment,
NameID varchar(20) NOT NULL,
Name varchar(200) NOT NULL,
Value text NOT NULL,
Type tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (ID)
)";
$qlist = mysql_query($sqllist);
if(!$qlist) {
echo "Creating List Table: <b>FAILED</b><br>";
echo mysql_error();
} else {
echo "Creating List Table: Pass<br>";
}
$quser = mysql_query($sqluser);
if(!$quser) {
echo "Creating Users Table: <b>FAILED</b><br>";
echo mysql_error();
} else {
echo "Creating Users Table: Pass<br>";
}
$qtemplate = mysql_query($sqltemplate);
if(!$qtemplate) {
echo "Creating Template Table: <b>FAILED</b><br>";
echo mysql_error();
} else {
echo "Creating Archive Table: Pass<br>";
}
$stuff[0] = "INSERT INTO " . $pre . "templates VALUES ( '', 'subsuc', 'Subscription Successful', 'You have successfully subscribed to the list.', '0')";
$stuff[1] = "INSERT INTO " . $pre . "templates VALUES ( '', 'confirmsuc', 'Confirmation Successful', 'You have successfully confirmed your sibscription to the list.', '0')";
$stuff[2] = "INSERT INTO " . $pre . "templates VALUES ( '', 'unsubsuc', 'Unsubscription Successful', 'You have successfully unsubscribed from the list.', '0')";
$stuff[3] = "INSERT INTO " . $pre . "templates VALUES ( '', 'unconfirmsuc', 'Unsubscription Successful', 'You have successfully confirmed your unsubscription from the list.', '0')";
$stuff[4] = "INSERT INTO " . $pre . "templates VALUES ( '', 'invalidemail', 'Invalid Email', 'The email you\'ve used is not a valid email address.', '0')";
$stuff[5] = "INSERT INTO " . $pre . "templates VALUES ( '', 'invaliduid', 'Invalid ID', 'The ID you\'ve used to modify your account is incorrect. Please try again.', '0')";
$stuff[6] = "INSERT INTO " . $pre . "templates VALUES ( '', 'invalidlist', 'Invalid List', 'The List you\'ve specified to join is invalid. Please try another list.', '0')";
$stuff[7] = "INSERT INTO " . $pre . "templates VALUES ( '', 'banned', 'Banned Email', 'The Email you are trying to add has been banned by the list administrator.', '0')";
$stuff[8] = "INSERT INTO " . $pre . "templates VALUES ( '', 'already', 'Email Already Subscribed', 'The email you entered has already been subscribed', '0')";
$stuff[9] = "INSERT INTO " . $pre . "templates VALUES ( '', 'noemail', 'No Email Entered', 'You didn\'t enter an email, please go back and enter one.', '0')";
$stuff[10] = "INSERT INTO " . $pre . "templates VALUES ( '', 'existemail', 'Email Doesn\'t Exist', 'The email you are specified doesn\'t exist.', '0')";
print "<font face='verdana' face='2'>Adding Template Data: ";
$num = count($stuff);
for($i = 0; $i < $num; $i++) {
$query = mysql_query($stuff[$i]);
if(!$query) {
print "<br>Cannot query the database.<br>";
print mysql_error();
} else {
print $i . ", ";
}
}
print "<br></font>";
$qarchive = mysql_query($sqlarchive);
if(!$qarchive) {
echo "Creating Archive Table: <b>FAILED</b><br>";
echo mysql_error();
} else {
echo "Creating Archive Table: Pass<br>";
}
echo "If any of the above are failed, look in the docs folder for instructions.<br>";
}
echo "</font>";
?>
<form action="<?php echo $PHP_SELF; ?>">
<input type="submit" name="Submit" value="Next">
<input type="hidden" name="page" value="5">
</form>
<?php
} elseif($page == 5) {
?>
<form action="<?php echo $PHP_SELF; ?>">
<font size="2" face="Verdana">Admin User Options:</font><br>
<br>
<table width="100" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><font face="Verdana" size="2">Name:</font></td>
<td>
<input type="text" name="name">
</td>
</tr>
<tr>
<td><font face="Verdana" size="2">Email:</font></td>
<td>
<input type="text" name="email">
</td>
</tr>
<tr>
<td><font face="Verdana" size="2">Username:</font></td>
<td>
<input type="text" name="username">
</td>
</tr>
<tr>
<td><font face="Verdana" size="2">Password:</font></td>
<td>
<input type="password" name="password">
</td>
</tr>
<tr>
<td><input type="submit" name="Submit" value="Next">
<input type="hidden" name="page" value="6">
</td>
<td> </td>
</tr>
</table>
</form>
<?php
} elseif($page == 6) {
include("config.php");
echo "<font face='verdana' size='2'";
$cnx = mysql_connect($mysqlhost, $mysqluser, $mysqlpass);
if(!$cnx) {
echo "Cannot connect to the database.";
} else {
mysql_select_db($mysqldbname);
$adduser = mysql_query("INSERT INTO " . $pre . "users VALUES ( '1', '$name', '$email', '$username', '$password', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1')");
if(!$adduser) {
echo "Adding Admin User: <b>FAILED<b><br>";
echo mysql_error();
echo "<br><br>Please manually add a user to the table.";
} else {
echo "Adding Admin User: Pass<br>";
}
echo "<br><br>Click here to login: <a href='login.php'>LOGIN</a>";
}
echo "</font>";
}
?>
If I press the submit button then this error appears:
Object not found!
The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.
If you think this is a server error, please contact the webmaster.
Error 404
localhost
11/15/2012 2:05:39 PM
Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1
Why is it?
