Dear friends,
i have developed an install file for phpnuke 7.3.0 . .
this is my code :
------------------- install.php -------------
<html dir="LTR">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>PHP-NUKE 7.3.0 FINAL INSTALLATION</title>
</head>
<body>
<?php
include("mainfile.php");
function display_alter($result, $table) {
global $prefix, $dbi;
if (!$result) {
echo "<font color=\"#CC0000\"><b> ** Error Altering Table: $table **</b></font><br><br>";
} else {
echo " -- Table <b>$table</b> altered successfully.<br><br>";
}
}
function display_create($result, $table) {
global $prefix, $dbi;
if (!$result) {
echo "<font color=\"#CC0000\"><b> ** Error Creating Table: $table **</b></font><br><br>";
} else {
echo " -- Table <b>$table</b> created successfully.<br><br>";
}
}
function display_dump($result, $table) {
global $prefix, $dbi;
if (!$result) {
echo "<font color=\"#CC0000\"><b> ** Dump Error for Table: $table **</b></font><br><br>";
} else {
echo " -- Table Dump for <b>$table</b> successful.<br><br>";
}
}
function SSNhead(){
echo "<body bgcolor=\"#0E3259\" text=\"#000000\" link=\"#0000ff\" topmargin=\"2\" leftmargin=\"0\"><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"840\" align=\"center\">\n"
."<tr><td width=\"100%\">\n"
."<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" width=\"840\" bgcolor=\"#d3e2ea\"><tr><td width=\"100%\">\n"
."<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"840\">\n"
."<tr><td width=\"100%\" height=\"88\" bgcolor=\"#FFFFFF\">\n"
."<table border=0 width=100% cellpadding=0 cellspacing=0><tr>\n"
."<TD align=left></a><A target=\"_blank\" href=\"http://www.phpnuke.org\"><IMG hspace=10 src=\"images/logo.gif\" alt=\"SSN INSTALLER FILE\" border=0></A></TD>\n"
."<TD align=right><IMG src=\"images/logo-graphic.gif\" border=0></TD></TR></TBODY></TABLE></TD></TR>\n"
."<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\"><tr><td bgcolor=\"#d3e2ea\">\n"
."<div align=\"center\">\n"
."<center>\n"
."<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"100%\" id=\"AutoNumber1\">\n"
."</table>\n"
."</center>\n"
."</div>\n";
}
function SSNfoot(){
echo "<br></td></tr></table>\n";
echo "<center><br><a target=\"_blank\" href=\"http://www.iranportals.com\"><img src=\"images/powered/powered6.jpg\" border=\"0\" alt=\"POWERED BY: IRANPORTALS\"></a>";
echo "</center>";
}
function main(){
require("config.php");
SSNhead();
echo "<div align=\"center\"><br><b><H2>WELCOME TO <font color=\"#FF0000\">SSNUKE </font>INSTALLER .::. 7.3.0 FINAL </H2></b></div>";
$SSNsitekey = $sitekey;
if($SSNsitekey=="SdFk*fa28367-dm56w69.3a2fDS+e9")
{
echo "<div align=\"center\"><H2><font color=\"#FF0000\">WARNING! WARNING! WARNING!</font><hr>PLEASE OPEN CONFIG.PHP FILE AND CHANGE THE SITEKEY VALUE!!</div></H2>";
}
else {
echo "<div align=\"center\"><a href=\"".$_SERVER['PHP_SELF']."?act=license\"><b>LICENSE CHECK</b></a></div><br>";
}
SSNfoot();
}
function license() {
SSNhead();
echo"<center>Please enter your license code here:</center>";
echo "<center><form name=\"form\" action=\"http://www.mysite.com/search.php\" method=\"post\">"
. "<input type=\"text\" name=\"q\"/>"
. "<input type=\"submit\" name=\"Submit\" value=\"License Check\" />"
."</form></center>";
SSNfoot();
}
function install() {
global $prefix, $dbi;
SSNhead();
#######################################################
# Table structure for table 'nuke_ns_contact_show' #
#######################################################
$result = mysql_query("create table ".$prefix."_ns_contact_show (
show_add tinyint(1) NOT NULL default '1'
)");
display_create($result, "".$prefix."_ns_contact_show");
#######################################################
# Table structure for table 'nuke_ns_contact_dept' #
#######################################################
$result = mysql_query("create table ".$prefix."_ns_contact_dept (
did int(3) NOT NULL auto_increment,
dept_name varchar(60) default NULL,
dept_email varchar(60) default NULL,
PRIMARY KEY (did),
KEY did (did)
)");
display_create($result, "".$prefix."_ns_contact_dept");
#######################################################
# Table structure for table 'nuke_ns_contact_phone' #
#######################################################
$result = mysql_query("create table ".$prefix."_ns_contact_phone (
pid int(3) NOT NULL auto_increment,
phone_name varchar(60) default NULL,
phone_num varchar(60) default NULL,
fax_num varchar(60) default NULL,
PRIMARY KEY (pid),
KEY pid (pid)
)");
display_create($result, "".$prefix."_ns_contact_phone");
#######################################################
# Table structure for table 'nuke_ns_contact_add' #
#######################################################
$result = mysql_query("create table ".$prefix."_ns_contact_add (
address text NOT NULL
)");
display_create($result, "".$prefix."_ns_contact_add");
#######################################################
# Dumping Values #
#######################################################
$result = mysql_query("insert into ".$prefix."_ns_contact_show values ('1')");
display_dump($result, "".$prefix."_ns_contact_show");
$result = mysql_query("insert into ".$prefix."_ns_contact_dept values (1,'Test Department','Test Email')");
display_dump($result, "".$prefix."_ns_contact_dept");
$result = mysql_query("insert into ".$prefix."_ns_contact_phone values (1,'Phone Test','1-800-TEST','1-800-TEST2')");
display_dump($result, "".$prefix."_ns_contact_phone");
$result = mysql_query("insert into ".$prefix."_ns_contact_add values ('Adress Info')");
display_dump($result, "".$prefix."_ns_contact_add");
echo "<font color=\"darkgreen\">database tables are now installed.</font><br><br>";
SSNfoot();
}
switch($act){
default:
main();
break;
case "license":
license();
break;
case "install":
install();
break;
case "SSNhead":
nukesqlhead();
break;
case "SSNfoot":
nukesqlfoot();
break;
}
?>
</body>
</html>
---------------------- search.php ------------
<?php
$var = @$_POST['q'] ;
$trimmed = trim($var);
if ($trimmed == "")
{
echo "<p>Please enter your license code</p>";
exit;
}
if (!isset($var))
{
echo "<p>We dont seem to have a search parameter!</p>";
exit;
}
mysql_connect("localhost","admin","best");
mysql_select_db("license") or die("Unable to select database");
$query = "select * from main where license like \"%$trimmed%\"
order by license";
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
if ($numrows == 0)
{
echo "<center><h4><font color=\"#ff0000\">Your license code is invalid!</h4></font></center>";
echo "<center><a target=\"_blank\" href=\"http://www.iranportals.com/sales/cgi-bin/client.cgi\">Club Membership</a></center>";
}
else {
echo "<div align=\"center\"><a href=\"ssninstaller.php?act=install\"><b>INSTALL DATABASE</b></a></div><br>";
}
?>
-------------------------------------------
first file (install.php) is on customer server and search.php located on my server !
how can i come back to first file (install.php) after license check function ?
can you modify my code !
regards
