handle global files too
[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
d49667a2
TC
47user/userpage_wishlist.tmpl = user,user/base_userpage_wishlist.tmpl
48user/wishlist.tmpl = user,user/base_wishlist.tmpl
0eb78304
TC
49user/bookseminar.tmpl = user,user/base_bookseminar.tmpl
50user/bookconfirm.tmpl = user,user/base_bookconfirm.tmpl
51user/bookcomplete.tmpl = user,user/base_bookcomplete.tmpl
5af99440 52user/redirect.tmpl = user,user/base_redirect.tmpl
ee6577c3
TC
53interest/confirm.tmpl = interest,interest/confirm_base.tmpl
54interest/askagain.tmpl = interest,interest/askagain_base.tmpl
55interest/error.tmpl = interest,interest/error_base.tmpl
a5e3fc4b
TC
56formmail/defquery.tmpl = formmail,formmail/defquery_base.tmpl
57formmail/defdone.tmpl = formmail,formmail/defdone_base.tmpl
c2096d67 58error.tmpl = error,error_base.tmpl
2eca61d5
TC
59
60[user settings]
61title = My $(site/name)
62
ee6577c3
TC
63[interest settings]
64title = $(site/name) Interest Registration
65
a5e3fc4b
TC
66[formmail settings]
67title = Send us a comment
68
c2096d67
TC
69[error settings]
70title = Error
57d988af 71dynamic = 0
c2096d67 72
2eca61d5
TC
73[messages]
74user/notyourorder = Order $1 isn't your order
721cd24c 75shop/fileitems = You have products in your cart that include downloadable files. Please logon or register before checking out.
6e3d2da5 76shop/logonrequired = This site requires that you be logged on to make a purchase. Please logon or register before checking out.
2eca61d5 77
2404a911
TC
78[downloads]
79; if true, an order must be marked paid for before the user can download
80; the files attached to the products
81;must_be_paid = yes
82; if true, an order must be marked filled before the user can download the
83; files attached to the products
84;must_be_filled = yes
721cd24c
TC
85
86[children of 5]
87template=common/sidebar.tmpl
88template_dirs=sidebar
b19047a6
TC
89
90[extra tags]
b19047a6 91siteUrl = $(site/url)
2a295ea9
TC
92siteName = $(site/name)
93; You can add any static tag definitions you like here
94; salesEmail = someone@yoursite.com
95; salesPhoneNo = 61 2 9999 8888
531fb3bc
TC
96
97[datadump]
98# where to email the data dump
99#to = someone@somewhere
100# program to run to do the dump
101# must take the same parameters as mysqldump
d09682dd 102#mysqldump = /usr/local/mysql/bin/mysqldump
531fb3bc
TC
103
104[subscriptions]
105# if override is non-zero then the fields for the archiving and templates
106# will be available when sending a subscription
107override=1
108
ca9aa2bf
TC
109[level names]
1100=Your Site
918735d1
TC
1111=Page Lev1
1122=Page Lev2
1133=Page Lev3
1144=Page Lev4
1155=Page Lev5
ca9aa2bf
TC
116
117[articles]
118shop=3
caa7299c 119
08123550
TC
120[shop]
121payment_types=0,1,2
122address1=First address line in configuration
123address2=Second address line in configuration
124address3=Third address line in configuration
7b81711b 125enabled=1
d49f56a6
TC
126display_billAddress=Billing Address
127display_name1=First Name
128display_name2=Last Name
129display_address=Address
08123550 130
caa7299c
TC
131[level 1]
132template=common/default.tmpl
133
134[level 2]
135template=common/default.tmpl
136
137[level 3]
138template=common/default.tmpl
139
140[level 4]
141template=common/default.tmpl
142
143[level 5]
144template=common/default.tmpl
145
146[catalogs]
147template=catalog.tmpl
148
149[products]
150template=shopitem.tmpl
08123550 151
cc9019d1
TC
152[templates]
153admin/edit_2=admin/edit_1
154admin/edit_3=admin/edit_1
155admin/edit_4=admin/edit_1
156admin/edit_5=admin/edit_1
157admin/edit_img=admin/article_img
158admin/edit_file=admin/filelist
159
2076966c
TC
160; this used to be handled via the edit target, but since CVS sucks
161; I won't rename the template
162admin/users/view_orders=admin/users/edit_orders
163
08123550 164[Global permissions]
de193691
TC
165change_body = 8
166change_body_no_shop = 9
167full_access = 0
168full_access_no_shop = 3
08123550 169shop_access = 1
de193691
TC
170shop_orders = 5
171subscriptions = 4
172users_and_groups = 6
6555857d
TC
173confirm_members = 12
174manage_members = 13
08123550
TC
175
176[Article permissions]
de193691 177change_body_doc = 2
7b81711b 178change_body_decendants = 10
de193691 179full_access_doc = 7
7b81711b 180full_access_decendants = 11
08123550 181
de193691
TC
182[permission change_body]
183brief=Title & body (Site)
184help=The user has permission to change only the title & body of all articles or products.
185permissions=edit_field_edit_body,edit_field_edit_title,edit_save
08123550 186descendants=1
de193691 187articles=-1
08123550 188
de193691
TC
189[permission change_body_no_shop]
190brief=Title & body except shop admin
191help=The user has permission to change only the title & body of all
192articles except for the shop.
abf5bbc6 193permissions=edit_field_edit_body,edit_field_edit_title,edit_save
de193691
TC
194descendants=1
195articles=not(3)
08123550 196
de193691
TC
197[permission full_access]
198brief=Full access (Site)
199help=Full access to the article. The user can modify all modifiable fields, delete and add articles at will.
7dd6ebae 200permissions=edit_*,regen_*,bse_*
08123550 201descendants=1
de193691 202articles=-1
08123550 203
de193691
TC
204[permission full_access_no_shop]
205brief=Full access except shop admin
206help=The user has complete access to all articles except for the shop.
207permissions=edit_*,regen_*
08123550 208descendants=1
de193691
TC
209articles=not(3)
210
211[permission shop_access]
212brief=Shop administration
213help=The user has complete access to catalogs or products in the shop.
9168c88c 214permissions=not(admin_*)
de193691
TC
215descendants=1
216articles=3
08123550 217
de193691
TC
218[permission shop_orders]
219brief=Shop orders management
220help=The user can view the order list, order details, and mark orders filled.
221permissions=shop_order_*
da6bc286 222articles=-1
da6bc286 223
de193691
TC
224[permission subscriptions]
225brief=Subscriptions management
226help=The user can create, edit and send subscriptions.
227permissions=subs_*
da6bc286 228articles=-1
da6bc286
TC
229
230[permission users_and_groups]
da6bc286 231brief=User/Group management
de193691 232help=The user can manage users, groups and their permissions.
da6bc286 233permissions=admin_*
de193691
TC
234articles=-1
235
236[permission change_body_doc]
237brief=Title & body (Article)
238help=The user has permission to change only the title & body of this
239article or product.
240permissions=edit_field_edit_body,edit_field_edit_title,edit_save
241
7b81711b
TC
242[permission change_body_decendants]
243brief=Title & body (Article + Decendants)
244help=The user has permission to change only the title & body of this article or product and it's decendants.
245permissions=edit_field_edit_body,edit_field_edit_title,edit_save
246descendants=1
247
de193691
TC
248[permission full_access_doc]
249brief=Full access (Article)
250help=Full access to the article. The user can modify all modifiable
251fields for this article or product.
252permissions=edit_*,regen_*
da6bc286 253
7b81711b
TC
254[permission full_access_decendants]
255brief=Full access (Article + Decendants)
256help=Full access to the article and it's decendants. The user can modify all modifiable fields for this article or product.
257permissions=edit_*,regen_*
258descendants=1
918735d1 259
6555857d
TC
260[permission confirm_members]
261brief=Confirm member email address
262help=The user can manually mark a members email address as confirmed.
263permissions=bse_members_confirm
264articles=-1
265
266[permission manage_members]
267brief=Member management
268help=The user can manage site members
269permissions=bse_members_user_*,bse_members_group_*
270articles=-1
271
918735d1
TC
272[article flags]
273I=Index even if hidden
cc9019d1
TC
274N=Don't index even if listed
275C=Don't index this article or it's descendants
efcc5a30 276R=Regenerate even if we're using JIT regen (dynamic pages only)
63e99d77 277F=Descendants inherit Always Dynamic
918735d1
TC
278
279[article 1]
280extra_templates=index.tmpl
281
282[article 2]
283extra_templates=index2.tmpl
b553afa2
TC
284
285[reports]
286sales_summ_by_product=Sales Summary By Product
287product_sales_over_time=Product Sales Over Time
2d873eb6
TC
288monthly_sales=Monthly Sales
289quarterly_sales=Quarterly Sales
290weekly_sales=Weekly Sales
291yearly_sales=Yearly Sales
292total_sales=Total Sales
293users_vs_orders=Users vs Orders
9063386f 294user_products=Products bought by User
988d8721 295bse_test=Test report
b553afa2
TC
296
297[report sales_summ_by_product]
2d873eb6 298sql1=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
299sql1link1=<a href="/cgi-bin/admin/report.pl?s_show=1&r=product_sales_over_time&p1=${Id}">Sales Over Time</a>
300sql1link2=<a href="/cgi-bin/admin/add.pl?id=${Id}">Edit</a>
9615cff6
TC
301sort1=-Units;By Unit from highest;order by 3 desc
302sort2=+Units;By Unit;order by 3
303sort3=+Product;Product name;order by 2
304sort4=-Product;Reverse product name;order by 2 desc
b553afa2
TC
305
306[report product_sales_over_time]
2d873eb6 307sql1=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 308sql1params=1
b553afa2 309param1=product,Product
9615cff6
TC
310sort1=-Year;Reverse time order;order by 1 desc, 2 desc
311sort2=+Year;Time order;order by 1 asc, 2 asc
312sort3=-Units;By units desc;order by 3 desc
313sort4=+Units;By units asc;order by 3 asc
b553afa2 314
2d873eb6
TC
315[report weekly_sales]
316sql1=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
317
318[report monthly_sales]
319sql1=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
320
321[report quarterly_sales]
322sql1=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
323
324[report yearly_sales]
325sql1=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
326
327[report total_sales]
328sql1=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
329
330[report user_products]
331sql1=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
332sql1params=1
333param1=site_user,User
2d873eb6
TC
334
335[report users_vs_orders]
336sql1=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
337
b553afa2
TC
338[report datatype product]
339type=sql
340sql=select ar.id as "id", ar.title as "label" from article ar, product pr where ar.id = pr.articleId order by 2
650a6188
TC
341novalues=[ You don't have any products ]
342
343[report datatype article]
344type=sql
345sql=select id, concat(title, ' (', id, ')') as "label" from article
77804754 346
2d873eb6
TC
347[report datatype site_user]
348type=sql
349sql=select id, userId as "label" from site_users
350novalues=[ There are no registered users ]
351
988d8721
TC
352[report bse_test]
353sql1=select id, title from article where id = ?
354hide=1
355param1=article,Article
356sql1params=1
357
77804754
TC
358[valid child types]
359Article=Article
360Catalog=Catalog,Product
361Product=
95989433
TC
362
363[protect link]
364; articles for which the link field should not be overwritten
365; the values are ignored, but you can include descriptions
3661=home page
3673=shop
3686=formatting guide
3697=RDF
2a295ea9 370
ab2cd916
TC
371[editor]
372;allow_thumbs=1
373;thumbs_class=BSE::Thumb::Imager
374
2a295ea9
TC
375[site users]
376display_name1=First Name
377display_name2=Last Name
378display_address=Street
379display_postcode=Post code
380display_telephone=Phone
829c9ed9 381
2076966c
TC
382[nonajax user agents]
383ie4=MSIE
384
385[ajax user agents]
38de0036 386mozilla=^Mozilla/5\.0
2076966c
TC
387
388[ajax definitions]
389includes=inline:<script type="text/javascript" src="/js/prototype.js"></script>
390
0eb78304
TC
391[nuser controllers]
392user=BSE::UI::User
5af99440 393redirect=BSE::UI::Redirect
e7367b88
TC
394shop=BSE::UI::Shop
395search=BSE::UI::Search
396page=BSE::UI::Page
85aba847 397default=shop
e7367b88 398
4c4d3c3f
TC
399[nadmin controllers]
400shop=BSE::UI::AdminShop
0eb78304 401
829c9ed9
TC
402[includes]
40300bsecfg_d=bsecfg_d/
40450local=bse-local.cfg