Help database! Rep

[sandstorm]

After this Table "TYPE" in "ACCOUNTS" is dissapear! I can't add gamemaster or something please Help me REP

 

[Korrex]

You could try using a more stable distro such as 0.2.
Maybe you did something wrong whilst uploading tables to your database.
TBH: this is the first time i've ever seen this error.

 

[sandstorm]

I have this database from Mystic spirit 0.2.5
I have now crying damson 0.3.6pl1;sss
Can you give me any database?xD

 

[Korrex]

I have this database from Mystic spirit 0.2.5
I have now crying damson 0.3.6pl1;sss
Can you give me any database?xD

Are you trolling? xD
You can't use the 0.2.5 DB with 0.3.6pl1.
Just redownload 0.3.6 from the distributions and use the mysql schema found in TFS/schemas.

 

[sandstorm]

Ok man i love you 2 rep for youxd

 

[Korrex]

But if i download 0.3.6pl1 there is only database sqlite...

@rep 4 you
xDD

Actually no. Check in the schemas folder, there you'll hopefully find schema.mysql or smth.

EDIT: http://otland.net/subversion.php?sv...tags/0.3.6pl1/schemas/mysql.sql&rev=95&peg=95
Use it.

 

[sandstorm]

After this i still don't have "TYPE" I use TFS 0.3.6pl1 Help !

 

[Korrex]

Does Crying Damson even use TYPE?

If so then:

ALTER TABLE `accounts` ADD `type` INT NOT NULL;

Also if you want to make a GM char just edit Group ID to 4, 5 or 6.

 

[sandstorm]

So how i can do for example god, gamemaster?D:

 

[Korrex]

So how i can do for example god, gamemaster?D:

In table players edit the player you want to be GMs groupid to 4 for GM, 5 for CM or 6 for God.

 

[sandstorm]

Thanks man with your help i can start do Ots! REP!

 

[Korrex]

Glad to help.