phpspell 1.06

New Member Joined: Mar 07, 2005 Posts: 19

Hi sorry, but I'm having issues getting phpspell installed. I've tried everything to figure out he problem...and yes I've searched the forum and tried the solutions that I found. Unfortunately I'm still stuck.

I'm getting:

Code:

Unable to locate the RavenNuke(tm) configuration file - rnconfig.php





It could be missing or not readable. Please verify that the file exists and is readable in the root folder.

I've seen a couple of solutions to this error, and I've tried several, but I'm stuck.

Download link to the script: Only registered users can see links on this board! Get registered or login!

Does anyone have any experience integrating this spell check with RavenNuke? I've seen a few sites using it.

Thanks

registered · Posted: Mon Apr 13, 2009 2:16 pm

try adding

Code:

define('INCLUDE_PATH');

towards the top of spell_phpbb.php after the <?php tag and see if it works.

Posted: Tue Apr 14, 2009 6:11 am

Ok, added as suggested and I get this:

Code:




Warning: define() expects at least 2 parameters, 1 given in /public_html/modules/Forums/spelling/spell_phpbb.php on line 2


Unable to locate the RavenNuke(tm) configuration file - INCLUDE_PATHrnconfig.php





It could be missing or not readable. Please verify that the file exists and is readable in the root folder.

Here's the file code:

Code:

<?php


define('INCLUDE_PATH');


  // --------------------------------------------------------------------


  // phpSpell 1.06 (beta) PHPBB & Nuke Specific code


  //


  // This is (c)Copyright 2003, Team phpSpell.


  // --------------------------------------------------------------------





  if (!defined('PHPSPELL_CONFIG')) exit;


  define('IN_PHPBB', true);


  $Spell_Config['DB_MODULE'] = 'PHPBB v2.0';





  $phpbb_root_path = $Spell_Config['PHPBB_ROOT_PATH'];


  include ($phpbb_root_path.'extension.inc');





  $PathPrefix = '';





  // --------------------------------------------


  // Setup to use under NUKE


  // --------------------------------------------


  if ($Spell_Config['DB_Type'] == 'PHPNuke') {


    $Spell_Config['PHPBB_NUKE'] = true;


    $forum_admin = 1;


    $PathPrefix = '../../';


    $Spell_Config['DB_MODULE'] .= ' - w/ Nuke Support';


  } else {


    $Spell_Config['PHPBB_NUKE'] = false;


  }





  // General Configuration Include File


  include ($phpbb_root_path.$PathPrefix.'config.'.$phpEx);


  // ---------------------------------





  if (defined('IN_SPELL_ADMIN') && !$Spell_Config['PHPBB_NUKE']) {





    // PHPNuke 6.5 removes the "db.php" from the common file.


    if ($Spell_Config['PHPBB_NUKE']) {


      define('PHPBB_INSTALLED', true);


      include_once($phpbb_root_path.$PathPrefix.'db/db.php');


    // include($phpbb_root_path.$PathPrefix.'mainfile.php');


    }


    include($phpbb_root_path . 'common.'.$phpEx);





    if ($Spell_Config['PHPBB_NUKE']) {


      $user = PHPNuke_User_Check();


      $userdata = session_pagestart($user_ip, PAGE_INDEX, $user);


    } else {


      $userdata = session_pagestart($user_ip, PAGE_INDEX);


    }


    init_userprefs($userdata);





    if( !$userdata['session_logged_in'] )


    {


      $header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';


      header($header_location . '../' . append_sid('login.'.$phpEx.'?redirect=spelling/spell_admin.'.$phpEx));


      exit;


    }


    else if( $userdata['user_level'] != ADMIN )


    {


        message_die(GENERAL_MESSAGE, $lang['Not_admin']);


    }


  } else {


    if ($Spell_Config['PHPBB_NUKE'] == true) {


      include ($phpbb_root_path.$PathPrefix.'db/db.php');


    } else {


      include ($phpbb_root_path.'includes/db.'.$phpEx);


    }


    define('CRITICAL_ERROR', 1);


    define('BEGIN_TRANSACTION', 1);


    define('END_TRANSACTION', 2);


    function message_die($Error, $Message) {


     die($Message);


    }


  }





  // Activate Spelling Support for the Database


//  $Spelling_DB = new SPELL_DB($db);





  // Required for Nuke


  if ($Spell_Config['PHPBB_NUKE'] == true) {


    $table_prefix = @$user_prefix . '_';


    $dbms = strtolower($dbtype);


  }





  if ($Spell_Config['PHPBB_Load_Smilies']) Create_PHPBB_Smiles();








  function Create_PHPBB_Smiles()


  {


    global $Spell_Config;


    global $db, $table_prefix, $dbms;





    // Php Nuke Specific code.


    $nuke_prefix = '';


    if ($Spell_Config['PHPBB_NUKE'] == true) $nuke_prefix = 'bb';





    if ($dbms == 'mssql' || $dbms == 'mssql-odbc') {


      $Query = 'SELECT code FROM'.$table_prefix.$nuke_prefix.'smilies ORDER BY {fn LENGTH(code)} desc';


    } else {


      $Query = 'SELECT code FROM '.$table_prefix.$nuke_prefix.'smilies ORDER BY length(code) desc';


    }


    if( !($Query_Result = $db->sql_query($Query)) ) {





       if (defined('IN_SPELL_DIAGS') || defined('IN_SPELL_ADMIN')) {


         echo '<br><Br><center><b>Error opening smilies table.</b></center><br>';


       } else {


         message_die(CRITICAL_ERROR,'Unable to perform spell check at this time.<br>');


         exit;


       }


    }





    $Count = $db->sql_numrows($Query_Result);


    for ($i=0;$i<$Count;$i++) {


      $Fetched_Array = $db->sql_fetchrow($Query_Result);


      $Spell_Config['Symbol_Tags'][] = $Fetched_Array['code'];


    }


  }





  function PHPNuke_User_Check()


  {


    global $cookie, $nukeuser, $db;


    $user = base64_decode($user);


    $cookie = explode(':', $user);


    $sql = 'SELECT uid, pass FROM ' . USERS_TABLE . 'WHERE uname=\'$cookie[1]\'';


    $result = $db->sql_query($sql);


    if(!$result) {


      message_die(GENERAL_ERROR, 'Could not query user account', '', __LINE__, __FILE__, $sql);


    }


    $row = $db->sql_fetchrow($result);


    if ($cookie[2] == $row['pass'] && $row['pass'] != '') {


       return ($user);


    } else {


      unset($user);


      unset($cookie);


      message_die(GENERAL_MESSAGE, 'You are not authorised to administer this board');


    }


    return ('');


  }














  // --------------------------------------------


  // Checks for a Good Word in the Database


  // --------------------------------------------


  function DB_Check_Word($Word_To_Check)


  {


     global $db, $dbms, $DB_TableName;





     if ($dbms == 'mysql' || $dbms == 'mysql4') {


       $word_to_seek = addslashes($Word_To_Check);


     } else {


       $word_to_seek = str_replace('\'', '\'\'', $Word_To_Check);


     }


     $Query = 'SELECT * FROM '.$DB_TableName.' WHERE word=\''.$word_to_seek.'\'';


     $Query_Result = $db->sql_query($Query, $db->db_connect_id);


     if( !$Query_Result ) {


       message_die(CRITICAL_ERROR,'Unable to perform spell check at this time.<br>');


     }


//     echo DB_Error_Message($Query_Result);





     $Count = $db->sql_numrows($Query_Result);


//     echo "<br>$Count<br>";


     if ($Count > 0) return (true);


     return (false);


  }








  // --------------------------------------------


  // Get the Suggestions from the Database


  // --------------------------------------------


  function DB_Get_Suggestions($Word_Sound, $Word_To_Check)


  {


    global $db, $DB_TableName, $dbms;


    $Suggestions = array();


    $Query = 'SELECT word FROM '. $DB_TableName.' WHERE sound=\''.$Word_Sound.'\'';


    if( !($Query_Result = $db->sql_query($Query)) ) {


       message_die(CRITICAL_ERROR,'Unable to perform spell check at this time.<br>');


    }


    $Count = $db->sql_numrows($Query_Result);


    for ($i=0;$i<$Count;$i++) {


      $Fetched_Array = $db->sql_fetchrow($Query_Result);


//      echo DB_Error_Message($Query_Result);


      if ($dbms == 'mysql' || $dbms == 'mysql4') {


        $Suggestions[$i] = stripslashes(trim(strtolower($Fetched_Array['word'])));


      } else {


        $Suggestions[$i] = str_replace('\'\'', '\'', trim(strtolower($Fetched_Array['word'])));


      }


    }


    return ($Suggestions);


  }





  // --------------------------------------------


  // Get the OFF BY ONE suggestions (if active)


  // --------------------------------------------


  function DB_Get_OBO_Suggestions($Word_To_Check)


  {


    global $db, $dbms, $DB_TableName;


    $Suggestions = array();





    $Query_Words_Length = strlen($Word_To_Check);


    $Query_Words = '"_'.substr($Word_To_Check, 1).'"';


    for ($i=1;$i<$Query_Words_Length;$i++) {


      $Query_Words .= ' OR word LIKE "'.substr($Word_To_Check, 0, $i).'_'.substr($Word_To_Check, $i+1).'"';


    }





    if ($dbms == 'mysql' || $dbms == 'mysql4') {


      $Query_Words = str_replace('\'', "\\'", $Query_Words);


    } else {


      $Query_Words = str_replace('\'', '\'\'', $Query_Words);


    }





    $Query = 'SELECT word FROM '. $DB_TableName.' WHERE word LIKE '.$Query_Words;


    if( !($Query_Result = $db->sql_query($Query)) ) {


       message_die(CRITICAL_ERROR,'Unable to perform spell check at this time.<br>');


    }


    $Count = $db->sql_numrows($Query_Result);


    for ($i=0;$i<$Count;$i++) {


      $Fetched_Array = $db->sql_fetchrow($Query_Result);


      if ($dbms == 'mysql' || $dbms == 'mysql4') {


        $Suggestions[$i] = stripslashes(trim(strtolower($Fetched_Array['word'])));


      } else {


        $Suggestions[$i] = str_replace('\'\'', '\'', trim(strtolower($Fetched_Array['word'])));


      }


    }


    return ($Suggestions);


  }








  // -----------------------------------------------


  // This function is used by the Diagnostic Routine


  // Returns the number of words in the Database


  // -----------------------------------------------


  function DB_Get_Word_Count()


  {


    global $DB_TableName, $db;


    $Query = 'SELECT COUNT(*) FROM '.$DB_TableName;





    $Query_Result = $db->sql_query($Query, $db->db_connect_id);


    if(!$Query_Result) {


       return(DB_Error_Message($Query_Result));


    }





    if ($db->sql_numrows($Query_Result) == 0) return ('0');





    $code = $db->sql_fetchrow($Query_Result);


    return ($code[0]);


  }








  // -----------------------------------------------


  // This function is used by the Diagnostic Routine


  // And by the Admin Module


  // Returns a detailed error message


  // -----------------------------------------------


  function DB_Error_Message($Query_Result, $Ignore_Table_Create_Error=false)


  {


    global $db, $dbms;


    $result = $db->sql_error();


    if (!isset($result['code'])) $result['code'] = 'N/A';





    if ($result['code'] == '1050' && $Ignore_Table_Create_Error) return (-1);


    $Info = 'Code: '.$result['code'].'<br>Message: '.$result['message'];


    $Info .= '<br>Result: '.$Query_Result.'  Link: '.$db->db_connect_id.'<br>';


    $Info .= 'DB: '.$db->dbname.' User: '.$db->user.' Server: '.$db->server;


    return ($Info);


  }








  // -----------------------------------------------


  // This function is used by the Admin Module


  // Adds a word to the table


  // -----------------------------------------------


  function DB_Add_Word($Word_To_Add, $Word_Sound)


  {


    global $dbms, $db, $DB_TableName;


    if ($dbms == 'mysql' || $dbms == 'mysql4') {


      $Word_To_Add = addslashes($Word_To_Add);


    } else {


      $Word_To_Add = str_replace('\'', '\'\'', $Word_To_Add);


    }


    $Query = 'INSERT INTO '.$DB_TableName.'(word, sound) VALUES (\''.$Word_To_Add.'\', \''.$Word_Sound.'\')';


    $QResult = $db->sql_query($Query);


//    echo DB_Error_Message($QResult);


  }





  // -----------------------------------------------


  // This function is used by the Admin Module


  // Create the Table


  // -----------------------------------------------


  function DB_Create_Table()


  {


    global $dbms, $db, $DB_TableName;


    switch ($dbms)


    {


      case 'mysql':


      case 'mysql4':


        $Query[0] = 'CREATE TABLE '.$DB_TableName.' (id MEDIUMINT AUTO_INCREMENT NOT NULL, word VARCHAR (30) BINARY NOT NULL, sound VARCHAR(10) not NULL, PRIMARY KEY(id), INDEX(sound), UNIQUE(word))';


        break;


      case 'mssql-odbc':


      case 'mssql':


        $Query[0] = 'CREATE TABLE ['.$DB_TableName.'] ([id] [int] primary key identity (1,1) NOT NULL , [word] [varchar] (30) NOT NULL, [sound] [varchar] (10) NOT NULL) ON [PRIMARY]';


//        $Query[0] = 'CREATE TABLE ['.$DB_TableName.'] ([id] [int] NOT NULL , [word] [varchar] (30) NOT NULL, [sound] [varchar] (10) NOT NULL) ON [PRIMARY]';


        $Query[1] = 'CREATE INDEX [IX_'.$DB_TableName.'_WORD] on ['.$DB_TableName.'](word) ON [PRIMARY]';


        $Query[2] = 'CREATE INDEX [IX_'.$DB_TableName.'_SOUND] on ['.$DB_TableName.'](sound) ON [PRIMARY]';


        break;


      default:


        message_die(CRITICAL_ERROR,'No valid SQL to create your database type.');


    }


    for ($i=0;$i<count($Query);$i++) {


      $result = $db->sql_query($Query[$i]);


      if (!$result) {


        $Info = DB_Error_Message($result);


        if ($Info != '1050') echo 'Unable to create dictionary database table: '.$Info;


      }


    }


  }





  // -----------------------------------------------


  // This function is used by the Admin Module


  // Deletes the Table


  // -----------------------------------------------


  function DB_Drop_Table()


  {


    global $db, $DB_TableName;


    $Query = 'DROP TABLE '.$DB_TableName;


    $db->sql_query($Query);


  }








?>

Posted: Tue Apr 14, 2009 7:49 am

Sorry, Try

Code:

define('INCLUDE_PATH', '');

Posted: Tue Apr 14, 2009 4:13 pm

This script just doesn't like me. I'm back to:

Code:




Unable to locate the RavenNuke(tm) configuration file - rnconfig.php





It could be missing or not readable. Please verify that the file exists and is readable in the root folder.

Posted: Sat Apr 18, 2009 7:46 am

Thanks for the help Nuken. Anyone else have any ideas or know of another spell check script for nuke?

Posted: Sat Apr 18, 2009 8:12 am

this may not be 100% correct way of going about it, but have had some success using this at times... it may depend on the location of the script having the problem...
if the script is in root/modules/Forums you could try

Code:

define('INCLUDE_PATH', '../../');

or if the script is in root/modules/Forums/somefolder you could try

Code:

define('INCLUDE_PATH', '../../../');

keep in mind if the mod references any forum includes they have moved in RN from root/includes to root/modules/Forums/includes

Smile

good luck