6.4.2 Server files and code and more

[keyrita1]

Do you have 6.5.2.2758Client？

 

[angel223]

Do you have 6.5.2.2758Client？

Sorry, friend, I don't have a 6.5.2.2758 client.

 

[keyrita1]

Do you have 6.4.2.2758Client？

 

[hangu]

Yes, I have a 6.4.xx client, but I'm more interested in lua, please post the 6.4.2 server assembly.

thanks in advance. =)

Do you have 6.4.2.2758Client？

Yes, I have a 6.4.xx client, but I'm more interested in lua, please post the 6.4.2 server assembly.

thanks in advance. =)

 

[keyrita1]

Add me qq to you
QQ:232169238

 

[hangu]

Add me qq to you
QQ:232169238

don't use qq =(
throw off the lua at least some quests do not work = (

 

[Mageoski]

I'm not sure, but i think if quests aren't working its not a lua problem. I guess its more a database problem.

 

[hangu]

I'm not sure, but i think if quests aren't working its not a lua problem. I guess its more a database problem.

therefore I want to update the server, Please share the link again! I will be very grateful!

 

[pseudorndnbr]

Unfortunately it seems all the links are dead. If anyone would be willing to send me a download link via PM, I would really appreciate it.

 

[Cloxdie]

I'm looking for 6.4.2(or 7.0) server files or source code. How do I get these files? Who can help me?

 

[CDWriter]

Same here someone please put it on a site

 

[CDWriter]

Damn no one else tryes to help here is the Link for 6.4.2 again

[URL="HAHAHA someone reported this link so its down........[/URL]


Anyone have any NEW zone.ini files they would like to share BASED off Official Game...


HAHAHA someone reported this link so its down........

 

[CDWriter]

Thank for theses ... beardilus i got them working ... was there any new zone.ini for these ... I do not run a server i do it for the privilege of screwing over runs of magic them self since they deleted my level 85 toon while i was in Iraq,

again thanks

For anyone who needs Patches to 6.4.2 or higher go here .....

You must be registered to see links

dont pay anyone for the updates........And not sure if you can run just the last one or if you have to run them all to update to what you need.. But there all there I got everything too patch_7.2.0.2820.en_7.2.0.282 just in case 1 day someone will release 7 or higher...

After reading things here i forgot others thanks theDomo , Lifefire for the exe builds and boost libs,

 

[Lifefire]

i grabbed my link from a different post and turned it into it's own thread...


[Release] Official RoM Manual Patches

 

[CDWriter]

Thanks Lifefire .... hey any help on this table ???? Not sure why i get this error

(5)20:22:06 DB Write Error SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETDATE()) and ( worldID=-1 or worldID = 1)
(5)20:22:16 DB Write Error SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETDATE()) and ( worldID=-1 or worldID = 1)
(5)20:22:26 DB Write Error SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETDATE()) and ( worldID=-1 or worldID = 1)
(5)20:22:36 DB Write Error SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETDATE()) and ( worldID=-1 or worldID = 1)
(5)20:22:46 DB Write Error SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETDATE()) and ( worldID=-1 or worldID = 1)

and my table is

CREATE TABLE [dbo].[BuffSchedule](
[ZoneID] [int] NOT NULL CONSTRAINT [DF_BuffSchedule_ZoneID] DEFAULT ((-1)),
[CAST] [bigint] NOT NULL CONSTRAINT [DF_BuffSchedule_CAST] DEFAULT ((-1)),
[EndTime] [float] NOT NULL CONSTRAINT [DF_BuffSchedule_EndTime] DEFAULT ((0)),
[BuffID] [int] NOT NULL CONSTRAINT [DF_BuffSchedule_BuffID] DEFAULT ((-1)),
[BuffLv] [int] NOT NULL CONSTRAINT [DF_BuffSchedule_BuffLv] DEFAULT ((-1)),

help would be great ....

 

[Lifefire]

Yes your error is with your table... specifically 'CAST( EndTime as float)' is not a column, it is a coversion.

Change your table to:

CREATE TABLE [dbo].[BuffSchedule](
    [WorldID] [int] NOT NULL,
    [ZoneID] [int] NOT NULL,
    [BuffID] [int] NOT NULL,
    [BuffLv] [int] NOT NULL,
    [StartTime] [real] NOT NULL,
    [EndTime] [real] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[BuffSchedule] ADD  DEFAULT ((1)) FOR [WorldID]
GO

ALTER TABLE [dbo].[BuffSchedule] ADD  DEFAULT ((-1)) FOR [ZoneID]
GO

ALTER TABLE [dbo].[BuffSchedule] ADD  DEFAULT ((0)) FOR [BuffID]
GO

ALTER TABLE [dbo].[BuffSchedule] ADD  DEFAULT ((0)) FOR [BuffLv]
GO

 

[CDWriter]

100000 thanks lifefire the Ms Sql thows me off alot ... another words i HATE it.... bt again thanks ...
Thanks again



Hopefully this will be my last Sql error how ever i get this error now ?

(5)21:25:44 SQL ERROR SELECT Day, ZoneGroupID FROM WeekInstances
(5)21:25:44 SQLERR [RETCODE]=-1 [SqlState]=S0002 [NativeError]=208
[BkSqlCmd]SELECT KeyStr,Value FROM SysKeyValue WHERE (WorldID = - 1) OR (WorldID = 1)
[SQLCMD]SELECT Day, ZoneGroupID FROM WeekInstances
[ErrorCode][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'WeekInstances'. [SuccessCmd]0
(5)21:25:45 SQLERR

Here is my tables how i seen it ??

CREATE TABLE [dbo].[WeekInstances](
[ZoneID] [int] NOT NULL,
[ZoneGroupID] [int] NOT NULL,
[Clock] [int] NOT NULL,
[SysTime] [bigint] NOT NULL,
[SysTime_Base] [bigint] NOT NULL,
[PKType] [int] NOT NULL,
[NowStr] [int] NOT NULL,
[Now] [bigint] NOT NULL,
[Now_Float] [float] NOT NULL,
[Day] [int] NOT NULL,
[IsPvE] [int] NOT NULL,
[TimeZone] [int] NULL,
[MaxVocCount] [int] NOT NULL,
CONSTRAINT [PK_WeekInstances] PRIMARY KEY CLUSTERED
(

please let me know ?? thanks

 

[Lifefire]

you are missing your [WorldID] column in that table too... also for questions about my threads please post it over there so it all stays together.

 

[CDWriter]

(5)22:44:20 SQL ERROR SELECT Day, ZoneGroupID FROM WeekInstances
(5)22:44:20 SQLERR [RETCODE]=-1 [SqlState]=S0002 [NativeError]=208
[BkSqlCmd]SELECT KeyStr,Value FROM SysKeyValue WHERE (WorldID = - 1) OR (WorldID = 1)
[SQLCMD]SELECT Day, ZoneGroupID FROM WeekInstances
[ErrorCode][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'WeekInstances'. [SuccessCmd]0
(5)22:44:21 SQLERR
[SQLBaseClass] INFO: Connection re-established.
(5)22:44:21 SQL ERROR SELECT Day, ZoneGroupID FROM WeekInstances
(5)22:44:21 SQLERR [RETCODE]=-1 [SqlState]=S0002 [NativeError]=208
[BkSqlCmd]SELECT KeyStr,Value FROM SysKeyValue WHERE (WorldID = - 1) OR (WorldID = 1)
[SQLCMD]SELECT Day, ZoneGroupID FROM WeekInstances
[ErrorCode][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'WeekInstances'. [SuccessCmd]0

any help on why i get this error ???

 

[Lifefire]

[ErrorCode][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'WeekInstances'...


It goes in your ImportDB