Guilds not saving... +spec repair npc

[Bon]

m2server says this


[31/01/2008 17:36:43] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_GuildMemberList'
[31/01/2008 17:36:43] [LOADGUILDMEMBERS] loading memberlist failed for guild: OldSkool
[31/01/2008 17:36:43] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_GuildItems'
[31/01/2008 17:36:43] [LoadGuildStorage] Guild: OldSkool
[31/01/2008 17:36:43] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_GuildMemberList'
[31/01/2008 17:36:43] [LOADGUILDMEMBERS] loading memberlist failed for guild: The_Mafia
[31/01/2008 17:36:43] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_GuildItems'
[31/01/2008 17:36:43] [LoadGuildStorage] Guild: The_Mafia
[31/01/2008 17:36:43] Guilds: 2


i can make a guild, then when i reboot... guilds are gone ¬_¬


any ideas?


also save me makin a new thread, heres my specail repair npc... wot have i done wrong?
when i try repair items it jsut says "?????"


[@main]
Hello <$USERNAME>..Feel free to use my services! \ \
<Special repair/@s_repair> Anything\
<Exchange/@exchange> Things\
<Exit/@exit>>\

[@s_repair]
Would you like to repair your items ?\ \
<Back/@main>
[~@s_repair]
Your item seems to be repaired fine.\ \
<Back/@main>


ta

 

[™blade™]

m2server says this


[31/01/2008 17:36:43] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_GuildMemberList'
[31/01/2008 17:36:43] [LOADGUILDMEMBERS] loading memberlist failed for guild: OldSkool
[31/01/2008 17:36:43] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name


[31/01/2008 17:36:43] [LoadGuildStorage] Guild: OldSkool
[31/01/2008 17:36:43] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_GuildMemberList'
[31/01/2008 17:36:43] [LOADGUILDMEMBERS] loading memberlist failed for guild: The_Mafia
[31/01/2008 17:36:43] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_GuildItems'
[31/01/2008 17:36:43] [LoadGuildStorage] Guild: The_Mafia
[31/01/2008 17:36:43] Guilds: 2


i can make a guild, then when i reboot... guilds are gone ¬_¬


any ideas?


also save me makin a new thread, heres my specail repair npc... wot have i done wrong?
when i try repair items it jsut says "?????"


[@main]
Hello <$USERNAME>..Feel free to use my services! \ \
<Special repair/@s_repair> Anything\
<Exchange/@exchange> Things\
<Exit/@exit>>\

[@s_repair]
Would you like to repair your items ?\ \
<Back/@main>
[~@s_repair]
Your item seems to be repaired fine.\ \
<Back/@main>


ta

look to me like u need to make the 'TBL_GuildItems'

for for ur specail repair


and ur npc should look some thing like

;Settings
(@repair @s_repair)
%100
+5
+6
+43
+ then the stmode number of the item u wont to repair specail repair

[@main]
Hello <$USERNAME>..Feel free to use my services! \ \
<Special repair/@s_repair> Anything\
<Exchange/@exchange> Things\
<Exit/@exit>>\

[@s_repair]
Would you like to repair your items ?\ \
<Back/@main>
[~@s_repair]
Your item seems to be repaired fine.\ \
<Back/@main>

 

[NewHope]

You missed what items it repairs.

;Settings
(@s_repair)
%100
+10
+11
+15
+19
+20
+21
+22
+23
+24
+26
+29
+52
+53
+54
+62
+64

[@main]
I can special repair your items.\ \
<Special repair/@s_repair> my items.\
<Maybe another time./@exit>\

[@s_repair]
\
What do you want to special repair?\ \
<Back to main.../@main>\

[~@s_repair]
\
There you go, your items are fully repaired.\ \
<Back to main.../@main>\

This script should work.

 

[Adamsy]

For your guild rpoblem don't forget to add these tables to sql. These sort of updates are explained in TD's update.doc that comes with the server files.

[FONT=&quot]- Tbl_GuildList (contains only one field: Fld_GuildName, data type: varchar, length: 20, allow nulls:false)[/FONT]
  [FONT=&quot]- Tbl_GuildItems(contains the same fields as tbl_useritems except instead of Fld_Charname it's Fld_Guildname here)[/FONT]
  [FONT=&quot]- Tbl_GuildMemberList, contains:[/FONT]
  [FONT=&quot]     Fld_GuildName: varchar, length 20, allow null : false[/FONT]
  [FONT=&quot]     Fld_GuildRank:   int                  , length 4 , allow null: false[/FONT]
  [FONT=&quot]     Fld_CharName: varchar , length20,  allow null: false[/FONT]
  [FONT=&quot]     Fld_Level        :  int         , length 4  , allow null: false[/FONT]
  [FONT=&quot]     Fld_RankName: varchar, length 50, allow null: false[/FONT]

[FONT=&quot][/FONT]

 

[Bon]

look to me like u need to make the 'TBL_GuildItems'

'TBL_GuildMemberList'
aswell?

how would i do that?

do u have these 2 things in ur sql database? could u possibly copy paste the headers in each table?

no clue wot im meant to do :/


- specail repair fixed, thx