3 ; url should not include a trailing /
4 url=http://your.site.base
8 randomdata = /dev/urandom
12 ; the following needs to be set to a path writable by the BSE processes
13 downloads = /somewhere
14 siteuser_images = $(paths/downloads)
15 dynamic_cache=$(paths/downloads)/../cache
19 ; the following are required by the system - don't modify them
20 user/orderdetail.tmpl = user,user/base_orderdetail.tmpl
21 user/alreadyblacklisted.tmpl = user,user/alreadyblacklisted_base.tmpl
22 user/blacklistdone.tmpl = user,user/blacklistdone_base.tmpl
23 user/cantunsub.tmpl = user,user/cantunsub_base.tmpl
24 user/confirmed.tmpl = user,user/confirmed_base.tmpl
25 user/confsent.tmpl = user,user/confsent_base.tmpl
26 user/confsent_nop.tmpl = user,user/confsent_nop_base.tmpl
27 user/email_conferror.tmpl = user,user/email_conferror_base.tmpl
28 user/logon.tmpl = user,user/logon_base.tmpl
29 user/lostemailsent.tmpl = user,user/lostemailsent_base.tmpl
30 user/lostpassword.tmpl = user,user/lostpassword_base.tmpl
31 user/lostpwdemail.tmpl = user,user/lostpwdemail_base.tmpl
32 user/nopassword.tmpl = user,user/nopassword_base.tmpl
33 user/options.tmpl = user,user/options_base.tmpl
34 user/options_saved.tmpl = user,user/options_saved_base.tmpl
35 user/options_billing.tmpl = user,user/options_billing_base.tmpl
36 user/options_images.tmpl = user,user/options_images_base.tmpl
37 user/register.tmpl = user,user/register_base.tmpl
38 user/toomany.tmpl = user,user/toomany_base.tmpl
39 user/toosoon.tmpl = user,user/toosoon_base.tmpl
40 user/unsuball.tmpl = user,user/unsuball_base.tmpl
41 user/unsubone.tmpl = user,user/unsubone_base.tmpl
42 user/userpage.tmpl = user,user/userpage_base.tmpl
43 interest/confirm.tmpl = interest,interest/confirm_base.tmpl
44 interest/askagain.tmpl = interest,interest/askagain_base.tmpl
45 interest/error.tmpl = interest,interest/error_base.tmpl
46 formmail/defquery.tmpl = formmail,formmail/defquery_base.tmpl
47 formmail/defdone.tmpl = formmail,formmail/defdone_base.tmpl
50 title = My $(site/name)
53 title = $(site/name) Interest Registration
56 title = Send us a comment
59 user/notyourorder = Order $1 isn't your order
60 shop/fileitems = You have products in your cart that include downloadable files. Please logon or register before checking out.
61 shop/logonrequired = This site requires that you be logged on to make a purchase. Please logon or register before checking out.
64 ; if true, an order must be marked paid for before the user can download
65 ; the files attached to the products
67 ; if true, an order must be marked filled before the user can download the
68 ; files attached to the products
72 template=common/sidebar.tmpl
77 siteName = $(site/name)
78 ; You can add any static tag definitions you like here
79 ; salesEmail = someone@yoursite.com
80 ; salesPhoneNo = 61 2 9999 8888
83 # where to email the data dump
84 #to = someone@somewhere
85 # program to run to do the dump
86 # must take the same parameters as mysqldump
87 #mysqldump = /usr/local/mysql/bin/mysqldump
90 # if override is non-zero then the fields for the archiving and templates
91 # will be available when sending a subscription
107 address1=First address line in configuration
108 address2=Second address line in configuration
109 address3=Third address line in configuration
111 display_billAddress=Billing Address
112 display_name1=First Name
113 display_name2=Last Name
114 display_address=Address
117 template=common/default.tmpl
120 template=common/default.tmpl
123 template=common/default.tmpl
126 template=common/default.tmpl
129 template=common/default.tmpl
132 template=catalog.tmpl
135 template=shopitem.tmpl
138 admin/edit_2=admin/edit_1
139 admin/edit_3=admin/edit_1
140 admin/edit_4=admin/edit_1
141 admin/edit_5=admin/edit_1
142 admin/edit_img=admin/article_img
143 admin/edit_file=admin/filelist
147 change_body_no_shop = 9
149 full_access_no_shop = 3
155 [Article permissions]
157 change_body_decendants = 10
159 full_access_decendants = 11
161 [permission change_body]
162 brief=Title & body (Site)
163 help=The user has permission to change only the title & body of all articles or products.
164 permissions=edit_field_edit_body,edit_field_edit_title,edit_save
168 [permission change_body_no_shop]
169 brief=Title & body except shop admin
170 help=The user has permission to change only the title & body of all
171 articles except for the shop.
172 permissions=edit_field_edit_body,edit_field_edit_title,edit_save
176 [permission full_access]
177 brief=Full access (Site)
178 help=Full access to the article. The user can modify all modifiable fields, delete and add articles at will.
179 permissions=edit_*,regen_*,bse_*
183 [permission full_access_no_shop]
184 brief=Full access except shop admin
185 help=The user has complete access to all articles except for the shop.
186 permissions=edit_*,regen_*
190 [permission shop_access]
191 brief=Shop administration
192 help=The user has complete access to catalogs or products in the shop.
193 permissions=not(admin_*)
197 [permission shop_orders]
198 brief=Shop orders management
199 help=The user can view the order list, order details, and mark orders filled.
200 permissions=shop_order_*
203 [permission subscriptions]
204 brief=Subscriptions management
205 help=The user can create, edit and send subscriptions.
209 [permission users_and_groups]
210 brief=User/Group management
211 help=The user can manage users, groups and their permissions.
215 [permission change_body_doc]
216 brief=Title & body (Article)
217 help=The user has permission to change only the title & body of this
219 permissions=edit_field_edit_body,edit_field_edit_title,edit_save
221 [permission change_body_decendants]
222 brief=Title & body (Article + Decendants)
223 help=The user has permission to change only the title & body of this article or product and it's decendants.
224 permissions=edit_field_edit_body,edit_field_edit_title,edit_save
227 [permission full_access_doc]
228 brief=Full access (Article)
229 help=Full access to the article. The user can modify all modifiable
230 fields for this article or product.
231 permissions=edit_*,regen_*
233 [permission full_access_decendants]
234 brief=Full access (Article + Decendants)
235 help=Full access to the article and it's decendants. The user can modify all modifiable fields for this article or product.
236 permissions=edit_*,regen_*
240 I=Index even if hidden
241 N=Don't index even if listed
242 C=Don't index this article or it's descendants
243 R=Regenerate even if we're using JIT regen (dynamic pages only)
246 extra_templates=index.tmpl
249 extra_templates=index2.tmpl
252 sales_summ_by_product=Sales Summary By Product
253 product_sales_over_time=Product Sales Over Time
254 monthly_sales=Monthly Sales
255 quarterly_sales=Quarterly Sales
256 weekly_sales=Weekly Sales
257 yearly_sales=Yearly Sales
258 total_sales=Total Sales
259 users_vs_orders=Users vs Orders
260 user_products=Products bought by User
263 [report sales_summ_by_product]
264 sql1=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
265 sql1link1=<a href="/cgi-bin/admin/report.pl?s_show=1&r=product_sales_over_time&p1=${Id}">Sales Over Time</a>
266 sql1link2=<a href="/cgi-bin/admin/add.pl?id=${Id}">Edit</a>
268 [report product_sales_over_time]
269 sql1=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
271 param1=product,Product
273 [report weekly_sales]
274 sql1=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
276 [report monthly_sales]
277 sql1=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
279 [report quarterly_sales]
280 sql1=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
282 [report yearly_sales]
283 sql1=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
286 sql1=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
288 [report user_products]
289 sql1=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
291 param1=site_user,User
293 [report users_vs_orders]
294 sql1=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
296 [report datatype product]
298 sql=select ar.id as "id", ar.title as "label" from article ar, product pr where ar.id = pr.articleId order by 2
299 novalues=[ You don't have any products ]
301 [report datatype article]
303 sql=select id, concat(title, ' (', id, ')') as "label" from article
305 [report datatype site_user]
307 sql=select id, userId as "label" from site_users
308 novalues=[ There are no registered users ]
311 sql1=select id, title from article where id = ?
313 param1=article,Article
318 Catalog=Catalog,Product
322 ; articles for which the link field should not be overwritten
323 ; the values are ignored, but you can include descriptions
331 ;thumbs_class=BSE::Thumb::Imager
334 display_name1=First Name
335 display_name2=Last Name
336 display_address=Street
337 display_postcode=Post code
338 display_telephone=Phone
342 50local=bse-local.cfg