Sub Menu
Links Menu
Online Users

In total there are 314 users online :: 3 registered, 0 hidden and 311 guests

Most users ever online was 1091 on Wed Aug 16, 2023 5:27 pm

Registered users: Bing [Bot], Google [Bot], Majestic-12 [Bot] based on users active over the past 60 minutes

sql install stripper??

Any topics related to phpBB (non-IntegraMOD related)

Moderator: Integra Moderator

sql install stripper??

PostAuthor: Tom_S » Sat May 20, 2006 10:05 am

Does anyone know where there is a tool to strip out the SQL from an install for a mod so you can just add the SQL manually? Or do you know how to strip the info?

I seriously need this stripped so I can manually install this and yes I have already searched everywhere. Here tis:

Code: Select all
<?php /***************************************************************************  *                             install_kb_tables.php  *                            -------------------  *   begin                ]eric@egcnetwork.com[/url] &gt; (Eric Faerber) - [url=http://eric.best-1.biz/]http://eric.best-1.biz/[/url], now supervised by _Haplo &lt; [url=http://www.mx-system.com/]http://www.mx-system.com/[/url] rnrnBe sure you add categories and article types in the ACP and also change the Configuration to your liking.rnrnHave fun and enjoy your new Knowledge Base!  :D", 1, 1, 0, 0,0,0                  );';            $sql[] = 'CREATE TABLE '.KB_CATEGORIES_TABLE.' (                          category_id mediumint(8) unsigned NOT NULL auto_increment,                     category_name VARCHAR(255) binary NOT NULL,                     category_details VARCHAR(255) binary NOT NULL,                    number_articles mediumint(8) unsigned NOT NULL,                   parent mediumint(8) unsigned,                   cat_order mediumint(8) unsigned NOT NULL,                     auth_view tinyint(3) NOT NULL DEFAULT "0",                   auth_post tinyint(3) NOT NULL DEFAULT "0",                   auth_rate tinyint(3) NOT NULL DEFAULT "0",                   auth_comment tinyint(3) NOT NULL DEFAULT "0",                   auth_edit tinyint(3) NOT NULL DEFAULT "0",                   auth_delete tinyint(3) NOT NULL DEFAULT "2",                   auth_approval tinyint(3) NOT NULL DEFAULT "0",                   auth_approval_edit tinyint(3) NOT NULL DEFAULT "0",                   auth_view_groups varchar(255),                   auth_post_groups varchar(255),                   auth_rate_groups varchar(255),                   auth_comment_groups varchar(255),                   auth_edit_groups varchar(255),                   auth_delete_groups varchar(255),                   auth_approval_groups varchar(255),                   auth_approval_edit_groups varchar(255),                   auth_moderator_groups varchar(255),                   comments_forum_id tinyint(3) NOT NULL DEFAULT "-1",                     KEY category_id (category_id)                ) TYPE=MyISAM';                                       $sql[] = 'INSERT INTO '.KB_CATEGORIES_TABLE.' VALUES (1, "Test Category 1", "This is a test category", "0", "0", "10", "0", "0", "0", "0", "0", "2", "0", "0", "", "", "", "", "", "", "", "", "", "0" );';            $sql[] = 'CREATE TABLE '.KB_CONFIG_TABLE.' (                     config_name VARCHAR(255) NOT NULL default "",                   config_value varchar(255) NOT NULL default "",                   PRIMARY KEY  (config_name)                   ) TYPE=MyISAM';                    $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_new", "1")';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("notify", "1")';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("admin_id", "2")';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) values("show_pretext",0);';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) values("pt_header","Article Submission Instructions");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) values("pt_body","Please check your references and include as much information as you can.");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("use_comments", "1");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("del_topic", "1");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("use_ratings", "0");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("comments_show", "1");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("bump_post", "1");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("stats_list", "1");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("header_banner", "1");';            $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("votes_check_userid", "1");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("votes_check_ip", "1");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("art_pagination", "5");';            $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("comments_pagination", "5");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("news_sort", "Alphabetic");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("news_sort_par", "ASC");';            $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("wysiwyg", "0");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("wysiwyg_path", "modules/");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_html", "1");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_bbcode", "1");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_smilies", "1");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("formatting_fixup", "0");';          $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allowed_html_tags", "b,i,u,a");';                          $sql[] = 'CREATE TABLE ' . KB_TYPES_TABLE . ' (                             id mediumint(8) unsigned NOT NULL auto_increment,                           type varchar(255) binary DEFAULT "" NOT NULL,                           KEY id (id)                  ) TYPE=MyISAM';                            $sql[] = 'INSERT INTO '. KB_TYPES_TABLE . ' VALUES (1, "Test Type 1")';            $sql[] = 'CREATE TABLE '. KB_VOTES_TABLE . ' (                        votes_ip varchar(50) NOT NULL default "0",                        votes_userid int(50) NOT NULL default "0",                        votes_file int(50) NOT NULL default "0"                  ) TYPE=MyISAM';            $sql[] = 'CREATE TABLE ' . KB_SEARCH_TABLE . ' (                          search_id int(11) unsigned NOT NULL default "0",                        session_id varchar(32) NOT NULL default "",                        search_array text NOT NULL,                        PRIMARY KEY  (search_id),                        KEY session_id (session_id)                   ) TYPE=MyISAM;';            $sql[] = 'CREATE TABLE ' . KB_WORD_TABLE . ' (                            word_text varchar(50) binary NOT NULL default "",                        word_id mediumint(8) unsigned NOT NULL auto_increment,                        word_common tinyint(1) unsigned NOT NULL default "0",                        PRIMARY KEY  (word_text),                        KEY word_id (word_id)                   ) TYPE=MyISAM;';            $sql[] = 'CREATE TABLE ' . KB_MATCH_TABLE . ' (                         article_id mediumint(8) unsigned NOT NULL default "0",                        word_id mediumint(8) unsigned NOT NULL default "0",                        title_match tinyint(1) NOT NULL default "0",                        KEY post_id (article_id),                        KEY word_id (word_id)                     ) TYPE=MyISAM;';                $sql[] = 'CREATE TABLE ' . KB_CUSTOM_TABLE . ' (                      custom_id int(50) NOT NULL auto_increment,                      custom_name text NOT NULL,                      custom_description text NOT NULL,                      data text NOT NULL,                      field_order int(20) NOT NULL default "0",                      field_type tinyint(2) NOT NULL default "0",                      regex varchar(255) NOT NULL default "",                      PRIMARY KEY  (custom_id)                   ) TYPE=MyISAM;';                    $sql[] = 'CREATE TABLE ' . KB_CUSTOM_DATA_TABLE . ' (                      customdata_file int(50) NOT NULL default "0",                      customdata_custom int(50) NOT NULL default "0",                      data text NOT NULL                   ) TYPE=MyISAM;';                                    break;               case 'mssql':       case 'mssql-odbc':               default:          die("/! No Database Abstraction Layer (DBAL) found /!\");          break;    }    echo("<h2>Adding/modifying tables to your database</h2>n");    for ($i=0; $i <count>sql_query($sql[$i])) )       {          $error_code = TRUE;          $error = $db->sql_error();            echo(" -> <b><span>ERROR - QUERY FAILED</span></b> ----> <u>" . $error['message'] . "</u><br><br>nn");       }       else       {          echo(" -> <b><span>GOOD - QUERY OK</span></b><br><br>nn");       }    }         $error_message = "";         if ( $error_code )       {          $error_message .= "<br>At least one query failed : check the error message and contact me if you need help to resolve the problem. <br>";       }       else       {          $error_message .= "<br>All the queries have been successfully done - Enjoy. <br>";       }         echo("n<br>n<b>COMPLETE - INSTALLATION IS ENDED</b><br>n");       echo($error_message . "<br>");       echo("<br><b>NOW, DELETE THIS FILE FROM YOUR SERVER</b><br>n"); }  ?> </body> </html>


Thanks in advance so very much <img>
Last edited by Tom_S on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
<img>

Tom_S
Integra Supporter
Integra Supporter
 
Posts: 62
Likes: 0 post
Liked in: 0 post
Joined: Wed Apr 26, 2006 7:23 am
Cash on hand: 0.00

PostAuthor: Michaelo » Sun May 21, 2006 9:35 am

Dont know offhand but would be interested so I am posting to keep in touchà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦
Mike
Last edited by Michaelo on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
Kiss Portal Engine phpbbireland (status: Released)
User avatar
Michaelo
Administrator
Administrator
 
Posts: 1646
Likes: 0 post
Liked in: 0 post
Joined: Sat Mar 11, 2006 5:14 pm
Cash on hand: 0.00
Location: Dublin, Ireland

Re: sql install stripper??

PostAuthor: Tom_S » Sun May 21, 2006 9:57 am

I searched high and low but can only come up with the SQL install creator. I would like to find the reverse action of that to strip the sql from the install so it can be not only manually installed but show acurate errors if any exist. I will keep you posted if I find anything.
Last edited by Tom_S on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
<img>

Tom_S
Integra Supporter
Integra Supporter
 
Posts: 62
Likes: 0 post
Liked in: 0 post
Joined: Wed Apr 26, 2006 7:23 am
Cash on hand: 0.00

PostAuthor: Michaelo » Sun May 21, 2006 4:29 pm

Thanks Tom... I normally have to export them individually and execute one at a time ;(
Last edited by Michaelo on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
Kiss Portal Engine phpbbireland (status: Released)
User avatar
Michaelo
Administrator
Administrator
 
Posts: 1646
Likes: 0 post
Liked in: 0 post
Joined: Sat Mar 11, 2006 5:14 pm
Cash on hand: 0.00
Location: Dublin, Ireland


Return to phpBB Related Topics

Who is online

Registered users: Bing [Bot], Google [Bot], Majestic-12 [Bot]

cron