Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 14:40

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Help Thread] Please post your questions here.

Reply
 
Old   #3646
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by siegemaster223 View Post
No one has ever taught me how to use SQL or even where to get a free copy
You won't be able to do anything on the server without SQL. If you don't know how to use it you should learn it first. There are a lot of Documentations about the Rappelz Tables in this section but you won't be able to understand them without a little bit of knowledge about the SQL Syntax.

You should do/read some SQL tutorials in the internet and come back to rappelz after that.

If you don't have a SQL Server you won't be able to setup a rappelz server.




c1ph3r is offline  
Old   #3647
 
elite*gold: 0
Join Date: Dec 2013
Posts: 31
Received Thanks: 1
Quick question

when i try to open my file arcadia.conents.sql i get an error message saying not enough room available? im new and have no clue what im doing i just want to open the database up for my first time


siegemaster223 is offline  
Old   #3648
 
elite*gold: 0
Join Date: Nov 2009
Posts: 303
Received Thanks: 30
Quote:
Originally Posted by tokesbowls View Post
Thank you very much, But seems we are on the hunt for these:

devil_astaroth_lv1_top.nx3
devil_astaroth_lv1_middle.nx3
devil_astaroth_lv1_damage.nx3
devil_astaroth_lv1_etc.nx3
astaroth_hand.DDS

If anyone is able to help out, would be much thanks.

Bump
tokesbowls is offline  
Old   #3649
 
elite*gold: 0
Join Date: Sep 2012
Posts: 62
Received Thanks: 3
Boars Ring

Could someone please help with the codes for the boars rings

Thanks


Domesday Brock is offline  
Old   #3650
 
elite*gold: 0
Join Date: Aug 2014
Posts: 6
Received Thanks: 0
hi, where can find the list of the personage in txt ?
impschou is offline  
Old   #3651
 
elite*gold: 0
Join Date: Jun 2014
Posts: 6
Received Thanks: 3
Hiho, my question is very easy.
I´m GM from Echion (Release should be 31.08.14)
I am in a position to change anything on the server, but after the changes I have to reboot the server.

My question is:
I cannt shut down the server manually, I have to do it with gm comands.
How does it work?

I read many variations of spelling

/shutdown
$shutdown
#shutdown
/set shutdown
$set shutdown
#set shutdown

what should i write?

Thanks for help
Zerorx is offline  
Old   #3652
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Ingame:

/run shutdown(300)
This will shutdown your server in 300 seconds

Gameserver Consol
#shutdown(300)
This will shutdown your server in 300 seconds
c1ph3r is offline  
Thanks
1 User
Old   #3653
 
elite*gold: 0
Join Date: Jun 2014
Posts: 6
Received Thanks: 3
Can i also restart the server or only shutdown and wait until the servermaster is at home to start again?
Zerorx is offline  
Old   #3654
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
You can you only have to setup one of the several restart tools that are released in this section.



XAdmin Tool from Xijezu is able to restart a server.
c1ph3r is offline  
Old   #3655
 
elite*gold: 0
Join Date: Jan 2008
Posts: 97
Received Thanks: 61
Anyone to the download link for client Rappelz ph 8.1 please
soleil is offline  
Old   #3656
 
elite*gold: 0
Join Date: Aug 2013
Posts: 32
Received Thanks: 3
Clean 8.1 Client Files

Hi Guys and thank for this Thread!!

First to say is, thanks for the good [HOW to] Create a Rappelz Server Thread.

I set up my privat server, one to one from the [How To] Thead, and the server runs great on my local machine.

My question now is:
Where can i get clean 8.1 Client Files?

At the ent from the How to Thread it says: You can use the Offical Client of your country.

It dosen't work. I think it's course of Rappels Offi is now at 8.3 and has newer files, for what i need?!?

First problem is, that cant see any NPC and my Equip. All of them are invisible.
I only see my head, my hands and my shoes.

At the NPC i only see that there is the exclemation mark -> [!] but no NPC.


If i use Several Clients from existing P-Server's i have other bugs like new NPC's i cant use, course of other Server Files i dont have, or everywhere in Rappelz there stand Christmas Trees i dont wannna have in it.


I just want to have a clean Rappelz Client like the Offical Servers to play for fun on my local PC with my Friend at some days.

Its enough for us to raise the exp rate a litte bit in the gameserver.opt to play on this simple server.

How ca i create or where can i get the clean client files without anything else, unless containing the offical rappelz server stuff like standard npc's and the standard quests like hq1+2 and mc quest and all standard like ek and Kainen Quest series??


Thanks for your help with my problem!

Edit:
I don't know if i could post it, but i find a download for Rappelz Epic 8.1 Client (German) Size: 2.09GB on Gam**Helldotcom. Befor i will download this file i will ask u, can u tell me that this Client is the right one to download for my Server?

Edit2:
It makes me sad. My Friend donwloaded the File an we have now install it. Its a Rappelz 8.1 Setup but after install and copy the Launcher.bat and SFrame.exe game Crash after starting the Launcher.bat.

"Beim Ausführen des Spieleclients ist ein unerwarteter Fehler aufgetreten ... "

If i try to update the Client, the update on Laucher.exe crashes after downloading a new Launcher.exe severeal times course of wrong Launcher.exe size. (Green Screen)

Pleas help!!
Laladumdum is offline  
Old   #3657
 
elite*gold: 0
Join Date: Jan 2013
Posts: 72
Received Thanks: 5
Hi, just want to ask you, i sucess in adding 9.1 weapons on my local database but with the resource i use, when they are +20, i don't see the effect of the normal +20.

This is a picture to explain my problem : I just want to know, what is the name of the resource(s) wich support this effect.



Thanks

Kuro

Update : I found it

New problem xD :

I making the circus dungeon instance. So it's work for the instance but when i log out when i'm in the circus i'm not warp to default point as in underground. Possible to explain me how fix it please ? Thanks

Edit : Found too
cece1812 is offline  
Old   #3658
 
elite*gold: 0
Join Date: Jul 2014
Posts: 31
Received Thanks: 26
Looking for help from one of the greats.

I am working on an NFS Editor for a personal project, I have largely gotten it to work. I can read all four data-sections inside NFS (locations, locationScripts, actors, actorScripts) But the NPC ID (as short is unrecognizable -- at-least I can't connect it to anything) and of you read it as int the number is large and even more unrecognizable.

The place I need help is with actors. (actorScripts borrows the id, just for my purposes)

Here is the NFS.cs I am using to load the NFS (any help is appreciated)

Code:
class NFS
    {
        static NFS instance;

        public static NFS Instance
        {
            get
            {
                if (instance == null)
                {
                    instance = new NFS();
                }

                return instance;
            }
        }

        struct location
        {
            public int left { get; set; }
            public int top { get; set; }
            public int right { get; set; }
            public int bottom { get; set; }
        }

        struct locationScript
        {
            public int regionIndex { get; set; }
            public int propCount { get; set; }
            public int trigger { get; set; }
            public int scriptSize { get; set; }
            public string script { get; set; }
        }

        struct actor
        {
            public short id { get; set; }
            public int x { get; set; }
            public int y { get; set; }
            public short modelId { get; set; }
            public int scriptCount { get; set; }
        }

        struct actorScript
        {
            public short actorId { get; set; }
            public int trigger { get; set; }
            public int scriptSize { get; set; }
            public string script { get; set; }
        }

        PropertyInfo[] locationProperties = typeof(location).GetProperties();
        PropertyInfo[] locationScriptProperties = typeof(locationScript).GetProperties();
        PropertyInfo[] actorProperties = typeof(actor).GetProperties();
        PropertyInfo[] actorScriptProperties = typeof(actorScript).GetProperties();

        string fileSignature = null;
        int fileVersion = 0;
        int locationOffset = 0;
        int scriptOffset = 0;
        int actorOffset = 0;

        BinaryReader br;
        BinaryWriter bw;

        string errorMessage = null;

        public DataSet PrepareTables()
        {
            DataSet ds = new DataSet();
            bool hasData = false;

            try
            {
                DataTable locationTable = new DataTable();
                locationTable.TableName = "locations";
                DataTable functionTable = new DataTable();
                functionTable.TableName = "locationScripts";
                DataTable actorTable = new DataTable();
                actorTable.TableName = "actors";
                DataTable actorScriptTable = new DataTable();
                actorScriptTable.TableName = "actorScripts";

                foreach (PropertyInfo property in locationProperties)
                {
                    locationTable.Columns.Add(property.Name, property.PropertyType);
                }

                hasData = locationTable.Columns.Count > 0;

                if (hasData)
                    ds.Tables.Add(locationTable);
                

                foreach (PropertyInfo property in locationScriptProperties)
                {
                    functionTable.Columns.Add(property.Name, property.PropertyType);
                }

                hasData = functionTable.Columns.Count > 0;

                if (hasData)
                    ds.Tables.Add(functionTable);

                foreach (PropertyInfo property in actorProperties)
                {
                    actorTable.Columns.Add(property.Name, property.PropertyType);
                }

                hasData = actorTable.Columns.Count > 0;

                if (hasData)
                    ds.Tables.Add(actorTable);

                foreach (PropertyInfo property in actorScriptProperties)
                {
                    actorScriptTable.Columns.Add(property.Name, property.PropertyType);
                }

                hasData = actorScriptTable.Columns.Count > 0;

                if (hasData)
                    ds.Tables.Add(actorScriptTable);
                
                if (ds.Tables.Count > 0)
                {
                    return ds;
                }
                else
                {
                    return null;
                }
            }
            catch (Exception ex)
            {
                errorMessage = ex.Message;
                return null;
            }
        }

        public DataSet Read(string loadPath)
        {
            br = new BinaryReader(File.Open(loadPath, FileMode.Open, FileAccess.Read, FileShare.Read));

            DataSet tableCollection = PrepareTables();

            //Read Signature
            fileSignature = Encoding.Default.GetString(br.ReadBytes(16));
            fileVersion = br.ReadInt32();
            locationOffset = br.ReadInt32();
            scriptOffset = br.ReadInt32();
            actorOffset = br.ReadInt32();

            //Read Locations
            int locationCount = br.ReadInt32();

            for (int currentLocation = 0; currentLocation < locationCount; currentLocation++)
            {
                tableCollection.Tables[0].Rows.Add(readLocation(tableCollection.Tables[0].NewRow(), br));

                br.ReadInt32();
            }

            //Read Location Scripts
            locationCount = br.ReadInt32();

            for (int currentLocation = 0; currentLocation < locationCount; currentLocation++)
            {
                tableCollection.Tables[1].Rows.Add(readLocationScript(tableCollection.Tables[1].NewRow(), br));
            }

            //Read Props
            int propCount = br.ReadInt32();

            if (propCount > 0)
            {
                for (int currentFunction = 0; currentFunction < propCount; currentFunction++)
                {
                    DataRow propRow = readActor(tableCollection.Tables[2].NewRow(), br);

                    tableCollection.Tables[2].Rows.Add(propRow);

                    short propId = (short)propRow["id"];
                    int propScriptCount = (int)propRow["scriptCount"];

                    if (propScriptCount > 0)
                    {
                        List<DataRow> rowCollection = readActorScript(propId, propScriptCount, tableCollection.Tables[3].NewRow(), br);

                        foreach (DataRow row in rowCollection)
                        {
                            tableCollection.Tables[3].Rows.Add(row);
                        }
                    }
                }
            }

            return tableCollection; 
        }

        public DataRow readLocation(DataRow newRow, BinaryReader br)
        {
            bool brInitialized = br != null;

            if (brInitialized)
            {
                for (int currentProperty = 0; currentProperty < locationProperties.Length; currentProperty++)
                {
                    PropertyInfo property = locationProperties[currentProperty];

                    if (property.PropertyType == typeof(int) || property.PropertyType == typeof(Int32))
                    {
                        newRow[currentProperty] = br.ReadInt32();
                    }
                }               
                
                return newRow;
            }
            else
            {
                //br init error
                return null;
            }
        }

        public DataRow readLocationScript(DataRow newRow, BinaryReader br)
        {
            bool brInitialized = br != null;
            int scriptSize = 0;

            if (brInitialized)
            {

                for (int currentProperty = 0; currentProperty < locationScriptProperties.Length; currentProperty++)
                {
                    PropertyInfo property = locationScriptProperties[currentProperty];

                    if (property.PropertyType == typeof(int) || property.PropertyType == typeof(Int32))
                    {
                        if (property.Name == "scriptSize")
                        {
                            scriptSize = br.ReadInt32();
                            newRow[currentProperty] = scriptSize;
                        }
                        else
                        {
                            newRow[currentProperty] = br.ReadInt32();
                        }
                    }
                        
                    if (property.PropertyType == typeof(string))
                    {
                        newRow[currentProperty] = Encoding.Default.GetString(br.ReadBytes(scriptSize));
                    }
                }
                
                return newRow;
            }
            else
            {
                //br init error
                return null;
            }
        }

        public DataRow readActor(DataRow newRow, BinaryReader br)
        {
            bool brInitialized = br != null;

            if (brInitialized)
            {
                for (int currentProperty = 0; currentProperty < actorProperties.Length; currentProperty++)
                {
                    PropertyInfo property = actorProperties[currentProperty];
                        
                    if (property.PropertyType == typeof(short))
                    {
                        if (property.Name == "id")
                        {
                            newRow[currentProperty] = br.ReadInt16();
                            br.ReadInt16();
                        }
                        else
                        {
                            newRow[currentProperty] = br.ReadInt16();
                        }
                    }

                    if (property.PropertyType == typeof(int))
                    {
                        if (property.Name == "x" || property.Name == "y")
                        {
                            newRow[currentProperty] = (int)(br.ReadSingle() / 5.25f);
                        }
                        else
                        {
                            newRow[currentProperty] = br.ReadInt32();                       
                        }
                    }
                }
                
                return newRow;
            }
            else
            {
                return null;
            }
        }

        public List<DataRow> readActorScript(int actorId, int scriptCount, DataRow newRow,  BinaryReader br)
        {
            bool brInitialized = br != null;
            int scriptSize = 0;

            if (brInitialized)
            {
                List<DataRow> rowCollection = new List<DataRow>();

                for (int currentScript = 0; currentScript < scriptCount; currentScript++)
                {
                    DataRow outRow = newRow.Table.NewRow();

                    for (int currentProperty = 0; currentProperty < actorScriptProperties.Length; currentProperty++)
                    {
                        PropertyInfo property = actorScriptProperties[currentProperty];

                        if (property.PropertyType == typeof(short))
                        {
                            if (property.Name == "actorId")
                            {
                                outRow[currentProperty] = actorId;
                            }
                        }

                        if (property.PropertyType == typeof(int))
                        {
                            if (property.Name == "scriptSize")
                            {
                                scriptSize = br.ReadInt32();
                                outRow[currentProperty] = scriptSize;
                            }
                            else
                            {
                                outRow[currentProperty] = br.ReadInt32();
                            }
                        }

                        if (property.PropertyType == typeof(string))
                        {
                            outRow[currentProperty] = Functions.byteConverter.BytesToString(br.ReadBytes(scriptSize));
                        }
                    }

                    rowCollection.Add(outRow);
                }

                return rowCollection;
            }

            return null;
        }

        public bool Save(string savePath)
        {
            return false;
        }
    }
Currently the script yields the following for actors:

Screenshot

The first npc id should be 2009, but as you can see it is not
undergroundtaffy is offline  
Old   #3659
 
elite*gold: 0
Join Date: Jun 2011
Posts: 10
Received Thanks: 0
hi guys
i need ur help
i use royal repack 8.1/8.2

i get some weird names of soul pets skills, enhanced altered pieces, soul taming card and royal npc that appear like "?¯¼?¼?´?¸?°???:µ¥¹?"

im grateful for any help i can get
rkiouak is offline  
Old   #3660
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,045
Received Thanks: 979
Are you using the resources that came with the repack?

What client did you happen to pick to run with the repack?


ThunderNikk is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
stucked on anything while setuping your server? post your problem here and you will get answer as fast as possible better than spamming with posts...
31 Replies - EO PServer Hosting



All times are GMT +2. The time now is 14:40.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.