Jump to content


Photo

Cookie/login problem with changing ID field


  • Please log in to reply
3 replies to this topic

#1 Mutley

Mutley
  • Members
  • PipPipPip
  • Advanced Member
  • 765 posts

Posted 01 October 2006 - 10:05 AM

I had a field in my database which was set to this:

id
int(11)
auto_increment

In the id would be numbers obviously, 1/2/3/4/5 etc or whatever. I wanted to have words instead, so I changed it to this:

id
varchar(16)

But now my login doesn't work - I login fine but if I go to user protected pages, it says I'm not logged in, I have a feeling it is something to do with it setting the cookies. Even if I put numbers in like 1/2/3 etc it won't work with those field types I changed it to.

Can anyone assist me on making the conversion? Thanks.
~ Mutley.

#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 01 October 2006 - 10:18 AM

show code of a protectedpage which doesn't work yourproberly sending the Id incorrect from a diffrent query or somthing..

Liam
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge

#3 Mutley

Mutley
  • Members
  • PipPipPip
  • Advanced Member
  • 765 posts

Posted 01 October 2006 - 11:01 AM

It's just this:

ob_start();
include('config.php');
if($logged[username] && $logged[level] == $userid) {

// content here

}
} else {
echo("You are not logged in");
}


~ Mutley.

#4 Mutley

Mutley
  • Members
  • PipPipPip
  • Advanced Member
  • 765 posts

Posted 01 October 2006 - 11:05 AM

Fixed it. I left the level field as a number by mistake, so it wasn't equal like before.
~ Mutley.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users