Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Forum : Discussion :

how to make an insert in User Table

Nov 13, 2003, 11:48 PM
hoefti
User (190 posts)
hoefti's avatar
Nov 13, 2003, 11:48 PM
Post #1 of 3
Views: 2664
Shortcut
Quote Reply
how to make an insert in User Table
hello i would like to make an insert from forum_vie.html when a user go in this forum

like
<%if forum_id =1%>
<input type="hidden" name="go_in_forum" value="date">
<%endif%>

i would save the date when last login

is this possible?

thanks hoefti
linktobuy Web Directory
Ratgeber Recht
Nov 14, 2003, 11:14 AM
Jagerman
Staff / Moderator (2198 posts)
Jagerman's avatar
Nov 14, 2003, 11:14 AM
Post #2 of 3
Views: 2577
Shortcut
Quote Reply
Re: [hoefti] how to make an insert in User Table In reply to
If I understand correctly, it might be best to create a global code variable that does the update, then use:

Code:
<%if forum_id = 1%><%update_user($current_user_id)%><%endif%>

The update_user global would look something like:

Code:
sub { my $user_id = shift; $DB->table('User')->update({ some_column => time }, { user_id => $user_id }); return }

The update_user global will only be called when forum_id is '1'.
Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Nov 26, 2003, 6:47 AM
hoefti
User (190 posts)
hoefti's avatar
Nov 26, 2003, 6:47 AM
Post #3 of 3
Views: 2546
Shortcut
Quote Reply
Re: [Jagerman] how to make an insert in User Table In reply to
Hello Jagerman

Thanks, its works

greeting hoefti
linktobuy Web Directory
Ratgeber Recht