Zobacz temat - [Pomoc-Sql part]BBcode manager

Unofficial modifications
nieoficjalne modyfikacje for?w phpBB by Przemo

Pomoc dla modyfikacji - [Pomoc-Sql part]BBcode manager

Kuzyn - Sob 09 Cze, 2007
Temat postu: [Pomoc-Sql part]BBcode manager

Witam, na forum php by przemo ju? troch? czasu pracowa?em, ale nigdy nie bawi?em si? w modyfikacje(hacki) zainstalowa?em BearMod i chc? zainstalowa? BBcode manager ale nie mog? ruszy? z miejsca bo nie znam si? na phpMyAdmin. Pojawia si? pytanie czy kto? m?g?by wyt?umaczy? mi gdzie to wklei? dok?adnie:

Kod

--

--

--  wklej tresc tego pliku do phpMyAdmina

--

--

-- stworz nowa tabele

CREATE TABLE `phpbb_bbcode_table` (

  `bbcode_id` int(12) unsigned NOT NULL auto_increment,

  `bbcode_name` varchar(25) NOT NULL default '',

  `bbcode_in` text NOT NULL,

  `bbcode_out` text NOT NULL,

  `bbcode_func` varchar(255) NOT NULL default '',

  `bbcode_lock` tinyint(1) NOT NULL default '0',

  `bbcode_guest` tinyint(4) NOT NULL default '0',

  `bbcode_logged` tinyint(4) NOT NULL default '0',

  `bbcode_groups` varchar(255) NOT NULL default '',

  `bbcode_mod` tinyint(4) NOT NULL default '0',

  `bbcode_admin` tinyint(4) NOT NULL default '0',

  `bbcode_sig` tinyint(1) NOT NULL default '0',

  KEY `bbcode_id` (`bbcode_id`)

);

-- wypelnij tabele

INSERT INTO `phpbb_bbcode_table` (`bbcode_id`, `bbcode_name`, `bbcode_in`, `bbcode_out`, `bbcode_func`, `bbcode_lock`, `bbcode_guest`, `bbcode_logged`, `bbcode_groups`, `bbcode_mod`, `bbcode_admin`, `bbcode_sig`) VALUES (1, '[b]', '[b]{TEXT}[/b]', '<b>{TEXT}</b>', '', 0, 1, 0, '', 0, 0, 1),

(2, '[i]', '[i]{TEXT}[/i]', '<i>{TEXT}</i>', '', 0, 1, 0, '', 0, 0, 1),

(3, '[u]', '[u]{TEXT}[/u]', '<u>{TEXT}</u>', '', 0, 1, 0, '', 0, 0, 1),

(4, '[s]', '[s]{TEXT}[/s]', '<strike>{TEXT}</strike>', '', 0, 1, 0, '', 0, 0, 1),

(5, '[size]', '[size={SIZE}]{TEXT}[/size]', '', 'size_bbcode', 0, 1, 0, '', 0, 0, 1),

(6, '[color=]', '[color={COLOR}]{TEXT}[/color]', '<span style="color:{COLOR}">{TEXT}</span>', '', 0, 1, 0, '', 0, 0, 1),

(7, '[quote=]', '[quote={QUOTED}]{TEXT}[/quote]', ' </span><table style="background-color: white;color: #000000;border: 1px solid #a9b8c2;" width="90%" align="center" cellspacing="0" cellpadding="4"><tr><td><b>{QUOTED} {LANG_wrote}</b></td></tr><tr><td>{TEXT}</td></tr></table><span class="postbody">', '', 0, 1, 0, '', 0, 0, 0),

(8, '

Kod

', '{TEXT}', ' </span><table style="background-color: white;color:black;border: 1px solid #a9b8c2; width:90%;" align="center" cellspacing="0" cellpadding="4"><tr><td><b>{LANG_Code}</b></td></tr><tr><td style="font-size: 11px;font-family: Courier New, sans-serif; color: #32a354">{TEXT}</td></tr></table><span class="postbody">', 'code_bbcode', 1, 1, 0, '', 0, 0, 0),

(9, '[php]', '[php]{TEXT}[/php]', ' </span><table style="background-color: white;color: #000000;border: 1px solid #a9b8c2; width:90%" align="center" cellspacing="0" cellpadding="4"><tr><td><b>PHP Code:</b></td></tr><tr><td><pre style="font-size: 11px;font-family: Courier New, sans-serif;vertical-align: top;width: 100%" width="85%">{TEXT}<br /> </pre></td></tr></table><span class="postbody">', 'php_tag_bbcode', 1, 1, 0, '', 0, 0, 0),

(10, '[list]', '[list]{TEXT}[/list]', '', 'list_bbcode', 0, 1, 0, '', 0, 0, 0),

(11, '[img]', '[img]{IMG}[/img]', '<img src="{IMG}" alt="" border="0" onload="rmw_img_loaded(this)" />', '', 0, 1, 0, '', 0, 0, 0),

(12, '[url=]', '[url={VAL}]{TXT}[/url]', '<a href="{VAL}" target="_blank" style="text-decoration:none">{TXT}</a>', '', 0, 1, 0, '', 0, 0, 1),

(13, '[center]', '[center]{TEXT}[/center]', '<div style="text-align:center">{TEXT}</div>', '', 0, 1, 0, '', 0, 0, 1),

(14, '[right]', '[RIGHT]{TEXT}[/RIGHT]', '<div style="text-align:right">{TEXT}</div>', '', 0, 1, 0, '', 0, 0, 1),

(15, '[line]', '[line]', '<hr />', '', 0, 0, 1, '', 0, 0, 1),

(16, '[hide]', '[hide]{TEXT}[/hide]', '</span><table style="background-color: white;color: #000000;border: 1px solid #a9b8c2; width:90%" align="center" cellspacing="0" cellpadding="4"><tr><td><b>Ukryta wiadomo¶? / Hidden message</b></td></tr><tr><td>{TEXT}</td></tr></table><span class="postbody">', '', 0, 1, 0, '', 0, 0, 0),

(17, '[logged]', '[logged]{TEXT}[/logged]', ' </span><table style="background-color: white;color: #000000;border: 1px solid #a9b8c2; width:90%" align="center" cellspacing="0" cellpadding="4"><tr><td><b>{LANG_Message}</b></td></tr><tr><td>{TEXT}</td></tr></table><span class="postbody">', 'logged_bbcode', 0, 1, 0, '', 0, 0, 1),

(18, '[guest]', '[guest]{TEXT}[/guest]', ' </span><table style="background-color: white;color: #000000;border: 1px solid #a9b8c2; width:90%" align="center" cellspacing="0" cellpadding="4"><tr><td><b>{LANG_Message}</b></td></tr><tr><td>{TEXT}</td></tr></table><span class="postbody">', 'guest_bbcode', 0, 1, 0, '', 0, 0, 1),

(19, '[you]', '[you]', '', 'you_bbcode', 0, 0, 1, '', 0, 0, 1),

(20, '[url]', '[url]{URL}[/url]', '<a href="{URL}" target="_blank">{URL}</a>', '', 0, 1, 0, '', 0, 0, 1),

(21, '[quote]', '[quote]{TEXT}[/quote]', '</span><table style="background-color: white;color: #fafaef;border: 1px solid #a9b8c2;" width="90%" align="center" cellspacing="0" cellpadding="4"><tr><td><b>{LANG_Quote}</b></td></tr><tr><td>{TEXT}</td></tr></table><span class="postbody">', '', 0, 1, 0, '', 0, 0, 0),

(22, '[list=]', '[list={TYPE}]{TEXT}[/list]', '', 'list_enhanced_bbcode', 0, 1, 0, '', 0, 0, 0);

B?d? bardzo wdzi?czny

INIM - Sob 09 Cze, 2007

PA > SQL > MySQL
Nie musisz si? phpmyadminem bawi?, ale je?li b?dziesz chcia? to polecam t? lekturk?:
http://www.przemo.org/php...pic.php?t=10458

Kuzyn - Sob 09 Cze, 2007

dzi?kuje masz piwko :] prosz? o zamkni?cie :]

[ Dodano: Sob 09 Cze, 2007 ]
Kurde jak wykonuje to wyskakuje mi b??d:

Kod

Nie mog? wykona?: -- stworz nowa tabele CREATE TABLE `phpbb_bbcode_table` ( `bbcode_id` int(12) unsigned NOT NULL auto_increment, `bbcode_name` varchar(25) NOT NULL default '', `bbcode_in` text NOT NULL, `bbcode_out` text NOT NULL, `bbcode_func` varchar(255) NOT NULL default '', `bbcode_lock` tinyint(1) NOT NULL default '0', `bbcode_guest` tinyint(4) NOT NULL default '0', `bbcode_logged` tinyint(4) NOT NULL default '0', `bbcode_groups` varchar(255) NOT NULL default '', `bbcode_mod` tinyint(4) NOT NULL default '0', `bbcode_admin` tinyint(4) NOT NULL default '0', `bbcode_sig` tinyint(1) NOT NULL default '0', KEY `bbcode_id` (`bbcode_id`) )