guilds

[K_Jonzy]

yesterday night i made a guild on my gm and i logged on my serv this morning with a few problems in my m2server
my guild has been stripped of my character and here is the screenie


any ideas plz???

 

[TravisW]

yeah you need to add some tables to sql, since you aren't using the updated files available.
-from TD's updates.doc

added a few new tables to the char database
- Tbl_GuildList (contains only one field: Fld_GuildName, data type: varchar, length: 20, allow nulls:false)
- 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

 

[K_Jonzy]

kk i did that and ran m2server

it say invalid column name "Fld_GuildName"

 

[mStation]

tell us what u did exaclty.. seems u have splet something wrong in the sql db

 

[K_Jonzy]

i opened sql

rite cliked in the mir2 database
pressed newtable

called it TBL_GUILDITEMS/TBL_GUILDMEMBERLIST/TBL_GUILDLIST

put the coloums in and the rest in and that it

 

[mStation]

hmm..

i think u did something wrong.. u must create 3 tables which are called

- Tbl_GuildList
- Tbl_GuildItems
- Tbl_GuildMemberList

The first tables contains only one field which is
Fld_GuildName, data type: varchar, length: 20, allow nulls:false

Second table contains the same fields as tbl_useritems except instead of Fld_Charname it's Fld_Guildname

The third table 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

is this what u did ?

 

[Gough]

I have the same problem... i think it is the database... i got my files from noob server guide or something like that.... and i had to get a table to put into the database in sql becouse there was no monsters around.

I did the same thing created a guide on my admin for server and i tryed to take over the sabuk castle and it wouldnt let me... next time i opened up server i got the very same error.

hope you guys can help with this cos i want to have all my files working correctly and i want the sabuk wall war working.

thanks