Re-Share School War Source..

[trojan1231]

how to fix this ?


DB:SELECT SwID, SwNum FROM SwRegion WITH (NOLOCK) ORDER BY SwID
DB:42S02, NativeError:208, [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'SwRegion'.

and the 4tower not appeared in sw map during sw time



PLEASE SHARE COMPATIBLE DATABASE

no need for new Database
Just add this to your RanGame1 New Table
SwNum int not null
SwID int not null
Then name it to SwRegion

btw about 4towers setup by yourself

how to fix randombugtrap or pleasewait in fieldserver ?
please help tia!

Try to upgrade your Memory RAM

 

[ProSer]

no need for new Database
Just add this to your RanGame1 New Table
SwNum int not null
SwID int not null
Then name it to SwRegion

btw about 4towers setup by yourself





Try to upgrade your Memory RAM

thanks how about this ?

DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'sp_add_sw_region'.
DB:{call sp_add_sw_region(1,1,?)}

and this
DB:{call sp_LogAction_Insert(240,1,0,4,73786988389466112,0,0,0)}
DB:42000, NativeError:8114, [Microsoft][SQL Server Native Client 10.0][SQL Server]Error converting data type numeric to money.

TIA

 

[trojan1231]

thanks how about this ?

DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'sp_add_sw_region'.
DB:{call sp_add_sw_region(1,1,?)}

and this
DB:{call sp_LogAction_Insert(240,1,0,4,73786988389466112,0,0,0)}
DB:42000, NativeError:8114, [Microsoft][SQL Server Native Client 10.0][SQL Server]Error converting data type numeric to money.

TIA

Then try insert this script to your rangame1

USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_add_sw_region] Script Date: 11/04/2015 20:36:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




CREATE Procedure [dbo].[sp_add_sw_region]
@SwID int,
@SwNum int,
@nReturn int OUTPUT
AS
DECLARE ERROR_var int,
Rowcount_var int

SET NOCOUNT ON

SET @nReturn = 0
SET ERROR_var = 0
SET Rowcount_var = 0

IF EXISTS(SELECT * FROM SwRegion WHERE SwID=@SwID)
BEGIN -- ??? ????
UPDATE SwRegion
SET SwNum=@SwNum
WHERE SwID=@SwID

SELECT ERROR_var = ERROR, Rowcount_var = RowCOUNT
IF ERROR_var <> 0 OR Rowcount_var = 0 -- ????
BEGIN
SET @nReturn = 0
SET NOCOUNT OFF
RETURN @nReturn
END
END
ELSE
BEGIN
INSERT INTO SwRegion (SwID, SwNum)
VALUES (@SwID, @SwNum)

SELECT ERROR_var = ERROR, Rowcount_var = RowCOUNT
IF ERROR_var <> 0 OR Rowcount_var = 0 -- ????
BEGIN
SET @nReturn = 0
SET NOCOUNT OFF
RETURN @nReturn
END
END
SET @nReturn = 1
SET NOCOUNT OFF
RETURN @nReturn

 

[ProSer]

Then try insert this script to your rangame1

USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_add_sw_region] Script Date: 11/04/2015 20:36:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




CREATE Procedure [dbo].[sp_add_sw_region]
@SwID int,
@SwNum int,
@nReturn int OUTPUT
AS
DECLARE @ERROR_var int,
@Rowcount_var int

SET NOCOUNT ON

SET @nReturn = 0
SET @ERROR_var = 0
SET @Rowcount_var = 0

IF EXISTS(SELECT * FROM SwRegion WHERE SwID=@SwID)
BEGIN -- ??? ????
UPDATE SwRegion
SET SwNum=@SwNum
WHERE SwID=@SwID

SELECT @ERROR_var = @ERROR, @Rowcount_var = @RowCOUNT
IF @ERROR_var <> 0 OR @Rowcount_var = 0 -- ????
BEGIN
SET @nReturn = 0
SET NOCOUNT OFF
RETURN @nReturn
END
END
ELSE
BEGIN
INSERT INTO SwRegion (SwID, SwNum)
VALUES (@SwID, @SwNum)

SELECT @ERROR_var = @ERROR, @Rowcount_var = @RowCOUNT
IF @ERROR_var <> 0 OR @Rowcount_var = 0 -- ????
BEGIN
SET @nReturn = 0
SET NOCOUNT OFF
RETURN @nReturn
END
END
SET @nReturn = 1
SET NOCOUNT OFF
RETURN @nReturn

Msg 137, Level 15, State 2, Procedure sp_add_sw_region, Line 25
Must declare the scalar variable "@ERROR".
Msg 137, Level 15, State 2, Procedure sp_add_sw_region, Line 38
Must declare the scalar variable "@ERROR".

 

[Ran Wing]

 

[Adriane Angeles]

sir pa share naman po ng _bin file. TIA

 

[Ran Wing]

_bin(RAN TH)

You must be registered to see links

sir pa share naman po ng _bin file. TIA

_bin(RAN EN)

https://mega.nz/#!0NcFGIQI!rOvgqiql1lJ36Z_OG4u-w80tHgWcPUoNYGm_Md7u9UM



cfg

https://mega.nz/#!dVFCHSYS!WH_yRptLTz_3-wuj8wuZkIvgMC1nxtkmr3GF8nFfidE


glogicserverของMMR

https://mega.nz/#!9MUnmbBT!eq10lcqUpmGQYnVcqtbkJf5wKmYWE5cJG12Qi-z6Tjw

 

[blackcatyb]

_bin(RAN TH)

You must be registered to see links

_bin(RAN EN)

https://mega.nz/#!0NcFGIQI!rOvgqiql1lJ36Z_OG4u-w80tHgWcPUoNYGm_Md7u9UM



cfg

https://mega.nz/#!dVFCHSYS!WH_yRptLTz_3-wuj8wuZkIvgMC1nxtkmr3GF8nFfidE


glogicserverของMMR

https://mega.nz/#!FAUXlZyC!29Dkx-DOKqeb54wiwq7szSTZBSr0oz33c1b5vlvPE9w

Bro can upload glogicserver

 

[elucidator]

what's the name of the table? i think "SchoolWar"

 

[Adriane Angeles]

_bin(RAN TH)

You must be registered to see links

_bin(RAN EN)

https://mega.nz/#!0NcFGIQI!rOvgqiql1lJ36Z_OG4u-w80tHgWcPUoNYGm_Md7u9UM



cfg

https://mega.nz/#!dVFCHSYS!WH_yRptLTz_3-wuj8wuZkIvgMC1nxtkmr3GF8nFfidE


glogicserverของMMR

https://mega.nz/#!FAUXlZyC!29Dkx-DOKqeb54wiwq7szSTZBSr0oz33c1b5vlvPE9w

Sir what is the .ini of the School war in your glogicserver? do i need to add the ShoolWar.ini that is shared? and how to configure it?

 

[inlove]

Thank You

REMOVED

 

[Ran Wing]

Thank You

REMOVED

นายของguiหน่อยดิได้ปะแลกกับจักกลแสงก้ได้

 

[Adriane Angeles]

how to configure SW?

 

[ProSer]

how to fix cw bug ?
after kill 1 player then move to room again then the character need to Z to kill
the character is white name not red name
and i try to verify the room after few sec the verify has been cancel and i don`t know why
please help sorry for my english :/

 

[goodboy454]

how to fix cw bug ?
after kill 1 player then move to room again then the character need to Z to kill
the character is white name not red name
and i try to verify the room after few sec the verify has been cancel and i don`t know why
please help sorry for my english :/

try to edit the maplist.ini and find the map of CW that u want to change and u can find there a
FreePk 1 = on 0 = off. also do this in your SW map. Hope it helps.

 

[Lincoln]

update client

 

[markalejo11]

what map for SW ??

 

[goodboy454]

what map for SW ??

fightmap.lev

 

[carvicsy09]

problem school war i cant see other school tower

DB:{call sp_add_sw_region(1,2,?)}
DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'sp_add_sw_region'.

 

[Lincoln]

database file?