Add new attachment

Only authorized users are allowed to upload new attachments.

List of attachments

Kind Attachment Name Size Version Date Modified Author Change note
png
insert_methods.png 112.2 kB 1 20-Aug-2020 04:28 krivacsz
jpg
sql_stats1.jpg 163.2 kB 1 07-Jul-2020 14:16 Ada Csaba

This page (revision-37) was last changed on 20-Aug-2020 04:41 by krivacsz

This page was created on 25-Oct-2018 04:31 by Ben Spink

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 51 changed 3 lines
3.
\\
3. Adjust insert queries. Remove the __RID__ value from all insert query.\\
\\
[attachments|insert_methods.png]\\
\\
Change __stats_insert_meta_info__ from:\\
{{{
INSERT INTO META_INFO (RID, SESSION_RID, TRANSFER_RID, ITEM_KEY, ITEM_VALUE) VALUES (?,?,?,?,?)
}}}\\
to:\\
{{{
INSERT INTO META_INFO (SESSION_RID, TRANSFER_RID, ITEM_KEY, ITEM_VALUE) VALUES (?,?,?,?)
}}}\\
\\
__stats_insert_sessions__ from:\\
{{{
INSERT INTO SESSIONS (RID, SESSION, SERVER_GROUP, USER_NAME, START_TIME, END_TIME, SUCCESS_LOGIN, IP) VALUES (?,?,?,?,?,?,?,?)
}}}\\
to:\\
{{{
INSERT INTO SESSIONS (SESSION, SERVER_GROUP, USER_NAME, START_TIME, END_TIME, SUCCESS_LOGIN, IP) VALUES (?,?,?,?,?,?,?)
}}}\\
\\
__stats_insert_transfers__ from:\\
{{{
INSERT INTO TRANSFERS (RID, SESSION_RID, START_TIME, DIRECTION, PATH, FILE_NAME, URL, SPEED, TRANSFER_SIZE, IGNORE_SIZE) VALUES (?,?,?,?,?,?,?,?,?,'N')
}}}\\
to:\\
{{{
INSERT INTO TRANSFERS (SESSION_RID, START_TIME, DIRECTION, PATH, FILE_NAME, URL, SPEED, TRANSFER_SIZE, IGNORE_SIZE) VALUES (?,?,?,?,?,?,?,?,'N')
}}}\\
Version Date Modified Size Author Changes ... Change note
37 20-Aug-2020 04:41 3.9 kB krivacsz to previous
36 20-Aug-2020 04:40 3.893 kB krivacsz to previous | to last
35 20-Aug-2020 04:39 3.531 kB krivacsz to previous | to last
34 20-Aug-2020 04:38 3.523 kB krivacsz to previous | to last
33 20-Aug-2020 04:37 3.196 kB krivacsz to previous | to last
32 20-Aug-2020 04:36 3.2 kB krivacsz to previous | to last
31 20-Aug-2020 04:36 3.196 kB krivacsz to previous | to last
30 20-Aug-2020 04:32 2.904 kB krivacsz to previous | to last
29 20-Aug-2020 04:32 2.916 kB krivacsz to previous | to last
28 20-Aug-2020 04:30 2.866 kB krivacsz to previous | to last
27 20-Aug-2020 04:28 2.831 kB krivacsz to previous | to last
26 20-Aug-2020 04:22 2.839 kB krivacsz to previous | to last
25 20-Aug-2020 04:21 2.839 kB krivacsz to previous | to last
24 20-Aug-2020 04:21 2.835 kB krivacsz to previous | to last
23 20-Aug-2020 04:20 2.829 kB krivacsz to previous | to last
22 20-Aug-2020 04:19 2.821 kB krivacsz to previous | to last
21 20-Aug-2020 04:18 2.656 kB krivacsz to previous | to last
« This page (revision-37) was last changed on 20-Aug-2020 04:41 by krivacsz
G’day (anonymous guest)
CrushFTP9 | What's New

Referenced by
General Settings

JSPWiki