• Welcome to SQLitening Support Forum.


Welcome to the SQLitening support forums!

Main Menu

Source code - Remote Ip/Port added to SQLiteningServer.log

Started by cj, February 17, 2018, 01:02:23 AM

Previous topic - Next topic



stop server by running SQLiteningServerAdmin.exe
download using link at bottom of page
extract  sqliteningserver.bas from the sqliteningserver .zip (it is the only file in there)
put sqliteningserver.bas into your \src folder with the other SQLitening source files
open SQLiteningServer.Bas in the PBEditor
#COMPILE EXE "c:\something\bin\SQLiteningServer"
start server by running SQLiteningServerAdmin.exe

'SqliteningServer.bas can now be compiled with a click
'SUB LogIt(BYVAL rlEntryType AS LONG, rsEntryData AS STRING)
'  Before: PRINT #gwLogFileNumber, REMOVE$(RIGHT$(DATE$, 2) & LEFT$(DATE$, 5) & TIME$, ANY "-:") & " " & _ ...
'  Now  : PRINT #gwLogFileNumber, DATE$  & " " & TIME$ & " " & _ ...

02-17-2018 14:19:23 Conn #24 SK 584 CJ MYCOMPUTER  ( on port 54349)
180217141923        Conn #24 SK 584 CJ MYCOMPUTER  (before change)

At the bottom of the source (sqliteningserver.bas) is the new function PBgetIPandPort.
Date and time was a a simple change to the function Logit Date$ & " " & Time$

It is now easier to add other features to SQLiteningServer.Bas without getting type mismatches and
having to modify DECLARE and TYPE statements because win32api.inc is now used.

Here is an updated SqliteningServer.bas in a .zip file

Bern Ertl

Fredrick Ughimi

Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet


Downloaded 97-times.
Wonder if anyone uses it?

Might add a new function or two to see if it would
be easier and faster than using the Procs method.
The code compiles "as is" with the update above.


Instructions added to post #1