[GUIDE]how to add Free Silks For all

~~883572~~ · 02/24/2012, 00:38

Plz click Thanx!!!

Remove all Silks Query:

Code:

USE [SRO_VT_ACCOUNT]
GO
-------By [GM]L-12-------
TRUNCATE TABLE 
[dbo].[SK_Silk]

Add JID CODE

Code:

Add Silks Query:

Code:

USE [SRO_VT_ACCOUNT]
GO
-------By [GM]L-12-------

UPDATE dbo.SK_Silk SET 
silk_own = 1 ,
silk_gift = 1 ,
silk_point = 1
WHERE JID>= 0

JID in next post

Code:

Plz tankx

Dr.Abdelfattah · 02/24/2012, 09:47

hmm that's fully wrong
Easier and right way to add free silk to all registered users by query

PHP Code:


			
INSERT INTO SK_SILK 
    (JID) 
    SELECT JID 
    FROM TB_User 
    WHERE not exists (select * from SK_Silk 
WHERE SK_SILK.JID = TB_User.JID);   
UPDATE dbo.SK_Silk SET 
silk_own = 1

at silk_own = 1 change 1 to the silk value u need to add .

~~883572~~ · 02/25/2012, 12:46

Tank You

How to add Avatar From Isro or Ksro in my server??