Editing Noisecode

Jump to navigation Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
Line 21: Line 21:
</pre>
</pre>


Noisesql is yet another bot in #noisebridge which knows all about MySQL.  It's used so often that it also responds to anything prefixed with ".sql".  It has a database of dong urls (dongs), a database of gong urls (gongs), and a database with a copy of the 2009 California legislature's output and the state codes (capublic).  Fun things to ask it to do:
Noisesql is yet another bot in #noisebridge which knows all about MySQL.  It's used so often that it also responds to anything prefixed with ".sql".  Fun things to ask it to do:


<pre>
<pre>
Line 27: Line 27:
noisesql: eval select cos(0)
noisesql: eval select cos(0)
noisesql: eval select aes_encrypt('hocus', 'pocus')
noisesql: eval select aes_encrypt('hocus', 'pocus')
.sql select * from gongs order by rand() limit 1
</pre>
</pre>


Line 41: Line 40:
noisejs: eval function f(x) { if(x>2) { return x*f(x-1); } else { return x; } };  print(f(5));
noisejs: eval function f(x) { if(x>2) { return x*f(x-1); } else { return x; } };  print(f(5));
</pre>
</pre>
There used to be a bot that looked for certain keywords and would respond with "appropriate" images, but it was kicked and the group arguing for the bot didn't exercise their do-ocratic rights and reinstate it.


Things people have tried to break the bots so far:
Things people have tried to break the bots so far:
Line 51: Line 48:
* Modifying noisecode's internal objects using setattr/getattr.
* Modifying noisecode's internal objects using setattr/getattr.
* Calling eval() in noisecode via InteractiveConsole and InteractiveInterpreter.
* Calling eval() in noisecode via InteractiveConsole and InteractiveInterpreter.
* feta called sleep() in noisesql to hang it:
< feta> .sql select sleep(999999999)
* davr called sleep(), but with more snazz:
< davr> .sql set @s=concat('select sle','ep(99999)');prepare stmt1 from @s; execute stmt1;
* feta called benchmark and md5 to hang it:
< feta> .sql select benchmark(99999999999999,md5(1))
Please note that all contributions to Noisebridge are considered to be released under the Creative Commons Attribution-NonCommercial-ShareAlike (see Noisebridge:Copyrights for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource. Do not submit copyrighted work without permission!

To protect the wiki against automated edit spam, we kindly ask you to solve the following CAPTCHA:

Cancel Editing help (opens in new window)