User:Dt192 - Revision history

Dt192 at 09:42, 16 February 2026

2026-02-16T09:42:35Z

Dt192 at 09:42, 16 February 2026

2026-02-16T09:42:08Z

Dt192 at 14:21, 30 January 2025

2025-01-30T14:21:07Z

Dt192 at 12:05, 21 September 2024

2024-09-21T12:05:30Z

Dt192 at 19:22, 19 September 2024

2024-09-19T19:22:47Z

Dt192 at 01:59, 3 February 2024

2024-02-03T01:59:28Z

Dt192 at 05:27, 31 January 2024

2024-01-31T05:27:06Z

Dt192 at 04:30, 31 January 2024

2024-01-31T04:30:41Z

Dt192 at 04:21, 31 January 2024

2024-01-31T04:21:33Z

Dt192 at 17:03, 30 January 2024

2024-01-30T17:03:18Z

@@ Line 34: / Line 34: @@
 Prints created sql statements
-<syntaxhighlight language="lua">
+<syntaxhighlight lang="lua">
 db.debug_sql  = true
 </syntaxhighlight>

@@ Line 42: / Line 42: @@
 [https://lunarmodules.github.io/luasql/manual.html luasql manual]
-<syntaxhighlight language="lua">
+<syntaxhighlight lang="lua">
 mydb = db:create("mydb",
+{

@@ Line 32: / Line 32: @@
 ...
 </pre>
 So i don't forget again. This is how you sent raw sql to the db and fetch the result

@@ Line 1: / Line 1: @@
-[[User:Dt192/Sandbox|Sandbox]]
+Sandboxes: [[User:Dt192/Sandbox|1]] / [[User:Dt192/Sandbox2|2]]
-[[User:Dt192/Sandbox2|Sandbox2]]
 <pre>

← Older revision		Revision as of 19:22, 19 September 2024
Line 1:		Line 1:
	[[User:Dt192/Sandbox\|Sandbox]]		[[User:Dt192/Sandbox\|Sandbox]]
		+	[[User:Dt192/Sandbox2\|Sandbox2]]

	<pre>		<pre>

← Older revision		Revision as of 01:59, 3 February 2024
Line 125:		Line 125:

	</syntaxhighlight>		</syntaxhighlight>
		+
		+	==Command line arguments==
		+	{\| class="wikitable"
		+	\| align="center" style="background:#f0f0f0;"\|'''Switch'''
		+	\| align="center" style="background:#f0f0f0;"\|'''Short'''
		+	\| align="center" style="background:#f0f0f0;"\|'''Action'''
		+	\|-
		+	\| --help\|\|-h\|\|displays this message.
		+	\|-
		+	\| --version\|\|-v\|\|displays version information.
		+	\|-
		+	\| --quiet\|\|-q\|\|no splash screen on startup.
		+	\|-
		+	\| --profile=<profile>\|\|-p\|\|additional profile to open, may be repeated.
		+	\|-
		+	\| --only=<predefined>\|\|-o\|\|make Mudlet only show the specific predefined game, may be repeated.
		+	\|-
		+	\|}
		+	There are other inherited options that arise from the Qt Libraries which are less likely to be useful for normal use of this application:
		+	{\| class="wikitable"
		+	\|-
		+	\| --dograb\|\|ignore any implicit or explicit -nograb. --dograb wins over --nograb even when --nograb is last on the command line.
		+	\|-
		+	\| --nograb\|\|the application should never grab the mouse or the keyboard.
		+	\|-
		+	\| --reverse\|\|sets the application's layout direction to right to left.
		+	\|-
		+	\| --style=style\|\|sets the application GUI style. Possible values depend on your system configuration. If Qt was compiled with additional styles or has additional styles as plugins these will be available to the -style command line option. You can also set the style for all Qt applications by setting the QT_STYLE_OVERRIDE environment variable.
		+	\|-
		+	\| --style style\|\|is the same as listed above.
		+	\|-
		+	\| --stylesheet=stylesheet\|\|sets the application styleSheet. The value must be a path to a file that contains the Style Sheet. Note: Relative URLs in the Style Sheet file are relative to the Style Sheet file's path.
		+	\|-
		+	\| --stylesheet stylesheet\|\|is the same as listed above.
		+	\|-
		+	\| --widgetcount\|\|prints debug message at the end about number of widgets left undestroyed and maximum number of widgets existing at the same time.
		+	\|-
		+	\| --qmljsdebugger=1234[,block]\|\|activates the QML/JS debugger with a specified port. The number is the port value and block is optional and will make the application wait until a debugger connects to it.
		+	\|-
		+	\|}

@@ Line 1: / Line 1: @@
 [[User:Dt192/Sandbox|Sandbox]]
-List of orphaned pages
 <pre>
-**Orphaned Pages**
+**List of orphaned pages**
 https://wiki.mudlet.org/w/Area_51/Mapping_script
 https://wiki.mudlet.org/w/Artists_performance_package

@@ Line 98: / Line 98: @@
    end
 end
 local query = [[
@@ Line 106: / Line 105: @@
 for row in rows(conn, query) do
    print(row.name, row.city, row.id)
 end
 </syntaxhighlight>

@@ Line 59: / Line 59: @@
 ---------------------------------------------------------------------------------------
-res = conn:execute("SELECT last_insert_rowid()")
+display(conn:getlastautoid())
 ----------------------------------------------------------------------------------------
-results = conn:execute([[SELECT city,name FROM mySheet WHERE city = 'Hallifax']])
+results = conn:execute[[
 local city,name = results:fetch()
@@ Line 91: / Line 91: @@
 ----------------------------------------------------------------------------------------
-function rows(connection, sql_statement)
+function rows(conn, query)
-   local cursor = assert (connection:execute (sql_statement))
+   local cursor = assert(conn:execute(query))
-   return function()
+  local res = {}
-     return cursor:fetch()
+   return function ()
    end
 end
-local query = [[SELECT id,city,name FROM mySheet WHERE id > 1 AND id < 5]]
-for id,city,name in rows(conn, query) do
+local query = [[
-   print (name, city, id)
+  select * from mySheet WHERE id > 1 AND id < 5
 end
 </syntaxhighlight>