Nukemods Forum - View Single Post

Marty · #10 (**permalink**) 11-05-2006, 11: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);