[ODBC]Password logs easier to search up CTRL+F
This shows userid, last connected, password, last connected ip, the registerip won't work for you because i used lloyd register script and it logged the ip adress at RegisterIP so you can just ignore it or delete it.
Connection:
Code:
Code:
<?php
//Database Connection
$dns="GunzDB";
$user="sa";
$pass="password";
$connect=odbc_connect($dns, $user, $pass) or die ("Couldn't connect to the database, we're sorry...");
odbc_exec($connect,"use GunzDB");
?>
Code:
<?php
include ('config.php');
?>
<?php
//get latest clan fight
$query = odbc_exec($connect, "SELECT TOP 1000* FROM Login ORDER BY RegisterIP DESC");
odbc_fetch_row($query);
$name = odbc_result($query, "UserID");
$point = odbc_result($query, "Password");
$wins = odbc_result($query, "LastConnDate");
$losses = odbc_result($query, "RegisterIP");
$draws = odbc_result($query, "LastIP");
?>
<table width="1152" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="105"><b>#</b></td>
<td width="213"><b>UserID</b></td>
<td width="143"><b>Password</b></td>
<td width="234"><b>Last connected</b></td>
<td width="159"><b>Registered IP</b></td>
<td width="298"><b>Last connected IP</b></td>
</tr>
<?php
$rank2 = 0;
while($rij3 = odbc_fetch_object($query))
{
$rank2 = $rank2 + 1;
{
}
?>
<tr>
<td><?php echo $rank2; ?></td>
<td><?php echo $rij3->UserID; ?></td>
<td><?php echo $rij3->Password; ?></td>
<td><?php echo $rij3->LastConnDate; ?></td>
<td><?php echo $rij3->RegisterIP; ?></td>
<td><?php echo $rij3->LastIP; ?></td>
</tr>
<?php
}
?>
</table>
Re: [ODBC]Password logs easier to search up CTRL+F
man this is a great release but look what happens when i tested it!
Quote:
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\AppServ\www\scripts\config.php on line 6
Couldn't connect to the database, we're sorry...
How can we fix this?
Re: [ODBC]Password logs easier to search up CTRL+F
You need to make a user DSN and system DSN
Are you running an 64bit OS?
And did you put a password?
Re: [ODBC]Password logs easier to search up CTRL+F
