How to disable guild stuff when server is loading? Mir2

[Hawky]

Here is what comes up when server is started:

Loaded client version information and server table...
Loading StdItem.DB...
StdItem.DB loaded(758).
Loading MapFiles...
Mapfile loaded(429).
DecoItem loaded..
Loading Guild Territorys...
Loading Monster.DB...
Monster.DB loaded(502).
Loading Magic.DB...
Magic.DB loaded(55).
Loading MonGen.txt...
MonGen.txt loaded(254).
Loading GenMsg.txt...
GenMsg.txt loaded(6).
Loading UnbindList.txt...
UnbindList information loaded.
Loading BindList.txt...
BindList information loaded.
Loading MapQuest.txt...
MapQuest information loaded.
Loading QuestDiary\*.txt...
QuestDiary information loaded.
!Abuse.txt loaded..
Loading LineNotice...
Line Notice loaded...
Admin List loaded..
Guild List loaded..
PumpkinLists loaded..
Castle List loaded..
Castle initialized..
IDSoc Initialized..
GrobalEnvir loaded..
MakeStoneMines...
Merchant loaded...
GuardList loaded..
Npc loaded..
MakeItem loaded..
StartPoints loaded...
F-Engine resumed..
U-Engine initialized..
[15/06/2007 11:44:12 PM] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_GuildPoints'
[15/06/2007 11:44:12 PM] [LoadGuildInfo] Failed
[15/06/2007 11:44:12 PM] Guilds: 0
[15/06/2007 11:44:12 PM] Total Castles: 1
[15/06/2007 11:44:22 PM] LoginServer Connected(127.0.0.1:5600)
[15/06/2007 11:44:24 PM] Gate[0](127.0.0.1:2208) Opened...
[15/06/2007 11:44:25 PM] DBServer Connected(127.0.0.1:6000)


Is there any way to disable the guild stuff at this stage? Figure I can always go back to it when server is up and running.

Thanks in advance

 

[shunt]

in updates.doc


you need to add Fld_GuildPoints to tbl_guildlist, data type: int, length: 4, allow nulls: false, default value 0

need to add a new field to tbl_guildlist: fieldname: Fld_GuildLogo , data type: varchar, length: 20, allow null = false, default value : '' (yes the 2 ' signs)
( i think he means by the 2 ' the apostrophe under the @)

to do this:
open up sql enterprise, expand the selections till u drop down to your database,
click "tables" so that all the tables are in the right hand pane
right click the Tbl_Guildlist
a select box will open up,, select "design table"
this will open up a new pane showing 4 columns
the first row will already contain info

Column Name-------Data Type-------Length-------Allow Nulls
fld_guildname-------varchar------------20-----------blank (no tick)

select the next row, and enter the data as instructed (data type opens up a dropdown box to select from)


Column Name-------Data Type-------Length-------Allow Nulls
fld_guildname-------- varchar----------20-----------blank (no tick)
fld_guildpoints---------int-------------4-------------blank (de-select tick) default data 0 enter at the left bottom of screen under the column tab
fld_guildlogos---------varchar-----------20----------blank (de-select tick) default data '' enter at the left bottom of screen under the column tab


both advanced guild functions and guild logos can be enabled or disabled in !setup by setting them to TRUE or FALSE

 

[Hawky]

Thanks for that Shunt, all done and everything seems to be fine except for the screen going blank when I log in.

I can create chars, select them but when I press "start" the screen goes blank, mouse still working, but no game world.

Noticed other people having the same problem, unfortunately when they get it fixed they never post what it was that fixed it!

The exe i'm using is 1,621kb and downloaded the 2.3 client. M2server.exe is 2,216kb

Any ideas?

 

[Fire_Nemesis]

check your rungate IP,

also make sure you have all the latest exe's in

 

[Hawky]

check your rungate IP,

also make sure you have all the latest exe's in

Hmm I can find a rungate.exe altho it is not one of the files that get started when I boot the server. I do run gamegate tho. I also can't seem to find an IP setting for rungate.

Should rungate be running when server is up?

 

[shunt]

yes,, you should be using Rungate.exe in stead of the gamegate in the same gamegate folder size 1410kb mod 16/04/07

 

[Fire_Nemesis]

you should be starting with the base files from the first archive on the deaths files, and then replace ALL the exe's with his updates set