30 svar · 368 visningar · startad av jboy_87
varför plussas det dubbelt??:
minutes = datediff("n",cdate(session("totalminonline")),now())
Set connect55 = server.createobject("adodb.connection")
Connect55.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect55.execute "update members set totalminonline = totalminonline +" & minutes & " where id = " & session("id"),,128
------------------
ASP är bäst fuck the rest!!!
annars kan du alltid testa detta:
Response.Write(TypeName(minutes))
så får du se vad det är för typ på varibeln minutes!
------------------
FEL!!
FÖR MYCKET NAKENHET I SIGNATUREN
[Redigerat av webzonen den 06 jan 2002]
Session("totalminonline") = now() när man loggar in
------------------
ASP är bäst fuck the rest!!!
Hmm.....testa att göra om minutes till en integer...
minutes = datediff("n",cdate(session("totalminonline")),now())
Set connect55 = server.createobject("adodb.connection")
Connect55.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect55.execute "update members set totalminonline = totalminonline + " & cint(trim(minutes)) & " where id = " & session("id"),,128
EDIT: fattade fel....
------------------
mvh
Harback
HiFiguiden.nu
[Redigerat av Harback den 06 jan 2002]
så här ser hela ut:
<%
minutes = datediff("n",cdate(session("minonline")),now())
response.write "" & minutes & "" %><%minutes = datediff("n",cdate(session("minonline")),now())
set connect22 = server.createobject("adodb.connection")
Connect22.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect22.execute "update members set minonline = " & minutes & " where id = " & session("id"),,128
minutes = datediff("n",cdate(session("minonline")),now())
if minutes > 60 then
points = 3
connect22.execute "update members set minonline = " & minutes & " , poang = " & points &" where id = " & session("id"),,128
Connect22.close
Set Connect22 = nothing
end if
minutes2 = datediff("n",cdate(session("totalminonline")),now())
Set connect55 = server.createobject("adodb.connection")
Connect55.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect55.execute "update members set totalminonline = totalminonline + 0" & minutes2 & " where id = " & session("id"),,128
%>
------------------
ASP är bäst fuck the rest!!!
först uppdaterar du minutes en gång här
<%
minutes = datediff("n",cdate(session("minonline")),now())
response.write "" & minutes & "" %><%minutes = datediff("n",cdate(session("minonline")),now())
set connect22 = server.createobject("adodb.connection")
Connect22.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect22.execute "update members set minonline = " & minutes & " where id = " & session("id"),,128
minutes = datediff("n",cdate(session("minonline")),now())
if minutes > 60 then
points = 3
connect22.execute "update members set minonline = " & minutes & " , poang = " & points &" where id = " & session("id"),,128
Connect22.close
Set Connect22 = nothing
end if
sen uppdaterar du den en gång till här
minutes2 = datediff("n",cdate(session("totalminonline")),now())
Set connect55 = server.createobject("adodb.connection")
Connect55.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect55.execute "update members set totalminonline = totalminonline + 0" & minutes2 & " where id = " & session("id"),,128
%>
inte konstigt att det blir dubbelt :)
------------------
kolung.....det tål att tänkas på!
mär jag tittat lite närmare så märkte jar att om man har varit där i mer än 60 minuter uppdateras minuterna 3 ggr..... :OO
------------------
kolung.....det tål att tänkas på!
Vad är det du inte fattar... ;)
här lägger du in totalminutes första gången:
<%
minutes = datediff("n",cdate(session("minonline")),now())
response.write "" & minutes & "" %><%minutes = datediff("n",cdate(session("minonline")),now())
set connect22 = server.createobject("adodb.connection")
Connect22.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect22.execute "update members set minonline = " & minutes & " where id = " & session("id"),,128
sen uppdaterar du tabellen en gång till om man varit inloggad 60 minuter
minutes = datediff("n",cdate(session("minonline")),now())
if minutes > 60 then
points = 3
connect22.execute "update members set minonline = " & minutes & " , poang = " & points &" where id = " & session("id"),,128
Connect22.close
Set Connect22 = nothing
end if
och sen uppdaterar du en sista gång
minutes2 = datediff("n",cdate(session("totalminonline")),now())
Set connect55 = server.createobject("adodb.connection")
Connect55.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect55.execute "update members set totalminonline = totalminonline + 0" & minutes2 & " where id = " & session("id"),,128
%>
hmmmmmm ......varför vet jag inte
------------------
kolung.....det tål att tänkas på!