Well... as these first Goldenboy database creation scripts are incomplete... and I finally found from where I can make these scripts... then...
I release MAINLOG and WS1 database creation scripts from my database, where I have atm running HBserver with these China HG and other official files... so for beginners it's much easier to create database with right structures...
<a href='http://www.hot.ee/rageatm/rage_database_scripts.rar' target='_blank'>http://www.hot.ee/rageatm/rage_database_scripts.rar</a>
don't know why.. I couldn't upload this foile to here forum.. so anyone could upload it here and add to the first post in this topic..
Sql Files Guide
-
RageIlluminati
- Outpost bitch
- Posts: 559
- Joined: Wed Mar 30, 2005 6:45 am
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
what are the benefits of this scripts? you made work something new? or you only recompile it?RageIlluminati wrote: Well... as these first Goldenboy database creation scripts are incomplete... and I finally found from where I can make these scripts... then...
I release MAINLOG and WS1 database creation scripts from my database, where I have atm running HBserver with these China HG and other official files... so for beginners it's much easier to create database with right structures...
<a href='http://www.hot.ee/rageatm/rage_database_scripts.rar' target='_blank'>http://www.hot.ee/rageatm/rage_database_scripts.rar</a>
don't know why.. I couldn't upload this foile to here forum.. so anyone could upload it here and add to the first post in this topic..
something new like helenian or something. thanks
-
RageIlluminati
- Outpost bitch
- Posts: 559
- Joined: Wed Mar 30, 2005 6:45 am
benefits... if you download goldenboy files and execute his scripts.. then your database miss some shit.. like you don't have code_t table in it.. and you don't have gizonupgradeleft golumn and so on... in my scipts they all are there...-Pitu- wrote: what are the benefits of this scripts? you made work something new? or you only recompile it?
something new like helenian or something. thanks
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
-
RageIlluminati
- Outpost bitch
- Posts: 559
- Joined: Wed Mar 30, 2005 6:45 am
Have anybody got 'Scan' spell work on these HBChina files?
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
i talked with rage and he thought about same thing, he said that they MUST be named there as "ws1" and "mainlogin" so i renamed them and restarted sql, but still it gives the same error INIT FAIL... im so tired of this error and i cant find any info about it from internet 
also i found that in those files here u also need mapdata amd files for gameserver to work
edit: (a copy from odbc)
mainlog:
Microsoft SQL Server ODBC Driver Version 03.81.9030
Data Source Name: mainlogin
Data Source Description: mainlogin
Server: (local)
Database: mainlogin
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: Yes
Statistics File: C:\STATS.LOG
Use Integrated Security: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No
ws1:
Microsoft SQL Server ODBC Driver Version 03.81.9030
Data Source Name: ws1
Data Source Description: ws1
Server: (local)
Database: ws1
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: Yes
Statistics File: C:\STATS.LOG
Use Integrated Security: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No
also i found that in those files here u also need mapdata amd files for gameserver to work
edit: (a copy from odbc)
mainlog:
Microsoft SQL Server ODBC Driver Version 03.81.9030
Data Source Name: mainlogin
Data Source Description: mainlogin
Server: (local)
Database: mainlogin
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: Yes
Statistics File: C:\STATS.LOG
Use Integrated Security: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No
ws1:
Microsoft SQL Server ODBC Driver Version 03.81.9030
Data Source Name: ws1
Data Source Description: ws1
Server: (local)
Database: ws1
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: Yes
Statistics File: C:\STATS.LOG
Use Integrated Security: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No
znookie
When u made these in odbc and got to the end of when u created them...did u TEST them to see if they connected???????
And read the Guild I made to see what there suppose to be called ....
account and character
Rage must have misunderstood your question or u took it wrong some how ...and u did edit the Mainlog and and world exe?
When u made these in odbc and got to the end of when u created them...did u TEST them to see if they connected???????
And read the Guild I made to see what there suppose to be called ....
account and character
Rage must have misunderstood your question or u took it wrong some how ...and u did edit the Mainlog and and world exe?
Code: Select all
Microsoft SQL Server ODBC Driver Version 03.81.9030
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!EDIT: Yay, now worldlog works(I think) at least it starts now and won't give the INIT fail or Can't connect to db error!
EDIT2: Still can't figure out whats wrong with Mainlog, its named "account" at ODBC atm, but still getting the init error... it pops up instantly when I open mlserv and for the record I have overlooked the hex part of mainlog and the password is right in there so I'm kinda out of ideas atm. <_<