soz for making too many thread but i just found out..

Play Now

pSygOrE

Dedicated Member
Dedicated Member
May 22, 2008
31
0
32
[9/8/2008 4:31:12 AM] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Tbl_GuildMemberList'
[9/8/2008 4:31:12 AM] [SAVEGUILDMEMBERLIST] deleting old list failed

M2server. ty in advance
 

pSygOrE

Dedicated Member
Dedicated Member
May 22, 2008
31
0
32
Load and i @addguild twice and no theres no guild .. do i have to make new table in DB e.g "TBL_Guildlist" ? which is empty table or .. ?
 
Upvote 0

Killmaster

Legend
Legendary
Golden Oldie
Loyal Member
Nov 13, 2003
3,967
27
274
Fld_GuildName varchar 20
Fld_GuildLogo varchar 20
Fld_GuildPoints int 4

Make a table called TBL_Guildlist, enter the fields with the info above.
Empty table is ok.
 
Upvote 0

mStation

Golden Oldie
Golden Oldie
Oct 29, 2003
2,042
69
235
♫♪♫ ♦♥♠♣ ♀♂♀
its all explained in the update.doc in the server files.. here is the part.. i think in your mir2 db there are a few missing tables..

check if u have them if not create them..

- Tbl_GuildList contains:
Fld_GuildName varchar 20
Fld_GuildLogo varchar 20
Fld_GuildPoints int 4

- 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
 
Last edited:
Upvote 0

pSygOrE

Dedicated Member
Dedicated Member
May 22, 2008
31
0
32
im doing this server alone .. neone wanna be in team for doing this server?
post it here or add me on msn [email protected].. thank you and sorry if i posted it wrong..
 
Upvote 0