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