Account

06/21/2013 06:40 uncmp4#1
Hey guys i have a question. I have succesfully created my own dekaron test server thanks to KingTuT and Toasty. I have a question, how do i create more accounts using the Enterprise????
06/21/2013 16:13 Farius~#2
With Query Analizer:

Use This Code
Code:
Use account;
Go
---Account Query By Warmonger---
DECLARE @UserNO varchar(16), @AccountID varchar(16), @Password  varchar(32), @Email varchar(50), @SecretA varchar(22), @SecretQ  varchar(22)
SET @UserNO= '09101410275532'
SET @AccountID = 'Account ID'
SET @Password = 'Account Password'
SET @Email = 'E-Mail'
SET @SecretA = 'Secret Answer'
SET @SecretQ = 'Secret Question'
 
Insert Into [USER_PROFILE] Values  (@UserNO,@AccountID,@Password,'801011000000','1','0','Y','01/01/2006  00:00:00',null,null,null,'000')
1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager)
2. Go To Tools -> SQL Query Analyzer (Login With Your "sa" Password)
3. Go To [Only registered and activated users can see links. Click Here To Register...] And Generate A Hashed Password And Define It Below.

(NOTE: 09101410275532 Must Be Changed Atleast 1 Digit Per Account Added This Way)
06/21/2013 23:34 uncmp4#3
soo i just copy paste this and then what?

i get errors when i do that... add me on skype michael.m.m1 and talk me thru it...
06/22/2013 07:50 .Genome.#4
If you took the time to read his post he said you need to change the UserNO number by 1 per account manually created.

The best way to make accounts is by doing what everyone else does and set up a registration page.
06/22/2013 23:22 uncmp4#5
:( im sorry i didnt see the bottom part. and could you instruct me on how to do that?. My server isnt public yet, im trying to figure out how to get it public. im completely new to owning a server. i need as much help as i can get.

Genome thanks soo much it worked :D, you guys are like GODS to me. id like to add some of you on my skype.. michael.m.m1 [GM]Michael

how can i change EXP rates to the max?? i kno go into Formula, line 19 but what is the highest it can be??
06/23/2013 04:55 Farius~#6
1. Go To [Only registered and activated users can see links. Click Here To Register...] And Download.

2. Go To c:/xampp/htcdos

3. create new file with name: register.php

Pasted This Code:

Code:
<?php

// fill in your mssql info here
$mssql = array(
        'host' => "localhost",
        'user' => "sa",
        'pass' => "server"
    );

function anti_injection($sql) {
   $sql = preg_replace(sql_regcase("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"),"",$sql);
   $sql = trim($sql);
   $sql = strip_tags($sql);
   $sql = addslashes($sql);
   return $sql;
}


echo "<center>";

if($_POST['activ'] == '1') {

        $accname = anti_injection($_POST['accname']);
        $accmail = anti_injection($_POST['accmail']);
        
        $accpass1 = anti_injection($_POST['accpass1']);
        $accpass2 = anti_injection($_POST['accpass2']);
    
        $con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);

        $result1 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE WHERE user_id = '".$accname."'",$con);
        $result2 = mssql_query("SELECT * FROM account.dbo.Tbl_user WHERE user_id = '".$accname."'",$con);
        $result3 = mssql_query("SELECT * FROM account.dbo.Tbl_user WHERE user_mail = '".$accmail."'",$con);

        $row1 = mssql_num_rows($result1);
        $row2 = mssql_num_rows($result2);
        $row3 = mssql_num_rows($result3);
        
        $dk_time=strftime("%y%m%d%H%M%S");
         list($usec1, $sec1) = explode(" ",microtime());
         $dk_user_no=$dk_time.substr($usec1,2,2);


        if(empty($accname) || empty($accpass1) || empty($accpass2)|| empty($accname) || empty($accmail)) {
            echo "<br>You didnt fill in all fields<a href='javascript:history.back()'>Go Back</a>";
        } elseif($row1 > '0' || $row2 > '0') {
            echo "<br>This Account name already exists.<a href='javascript:history.back()'>Go Back</a>";
        } elseif($row3 > '0') {
            echo "<br>This E-Mail is already in use.<a href='javascript:history.back()'>Go Back</a>";
        } elseif($accpass1 != $accpass2) {
            echo "<br>The passwords did not match<a href='javascript:history.back()'>Go Back</a>";
        } elseif($accpass1 == $accname) {
            echo "<br>Account name and password are the same.<a href='javascript:history.back()'>Go Back</a>";
        } elseif(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $accname)) {
            echo "<br>Enter a account name only with 0-9 , a-z and A-Z.<a href='javascript:history.back()'>Go Back</a>";
        } elseif(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $accpass1)) {
            echo "<br>Enter a password only with 0-9 , a-z and A-Z.<a href='javascript:history.back()'>Go Back</a>";
        } elseif(!preg_match("/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/i",$accmail)) {
            echo "<br>Your e-Mail is not correct.<a href='javascript:history.back()'>Go Back</a>";
        } elseif(strlen($accname) < 3 || strlen($accname) > 15) {
            echo "<br>The Accountname must at least 3 indications long and may maximally 15 indications long.<a href='javascript:history.back()'>Go Back</a>";
        } elseif(strlen($accpass1) < 3 || strlen($accpass1) > 15) {
            echo "<br>The Password must at least 3 indications long and may maximally 15 indications long.<a href='javascript:history.back()'>Go Back</a>";
        } else {

            $accpass = md5($accpass1);

            mssql_query("INSERT INTO account.dbo.USER_PROFILE (user_no,user_id,user_pwd,resident_no,user_type,login_flag,login_tag,ipt_time,login_time,logout_time,user_ip_addr,server_id) VALUES ('$dk_user_no','".$accname."','".$accpass."','801011000000','1','0','Y','".$date."',null,null,null,'000')",$con);
            mssql_query("INSERT INTO account.dbo.Tbl_user (user_no,user_id,user_pwd,user_mail,user_answer,user_question) VALUES ('$dk_user_no','".$accname."','".$accpass1."','".$accmail."','0','0')",$con);

            echo "<center><b><u>The account was successfully created. Have fun !</b></u></center><br><br>";
            echo "<center>Here is your login info again:</center>";
            echo "<center>Your account name is: <b>".$accname."</b></center>";
            echo "<center>Your password is: <b>".$accpass1."</b></center>";
            echo "DO NOT LOOSE THIS INFO, YOU MAY WRITE IS DOWN AND HIDE IT";
        }

} else {

    $con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
    $result1 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE",$con);
    $row1 = mssql_num_rows($result1);
    
    echo "<center><b><u>This time we have ".$row1." Registed Accounts on our Server<br>Join us.</b></u></center><br>";
    echo "<form action='".$_SEVER['PHP_SELF']."' method='POST'>";
    echo "<center><table>";
    echo "<tr><td colspan='2' align='center'><b><u>Your Account Info</u></b></td></tr>";
    echo "<tr><td>Account Name</td><td><input type='text' name='accname' maxlength='12'></td></tr>";
    echo "<tr><td>Password</td><td><input type='password' name='accpass1' maxlength='12'></td></tr>";
    echo "<tr><td>Again pass.</td><td><input type='password' name='accpass2' maxlength='12'></td></tr>";
    echo "<tr><td>&nbsp;</td><td>&nbsp;</td></tr>";
    echo "<tr><td colspan='2' align='center'><b><u>Other account info</u></b></td></tr>";
    echo "<tr><td>Email</td><td><input type='text' name='accmail' maxlength='50'></td></tr>";
    echo "<tr><td>&nbsp;</td><td>&nbsp;</td></tr>";
    echo "<tr><td colspan='2' align='center'>
        <input type='hidden' name='activ' value='1'>
        <input type='submit' value='Create Account'></td></tr>";
    echo "</table></center>";
    echo "</form>";

}

echo "</center>";

?>
Remember Config This:

Code:
$mssql = array(
        'host' => "localhost",
        'user' => "sa",
        'pass' => "server"
and open yours Browser, and put: localhost/register.php.