-
Replace text in SQL
Query to replace string in SQL
1 UPDATE `table_name` SET `field_name` = replace( `field_name` , 'find this', 'replace with' ) ;
-
Template frame
Szkielet serwisu w TS
1 # MAIN CONFIGURATION
2 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/_main_config.ts3">
3
4 # ---------------------------------------------------------- #
5 # MAIN TEMPLATE ELEMENTS
6 # ---------------------------------------------------------- #
7
8 # LOGIN BOX
9 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/login_box.ts3">
10
11 # TOP MENU
12 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/top_menu.ts3">
13
14 # TAG CLOUD
15 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/tag_cloud.ts3">
16
17 # ---------------------------------------------------------- #
18
19
20 # MAIN SETUP
21 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/_main_setup.ts3">
22
23
24 # ---------------------------------------------------------- #
25 # PAGES SETUP
26 # ---------------------------------------------------------- #
27
28 # Show Article/News
29 [globalVar = TSFE:id = 27]
30
31 includeLibs.userPageBrowserFunc = fileadmin/libs/user_makePageBrowserSingle
32
33 # Warto wiedziec
34 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/warto_wiedziec.ts3">
35
36 # Article SETUP
37 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/_article.ts3">
38
39
40 [end]
41
42 # ---------------------------------------------------------- #
43
44 # Start
45 [globalVar = TSFE:id = 51]
46
47 # Warto wiedziec
48 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/warto_wiedziec.ts3">
49
50 # TAB: Multimedia
51 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/start_multimedia.ts3">
52
53 # TAB: Newsy
54 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/start_newsy.ts3">
55
56 # TAB: Nowe technologie
57 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/start_nowe_technologie.ts3">
58
59 # Spolecznosc Focusa
60 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/start_spolecznosc.ts3">
61
62 # Warto przeczytac
63 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/start_warto_przeczytac.ts3">
64
65 # Warto zobaczyc
66 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/start_warto_zobaczyc.ts3">
67
68
69 # Start SETUP
70 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/start.ts3">
71
72 page.1.subparts.CONTENT < tpl.start
73 [end]
74
75 # Newsy
76 [globalVar = TSFE:id = 24]
77
78 # Newsy SETUP
79 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/newsy.ts3">
80 page.1 {
81 subparts.CONTENT < tpl.newsy
82 }
83
84 [end]
85
86 # ARTICLES LIST: Nauka
87 [globalVar = TSFE:id = 37]
88
89 # Warto wiedziec
90 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/warto_wiedziec.ts3">
91
92 # ARTICLES LIST SETUP
93 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/_articleslist.ts3">
94
95 page.1 {
96 subparts.CONTENT < tpl.articlesList
97 subparts.CONTENT {
98 subparts.ARTICLES_LIST.categorySelection = 2
99 #subparts.ARICLES_PAGE_TITLE.value = Lorem
100 }
101 }
102
103 [end]
104
105 # ARTICLES LIST: Sport
106 [globalVar = TSFE:id = 41]
107
108 # Warto wiedziec
109 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/warto_wiedziec.ts3">
110
111 # ARTICLES LIST SETUP
112 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/_articleslist.ts3">
113
114 page.1 {
115 subparts.CONTENT < tpl.articlesList
116 subparts.CONTENT {
117 subparts.ARTICLES_LIST.categorySelection = 5
118 #subparts.ARICLES_PAGE_TITLE.value = Lorem
119 }
120 }
121
122 [end]
123
124 # ARTICLES LIST: Technika
125 [globalVar = TSFE:id = 41]
126
127 # Warto wiedziec
128 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/warto_wiedziec.ts3">
129
130 # ARTICLES LIST SETUP
131 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/_articleslist.ts3">
132
133 page.1 {
134 subparts.CONTENT < tpl.articlesList
135 subparts.CONTENT {
136 subparts.ARTICLES_LIST.categorySelection = 6
137 #subparts.ARICLES_PAGE_TITLE.value = Lorem
138 }
139 }
140
141 [end]
142
143 # ARTICLES LIST: Przyroda
144 [globalVar = TSFE:id = 42]
145
146 # Warto wiedziec
147 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/elements/warto_wiedziec.ts3">
148
149 # ARTICLES LIST SETUP
150 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/_articleslist.ts3">
151
152 page.1 {
153 subparts.CONTENT < tpl.articlesList
154 subparts.CONTENT {
155 subparts.ARTICLES_LIST.categorySelection = 7
156 #subparts.ARICLES_PAGE_TITLE.value = Lorem
157 }
158 }
159
160 [end]
161
162 # Zarejestruj sie/Registration
163 [globalVar = TSFE:id = 23]
164
165 # Zarejestruj sie SETUP
166 <INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/template/ts/zarejestruj_sie.ts3">
167
168 page.1 {
169 subparts.CONTENT < tpl.zarejestrujSie
170 }
171
172 [end]
173
174 # Forum
175 [globalVar = TSFE:id = 50]
176
177 page.1 {
178 subparts.CONTENT < styles.content.get
179 }
180
181 [end]
182
183
184 #styles.content.get -
Ciekawostka matematyczna
Ciekawostka matematyczna
1 1 x 8 + 1 = 9
2 12 x 8 + 2 = 98
3 123 x 8 + 3 = 987
4 1234 x 8 + 4 = 9876
5 12345 x 8 + 5 = 98765
6 123456 x 8 + 6 = 987654
7 1234567 x 8 + 7 = 9876543
8 12345678 x 8 + 8 = 98765432
9 123456789 x 8 + 9 = 987654321
10
11 1 x 9 + 2 = 11
12 12 x 9 + 3 = 111
13 123 x 9 + 4 = 1111
14 1234 x 9 + 5 = 11111
15 12345 x 9 + 6 = 111111
16 123456 x 9 + 7 = 1111111
17 1234567 x 9 + 8 = 11111111
18 12345678 x 9 + 9 = 111111111
19 123456789 x 9 +10= 1111111111
20
21 1 x 1 = 1
22 11 x 11 = 121
23 111 x 111 = 12321
24 1111 x 1111 = 1234321
25 11111 x 11111 = 123454321
26 111111 x 111111 = 12345654321
27 1111111 x 1111111 = 1234567654321
28 11111111 x 11111111 = 123456787654321
29 111111111 x 111111111=12345678987654321 -
[TS] Przyklad szablonu dla tt_news
http://harrywessling.com/typo3conf/ext/tt_news/res/ext_typoscript_setup.txt
1 ###
2 # This is an example TS setup for the CSS based template: EXT:tt_news/res/tt_news_medialinks.html
3 #
4 # the file EXT:tt_news/res/tt_news_styles.css contains the formating
5 # information for this template
6 #
7 # (see Section Reference in the manual for more options & parameters)
8 #
9 # tt_news v 1.7.0
10 ###
11
12 ## Includes the newsLib:
13 includeLibs.ts_news = EXT:tt_news/pi/class.tx_ttnews.php
14
15 ## This enables the tt_content.list item to display the news:
16
17 plugin.tt_news >
18 plugin.tt_news = USER
19 plugin.tt_news {
20 userFunc = tx_ttnews->main_news
21
22 # template file
23 templateFile = EXT:tt_news/res/tt_news_medialinks.html
24
25 # page to get the newsitems from -> "Starting point"
26 pid_list = {$plugin.tt_news.pid_list}
27
28 # page for the Single view (changed in version 1.6.0 - PIDitemDisplay don't work anymore)
29 singlePid = {$plugin.tt_news.singlePid}
30
31 # page id for the archive link in "LATEST" template
32 archiveTypoLink.parameter = {$plugin.tt_news.archiveLinkUid}
33
34 recursive = 2
35 code.field = select_key
36 allowCaching = {$plugin.tt_news.allowCaching}
37 limit = 5
38 latestLimit = 3
39 backPid =
40
41 # search
42 searchPid =
43 emptySearchAtStart = 1
44
45 # mediafiles
46 newsFiles {
47 path = uploads/media/
48 icon = 1
49 stdWrap.wrap = | <br />
50 }
51
52 # Rendering of news items. re-use the RTE parseFunc configuration for normal content
53 general_stdWrap {
54 parseFunc < tt_content.text.20.parseFunc
55 }
56
57
58 # Pagebrowser settings
59 pageBrowser {
60 maxPages = 10
61 # set this to '0' if you want the pagebrowser to display only numbers
62 showPBrowserText = 1
63 tableParams = cellpadding=2
64 showResultCount = 1
65 }
66
67 # Category settings
68 catImageMode = {$plugin.tt_news.catImageMode}
69 catTextMode = {$plugin.tt_news.catTextMode}
70 maxCatImages = 10
71 maxCatTexts = 10
72
73 # category modes:
74 # 0 = don't care about category selections
75 # 1 = display selected categories
76 # -1 = display deselected categories
77 categoryMode = 0
78
79 catImageMaxWidth = 25
80 catImageMaxHeight = 25
81
82 # Archive settings
83 datetimeDaysToArchive = 0
84 enableArchiveDate = 1
85 pageTypoLink.parameter.current = 1
86
87 reverseAMenu = 1
88 archiveMenuNoEmpty = 1
89 archiveTitleCObject = COA
90 archiveTitleCObject {
91 10 = TEXT
92 10.field = start
93 10.strftime = %B %Y
94 }
95
96 archiveEmptyMsg_stdWrap.wrap =
97 searchEmptyMsg_stdWrap.wrap =
98
99 ### Settings for Related News:
100 relatedHeader_stdWrap.wrap = <strong>|</strong>
101
102 # icon for related news
103 tmp.5 = IMAGE
104 tmp.5 {
105 file = EXT:tt_news/ext_icon.gif
106 file.width = 11
107 file.height = 12
108 wrap = |
109 }
110
111 # end-wrap for the getRelated objects
112 tmp.20 = TEXT
113 tmp.20 {
114 field = datetime
115 strftime = %d-%m-%y %H:%M
116 wrap = - | <br />
117 }
118
119 # Build the list of related news:
120 getRelatedCObject = COA
121 getRelatedCObject {
122
123 # groupBy =
124 orderBy = datetime desc
125
126 10=CASE
127 10.key.field=type
128 # settings for 'normal' related news
129 10.default=COA
130 10.default {
131 5 < plugin.tt_news.tmp.5
132 10 = TEXT
133 10.field = title
134 10.typolink.parameter = {$plugin.tt_news.singlePid}
135 10.typolink.additionalParams.data=register:newsAddParams
136 10.wrap = |
137 20 < plugin.tt_news.tmp.20
138 }
139 # settings for related news, that point to internal pages
140 10.1=COA
141 10.1 {
142 5 < plugin.tt_news.tmp.5
143 5.file=EXT:tt_news/res/tt_news_article.gif
144 10 = TEXT
145 10.field = title
146 10.typolink.parameter.field = page
147 10.wrap = |
148 20 < plugin.tt_news.tmp.20
149 }
150 # settings for related news, that point to external URLs
151 10.2=COA
152 10.2 {
153 5 < plugin.tt_news.tmp.5
154 5.file=EXT:tt_news/res/tt_news_exturl.gif
155 10 = TEXT
156 10.field = title
157 10.typolink.parameter.field = ext_url
158 10.wrap = |
159 20 < plugin.tt_news.tmp.20
160 }
161 }
162
163
164
165 # rendering of SINGLE news
166 displaySingle {
167 age_stdWrap.age = 1
168 textNewsAge_stdWrap.wrap =
169 date_stdWrap.strftime= %d/%m/%y
170 time_stdWrap.strftime= %H:%M
171 title_stdWrap.wrap =
172 subheader_stdWrap.wrap =
173 author_stdWrap.typolink.parameter.field = author_email
174 links_stdWrap.wrap =
175
176 noNewsIdMsg_stdWrap =
177 imageCount=2
178 imgAltTextField = imagecaption
179 imageWrapIfAny = <div class="news-single-images-container"> | </div>
180
181 email_stdWrap.setContentToCurrent = 1
182 email_stdWrap.typolink.parameter.current = 1
183 caption_stdWrap.wrap = <div class="news-single-imgcaption"> | </div>
184 caption_stdWrap.trim=1
185 caption_stdWrap.required=1
186 }
187 displaySingle.image {
188 file.maxW = 200
189 file.maxH = 150
190 wrap = | <br />
191 imageLinkWrap = 1
192 imageLinkWrap {
193 enable = 1
194 bodyTag = <body bgColor="#ffffff">
195 wrap = <a href="javascript:close();"> | </a>
196 width = 400m
197 height = 400
198 JSwindow = 1
199 JSwindow.newWindow = 1
200 JSwindow.expand = 17,20
201 }
202 stdWrap.spaceAfter=0
203 }
204
205 # rendering of LATEST news
206 displayLatest {
207 age_stdWrap.age = 1
208 date_stdWrap.strftime= %d/%m/%y
209 time_stdWrap.strftime= %H:%M
210 caption_stdWrap.if.directReturn = 0
211 subheader_stdWrap.crop = 100 | ...
212 subheader_stdWrap.ifEmpty.field = bodytext
213 imageCount=1
214 imgAltTextField = imagecaption
215 }
216 displayLatest.image < displaySingle.image
217 displayLatest.image {
218 file.maxW = 60
219 file.maxH = 45
220 imageLinkWrap = 1
221 stdWrap.spaceAfter = 0
222 }
223
224 # rendering of LIST news
225 displayList {
226 age_stdWrap.age = 1
227 textNewsAge_stdWrap.wrap =
228 date_stdWrap.strftime= %A %d. of %B %Y
229 time_stdWrap.strftime= %d/%m/%y %H:%M
230 caption_stdWrap.wrap = <span class="news-list-imgcaption"> | </span>
231 caption_stdWrap.trim=1
232 caption_stdWrap.required=1
233 title_stdWrap.wrap =
234 subheader_stdWrap.wrap =
235 subheader_stdWrap.crop = 300 | ...
236 subheader_stdWrap.ifEmpty.field = bodytext
237 author_stdWrap.wrap =
238 imageCount=1
239 imageWrapIfAny =
240 imgAltTextField = imagecaption
241 }
242 displayList.image < displaySingle.image
243 displayList.image {
244 file.maxW = 120
245 file.maxH = 90
246 imageLinkWrap = 1
247 stdWrap.spaceAfter=0
248 }
249 # Example for overriding values from locallang.php with other values
250 _LOCAL_LANG.de {
251 # more = [weiterlesen...]
252 }
253 }
254
255
256 ###
257 # render XML news
258 # point your rss reader to: http://your-server.org/index.php?type=100
259 ###
260
261 plugin.tt_news {
262 displayXML {
263 # rss091_tmplFile = EXT:tt_news/res/rss_0_91.tmpl
264 rss2_tmplFile = EXT:tt_news/res/rss_2.tmpl
265
266 xmlFormat = rss2
267 #possibile values: rss091 / rss2 /
268 # (planning: rdf / atom)
269
270 xmlTitle = example.com: Latest News
271 xmlLink = http://localhost/testsite-3.6.1/
272 xmlDesc = Latest News
273 xmlLang = en
274 xmlIcon = testsite-3.6.1/fileadmin/tt_news_article.gif
275 subheader_stdWrap.crop = 100 | ...
276 subheader_stdWrap.ifEmpty.field = bodytext
277 xmlLastBuildDate = 1
278 xmlLimit = 10
279 }
280 }
281
282
283 ## This enables the xml news feed
284 xmlnews = PAGE
285 xmlnews {
286 typeNum = 100
287
288 10 >
289 10 < plugin.tt_news
290 10.pid_list >
291 10.pid_list = {$plugin.tt_news.pid_list}
292 10.singlePid = {$plugin.tt_news.singlePid}
293 10.defaultCode = XML
294
295 config {
296 disableAllHeaderCode = 1
297 additionalHeaders = Content-type:text/xml
298 no_cache = 1
299 xhtml_cleaning = 0
300 }
301 }
302
303 ## This enables the tt_content.record item to display news items:
304 tt_news >
305 tt_news = < plugin.tt_news
306 tt_news.displayCurrentRecord = 1 -
[TS] css-based template for tt_news
http://www.nabble.com/tt_news-singleview-pagebrowser-ohne-tabelle-t4633878.html
1 plugin.tt_news {
2 _CSS_DEFAULT_STYLE =
3 datetimeDaysToArchive = 0
4 enableArchiveDate = 0
5 templateFile = fileadmin/template/tt_news_v2_template.html
6 displayLatest.date_stdWrap.strftime = <div
7 class="news-latest-day">%d</div><div
8 class="news-latest-month">%b</div><div class="news-latest-year">%Y</div>
9 usePiBasePagebrowser = 1
10 pageBrowser {
11 tableParams =
12 showPBrowserText = 1
13 showFirstLast = 0
14 showResultCount = 1
15 inactiveLinkWrap = <span class="inactive">|</span>
16 browseBoxWrap = <div class="browseBoxWrap">|</div>
17 browseLinksWrap = <div class="browseLinksWrap">|</div>
18 disabledLinkWrap = <span class="disabled">|</span>
19 activeLinkWrap = <span class="active">|</span>
20 showResultsWrap = <span class="showResultWrap">|</span>
21 showResultsNumbersWrap = <span class="resultNumbersWrap">|</span>
22 showResultsWrap = <div class="showResultWrap">|</div>
23 showResultsNumbersWrap = <span>|</span>
24 }
25 displayCatMenu.mode = nestedWraps
26 displayCatMenu.catmenu_stdWrap.wrap = <div
27 class="news-catmenu-container"><div class="news-catmenu">|</div></div>
28 displaySingle.date_stdWrap.strftime = <span
29 class="singledate">%d.%m.%Y</span>
30
31 useMultiPageSingleView = 1
32 maxWordsInSingleView = 300
33
34
35 general_stdWrap >
36 displayList.subheader_stdWrap.wrap = <p>|</p>
37 displayLatest.subheader_stdWrap.wrap = <p>|</p>
38 displayLatest.subheader_stdWrap.crop = 150 | ... | 1
39 displaySingle {
40 subheader_stdWrap.parseFunc < lib.parseFunc_RTE
41
42 subheader_stdWrap.parseFunc.nonTypoTagStdWrap.encapsLines.nonWrappedTag >
43 content_stdWrap.parseFunc < lib.parseFunc_RTE
44 linksItem_stdWrap.parseFunc < lib.parseFunc_RTE
45
46 linksItem_stdWrap.parseFunc.nonTypoTagStdWrap.encapsLines.nonWrappedTag >
47 }
48
49 general_stdWrap.editPanel = 1
50 general_stdWrap.editPanel.allow = edit, new, delete, hide
51
52 #general_stdWrap.wrap = <div>HIER|</div>
53
54
55
56 _LOCAL_LANG.de {
57 more = mehr
58 backToList = Zurück zu: %s
59 goToArchive = zum Archiv
60 archiveHeader = News Archiv:
61 textFiles = Download:
62 }
63 }
Pages : 1
