Db Sql Format

DarkieDuck · Post by **DarkieDuck** » Tue May 17, 2005 11:17 am

Make sure that user "hell" (dunno if the releasers changed that username) has full access to all DBs

here is 1 from my db

Code: Select all

sjaak   9999999999   1001   127.0.0.1   0   2002-02-02 16:00:00   2004-05-31 16:16:00   2004-05-31 16:16:00   2002-02-02 00:00:00   realname   ssn   email   none   quiz   answer   2002-02-02 00:00:00   0

CDWriter · Post by **CDWriter** » Tue May 17, 2005 11:37 am

DarkieDuck i dont know if your trying to help or be a smart ass....Becuase i know u could fix this in 1 sec just by giveing us the orginal mssql db setup files for it .....

Make sure that user "hell" (dunno if the releasers changed that username) has full access to all DBs

that statement looks like your trying to be a smart ass .....so if your not willing to help please dont dick with us ........

DarkieDuck · Post by **DarkieDuck** » Tue May 17, 2005 2:06 pm

i already gave the orginal MSSQL dumps lol (was on gamehacking.com)

im sure some ppl still have it , cuz i got it on CD somewhere and its a bit of a mess here

[edit]
oh and i was trying to help , cuz i ran into the same problem
[/edit]

CDWriter · Post by **CDWriter** » Tue May 17, 2005 7:40 pm

[QUOTE]here is 1 from my db

Code: Select all


sjaak   9999999999   1001   127.0.0.1   0   2002-02-02 16:00:00   2004-05-31 16:16:00   2004-05-31 16:16:00   2002-02-02 00:00:00   realname   ssn   email   none   quiz   answer   2002-02-02 00:00:00   0

mean u have one could u dump it for us DD.

Ice-T · Post by **Ice-T** » Tue May 17, 2005 10:06 pm

CDWriter wrote:no i think there some stuff missing in MSSQL db that we all dont have ....

example from Mainlogin

select * from CODE_T where cKEYCODE = '%s'

CODE_T - cKETCODE <---- whats this ?

iam going throu the mainlog now so i get any where ill let u all know...

and something has to reflect the accountID based to the Char or cAccount

yup this deals with encryption

DarkieDuck · Post by **DarkieDuck** » Tue May 17, 2005 10:20 pm

i dont have anything about ketcode , but then again i used the USA server files and not the chinese

Ice-T · Post by **Ice-T** » Tue May 17, 2005 10:37 pm

hum well, they shouldent be all that diffrent, unless hb china is the only one that has encryption, but as you said u ran in to similar problems in an earler post

DarkieDuck · Post by **DarkieDuck** » Wed May 18, 2005 12:03 pm

i ran into Account doesnt exists.
I fixed that by changing some account rights.

just looked over my DB , i got nothing regarding a keycode

Ice-T · Post by **Ice-T** » Wed May 18, 2005 12:11 pm

DarkieDuck wrote:i ran into Account doesnt exists.
I fixed that by changing some account rights.

just looked over my DB , i got nothing regarding a keycode

thats the exact same problem i have come accross, i thought it might have been because i input data manual in to it, so i bodged up an acc maker but still nothin. ill have a look around in the acc rights part to

tyteman · Post by **tyteman** » Wed May 18, 2005 12:43 pm

DarkieDuck wrote: i already gave the orginal MSSQL dumps lol (was on gamehacking.com)

im sure some ppl still have it , cuz i got it on CD somewhere and its a bit of a mess here

[edit]
oh and i was trying to help , cuz i ran into the same problem
[/edit]

i remember that... but too bad ddh pruned the mp hacking thread ... LOL .. so it got completely cleaned out... so nothing useful is in there now except server ads

Ice-T · Post by **Ice-T** » Wed May 18, 2005 12:52 pm

yeh, its workin now

GoldenBoy · Post by **GoldenBoy** » Wed May 18, 2005 2:29 pm

dd dide released SQL sump month ago, it should be on tthe zip, but anyways its on dev. you guys with acccess to dev. can take it amd post it here.

DarkieDuck · Post by **DarkieDuck** » Wed May 18, 2005 2:37 pm

just looked @ the zip , its only has the mainlogin.sql(txt) other 3 are missing

Ice-T · Post by **Ice-T** » Wed May 18, 2005 2:52 pm

theres 5 scripts

CrusadeScript
HeldenianScript
mainlogin
RebuildIdx
ws1

DarkieDuck · Post by **DarkieDuck** » Wed May 18, 2005 5:41 pm

ur missing the upgrade scripts

mainlogin2.sql
and world-something.sql

upgrades / changes both DBs a bit