Printable View
hey guys i get this error when i execute RanGame1_2k5
I'm not sure if this would be an issue with my installation but all other dbs execute just fine.Code:DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 207, Level 16, State 1, Procedure sp_DeletePet, Line 0
Invalid column name 'PetDeleted'.
@QuickSilver
You need to Add a Coulumn PetDelete in your Pet DB.
:drinks_dr
help me pls look all went ok but when i open the field server
always came out
Service Provider:IANZ SERVER
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
User DB Open OK
Game DB Open OK
Log DB Open OK
Shop DB Open OK
Database Thread Create OK
Log Database Thread Create OK
User Database Thread Create OK
--------------- System Information -------------------
Microsoft Windows XP
Pentium III processor 2003 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
[IaNz Server] Start
its stops and
after i run field server this comes out
---------------------------
---------------------------
ERROR
---------------------------
Need New version Exe File!
---------------------------
OK
---------------------------
i just dowload ianz file
when i open GMCharEdit.exe GM ID and Password cames out how can i know the GM id and the password
to know the ID and pass go to sql server managementQuote:
Originally Posted by arielugose
expand databases
expand RanUser
expand tables
ryt click the chainfo
click open table then you will see all the info's there
remember that if you want to make it a GM account
set the user type into 32
and 1 for normal characters
correct me if i'm wrong
help me about this....
can i have a screenshots.....
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
what's next in GmCharEdit
Attachment 58859
right click dbo.servergroup
then click open table
then apply what ian said
ok thanx!..
how can i create a character for GM? my launcher wont start...
what should i do??
plss help me..
almost done... ^_^
@dashuelQuote:
Originally Posted by dashuel
better to READ this before Posting, http://forum.ragezone.com/showthread.php?t=458190
:drinks_dr
to create a GM charQuote:
Originally Posted by dashuel
go to sql again
RanUser>>Tables>>ryt click the UserINfo>>find the user type
make it 32
that's all
pls help when i open the GMCharEdit.exe
warning came out
---------------------------
Warning !
---------------------------
m_pBuffer Not enough file. Line : 366 ( over char number : 1024 )
---------------------------
OK
---------------------------
---------------------------
Warning !
---------------------------
m_pBuffer Not enough file. Line : 584 ( over char number : 1024 )
---------------------------
OK
---------------------------
People avoid double posting!.
oh srry i saw the post in help but where can i download the old GMCharEdit i dont have the file because when i use the ianz file when i open GMCharEdit.exe always say open db faild
@arielugose
bro, if you are running ep3 Server, then you encounter the Open DB Failed after opening GMCharEditor, then it means you need to Config/Re-Config your ODBC Settings theres a Flash Video Guide on how to Set Up your ODBC, and you need to Set Up the dbo.ServerGroup and dbo.ServerInfo at your SQL.
Now if you are running ep4/5 Server, its normal to encounter that m_pBuffer when you are using EP4 Files and GMCharEditor, because GMCharEditor its for only EP3. BUT! There is a Guide Posted by bro Micheal2k10 on how to Use the GMCharEdit into the EP4/5 Search for it bro.
:drinks_dr
Heads up: Before re-configuring the gmcharedit, delete gmcharedit.cfg first then reconfigure again.
@sir AusthistikateDQuote:
Originally Posted by austhistikated
Thanks for the Correction, ^^ yah b4 Re-Config delete the GMCharEdit.cfg 1st! ^^. tsuri!
:drinks_dr
sir ano po gagawin ko lumalabas pag maglologin na ako system error caused in log in fail. newbie po me sa gani2 eh at ano po gagawin ko doon sa GMchar edit. laging log in failed T_T
using the jamu ran client po
knight1021 please post in english!
sorry for that i used Filipino since most of the people checking this is pinoys
can anyone help me on how to fix the "System Error Caused in Login Fail" Im using the Jamu-ran Client (EP3-EP4) i think. And why does the GM Char Edit dosent log in it always says that Login Fail .
@Knight1021
if you are using JamuRan then use EP3 DB dont use the EP4 DB.
:drinks_dr
Im using the one supplied here this one to be specific
Creating New Database
For SQL Express 2005
1. on SQL Server Script Open your RanGame1.sql, SQL Management Studio
will open automatically.
2. Press Connect..
3. then Press Execute[!], wait until analyzing is complete.
Using this Files
SQL Script Database for using SQL Express 2005
Download Here - updated
4. Refresh on database.
5. Same on RanLog.sql, RanShop.sql and RanUser.sql
Help bout my odbc settings. I used ianotida's automatic registry setup. I merge it already. SQL 2005. Im using ms sql 2005. But I think there's an error to that automatic setup. Here's the error when i configure it.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Please help me about this problem.
Service Provider:IANZ SERVER
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
ERROR:SQLConnect Failed
ERROR:User DB Open Error
Stop IOCP
Stop Message Queue
Stop DataBase
Stop CFG
=======================================================
Server Stop OK
=======================================================
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
I keep getting this error for the session server. Guide please.
try configuring your ODBC settings manually dude that might help and make sure that you refer to the correct path for your SQL Server.Quote:
Help bout my odbc settings. I used ianotida's automatic registry setup. I merge it already. SQL 2005. Im using ms sql 2005. But I think there's an error to that automatic setup. Here's the error when i configure it.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Please help me about this problem.
Service Provider:IANZ SERVER
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
ERROR:SQLConnect Failed
ERROR:User DB Open Error
Stop IOCP
Stop Message Queue
Stop DataBase
Stop CFG
================================================== =====
Server Stop OK
================================================== =====
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
I keep getting this error for the session server. Guide please.
ODBC-->Add SQL Native Client-->(name)RanGame1-->(server)FEHJSOFT-D6BCA5-->(loginId)sa-->(pword)1234-->
then this error
[Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
'What does this means?
'Please help me..
when you enter your odbc settings for your SQL server make sure that you put in the correct server instance on the last field in your caseQuote:
Originally Posted by bloodshed`48
FEHJSOFT-D6BCA5\SQLEXPRESS
Mga tol patulong naman po...please send me naman ng step by step guide to make my own server.
Translation:
Guyz help please, please send me a step by step guide on how to make my own server.
