corrade-lsl-templates – Diff between revs 15 and 24

Subversion Repositories:
Rev:
Only display areas with differencesIgnore whitespace
Rev 15 Rev 24
1 /////////////////////////////////////////////////////////////////////////// 1 ///////////////////////////////////////////////////////////////////////////
2 // Copyright (C) Wizardry and Steamworks 2016 - License: GNU GPLv3 // 2 // Copyright (C) Wizardry and Steamworks 2016 - License: GNU GPLv3 //
3 /////////////////////////////////////////////////////////////////////////// 3 ///////////////////////////////////////////////////////////////////////////
4 // 4 //
5 // A MOTD module for Corrade Eggdrop. 5 // A MOTD module for Corrade Eggdrop.
6 // 6 //
7 /////////////////////////////////////////////////////////////////////////// 7 ///////////////////////////////////////////////////////////////////////////
8   8
9 /////////////////////////////////////////////////////////////////////////// 9 ///////////////////////////////////////////////////////////////////////////
10 // Copyright (C) 2014 Wizardry and Steamworks - License: GNU GPLv3 // 10 // Copyright (C) 2014 Wizardry and Steamworks - License: GNU GPLv3 //
11 /////////////////////////////////////////////////////////////////////////// 11 ///////////////////////////////////////////////////////////////////////////
12 string wasKeyValueGet(string k, string data) { 12 string wasKeyValueGet(string k, string data) {
13 if(llStringLength(data) == 0) return ""; 13 if(llStringLength(data) == 0) return "";
14 if(llStringLength(k) == 0) return ""; 14 if(llStringLength(k) == 0) return "";
15 list a = llParseString2List(data, ["&", "="], []); 15 list a = llParseString2List(data, ["&", "="], []);
16 integer i = llListFindList(a, [ k ]); 16 integer i = llListFindList(a, [ k ]);
17 if(i != -1) return llList2String(a, i+1); 17 if(i != -1) return llList2String(a, i+1);
18 return ""; 18 return "";
19 } 19 }
20 20
21 /////////////////////////////////////////////////////////////////////////// 21 ///////////////////////////////////////////////////////////////////////////
22 // Copyright (C) 2013 Wizardry and Steamworks - License: GNU GPLv3 // 22 // Copyright (C) 2013 Wizardry and Steamworks - License: GNU GPLv3 //
23 /////////////////////////////////////////////////////////////////////////// 23 ///////////////////////////////////////////////////////////////////////////
24 string wasKeyValueEncode(list data) { 24 string wasKeyValueEncode(list data) {
25 list k = llList2ListStrided(data, 0, -1, 2); 25 list k = llList2ListStrided(data, 0, -1, 2);
26 list v = llList2ListStrided(llDeleteSubList(data, 0, 0), 0, -1, 2); 26 list v = llList2ListStrided(llDeleteSubList(data, 0, 0), 0, -1, 2);
27 data = []; 27 data = [];
28 do { 28 do {
29 data += llList2String(k, 0) + "=" + llList2String(v, 0); 29 data += llList2String(k, 0) + "=" + llList2String(v, 0);
30 k = llDeleteSubList(k, 0, 0); 30 k = llDeleteSubList(k, 0, 0);
31 v = llDeleteSubList(v, 0, 0); 31 v = llDeleteSubList(v, 0, 0);
32 } while(llGetListLength(k) != 0); 32 } while(llGetListLength(k) != 0);
33 return llDumpList2String(data, "&"); 33 return llDumpList2String(data, "&");
34 } 34 }
35   35
36 /////////////////////////////////////////////////////////////////////////// 36 ///////////////////////////////////////////////////////////////////////////
37 // Copyright (C) 2011 Wizardry and Steamworks - License: GNU GPLv3 // 37 // Copyright (C) 2011 Wizardry and Steamworks - License: GNU GPLv3 //
38 /////////////////////////////////////////////////////////////////////////// 38 ///////////////////////////////////////////////////////////////////////////
39 // http://was.fm/secondlife/wanderer 39 // http://was.fm/secondlife/wanderer
40 vector wasCirclePoint(float radius) { 40 vector wasCirclePoint(float radius) {
41 float x = llPow(-1, 1 + (integer) llFrand(2)) * llFrand(radius*2); 41 float x = llPow(-1, 1 + (integer) llFrand(2)) * llFrand(radius*2);
42 float y = llPow(-1, 1 + (integer) llFrand(2)) * llFrand(radius*2); 42 float y = llPow(-1, 1 + (integer) llFrand(2)) * llFrand(radius*2);
43 if(llPow(x,2) + llPow(y,2) <= llPow(radius,2)) 43 if(llPow(x,2) + llPow(y,2) <= llPow(radius,2))
44 return <x, y, 0>; 44 return <x, y, 0>;
45 return wasCirclePoint(radius); 45 return wasCirclePoint(radius);
46 } 46 }
47   47
48 /////////////////////////////////////////////////////////////////////////// 48 ///////////////////////////////////////////////////////////////////////////
49 // Copyright (C) 2015 Wizardry and Steamworks - License: GNU GPLv3 // 49 // Copyright (C) 2015 Wizardry and Steamworks - License: GNU GPLv3 //
50 /////////////////////////////////////////////////////////////////////////// 50 ///////////////////////////////////////////////////////////////////////////
51 // escapes a string in conformance with RFC1738 51 // escapes a string in conformance with RFC1738
52 string wasURLEscape(string i) { 52 string wasURLEscape(string i) {
53 string o = ""; 53 string o = "";
54 do { 54 do {
55 string c = llGetSubString(i, 0, 0); 55 string c = llGetSubString(i, 0, 0);
56 i = llDeleteSubString(i, 0, 0); 56 i = llDeleteSubString(i, 0, 0);
57 if(c == "") jump continue; 57 if(c == "") jump continue;
58 if(c == " ") { 58 if(c == " ") {
59 o += "+"; 59 o += "+";
60 jump continue; 60 jump continue;
61 } 61 }
62 if(c == "\n") { 62 if(c == "\n") {
63 o += "%0D" + llEscapeURL(c); 63 o += "%0D" + llEscapeURL(c);
64 jump continue; 64 jump continue;
65 } 65 }
66 o += llEscapeURL(c); 66 o += llEscapeURL(c);
67 @continue; 67 @continue;
68 } while(i != ""); 68 } while(i != "");
69 return o; 69 return o;
70 } 70 }
71   71
72 /////////////////////////////////////////////////////////////////////////// 72 ///////////////////////////////////////////////////////////////////////////
73 // Copyright (C) 2015 Wizardry and Steamworks - License: GNU GPLv3 // 73 // Copyright (C) 2015 Wizardry and Steamworks - License: GNU GPLv3 //
74 /////////////////////////////////////////////////////////////////////////// 74 ///////////////////////////////////////////////////////////////////////////
75 list wasCSVToList(string csv) { 75 list wasCSVToList(string csv) {
76 list l = []; 76 list l = [];
77 list s = []; 77 list s = [];
78 string m = ""; 78 string m = "";
79 do { 79 do {
80 string a = llGetSubString(csv, 0, 0); 80 string a = llGetSubString(csv, 0, 0);
81 csv = llDeleteSubString(csv, 0, 0); 81 csv = llDeleteSubString(csv, 0, 0);
82 if(a == ",") { 82 if(a == ",") {
83 if(llList2String(s, -1) != "\"") { 83 if(llList2String(s, -1) != "\"") {
84 l += m; 84 l += m;
85 m = ""; 85 m = "";
86 jump continue; 86 jump continue;
87 } 87 }
88 m += a; 88 m += a;
89 jump continue; 89 jump continue;
90 } 90 }
91 if(a == "\"" && llGetSubString(csv, 0, 0) == a) { 91 if(a == "\"" && llGetSubString(csv, 0, 0) == a) {
92 m += a; 92 m += a;
93 csv = llDeleteSubString(csv, 0, 0); 93 csv = llDeleteSubString(csv, 0, 0);
94 jump continue; 94 jump continue;
95 } 95 }
96 if(a == "\"") { 96 if(a == "\"") {
97 if(llList2String(s, -1) != a) { 97 if(llList2String(s, -1) != a) {
98 s += a; 98 s += a;
99 jump continue; 99 jump continue;
100 } 100 }
101 s = llDeleteSubList(s, -1, -1); 101 s = llDeleteSubList(s, -1, -1);
102 jump continue; 102 jump continue;
103 } 103 }
104 m += a; 104 m += a;
105 @continue; 105 @continue;
106 } while(csv != ""); 106 } while(csv != "");
107 // postcondition: length(s) = 0 107 // postcondition: length(s) = 0
108 return l + m; 108 return l + m;
109 } 109 }
110   110
111 /////////////////////////////////////////////////////////////////////////// 111 ///////////////////////////////////////////////////////////////////////////
112 // Copyright (C) 2015 Wizardry and Steamworks - License: GNU GPLv3 // 112 // Copyright (C) 2015 Wizardry and Steamworks - License: GNU GPLv3 //
113 /////////////////////////////////////////////////////////////////////////// 113 ///////////////////////////////////////////////////////////////////////////
114 string wasListToCSV(list l) { 114 string wasListToCSV(list l) {
115 list v = []; 115 list v = [];
116 do { 116 do {
117 string a = llDumpList2String( 117 string a = llDumpList2String(
118 llParseStringKeepNulls( 118 llParseStringKeepNulls(
119 llList2String( 119 llList2String(
120 l, 120 l,
121 0 121 0
122 ), 122 ),
123 ["\""], 123 ["\""],
124 [] 124 []
125 ), 125 ),
126 "\"\"" 126 "\"\""
127 ); 127 );
128 if(llParseStringKeepNulls( 128 if(llParseStringKeepNulls(
129 a, 129 a,
130 [" ", ",", "\n", "\""], [] 130 [" ", ",", "\n", "\""], []
131 ) != 131 ) !=
132 (list) a 132 (list) a
133 ) a = "\"" + a + "\""; 133 ) a = "\"" + a + "\"";
134 v += a; 134 v += a;
135 l = llDeleteSubList(l, 0, 0); 135 l = llDeleteSubList(l, 0, 0);
136 } while(l != []); 136 } while(l != []);
137 return llDumpList2String(v, ","); 137 return llDumpList2String(v, ",");
138 } 138 }
139   139
140 /////////////////////////////////////////////////////////////////////////// 140 ///////////////////////////////////////////////////////////////////////////
141 // Copyright (C) 2015 Wizardry and Steamworks - License: GNU GPLv3 // 141 // Copyright (C) 2015 Wizardry and Steamworks - License: GNU GPLv3 //
142 /////////////////////////////////////////////////////////////////////////// 142 ///////////////////////////////////////////////////////////////////////////
143 // unescapes a string in conformance with RFC1738 143 // unescapes a string in conformance with RFC1738
144 string wasURLUnescape(string i) { 144 string wasURLUnescape(string i) {
145 return llUnescapeURL( 145 return llUnescapeURL(
146 llDumpList2String( 146 llDumpList2String(
147 llParseString2List( 147 llParseString2List(
148 llDumpList2String( 148 llDumpList2String(
149 llParseString2List( 149 llParseString2List(
150 i, 150 i,
151 ["+"], 151 ["+"],
152 [] 152 []
153 ), 153 ),
154 " " 154 " "
155 ), 155 ),
156 ["%0D%0A"], 156 ["%0D%0A"],
157 [] 157 []
158 ), 158 ),
159 "\n" 159 "\n"
160 ) 160 )
161 ); 161 );
162 } 162 }
163   163
164 // configuration data 164 // configuration data
165 string configuration = ""; 165 string configuration = "";
166 // callback URL 166 // callback URL
167 string URL = ""; 167 string URL = "";
168 // store message over state. 168 // store message over state.
169 string firstname = ""; 169 string firstname = "";
170 string lastname = ""; 170 string lastname = "";
171 string group = ""; 171 string group = "";
172 string data = ""; 172 string data = "";
173 string jump_state = ""; 173 string jump_state = "";
174   174
175 default { 175 default {
176 state_entry() { 176 state_entry() {
177 llOwnerSay("[MOTD] Starting module..."); 177 llOwnerSay("[MOTD] Starting module...");
178 llSetTimerEvent(10); 178 llSetTimerEvent(10);
179 } 179 }
180 link_message(integer sender, integer num, string message, key id) { 180 link_message(integer sender, integer num, string message, key id) {
181 if(id != "configuration") return; 181 if(id != "configuration") return;
182 llOwnerSay("[MOTD] Got configuration..."); 182 llOwnerSay("[MOTD] Got configuration...");
183 configuration = message; 183 configuration = message;
184 jump_state = "create_database"; 184 jump_state = "create_database";
185 state url; 185 state url;
186 } 186 }
187 timer() { 187 timer() {
188 llOwnerSay("[MOTD] Requesting configuration..."); 188 llOwnerSay("[MOTD] Requesting configuration...");
189 llMessageLinked(LINK_THIS, 0, "configuration", NULL_KEY); 189 llMessageLinked(LINK_THIS, 0, "configuration", NULL_KEY);
190 } 190 }
191 on_rez(integer num) { 191 on_rez(integer num) {
192 llResetScript(); 192 llResetScript();
193 } 193 }
194 changed(integer change) { 194 changed(integer change) {
195 if((change & CHANGED_INVENTORY) || 195 if((change & CHANGED_INVENTORY) ||
196 (change & CHANGED_REGION_START) || 196 (change & CHANGED_REGION_START) ||
197 (change & CHANGED_OWNER)) { 197 (change & CHANGED_OWNER)) {
198 llResetScript(); 198 llResetScript();
199 } 199 }
200 } 200 }
201 state_exit() { 201 state_exit() {
202 llSetTimerEvent(0); 202 llSetTimerEvent(0);
203 } 203 }
204 } 204 }
205   205
206 state url { 206 state url {
207 state_entry() { 207 state_entry() {
208 // DEBUG 208 // DEBUG
209 llOwnerSay("[MOTD] Requesting URL..."); 209 llOwnerSay("[MOTD] Requesting URL...");
210 llRequestURL(); 210 llRequestURL();
211 } 211 }
212 http_request(key id, string method, string body) { 212 http_request(key id, string method, string body) {
213 if(method != URL_REQUEST_GRANTED) return; 213 if(method != URL_REQUEST_GRANTED) return;
214 URL = body; 214 URL = body;
215 // DEBUG 215 // DEBUG
216 llOwnerSay("[MOTD] Got URL..."); 216 llOwnerSay("[MOTD] Got URL...");
217 if(jump_state == "create_database") 217 if(jump_state == "create_database")
218 state create_database; 218 state create_database;
219 if(jump_state == "greet") 219 if(jump_state == "greet")
220 state greet; 220 state greet;
221 if(jump_state == "get") 221 if(jump_state == "get")
222 state get; 222 state get;
223 if(jump_state == "set") 223 if(jump_state == "set")
224 state set; 224 state set;
225 if(jump_state == "listen_group") 225 if(jump_state == "listen_group")
226 state listen_group; 226 state listen_group;
227 227
228 // DEBUG 228 // DEBUG
229 llOwnerSay("[MOTD] Jump table corrupted, please contact creator..."); 229 llOwnerSay("[MOTD] Jump table corrupted, please contact creator...");
230 llResetScript(); 230 llResetScript();
231 } 231 }
232 on_rez(integer num) { 232 on_rez(integer num) {
233 llResetScript(); 233 llResetScript();
234 } 234 }
235 changed(integer change) { 235 changed(integer change) {
236 if((change & CHANGED_INVENTORY) || 236 if((change & CHANGED_INVENTORY) ||
237 (change & CHANGED_REGION_START) || 237 (change & CHANGED_REGION_START) ||
238 (change & CHANGED_OWNER)) { 238 (change & CHANGED_OWNER)) {
239 llResetScript(); 239 llResetScript();
240 } 240 }
241 } 241 }
242 } 242 }
243   243
244 state create_database { 244 state create_database {
245 state_entry() { 245 state_entry() {
246 // DEBUG 246 // DEBUG
247 llOwnerSay("[MOTD] Creating database."); 247 llOwnerSay("[MOTD] Creating database: " + wasKeyValueGet("motd table", configuration));
248 llInstantMessage( 248 llInstantMessage(
249 wasKeyValueGet( 249 wasKeyValueGet(
250 "corrade", 250 "corrade",
251 configuration 251 configuration
252 ), 252 ),
253 wasKeyValueEncode( 253 wasKeyValueEncode(
254 [ 254 [
255 "command", "database", 255 "command", "database",
256 "group", wasURLEscape( 256 "group", wasURLEscape(
257 wasKeyValueGet( 257 wasKeyValueGet(
258 "group", 258 "group",
259 configuration 259 configuration
260 ) 260 )
261 ), 261 ),
262 "password", wasURLEscape( 262 "password", wasURLEscape(
263 wasKeyValueGet( 263 wasKeyValueGet(
264 "password", 264 "password",
265 configuration 265 configuration
266 ) 266 )
267 ), 267 ),
268 "SQL", wasURLEscape("CREATE TABLE IF NOT EXISTS \"" + 268 "SQL", wasURLEscape("CREATE TABLE IF NOT EXISTS \"" +
269 wasKeyValueGet("motd table", configuration) + 269 wasKeyValueGet("motd table", configuration) +
270 "\" (name text unique collate nocase, data text)"), 270 "\" (name text unique collate nocase, data text)"),
271 "callback", wasURLEscape(URL) 271 "callback", wasURLEscape(URL)
272 ] 272 ]
273 ) 273 )
274 ); 274 );
275 llSetTimerEvent(60); 275 llSetTimerEvent(60);
276 } 276 }
277 http_request(key id, string method, string body) { 277 http_request(key id, string method, string body) {
278 llHTTPResponse(id, 200, "OK"); 278 llHTTPResponse(id, 200, "OK");
279 llReleaseURL(URL); 279 llReleaseURL(URL);
280 if(wasKeyValueGet("command", body) != "database" || 280 if(wasKeyValueGet("command", body) != "database" ||
281 wasKeyValueGet("success", body) != "True") { 281 wasKeyValueGet("success", body) != "True") {
282 // DEBUG 282 // DEBUG
283 llOwnerSay("[MOTD] Unable modify database: " + 283 llOwnerSay("[MOTD] Unable modify database: " +
284 wasURLUnescape( 284 wasURLUnescape(
285 wasKeyValueGet("error", body) 285 wasKeyValueGet("error", body)
-   286 ) +
-   287 " " +
-   288 wasURLUnescape(
-   289 wasKeyValueGet("data", body)
286 ) 290 )
-   291
287 ); 292 );
288 llResetScript(); 293 llResetScript();
289 } 294 }
290 llOwnerSay("[MOTD] Database created!"); 295 llOwnerSay("[MOTD] Database created!");
291 state listen_group; 296 state listen_group;
292 } 297 }
293 timer() { 298 timer() {
294 llReleaseURL(URL); 299 llReleaseURL(URL);
295 state listen_group; 300 state listen_group;
296 } 301 }
297 on_rez(integer num) { 302 on_rez(integer num) {
298 llResetScript(); 303 llResetScript();
299 } 304 }
300 changed(integer change) { 305 changed(integer change) {
301 if((change & CHANGED_INVENTORY) || 306 if((change & CHANGED_INVENTORY) ||
302 (change & CHANGED_REGION_START) || 307 (change & CHANGED_REGION_START) ||
303 (change & CHANGED_OWNER)) { 308 (change & CHANGED_OWNER)) {
304 llResetScript(); 309 llResetScript();
305 } 310 }
306 } 311 }
307 state_exit() { 312 state_exit() {
308 llSetTimerEvent(0); 313 llSetTimerEvent(0);
309 } 314 }
310 } 315 }
311   316
312   317
313 state listen_group { 318 state listen_group {
314 state_entry() { 319 state_entry() {
315 // DEBUG 320 // DEBUG
316 llOwnerSay("[MOTD] Waiting for group messages and new group members."); 321 llOwnerSay("[MOTD] Waiting for group messages and new group members.");
317 } 322 }
318 link_message(integer sender, integer num, string message, key id) { 323 link_message(integer sender, integer num, string message, key id) {
319 // We only care about notifications now. 324 // We only care about notifications now.
320 if(id != "notification") 325 if(id != "notification")
321 return; 326 return;
322 327
323 // Get the group. 328 // Get the group.
324 group = wasURLUnescape( 329 group = wasURLUnescape(
325 wasKeyValueGet( 330 wasKeyValueGet(
326 "group", 331 "group",
327 message 332 message
328 ) 333 )
329 ); 334 );
330 335
331 // Retrieve the membership notification. 336 // Retrieve the membership notification.
332 if(wasKeyValueGet("type", message) == "membership" && 337 if(wasKeyValueGet("type", message) == "membership" &&
333 wasKeyValueGet("action", message) == "joined") { 338 wasKeyValueGet("action", message) == "joined") {
334 firstname = wasURLUnescape( 339 firstname = wasURLUnescape(
335 wasKeyValueGet( 340 wasKeyValueGet(
336 "firstname", 341 "firstname",
337 message 342 message
338 ) 343 )
339 ); 344 );
340 lastname = wasURLUnescape( 345 lastname = wasURLUnescape(
341 wasKeyValueGet( 346 wasKeyValueGet(
342 "lastname", 347 "lastname",
343 message 348 message
344 ) 349 )
345 ); 350 );
346 jump_state = "greet"; 351 jump_state = "greet";
347 state url; 352 state url;
348 } 353 }
349 354
350 // This script only processes group notifications. 355 // This script only processes group notifications.
351 if(wasKeyValueGet("type", message) != "group") 356 if(wasKeyValueGet("type", message) != "group")
352 return; 357 return;
353 358
354 // Get the sent message. 359 // Get the sent message.
355 data = wasURLUnescape( 360 data = wasURLUnescape(
356 wasKeyValueGet( 361 wasKeyValueGet(
357 "message", 362 "message",
358 message 363 message
359 ) 364 )
360 ); 365 );
361 366
362 // Check if this is an eggdrop command. 367 // Check if this is an eggdrop command.
363 if(llGetSubString(data, 0, 0) != 368 if(llGetSubString(data, 0, 0) !=
364 wasKeyValueGet("command", configuration)) 369 wasKeyValueGet("command", configuration))
365 return; 370 return;
366 371
367 // Check if the command matches the current module. 372 // Check if the command matches the current module.
368 list command = llParseString2List(data, [" "], []); 373 list command = llParseString2List(data, [" "], []);
369 if(llList2String(command, 0) != 374 if(llList2String(command, 0) !=
370 wasKeyValueGet("command", configuration) + "motd") 375 wasKeyValueGet("command", configuration) + "motd")
371 return; 376 return;
372 377
373 // Remove command. 378 // Remove command.
374 command = llDeleteSubList(command, 0, 0); 379 command = llDeleteSubList(command, 0, 0);
375 380
376 // Dump the rest of the message. 381 // Dump the rest of the message.
377 data = llDumpList2String(command, " "); 382 data = llDumpList2String(command, " ");
378 383
379 // Get the sent message. 384 // Get the sent message.
380 if(data == "") { 385 if(data == "") {
381 jump_state = "get"; 386 jump_state = "get";
382 state url; 387 state url;
383 } 388 }
384 389
385 jump_state = "set"; 390 jump_state = "set";
386 state url; 391 state url;
387 } 392 }
388 on_rez(integer num) { 393 on_rez(integer num) {
389 llResetScript(); 394 llResetScript();
390 } 395 }
391 changed(integer change) { 396 changed(integer change) {
392 if((change & CHANGED_INVENTORY) || 397 if((change & CHANGED_INVENTORY) ||
393 (change & CHANGED_REGION_START) || 398 (change & CHANGED_REGION_START) ||
394 (change & CHANGED_OWNER)) { 399 (change & CHANGED_OWNER)) {
395 llResetScript(); 400 llResetScript();
396 } 401 }
397 } 402 }
398 } 403 }
399   404
400 state greet { 405 state greet {
401 state_entry() { 406 state_entry() {
402 // DEBUG 407 // DEBUG
403 llOwnerSay("[MOTD] Member joined, retrieving MOTD..."); 408 llOwnerSay("[MOTD] Member joined, retrieving MOTD...");
404 llInstantMessage( 409 llInstantMessage(
405 wasKeyValueGet( 410 wasKeyValueGet(
406 "corrade", 411 "corrade",
407 configuration 412 configuration
408 ), 413 ),
409 wasKeyValueEncode( 414 wasKeyValueEncode(
410 [ 415 [
411 "command", "database", 416 "command", "database",
412 "group", wasURLEscape( 417 "group", wasURLEscape(
413 wasKeyValueGet( 418 wasKeyValueGet(
414 "group", 419 "group",
415 configuration 420 configuration
416 ) 421 )
417 ), 422 ),
418 "password", wasURLEscape( 423 "password", wasURLEscape(
419 wasKeyValueGet( 424 wasKeyValueGet(
420 "password", 425 "password",
421 configuration 426 configuration
422 ) 427 )
423 ), 428 ),
424 "SQL", wasURLEscape("SELECT data FROM \"" + 429 "SQL", wasURLEscape("SELECT data FROM \"" +
425 wasKeyValueGet("motd table", configuration) + 430 wasKeyValueGet("motd table", configuration) +
426 "\" WHERE name=:group"), 431 "\" WHERE name=:group"),
427 "data", wasURLEscape( 432 "data", wasURLEscape(
428 wasListToCSV( 433 wasListToCSV(
429 [ 434 [
430 "group", 435 "group",
431 wasURLEscape(group) 436 wasURLEscape(group)
432 ] 437 ]
433 ) 438 )
434 ), 439 ),
435 "callback", wasURLEscape(URL) 440 "callback", wasURLEscape(URL)
436 ] 441 ]
437 ) 442 )
438 ); 443 );
439 llSetTimerEvent(60); 444 llSetTimerEvent(60);
440 } 445 }
441 http_request(key id, string method, string body) { 446 http_request(key id, string method, string body) {
442 llHTTPResponse(id, 200, "OK"); 447 llHTTPResponse(id, 200, "OK");
443 llReleaseURL(URL); 448 llReleaseURL(URL);
444 if(wasKeyValueGet("command", body) != "database" || 449 if(wasKeyValueGet("command", body) != "database" ||
445 wasKeyValueGet("success", body) != "True") { 450 wasKeyValueGet("success", body) != "True") {
446 // DEBUG 451 // DEBUG
447 llOwnerSay("[MOTD] Unable retrieve from database: " + 452 llOwnerSay("[MOTD] Unable retrieve from database: " +
448 wasURLUnescape( 453 wasURLUnescape(
449 wasKeyValueGet("error", body) 454 wasKeyValueGet("error", body)
450 ) 455 )
451 ); 456 );
452 state listen_group; 457 state listen_group;
453 } 458 }
454 459
455 data = llDumpList2String( 460 data = llDumpList2String(
456 llDeleteSubList( 461 llDeleteSubList(
457 wasCSVToList( 462 wasCSVToList(
458 wasURLUnescape( 463 wasURLUnescape(
459 wasKeyValueGet("data", body) 464 wasKeyValueGet("data", body)
460 ) 465 )
461 ), 466 ),
462 0, 467 0,
463 0 468 0
464 ), 469 ),
465 "" 470 ""
466 ); 471 );
467 472
468 if(data == "") 473 if(data == "")
469 state listen_group; 474 state listen_group;
470 475
471 data = "Hello " + firstname + " " + lastname + "!" + " " + data; 476 data = "Hello " + firstname + " " + lastname + "!" + " " + data;
472 state tell; 477 state tell;
473 } 478 }
474 timer() { 479 timer() {
475 llReleaseURL(URL); 480 llReleaseURL(URL);
476 state listen_group; 481 state listen_group;
477 } 482 }
478 on_rez(integer num) { 483 on_rez(integer num) {
479 llResetScript(); 484 llResetScript();
480 } 485 }
481 changed(integer change) { 486 changed(integer change) {
482 if((change & CHANGED_INVENTORY) || 487 if((change & CHANGED_INVENTORY) ||
483 (change & CHANGED_REGION_START) || 488 (change & CHANGED_REGION_START) ||
484 (change & CHANGED_OWNER)) { 489 (change & CHANGED_OWNER)) {
485 llResetScript(); 490 llResetScript();
486 } 491 }
487 } 492 }
488 state_exit() { 493 state_exit() {
489 llSetTimerEvent(0); 494 llSetTimerEvent(0);
490 } 495 }
491 } 496 }
492   497
493 state get { 498 state get {
494 state_entry() { 499 state_entry() {
495 // DEBUG 500 // DEBUG
496 llOwnerSay("[MOTD] Retrieving from database."); 501 llOwnerSay("[MOTD] Retrieving from database.");
497 llInstantMessage( 502 llInstantMessage(
498 wasKeyValueGet( 503 wasKeyValueGet(
499 "corrade", 504 "corrade",
500 configuration 505 configuration
501 ), 506 ),
502 wasKeyValueEncode( 507 wasKeyValueEncode(
503 [ 508 [
504 "command", "database", 509 "command", "database",
505 "group", wasURLEscape( 510 "group", wasURLEscape(
506 wasKeyValueGet( 511 wasKeyValueGet(
507 "group", 512 "group",
508 configuration 513 configuration
509 ) 514 )
510 ), 515 ),
511 "password", wasURLEscape( 516 "password", wasURLEscape(
512 wasKeyValueGet( 517 wasKeyValueGet(
513 "password", 518 "password",
514 configuration 519 configuration
515 ) 520 )
516 ), 521 ),
517 "SQL", wasURLEscape("SELECT data FROM \"" + 522 "SQL", wasURLEscape("SELECT data FROM \"" +
518 wasKeyValueGet("motd table", configuration) + 523 wasKeyValueGet("motd table", configuration) +
519 "\" WHERE name=:group"), 524 "\" WHERE name=:group"),
520 "data", wasURLEscape( 525 "data", wasURLEscape(
521 wasListToCSV( 526 wasListToCSV(
522 [ 527 [
523 "group", 528 "group",
524 wasURLEscape(group) 529 wasURLEscape(
-   530 wasKeyValueGet(
-   531 "group",
-   532 configuration
-   533 )
-   534 )
525 ] 535 ]
526 ) 536 )
527 ), 537 ),
528 "callback", wasURLEscape(URL) 538 "callback", wasURLEscape(URL)
529 ] 539 ]
530 ) 540 )
531 ); 541 );
532 llSetTimerEvent(60); 542 llSetTimerEvent(60);
533 } 543 }
534 http_request(key id, string method, string body) { 544 http_request(key id, string method, string body) {
535 llHTTPResponse(id, 200, "OK"); 545 llHTTPResponse(id, 200, "OK");
536 llReleaseURL(URL); 546 llReleaseURL(URL);
537 if(wasKeyValueGet("command", body) != "database" || 547 if(wasKeyValueGet("command", body) != "database" ||
538 wasKeyValueGet("success", body) != "True") { 548 wasKeyValueGet("success", body) != "True") {
539 // DEBUG 549 // DEBUG
540 llOwnerSay("[MOTD] Unable retrieve from database: " + 550 llOwnerSay("[MOTD] Unable retrieve from database: " +
541 wasURLUnescape( 551 wasURLUnescape(
542 wasKeyValueGet("error", body) 552 wasKeyValueGet("error", body)
543 ) 553 )
544 ); 554 );
545 state listen_group; 555 state listen_group;
546 } 556 }
547 557
548 data = llDumpList2String( 558 data = llDumpList2String(
549 llDeleteSubList( 559 llDeleteSubList(
550 wasCSVToList( 560 wasCSVToList(
551 wasURLUnescape( 561 wasURLUnescape(
552 wasKeyValueGet("data", body) 562 wasKeyValueGet("data", body)
553 ) 563 )
554 ), 564 ),
555 0, 565 0,
556 0 566 0
557 ), 567 ),
558 "" 568 ""
559 ); 569 );
560 570
561 if(data == "") { 571 if(data == "") {
562 data = "Sorry, no MOTD is currently set."; 572 data = "Sorry, no MOTD is currently set.";
563 state tell; 573 state tell;
564 } 574 }
565 575
566 state tell; 576 state tell;
567 } 577 }
568 timer() { 578 timer() {
569 llReleaseURL(URL); 579 llReleaseURL(URL);
570 state listen_group; 580 state listen_group;
571 } 581 }
572 on_rez(integer num) { 582 on_rez(integer num) {
573 llResetScript(); 583 llResetScript();
574 } 584 }
575 changed(integer change) { 585 changed(integer change) {
576 if((change & CHANGED_INVENTORY) || 586 if((change & CHANGED_INVENTORY) ||
577 (change & CHANGED_REGION_START) || 587 (change & CHANGED_REGION_START) ||
578 (change & CHANGED_OWNER)) { 588 (change & CHANGED_OWNER)) {
579 llResetScript(); 589 llResetScript();
580 } 590 }
581 } 591 }
582 state_exit() { 592 state_exit() {
583 llSetTimerEvent(0); 593 llSetTimerEvent(0);
584 } 594 }
585 } 595 }
586   596
587 state set { 597 state set {
588 state_entry() { 598 state_entry() {
589 // DEBUG 599 // DEBUG
590 llOwnerSay("[MOTD] Adding to database."); 600 llOwnerSay("[MOTD] Adding to database.");
591 llInstantMessage( 601 llInstantMessage(
592 wasKeyValueGet( 602 wasKeyValueGet(
593 "corrade", 603 "corrade",
594 configuration 604 configuration
595 ), 605 ),
596 wasKeyValueEncode( 606 wasKeyValueEncode(
597 [ 607 [
598 "command", "database", 608 "command", "database",
599 "group", wasURLEscape( 609 "group", wasURLEscape(
600 wasKeyValueGet( 610 wasKeyValueGet(
601 "group", 611 "group",
602 configuration 612 configuration
603 ) 613 )
604 ), 614 ),
605 "password", wasURLEscape( 615 "password", wasURLEscape(
606 wasKeyValueGet( 616 wasKeyValueGet(
607 "password", 617 "password",
608 configuration 618 configuration
609 ) 619 )
610 ), 620 ),
611 "SQL", wasURLEscape("REPLACE INTO \"" + 621 "SQL", wasURLEscape("REPLACE INTO \"" +
612 wasKeyValueGet("motd table", configuration) + 622 wasKeyValueGet("motd table", configuration) +
613 "\" (name, data) VALUES (:name, :data)"), 623 "\" (name, data) VALUES (:name, :data)"),
614 "data", wasURLEscape( 624 "data", wasURLEscape(
615 wasListToCSV( 625 wasListToCSV(
616 [ 626 [
617 "name", 627 "name",
618 wasURLEscape(group), 628 wasURLEscape(
-   629 wasKeyValueGet(
-   630 "group",
-   631 configuration
-   632 )
-   633 ),
619 "data", 634 "data",
620 wasURLEscape(data) 635 wasURLEscape(data)
621 ] 636 ]
622 ) 637 )
623 ), 638 ),
624 "callback", wasURLEscape(URL) 639 "callback", wasURLEscape(URL)
625 ] 640 ]
626 ) 641 )
627 ); 642 );
628 llSetTimerEvent(60); 643 llSetTimerEvent(60);
629 } 644 }
630 http_request(key id, string method, string body) { 645 http_request(key id, string method, string body) {
631 llHTTPResponse(id, 200, "OK"); 646 llHTTPResponse(id, 200, "OK");
632 llReleaseURL(URL); 647 llReleaseURL(URL);
633 if(wasKeyValueGet("command", body) != "database" || 648 if(wasKeyValueGet("command", body) != "database" ||
634 wasKeyValueGet("success", body) != "True") { 649 wasKeyValueGet("success", body) != "True") {
635 // DEBUG 650 // DEBUG
636 llOwnerSay("[MOTD] Unable modify database: " + 651 llOwnerSay("[MOTD] Unable modify database: " +
637 wasURLUnescape( 652 wasURLUnescape(
638 wasKeyValueGet("error", body) 653 wasKeyValueGet("error", body)
639 ) 654 )
640 ); 655 );
641 state listen_group; 656 state listen_group;
642 } 657 }
643 data = "Saved"; 658 data = "Saved";
644 state tell; 659 state tell;
645 } 660 }
646 timer() { 661 timer() {
647 llReleaseURL(URL); 662 llReleaseURL(URL);
648 state listen_group; 663 state listen_group;
649 } 664 }
650 on_rez(integer num) { 665 on_rez(integer num) {
651 llResetScript(); 666 llResetScript();
652 } 667 }
653 changed(integer change) { 668 changed(integer change) {
654 if((change & CHANGED_INVENTORY) || 669 if((change & CHANGED_INVENTORY) ||
655 (change & CHANGED_REGION_START) || 670 (change & CHANGED_REGION_START) ||
656 (change & CHANGED_OWNER)) { 671 (change & CHANGED_OWNER)) {
657 llResetScript(); 672 llResetScript();
658 } 673 }
659 } 674 }
660 state_exit() { 675 state_exit() {
661 llSetTimerEvent(0); 676 llSetTimerEvent(0);
662 } 677 }
663 } 678 }
664   679
665 state tell { 680 state tell {
666 state_entry() { 681 state_entry() {
667 // DEBUG 682 // DEBUG
668 llOwnerSay("[MOTD] Sending to group."); 683 llOwnerSay("[MOTD] Sending to group.");
669 llInstantMessage( 684 llInstantMessage(
670 wasKeyValueGet( 685 wasKeyValueGet(
671 "corrade", 686 "corrade",
672 configuration 687 configuration
673 ), 688 ),
674 wasKeyValueEncode( 689 wasKeyValueEncode(
675 [ 690 [
676 "command", "tell", 691 "command", "tell",
677 "group", wasURLEscape( 692 "group", wasURLEscape(
678 wasKeyValueGet( 693 wasKeyValueGet(
679 "group", 694 "group",
680 configuration 695 configuration
681 ) 696 )
682 ), 697 ),
683 "password", wasURLEscape( 698 "password", wasURLEscape(
684 wasKeyValueGet( 699 wasKeyValueGet(
685 "password", 700 "password",
686 configuration 701 configuration
687 ) 702 )
688 ), 703 ),
689 "entity", "group", 704 "entity", "group",
690 "message", wasURLEscape(data) 705 "message", wasURLEscape(data)
691 ] 706 ]
692 ) 707 )
693 ); 708 );
694 state listen_group; 709 state listen_group;
695 } 710 }
696 } 711 }
697   712