• db update: in tbl_charinfo add the following field:
Fld_Killpoints (bigint, length 8, default value 0, allow null : false)
• forgot to mention last update log: you need to add a new table to the ms sql 'char' db info:
name: TBL_GuildWarLog
fields:
Fld_GuildName1, varchar, length 20, allow null = false
Fld_GuildName2 (same as above)
Fld_Time, int, length 4, allow null = false, default value = 0
Fld_Duration (same as above
• reworked the dbserver; info below(afraid it can only run mssql now not mysql)
deleted following data from tbl_charinfo:(all pointless really)
Fld_AC,Fld_mac,Fld_DC,Fld_MC,Fld_SC,Fld_MaxHP,Fld_MaxMP,Fld_MaxExp, Fld_Weight,Fld_MaxWeight,
Fld_WearWeight,Fld_MaxWearWeight,Fld_HandWeight, Fld_MaxHandWeight
changes to tbl_CharList:(allow null is always false :p)
Fld_Index(int, length4, increment = yes, identity increment = 1)
Fld_Account(varchar,16)
Fld_CharName(varchar,20)
Fld_CreateDate(bigint,8,default 0)
Fld_Modifydate(bigint,8, default 0)
Fld_SelectID(int,4,default 0)
Fld_Deleted(bit,1,default 0)
Fld_Selected(bit, 1, default value 0)
• 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)
• 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