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