I Need A Bit Of Help :(

Hello Fourms,

I have suffered an issue for the past couple hours with my server. I rewrote my API which actually worked. But I figured out the accounts that weren't being created on my Database. So I changed everything back to my information and here it is that my server says "Could Not Connect To Server, Please Try Again Later". Here is the r3dlog of my game. I cannot seem to fix this error :(




--- Log started at Sun Mar 09 18:50:23 2014


000000.520| ComputerID: 0x1d37a075bb81
000000.520| Game Version: WarZ v1.0 (build: Mar 2 2014 20:28:48) - final
000000.520| Available memory: 3327 MB
000000.547| r3dFS: version:March 9, 2014 0:37, 23261 files
000000.640| readGameOptionsFile: found INI at C:\Users\Chris\Documents\Arktos\WarZ\gameSettings.ini
000000.641| writeGameOptionsFile: Saving settings to C:\Users\Chris\Documents\Arktos\WarZ\gameSettings.ini
000000.665| readInputMap: found file at C:\Users\Chris\Documents\Arktos\WarZ\inputMap.xml
000000.677| writeInputMap: Saving settings to C:\Users\Chris\Documents\Arktos\WarZ\inputMap.xml
000000.712| userSettings: found file at C:\Users\Chris\Documents\Arktos\WarZ\userSettings.xml
000000.740| userSettings: Saving settings to C:\Users\Chris\Documents\Arktos\WarZ\userSettings.xml
000000.778| SOUND: initializing sound system
000001.964| SOUND: '1' sound drivers found
000001.972| SOUND: sound caps = 0xF8, speakermode= 2
000001.972| SOUND: sound driver 'Headset Earphone (USB Audio Device)'
000002.071| SOUND: sound system ready
000002.071| FMOD: LoadSoundEffects: Loading from Data\Sounds\Sounds.fev
000006.363| Input Devices enabled: Mouse, Keyboard
000006.426| VMEM As seen through DDRaw: 978
000006.426| VMEM As seen through WMI: 0
000006.426| Setting mode: 1680x1050x32 Flags=4
000006.467| NVApi successfuly initialized.
000006.467| NVApi: stereo is not available. Stereo driver not installed?
000006.467| Adapter: NVIDIA GeForce GT 630
000006.468| nvd3dum.dll 9.18.13.2018
000006.468| Monitor: \\.\DISPLAY1 (1680x1050)
000006.521| res adjusted 1680x1050->1674x1022
000006.523| r3dRenderLayer::SetMode(x=1674,y=1022,bpp=32,windowed=4,hz=59)
000006.525| Creating d3d device
000006.551| NVApi: failed to create stereo handle!
000006.551| GPU supports D3DQUERYTYPE_TIMESTAMP
000006.551| GPU supports D3DQUERYTYPE_TIMESTAMPFREQ
000006.551| D3D hack support = NullRT: 1, hwPCF: 1, IntZ: 1, ResZ: 0
000006.552| We have 2366 MB texture memory
000006.601| r3dFont: Creating Verdana 10pt
000006.602| r3dFont: Finished creating Verdana 10pt
000006.603| Loading shaders...
000008.051| Finished loading shaders (1.447874 sec)!
000008.447| r3dFont: Creating Tahoma 12pt
000008.450| r3dFont: Finished creating Tahoma 12pt
000008.450| r3dFont: Creating Verdana 10pt
000008.450| r3dFont: Finished creating Verdana 10pt
000008.830| Creating render targets
000008.837| r3dFont: Creating Verdana 8pt
000008.841| r3dFont: Finished creating Verdana 8pt
000008.961| Loaded 15 of 15 grass settings locations from the glist file
000008.961| r3dFile: can't open Data/Grass/BM_Grass_Far.xml
000008.961| r3dFile: can't open Data/Grass/BM_Grass_Med.xml
000008.961| r3dFile: can't open Data/Grass/BM_Grass_Near.xml
000008.962| Loaded 12 grass settings files
000011.724| SetHomeDir: Levels\WZ_FrontEndLighting
000011.724| We have 2201 MB texture memory
000011.826| WO_API: failed with error code 5 System.IndexOutOfRangeException: IsPunisher


at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)


at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)


at System.Data.SqlClient.SqlDataReader.get_Item(String name)


at api_GetProfile1.Execute()


at WOApiWebPage.Page_Load(Object sender, EventArgs _e)
000011.826| GetProfile FAILED, code: 5
000011.895| Couldn't get profile data! stage: 4
000016.432| obj_Zombie::FreePhysSkeletonCache:000016.432| done in 0.00 seconds
000016.444| Deleting render targets
000016.559|
000016.563| WARNING: pd3ddev have 10 reference counts

I had that error once. When I get online ill help you.

Quote:

---

Originally Posted by m70b1jr

I had that error once. When I get online ill help you.

---

Thanks bro :)

It's because the api is different from the one you're meant to be using.

check your table "UsersData"

SELECT TOP 1000
[CustomerID]
,[IsDeveloper]
,[AccountType]
,[AccountStatus]
,[GamePoints]
,[GameDollars]
,[dateregistered]
,[lastjoineddate]
,[lastgamedate]
,[ClanID]
,[ClanRank]
,[GameServerId]
,[CharsCreated]
,[TimePlayed]
,[DateActiveUntil]
,[BanTime]
,[BanReason]
,[BanCount]
,[BanExpireDate]
,[IsPunisher]
,[ReportCount]
FROM [WarZ].[dbo].[UsersData]

and api script
PROCEDURE [dbo].[WZ_ACCOUNT_CREATE]
PROCEDURE [dbo].[WZ_CharCreate]
...
...
and more

Thanks

>> Click Like <<

Quote:

---

Originally Posted by javaz97

>> Click Like <<

---

Well I can't because phpmyretro hacked my rdp/vps so I didn't even get to fix my error now I'm stuck with another error pleas java skype me

Batman19062

Quote:

---

Originally Posted by javaz97

check your table "UsersData"

SELECT TOP 1000
[CustomerID]
,[IsDeveloper]
,[AccountType]
,[AccountStatus]
,[GamePoints]
,[GameDollars]
,[dateregistered]
,[lastjoineddate]
,[lastgamedate]
,[ClanID]
,[ClanRank]
,[GameServerId]
,[CharsCreated]
,[TimePlayed]
,[DateActiveUntil]
,[BanTime]
,[BanReason]
,[BanCount]
,[BanExpireDate]
,[IsPunisher]
,[ReportCount]
FROM [WarZ].[dbo].[UsersData]

and api script
PROCEDURE [dbo].[WZ_ACCOUNT_CREATE]
PROCEDURE [dbo].[WZ_CharCreate]
...
...
and more

---

okey here is my "usersdata":http://kepfeltoltes.hu/view/140406/D...toltes.hu_.png
but where can i find "and api script
PROCEDURE [dbo].[WZ_ACCOUNT_CREATE]
PROCEDURE [dbo].[WZ_CharCreate]"
and how?

- - - Updated - - -

Quote:

---

Originally Posted by manhun1222

okey here is my "usersdata":http://kepfeltoltes.hu/view/140406/D...toltes.hu_.png
but where can i find "and api script
PROCEDURE [dbo].[WZ_ACCOUNT_CREATE]
PROCEDURE [dbo].[WZ_CharCreate]"
and how?

---

i cant add this line for UsersData
[IsPunisher]
,[ReportCount]

because:invalid column name