Database

03/17/2010 18:31 Scotticus#1
Can someone please provide me with a Database with the DEKARON0001 etc

Thanks

Scott
03/17/2010 18:33 iAslana#2
[Only registered and activated users can see links. Click Here To Register...]

There you go, next time please browser trough the forums.
03/17/2010 18:37 Scotticus#3
Thanks

Close please
03/17/2010 18:42 iAslana#4
No problem, you know how to import them I hope?
03/17/2010 18:58 Scotticus#5
ugh.. do you still have me on MSN.. This database does not contain the damn DEKARON0001 chars
03/17/2010 19:13 freeskier4lif3#6
[Only registered and activated users can see links. Click Here To Register...] - they have all the db files you need on their file database
03/17/2010 19:15 Scotticus#7
Tried that.. Thanks anyways..
03/17/2010 23:33 -=ToMiK=-#8
There is many sites where you can get those databases.
Two of the best ones are already posted, you can definitely find something on there.
03/18/2010 00:39 da_unknown#9
Hmm, Scotticus you goes offline untill i was ready to give you this.
Here is the SQL Script to re-insert the System Characters. I hope it helps you if you did not make a backup or something.
Just copy this in a new Query with the Query Analyzer and Check Parse Query then Execute it.

[Only registered and activated users can see links. Click Here To Register...]

Greetings
dA-uNknOwN
03/18/2010 01:55 [GA]Lightning#10
Quote:
Originally Posted by da_unknown View Post
Hmm, Scotticus you goes offline untill i was ready to give you this.
Here is the SQL Script to re-insert the System Characters. I hope it helps you if you did not make a backup or something.
Just copy this in a new Query with the Query Analyzer and Check Parse Query then Execute it.

[Only registered and activated users can see links. Click Here To Register...]

Greetings
dA-uNknOwN
nice :-) and where is the aloken system character ? :P
03/18/2010 02:34 da_unknown#11
German: Jaaaa, Gute Frage :>
Den habe ich ja glatt unterschlagen ^^

I thought Scotticus Server havent the Aloken , but who has Aloken feel free to add the last line. :>


Greetings
dA-uNknOwN
03/18/2010 05:36 Scotticus#12
Does not work.. Returns this..

Quote:
Server: Msg 260, Level 16, State 1, Line 1
Disallowed implicit conversion from data type varchar to data type varbinary, table 'character.dbo.user_character', column 'user_ip_addr'. Use the CONVERT function to run this query.
Server: Msg 260, Level 16, State 1, Line 1
Disallowed implicit conversion from data type varchar to data type varbinary, table 'character.dbo.user_character', column 'user_ip_addr'. Use the CONVERT function to run this query.
Server: Msg 260, Level 16, State 1, Line 1
Disallowed implicit conversion from data type varchar to data type varbinary, table 'character.dbo.user_character', column 'user_ip_addr'. Use the CONVERT function to run this query.
Server: Msg 260, Level 16, State 1, Line 1
Disallowed implicit conversion from data type varchar to data type varbinary, table 'character.dbo.user_character', column 'user_ip_addr'. Use the CONVERT function to run this query.
Server: Msg 260, Level 16, State 1, Line 1
Disallowed implicit conversion from data type varchar to data type varbinary, table 'character.dbo.user_character', column 'user_ip_addr'. Use the CONVERT function to run this query.
Server: Msg 260, Level 16, State 1, Line 1
Disallowed implicit conversion from data type varchar to data type varbinary, table 'character.dbo.user_character', column 'user_ip_addr'. Use the CONVERT function to run this query.
03/18/2010 07:46 [GA]Lightning#13
Quote:
Originally Posted by da_unknown View Post
German: Jaaaa, Gute Frage :>
Den habe ich ja glatt unterschlagen ^^

I thought Scotticus Server havent the Aloken , but who has Aloken feel free to add the last line. :>


Greetings
dA-uNknOwN
GERMAN:
@da-unknown
tztztz ja gut das kann gut sein
haste die line zufällig und könntest mir die per pn schicken?
von mir aus auch gegen irgendwas ^^

@Scot
then make you any what wrong well i have test by me work^^

LG Deathmage
03/18/2010 11:53 da_unknown#14
Hi Scotticus,
Try to change the Column 'user_ip_addr' into varchar then it must work.
You start MSSQL Enterprisemanager mark the dbo.user_character and choose Design Table and change the datatype of 'user_ip_addr'
Or insert a 'varbinary' Code into the column.

Greetings
dA-uNknOwN
03/18/2010 12:08 pieter#15
Quote:
Originally Posted by Scotticus View Post
Does not work.. Returns this..

hmm an uber programmer should just easilly notice where it goes wrong reading those errors

just set the binary fields to NULL or use the stored procedure in the character database to make the binary ip's from 127.0.0.1 :)