Damned_Flyff_rev2 > Problem in REGISTER

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

Quote:

---

<?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'); ?>

---

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', 'billing@server.com');
$mail['abuse'] = getConfigValue('mail_abuse', 'abuse@server.com');
$mail['paypal'] = getConfigValue('mail_paypal', 'paypal@server.com');

// 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 Alot....:(:

I'm not entirely sure what you're trying to do.. I do know that Flyff only uses MSSQL for everything. Unless that website does some things of it's own in MySQL.

Check the row number and names in your database.