select id from #variables.tableprefix#users where username = To complete your registration at #variables.title#, please click on the link below. #application.galleon.settings.rooturl#confirm.cfm?u=#newid# insert into #variables.tableprefix#users(id,username,password,emailaddress,datecreated,confirmed,signature) values(, , , , , , '' ) insert into #variables.tableprefix#users_groups(useridfk,groupidfk) values(,) select id from #variables.tableprefix#users where username = and password = and confirmed = 1 select id from #variables.tableprefix#users where id = update #variables.tableprefix#users set confirmed = 1 where id = delete from #variables.tableprefix#users_groups where useridfk = delete from #variables.tableprefix#users where id = delete from #variables.tableprefix#subscriptions where useridfk = select id from #variables.tableprefix#groups where [group] #variables.tableprefix#groups.group = select id, [group] #variables.tableprefix#groups.group from #variables.tableprefix#groups select #variables.tableprefix#groups.[group] select #variables.tableprefix#groups.group from #variables.tableprefix#users, #variables.tableprefix#groups, #variables.tableprefix#users_groups where #variables.tableprefix#users_groups.useridfk = #variables.tableprefix#users.id and #variables.tableprefix#users_groups.groupidfk = #variables.tableprefix#groups.id and #variables.tableprefix#users.username = select id, threadidfk, forumidfk, conferenceidfk from #variables.tableprefix#subscriptions where useridfk = select #variables.tableprefix#users.id, #variables.tableprefix#users.username, #variables.tableprefix#users.password, #variables.tableprefix#users.emailaddress, #variables.tableprefix#users.datecreated, #variables.tableprefix#users.confirmed, #variables.tableprefix#users.signature from #variables.tableprefix#users where #variables.tableprefix#users.username = select count(id) as postcount from #variables.tableprefix#messages where useridfk = select id from #variables.tableprefix#users where username = select username from #variables.tableprefix#users where id = select #variables.tableprefix#users.id, #variables.tableprefix#users.username, #variables.tableprefix#users.password, #variables.tableprefix#users.emailaddress, #variables.tableprefix#users.datecreated, count(#variables.tableprefix#messages.id) as postcount, #variables.tableprefix#users.confirmed from #variables.tableprefix#users left join #variables.tableprefix#messages on #variables.tableprefix#users.id = #variables.tableprefix#messages.useridfk group by #variables.tableprefix#users.id, #variables.tableprefix#users.username, #variables.tableprefix#users.password, #variables.tableprefix#users.emailaddress, #variables.tableprefix#users.datecreated, #variables.tableprefix#users.confirmed order by #variables.tableprefix#users.username delete from #variables.tableprefix#users_groups where useridfk = update #variables.tableprefix#users set emailaddress = , password = , datecreated = , confirmed = , signature = where username = select useridfk from #variables.tableprefix#subscriptions where conferenceidfk = forumidfk = threadidfk = and useridfk = insert into #variables.tableprefix#subscriptions(id,useridfk, conferenceidfk forumidfk threadidfk ) values(, , ) delete from #variables.tableprefix#subscriptions where id = and useridfk =