[Release] Sudden Attack Server - Page 5 - RaGEZONE

wesman2232 · 06-26-2009

Originally Posted by snaity

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.

kn95951135 · 06-28-2009

We are looking programmer LINK: http://forum.ragezone.com/f206/sa-hi...ammers-585995/

hmy2030 · 07-04-2009

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 ?????????

**Ace** · 07-06-2009

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 ,

Originally Posted by Ragesource

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: http://www.megaupload.com/?d=JENDV24B

Launcher: http://gamenao.com/download/Launcher.exe

Register: http://zeus.gamenao.com:8080/

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?

lecksmatt · 07-06-2009

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]

zad67 · 07-06-2009

Its not hard to set up someone as already gone out of their way to show everyone just read.

snaity · 07-07-2009

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)

wesman2232 · 07-07-2009

Originally Posted by snaity

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

andres00 · 07-07-2009

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

http://img19.imageshack.us/img19/5519/imagemjvp.jpg

snaity · 07-08-2009

Originally Posted by andres00

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

http://img19.imageshack.us/img19/5519/imagemjvp.jpg

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+

wesman2232 · 07-09-2009

what you have to change in the config.ini to make it work with sql2005/ODBC connection to sql2005?

snaity · 07-09-2009

http://www.connectionstrings.com helps in that

2005: http://www.connectionstrings.com/sql-server-2005
2008: http://www.connectionstrings.com/sql-server-2008

its better to u use the sql server 2005/2008 OleDB Provider.

wesman2232 · 07-09-2009

thanks for the links :D

AKllX · 07-10-2009

how to register ?

~~

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

Event.txt :

Quote:

======= 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)

snaity · 07-10-2009

returned -2 u need to create account in table MB_USR

read guide.txt have info about that

snaity · 07-10-2009

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!

Sniper · 07-13-2009

any progress guys? translation of client?

sylock232 · 07-14-2009

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!

myripper · 07-14-2009

Originally Posted by sylock232

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

taerocks · 07-14-2009

how do i log in to the game?

taerocks · 07-14-2009

and soo many files... i dunno and its kinda confusing putting stuff in to files

and where is LANUCHER!?

taerocks · 07-14-2009

it say i am missing mfc2d.dll or somthing... when i try lanuching it...

taerocks · 07-14-2009

it say max chennal 1 and it say error createddatabase connected = 0 wtf???

taerocks · 07-14-2009

[2009.07.14 16.17.27] ==[Start Sudden Attack Server]===========================

[2009.07.14 16.17.27] @@ Start Time : 2009/07/14 16:17:27

[2009.07.14 16.17.27] @@ Address : 211.39.158.149 (12000)

[2009.07.14 16.17.27] @@ MaxPacketSize : 8192

[2009.07.14 16.17.27] @@ MaxClients : 100

[2009.07.14 16.17.27] @@ MaxResponseBufferSize : 65536

[2009.07.14 16.17.27] @@ MaxRoomUser : 32

[2009.07.14 16.17.27] @@ MaxChannels : 1

[2009.07.14 16.17.50] ## ERROR CreateDataBase Connected : 0

Sniper · 07-16-2009

Originally Posted by sylock232

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!

thank you!!!!!

Omfg!!!! +1000000000000000000000000000000000000000000000000 0000000000000