How do I create my account???
I have no clue how to create accounts, I did setup the server and everything correctly and now I don't know how to create my account on it to login :blink:
Can someone help me out I tried searching through the forums but nothing helped, I've been searching for HOURS...
I need help pretty much on everything, please lend me a hand.
Thanks is advance.
Re: How do I create my account???
Open your Query Analyzer and type this in
Code:
use account
exec dbo.cabal_tool_registerAccount 'yourusername' , 'yourpw'
Change the ones in bold to your preferred username and password.
Or download XAMPP, and put this(save it as index.php or something) in your root folder(Default: C:\xampp\htdocs\)
PHP Code:
<?php
// Config
// Title
echo '<title>CABAL Online Register</title>';
// MSSQL server connection details
// Database server
define('DB_ADDR','127.0.0.1');
// Database login
define('DB_USER','sa');
// Database password
define('DB_PASS','password');
// In case you have a different db names
define('DB_ACC','ACCOUNT');
define('DB_GAM','GAMEDB');
$link = mssql_connect(DB_ADDR, DB_USER, DB_PASS);
if (!$link) die('Could not connect to MSSQL database.');
$num_acc=0;
$num_cha=0;
$num_onl=0;
$r=mssql_query('select count (*) from '.DB_ACC.'.dbo.cabal_auth_table');
$num_acc=mssql_result($r,0,0);
$r=mssql_query('select count (*) from '.DB_ACC.'.dbo.cabal_auth_table where Login=1');
$num_onl=mssql_result($r,0,0);
$r=mssql_query('select count (*) from '.DB_GAM.'.dbo.cabal_character_table');
$num_cha=mssql_result($r,0,0);
echo '<div align="center">';
echo '<p style="font-size:24px;font-weight:bold">CABAL Online Account Registration</p>';
echo '<p>Login ID and Password must be at least a minimum of 6 characters, letters and/or numbers only.</p>';
echo '<form method="post" action="'.$_PHP['self'].'">';
echo '<table cellspacing="4" cellpadding="0" border="0">';
echo '<tr><td align="right">Login ID: </td><td><input type="text" name="uname" class="editbox"></td></tr>';
echo '<tr><td align="right">Password: </td><td><input type="password" name="pass" class="editbox"></td></tr>';
echo '<tr><td align="right">Confirm Password: </td><td><input type="password" name="pass2" class="editbox"></td></tr>';
echo '<tr><td colspan="2" align="center"><input type="submit" value="Register" class="button"></td></tr><br \>';
echo '</table>';
echo '</form>';
echo '<p>Registered accounts: <span style="font-size:16px;font-weight:bold">'.$num_acc.'</span> | Characters created: <span style="font-size:16px;font-weight:bold">'.$num_cha.'</span></p>';
$uid='';
$pass='';
$failed=false;
if (isset($_POST['uname'])) {
if (!ctype_alnum($_POST['uname']) || strlen($_POST['uname'])<6) {
$failed=true;
echo '<p class="errortext">Invalid username. Minimum of 6 characters, letters and numbers only.</p> ';
} else {
$uid=$_POST['uname'];
}
}
if (isset($_POST['pass'])) {
if (!ctype_alnum($_POST['pass']) || strlen($_POST['pass'])<6) {
$failed=true;
echo '<p class="errortext">Invalid password. Minimum of 6 characters, letters and numbers only.</p> ';
} else {
$pass=$_POST['pass'];
}
}
if (isset($_POST['pass2'])) {
if (!ctype_alnum($_POST['pass2'])) {
$failed=true;
} else {
if ($_POST['pass2']!=$_POST['pass']) {
$failed=true;
echo '<p class="errortext">Both password fields do not match.</p> ';
}
}
}
if ($failed==true) {
echo '<p class="errortext">Account Registration Failed.</p> ';
} else {
if ($uid!='' && $pass!='') {
$r=mssql_query('select count (*) from '.DB_ACC.'.dbo.cabal_auth_table where ID="'.$uid.'"');
if (mssql_result($r,0,0)==0) {
$r=mssql_query('exec '.DB_ACC.'.dbo.cabal_tool_registerAccount "'.$uid.'","'.$pass.'"');
if ($r==false) {
echo '<p class="errortext">Something went wrong.</p>';
} else {
echo '<p class="goodtext">Account created successfully.</p>';
}
mssql_free_result($r);
mssql_close($link);
} else {
echo '<p class="errortext">Login ID has been used.</p> ';
}
}
}
echo '</div>';
?>
Make sure you edit the config. Credits to chumpy for this registration page.
By the way, have you really searched for HOURS? It's mentioned in this video guide/tutorial(...and the thread is on the front page as well). http://forum.ragezone.com/f460/video...by-fix-524857/ http://forums.asiasoftsea.net/images/smilies/py62.gif
Re: How do I create my account???
How do I create the databases I need in the MSSQL?
Yeah, I've been on this forum FOREVER....
Taking me forever all I want to do it try to put up a Cabal PS...
Re: How do I create my account???
Quote:
Originally Posted by
SkilledKorean
How do I create the databases I need in the MSSQL?
Yeah, I've been on this forum FOREVER....
Taking me forever all I want to do it try to put up a Cabal PS...
Ok, look in my siggy as everything you need is there. Start with the MSSQL guide and make sure that is all set up correctly. Next onto Centos (my repack and databases are on my v2.5 topic) and finally read the miniguide that comes with my server repack.
The "how to properly start a Cabal client" topic in my sig explains how to log in. I recommend a clean non-updated ogplanet client and saur0n's login patch.
http://forum.ragezone.com/f459/sync-...client-457455/
Re: How do I create my account???
i try to create an account i use microsoft sql server 2005 but it doesn't work :
use account
exec dbo.cabal_tool_registerAccount 'yourusername' , 'yourpw'
and the result is:
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 10
Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.
(1 row(s) affected)
what now??
help me
Re: How do I create my account???
Errors resulting in "cannot insert NULL" are always down to xp_md5 not working properly.
If you run the query below and get a "null" back your md5 isn't working, if you get letters and numbers it is. Check for the xp_md5 in the extended procedures folder in mssql and check the path to the dll is correct and that the .dll allows the "everyone" group read access at least.
select account.dbo.fn_md5('test')
If you want a good tip here use search to search on the error meesage and set "posts by" as my name. You will always find the answer ;)
Re: How do I create my account???
Wow Chumpy.
Im searching for this answer for 3 hours.
I forgot to put xp_md5.dll in my Cabal inventory :D
Thats ver funny,but thanks,you are best man.
2 Attachment(s)
Re: How do I create my account???
i search and found this then i try it..
\but error occurs
and how do i know that my server is ok??
i just follow dodorts guide
Attachment 68977
log files sir, i dont know if they are ok or not
Attachment 68976
heres my settigns
http://www.mediafire.com/file/bdzjweommyk/settings.rar
Re: How do I create my account???
Quote:
Originally Posted by
ramispo
Go to the directory where you transferred the server file then open cabal_install.sh; select run terminal or something. Then after you finished installing, type cabal_config and press enter on the terminal. Then poof.
Re: How do I create my account???
aw, im so noob about this sir>>
whre can i find this one cabal_install.sh?
what folder??
im in root now>> im using winscp
what folder name?
Re: How do I create my account???
use centos, go to the directory where you transferred the files!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
then open it!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Re: How do I create my account???
Quote:
Originally Posted by
ramispo
aw, im so noob about this sir>>
whre can i find this one cabal_install.sh?
what folder??
im in root now>> im using winscp
what folder name?
So you are in the root folder, exactly where the readme tells you to be, and you can't see cabal_install.sh? There are only 2 .sh files in the folder!
Re: How do I create my account???
sir chumpy, i found the cabal_install.sh
but what will i do,
theres no guide like this in dodorts video T_T
i dont know what does this mean
Quote:
Originally Posted by
GunKill
Go to the directory where you transferred the server file then open cabal_install.sh; select run terminal or something. Then after you finished installing, type cabal_config and press enter on the terminal. Then poof.
how to do this sir chump??
echo -e "\nAll done. You should now run cabal_config.sh to configure the server."
echo -e "E.g. /home/cabal/cabal_config.sh\n"
how to run?
i tried this one "run cabal_config.sh"
and this "run cabal_install.sh"
but it says command not found
i have NO idea when it comes to linux commands sorry
Re: How do I create my account???
Open it with terminal, right click>open with>terminal!
Dang.