[Tut] How to allow players to fix "ID is already Logged in via Website"

**voldermord** · 03-06-08

FOR ODINMS
Can be changed for any other by editing fix.php insert value
Re: ID is already logged in when acct is actually logged out..
I found it quite annoying and decided to allow players to fix their accounts themselves without bugging me out..

I will cover how to enable PHP in HTML pages below if your page is running any PHP scripts.

Ok copy these into notepad and save as index.html or anything u wish to put as ur link. U can also put this in any segment of your webpage, it must be .HTML

Code:

<form action="fix.php" method="post"> 
Login: <input name="login" type="text" />
<br><br>
Password: <input name="pass" type="password" />
<br><br>
<input type="submit" value="Fix Login!"/>
</form>

Copy this into notepad and rename it fix.php

Code:

<title>Fix Login</title>
<body background="bg.jpg" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<?php
include('config.php');

$login = $_POST['login'];
$pass = $_POST['pass'];

$resultsalt = mysql_query("SELECT salt FROM accounts WHERE name='$login'"); 
if ($row = mysql_fetch_array($resultsalt)){
   do {
         $salt = $row["salt"];
   } while ($row = mysql_fetch_array($resultsalt)); 
} else { 
echo "You need to be logged off before you can do this!";
}
$password = hash('sha512', $pass . $salt);

$sqlquery = "SELECT * FROM accounts WHERE name = '$login' AND password = '$password'";
$result = mysql_query($sqlquery);
$number = mysql_num_rows($result); //LINE NUMBER 23

$i = 0;
if ($number < 1) //10
{
echo "This account doesn't exist, or the password is wrong.";
}
else
{
if ($number > $i)
{
$sqlquery2 = "Update accounts SET loggedin = 0 WHERE name='$login'";
mysql_query("$sqlquery2") or DIE (mysql_error());
echo "The account has been unbugged successfully!";
}
}

?>
<center><h5>Credits to Voldermord<h5></center>

lastly, copy the following into notepad and rename config.php

Code:

   <?php
//Database details

$host['name'] = 'localhost';                // your host
$host['username'] = 'root';       // your database username
$host['password'] = 'yourpasswordhere';   // your database password
$host['databasename'] = 'odinms';       // your database name

$db = mysql_connect($host['name'], $host['username'], $host['password']) OR die ('Cant connect to the database');
mysql_select_db($host['databasename'], $db);
?>

Lastly Put this into another notepad file and save as ".htaccess"
important, must include the ""
This is to enable PHP in HTML pages

Code:

RemoveHandler .html .htm
AddType application/x-httpd-php .php .htm .html

Do those and copy to your PHP enabled webserver, apache mod or Wampserver root folder or whereever ur htdocs/www folder is.
* The .htaccess must be in the same folder as the 3 other files.

Edit
Thanks ddxsamx - pointing out the mistake which would render an error i will definitely get spammed for :D

Edit
The page to change is NOT the fix.php if u try to go there it will juz give u a download link. The page is the .html page where u EMBEDDED the first code at the top below the bolded words.

**MentaL**

[Tut] How to allow players to fix "ID is already Logged in via Website"

**ddxsamx** · 03-06-08

You have forgotten a [ in your config.php

$db = mysql_connect($host['name'], $host['username'], $host['[password']) OR die ('Cant connect to the database');
mysql_select_db($host['databasename'], $db);
?>

Either that, or you've added an extra -

"[" in $host['[password'] = 'yourpasswordhere'; // your database password

But great work! =)

**xshinobii** · 08-06-08

Nice job!

**relix** · 17-06-08

Sorry, i need to ask, where is the wamp root folder? I tried putting it in the www folder along with my reg page but the Login Fix part still doesn't show.

**narut8251** · 17-06-08

yea it come out a download link of the fix.php

**voldermord** · 17-06-08

you dont go to /%/fix.php

you put the

Code:

<form action="fix.php" method="post"> 
Login: <input name="login" type="text" />
<br><br>
Password: <input name="pass" type="password" />
<br><br>
<input type="submit" value="Fix Login!"/>
</form>

into a html file and u go to the .html

basically the above is the form. Embed into any part of your webpage. Put the fix.php and config.php in the same folder. people go through the webpage u made with the form inside to fix their login status.

**ZorrousingZ** · 17-06-08

Always When i try to do a private server it does'nt work cuz
it pop's up a window it says:
Unable to connect to the server.
Either you are not online or maplestory is going
through a server check
Please check the maplestory homepage for more
information.

**voldermord** · 17-06-08

Originally Posted by ZorrousingZ

Always When i try to do a private server it does'nt work cuz
it pop's up a window it says:
Unable to connect to the server.
Either you are not online or maplestory is going
through a server check
Please check the maplestory homepage for more
information.

well this isnt the place to ask about that..

**Xskyline846** · 19-06-08

what i do worng:

Warning: include(config.php) [function.include]: failed to open stream: No such file or directory in C:\Program Files\Abyss Web Server\htdocs\fix.php on line 4

Warning: include() [function.include]: Failed opening 'config.php' for inclusion (include_path='.;C:\php5\pear') in C:\Program Files\Abyss Web Server\htdocs\fix.php on line 4

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Abyss Web Server\htdocs\fix.php on line 10
You need to be logged off before you can do this!
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\Abyss Web Server\htdocs\fix.php on line 21
This account doesn't exist, or the password is wrong.
Credits to Voldermord

**sush** · 19-06-08

Originally Posted by voldermord

FOR ODINMS
Can be changed for any other by editing fix.php insert value
Re: ID is already logged in when acct is actually logged out..
I found it quite annoying and decided to allow players to fix their accounts themselves without bugging me out..

I will cover how to enable PHP in HTML pages below if your page is running any PHP scripts.

Ok copy these into notepad and save as index.html or anything u wish to put as ur link. U can also put this in any segment of your webpage, it must be .HTML

Code:

<form action="fix.php" method="post"> 
Login: <input name="login" type="text" />
<br><br>
Password: <input name="pass" type="password" />
<br><br>
<input type="submit" value="Fix Login!"/>
</form>

Copy this into notepad and rename it fix.php

Code:

<title>Fix Login</title>
<body background="bg.jpg" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<?php
include('config.php');

$login = $_POST['login'];
$pass = $_POST['pass'];

$resultsalt = mysql_query("SELECT salt FROM accounts WHERE name='$login'"); 
if ($row = mysql_fetch_array($resultsalt)){
   do {
         $salt = $row["salt"];
   } while ($row = mysql_fetch_array($resultsalt)); 
} else { 
echo "You need to be logged off before you can do this!";
}
$password = hash('sha512', $pass . $salt);

$sqlquery = "SELECT * FROM accounts WHERE name = '$login' AND password = '$password'";
$result = mysql_query($sqlquery);
$number = mysql_num_rows($result); //LINE NUMBER 23

$i = 0;
if ($number < 1) //10
{
echo "This account doesn't exist, or the password is wrong.";
}
else
{
if ($number > $i)
{
$sqlquery2 = "Update accounts SET loggedin = 0 WHERE name='$login'";
mysql_query("$sqlquery2") or DIE (mysql_error());
echo "The account has been unbugged successfully!";
}
}

?>
<center><h5>Credits to Voldermord<h5></center>

lastly, copy the following into notepad and rename config.php

Code:

   <?php
//Database details

$host['name'] = 'localhost';                // your host
$host['username'] = 'root';       // your database username
$host['password'] = 'yourpasswordhere';   // your database password
$host['databasename'] = 'odinms';       // your database name

$db = mysql_connect($host['name'], $host['username'], $host['password']) OR die ('Cant connect to the database');
mysql_select_db($host['databasename'], $db);
?>

Lastly Put this into another notepad file and save as ".htaccess"
important, must include the ""
This is to enable PHP in HTML pages

Code:

RemoveHandler .html .htm
AddType application/x-httpd-php .php .htm .html

Do those and copy to your PHP enabled webserver, apache mod or Wampserver root folder or whereever ur htdocs/www folder is.
* The .htaccess must be in the same folder as the 3 other files.

Edit
Thanks ddxsamx - pointing out the mistake which would render an error i will definitely get spammed for :D

Edit
The page to change is NOT the fix.php if u try to go there it will juz give u a download link. The page is the .html page where u EMBEDDED the first code at the top below the bolded words.

Or you can just use Navicat and if you have a 2 on your logged in tab. change it to 0 and then it works but i'm not sure if it's permanent :boxed2:

**Xskyline846** · 19-06-08

Grade Work!

**DeathScythee** · 25-06-08

Hey i did all those stuff you said and my website doesn't have that DC id thing.

**voldermord** · 25-06-08

Originally Posted by Xskyline846

what i do worng:

Warning: include(config.php) [function.include]: failed to open stream: No such file or directory in C:\Program Files\Abyss Web Server\htdocs\fix.php on line 4

Warning: include() [function.include]: Failed opening 'config.php' for inclusion (include_path='.;C:\php5\pear') in C:\Program Files\Abyss Web Server\htdocs\fix.php on line 4

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Abyss Web Server\htdocs\fix.php on line 10
You need to be logged off before you can do this!
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\Abyss Web Server\htdocs\fix.php on line 21
This account doesn't exist, or the password is wrong.
Credits to Voldermord

config.php isnt inside ur folder perhaps? permissions set? configuration changed to match yours?

**voldermord** · 25-06-08

Originally Posted by DeathScythee

Hey i did all those stuff you said and my website doesn't have that DC id thing.

go to the page where u embedded the first codes in my post.. eg if u embedded in index.html go to http://localhost/index.html

**lizaraxp** · 05-07-08

Edit: Nvm..

[Tut] How to allow players to fix "ID is already Logged in via Website"

Thread Tools

[Tut] How to allow players to fix "ID is already Logged in via Website"

Re: [GUIDE]How to allow players to fix "ID is already Logged in via Website"

Re: [GUIDE]How to allow players to fix "ID is already Logged in via Website"

Re: [Guide] How to allow players to fix "ID is already Logged in via Website"

Re: [Guide] How to allow players to fix "ID is already Logged in via Website"

Re: [Guide] How to allow players to fix "ID is already Logged in via Website"

Re: [Guide] How to allow players to fix "ID is already Logged in via Website"

Re: [Guide] How to allow players to fix "ID is already Logged in via Website"

Re: [Guide] How to allow players to fix "ID is already Logged in via Website"

Re: [Guide] How to allow players to fix "ID is already Logged in via Website"

Re: [Guide] How to allow players to fix "ID is already Logged in via Website"

Re: [Guide] How to allow players to fix "ID is already Logged in via Website"

Re: [Guide] How to allow players to fix "ID is already Logged in via Website"

Re: [Guide] How to allow players to fix "ID is already Logged in via Website"

Re: [Guide] How to allow players to fix "ID is already Logged in via Website"

Advertisement