Database

[Gough]

would it be easier to just restore a fresh up to date database or is it easy enough to fix? I did see a post with the same problem but cant find it again

<IM A NOOB BEFORE SOMEONE STARTS>

 

[azzi]

go into ure EnterPrise manager, Find the tables Guild memberlist and GuildItems. And remove everything inside them

 

[Gough]

i would do that is i had them tables lol this is all i got... i thought there must be things missing thats why i was asking if it would be better to get a copy of another database and just copy my accounts

 

[azzi]

restore another database then :P u have a little bit missing ^_^

 

[Gough]

how much is missing? alot?

 

[boothy]

You need to add 2 new tables to your database:

- Tbl_GuildItems(contains the same fields as tbl_useritems except instead of Fld_Charname it's Fld_Guildname here)​

​

- Tbl_GuildMemberList, contains:​

Fld_GuildName: varchar, length 20, allow null : false​

Fld_GuildRank: int , length 4 , allow null: false​

Fld_CharName: varchar , length20, allow null: false​

Fld_Level : int , length 4 , allow null: false​

Fld_RankName: varchar, length 50, allow null: false​

 

[Snowman]

read the damn updates.doc, its all explained in there although most of the things are done just the sql tables need adding

 

[TravisW]

ye, download jasper and elvins UPDATED files. =p
http://www.lomcn.co.uk/forum/showthread.php?t=53383

 

[jasper]

if somebody wants to take the sql2000 db in those files, update it with the 2 missing tables, and send it me, i will swap it over with the one in the download and it then should stop the repeated questions, i cant do it, only have 2005 now.

 

[TravisW]

ok I'll do, I thought you guys had done that on them already. =p

EDIT: done it
heres the updated DB file for sql2000 gough, if you need that one.
http://www.megaupload.com/?d=WNBWH3L3

 

[PoPcOrN]

m8s can u lot help me bye addin me on msn [email protected]
need to no how some 1 can send me Sql i tryed downloading it
but...... i get the auto run and the Sql things Not the Sql Manager tho dnno what to do ty

 

[Gough]

thanks for the database ill try it out tomorrow

 

[Gough]

HELP!!!

i just restored that database and now im getting connection closed when trying to connect to server. didnt think that would happen. what will i have to do to get it working again plz....

*cough* had a noob moment it is working... forgot to run the server lol

 

[jasper]

ok I'll do, I thought you guys had done that on them already. =p

EDIT: done it
heres the updated DB file for sql2000 gough, if you need that one.
http://www.megaupload.com/?d=WNBWH3L3

cheers travisw,, put this into the download, replaced the one with missing tables

 

[Gough]

after updating database i still cant take over sabuk wall.

can someone tell me what steps you have to take to take over the castle and i can check i have done them.

 

[Gough]

I have no monsters on my server now after i have updated the database. any help plz

 

[mStation]

mate.. i think that the spawns problem has been fixed soo many times.. search for "no spawns" made by mirrealms

 

[Gough]

lol i have had this problem before and someone sent me a excel file to solve the problem and it worked... done it again and this time it didnt make a differance