الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم المواضيع المكررة و المخالفة (https://silkroad4arab.com/vb/forumdisplay.php?f=58)
-   -   عاوز اغير ال honor ranking ل job ranking (https://silkroad4arab.com/vb/showthread.php?t=612871)

Exanic* 08-03-2017 03:36 AM
عاوز اغير ال honor ranking ل job ranking
 
انا عاوز اغير ال honor ranking ل job ranking بمعنى انك لو عملت trade تاخد honor point
وانا كنت الصفحه بتاعت ال honor ranking من ال storage ومش فاكر ازاى
ارجوا المساعده
وكنت محتاج ال storm effect بتاع ال weapons

Dev.Klito 08-03-2017 11:00 AM
رد: Help
 
يا ريت يكون اسم الموضوع واضح حسب القوانين اتفضل شوف الموضوع دا

http://silkroad4arab.com/vb/showthread.php?t=574634

بالنسبة لاسم التاب فى ال npc اعتقد انت رجل معاك سيرفر اون لين و عارف هتغيرو منين

بخصوص الجلو هشفهولك حاضر

Galactus 08-03-2017 02:17 PM
رد: Help
 
تم تعديل اسم الموضوع ..

Mahmoud Rashwan 08-03-2017 02:26 PM
رد: عاوز اغير ال honor ranking ل job ranking
 
SRO_VT_SHARDLOG-->Programmability-->Stored Procedure-->AddLogCher
كود PHP:
declare*@jobtype*int,@jobnames*varchar(50)
****set*@jobtype=(select*jobtype*from*SRO_VT_SHARD.._chartrijob*where*charid=@charid)
****select*@jobnames=case*when*@jobtype*=1*then*'Trader'
****when*@jobtype=2*then*'Thief'
****when*@jobtype=3*then*'Hunter'
****end
****if*@eventid*in*(4,6)*and*((select*contribution*from*SRO_VT_SHARD.._CharTrijob*where*CharID=@CharID)*>=436657932)*and*((select*jobtype*from*SRO_VT_SHARD.._CharTrijob*where*CHARid=@CharID)>0)
****begin
****if*(select*jobtype*from*SRO_VT_SHARD.._CharTrijob*where*CharID=@CharID)=1
****begin
****exec*SRO_VT_SHARD.._TRAINING_CAMP_CREATE*@charid
****update*SRO_VT_SHARD.._CharTrijob*set*Contribution=0*where*CharID=@CharID
****update*SRO_VT_SHARD.._TrainingCamp*set*EvaluationPoint+=10,GraduateCount+=10*where*id*in*(Select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*charid=@charid)
****if*not*exists*(select*campid*from*[dbo].[SaveTrade_Mr.x]*where*Charid=@CharID)
****begin
****insert*into*[dbo].[SaveTrade_Mr.x]*(Charname,Charid,CampID,HonorPoints,TradeCount,JobType)*values*((select*charname16*from*SRO_VT_SHARD.._char*where*CharID=@CharID),@CharID,(select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*CharID=@CharID),(select*GraduateCount*from*SRO_VT_SHARD.._TrainingCamp*where*id*in*(select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*CharID=@CharID)),0,@jobnames)
****end
****if*exists*(select*campid*from*[dbo].[SaveTrade_Mr.x]*where*Charid=@CharID)
****begin*
****update*[dbo].[SaveTrade_Mr.x]*set*TradeCount+=1,HonorPoints+=10*where*Charid=@CharID
****end
****end
****if*(select*jobtype*from*SRO_VT_SHARD.._CharTrijob*where*CharID=@CharID)=2
****begin
****exec*SRO_VT_SHARD.._TRAINING_CAMP_CREATE*@charid
****update*SRO_VT_SHARD.._CharTrijob*set*Contribution=0*where*CharID=@CharID
****update*SRO_VT_SHARD.._TrainingCamp*set*EvaluationPoint+=10,GraduateCount+=10*where*id*in*(Select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*charid=@charid)
****if*not*exists*(select*campid*from*[dbo].[SaveTrade_Mr.x]*where*Charid=@CharID)
****begin
****insert*into*[dbo].[SaveTrade_Mr.x]*(Charname,Charid,CampID,HonorPoints,TradeCount,JobType)*values*((select*charname16*from*SRO_VT_SHARD.._char*where*CharID=@CharID),@CharID,(select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*CharID=@CharID),(select*GraduateCount*from*SRO_VT_SHARD.._TrainingCamp*where*id*in*(select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*CharID=@CharID)),0,@jobnames)
****end
****if*exists*(select*campid*from*[dbo].[SaveTrade_Mr.x]*where*Charid=@CharID)
****begin*
****update*[dbo].[SaveTrade_Mr.x]*set*TradeCount+=1,HonorPoints+=10*where*Charid=@CharID
****end
****end
****if*(select*jobtype*from*SRO_VT_SHARD.._CharTrijob*where*CharID=@CharID)=3
****begin
****exec*SRO_VT_SHARD.._TRAINING_CAMP_CREATE*@charid
****update*SRO_VT_SHARD.._CharTrijob*set*Contribution=0*where*CharID=@CharID
****update*SRO_VT_SHARD.._TrainingCamp*set*EvaluationPoint+=10,GraduateCount+=10*where*id*in*(Select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*charid=@charid)
****if*not*exists*(select*campid*from*[dbo].[SaveTrade_Mr.x]*where*Charid=@CharID)
****begin
****insert*into*[dbo].[SaveTrade_Mr.x]*(Charname,C_char*where*CharID=@CharID),@CharID,(select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*CharID=@CharID),(select*GraduateCount*from*SRO_VT_SHARD.._TrainingCamp*where*id*in*(select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*CharID=@CharID)),0,@jobnames)
****end
****if*exists*(select*campid*from*[dbo].[SaveTrade_Mr.x]*where*Charid=@CharID)
****begin*
****update*[dbo].[SaveTrade_Mr.x]*set*TradeCount+=1,HonorPoints+=10*where*Charid=@CharID
****end
********update*SRO_VT_SHARD.._CharTrijob*set*Contribution=Contribution+1000*where*CharID=@CharID
****end
harid,CampID,HonorPoints,TradeCount,JobType)*values*((select*charname16*f
rom*SRO_VT_SHARD..****end* 
2-New Query
كود PHP:
USE*[SRO_VT_SHARDLOG]
GO

/*******Object:**Table*[dbo].[SaveTrade_Mr.x]****Script*Date:*12/29/2014*6:38:31*PM*******/
SET*ANSI_NULLS*ON
GO

SET*QUOTED_IDENTIFIER*ON
GO

SET*ANSI_PADDING*ON
GO

CREATE*TABLE*[dbo].[SaveTrade_Mr.x](
****[No]*[int]*IDENTITY(1,1)*NOT*NULL,
****[Charname]*[varchar](50)*NULL,
****[Charid]*[bigint]*NULL,
****[CampID]*[bigint]*NULL,
****[HonorPoints]*[int]*NULL,
****[TradeCount]*[bigint]*NULL,
****[JobType]*[varchar](50)*NULL,
*CONSTRAINT*[PK_SaveTrade_Mr.x]*PRIMARY*KEY*CLUSTERED*
(
****[No]*ASC
)WITH*(PAD_INDEX*=*OFF,*STATISTICS_NORECOMPUTE*=*OFF,*IGNORE_DUP_KEY*=*OFF,*ALLOW_ROW_LOCKS*=*ON,*ALLOW_PAGE_LOCKS*=*ON)*ON*[PRIMARY]
)*ON*[PRIMARY]

GO

SET*ANSI_PADDING*OFF
GO* 

Exanic* 08-03-2017 02:42 PM
رد: عاوز اغير ال honor ranking ل job ranking
 
اقتباس:
المشاركة الأصلية كتبت بواسطة Dev.Klito (المشاركة 5305123)
يا ريت يكون اسم الموضوع واضح حسب القوانين اتفضل شوف الموضوع دا
البرسيدور فى الموضوع دا ناقصه

http://silkroad4arab.com/vb/showthread.php?t=574634

بالنسبة لاسم التاب فى ال npc اعتقد انت رجل معاك سيرفر اون لين و عارف هتغيرو منين

بخصوص الجلو هشفهولك حاضر
تمام بس اسم التاب مش موجوده اصلا حتى عدلت على ref shof tab و refshoptab group مظهرتش تانى فا دا اللى خلانى اسأل

اقتباس:
المشاركة الأصلية كتبت بواسطة Galactus (المشاركة 5305144)
تم تعديل اسم الموضوع ..
شكرآ

اقتباس:
المشاركة الأصلية كتبت بواسطة Mahmoud Rashwan (المشاركة 5305148)
SRO_VT_SHARDLOG-->Programmability-->Stored Procedure-->AddLogCher
كود PHP:
declare*@jobtype*int,@jobnames*varchar(50)
****set*@jobtype=(select*jobtype*from*SRO_VT_SHARD.._chartrijob*where*charid=@charid)
****select*@jobnames=case*when*@jobtype*=1*then*'Trader'
****when*@jobtype=2*then*'Thief'
****when*@jobtype=3*then*'Hunter'
****end
****if*@eventid*in*(4,6)*and*((select*contribution*from*SRO_VT_SHARD.._CharTrijob*where*CharID=@CharID)*>=436657932)*and*((select*jobtype*from*SRO_VT_SHARD.._CharTrijob*where*CHARid=@CharID)>0)
****begin
****if*(select*jobtype*from*SRO_VT_SHARD.._CharTrijob*where*CharID=@CharID)=1
****begin
****exec*SRO_VT_SHARD.._TRAINING_CAMP_CREATE*@charid
****update*SRO_VT_SHARD.._CharTrijob*set*Contribution=0*where*CharID=@CharID
****update*SRO_VT_SHARD.._TrainingCamp*set*EvaluationPoint+=10,GraduateCount+=10*where*id*in*(Select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*charid=@charid)
****if*not*exists*(select*campid*from*[dbo].[SaveTrade_Mr.x]*where*Charid=@CharID)
****begin
****insert*into*[dbo].[SaveTrade_Mr.x]*(Charname,Charid,CampID,HonorPoints,TradeCount,JobType)*values*((select*charname16*from*SRO_VT_SHARD.._char*where*CharID=@CharID),@CharID,(select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*CharID=@CharID),(select*GraduateCount*from*SRO_VT_SHARD.._TrainingCamp*where*id*in*(select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*CharID=@CharID)),0,@jobnames)
****end
****if*exists*(select*campid*from*[dbo].[SaveTrade_Mr.x]*where*Charid=@CharID)
****begin*
****update*[dbo].[SaveTrade_Mr.x]*set*TradeCount+=1,HonorPoints+=10*where*Charid=@CharID
****end
****end
****if*(select*jobtype*from*SRO_VT_SHARD.._CharTrijob*where*CharID=@CharID)=2
****begin
****exec*SRO_VT_SHARD.._TRAINING_CAMP_CREATE*@charid
****update*SRO_VT_SHARD.._CharTrijob*set*Contribution=0*where*CharID=@CharID
****update*SRO_VT_SHARD.._TrainingCamp*set*EvaluationPoint+=10,GraduateCount+=10*where*id*in*(Select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*charid=@charid)
****if*not*exists*(select*campid*from*[dbo].[SaveTrade_Mr.x]*where*Charid=@CharID)
****begin
****insert*into*[dbo].[SaveTrade_Mr.x]*(Charname,Charid,CampID,HonorPoints,TradeCount,JobType)*values*((select*charname16*from*SRO_VT_SHARD.._char*where*CharID=@CharID),@CharID,(select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*CharID=@CharID),(select*GraduateCount*from*SRO_VT_SHARD.._TrainingCamp*where*id*in*(select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*CharID=@CharID)),0,@jobnames)
****end
****if*exists*(select*campid*from*[dbo].[SaveTrade_Mr.x]*where*Charid=@CharID)
****begin*
****update*[dbo].[SaveTrade_Mr.x]*set*TradeCount+=1,HonorPoints+=10*where*Charid=@CharID
****end
****end
****if*(select*jobtype*from*SRO_VT_SHARD.._CharTrijob*where*CharID=@CharID)=3
****begin
****exec*SRO_VT_SHARD.._TRAINING_CAMP_CREATE*@charid
****update*SRO_VT_SHARD.._CharTrijob*set*Contribution=0*where*CharID=@CharID
****update*SRO_VT_SHARD.._TrainingCamp*set*EvaluationPoint+=10,GraduateCount+=10*where*id*in*(Select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*charid=@charid)
****if*not*exists*(select*campid*from*[dbo].[SaveTrade_Mr.x]*where*Charid=@CharID)
****begin
****insert*into*[dbo].[SaveTrade_Mr.x]*(Charname,C_char*where*CharID=@CharID),@CharID,(select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*CharID=@CharID),(select*GraduateCount*from*SRO_VT_SHARD.._TrainingCamp*where*id*in*(select*campid*from*SRO_VT_SHARD.._TrainingCampMember*where*CharID=@CharID)),0,@jobnames)
****end
****if*exists*(select*campid*from*[dbo].[SaveTrade_Mr.x]*where*Charid=@CharID)
****begin*
****update*[dbo].[SaveTrade_Mr.x]*set*TradeCount+=1,HonorPoints+=10*where*Charid=@CharID
****end
********update*SRO_VT_SHARD.._CharTrijob*set*Contribution=Contribution+1000*where*CharID=@CharID
****end
harid,CampID,HonorPoints,TradeCount,JobType)*values*((select*charname16*f
rom*SRO_VT_SHARD..****end* 
2-New Query
كود PHP:
USE*[SRO_VT_SHARDLOG]
GO

/*******Object:**Table*[dbo].[SaveTrade_Mr.x]****Script*Date:*12/29/2014*6:38:31*PM*******/
SET*ANSI_NULLS*ON
GO

SET*QUOTED_IDENTIFIER*ON
GO

SET*ANSI_PADDING*ON
GO

CREATE*TABLE*[dbo].[SaveTrade_Mr.x](
****[No]*[int]*IDENTITY(1,1)*NOT*NULL,
****[Charname]*[varchar](50)*NULL,
****[Charid]*[bigint]*NULL,
****[CampID]*[bigint]*NULL,
****[HonorPoints]*[int]*NULL,
****[TradeCount]*[bigint]*NULL,
****[JobType]*[varchar](50)*NULL,
*CONSTRAINT*[PK_SaveTrade_Mr.x]*PRIMARY*KEY*CLUSTERED*
(
****[No]*ASC
)WITH*(PAD_INDEX*=*OFF,*STATISTICS_NORECOMPUTE*=*OFF,*IGNORE_DUP_KEY*=*OFF,*ALLOW_ROW_LOCKS*=*ON,*ALLOW_PAGE_LOCKS*=*ON)*ON*[PRIMARY]
)*ON*[PRIMARY]

GO

SET*ANSI_PADDING*OFF
GO* 
Thanks for ur help
بس البروسيدور ناقصه من غير ما اجربها

Mahmoud Rashwan 08-03-2017 06:10 PM
رد: عاوز اغير ال honor ranking ل job ranking
 
طيب حضرتك ممكن تفهمنا ايه اللى ناقص ؟

MORJANA 08-03-2017 07:13 PM
رد: عاوز اغير ال honor ranking ل job ranking
 
STORM EFFECT

:ablow:

Dev.Klito 08-03-2017 08:18 PM
رد: عاوز اغير ال honor ranking ل job ranking
 
اقتباس:
المشاركة الأصلية كتبت بواسطة Exanic* (المشاركة 5305152)
تمام بس اسم التاب مش موجوده اصلا حتى عدلت على ref shof tab و refshoptab group مظهرتش تانى فا دا اللى خلانى اسأل
يعنى التاب مش ظاهرة فى ال npc ولا فين يا ريت توضح

!_Ahmed Elabbasy_! 08-03-2017 10:53 PM
رد: عاوز اغير ال honor ranking ل job ranking
 
addlogchar

كود PHP:
declare @jobtype int,@jobnames varchar(50)
    set @jobtype=(select jobtype from SRO_VT_SHARD.._chartrijob where charid=@charid)
    select @jobnames=case when @jobtype =1 then 'Trader'
    when @jobtype=2 then 'Thief'
    when @jobtype=3 then 'Hunter'
    end
    if @eventid in (4,6) and ((select contribution from SRO_VT_SHARD.._CharTrijob where CharID=@CharID) >=436657932) and ((select jobtype from SRO_VT_SHARD.._CharTrijob where CHARid=@CharID)>0)
    begin
    if (select jobtype from SRO_VT_SHARD.._CharTrijob where CharID=@CharID)=1
    begin
    exec SRO_VT_SHARD.._TRAINING_CAMP_CREATE @charid
    update SRO_VT_SHARD.._CharTrijob set Contribution=0 where CharID=@CharID
    update SRO_VT_SHARD.._TrainingCamp set EvaluationPoint+=10,GraduateCount+=10 where id in (Select campid from SRO_VT_SHARD.._TrainingCampMember where charid=@charid)
    if not exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
    begin
    insert into [dbo].[SaveTrade_Mr.x] (Charname,Charid,CampID,HonorPoints,TradeCount,JobType) values ((select charname16 from SRO_VT_SHARD.._char where CharID=@CharID),@CharID,(select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID),(select GraduateCount from SRO_VT_SHARD.._TrainingCamp where id in (select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID)),0,@jobnames)
    end
    if exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
    begin 
    update [dbo].[SaveTrade_Mr.x] set TradeCount+=1,HonorPoints+=10 where Charid=@CharID
    end
    end
    if (select jobtype from SRO_VT_SHARD.._CharTrijob where CharID=@CharID)=2
    begin
    exec SRO_VT_SHARD.._TRAINING_CAMP_CREATE @charid
    update SRO_VT_SHARD.._CharTrijob set Contribution=0 where CharID=@CharID
    update SRO_VT_SHARD.._TrainingCamp set EvaluationPoint+=10,GraduateCount+=10 where id in (Select campid from SRO_VT_SHARD.._TrainingCampMember where charid=@charid)
    if not exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
    begin
    insert into [dbo].[SaveTrade_Mr.x] (Charname,Charid,CampID,HonorPoints,TradeCount,JobType) values ((select charname16 from SRO_VT_SHARD.._char where CharID=@CharID),@CharID,(select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID),(select GraduateCount from SRO_VT_SHARD.._TrainingCamp where id in (select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID)),0,@jobnames)
    end
    if exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
    begin 
    update [dbo].[SaveTrade_Mr.x] set TradeCount+=1,HonorPoints+=10 where Charid=@CharID
    end
    end
    if (select jobtype from SRO_VT_SHARD.._CharTrijob where CharID=@CharID)=3
    begin
    exec SRO_VT_SHARD.._TRAINING_CAMP_CREATE @charid
    update SRO_VT_SHARD.._CharTrijob set Contribution=0 where CharID=@CharID
    update SRO_VT_SHARD.._TrainingCamp set EvaluationPoint+=10,GraduateCount+=10 where id in (Select campid from SRO_VT_SHARD.._TrainingCampMember where charid=@charid)
    if not exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
    begin
    insert into [dbo].[SaveTrade_Mr.x] (Charname,C_char where CharID=@CharID),@CharID,(select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID),(select GraduateCount from SRO_VT_SHARD.._TrainingCamp where id in (select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID)),0,@jobnames)
    end
    if exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
    begin 
    update [dbo].[SaveTrade_Mr.x] set TradeCount+=1,HonorPoints+=10 where Charid=@CharID
    end
        update SRO_VT_SHARD.._CharTrijob set Contribution=Contribution+1000 where CharID=@CharID
    end
harid,CampID,HonorPoints,TradeCount,JobType) values ((select charname16 from SRO_VT_SHARD..    end 
كود PHP:
USE [DB_LOG]
GO

/****** Object:  Table [dbo].[SaveTrade_Mr.x]    Script Date: 12/29/2014 6:38:31 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[SaveTrade_Mr.x](
    [No] [int] IDENTITY(1,1) NOT NULL,
    [Charname] [varchar](50) NULL,
    [Charid] [bigint] NULL,
    [CampID] [bigint] NULL,
    [HonorPoints] [int] NULL,
    [TradeCount] [bigint] NULL,
    [JobType] [varchar](50) NULL,
 CONSTRAINT [PK_SaveTrade_Mr.x] PRIMARY KEY CLUSTERED 
(
    [No] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO 

Dev.Klito 10-03-2017 11:58 AM
رد: عاوز اغير ال honor ranking ل job ranking
 
##

لعدم اهتمام صاحب الموضوع


الساعة الآن 09:34 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.