Advertisement:

Author Topic: Were are web site URLs hidden?  (Read 2774 times)

Offline wakewatcher

  • Jr. Member
  • **
  • Posts: 232
Were are web site URLs hidden?
« on: December 05, 2008, 03:28:12 AM »
hmmmm.  I'm looking to pull the user's web site url (set in the forum profile) and I can't find them in the database anywhere.  Are they encrypted for some reason?
smf 2.0.7

Offline Joey Smith™

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,356
  • Gender: Male
Re: Were are web site URLs hidden?
« Reply #1 on: December 05, 2008, 03:30:49 AM »
Why not look on there profile?

Offline wakewatcher

  • Jr. Member
  • **
  • Posts: 232
Re: Were are web site URLs hidden?
« Reply #2 on: December 05, 2008, 03:45:09 AM »
I don't really care where it is I'm just looking for where it is in the database.  It is set in the member's forum profile.  What I want to know is where it is "stored."
smf 2.0.7

Offline Joey Smith™

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,356
  • Gender: Male
Re: Were are web site URLs hidden?
« Reply #3 on: December 05, 2008, 03:55:35 AM »
I do not think that information would be encrypted. You would have to open a sql backup file in an editor and look for it. Someone else here may be able to tell you just where to look.

Offline wakewatcher

  • Jr. Member
  • **
  • Posts: 232
Re: Were are web site URLs hidden?
« Reply #4 on: December 05, 2008, 04:15:25 AM »
Why would I have to open up an sql backup file?  Why can't I just use mySQLadmin and search for it?  (Which is what I did but couldn't find it.)
smf 2.0.7

Offline Joey Smith™

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,356
  • Gender: Male
Re: Were are web site URLs hidden?
« Reply #5 on: December 05, 2008, 05:20:01 AM »
I never said you couldn't do that.... I just always open a file and read through it..

But then again I have never had a desire to find that info in a database.

Offline wakewatcher

  • Jr. Member
  • **
  • Posts: 232
Re: Were are web site URLs hidden?
« Reply #6 on: December 05, 2008, 05:28:22 AM »
I always look where it is actively being used but that's just me.  Not to worry, I'm sure that someone will set me straight on it.  It can't be hiding too far away.  ;)
smf 2.0.7

Offline swtdivalove

  • Full Member
  • ***
  • Posts: 652
Re: Were are web site URLs hidden?
« Reply #7 on: December 05, 2008, 10:15:09 AM »
Check the '{dbprefix}_members' table.  It is stored there.

Offline wakewatcher

  • Jr. Member
  • **
  • Posts: 232
[solved]Re: Were are web site URLs hidden?
« Reply #8 on: December 05, 2008, 11:41:05 AM »
Bingo!
smf 2.0.7