uhm.. dude it means you already have the log_serverstate
Printable View
uhm.. dude it means you already have the log_serverstate
The code I posted is for the guy that has incomplete sp...Quote:
Originally Posted by istamburukoi
He is lacking sp_logserverstate that's why I posted the code for that sp..
For your error it's another story...
ah! thank you! and do you know how to fix my problem? did you see my problem message? do you know how to fix that? my problem is you cant see my server in server select window. blank server select windowQuote:
Originally Posted by austhistikated
and the other oneis gmcharedit. after i entered the gmid and password and click my server and click ok, the message" Game DB opoen failed" appeared. what should i do
please help me..>_<
yup and i realized that its not the solution to my problem because my problem is you cant see my server in server select window. blank server select window...Quote:
Originally Posted by Seifer13
how to make my server appear in the server select window?
and the other oneis gmcharedit. after i entered the gmid and password and click my server and click ok, the message" Game DB opoen failed" appeared. what should i do
please help me..>_<
for the server selectQuote:
Originally Posted by istamburukoi
try to have a fresh gui
and for your gmcharedit
make sure you placed it in the ryt place and it has the required files with it
my problem is you cant see my server in server select window. blank server select window...
how to make my server appear in the server select window?
and the other oneis gmcharedit. after i entered the gmid and password and click my server and click ok, the message" Game DB opoen failed" appeared. what should i do
please help me..>_<
your problem is in the guiQuote:
Originally Posted by istamburukoi
go to data folder
then replace the file with this gui
http://www.mediafire.com/?tly4cn8peyf
thank you for the reply!!=)Quote:
Originally Posted by abry
huhuhu i tried ur suggestion but it failed again
the server select windows appeared blank again
huhuhuh! do you know what is the other possible problem of it? nd solution.. huhuhu!
this morning i tried something to my program and i think it is succesful but its not continueing, the last message i saw is "Reading the server`s account info" what do you think is the problem? pls help me on this..thank you...
SQL 2005 Express
Install .NET Framework 2.0 (dotnetfx.exe)
how to install?
Install MSSQL 2005 Express Edition
how to install?
Install MSSQL Management Studio Express
how to install?
can show some picture?
@shuyina
For installation procedure with pictures...
Just refer to this thread...
http://forum.ragezone.com/showthread.php?t=139906/
i got some problems here im new in this kind of things.
i want to make a ran offline server
http://i519.photobucket.com/albums/u.../untitled2.jpg
and this too
http://i519.photobucket.com/albums/u...3/untitled.jpg
hehehe
u can use URONetwork Client & My RanServer
ok i manage to make it work now..
the problem is how to register in game?
which file? should i use?
anyone???
THX sa mag reply :drinks_no
to have a registration
go to important links:Click This
then scroll down and you will see a RanCp
choose what do you want there
T_T i dont have RanCP i just wanna play offline.Quote:
Originally Posted by abry
but i already downloaded the register.php
where should i put it?
sorry im a total noob T_T
awts, follow the instruction dude.
If hard for you to make rancp
you can manually register the account
in your Sql Server manager
databases > RanUser > Tables > dbo.userinfo > open table > put your account in the table.
T_T when i try to edit these
something pops out say's "column sa already exist"
SGNum : 0 <--DONE
SGName : IaNz Server ( you can put any name u want ) <--DONE
OdbcName : RanGame1 <--DONE
OdbcUserID : sa <--DONE
OdbcPassword : 1234 <--DONE
OdbcLogName : RanLog <--DONE
OdbcLogUserID : sa <-- di ko ma palitan to kasi daw may column sa na T_T
OdbcLogPassword : 1234 <--same here
thx sa mag reply =)
i cant pass here...i dont understand where can i change it?
Quote:
GM Character Edit Settings (GMCharEdit.exe)
Quote:
Open up your SQL Manager, go to the RanUser database.
Now, Open ServerGroup table. Fill in this Column
SGNum : 0
SGName : IaNz Server ( you can put any name u want )
OdbcName : RanGame1
OdbcUserID : sa
OdbcPassword : 1234
OdbcLogName : RanLog
OdbcLogUserID : sa
OdbcLogPassword : 1234
When done, Open ServerInfo table in the RanUser database.
put these values.
For Windows Authentication user and pass is not needed.
SGNum : 0
SvrNum : 0
SvrType : 4
Now, run the GMCharEdit. If this is your first time running it
you'll see 4 fields to input information.
First field : RanUser
Second field : sa
Third field : 1234
Fourth field : 1234
For Windows Authentication user and pass is not needed.
Creating an account
set UserType = 32 on UserInfo table for GM
and UserType = 1 for Users Only
on Ep4 database, you notice that the password is code instead of word
thats the new changes on Ep4 database
you must convert your password to a code known as MD5 Hash
ex:
Password | MD5 Hash Code
123456 = E10ADC3949BA59ABBE5
test = 098F6BCD4621D373CAD
ianz = 0948D2350A28EEB4B3B
pdf = BCD1B68617759B1DFCF
and this is what show in session,login, field,agent:
Quote:
ERROR:User db open failed
== Please wait until server stop
Stop IOCP
Stop Message Queue
Stop DataBase
Stop CFG
=======================================================
Server Stop OK
=======================================================
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
Quote:
Service Provider:CHINA
CreateIoCompletionPort OK
--------------- System Information -------------------
Microsoft Windows XP
Pentium 4 processor 2415 Mhz
2 System Processor Detected
------------------------------------------------------
4 Worker Thread
1 st Worker Thread Create OK
2 st Worker Thread Create OK
3 st Worker Thread Create OK
4 st Worker Thread Create OK
Server Update Thread Create OK
WSASocket OK
Bind OK
127.0.0.1:5001
Server Accept Thread Create OK
ERROR:CLoginServer::SessionConnect connect 10061
================================
Session Server Connection Failed
================================
== Please wait until server stop
CloseAllClient
Stop IOCP
Stop Meessage Queue
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
Stop DataBase
Stop CFG
=======================================================
Server Stop OK
=======================================================
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
Quote:
Service Provider:CHINA
INFO:nProtect GameGuard server DLL load failed
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
ERROR:SQLConnect Failed
ERROR:User DB Open Error
== Please wait until server stop
== Update Thread end
INFO:CAgentServer::SessionCloseConnect SessionCloseConnect already offline
== Client Manager closed
== Message Manager closed
== Database Manager closed OK
=======================================================
Server Stop OK
=======================================================
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
Quote:
Service Provider:IANZ SERVER
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
ERROR:SQLConnect Failed
ERROR:User DB Open Error
== Please wait until server stop
== Update Thread end
== Client Manager closed
== Message Manager closed
== Database Manager closed OK
=======================================================
Server Stop OK
=======================================================
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
LIA insideQuote:
Originally Posted by shuyina
what Lia inside?
I have the same problem with asura and followed austhistikated but when I execute it this error shows
Msg 2714, Level 16, State 3, Procedure log_serverstate, Line 13
There is already an object named 'log_serverstate' in the database.
Hello Guyz
Y i cant make database?? where can i find it please help me??
hey is there some one can help me to find the registration in th SLQ????? and find the usertype?????????????? can you plss give me a sample picture....................... i'm done whit he data base only the creating account is my problem!!!!!!!!!!!!!!! help plssssssssssssssssssssssssss!!!!!!!!!!!!!!!
@Crainon23
Last warning! You can always use the edit button if you "mistakenly" posted non-english content. And for your problem, the easiest fix would be setting up RanCP, it's just easy, just follow the guide carefully. And you'll be good in no time.
what the hell..this is the guide i want..thanks :drinks_noQuote:
Originally Posted by austhistikated
...and what server files i need? sry im noobie...just the client?can i use 123Ran-EP6?
you can find that in the first page of this thread=)Quote:
Originally Posted by shuyina