Adding Admins

Posted: Thu Nov 13, 2003 10:34 am

I think this thread was discussed at Nuke Cops but it's taking forever to find anything over there this morning...

I get a blank white page when I submit new Admins to the authors table. So, I use phpmyadmin and put the data in manually, then everything works ok. phpnuke ver 6.9 with Ravens fixes.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

That's usually an indication that the nuke_authors table has been modified by an addon and the admin.php script has not, or visa-versa. Here is the standard v6.9 schema for nuke_authors

Code:

  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',


  radminarticle tinyint(2) NOT NULL default '0',


  radmintopic tinyint(2) NOT NULL default '0',


  radminuser tinyint(2) NOT NULL default '0',


  radminsurvey tinyint(2) NOT NULL default '0',


  radminsection tinyint(2) NOT NULL default '0',


  radminlink tinyint(2) NOT NULL default '0',


  radminephem tinyint(2) NOT NULL default '0',


  radminfaq tinyint(2) NOT NULL default '0',


  radmindownload tinyint(2) NOT NULL default '0',


  radminreviews tinyint(2) NOT NULL default '0',


  radminnewsletter tinyint(2) NOT NULL default '0',


  radminforum tinyint(2) NOT NULL default '0',


  radmincontent tinyint(2) NOT NULL default '0',


  radminency tinyint(2) NOT NULL default '0',


  radminsuper tinyint(2) NOT NULL default '1',


  admlanguage varchar(30) NOT NULL default ''

Do you have any extra radmin* columns? If so, then whatever mod they represent would be a suspect Wink

Posted: Thu Nov 13, 2003 8:07 pm

Quote:

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',
`radminarticle` tinyint(2) NOT NULL default '0',
`radmintopic` tinyint(2) NOT NULL default '0',
`radminuser` tinyint(2) NOT NULL default '0',
`radminsurvey` tinyint(2) NOT NULL default '0',
`radminsection` tinyint(2) NOT NULL default '0',
`radminlink` tinyint(2) NOT NULL default '0',
`radminephem` tinyint(2) NOT NULL default '0',
`radminfaq` tinyint(2) NOT NULL default '0',
`radmindownload` tinyint(2) NOT NULL default '0',
`radminreviews` tinyint(2) NOT NULL default '0',
`radminnewsletter` tinyint(2) NOT NULL default '0',
`radminforum` tinyint(2) NOT NULL default '0',
`radmincontent` tinyint(2) NOT NULL default '0',
`radminency` tinyint(2) NOT NULL default '0',
`radminCalendarAdmin` tinyint(2) NOT NULL default '0',
`radmingroup` tinyint(2) NOT NULL default '0',
`radminsuper` tinyint(2) NOT NULL default '1',
`admlanguage` varchar(30) NOT NULL default '',
`radminblocker` tinyint(2) NOT NULL default '0',

yeppers.. of course, it's the mods. So I have to fix the add admin function in which file?

Posted: Thu Nov 13, 2003 8:30 pm

My guess is that calendar and blocker aren't playing well together. See this post I wrote at NC for some information on calendar 2.11, but the principle still applieshttp://nukecops.com/postlite3544-calender+calendar.html

Normally it's the admin.php and/or admin/modules/authors.php

Posted: Fri Nov 14, 2003 1:21 pm

yes... NOW I remember doing the mods to get calendar and groups to work together... it's those $selx variables in the admin/authors.php modifyadmin(). (And might be somewhere else too.) There are four major groups of them to muck with in that file alone. I must have had a brain dump between then and now. Now I'll do it again and add the blocker.

Sheesh... how stressful is that? Is Holbrooke right? What would it take to make this adding modules process a tad easier? Question