My Little Scripts - blog-sign-up-create.php - PHP ASP Scripts, JavaScript, HTML

<?
$hostname = "localhost";
$database = "";
$username = "";
$password = "";
include("blog-functions.php");

$isLogged = @isLogged();

$create_account = param("create_account");
$User_Name = param("User_Name");
$email = param("email");
$password = param("password");

$Valid_User_Name = Validate_String($User_Name, true);
$Valid_email = Verify_Email_Address($email);
$Valid_password = Check_Password($password);

$isSubmitted = false;
if($create_account == "true" &&
   $User_Name != "" &&
   $email != "" &&
   $password != "")
  {
   $isSubmitted = true;
  }

if($isSubmitted && $isLogged)
   mysql_select_db($database);

if($isSubmitted && $isLogged &&
   $Valid_User_Name === true &&
   $Valid_email && $Valid_password == "")
  {
  if(Table_Exists("users") == false)
    {
    $users = "create table users (" .
             "id int primary key auto_increment, " .
             "user_name varchar(255) unique, " .
             "email tinytext, " .
             "password tinytext, " .
             "pages int)";

    @mysql_query($users);
    }
  }

$User_Name_Exists = User_Name_Exists($User_Name);

if($isSubmitted && $isLogged &&
   $Valid_User_Name === true && $User_Name_Exists == false &&
   $Valid_email && $Valid_password == "")
  {
  if(is_dir("./" . $User_Name) == false)
    {
    mkdir("./" . $User_Name, 0775);
    }

  $user = "insert into users (user_name, email, password, pages) values ('" .
          $User_Name . "', '" .
          $email . "', '" .
          md5($password) . "', " .
          "20)";

  @mysql_query($user);

  $pages = "create table " . $User_Name . "_pages (" .
           "id int primary key auto_increment, " .
           "layout int not null, " .
           "title tinytext, " .
           "keywords tinytext, " .
           "width varchar(20), " .
           "number int not null)";

  @mysql_query($pages);

  $layout = "create table " . $User_Name . "_layout (" .
            "id int primary key auto_increment, " .
            "page_id int not null, " .
            "paragraph_id int, " .
            "image_id int, " .
            "location int not null, " .
            "align varchar(10), " .
            "valign varchar(10))";

  @mysql_query($layout);

  $paragraphs = "create table " . $User_Name . "_paragraphs (" .
                "id int primary key auto_increment, " .
                "title tinytext, " .
                "body text)";

  @mysql_query($paragraphs);

  $images = "create table " . $User_Name . "_images (" .
            "id int primary key auto_increment, " .
            "file_name tinytext, " .
            "caption tinytext, " .
            "bytes blob)";

  @mysql_query($images);
  }
?>
<html>
<head>
<title>FullPages.org create account</title>

<script>
function setCookie(name, value)
         {
         //If name is the empty string, it places a ; at the beginning
         //of document.cookie, causing clearCookies() to malfunction.
         if(name != '')
            document.cookie = name + '=' + value;
         }

function clearCookie(name)
         {
         expires = new Date();
         expires.setYear(expires.getYear() - 1);

         document.cookie = name + '=null' + '; expires=' + expires;
         }
</script>

<style>
.prompt
{
color:000000;
font-weight:bold;
}

.error
{
color:884444;
}

.background
{
background-color:ddddff;
border-style:solid;
border-color:000000;
border-width:1px;
}
</style>
</head>

<body>

<table width="100%" height="100%" cellpadding="0" cellspacing="0" class="background">
<tr><td align="center" valign="middle">
<table>
<? if($isSubmitted && $isLogged &&
      $Valid_User_Name === true && $User_Name_Exists == false &&
      $Valid_email && $Valid_password == "") { ?>
     <tr>
     <td><a href="mailto:<?= $email ?>?subject=fullpages.org" class="prompt"><?= $email ?></a></td>
     </tr>
     <tr>
     <td>
     <?
     $Welcoming_text =
     "Greatings and welcome to FullPages.org, " . $User_Name . "!";
     ?>
     <textarea cols="80" rows="20" nowrap><?= $Welcoming_text ?></textarea>
     </td>
     </tr>
     <tr>
     <td>
     <input type="button" value="log out"
            onclick="clearCookie('UserName');
                     clearCookie('PassWord');
                     document.EmptyForm.submit();">
     </td>
     </tr>
     <form name="EmptyForm" method="post">
     </form>
<? } ?>

<? if($isLogged &&
     ($isSubmitted == false ||
      $Valid_User_Name === false || $User_Name_Exists == true ||
      $Valid_email == false || $Valid_password != "")) { ?>
     <form method="post">
     <input type="hidden" name="create_account" value="true" />
     <? if($Valid_User_Name !== true && $isSubmitted == true) { ?>
     <tr><td colspan="2" class="error">The user name you chose contained the following invalid characters:
     <br /><?= $Valid_User_Name ?></td></tr>
     <? } ?>
     <? if($User_Name_Exists == true && $isSubmitted == true) { ?>
     <tr><td colspan="2" class="error">
     <?= $User_Name ?> is already taken, please choose another user name</td></tr>
     <? } ?>
     <tr>
     <td class="prompt">User Name</td>
     <td align="right"><input type="text" name="User_Name" value="<?= $User_Name ?>" /></td>
     </tr>
     <? if($Valid_email != true && $isSubmitted == true) { ?>
     <tr><td colspan="2" class="error">The Email address you have submitted is invalid</td></tr>
     <? } ?>
     <tr>
     <td class="prompt">Email Address</td>
     <td align="right"><input type="text" name="email" value="<?= $email ?>" /></td>
     <? if($Valid_password != "" && $isSubmitted == true) { ?>
     <tr><td colspan="2" class="error"><?= $Valid_password ?></td></tr>
     </tr>
     <? } ?>
     <tr>
     <td class="prompt">Password</td>
     <td align="right"><input type="text" name="password" value="<?= $password ?>" /></td>
     </tr>
     <tr>
     <td colspan="2" align="right">
     <input type="button" value="log out"
            onclick="clearCookie('UserName');
                     clearCookie('PassWord');
                     document.EmptyForm.submit();">
     <input type="submit" value="create account" />
     </td>
     </tr>
     </form>
     <form name="EmptyForm" method="post">
     </form>
<? } ?>





<? if($isLogged == false) { ?>
     <form name="login">
     <tr>
     <td class="prompt">User Name</td>
     <td><input type="text" name="UserName" /></td>
     </tr>

     <tr>
     <td class="prompt">Password</td>
     <td><input type="password" name="PassWord" /></td>
     </tr>

     <tr>
     <td colspan="2" align="right">
     <input type="button" value="log in"
            onclick="setCookie('UserName', document.login.UserName.value);
                     setCookie('PassWord', document.login.PassWord.value);
                     document.EmptyForm.submit();">
     </td>
     </tr>
     </form>

     <form name="EmptyForm" method="post">
     </form>
<? } ?>

</table></td></tr>
</table>

</body>
</html>

<?
$hostname = "localhost";
$database = "";
$username = "";
$password = "";
include("blog-functions.php");

$isLogged = @isLogged();

$create_account = param("create_account");
$User_Name = param("User_Name");
$email = param("email");
$password = param("password");

$Valid_User_Name = Validate_String($User_Name, true);
$Valid_email = Verify_Email_Address($email);
$Valid_password = Check_Password($password);

$isSubmitted = false;
if($create_account == "true" &&
   $User_Name != "" &&
   $email != "" &&
   $password != "")
  {
   $isSubmitted = true;
  }

if($isSubmitted && $isLogged)
   mysql_select_db($database);

if($isSubmitted && $isLogged &&
   $Valid_User_Name === true &&
   $Valid_email && $Valid_password == "")
  {
  if(Table_Exists("users") == false)
    {
    $users = "create table users (" .
             "id int primary key auto_increment, " .
             "user_name varchar(255) unique, " .
             "email tinytext, " .
             "password tinytext, " .
             "pages int)";

    @mysql_query($users);
    }
  }

$User_Name_Exists = User_Name_Exists($User_Name);

if($isSubmitted && $isLogged &&
   $Valid_User_Name === true && $User_Name_Exists == false &&
   $Valid_email && $Valid_password == "")
  {
  if(is_dir("./" . $User_Name) == false)
    {
    mkdir("./" . $User_Name, 0775);
    }

  $user = "insert into users (user_name, email, password, pages) values ('" .
          $User_Name . "', '" .
          $email . "', '" .
          md5($password) . "', " .
          "20)";

  @mysql_query($user);

  $pages = "create table " . $User_Name . "_pages (" .
           "id int primary key auto_increment, " .
           "layout int not null, " .
           "title tinytext, " .
           "keywords tinytext, " .
           "width varchar(20), " .
           "number int not null)";

  @mysql_query($pages);

  $layout = "create table " . $User_Name . "_layout (" .
            "id int primary key auto_increment, " .
            "page_id int not null, " .
            "paragraph_id int, " .
            "image_id int, " .
            "location int not null, " .
            "align varchar(10), " .
            "valign varchar(10))";

  @mysql_query($layout);

  $paragraphs = "create table " . $User_Name . "_paragraphs (" .
                "id int primary key auto_increment, " .
                "title tinytext, " .
                "body text)";

  @mysql_query($paragraphs);

  $images = "create table " . $User_Name . "_images (" .
            "id int primary key auto_increment, " .
            "file_name tinytext, " .
            "caption tinytext, " .
            "bytes blob)";

  @mysql_query($images);
  }
?>
<html>
<head>
<title>FullPages.org create account</title>

<script>
function setCookie(name, value)
         {
         //If name is the empty string, it places a ; at the beginning
         //of document.cookie, causing clearCookies() to malfunction.
         if(name != '')
            document.cookie = name + '=' + value;
         }

function clearCookie(name)
         {
         expires = new Date();
         expires.setYear(expires.getYear() - 1);

         document.cookie = name + '=null' + '; expires=' + expires;
         }
</script>

<style>
.prompt
{
color:000000;
font-weight:bold;
}

.error
{
color:884444;
}

.background
{
background-color:ddddff;
border-style:solid;
border-color:000000;
border-width:1px;
}
</style>
</head>

<body>

<table width="100%" height="100%" cellpadding="0" cellspacing="0" class="background">
<tr><td align="center" valign="middle">
<table>
<? if($isSubmitted && $isLogged &&
      $Valid_User_Name === true && $User_Name_Exists == false &&
      $Valid_email && $Valid_password == "") { ?>
     <tr>
     <td><a href="mailto:<?= $email ?>?subject=fullpages.org" class="prompt"><?= $email ?></a></td>
     </tr>
     <tr>
     <td>
     <?
     $Welcoming_text =
     "Greatings and welcome to FullPages.org, " . $User_Name . "!";
     ?>
     <textarea cols="80" rows="20" nowrap><?= $Welcoming_text ?></textarea>
     </td>
     </tr>
     <tr>
     <td>
     <input type="button" value="log out"
            onclick="clearCookie('UserName');
                     clearCookie('PassWord');
                     document.EmptyForm.submit();">
     </td>
     </tr>
     <form name="EmptyForm" method="post">
     </form>
<? } ?>

<? if($isLogged &&
     ($isSubmitted == false ||
      $Valid_User_Name === false || $User_Name_Exists == true ||
      $Valid_email == false || $Valid_password != "")) { ?>
     <form method="post">
     <input type="hidden" name="create_account" value="true" />
     <? if($Valid_User_Name !== true && $isSubmitted == true) { ?>
     <tr><td colspan="2" class="error">The user name you chose contained the following invalid characters:
     <br /><?= $Valid_User_Name ?></td></tr>
     <? } ?>
     <? if($User_Name_Exists == true && $isSubmitted == true) { ?>
     <tr><td colspan="2" class="error">
     <?= $User_Name ?> is already taken, please choose another user name</td></tr>
     <? } ?>
     <tr>
     <td class="prompt">User Name</td>
     <td align="right"><input type="text" name="User_Name" value="<?= $User_Name ?>" /></td>
     </tr>
     <? if($Valid_email != true && $isSubmitted == true) { ?>
     <tr><td colspan="2" class="error">The Email address you have submitted is invalid</td></tr>
     <? } ?>
     <tr>
     <td class="prompt">Email Address</td>
     <td align="right"><input type="text" name="email" value="<?= $email ?>" /></td>
     <? if($Valid_password != "" && $isSubmitted == true) { ?>
     <tr><td colspan="2" class="error"><?= $Valid_password ?></td></tr>
     </tr>
     <? } ?>
     <tr>
     <td class="prompt">Password</td>
     <td align="right"><input type="text" name="password" value="<?= $password ?>" /></td>
     </tr>
     <tr>
     <td colspan="2" align="right">
     <input type="button" value="log out"
            onclick="clearCookie('UserName');
                     clearCookie('PassWord');
                     document.EmptyForm.submit();">
     <input type="submit" value="create account" />
     </td>
     </tr>
     </form>
     <form name="EmptyForm" method="post">
     </form>
<? } ?>





<? if($isLogged == false) { ?>
     <form name="login">
     <tr>
     <td class="prompt">User Name</td>
     <td><input type="text" name="UserName" /></td>
     </tr>

     <tr>
     <td class="prompt">Password</td>
     <td><input type="password" name="PassWord" /></td>
     </tr>

     <tr>
     <td colspan="2" align="right">
     <input type="button" value="log in"
            onclick="setCookie('UserName', document.login.UserName.value);
                     setCookie('PassWord', document.login.PassWord.value);
                     document.EmptyForm.submit();">
     </td>
     </tr>
     </form>

     <form name="EmptyForm" method="post">
     </form>
<? } ?>

</table></td></tr>
</table>

</body>
</html>

BLOG-SIGN-UP-CREATE.PHP