SQL Error :S

[exique]

I've tried to add marriage to my ot (The npc)
http://otland.net/f83/ultra-release-exclusive-marriage-system-22540/
And when I try to add

         ALTER  TABLE  `players`  ADD  `marrystatus` INT  UNSIGNED NOT  NULL DEFAULT  '0' AFTER  `marriage`

I get this:

[B]SQL-fråga:[/B]     
              ALTER  TABLE  `players`  ADD  `marrystatus` INT  UNSIGNED NOT  NULL DEFAULT  '0' AFTER  `marriage`      
      [B]MySQL sa: [/B][URL="http://dev.mysql.com/doc/refman/4.1/en/error-messages-server.html"][IMG]http://localhost/phpmyadmin/themes/original/img/b_help.png[/IMG][/URL] 
  #1054 - Unknown column 'marriage' in 'players'

How to fix it?
HELP!

 

[Delirium]

Marriage column doesn't exist...the error is obvious.

 

[Xampy]

Hello!

Maybe are you using 0.2? I think that that script is for 0.3.x But...

Execute these:

ALTER TABLE `players` ADD `marriage` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `online` ;
ALTER TABLE `players` ADD `marrystatus` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `marriage` ;

Regards.

 

[exique]

Thanks ;D
Reputation!

Now the npc doesn't say anything when you after you've said marry

HELP!

 

[exique]

(I am using tfs 0.2.3 btw) BUMP

 

[Xampy]

It appears any error in console or something?

 

[exique]

Ehm.. not a error :S

 

[Xampy]

Hello.

In 0.2 the functions must be added in global.lua instead of functions.lua, did you do that?

Oh, you must use this too -> http://otland.net/f163/forgotten-server-0-3-db-class-0-2-a-26225/

 

[exique]

Nah.. still doesn't work :S

Cykokotitan says that It wont work for tfs 0.2.3 (The npc)

:S

 

[husam]

Jes! Cykotitan is n00b :S is nooblet ;Ss

 

[Belthazor]

Jes! Cykotitan is n00b :S is nooblet ;Ss

Respect for Cykotitan hes rox ^^

and about the thread use the functions that xampy said maby u can adjust it.

 

[exique]

;O
but how do I make the npc so it works for 0.2.3 then? :S

 

[exique]

Respect for Cykotitan hes rox ^^

and about the thread use the functions that xampy said maby u can adjust it.

Couldn't (BUMP)

 

[Xampy]

Hmmm, idk I think it must work with what I told you

 

[exique]

Nopp ;(
:'(