[Guide]How To Make Your Own Server (EP3)

change ur glogic, glogicserver.

@seraphipod
bro, i already setup my odbc & still can get in to sql server.
anyway ... b4 my head blowup because this sql thing, i re-format my hdd, re-install windoze + sql. now everything back to normal. i play on my server right now.

btw ... sir seraph, i just want to ask a small favor. hope you can help.
as you told me that i can't change map, i unload several maps. but when i try to unload mobs, i can't find any files that contain the mobs span point. can you tell me what to do to unload mobs on the unloaded maps ?

thx

help pls give me a working download link for the client and the version 2 of ianz game.exe

yesterday it was The name has been used,Login failed now.....What's next?
Character Failed to be proccessed??? ahahahahahahhahhahah

Quote:

---

Originally Posted by Ricia

@Seifer13
I know how you feel about that thing and for sure these people are already aware about that. It's sad because RZ Ran Online Development has reached its end but please
let them do their thing. Everything is on record and I think many people can learn from it with a little help of some people who are still willing to stay after that scam.

Thank you for your share and for the information.

---

NO!!!RZ has not reached it's..We will reborn RZ Ran Online Development..So just stick with RZ :poster_ss:poster_ss PEACE ^_^

Quote:

---

yesterday it was The name has been used,Login failed now.....What's next?
Character Failed to be proccessed??? ahahahahahahhahhahah

---

Quote:

---

O!!!RZ has not reached it's..We will reborn RZ Ran Online Development..So just stick with RZ PEACE ^_^

---

Don't Double Post,
Try to check your Cfgs, ips, and ODBC(EDIT: check odbc plz)

pls look this picture

Just click on the .reg file and thats all :jump1:

Great guide, thank you.

oooh, everyone that likes to upgrade their server to ep4
than ep3/ep4..
please read seifer's guide.

thx
..

how to run the gmcharedit or what should i do or open for it to work??

haha ok i know it how to use!! all i need now is a developer sir seraph pls help me i already set my obdc like what you've said=) i will PM you in your YM

:2gunsfiring_v1:

where can i find the latest ran client?can u give the links

how can i get this option???

Trigger Codes (Optional )
=============

Here's the Trigger Code for Starting Character Level,Stats,Skill Points,Money and etc...

HERE ARE THE STEPS...

1. Open/Login you SQL Server Management Studio
2. Expand the Databases Group
3. Expand the RanGame1 Database
4. Select New Query from the toolbar
5. From the New Query window on the right pane, copy and paste this SQL Trigger Code...

Put this code direct to the SQL Query
Open ur SQL Queries then put this code Choose the RanGame1 table
for SQL2005 right click the RanGame1 ,select New Queries

and how did i do int this??

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

-- ================================================== ====
-- Author: IaNz
-- Create date: --,--,--
-- Description: Starting Character Level,Skill and Stat Points
-- Dex,Pow,Int,Vit,Stm and Money
-- Note : If you have existing trigger replace CREATE TRIGGER
-- to ALTER TRIGGER
-- ================================================== ====

CREATE TRIGGER [dbo].[NewChar_Level] ON [dbo].[ChaInfo]
after update
as
BEGIN

Update [ChaInfo] set [ChaInfo].ChaLevel=100
From Inserted
Where Inserted.ChaLevel = 1 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaSkillPoint=1500
From Inserted
Where Inserted.ChaSkillPoint = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaStRemain=1500
From Inserted
Where Inserted.ChaStRemain = 3 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaMoney=1000000
From Inserted
Where Inserted.ChaMoney = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

help me about this error plss..i need you help ..

TITLE: Connect to Server
------------------------------

Cannot connect to JONAS\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

@ray pls read the other threads and don't be a lazy man=)

ok 1 by 1
no one can blame me if I don't double POST
stupid double posters
@ray
no need to do that.

how to make a character?

help me plz

it always pop ups every time i try to make a new database =,=

"TITLE: Connect to Database Engine
------------------------------

Cannot connect to RanGame1.

------------------------------
ADDITIONAL INFORMATION:

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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476"

@bernard pls use ur sixth sense or in short your common sense:scratch:

I got this error....when I excecute ran shop

Msg 1801, Level 16, State 3, Line 2
Database 'RanShop' already exists. Choose a different database name.
Msg 945, Level 14, State 2, Line 1
Database 'RanShop' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RanShop.mdf". Operating system error 2: "2(The system cannot find the file specified.)".
File activation failure. The physical file name "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RanShop_log.ldf" may be incorrect.
Msg 945, Level 14, State 2, Line 1
Database 'RanShop' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RanShop.mdf". Operating system error 2: "2(The system cannot find the file specified.)".
File activation failure. The physical file name "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RanShop_log.ldf" may be incorrect.
Msg 945, Level 14, State 2, Line 1
Database 'RanShop' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 1
Primary log file is not available for database 'RanShop'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 945, Level 14, State 2, Line 3
Database 'RanShop' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.





help me guys...THNX

or you can PM me in YM kayokase_4

resukah
here is a line that i saw maybe your problem

Quote:

---

Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 945, Level 14, State 2, Line 3
Database 'RanShop' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

---

for my suggestion onliy:construct
maybe you should upgrade your specs

or here

did you already set your database in the sql for ranshop,rangame,ranlog and ranuser?


here is the site for how to set sql with screenshots
http://forum.ragezone.com/showthread.php?t=139906/

Originally Posted by ianotida
bro just login in ur Windows Authentication then then Right click RanGame1 , click PROPERTIES, select FILES then change owner to "sa"

same procedure as RanShop,RanLog,RanUser



pano po yan gawin? sorry po bagohan pa kc ako at wla pa po akong dBASE Files, Exel Files at MS Access Database... meron lang po akong RanGame1,RanLog,RanShop and RanUser SQL NATIVE CLIENTS.. pls help po!

@myopia666
add me up in YM
spiritupro@yahoo.com
june 30
i am online
maybe
4:30-5:00 w8 for me

@abry - Offtopic
CAN YOU PLEASE HAVE MY PERMISSION BEFORE INSTALLING SOMEONE TO MY FORUM + SERVER? IT'S FUCKING MAKING ME MAD!!