GoldMine Table Definitions

GoldMine web import forms and GoldMine API programming, Automatic Web Update software

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API

The home of IRCDominatorXT, NETUpdate automatic web update and GMGoldLINK the new GoldMine API

» Home Page
» My Forum
» Email Me
» My Shop

»Affiliate Market«
»Featured Product

»GoldMine«
     »GoldFORM
     »GoldMine API
     »GoldMine Tables
     »Services
     »Downloads

»NETUpdate Suite«
     »Client
     »Admin Part1
     »Admin Part2
     »ActiveX
     »Features
     »News
     »Downloads

»Visual Basic Stuff«
     »CodeSmartX
     »PikLink
     »Links

»Fun Stuff«

Old Projects

»IRCDominatorXT«
     »Latest
     »Known Bugs
     »Using Passport
     »Trouble Shoot
     »Downloads

»Legend Of Mir2«
     »Server Config
     »Converter
     »Browser
     »Other

»Work In Progress«

� Downloads

USERLOG

DBase Directory Location: GMBASE
Table Description: Log file of user logins, duration and amount of work completed. Displayed in the
GoldMine system logs.

Table Indexes
Name	DBase Index	SQL Index	ID
USERLOG	USERID+LOGIN	USERID+LOGIN	-
ULGRECID	RECID	RECID	-

Table Relationships
Field
None

Table Fields Structure
Field Name	Field Type	Length	Description
CRC	String	2	CRC code used as an integrity check to prevent tampering from outside sources.
USERID	String	8	User Name
LOGIN	String	14	Time logged in (Format YYYYMMDD HH:MM)
LOGOUT	String	14	Time logged Out (Format YYYYMMDD HH:MM)
INOUT	Integer	2	Number of times user logged in. If more than 1, Track Daily Totals has been turned on for this user.
DUR	Long	4	Number of minutes logged in. If Track Daily Totals is turned on, this is the total login time for the day.
KEYS	Long	4	Number of keys pressed
CLICKS	Long	4	Number of mouse clicks
RECID	String	15	Record ID

Your IP Address is: 162.158.79.56

Questions Answered

Articles Written

Overall Points

Do you want to
exchange links?
Click on my banner
for more information.

I can't even believe in skepticism anymore.

-- David Pavlovitch

Darren Lawrence aka MrEnigma/AbsoluteGenius