MySql Help

  • Sk8erGuy
  • Student
  • Student
  • Sk8erGuy
  • Posts: 74

Post 3+ Months Ago

Hello,, i am having a little problem with this sql. The site works and all but we cant get in to edit the template or anything cuz i lost the username and password that worked for the scripts. If you could please edit it so there is an admin username and password or if you could find it it'd really help.

btw, sorry its so long.

Quote:
//Sorry ... I removed that import code. way too long and not necessary -- ATNO/TW
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • this213
  • Guru
  • Guru
  • User avatar
  • Posts: 1260
  • Loc: ./

Post 3+ Months Ago

This is just a table creation script - it has nothing to do with access to your admin area. Looking at this, it doesn't look like the admin passwords are even stored in the DB - unless that table is created separately (or I missed it scrolling through all that). You'll have to poke around your scripts to find it. Trace it back from where it's input at the login screen and find where the script thinks it's supposed to be. If nothing else, change that to where you want it.

hth
This
  • Sk8erGuy
  • Student
  • Student
  • Sk8erGuy
  • Posts: 74

Post 3+ Months Ago

i was talking to the guy that helped me out last time and he said i needed to make the admin user and pass in this or w/e. i tried to take it from my other sql file from other set of scripts that made the admin account but it didnt work. ill try that thing from the login/ thank you.
  • Sk8erGuy
  • Student
  • Student
  • Sk8erGuy
  • Posts: 74

Post 3+ Months Ago

ok, i found this in functions.php.

Code: [ Select ]
// This Function authenticates to make sure that the user has entered a valid

// username and password, and then grabs the user's info

function authenticate($user, $pass, $minRank)


{

    global $fontString;

    global $myrow;

    global $recruit;

    $result = @mysql_query("SELECT * FROM members WHERE username = '$user'");

    $myrow = mysql_fetch_array($result);

    if($myrow != NULL)

    {

        extract($myrow);

    }

    // If the username matches the result in the mysql query and the password is correct

    // return the rank of the user.

    if($user == $username && $pass == $password and $username != NULL)
  1. // This Function authenticates to make sure that the user has entered a valid
  2. // username and password, and then grabs the user's info
  3. function authenticate($user, $pass, $minRank)
  4. {
  5.     global $fontString;
  6.     global $myrow;
  7.     global $recruit;
  8.     $result = @mysql_query("SELECT * FROM members WHERE username = '$user'");
  9.     $myrow = mysql_fetch_array($result);
  10.     if($myrow != NULL)
  11.     {
  12.         extract($myrow);
  13.     }
  14.     // If the username matches the result in the mysql query and the password is correct
  15.     // return the rank of the user.
  16.     if($user == $username && $pass == $password and $username != NULL)


so i need to insert the account ito the sql but i dont know how to do that.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

Just curious...what program is this?
  • this213
  • Guru
  • Guru
  • User avatar
  • Posts: 1260
  • Loc: ./

Post 3+ Months Ago

Actually, that's probably not what you're looking for either. That queries the DB to see if the user is a user, not to see if the user is an administrator - unless your administrator is seen by the program as just another rank of user - usually a bad idea as far as authentication goes.

-- I'm curious as to what program this is too. Or is it homemade?
  • Sk8erGuy
  • Student
  • Student
  • Sk8erGuy
  • Posts: 74

Post 3+ Months Ago

tehy are clan scripts. we have basic ones so im trying to upgrade to these. thx for the help, ill keep looking.

Post Information

  • Total Posts in this topic: 7 posts
  • Users browsing this forum: No registered users and 108 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.