Team BlueWater Game Online Tutorial's
Bine ati venit la Team-BlueWater!!Tutorial's 4 all Games!

Season 4 FULL + 80 New Items in the Season 5 E2

View previous topic View next topic Go down

Season 4 FULL + 80 New Items in the Season 5 E2

Post  Karma on Sat Aug 06, 2011 6:16 am

Server Files :
BC8 - 100%
DS7 - 100%
CC7 - 100%
Illusion Temple - 100%
Happy Hour - 100%
Golden Invasion - 100%
White Wizzard - 100%
Sky Event - 100%
Event Blue - 100%
All Quests - 100%
Marlon Quest - 100%
HalloweenEvent - 100%
GM Command - 100%
S3 Items - 100%
S3 NPC - 100%
Mobs S3 - 100%
Map S3 - 100%
S4 Mobs - 100%
S4 Items - 100%
S4 Skills - 100%
PC Points Shop - 100%
Raklion Map -100%
CryWolf - 100%
Castle Sidge - 100%
SwampOfCalmess - 100%
Skill Tree - 100%
/ reset 100%
DL ve GS-CS ^ ^
80 + Items - 100%

Use MuOnline

Code:

Create PROCEDURE PC_POINT_by_RMST
As
Begin
Set nocount on
Set dateformat dmy
Declare
@PCPoint int,
@Onlinetime int
SET @PCPoint=2
SET @Onlinetime=60
UPDATE CHARACTER
SET Onlinetime = Onlinetime + 1
FROM memb_stat, AccountCharacter, Character
Where MEMB_STAT.ConnectStat = 1 and memb_stat.memb___id = AccountCharacter.Id and AccountCharacter.GameIDC = Character.Name;
UPDATE CHARACTER
SET SCFPCPoints = SCFPCPoints + @PCPoint
FROM memb_stat, AccountCharacter, Character
WHERE MEMB_STAT.ConnectStat = 1 and memb_stat.memb___id = AccountCharacter.Id and AccountCharacter.GameIDC = Character.Name and (Onlinetime = @Onlinetime)
Update CHARACTER
SET Onlinetime = 0
From Character JOIN memb_stat on Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE ((ConnectStat = 0) OR (Onlinetime>=@Onlinetime))
End

[You must be registered and logged in to see this link.]
[You must be registered and logged in to see this link.]
[You must be registered and logged in to see this link.]
Credite:
NoFeaR
avatar
Karma
Admin
Admin

Mesaje : 1092
Data de inscriere : 2011-04-22
Varsta : 26
Localizare : Craiova

View user profile http://team-bluewater.forumz.ro

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum