filelink[] tags weren't being replaced correctly in search results
[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
4ef01459 10
2eca61d5
TC
11[paths]
12; the following needs to be set to a path writable by the BSE processes
13downloads = /somewhere
3c32512d 14siteuser_images = $(paths/downloads)
efcc5a30 15dynamic_cache=$(paths/downloads)/../cache
2eca61d5
TC
16
17[pregenerate]
18
19; the following are required by the system - don't modify them
3fb296b8
TC
20user/editbooking.tmpl = user,user/base_editbooking.tmpl
21user/bookingdetail.tmpl = user,user/base_bookingdetail.tmpl
22user/cancelbooking.tmpl = user,user/base_cancelbooking.tmpl
23user/bookinglist.tmpl = user,user/base_bookinglist.tmpl
ab2cd916 24user/orderdetail.tmpl = user,user/base_orderdetail.tmpl
4ef01459
TC
25user/alreadyblacklisted.tmpl = user,user/alreadyblacklisted_base.tmpl
26user/blacklistdone.tmpl = user,user/blacklistdone_base.tmpl
27user/cantunsub.tmpl = user,user/cantunsub_base.tmpl
28user/confirmed.tmpl = user,user/confirmed_base.tmpl
29user/confsent.tmpl = user,user/confsent_base.tmpl
2a295ea9 30user/confsent_nop.tmpl = user,user/confsent_nop_base.tmpl
4ef01459 31user/email_conferror.tmpl = user,user/email_conferror_base.tmpl
2eca61d5 32user/logon.tmpl = user,user/logon_base.tmpl
2eca61d5 33user/lostemailsent.tmpl = user,user/lostemailsent_base.tmpl
4ef01459 34user/lostpassword.tmpl = user,user/lostpassword_base.tmpl
2eca61d5 35user/lostpwdemail.tmpl = user,user/lostpwdemail_base.tmpl
2a295ea9 36user/nopassword.tmpl = user,user/nopassword_base.tmpl
4ef01459 37user/options.tmpl = user,user/options_base.tmpl
2a295ea9 38user/options_saved.tmpl = user,user/options_saved_base.tmpl
9063386f 39user/options_billing.tmpl = user,user/options_billing_base.tmpl
3c32512d 40user/options_images.tmpl = user,user/options_images_base.tmpl
4ef01459 41user/register.tmpl = user,user/register_base.tmpl
b19047a6 42user/toomany.tmpl = user,user/toomany_base.tmpl
4ef01459 43user/toosoon.tmpl = user,user/toosoon_base.tmpl
531fb3bc
TC
44user/unsuball.tmpl = user,user/unsuball_base.tmpl
45user/unsubone.tmpl = user,user/unsubone_base.tmpl
4ef01459 46user/userpage.tmpl = user,user/userpage_base.tmpl
0eb78304
TC
47user/bookseminar.tmpl = user,user/base_bookseminar.tmpl
48user/bookconfirm.tmpl = user,user/base_bookconfirm.tmpl
49user/bookcomplete.tmpl = user,user/base_bookcomplete.tmpl
5af99440 50user/redirect.tmpl = user,user/base_redirect.tmpl
ee6577c3
TC
51interest/confirm.tmpl = interest,interest/confirm_base.tmpl
52interest/askagain.tmpl = interest,interest/askagain_base.tmpl
53interest/error.tmpl = interest,interest/error_base.tmpl
a5e3fc4b
TC
54formmail/defquery.tmpl = formmail,formmail/defquery_base.tmpl
55formmail/defdone.tmpl = formmail,formmail/defdone_base.tmpl
c2096d67 56error.tmpl = error,error_base.tmpl
2eca61d5
TC
57
58[user settings]
59title = My $(site/name)
60
ee6577c3
TC
61[interest settings]
62title = $(site/name) Interest Registration
63
a5e3fc4b
TC
64[formmail settings]
65title = Send us a comment
66
c2096d67
TC
67[error settings]
68title = Error
57d988af 69dynamic = 0
c2096d67 70
2eca61d5
TC
71[messages]
72user/notyourorder = Order $1 isn't your order
721cd24c 73shop/fileitems = You have products in your cart that include downloadable files. Please logon or register before checking out.
6e3d2da5 74shop/logonrequired = This site requires that you be logged on to make a purchase. Please logon or register before checking out.
2eca61d5 75
2404a911
TC
76[downloads]
77; if true, an order must be marked paid for before the user can download
78; the files attached to the products
79;must_be_paid = yes
80; if true, an order must be marked filled before the user can download the
81; files attached to the products
82;must_be_filled = yes
721cd24c
TC
83
84[children of 5]
85template=common/sidebar.tmpl
86template_dirs=sidebar
b19047a6
TC
87
88[extra tags]
b19047a6 89siteUrl = $(site/url)
2a295ea9
TC
90siteName = $(site/name)
91; You can add any static tag definitions you like here
92; salesEmail = someone@yoursite.com
93; salesPhoneNo = 61 2 9999 8888
531fb3bc
TC
94
95[datadump]
96# where to email the data dump
97#to = someone@somewhere
98# program to run to do the dump
99# must take the same parameters as mysqldump
d09682dd 100#mysqldump = /usr/local/mysql/bin/mysqldump
531fb3bc
TC
101
102[subscriptions]
103# if override is non-zero then the fields for the archiving and templates
104# will be available when sending a subscription
105override=1
106
ca9aa2bf
TC
107[level names]
1080=Your Site
918735d1
TC
1091=Page Lev1
1102=Page Lev2
1113=Page Lev3
1124=Page Lev4
1135=Page Lev5
ca9aa2bf
TC
114
115[articles]
116shop=3
caa7299c 117
08123550
TC
118[shop]
119payment_types=0,1,2
120address1=First address line in configuration
121address2=Second address line in configuration
122address3=Third address line in configuration
7b81711b 123enabled=1
d49f56a6
TC
124display_billAddress=Billing Address
125display_name1=First Name
126display_name2=Last Name
127display_address=Address
08123550 128
caa7299c
TC
129[level 1]
130template=common/default.tmpl
131
132[level 2]
133template=common/default.tmpl
134
135[level 3]
136template=common/default.tmpl
137
138[level 4]
139template=common/default.tmpl
140
141[level 5]
142template=common/default.tmpl
143
144[catalogs]
145template=catalog.tmpl
146
147[products]
148template=shopitem.tmpl
08123550 149
cc9019d1
TC
150[templates]
151admin/edit_2=admin/edit_1
152admin/edit_3=admin/edit_1
153admin/edit_4=admin/edit_1
154admin/edit_5=admin/edit_1
155admin/edit_img=admin/article_img
156admin/edit_file=admin/filelist
157
2076966c
TC
158; this used to be handled via the edit target, but since CVS sucks
159; I won't rename the template
160admin/users/view_orders=admin/users/edit_orders
161
08123550 162[Global permissions]
de193691
TC
163change_body = 8
164change_body_no_shop = 9
165full_access = 0
166full_access_no_shop = 3
08123550 167shop_access = 1
de193691
TC
168shop_orders = 5
169subscriptions = 4
170users_and_groups = 6
08123550
TC
171
172[Article permissions]
de193691 173change_body_doc = 2
7b81711b 174change_body_decendants = 10
de193691 175full_access_doc = 7
7b81711b 176full_access_decendants = 11
08123550 177
de193691
TC
178[permission change_body]
179brief=Title & body (Site)
180help=The user has permission to change only the title & body of all articles or products.
181permissions=edit_field_edit_body,edit_field_edit_title,edit_save
08123550 182descendants=1
de193691 183articles=-1
08123550 184
de193691
TC
185[permission change_body_no_shop]
186brief=Title & body except shop admin
187help=The user has permission to change only the title & body of all
188articles except for the shop.
abf5bbc6 189permissions=edit_field_edit_body,edit_field_edit_title,edit_save
de193691
TC
190descendants=1
191articles=not(3)
08123550 192
de193691
TC
193[permission full_access]
194brief=Full access (Site)
195help=Full access to the article. The user can modify all modifiable fields, delete and add articles at will.
7dd6ebae 196permissions=edit_*,regen_*,bse_*
08123550 197descendants=1
de193691 198articles=-1
08123550 199
de193691
TC
200[permission full_access_no_shop]
201brief=Full access except shop admin
202help=The user has complete access to all articles except for the shop.
203permissions=edit_*,regen_*
08123550 204descendants=1
de193691
TC
205articles=not(3)
206
207[permission shop_access]
208brief=Shop administration
209help=The user has complete access to catalogs or products in the shop.
9168c88c 210permissions=not(admin_*)
de193691
TC
211descendants=1
212articles=3
08123550 213
de193691
TC
214[permission shop_orders]
215brief=Shop orders management
216help=The user can view the order list, order details, and mark orders filled.
217permissions=shop_order_*
da6bc286 218articles=-1
da6bc286 219
de193691
TC
220[permission subscriptions]
221brief=Subscriptions management
222help=The user can create, edit and send subscriptions.
223permissions=subs_*
da6bc286 224articles=-1
da6bc286
TC
225
226[permission users_and_groups]
da6bc286 227brief=User/Group management
de193691 228help=The user can manage users, groups and their permissions.
da6bc286 229permissions=admin_*
de193691
TC
230articles=-1
231
232[permission change_body_doc]
233brief=Title & body (Article)
234help=The user has permission to change only the title & body of this
235article or product.
236permissions=edit_field_edit_body,edit_field_edit_title,edit_save
237
7b81711b
TC
238[permission change_body_decendants]
239brief=Title & body (Article + Decendants)
240help=The user has permission to change only the title & body of this article or product and it's decendants.
241permissions=edit_field_edit_body,edit_field_edit_title,edit_save
242descendants=1
243
de193691
TC
244[permission full_access_doc]
245brief=Full access (Article)
246help=Full access to the article. The user can modify all modifiable
247fields for this article or product.
248permissions=edit_*,regen_*
da6bc286 249
7b81711b
TC
250[permission full_access_decendants]
251brief=Full access (Article + Decendants)
252help=Full access to the article and it's decendants. The user can modify all modifiable fields for this article or product.
253permissions=edit_*,regen_*
254descendants=1
918735d1
TC
255
256[article flags]
257I=Index even if hidden
cc9019d1
TC
258N=Don't index even if listed
259C=Don't index this article or it's descendants
efcc5a30 260R=Regenerate even if we're using JIT regen (dynamic pages only)
63e99d77 261F=Descendants inherit Always Dynamic
918735d1
TC
262
263[article 1]
264extra_templates=index.tmpl
265
266[article 2]
267extra_templates=index2.tmpl
b553afa2
TC
268
269[reports]
270sales_summ_by_product=Sales Summary By Product
271product_sales_over_time=Product Sales Over Time
2d873eb6
TC
272monthly_sales=Monthly Sales
273quarterly_sales=Quarterly Sales
274weekly_sales=Weekly Sales
275yearly_sales=Yearly Sales
276total_sales=Total Sales
277users_vs_orders=Users vs Orders
9063386f 278user_products=Products bought by User
988d8721 279bse_test=Test report
b553afa2
TC
280
281[report sales_summ_by_product]
2d873eb6 282sql1=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
283sql1link1=<a href="/cgi-bin/admin/report.pl?s_show=1&r=product_sales_over_time&p1=${Id}">Sales Over Time</a>
284sql1link2=<a href="/cgi-bin/admin/add.pl?id=${Id}">Edit</a>
b553afa2
TC
285
286[report product_sales_over_time]
2d873eb6 287sql1=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 288sql1params=1
b553afa2
TC
289param1=product,Product
290
2d873eb6
TC
291[report weekly_sales]
292sql1=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 site_users su on od.userId =su.userId group by year(od.orderDate), week(od.orderDate) order by 1 DESC, 2 DESC
293
294[report monthly_sales]
295sql1=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 site_users su on od.userId = su.userId group by year(od.orderDate), month(od.orderDate) order by 1 DESC, 2 DESC
296
297[report quarterly_sales]
298sql1=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
299
300[report yearly_sales]
301sql1=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 site_users su on od.userId = su.userId group by year(od.orderDate) order by 1 DESC
302
303[report total_sales]
304sql1=select count(*) as "Orders", format(sum(total)/100.0,2) as '$ Total', count(su.userId) as 'Logon Orders' from orders od left join site_users su on od.userId = su.userId
305
306[report user_products]
307sql1=select pr.title, count(*) as 'Count' from orders od, order_item oi, article pr, site_users 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
308sql1params=1
309param1=site_user,User
2d873eb6
TC
310
311[report users_vs_orders]
312sql1=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
313
b553afa2
TC
314[report datatype product]
315type=sql
316sql=select ar.id as "id", ar.title as "label" from article ar, product pr where ar.id = pr.articleId order by 2
650a6188
TC
317novalues=[ You don't have any products ]
318
319[report datatype article]
320type=sql
321sql=select id, concat(title, ' (', id, ')') as "label" from article
77804754 322
2d873eb6
TC
323[report datatype site_user]
324type=sql
325sql=select id, userId as "label" from site_users
326novalues=[ There are no registered users ]
327
988d8721
TC
328[report bse_test]
329sql1=select id, title from article where id = ?
330hide=1
331param1=article,Article
332sql1params=1
333
77804754
TC
334[valid child types]
335Article=Article
336Catalog=Catalog,Product
337Product=
95989433
TC
338
339[protect link]
340; articles for which the link field should not be overwritten
341; the values are ignored, but you can include descriptions
3421=home page
3433=shop
3446=formatting guide
3457=RDF
2a295ea9 346
ab2cd916
TC
347[editor]
348;allow_thumbs=1
349;thumbs_class=BSE::Thumb::Imager
350
2a295ea9
TC
351[site users]
352display_name1=First Name
353display_name2=Last Name
354display_address=Street
355display_postcode=Post code
356display_telephone=Phone
829c9ed9 357
2076966c
TC
358[nonajax user agents]
359ie4=MSIE
360
361[ajax user agents]
362mozilla=^Mozilla/5.0
363
364[ajax definitions]
365includes=inline:<script type="text/javascript" src="/js/prototype.js"></script>
366
0eb78304
TC
367[nuser controllers]
368user=BSE::UI::User
5af99440 369redirect=BSE::UI::Redirect
0eb78304 370
829c9ed9
TC
371[includes]
37200bsecfg_d=bsecfg_d/
37350local=bse-local.cfg