[Release] OsDs Control Panel

janvier123 · 10/15/2009, 23:02

its created with a MSSQL 2005 so .... download 2005 ?
ill look if i can downgrade it
Trial from MS.com:

Error listed here:

Quote:

Details
Product: SQL Server
ID: 3169
Source: MSSQLServer
Version: 10.0
Component: SQLEngine
Message: The database was backed up on a server running version %ls. That version is incompatible with this server, which is running version %ls. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

Explanation
Certain features in SQL Server affect the structure of the database files. When you restore a database to another instance of SQL Server, the file format might not be compatible with a different version of the SQL Server Database Engine.

For example, this error can be caused by using the vardecimalstorage format in a later version of SQL Server and then trying to restore the database files in a version earlier than SQL Server 2005 Service Pack 2.

User Action
Determine the version of SQL Server that is running on the originating server. In SQL Server Management Studio, either right-click the server and then click Properties or type SELECT @@VERSION in a query window. Open the database by using the original version of SQL Server. Investigate the features that are enabled on the original database in the instance of SQL Server. Modify these settings to work with the version of SQL Server in which the database will be restored.

If not look for MSSQL 2005
but i cant realy post a link so ... maybe i can say its on my ftp/http

My Server SQL Info

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.3053
Operating System 5.2.3790

gedimazs · 10/15/2009, 23:19

can you try to remake it on mssql 2000?
edited: not working your last release to make it work on mssql 2000 :S
edited2: emm will our database from mssql 2000 will restore in mssql 2005 correctly with no errors?will we t lose any info?

~~[GA]Lightning~~ · 10/15/2009, 23:32

Quote:

Originally Posted by janvier123

its created with a MSSQL 2005 so .... download 2005 ?
ill look if i can downgrade it
Trial from MS.com:

Error listed here:

Try this database:
If not look for MSSQL 2005
but i cant realy post a link so ... maybe i can say its on my ftp/http

My Server SQL Info

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.3053
Operating System 5.2.3790

i cant download 2005 in ms.com site only the 2008

and the database for 2000 its the same error

i hope you can fix it :-(

janvier123 · 10/16/2009, 01:13

ill try to remake it
but mssql is soooo old
mssql 2005 is way better and faster so ...

~~[GA]Lightning~~ · 10/16/2009, 01:22

Quote:

Originally Posted by janvier123

ill try to remake it
but mssql is soooo old
mssql 2005 is way better and faster so ...

Oh thank you

regards Deathmage

Decima · 10/16/2009, 01:28

jan, i thought the use of mysql was way better anyways, because its more secure using a different DB platform then the game, also the fact that a DB in mysql is still compatible (to a point, usable still) with other versions of mysql, plus lets face it, mysql is easier to work with all the way around, gates doesnt control it, so no worries about upgrading and breaking ur script

why did u even stray from it if i may ask?

janvier123 · 10/16/2009, 01:56

Quote:

Originally Posted by Decima

jan, i thought the use of mysql was way better anyways, because its more secure using a different DB platform then the game, also the fact that a DB in mysql is still compatible (to a point, usable still) with other versions of mysql, plus lets face it, mysql is easier to work with all the way around, gates doesnt control it, so no worries about upgrading and breaking ur script

why did u even stray from it if i may ask?

easyer

OK ive transferd my MSSQL 2005 DB to MSSQL 2000 (without SP4) so it should be older then MSSQL 200 with SP4

everything went fine
Here is the download:

(It can be that the name is too long to mssql to read, you may have to make it shorter)

if it works ill remake the download release with both mssql 2005 and mssql 2000 dbs inside
then its up to you whate you want to use
Here is the log:

Quote:

Process started.
Source database:-- MSSQL database -- (2005 db server)
Host: localhost
Port: 1433
User: sa
Password: Yes
Database: osds
CharSet: utf8

Destination database:-- MSSQL database -- (2000 db server)
Host: 192.168.1.102
Port: 1433
User: sa
Password: Yes
Database: osds
CharSet: utf8

Removing database 'osds'.
Creating database 'osds'.
Connecting to the source database.
Connecting to the destination database.
Creating table 'allitems'.
Creating table 'banned'.
Creating table 'itemarmor'.
Creating table 'itemcash'.
Creating table 'itemcsv'.
Creating table 'itemweapon'.
Creating table 'q_index'.
Creating table 'session'.
Creating table 'site_about'.
Creating table 'site_config'.
Creating table 'site_download'.
Creating table 'site_ipban'.
Creating table 'site_news'.
Creating table 'site_rules'.
Creating table 'site_store'.
Copying data for table 'allitems'.
Copying data for table 'banned'.
Copying data for table 'itemarmor'.
Copying data for table 'itemcash'.
Copying data for table 'itemcsv'.
Copying data for table 'itemweapon'.
Copying data for table 'q_index'.
Copying data for table 'session'.
Copying data for table 'site_about'.
Copying data for table 'site_config'.
Copying data for table 'site_download'.
Copying data for table 'site_ipban'.
Copying data for table 'site_news'.
Copying data for table 'site_rules'.
Copying data for table 'site_store'.
Closing connections.
Process completed successfully.

~~[GA]Lightning~~ · 10/16/2009, 02:53

Quote:

Originally Posted by janvier123

easyer

OK ive transferd my MSSQL 2005 DB to MSSQL 2000 (without SP4) so it should be older then MSSQL 200 with SP4

everything went fine
Here is the download:
(It can be that the name is too long to mssql to read, you may have to make it shorter)

if it works ill remake the download release with both mssql 2005 and mssql 2000 dbs inside
then its up to you whate you want to use
Here is the log:

Thank you working

but by install i have a error on the site

Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\osds\config\install.php on line 94

but why?

Best Regards DeathMage

janvier123 · 10/16/2009, 02:58

well its easy
open your PHP.INI in your xampp or whate even you use
path for xampp "\xampp\php"

and look for

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;

Find:

;extension=php_mssql.dll

note that there is a ; before the line
remove the ; save file and restart xampp

you should have

extension=php_mssql.dll

That's it

~~[GA]Lightning~~ · 10/16/2009, 03:27

Quote:

Originally Posted by janvier123

well its easy
open your PHP.INI in your xampp or whate even you use
path for xampp "\xampp\php"

and look for

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;

Find:

;extension=php_mssql.dll

note that there is a ; before the line
remove the ; save file and restart xampp

you should have

extension=php_mssql.dll

That's it

thank you

work now but i have the next error

Warning: mssql_select_db() [function.mssql-select-db]: message: Could not locate entry in sysdatabases for database 'char2'. No entry found with that name. Make sure that the name is entered correctly. (severity 16) in C:\xampp\htdocs\osds\config\install.php on line 95

Warning: mssql_select_db() [function.mssql-select-db]: Unable to select database: char2 in C:\xampp\htdocs\osds\config\install.php on line 95

Warning: mssql_query() [function.mssql-query]: message: Cannot alter table 'user_character' because this table does not exist in database 'master'. (severity 16) in C:\\xampp\htdocs\osds\config\install.php on line 96

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\osds\config\install.php on line 96

but why? i have restored the database the name is osds

can you help?

Best regards

DeathMage and thanks again for the nice work

Decima · 10/16/2009, 04:21

Quote:

Originally Posted by janvier123

easyer

jan . . . .

u know what i think about you, but . . .

it doesnt look like its turning out easier lol

gedimazs · 10/16/2009, 07:30

hmm same errors as DeathMage has:

Warning: mssql_select_db() [function.mssql-select-db]: message: Could not locate entry in sysdatabases for database 'char2'. No entry found with that name. Make sure that the name is entered correctly. (severity 16) in C:\xampp\htdocs\osds\config\install.php on line 95

and so on...

janvier123 · 10/16/2009, 10:35

Fixed Install:

Thx for reporting the error codes and not "i does not work" !
video will come today !

EDIT: New upload on first page !

#Added:
Fixed "install.php
Added Fixed "php.ini"
Added MSSQL Links
Added "Bugs file"
Added Xampp read me
Added Mssq 2000 database
Added "installation.txt"

gedimazs · 10/16/2009, 11:50

1.Please fix players online. Cause it is showing players who not online 100%
2.After selecting modify character you get error: Login Error, Please login again.
3.Add send message from web (only for GMs)
4.Make log off button in user mode.
5.In Coins Admin add field to send coins using charname or account id

So that's it for now. But I think later I will edit it

janvier123 · 10/16/2009, 14:03

prefect, ill get to it then

1.Please fix players online. Cause it is showing players who not online 100% #Fixed cuz ive used a general tag for all pages called $user_no
2.After selecting modify character you get error: Login Error, Please login again.#Fixed
4.Make log off button in user mode.#Fixed

ill add gm send page

HD Video tutorial Added !