Hi, im just wondering how I could merge punBB with my current table that is set up like this:
im hoping that when people login to my website, the automatically login to the forum
the registering and logging in is done by:
Register
function createUser($userName,$race,$e_mail,$password,$commander,$active=0,$uniqueLink="",$fortificationLevel=0,$siegeLevel=0,
$gold=2800,$lastTurnTime=0,$attackTurns=17,$currentUnitProduction=0,$currentSpySkill=0,
$trainedAttackSold=0,$trainedAttackMerc=0,$trainedDefSold=0,$trainedDefMerc=0,$untrainedSold=1,$untrainedMerc=0,$spies=0){
if (!$lastTurnTime){$lastTurnTime=time();}
$uniqueLink=genUniqueLink();
$str = "INSERT INTO `UserDetails` (userName,race,e_mail,password,commander,active,uniqueLink,fortificationLevel,siegeLevel,
gold,lastTurnTime,attackTurns,currentUnitProduction,currentSpySkill,
trainedAttackSold,trainedAttackMerc,trainedDefSold,trainedDefMerc,untrainedSold,untrainedMerc,spies) VALUES ('$userName','$race','$e_mail','$password','$commander','$active','$uniqueLink','$fortificationLevel','$siegeLevel',
'$gold','$lastTurnTime','$attackTurns','$currentUnitProduction','$currentSpySkill',
'$trainedAttackSold','$trainedAttackMerc','$trainedDefSold','$trainedDefMerc','$untrainedSold','$untrainedMerc','$spies')";
$q = @mysql_query($str);
if (!$q) {
print ('Query failed: '.mysql_error());
return;
}login
function isLogined($uname,$uemail,$psword){
$str="select * from `UserDetails` where userName='$uname' and e_mail='$uemail' and password='$psword'";
//echo $str;
$q = @mysql_query($str);
if (!$q) {
print ('Query failed: '.mysql_error());
return;
}
if (!@mysql_num_rows($q)) {
return 0;
}
else{
$st="";
$st = mysql_fetch_object($q);
return $st->ID;
}
}