Difference between revisions of "SQL"
From Organic Design wiki
(User:Test should not be admin) |
m |
||
| Line 14: | Line 14: | ||
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+recentchanges+ORDER+BY+rc_timestamp+DESC+LIMIT+100; RC] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+recentchanges+ORDER+BY+rc_timestamp+DESC+LIMIT+100; RC] | ||
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+user_rights; UR] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+*+FROM+user_rights; UR] | ||
| − | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=UPDATE+user_rights+SET+ur_rights= | + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=UPDATE+user_rights+SET+ur_rights=""+WHERE+ur_user=15; makeBot] |
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=UPDATE+user+SET+user_password=md5(CONCAT('184-',md5('password')))+WHERE+user_id=184; Reset Password] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=UPDATE+user+SET+user_password=md5(CONCAT('184-',md5('password')))+WHERE+user_id=184; Reset Password] | ||
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+old_id,old_user_text+FROM+old+WHERE+old_title='Nobots'+ORDER+BY+old_timestamp+LIMIT+1; Owner-Old] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+old_id,old_user_text+FROM+old+WHERE+old_title='Nobots'+ORDER+BY+old_timestamp+LIMIT+1; Owner-Old] | ||
Revision as of 22:28, 9 February 2007
- Some SQL queries executable by admin
