[HELP] webpage error please help

[Sexytana]

can anyone explain it i can understan this error. . .

[MentaL]

[Maples]

The user or password (most likely password) to connect to the database is wrong, go to ForsakenFlyff\inc\config.inc.php, open it with a text editor (or your favorite PHP IDE) and change the variable that contains the wrong password (you'll have to look around for it, I can't exactly point you to the line as I don't have that file) to the right password to connect to your database.

If there's no variable that holds the password, look for odbc_connect (still in the same file) and change the credentials there.

You can ignore the errors below the first one. The first error is what's indirectly causing the other errors.

[Sexytana]

which one here should i change?

Spoiler:

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

[Maples]

Ah, I see. The password is set using the define function. Search for this text: define('MSSQL_PASS', then you'll probably come accross a line like this:

define('MSSQL_PASS', 'SomePasswordHere');

Now change SomePasswordHere to the password of your SQL Server.

[Sexytana]

can you please highligted where i should change the pass?

Spoiler:

<?php
session_start();

// SQL Data
define('MSSQL_HOST', 'STEFAN-PC\SQLEXPRESS'); // MsSQL Host
define('MSSQL_USER', 'sa'); // MsSQL Username
define('MSSQL_PASS', 'password'); // MsSQL Password

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

// Including Files
include('functions.inc.php');

// Config
$_CONFIG['webtitle'] = getConfigValue('webtitle', 'Sapphire Flyff Website');
$_CONFIG['forumlink'] = getConfigValue('forumlink', 'http://www.google.com');
$_CONFIG['pwdsalt'] = getConfigValue('pwdsalt', 'kikugalanet');
$_CONFIG['noreply'] = getConfigValue('noreplymail', 'noreply@localhost.com');
$_CONFIG['ppemail'] = getConfigValue('ppemail', 'email@web.de');

[Maples]

Right here:

// SQL Data
define('MSSQL_HOST', 'STEFAN-PC\SQLEXPRESS'); // MsSQL Host
define('MSSQL_USER', 'sa'); // MsSQL Username
define('MSSQL_PASS', 'password'); // MsSQL Password

Note that, if these little things are too hard for you, I can, in no way, advise you to continue working on a flyff server/website. You'll run in way too much problems that you can't solve by yourself, just a heads-up.

[Sexytana]

the thing is ive already change that into my SQL password ****** and when im trying to look on my local host it says like this:

Spoiler:

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'., SQL state 28000 in SQLConnect in C:\wamp\www\ForsakenFlyff\inc\config.inc.php on line 10

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 9

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 10

Warning: odbc_result() expects parameter 1 to be resource, null given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 11

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 9

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 10

Warning: odbc_result() expects parameter 1 to be resource, null given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 11

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 9

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 10

Warning: odbc_result() expects parameter 1 to be resource, null given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 11

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 9

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 10

Warning: odbc_result() expects parameter 1 to be resource, null given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 11

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 9

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 10

Warning: odbc_result() expects parameter 1 to be resource, null given in C:\wamp\www\ForsakenFlyff\inc\functions.inc.php on line 11

[Maples]

Are you absolutely sure the password you entered is working? Have you tried connecting to the database using SQL Server Management Studio?

[Sexytana]

Do i need to create a "New Database" on my SQL server and name as "WEBSITE_DBF" i wonder how to restore the "WEBSITE_DBF"
that is include on the file that i downloaded.

[Sexytana]

damn stupid i am ive forgot that i uninstall my sql server and make a new with different password, not its already fix. . thanks a lot for the help mate. my problem after successfull registration it has errors and here it is:

[Maples]

Do i need to create a "New Database" on my SQL server and name as "WEBSITE_DBF" i wonder how to restore the "WEBSITE_DBF"
that is include on the file that i downloaded.

Connect to your server using SQL Server Management Studio, right click Databases and click on Restore Database...



In To Database (1) enter WEBSITE_DBF, then select the From device: (2) option, and lastly click the button to the right (3)



It'll open a new window. Now click Add (1), select the WEBSITE_DBF file and click OK (2).



When that's done, you'll return to the previous window (which was still open). Press OK there and you'll have the database restored.

Edit: To put your server online, see: http://forum.ragezone.com/f483/new-d...8/#post7124266

[Sexytana]

i was asking how to fix this error after registration complete :(



what should i replace in this code ?

Spoiler:

} else {
odbc_exec($mssql, 'INSERT INTO [dbo].[ACCOUNT_TBL] (account, password, isuse, member, id_no1, id_no2, realname, reload, OldPassword, TempPassword, cash) VALUES (N\''.mssql_escape_string($_POST['reg_username']).'\', N\''.mssql_escape_string(md5($_CONFIG['pwdsalt'].$_POST['reg_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['reg_username']).'\', N\'A000\', N\'2\', N\'F\', \''.mssql_escape_string(date('Ymd H:i:s')).'\', N\'20010101\', N\'20990101\', N\'20050101\', N\'O\', NULL, N\''.mssql_escape_string($_POST['reg_email']).'\')');
echo '<div class="success">Your account has successfully been created!</div>';
}

[Valkyrie]

It's telling you that one "column" from a table that the register page is using doesn't exist.
Is there a column in your Database called "OldPassword"?
If not, check the script... see what columns it uses, then check them against the database and make sure they match correctly.

[Sexytana]

this what i got in my data base acount_tbl tables coloumn



some are not existing cplumns in my data base are:

Spoiler:

else {
odbc_exec($mssql, 'INSERT INTO [dbo].[ACCOUNT_TBL] (account, password, isuse, member, id_no1, id_no2, realname, reload, OldPassword, TempPassword, cash) VALUES (N\''.mssql_escape_string($_POST['reg_username']).'\', N\''.mssql_escape_string(md5($_CONFIG['pwdsalt'].$_POST['reg_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['reg_username']).'\', N\'A000\', N\'2\', N\'F\', \''.mssql_escape_string(date('Ymd H:i:s')).'\', N\'20010101\', N\'20990101\', N\'20050101\', N\'O\', NULL, N\''.mssql_escape_string($_POST['reg_email']).'\')');
echo '<div class="success">Your account has successfully been created!</div>';

the red highlighted are not existing in my columns how do i edited them to disappear and avoid error in my webpage



•also i havce this error in vote script can anyone please help or tell me what should i need to do to avoid this error. :(



please help thanks in advance :D

[Maples]

Did you even read the ReadMe.txt? Read it first, follow the steps (translate it to English if you do not understand German) and you'll should be fine.

1. MoltenFlyff Ordner in das Webverzeichnis legen
2. config.inc.php im Ordner inc/ bearbeiten (MSSQL Daten, Vote Seiten)
3. Datenbank WEBSITE_DBF in MSSQL erstellen und danach beigelegte WEBSITE_DBF.sql ausführen
4. In ACCOUNT_DBF -> ACCOUNT_TBL folgende Spalten adden:
- lastvote1 (Typ: datetime)
- lastvote2 (Typ: datetime)
- lastvote3 (Typ: datetime)
- votepoints (Typ: int)

So bottomline; add the columns from 4. to ACCOUNT_DBF -> ACCOUNT_TBL

@Your post before, you asked me how you could restore a database, so I gave you a tiny tutorial..