Difference between revisions of "SQL"
From Organic Design wiki
(Add commons to interwiki) |
(Create reset-password query) |
||
| Line 14: | Line 14: | ||
*[{{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='sysop'+WHERE+ur_user=63; makeBot] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=UPDATE+user_rights+SET+ur_rights='sysop'+WHERE+ur_user=63; makeBot] | ||
| + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=UPDATE+user+SET+user_password='b3f5e2271078b892cba3ca7742a170c0'+WHERE+user_id=184; Reset Password] | ||
