insert into <@PREFIX@>jshopping_users
(
user_id,
u_name,
title,
firma_name,
f_name,
l_name,
number,
street,
zip,
city,
country,
usergroup_id)
values
('<@KEY@>',
'<@SEMAIL@>',
'<@GENDER@>',
'<@COMPNAME@>',
'<@NAME@>',
'<@LASTNAME@>',
'<@KEY@>',
'<@SPOSTAL1@>',
'<@SPOSTALCODE@>',
'<@SPOSTAL2@>',
<@PROCESS@>&SELECT `country_id` from <@PREFIX@>jshopping_countries where `name_nl-NL` = '<@COUNTRIES_NAME@>'##,
'2')
@@GO@@
insert into <@PREFIX@>user_usergroup_map
(user_id,
group_id)
values(
'<@KEY@>',
'2')
@@GO@@




