Tutorial Comments for sanitisation and validation in php

PHP & MySQL

Free Tutorials » PHP & MySQL » Sanitisation and Validation in PHP

Sanitisation and Validation are important terms to understand when writing PHP applications.

Tutorial comments

29.10.2009 -

supermallsz says …

How to set php.ini ?
How to turn off the "safe mode" ,
Because When I install a program,show :
Warning: set_time_limit() has been disabled for security reasons in
/www/zymichost.com/d/i/g/digimall/htdocs/install/install.core.php on line 5

PLS tell me to JasonW918@gmail.com,THanKS!

17.10.2009 -

Zer0respect says …

I didn't knoiw about these functions, very useful information, thank you.

16.10.2009 -

monay says …

because if it is left unchecked, the input may be used to facilitate an exploit. Some of the most common exploits involving user input are: code injection, sql injection and header injection. And we will have a look at some of these during the tutorial.

I dont know thst before

___________________________________________
[url=http://www.dvdcollectionsale.com/Smallville-Seasons-1-8-DVD-Boxset-DVD-1533.html]smallville seasons 1-8 dvd boxset[/url]
[url=http://www.dvdcollectionsale.com/Scrubs-Seasons-1-8-DVD-Boxset-DVD-1616.html]scrubs 1-8[/url]

25.08.2009 -

says …

Trang chủ - Forum Cai Bo

// 0) {
var seo_page = (page - 1) * perpage;
if ( base_url.indexOf('?') >= 0 ) {
document.location.href = base_url.replace(/&/g, '&') + '&start=' + seo_page;
} else if ( seo_page > 0 ) {
var seo_type1 = base_url.match(/\.[a-z0-9]+$/i);
if (seo_type1 !== null) {
document.location.href = base_url.replace(/\.[a-z0-9]+$/i, '') + seo_delim_start + seo_page + seo_type1;
}
var seo_type2 = base_url.match(/\/$/);
if (seo_type2 !== null) {
document.location.href = base_url + seo_static_pagination + seo_page + seo_ext_pagination;
}
} else {
document.location.href = base_url;
}
}
}
// www.phpBB-SEO.com SEO TOOLKIT END

/**
* Find a member
*/
function find_username(url)
{
popup(url, 760, 570, '_usersearch');
return false;
}

/**
* Mark/unmark checklist
* id = ID of parent container, name = name prefix, state = state [true/false]
*/
function marklist(id, name, state)
{
var parent = document.getElementById(id);
if (!parent)
{
eval('parent = document.' + id);
}

if (!parent)
{
return;
}

var rb = parent.getElementsByTagName('input');

for (var r = 0; r < rb.length; r++)
{
if (rb[r].name.substr(0, name.length) == name)
{
rb[r].checked = state;
}
}
}

// ]]>

THÔNG BÁO

Chào mừng các bạn đến với diễn đàn !

Spoiler: body {cursor: url(http://www.myspacecursor.net/dragonball/4.ani); }
Free CursorsMyspace LayoutsMyspace Comments

Đăng nhập Đăng ký
Trợ giúp
Tìm kiếm

Trang chủ

Đăng nhập

Tên thành viên: Mật khẩu: Đăng nhập tự động mỗi lần ghé thăm

Bài viết mới nhất :

Tạo Mr.Captor theo dõi mà…

Trả lời :0 Xem :2
Thủ Thật Web-Blog

Thứ 3 Tháng 8 25, 2009 9:38 am Admin

My Clip

Trả lời :0 Xem :1
Clip-Phim

Thứ 3 Tháng 8 25, 2009 9:13 am Admin

Các Truờng còn chỉ tiêu N…

Trả lời :1 Xem :3
Ôn Đại Học

Thứ 3 Tháng 8 25, 2009 8:41 am Admin

Ánh Trăng Buồn

Trả lời :1 Xem :1
Âm Nhạc

Thứ 3 Tháng 8 25, 2009 6:30 am hellovietnam

Tạo hiệu ứng chuột cho we…

Trả lời :1 Xem :3
Thủ Thật Web-Blog

Thứ 3 Tháng 8 25, 2009 4:15 am Admin

Teen nghịch nghợm !

Trả lời :2 Xem :10
Tuổi Teen

Thứ 3 Tháng 8 25, 2009 3:55 am Admin

Trường THPT Quảng Uyên 26…

Trả lời :2 Xem :7
Clip-Phim

Thứ 3 Tháng 8 25, 2009 3:07 am Admin

kêt ban

Trả lời :1 Xem :2
Giao Lưu-Kết Bạn

Thứ 3 Tháng 8 25, 2009 2:43 am Admin

Sử dụng Photoshop căn bản

Trả lời :3 Xem :11
Thủ Thật Web-Blog

Thứ 2 Tháng 8 24, 2009 8:37 am Admin

Chùm Ảnh Trường THPT Quản…

Trả lời :2 Xem :20
Ảnh Phong Cảnh

Thứ 3 Tháng 8 18, 2009 9:23 am Admin

Mu Hạ Long Season 4 Full …

Trả lời :2 Xem :4
Game

Thứ 4 Tháng 8 12, 2009 8:21 am khang@long

Mu Hải Phòng Season IV Fu…

Trả lời :0 Xem :2
Game

Thứ 5 Tháng 7 23, 2009 5:18 pm modvt

Chuyên mục
Chuyên mục
Bài viết mới nhất
Chủ đề | Bài viết

Ban Quản Trị
[3][/3]

Thông báo cho thành viên !
Gửi bởi Admin
Thứ 7 Tháng 6 27, 2009 10:04 am

1 | 1

Trang Văn Học
Spoiler: Dành Cho các bạn yêu thích thơ văn
Chuyên mục con: Góc Thơ Truyện Của Bạn

Re: Trích tác 100 câu của nhữ…
Gửi bởi khang@long
Thứ 4 Tháng 7 22, 2009 3:21 am

14 | 18

Cao Băng Quê Tôi

Chuyên mục con: Du Lịch Cao Bằng Ẩm Thực   Văn Hóa Cao Bằng

Re: Trò Chơi LÀy Cỏ !
Gửi bởi khang@long
Thứ 4 Tháng 7 22, 2009 3:26 am

8 | 11

Học Tập

Chuyên mục con: Ôn Đại Học Ôn TN THPT

Re: Các Truờng còn chỉ tiêu N…
Gửi bởi Admin
Thứ 3 Tháng 8 25, 2009 8:41 am

8 | 13

Thư Viện Ảnh
Spoiler:
Chuyên mục con: Ảnh Trai Gái Ảnh Phong Cảnh

Re: Chùm Ảnh Trường THPT Quản…
Gửi bởi Admin
Thứ 3 Tháng 8 18, 2009 9:23 am

2 | 5

Góc Bạn Bè
Spoiler:
Chuyên mục con: Giao Lưu-Kết Bạn Bạn Đồng Hương

Trả lời: kêt ban
Gửi bởi Admin
Thứ 3 Tháng 8 25, 2009 2:43 am

5 | 12

Góc Giải Trí
Spoiler:
Chuyên mục con: Game Đố Vui-Cá Độ

Re: Mu Hạ Long Season 4 Full …
Gửi bởi khang@long
Thứ 4 Tháng 8 12, 2009 8:21 am

5 | 12

Khoa Học-Kĩ Thuật

Chuyên mục con: Thủ Thật Web-Blog

Tạo Mr.Captor theo dõi mà…
Gửi bởi Admin
Thứ 3 Tháng 8 25, 2009 9:38 am

3 | 7

Tuổi Teen
Spoiler:

Re: Teen nghịch nghợm !
Gửi bởi Admin
Thứ 3 Tháng 8 25, 2009 3:55 am

3 | 7

Nghệ Thuật

Chuyên mục con: Vẽ Vời Âm Nhạc   Clip-Phim

My Clip
Gửi bởi Admin
Thứ 3 Tháng 8 25, 2009 9:13 am

7 | 10

Lượt Ghé Thăm
Spoiler: _gos='c4.gostats.vn';_goa=338075;_got=7;_goi=105;_goz=0;_gol='Bộ đếm Web miễn phí';_GoStatsRun();

Đồng Hồ
obj=new Object;obj.clockfile="5010-red.swf";obj.TimeZone="VietNam_Hanoi";obj.width=150;obj.height=45;obj.wmode="transparent";showClock(obj);

Rao Vặt
các cuộc rao vặt

Không có bài viết nào

0 | 0

Xoá tất cả cookie | Ban điều hành |

Ai đang trực tuyến?

Trong tổng số 1 người đang trực tuyến: 0 thành viên, 0 thành viên ẩn và 1 khách (cập nhật dựa trên các thành viên hoạt động trong 5 phút vừa qua)Số lượt người ghé thăm đông nhất là 3 vào ngày Thứ 2 Tháng 6 29, 2009 8:29 amCác thành viên đang trực tuyến: Không có thành viên nào đang trực tuyến.

Có 3 thành viên đã ghé thăm trong 24 giờ: Admin, Google [Bot], hellovietnam

Chú thích :: Quản trị viên, Binh bét, Điều hành viên chính

Sinh nhật

Sinh nhật: Không có sinh nhật của thành viên nào hôm nay.

Thống kê

Tổng số bài viết: 94 | Tổng số chủ đề: 56 | Tổng số thành viên: 8 | Chào mừng thành viên mới nhất: hellovietnam

Thống kê sau 24 giờ

Bài viết mới 11 | Chủ đề mới 5 | Thành viên mới 0

Bài viết mới


Không có bài viết mới


Chuyên mục đã khoá

var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));

var pageTracker = _gat._getTracker("UA-5126659-1");
pageTracker._trackPageview();

Powered by phpBB © 2007 phpBB Group

Thời gian được tính theo giờ UTC [ DST ] - Hôm nay, Thứ 3 Tháng 8 25, 2009 10:34 am

Vietnamese translation by nedka Hosted by HNSV Community

Autinhyeu Style designed by Autinhyeu

25.08.2009 -

says …

Forum Cai Bộ

15.07.2009 -

habboadminusa says …

good

11.07.2009 -

khuvv says …

thank you

10.07.2009 -

mtm_jazz says …

can you give me some tutorials on how to connect to the database during log-in..
thnx..

08.07.2009 -

manhtuyen_0906 says …

thanks you !

22.06.2009 -

hendrabima says …

nice, thanks a lot

14.06.2009 -

hedylau2000 says …

for example,my username:abcd_ms and password:4444;
how can i using php connect to mysql ?

18.05.2009 -

netniaz says …

tank you
www.netniaz.com

06.05.2009 -

irannnn says …

very good

http://www.iranhome.blogfa.com

01.05.2009 -

quachkhanh says …

THANKYOU

25.04.2009 -

ginnyluse says …

This is one of the best site to help how to get rid of wrinkles
For more Information pls visit :- get rid of wrinkles

25.04.2009 -

ginnyluse says …

This is one of the best site to every one help how to get rid of wrinkles
http://ezinearticles.com/?Anti-Ageing---Get-Rid-of-Wrinkles-and-Laugh-Marks-Within-30-Days&id=2196755

04.04.2009 -

billysmith12 says …

Very helpful and well explained.

01.03.2009 -

a9719673 says …

These tutorials are great. Very easy to follow for a novice.

25.02.2009 -

s-7bee says …

شركة عشق احلامي لطلباتكم ومشاريعكم

23.01.2009 -

FnCool says …

nice to see this all put in one place, and with simple examples, helps me to be lazy!

11.01.2009 -

uSearch says …

nice

10.01.2009 -

bhavinvora says …

Very Good

07.01.2009 -

UnfixedSNIPERJ says …

Great Tutorial, to many websites don't validate information from their users.

01.01.2009 -

djkarachi says …

I submit before write something...So that is fantastic I've really like it and I will used for future in my scripts!!!

28.12.2008 -

bY_aLp says …

good

10.12.2008 -

tjaldlala says …

nice allways good to remember :P

10.12.2008 -

moipds says …

good

07.11.2008 -

spmatrix says …

ok

nice

07.11.2008 -

spmatrix says …

here

04.11.2008 -

aditz says …

What do you think of this tutorial and free 100%? Type your comment here!

01.10.2008 -

Ziprock says …

nice one

26.09.2008 -

fargcbm says …

Good tutorial. My employer's site got hacked (before I worked there) because they didn't include any validation. Needless to say, its much safer now.

26.09.2008 -

fargcbm says …

Good tutorial. My employer's site got hacked (before I worked there) because they didn't include any validation. Needless to say, its much safer now.

11.09.2008 -

martymfly says …

good !!

05.09.2008 -

cuongga311 says …

fgsdgfdg

23.08.2008 -

jonel23 says …

21.08.2008 -

madp says …

Good tutorial. My employer's site got hacked (before I worked there) because they didn't include any validation. Needless to say, its much safer now.

19.08.2008 -

Bryan08 says …

it helps alot

30.07.2008 -

idadmiral says …

hi all this is very good code

30.07.2008 -

idadmiral says …

dsfsdf sdf

10.07.2008 -

culreggie says …

dont get it

27.06.2008 -

klevz says …

not cool

22.06.2008 -

junjin-forever says …

-- --------------------------------------------------
--
-- Discuz! SQL file for installation
-- $Id: discuz.sql 10517 2007-09-04 01:15:26Z monkey $
--
-- --------------------------------------------------

DROP TABLE IF EXISTS cdb_access;
CREATE TABLE cdb_access (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
fid smallint(6) unsigned NOT NULL DEFAULT '0',
allowview tinyint(1) NOT NULL DEFAULT '0',
allowpost tinyint(1) NOT NULL DEFAULT '0',
allowreply tinyint(1) NOT NULL DEFAULT '0',
allowgetattach tinyint(1) NOT NULL DEFAULT '0',
allowpostattach tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (uid,fid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_activities;
CREATE TABLE cdb_activities (
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
cost mediumint(8) unsigned NOT NULL DEFAULT '0',
starttimefrom int(10) unsigned NOT NULL DEFAULT '0',
starttimeto int(10) unsigned NOT NULL DEFAULT '0',
place char(40) NOT NULL DEFAULT '',
class char(20) NOT NULL DEFAULT '',
gender tinyint(1) NOT NULL DEFAULT '0',
number smallint(5) unsigned NOT NULL DEFAULT '0',
expiration int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (tid),
KEY uid (uid,starttimefrom)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_activityapplies;
CREATE TABLE cdb_activityapplies (
applyid int(10) unsigned NOT NULL AUTO_INCREMENT,
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
username char(15) NOT NULL DEFAULT '',
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
message char(200) NOT NULL DEFAULT '',
verified tinyint(1) NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
payment mediumint(8) NOT NULL DEFAULT '0',
contact char(200) NOT NULL,
PRIMARY KEY (applyid),
KEY uid (uid),
KEY tid (tid),
KEY dateline (tid,dateline)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_adminactions;
CREATE TABLE cdb_adminactions (
admingid smallint(6) unsigned NOT NULL DEFAULT '0',
disabledactions text NOT NULL,
PRIMARY KEY (admingid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_admingroups;
CREATE TABLE cdb_admingroups (
admingid smallint(6) unsigned NOT NULL DEFAULT '0',
alloweditpost tinyint(1) NOT NULL DEFAULT '0',
alloweditpoll tinyint(1) NOT NULL DEFAULT '0',
allowstickthread tinyint(1) NOT NULL DEFAULT '0',
allowmodpost tinyint(1) NOT NULL DEFAULT '0',
allowdelpost tinyint(1) NOT NULL DEFAULT '0',
allowmassprune tinyint(1) NOT NULL DEFAULT '0',
allowrefund tinyint(1) NOT NULL DEFAULT '0',
allowcensorword tinyint(1) NOT NULL DEFAULT '0',
allowviewip tinyint(1) NOT NULL DEFAULT '0',
allowbanip tinyint(1) NOT NULL DEFAULT '0',
allowedituser tinyint(1) NOT NULL DEFAULT '0',
allowmoduser tinyint(1) NOT NULL DEFAULT '0',
allowbanuser tinyint(1) NOT NULL DEFAULT '0',
allowpostannounce tinyint(1) NOT NULL DEFAULT '0',
allowviewlog tinyint(1) NOT NULL DEFAULT '0',
allowbanpost tinyint(1) NOT NULL DEFAULT '0',
disablepostctrl tinyint(1) NOT NULL DEFAULT '0',
supe_allowpushthread tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (admingid)
) TYPE=MyISAM;

INSERT INTO cdb_admingroups VALUES ('1','1','1','3','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1');
INSERT INTO cdb_admingroups VALUES ('2','1','0','2','1','1','1','1','1','1','1','1','1','1','1','1','1','1','0');
INSERT INTO cdb_admingroups VALUES ('3','1','0','1','1','1','0','0','0','1','0','0','1','1','0','0','1','1','0');

DROP TABLE IF EXISTS cdb_adminnotes;
CREATE TABLE cdb_adminnotes (
id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
admin varchar(15) NOT NULL DEFAULT '',
access tinyint(3) NOT NULL DEFAULT '0',
adminid tinyint(3) NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
expiration int(10) unsigned NOT NULL DEFAULT '0',
message text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_adminsessions;
CREATE TABLE cdb_adminsessions (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
ip char(15) NOT NULL DEFAULT '',
dateline int(10) unsigned NOT NULL DEFAULT '0',
errorcount tinyint(1) NOT NULL DEFAULT '0'
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_advertisements;
CREATE TABLE cdb_advertisements (
advid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
available tinyint(1) NOT NULL DEFAULT '0',
`type` varchar(50) NOT NULL DEFAULT '0',
displayorder tinyint(3) NOT NULL DEFAULT '0',
title varchar(50) NOT NULL DEFAULT '',
targets text NOT NULL,
parameters text NOT NULL,
`code` text NOT NULL,
starttime int(10) unsigned NOT NULL DEFAULT '0',
endtime int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (advid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_announcements;
CREATE TABLE cdb_announcements (
id smallint(6) unsigned NOT NULL AUTO_INCREMENT,
author varchar(15) NOT NULL DEFAULT '',
`subject` varchar(250) NOT NULL DEFAULT '',
`type` tinyint(1) NOT NULL DEFAULT '0',
displayorder tinyint(3) NOT NULL DEFAULT '0',
starttime int(10) unsigned NOT NULL DEFAULT '0',
endtime int(10) unsigned NOT NULL DEFAULT '0',
message text NOT NULL,
groups text NOT NULL,
PRIMARY KEY (id),
KEY timespan (starttime,endtime)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_attachments;
CREATE TABLE cdb_attachments (
aid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
pid int(10) unsigned NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
readperm tinyint(3) unsigned NOT NULL DEFAULT '0',
price smallint(6) unsigned NOT NULL DEFAULT '0',
filename char(100) NOT NULL DEFAULT '',
description char(100) NOT NULL DEFAULT '',
filetype char(50) NOT NULL DEFAULT '',
filesize int(10) unsigned NOT NULL DEFAULT '0',
attachment char(100) NOT NULL DEFAULT '',
downloads mediumint(8) NOT NULL DEFAULT '0',
isimage tinyint(1) unsigned NOT NULL DEFAULT '0',
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
thumb tinyint(1) unsigned NOT NULL DEFAULT '0',
remote tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (aid),
KEY tid (tid),
KEY pid (pid,aid),
KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_attachpaymentlog;
CREATE TABLE cdb_attachpaymentlog (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
aid mediumint(8) unsigned NOT NULL DEFAULT '0',
authorid mediumint(8) unsigned NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
amount int(10) unsigned NOT NULL DEFAULT '0',
netamount int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (aid,uid),
KEY uid (uid),
KEY authorid (authorid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_attachtypes;
CREATE TABLE cdb_attachtypes (
id smallint(6) unsigned NOT NULL AUTO_INCREMENT,
extension char(12) NOT NULL DEFAULT '',
maxsize int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_banned;
CREATE TABLE cdb_banned (
id smallint(6) unsigned NOT NULL AUTO_INCREMENT,
ip1 smallint(3) NOT NULL DEFAULT '0',
ip2 smallint(3) NOT NULL DEFAULT '0',
ip3 smallint(3) NOT NULL DEFAULT '0',
ip4 smallint(3) NOT NULL DEFAULT '0',
admin varchar(15) NOT NULL DEFAULT '',
dateline int(10) unsigned NOT NULL DEFAULT '0',
expiration int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_bbcodes;
CREATE TABLE cdb_bbcodes (
id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
available tinyint(1) NOT NULL DEFAULT '0',
tag varchar(100) NOT NULL DEFAULT '',
icon varchar(255) NOT NULL,
replacement text NOT NULL,
example varchar(255) NOT NULL DEFAULT '',
explanation text NOT NULL,
params tinyint(1) unsigned NOT NULL DEFAULT '1',
prompt text NOT NULL,
nest tinyint(3) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=4;

INSERT INTO cdb_bbcodes VALUES ('1','0','fly','bb_fly.gif','{1}','[fly]This is sample text[/fly]','使內容橫向滾動，這個效果類似 HTML 的 marquee 標籤，注意：這個效果只在 Internet Explorer 瀏覽器下有效。','1','請輸入滾動顯示的文字:','1');
INSERT INTO cdb_bbcodes VALUES ('2','0','flash','bb_flash.gif','','Flash Movie','嵌入 Flash 動畫','1','請輸入 Flash 動畫的 URL:','1');
INSERT INTO cdb_bbcodes VALUES ('3','1','qq','bb_qq.gif','','[qq]688888[/qq]','顯示 QQ 在線狀態，點這個圖標可以和他（她）聊天','1','請輸入顯示在線狀態 QQ 號碼:','1');
INSERT INTO cdb_bbcodes VALUES ('4', '0', 'sup', 'bb_sup.gif', '{1}', 'X[sup]2[/sup]', '上標', 1, '請輸入上標文字：', '1');
INSERT INTO cdb_bbcodes VALUES ('5', '0', 'sub', 'bb_sub.gif', '{1}', 'X[sub]2[/sub]', '下標', 1, '請輸入下標文字：', '1');

DROP TABLE IF EXISTS cdb_buddys;
CREATE TABLE cdb_buddys (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
buddyid mediumint(8) unsigned NOT NULL DEFAULT '0',
grade tinyint(3) unsigned NOT NULL DEFAULT '1',
dateline int(10) unsigned NOT NULL DEFAULT '0',
description char(255) NOT NULL DEFAULT '',
KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_caches;
CREATE TABLE cdb_caches (
cachename varchar(32) NOT NULL,
`type` tinyint(3) unsigned NOT NULL,
dateline int(10) unsigned NOT NULL,
expiration int(10) unsigned NOT NULL,
`data` mediumtext NOT NULL,
PRIMARY KEY (cachename),
KEY expiration (`type`,expiration)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_campaigns;
CREATE TABLE cdb_campaigns (
id mediumint(8) unsigned NOT NULL,
`type` tinyint(1) unsigned NOT NULL,
fid smallint(6) unsigned NOT NULL,
tid mediumint(8) unsigned NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0',
begintime int(10) unsigned NOT NULL,
starttime int(10) unsigned NOT NULL,
endtime int(10) unsigned NOT NULL,
expiration int(10) unsigned NOT NULL,
nextrun int(10) unsigned NOT NULL,
PRIMARY KEY (id,`type`),
KEY tid (tid),
KEY nextrun (nextrun)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_creditslog;
CREATE TABLE cdb_creditslog (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
fromto char(15) NOT NULL DEFAULT '',
sendcredits tinyint(1) NOT NULL DEFAULT '0',
receivecredits tinyint(1) NOT NULL DEFAULT '0',
send int(10) unsigned NOT NULL DEFAULT '0',
receive int(10) unsigned NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
operation char(3) NOT NULL DEFAULT '',
KEY uid (uid,dateline)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_crons;
CREATE TABLE cdb_crons (
cronid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
available tinyint(1) NOT NULL DEFAULT '0',
`type` enum('user','system') NOT NULL DEFAULT 'user',
`name` char(50) NOT NULL DEFAULT '',
filename char(50) NOT NULL DEFAULT '',
lastrun int(10) unsigned NOT NULL DEFAULT '0',
nextrun int(10) unsigned NOT NULL DEFAULT '0',
weekday tinyint(1) NOT NULL DEFAULT '0',
`day` tinyint(2) NOT NULL DEFAULT '0',
`hour` tinyint(2) NOT NULL DEFAULT '0',
`minute` char(36) NOT NULL DEFAULT '',
PRIMARY KEY (cronid),
KEY nextrun (available,nextrun)
) TYPE=MyISAM AUTO_INCREMENT=15;

INSERT INTO cdb_crons VALUES ('1','1','system','清空今日發帖數','todayposts_daily.inc.php','1170601081','1170604800','-1','-1','0','0');
INSERT INTO cdb_crons VALUES ('2','1','system','清空本月在線時間','onlinetime_monthly.inc.php','1170601081','1172678400','-1','1','0','0');
INSERT INTO cdb_crons VALUES ('3','1','system','每日數據清理','cleanup_daily.inc.php','1170601083','1170624600','-1','-1','5','30');
INSERT INTO cdb_crons VALUES ('4','1','system','生日統計與郵件祝福','birthdays_daily.inc.php','1170601084','1170604800','-1','-1','0','0');
INSERT INTO cdb_crons VALUES ('5','1','system','主題回復通知','notify_daily.inc.php','1170601084','1170622800','-1','-1','5','00');
INSERT INTO cdb_crons VALUES ('6','1','system','每日公告清理','announcements_daily.inc.php','1170601084','1170604800','-1','-1','0','0');
INSERT INTO cdb_crons VALUES ('7','1','system','限時操作清理','threadexpiries_hourly.inc.php','1170601084','1170622800','-1','-1','5','0');
INSERT INTO cdb_crons VALUES ('8','1','system','論壇推廣清理','promotions_hourly.inc.php','1170601094','1170604800','-1','-1','0','00');
INSERT INTO cdb_crons VALUES ('9','1','system','每月主題清理','cleanup_monthly.inc.php','0','1170600452','-1','1','6','00');
INSERT INTO cdb_crons VALUES ('10','1','system','每日 X-Space更新用戶','supe_daily.inc.php','0','1170600452','-1','-1','0','0');
INSERT INTO cdb_crons VALUES ('12','1','system','道具自動補貨','magics_daily.inc.php','0','1170600452','-1','-1','0','0');
INSERT INTO cdb_crons VALUES ('13','1','system','每日驗證問答更新','secqaa_daily.inc.php','0','1170600452','-1','-1','6','0');
INSERT INTO cdb_crons VALUES ('14','1','system','每日標籤更新','tags_daily.inc.php','0','1170600452','-1','-1','0','0');

DROP TABLE IF EXISTS cdb_debateposts;
CREATE TABLE cdb_debateposts (
pid int(10) unsigned NOT NULL DEFAULT '0',
stand tinyint(1) NOT NULL DEFAULT '0',
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
voters mediumint(10) unsigned NOT NULL DEFAULT '0',
voterids text NOT NULL,
PRIMARY KEY (pid),
KEY pid (pid,stand),
KEY tid (tid,uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_debates;
CREATE TABLE cdb_debates (
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
starttime int(10) unsigned NOT NULL DEFAULT '0',
endtime int(10) unsigned NOT NULL DEFAULT '0',
affirmdebaters mediumint(8) unsigned NOT NULL DEFAULT '0',
negadebaters mediumint(8) unsigned NOT NULL DEFAULT '0',
affirmvotes mediumint(8) unsigned NOT NULL DEFAULT '0',
negavotes mediumint(8) unsigned NOT NULL DEFAULT '0',
umpire varchar(15) NOT NULL DEFAULT '',
winner tinyint(1) NOT NULL DEFAULT '0',
bestdebater varchar(50) NOT NULL DEFAULT '',
affirmpoint text NOT NULL,
negapoint text NOT NULL,
umpirepoint text NOT NULL,
affirmvoterids text NOT NULL,
negavoterids text NOT NULL,
affirmreplies mediumint(8) unsigned NOT NULL,
negareplies mediumint(8) unsigned NOT NULL,
PRIMARY KEY (tid),
KEY uid (uid,starttime)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_failedlogins;
CREATE TABLE cdb_failedlogins (
ip char(15) NOT NULL DEFAULT '',
count tinyint(1) unsigned NOT NULL DEFAULT '0',
lastupdate int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (ip)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_faqs;
CREATE TABLE cdb_faqs (
id smallint(6) NOT NULL AUTO_INCREMENT,
fpid smallint(6) unsigned NOT NULL DEFAULT '0',
displayorder tinyint(3) NOT NULL DEFAULT '0',
identifier varchar(20) NOT NULL,
keyword varchar(50) NOT NULL,
title varchar(50) NOT NULL,
message text NOT NULL,
PRIMARY KEY (id),
KEY displayplay (displayorder)
) TYPE=MyISAM AUTO_INCREMENT=35;

INSERT INTO cdb_faqs VALUES ('1','0','1','','','用戶須知','');
INSERT INTO cdb_faqs VALUES ('2','1','1','','','我必須要註冊嗎？','這取決於管理員如何設置 Discuz! 論壇的用戶組權限選項，您甚至有可能必須在註冊成正式用戶後後才能瀏覽帖子。當然，在通常情況下，您至少應該是正式用戶才能發新帖和回復已有帖子。請點擊這裡免費註冊成為我們的新用戶！\\r\n強烈建議您註冊，這樣會得到很多以遊客身份無法實現的功能。');
INSERT INTO cdb_faqs VALUES ('3','1','2','login','登錄幫助','我如何登錄論壇？','如果您已經註冊成為該論壇的會員，哪麼您只要通過訪問頁面右上的登錄，進入登陸界面填寫正確的用戶名和密碼（如果您設有安全提問，請選擇正確的安全提問並輸入對應的答案），點擊「提交」即可完成登陸如果您還未註冊請點擊這裡。\r\n如果需要保持登錄，請選擇相應的 Cookie 時間，在此時間範圍內您可以不必輸入密碼而保持上次的登錄狀態。');
INSERT INTO cdb_faqs VALUES ('4','1','3','','','忘記我的登錄密碼，怎麼辦？','當您忘記了用戶登錄的密碼，您可以通過註冊時填寫的電子郵箱重新設置一個新的密碼。點擊登錄頁面中的取回密碼，按照要求填寫您的個人信息，系統將自動發送重置密碼的郵件到您註冊時填寫的 Email 信箱中。如果您的 Email 已失效或無法收到信件，請與論壇管理員聯繫。');
INSERT INTO cdb_faqs VALUES ('5','0','2','','','帖子相關操作','');
INSERT INTO cdb_faqs VALUES ('6','0','3','','','基本功能操作','');
INSERT INTO cdb_faqs VALUES ('7','0','4','','','其他相關問題','');
INSERT INTO cdb_faqs VALUES ('8','1','4','','','我如何使用個性化頭像','在控制面板中的「編輯個人資料」，有一個「頭像」的選項，可以使用論壇自帶的頭像或者自定義的頭像。');
INSERT INTO cdb_faqs VALUES ('9','1','5','','','我如何修改登錄密碼','在控制面板中的「編輯個人資料」，填寫「原密碼」，「新密碼」，「確認新密碼」。點擊「提交」，即可修改。');
INSERT INTO cdb_faqs VALUES ('10','1','6','','','我如何使用個性化簽名和暱稱','在控制面板中的「編輯個人資料」，有一個「暱稱」和「個人簽名」的選項，可以在此設置。');
INSERT INTO cdb_faqs VALUES ('11','5','1','','','我如何發表新主題','在論壇版塊中，點「新帖」，如果有權限，您可以看到有「投票，懸賞，活動，交易」，點擊即可進入功能齊全的發帖界面。\\r\n注意：一般論壇都設置為高級別的用戶組才能發佈這四類特殊主題。如發佈普通主題，直接點擊「新帖」，當然您也可以使用版塊下面的「快速發帖」發表新帖(如果此選項打開)。一般論壇都設置為需要登錄後才能發帖。');
INSERT INTO cdb_faqs VALUES ('12','5','2','','','我如何發表回復','回復有分三種：第一、貼子最下方的快速回復；第二、在您想回復的樓層點擊右下方「回復」；第三、完整回復頁面，點擊本頁「新帖」旁邊的「回復」。');
INSERT INTO cdb_faqs VALUES ('13','5','3','','','我如何編輯自己的帖子','在帖子的右下角，有編輯，回復，報告等選項，點擊編輯，就可以對帖子進行編輯。');
INSERT INTO cdb_faqs VALUES ('14','5','4','','','我如何出售購買主題','出售主題：\\r\n當您進入發貼界面後，如果您所在的用戶組有發買賣貼的權限，在「售價(金錢)」後面填寫主題的價格，這樣其他用戶在查看這個帖子的時候就需要進入交費的過程才可以查看帖子。\r\n購買主題：\\r\n瀏覽你準備購買的帖子，在帖子的相關信息的下面有[查看付款記錄] [購買主題] [返回上一頁] \r\n等鏈接，點擊「購買主題」進行購買。');
INSERT INTO cdb_faqs VALUES ('15','5','5','','','我如何出售購買附件','上傳附件一欄有個售價的輸入框，填入出售價格即可實現需要支付才可下載附件的功能。\r\n點擊帖子中[購買附件]按鈕或點擊附件的下載鏈接會跳轉至附件購買頁面，確認付款的相關信息後點提交按鈕，即可得到附件的下載權限。只需購買一次，就有該附件的永遠下載權限。');
INSERT INTO cdb_faqs VALUES ('16','5','6','','','我如何上傳附件','發表新主題的時候上傳附件，步驟為：寫完帖子標題和內容後點上傳附件右方的瀏覽，然後在本地選擇要上傳附件的具體文件名，最後點擊發表話題。\r\n發表回復的時候上傳附件，步驟為：寫完回復樓主的內容，然後點上傳附件右方的瀏覽，找到需要上傳的附件，點擊發表回復。');
INSERT INTO cdb_faqs VALUES ('17','5','7','','','我如何實現發帖時圖文混排效果','發表新主題的時候點擊上傳附件左側的「[插入]」鏈接把附件標記插入到帖子中適當的位置即可。');
INSERT INTO cdb_faqs VALUES ('18','5','8','discuzcode','Discuz!代碼','我如何使用Discuz!代碼','\r\n \r\n Discuz!代碼\r\n 效果\r\n \r\n \r\n [b]粗體文字 Abc[/b]\r\n 粗體文字 Abc\r\n \r\n \r\n [i]斜體文字 Abc[/i]\r\n 斜體文字 Abc\r\n \r\n \r\n [u]下劃線文字 Abc[/u]\r\n 下劃線文字 Abc\r\n \r\n \r\n [color=red]紅顏色[/color]\r\n 紅顏色\r\n \r\n \r\n [size=3]文字大小為 3[/size] \r\n 文字大小為 3\r\n \r\n \r\n [font=仿宋]字體為仿宋[/font] \r\n 字體為仿宋\r\n \r\n \r\n [align=Center]內容居中[/align] \r\n 內容居中\r\n \r\n \r\n [url]http://www.comsenz.com[/url]\r\n http://www.comsenz.com（超級鏈接）\r\n \r\n \r\n [url=http://www.Discuz.net]Discuz! 論壇[/url]\r\n Discuz! 論壇（超級鏈接）\r\n \r\n \r\n [email]myname@mydomain.com[/email]\r\n myname@mydomain.com（E-mail鏈接）\r\n \r\n \r\n [email=support@discuz.net]Discuz! 技術支持[/email]\r\n Discuz! 技術支持（E-mail鏈接）\r\n \r\n \r\n [quote]Discuz! Board 是由康盛創想（北京）科技有限公司開發的論壇軟件[/quote] \r\n 引用:原帖由 admin 於 2006-12-26 08:45 發表Discuz! Board 是由康盛創想（北京）科技有限公司開發的論壇軟件\r\n \r\n \r\n [code]Discuz! Board 是由康盛創想（北京）科技有限公司開發的論壇軟件[/code] \r\n 代碼:Discuz! Board 是由康盛創想（北京）科技有限公司開發的論壇軟件\r\n \r\n \r\n [hide]隱藏內容 Abc[/hide]\r\n 效果:只有當瀏覽者回復本帖時，才顯示其中的內容，否則顯示為「**** 隱藏信息跟帖後才能顯示 *****」\r\n \r\n \r\n [hide=20]隱藏內容 Abc[/hide]\r\n 效果:只有當瀏覽者積分高於 20 點時，才顯示其中的內容，否則顯示為「**** 隱藏信息積分高於 20 點才能顯示 ****」\r\n \r\n \r\n [list][*]列表項 #1[*]列表項 #2[*]列表項 #3[/list]\r\n \r\n 列表項＃1\r\n 列表項＃2\r\n 列表項＃3 \r\n \r\n \r\n \r\n [img]http://www.discuz.net/images/default/logo.gif[/img] \r\n 帖子內顯示為：\r\n \r\n \r\n [img=88,31]http://www.discuz.net/images/logo.gif[/img] \r\n 帖子內顯示為：\r\n \r\n [media=400,300,1]多媒體 URL[/media]\r\n 帖子內嵌入多媒體，寬 400 高 300 自動播放\r\n \r\n \r\n [fly]飛行的效果[/fly]\r\n 飛行的效果\r\n \r\n \r\n [flash]Flash網頁地址 [/flash] \r\n 帖子內嵌入 Flash 動畫\r\n \r\n \r\n [qq]123456789[/qq]\r\n 在帖子內顯示 QQ 在線狀態，點這個圖標可以和他（她）聊天\r\n \r\n \r\n X[sup]2[/sup]\r\n X2\r\n \r\n \r\n X[sub]2[/sub]\r\n X2\r\n \r\n \r\n');
INSERT INTO cdb_faqs VALUES ('19','6','1','','','我如何使用短消息功能','您登錄後，點擊導航欄上的短消息按鈕，即可進入短消息管理。\r\n點擊[發送短消息]按鈕，在"發送到"後輸入收信人的用戶名，填寫完標題和內容，點提交(或按 Ctrl+Enter 發送)即可發出短消息。\r\n如果要保存到發件箱，以在提交前勾選"保存到發件箱中"前的復選框。\r\n\r\n點擊收件箱可打開您的收件箱查看收到的短消息。\r\n點擊發件箱可查看保存在發件箱裡的短消息。 \r\n點擊已發送來查看對方是否已經閱讀您的短消息。 \r\n點擊搜索短消息就可通過關鍵字，發信人，收信人，搜索範圍，排序類型等一系列條件設定來找到您需要查找的短消息。 \r\n點擊導出短消息可以將自己的短消息導出htm文件保存在自己的電腦裡。 \r\n點擊忽略列表可以設定忽略人員，當這些被添加的忽略用戶給您發送短消息時將不予接收。\r\n');
INSERT INTO cdb_faqs VALUES ('20','6','2','','','我如何向好友群發短消息','登錄論壇後，點擊短消息，然後點發送短消息，如果有好友的話，好友群發後麵點擊全選，可以給所有的好友群發短消息。');
INSERT INTO cdb_faqs VALUES ('21','6','3','','','我如何查看論壇會員數據','點擊導航欄上面的會員，然後顯示的是此論壇的會員數據。註：需要論壇管理員開啟允許你查看會員資料才可看到。');
INSERT INTO cdb_faqs VALUES ('22','6','4','','','我如何使用搜索','點擊導航欄上面的搜索，輸入搜索的關鍵字並選擇一個範圍，就可以檢索到您有權限訪問論壇中的相關的帖子。');
INSERT INTO cdb_faqs VALUES ('23','6','5','','','我如何使用「我的」功能','會員必須首先登錄，沒有用戶名的請先註冊；\r\n登錄之後在論壇的左上方會出現一個「我的」的超級鏈接，點擊這個鏈接之後就可進入到有關於您的信息。');
INSERT INTO cdb_faqs VALUES ('24','7','1','','','我如何向管理員報告帖子','打開一個帖子，在帖子的右下角可以看到：「編輯」、「引用」、「報告」、「評分」、「回復」等等幾個按鈕，點擊其中的「報告」按鈕進入報告頁面，填寫好「我的意見」，單擊「報告」按鈕即可完成報告某個帖子的操作。');
INSERT INTO cdb_faqs VALUES ('25','7','2','','','我如何「打印」，「推薦」，「訂閱」，「收藏」帖子','當你瀏覽一個帖子時，在它的右上角可以看到：「打印」、「推薦」、「訂閱」、「收藏」，點擊相對應的文字連接即可完成相關的操作。');
INSERT INTO cdb_faqs VALUES ('26','7','3','','','我如何設置論壇好友','設置論壇好友有3種簡單的方法。\\r\n\r\n當您瀏覽帖子的時候可以點擊「發表時間」右側的「加為好友」設置論壇好友。\r\n當您瀏覽某用戶的個人資料時，可以點擊頭像下方的「加為好友」設置論壇好友。\r\n您也可以在控制面板中的好友列表增加您的論壇好友。\r\n');
INSERT INTO cdb_faqs VALUES ('27','7','4','','','我如何使用RSS訂閱','在論壇的首頁和進入版塊的頁面的右上角就會出現一個rss訂閱的小圖標，鼠標點擊之後將出現本站點的rss地址，你可以將此rss地址放入到你的rss閱讀器中進行訂閱。');
INSERT INTO cdb_faqs VALUES ('28','7','5','','','我如何清除Cookies','cookie是由瀏覽器保存在系統內的，在論壇的右下角提供有"清除 Cookies"的功能，點擊後即可幫您清除系統內存儲的Cookies。 \r\n以下介紹3種常用瀏覽器的Cookies清除方法(註：此方法為清除全部的Cookies,請謹慎使用)\r\n\r\nInternet Explorer: 工具（選項）內的Internet選項→常規選項卡內，IE6直接可以看到刪除Cookies的按鈕點擊即可，IE7為「瀏覽歷史記錄」選項內的刪除點擊即可清空Cookies。對於Maxthon,騰訊TT等IE核心瀏覽器一樣適用。 \r\nFireFox:工具→選項→隱私→Cookies→顯示Cookie裡可以對Cookie進行對應的刪除操作。 \r\nOpera:工具→首選項→高級→Cookies→管理Cookies即可對Cookies進行刪除的操作。\r\n');
INSERT INTO cdb_faqs VALUES ('29','7','6','','','我如何聯繫管理員','您可以通過論壇底部右下角的「聯繫我們」鏈接快速的發送郵件與我們聯繫。也可以通過管理團隊中的用戶資料發送短消息給我們。');
INSERT INTO cdb_faqs VALUES ('30','7','7','','','我如何開通個人空間','如果您有權限開通「我的個人空間」，當用戶登錄論壇以後在論壇首頁，用戶名的右方點擊開通我的個人空間，進入個人空間的申請頁面。');
INSERT INTO cdb_faqs VALUES ('31','7','8','','','我如何將自己的主題加入個人空間','如果您有權限開通「我的個人空間」，在您發表的主題上方點擊「加入個人空間」，您發表的主題以及回復都會加入到您空間的日誌裡。');
INSERT INTO cdb_faqs VALUES ('32','5','9','smilies','表情','我如何使用表情代碼','表情是一些用字符表示的表情符號，如果打開表情功能，Discuz! 會把一些符號轉換成小圖像，顯示在帖子中，更加美觀明瞭。目前支持下面這些表情：\r\n\r\n表情符號\r\n對應圖像\r\n\r\n\r\n:)\r\n\r\n\r\n\r\n:(\r\n\r\n\r\n\r\n:D\r\n\r\n\r\n\r\n:\\\'(\r\n\r\n\r\n\r\n:@\r\n\r\n\r\n\r\n:o\r\n\r\n\r\n\r\n:P\r\n\r\n\r\n\r\n:$\r\n\r\n\r\n\r\n;P\r\n\r\n\r\n\r\n:L\r\n\r\n\r\n\r\n:Q\r\n\r\n\r\n\r\n:lol\r\n\r\n\r\n\r\n:hug:\r\n\r\n\r\n\r\n:victory:\r\n\r\n\r\n\r\n:time:\r\n\r\n\r\n\r\n:kiss:\r\n\r\n\r\n\r\n:handshake\r\n\r\n\r\n\r\n:call:\r\n\r\n\r\n\r\n\r\n');
INSERT INTO cdb_faqs VALUES ('33','0','5','','','論壇高級功能使用','');
INSERT INTO cdb_faqs VALUES ('34','33','0','forwardmessagelist','','論壇快速跳轉關鍵字列表','Discuz! 支持自定義快速跳轉頁面，當某些操作完成後，可以不顯示提示信息，直接跳轉到新的頁面，從而方便用戶進行下一步操作，避免等待。在實際使用當中，您根據需要，把關鍵字添加到快速跳轉設置裡面(後台 -- 基本設置 -- 界面與顯示方式 -- [提示信息跳轉設置 ])，讓某些信息不顯示而實現快速跳轉。以下是 Discuz! 當中的一些常用信息的關鍵字:\r\n\r\n\r\n\r\n \r\n 關鍵字\r\n 提示信息頁面或者作用\r\n \r\n \r\n login_succeed\r\n 登錄成功\r\n \r\n \r\n logout_succeed\r\n 退出登錄成功\r\n \r\n \r\n thread_poll_succeed\r\n 投票成功\r\n \r\n \r\n thread_rate_succeed\r\n 評分成功\r\n \r\n \r\n register_succeed\r\n 註冊成功\r\n \r\n \r\n usergroups_join_succeed\r\n 加入擴展組成功\r\n \r\n \r\n usergroups_exit_succeed\r\n 退出擴展組成功\r\n \r\n \r\n usergroups_update_succeed\r\n 更新擴展組成功\r\n \r\n \r\n buddy_update_succeed\r\n 好友更新成功\r\n \r\n \r\n post_edit_succeed\r\n 編輯帖子成功\r\n \r\n \r\n post_edit_delete_succeed\r\n 刪除帖子成功\r\n \r\n \r\n post_reply_succeed\r\n 回復成功\r\n \r\n \r\n post_newthread_succeed\r\n 發表新主題成功\r\n \r\n \r\n post_reply_blog_succeed\r\n 文集評論發表成功\r\n \r\n \r\n post_newthread_blog_succeed\r\n blog 發表成功\r\n \r\n \r\n profile_avatar_succeed\r\n 頭像設置成功\r\n \r\n \r\n profile_succeed\r\n 個人資料更新成功\r\n \r\n \r\n pm_send_succeed\r\n 短消息發送成功\r\n \r\n \r\n \r\n pm_delete_succeed\r\n 短消息刪除成功\r\n \r\n \r\n \r\n pm_ignore_succeed\r\n 短消息忽略列表更新\r\n \r\n \r\n admin_succeed\r\n 管理操作成功〔注意：設置此關鍵字後，所有管理操作完畢都將直接跳轉〕\r\n \r\n \r\n admin_succeed_next \r\n 管理成功並將跳轉到下一個管理動作\r\n \r\n \r\n search_redirect\r\n 搜索完成，進入搜索結果列表\r\n \r\n');

DROP TABLE IF EXISTS cdb_favorites;
CREATE TABLE cdb_favorites (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
fid smallint(6) unsigned NOT NULL DEFAULT '0',
KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_forumfields;
CREATE TABLE cdb_forumfields (
fid smallint(6) unsigned NOT NULL DEFAULT '0',
description text NOT NULL,
`password` varchar(12) NOT NULL DEFAULT '',
icon varchar(255) NOT NULL DEFAULT '',
postcredits varchar(255) NOT NULL DEFAULT '',
replycredits varchar(255) NOT NULL DEFAULT '',
getattachcredits varchar(255) NOT NULL DEFAULT '',
postattachcredits varchar(255) NOT NULL DEFAULT '',
digestcredits varchar(255) NOT NULL DEFAULT '',
redirect varchar(255) NOT NULL DEFAULT '',
attachextensions varchar(255) NOT NULL DEFAULT '',
formulaperm text NOT NULL,
moderators text NOT NULL,
rules text NOT NULL,
threadtypes text NOT NULL,
viewperm text NOT NULL,
postperm text NOT NULL,
replyperm text NOT NULL,
getattachperm text NOT NULL,
postattachperm text NOT NULL,
keywords text NOT NULL,
supe_pushsetting text NOT NULL,
modrecommend text NOT NULL,
tradetypes text NOT NULL,
typemodels mediumtext NOT NULL,
PRIMARY KEY (fid)
) TYPE=MyISAM;

INSERT INTO cdb_forumfields VALUES ('1','','','','','','','','','','','','','','','','','','','','','','','','');
INSERT INTO cdb_forumfields VALUES ('2','','','','','','','','','','','','','','','','','','','','','','','','');

DROP TABLE IF EXISTS cdb_forumlinks;
CREATE TABLE cdb_forumlinks (
id smallint(6) unsigned NOT NULL AUTO_INCREMENT,
displayorder tinyint(3) NOT NULL DEFAULT '0',
`name` varchar(100) NOT NULL DEFAULT '',
url varchar(100) NOT NULL DEFAULT '',
description mediumtext NOT NULL,
logo varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=2;

INSERT INTO cdb_forumlinks VALUES ('1','0','Discuz! 官方論壇','http://www.discuz.com','提供最新 Discuz! 產品新聞、軟件下載與技術交流','images/logo.gif');

DROP TABLE IF EXISTS cdb_forumrecommend;
CREATE TABLE cdb_forumrecommend (
fid smallint(6) unsigned NOT NULL,
tid mediumint(8) unsigned NOT NULL,
displayorder tinyint(1) NOT NULL,
`subject` char(80) NOT NULL,
author char(15) NOT NULL,
authorid mediumint(8) NOT NULL,
moderatorid mediumint(8) NOT NULL,
expiration int(10) unsigned NOT NULL,
PRIMARY KEY (tid),
KEY displayorder (fid,displayorder)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_forums;
CREATE TABLE cdb_forums (
fid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
fup smallint(6) unsigned NOT NULL DEFAULT '0',
`type` enum('group','forum','sub') NOT NULL DEFAULT 'forum',
`name` char(50) NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT '0',
displayorder tinyint(3) NOT NULL DEFAULT '0',
styleid smallint(6) unsigned NOT NULL DEFAULT '0',
threads mediumint(8) unsigned NOT NULL DEFAULT '0',
posts mediumint(8) unsigned NOT NULL DEFAULT '0',
todayposts mediumint(8) unsigned NOT NULL DEFAULT '0',
lastpost char(110) NOT NULL DEFAULT '',
allowsmilies tinyint(1) NOT NULL DEFAULT '0',
allowhtml tinyint(1) NOT NULL DEFAULT '0',
allowbbcode tinyint(1) NOT NULL DEFAULT '0',
allowimgcode tinyint(1) NOT NULL DEFAULT '0',
allowmediacode tinyint(1) NOT NULL DEFAULT '0',
allowanonymous tinyint(1) NOT NULL DEFAULT '0',
allowshare tinyint(1) NOT NULL DEFAULT '0',
allowpostspecial smallint(6) unsigned NOT NULL DEFAULT '0',
allowspecialonly tinyint(1) unsigned NOT NULL DEFAULT '0',
alloweditrules tinyint(1) NOT NULL DEFAULT '0',
recyclebin tinyint(1) NOT NULL DEFAULT '0',
modnewposts tinyint(1) NOT NULL DEFAULT '0',
jammer tinyint(1) NOT NULL DEFAULT '0',
disablewatermark tinyint(1) NOT NULL DEFAULT '0',
inheritedmod tinyint(1) NOT NULL DEFAULT '0',
autoclose smallint(6) NOT NULL DEFAULT '0',
forumcolumns tinyint(3) unsigned NOT NULL DEFAULT '0',
threadcaches tinyint(1) NOT NULL DEFAULT '0',
allowpaytoauthor tinyint(1) unsigned NOT NULL DEFAULT '1',
alloweditpost tinyint(1) unsigned NOT NULL DEFAULT '1',
`simple` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (fid),
KEY forum (`status`,`type`,displayorder),
KEY fup (fup)
) TYPE=MyISAM AUTO_INCREMENT=3;

INSERT INTO cdb_forums VALUES ('1','0','group','Discuz!','1','0','0','0','0','0','','0','0','1','1','1','0','1','63','0','0','0','0','0','0','0','0','0','0','1','1','0');
INSERT INTO cdb_forums VALUES ('2','1','forum','默認版塊','1','0','0','0','0','0','','1','0','1','1','1','0','1','63','0','0','0','0','0','0','0','0','0','0','1','1','0');

DROP TABLE IF EXISTS cdb_imagetypes;
CREATE TABLE cdb_imagetypes (
typeid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` char(20) NOT NULL,
`type` enum('smiley','icon','avatar') NOT NULL DEFAULT 'smiley',
displayorder tinyint(3) NOT NULL DEFAULT '0',
`directory` char(100) NOT NULL,
PRIMARY KEY (typeid)
) TYPE=MyISAM;

INSERT INTO cdb_imagetypes VALUES ('1','默認表情','smiley','1','default');

DROP TABLE IF EXISTS cdb_invites;
CREATE TABLE cdb_invites (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
expiration int(10) unsigned NOT NULL DEFAULT '0',
inviteip char(15) NOT NULL,
invitecode char(16) NOT NULL,
reguid mediumint(8) unsigned NOT NULL DEFAULT '0',
regdateline int(10) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '1',
KEY uid (uid,`status`),
KEY invitecode (invitecode)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_itempool;
CREATE TABLE cdb_itempool (
id smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`type` tinyint(1) unsigned NOT NULL,
question text NOT NULL,
answer varchar(50) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=1;

DROP TABLE IF EXISTS cdb_magiclog;
CREATE TABLE cdb_magiclog (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
magicid smallint(6) unsigned NOT NULL DEFAULT '0',
`action` tinyint(1) NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
amount smallint(6) unsigned NOT NULL DEFAULT '0',
price mediumint(8) unsigned NOT NULL DEFAULT '0',
targettid mediumint(8) unsigned NOT NULL DEFAULT '0',
targetpid int(10) unsigned NOT NULL DEFAULT '0',
targetuid mediumint(8) unsigned NOT NULL DEFAULT '0',
KEY uid (uid,dateline),
KEY targetuid (targetuid,dateline)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_magicmarket;
CREATE TABLE cdb_magicmarket (
mid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
magicid smallint(6) unsigned NOT NULL DEFAULT '0',
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
username char(15) NOT NULL,
price mediumint(8) unsigned NOT NULL DEFAULT '0',
num smallint(6) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (mid),
KEY num (magicid,num),
KEY price (magicid,price),
KEY uid (uid)
) TYPE=MyISAM AUTO_INCREMENT=1;

DROP TABLE IF EXISTS cdb_magics;
CREATE TABLE cdb_magics (
magicid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
available tinyint(1) NOT NULL DEFAULT '0',
`type` tinyint(3) NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL,
identifier varchar(40) NOT NULL,
description varchar(255) NOT NULL,
displayorder tinyint(3) NOT NULL DEFAULT '0',
price mediumint(8) unsigned NOT NULL DEFAULT '0',
num smallint(6) unsigned NOT NULL DEFAULT '0',
salevolume smallint(6) unsigned NOT NULL DEFAULT '0',
supplytype tinyint(1) NOT NULL DEFAULT '0',
supplynum smallint(6) unsigned NOT NULL DEFAULT '0',
weight tinyint(3) unsigned NOT NULL DEFAULT '1',
filename varchar(50) NOT NULL,
magicperm text NOT NULL,
PRIMARY KEY (magicid),
UNIQUE KEY identifier (identifier),
KEY displayorder (available,displayorder)
) TYPE=MyISAM AUTO_INCREMENT=13;

INSERT INTO cdb_magics VALUES ('1','1','1','變色卡','CCK','可以變換主題的顏色,並保存24小時','0','10','999','0','0','0','20','magic_color.inc.php','');
INSERT INTO cdb_magics VALUES ('2','1','3','金錢卡','MOK','可以隨機獲得一些金幣','0','10','999','0','0','0','30','magic_money.inc.php','');
INSERT INTO cdb_magics VALUES ('3','1','1','IP卡','SEK','可以查看帖子作者的IP','0','15','999','0','0','0','30','magic_see.inc.php','');
INSERT INTO cdb_magics VALUES ('4','1','1','提升卡','UPK','可以提升某個主題','0','10','999','0','0','0','30','magic_up.inc.php','');
INSERT INTO cdb_magics VALUES ('5','1','1','置頂卡','TOK','可以將主題置頂24小時','0','20','999','0','0','0','40','magic_top.inc.php','');
INSERT INTO cdb_magics VALUES ('6','1','1','悔悟卡','REK','可以刪除自己的帖子','0','10','999','0','0','0','30','magic_del.inc.php','');
INSERT INTO cdb_magics VALUES ('7','1','2','狗仔卡','RTK','查看某個用戶是否在線','0','15','999','0','0','0','30','magic_reporter.inc.php','');
INSERT INTO cdb_magics VALUES ('8','1','1','沉默卡','CLK','24小時內不能回復','0','15','999','0','0','0','30','magic_close.inc.php','');
INSERT INTO cdb_magics VALUES ('9','1','1','喧囂卡','OPK','使貼子可以回復','0','15','999','0','0','0','30','magic_open.inc.php','');
INSERT INTO cdb_magics VALUES ('10','1','1','隱身卡','YSK','可以將自己的帖子匿名','0','20','999','0','0','0','30','magic_hidden.inc.php','');
INSERT INTO cdb_magics VALUES ('11','1','1','恢復卡','CBK','將匿名恢復為正常顯示的用戶名,匿名終結者','0','15','999','0','0','0','20','magic_renew.inc.php','');
INSERT INTO cdb_magics VALUES ('12','1','1','移動卡','MVK','可將自已的帖子移動到其他版面（隱含、特殊限定版面除外）','0','50','989','0','0','0','50','magic_move.inc.php','');

DROP TABLE IF EXISTS cdb_medals;
CREATE TABLE cdb_medals (
medalid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
available tinyint(1) NOT NULL DEFAULT '0',
image varchar(30) NOT NULL DEFAULT '',
PRIMARY KEY (medalid)
) TYPE=MyISAM AUTO_INCREMENT=11;

INSERT INTO cdb_medals VALUES ('1','Medal No.1','0','medal1.gif');
INSERT INTO cdb_medals VALUES ('2','Medal No.2','0','medal2.gif');
INSERT INTO cdb_medals VALUES ('3','Medal No.3','0','medal3.gif');
INSERT INTO cdb_medals VALUES ('4','Medal No.4','0','medal4.gif');
INSERT INTO cdb_medals VALUES ('5','Medal No.5','0','medal5.gif');
INSERT INTO cdb_medals VALUES ('6','Medal No.6','0','medal6.gif');
INSERT INTO cdb_medals VALUES ('7','Medal No.7','0','medal7.gif');
INSERT INTO cdb_medals VALUES ('8','Medal No.8','0','medal8.gif');
INSERT INTO cdb_medals VALUES ('9','Medal No.9','0','medal9.gif');
INSERT INTO cdb_medals VALUES ('10','Medal No.10','0','medal10.gif');

DROP TABLE IF EXISTS cdb_memberfields;
CREATE TABLE cdb_memberfields (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
nickname varchar(30) NOT NULL DEFAULT '',
site varchar(75) NOT NULL DEFAULT '',
alipay varchar(50) NOT NULL DEFAULT '',
icq varchar(12) NOT NULL DEFAULT '',
qq varchar(12) NOT NULL DEFAULT '',
yahoo varchar(40) NOT NULL DEFAULT '',
msn varchar(40) NOT NULL DEFAULT '',
taobao varchar(40) NOT NULL DEFAULT '',
location varchar(30) NOT NULL DEFAULT '',
customstatus varchar(30) NOT NULL DEFAULT '',
medals varchar(255) NOT NULL DEFAULT '',
avatar varchar(255) NOT NULL DEFAULT '',
avatarwidth tinyint(3) unsigned NOT NULL DEFAULT '0',
avatarheight tinyint(3) unsigned NOT NULL DEFAULT '0',
bio text NOT NULL,
sightml text NOT NULL,
ignorepm text NOT NULL,
groupterms text NOT NULL,
authstr varchar(20) NOT NULL DEFAULT '',
spacename varchar(40) NOT NULL,
buyercredit smallint(6) NOT NULL DEFAULT '0',
sellercredit smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (uid)
) TYPE=MyISAM;

INSERT INTO cdb_memberfields VALUES ('1','','','','','','','','','','','','','0','0','','','','','','','0','0');

DROP TABLE IF EXISTS cdb_membermagics;
CREATE TABLE cdb_membermagics (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
magicid smallint(6) unsigned NOT NULL DEFAULT '0',
num smallint(6) unsigned NOT NULL DEFAULT '0',
KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_members;
CREATE TABLE cdb_members (
uid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
username char(15) NOT NULL DEFAULT '',
`password` char(32) NOT NULL DEFAULT '',
secques char(8) NOT NULL DEFAULT '',
gender tinyint(1) NOT NULL DEFAULT '0',
adminid tinyint(1) NOT NULL DEFAULT '0',
groupid smallint(6) unsigned NOT NULL DEFAULT '0',
groupexpiry int(10) unsigned NOT NULL DEFAULT '0',
extgroupids char(20) NOT NULL DEFAULT '',
regip char(15) NOT NULL DEFAULT '',
regdate int(10) unsigned NOT NULL DEFAULT '0',
lastip char(15) NOT NULL DEFAULT '',
lastvisit int(10) unsigned NOT NULL DEFAULT '0',
lastactivity int(10) unsigned NOT NULL DEFAULT '0',
lastpost int(10) unsigned NOT NULL DEFAULT '0',
posts mediumint(8) unsigned NOT NULL DEFAULT '0',
digestposts smallint(6) unsigned NOT NULL DEFAULT '0',
oltime smallint(6) unsigned NOT NULL DEFAULT '0',
pageviews mediumint(8) unsigned NOT NULL DEFAULT '0',
credits int(10) NOT NULL DEFAULT '0',
extcredits1 int(10) NOT NULL DEFAULT '0',
extcredits2 int(10) NOT NULL DEFAULT '0',
extcredits3 int(10) NOT NULL DEFAULT '0',
extcredits4 int(10) NOT NULL DEFAULT '0',
extcredits5 int(10) NOT NULL DEFAULT '0',
extcredits6 int(10) NOT NULL DEFAULT '0',
extcredits7 int(10) NOT NULL DEFAULT '0',
extcredits8 int(10) NOT NULL DEFAULT '0',
email char(40) NOT NULL DEFAULT '',
bday date NOT NULL DEFAULT '0000-00-00',
sigstatus tinyint(1) NOT NULL DEFAULT '0',
tpp tinyint(3) unsigned NOT NULL DEFAULT '0',
ppp tinyint(3) unsigned NOT NULL DEFAULT '0',
styleid smallint(6) unsigned NOT NULL DEFAULT '0',
dateformat tinyint(1) NOT NULL DEFAULT '0',
timeformat tinyint(1) NOT NULL DEFAULT '0',
pmsound tinyint(1) NOT NULL DEFAULT '0',
showemail tinyint(1) NOT NULL DEFAULT '0',
newsletter tinyint(1) NOT NULL DEFAULT '0',
invisible tinyint(1) NOT NULL DEFAULT '0',
timeoffset char(4) NOT NULL DEFAULT '',
newpm tinyint(1) NOT NULL DEFAULT '0',
accessmasks tinyint(1) NOT NULL DEFAULT '0',
editormode tinyint(1) unsigned NOT NULL DEFAULT '2',
customshow tinyint(1) unsigned NOT NULL DEFAULT '26',
xspacestatus tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (uid),
UNIQUE KEY username (username),
KEY email (email),
KEY groupid (groupid)
) TYPE=MyISAM AUTO_INCREMENT=2;

INSERT INTO cdb_members VALUES ('1','admin','21232f297a57a5a743894a0e4a801fc3','','0','1','1','0','','hidden','1170596852','127.0.0.1','0','1170597433','1170596852','0','0','1','0','0','0','0','0','0','0','0','0','0','name@domain.com','0000-00-00','0','0','0','0','','0','0','1','1','0','9999','0','0','2','26','0');

DROP TABLE IF EXISTS cdb_memberspaces;
CREATE TABLE cdb_memberspaces (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
style char(20) NOT NULL,
description char(100) NOT NULL,
layout char(200) NOT NULL,
side tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_moderators;
CREATE TABLE cdb_moderators (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
fid smallint(6) unsigned NOT NULL DEFAULT '0',
displayorder tinyint(3) NOT NULL DEFAULT '0',
inherited tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (uid,fid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_modworks;
CREATE TABLE cdb_modworks (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
modaction char(3) NOT NULL DEFAULT '',
dateline date NOT NULL DEFAULT '2006-01-01',
count smallint(6) unsigned NOT NULL DEFAULT '0',
posts smallint(6) unsigned NOT NULL DEFAULT '0',
KEY uid (uid,dateline)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_myposts;
CREATE TABLE cdb_myposts (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
pid int(10) unsigned NOT NULL DEFAULT '0',
position smallint(6) unsigned NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
special tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (uid,tid),
KEY tid (tid,dateline)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_mythreads;
CREATE TABLE cdb_mythreads (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
special tinyint(1) unsigned NOT NULL DEFAULT '0',
dateline int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (uid,tid),
KEY tid (tid,dateline)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_onlinelist;
CREATE TABLE cdb_onlinelist (
groupid smallint(6) unsigned NOT NULL DEFAULT '0',
displayorder tinyint(3) NOT NULL DEFAULT '0',
title varchar(30) NOT NULL DEFAULT '',
url varchar(30) NOT NULL DEFAULT ''
) TYPE=MyISAM;

INSERT INTO cdb_onlinelist VALUES ('1','1','管理員','online_admin.gif');
INSERT INTO cdb_onlinelist VALUES ('2','2','超級版主','online_supermod.gif');
INSERT INTO cdb_onlinelist VALUES ('3','3','版主','online_moderator.gif');
INSERT INTO cdb_onlinelist VALUES ('0','4','會員','online_member.gif');

DROP TABLE IF EXISTS cdb_onlinetime;
CREATE TABLE cdb_onlinetime (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
thismonth smallint(6) unsigned NOT NULL DEFAULT '0',
total mediumint(8) unsigned NOT NULL DEFAULT '0',
lastupdate int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (uid)
) TYPE=MyISAM;

INSERT INTO cdb_onlinetime VALUES ('1','10','60','1170601084');

DROP TABLE IF EXISTS cdb_orders;
CREATE TABLE cdb_orders (
orderid char(32) NOT NULL DEFAULT '',
`status` char(3) NOT NULL DEFAULT '',
buyer char(50) NOT NULL DEFAULT '',
admin char(15) NOT NULL DEFAULT '',
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
amount int(10) unsigned NOT NULL DEFAULT '0',
price float(7,2) unsigned NOT NULL DEFAULT '0.00',
submitdate int(10) unsigned NOT NULL DEFAULT '0',
confirmdate int(10) unsigned NOT NULL DEFAULT '0',
UNIQUE KEY orderid (orderid),
KEY submitdate (submitdate),
KEY uid (uid,submitdate)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_paymentlog;
CREATE TABLE cdb_paymentlog (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
authorid mediumint(8) unsigned NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
amount int(10) unsigned NOT NULL DEFAULT '0',
netamount int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (tid,uid),
KEY uid (uid),
KEY authorid (authorid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_pluginhooks;
CREATE TABLE cdb_pluginhooks (
pluginhookid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
pluginid smallint(6) unsigned NOT NULL DEFAULT '0',
available tinyint(1) NOT NULL DEFAULT '0',
title varchar(255) NOT NULL DEFAULT '',
description mediumtext NOT NULL,
`code` mediumtext NOT NULL,
PRIMARY KEY (pluginhookid),
KEY pluginid (pluginid),
KEY available (available)
) TYPE=MyISAM AUTO_INCREMENT=1;

DROP TABLE IF EXISTS cdb_plugins;
CREATE TABLE cdb_plugins (
pluginid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
available tinyint(1) NOT NULL DEFAULT '0',
adminid tinyint(1) unsigned NOT NULL DEFAULT '0',
`name` varchar(40) NOT NULL DEFAULT '',
identifier varchar(40) NOT NULL DEFAULT '',
description varchar(255) NOT NULL DEFAULT '',
datatables varchar(255) NOT NULL DEFAULT '',
`directory` varchar(100) NOT NULL DEFAULT '',
copyright varchar(100) NOT NULL DEFAULT '',
modules text NOT NULL,
PRIMARY KEY (pluginid),
UNIQUE KEY identifier (identifier)
) TYPE=MyISAM AUTO_INCREMENT=1;

DROP TABLE IF EXISTS cdb_pluginvars;
CREATE TABLE cdb_pluginvars (
pluginvarid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
pluginid smallint(6) unsigned NOT NULL DEFAULT '0',
displayorder tinyint(3) NOT NULL DEFAULT '0',
title varchar(100) NOT NULL DEFAULT '',
description varchar(255) NOT NULL DEFAULT '',
variable varchar(40) NOT NULL DEFAULT '',
`type` varchar(20) NOT NULL DEFAULT 'text',
`value` text NOT NULL,
extra text NOT NULL,
PRIMARY KEY (pluginvarid),
KEY pluginid (pluginid)
) TYPE=MyISAM AUTO_INCREMENT=1;

DROP TABLE IF EXISTS cdb_pms;
CREATE TABLE cdb_pms (
pmid int(10) unsigned NOT NULL AUTO_INCREMENT,
msgfrom varchar(15) NOT NULL DEFAULT '',
msgfromid mediumint(8) unsigned NOT NULL DEFAULT '0',
msgtoid mediumint(8) unsigned NOT NULL DEFAULT '0',
folder enum('inbox','outbox') NOT NULL DEFAULT 'inbox',
`new` tinyint(1) NOT NULL DEFAULT '0',
`subject` varchar(75) NOT NULL DEFAULT '',
dateline int(10) unsigned NOT NULL DEFAULT '0',
message text NOT NULL,
delstatus tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (pmid),
KEY msgtoid (msgtoid,folder,dateline),
KEY msgfromid (msgfromid,folder,dateline)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_pmsearchindex;
CREATE TABLE cdb_pmsearchindex (
searchid int(10) unsigned NOT NULL AUTO_INCREMENT,
keywords varchar(255) NOT NULL DEFAULT '',
searchstring varchar(255) NOT NULL DEFAULT '',
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
expiration int(10) unsigned NOT NULL DEFAULT '0',
pms smallint(6) unsigned NOT NULL DEFAULT '0',
pmids text NOT NULL,
PRIMARY KEY (searchid)
) TYPE=MyISAM AUTO_INCREMENT=1;

DROP TABLE IF EXISTS cdb_polloptions;
CREATE TABLE cdb_polloptions (
polloptionid int(10) unsigned NOT NULL AUTO_INCREMENT,
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
votes mediumint(8) unsigned NOT NULL DEFAULT '0',
displayorder tinyint(3) NOT NULL DEFAULT '0',
polloption varchar(80) NOT NULL DEFAULT '',
voterids mediumtext NOT NULL,
PRIMARY KEY (polloptionid),
KEY tid (tid,displayorder)
) TYPE=MyISAM AUTO_INCREMENT=1;

DROP TABLE IF EXISTS cdb_polls;
CREATE TABLE cdb_polls (
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
multiple tinyint(1) NOT NULL DEFAULT '0',
visible tinyint(1) NOT NULL DEFAULT '0',
maxchoices tinyint(3) unsigned NOT NULL DEFAULT '0',
expiration int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (tid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_posts;
CREATE TABLE cdb_posts (
pid int(10) unsigned NOT NULL AUTO_INCREMENT,
fid smallint(6) unsigned NOT NULL DEFAULT '0',
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
`first` tinyint(1) NOT NULL DEFAULT '0',
author varchar(15) NOT NULL DEFAULT '',
authorid mediumint(8) unsigned NOT NULL DEFAULT '0',
`subject` varchar(80) NOT NULL DEFAULT '',
dateline int(10) unsigned NOT NULL DEFAULT '0',
message mediumtext NOT NULL,
useip varchar(15) NOT NULL DEFAULT '',
invisible tinyint(1) NOT NULL DEFAULT '0',
anonymous tinyint(1) NOT NULL DEFAULT '0',
usesig tinyint(1) NOT NULL DEFAULT '0',
htmlon tinyint(1) NOT NULL DEFAULT '0',
bbcodeoff tinyint(1) NOT NULL DEFAULT '0',
smileyoff tinyint(1) NOT NULL DEFAULT '0',
parseurloff tinyint(1) NOT NULL DEFAULT '0',
attachment tinyint(1) NOT NULL DEFAULT '0',
rate smallint(6) NOT NULL DEFAULT '0',
ratetimes tinyint(3) unsigned NOT NULL DEFAULT '0',
status tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (pid),
KEY fid (fid),
KEY authorid (authorid),
KEY dateline (dateline),
KEY invisible (invisible),
KEY displayorder (tid,invisible,dateline),
KEY `first` (tid,`first`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_profilefields;
CREATE TABLE cdb_profilefields (
fieldid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
available tinyint(1) NOT NULL DEFAULT '0',
invisible tinyint(1) NOT NULL DEFAULT '0',
title varchar(50) NOT NULL DEFAULT '',
description varchar(255) NOT NULL DEFAULT '',
size tinyint(3) unsigned NOT NULL DEFAULT '0',
displayorder smallint(6) NOT NULL DEFAULT '0',
required tinyint(1) NOT NULL DEFAULT '0',
unchangeable tinyint(1) NOT NULL DEFAULT '0',
showinthread tinyint(1) NOT NULL DEFAULT '0',
selective tinyint(1) NOT NULL DEFAULT '0',
choices text NOT NULL,
PRIMARY KEY (fieldid),
KEY available (available,required,displayorder)

) TYPE=MyISAM AUTO_INCREMENT=1;

DROP TABLE IF EXISTS cdb_projects;
CREATE TABLE cdb_projects (
id smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`type` varchar(10) NOT NULL,
description varchar(255) NOT NULL,
`value` mediumtext NOT NULL,
PRIMARY KEY (id),
KEY `type` (`type`)
) TYPE=MyISAM AUTO_INCREMENT=12;

INSERT INTO cdb_projects VALUES ('1','技術性論壇','extcredit','如果您不希望會員通過灌水、頁面訪問等方式得到積分，而是需要發佈一些技術性的帖子獲得積分。','a:4:{s:10:\"savemethod\";a:2:{i:0;s:1:\"1\";i:1;s:1:\"2\";}s:14:\"creditsformula\";s:49:\"posts*0.5+digestposts*5+extcredits1*2+extcredits2\";s:13:\"creditspolicy\";s:299:\"a:12:{s:4:\"post\";a:0:{}s:5:\"reply\";a:0:{}s:6:\"digest\";a:1:{i:1;i:10;}s:10:\"postattach\";a:0:{}s:9:\"getattach\";a:0:{}s:2:\"pm\";a:0:{}s:6:\"search\";a:0:{}s:15:\"promotion_visit\";a:1:{i:3;i:2;}s:18:\"promotion_register\";a:1:{i:3;i:2;}s:13:\"tradefinished\";a:0:{}s:8:\"votepoll\";a:0:{}s:10:\"lowerlimit\";a:0:{}}\";s:10:\"extcredits\";s:1444:\"a:8:{i:1;a:8:{s:5:\"title\";s:4:\"威望\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:2;a:8:{s:5:\"title\";s:4:\"金錢\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:3;a:8:{s:5:\"title\";s:4:\"貢獻\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:4;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:5;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:6;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:7;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:8;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}}\";}');
INSERT INTO cdb_projects VALUES ('2','娛樂性論壇','extcredit','此類型論壇的會員可以通過發佈一些評論、回復等獲得積分，同時擴大論壇的訪問量。更重要的是希望會員發佈一些有價值的娛樂新聞等。','a:4:{s:10:\"savemethod\";a:2:{i:0;s:1:\"1\";i:1;s:1:\"2\";}s:14:\"creditsformula\";s:81:\"posts+digestposts*5+oltime*5+pageviews/1000+extcredits1*2+extcredits2+extcredits3\";s:13:\"creditspolicy\";s:315:\"a:12:{s:4:\"post\";a:1:{i:1;i:1;}s:5:\"reply\";a:1:{i:2;i:1;}s:6:\"digest\";a:1:{i:1;i:10;}s:10:\"postattach\";a:0:{}s:9:\"getattach\";a:0:{}s:2:\"pm\";a:0:{}s:6:\"search\";a:0:{}s:15:\"promotion_visit\";a:1:{i:3;i:2;}s:18:\"promotion_register\";a:1:{i:3;i:2;}s:13:\"tradefinished\";a:0:{}s:8:\"votepoll\";a:0:{}s:10:\"lowerlimit\";a:0:{}}\";s:10:\"extcredits\";s:1036:\"a:8:{i:1;a:6:{s:5:\"title\";s:4:\"威望\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;}i:2;a:6:{s:5:\"title\";s:4:\"金錢\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;}i:3;a:6:{s:5:\"title\";s:4:\"貢獻\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;}i:4;a:6:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;}i:5;a:6:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;}i:6;a:6:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;}i:7;a:6:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;}i:8;a:6:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;}}\";}');
INSERT INTO cdb_projects VALUES ('3','動漫、攝影類論壇','extcredit','此類型論壇需要更多的圖片附件發佈給廣大會員，因此增加一項擴展積分：魅力。','a:4:{s:10:\"savemethod\";a:2:{i:0;s:1:\"1\";i:1;s:1:\"2\";}s:14:\"creditsformula\";s:86:\"posts+digestposts*2+pageviews/2000+extcredits1*2+extcredits2+extcredits3+extcredits4*3\";s:13:\"creditspolicy\";s:324:\"a:12:{s:4:\"post\";a:1:{i:2;i:1;}s:5:\"reply\";a:0:{}s:6:\"digest\";a:1:{i:1;i:10;}s:10:\"postattach\";a:1:{i:4;i:3;}s:9:\"getattach\";a:1:{i:2;i:-2;}s:2:\"pm\";a:0:{}s:6:\"search\";a:0:{}s:15:\"promotion_visit\";a:1:{i:3;i:2;}s:18:\"promotion_register\";a:1:{i:3;i:2;}s:13:\"tradefinished\";a:0:{}s:8:\"votepoll\";a:0:{}s:10:\"lowerlimit\";a:0:{}}\";s:10:\"extcredits\";s:1454:\"a:8:{i:1;a:8:{s:5:\"title\";s:4:\"威望\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:2;a:8:{s:5:\"title\";s:4:\"金錢\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:3;a:8:{s:5:\"title\";s:4:\"貢獻\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:4;a:8:{s:5:\"title\";s:4:\"魅力\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:5;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:6;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:7;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:8;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}}\";}');
INSERT INTO cdb_projects VALUES ('4','文章、小說類論壇','extcredit','此類型的論壇更重視會員的原創文章或者是轉發的文章，因此增加一項擴展積分：文采。','a:4:{s:10:\"savemethod\";a:2:{i:0;s:1:\"1\";i:1;s:1:\"2\";}s:14:\"creditsformula\";s:57:\"posts+digestposts*8+extcredits2+extcredits3+extcredits4*2\";s:13:\"creditspolicy\";s:307:\"a:12:{s:4:\"post\";a:1:{i:2;i:1;}s:5:\"reply\";a:0:{}s:6:\"digest\";a:1:{i:4;i:10;}s:10:\"postattach\";a:0:{}s:9:\"getattach\";a:0:{}s:2:\"pm\";a:0:{}s:6:\"search\";a:0:{}s:15:\"promotion_visit\";a:1:{i:3;i:2;}s:18:\"promotion_register\";a:1:{i:3;i:2;}s:13:\"tradefinished\";a:0:{}s:8:\"votepoll\";a:0:{}s:10:\"lowerlimit\";a:0:{}}\";s:10:\"extcredits\";s:1454:\"a:8:{i:1;a:8:{s:5:\"title\";s:4:\"威望\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:2;a:8:{s:5:\"title\";s:4:\"金錢\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:3;a:8:{s:5:\"title\";s:4:\"貢獻\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:4;a:8:{s:5:\"title\";s:4:\"文采\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";s:1:\"1\";s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:5;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:6;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:7;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}i:8;a:8:{s:5:\"title\";s:0:\"\";s:4:\"unit\";s:0:\"\";s:5:\"ratio\";i:0;s:9:\"available\";N;s:10:\"lowerlimit\";i:0;s:12:\"showinthread\";N;s:15:\"allowexchangein\";N;s:16:\"allowexchangeout\";N;}}\";}');
INSERT INTO cdb_projects VALUES ('5','調研性論壇','extcredit','此類型論壇更期望的是得

22.06.2008 -

junjin-forever says …

ALTER DATABASE junjin-forever_junjin DEFAULT CHARACTER SET big5

17.06.2008 -

deepakanand says …

excellent !

11.06.2008 -

mikedell says …

if you dont understand you should not be programming

26.05.2008 -

ashbalsahra2 says …

verry good

17.05.2008 -

mikeboyles says …

I think it is excellent for people to follow in designing their own scripts. Well explained and useful.

10.05.2008 -

nettronik says …

Extremely Help ful

10.05.2008 -

loverlol says …

good

08.05.2008 -

kurizzu says …

i dont understant.. :(

22.04.2008 -

zinfinal says …

masomenos

16.04.2008 -

hamed6270 says …

salam be hame dosstan aziz

16.04.2008 -

hamed6270 says …

salam be hame dosstan aziz

16.04.2008 -

hamed6270 says …

gooya forum

16.04.2008 -

hamed6270 says …

gooya forum

04.04.2008 -

manhgd says …

great!

14.03.2008 -

xforumfree says …

Very good

07.03.2008 -

chullo says …

Where do i get rice and chicken?

07.03.2008 -

seeal says …

thanxz for your tutorial

07.03.2008 -

giotcafes says …

thanks very good

07.03.2008 -

fbabol says …

I think vaska94 is full of crap. Show us what you got then, smartass fool

21.02.2008 -

hunterxhunter says …

nice

20.02.2008 -

JJSSMAN says …

The best!!

20.02.2008 -

vaska94 says …

ne xuia sebe :D, this tutorial is for lamers & noobs only :D

15.02.2008 -

mahirharoon says …

but it cannot vlidate if that is a real email or not
i rember there was a tut about validating real domains (checking even mail servers) in frihost's php section as areply

12.02.2008 -

mostafatoncy says …

nice

11.02.2008 -

nikolis17 says …

@romka

md5 is an encryption algorithm used to produce a 32-character hexadecimal number from a given value (See: http://en.wikipedia.org/wiki/MD5). In the example, the PHP script is taking a user-given string supplied through the processed form and then converting it to a md5 hash with the PHP function md5( string ). This is for security reasons, as the password data needs to be stored in the database securely. The md5 hash insures that the password will remain secure (to a degree), even if the database is exploited.

For more information on using md5 with PHP, please visit the official PHP website.
http://php.net/md5

@thehealer
Read it as you would a book, from start to finish. :P Read each paragraph that describes the following code, and then review the code posted. If you are still unclear on a subject, or feel that the tutorial's poster did not elaborate enough on a subject, then please visit the official PHP site and find out more there. There's many examples and user comments on that site. Also, as a note, this code provided in the tutorial is not meant for Copy+Paste, ready-to-go use. It's simply meant to educate you, and perhaps teach you how to better secure your PHP script by applying certain measurements to validate and "sanitize" information sent via a form, which could unfortunately include injections and exploits.

08.02.2008 -

romka says …

great tuttorial but i don't understand 1 thing. if i ll use the same example as above in order to create a user validation form, can i just use the md5 as it is???
pls someone help me pls. i have to do it as soon as posible and i don't get it at all. i know md5 is about encryption. my email is r.spyridis@gmail.com if someone can help me pls e-mail me
thanks

23.01.2008 -

oblivionsources says …

Nice tutorial, definitely going to finish reading it when I get home ;D

16.01.2008 -

kingtut says …

are you sure all this are free? this is amazing man

10.01.2008 -

thehealer says …

its great i like the security of it all, but i am still not sure how to put all these bits of code together andnot sure what i should be reading

04.01.2008 -

cosme says …

selamınaleyküm şimdi
türkler bu ne iş yerıyor

28.12.2007 -

samer says …

jelly good

23.12.2007 -

nour says …

hala

09.12.2007 -

jalqamus says …

bilal كيف جالكم بدنا منتدى عربي

07.12.2007 -

Gandalf says …

de 10 ^^

05.12.2007 -

dbarasuk says …

helpful

22.11.2007 -

fayayz says …

Hello How are u Nice Zymic Service i love it a long time

06.11.2007 -

nakhee says …

31.10.2007 -

veriu says …

do you provide PHP ??!?! If you do how can i use it!?

16.10.2007 -

loscocorotes says …

esta super

16.10.2007 -

loscocorotes says …

esta super

11.10.2007 -

albra says …

Thanks
very easy explains

28.09.2007 -

pcszeng says …

Very good tutorial. Explains many things and very clear when discussing about certain aspects

20.09.2007 -

stanimir says …

Sorry for my late post :). I submit before write something...So that is fantastic I've really like it and I will used for future in my scripts!!!

19.09.2007 -

MrCracker says …

Good stuff.

Tutorial statistics

Date added:

25.08.2007

Author:

Alex Elliott

User rating:

4/5

Rate tutorial:

Total views:

55035

Total comments:

Zymic

Follow us on Twitter!

PHP & MySQL

Free Tutorials » PHP & MySQL » Sanitisation and Validation in PHP