![Share storage [Skin - Exchange]](https://www.elitepvpers.com/forum/iconimages/dekaron-private-server/share-storage-skin-exchange_ltr.gif){kind=small}
Disclaimer:
This is not the best script out there however this is a good start. and study from it. improvise the script the way you like it.
PHP Code:
USE [CHARACTER];
GO
BEGIN
/* Declaration of variables used for skin_ Key Item - target skin_*/
DECLARE [MENTION=295157]skin[/MENTION]_Itemtarget INT = 71102;
DECLARE [MENTION=8409491]wept[/MENTION]ochange INT;
DECLARE [MENTION=7905493]Usernumber[/MENTION] varchar(50);
DECLARE [MENTION=6016504]Byh[/MENTION]eaderValue INT;
DECLARE [MENTION=1457041]wpi[/MENTION]ndexCounter INT;
/* Syntax for searching existing user number and its assigned weapon item index */
SELECT [MENTION=7905493]Usernumber[/MENTION] = user_no FROM USER_SHARE_STORAGE WHERE wIndex = [MENTION=295157]skin[/MENTION]_Itemtarget AND line_no = 0
SELECT [MENTION=8409491]wept[/MENTION]ochange = wIndex FROM USER_SHARE_STORAGE WHERE user_no = [MENTION=7905493]Usernumber[/MENTION] AND line_no = 1
SELECT [MENTION=6016504]Byh[/MENTION]eaderValue = byHeader FROM USER_SHARE_STORAGE WHERE wIndex = [MENTION=8409491]wept[/MENTION]ochange AND line_no = 1 AND user_no = [MENTION=7905493]Usernumber[/MENTION]
/* Syntax for fetching the values of [MENTION=7905493]Usernumber[/MENTION], [MENTION=8409491]wept[/MENTION]ochange and [MENTION=6016504]Byh[/MENTION]eaderValue variables */
SELECT [MENTION=7905493]Usernumber[/MENTION]
SELECT [MENTION=8409491]wept[/MENTION]ochange
SELECT [MENTION=6016504]Byh[/MENTION]eaderValue
UPDATE USER_SHARE_STORAGE
SET wIndex =
CASE
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3503 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 800
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3504 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 810
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3505 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 215
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3506 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 820
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3507 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 830
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3508 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 215
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3509 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 840
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3510 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 850
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3511 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 215
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3512 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 860
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3513 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 880
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3514 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 890
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3515 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 900
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3516 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 910
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3517 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 870
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3518 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 920
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3519 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 930
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3520 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 950
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3521 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 940
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3522 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 970
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3523 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 210
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3524 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 211
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3525 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 212
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3526 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 213
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3527 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 214
WHEN [MENTION=8409491]wept[/MENTION]ochange = 3528 AND (user_no = [MENTION=7905493]Usernumber[/MENTION]) AND (line_no = 1) THEN 215
ELSE [MENTION=8409491]wept[/MENTION]ochange
END
WHERE wIndex = [MENTION=8409491]wept[/MENTION]ochange
/* Syntax to Delete skin_ Key */
IF [MENTION=8409491]wept[/MENTION]ochange IN (
3503, 3504, 3505, 3506, 3507, 3508,
3509, 3510, 3511, 3512, 3513, 3514,
3515, 3516, 3517, 3518, 3519, 3520,
3521, 3522, 3523, 3524, 3525, 3526,
3527, 3528
)
BEGIN
DELETE FROM USER_SHARE_STORAGE WHERE wIndex = [MENTION=295157]skin[/MENTION]_Itemtarget AND user_no = [MENTION=7905493]Usernumber[/MENTION] AND line_no = 0
END
ELSE PRINT 'Program Terminated'
END
