Update the DBS - نوشته شده در (900 Views)
Advanced Member
JJenson
مطلب: 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<
 پیش‌فرض مرتب‌سازی برای تاریخ DESC به معنی جدیدترین است  
 تعداد در صفحه 
نوشته شده در
Advanced Member
JJenson
مطلب: 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] <
نوشته شده در
Support Moderator
Shaggy
مطلب: 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.”
نوشته شده در
Advanced Member
JJenson
مطلب: 2121
2121
Thanks Shaggy smile<
نوشته شده در
Advanced Member
JJenson
مطلب: 2121
2121
No worries I ended up getting it. smile<
 
شما باید یک متن وارد کنید