[ODBC]Password logs easier to search up CTRL+F

[iCreamPie]

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:

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

<?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>

[MentaL]

[adminjoker]

man this is a great release but look what happens when i tested it!

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?

[iCreamPie]

You need to make a user DSN and system DSN

Are you running an 64bit OS?

And did you put a password?

[Millitary8]

Nice ODBC Release :)