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