Code: Select all
cd /u6/harry
gunzip gcc-2.95.3-sol8-sparc-local.gz
pkgadd -d gcc-2.95.3-sol8-sparc-local
gunzip make-3.79.1-sol8-sparc-local.gz
pkgadd -d make-3.79.1-sol8-sparc-local
gunzip flex-2.5.4a-sol8-sparc-local.gz
pkgadd -d flex-2.5.4a-sol8-sparc-local
gunzip libgcc-3.0-sol8-sparc-local.gz
pkgadd -d libgcc-3.0-sol8-sparc-local
gunzip php-4.3.3.tar.gz
tar xvf php-4.3.3.tar
gunzip apache_1.3.28.tar.gz
tar xvf apache_1.3.28.tar
PATH=/usr/local/bin:/usr/ccs/bin:$PATH (to enable "make" to find its tools)
cd /u6/harry/apache_1.3.28
./configure --prefix=/u6/apache_1.3.28 --enable-module=most --enable-shared=max
LIBS=-lpthread ./config.status
make
make install
su - oracle (to activate the related Oracle environment variables)
cd /u6/harry/php-4.3.3
PATH=/usr/xpg4/bin:$PATH (to get "make" to use a copy of "sed" in /usr/xpg4/bin, which doesn't have the show-stopping bug)
./configure --with-oci8=/u4/oracle/app/oracle/product/8.1.7 --with-apxs=/u6/apache_1.3.28/bin/apxs
make
make install
cd ../apache_1.3.28
./config.status --activate-module=src/modules/php4/libphp4.module
make
make install
chown -R nobody /u6/apache_1.3.28
ln -s /u6/apache_1.3.28 /u6/apache
vi /u6/apache/conf/httpd.conf
Code: Select all
AddType application/x-httpd-php .php
Code: Select all
cd /u6/apache/bin
./apachectl start
Code: Select all
$dbms = 'oracle';
$dbhost = 'your_Oracle_SID';
$dbname = 'your_Oracle_SID';
$dbuser = 'your_Oracle_username';
$dbpasswd = 'your_Oracle_password';
Code: Select all
REM ----------------------------------------------------------------------------------------------------
REM
REM This script is used to built the relevant tables in an Oracle database
REM to prepare it to be used by phpBB (http://www.phpbb.com)
REM
REM ----------------------------------------------------------------------------------------------------
REM Originally written by Alexander Lukanin (alex at tascom dot net dot dotru)
REM Testing and error corrections done by Stephen Booth (stephen_booth at birmingham dot gov dot dotuk)
REM "DROP TABLE"s added for convenience by Harry Sufehmi (harry_sufehmi at birmingham dot gov dot dotuk)
REM ----------------------------------------------------------------------------------------------------
REM
REM === WARNING ===
REM This script will destroy all data in the related tables, naturally, because this script is supposed
REM to be run only on the initial installation of phpBB.
REM
REM ----------------------------------------------------------------------------------------------------
DROP SEQUENCE phpbb_groups_id_seq;
CREATE SEQUENCE phpbb_groups_id_seq;
DROP SEQUENCE phpbb_banlist_id_seq;
CREATE SEQUENCE phpbb_banlist_id_seq;
DROP SEQUENCE phpbb_categories_id_seq;
CREATE SEQUENCE phpbb_categories_id_seq;
DROP SEQUENCE phpbb_disallow_id_seq;
CREATE SEQUENCE phpbb_disallow_id_seq;
DROP SEQUENCE phpbb_forum_prune_id_seq;
CREATE SEQUENCE phpbb_forum_prune_id_seq;
DROP SEQUENCE phpbb_posts_id_seq;
CREATE SEQUENCE phpbb_posts_id_seq;
DROP SEQUENCE phpbb_privmsgs_id_seq;
CREATE SEQUENCE phpbb_privmsgs_id_seq;
DROP SEQUENCE phpbb_ranks_id_seq;
CREATE SEQUENCE phpbb_ranks_id_seq;
DROP SEQUENCE phpbb_search_wordlist_id_seq;
CREATE SEQUENCE phpbb_search_wordlist_id_seq;
DROP SEQUENCE phpbb_smilies_id_seq;
CREATE SEQUENCE phpbb_smilies_id_seq;
DROP SEQUENCE phpbb_themes_id_seq;
CREATE SEQUENCE phpbb_themes_id_seq;
DROP SEQUENCE phpbb_topics_id_seq;
CREATE SEQUENCE phpbb_topics_id_seq;
DROP SEQUENCE phpbb_vote_desc_id_seq;
CREATE SEQUENCE phpbb_vote_desc_id_seq;
DROP SEQUENCE phpbb_words_id_seq;
CREATE SEQUENCE phpbb_words_id_seq;
DROP TABLE phpbb_auth_access;
CREATE TABLE phpbb_auth_access
(group_id NUMBER DEFAULT '0' NOT NULL,
forum_id NUMBER DEFAULT '0' NOT NULL,
auth_view VARCHAR2(1) DEFAULT '0' NOT NULL,
auth_read VARCHAR2(1) DEFAULT '0' NOT NULL,
auth_post VARCHAR2(1) DEFAULT '0' NOT NULL,
auth_reply VARCHAR2(1) DEFAULT '0' NOT NULL,
auth_edit VARCHAR2(1) DEFAULT '0' NOT NULL,
auth_delete VARCHAR2(1) DEFAULT '0' NOT NULL,
auth_sticky VARCHAR2(1) DEFAULT '0' NOT NULL,
auth_announce VARCHAR2(1) DEFAULT '0' NOT NULL,
auth_vote VARCHAR2(1) DEFAULT '0' NOT NULL,
auth_pollcreate VARCHAR2(1) DEFAULT '0' NOT NULL,
auth_attachments VARCHAR2(1) DEFAULT '0' NOT NULL,
auth_mod VARCHAR2(1) DEFAULT '0' NOT NULL);
DROP TABLE phpbb_banlist;
CREATE TABLE phpbb_banlist
(ban_id NUMBER NOT NULL,
ban_userid NUMBER,
ban_ip VARCHAR2(8),
ban_email VARCHAR2(255));
CREATE OR REPLACE TRIGGER phpbb_banlist_bi
BEFORE INSERT
ON phpbb_banlist
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_banlist_ID_SEQ.NEXTVAL INTO :NEW.ban_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_categories;
CREATE TABLE phpbb_categories
(cat_id NUMBER NOT NULL,
cat_title VARCHAR2(100),
cat_order NUMBER NOT NULL);
CREATE OR REPLACE TRIGGER phpbb_categories_bi
BEFORE INSERT
ON phpbb_categories
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_categories_ID_SEQ.NEXTVAL INTO :NEW.cat_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_config;
CREATE TABLE phpbb_config
(config_name VARCHAR2(255) NOT NULL,
config_value VARCHAR2(255));
DROP TABLE phpbb_disallow;
CREATE TABLE phpbb_disallow
(disallow_id NUMBER NOT NULL,
disallow_username VARCHAR2(25) DEFAULT '' NOT NULL);
CREATE OR REPLACE TRIGGER phpbb_disallow_bi
BEFORE INSERT
ON phpbb_disallow
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_disallow_ID_SEQ.NEXTVAL INTO :NEW.disallow_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_forum_prune;
CREATE TABLE phpbb_forum_prune
(prune_id NUMBER NOT NULL,
forum_id NUMBER NOT NULL,
prune_days NUMBER NOT NULL,
prune_freq NUMBER NOT NULL);
CREATE OR REPLACE TRIGGER phpbb_forum_prune_bi
BEFORE INSERT
ON phpbb_forum_prune
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_forum_prune_ID_SEQ.NEXTVAL INTO :NEW.prune_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_forums;
CREATE TABLE phpbb_forums
(forum_id NUMBER NOT NULL,
cat_id NUMBER NOT NULL,
forum_name VARCHAR2(150),
forum_desc VARCHAR2(2000),
forum_status NUMBER DEFAULT '0' NOT NULL,
forum_order NUMBER DEFAULT '1' NOT NULL,
forum_posts NUMBER DEFAULT '0' NOT NULL,
forum_topics NUMBER DEFAULT '0' NOT NULL,
forum_last_post_id NUMBER DEFAULT '0' NOT NULL,
prune_next NUMBER,
prune_enable VARCHAR2(1) DEFAULT '0' NOT NULL,
auth_view VARCHAR2(2) DEFAULT '0' NOT NULL,
auth_read VARCHAR2(2) DEFAULT '0' NOT NULL,
auth_post VARCHAR2(2) DEFAULT '0' NOT NULL,
auth_reply VARCHAR2(2) DEFAULT '0' NOT NULL,
auth_edit VARCHAR2(2) DEFAULT '0' NOT NULL,
auth_delete VARCHAR2(2) DEFAULT '0' NOT NULL,
auth_sticky VARCHAR2(2) DEFAULT '0' NOT NULL,
auth_announce VARCHAR2(2) DEFAULT '0' NOT NULL,
auth_vote VARCHAR2(2) DEFAULT '0' NOT NULL,
auth_pollcreate VARCHAR2(2) DEFAULT '0' NOT NULL,
auth_attachments VARCHAR2(2) DEFAULT '0' NOT NULL);
DROP TABLE phpbb_groups;
CREATE TABLE phpbb_groups
(group_id NUMBER NOT NULL,
group_type NUMBER DEFAULT '1' NOT NULL,
group_name VARCHAR2(40),
group_description VARCHAR2(255),
group_moderator NUMBER DEFAULT '0' NOT NULL,
group_single_user VARCHAR2(1) DEFAULT '1' NOT NULL);
CREATE OR REPLACE TRIGGER phpbb_groups_bi
BEFORE INSERT
ON phpbb_groups
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_groups_ID_SEQ.NEXTVAL INTO :NEW.group_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_posts;
CREATE TABLE phpbb_posts
(post_id NUMBER NOT NULL,
topic_id NUMBER DEFAULT '0' NOT NULL,
forum_id NUMBER DEFAULT '0' NOT NULL,
poster_id NUMBER DEFAULT '0' NOT NULL,
post_time NUMBER DEFAULT '0' NOT NULL,
poster_ip VARCHAR2(8) NOT NULL,
post_username VARCHAR2(25),
enable_bbcode VARCHAR2(1) DEFAULT '1' NOT NULL,
enable_html VARCHAR2(1) DEFAULT '0' NOT NULL,
enable_smilies VARCHAR2(1) DEFAULT '1' NOT NULL,
enable_sig VARCHAR2(1) DEFAULT '1' NOT NULL,
post_edit_time NUMBER,
post_edit_count NUMBER DEFAULT '0' NOT NULL);
CREATE OR REPLACE TRIGGER phpbb_posts_bi
BEFORE INSERT
ON phpbb_posts
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_posts_ID_SEQ.NEXTVAL INTO :NEW.post_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_posts_text;
CREATE TABLE phpbb_posts_text
(post_id NUMBER DEFAULT '0' NOT NULL,
bbcode_uid VARCHAR2(10),
post_subject VARCHAR2(60),
post_text VARCHAR2(2000));
DROP TABLE phpbb_privmsgs;
CREATE TABLE phpbb_privmsgs
(privmsgs_id NUMBER NOT NULL,
privmsgs_type NUMBER DEFAULT '0' NOT NULL,
privmsgs_subject VARCHAR2(255) DEFAULT '0' NOT NULL,
privmsgs_from_userid NUMBER DEFAULT '0' NOT NULL,
privmsgs_to_userid NUMBER DEFAULT '0' NOT NULL,
privmsgs_date NUMBER DEFAULT '0' NOT NULL,
privmsgs_ip VARCHAR2(8) NOT NULL,
privmsgs_enable_bbcode VARCHAR2(1) DEFAULT '1' NOT NULL,
privmsgs_enable_html VARCHAR2(1) DEFAULT '0' NOT NULL,
privmsgs_enable_smilies VARCHAR2(1) DEFAULT '1' NOT NULL,
privmsgs_attach_sig VARCHAR2(1) DEFAULT '1' NOT NULL);
CREATE OR REPLACE TRIGGER phpbb_privmsgs_bi
BEFORE INSERT
ON phpbb_privmsgs
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_privmsgs_ID_SEQ.NEXTVAL INTO :NEW.privmsgs_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_privmsgs_text;
CREATE TABLE phpbb_privmsgs_text
(privmsgs_text_id NUMBER DEFAULT '0' NOT NULL,
privmsgs_bbcode_uid VARCHAR2(10) DEFAULT '0' NOT NULL,
privmsgs_text VARCHAR2(2000));
DROP TABLE phpbb_ranks;
CREATE TABLE phpbb_ranks
(rank_id NUMBER NOT NULL,
rank_title VARCHAR2(50) NOT NULL,
rank_min NUMBER DEFAULT '0' NOT NULL,
rank_special VARCHAR2(1) DEFAULT '0',
rank_image VARCHAR2(255));
CREATE OR REPLACE TRIGGER phpbb_ranks_bi
BEFORE INSERT
ON phpbb_ranks
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_ranks_ID_SEQ.NEXTVAL INTO :NEW.rank_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_search_results;
CREATE TABLE phpbb_search_results
(search_id NUMBER DEFAULT '0' NOT NULL,
session_id VARCHAR2(32) DEFAULT '' NOT NULL,
search_array VARCHAR2(2000) NOT NULL);
DROP TABLE phpbb_search_wordlist;
CREATE TABLE phpbb_search_wordlist
(word_text VARCHAR2(50) DEFAULT '' NOT NULL,
word_id NUMBER NOT NULL,
word_common VARCHAR2(1) DEFAULT '0' NOT NULL);
CREATE OR REPLACE TRIGGER phpbb_search_wordlist_bi
BEFORE INSERT
ON phpbb_search_wordlist
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_search_wordlist_ID_SEQ.NEXTVAL INTO :NEW.word_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_search_wordmatch;
CREATE TABLE phpbb_search_wordmatch
(post_id NUMBER DEFAULT '0' NOT NULL,
word_id NUMBER DEFAULT '0' NOT NULL,
title_match VARCHAR2(1) DEFAULT '0' NOT NULL);
DROP TABLE phpbb_sessions;
CREATE TABLE phpbb_sessions
(session_id VARCHAR2(32) DEFAULT '' NOT NULL,
session_user_id NUMBER DEFAULT '0' NOT NULL,
session_start NUMBER DEFAULT '0' NOT NULL,
session_time NUMBER DEFAULT '0' NOT NULL,
session_ip VARCHAR2(8) DEFAULT '0' NOT NULL,
session_page NUMBER DEFAULT '0' NOT NULL,
session_logged_in VARCHAR2(1) DEFAULT '0' NOT NULL);
DROP TABLE phpbb_smilies;
CREATE TABLE phpbb_smilies
(smilies_id NUMBER NOT NULL,
code VARCHAR2(50),
smile_url VARCHAR2(100),
emoticon VARCHAR2(75));
CREATE OR REPLACE TRIGGER phpbb_smilies_bi
BEFORE INSERT
ON phpbb_smilies
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_smilies_ID_SEQ.NEXTVAL INTO :NEW.smilies_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_themes;
CREATE TABLE phpbb_themes
(themes_id NUMBER NOT NULL,
template_name VARCHAR2(30) DEFAULT '' NOT NULL,
style_name VARCHAR2(30) DEFAULT '' NOT NULL,
head_stylesheet VARCHAR2(100) DEFAULT NULL,
body_background VARCHAR2(100) DEFAULT NULL,
body_bgcolor VARCHAR2(6) DEFAULT NULL,
body_text VARCHAR2(6) DEFAULT NULL,
body_link VARCHAR2(6) DEFAULT NULL,
body_vlink VARCHAR2(6) DEFAULT NULL,
body_alink VARCHAR2(6) DEFAULT NULL,
body_hlink VARCHAR2(6) DEFAULT NULL,
tr_color1 VARCHAR2(6) DEFAULT NULL,
tr_color2 VARCHAR2(6) DEFAULT NULL,
tr_color3 VARCHAR2(6) DEFAULT NULL,
tr_class1 VARCHAR2(25) DEFAULT NULL,
tr_class2 VARCHAR2(25) DEFAULT NULL,
tr_class3 VARCHAR2(25) DEFAULT NULL,
th_color1 VARCHAR2(6) DEFAULT NULL,
th_color2 VARCHAR2(6) DEFAULT NULL,
th_color3 VARCHAR2(6) DEFAULT NULL,
th_class1 VARCHAR2(25) DEFAULT NULL,
th_class2 VARCHAR2(25) DEFAULT NULL,
th_class3 VARCHAR2(25) DEFAULT NULL,
td_color1 VARCHAR2(6) DEFAULT NULL,
td_color2 VARCHAR2(6) DEFAULT NULL,
td_color3 VARCHAR2(6) DEFAULT NULL,
td_class1 VARCHAR2(25) DEFAULT NULL,
td_class2 VARCHAR2(25) DEFAULT NULL,
td_class3 VARCHAR2(25) DEFAULT NULL,
fontface1 VARCHAR2(50) DEFAULT NULL,
fontface2 VARCHAR2(50) DEFAULT NULL,
fontface3 VARCHAR2(50) DEFAULT NULL,
fontsize1 NUMBER DEFAULT NULL,
fontsize2 NUMBER DEFAULT NULL,
fontsize3 NUMBER DEFAULT NULL,
fontcolor1 VARCHAR2(6) DEFAULT NULL,
fontcolor2 VARCHAR2(6) DEFAULT NULL,
fontcolor3 VARCHAR2(6) DEFAULT NULL,
span_class1 VARCHAR2(25) DEFAULT NULL,
span_class2 VARCHAR2(25) DEFAULT NULL,
span_class3 VARCHAR2(25) DEFAULT NULL,
img_size_poll NUMBER,
img_size_privmsg NUMBER);
CREATE OR REPLACE TRIGGER phpbb_themes_bi
BEFORE INSERT
ON phpbb_themes
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_themes_ID_SEQ.NEXTVAL INTO :NEW.themes_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_themes_name;
CREATE TABLE phpbb_themes_name
(themes_id NUMBER DEFAULT '0' NOT NULL,
tr_color1_name VARCHAR2(50),
tr_color2_name VARCHAR2(50),
tr_color3_name VARCHAR2(50),
tr_class1_name VARCHAR2(50),
tr_class2_name VARCHAR2(50),
tr_class3_name VARCHAR2(50),
th_color1_name VARCHAR2(50),
th_color2_name VARCHAR2(50),
th_color3_name VARCHAR2(50),
th_class1_name VARCHAR2(50),
th_class2_name VARCHAR2(50),
th_class3_name VARCHAR2(50),
td_color1_name VARCHAR2(50),
td_color2_name VARCHAR2(50),
td_color3_name VARCHAR2(50),
td_class1_name VARCHAR2(50),
td_class2_name VARCHAR2(50),
td_class3_name VARCHAR2(50),
fontface1_name VARCHAR2(50),
fontface2_name VARCHAR2(50),
fontface3_name VARCHAR2(50),
fontsize1_name VARCHAR2(50),
fontsize2_name VARCHAR2(50),
fontsize3_name VARCHAR2(50),
fontcolor1_name VARCHAR2(50),
fontcolor2_name VARCHAR2(50),
fontcolor3_name VARCHAR2(50),
span_class1_name VARCHAR2(50),
span_class2_name VARCHAR2(50),
span_class3_name VARCHAR2(50));
DROP TABLE phpbb_topics;
CREATE TABLE phpbb_topics
(topic_id NUMBER NOT NULL,
forum_id NUMBER DEFAULT '0' NOT NULL,
topic_title VARCHAR2(60) NOT NULL,
topic_poster NUMBER DEFAULT '0' NOT NULL,
topic_time NUMBER DEFAULT '0' NOT NULL,
topic_views NUMBER DEFAULT '0' NOT NULL,
topic_replies NUMBER DEFAULT '0' NOT NULL,
topic_status VARCHAR2(3) DEFAULT '0' NOT NULL,
topic_vote VARCHAR2(1) DEFAULT '0' NOT NULL,
topic_type VARCHAR2(3) DEFAULT '0' NOT NULL,
topic_first_post_id NUMBER DEFAULT '0' NOT NULL,
topic_last_post_id NUMBER DEFAULT '0' NOT NULL,
topic_moved_id NUMBER DEFAULT '0' NOT NULL);
CREATE OR REPLACE TRIGGER phpbb_topics_bi
BEFORE INSERT
ON phpbb_topics
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_topics_ID_SEQ.NEXTVAL INTO :NEW.topic_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_topics_watch;
CREATE TABLE phpbb_topics_watch
(topic_id NUMBER DEFAULT '0' NOT NULL,
user_id NUMBER DEFAULT '0' NOT NULL,
notify_status VARCHAR2(1) DEFAULT '0' NOT NULL);
DROP TABLE phpbb_user_group;
CREATE TABLE phpbb_user_group
(group_id NUMBER DEFAULT '0' NOT NULL,
user_id NUMBER DEFAULT '0' NOT NULL,
user_pending VARCHAR2(1));
DROP TABLE phpbb_users;
CREATE TABLE phpbb_users
(user_id NUMBER NOT NULL,
user_active VARCHAR2(1) DEFAULT '1',
username VARCHAR2(25) NOT NULL,
user_password VARCHAR2(32),
user_session_time NUMBER DEFAULT '0' NOT NULL,
user_session_page NUMBER DEFAULT '0' NOT NULL,
user_lastvisit NUMBER DEFAULT '0' NOT NULL,
user_regdate NUMBER DEFAULT '0' NOT NULL,
user_level NUMBER DEFAULT '0',
user_posts NUMBER DEFAULT '0' NOT NULL,
user_timezone NUMBER DEFAULT '0' NOT NULL,
user_style NUMBER,
user_lang VARCHAR2(255),
user_dateformat VARCHAR2(14) DEFAULT 'd M Y H:i' ,
user_new_privmsg NUMBER DEFAULT '0' NOT NULL,
user_unread_privmsg NUMBER DEFAULT '0' NOT NULL,
user_last_privmsg NUMBER DEFAULT '0' NOT NULL,
user_emailtime NUMBER,
user_viewemail VARCHAR2(1),
user_attachsig VARCHAR2(1),
user_allowhtml VARCHAR2(1) DEFAULT '1',
user_allowbbcode VARCHAR2(1) DEFAULT '1',
user_allowsmile VARCHAR2(1) DEFAULT '1',
user_allowavatar VARCHAR2(1) DEFAULT '1' NOT NULL,
user_allow_pm VARCHAR2(1) DEFAULT '1' NOT NULL,
user_allow_viewonline VARCHAR2(1) DEFAULT '1' NOT NULL,
user_notify VARCHAR2(1) DEFAULT '1' NOT NULL,
user_notify_pm VARCHAR2(1) DEFAULT '0' NOT NULL,
user_popup_pm VARCHAR2(1) DEFAULT '0' NOT NULL,
user_rank NUMBER DEFAULT '0',
user_avatar VARCHAR2(100),
user_avatar_type NUMBER DEFAULT '0' NOT NULL,
user_email VARCHAR2(255),
user_icq VARCHAR2(15),
user_website VARCHAR2(100),
user_from VARCHAR2(100),
user_sig VARCHAR2(2000),
user_sig_bbcode_uid VARCHAR2(10),
user_aim VARCHAR2(255),
user_yim VARCHAR2(255),
user_msnm VARCHAR2(255),
user_occ VARCHAR2(100),
user_interests VARCHAR2(255),
user_actkey VARCHAR2(32),
user_newpasswd VARCHAR2(32));
DROP TABLE phpbb_vote_desc;
CREATE TABLE phpbb_vote_desc
(vote_id NUMBER NOT NULL,
topic_id NUMBER DEFAULT '0' NOT NULL,
vote_text VARCHAR2(2000) NOT NULL,
vote_start NUMBER DEFAULT '0' NOT NULL,
vote_length NUMBER DEFAULT '0' NOT NULL);
CREATE OR REPLACE TRIGGER phpbb_vote_desc_bi
BEFORE INSERT
ON phpbb_vote_desc
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_vote_desc_ID_SEQ.NEXTVAL INTO :NEW.vote_id FROM DUAL;
END;
/
show errors
DROP TABLE phpbb_vote_results;
CREATE TABLE phpbb_vote_results
(vote_id NUMBER DEFAULT '0' NOT NULL,
vote_option_id NUMBER DEFAULT '0' NOT NULL,
vote_option_text VARCHAR2(255) NOT NULL,
vote_result NUMBER DEFAULT '0' NOT NULL);
DROP TABLE phpbb_vote_voters;
CREATE TABLE phpbb_vote_voters
(vote_id NUMBER DEFAULT '0' NOT NULL,
vote_user_id NUMBER DEFAULT '0' NOT NULL,
vote_user_ip VARCHAR2(8) NOT NULL);
DROP TABLE phpbb_words;
CREATE TABLE phpbb_words
(word_id NUMBER NOT NULL,
word VARCHAR2(100) NOT NULL,
replacement VARCHAR2(100) NOT NULL);
CREATE OR REPLACE TRIGGER phpbb_words_bi
BEFORE INSERT
ON phpbb_words
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT phpbb_words_ID_SEQ.NEXTVAL INTO :NEW.word_id FROM DUAL;
END;
/
show errors
Code: Select all
CREATE INDEX phpbb_auth_access_group_id ON phpbb_auth_access
(group_id ASC);
CREATE INDEX phpbb_auth_access_forum_id ON phpbb_auth_access
(forum_id ASC);
CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group
(group_id ASC);
CREATE INDEX phpbb_user_group_user_id ON phpbb_user_group
(user_id ASC);
CREATE INDEX phpbb_groups_group_id ON phpbb_groups
(group_id ASC);
CREATE INDEX phpbb_groups_group_single_user ON phpbb_groups
(group_single_user ASC);
CREATE INDEX phpbb_banlist_ban_id ON phpbb_banlist
(ban_id ASC);
CREATE INDEX phpbb_categories_cat_id ON phpbb_categories
(cat_id ASC);
CREATE INDEX phpbb_categories_cat_order ON phpbb_categories
(cat_order ASC);
CREATE INDEX phpbb_config_config_name ON phpbb_config
(config_name ASC);
CREATE INDEX phpbb_disallow_disallow_id ON phpbb_disallow
(disallow_id ASC);
CREATE INDEX phpbb_forum_prune_prune_id ON phpbb_forum_prune
(prune_id ASC);
CREATE INDEX phpbb_forum_prune_forum_id ON phpbb_forum_prune
(forum_id ASC);
CREATE INDEX phpbb_forums_forum_id ON phpbb_forums
(forum_id ASC);
CREATE INDEX phpbb_forums_forum_order ON phpbb_forums
(forum_order ASC);
CREATE INDEX phpbb_forums_cat_id ON phpbb_forums
(cat_id ASC);
CREATE INDEX phpbb_forums_last_post_id ON phpbb_forums
(forum_last_post_id ASC);
CREATE INDEX phpbb_posts_post_id ON phpbb_posts
(post_id ASC);
CREATE INDEX phpbb_posts_forum_id ON phpbb_posts
(forum_id ASC);
CREATE INDEX phpbb_posts_topic_id ON phpbb_posts
(topic_id ASC);
CREATE INDEX phpbb_posts_poster_id ON phpbb_posts
(poster_id ASC);
CREATE INDEX phpbb_posts_post_time ON phpbb_posts
(post_time ASC);
CREATE INDEX phpbb_posts_text_post_id ON phpbb_posts_text
(post_id ASC);
CREATE INDEX phpbb_privmsgs_privmsgs_id ON phpbb_privmsgs
(privmsgs_id ASC);
CREATE INDEX phpbb_privmsgs_from_userid ON phpbb_privmsgs
(privmsgs_from_userid ASC);
CREATE INDEX phpbb_privmsgs_to_userid ON phpbb_privmsgs
(privmsgs_to_userid ASC);
CREATE INDEX phpbb_privmsgs_text_id ON phpbb_privmsgs_text
(privmsgs_text_id ASC);
CREATE INDEX phpbb_ranks_rank_id ON phpbb_ranks
(rank_id ASC);
CREATE INDEX phpbb_search_results_search_id ON phpbb_search_results
(search_id ASC);
CREATE INDEX phpbb_search_results_id ON phpbb_search_results
(session_id ASC);
CREATE INDEX phpbb_search_wordlist_text ON phpbb_search_wordlist
(word_text ASC);
CREATE INDEX phpbb_search_wordlist_word_id ON phpbb_search_wordlist
(word_id ASC);
CREATE INDEX phpbb_search_wordmatch_word_id ON phpbb_search_wordmatch
(word_id ASC);
CREATE INDEX phpbb_sessions_session_id ON phpbb_sessions
(session_id ASC);
CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions
(session_user_id ASC);
CREATE INDEX phpbb_smilies_smilies_id ON phpbb_smilies
(smilies_id ASC);
CREATE INDEX phpbb_themes_themes_id ON phpbb_themes
(themes_id ASC);
CREATE INDEX phpbb_themes_name_themes_id ON phpbb_themes_name
(themes_id ASC);
CREATE INDEX phpbb_topics_topic_id ON phpbb_topics
(topic_id ASC);
CREATE INDEX phpbb_topics_forum_id ON phpbb_topics
(forum_id ASC);
CREATE INDEX phpbb_topics_topic_moved_id ON phpbb_topics
(topic_moved_id ASC);
CREATE INDEX phpbb_topics_topic_status ON phpbb_topics
(topic_status ASC);
CREATE INDEX phpbb_topics_topic_type ON phpbb_topics
(topic_type ASC);
CREATE INDEX phpbb_topics_watch_topic_id ON phpbb_topics_watch
(topic_id ASC);
CREATE INDEX phpbb_topics_watch_user_id ON phpbb_topics_watch
(user_id ASC);
CREATE INDEX phpbb_topics_watch_status ON phpbb_topics_watch
(notify_status ASC);
CREATE INDEX phpbb_users_user_id ON phpbb_users
(user_id ASC);
CREATE INDEX phpbb_users_user_session_time ON phpbb_users
(user_session_time ASC);
CREATE INDEX phpbb_vote_desc_vote_id ON phpbb_vote_desc
(vote_id ASC);
CREATE INDEX phpbb_vote_desc_topic_id ON phpbb_vote_desc
(topic_id ASC);
CREATE INDEX phpbb_vote_results_id ON phpbb_vote_results
(vote_option_id ASC);
CREATE INDEX phpbb_vote_results_vote_id ON phpbb_vote_results
(vote_id ASC);
CREATE INDEX phpbb_vote_voters_vote_id ON phpbb_vote_voters
(vote_id ASC);
CREATE INDEX phpbb_vote_voters_vote_user_ip ON phpbb_vote_voters
(vote_user_ip ASC);
CREATE INDEX phpbb_words_word_id ON phpbb_words
(word_id ASC);
Code: Select all
REM ----------------------------------------------------------------------------------------------------
REM
REM This script is used to populate the relevant tables in an Oracle database
REM to prepare it to be used by phpBB (http://www.phpbb.com)
REM
REM This script is to be run after tables.sql
REM
REM ----------------------------------------------------------------------------------------------------
REM Originally written by Alexander Lukanin (alex at tascom dot net dotru)
REM Testing and error corrections done by Stephen Booth (stephen_booth at birmingham dot gov dot dotuk)
REM ----------------------------------------------------------------------------------------------------
REM
REM Instructions:
REM
REM # Change "www.myserver.tld" to your server's domain/IP address.
REM # Change "server_port" accordingly
REM # Change "script_path" accordingly
REM - The rest then should be changeable from phpBB's admin panel.
REM - Username is "Admin" with password "sapsap"
REM ----------------------------------------------------------------------------------------------------
INSERT INTO phpbb_config (config_name, config_value) VALUES ('config_id','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb2mysql');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','3600');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_theme_create','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sentbox_privmsgs','25');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_savebox_privmsgs','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','[email protected]');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_users', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.myserver.tld');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.4');
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 10);
INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, cat_id, forum_order, forum_posts, forum_topics, forum_last_post_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_attachments) VALUES (1, 'Test Forum 1', 'This is just a test forum.', 1, 10, 1, 1, 1, 0, 0, 0, 0, 1, 1, 3, 3, 1, 1, 3);
INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 0, 1, 0, 1, 1, NULL, '', '', 0, '', '', 0, 0);
INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_popup_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 2, 'Admin', 1, 0, 'c4e7fae1c0d5c5daba89d6383d270567', '[email protected]', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'english', 0, 'd M Y h:i a', '', '', 0, 1);
INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( 1, 'Site Admin', -1, 1, NULL);
INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1);
INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (2, 'Admin', 'Personal User', 1);
INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0);
INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0);
INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_vote, topic_first_post_id, topic_last_post_id, topic_moved_id) VALUES (1, 'Welcome to phpBB 2', 2, '972086460', 0, 0, 1, 0, 0, 0, 1, 1, 0);
INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, 972086460, NULL, '7F000001');
INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, NULL, 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!');
INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1, 'subSilver', 'subSilver', 'subSilver.css', '', 'E5E5E5', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, Courier New, sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', '');
INSERT INTO phpbb_themes_name (themes_id, tr_color1_name, tr_color2_name, tr_color3_name, tr_class1_name, tr_class2_name, tr_class3_name, th_color1_name, th_color2_name, th_color3_name, th_class1_name, th_class2_name, th_class3_name, td_color1_name, td_color2_name, td_color3_name, td_class1_name, td_class2_name, td_class3_name, fontface1_name, fontface2_name, fontface3_name, fontsize1_name, fontsize2_name, fontsize3_name, fontcolor1_name, fontcolor2_name, fontcolor3_name, span_class1_name, span_class2_name, span_class3_name) VALUES (1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 1, ':D', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 2, ':-D', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 3, ':grin:', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 4, ':)', 'icon_smile.gif', 'Smile');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 5, ':-)', 'icon_smile.gif', 'Smile');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 6, ':smile:', 'icon_smile.gif', 'Smile');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 7, ':(', 'icon_sad.gif', 'Sad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 8, ':-(', 'icon_sad.gif', 'Sad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 9, ':sad:', 'icon_sad.gif', 'Sad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 10, ':o', 'icon_surprised.gif', 'Surprised');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 11, ':-o', 'icon_surprised.gif', 'Surprised');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 12, ':eek:', 'icon_surprised.gif', 'Surprised');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 13, ':shock:', 'icon_eek.gif', 'Shocked');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 14, ':?', 'icon_confused.gif', 'Confused');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 15, ':-?', 'icon_confused.gif', 'Confused');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 16, ':???:', 'icon_confused.gif', 'Confused');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 17, '8)', 'icon_cool.gif', 'Cool');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 18, '8-)', 'icon_cool.gif', 'Cool');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 19, ':cool:', 'icon_cool.gif', 'Cool');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 20, ':lol:', 'icon_lol.gif', 'Laughing');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 21, ':x', 'icon_mad.gif', 'Mad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 22, ':-x', 'icon_mad.gif', 'Mad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 23, ':mad:', 'icon_mad.gif', 'Mad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 24, ':P', 'icon_razz.gif', 'Razz');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 25, ':-P', 'icon_razz.gif', 'Razz');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 26, ':razz:', 'icon_razz.gif', 'Razz');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 27, ':oops:', 'icon_redface.gif', 'Embarassed');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 28, ':cry:', 'icon_cry.gif', 'Crying or Very sad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 29, ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 30, ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 31, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 32, ':wink:', 'icon_wink.gif', 'Wink');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 33, ';)', 'icon_wink.gif', 'Wink');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 34, ';-)', 'icon_wink.gif', 'Wink');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 35, ':!:', 'icon_exclaim.gif', 'Exclamation');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 36, ':?:', 'icon_question.gif', 'Question');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 37, ':idea:', 'icon_idea.gif', 'Idea');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 38, ':arrow:', 'icon_arrow.gif', 'Arrow');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 39, ':|', 'icon_neutral.gif', 'Neutral');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 40, ':-|', 'icon_neutral.gif', 'Neutral');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 41, ':neutral:', 'icon_neutral.gif', 'Neutral');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 42, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 1, 'example', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 2, 'post', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 3, 'phpbb', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 4, 'installation', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 5, 'delete', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 6, 'topic', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 7, 'forum', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 8, 'since', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 9, 'everything', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 10, 'seems', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 11, 'working', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 12, 'welcome', 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 1, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 2, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 4, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 5, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 6, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 7, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 8, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 9, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 10, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 11, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 12, 1, 1 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 1 );
commit;
Code: Select all
WHERE p.post_id = f.forum_last_post_id(+)
AND u.user_id = p.poster_id(+)
Code: Select all
WHERE p.post_id (+) = f.forum_last_post_id
AND u.user_id (+) = p.poster_id
Code: Select all
putenv('ORACLE_BASE=/u4/oracle/app/oracle');
putenv('ORACLE_HOME=/u4/oracle/app/oracle/product/8.1.7');
putenv('PATH=/u4/oracle/app/oracle/product/8.1.7/bin:/usr/bin:/bin:/etc:/usr/openwin/bin:/usr/local/bin');
putenv('ORACLE_DOC=$ORACLE_BASE/docs/8.1.7');
putenv('TNS_ADMIN=/u4/oracle/app/oracle/product/8.1.7/network/admin');
Code: Select all
$temp_result = @OCIFetchInto($stmt, $temp_result, OCI_ASSOC+OCI_RETURN_NULLS);
if($temp_result)
{
return $temp_result['CURRVAL'];
Code: Select all
$tmp_result = OCIFetchInto($stmt, $temp_result, OCI_ASSOC+OCI_RETURN_NULLS);
if($tmp_result)
{
return $temp_result['NEXTVAL'];
Code: Select all
if( eregi("^(INSERT{1}|^INSERT INTO{1})[[:space:]][\"]?([a-zA-Z0-9\_\-]+)[\"]?", $this->last_query_text[$query_id], $tablename))
Code: Select all
if(eregi("^(INSERT INTO{1}|^INSERT INTO{1})[[:space:]][\"]?([a-zA-Z0-9\_\-]+)[\"]?", $this->last_query_text[$query_id], $tablename))
Code: Select all
}
if(eregi("^(INSERT|UPDATE) ", $query))
Code: Select all
$start_row = $row_offset;
$end_row = strval(intval($start_row) + intval($num_rows));
$temp_query = $query;
$temp_replacement = "WHERE rownum >= ".$start_row." AND rownum <= ".$end_row." AND ";
$query = "SELECT * FROM (SELECT rownum AS xrownum, a.* FROM (".$temp_query.") a WHERE rownum <= ".$end_row.") WHERE xrownum >= ".$start_row;
Code: Select all
$sql = "SELECT t.*, f.forum_id, f.forum_name, u.username
, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE .
" f, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
WHERE t.topic_id IN ($search_results)
AND t.topic_poster = u.user_id
AND f.forum_id = t.forum_id
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND u2.user_id = p2.poster_id";
Code: Select all
$sql = "SELECT t.*, f.forum_id as fforum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2 WHERE t.topic_id IN ($search_results) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id";
Code: Select all
if ( $match_sql != '' )
{
$sql = "INSERT IGNORE INTO " . SEARCH_MATCH_TABLE . " (post_id, word_id, title_match)
SELECT $post_id, word_id, $title_match
FROM " . SEARCH_WORD_TABLE . "
WHERE word_text IN ($match_sql)";
if ( !$db->sql_query($sql) )
Code: Select all
if ( $match_sql != '' )
{
if (SQL_LAYER == 'oracle')
{
$sql = "INSERT INTO " . SEARCH_MATCH_TABLE . " (post_id, word_id, title_match)
SELECT $post_id, word_id, $title_match
FROM " . SEARCH_WORD_TABLE . "
WHERE word_text IN ($match_sql)";
} else {
$sql = "INSERT IGNORE INTO " . SEARCH_MATCH_TABLE . " (post_id, word_id, title_match)
SELECT $post_id, word_id, $title_match
FROM " . SEARCH_WORD_TABLE . "
WHERE word_text IN ($match_sql)";
};
if ( !$db->sql_query($sql) )
Code: Select all
if ( $show_results == 'posts' )
{
$sql = "SELECT pt.post_text, pt.bbcode_uid, pt.post_subject, p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid
FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt
WHERE p.post_id IN ($search_results)
AND pt.post_id = p.post_id
AND f.forum_id = p.forum_id
AND p.topic_id = t.topic_id
AND p.poster_id = u.user_id";
}
else
Code: Select all
if ( $show_results == 'posts' )
{
if (SQL_LAYER == 'oracle')
{
$sql = "SELECT pt.post_text, pt.bbcode_uid, pt.post_subject, p.*, f.forum_id as fforum_id, f.forum_name, t.topic_title, t.topic_poster, t.topic_time, t.topic_views, t.topic_replies, t.topic_status, t.topic_vote, t.topic_type, t.topic_first_post_id, t.topic_last_post_id, t.topic_moved_id, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid
FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt
WHERE p.post_id IN ($search_results)
AND pt.post_id = p.post_id
AND f.forum_id = p.forum_id
AND p.topic_id = t.topic_id
AND p.poster_id = u.user_id";
} else {
$sql = "SELECT pt.post_text, pt.bbcode_uid, pt.post_subject, p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid
FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt
WHERE p.post_id IN ($search_results)
AND pt.post_id = p.post_id
AND f.forum_id = p.forum_id
AND p.topic_id = t.topic_id
AND p.poster_id = u.user_id";
}
}
else
Code: Select all
CREATE TABLE phpbb_banlist (ban_id NUMBER NOT NULL, ban_userid NUMBER NOT NULL, ban_ip VARCHAR2(8) NOT NULL, ban_email VARCHAR2(255));
Code: Select all
CREATE TABLE phpbb_banlist (ban_id NUMBER NOT NULL, ban_userid NUMBER, ban_ip VARCHAR2(8), ban_email VARCHAR2(255));
Hi, please don't discuss here. You can talk about this patch in this thread instead.Gnolaum wrote:Any chance to get an update on this? Preferably with phpbb 2.0.20 and Oracle Express (10g)?