t10edit.t now cleans up the article it creates
[bse.git] / site / cgi-bin / bse.cfg
CommitLineData
2eca61d5
TC
1[site]
2name=SomeSite
b19047a6
TC
3; url should not include a trailing /
4url=http://your.site.base
5secureurl=$(url)
d980b7fa 6public_files=/managed_assets/
2eca61d5 7
4ef01459
TC
8[basic]
9randomdata = /dev/urandom
9168c88c 10access_control=0
6430ee52 11file_handlers=flv
b62cae00 12preload_template=preload.tmpl
4ef01459 13
2eca61d5
TC
14[paths]
15; the following needs to be set to a path writable by the BSE processes
16downloads = /somewhere
3c32512d 17siteuser_images = $(paths/downloads)
efcc5a30 18dynamic_cache=$(paths/downloads)/../cache
026d5cec 19backgroundlogs=$(downloads)/../backlogs
d980b7fa 20public_files=$(public_html)/managed_assets
2eca61d5
TC
21
22[pregenerate]
23
24; the following are required by the system - don't modify them
3fb296b8
TC
25user/editbooking.tmpl = user,user/base_editbooking.tmpl
26user/bookingdetail.tmpl = user,user/base_bookingdetail.tmpl
27user/cancelbooking.tmpl = user,user/base_cancelbooking.tmpl
28user/bookinglist.tmpl = user,user/base_bookinglist.tmpl
ab2cd916 29user/orderdetail.tmpl = user,user/base_orderdetail.tmpl
492998c7 30user/orderdetaila.tmpl = user,user/base_orderdetail.tmpl
4ef01459
TC
31user/alreadyblacklisted.tmpl = user,user/alreadyblacklisted_base.tmpl
32user/blacklistdone.tmpl = user,user/blacklistdone_base.tmpl
33user/cantunsub.tmpl = user,user/cantunsub_base.tmpl
34user/confirmed.tmpl = user,user/confirmed_base.tmpl
35user/confsent.tmpl = user,user/confsent_base.tmpl
2a295ea9 36user/confsent_nop.tmpl = user,user/confsent_nop_base.tmpl
4ef01459 37user/email_conferror.tmpl = user,user/email_conferror_base.tmpl
2eca61d5 38user/logon.tmpl = user,user/logon_base.tmpl
2eca61d5 39user/lostemailsent.tmpl = user,user/lostemailsent_base.tmpl
4ef01459 40user/lostpassword.tmpl = user,user/lostpassword_base.tmpl
93be4a7b 41user/lost_prompt.tmpl = user,user/base_lost_prompt.tmpl
2a295ea9 42user/nopassword.tmpl = user,user/nopassword_base.tmpl
4ef01459 43user/options.tmpl = user,user/options_base.tmpl
2a295ea9 44user/options_saved.tmpl = user,user/options_saved_base.tmpl
b27af108 45user/options_delivery.tmpl = user,user/options_delivery_base.tmpl
3c32512d 46user/options_images.tmpl = user,user/options_images_base.tmpl
4ef01459 47user/register.tmpl = user,user/register_base.tmpl
b19047a6 48user/toomany.tmpl = user,user/toomany_base.tmpl
4ef01459 49user/toosoon.tmpl = user,user/toosoon_base.tmpl
531fb3bc
TC
50user/unsuball.tmpl = user,user/unsuball_base.tmpl
51user/unsubone.tmpl = user,user/unsubone_base.tmpl
4ef01459 52user/userpage.tmpl = user,user/userpage_base.tmpl
d49667a2 53user/userpage_wishlist.tmpl = user,user/base_userpage_wishlist.tmpl
32696f84
TC
54user/userpage_files.tmpl = user,user/base_userpage_files.tmpl
55user/userpage_orders.tmpl = user,user/base_userpage_orders.tmpl
d49667a2 56user/wishlist.tmpl = user,user/base_wishlist.tmpl
0eb78304
TC
57user/bookseminar.tmpl = user,user/base_bookseminar.tmpl
58user/bookconfirm.tmpl = user,user/base_bookconfirm.tmpl
59user/bookcomplete.tmpl = user,user/base_bookcomplete.tmpl
5af99440 60user/redirect.tmpl = user,user/base_redirect.tmpl
ee6577c3
TC
61interest/confirm.tmpl = interest,interest/confirm_base.tmpl
62interest/askagain.tmpl = interest,interest/askagain_base.tmpl
63interest/error.tmpl = interest,interest/error_base.tmpl
a5e3fc4b
TC
64formmail/defquery.tmpl = formmail,formmail/defquery_base.tmpl
65formmail/defdone.tmpl = formmail,formmail/defdone_base.tmpl
c2096d67 66error.tmpl = error,error_base.tmpl
0c2e7f7a
TC
67tellafriend/form.tmpl = user,tellafriend/base_form.tmpl
68tellafriend/done.tmpl = user,tellafriend/base_done.tmpl
2eca61d5
TC
69
70[user settings]
71title = My $(site/name)
72
ee6577c3
TC
73[interest settings]
74title = $(site/name) Interest Registration
75
a5e3fc4b
TC
76[formmail settings]
77title = Send us a comment
78
c2096d67
TC
79[error settings]
80title = Error
57d988af 81dynamic = 0
c2096d67 82
2eca61d5
TC
83[messages]
84user/notyourorder = Order $1 isn't your order
721cd24c 85shop/fileitems = You have products in your cart that include downloadable files. Please logon or register before checking out.
6e3d2da5 86shop/logonrequired = This site requires that you be logged on to make a purchase. Please logon or register before checking out.
2eca61d5 87
2404a911
TC
88[downloads]
89; if true, an order must be marked paid for before the user can download
90; the files attached to the products
91;must_be_paid = yes
92; if true, an order must be marked filled before the user can download the
93; files attached to the products
94;must_be_filled = yes
721cd24c
TC
95
96[children of 5]
97template=common/sidebar.tmpl
98template_dirs=sidebar
b19047a6
TC
99
100[extra tags]
b19047a6 101siteUrl = $(site/url)
2a295ea9
TC
102siteName = $(site/name)
103; You can add any static tag definitions you like here
104; salesEmail = someone@yoursite.com
105; salesPhoneNo = 61 2 9999 8888
531fb3bc
TC
106
107[datadump]
108# where to email the data dump
109#to = someone@somewhere
110# program to run to do the dump
111# must take the same parameters as mysqldump
d09682dd 112#mysqldump = /usr/local/mysql/bin/mysqldump
531fb3bc
TC
113
114[subscriptions]
115# if override is non-zero then the fields for the archiving and templates
116# will be available when sending a subscription
117override=1
118
ca9aa2bf
TC
119[level names]
1200=Your Site
918735d1
TC
1211=Page Lev1
1222=Page Lev2
1233=Page Lev3
1244=Page Lev4
1255=Page Lev5
ca9aa2bf
TC
126
127[articles]
128shop=3
caa7299c 129
08123550
TC
130[shop]
131payment_types=0,1,2
132address1=First address line in configuration
133address2=Second address line in configuration
134address3=Third address line in configuration
7b81711b 135enabled=1
08123550 136
caa7299c
TC
137[level 1]
138template=common/default.tmpl
139
140[level 2]
141template=common/default.tmpl
142
143[level 3]
144template=common/default.tmpl
145
146[level 4]
147template=common/default.tmpl
148
149[level 5]
150template=common/default.tmpl
151
152[catalogs]
153template=catalog.tmpl
154
155[products]
156template=shopitem.tmpl
08123550 157
cc9019d1
TC
158[templates]
159admin/edit_2=admin/edit_1
160admin/edit_3=admin/edit_1
161admin/edit_4=admin/edit_1
162admin/edit_5=admin/edit_1
163admin/edit_img=admin/article_img
164admin/edit_file=admin/filelist
165
2076966c
TC
166; this used to be handled via the edit target, but since CVS sucks
167; I won't rename the template
168admin/users/view_orders=admin/users/edit_orders
169
08123550 170[Global permissions]
de193691
TC
171change_body = 8
172change_body_no_shop = 9
173full_access = 0
174full_access_no_shop = 3
08123550 175shop_access = 1
de193691
TC
176shop_orders = 5
177subscriptions = 4
178users_and_groups = 6
6555857d
TC
179confirm_members = 12
180manage_members = 13
08123550
TC
181
182[Article permissions]
de193691 183change_body_doc = 2
7b81711b 184change_body_decendants = 10
de193691 185full_access_doc = 7
7b81711b 186full_access_decendants = 11
08123550 187
de193691
TC
188[permission change_body]
189brief=Title & body (Site)
190help=The user has permission to change only the title & body of all articles or products.
191permissions=edit_field_edit_body,edit_field_edit_title,edit_save
08123550 192descendants=1
de193691 193articles=-1
08123550 194
de193691
TC
195[permission change_body_no_shop]
196brief=Title & body except shop admin
197help=The user has permission to change only the title & body of all
198articles except for the shop.
abf5bbc6 199permissions=edit_field_edit_body,edit_field_edit_title,edit_save
de193691
TC
200descendants=1
201articles=not(3)
08123550 202
de193691
TC
203[permission full_access]
204brief=Full access (Site)
205help=Full access to the article. The user can modify all modifiable fields, delete and add articles at will.
7dd6ebae 206permissions=edit_*,regen_*,bse_*
08123550 207descendants=1
de193691 208articles=-1
08123550 209
de193691
TC
210[permission full_access_no_shop]
211brief=Full access except shop admin
212help=The user has complete access to all articles except for the shop.
213permissions=edit_*,regen_*
08123550 214descendants=1
de193691
TC
215articles=not(3)
216
217[permission shop_access]
218brief=Shop administration
219help=The user has complete access to catalogs or products in the shop.
9168c88c 220permissions=not(admin_*)
de193691
TC
221descendants=1
222articles=3
08123550 223
de193691
TC
224[permission shop_orders]
225brief=Shop orders management
226help=The user can view the order list, order details, and mark orders filled.
227permissions=shop_order_*
da6bc286 228articles=-1
da6bc286 229
de193691
TC
230[permission subscriptions]
231brief=Subscriptions management
232help=The user can create, edit and send subscriptions.
233permissions=subs_*
da6bc286 234articles=-1
da6bc286
TC
235
236[permission users_and_groups]
da6bc286 237brief=User/Group management
de193691 238help=The user can manage users, groups and their permissions.
da6bc286 239permissions=admin_*
de193691
TC
240articles=-1
241
242[permission change_body_doc]
243brief=Title & body (Article)
244help=The user has permission to change only the title & body of this
245article or product.
246permissions=edit_field_edit_body,edit_field_edit_title,edit_save
247
7b81711b
TC
248[permission change_body_decendants]
249brief=Title & body (Article + Decendants)
250help=The user has permission to change only the title & body of this article or product and it's decendants.
251permissions=edit_field_edit_body,edit_field_edit_title,edit_save
252descendants=1
253
de193691
TC
254[permission full_access_doc]
255brief=Full access (Article)
256help=Full access to the article. The user can modify all modifiable
257fields for this article or product.
258permissions=edit_*,regen_*
da6bc286 259
7b81711b
TC
260[permission full_access_decendants]
261brief=Full access (Article + Decendants)
262help=Full access to the article and it's decendants. The user can modify all modifiable fields for this article or product.
263permissions=edit_*,regen_*
264descendants=1
918735d1 265
6555857d
TC
266[permission confirm_members]
267brief=Confirm member email address
268help=The user can manually mark a members email address as confirmed.
269permissions=bse_members_confirm
270articles=-1
271
272[permission manage_members]
273brief=Member management
274help=The user can manage site members
275permissions=bse_members_user_*,bse_members_group_*
276articles=-1
277
918735d1 278[article flags]
3f36e485
TC
279A=Disallow browser caching (default, dynamic articles only)
280B=Allow browser caching (dynamic articles only)
281C=Don't index this article or it's descendants
70c6e1e1 282D=Disable linking
3f36e485 283F=Descendants inherit Always Dynamic
918735d1 284I=Index even if hidden
cc9019d1 285N=Don't index even if listed
efcc5a30 286R=Regenerate even if we're using JIT regen (dynamic pages only)
538b7aee 287P=Link to parent
918735d1
TC
288
289[article 1]
290extra_templates=index.tmpl
291
292[article 2]
293extra_templates=index2.tmpl
b553afa2
TC
294
295[reports]
296sales_summ_by_product=Sales Summary By Product
297product_sales_over_time=Product Sales Over Time
2d873eb6
TC
298monthly_sales=Monthly Sales
299quarterly_sales=Quarterly Sales
300weekly_sales=Weekly Sales
301yearly_sales=Yearly Sales
302total_sales=Total Sales
303users_vs_orders=Users vs Orders
9063386f 304user_products=Products bought by User
988d8721 305bse_test=Test report
538b7aee 306bse_recent_regos=Recent registrations
b553afa2
TC
307
308[report sales_summ_by_product]
2d873eb6 309sql1=select pr.articleId as "Id", ar.title as "Product", count(*) as "Units" from article ar, product pr, order_item oi where ar.id = pr.articleId and pr.articleId = oi.productId group by pr.articleId, ar.title
9063386f
TC
310sql1link1=<a href="/cgi-bin/admin/report.pl?s_show=1&r=product_sales_over_time&p1=${Id}">Sales Over Time</a>
311sql1link2=<a href="/cgi-bin/admin/add.pl?id=${Id}">Edit</a>
9615cff6
TC
312sort1=-Units;By Unit from highest;order by 3 desc
313sort2=+Units;By Unit;order by 3
314sort3=+Product;Product name;order by 2
315sort4=-Product;Reverse product name;order by 2 desc
b553afa2
TC
316
317[report product_sales_over_time]
2d873eb6 318sql1=select year(od.orderDate) as "Year", month(od.orderDate) as "Month", count(*) as 'Units' from order_item oi, orders od where oi.orderId = od.id and productId = ? group by year(od.orderDate), month(od.orderDate) order by 1 DESC, 2 DESC
650a6188 319sql1params=1
b553afa2 320param1=product,Product
9615cff6
TC
321sort1=-Year;Reverse time order;order by 1 desc, 2 desc
322sort2=+Year;Time order;order by 1 asc, 2 asc
323sort3=-Units;By units desc;order by 3 desc
324sort4=+Units;By units asc;order by 3 asc
b553afa2 325
2d873eb6 326[report weekly_sales]
b27af108 327sql1=select year(od.orderDate) as "Year", week(od.orderDate) as "Week", count(*) as 'Orders', format(sum(od.total)/100.0,2) as '$ Total', count(su.userId) as 'Logon Orders' from orders od left join bse_siteusers su on od.userId =su.userId group by year(od.orderDate), week(od.orderDate) order by 1 DESC, 2 DESC
2d873eb6
TC
328
329[report monthly_sales]
b27af108 330sql1=select year(od.orderDate) as "Year", month(od.orderDate) as "Month", format(sum(od.total)/100.0,2) as 'Total', count(*) as 'Count', count(su.userId) as 'User Registered' from orders od left join bse_siteusers su on od.userId = su.userId group by year(od.orderDate), month(od.orderDate) order by 1 DESC, 2 DESC
2d873eb6
TC
331
332[report quarterly_sales]
333sql1=select year(od.orderDate) as "Year", quarter(od.orderDate) as "Quarter", format(sum(od.total)/100.0,2) as 'Total', count(*) as 'Count' from orders od group by year(od.orderDate), quarter(od.orderDate) order by 1 DESC, 2 DESC
334
335[report yearly_sales]
b27af108 336sql1=select year(od.orderDate) as "Year", count(*) as "Orders",format(sum(od.total)/100.0,2) as '$ Total', count(su.userId) as 'Logon Orders' from orders od left join bse_siteusers su on od.userId = su.userId group by year(od.orderDate) order by 1 DESC
2d873eb6
TC
337
338[report total_sales]
b27af108 339sql1=select count(*) as "Orders", format(sum(total)/100.0,2) as '$ Total', count(su.userId) as 'Logon Orders' from orders od left join bse_siteusers su on od.userId = su.userId
2d873eb6
TC
340
341[report user_products]
b27af108 342sql1=select pr.title, count(*) as 'Count' from orders od, order_item oi, article pr, bse_siteusers su where oi.orderId = od.id and oi.productId = pr.id and su.userId = od.userId and su.id = ? group by pr.id
9063386f
TC
343sql1params=1
344param1=site_user,User
2d873eb6
TC
345
346[report users_vs_orders]
347sql1=select delivFirstName as "First Name", delivLastName as "Last Name", userId as "Logon", format(sum(total)/100.0,2) as '$ Total', count(*) as "Orders" from orders group by delivFirstName, delivLastName order by 5 DESC, 2
348
b553afa2
TC
349[report datatype product]
350type=sql
351sql=select ar.id as "id", ar.title as "label" from article ar, product pr where ar.id = pr.articleId order by 2
650a6188
TC
352novalues=[ You don't have any products ]
353
538b7aee
TC
354[report bse_recent_regos]
355sql1=<<SQL
356select id, userId as "Logon", name1 as "First Name", name2 as "Last Name", whenRegistered as "When Registered"
b27af108 357from bse_siteusers
538b7aee
TC
358where whenRegistered > date_sub(now(), interval 7 day)
359order by whenRegistered desc
360SQL
361
362
650a6188
TC
363[report datatype article]
364type=sql
365sql=select id, concat(title, ' (', id, ')') as "label" from article
77804754 366
2d873eb6
TC
367[report datatype site_user]
368type=sql
b27af108 369sql=select id, userId as "label" from bse_siteusers
2d873eb6
TC
370novalues=[ There are no registered users ]
371
988d8721
TC
372[report bse_test]
373sql1=select id, title from article where id = ?
374hide=1
375param1=article,Article
376sql1params=1
377
77804754
TC
378[valid child types]
379Article=Article
380Catalog=Catalog,Product
381Product=
95989433
TC
382
383[protect link]
384; articles for which the link field should not be overwritten
385; the values are ignored, but you can include descriptions
3861=home page
3873=shop
3886=formatting guide
3897=RDF
2a295ea9 390
ab2cd916
TC
391[editor]
392;allow_thumbs=1
393;thumbs_class=BSE::Thumb::Imager
8aa7eb30 394file_display=small
ab2cd916 395
2a295ea9
TC
396[site users]
397display_name1=First Name
398display_name2=Last Name
b27af108 399display_street=Street
2a295ea9
TC
400display_postcode=Post code
401display_telephone=Phone
829c9ed9 402
2076966c 403[nonajax user agents]
9b3a5df0
TC
404ie4=MSIE 4
405ie5=MSIE 5.01
2076966c
TC
406
407[ajax user agents]
38de0036 408mozilla=^Mozilla/5\.0
9b3a5df0
TC
409ie5=MSIE 5.5
410ie6=MSIE 6
411ie7=MSIE 7
412ie8=MSIE 8
413safari=Safari
414khtml=KHTML
415opera=Opera
2076966c
TC
416
417[ajax definitions]
454cdabb
TC
418includes=<<INLINE
419inline:<script type="text/javascript" src="/js/prototype.js"></script>
420<script type="text/javascript" src="/js/scriptaculous.js"></script>
5f3a2963 421<script type="text/javascript" src="/js/scriptoverride.js"></script>
454cdabb 422INLINE
2076966c 423
0eb78304
TC
424[nuser controllers]
425user=BSE::UI::User
5af99440 426redirect=BSE::UI::Redirect
e7367b88
TC
427shop=BSE::UI::Shop
428search=BSE::UI::Search
429page=BSE::UI::Page
0c2e7f7a 430tellafriend=BSE::UI::Tellafriend
85aba847 431default=shop
e7367b88 432
4c4d3c3f 433[nadmin controllers]
95e517da 434shopadmin=BSE::UI::AdminShop
75b07edf 435modules=BSE::UI::AdminModules
95e517da 436log=BSE::UI::AdminAudit
0eb78304 437
829c9ed9 438[includes]
2d42cf8f
TC
43900install=bse-install.cfg
44010bsecfg_d=cfg/
0c2e7f7a
TC
441
442[mail resources]
443stylesheet=email/email.css,text/css,1
444
445[targets]
446tellafriend=/cgi-bin/nuser.pl/tellafriend/TARGET
447tellafriend_n=/cgi-bin/nuser.pl/tellafriend
f40af7e2
TC
448
449[thumb geometries]
450editor=scale(200x200)
eac3131d 451sadmingall=scale(120x120),dropshadow(),canvas(140x140,bgalpha:0),format(png)
3f9c8a96 452search=scale(150x120)
6430ee52
TC
453
454[file handlers]
455flv=BSE::FileHandler::FLV
bf921eb7 456
fea96500 457[template descriptions]
bf921eb7 458common/default.tmpl=Default template
ebc63b18 459
c925a6af
TC
460[nightly work]
461bse_session_clean=1
462bse_audit_log_clean=1
fd737137
TC
463
464[undeletable articles]
4651=home page
4662=more home page
4675=sidebar