Any clean 1.36 db for sql 2012

[Riizq 7]

Any1?

 

@Sk3let0n?

@V3ct0r?

@J0k3r?

 

Or any1 on this forum who reads this thread.

I need help. I am unable to attach quite a few databases in sql 2012. Gives an error.

[Simon 76]

19 minutes ago, Riizq said:

Any1?

 

@Sk3let0n?

@V3ct0r?

@J0k3r?

 

Or any1 on this forum who reads this thread.

I need help. I am unable to attach quite a few databases in sql 2012. Gives an error.

Check Perseus topic about topCMS,I shared queries for databases on the replies.

[Riizq 7]

8 minutes ago, Sk3let0n said:

Check Perseus topic about topCMS,I shared queries for databases on the replies.

@Sk3let0n

 

how do I use the .sql file? I double click and open it and then do what?

 

Sorry I am not very experienced at this.

[Simon 76]

create a database manually in Management Studio,then run SQL File and press f5

[Riizq 7]

14 minutes ago, Sk3let0n said:

create a database manually in Management Studio,then run SQL File and press f5

Thankfully it works.

 

But I am unable to create accounts with account creator v2.

It says email column not valid..

-.-

 

1 problem gets fixed... another arises... 
 

Please help. I used the account creator that is provided here in pko dev. After search.

 

Oh and btw these 1.36 DB right? @Sk3let0n

 

and thank you so much for the help. You really are trying to make a better pko community.

Edited June 14, 2017 by Riizq

[Simon 76]

5 minutes ago, Riizq said:

Thankfully it works.

 

But I am unable to create accounts with account creator v2.

It says email column not valid..

-.-

 

1 problem gets fixed... another arises... 
 

Please help. I used the account creator that is provided here in pko dev. After search.

 

Oh and btw these 1.36 DB right? @Sk3let0n

 

and thank you so much for the help. You really are trying to make a better pko community.

They work with any version,there are no special versions of databases for the game.

[Riizq 7]

Just now, Sk3let0n said:

They work with any version,there are no special versions of databases for the game.

Wait so I will not have any info mismatch with iteminfo? or other server infos?

[Simon 76]

1 minute ago, Riizq said:

Wait so I will not have any info mismatch with iteminfo? or other server infos?

Nope,they have no relation at all with databases.

[Riizq 7]

LMAO WAHT THE FU....................

 

 

[Riizq 7]

3 minutes ago, Sk3let0n said:

Nope,they have no relation at all with databases.

But I am here with another problem

 

USE AccountServer; 
INSERT INTO account_login (name, password) VALUES ('PKODev', 'E10ADC3949BA59ABBE56E057F20F883E')

 

I use this ( I change the password and login name ofcourse )

But I get this stupid error now... 

 

Msg 515, Level 16, State 2, Line 2
Cannot insert the value NULL into column 'id', table 'AccountServer.dbo.account_login'; column does not allow nulls. INSERT fails.
The statement has been terminated.

 

[Simon 76]

Dunno but just add EMAIL Column and should work

[Riizq 7]

2 minutes ago, Sk3let0n said:

Dunno but just add EMAIL Column and should work

Can I use pko 1.38 DB instead? as that DB attached just fine, without any errors.

I am using 1.36 server files. Thats why I thought using 1.38 db would create problems...

 

 

[Simon 76]

17 minutes ago, Riizq said:

Can I use pko 1.38 DB instead? as that DB attached just fine, without any errors.

I am using 1.36 server files. Thats why I thought using 1.38 db would create problems...

 

 

Yeah you can.

[V3ct0r 2,117]

15 часов назад, Riizq сказал:

But I am here with another problem

 

USE AccountServer; 
INSERT INTO account_login (name, password) VALUES ('PKODev', 'E10ADC3949BA59ABBE56E057F20F883E')

 

I use this ( I change the password and login name ofcourse )

But I get this stupid error now... 

 

Msg 515, Level 16, State 2, Line 2
Cannot insert the value NULL into column 'id', table 'AccountServer.dbo.account_login'; column does not allow nulls. INSERT fails.
The statement has been terminated.

 

You should also specify 'id' fileld in SQL query:

 

INSERT INTO AccountServer.dbo.account_login (id, name, password) VALUES (25, 'PKODev', 'md5 password')