1 Topic by Brero-San (edited by Brero-San 2012-03-30 01:38)

  • Registered: 2012-03-30
  • Posts: 2

Topic: integrating PunBB with my current MySQL Table

Hi, im just wondering how I could merge punBB with my current table that is set up like this:
http://www.ragingape.tk/example.png
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;
    }    
}