Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Troubleshooting mir 2.3 guild list and inventory issue

Newbie Spellweaver
Joined
Feb 21, 2006
Messages
31
Reaction score
1
Hey guys I decided to set up a mir 2.3 server yesterday I got it connected fine ect I can log in and all the rest thanks to the files and guides that were posted but I have 2 little issues..

1. My guild list wont load properley ive checked the database and it seems I am missing something TBL_GuildMemberList and TBL_GuildItems' any guide help would be appreciated heres what my m2server says:

Code:
[23/07/2008 19:11:57] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_GuildMemberList'
[23/07/2008 19:11:57] [LOADGUILDMEMBERS] loading memberlist failed for guild: GameMasters
[23/07/2008 19:11:57] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_GuildItems'
[23/07/2008 19:11:57] [LoadGuildStorage] Guild: GameMasters
[23/07/2008 19:11:57] Guilds: 1
[23/07/2008 19:11:57] Total Castles: 1
[23/07/2008 19:12:14] Gate[0](127.0.0.1:1057) Opened...
[23/07/2008 19:12:17] DBServer Connected(127.0.0.1:6000)
[23/07/2008 19:12:27] LoginServer Connected(127.0.0.1:5600)
[23/07/2008 19:21:37] Users: 0

2: Ok my 2nd problem is everytime i log into my account i strangly end up with 917504 cannibal leafs appearing in my inventory every time i get rid of them they come back after every relog any advice?

Thanks hope you get back to me soon.
/Riseofpower1

**EDIT: Also i used the files from the TD's Files in one from elvin : http://forum.ragezone.com/showthread.php?t=325257 **
 
Last edited:
Newbie Spellweaver
Joined
Jun 3, 2008
Messages
50
Reaction score
0
Re: 2 little problems

Your SQL tables need updated. Need to add those two missing tables in.
If using the files from thread you have linked to, dunno why they aren't updatedm thought they were.

As for items, go into tbl_Useritems and just delete everything. Sounds like a DB problem to me. Are you sure you are using the latest updated files? (When you get server running, cntrl/alt/delete and set DBServer in task manager to "RealTime"
 
Newbie Spellweaver
Joined
Feb 21, 2006
Messages
31
Reaction score
1
Re: 2 little problems

Your SQL tables need updated. Need to add those two missing tables in.
If using the files from thread you have linked to, dunno why they aren't updatedm thought they were.

As for items, go into tbl_Useritems and just delete everything. Sounds like a DB problem to me. Are you sure you are using the latest updated files? (When you get server running, cntrl/alt/delete and set DBServer in task manager to "RealTime"

First of all id like to thank you for replying, i deleted the the user items and it finally stoped thank you.

and i hate to be a pain but do you no Fields are needed in them 2 missing tables and im sure im using the latested updated ones, thank you in advance

/Riseofpower1
 
Newbie Spellweaver
Joined
Jun 3, 2008
Messages
50
Reaction score
0
Re: 2 little problems

First of all id like to thank you for replying, i deleted the the user items and it finally stoped thank you.

and i hate to be a pain but do you no Fields are needed in them 2 missing tables and im sure im using the latested updated ones, thank you in advance

/Riseofpower1


- 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:
Newbie Spellweaver
Joined
Feb 21, 2006
Messages
31
Reaction score
1
Re: 2 little problems

I added the 2 databases and everything works fine now, thank you very much JamieWeikl for your help.

/Riseofpower1
 
Back
Top