Sudden Attack Server

Status
Not open for further replies.
Re: Release Sudden Attack Server

if anyone can export sql server database to .sql files, i can convert to mysql(i am not have installed mssql here, and my connection is dialup in this moment)

Here how to disable fixed password

go offset 0013111C
change 73 61(sa in ascii) to 00 00

if you done that it will use the set password in DB_Conn string
if anyone can convert it ill test it on mssql 2005 :P use odbc to connect probably.
 
Re: Release Sudden Attack Server

Dev OnPacket : U(0) 100
Dev 7 2009-07-04 20:33:51 State LOGINING U(0)
Dev [LOW_DB] Source: Microsoft OLE DB Provider for SQL Server
Dev [LOW_DB] Detail: 80040e14, 열 이름 'ServerID'이(가) 잘못되었습니다.

What Server ID ?????????
 
Re: Release Sudden Attack Server

hmm, if we can get a sudden attack private server, it will the first, first shooter FPS private server in the world, I think.

Found this ,
Hey guy's I am Brutal from Gamenao and I was just wanting to give you all the chance to play our sudden attack server so I will provide the link for the download and the register page first I must tell you we have been working on this for only 3 days now and we already have it up and running we are in the middle of translating the client for the most part its readable at the moment. Our forums will provide guides if you get stuck. so I hope to see you on and Ill add some screen shots in a few!

Download:

Launcher:

Register:


Pics and maybe a vid soon. gotta get someone to do the vid!!!


Ventrilo info

Host/IP: vent.gamenao.com
Port: 4139

Maybe we can learn something from that?
 
Re: Release Sudden Attack Server

Any update 'bout this SA?
And if someone can make the instructions...
Pls share it to our RZ members , including me! ^^
Coz if i get this in work then this will be the 1st FPS Pserver game in philippines!!!
WOOT!!!
So can someone make a guide/tut???
Tnx in adv!!!
THIS WILL BE A REALLY GREAT GAME FOR PHILIPPINES!!!
HAHA!!!

~Lecks - [1M4G3]
 
Re: Release Sudden Attack Server

i am porting database to mysql, but i've got one problem about the OUT param in call procedures.

Server uses this:
call SP_GS_GM_ServerStatus_R(_latin1'127.0.0.1', 12000, _latin1'', _latin1'', 0);

and mysql get out by this:
call SP_GS_GM_ServerStatus_R('127.0.0.1', 12000, @o_ServerID, @o_ServerName, @o_sp_rtn);

and while call stored procedure mysql give a error, the only way is mod the server(mod the source code and recompile)

i dont have tested with PostgreSQL or other DBS with stored procedures.

i have got the data structure from mssql dbs using one database recover program, if anyone like i will post later(to use in mssql 2005 or 2008)
 
Re: Release Sudden Attack Server

i am porting database to mysql, but i've got one problem about the OUT param in call procedures.

Server uses this:
call SP_GS_GM_ServerStatus_R(_latin1'127.0.0.1', 12000, _latin1'', _latin1'', 0);

and mysql get out by this:
call SP_GS_GM_ServerStatus_R('127.0.0.1', 12000, @o_ServerID, @o_ServerName, @o_sp_rtn);

and while call stored procedure mysql give a error, the only way is mod the server(mod the source code and recompile)

i dont have tested with PostgreSQL or other DBS with stored procedures.

i have got the data structure from mssql dbs using one database recover program, if anyone like i will post later(to use in mssql 2005 or 2008)
so it can be used in MSSQL 2005? If so then I would like it if you posted it :D
 
Re: [Release] Sudden Attack Server

My GameServerDebug.exe is completely black, please help-me

kn95951135 - Sudden Attack Server - RaGEZONE Forums
 
Re: [Release] Sudden Attack Server

My GameServerDebug.exe is completely black, please help-me

kn95951135 - Sudden Attack Server - RaGEZONE Forums

its normal, while server is working the console will be blank, only write something if server has an error.

here restored data/structure from mdf files for sql2005+
 

Attachments

Last edited:
Re: [Release] Sudden Attack Server

helps in that

2005:
2008:

its better to u use the sql server 2005/2008 OleDB Provider.
 
Re: [Release] Sudden Attack Server

how to register ?

~~

When i try to login , i receive an error and game close.



Event.txt :
======= 07/09/09 == 21:10:13 ===============

Room 0 2009-07-09 21:10:13 OpenLobby R(0)

Room 1 2009-07-09 21:10:13 OpenLobby R(1)

Room 2 2009-07-09 21:10:13 OpenLobby R(2)

DB 3 2009-07-09 21:10:18 SP_GS_GM_ServerStatus_R 0 127.0.0.1 12000

DB 4 2009-07-09 21:10:18 SP_GS_GM_LEVEL_R 0
0|0?|0|3000|0.003
1|1?|3001|6000|0.006
2|2?|6001|9000|0.009
3|3?|9001|18000|0.018
4|4?|18001|30000|0.030
5|5?|30001|45000|0.045
6|6?|45001|75000|0.075
7|7?|75001|135000|0.135
8|8?|135001|255000|0.255
9|9?|255001|425000|0.425
10|10?|425001|775000|0.775
11|11?|775001|1275000|1.275
12|12?|1275001|2275000|2.275
13|13?|2275001|3575000|3.575
14|14?|3575001|5075000|5.075
15|15?|5075001|8075000|8.075
16|16?|8075001|12075000|12.075
17|17?|12075001|17075000|17.075
18|18?|17075001|27075000|27.075
19|19?|27075001|99999999|100.000


DB 5 2009-07-09 21:10:21 SP_GS_GM_RANK_R 0
0|???|0
1|???|3000
2|???|10000


DB 6 2009-07-09 21:12:20 SP_GS_GM_ServerStatus_U 0 1 0

DB 7 2009-07-09 21:14:22 SP_GS_GM_ServerStatus_U 0 1 0

DB 8 2009-07-09 21:16:24 SP_GS_GM_ServerStatus_U 0 1 0

DB 9 2009-07-09 21:18:26 SP_GS_GM_ServerStatus_U 0 1 0

DB 10 2009-07-09 21:20:28 SP_GS_GM_ServerStatus_U 0 1 0

DB 11 2009-07-09 21:22:30 SP_GS_GM_ServerStatus_U 0 1 0

DB 12 2009-07-09 21:24:32 SP_GS_GM_ServerStatus_U 0 1 0

Dev 13 2009-07-09 21:25:06 State INIT U(0) IP(127.0.0.1)



Dev OnPacket : U(0) 100

Dev 14 2009-07-09 21:25:06 State LOGINING U(0)

DB 15 2009-07-09 21:25:07 SP_GS_MB_LOGIN -2 12

<== 101

Dev 16 2009-07-09 21:25:07 State CLOSING U(0)

Dev OnClose : U(0)
 
Re: [Release] Sudden Attack Server

returned -2 u need to create account in table MB_USR

read guide.txt have info about that

or execute this
Code:
CALL SP_MB_USR_C('user_no', 'user_id', 'user_name', 'user_age', 'user_pwd', 'user_nick', 'user_sex', 'user_type', GETDATE(), '127.0.0.1', '');
just change the values!

* Sorry about double post internet just got lagged!
 
Re: [Release] Sudden Attack Server

i have translated everything into english.
im planning to upload my server soon under the name of Miracle SuddenAttack.
I have also found out how to create accounts to login.
And to all you people that want to do this as well!
dont worry ill upload some screenies/videos/tutorials on how to do this!
 
Re: [Release] Sudden Attack Server

i have translated everything into english.
im planning to upload my server soon under the name of Miracle SuddenAttack.
I have also found out how to create accounts to login.
And to all you people that want to do this as well!
dont worry ill upload some screenies/videos/tutorials on how to do this!
Good job :thumbup:
 
Status
Not open for further replies.
Back