Damned_Flyff_rev2 > Problem in REGISTER

guemebr1 · 12/19/2011, 05:52

Hello!

I am having a problem to register my bills using the website Damned rev2 of Surako.

When I create an account will only account for mysql, mssql and not for I'm desperate please help!

My register.php

Code:

<?php include('inc/header.php'); ?>
<h1><?php echo $lang['h1_register']; ?></h1>
<?php
	// Auf Fehler kontrollieren
	$checkacc = mysql_query('SELECT * FROM `'.TABLE_PREFIX.'users` WHERE `username`=\''.mysql_real_escape_string($_POST['username']).'\'');
	$checkmail = mysql_query('SELECT * FROM `'.TABLE_PREFIX.'users` WHERE `email`=\''.mysql_real_escape_string($_POST['email']).'\'');
	$errors = array();
	if($_POST['username'] == '' || $_POST['password'] == '' || $_POST['reppassword'] == '' || $_POST['email'] == '' || $_POST['day'] == '' || $_POST['month'] == '' || $_POST['year'] == '' || $_POST['captcha'] == '')
		$errors[] = $lang['register_error_fillin'];
	if($_POST['username'] != '' && mysql_num_rows($checkacc) > 0)
		$errors[] = $lang['register_error_usernameexist'];
	if($_POST['email'] != '' && mysql_num_rows($checkmail) > 0)
		$errors[] = $lang['register_error_emailexist'];
	if(($_POST['password'] != '' && $_POST['reppassword'] != '') && $_POST['password'] != $_POST['reppassword'])
		$errors[] = $lang['register_error_password'];
	if(($_POST['username'] != '') && (strlen($_POST['username']) > 10 || strlen($_POST['username']) < 4))
		$errors[] = $lang['register_error_userlength'];
	if(($_POST['password'] != '') && (strlen($_POST['password']) > 11 || strlen($_POST['password']) < 6))
		$errors[] = $lang['register_error_passlength'];
	if($_POST['email'] != '' && !preg_match('/^[a-zA-Z0-9-_.]+@[a-zA-Z0-9-_.]+\.[a-zA-Z]{2,4}$/', $_POST['email']))
		$errors[] = $lang['register_error_email'];
	if(($_POST['day'] != '' && $_POST['year'] != '' && $_POST['month'] != '') && (strlen($_POST['day']) > 2 || strlen($_POST['year']) > 4 || strlen($_POST['year']) < 4))
		$errors[] = $lang['register_error_bday'];
	if($_POST['captcha'] != '' && ($_SESSION['captcha'] != md5($_POST['captcha'])))
		$errors[] = $lang['register_error_captcha'];
	
	// Buttonklick
	if(isset($_POST['regsbm'])) {
		if(count($errors) > 0) {
			// Fehler ausgeben
			echo '<div class="fail">';
			foreach($errors as $error) {
				echo $error.'<br/>';
			}
			echo '</div>';
		} else {
			// Account erstellen
			// Insert into MSSQL
			@odbc_exec($mssql, 'USE [ACCOUNT_DBF] INSERT INTO [dbo].[ACCOUNT_TBL] (account, password, isuse, member, id_no1, id_no2, realname, reload, OldPassword, TempPassword, cash) VALUES (N\''.mssql_escape_string($_POST['username']).'\', N\''.mssql_escape_string(md5($_CONFIG['pwsalt'].$_POST['password'])).'\', N\'T\', N\'A\', NULL, 0, N\'P\', NULL, 0, NULL, 0)');
			@odbc_exec($mssql, 'USE [ACCOUNT_DBF] INSERT INTO [dbo].[ACCOUNT_TBL] (account, password, isuse, member, id_no1, id_no2, realname, reload, OldPassword, TempPassword, cash) VALUES (N\''.mssql_escape_string($_POST['username']).'\', N\''.mssql_escape_string(md5($_CONFIG['pwsalt'].$_POST['password'])).'\', N\'T\', N\'A\', NULL, 0, N\'P\', NULL, 0, NULL, 0)');
			@odbc_exec($mssql, 'INSERT INTO [dbo].[ACCOUNT_TBL_DETAIL] (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse, secession, email) VALUES (N\''.mssql_escape_string($_POST['username']).'\', N\'A000\', N\'2\', N\'F\', \'20080818 00:51:35.700\', N\'20010101\', N\'20990101\', N\'20050101\', N\'O\', NULL, NULL)');
			// Insert into MySQL
			// Website
			mysql_query('INSERT INTO `'.TABLE_PREFIX.'users`(username, password, email, birthday, regdate) VALUES(\''.mysql_real_escape_string($_POST['username']).'\', \''.mysql_real_escape_string(md5($_POST['password'])).'\', \''.mysql_real_escape_string($_POST['email']).'\', \''.mysql_real_escape_string($_POST['year']).'-'.mysql_real_escape_string($_POST['month']).'-'.mysql_real_escape_string($_POST['day']).'\', \''.date('Y-m-d H:i:s').'\')');
			// Ticket System
			mysql_query('INSERT INTO `'.TS_TABLE_PREFIX.'user`(username, password, email, birthday) VALUES(
	\''.mysql_real_escape_string($_POST['username']).'\',
	\''.md5(mysql_real_escape_string($_POST['password'])).'\',
	\''.mysql_real_escape_string($_POST['email']).'\',
	\''.mysql_real_escape_string($_POST['year']).'-'.mysql_real_escape_string($_POST['month']).'-'.mysql_real_escape_string($_POST['day']).'\')');
			echo '<div class="success">'.$lang['register_success'].'</div>';
		}
	}
?>
<form action="" method="post">
	<table>
    	<tr>
        	<td><?php echo $lang['register_username']; ?>:</td>
            <td><a title="<?php echo $lang['tooltip_register_username']; ?>" rel="tooltip"><input type="text" name="username" /></a></td>
        </tr>
    	<tr>
        	<td><?php echo $lang['register_password']; ?>:</td>
            <td><a title="<?php echo $lang['tooltip_register_password']; ?>" rel="tooltip"><input type="password" name="password" /></a></td>
        </tr>
    	<tr>
        	<td><?php echo $lang['register_reppassword']; ?>:</td>
            <td><a title="<?php echo $lang['tooltip_register_reppassword']; ?>" rel="tooltip"><input type="password" name="reppassword" /></a></td>
        </tr>
    	<tr>
        	<td><?php echo $lang['register_email']; ?>:</td>
            <td><a title="<?php echo $lang['tooltip_register_email']; ?>" rel="tooltip"><input type="text" name="email" /></a></td>
        </tr>
    	<tr>
        	<td style="vertical-align: top;"><?php echo $lang['register_bday']; ?>:</td>
            <td>
            	<a title="<?php echo $lang['tooltip_register_day']; ?>" rel="tooltip"><input type="text" name="day" style="background: url('img/input_txtsmall.png'); width: 28px;" /></a>
                <a title="<?php echo $lang['tooltip_register_month']; ?>" rel="tooltip"><select name="month" style="width: 130px;">
                	<option value="1"><?php echo $lang['month_jan']; ?></option>
                	<option value="2"><?php echo $lang['month_feb']; ?></option>
                	<option value="3"><?php echo $lang['month_mar']; ?></option>
                	<option value="4"><?php echo $lang['month_apr']; ?></option>
                	<option value="5"><?php echo $lang['month_may']; ?></option>
                	<option value="6"><?php echo $lang['month_jun']; ?></option>
                	<option value="7"><?php echo $lang['month_jul']; ?></option>
                	<option value="8"><?php echo $lang['month_aug']; ?></option>
                	<option value="9"><?php echo $lang['month_sep']; ?></option>
                	<option value="10"><?php echo $lang['month_oct']; ?></option>
                	<option value="11"><?php echo $lang['month_nov']; ?></option>
                	<option value="12"><?php echo $lang['month_dec']; ?></option>
                </select></a>
                <a title="<?php echo $lang['tooltip_register_year']; ?>" rel="tooltip"><input type="text" name="year" style="background: url('img/input_txtsmall.png'); width: 28px;" /></a><br/>
                <?php echo $lang['register_bday_eg']; ?>
            </td>
        </tr>
    	<tr>
        	<td><img src="inc/captcha.php" /></td>
            <td><a title="<?php echo $lang['tooltip_register_captcha']; ?>" rel="tooltip"><input type="text" name="captcha" size="5" /></a></td>
        </tr>
    	<tr>
        	<td></td>
            <td><input type="submit" name="regsbm" value="<?php echo $lang['input_register']; ?>" /></td>
        </tr>
    </table>
</form>
<br style="clear: both;" />
<?php include('inc/footer.php'); ?>

thanks....

dennisdra · 12/19/2011, 07:30

Check your mssql Config in the Inc Folder.
And a Other reason Would be, that your webserver has no Mssql support.
What are you using? Xampp or IIS ?
Xampp has Since v1.7.3 no mssql Extension included

guemebr1 · 12/19/2011, 08:08

Hi dude! my xampp is 1.7.7 version, my mssql in php.ini is active and functional.

my config.inc.php.

Quote:

<?php
// Defining MySQL Data
define("MYSQL_HOST", 'localhost');
define("MYSQL_USER", 'root');
define("MYSQL_PASS", 'XXXXXXX');
define("MYSQL_DB", 'damnedflyff');
define("TABLE_PREFIX", 'damn_');
define("TS_TABLE_PREFIX", 'ts_');

// Connecting to MySQL
mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS);
mysql_select_db(MYSQL_DB);

// Defining MSSQL Data
define("MSSQL_DSN", XXXXXX');
define("MSSQL_USER", 'sa');
define("MSSQL_PASS", 'XXXXXX');

// Connecting to MSSQL (ODBC)
$mssql = odbc_connect('Driver={SQL Server};Server='.MSSQL_DSN.';', MSSQL_USER, MSSQL_PASS);

// Including files
include('functions.inc.php');
include('ranking.inc.php');

// Config
$_CONFIG['title'] = getConfigValue('title', 'Damned!');
$_CONFIG['pwdsalt'] = getConfigValue('pwdsalt', 'kikugalanet');

// Shop
$currency = getConfigValue('shop_currency', 'dpoints'); // Währung
$currencyshort = getConfigValue('shop_currency_short', 'dp'); // Währung (Kurzform)
$itmperpage = getConfigValue('shop_itmperpage', 10); // Items pro Seite

// Contact
$mail['billing'] = getConfigValue('mail_billing', '');
$mail['abuse'] = getConfigValue('mail_abuse', '');
$mail['paypal'] = getConfigValue('mail_paypal', '');

// Paypal

// Language
if(isset($_GET['lang'])) {
if(file_exists('languages/'.$_GET['lang'].'.php')) {
$_SESSION['lang'] = $_GET['lang'];
}
}

if(!isset($_SESSION['lang'])) {
$_SESSION['lang'] = 'english';
}
include('languages/'.$_SESSION['lang'].'.php');
?>

Thanks again.