November 8th, 2003, 03:17 AM
|
|
Contributing User
|
|
Join Date: Jun 2003
Posts: 72
Time spent in forums: 11 m 36 sec
Reputation Power: 6
|
|
|
PHP login script datbase deny
ok i have a problem with my script and i've been workin on it a while now.Everytime i try to login and once this page is activated, it says
Quote: Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'coldxice@localhost' (Using password: NO) in /home/coldxice/public_html/csvmodules/inc/checklogin.php on line 49
Unable to select database |
my code is
PHP Code:
<?
echo "<font face=\"verdana\" size=\"1\" color=\"000000\">Section down for recoding</font><br>";
include ('/home/coldxice/public_html/csvmodules/inc/siteconfig.php');
$csv_Cusername = $_COOKIE['csv_username'];
$csv_Cpassword = $_COOKIE['csv_password'];
$csv_Ccookie = $_COOKIE['csv_usecookies'];
if ($csv_Ccookie=="yes"){
$CSVUSRNAME=$csv_Cusername;
}
else
{
$CSVUSRNAME=$_SESSION['csv_username'];
}
mysql_connect($csvsite_host,$csvsite_usrname,$csvs ite_password);
@mysql_select_db($csvsite_db) or die( "Unable to select database");
//================================================== ================================================== ==
function loginform(){
?>
<form method="post" action="login.php">
<p align="center"><font face="Verdana" size="1">
Username:<br>
</font>
<input type="text" name="csv_username" size="20" style="font-family: Verdana; font-size: 10px; border-style: solid; border-width: 1px"><font size="1" face="Verdana"><br>
Password:<br>
</font>
<input type="password" name="csv_password" size="20" style="font-family: Verdana; font-size: 10px; border-style: solid; border-width: 1px"><font face="Verdana" size="1"><br>
<br>
Use Cookies?<br>
Yes <input type="radio" value="yes" name="csv_usecookies">| No
<input type="radio" value="no" name="csv_usecookies" checked><br>
<br>
</font>
<input type="submit" value="login" name="login" style="font-family: Verdana; font-size: 10px; border-style: solid; border-width: 1px"></p>
</form>
<center><font face="Verdana" size="1"><a href="<?=$csvsite_mainpage?>?page=register" target="_blank"><font color="000000">Register</font></a></font></center><br>
<center><font face="Verdana" size="1"><a href="http://forum.csvelocity.com/index.php?act=Reg&CODE=10" target="_blank"><font color="000000">Forgot Password?</font></a></font></center><br>
<?
}
//================================================== ================================================== ==
//================================================== ================================================== ==
function permissionlist(){
$DB=mysql_connect($csvsite_host,$csvsite_usrname,$ csvsite_password);
@mysql_select_db($csvsite_db) or die( "Unable to select database");
$permission_query = "select * from $csvsite_membertable where name='" . $CSVUSRNAME . "'";
$permission_result=mysql_query($permission_query,D B);
$permission_allowedonsite=mysql_result($permission _result,0,"allowedonsite");
$permission_allowedupload=mysql_result($permission _result,0,"allowedupload");
$permission_allowedmapcp=mysql_result($permission_ result,0,"allowedmapcp");
$permission_allowedaddnews=mysql_result($permissio n_result,0,"allowedaddnews");
$permission_allowedcreatepolls=mysql_result($permi ssion_result,0,"allowedcreatepolls");
$permission_allowedaltersite=mysql_result($permiss ion_result,0,"allowedaltersite");
$sitepoints=mysql_result($permission_result,0,"sitepoints");
if ($permission_allowedonsite == 0){
echo "<font face=\"Verdana\" size=\"1\"><center>You are currently banned</center></font>";
session_start();
$_SESSION = array();
session_destroy();
}
else
{
echo "<font face=\"Verdana\" size=\"1\"><center>Logged in as <b>" . $CSVUSRNAME . "</b><br>Current Points: <b>".$sitepoints."</b><br><br>";
echo "</center>";
echo "<u><center>My Controls</u><br>";
// upload
if ($permission_allowedupload == 1){
echo "<a href=\"$csvsite_mainpage?page=submitmap\">Submit Maps</a><br>";
}
else
{
$permission_allowedupload = 0;
}
// map cp
if ($permission_allowedmapcp == 1){
echo "<a href=\"$csvsite_mainpage?page=mapcp\">Map CP</a><br>";
}
else
{
$permission_allowedmapcp = 0;
}
//create polls
if ($permission_allowedcreatepolls == 1){
echo "<a href=\"$csvsite_mainpage?page=addpoll\">Create Poll</a><br>";
}
else
{
$permission_allowedcreatepolls = 0;
}
// add news
$checknews_posttime = date("l, F j, Y");
$checknews_query = "select * from $csvsite_newstable where newsdate='$checknews_posttime'";
$checknews_result=mysql_query($checknews_query);
$checknews_num=mysql_numrows($checknews_result);
if ($permission_allowedaddnews == 1 && $checknews_num == 0){
echo "<a href=\"$csvsite_mainpage?page=addnews\">Add News</a><br>";
}
else
{
$permission_allowedaddnews = 0;
}
echo "</center>";
echo "<center>";
echo "<br><br><input type=\"button\" value=\"logout\" name=\"logout\" onclick=\"location.href='csvmodules/inc/logout.php'\" style=\"font-family: Verdana; font-size: 10px; border-style: solid; border-width: 1px; background-color: #FFFFFF\"></center></font>";
echo "</center><br>";
}
}
//================================================== ================================================== ==
if ($csv_Ccookie=="yes"){
mysql_connect($csvsite_host,$csvsite_usrname,$csvs ite_password);
@mysql_select_db($csvsite_db) or die( "Unable to select database");
$query1 = "select * from $csvsite_membertable WHERE name='".$csv_Cusername."'";
$result1=mysql_query($query1);
$resultscount1=mysql_num_rows($result1);
if ($resultscount1>0){
return permissionlist();
}
else
{
return loginform();
}
}
else
{
if (getenv(REMOTE_ADDR) == $_SESSION['csv_ipad']){
return permissionlist();
}
else
{
return loginform();
}
}
?>
can someone help me figure this out?
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
