WarZ Server Setup Guide || By DeadZ Dev Team

[rictoten]

someone wanna help with make a server as this is confusing me :/

 

[iKasu]

how to fix? :grr:

all SDK install.

No Visual Studio 2008 - Yours is 2012 Express.

 

[Aero174]

No Visual Studio 2008 - Yours is 2012 Express.

VS2008

r3dPCH.cpp
2>C:\Shared\InstallableFiles\WarZ\bin\src\eternity\include\r3dPCH.h(62) : fatal error C1083: Can not open file include: unordered_map: No such file or directory

 

[withstyle]

VS2008

r3dPCH.cpp
2>C:\Shared\InstallableFiles\WarZ\bin\src\eternity\include\r3dPCH.h(62) : fatal error C1083: Can not open file include: unordered_map: No such file or directory

Installed Service Pack 1 ?

 

[Liphe_xD]

I Love You iKasu! <3

 

[SazanOFF94]

a) The WZBackend-ASP.NET.sln needs to be built as a compiled application. Move the Precompiled site contents to a location on your IIS server in (root)/api/ after building it now and any other times in this guide.
3) Tab to WZBackend-ASP.NET. Edit this file and fill in with your SQL information in "public SQLBase()".
4) 'Build' the site and put WZBackend-ASP.NET's precompiled folder on your IIS Server.
a) Remember to mark the IIS server application as an application so it can be executed. You can do this in control panel -> administrative tools -> IIS Management -> right click the folder in your www directory.
5) Change the location of the API to match in each of the solutions. Go into the solution and make sure the API base location (ctrl f -> gDomainBaseUrl ) looks like figure a in all solutions.
a)Code:

const char* gDomainBaseUrl= "/api/"; //Keep this the same. int gDomainPort = 80; // Change this to the port of the API server. bool gDomainUseSSL = false; //Change this if your IIS server uses SSL.
​Explain please what can I do?? I do not understand, I can not translate.

What is there to do?
I created following the instructions api http://forum.ragezone.com/f791/setting-webserver-api-925957/
What do I do? I'm stuck! I do not understand much.
Help me please
a) Remember to mark the IIS server application as an application so it can be executed. You can do this in control panel -> administrative tools -> IIS Management -> right click the folder in your www directory.
5) Change the location of the API to match in each of the solutions. Go into the solution and make sure the API base location (ctrl f -> gDomainBaseUrl ) looks like figure a in all solutions.
a)Code:

const char* gDomainBaseUrl= "/api/"; //Keep this the same. int gDomainPort = 80; // Change this to the port of the API server. bool gDomainUseSSL = false; //Change this if your IIS server uses SSL.

 

[fabiofloyd]

I did a little Video Tutorial but its not as good as it can be xD

I redo the Tutorial when i have another Root to setup the Server =)

Very good video but i got lost when u had to edit everything with you external ip.


I dont know how to do since i am running everything at the same machine.


I am getting error 404 because i think my api settings are wrong,

[solved]also at the end "Create client stuff", rsbuild give me errors too.[missing rsbuild.xml comment]

Can you help me? What information, log or


something do u need?

 

[War Inc]

I did a little Video Tutorial but its not as good as it can be xD

I redo the Tutorial when i have another Root to setup the Server =)

Hi,

Good tutorial !!

One question, where i can find the DB?, i download the db here (http://forum.ragezone.com/f791/setting-databases-microsoft-sql-server-924271/)

but i have the next errors:

breezenet.sql

Spoiler

Msg 139, Level 15, State 1, Procedure DB_BackupDatabase, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure DB_BackupDatabase, Line 13
Must declare the scalar variable "@databaseName".
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderChangeEmail, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderChangeEmail, Line 40
Must declare the scalar variable "@msg".
Msg 139, Level 15, State 1, Procedure BN_WarZ_GetSerial, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure BN_WarZ_GetSerial, Line 11
Must declare the scalar variable "@SerialKey".
Msg 137, Level 15, State 2, Procedure BN_WarZ_GetSerial, Line 17
Must declare the scalar variable "@SerialKey".
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'WarZ.dbo.WZ_ACCOUNT_DELETE'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'WarZ.dbo.WZ_ACCOUNT_DELETE'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Msg 156, Level 15, State 1, Procedure BN_Xsolla_CancelOrder, Line 18
Incorrect syntax near the keyword 'convert'.
Msg 137, Level 15, State 2, Procedure BN_Xsolla_CancelOrder, Line 31
Must declare the scalar variable "@OrderId".
Msg 137, Level 15, State 2, Procedure BN_Xsolla_CancelOrder, Line 62
Must declare the scalar variable "@OrderId".
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderRegister, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 16
Must declare the scalar variable "@Serial1".
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderRegister, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderRegister, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderRegister, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 29
Must declare the scalar variable "@Serial2".
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 30
Must declare the scalar variable "@Serial3".
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 31
Must declare the scalar variable "@Serial4".
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 57
Must declare the scalar variable "@Serial1".
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 69
Must declare the scalar variable "@Serial1".
Msg 139, Level 15, State 1, Procedure BN_Xsolla_StoreOrder, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure BN_Xsolla_StoreOrder, Line 35
Must declare the scalar variable "@xOrderID".

WarZ.sql

Spoiler

Msg 139, Level 15, State 1, Procedure DB_BackupDatabase, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure DB_BackupDatabase, Line 13
Must declare the scalar variable "@databaseName".
Msg 139, Level 15, State 1, Procedure FN_LevelUpBonus, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure FN_LevelUpBonus, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure FN_CreateMD5Password, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure FN_CreateMD5Password, Line 9
Must declare the scalar variable "@PASSWORD_SALT".
Msg 139, Level 15, State 1, Procedure TEMP_AddGPToUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure TEMP_AddGPToUser, Line 13
Must declare the scalar variable "@CustomerID".
Msg 139, Level 15, State 1, Procedure TEMP_AddGPToUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure TEMP_AddGPToUser, Line 20
Must declare the scalar variable "@GamePoints".
Msg 137, Level 15, State 2, Procedure TEMP_AddGPToUser, Line 29
Must declare the scalar variable "@CustomerID".
Msg 137, Level 15, State 2, Procedure TEMP_AddGPToUser, Line 36
Must declare the scalar variable "@CustomerID".
Msg 137, Level 15, State 2, Procedure TEMP_AddGPToUser, Line 37
Must declare the scalar variable "@CustomerID".
Msg 139, Level 15, State 1, Procedure FN_AlterUserGP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure FN_AlterUserGP, Line 13
Must declare the scalar variable "@GamePoints".
Msg 137, Level 15, State 2, Procedure FN_AlterUserGP, Line 26
Must declare the scalar variable "@GamePoints".
Msg 139, Level 15, State 1, Procedure FN_AddItemToUser, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure FN_AddItemToUser, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure FN_AddItemToUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure FN_AddItemToUser, Line 16
Must declare the scalar variable "@BuyStackSize".
Msg 137, Level 15, State 1, Procedure FN_AddItemToUser, Line 19
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 21
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 34
Must declare the scalar variable "@CurDate".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 40
Must declare the scalar variable "@CurDate".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 41
Must declare the scalar variable "@CurDate".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 51
Must declare the scalar variable "@BuyStackSize".
Msg 139, Level 15, State 1, Procedure WZ_CharCreate, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharCreate, Line 37
Must declare the scalar variable "@NumChars".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 38
Must declare the scalar variable "@NumChars".
Msg 139, Level 15, State 1, Procedure WZ_CharCreate, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_CharCreate, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharCreate, Line 69
Must declare the scalar variable "@CharsCreated".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 70
Must declare the scalar variable "@CharsCreated".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 73
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 75
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 77
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 79
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 83
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 86
Must declare the scalar variable "@CharID".
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 26
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 32
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 38
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 44
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 57
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 58
Must declare the scalar variable "@Price7".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 59
Must declare the scalar variable "@Price30".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 60
Must declare the scalar variable "@PriceP".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 61
Must declare the scalar variable "@GPrice1".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 62
Must declare the scalar variable "@GPrice7".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 63
Must declare the scalar variable "@GPrice30".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 64
Must declare the scalar variable "@GPriceP".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 71
Must declare the scalar variable "@IsEnabled".
Msg 139, Level 15, State 1, Procedure WZ_ClanCreate, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanCreate, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanCreate, Line 19
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 20
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 40
Must declare the scalar variable "@DEFAULT_CLAN_SIZE".
Msg 137, Level 15, State 1, Procedure WZ_ClanCreate, Line 45
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 52
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 63
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 74
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 16
Must declare the scalar variable "@PlayerClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyToJoin, Line 17
Must declare the scalar variable "@PlayerClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 38
Must declare the scalar variable "@AppTotalCounts".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyToJoin, Line 39
Must declare the scalar variable "@AppTotalCounts".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyToJoin, Line 55
Must declare the scalar variable "@APPLY_EXPIRE_TIME_HOURS".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyGetList, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyGetList, Line 13
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyGetList, Line 14
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyGetList, Line 37
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 15
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 16
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 30
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 40
Must declare the scalar variable "@AppClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 41
Must declare the scalar variable "@AppClanID".
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 51
Must declare the scalar variable "@AppClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 52
Must declare the scalar variable "@AppClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 67
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 68
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 82
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanAddClanMembers, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanAddClanMembers, Line 12
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanAddClanMembers, Line 13
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanAddClanMembers, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanAddClanMembers, Line 20
Must declare the scalar variable "@GPriceP".
Msg 137, Level 15, State 2, Procedure WZ_ClanAddClanMembers, Line 21
Must declare the scalar variable "@GPriceP".
Msg 137, Level 15, State 2, Procedure WZ_ClanAddClanMembers, Line 27
Must declare the scalar variable "@GPriceP".
Msg 137, Level 15, State 2, Procedure WZ_ClanAddClanMembers, Line 39
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_CharRevive, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharRevive, Line 10
Must declare the scalar variable "@CustomerID".
Msg 137, Level 15, State 2, Procedure WZ_CharRevive, Line 11
Must declare the scalar variable "@CustomerID".
Msg 139, Level 15, State 1, Procedure WZ_CharRevive, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharRevive, Line 18
Must declare the scalar variable "@IsDeveloper".
Msg 139, Level 15, State 1, Procedure WZ_CharRevive, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharRevive, Line 25
Must declare the scalar variable "@Alive".
Msg 137, Level 15, State 2, Procedure WZ_CharRevive, Line 29
Must declare the scalar variable "@Alive".
Msg 137, Level 15, State 2, Procedure WZ_CharRevive, Line 35
Must declare the scalar variable "@IsDeveloper".
Msg 139, Level 15, State 1, Procedure WZ_UpdateAchievementStatus, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_SRV_NoteAddNew, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_SRV_NoteAddNew, Line 36
Must declare the scalar variable "@NoteID".
Msg 139, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 20
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 23
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 26
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 29
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 32
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 38
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 43
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 46
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 49
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 52
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 139, Level 15, State 1, Procedure WZ_DB_GenerateLeaderboard7, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard7, Line 13
Must declare the scalar variable "@StartDay".
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard7, Line 41
Must declare the scalar variable "@StartDay".
Msg 139, Level 15, State 1, Procedure WZ_DB_GenerateLeaderboard30, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard30, Line 13
Must declare the scalar variable "@StartDay".
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard30, Line 14
Must declare the scalar variable "@StartDay".
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard30, Line 42
Must declare the scalar variable "@StartDay".
Msg 139, Level 15, State 1, Procedure WZ_DB_GenerateDailyLeaderboard, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateDailyLeaderboard, Line 39
Must declare the scalar variable "@CurDay".
Msg 139, Level 15, State 1, Procedure WZ_ClanSetMemberRank, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanSetMemberRank, Line 19
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetMemberRank, Line 20
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanSetMemberRank, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanSetMemberRank, Line 30
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetMemberRank, Line 31
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetMemberRank, Line 58
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetMemberRank, Line 76
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanSetLore, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanSetLore, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanSetLore, Line 12
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetLore, Line 13
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetLore, Line 19
Must declare the scalar variable "@ClanRank".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetLore, Line 24
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanKickMember, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanKickMember, Line 18
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanKickMember, Line 19
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanKickMember, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanKickMember, Line 28
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanKickMember, Line 29
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanKickMember, Line 49
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanKickMember, Line 63
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteSendToPlayer, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteSendToPlayer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanInviteSendToPlayer, Line 16
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 17
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 33
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteSendToPlayer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 37
Must declare the scalar variable "@PendingInvites".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 57
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 69
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteReportAll, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanInviteReportAll, Line 13
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteReportAll, Line 14
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteReportAll, Line 38
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteAnswer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanInviteAnswer, Line 14
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 15
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 1, Procedure WZ_ClanInviteAnswer, Line 22
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 40
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 47
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 54
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 55
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 66
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 76
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanGetEvents, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanGetEvents, Line 14
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanGetEvents, Line 15
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanGetEvents, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ClanGetEvents, Line 24
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_BackpackToInv, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_BackpackToInv, Line 90
Must declare the scalar variable "@InvInventoryID".
Msg 137, Level 15, State 1, Procedure WZ_BackpackToInv, Line 110
Must declare the scalar variable "@InvInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackToInv, Line 113
Must declare the scalar variable "@InvInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackToInv, Line 126
Must declare the scalar variable "@InvInventoryID".
Msg 139, Level 15, State 1, Procedure WZ_BackpackGridSwap, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackGridSwap, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BackpackGridSwap, Line 41
Must declare the scalar variable "@InventoryIdFrom".
Msg 137, Level 15, State 1, Procedure WZ_BackpackGridSwap, Line 42
Must declare the scalar variable "@InventoryIdTo".
Msg 137, Level 15, State 2, Procedure WZ_BackpackGridSwap, Line 45
Must declare the scalar variable "@InventoryIdFrom".
Msg 137, Level 15, State 2, Procedure WZ_BackpackGridSwap, Line 46
Must declare the scalar variable "@InventoryIdTo".
Msg 139, Level 15, State 1, Procedure WZ_BackpackFromInv, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackFromInv, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BackpackFromInv, Line 70
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 73
Must declare the scalar variable "@BackpackItemID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 83
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 91
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 1, Procedure WZ_BackpackFromInv, Line 114
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 118
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 131
Must declare the scalar variable "@BackpackInventoryID".
Msg 139, Level 15, State 1, Procedure WZ_ClanCreateCheckParams, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanCreateCheckParams, Line 11
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreateCheckParams, Line 12
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure DB_PurgeUnusedUserData, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure DB_PurgeUnusedUserData, Line 47
Must declare the scalar variable "@InvCleanDate".
Msg 137, Level 15, State 2, Procedure DB_PurgeUnusedUserData, Line 48
Must declare the scalar variable "@InvCleanDate".
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'FN_CreateMD5Password'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 9
Must declare the scalar variable "@AccountType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 16
Must declare the scalar variable "@AccountType".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 32
Must declare the scalar variable "@keyResultCode".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 36
Must declare the scalar variable "@keyResultCode".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 40
Must declare the scalar variable "@keyCustomerID".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 47
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 49
Must declare the scalar variable "@DateActiveUntil".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 51
Must declare the scalar variable "@DateActiveUntil".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 57
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 62
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 69
Must declare the scalar variable "@keySerialType".
Msg 139, Level 15, State 1, Procedure ADMIN_BanUser, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure ADMIN_BanUser, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure ADMIN_BanUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure ADMIN_BanUser, Line 21
Must declare the scalar variable "@AccountStatus".
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 26
Must declare the scalar variable "@AccountStatus".
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 41
Must declare the scalar variable "@AccountType".
Msg 137, Level 15, State 1, Procedure ADMIN_BanUser, Line 43
Must declare the scalar variable "@BanCount".
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 47
Must declare the scalar variable "@BanCount".
Msg 156, Level 15, State 1, Procedure ADMIN_BanUser, Line 62
Incorrect syntax near the keyword 'else'.
Msg 139, Level 15, State 1, Procedure ADMIN_BanUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 66
Must declare the scalar variable "@BanTime".
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 73
Must declare the scalar variable "@BanTime".
Msg 139, Level 15, State 1, Procedure WZ_Backpack_SRV_AddItem, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_Backpack_SRV_AddItem, Line 21
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure WZ_Backpack_SRV_AddItem, Line 22
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 1, Procedure WZ_Backpack_SRV_AddItem, Line 47
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure WZ_Backpack_SRV_AddItem, Line 50
Must declare the scalar variable "@InventoryID".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 20
Must declare the scalar variable "@IsDeveloper".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 50
Must declare the scalar variable "@BanExpireMin".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 55
Must declare the scalar variable "@BanExpireMin".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 94
Must declare the scalar variable "@SessionKey".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 106
Must declare the scalar variable "@SessionKey".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 125
Must declare the scalar variable "@SessionID".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN, Line 20
Must declare the scalar variable "@AccountStatus".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN, Line 43
Must declare the scalar variable "@AccountStatus".
Msg 139, Level 15, State 1, Procedure ADMIN_BanWeaponHackers, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure ADMIN_BanWeaponHackers, Line 16
Must declare the scalar variable "@dt1".
Msg 137, Level 15, State 2, Procedure ADMIN_BanWeaponHackers, Line 20
Must declare the scalar variable "@dt1".
Msg 139, Level 15, State 1, Procedure ADMIN_BanWeaponHackers, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure ADMIN_BanWeaponHackers, Line 43
Must declare the scalar variable "@BanReason".
Msg 137, Level 15, State 2, Procedure ADMIN_BanWeaponHackers, Line 50
Must declare the scalar variable "@BanReason".
Msg 137, Level 15, State 2, Procedure ADMIN_BanWeaponHackers, Line 51
Must declare the scalar variable "@BanReason".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 24
Must declare the scalar variable "@keyResultCode".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 28
Must declare the scalar variable "@keyResultCode".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 35
Must declare the scalar variable "@RefundCustomerID".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 36
Must declare the scalar variable "@RefundCustomerID".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 41
Must declare the scalar variable "@refundedEmail".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 80
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 85
Must declare the scalar variable "@keySerialType".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 87
Must declare the scalar variable "@DateActiveUntil".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 113
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 118
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 125
Must declare the scalar variable "@keySerialType".
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BackpackChange, Line 39
Must declare the scalar variable "@InvItemID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 40
Must declare the scalar variable "@InvCustomerID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 44
Must declare the scalar variable "@InvCharID".
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BackpackChange, Line 51
Must declare the scalar variable "@MaxSlots".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 52
Must declare the scalar variable "@MaxSlots".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 58
Must declare the scalar variable "@MaxSlots".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 61
Must declare the scalar variable "@InvQuantity".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 62
Must declare the scalar variable "@InvQuantity".
Msg 156, Level 15, State 1, Procedure WZ_BackpackChange, Line 65
Incorrect syntax near the keyword 'else'.
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 66
Must declare the scalar variable "@InvQuantity".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 75
Must declare the scalar variable "@InvItemID".
Msg 139, Level 15, State 1, Procedure WZ_ClanDonateToMemberGP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanDonateToMemberGP, Line 24
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanDonateToMemberGP, Line 25
Must declare the scalar variable "@MemberClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanDonateToMemberGP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanDonateToMemberGP, Line 37
Must declare the scalar variable "@ClanGP".
Msg 137, Level 15, State 2, Procedure WZ_ClanDonateToMemberGP, Line 42
Must declare the scalar variable "@ClanGP".
Msg 139, Level 15, State 1, Procedure WZ_ClanDonateToClanGP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanDonateToClanGP, Line 20
Must declare the scalar variable "@GamePoints".
Msg 137, Level 15, State 2, Procedure WZ_ClanDonateToClanGP, Line 26
Must declare the scalar variable "@GamePoints".
Msg 102, Level 15, State 1, Procedure WZ_ClanDonateToClanGP, Line 34
Incorrect syntax near '@in_GP'.
Msg 137, Level 15, State 2, Procedure WZ_ClanDonateToClanGP, Line 35
Must declare the scalar variable "@AlterGP".
Msg 139, Level 15, State 1, Procedure WZ_CharDelete, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharDelete, Line 10
Must declare the scalar variable "@CustomerID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 11
Must declare the scalar variable "@CustomerID".
Msg 139, Level 15, State 1, Procedure WZ_CharDelete, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_CharDelete, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharDelete, Line 19
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 20
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 23
Must declare the scalar variable "@ClanRank".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 27
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 34
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 39
Must declare the scalar variable "@ClanID".
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'FN_AddItemToUser'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 23
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 24
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 25
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 42
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 43
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 44
Must declare the scalar variable "@out_FNResult".
Msg 102, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 50
Incorrect syntax near '@FinalPrice'.
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 51
Must declare the scalar variable "@AlterGP".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 56
Must declare the scalar variable "@TType".
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 57
Must declare the scalar variable "@TType".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 61
Must declare the scalar variable "@TType".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 66
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 70
Must declare the scalar variable "@InventoryID".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 23
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 24
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 25
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 42
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 43
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 44
Must declare the scalar variable "@out_FNResult".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 55
Must declare the scalar variable "@TType".
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 56
Must declare the scalar variable "@TType".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 60
Must declare the scalar variable "@TType".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 65
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 69
Must declare the scalar variable "@InventoryID".

i have instaled sql sp1, sp2, sp3 :/

 

[iMgx]

Hi War Inc,

i think you've first created and done the whole procedure with the WarZ.sql.

You have to do it with the BreezeNet.sql first , then do the same with the WarZ.sql.

You will no longer get those errors.

 

[ccleanerz]

Hi War Inc,

i think you've first created and done the whole procedure with the WarZ.sql.

You have to do it with the BreezeNet.sql first , then do the same with the WarZ.sql.

You will no longer get those errors.

It seem that he use the wrong instance because i got the same problem.

 

[War Inc]

It seem that he use the wrong instance because i got the same problem.

how i fix the instance?

 

[ccleanerz]

how i fix the instance?

I don't know which instance is right for you , i had to change mine when i installed sql server 2008.
Maybe check in sql server configuration manager to know the right instance.

 

[War Inc]

I don't know which instance is right for you , i had to change mine when i installed sql server 2008.
Maybe check in sql server configuration manager to know the right instance.

I dont know sql, i need reinstall ? but i think i cant delete instances.

Any idea? :/

 

[ccleanerz]

Ok so you have 2 instances one of them is the right one , try the SQLEXPRESS2
As you can see :

I have 2 instances me too, when i installed SQl server 2008 it asked me for the instance and i put MS in front of SQLEXPRESS.
If you didn't changed that maybe it added a 2 automaticly i don't know.
If it's not SQLEXPRESS and SQLEXPRESS2 you have to reinstall it.

 

[War Inc]

Ok so you have 2 instances one of them is the right one , try the SQLEXPRESS2
As you can see :

I have 2 instances me too, when i installed SQl server 2008 it asked me for the instance and i put MS in front of SQLEXPRESS.
If you didn't changed that maybe it added a 2 automaticly i don't know.
If it's not SQLEXPRESS and SQLEXPRESS2 you have to reinstall it.

it work, ty

 

[War Inc]

Hi

new problem ! xD

i cant login in the launcher

Spoiler

--- Log started at Tue Apr 23 01:44:27 2013
000000.000| Input Devices enabled: Mouse, Keyboard
000000.033| VMEM As seen through DDRaw: 978
000000.033| VMEM As seen through WMI: 0
000000.040| We have 4045 MB texture memory
000000.040| r3dFont: Creating Verdana 10pt
000000.041| r3dFont: Finished creating Verdana 10pt
000000.041| r3dFont: Creating Tahoma 12pt
000000.041| r3dFont: Finished creating Tahoma 12pt
000000.041| r3dFont: Creating Tahoma 10pt
000000.041| r3dFont: Finished creating Tahoma 10pt
000000.041| r3dFont: Creating Tahoma 9pt
000000.041| r3dFont: Finished creating Tahoma 9pt
000000.210| Starting updater, v:0.9.3, cmd:
000000.210| Checking for new updater
000000.213| Checking for new updater - finished
000009.436| WO_API: http timeout
000009.436| Login FAILED, code: 8
000072.385| WO_API: http timeout
000072.385| Login FAILED, code: 8

another question, i can open SupervisorServer.exe and MasterServer.exe but i cant open WZ_GameServer.exe, its normal?

 

[Kirito2105]

1> Project: error PRJ0019: A tool returned an error code from "copying exe"
help pls

 

[ccleanerz]

http://forum.ragezone.com/f792/faq-updated-04-16-12-a-923228/

It's normal if you can't open gameserver.

 

[Kirito2105]

1> Project: error PRJ0019: A tool returned an error code from "copying exe"
help pls

help!

 

[War Inc]

in the tutorial when he config de iis server he use "wwps176-28-46-62.dedicated.hosteurope.de" i dont have this website, i can use "Default Web Site"?