[Help Thread] Please post your questions here.

[imnowlearn]

Hi, i need cash shop and register website script please

[blackcs12]

how can i set a password to sa or even use another login account with auth and game server opt and what kind of password can i use i tried to put a hash or even md5 in the password in opt but i cant login i get auth failed to login to sa ?

[ThunderNikk]

Pyroks password generator is used for the SQL passwords encrypted in the .opt files.

You set them up in the SQL server in user management as plain text.

Then use Pyroks password generator for a des hash on the password to put in the .opt files and compress the .opt files again.

[hassuny]

Hello guys

I need the databases for official server files 8.1 & 9.1 as scripts not .Bak file >> please in SQL-Format

[kojima2501]

hi all =)

now i try to auto update my client but nothing updated ..//

i add some screen and full code (by TheChinStrap)


code:

 Spoiler

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Net;
using System.Runtime.InteropServices;
using System.Text;
using System.Windows.Forms;
using System.Xml.Linq;
using Ionic.Zip;

namespace Launcher_v2
{
    public partial class Form1 : Form
    {

        public const int WM_NCLBUTTONDOWN = 0xA1;
        public const int HT_CAPTION = 0x2;

        [DllImportAttribute("user32.dll")]
        public static extern int SendMessage(IntPtr hWnd,
                         int Msg, int wParam, int lParam);
        [DllImportAttribute("user32.dll")]
        public static extern bool ReleaseCapture();

        public Form1()
        {
            InitializeComponent();

            //Download progress
            backgroundWorker1.RunWorkerAsync();

            strtGameBtn.Enabled = false;

        }

        //Makes the form dragable
        private void Form1_MouseDown(object sender,
        System.Windows.Forms.MouseEventArgs e)
        {
            if (e.Button == MouseButtons.Left)
            {
                ReleaseCapture();
                SendMessage(Handle, WM_NCLBUTTONDOWN, HT_CAPTION, 0);
            }
        }

        //Close Button
        private void closeBtn_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void closeBtn_MouseEnter(object sender, EventArgs e)
        {
            closeBtn.BackgroundImage = Properties.Resources.close2;
        }

        private void closeBtn_MouseLeave(object sender, EventArgs e)
        {
            closeBtn.BackgroundImage = Properties.Resources.close1;
        }

        //Minimize Button
        private void minimizeBtn_Click(object sender, EventArgs e)
        {
            this.WindowState = FormWindowState.Minimized;
        }

        private void minimizeBtn_MouseEnter(object sender, EventArgs e)
        {
            minimizeBtn.BackgroundImage = Properties.Resources.minimize2;
        }

        private void minimizeBtn_MouseLeave(object sender, EventArgs e)
        {
            minimizeBtn.BackgroundImage = Properties.Resources.minimize1;
        }

        //Delete File
        static bool deleteFile(string f)
        {
            try
            {
                File.Delete(f);
                return true;
            }
            catch (IOException)
            {
                return false;
            }
        }
        

        //background Worker: Handles downloading the updates
        private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
        {
            //Defines the server's update directory
            string Server = "http://127.0.0.1:8080/";

            //Defines application root
            string Root = AppDomain.CurrentDomain.BaseDirectory;

            //Make sure version file exists
            FileStream fs = null;
            if(!File.Exists("version"))
            {
                using (fs = File.Create("version"))
                {

                }

                using (StreamWriter sw = new StreamWriter("version"))
                {
                    sw.Write("1.0");
                }
            }
            //checks client version
            string lclVersion;
            using (StreamReader reader = new StreamReader("version"))
            {
                lclVersion = reader.ReadLine();
            }
            decimal localVersion = decimal.Parse(lclVersion);


            //server's list of updates
            XDocument serverXml = XDocument.Load(@Server+"Updates.xml");

            //The Update Process
            foreach (XElement update in serverXml.Descendants("update"))
            {
                string version = update.Element("version").Value;
                string file = update.Element("file").Value;

                decimal serverVersion = decimal.Parse(version);


                string sUrlToReadFileFrom = Server + file;

                string sFilePathToWriteFileTo = Root + file;

                if (serverVersion > localVersion)
                {
                    Uri url = new Uri(sUrlToReadFileFrom);
                    System.Net.HttpWebRequest request = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(url);
                    System.Net.HttpWebResponse response = (System.Net.HttpWebResponse)request.GetResponse();
                    response.Close();

                    Int64 iSize = response.ContentLength;

                    Int64 iRunningByteTotal = 0;

                    using (System.Net.WebClient client = new System.Net.WebClient())
                    {
                        using (System.IO.Stream streamRemote = client.OpenRead(new Uri(sUrlToReadFileFrom)))
                        {
                            using (Stream streamLocal = new FileStream(sFilePathToWriteFileTo, FileMode.Create, FileAccess.Write, FileShare.None))
                            {
                                int iByteSize = 0;
                                byte[] byteBuffer = new byte[iSize];
                                while ((iByteSize = streamRemote.Read(byteBuffer, 0, byteBuffer.Length)) > 0)
                                {
                                    streamLocal.Write(byteBuffer, 0, iByteSize);
                                    iRunningByteTotal += iByteSize;

                                    double dIndex = (double)(iRunningByteTotal);
                                    double dTotal = (double)byteBuffer.Length;
                                    double dProgressPercentage = (dIndex / dTotal);
                                    int iProgressPercentage = (int)(dProgressPercentage * 100);

                                    backgroundWorker1.ReportProgress(iProgressPercentage);
                                }

                                streamLocal.Close();
                            }

                            streamRemote.Close();
                        }
                    }

                    //unzip
                    using (ZipFile zip = ZipFile.Read(file))
                    {
                        foreach (ZipEntry zipFiles in zip)
                        {
                            zipFiles.Extract(Root + "\\Resource\\", true);
                        }
                    }

                    //download new version file
                    WebClient webClient = new WebClient();
                    webClient.DownloadFile(Server+"version.txt", [MENTION=284679]Root[/MENTION]+"version");

                    //Delete Zip File
                    deleteFile(file);
                }
            }
        }

        private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
        {
            progressBar1.Value = e.ProgressPercentage;
            downloadLbl.ForeColor = System.Drawing.Color.Silver;
            downloadLbl.Text = "Downloading Updates";
        }

        private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
        {
            strtGameBtn.Enabled = true;
            this.downloadLbl.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(121)))), ((int)(((byte)(203)))));
            downloadLbl.Text = "Client is up to date";
        }


        //Starts the game
        private void strtGameBtn_Click(object sender, EventArgs e)
        {
            Process.Start("SFrame.exe", "/auth_ip: 127.0.0.1 /locale:ASCII /country:US /cash /commercial_shop");
            this.Close();
        }

        private void patchNotes_DocumentCompleted(object sender, WebBrowserDocumentCompletedEventArgs e)
        {

        }
    }
}

i use in patch Url

Screen:

 Spoiler

my launcher work perfectly for play // Version in client stay 1.0 and 0 add in resource... this is one local test for this moment ^^

i hope anyone have solution thx for ur help

[ThunderNikk]

Make sure the zip file is named correctly V1-1.zip and not V1.1.zip in your updates folder.

Make sure you have an Updates folder in the root of your server.

Server update directory path in the launcher should lead to your updates folder...

[KingsMan0]

help me Server 7.3

I want rdb manger 7.3 Now Very necessary


Please help me

[ThunderNikk]

Try out this one...



Thanks to Smoky for his work.

[LuXorioN]

Sup everyone. Im struggeling since few hours to get correct offsets for db_item.rdb (Epic 9.4) - Somehow i cant seem to get it working properly.
Do you guys have any suggestions / solutions ? Didnt had these issues on other rdb files. only item.rdb is kicking my head off.

my thought is that im skipping some values by doing seekg of 6200 bytes.
its loading perfectly until it reads the rank value.

void ItemResource::LoadEntitys( std::fstream& pRDBFile, eItemResource data[] )
{
	pRDBFile.read((char *)&data[0].id, 4);
	pRDBFile.read((char *)&data[0].name_id, 4);
	pRDBFile.read((char *)&data[0].type, 4);
	pRDBFile.read((char *)&data[0].group, 4);

	pRDBFile.read((char *)&data[0].Class, 4);
	pRDBFile.read((char *)&data[0].set_id, 4);
	pRDBFile.read((char *)&data[0].set_part_flag, 4);
	
	pRDBFile.seekg(1, std::fstream::cur);
	pRDBFile.read((char *)&data[0].rank, 4);
	
	//pRDBFile.seekg(6169, std::fstream::cur);
	pRDBFile.read((char *)&data[0].level, 4);
	
	pRDBFile.read((char *)&data[0].enhance, 4);
	pRDBFile.read((char *)&data[0].socket, 4);
	pRDBFile.read((char *)&data[0].status_flag, 4);
	pRDBFile.read((char *)&data[0].min_level, 4);
}

// Edit: adjusted code.. can anyone say if min_level is 15 for itemid 100001 and max_level 48 ?

[hassuny]

Hello guys

I need the databases for official server files 8.1 & 9.1 as scripts not .Bak file >> please in SQL-Format

[ThunderNikk]

Originally Posted by LuXorioN

Sup everyone. Im struggeling since few hours to get correct offsets for db_item.rdb (Epic 9.4) - Somehow i cant seem to get it working properly.
Do you guys have any suggestions / solutions ? Didnt had these issues on other rdb files. only item.rdb is kicking my head off.

my thought is that im skipping some values by doing seekg of 6200 bytes.
its loading perfectly until it reads the rank value.

void ItemResource::LoadEntitys( std::fstream& pRDBFile, eItemResource data[] )
{
	pRDBFile.read((char *)&data[0].id, 4);
	pRDBFile.read((char *)&data[0].name_id, 4);
	pRDBFile.read((char *)&data[0].type, 4);
	pRDBFile.read((char *)&data[0].group, 4);

	pRDBFile.read((char *)&data[0].Class, 4);
	pRDBFile.read((char *)&data[0].set_id, 4);
	pRDBFile.read((char *)&data[0].set_part_flag, 4);
	
	pRDBFile.seekg(1, std::fstream::cur);
	pRDBFile.read((char *)&data[0].rank, 4);
	
	//pRDBFile.seekg(6169, std::fstream::cur);
	pRDBFile.read((char *)&data[0].level, 4);
	
	pRDBFile.read((char *)&data[0].enhance, 4);
	pRDBFile.read((char *)&data[0].socket, 4);
	pRDBFile.read((char *)&data[0].status_flag, 4);
	pRDBFile.read((char *)&data[0].min_level, 4);
}

// Edit: adjusted code.. can anyone say if min_level is 15 for itemid 100001 and max_level 48 ?

Job_depth for that item is 15 and I couldn't find any value that was 48. Looks like you still have some work to do.

[imnowlearn]

I have problems with skill cards on my server
Their attack points arent proper
How can i fix. my server is epic 7.3

[Sherock]

how to make
set_account_authority( 910000, 2592000 )
works in my 9.1 server ?

[risslove]

hello, guys


(the problem video)

I have a problem that "This item cannot be combined/enchanted"..
and weapons, armors, Cubes , Creature cards same problem.
so..I can't enhance.

What seems to be the problem with it?

(my server is epic 9.1 and 9.1 sframe. It got in )

[Sherock]

Originally Posted by Sherock

how to make
set_account_authority( 910000, 2592000 )
works in my 9.1 server ?

up