Update the DBS - Postet den (901 Views)
Advanced Member
JJenson
Innlegg: 2121
2121
I am trying to write 2 siple scripts to go into the alternate mod setup. the first one is just supposed to keep adding one to the number everytime it is downloaded. would that be something like this?
[ALTER] MEMBERS
ADD#M_DOWNLOADED#int#NULL#1
[END]
The second one is just supposed to keep the last date something was downloaded would that be something like this?
[ALTER] MEMBERS
ADD#M_LASTDOWNLOAD#int#NULL#9\7\07
[END]
I don't want to add it in till I am sure but I think it is something like this?
Thanks<
   
 Sidestørrelse 
Postet den
Advanced Member
JJenson
Innlegg: 2121
2121
Nevermind got it the first one worked and the 2nd needed to be changed to

[ALTER] MEMBERS
ADD#M_LASTDOWNLOAD#VARCHAR(50)##
[END] <
Postet den
Support Moderator
Shaggy
Innlegg: 6780
6780
You only really need 14 characters to hold a date; yyyymmddhhmmss.
<
Search is your friend “I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Postet den
Advanced Member
JJenson
Innlegg: 2121
2121
Thanks Shaggy smile<
Postet den
Advanced Member
JJenson
Innlegg: 2121
2121
No worries I ended up getting it. smile<
 
Du må legge inn en melding