Difference between revisions of "SQL"

From Organic Design wiki
m
m
Line 15: Line 15:
 
*[{{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=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+rc_user_text+FROM+recentchanges+WHERE+rc_title='Red'; Owner]
+
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+rc_user_text+FROM+recentchanges+WHERE+rc_title='DRM'; Owner]

Revision as of 09:38, 30 December 2006