Zoneserver with PvP notification

[prologos]

what about map name and X and Y cordinaes in pk shoutes

I don't know how to specify the name of the map in the ZS.
Map number is available, however.


EAX = map number
MOV EAX,DWORD PTR SS:[EBP+1C]

EAX = X coordinate
MOV EAX,DWORD PTR SS:[EBP+20]
AND EAX,000000FF

EAX = Y coordinate
MOV EAX,DWORD PTR SS:[EBP+20]
SAR EAX,8

[prologos]

It is my environment. Please see.



You must create two ODBC as follows.

ODBC Name | DB Name
-----------------------
A3ASD | ASD (DB there is a table called charac0)
A3SerialList | A3ItemEvent (DB there is a table called SerialList and RcvResult)

ID to connect to the ODBC is set to sa
ID = sa
PW = your password

[prologos]

I tried then output the name of the map you only change the ZS so complex Harco and to fix up Client is to distribute.
It can be solved most problems, read from the beginning of this thread.

To use it, you create a table that stores your map name to DB.
Run the following SQL, please create a mc table.
The table mc, there is a need to create in the DB there is charac0 and account. The following code is to create a mc tables in the ASD.
If you do not have ASD, please run by modifying the part of the USE [ASD] is the name of your DB.

USE [ASD]
GO
/****** Object:  Table [dbo].[mc]    Script Date: 2014-01-11 오전 12:50:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mc](
	[mNumber] [char](10) NOT NULL,
	[mName] [varchar](255) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO

insert_mc.zip
Modify to fit the server of your Excel files attached, to INSERT the data.
It may be changed only mName of column B. (It is written in Korean now.)
Please insert data into a table of mc with the SQL statement of the C auto-generated columns

ZoneServer_pvp.7z

[cyberinferno]

I tried then output the name of the map you only change the ZS so complex Harco and to fix up Client is to distribute.
It can be solved most problems, read from the beginning of this thread.

To use it, you create a table that stores your map name to DB.
Run the following SQL, please create a mc table.
The table mc, there is a need to create in the DB there is charac0 and account. The following code is to create a mc tables in the ASD.
If you do not have ASD, please run by modifying the part of the USE [ASD] is the name of your DB.

USE [ASD]
GO
/****** Object:  Table [dbo].[mc]    Script Date: 2014-01-11 오전 12:50:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mc](
	[mNumber] [char](10) NOT NULL,
	[mName] [varchar](255) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO

insert_mc.zip
Modify to fit the server of your Excel files attached, to INSERT the data.
It may be changed only mName of column B. (It is written in Korean now.)
Please insert data into a table of mc with the SQL statement of the C auto-generated columns

ZoneServer_pvp.7z

Can you share the server URL if it is online? Also can you share A3Client.exe you using?

By the way nice weapons you using!

[mihir]

prologos thanks for this ZS that gives map name and coordinates
but i found some problem with this ZS
1) crashes some times
2) suppose there are two players say xyz and abc
if xyz kills abc first then pvp shout is coming only when xyz kills abc now
if abc kills xyz its not showing pvp msg

- - - Updated - - -

Problem solved still testing
Thanks

[mihir]

Crash in ZS
i have attached report generated by ZS and ollydbg offset plz look after it
thaks

[prologos]

Crash in ZS
i have attached report generated by ZS and ollydbg offset plz look after it
thaks

There appears to be an error not related to the function that I have added.
Perhaps it is a part which monsters (re)generated there.

[mihir]

Thanks prologos
can you plz tell me what should i do to prevent this crash ( as this crash is sometimes not all times )

[GenialO]

Good evening, I want to tell you to i download the zoneserver, change the password of a3serial and I have connection problems with the database. Compare with other zoneserver and it is correct, but does not start, gives error 12.

Previously I had a zoneserver that at the time of pk the notification appeared, now nothing appears, that is, it does not notify who killed whom.

If someone can guide me to find the error or the reason why the pvp system does not notify, I would appreciate it.

[Prot]

Good evening, I want to tell you to i download the zoneserver, change the password of a3serial and I have connection problems with the database. Compare with other zoneserver and it is correct, but does not start, gives error 12.

Previously I had a zoneserver that at the time of pk the notification appeared, now nothing appears, that is, it does not notify who killed whom.

If someone can guide me to find the error or the reason why the pvp system does not notify, I would appreciate it.

The entire 6 year old thread you bumped is the guide you need.
Almost every question is answered in the thread.
Just spend some time reading it.