About this Page
This is a discussion on Getting God admin back within the Nuke 7.x - General forums, part of the PHP-Nuke 7.x category; Hello How would I go about getting the God admin link back and resetting that!I now it is easy ...

pink · #1 (**permalink**) 07-07-2006, 04:00 PM

Hello

How would I go about getting the God admin link back and resetting that!I now it is easy I jsut am having a mental day :[ you know how it goes .I once forgot how to tie my shoes too

ops:

ops:

The re son I ask is I do free gaming phpnuke installs ! I just got all the regular blocks that most gamin clans use! But I am tired of adding these all the time over and over! So I thought I do Is Reset the god admin make my back up of the sql , So then when I do a new site all I have to do is use that sql and phpnuke folders files I have and boom Babbie it all done for me!

Well any help thank you ! Also I am almost done with a few phpnuke themes I have coded how dose one add their work to the downloads !

thank you

Marty · #2 (**permalink**) 11-03-2006, 11:44 AM

I know iam late with this but for others.....

To reset your admin.php access run the following sql text, then obviously goto *http://your_site.com/admin.php asap and set yourself up, but this time DONT create a user account aswell.

Code:

DROP TABLE IF EXISTS `nuke_authors`;
CREATE TABLE `nuke_authors` (
  `aid` varchar(25) NOT NULL default '',
  `name` varchar(50) default NULL,
  `url` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `pwd` varchar(40) default NULL,
  `counter` int(11) NOT NULL default '0',
  `radminsuper` tinyint(1) NOT NULL default '1',
  `admlanguage` varchar(30) NOT NULL default '',
  `radminblocker` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`aid`),
  KEY `aid` (`aid`)
);

PvtRyan · #3 (**permalink**) 11-04-2006, 08:51 PM

Originally Posted by Marty

I know iam late with this but for others.....

To reset your admin.php access run the following sql text, then obviously goto *http://your_site.com/admin.php asap and set yourself up, but this time DONT create a user account aswell.

Code:

DROP TABLE IF EXISTS `nuke_authors`;
CREATE TABLE `nuke_authors` (
  `aid` varchar(25) NOT NULL default '',
  `name` varchar(50) default NULL,
  `url` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `pwd` varchar(40) default NULL,
  `counter` int(11) NOT NULL default '0',
  `radminsuper` tinyint(1) NOT NULL default '1',
  `admlanguage` varchar(30) NOT NULL default '',
  `radminblocker` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`aid`),
  KEY `aid` (`aid`)
);

I did this, but when I go to my admin login page and create a new account without making a normal one, then try to login, it sends me back to the create a Super User account page.

Marty · #4 (**permalink**) 11-05-2006, 06:00 AM

This is the _NOADMINYET message whose translation you can find in the various language files in the language folder. It occurs in admin.php:

Code:

$the_first = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_authors"));
if ($the_first == 0) {
    if (!$name) {
    include("header.php");
    title("$sitename: "._ADMINISTRATION."");
    OpenTable();
    echo "<center>"._NOADMINYET."</center>

"

From the code we see that it is echoed only if $the_first is 0, meaning no entries in the $prefix_authors table.

Thus, for some reason, the nuke_authors table (assuming your $prefix is "nuke" in config.php), is not filled. Could you check the entries in nuke_authors? You can do this either from the MySQL prompt with

Code:

select aid, name, email, pwd from nuke_authors;

or with the "browse" function of phpMyAdmin.

If your Super Admin is there, then it is weird...

If the Super Admin is not there, then you can't write to the database. To check this possibility, find the function create_first() in admin.php. There, you will see two lines with a call to sql_query. They are both identical:

Code:

$db->sql_query($sql);

Insert the line:

Code:

echo mysql_error();

after each one. This will echo a more descriptive error message and may lead you to the solution. But, as experience shows, you most probably have set the wrong values in your config.php

PvtRyan · #5 (**permalink**) 11-05-2006, 09:41 AM

Originally Posted by Marty

This is the _NOADMINYET message whose translation you can find in the various language files in the language folder. It occurs in admin.php:

Code:

$the_first = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_authors"));
if ($the_first == 0) {
    if (!$name) {
    include("header.php");
    title("$sitename: "._ADMINISTRATION."");
    OpenTable();
    echo "<center>"._NOADMINYET."</center>

"

From the code we see that it is echoed only if $the_first is 0, meaning no entries in the $prefix_authors table.

Thus, for some reason, the nuke_authors table (assuming your $prefix is "nuke" in config.php), is not filled. Could you check the entries in nuke_authors? You can do this either from the MySQL prompt with

Code:

select aid, name, email, pwd from nuke_authors;

or with the "browse" function of phpMyAdmin.

If your Super Admin is there, then it is weird...

If the Super Admin is not there, then you can't write to the database. To check this possibility, find the function create_first() in admin.php. There, you will see two lines with a call to sql_query. They are both identical:

Code:

$db->sql_query($sql);

Insert the line:

Code:

echo mysql_error();

after each one. This will echo a more descriptive error message and may lead you to the solution. But, as experience shows, you most probably have set the wrong values in your config.php

What are you saying I should check for in the config.php file?

Marty · #6 (**permalink**) 11-05-2006, 09:46 AM

Are there any entries in nuke_authors database table ?

Open your database and browse the nuke_authors

BTW are you using any symbols or spaces when your setting up an Administrator ?

PvtRyan · #7 (**permalink**) 11-05-2006, 09:50 AM

Originally Posted by Marty

Are there any entries in nuke_authors database table ?

Open your database and browse the nuke_authors

BTW are you using any symbols or spaces when your setting up an Administrator ?

There are various fields but I'm not very familiar with MySQL and phpMyAdmin so I'm not quite sure. However, I believe there aren't any entries

The way I lost my admin is a tried to add the ^ character to my login username and then I couldn't login. When I tried to create a new accout I used 6 letters and no other characters. But, it didn't redirect me to the admin page after trying to login with the correct credentials.

Marty · #8 (**permalink**) 11-05-2006, 10:02 AM

do you know how to get to the database ?

To be honest the quickest way would be to manually enter a username and password into that.

Is there anything eles you might have done like before you had a problem with the languages thats probable it the variable is missing ?

PvtRyan · #9 (**permalink**) 11-05-2006, 10:08 AM

Originally Posted by Marty

do you know how to get to the database ?

To be honest the quickest way would be to manually enter a username and password into that.

Is there anything eles you might have done like before you had a problem with the languages thats probable it the variable is missing ?

Yes, I know how to get to the database. However, in phpMyAdmin I cannot click the "browse" button at the top. How do I enter my username and password into that?

Marty · #10 (**permalink**) 11-05-2006, 10:40 AM

Originally Posted by PvtRyan

Originally Posted by Marty

do you know how to get to the database ?

To be honest the quickest way would be to manually enter a username and password into that.

Is there anything eles you might have done like before you had a problem with the languages thats probable it the variable is missing ?

Yes, I know how to get to the database. However, in phpMyAdmin I cannot click the "browse" button at the top. How do I enter my username and password into that?

When you open your database theres usually (99%) a list of all the tables within, on the left-hand side of the page, click the image beside nuke_authors that should open a new window if theres any listings there you can edit those, by clocking the pencil image.

Or if you have all the tables open in the main screen you will see by the records if there are any entries, either 0 or 1,2,3,4 whatever...

Try running this sql, I have pm'd you the password, if that works, you can edit yourself from the admin panel, under Edit Admins section.

Code:

DROP TABLE IF EXISTS nuke_authors;
CREATE TABLE nuke_authors (
  aid varchar(25) NOT NULL default '',
  name varchar(50) default NULL,
  url varchar(255) NOT NULL default '',
  email varchar(255) NOT NULL default '',
  pwd varchar(40) default NULL,
  counter int(11) NOT NULL default '0',
  radminsuper tinyint(1) NOT NULL default '1',
  admlanguage varchar(30) NOT NULL default '',
  radminblocker tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (aid),
  KEY aid (aid)
) TYPE=MyISAM;

-- 
-- Dumping data for table `nuke_authors`
-- 

INSERT INTO nuke_authors VALUES ('PvtRyan', 'God', 'http://AHSUSF.com/Home/index.php', 'admin@AHSUSF.com', '51974490e30490deb2ae0b94fccb193c', 5, 1, '', 0);

About this PageThis is a discussion on Getting God admin back within the Nuke 7.x - General forums, part of the PHP-Nuke 7.x category; Hello How would I go about getting the God admin link back and resetting that!I now it is easy ...

Getting God admin back

About this Page
This is a discussion on Getting God admin back within the Nuke 7.x - General forums, part of the PHP-Nuke 7.x category; Hello How would I go about getting the God admin link back and resetting that!I now it is easy ...