Help me about Hit counter using DB and Global.asax

yoord · October 11th, 2004, 05:31 PM

hi every one i am developping a hit counter that uses Session_Start() event to increment for totall site viewer and decrementing when a session is expire or when the user left or End_Session() event fires but i see some incossistency in this approche the the first maybe works correct but the second seems that dont work correctly any idea about this how i can do this .
Thanks in advance.
YoOrD.

Beauty Is not on the face
Beauty is on the heart
--<<Ghibran Khalil>>--

yoord · October 11th, 2004, 05:36 PM

the SP is some thing like this

Quote:

quote:
create proc sp_update_counters_logout as

declare @cur int
select @cur=count_cur from counter
if(@cur>=1)
   begin
       set @cur=@cur-1
       update counter set count_cur=@cur where id=1
   end

GO
and
CREATE proc sp_update_counter as
declare @cnt int
declare @cur int
select @cnt=count_all,@cur=count_cur from counter
set @cnt=@cnt+1
set @cur=@cur+1
update counter set count_all=@cnt,count_cur=@cur where id=1
return @cnt
GO

Beauty Is not on the face
Beauty is on the heart
--<<Ghibran Khalil>>--

yoord · October 14th, 2004, 06:30 AM

hi every one any idea about hitcounter using session_start() event and DB.
thanks in advance.
YoOrD.

Beauty Is not on the face
Beauty is on the heart
--<<Ghibran Khalil>>--

yoord · October 16th, 2004, 05:02 AM

hi every one
i need help about this tipic that if this type of hitcounter work correctly or not any one give idea about this topic please.
Thanks in advance.
YoOrD.

Beauty Is not on the face
Beauty is on the heart
--<<Ghibran Khalil>>--