help Please vsro

05/07/2013 17:57 karimwolf3#1
:rolleyes:i need query to give silk by charname or account id any one know it please give it to me
05/07/2013 18:04 Zodiao#2
Code:
USE SRO_VT_ACCOUNT

UPDATE SK_SILK
SET SILK_OWN = SILK_OWN + 50 --(CHANGE 50 TO W/E U WANT)
WHERE JID=(SELECT JID FROM TB_USER WHERE STRUSERID='USERNAME HERE')
Regards
05/07/2013 23:01 karimwolf3#3
Quote:
Originally Posted by Sir*EviL View Post
Code:
USE SRO_VT_ACCOUNT

UPDATE SK_SILK
SET SILK_OWN = SILK_OWN + 50 --(CHANGE 50 TO W/E U WANT)
WHERE JID=(SELECT JID FROM TB_USER WHERE STRUSERID='USERNAME HERE')
Regards
Thx