Search options (Page 4 of 16)

// Enable DEBUG mode by removing // from the following line
define('FORUM_DEBUG', 1);

~ PunBB 1.2 -> PunBB 1.3 database preparation ~
(tested successfully during a real forum migration)

Converts latin1 (or whatever) colums to utf8 manually, and prevents loss of data due to special chars.
This does NOT convert 1.2 database to 1.3 format, it only alters the charset, you still need to run db_update.php script to convert your db.
>> After executing this script, you MUST NOT SELECT "Enable conversation", or you will lose data if sone of your entries contain special chars.

<?>    This script assumes your data is in the same format as your headers (which is the case most of the time)
    Please backup/dump your database before using my script for safety.

<!> Don't forget to change the USE statement at line 25

Read this topic for more information:
http://punbb.informer.com/forums/post/140765/#p140765


    tOnI0 (punBB official forum)
    contact: tonio.cotten@gnail.com
    03/08/2011

*/

USE myDbName --your punBB 1.2 Database name

--bans

ALTER TABLE bans

DEFAULT CHARSET=utf8,

MODIFY COLUMN `username` varchar(200) CHARACTER SET utf8,
MODIFY COLUMN `ip` varchar(255) CHARACTER SET utf8,
MODIFY COLUMN `email` varchar(50) CHARACTER SET utf8,
MODIFY COLUMN `message` varchar(255) CHARACTER SET utf8;

--categories

ALTER TABLE categories

DEFAULT CHARSET=utf8,

MODIFY COLUMN `cat_name` varchar(80) CHARACTER SET utf8 not null DEFAULT 'New Category';

--censoring

ALTER TABLE censoring

DEFAULT CHARSET=utf8,

MODIFY COLUMN `search_for` varchar(60) CHARACTER SET utf8 not null DEFAULT '',
MODIFY COLUMN `replace_with` varchar(60) CHARACTER SET utf8 not null DEFAULT '';

--config

ALTER TABLE config

DEFAULT CHARSET=utf8,

MODIFY COLUMN `conf_name` varchar(255) CHARACTER SET utf8 not null DEFAULT '',
MODIFY COLUMN `conf_value` text CHARACTER SET utf8;

--forums

ALTER TABLE forums

DEFAULT CHARSET=utf8,

MODIFY COLUMN `forum_name` varchar(80) CHARACTER SET utf8 not null DEFAULT 'New Forum',
MODIFY COLUMN `forum_desc` text CHARACTER SET utf8,
MODIFY COLUMN `redirect_url` varchar(100) CHARACTER SET utf8,
MODIFY COLUMN `moderators` text CHARACTER SET utf8,
MODIFY COLUMN `last_poster` varchar(200) CHARACTER SET utf8;

--perms

ALTER TABLE forum_perms

DEFAULT CHARSET=utf8;

--groups

ALTER TABLE groups

DEFAULT CHARSET=utf8,

MODIFY COLUMN `g_title` varchar(50) CHARACTER SET utf8 not null DEFAULT '',
MODIFY COLUMN `g_user_title` varchar(50) CHARACTER SET utf8;

--online

ALTER TABLE online

DEFAULT CHARSET=utf8,

MODIFY COLUMN `ident` varchar(200) CHARACTER SET utf8 not null DEFAULT '';

--posts

ALTER TABLE posts

DEFAULT CHARSET=utf8,

MODIFY COLUMN `poster` varchar(200) CHARACTER SET utf8 not null DEFAULT '',
MODIFY COLUMN `poster_ip` varchar(15) CHARACTER SET utf8,
MODIFY COLUMN `poster_email` varchar(50) CHARACTER SET utf8,
MODIFY COLUMN `message` text CHARACTER SET utf8,
MODIFY COLUMN `edited_by` varchar(200) CHARACTER SET utf8 not null DEFAULT '';

--ranks

ALTER TABLE ranks

DEFAULT CHARSET=utf8,

MODIFY COLUMN `rank` varchar(50) CHARACTER SET utf8 not null DEFAULT '';

--reports

ALTER TABLE reports

DEFAULT CHARSET=utf8,

MODIFY COLUMN `message` text CHARACTER SET utf8;

--search_table

ALTER TABLE search_cache

DEFAULT CHARSET=utf8,

MODIFY COLUMN `ident` varchar(200) CHARACTER SET utf8 not null DEFAULT '',
MODIFY COLUMN `search_data` text CHARACTER SET utf8;

--search_matches

ALTER TABLE search_matches

DEFAULT CHARSET=utf8;

--search_words

ALTER TABLE search_words

DEFAULT CHARSET=utf8,

MODIFY COLUMN `word` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin not null DEFAULT '';

--subscriptions

ALTER TABLE subscriptions

DEFAULT CHARSET=utf8;

--topics

ALTER TABLE topics

DEFAULT CHARSET=utf8,

MODIFY COLUMN `poster` varchar(200) CHARACTER SET utf8 not null DEFAULT '',
MODIFY COLUMN `subject` varchar(255) CHARACTER SET utf8 not null DEFAULT '',
MODIFY COLUMN `last_poster` varchar(200) CHARACTER SET utf8;

--users

ALTER TABLE users

DEFAULT CHARSET=utf8,

MODIFY COLUMN `username` varchar(200) CHARACTER SET utf8 not null DEFAULT '',
MODIFY COLUMN `password` varchar(40) CHARACTER SET utf8 not null DEFAULT '',
MODIFY COLUMN `email` varchar(50) CHARACTER SET utf8 not null DEFAULT '',
MODIFY COLUMN `title` varchar(40) CHARACTER SET utf8,
MODIFY COLUMN `realname` varchar(40) CHARACTER SET utf8,
MODIFY COLUMN `url` varchar(100) CHARACTER SET utf8,
MODIFY COLUMN `jabber` varchar(75) CHARACTER SET utf8,
MODIFY COLUMN `icq` varchar(12) CHARACTER SET utf8,
MODIFY COLUMN `msn` varchar(50) CHARACTER SET utf8,
MODIFY COLUMN `aim` varchar(30) CHARACTER SET utf8,
MODIFY COLUMN `yahoo` varchar(30) CHARACTER SET utf8,
MODIFY COLUMN `location` varchar(30) CHARACTER SET utf8,
MODIFY COLUMN `signature` text CHARACTER SET utf8,
MODIFY COLUMN `language` varchar(25) CHARACTER SET utf8 not null DEFAULT 'English',
MODIFY COLUMN `style` varchar(25) CHARACTER SET utf8 not null DEFAULT 'Oxygen',
MODIFY COLUMN `registration_ip` varchar(15) CHARACTER SET utf8 not null DEFAULT '0.0.0.0',
MODIFY COLUMN `admin_note` varchar(30) CHARACTER SET utf8,
MODIFY COLUMN `activate_string` varchar(50) CHARACTER SET utf8,
MODIFY COLUMN `activate_key` varchar(8) CHARACTER SET utf8;

<?php

$db_type = 'mysqli_innodb';   // here is your type of connection to the database
$db_host = '...';    
$db_name = '...';    
$db_username = '...';   
$db_password = '...';  
$db_prefix = '...'; 
$p_connect = false;

$base_url = 'http://...';

$cookie_name = 'forum_cookie_...';
$cookie_domain = '';
$cookie_path = '/';
$cookie_secure = 0;

define('FORUM', 1);

// Enable DEBUG mode by removing // from the following line
define('FORUM_DEBUG', 1);

// Enable show DB Queries mode by removing // from the following line
define('FORUM_SHOW_QUERIES', 1);

// Enable forum IDNA support by removing // from the following line
//define('FORUM_ENABLE_IDNA', 1);

// Disable forum CSRF checking by removing // from the following line
//define('FORUM_DISABLE_CSRF_CONFIRM', 1);

// Disable forum hooks (extensions) by removing // from the following line
//define('FORUM_DISABLE_HOOKS', 1);

// Disable forum output buffering by removing // from the following line
//define('FORUM_DISABLE_BUFFERING', 1);

// Disable forum async JS loader by removing // from the following line
//define('FORUM_DISABLE_ASYNC_JS_LOADER', 1);

// Disable forum extensions version check by removing // from the following line
//define('FORUM_DISABLE_EXTENSIONS_VERSION_CHECK', 1);

// SQLite3 busy timeout -> after waiting for that time we get 'db is locked' error (in msec)
//define('FORUM_SQLITE3_BUSY_TIMEOUT', 10000);

// SQLite3 WAL mode has better control over concurrency. Source: https://www.sqlite.org/wal.html
//define('FORUM_SQLITE3_WAL_ON', 1);

<?php

$db_type = 'mysqli_innodb';   // here is your type of connection to the database
$db_host = '...';
$db_name = '...';
$db_username = '...';
$db_password = '...';
$db_prefix = '...';
$p_connect = false;

$cookie_name = 'pun_cookie_...';
$cookie_domain = '';
$cookie_path = '/';
$cookie_secure = 0;
$cookie_seed = '...'; // random string
$cookie_samesite = 'Lax'; // Strict, Lax or None

$salt1 = '';

define('PUN', 1);

define('PUN_DEBUG', 1);
define('PUN_SHOW_QUERIES', 1);
define('PUN_MAX_POSTSIZE', 65535);
//define('FORUM_EOL', "\r\n"); // possible values can be PHP_EOL, "\r\n", "\n" or "\r"
//define('FORUM_UA_OFF', 1);
define('FORUM_AJAX_JQUERY', 'https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js');
//define('FORUM_SQLITE3_BUSY_TIMEOUT', 10000);
//define('FORUM_SQLITE3_WAL_ON', 1);

//error_reporting(E_ALL);
//ini_set('display_errors', 1);
//ini_set('log_errors', 1);

.kt_newpost_hl > a{
    font-weight: bold;
    color: #C60000;
}