# Name: rah_sql_query v0.1 # Type: Admin/Client side plugin # Run plain SQL-queries directly from Textpattern's Extensions-tab # Author: Jukka Svahn # URL: http://rahforum.biz # Recommended load order: 5 # ..................................................................... # This is a plugin for Textpattern - http://textpattern.com/ # To install: textpattern > admin > plugins # Paste the following text into the 'Install plugin' box: # ..................................................................... YToxMTp7czo0OiJuYW1lIjtzOjEzOiJyYWhfc3FsX3F1ZXJ5IjtzOjY6ImF1dGhvciI7czox MToiSnVra2EgU3ZhaG4iO3M6MTA6ImF1dGhvcl91cmkiO3M6MTk6Imh0dHA6Ly9yYWhmb3J1 bS5iaXoiO3M6NzoidmVyc2lvbiI7czozOiIwLjEiO3M6MTE6ImRlc2NyaXB0aW9uIjtzOjY0 OiJSdW4gcGxhaW4gU1FMLXF1ZXJpZXMgZGlyZWN0bHkgZnJvbSBUZXh0cGF0dGVybidzIEV4 dGVuc2lvbnMtdGFiIjtzOjQ6ImhlbHAiO3M6MTM3NToiCTxoMT5yYWhfc3FsX3F1ZXJ5PC9o MT4KCgk8cD5IYXZlIHlvdSB0aXJlZCB0byBydW4gbGl0dGxlIHBocCBsaW5lLCBvciBvcGVu IGEgcGhwTXlBZG1pbiB0byBiZSBhYmxlIHJ1biBzaW5nbGUgYW5kIHNpbXBsZSBxdWVyeT8g QnV0IHlvdXIganVzdCB0b28gbGF6eSB0byBsb2dpbiB0byBhbm90aGVyIHByb2dyYW0sIGFu ZCB3YW50IHRvIGRvIGl0IGRpcmVjdGx5IHZpYSBUZXh0cGF0dGVybj8gTm93LCBpdCBpcyB5 b3VyIGNoYW5nZS4gUmFoX3NxbF9xdWVyeS1wbHVnaW4gYWxsb3dzIHlvdSB0byBydW4gcXVl cmllcyBkaXJlY3RseSB2aWEgVGV4dHBhdHRlcm4gYmFja2VuZCwgbm90aGluZyBtb3JlIG9y IGxlc3MuIEp1c3Qgc2ltcGxlIHRleHRhcmVhIGFuZCBidXR0b24sIGVycm9yIHJlcG9ydGlu ZyBhbmQgcmV0dXJuZWQgdmFsdWUgb3V0cHV0dGluZy48L3A+CgoJPHVsPgoJCTxsaT5WZXJz aW9uOiAwLjE8L2xpPgoJCTxsaT5VcGRhdGVkOiAyMDA4LzA3LzI3IDE0OjAwIDxzcGFuIGNs YXNzPSJjYXBzIj5HTVQ8L3NwYW4+KzI8L2xpPgoJPC91bD4KCgk8aDM+VGFibGUgb2YgQ29u dGVudHM8L2gzPgoKCTx1bD4KCQk8bGk+PGEgaHJlZj0iI2xpc3Qtb2YtZmVhdHVyZXMiPkxp c3Qgb2YgZmVhdHVyZXM8L2E+PC9saT4KCQk8bGk+PGEgaHJlZj0iI3JlcXVpcmVtZW50cyI+ UmVxdWlyZW1lbnRzPC9hPjwvbGk+CgkJPGxpPjxhIGhyZWY9IiNpbnN0YWxsYXRpb24tYW5k LXVzYWdlIj5JbnN0YWxsYXRpb24gYW5kIHVzYWdlPC9hPjwvbGk+Cgk8L3VsPgoKCTxoMyBp ZD0ibGlzdC1vZi1mZWF0dXJlcyI+TGlzdCBvZiBmZWF0dXJlczwvaDM+CgoJPHVsPgoJCTxs aT5BbGxvd3MgeW91IHRvIHJ1biA8c3BhbiBjbGFzcz0iY2FwcyI+U1FMPC9zcGFuPi1xdWVy aWVzIGRpcmVjdGx5IGZyb20gVGV4dHBhdHRlcm4gYmFja2VuZDwvbGk+CgkJPGxpPlNpbXBs ZSBhbmQgY2xlYW4gcGFuZWw8L2xpPgoJPC91bD4KCgk8aDMgaWQ9InJlcXVpcmVtZW50cyI+ UmVxdWlyZW1lbnRzPC9oMz4KCgk8dWw+CgkJPGxpPjxzcGFuIGNsYXNzPSJjYXBzIj5QSFA8 L3NwYW4+IDQuMy4wPC9saT4KCQk8bGk+VGV4dHBhdHRlcm4gNC4wLngrPC9saT4KCTwvdWw+ CgoJPGgzIGlkPSJpbnN0YWxsYXRpb24tYW5kLXVzYWdlIj5JbnN0YWxsYXRpb24gYW5kIHVz YWdlPC9oMz4KCgk8cD5UaGUgZ2VuZXJhbCBiZWhhdmlvciBzdGFuZHM6IHBhc3RlIHBsdWdp biBjb2RlIHRvIHRoZSBwbHVnaW4gaW5zdGFsbGVyIHRleHRhcmVhIGFuZCBydW4gdGhlIGF1 dG9tYXRpYyBzZXR1cC4gQWN0aXZhdGUgdGhlIHBsdWdpbiwgYW5kIHRoZSBuZXcgcmFoX3Nx bF9xdWVyeS10YWIgaXMgY3JlYXRlZCB1bmRlciAmIzgyMjA7RXh0ZW5zaW9ucyYjODIyMTsu PC9wPiI7czo0OiJjb2RlIjtzOjE2NjI6IgkjIyMjIyMjIyMjIyMjIyMjIyMNCgkjDQoJIwly YWhfc3FsX3F1ZXJ5LXBsdWdpbiBmb3IgVGV4dHBhdHRlcm4NCgkjCXZlcnNpb24gMC4xDQoJ IwlieSBKdWtrYSBTdmFobg0KCSMJaHR0cDovL3JhaGZvcnVtLmJpeg0KCSMNCgkjIyMjIyMj IyMjIyMjIyMjIyMjDQoNCglpZiAoQHR4cGludGVyZmFjZSA9PSAnYWRtaW4nKSB7DQoJCWFk ZF9wcml2cygncmFoX3NxbF9xdWVyeScsICcxLDInKTsNCgkJcmVnaXN0ZXJfdGFiKCJleHRl bnNpb25zIiwgInJhaF9zcWxfcXVlcnkiLCAiUnVuIFF1ZXJpZXMiKTsNCgkJcmVnaXN0ZXJf Y2FsbGJhY2soInJhaF9zcWxfcXVlcnkiLCAicmFoX3NxbF9xdWVyeSIpOw0KCX0NCg0KCWZ1 bmN0aW9uIHJhaF9zcWxfcXVlcnkoKSB7DQoJCXBhZ2V0b3AoJ3JhaF9zcWxfcXVlcnknKTsN CgkJDQoJCWVjaG8gDQoJCQknPGZvcm0gbWV0aG9kPSJwb3N0IiBhY3Rpb249ImluZGV4LnBo cCIgc3R5bGU9IndpZHRoOjgwMHB4O21hcmdpbjowIGF1dG87Ij4nLm4uDQoJCQknCTxoMT5y YWhfc3FsX3F1ZXJ5OiBSdW4gUXVlcmllczwvaDE+Jy5uLg0KCQkJJwk8aW5wdXQgdHlwZT0i aGlkZGVuIiBuYW1lPSJldmVudCIgdmFsdWU9InJhaF9zcWxfcXVlcnkiIC8+Jy5uLg0KCQkJ Jwk8aW5wdXQgdHlwZT0iaGlkZGVuIiBuYW1lPSJxdWVyeV9kbyIgdmFsdWU9IjEiIC8+Jy5u Lg0KCQkJJwk8bGFiZWwgZm9yPSJxdWVyeSI+UXVlcnkgdG8gcnVuOjwvbGFiZWw+Jy5uLg0K CQkJJwk8dGV4dGFyZWEgaWQ9InF1ZXJ5IiBuYW1lPSJxdWVyeSIgcm93cz0iMTAiIGNvbHM9 IjMwIiBzdHlsZT0id2lkdGg6NzkwcHg7Ij48L3RleHRhcmVhPicubi4NCgkJCScJPGJ1dHRv biBzdHlsZT0ibWFyZ2luOjEwcHg7IiB0eXBlPSJzdWJtaXQiPlJ1biBRdWVyeTwvYnV0dG9u Picubi4oKHBzKCdxdWVyeScpICYmIHBzKCdxdWVyeV9kbycpKSA/DQoJCQkJCScJPGhyIC8+ PHA+RG9uZSBRdWVyeTo8L3A+PHByZT4nLmh0bWxzcGVjaWFsY2hhcnMocHMoJ3F1ZXJ5Jykp Lic8L3ByZT4nLm4uDQoJCQkJCScJPGhyIC8+Jy5uLg0KCQkJCQknCTxwPlJldHVybmVkOjwv cD48cHJlPicuc2FmZV9xdWVyeShwcygncXVlcnknKSkuJzwvcHJlPicubiA6ICcnKS4NCgkJ CScJPHAgc3R5bGU9Im1hcmdpbjogMTVweCBhdXRvO3dpZHRoOiA2MDBweDtwYWRkaW5nOjE1 cHg7bGluZS1oZWlnaHQ6MS42NWVtO2JvcmRlcjoxcHggc29saWQgI2NjMDAwMDtiYWNrZ3Jv dW5kOiAjZmZmZmMwO2NvbG9yOiAjMDAwOyI+Jy5uLg0KCQkJJwkJPHN0cm9uZyBzdHlsZT0i Y29sb3I6ICNjYzAwMDA7Ij5XYXJuaW5nITwvc3Ryb25nPiBJZiB5b3UgZG9uXCd0IGtub3cg d2hhdCB5b3UgYXJlIGRvaW5nLCBkb25cJ3QgbmV2ZXIgcnVuIGEgcXVlcnkhIE1pc3N1c2Vk IHF1ZXJpZXMgY2FuIHBlcm1hbmVudGx5IGxvc3MgeW91ciBkYXRhLCBoYXJtIHlvdXIgTXlT UUwtZGF0YWJhc2UgYW5kL29yIFRleHRwYXR0ZXJuIGl0c2VsZi4gSWYgeW91IGFyZSBhbnkg ZW5zdXJlLCByZW1lbWJlciB0byBiYWNrdXAgZmlyc3QgeW91ciBUZXh0cGF0dGVybiBkYXRh YmFzZS4gUmVjb21tZW5kZWQgdG8gb25seSB1c2Ugb24gZGV2ZWxvcG1lbnQgYW5kIHRlc3Qg aW5zdGFsbHMsIG5vdCBpbiBsaXZlIHNpdGVzLicubi4NCgkJCScJPC9wPicubi4NCgkJCSc8 L2Zvcm0+JzsJDQoJfSI7czo0OiJ0eXBlIjtzOjE6IjEiO3M6NToiZmxhZ3MiO3M6MToiMCI7 czo1OiJvcmRlciI7czoxOiI1IjtzOjM6Im1kNSI7czozMjoiNzc5YzljNmI4NDg2OTQxYmZk MjU5YWU0MTk1ZTFjZGUiO30=