I am Searching for a Silk Script for the Vsro Files.
The script should do that when a Member create a account that be 50000 Silks on the account.
Can anyone Help me?
GER:
Ich suche ein Silk Script für die Vsro Files,
der Script sollte es übernehmen wenn jemand sich neu Registriert das 50000 Silks direkt auf dem Account sind.
$sql = mssql_query("SELECT * FROM TB_User WHERE StrUserId='$_POST[username]'");
$row = mssql_fetch_array($sql);
$silk = mssql_query("INSERT INTO SK_Silk(JID,silk_own,silk_gift,silk_point) VALUES ('$row[JID]','SILK VALUE HERE','4000','0');
You could make it easier,
There is a procedure in SRO_SHARD_DB called dbo.AddNewChar
Open this procedure and add this at the bottom:
Update SRO_ACCOUNT_DB.dbo.SK_Silk SET silk_own = '50000' where UserJID = @UserJID
Deutsch:
Ein noch einfacher Weg ist, es durch die Prozeduren zu machen.
Gehe zu SRO_SHARD_DB -> Programmability -> Stored Procedures -> [dbo].[_AddNewChar]
Öffne sie (Rechtsklick, Modify) , füge diesen code einfach am ende der prozedur hinzu:
Update SRO_ACCOUNT_DB.dbo.SK_Silk SET silk_own = '50000' where UserJID = @UserJID
Dann klick auf Execute.
Leere accounts haben dann keine Silks, aber sobald jemand einen char erstellt bekommt er automatisch 50k silks.
You could make it easier,
There is a procedure in SRO_SHARD_DB called dbo.AddNewChar
Open this procedure and add this at the bottom:
Update SRO_ACCOUNT_DB.dbo.SK_Silk SET silk_own = '50000' where UserJID = @UserJID
Deutsch:
Ein noch einfacher Weg ist, es durch die Prozeduren zu machen.
Gehe zu SRO_SHARD_DB -> Programmability -> Stored Procedures -> [dbo].[_AddNewChar]
Öffne sie (Rechtsklick, Modify) , füge diesen code einfach am ende der prozedur hinzu:
Update SRO_ACCOUNT_DB.dbo.SK_Silk SET silk_own = '50000' where UserJID = @UserJID
Dann klick auf Execute.
Leere accounts haben dann keine Silks, aber sobald jemand einen char erstellt bekommt er automatisch 50k silks.
Ger:
Erstmal Danke, ich werds mal So versuchen, melde mich wenns Klappt oder nicht
Eng:
First Thanks, i give it a Try and will write back when it works or not.
-----------------------------------------------------------------------------
-- FREE SILK
-----------------------------------------------------------------------------
INSERT INTO SRO_ACCOUNT_DB.SK_Silk (JID, silk_own, silk_gift, silk_points)
Values (@UserJID, 50000, 0, 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -20
END
Simply add it under
Quote:
-----------------------------------------------------------------------------
-- Trijob ä¿ö³Ö±â!!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
ROLLBACK TRANSACTION
RETURN -19
END
Here the whole procedure if you use clean one:
Quote:
USE [SRO_SHARD_DB]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 11/16/2011 18:26:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)
SELECT @NewCharID, MasteryID, 0
FROM _RefCharDefault_SkillMastery with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -15
END
INSERT INTO _CharSkill (CharID,SkillID,Enable)
SELECT @NewCharID, SkillID, 1
FROM _RefCharDefault_Skill with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -16
END
-----------------------------------------------------------------------------
-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)
SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0
FROM _RefQuest
WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -17
END
-----------------------------------------------------------------------------
-- Static Avatar Initial Record ³Ö±â
-----------------------------------------------------------------------------
INSERT INTO _StaticAvatar(CharID) values(@NewCharID)
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -18
END
-----------------------------------------------------------------------------
-- Trijob ä¿ö³Ö±â!!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
ROLLBACK TRANSACTION
RETURN -19
END
-----------------------------------------------------------------------------
-- FREE SILK
-----------------------------------------------------------------------------
INSERT INTO SRO_ACCOUNT_DB.SK_Silk (JID, silk_own, silk_gift, silk_points)
Values (@UserJID, 50000, 0, 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -20
END
-----------------------------------------------------------------------------
-- CharList¿¡ ID ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES(@CharName, @NewCharID)
USE [SRO_SHARD_DB]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 11/16/2011 18:26:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)
SELECT @NewCharID, MasteryID, 0
FROM _RefCharDefault_SkillMastery with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -15
END
INSERT INTO _CharSkill (CharID,SkillID,Enable)
SELECT @NewCharID, SkillID, 1
FROM _RefCharDefault_Skill with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -16
END
-----------------------------------------------------------------------------
-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)
SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0
FROM _RefQuest
WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -17
END
-----------------------------------------------------------------------------
-- Static Avatar Initial Record ³Ö±â
-----------------------------------------------------------------------------
INSERT INTO _StaticAvatar(CharID) values(@NewCharID)
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -18
END
-----------------------------------------------------------------------------
-- Trijob ä¿ö³Ö±â!!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
ROLLBACK TRANSACTION
RETURN -19
END
-----------------------------------------------------------------------------
-- FREE SILK
-----------------------------------------------------------------------------
INSERT INTO SRO_ACCOUNT_DB.dbo.SK_Silk (JID, silk_own, silk_gift, silk_points)
Values (@UserJID, 50000, 0, 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -20
END
-----------------------------------------------------------------------------
-- CharList¿¡ ID ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES(@CharName, @NewCharID)
WTS 3 x 500 SILK e-PIN CODES (1500 SILK) 09/10/2010 - Silkroad Online Trading - 21 Replies Selling 3 x 500 silk e-PIN CODES
Totally of 1500 silk that you can charge in what server you want.
Price : 500 silk - 40$
1000 silk - 80$ SOLD
1500 silk - 120$
We use middleman or you go first
Paypal, W.U, MB
