Originalmente inviato da
jostock
rimetti il db original
ho provato ma non esegue le istruz!
dice che le tabelle c sono già!
Codice:
Errore
query SQL:
# ========================================================
#
# Database saved : my_lultimozarro
# On 09-28-2005 at 00:46 by !
#
# ========================================================
# --------------------------------------------------------
#
# Table structure for table 'nuke_authors'
#
CREATE TABLE nuke_authors(
aid varchar( 25 ) NOT NULL ,
name varchar( 50 ) ,
url varchar( 255 ) NOT NULL ,
email varchar( 255 ) NOT NULL ,
pwd varchar( 40 ) ,
counter int( 11 ) DEFAULT '0' NOT NULL ,
radminsuper tinyint( 1 ) DEFAULT '1' NOT NULL ,
admlanguage varchar( 30 ) NOT NULL ,
PRIMARY KEY ( aid ) ,
KEY aid( aid )
)
Messaggio di MySQL: Documentazione
#1050 - Table 'nuke_authors' already exists
ora all' index.php visualizzo solo "you can't access this file directly"
e da admin visualizzo tutto sballato e al posto dei moduli visualizzo questo codice
Codice:
x."_modules WHERE active='1' AND inmenu='0' ORDER BY title ASC"); while ($row5 = $db->sql_fetchrow($result5)) { $mn_title = stripslashes($row5['title']); $custom_title = $row5['custom_title']; $mn_title2 = ereg_replace("_", " ", $mn_title); if ($custom_title != "") { $mn_title2 = $custom_title; } if ($mn_title2 != "") { $content .= "· $mn_title2
\n"; $dummy = 1; } else { $a = 1; } } if ($a == 1 AND $dummy != 1) { $content .= "· "._NONE."
\n"; } $content .= "
"._NOACTIVEMODULES."
"; $content .= ""._FORADMINTESTS."
"; $result6 = $db->sql_query("SELECT title, custom_title FROM ".$prefix."_modules WHERE active='0' ORDER BY title ASC"); while ($row6 = $db->sql_fetchrow($result6)) { $mn_title = stripslashes($row6['title']); $custom_title = $row6['custom_title']; $mn_title2 = ereg_replace("_", " ", $mn_title); if ($custom_title != "") { $mn_title2 = $custom_title; } if ($mn_title2 != "") { $content .= "· $mn_title2
\n"; $dummy = 1; } else { $a = 1; } } if ($a == 1 AND $dummy != 1) { $content .= "· "._NONE."
\n"; } } ?>_module = $default_module; } else { $def_module = ""; } } $row = $db->sql_fetchrow($db->sql_query("SELECT main_module FROM ".$prefix."_main")); $main_module = $row['main_module']; /* If the module doesn't exist, it will be removed from the database automaticaly */ $result2 = $db->sql_query("SELECT title FROM " . $prefix . "_modules"); while ($row2 = $db->sql_fetchrow($result2)) { $title = stripslashes($row2['title']); $a = 0; $handle=opendir('modules'); while ($file = readdir($handle)) { if ($file == $title) { $a = 1; } } closedir($handle); if ($a == 0) { $db->sql_query("DELETE FROM ".$prefix."_modules WHERE title='$title'"); } } /* Now we make the Modules block with the correspondent links */ $content .= "· "._HOME."
\n"; $result3 = $db->sql_query("SELECT title, custom_title, view FROM " . $prefix . "_modules WHERE active='1' AND title!='$def_module' AND inmenu='1' ORDER BY custom_title ASC"); while ($row3 = $db->sql_fetchrow($result3)) { $m_title = stripslashes($row3['title']); $custom_title = $row3['custom_title']; $view = intval($row3['view']); $m_title2 = ereg_replace("_", " ", $m_title); if ($custom_title != "") { $m_title2 = $custom_title; } if ($m_title != $main_module) { if ((is_admin($admin) AND $view == 2) OR $view != 2) { $content .= "· $m_title2
\n"; } } } /* If you're Admin you and only you can see Inactive modules and test it */ /* If you copied a new module is the /modules/ directory, it will be added to the database */ if (is_admin($admin)) { $handle=opendir('modules'); while ($file = readdir($handle)) { if ( (!ereg("[.]",$file)) ) { $modlist .= "$file "; } } closedir($handle); $modlist = explode(" ", $modlist); sort($modlist); for ($i=0; $i < sizeof($modlist); $i++) { if($modlist[$i] != "") { $row4 = $db->sql_fetchrow($db->sql_query("SELECT mid FROM ".$prefix."_modules WHERE title='$modlist[$i]'")); $mid = intval($row4['mid']); $mod_uname = ereg_replace("_", " ", $modlist[$i]); if ($mid == "") { $db->sql_query("INSERT INTO ".$prefix."_modules VALUES (NULL, '$modlist[$i]', '$mod_uname', '0', '0', '1', '0')"); } } } $content .= "
"._INVISIBLEMODULES."
"; $content .= ""._ACTIVEBUTNOTSEE."
"; $result5 = $db->sql_query("SELECT title, custom_title FROM ".$prefÿÿÿÿ