Pełna wersja: Unofficial modifications

**ToxicMan** Wysłany: Nie 21 Sty, 2007

Witam mam jedno pytanie bo tego nie rozumiem i nie wiem gdzie to da? ot?? co mam zrobi? z tym doda?em now? tabele lecz nie wiem o co chodzi z tym:

-- 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]{TEXT}', '<b>{TEXT}</b>', '', 0, 1, 0, '', 0, 0, 1),
(2, '', '[i]{TEXT}', '<i>{TEXT}</i>', '', 0, 1, 0, '', 0, 0, 1),
(3, '', '[u]{TEXT}', '<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, '[code]', '[code]{TEXT}[/code]', ' </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, '

', '
{TEXT}', '', '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]{TEXT}
', '<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, '
Ukryta Wiadomo??:
Je?li jeste? *zarejestrowanym u?ytkownikiem* musisz odpowiedzie? w tym temacie ?eby zobaczy? t? wiadomo??
--- If you are a *registered user* : you need to post in this topic to see the message ---
', '</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, 'Go??', 'Go??', '', '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]', '
Cytat:
{TEXT}
', '</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_enhanced_bbcode', 0, 1, 0, '', 0, 0, 0);
prosz? o pomoc.

**KnofeL** Wysłany: Nie 21 Sty, 2007

LOL to jest zapytanie kt?re musisz wykona? :roll:

**ToxicMan** Wysłany: Nie 21 Sty, 2007

jak daje to zapytanie w MySQL to wyskakuj? to:

KodB??d Og?lny
Nie mog? wykona?: 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

o co z tym chodzi bo nie rozumiem.

**They** Wysłany: Nie 21 Sty, 2007

ty nie do konca wykona?e?, musisz wykona? zapytanie w ca?o?ci.. pisze to przeciez w instrukcji cale zapytania ma wykona? w bazie danych sql.

**kidzior** Wysłany: Nie 21 Sty, 2007

Przyjrzyj si? temu, co wydziel?:
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, '', '{TEXT}', '<b>{TEXT}</b>', '', 0, 1, 0, '', 0, 0, 1),
(2, '', '{TEXT}', '<i>{TEXT}</i>', '', 0, 1, 0, '', 0, 0, 1),
(3, '', '{TEXT}', '<u>{TEXT}</u>', '', 0, 1, 0, '', 0, 0, 1),
(4, '[s]', '[s]{TEXT}[/s]', '<strike>{TEXT}</strike>', '', 0, 1, 0, '', 0, 0, 1),
(5, '', '{TEXT}', '', 'size_bbcode', 0, 1, 0, '', 0, 0, 1),
(6, '', '{TEXT}', '<span style="color:{COLOR}">{TEXT}</span>', '', 0, 1, 0, '', 0, 0, 1),
(7, '', ' {QUOTED} napisał/a{TEXT}', ' </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, '

', '
{TEXT}', '', '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]{TEXT}
', '<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, '

*************************

Ukryta Wiadomo??:
Je?li jeste? *zarejestrowanym u?ytkownikiem* musisz odpowiedzie? w tym temacie ?eby zobaczy? t? wiadomo??
--- If you are a *registered user* : you need to post in this topic to see the message ---
', '</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, 'Go??', 'Go??', '', '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]', '
Cytat:
{TEXT}
', '</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_enhanced_bbcode', 0, 1, 0, '', 0, 0, 0);

[ Dodano: Nie 21 Sty, 2007 ]
Nie wida? w zawi?o?ciah, ale masz wstawione do zapytania:
KodUkryta Wiadomo??:
Je?li jeste? *zarejestrowanym u?ytkownikiem* musisz odpowiedzie? w tym temacie ?eby zobaczy? t? wiadomo??
--- If you are a *registered user* : you need to post in this topic to see the message ---
', '</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), :roll: