How can I manually create an admin?

[michaeldebruin]

hello,

I want to make my own website, with a login system. So I've downloaded a ready one. But now I had to install it by running the setup.php, which should provide me a admin account. The only problem is that when I full in the form to install it. It can't create an admin account because of a failure. As a solution it says that I have to create an admin account myself manually, but I have to make sure that the password is md5 coded. And now comes the question, how can I do that?
If you have another login system for me which is very safe, and easy to use and easy to install on my website, please tell me and give me the download link.
Thanks in advance.

Here is the code from the setup.php file

<?
include("config.php");
include("htmltop.php");
 
if(isset($_POST['submit'])) {
 if($_POST['pass'] == $_POST['pass2']) {
  $sql = "DROP TABLE IF EXISTS `gebruikers`;";
  $query = mysql_query($sql);
  if($query == TRUE) {
   echo "Indien er oude tabellen waren met de naam gebruikers, zijn deze verwijderd...<br />\n";
   $sql = "CREATE TABLE `gebruikers` (`id` int(11) NOT NULL auto_increment,`naam` varchar(50) NOT NULL default '',`wachtwoord` varchar(50) NOT NULL default '',`status` char(1) NOT NULL default '0',`email` varchar(100) NOT NULL default '',`actief` char(1) NOT NULL default '0',`actcode` varchar(15) NOT NULL default '',`lastactive` datetime NOT NULL default '0000-00-00 00:00:00',PRIMARY KEY  (`id`)) TYPE=MyISAM AUTO_INCREMENT=1";
   $query = mysql_query($sql);
   if($sql == TRUE) {
    echo "De tabel 'gebruikers' is succesvol aangemaakt...<br />\nAdministrator account met naam '".$_POST['user']."' zal nu worden aangemaakt...<br />\n";
    $md5pass = md5($_POST['pass']);
    $sql = "INSERT INTO gebruikers (naam,wachtwoord,status,email,actief) VALUES ('".$_POST['user']."','".$md5pass."',1,'".$_POST['email']."',1)";
    $query = mysql_query($sql);
    if($query == TRUE) {
     echo "De Administrator is succesvol aangemaakt, de gebruikersnaam van de Administrator is: '".$_POST['user']."'...<br />\n";
     $del = unlink("setup.php");
     if($del == TRUE) {
      echo "Het bestand 'setup.php' is succesvol verwijderd...<br />\n";
      echo "<p />\n";
      echo "Installatie compleet. Je kunt nu gebruik maken van het script. Bedankt voor het gebruik maken van dit script!";
     }else{
      echo "Er is een fout opgetreden bij het verwijderen van het bestand 'setup.php'. Verwijder dit bestand handmatig!<br />\n";
     }
    }else{
     echo "Er is een fout opgetreden bij het aanmaken van de Administrator. je kunt het handmatig proberen met bv. PhpMyAdmin (wachtword moet MD5 coded zijn!)...<br />\n";
    }
   }else{
    echo "Er is een fout opgetreden bij het maken van de tabel. Weet je zeker dat je MySQL-instellingen in config.php kloppen?<br />\n";
   }
  }else{
   echo "Er is een fout opgetreden bij het verwijderen van eventuele oude gebruikers-tabellen. Controleer de MySQL-instellingen in config.php<br />\n";
  }
 }else{
  echo "De twee wachtwoorden komen niet overeen.<br />\n<a href=\"javascript:history.back()\">&laquo; Ga terug</a>";
 }
}else{
 ?>
 <form method="post" action="setup.php">
  <table>
   <tr>
    <td>Administrator naam:</td><td><input type="text" name="user" maxlength="50" /> <small>(de inlognaam voor de administraotr)</small></td>
   </tr>
   <tr>
    <td>Wachtwoord:</td><td><input type="password" name="pass" /></td>
   </tr>
   <tr>
    <td>Herhaal:</td><td><input type="password" name="pass2" /></td>
   </tr>
   <tr> 
    <td>E-mail:</td><td><input type="text" name="email" maxlength="100" /></td>
   </tr>
   <tr>
    <td></td><td><input type="submit" name="submit" value="Installeren" /></td>
   </tr>
  </table>
 </form>
 <?
}
include("htmlbottom.php");
?> 
 

[Atli]

The SQL query on line 16 is what creates you account. To do it manually, just copy it, fill it out by hand, and execute it on your MySQL server.

MySQL has it's own MD5 function, so you can just do MD5('yourpass') where the password should go.

Just to point this out. MD5 is a very very weak algorithm. It really shouldn't be used for password security these days. The SHA-2 family, or Whirlpool, is much more secure. - Not to mention that you should at least be salting the hash, and even re-hashing it a few thousand times.


If you are looking for a decent quality CMS system that you can just plop onto your server and run without having to mess with the code, consider trying something like Drupal or Joomla. WordPress is also good, but requires a bit more coding to be effective.