Re:installer&conv lang step1

[DigitalPixel]

         echo ""._STEP33." $dbname, "._STEP34."";
         $goon = 0;
      }
   }
   if($goon) // It's time to dump ;)
   {
      $fd = fopen ("$installdir/yabb.sql", "r");

      $query = "";
      $counter = 0;
      while (!feof ($fd)) {
         $line = fgets($fd, 4096);
         $line = chop($line);

         // add the prefix
         $tablesFrom = array(" log_karma", " log_banned", " log_boards", " banned", " boards", " categories", " censor", " instant_messages", " log_clicks", " log_floodcontrol", " log_mark_read", " log_online", " log_topics", " membergroups", " members", " messages", " polls", " reserved_names", " settings", " topics");
         $tablesTo = array(" {$dbprefix}log_karma"," {$dbprefix}log_banned", " {$dbprefix}log_boards", " {$dbprefix}banned", " {$dbprefix}boards", " {$dbprefix}categories", " {$dbprefix}censor", " {$dbprefix}instant_messages", " {$dbprefix}log_clicks", " {$dbprefix}log_floodcontrol", " {$dbprefix}log_mark_read", " {$dbprefix}log_online", " {$dbprefix}log_topics", " {$dbprefix}membergroups", " {$dbprefix}members", " {$dbprefix}messages", " {$dbprefix}polls", " {$dbprefix}reserved_names", " {$dbprefix}settings", " {$dbprefix}topics");
         $line = str_replace($tablesFrom, $tablesTo, $line);

         if(!ereg("^#",$line)) $query .= $line;
         if((ereg(";\n?$",$line) or feof($fd)) and $query != "") {
            $counter++;
            echo "<i>"._STEP35." $counter</i><br>";
            if (!mysql_query($query))
               print "<i>"._STEP36." ".mysql_error()."</i><br><br>\n";
            else
               print "<i>"._STEP37."</i><br><br>\n";
            $query = "";
         }
         if($count%200==0)
            set_time_limit(240);
      }
      fclose ($fd);

   echo"<center>
   <form action=\"install.php?step=5\" method=\"POST\">
   <input type=hidden name=\"dbuser\" value=\"$dbuser\">
   <input type=hidden name=\"dbpassword\" value=\"$dbpassword\">
   <input type=hidden name=\"dbprefix\" value=\"$dbprefix\">
   <input type=hidden name=\"dbname\" value=\"$dbname\">
   <input type=hidden name=\"dbserver\" value=\"$dbserver\">
   <input type=hidden name=\"installdir\" value=\"$installdir\">
   <input type=\"submit\" value=\""._STEP38."\">
   </form>
   </center>";
   
   }
}
elseif($step==5)
{
?>
<script>
   function updateFields() {
     if (document.layers || document.all || document.getElementById) {
       pForm = document.step6form;
      pForm.imagesdir.value = pForm.boardurl.value + "/YaBBImages";
      pForm.facesurl.value = pForm.boardurl.value + "/YaBBImages/avatars";
     }
   }
</script>
<?php
echo""._STEP39."
<form action=\"install.php?step=6\" method=\"POST\" name=\"step6form\">
<table border=0 cellspacing=0 cellpadding=3>
<tr>
   <td valign=top><b>"._STEP40."</b></td>
   <td><input type=text name=\"boardurl\" value=\"http://www.myserver.com/yabbse\" size=\"65\" onChange=\"updateFields();\"><br>
   <font size=1>"._STEP41."</font></td>
</tr>
<tr>
   <td valign=top><b>"._STEP42."</b></td>
   <td><input type=text name=\"imagesdir\" value=\"http://www.myserver.com/yabbse/YaBBImages\" size=\"65\"><br>
   <font size=1>"._STEP43."</font></td>
</tr>
<tr>
   <td valign=top><b>"._STEP44."</b></td>
   <td><input type=text name=\"facesurl\" value=\"http://www.myserver.com/yabbse/YaBBImages/avatars\" size=\"65\"><br>
   <font size=1>"._STEP45."</font></td>
</tr>
</table>
<center>
<input type=hidden name=\"dbuser\" value=\"$dbuser\">
<input type=hidden name=\"dbpassword\" value=\"$dbpassword\">
<input type=hidden name=\"dbprefix\" value=\"$dbprefix\">
<input type=hidden name=\"dbname\" value=\"$dbname\">
<input type=hidden name=\"dbserver\" value=\"$dbserver\">
<input type=hidden name=\"installdir\" value=\"$installdir\">
<input type=submit value=\""._STEP46."\">
</center>
</form>";

}
elseif($step==6)
{
$settingsArray = file("$installdir/Settings.php");
for ($i = 0; $i< sizeof($settingsArray); $i++)
   $settingsArray[$i]=trim($settingsArray[$i]);

// do the input ones
$settingsArray[42] = "\$boardurl = \"$boardurl\";            # URL of your board's folder (without trailing '/')";
$settingsArray[71] = "\$facesurl = \"$facesurl\";            # URL to your avatars folder";
$settingsArray[72] = "\$imagesdir = \"$imagesdir\";            # URL to your images directory";

$settingsArray[68] = "\$boarddir = \"$installdir\";             # The absolute path to the board's folder (usually can be left as '.')";

// now generate others
$settingsArray[69] = "\$sourcedir = \"$installdir/Sources\";             # Directory with YaBB source files";
$settingsArray[70] = "\$facesdir = \"$installdir/YaBBImages/avatars\";            # Absolute Path to your avatars folder";
$settingsArray[73] = "\$ubbcjspath = \"$boardurl/ubbc.js\";                           # Web path to your 'ubbc.js' REQUIRED for post/modify to work properly!";
$settingsArray[74] = "\$faderpath = \"$boardurl/fader.js\";            # Web path to your 'fader.js'";
$settingsArray[75] = "\$helpfile = \"$boardurl/YaBBHelp/index.html\";            # Location of your help file;";

$fp = fopen("$installdir/Settings.php", "w");
foreach($settingsArray as $row)
   fputs($fp, "$row\n");
fclose ($fp);


   echo "<center>
   <form action=\"install.php?step=7\" method=\"POST\">
   <br><br>"._STEP47."<br>
   <input type=hidden name=\"dbuser\" value=\"$dbuser\">
   <input type=hidden name=\"dbpassword\" value=\"$dbpassword\">
   <input type=hidden name=\"dbprefix\" value=\"$dbprefix\">
   <input type=hidden name=\"dbname\" value=\"$dbname\">
   <input type=hidden name=\"dbserver\" value=\"$dbserver\">
   <input type=hidden name=\"installdir\" value=\"$installdir\">
   <input type=\"submit\" value=\""._STEP48."\">
   </form>
   </center>";
   
}
elseif ($step==7)
{

echo ""._STEP49."
<form action=\"install.php?step=8\" method=\"POST\">
<table border=0 cellspacing=0 cellpadding=3>
<tr>
   <td valign=top><b>"._STEP50."</b></td>
   <td><input type=text name=\"username\" value=\"\"><br>
   <font size=1>"._STEP51."</font></td>
</tr>
<tr>
   <td valign=top><b>"._STEP52."</b></td>
   <td><input type=password name=\"password1\"><br>
   <font size=1>"._STEP53."</font></td>
</tr>
<tr>
   <td valign=top><b>"._STEP54."</b></td>
   <td><input type=password name=\"password2\"><br>
   <font size=1>"._STEP55."</font></td>
</tr>
<tr>
   <td valign=top><b>"._STEP56."</b></td>
   <td><input type=text name=\"email\" size=20></td>
</tr>
<tr>
   <td valign=top><b>"._STEP57."</b></td>
   <td><input type=checkbox name=\"skip\"> <font size=1>"._STEP58."</font></td>
</tr>
</table>
<center>
<input type=hidden name=\"installdir\" value=\"$installdir\">
<input type=hidden name=\"dbuser\" value=\"$dbuser\">
<input type=hidden name=\"dbpassword\" value=\"$dbpassword\">
<input type=hidden name=\"dbprefix\" value=\"$dbprefix\">
<input type=hidden name=\"dbname\" value=\"$dbname\">
<input type=hidden name=\"dbserver\" value=\"$dbserver\">
<input type=submit value=\""._STEP59."\">
</center>
</form>";

}
elseif($step == 8)
{
   include("$installdir/Settings.php");
   if ($skip != 'on')
   {
   if($password1 != $password2)
      die(""._STEP60."");
   $linkid = mysql_connect($db_server, $db_user, $db_passwd);
   mysql_select_db($db_name, $linkid);
   $queryPasswdPart = crypt($password1,substr($password1,0,2));
   // This will have to change obviously ;)
   $result=mysql_query("INSERT INTO {$db_prefix}members (memberName, realName, passwd, emailAddress, memberGroup, posts, personalText, avatar, dateRegistered, hideEmail) VALUES ('".addslashes($username)."', '".addslashes($username)."', '$queryPasswdPart', '$email', 'Administrator', '0', '', 'blank.gif', '".time()."', '0');");
   if (!$result){
   echo ""._STEP61." ".mysql_error();
   exit();}
print ""._STEP62."<br>";
   }


   echo"<form action=\"converter.php?step=1b\" method=\"POST\" name=\"theForm\">
   <input type=hidden name=\"installdir\" value=\"$installdir\">
   <input type=hidden name=\"dbuser\" value=\"$dbuser\">
   <input type=hidden name=\"dbpassword\" value=\"$dbpassword\">
   <input type=hidden name=\"dbprefix\" value=\"$dbprefix\">
   <input type=hidden name=\"dbname\" value=\"$dbname\">
   <input type=hidden name=\"dbserver\" value=\"$dbserver\">
   "._STEP63."<p><blockquote><a href=\"$boardurl/index.php\">"._STEP64."</a><br><a href=\"javascript:theForm.submit();\">"._STEP65."</a><blockquote><p>"._STEP66."<br>"._STEP67."</form>";
   
}

   echo"</td>
</tr>
</table></center>
</body>
</html>";
?>

[DigitalPixel]

-----------------
converter.php
-----------------
<?php

include 'lang.php';

echo "<html>
      <head>
      <title>"._CON0."</title>
      <style> <!-- body { font-family : Verdana; font-size : 10pt; } td { font-size : 10pt; } --> </style>
      </head>
      <body bgcolor=\"#FFFFFF\">
      <center><table border=0 cellspacing=1 cellpadding=4 bgcolor=\"#000000\" width=90%>
      <tr>
      <th bgcolor=\"#34699E\"><font color=\"#FFFFFF\">"._CON1."</font></th>
      </tr>
      <tr>
      <td bgcolor=\"#f0f0f0\">";

//Added to allow larger forums to convert without timing out - Jeff
set_time_limit(0);

if (!$step)
{
echo"<form action=\"converter.php?step=1a\" method=\"POST\">
     "._CON2."<p>
     "._CON3."
   <ul><li>"._CON4." <a href=\"install.php\">"._CON5."</a>.</li>
   <li>"._CON6."</li>
   <li>"._CON7."</li></ul>
<br><font size=1>"._CON8." <a href=\"http://www.yabb.info/community/\">"._CON9."</a>.</font><br>
<center>
<input type=submit value=\""._CON10."\">
</center>
</form>";

}
elseif($step == '1a')
{
   $mode = ini_get("safe_mode");
echo "<form action=\"converter.php?step=1b\" method=\"POST\">
"._CON11."<p>";

   if ($mode)
   {

echo ""._CON12."
      <ul>
      <li><i>"._CON13."</i> - "._CON14." template.html</li>
      <li><i>Settings.php "._CON15."</i> - "._CON16." Settings.php "._CON17."</li>
      </ul>
"._CON18."<p>";
   
   }
   else
   {
   
echo ""._CON19."<p>";
   
   }

echo "<center>
<input type=hidden name=\"from\" value=\"intro\">
<input type=submit value=\""._CON20."\">
</center>
</form>";


}
if($step=='1b')
{
   $y1gdir = $HTTP_SERVER_VARS["DOCUMENT_ROOT"]."/cgi-bin/YaBB";
   $y1gdir = str_replace("//","/",$y1gdir);
   $boardsdir = "$y1gdir/Boards";
   $membersdir = "$y1gdir/Members";
   $datadir = "$y1gdir/Messages";
   $vardir = "$y1gdir/Variables";

echo""._CON21."<br>";
?>
<script>
   function updateFields() {
     if (document.layers || document.all || document.getElementById) {
       pForm = document.step1bform;
      pForm.boardsdir.value = pForm.y1gdir.value + "/Boards";
      pForm.membersdir.value = pForm.y1gdir.value + "/Members";
      pForm.datadir.value = pForm.y1gdir.value +"/Messages";
      pForm.vardir.value = pForm.y1gdir.value + "/Variables";
     }
   }
</script>
<?php
echo" <form action=\"converter.php?\" method=\"POST\" name=\"step1bform\">
      <table border=0 cellspacing=0 cellpadding=3>
<tr>
   <td valign=top><b>"._CON22."</b></td>
   <td><input type=text name=\"y1gdir\" value=\"$y1gdir\" size=\"65\" onChange=\"updateFields();\"><br>
   <font size=1>"._CON23." settings.pl "._CON24." settings.php</font></td>
</tr>
<tr>
   <td valign=top><b>"._CON25."</b></td>
   <td><input type=text name=\"boardsdir\" value=\"$boardsdir\" size=\"65\"></td>
</tr>
<tr>
   <td valign=top><b>"._CON26."</b></td>
   <td><input type=text name=\"membersdir\" value=\"$membersdir\" size=\"65\"></td>
</tr>
<tr>
   <td valign=top><b>"._CON27."</b></td>
   <td><input type=text name=\"datadir\" value=\"$datadir\" size=\"65\"></td>
</tr>
<tr>
   <td valign=top><b>"._CON28."</b></td>
   <td><input type=text name=\"vardir\" value=\"$vardir\" size=\"65\"></td>
</tr>
</table>";

if ($from == 'install')
{

echo "<br><font size=1>"._CON29." <a href=\"http://www.yabb.info/community/\">"._CON30."</a>.</font><br>
      <input type=hidden name=\"dbuser\" value=\"$dbuser\">
      <input type=hidden name=\"dbpassword\" value=\"$dbpassword\">
      <input type=hidden name=\"dbprefix\" value=\"$dbprefix\">
      <input type=hidden name=\"dbname\" value=\"$dbname\">
      <input type=hidden name=\"dbserver\" value=\"$dbserver\">
      <input type=hidden name=\"installdir\" value=\"$installdir\">
      <input type=hidden name=\"dbpurge\" value=\"on\">
      <input type=hidden name=\"step\" value=\"3\">";

}
else
{
   print "<input type=hidden name=\"step\" value=\"2\">";
}

echo "<center>
      <input type=submit value=\""._CON31."\">
      </center>
      </form>";
   
}
elseif($step == "2")
{
   $installdir = $HTTP_SERVER_VARS["DOCUMENT_ROOT"]."/yabbse";
   $installdir = str_replace("//","/",$installdir);
   
echo ""._CON32."<br>
<form action=\"converter.php?step=3\" method=\"POST\">
<table border=0 cellspacing=0 cellpadding=3>
<tr>
   <td valign=top><b>"._CON33."</b></td>
   <td><input type=text name=\"installdir\" value=\"$installdir\" size=\"40\"><br>
   <font size=1>"._CON34." settings.pl "._CON35." settings.php</font></td>
</tr>
<tr>
   <td valign=top><b>"._CON36."</b></td>
   <td><input type=text name=\"dbserver\" value=\"localhost\"><br>
   <font size=1>"._CON37."</font></td>
</tr>
<tr>
   <td valign=top><b>"._CON38."</b></td>
   <td><input type=text name=\"dbuser\" value=\"\"><br>
   <font size=1>"._CON39."</font></td>
</tr>
<tr>
   <td valign=top><b>"._CON40."</b></td>
   <td><input type=password name=\"dbpassword\" value=\"\"><br>
   <font size=1>"._CON41."</font></td>
</tr>
   <tr>
   <td valign=top><b>"._CON42."</b></td>
   <td><input type=text name=\"dbname\" value=\"yabbse\"><br>
   <font size=1>"._CON43."</font></td>
</tr>
   <tr>
   <td valign=top><b>"._CON44."</b></td>
   <td><input type=text name=\"dbprefix\" value=\"yabbse_\"><br>
   <font size=1>"._CON45."</font></td>
</tr>
   <tr>
   <td valign=top><b>"._CON46."</b></td>
   <td><input type=checkbox name=\"dbpurge\"><br>
   <font size=1>"._CON47."</font></td>
</tr>
</table>
<center>
<input type=hidden name=\"y1gdir\" value=\"$y1gdir\">
<input type=hidden name=\"boardsdir\" value=\"$boardsdir\">
<input type=hidden name=\"membersdir\" value=\"$membersdir\">
<input type=hidden name=\"datadir\" value=\"$datadir\">
<input type=hidden name=\"vardir\" value=\"$vardir\">
<input type=submit value=\""._CON48."\"> ("._CON49.")
</center>
</form>";

}
elseif($step=="3")
{
   
echo ""._CON50."<br>
      <form action=\"converter.php?step=4\" method=\"POST\">
      <table border=0 cellspacing=0 cellpadding=3>
      <tr><td>";

   $dbcon = mysql_connect($dbserver, $dbuser, $dbpassword);
   mysql_select_db($dbname);

[DigitalPixel]

   // let's purge the database if it's selected
   if ($dbpurge == 'on')
   {
      print ""._CON51."<blockquote>";
      $request = mysql_query("DELETE FROM {$dbprefix}instant_messages WHERE 1");
      $request = mysql_query("ALTER TABLE {$dbprefix}instant_messages AUTO_INCREMENT=1");
      print "{$dbprefix}instant_messages "._CON52."<br>";
      $request = mysql_query("DELETE FROM {$dbprefix}members WHERE 1");
      $request = mysql_query("ALTER TABLE {$dbprefix}members AUTO_INCREMENT=1");
      print "{$dbprefix}members "._CON52."<br>";
      $request = mysql_query("DELETE FROM {$dbprefix}categories WHERE 1");
      $request = mysql_query("ALTER TABLE {$dbprefix}categories AUTO_INCREMENT=1");
      print "{$dbprefix}categories "._CON52."<br>";
      $request = mysql_query("DELETE FROM {$dbprefix}boards WHERE 1");
      $request = mysql_query("ALTER TABLE {$dbprefix}boards AUTO_INCREMENT=1");
      print "{$dbprefix}boards "._CON52."<br>";
      $request = mysql_query("DELETE FROM {$dbprefix}topics WHERE 1");
      $request = mysql_query("ALTER TABLE {$dbprefix}topics AUTO_INCREMENT=1");
      print "{$dbprefix}topics "._CON52."<br>";
      $request = mysql_query("DELETE FROM {$dbprefix}messages WHERE 1");
      $request = mysql_query("ALTER TABLE {$dbprefix}messages AUTO_INCREMENT=1");
      print "{$dbprefix}messages "._CON52."<br>";
      $request = mysql_query("DELETE FROM {$dbprefix}membergroups WHERE grouptype=1");
      $request = mysql_query("ALTER TABLE {$dbprefix}membergroups AUTO_INCREMENT=8");
      print "{$dbprefix}membergroups "._CON52."<br>";
      print "</blockquote><p>";
   }
   // lets copy over the variables and the settings first
   $agreementFile = file("$vardir/agreement.txt");
   $censorFile = file("$vardir/censor.txt");
   $membergroupsFile = file ("$vardir/membergroups.txt");
   $newsFile = file ("$vardir/news.txt");
   $oldestmesFile = file ("$vardir/oldestmes.txt");
   $reserveFile = file ("$vardir/reserve.txt");
   $reservecfgFile = file ("$vardir/reservecfg.txt");

   // now, lets create the array of variables to be injected into the settings table
   $settingsVars = array();
   $settingsVars['agreement'] = mysql_escape_string(implode("",$agreementFile));
   $settingsVars['news'] = mysql_escape_string(implode("",$newsFile));
   $settingsVars['maxdays'] = mysql_escape_string(trim($oldestmesFile[0]));
   foreach($settingsVars as $key=>$value)
   {
      $request = mysql_query("SELECT 1 FROM {$dbprefix}settings WHERE variable='$key' LIMIT 1");
      if (mysql_num_rows($request) == 0)
         $request = mysql_query("INSERT INTO {$dbprefix}settings (value,variable) VALUES ('$value','$key')");
      else
         $request = mysql_query("UPDATE {$dbprefix}settings SET value='$value' WHERE variable='$key' LIMIT 1");

      if (mysql_error() != '')
         print "<font color=red>"._CON53." ({$dbprefix}settings).  "._CON54." $key=".substr($value,0,50)."</font><br>";
      else
         print ""._CON55." ({$dbprefix}settings). "._CON56." $key=".htmlspecialchars(substr($value,0,50))."..<br>";
   }
   unset($settingsVars,$agreementFile,$newsFile,$oldestmesFile);   // clear up some memory

   // now lets deal with the reserved words settings
   $reserved = array();
   $reserved['matchword'] = (trim($reservecfgFile[0])=='checked')?'1':'0';
   $reserved['matchcase'] = (trim($reservecfgFile[1])=='checked')?'1':'0';
   $reserved['matchuser'] = (trim($reservecfgFile[2])=='checked')?'1':'0';
   $reserved['matchname'] = (trim($reservecfgFile[3])=='checked')?'1':'0';
   foreach($reserved as $key=>$value)
   {
      $request = mysql_query("SELECT 1 FROM {$dbprefix}reserved_names WHERE setting='$key' LIMIT 1");
      if (mysql_num_rows($request) == 0)
         $request = mysql_query("INSERT INTO {$dbprefix}reserved_names (value,setting) VALUES ('$value','$key')");
      else
         $request = mysql_query("UPDATE {$dbprefix}reserved_names SET value='$value' WHERE setting='$key' LIMIT 1");
   
      $request = mysql_query("UPDATE {$dbprefix}reserved_names SET value='$value' WHERE setting='$key' LIMIT 1");
      if (mysql_error() != '')
         print "<font color=red>"._CON53." ({$dbprefix}reserved_names).  "._CON54." $key=$value</font><br>";
      else
         print ""._CON55." ({$dbprefix}reserved_names). "._CON56." $key=$value..<br>";
   }
   unset ($reserved,$reservecfgFile);

   // now the reserved words
   foreach ($reserveFile as $word)
   {
      $word = mysql_escape_string(trim($word));
      $request = mysql_query("INSERT INTO {$dbprefix}reserved_names (setting,value) VALUES ('word','$word')");
      if (mysql_affected_rows() == 0)
         print "<font color=red>"._CON53." ({$dbprefix}reserved_names).  "._CON57." ($word)</font><br>";
      else
         print ""._CON55." ({$dbprefix}reserved_names). "._CON58." ($word)<br>";
   }
   unset ($reserveFile);

   // and the ever-entertaining censor
   foreach ($censorFile as $entry)
   {
      if (trim($entry) != '')
      {
         list($word,$replacement) = explode("=",$entry);
         $word = mysql_escape_string(trim($word));
         $replacement = mysql_escape_string(trim($replacement));
         $request = mysql_query("INSERT INTO {$dbprefix}censor (vulgar,proper) VALUES ('$word','$replacement')");
         if (mysql_affected_rows() < 0)
            print "<font color=red>"._CON55." ({$dbprefix}censor).  "._CON59." $word=".substr($replacement,0,50)."</font><br>";
         else
            print ""._CON55." ({$dbprefix}censor). "._CON60." $word=".substr($replacement,0,50)."<br>";
      }
   }
   unset ($censorFile);

   // now the membergroups
   for ($i = 7; $i < sizeof($membergroupsFile); $i++)
   {
      if (trim($membergroupsFile[$i]) != '')
      {
         $membergroupsFile[$i] = mysql_escape_string(trim($membergroupsFile[$i]));
         $request = mysql_query("INSERT INTO {$dbprefix}membergroups (membergroup,grouptype) VALUES ('$membergroupsFile[$i]','1')");
         if (mysql_affected_rows() < 0)
            print "<font color=red>"._CON53." ({$dbprefix}membergroups).  "._CON59." $membergroupsFile[$i]</font><br>";
         else
            print ""._CON55." ({$dbprefix}membergroups). "._CON56." $membergroupsFile[$i]<br>";
      }
   }
   unset ($membergroupsFile);
   
echo "</td></tr></table>
      <center>
      <input type=hidden name=\"y1gdir\" value=\"$y1gdir\">
      <input type=hidden name=\"boardsdir\" value=\"$boardsdir\">
      <input type=hidden name=\"membersdir\" value=\"$membersdir\">
      <input type=hidden name=\"datadir\" value=\"$datadir\">
      <input type=hidden name=\"vardir\" value=\"$vardir\">
      <input type=hidden name=\"dbuser\" value=\"$dbuser\">
      <input type=hidden name=\"dbpassword\" value=\"$dbpassword\">
      <input type=hidden name=\"dbprefix\" value=\"$dbprefix\">
      <input type=hidden name=\"dbname\" value=\"$dbname\">
      <input type=hidden name=\"dbserver\" value=\"$dbserver\">
      <input type=hidden name=\"installdir\" value=\"$installdir\">
      <input type=submit value=\""._CON61."\"> ("._CON62.")
      </center>
      </form>";

}
elseif($step=="4")
{

echo ""._CON63."<br>
     <form action=\"converter.php?step=5\" method=\"POST\">
     <table border=0 cellspacing=0 cellpadding=3>
     <tr><td>";

   $dh = opendir($membersdir);
   print ""._CON64."<br><blockquote>";
   $users = array();

   $dbcon = mysql_connect($dbserver, $dbuser, $dbpassword);
   mysql_select_db($dbname);

   while (($file = readdir($dh)) !== false)
   {
      $extension = substr(strrchr($file, "."), 1);
      if ($extension != 'dat') { continue; }

[DigitalPixel]

$user = substr($file,0,strrpos($file,"."));
      $userData = file ("$membersdir/$file");
      for ($i = 0; $i < sizeof($userData); $i++)
         $userData[$i] = mysql_escape_string(trim(htmlspecialchars($userData[$i])));
      $password = crypt (stripcslashes($userData[0]),substr(stripcslashes($userData[0]),0,2));
      if (strtotime(stripcslashes($userData[14])) == -1) {
         if (preg_match ("/(\d\d)\/(\d\d)\/(\d\d)(.*)(\d\d)\:(\d\d)\:(\d\d)/i", stripcslashes($userData[14]), $matches)) {
            $userData[14] = strtotime("$matches[5]:$matches[6]:$matches[7] $matches[1]/$matches[2]/$matches[3]");
         } else {
            $userData[14] = time();
         }
      } else {
         $userData[14] = strtotime(stripcslashes($userData[14]));         
      }   
      $birthdate = strtotime(stripcslashes($userData[16]));
      if ($birthdate > 0) {
         $tmp = getdate($birthdate);
         $userData[16] = "$tmp[year]-$tmp[mon]-$tmp[mday]";
      } else {
         if (preg_match ("/(\d\d)\/(\d\d)\/(\d\d)(.*)(\d\d)\:(\d\d)\:(\d\d)/i", stripcslashes($userData[16]), $matches)) {
            $birthdate = strtotime("$matches[5]:$matches[6]:$matches[7] $matches[1]/$matches[2]/$matches[3]");
            $tmp = getdate($birthdate);
            $userData[16] = "$tmp[year]-$tmp[mon]-$tmp[mday]";
         } else {
            $userData[16] = "";
         }
      }
      $userData[19] = $userData[19]=='checked'?'1':0;
      $userData[5] = str_replace("&&","\n",$userData[5]);
      $userData[5] = str_replace("&amp;&amp;","\n",$userData[5]);
      if ($userData[4] == 'Guest') {$userData[4] = $userData[1]; }
      $request = mysql_query("INSERT INTO {$dbprefix}members (memberName,passwd,realName,emailAddress,websiteTitle,websiteUrl,signature,posts,membergroup,ICQ,AIM,YIM,gender,personalText,avatar,dateRegistered,location,birthdate,timeOffset,hideEmail) VALUES ('$user','$password','$userData[1]','$userData[2]','$userData[3]','$userData[4]','$userData[5]','$userData[6]','$userData[7]','$userData[8]','$userData[9]','$userData[10]','$userData[11]','$userData[12]','$userData[13]','$userData[14]','$userData[15]','$userData[16]','$userData[18]','$userData[19]')");
      if (mysql_error()=='')
      {
         print "$user "._CON65.", ";
         $users[$user] = array($user,mysql_insert_id());
      }
      else
         print "<font color=red>$user "._CON66."</font>, ";
   }
   print "</blockquote><p>"._CON67."<br><blockquote>";
   closedir($dh);
   foreach($users as $user)
   {
      if (!file_exists("$membersdir/$user[0].msg")){ continue; }
      $data1 = file("$membersdir/$user[0].msg");
      foreach ($data1 as $theData)
      {
         if (trim($theData) == '') { continue; }
         $data = explode("|",trim($theData));

         $fromID = isset($users[$data[0]])?$users[$data[0]][1]:'-1';
         $fromName = isset($users[$data[0]])?$users[$data[0]][0]:'Guest';

         $data[1] = mysql_escape_string($data[1]);

         if (strtotime($data[2]) == -1) {
            if (preg_match ("/(\d\d)\/(\d\d)\/(\d\d)(.*)(\d\d)\:(\d\d)\:(\d\d)/i", $data[2], $matches)) {
               $data[2] = strtotime("$matches[5]:$matches[6]:$matches[7] $matches[1]/$matches[2]/$matches[3]");
            } else {
               $data[2] = time();
            }
         } else {
            $data[2] = strtotime($data[2]);
         }   
         
         $data[3] = mysql_escape_string(   $data[3]);

         if ($fromID != '-1')
            $request = mysql_query("INSERT INTO {$dbprefix}instant_messages (ID_MEMBER_FROM,ID_MEMBER_TO,fromName,toName,msgtime,subject,body,deletedBy) VALUES ('$fromID','$user[1]','$fromName','$user[0]','$data[2]','$data[1]','$data[3]','0')");

      }
      print ("$user[0]'s im's, ");
      if (file_exists("$membersdir/$user[0].imconfig"))
      {
         $imFile = file ("$membersdir/$user[0].imconfig");
         $imFile[0] = str_replace("|",",",trim($imFile));
         $imFile[1] = (trim($imFile[1])=='')?'0':'1';
         $request = mysql_query("UPDATE {$dbprefix}members SET im_email_notify='$imFile[1]',im_ignore_list='$imFile[0]' WHERE ID_MEMBER='$user[1]' LIMIT 1");
      }
   }
   foreach($users as $user)
   {
      if (!file_exists("$membersdir/$user[0].karma")){ continue; }
      $data1 = file("$membersdir/$user[0].karma");
      $field = (trim($data1[0])<0)?'karmaBad':'karmaGood';
      $val = abs(trim($data1[0]));
      $request = mysql_query("UPDATE {$dbprefix}members SET $field='$val' WHERE ID_MEMBER='$user[1]' LIMIT 1");
      print ("$user[0]'s karma, ");
   }
   print "</blockquote><br>";

echo"</td></tr></table>
     <center>
     <input type=hidden name=\"y1gdir\" value=\"$y1gdir\">
     <input type=hidden name=\"boardsdir\" value=\"$boardsdir\">
     <input type=hidden name=\"membersdir\" value=\"$membersdir\">
     <input type=hidden name=\"datadir\" value=\"$datadir\">
     <input type=hidden name=\"vardir\" value=\"$vardir\">
     <input type=hidden name=\"dbuser\" value=\"$dbuser\">
     <input type=hidden name=\"dbpassword\" value=\"$dbpassword\">
     <input type=hidden name=\"dbprefix\" value=\"$dbprefix\">
     <input type=hidden name=\"dbname\" value=\"$dbname\">
     <input type=hidden name=\"dbserver\" value=\"$dbserver\">
     <input type=hidden name=\"installdir\" value=\"$installdir\">
     <input type=submit value=\""._CON68."\"> ("._CON69.")
     </center>
     </form>";

}
elseif($step=="5")
{

echo""._CON70."<br>
     <form action=\"converter.php?step=6\" method=\"POST\">
     <table border=0 cellspacing=0 cellpadding=3>
     <tr><td>";

$dbcon = mysql_connect($dbserver, $dbuser, $dbpassword);
mysql_select_db($dbname);

// first we need to load an array of all the members
$dh = opendir($membersdir);
print ""._CON71."";
$users = array();
while (($file = readdir($dh)) !== false)
{
   $extension = substr(strrchr($file, "."), 1);
   if ($extension != 'dat') { continue; }
   $user = substr($file,0,strrpos($file,"."));

   $request = mysql_query("SELECT ID_MEMBER FROM {$dbprefix}members WHERE memberName='$user' LIMIT 1");
   $row = mysql_fetch_row($request);
   $users[$user] = array($user,$row[0]);
}
closedir($dh);

// now load an array of the sticky topics
$stickyTopics = array();
if (file_exists("$boardsdir/$sticky.stk"))
{
   foreach(file("$boardsdir/$sticky.stk") as $line)
   {
      if (trim($line)!= '')
         $stickyTopics[] = trim($line);
   }
}

// now to create the categories
$dh = opendir($boardsdir);
$categories = array();
$boards = array();
while (($file = readdir($dh)) !== false)
{
   list ($cat,$extension) = explode ('.',$file);
   if ($extension != 'cat') { continue; }
   // we are now only looping for the categories

   $catFile = file ("$boardsdir/$file");
   $catname = mysql_escape_string(trim($catFile[0]));
   $catmembergroups = mysql_escape_string(trim($catFile[1]));
   $request = mysql_query("INSERT INTO {$dbprefix}categories (name,memberGroups) VALUES ('$catname','$catmembergroups')");
   $catid = mysql_insert_id();
   $categories[$cat] = $catid;

   print ""._CON72." $cat<br>";
   // now we are going to loop though for every board
   for ($i = 2; $i < sizeof($catFile); $i++)
   {
      $curboard = trim($catFile[$i]);
      if ($curboard==''){ continue; }

      // now to get some board information to insert into the db
      $boardFile = file ("$boardsdir/$curboard.dat");
      $boardname = mysql_escape_string(trim($boardFile[0]));
      $boarddesc = mysql_escape_string(trim($boardFile[1]));
      $boardmods = mysql_escape_string(trim(str_replace("|",",",$boardFile[2])));
      $request = mysql_query("INSERT INTO {$dbprefix}boards (ID_CAT,name,description,moderators) VALUES ('$catid','$boardname','$boarddesc','$boardmods')");
      $boardid = mysql_insert_id();

      print "&nbsp;&nbsp;"._CON73." $boardname<br>";
      // initialize the topics and posts count for later
      $numTopics = 0;
      $numPosts = 0;

      // now loop through for all the topics
      $boardFile = file ("$boardsdir/$curboard.txt");
      foreach ($boardFile as $boardFileEntry)
      {
         if (trim($boardFileEntry=='')){ continue; }
         $topicinfo = explode("|",trim($boardFileEntry));
         $topicid = $topicinfo[0];
         $locked = $topicinfo[8];
         $topicinfo = file("$datadir/$topicid.data");
         $numViews = trim($topicinfo[0]);
         $request = mysql_query("INSERT INTO {$dbprefix}topics (ID_BOARD,numViews,locked) VALUES ('$boardid','$numViews','$locked')");
         $id_topic = mysql_insert_id();

         $first = true;
         $numReplies = 0;
         $posterID = '';
         $msgid = '';
         // now to loop through for the messages         
         $messageFile = file ("$datadir/$topicid.txt");
         foreach($messageFile as $messageFileEntry)
         {
            if (trim($messageFileEntry)==''){ continue; }
            $messageinfo = explode("|",$messageFileEntry);
            for ($j = 0; $j < sizeof ($messageinfo); $j++)
               $messageinfo[$j] = mysql_escape_string(trim($messageinfo[$j]));
            $posterID = isset($users[$messageinfo[4]])?$users[$messageinfo[4]][1]:'-1';

            // $messageinfo[3] = strtotime($messageinfo[3]);

            if (strtotime($messageinfo[3]) == -1) {
               if (preg_match ("/(\d\d)\/(\d\d)\/(\d\d)(.*)(\d\d)\:(\d\d)\:(\d\d)/i", $messageinfo[3], $matches)) {
                  $messageinfo[3] = strtotime("$matches[5]:$matches[6]:$matches[7] $matches[1]/$matches[2]/$matches[3]");
               } else {
                  $messageinfo[3] = time();
               }
            } else {
               $messageinfo[3] = strtotime($messageinfo[3]);         
            }   

            if (strtotime($messageinfo[11]) == -1) {
               if (preg_match ("/(\d\d)\/(\d\d)\/(\d\d)(.*)(\d\d)\:(\d\d)\:(\d\d)/i", $messageinfo[11], $matches)) {
                  $messageinfo[11] = strtotime("$matches[5]:$matches[6]:$matches[7] $matches[1]/$matches[2]/$matches[3]");
               } else {
                  $messageinfo[11] = '';

[DigitalPixel]

}
            } else {
               $messageinfo[11] = strtotime($messageinfo[11]);         
            }   

            $messageinfo[9] = !$messageinfo[9];
            $messageinfo[4] = ($messageinfo[4]=='Guest')?$messageinfo[1]:$messageinfo[4];
            $messageinfo[8] = preg_replace('/\[quote (.+?)]/i',"

",$messageinfo[8]);

            $request = mysql_query("INSERT INTO {$dbprefix}messages (ID_MEMBER,posterName,posterIP,posterEmail,posterTime,subject,body,smiliesEnabled,modifiedName,modifiedTime,icon,ID_TOPIC) VALUES ('$posterID','$messageinfo[4]','$messageinfo[7]','$messageinfo[2]','$messageinfo[3]','$messageinfo[0]','$messageinfo[8]','$messageinfo[9]','$messageinfo[11]','$messageinfo[10]','$messageinfo[5]','$id_topic')");
            $msgid = mysql_insert_id();

            if ($first)
            {
               $first = false;
               $request = mysql_query("UPDATE {$dbprefix}topics SET ID_FIRST_MSG='$msgid',ID_MEMBER_STARTED='$posterID' WHERE ID_TOPIC='$id_topic' LIMIT 1");
            }
            else
               $numReplies ++;
         }
         // now, just for Andrea, we're going to try to import the notifies
         $notifies = array();
         if (file_exists("$datadir/$topicid.mail"))
         {
            $notifyList = file ("$datadir/$topicid.mail");
            foreach ($notifyList as $not)
            {
               $not = trim($not);
               $request = mysql_query("SELECT ID_MEMBER FROM {$dbprefix}members WHERE emailAddress='$not' LIMIT 1");
               if (mysql_num_rows($request) > 0)
               {
                  $row = mysql_fetch_row($request);
                  $notifies[] = $row[0];
               }
            }
         }
         $notify = (sizeof($notifies) > 0) ? implode(",",$notifies) : '';

         // and now we'll try to do sticky topics
         $isSticky = (sizeof($stickyTopics) > 0 && in_array($topicid,$stickyTopics))?1:0;

         $request = mysql_query("UPDATE {$dbprefix}topics SET ID_LAST_MSG='$msgid',ID_MEMBER_UPDATED='$posterID',numReplies='$numReplies',notifies='$notify',isSticky='$isSticky' WHERE ID_TOPIC='$id_topic' LIMIT 1");
         $request = mysql_query("UPDATE {$dbprefix}boards SET numPosts=numPosts+$numReplies+1,numTopics=numTopics+1 WHERE ID_BOARD='$boardid' LIMIT 1");
      }
   }
}

closedir($dh);

echo"</td></tr></table>
     <center>
     <input type=hidden name=\"y1gdir\" value=\"$y1gdir\">
     <input type=hidden name=\"boardsdir\" value=\"$boardsdir\">
     <input type=hidden name=\"membersdir\" value=\"$membersdir\">
     <input type=hidden name=\"datadir\" value=\"$datadir\">
     <input type=hidden name=\"vardir\" value=\"$vardir\">
     <input type=hidden name=\"dbuser\" value=\"$dbuser\">
     <input type=hidden name=\"dbpassword\" value=\"$dbpassword\">
     <input type=hidden name=\"dbprefix\" value=\"$dbprefix\">
     <input type=hidden name=\"dbname\" value=\"$dbname\">
     <input type=hidden name=\"dbserver\" value=\"$dbserver\">
     <input type=hidden name=\"installdir\" value=\"$installdir\">
     <input type=submit value=\""._CON74."\"> ("._CON75.")
     </center>
     </form>";

}
elseif($step=="6")
{
      $mode = ini_get("safe_mode");

echo"Conversion Complete!<br>
     <form action=\"converter.php?step=7\" method=\"POST\">
     <table border=0 cellspacing=0 cellpadding=3>
     <tr><td>
     <input type=checkbox name=\"copyt\"> "._CON76." template.html<br>
     <input type=checkbox name=\"copys\"> "._CON76." settings<br>
     </td></tr></table>
     "._CON77."<br>";

   if ($mode)
   print ""._CON78."<p>";

echo"<center>
     <input type=hidden name=\"y1gdir\" value=\"$y1gdir\">
     <input type=hidden name=\"boardsdir\" value=\"$boardsdir\">
     <input type=hidden name=\"membersdir\" value=\"$membersdir\">
     <input type=hidden name=\"datadir\" value=\"$datadir\">
     <input type=hidden name=\"vardir\" value=\"$vardir\">
     <input type=hidden name=\"dbuser\" value=\"$dbuser\">
     <input type=hidden name=\"dbpassword\" value=\"$dbpassword\">
     <input type=hidden name=\"dbprefix\" value=\"$dbprefix\">
     <input type=hidden name=\"dbname\" value=\"$dbname\">
     <input type=hidden name=\"dbserver\" value=\"$dbserver\">
     <input type=hidden name=\"installdir\" value=\"$installdir\">
     <input type=submit value=\""._CON79."\">
     </center>
     </form>";

}
elseif($step=="7")
{

echo""._CON80."<br>
     <table border=0 cellspacing=0 cellpadding=3>
     <tr><td>";

$mode = ini_get("safe_mode");
if (isset($copyt) && !$mode)
{
   if (copy("$y1gdir/template.html","$installdir/template.html"))
      print "template.html "._CON81."<br>";
   else
      print "<font color=red>template.html "._CON82."</font><br>";
}
if (isset($copys) && !$mode)
{
   $settingsToCopy = array('guestaccess', 'mbname', 'Cookie_Length', 'RegAgree', 'emailpassword', 'emailnewpass', 'emailwelcome', "color{'titlebg'}", "color{'titletext'}", "color{'windowbg'}", "color{'windowbg2'}", "color{'windowbg3'}", "color{'catbg'}", "color{'bordercolor'}", "color{'fadertext'}", "color{'fadertext2'}", 'MenuType', 'curposlinks', 'profilebutton','allow_hide_email', 'showlatestmember', 'shownewsfader', 'Show_RecentBar', 'Show_MemberBar', 'showmarkread', 'showmodify', 'ShowBDescrip', 'showuserpic', 'showusertext', 'showgenderimage', 'showyabbcbutt', 'enable_ubbc', 'enable_news', 'allowpics', 'enable_guestposting', 'enable_notification', 'TopAmmount', 'MembersPerPage', 'maxdisplay', 'maxmessagedisplay', 'MaxMessLen', 'MaxSigLen', 'ClickLogTime', 'timeout', 'JrPostNum', 'FullPostNum', 'SrPostNum', 'GodPostNum', 'userpic_width', 'userpic_height');

   print"<p>";

   $copiedSettings = array();
   $settingsArray = file("$y1gdir/Settings.pl");
   for($i = 0; $i < sizeof($settingsArray); $i++)
   {
      foreach ($settingsToCopy as $curset)
      {
         if (substr($settingsArray[$i],1,strlen($curset))==$curset)
         {
            preg_match("/=(.*);/",$settingsArray[$i],$matches);
            $copiedSettings[$curset] = $matches[1];
            print ""._CON83." $curset...<br>";
            continue;
         }
      }
   }

   print "<p>";

   $settingsArray = file("$installdir/Settings.php");
   $url = "";
   for($i = 0; $i < sizeof($settingsArray); $i++)
   {
      foreach ($copiedSettings as $set => $val)
      {
         $set = str_replace("{'","['",$set);
         $set = str_replace("'}","']",$set);
         if (substr($settingsArray[$i],1,strlen($set))==$set)
         {
            $settingsArray[$i] = preg_replace("/=(.*);/","= $val;",$settingsArray[$i],1);
            print ""._CON84." $set"._CON85." $val   <br>";
            continue;
         }
      }
   }

   $fp = fopen("$installdir/Settings.php", "w");
   foreach($settingsArray as $row)
      fputs($fp, $row);
   fclose ($fp);
}
include("$installdir/Settings.php");

echo"</td></tr></table>
     <center><p>
     "._CON86."<p>
     <a href=\"$boardurl/index.php\">"._CON87."</a> "._CON88."<br><br>
     </center>";

}

echo"</td>
     </tr>
     </table></center>
     </body>
     </html>";
?>

[/quote]

[DigitalPixel]

--------------
lang.php
--------------

<?php
define('_STEP0',"YaBB SE Installer");
define('_STEP1',"YaBB SE Installer");
define('_STEP2',"Safe Mode Check:");
define('_STEP3',"Warning! It appears that safe mode is enabled.");
define('_STEP3_1',"This version of the YaBB SE Installer will not work with safe mode enabled. You should download the safe mode installer from");
define('_STEP3_2',"and procede with your installation using that version.");
define('_STEP3_3',"If you know for a fact that safe mode is NOT enabled, you may continue, although this is strongly discouraged.");
define('_STEP4',"It appears that safe mode has been disabled.  You may continue.");
define('_STEP5',"Click here");
define('_STEP5_1',"to continue.");
define('_STEP6',"This program will install YaBB SE on your webserver");
define('_STEP7',"Install to directory:");
define('_STEP8',"Create this directory first, then chmod it to 777!");
define('_STEP9',"Overwrite newer files:");
define('_STEP10',"Start installation &gt;");
define('_STEP11',"does not exist yet, please create it first");
define('_STEP12',"Installation starts now...");
define('_STEP13',"Skipping");
define('_STEP14',"because it's a newer version or a version of the same age");
define('_STEP15',"Wrote");
define('_STEP16',"...");
define('_STEP17',"Proceed &gt;");
define('_STEP18',"You will now have to set some settings you need to set =)");
define('_STEP19',"MySQL server name:");
define('_STEP20',"This is nearly always localhost, so if you don't know use localhost");
define('_STEP21',"MySQL username:");
define('_STEP22',"Fill in the username you need to connect to your MySQL database, if you don't know, try the username of your ftp account, most of the times those two are equal.");
define('_STEP23',"MySQL password:");
define('_STEP24',"Fill in the password you need to connect to your MySQL database, if you don't know, try the password of your ftp account, most of the times they're the same.");
define('_STEP25',"MySQL Database name:");
define('_STEP26',"Fill in the name of the database you want to use to let YaBB SE store it's data in, <b>make sure it is empty or at least doesn't contain important info, it's very likely that it will be destroyed<br>If this database does not exist, we will try to create it.");
define('_STEP27',"MySQL Database prefix:");
define('_STEP28',"Fill in the prefix you would like to use on all your table names.  You may leave this blank.  This value will be prepended to all table names to allow for multiple YaBB SE installations in a single database.");
define('_STEP29',"Proceed &gt;");
define('_STEP30',"(Only proceed if successful!)");
define('_STEP31',"Cannot connect to database server with given data");
define('_STEP32',"CREATE DATABASE IF NOT EXISTS");
define('_STEP33',"Cannot use database");
define('_STEP34',"connection to server succeeded by the way.");
define('_STEP35',"Inserting data package");
define('_STEP36',"Errors:");
define('_STEP37',"No Errors");
define('_STEP38',"Proceed &gt;");
define('_STEP39',"We now need to ask you for the forum URLs so you can use YaBB SE");
define('_STEP40',"Board URL:");
define('_STEP41',"This is the url of your site without the trailing '/'.");
define('_STEP42',"Images URL:");
define('_STEP43',"This is the location of your yabb images including the buttons, icons etc.");
define('_STEP44',"Faces URL:");
define('_STEP45',"This is the location of the avatars.  It is, by default, the avatars sub-directory in your images folder.");
define('_STEP46',"Proceed &gt;");
define('_STEP47',"Settings.php was modified successfully");
define('_STEP48',"Proceed &gt;");
define('_STEP49',"You will now have to set up an adminstrator account");
define('_STEP50',"Your username:");
define('_STEP51',"You can choose the username you'd like to have, this account will automatically get admin rights");
define('_STEP52',"Password:");
define('_STEP53',"Fill in your prefered password here, remember it well!");
define('_STEP54',"Password again:");
define('_STEP55',"Just for verification");
define('_STEP56',"E-Mail:");
define('_STEP57',"Skip this:");
define('_STEP58',"Only check this if you DON'T want to set up an admin account.  Most likely this will only happen if you intend to continue and convert an existing Y1G board.");
define('_STEP59',"Proceed &gt;");
define('_STEP60',"Passwords did not match");
define('_STEP61',"Error:");
define('_STEP62',"An administrator account has been created, you can now proceed to your newly created board.<B>Please remember to delete install.php or rename it so it can't be executed, and to chmod your installation dir to something other than 777</B>");
define('_STEP63',"Please follow one of the links below:");
define('_STEP64',"Go to your board");
define('_STEP65',"Convert an existing Y1G board data files");
define('_STEP66',"Good luck!");
define('_STEP67',"The YaBB SE team.");

[DigitalPixel]

define('_CON0',"YaBB 1 Gold to YaBB SE Converter");
define('_CON1',"YaBB 1 Gold to YaBB SE Converter");
define('_CON2',"This program will convert an existing Y1G board into an existing Yabb SE install.");
define('_CON3',"You must meet the following requirements to continue:");
define('_CON4',"You must have YaBB SE installed.  If it is not");
define('_CON5',"click here");
define('_CON6',"You must have YaBB SE installed with the same database prefix as you intend to convert to. i.e. if you are converting and intend to use the prefix yabbse2_ you must have, at some point, set up a YaBB SE install using that prefix.  Otherwise, this converter will be trying to insert data into tables that don't exist.");
define('_CON7',"You must have not have the encrypt passwords mod installed.  If you <b>must</b> notify your users they will have to use the 'forgot password' function to reset their passwords.  YaBB SE password encryption is incompatible with the encrypt password mod. Be prepared to change your passwords");
define('_CON8',"Note: On Windows-based hosts, usernames are case-insensitive.  This may result in some posts being mislabeled as 'Guest' postings when in reality, a user simply posted while logged in with a different case (i.e. alexandra as opposed to Alexandra) for more details on this, and ways to get around the problem, please visit the");
define('_CON9',"YaBB SE Community");
define('_CON10',"Proceed &gt;");
define('_CON11',"We are now determining whether PHP is currently running in safe mode.");
define('_CON12',"It appears that you are running in safe mode.  While the conversion process will work for the most part, the following steps will be disabled to prevent errors.");
define('_CON13',"template.html conversion");
define('_CON14',"you will have to manually replace your YaBB SE");
define('_CON15',"conversion");
define('_CON16',"you will have to update");
define('_CON17',"manually");
define('_CON18',"The rest of the conversion should procede successfully though.");
define('_CON19',"It appears that safe mode is disabled.  All conversion steps should be successful.");
define('_CON20',"Proceed &gt;");
define('_CON21',"This program will convert an existing YaBB 1 Gold install, into an existing YaBB SE install.  If you have not installed YaBB SE yet, please do so.");
define('_CON22',"YaBB 1 Gold Install directory:");
define('_CON23',"This directory is needed so we can copy your old");
define('_CON24',"into the new");
define('_CON25',"YaBB 1 Gold boards directory:");
define('_CON26',"YaBB 1 Gold members directory:");
define('_CON27',"YaBB 1 Gold data directory:");
define('_CON28',"YaBB 1 Gold variables directory:");
define('_CON29',"Note: On Windows-based hosts, usernames are case-insensitive.  This may result in some posts being mislabeled as 'Guest' postings when in reality, a user simply posted while logged in with a different case (i.e. alexandra as opposed to Alexandra) for more details on this, and ways to get around the problem, please visit the ");
define('_CON30',"YaBB SE Community");
define('_CON31',"Start Conversion &gt;");
define('_CON32',"Now to collect some information from you regarding your YaBB SE Install");
define('_CON33',"YaBB SE Install directory:");
define('_CON34',"This directory is needed so we can copy your old");
define('_CON35',"into the new");
define('_CON36',"MySQL server name:");
define('_CON37',"This is nearly always localhost, so if you don't know use localhost");
define('_CON38',"MySQL username:");
define('_CON39',"Fill in the username you need to connect to your MySQL database, if you don't know, try the username of your ftp account, most of the times those two are equal.");
define('_CON40',"MySQL password:");
define('_CON41',"Fill in the password you need to connect to your MySQL database, if you don't know, try the password of your ftp account, most of the times they're the same.");
define('_CON42',"MySQL Database name:");
define('_CON43',"Fill in the name of the database you want to use to let YaBB SE store it's data in, <b>make sure it is empty or at least doesn't contain important info, it's very likely that it will be destroyed</b>");
define('_CON44',"MySQL Database prefix:");
define('_CON45',"Fill in the prefix you would like to use on all your table names.  You may leave this blank.  This value will be prepended to all table names to allow for multiple YaBB SE installations in a single database.");
define('_CON46',"Purge the database?:");
define('_CON47',"Check this box if you want to purge the database of all conflicting data.  This will not empty the entire database - it will only empty those tables that may cause errors and/or duplication while using the converter.");
define('_CON48',"Proceed &gt;");
define('_CON49',"Only proceed if successful!");
define('_CON50',"Converting Settings...");
define('_CON51',"Purging the database as per request...");
define('_CON52',"purged");
define('_CON53',"Error editing table");
define('_CON54',"Unable to set");
define('_CON55',"Editing table");
define('_CON56',"Setting");
define('_CON57',"Unable to insert word");
define('_CON58',"Inserting reserved word");
define('_CON59',"Unable to insert");
define('_CON60',"Inserting");
define('_CON61',"Proceed &gt;");
define('_CON62',"Only proceed if successful!");
define('_CON63',"We are now going to attempt to convert your member data files.");
define('_CON64',"Importing Member Data:");
define('_CON65',"added");
define('_CON66',"not added");
define('_CON67',"Inserting Instant Messages");
define('_CON68',"Proceed &gt;");
define('_CON69',"Only proceed if successful!");
define('_CON70',"We are now going to attempt to convert your message files.  This may take a while.");
define('_CON71',"Initializing member data for processing....");
define('_CON72',"Inserted category:");
define('_CON73',"Inserted board:");
define('_CON74',"Proceed &gt;");
define('_CON75',"Only proceed if successful!");
define('_CON76',"Yes, copy my");
define('_CON77',"Your avatars and template images will not be copied over in this process.  You are responsible for copying over the necessary images from the YaBBImages dir and the avatars dir.");
define('_CON78',"Note, you are running in safe mode, these functions will not be executed regardless of your selection.  Please press continue.");
define('_CON79',"Proceed &gt;");
define('_CON80',"We are now copying your selections");
define('_CON81',"copied successfully.");
define('_CON82',"copy failed.");
define('_CON83',"Copied value of");
define('_CON84',"Replaced value of");
define('_CON85',"..with");
define('_CON86',"Installation Complete!");
define('_CON87',"Click Here");
define('_CON88',"to go to your board");

?>

[Zef Hemel]

Yeah attachments rule

[Daniel D.]

Hehe !