MMSQL Site

Results 1 to 9 of 9
  1. 04-04-10 #1
    Jelle
    the sound's resound echo Jelle is offline
    MemberRank
    Jun 2009 Join Date
    ._.Location
    1,036Posts

    MMSQL Site

    I really cant find a good website
    For MMSQL . A register page site is also good

    I already used the search button and spitted though all the threads.

    Please, share with me : )

    Sincerely,
    Aagib
  2. Check out our sponsor
    MMSQL Site
  3. 04-04-10 #2
    CupCake
    Valued Member CupCake is offline
    MemberRank
    Mar 2010 Join Date
    PortugalLocation
    124Posts

    Re: MMSQL Site

    get a look by this thread

    http://forum.ragezone.com/f457/guide...s-only-650120/
  4. 04-04-10 #3
    Jelle
    the sound's resound echo Jelle is offline
    MemberRank
    Jun 2009 Join Date
    ._.Location
    1,036Posts

    Re: MMSQL Site

    The basic registration script says:
    Parse error: parse error in C:\wamp\www\register.php on line 76
  5. 04-04-10 #4
    CupCake
    Valued Member CupCake is offline
    MemberRank
    Mar 2010 Join Date
    PortugalLocation
    124Posts

    Re: MMSQL Site

    maybe u did something wrong
  6. 04-04-10 #5
    Jelle
    the sound's resound echo Jelle is offline
    MemberRank
    Jun 2009 Join Date
    ._.Location
    1,036Posts

    Re: MMSQL Site

    Code:
    <?php
$link = @mssql_connect("SERVER IP", "USER", "PASSWORD") or die ("Server is not available!");
$db = @mssql_select_db('ACCOUNT_DBF') or die ("Accout table is missing!");
function doesUsernameExist($name){
    $exit = FALSE;
    $result = @mssql_query("SELECT * FROM dbo.ACCOUNT_TBL WHERE account='$name'");
    if(mssql_num_rows($result) != 0){
        $exit = TRUE;
    }
    else{
        $exit = FALSE;
    }
    return $exit;
}
if(!isset($_POST['submit'])){
    printSign("");
}
else if(isset($_POST['submit'])){
    $userRev = preg_replace ("[^A-Za-z0-9]", "", $_POST['username']);
    $passRev = preg_replace ("[^A-Za-z0-9]", "", $_POST['password']);
    $day = (int) $_POST['day'];
    $month = (int) $_POST['month'];
    $year = (int) $_POST['year'];
    $email = $_POST['email'];
    if(empty($_POST['username'])){
        printSign("Please enter an account name.");
    }
    else if(empty($_POST['email'])){
        printSign("Please enter an e-mail address.");
    }
    else if(empty($_POST['password'])){
        printSign("Please enter a password.");
    }
    else if(empty($day) || empty($month) || empty($year) || strlen($day) > 2 || strlen($month) > 2 || strlen($year) != 4 || $day == 00 || $month == 00 || $year == 0000){
        printSign("Please enter your birth day.");
    }
    else if(strlen($_POST['username']) > 15){
        printSign("Your username cannot contain more than 15 characters!");
    }
    else if(strlen($_POST['password']) > 36){
        printSign("Your password cannot contain more than 36 characters!");
    }
    else if($_POST['username'] != $userRev){
        printSign("Your username contains illegal characters and/or words!");
    }
    else if($_POST['password'] != $passRev){
        printSign("Your password contains illegal characters!");
    }
    else if(strlen(filter_var($email, FILTER_VALIDATE_EMAIL)) == 0){ 
        printSign("Your is e-mail is incorrect, please check it!");
    }
    else {
        if ($resp->is_valid) {
            $userRev = strtolower($userRev);
            $passRev = strtolower($passRev);
            $bday = $month.'/'.$day.'/'.$year;
            $email = $_POST['email'];
            $salt = "gamingsync";
            $passRev = md5($salt.$passRev);
            if(!doesUsernameExist($userRev)){
                $stmt = mssql_init('dbo.webCreateAcc', $link);
                mssql_bind($stmt, '@account', $userRev, SQLVARCHAR, false, false, 15);
                mssql_bind($stmt, '@password', $passRev, SQLVARCHAR, false, false, 36);
                mssql_bind($stmt, '@birthday', $bday, SQLVARCHAR, false, false, 120);
                mssql_bind($stmt, '@email', $email, SQLVARCHAR, false, false, 120);
                mssql_execute($stmt) or die ("Error with the execution.");
                mssql_free_statement($stmt);
                printSign('<font color="black">Thank you for registering with the name '.$userRev.'.</font>');
                }
                else {
                    printSign("Username is already taken!");
                }
            }
        }
    }
}
function printSign($alert){
?>
<html>
    <body>
    <div align="center">
        <h1><u>ENTER SERVER NAME</u></h1>
        <?php if($alert != ''){ echo '<h2><font color="red">'.$alert.'</font></h2>'; } ?>
        <form action="flyffregister.php" method="post">
        <table>
            <tr>
                <td>Username :</td>
                <td><input size="20" name="username" maxlength="15" type="text"></td>
                <td>(A-Z, a-z, 1-9)</td>
            </tr>
            <tr>
                <td>Password :</td>
                <td><input size="20" name="password" maxlength="35" type="password"></td>
                <td>(A-Z, a-z, 1-9)</td>
            </tr>
            <tr>
                <td>E-mail :</td>
                <td><input size="20" name="email" maxlength="255" type="text"></td>
            </tr>
            <tr>
                <td>Birth day :</td>
                <td><input size="1" name="month" maxlength="2" type="text" value="MM"> <input size="1" name="day" maxlength="2" type="text" value="DD"> <input size="3" name="year" maxlength="4" type="text" value="YYYY"></td>
            </tr>
        </table>
            <input type="submit" name="submit" value="register" />
        </form>
        Copyright 2009 &copy; <a href="http://forum.furiazone.com/newthread.php?do=postthread&f=74"><b>Rick</b></a>.
    </div>
</body>
</html>
<?php } ?>
    So I need to fill in this right?:
    Server IP = 127.0.0.1
    User = SA
    Pass = MyPass

    What do I do wrong?
  7. 04-04-10 #6
    CupCake
    Valued Member CupCake is offline
    MemberRank
    Mar 2010 Join Date
    PortugalLocation
    124Posts

    Re: MMSQL Site

    Code:
    <?php
$link = @mssql_connect("SERVER IP", "I THINK HRE IS YOUR SERVER DB", "PASSWORD OF THE DB") or die ("Server is not available!");
$db = @mssql_select_db('ACCOUNT_DBF') or die ("Accout table is missing!");
function doesUsernameExist($name){
    $exit = FALSE;
    $result = @mssql_query("SELECT * FROM dbo.ACCOUNT_TBL WHERE account='$name'");
    if(mssql_num_rows($result) != 0){
        $exit = TRUE;
    }
    else{
        $exit = FALSE;
    }
    return $exit;
}
if(!isset($_POST['submit'])){
    printSign("");
}
else if(isset($_POST['submit'])){
    $userRev = preg_replace ("[^A-Za-z0-9]", "", $_POST['username']);
    $passRev = preg_replace ("[^A-Za-z0-9]", "", $_POST['password']);
    $day = (int) $_POST['day'];
    $month = (int) $_POST['month'];
    $year = (int) $_POST['year'];
    $email = $_POST['email'];
    if(empty($_POST['username'])){
        printSign("Please enter an account name.");
    }
    else if(empty($_POST['email'])){
        printSign("Please enter an e-mail address.");
    }
    else if(empty($_POST['password'])){
        printSign("Please enter a password.");
    }
    else if(empty($day) || empty($month) || empty($year) || strlen($day) > 2 || strlen($month) > 2 || strlen($year) != 4 || $day == 00 || $month == 00 || $year == 0000){
        printSign("Please enter your birth day.");
    }
    else if(strlen($_POST['username']) > 15){
        printSign("Your username cannot contain more than 15 characters!");
    }
    else if(strlen($_POST['password']) > 36){
        printSign("Your password cannot contain more than 36 characters!");
    }
    else if($_POST['username'] != $userRev){
        printSign("Your username contains illegal characters and/or words!");
    }
    else if($_POST['password'] != $passRev){
        printSign("Your password contains illegal characters!");
    }
    else if(strlen(filter_var($email, FILTER_VALIDATE_EMAIL)) == 0){ 
        printSign("Your is e-mail is incorrect, please check it!");
    }
    else {
        if ($resp->is_valid) {
            $userRev = strtolower($userRev);
            $passRev = strtolower($passRev);
            $bday = $month.'/'.$day.'/'.$year;
            $email = $_POST['email'];
            $salt = "gamingsync";
            $passRev = md5($salt.$passRev);
            if(!doesUsernameExist($userRev)){
                $stmt = mssql_init('dbo.webCreateAcc', $link);
                mssql_bind($stmt, '@account', $userRev, SQLVARCHAR, false, false, 15);
                mssql_bind($stmt, '@password', $passRev, SQLVARCHAR, false, false, 36);
                mssql_bind($stmt, '@birthday', $bday, SQLVARCHAR, false, false, 120);
                mssql_bind($stmt, '@email', $email, SQLVARCHAR, false, false, 120);
                mssql_execute($stmt) or die ("Error with the execution.");
                mssql_free_statement($stmt);
                printSign('<font color="black">Thank you for registering with the name '.$userRev.'.</font>');
                }
                else {
                    printSign("Username is already taken!");
                }
            }
        }
    }
}
function printSign($alert){
?>
<html>
    <body>
    <div align="center">
        <h1><u>ENTER SERVER NAME</u></h1>
        <?php if($alert != ''){ echo '<h2><font color="red">'.$alert.'</font></h2>'; } ?>
        <form action="flyffregister.php" method="post">
        <table>
            <tr>
                <td>Username :</td>
                <td><input size="20" name="username" maxlength="15" type="text"></td>
                <td>(A-Z, a-z, 1-9)</td>
            </tr>
            <tr>
                <td>Password :</td>
                <td><input size="20" name="password" maxlength="35" type="password"></td>
                <td>(A-Z, a-z, 1-9)</td>
            </tr>
            <tr>
                <td>E-mail :</td>
                <td><input size="20" name="email" maxlength="255" type="text"></td>
            </tr>
            <tr>
                <td>Birth day :</td>
                <td><input size="1" name="month" maxlength="2" type="text" value="MM"> <input size="1" name="day" maxlength="2" type="text" value="DD"> <input size="3" name="year" maxlength="4" type="text" value="YYYY"></td>
            </tr>
        </table>
            <input type="submit" name="submit" value="register" />
        </form>
        Copyright 2009 &copy; <a href="http://forum.furiazone.com/newthread.php?do=postthread&f=74"><b>Rick</b></a>.
    </div>
</body>
</html>
<?php } ?>
  8. 04-04-10 #7
    Jelle
    the sound's resound echo Jelle is offline
    MemberRank
    Jun 2009 Join Date
    ._.Location
    1,036Posts

    Re: MMSQL Site

    Nah the database is below that.
    User = sa

    What is mssql

    ---------- Post added at 08:33 PM ---------- Previous post was at 08:29 PM ----------

    Nah the database is below that.
    User = sa

    What is mssql
  9. 04-04-10 #8
    CupCake
    Valued Member CupCake is offline
    MemberRank
    Mar 2010 Join Date
    PortugalLocation
    124Posts

    Re: MMSQL Site

    mssql is the program u will need to execute the tables of the db of the official server files lol
  10. 04-04-10 #9
    Jelle
    the sound's resound echo Jelle is offline
    MemberRank
    Jun 2009 Join Date
    ._.Location
    1,036Posts

    Re: MMSQL Site

    I know, the previous post got kinda wrong submitted.
    But the site you gave me really doesnt work :/


« Previous Thread | Next Thread »

Advertisement