yeah add me eliezer_rabadon@yahoo.com
Printable View
yeah add me eliezer_rabadon@yahoo.com
PHP Code:Service Provider:IANZ SERVER
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
USER DB Open OK
Log DB Open OK
Database Thread Create OK
--------------- System Information -------------------
Microsoft Windows XP
Pentium 4 processor 3023 Mhz
1 System Processor Detected
------------------------------------------------------
2 Worker Thread
1 st Worker Thread Create OK
2 st Worker Thread Create OK
Server Update Thread Create OK
WSASocket OK
Bind OK
127.0.0.1:5003
Server Accept Thread Create OK
=======================================================
Server Start OK
=======================================================
(Client ID:100) (127.0.0.1:1102)
(Client ID:101) (127.0.0.1:1129)
(Client ID:102) (127.0.0.1:1154)
MsgSndCurSvrInfo 127.0.0.1
MsgSndCurSvrInfo 127.0.0.1
MsgSndCurSvrInfo 127.0.0.1
MsgSndCurSvrInfo 127.0.0.1
DB:{call log_serverstate(0,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(0,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(0,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(0,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(1,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(1,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(1,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(1,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(1,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(1,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(1,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(1,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(1,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(1,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(1,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
(Client ID:103) (127.0.0.1:1336)
MsgSndCurSvrInfo 127.0.0.1
MsgSndCurSvrInfo 127.0.0.1
MsgSndCurSvrInfo 127.0.0.1
(Client ID:104) (127.0.0.1:1358)
MsgSndCurSvrInfo 127.0.0.1
MsgSndCurSvrInfo 127.0.0.1
MsgSndCurSvrInfo 127.0.0.1
MsgSndCurSvrInfo 127.0.0.1
DB:{call log_serverstate(0,131,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
I CAN'T LOG IN TO THE GAME AND GMCHAR EDIT y??
How Can I fix IT?
Check IPs!
You need the log_serverstate stored procedure..Quote:
Originally Posted by asura12
Here's my stored procedure for log_serverstate...
Just execute this on your SQL...
And tell me what happens next...
Code:USE RanUser
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE Procedure [dbo].[log_serverstate]
@usernum int,
@usermax int,
@svrnum int,
@sgnum int
AS
SET NOCOUNT ON
INSERT INTO LogServerState (UserNum, UserMaxNum, SvrNum, SGNum)
VALUES (@usernum, @usermax, @svrnum, @sgnum)
SET NOCOUNT OFF
how do you convert text into md5 hash?
Try online conversions...
Google will help you alot...
What does this error do [2008-08-01T17:11:46] [INTERFACE] INVENTORY_PAGE_WEAR_ARMS not found and how do i fix it?
@austhistikated
where can i paste i in RanUser?
or Just in SQL?
Sir Can You Help Me..
when i click my gmcharedit it say`s User DB open failed..
plzzz help me .....
u can use md5 converter from bro ianzQuote:
Originally Posted by myil
hi! can u share ur sql database ?
please
It's on the first page =.-'..
Try to read more, Asura.
on page one it has error!!!
what error ?
please don't post incomplete sentence/taught cause it can spam
im creating my first ranCP im using hamatchi with DB mssql windows autintication mode i got this error can someone help me to resolve this.....
Warning: mssql_connect(): message: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (severity 14) in C:\Program Files\Abyss Web Server\htdocs\rancp\function.php on line 37
Warning: mssql_connect(): Unable to connect to server: C1770FEA2F244D2\SQLEXPRESS in C:\Program Files\Abyss Web Server\htdocs\rancp\function.php on line 37
Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:\Program Files\Abyss Web Server\htdocs\rancp\function.php on line 38
Look for the FAQ sticky budhabils...
It has a fix for that...
dont login with win auth mode..... use SQL AUTHENTICATIONQuote:
Originally Posted by budhabils
Yup,
But you need to be Mixed in msSQL...
/Seraph\
Does it work with SQL 2000?
yah it works
ran server works in sql2k5 and sql2k
When i tried to run .sql file, i always meet error. I'm using SQL 2K.
http://img158.imageshack.us/img158/9100/95720143gp1.jpg
This error appears when i run RanGame1.sql.....The same error appears when i run the others.
........ ^^ use MSSQL 2005....
where should i put this code? pls instruct me where?Quote:
Originally Posted by austhistikated
and in GMCharEdit i entered my gm id and password and click ok it works,,,
my problem is after i select (0:0)Ran Server and click ok
this error appeared "Game DB Open Failed"
what should i do to fix this?
Open Microsoft SQL Studio Express - > Log In - > Click Query ToolBar - > Paste the Code
Sincerely,
-Flow
Quote:
Originally Posted by SeraphiPod
i did your advise but this error appeared
"Msg 2714, Level 16, State 3, Procedure log_serverstate, Line 13
There is already an object named 'log_serverstate' in the database."
(fyi im using MSQL 2005) what should i do? and by the way thanks for the reply.