Vm is vmware workstation right ? ( we are talking about the same thing here ? )Originally Posted by martijn464
I dont get it XD[/QUOTE]
VM = Virtual Machine
Vm is vmware workstation right ? ( we are talking about the same thing here ? )
I dont get it XD[/QUOTE]
VM = Virtual Machine
Starting from now my real weekend is starting, so I really don't know how much I will be able to reply to messages on forum. I'll do my best to check it but I cannot guarrantee a fast answer.
Sorry for that, have a nice weekend all:)
You have to write there after pressing esc on your DS window
Did you copy the lump.dat from c:\ scripts into your c:\9dragons folder?
Inviato dal mio GT-I9300 utilizzando Tapatalk
How many memory you have on your vm? Do you have enough disk space this db is needed but contains a lot of old data that can be probably removed I will have a look on monday to see if i can reduce the size and post a new bak file with just the data structure and the procedures.
Inviato dal mio GT-I9300 utilizzando Tapatalk
Wasn't 3.5GB for 32bit?
BTW. Everythings works SOMEHOW fine, but my IM procedure return v_error 1 and can't get any item via IM.
Windows 2003 enterprise ediction 32 bit have 32gb memory limit, the limit does not depend from the number of bits but from the os structure. A 32 bit os theotetically can handle up to 1Tb of memory
Inviato dal mio GT-I9300 utilizzando Tapatalk
If you changed the script remember that in python you must respect the indentation or the script will fail. You can try importing it manually from sql mgmt studio and commenting with a # the line autoconf.py that contain the name of the bak file, should be an append command.
Inviato dal mio GT-I9300 utilizzando Tapatalk
Nvm, the fix is to actually upgrade to Datacenter edition or download it from pirate bay... credits go to the post below me.
[strike]if someone wants to fix that database.. restore it into EXCEL using a software example like -> Excel MS SQL Server Import, Export & Convert Software
and send me the file ... i will repair the corrupt data.
or.... i can just re build the database for the community if the community really needs that database, but this will require me using someones test server + a lot of time and effort! - Seeing how this is written in python "wtf who uses python in the gaming industry" this will be a little annoying :P
[/strike]
Last edited by Jangan; 23-11-13 at 08:24 PM.
Re: WIP on 9dragons US Server Files
woo finally ...
I managed to get the ND_History_0.bak to restore.
To do this you need to already finish step 7 from zeroburner guide
You need to perform a edition upgrade for the SQL Server 2008 r2 express to datacenter with this Serial
here are the steps:
1)Go to all programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> SQL server Installation center
2)Go to maintenance and click Edition Upgrade
3)Ok -> Next -> select Enter the product key and paste the serial in and click next
4)Accept the license
5) select MSSQLSERVER as the instance -> next next-> upgrade
and the restoring should be working cheers
Lol, I've created that scripts to help, and I've done them in python because I like python and I script daily with that. The DB is not corrupted i've imported it and several other ppl did that before.
In any case, you are not obliged to use my stuffs and you can create things on your own.
Sent using Tapatalk on my Samsung Galaxy S3
Since lot of ppl have problems with the ND_HISTORY_0 database I've done a cleanup on an imported version of useless historical data, and created a new backup.
To fix the Autoconf.py problem restoring this database this is the procedure:
1) Download the file
https://www.dropbox.com/s/3c2fr8lz2e...19_2283750.bak
(around 3 mb)
2) Place it onto your c:\9dragons\db folder overwriting the existing version
3) relaunch the autoconf.py
As a side note in any case is better to use the full MSSQL rather than the express, since it have more functionalities and will avoid you problems with tables size.
Ps. doing an export to another datasource type, like the excel files you will lose all the stored procedures in the programmability section that are needed to execute the 9dragons server.
9dragons for the 99% of the times uses the stored procedures to access the database and not direct queries to the DB.
I hope it helps.
Last edited by ZeroBurner; 23-11-13 at 10:32 PM. Reason: changed link
I've uploaded a new version, I forgot to update the datafile size after the cleanup... apologize for that.
https://www.dropbox.com/s/3c2fr8lz2e...19_2283750.bak
SQL SERVER 2008 R2 ------> Descarga Microsoft® SQL Server® 2008 R2 SP2 - Express Edition del Centro de Descargas de Microsoft
About changing name - check procedures in ND_GAME_0, there are few of 'em. But to see effects I needed to reset whole sv.
*tested few procedures, deleted storages, items and so more because of 1 fault xD*
About BEs, you can get 'em from Item Mall too.
200 BE - Item Code: 2211447
Reply With Quote
