View Single Post
  #8 (permalink)  
Old 07-09-2003, 12:25 PM
chatserv chatserv is offline
Moderator
 
Join Date: Jan 2003
Posts: 338
Usually a webhost provides phpMyAdmin through a CP, else you can install one yourself, anyway to load the table copy the following into a file, name it something like newtable.php, upload it to where config.php is and point your browser to it.

Code:
<?php

include("mainfile.php");

$db->sql_query("CREATE TABLE ".$prefix."_access (
  access_id int(10) NOT NULL auto_increment,
  access_title varchar(20) default NULL,
  PRIMARY KEY  (access_id),
  KEY access_id (access_id)
) TYPE=MyISAM");

$db->sql_query("INSERT INTO ".$prefix."_access VALUES (-1,'Deleted')");
$db->sql_query("INSERT INTO ".$prefix."_access VALUES (1,'User')");
$db->sql_query("INSERT INTO ".$prefix."_access VALUES (2,'Moderator')");
$db->sql_query("INSERT INTO ".$prefix."_access VALUES (3,'Super Moderator')");
$db->sql_query("INSERT INTO ".$prefix."_access VALUES (4,'Administrator')");

echo "Update finished!

"
    ."You should now delete this file from your server. Go to your <a href=\"index.php\">website</a>.";

?>
Even before trying to load that table try this:

In db/db.php, lines 42-48, is this code:
Code:
if ($forum_admin == 1) { 
    $the_include = "../../../db"; 
} elseif ($inside_mod == 1) { 
    $the_include = "../../db"; 
} else { 
    $the_include = "db"; 
}
chnage to:
Code:
if ($forum_admin == 1) { 
    $the_include = "../../../db"; 
} elseif ($inside_mod == 1) { 
    $the_include = "../../db"; 
} else { 
    $the_include = "/your_web_root/nuke/html/db"; 
}
change "/your_web_root/nuke/html/db" to the actual path for the directory. (workaround by Raven).
Reply With Quote