GM wanted

Subject: GM wanted Sun 11 Jun 2006, 11:48

We want at least 3 GM from every school.

Number of posts : 2 Age : 45 Registration date : 2006-06-11

Adakah Kehenseman Ini Membawa Kepada Title GameMaster? Hahaha

Number of posts : 2 Age : 39 Registration date : 2006-06-12

HI,

If may be eligible. May I ask if what are the qualifications you are looking for a Game Master? Thanks

Number of posts : 6 Age : 38 Registration date : 2006-06-13

hi admin...........
can i be the gm.............
thx

Number of posts : 6 Age : 38 Registration date : 2006-06-13

i think im going to be in sg school.......

Subject: Re: GM wanted Tue 13 Jun 2006, 23:16

Good english and good knowledge in RAN game.

Someone who can make register online possible, please PM me. Immediate GM will be given.

Subject: Re: GM wanted Thu 15 Jun 2006, 15:26

gm did u still need any gm?

Number of posts : 24 Registration date : 2006-06-15

sry double posted

Number of posts : 24 Registration date : 2006-06-15

A LOT of people have been asking how to set the default level of a new character to 100 (or any level). So here is a MORE EFFECTIVE way to do it...

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

Code:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

-- =============================================
-- Author: James29
-- Create date: 6/15/2006
-- Description: Sets the default level of a NEW CHARACTER
-- =============================================
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

END
6. Execute the SQL Statement.
7. Verify if the SQL Trigger is created by Expanding dbo.ChaInfo tables, expand triggers. If you don't see NewChar_Level trigger under Triggers group, try refreshing your display.

This SQL Trigger has been tested by me and works 100%....

NOTE:
This should serve as your BASIC Template for SQL Triggering... You can do a lot of things with this... You could set the initial Stats, Stat Points, Money, Character Exp, Character Inventory, Character Skills etc. of a NEWLY CREATED CHARACTER... You would just have to be creative and update the SQL Trigger to suit your needs...

I hope this helps you...

credits given to james2930 in ragezone forum
thx you

Subject: Re: GM wanted Thu 15 Jun 2006, 21:23

How nice, might i suggest my friend 1tachi. Although from real ran online im a level 96 Ranger, and he a level 84 swordsman, he has very good knowledge of the interface and also all monsters and maps in ran online so i think he would be very suitable for a GM.
I will try and find a way for a Register page for you guys if you like Razz

One more thing, if you would like advertisments made for this private server you can only ask and it will be done Smile

Subject: Re: GM wanted Fri 16 Jun 2006, 00:52

Suggestion about server are really helping out. Thanks jiacheng1991.

I have now face another 2 problem, a big problem actually.
Our server doesnt have CP and prison.
If any of you can find the solution. Please PM me.
I dont know if it bug or my wrong in including them in SQL.

You can advertise this server to friend, but before you posting it to other forum or web please ask primission from their admin. Smile

GM is currently full, GM requested will be made until one of the GM been expel due to inactiveness and breaking the rules. This topic will be locked until new GM needed.