Db Sql Format

morbid · Post by **morbid** » Mon Jun 06, 2005 10:12 pm

Had3s wrote:
morbid wrote: Majestic Upgrade dont works x/
why dont u read all the topic and then u ask your questions if you have...

all the thinks u ask were answerd previously. :S

i saw.... but error continues...

Had3s · Post by **Had3s** » Tue Jun 07, 2005 6:11 pm

morbid wrote:
Had3s wrote:
morbid wrote: Majestic Upgrade dont works x/
why dont u read all the topic and then u ask your questions if you have...

all the thinks u ask were answerd previously. :S
i saw.... but error continues...

:S
i think u read it between lines.. :S

dksets needs the identification numer of the player. ( iID1, iID2, iID3)

create the items with a gm,log out and then go to your db and change che id numer of the item for yours...

AzraeL · Post by **AzraeL** » Wed Jun 08, 2005 1:35 am

CDWriter · Post by **CDWriter** » Wed Jun 08, 2005 8:18 am

Further Break down on the main log Account_T

CREATE TABLE [dbo].[ACCOUNT_T] (
[cAccountID] [nchar] (10) COLLATE Latin1_General_CI_AS NOT NULL ,
[cPasswd] [nchar] (10) COLLATE Latin1_General_CI_AS NULL ,
[iAccountID] [int] IDENTITY (1, 1) NOT NULL ,
[cLoginIpAddress] [nchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[IsGMAccount] [bit] NULL ,
[CreateDate] [smalldatetime] NULL ,
[LoginDate] [smalldatetime] NULL ,
[LogoutDate] [smalldatetime] NULL ,
[BlockDate] [smalldatetime] NULL ,
[cRealName] [nchar] (30) COLLATE Latin1_General_CI_AS NULL ,
[cSSN] [nchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[cEmail] [nchar] (60) COLLATE Latin1_General_CI_AS NULL ,
[cCharRecord] [nchar] (100) COLLATE Latin1_General_CI_AS NULL ,
[cQuiz] [nchar] (45) COLLATE Latin1_General_CI_AS NULL ,
[cAnswer] [nchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[ValidDate] [smalldatetime] NULL ,
[iValidTime] [int] NULL ,
[MaxUser] [int] NULL ,
[iShopID] [int] NULL
) ON [PRIMARY]

the last 2 lines MaxUser and iShopID must be there if u NULL out ValidTime or set it to Zero ......Try it your self create the char but leave your next column 0 or Null After iValidTime, the client will come back and tell u that there is too many on the Server Now ......So all Asp and php scripts to make a account Must have 800 or something for that line before account is crerated....

I changed mine to make them all 800 and the reason i found this is becuase iam trying to break down the line cKEYCODE to u can change pass word from client..........any other info or comments are welcome ....

CDWriter

Sparda · Post by **Sparda** » Wed Jun 08, 2005 12:16 pm

Hey peeps, there's gonna be a delay in the asp scripts i'm gonna create because i'm having some major problems with my computer with 1 hard drive failure, oh and come to think of it i've lost them all lol, was gonna upload them now....wellnef has got my latest scripts.

Nef when u see this message can u mail me my scripts please so i can get working on them again. Thx

nef · Post by **nef** » Wed Jun 08, 2005 1:18 pm

sure, sending now, but i still wanna know ur name haohaoh
btw sparda, i found kinda bug on ur scripts, u can take a lot of dk sets, i dont have any idea about how to fix it =P
CD, i will work with the sql this weekend, couse sunday i have chemestry test, so i have to study a little =P
send me all the information that u already have, and i will see what i can do with it =P
cyas

molo · Post by **molo** » Wed Jun 08, 2005 1:59 pm

nef wrote:
molo wrote:
Stik wrote: Here's mainlog.sql with the extra bits(shopid keycode)added to it
thx bro.. but one more problem. i need mainlog.mdf... and some ather too.
in mainlog.sql it says this Filename

FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\mainlogin.mdf'

and i dont have mainlog.mdf and ather files like (ws1.mdf, wa1.inx.mdf) i need those too were can i get it ? if u have it can u send it here please..
dude u dont need those files, those files will be created, just put there the address of ur mssql folder, mine 4 exemple is N'C:\Arquivos de programas\MSSQL\data\mainlogin.mdf'
i dun know urs, but u need to write it til C:\****\MSSQL\data\, the next part will be created by the sql server

ahhhh thx bro
thx for every thing

ya one more thing can i ask your msn ID so if i need help i can ask you.
u mite want to controll my pc and see your self My SQL. it acting stupid.
sometime it open sometime it give me error

so if u controll my pc and check it out it will be very help full. and thx again

nef · Post by **nef** » Wed Jun 08, 2005 7:30 pm

if u want remote assistence send pm, i dont think that ppl usually give msn here, only in some exeptions

Stik · Post by **Stik** » Thu Jun 09, 2005 4:28 pm

Anyone got the proper npc.cfg that goes with china server,mine is a lil messed up(useing old 2.19) my type numbers dont match up with what apears on map.

locobans · Post by **locobans** » Fri Jun 10, 2005 5:58 am

Anyone in here has RageIluminati 's msn?

Please pm me it...i need to talk to him

~Thx

nef · Post by **nef** » Fri Jun 10, 2005 8:35 am

ok, just find another bug, if u finish all apoc maps, u will not have an abbadon but a fire wyvern, anyone knows why and how to fix it?

Had3s · Post by **Had3s** » Fri Jun 10, 2005 5:29 pm

nef wrote: ok, just find another bug, if u finish all apoc maps, u will not have an abbadon but a fire wyvern, anyone knows why and how to fix it?

that was a bug in the international server xD

try changing the number of the abbadon for the firewyvern...
also change the number in the mapdata

Stik · Post by **Stik** » Fri Jun 10, 2005 5:40 pm

All the npc type numbers for the appoc monsters seem to be a lil messed up

nef · Post by **nef** » Fri Jun 10, 2005 6:43 pm

i did that and 4 result i got 10 abaddons on each infernia ¬¬

Had3s · Post by **Had3s** » Fri Jun 10, 2005 7:26 pm

nef wrote: i did that and 4 result i got 10 abaddons on each infernia ¬¬

what i think that u should get xD

well.. just look some where the abbadon npc number and change it.. until u get the correct

do u changes the mapdata in inferna from that number to the new fyrewyberns number :S???