SQLitening Support Forum

General => General Board => Topic started by: cj on February 17, 2018, 01:02:23 am

Title: Source code - Remote Ip/Port added to SQLiteningServer.log
Post by: cj on February 17, 2018, 01:02:23 am


SQLiteningServer.Bas

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

'Notes:
'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$ & " " & _ ...
'END SUB


02-17-2018 14:19:23 Conn #24 SK 584 CJ MYCOMPUTER 192.168.0.2  (92.132.13.133 on port 54349)
180217141923        Conn #24 SK 584 CJ MYCOMPUTER 192.168.0.2  (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
Title: Re: Remote Ip/Port added to SQLiteningServer.log
Post by: Bern Ertl on February 19, 2018, 11:51:06 am
Interesting changes cj.  Thanks.
Title: Re: Source code - Remote Ip/Port added to SQLiteningServer.log
Post by: Fredrick Ughimi on May 08, 2018, 10:19:05 am
Thank you CJ.
Title: Re: Source code - Remote Ip/Port added to SQLiteningServer.log
Post by: cj on July 21, 2019, 11:11:50 am
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.
Title: SqliteningServer.bas download/recompile instructions
Post by: cj on July 22, 2019, 09:52:34 am
Instructions added to post #1