Jump to content

mark1million

Moderators
  • Posts

    2283
  • Joined

  • Last visited

  • Days Won

    2

Posts posted by mark1million

  1. Just loaded in IE and it throws up the following,

    Message: Syntax error

    Line: 131

    Char: 25

    Code: 0

    URI: http://grantsva.com/index.php/routemap/hubmap/egkk

    Message: 'onLoad' is undefined

    Line: 329

    Char: 1

    Code: 0

    URI: http://grantsva.com/index.php/routemap/hubmap/egkk

    Line 131 is.    var point = new GLatLng(,);

    Line 329 is.    <script language="javascript" type="text/javascript" charset="utf-8">window.onload=onLoad;</script></script>

  2. Right guys, i thought id post my code, now i got to tell you i have no experience in coding, so i make no excuses now.

    This is what im using to interface with phpVMS, i have a few settings in the forum as well for this to work, you must have admin approval set in the forum this is a good idea as it stops nasty people registering on your forum and spamming.

    I have also created another user group "pilots" which is why you see group id 9, the normal registered user group in 2.

    Like i said im no coder but this works for me.

    Must also mention that both databases are in one, if yours are separate then just connect before. SMF users just rename the php_users to your members table and change other settings as required.

    <?php
    class ForumRegister extends CodonModule
    {
       
       public function __construct()
       {
          CodonEvent::addListener('ForumRegister');
       }
       
       public function EventListener($eventinfo)
       {
          if($eventinfo[0] == 'registration_complete')
          { 
    
    $userinfo = $eventinfo[2];
    
    
    $fname = $userinfo['firstname'];
    $lname = $userinfo['lastname'];
    $pass = $userinfo['password1'];
    $email = $userinfo['email'];
    $code = $userinfo['code'];
    
    //mysql_query("INSERT INTO phpbb_users (username, user_password, group_id, user_timezone, user_dst, user_lang, user_type, user_actkey, user_dateformat, user_style, user_regdate) VALUES ($userr, $pass, '2','1.0', '0','en','0','','d M Y H:i', '1', time())");
    
    $get_uinfo = mysql_query("SELECT * FROM phpvms_pilots WHERE firstname='".$fname."' AND lastname='".$lname."' AND email='".$email."'");
    echo "Result Select: ".mysql_error()."<br>";
    $uinfo = mysql_fetch_array( $get_uinfo );
    
    
    //echo "Uinfo: ".$uinfo['pilotid'];
    $str = $uinfo['pilotid'];
    $pilot_id = str_pad ($str,4,"0",STR_PAD_LEFT);
    $pilot_id = $fname.$lname.$code.$pilot_id; 
    $pilot_id_klein = strtolower($pilot_id);
    //echo "Pass: ".$pass."<br>";
    $passMD5 = md5($pass);
    //echo "Pass MD5: ".$passMD5."<br>";
    
    echo "PilotID: ".$str."<br>";
    $tm = time();
    
    mysql_query("INSERT INTO phpbb_users (username, username_clean, user_password, user_email, group_id, user_timezone, user_dst, user_rank, user_lang, user_colour, user_type, user_actkey, user_dateformat, user_style, user_regdate) VALUES ('".$pilot_id."', '".$pilot_id_klein."', '".$passMD5."', '".$email."', '9','0.0', '0', '2','en','0099FF','1','5BN4938HB2','D M d, Y g:i a', '2', '".$tm."')");
    
    //mysql_query("INSERT INTO phpbb_users (username, user_password) VALUES ('".$pilot_id."', '".md5($userinfo['password'])."')");
    
    
    //echo "Result: ".mysql_error()."<br>";
    //print_r($userinfo);
    
             
    
    
          }
       }
    
    }
    ?>

×
×
  • Create New...