SOD Scores

[rdcodester]

Hi guyz.. i have been wondering about this problem of mine for a week and i havent set it up correctly yet. so heres what ive got. though search it alot of times..

my clan is working although it always prompt unknown error 65 something.. after clan is created

the real deal is SOD i dont know how to make it works.. i already run ClanSODManager and set it correctly.. i find out that SOD doesnt work without sql.dll ? or maybe theres a way to make it work without sql.dll but i dont know how..

or is it already working and i only need 4 players to really make it record it score?.. im confused because it is set in clansodmanager that 2 players only need to survive in order to save the score, i tried it also but it didnt work

 

[Antiox]

maybe you type the wrong name of "SoDdB" you can get it in SQL

 

[SunnyZ]

error 65 is I think something to do with clanicons not being able to load em up (need write permission to ClanContent folder in teh web server, or something like that), no big deal with it.

How ever with sod, you must make sure you have the correct sql scripts.
The proper script for sandurrs clan sod manager should look similar to this.

The propper SQL script is below.

Spoiler

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Sod2Config]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Sod2Config](
[MIDX] [int] NULL,
[ClanName] [varchar](50) NULL,
[UserID] [varchar](50) NULL,
[CharName] [varchar](50) NULL,
[SelServer] [int] NOT NULL,
[ServerName] [varchar](50) NULL,
[TaxRates] [int] NOT NULL,
[OperFrom] [datetime] NOT NULL,
[OperTo] [datetime] NOT NULL,
[TotalEnterMoney] [bigint] NULL,
[BeforeMoney] [bigint] NULL,
[TodayMoney] [bigint] NULL,
[TotalMoney] [bigint] NULL,
[TotalEnterNum] [int] NULL,
[UpdateDate] [datetime] NULL,
[Note] [text] NULL,
[MIDX1] [int] NULL,
[MIDX2] [int] NULL,
[M0money] [bigint] NULL,
[M1money] [bigint] NULL,
[M2money] [bigint] NULL,
[VInfo] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Sod2ConfigLog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Sod2ConfigLog](
[IDX] [int] NOT NULL,
[MIDX] [int] NULL,
[ClanName] [varchar](50) NULL,
[UserID] [varchar](50) NULL,
[CharName] [varchar](50) NULL,
[SelServer] [int] NOT NULL,
[ServerName] [varchar](50) NULL,
[TaxRates] [int] NOT NULL,
[OperFrom] [datetime] NOT NULL,
[OperTo] [datetime] NOT NULL,
[TotalEnterMoney] [bigint] NULL,
[BeforeMoney] [bigint] NULL,
[TodayMoney] [bigint] NULL,
[TotalMoney] [bigint] NULL,
[TotalEnterNum] [int] NULL,
[UpdateDate] [datetime] NULL,
[Note] [text] NULL,
[MIDX1] [int] NULL,
[MIDX2] [int] NULL,
[M0money] [bigint] NULL,
[M1money] [bigint] NULL,
[M2money] [bigint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Sod2TaxLog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Sod2TaxLog](
[IDX] [int] NOT NULL,
[MIDX] [int] NULL,
[ClanName] [varchar](50) NULL,
[MCount] [int] NULL,
[UserID] [varchar](50) NULL,
[CharName] [varchar](50) NULL,
[SelServer] [int] NULL,
[TaxRates] [int] NULL,
[OperFrom] [datetime] NULL,
[OperTo] [datetime] NULL,
[RegiDate] [datetime] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UserBlackList]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[UserBlackList](
[SOD2No] [int] NOT NULL,
[UserID] [varchar](32) NOT NULL,
[CharName] [varchar](50) NOT NULL,
[ServerCode] [int] NOT NULL,
[Memo] [varchar](250) NULL,
[RegistDay] [datetime] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[temp]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[temp](
[IDX] [int] NOT NULL,
[CIDX] [int] NOT NULL,
[CServerTime] [bigint] NOT NULL,
[Server] [int] NOT NULL,
[ClanName] [varchar](20) NOT NULL,
[ServerName] [varchar](50) NOT NULL,
[CPoint] [int] NOT NULL,
[CRegistDay] [datetime] NOT NULL,
[ServerTime_Temp] [bigint] NULL,
[Point_Temp] [int] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[test]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[test](
[IDX] [int] NOT NULL,
[CIDX] [int] NOT NULL,
[CServerTime] [bigint] NOT NULL,
[Server] [int] NOT NULL,
[ClanName] [nvarchar](50) NOT NULL,
[ServerName] [varchar](50) NOT NULL,
[CPoint] [int] NOT NULL,
[CRegistDay] [datetime] NOT NULL,
[ServerTime_Temp] [bigint] NULL,
[Point_Temp] [int] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SOD2RecBySandurr]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SOD2RecBySandurr](
[SNo] [int] IDENTITY(1,1) NOT NULL,
[UserID] [varchar](50) NULL,
[CharName] [varchar](50) NULL,
[CharType] [int] NULL,
[Point] [int] NULL,
[KillCount] [int] NULL,
[GLevel] [int] NULL,
[TotalPoint] [int] NULL,
[TotalUser] [int] NULL,
[SuccessUser] [int] NULL,
[ServerName] [varchar](50) NULL,
[PCRNo] [int] NULL,
[GPCode] [varchar](50) NULL,
[BusinessName] [varchar](100) NULL,
[BAddress1] [varchar](100) NULL,
[PMNo] [int] NULL,
[Contribute] [int] NULL,
[RegistDay] [datetime] NULL,
[ServerTime] [bigint] NULL,
[Flag] [int] NULL,
[ClanIDX] [int] NULL,
[ClanName] [varchar](50) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SoD2BBSMain]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SoD2BBSMain](
[IDX] [int] NOT NULL,
[Userid] [varchar](25) NOT NULL,
[WriteName] [varchar](100) NOT NULL,
[Title] [varchar](600) NULL,
[Job] [int] NULL,
[Content] [text] NOT NULL,
[SelServer] [int] NOT NULL,
[RegiDate] [datetime] NOT NULL,
[RegiIP] [char](15) NOT NULL,
[Hit] [int] NOT NULL,
[CountCom] [int] NOT NULL,
[OwnerID] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SoD2BBSSub]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SoD2BBSSub](
[SIDX] [int] NOT NULL,
[MINDEX] [int] NOT NULL,
[Userid] [varchar](25) NOT NULL,
[WriteName] [varchar](100) NOT NULL,
[Content] [text] NOT NULL,
[RegiDate] [datetime] NOT NULL,
[RegiIP] [char](15) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SoD2Notice]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SoD2Notice](
[IDX] [int] NOT NULL,
[MIDX] [int] NOT NULL,
[SelServer] [int] NOT NULL,
[UserID] [varchar](50) NOT NULL,
[Notice] [text] NOT NULL,
[RegiDate] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END

And yes, you will notice wihtt eh program up teh top right. 'Min amount of players needed to survive to save score, its at 2. So yes, you need minimum of 2 players (in the same clan) to save the sod score.

 

[rdcodester]

thnx guyz,

i got old sql for SodDb and i find out that mine was SODDb.. does it affect?. also SodDb database, shall i delete it and make new one the same script i have for Sod2Db? im using sandurr clan system . also my SoD2DB is name like these. is it also correct ?..

 

[SunnyZ]

Well, you can have the database named what ever you want, whats important are the scripts inside it, the database can be named ChickenCheeseDB, you just have to enter ChickenCheeseDB in the sod manager settings under DB. And also make sure the sod database connection inside sql.dll from Gregoo is named correctly, but the sod database name inside gregoos sql.dll file is SodDB, so thats why I named my sod database SodDB, not Sod2DB.

 

[rdcodester]

still doesnt working.. i dont use sql.dll .. doesnt work with mpt. dont know why. can sod scoring work without sql.dll ?

 

[SunnyZ]

no, you NEED sql.dll like I said before.
It does work with mpt, thast what I use, you just need to fix a few minor things.

1: account_db in sql.dll needs to be changed to accountdb
2: Your account registration script needs to be edited so that DisuseDay is a date far in the past, lets say the year 2020.

Just for your information DisuseDay is a column that tell you the date the account is to stop letting you login.
I guess this was used for when PT was pay to play.

 

[rdcodester]

i just cant find a way on how to make sql.dll work with mpt.. i tried it once and it works back when i restart and make the clan work. sql.dll doesnt work anymore dont know the reasons .

 

[SunnyZ]

Well, if you cant read what I just wrote, then that's your issue.

I told you exactly what to do to get gregoos sql.dll generator to work with MPT server files.

 

[rdcodester]

thnx very much sunnyz !. go it working now.

heres what ive got.

1.get dll generator from gregoo. sql.dll/clan.dll/clan-proc.dll (input all necesarry fields)
2.paste it in server root.
3.change account_db to accountdb. in sql.dll (hex)
4.run clansodmanager. change database name to SodDb as what it looks like in sql.dll

although some minor issues regarding connection lost to server. i find out in accountdb that by changing GPCode from 0 into Null.. the account will login using sql.dll but if you didnt change it it will prompt connection lost to server.. works for me.


done.

 

[bobsobol]

Yup. The difference between Null and 0 or 0.0 for several fields is necessary when you change from ODBC to the DLLs. (which I think access via MDAC, or DAO... different API anyway)

 

[Owall]

Sorry guys. Could you show me where I can do this step in details. Thank you!
2: Your account registration script needs to be edited so that DisuseDay is a date far in the past, lets say the year 2020.

Just for your information DisuseDay is a column that tell you the date the account is to stop letting you login.
I guess this was used for when PT was pay to play.

 

[SunnyZ]

It's located in your website, the Pristontale account registration script.
I dunno what website files you are using to register accounts, so I have no idea what files you need to edit.

 

[rdcodester]

1.get dll generator from gregoo. sql.dll/clan.dll/clan-proc.dll (input all necesarry fields)
2.paste it in server root.
3.change account_db to accountdb. in sql.dll (hex)
4.run clansodmanager. change database name to SodDb as what it looks like in sql.dll

the query that sunnyz posted i used also.. in order for SodDb to record the sod scores..

i think you just make sure the Sod Scores are saved in order for ClanSodManager to read.. and for that to work you need sql.dll and correct database/table fields for SodDb.. i use the above query Sunnyz Posted. (works like a charm)

 

[SunnyZ]

1.get dll generator from gregoo. sql.dll/clan.dll/clan-proc.dll (input all necesarry fields)
2.paste it in server root.
3.change account_db to accountdb. in sql.dll (hex)
4.run clansodmanager. change database name to SodDb as what it looks like in sql.dll

the query that sunnyz posted i used also.. in order for SodDb to record the sod scores..

i think you just make sure the Sod Scores are saved in order for ClanSodManager to read.. and for that to work you need sql.dll and correct database/table fields for SodDb.. i use the above query Sunnyz Posted. (works like a charm)

I literally have no idea what you are saying...

 

[Antiox]

1.get dll generator from gregoo. sql.dll/clan.dll/clan-proc.dll (input all necesarry fields)
2.paste it in server root.
3.change account_db to accountdb. in sql.dll (hex)
4.run clansodmanager. change database name to SodDb as what it looks like in sql.dll

the query that sunnyz posted i used also.. in order for SodDb to record the sod scores..

i think you just make sure the Sod Scores are saved in order for ClanSodManager to read.. and for that to work you need sql.dll and correct database/table fields for SodDb.. i use the above query Sunnyz Posted. (works like a charm)

Yeah True! Spelling & Capital Letter's Matter or it wont load and gives you a lot of error.

 

[rdcodester]

I literally have no idea what you are saying...

Owall said he cant get his sod scores.. i just posted what i do in order for me to work sod..

 

[Owall]

I am using this Virtual Machine of Sunny http://forum.ragezone.com/f399/fully-working-server-virtual-box-922253/. I have not modified any files yet. Could you guys tell me where i should start. I have been doing it many times without success. I have a problem with SQL.dll if I paste it into server folder I cannot log on the game. If you can please attach those files here. Thank you very much!

I got all the files .dll from gregoo website. Whenever I paste the SQL.dll into server folder file then I could not connect to the game unless delete SQL.dll file. Could you guys help me out?

 

[bobsobol]

I suspect it's your registration script and / or the fields it's entering in the SQL. *If* they work without SQL.dll, then they *will not* work with it, and vies versa.

 

[Owall]

Hi guys. I still have the same problem even I have changed the account_db to accountdb in SQL.dll. I can log in know without connection lost so it meant I dont need to change anything in my registration script right? This is my photo taken in game

@ SunnyZ : I am using your Virtual Machine all the files are default like What you have done bro. Could you tell me which files need editing for DisuseDay and where I can change GPcode to Null. Thank you very much bro!

Finally I have it done. If someone has issues with SQL file like "Unable to connect to the server" and Registration script like "Connection lost to Server" please refer to this thread http://forum.ragezone.com/f286/lost-connection-server-945717/. Thank you rdcodester, Sunnyz and bobsobol very much for your help!

Here are some photos just about it: