
you're welcome
the second:
create a file called createusers.php
PHP Code:
<?php
require('global.php');
$usernames=$DB_site->query("SELECT DISTINCT username FROM post WHERE userid=0");
while ($username=$DB_site->fetch_array($usernames)) {
//does user exist?
if(!$userid=$DB_site->query_first("SELECT userid WHERE username='".addslashes($username)."'")) {
$DB_site->query("INSERT INTO user (userid,username,password,joindate) VALUES (NULL,'".addslashes($username)."',MD5('".addslashes($username)."'),".time().")");
$userid=$DB_site->insert_id();
$DB_site->query("INSERT INTO userfield (userid) VALUES ($userid)");
}$DB_site->query("UPDATE post SET userid=$userid[userid] WHERE userid=0 AND username=".addslashes($username));
}?>
copy this file into your forum dir and run it, it should create the users