Seal OFFLINE ( Tutorial Video )

Ini Sudah Saya Tulis Selama 2 jam . -__- wkkwkwk gpp demi share di N3 ..

[InfoAboutServer&Game]

Game name: Seal Online
Server type: Emulator
Server database: MySQL

TOOLS:

Mysql server 5 cari disini
navicat cari disini
Xampp Cari disini
Cara Install nya bisa lihat video dari bang ayief klik disini



Quote:
credit to bang ayief @ snutz.us
video create server dan run server :

download file server
mirror file server

Liat video bang ayief disini

Quote:
credit to bang ayief @ snutz.us
video add user and Run clien :

download client seal china part 1

download client seal china part 2

download client seal china part 3

download client seal china part 4

download client seal china part 5

download client seal china part 6

download client seal china part 7


Code:
password client seal china: ragezone.com
Mirror lewat File Front nihh
http://www.filefront.com/17147766/45...5-27.part1.rar
http://www.filefront.com/17147948/45...5-27.part2.rar
http://www.filefront.com/17147819/45...5-27.part3.rar

krack seal biar bisa Launcher ke server kita

liat video bang ayief disini


Quote:
credit to bang ayief @ snutz.us
Code:
password buat semua tools dan video: klik disini
Quote:
Tutor by ay1ef
script server by omen aka G1G010 aka hackoza ( maaf kalo ada salah tulis huruf huahua)
tutor awal dari www.ragezone.com

masih banyak bug


ini HADIAH THR buat sealover yang ga pernah punya equip dewa...
mangga dicobian...

update lainnya menyusul...nunggu sesepuh benerin dulu...

Quote:
undefined
pas login nya ene...
Quote:
undefined
ini pas milih server...banyak yoo..tapi cuman 1 yg bisa..
Quote:
undefined
nahh ene char saya boss...hahaha
Quote:
undefined
kalo pas milih char muncul kaya gambar ini, berarti belum konek ke host..
kalo ente ada LAN sambungin lahh terus setting IP nya samain yg di ascent-chatserver.conf , ascent-logonserver.conf ama WSDserver.conf
kalo kaga ada LAN bikin Loopback adaptor terus setting kaya LAN biasa..gimana bikinnya loopback?
neh linkna baca dari microsoft
-klik here buat XP
-klik here buat 7
Quote:
undefined
biar bisa dapet item/equip/pet sesuka hati kita silakan edit database inventory pake tools navicat..
hehe kren ya koleksi pet saya..
Quote:
undefined
ada momon di kota Lime...coba ke map atas kota Lime yg ada BahBah ada OHM 2 biji lhooo..wkwkkw
Quote:
undefined
ajib dah equip nya wkwkkw..

ini database char HolyAngel punya saya yg kek di picture diatas.. silakan disedot


CARA EDIT DATABASE inventory + itemID nya...
Quote:
guid = id (di table characters)(jadi liat di table character IDnya char yang kmu pake tuh brp misal "3"
maka di "guid"(tabel invent = "3")
item_id = (ganti sesuka hati misal 433=ruby)
num = (++nya equip/pet/jumlah barang(sampah2)) misal kamu mau buat pet + 9 maka di item_id masukin ID petnya.. trus di num kasi angka "9" = Pet+9
num2 = ga ngerti apaan
a0 sampai a3 = klo itemnya sampah(kaya giranium, pot, russty gear dll, maka a0-a3 nilainya "0"(nol)
klo itemnya equip++/pet++ maka nilainya a0-a3 = "255"
pos = posisi item di slot invent = dimuali dari angka 8 (slot 1)
crc & szid = biasanya semua nilainya "0(nol)"

waduh.. kata2nya ribet ya kk
klo ada salah maap ya...
*ampir lupa.. nih itemIDnya DOWNLOAD
credit to snutzisthebest @ snutz .us

Release Seal offline Map Id
0 = zaid
2 = elim
4 = tempatnya Joan dan kawan2
5 = hilir sungai glasis
6 = tahun 315
7 = gunubg travia
8 = lime
10 = tambang clement lt 1
13~18 = madelin
15 = hutan cross , hilir sungai glasis
16 = kuburan bawah tanah
17 = hutan laywook barat
18 = kuil adel
19 = lembah travia ( tmpt beli golden shield )
20 = map sevis dalam perbaikan neh :
21 = pelatihan beginner
22 = colloseum
24 = selatan poibus
25 = goa kematian ( kosong doang ga ada isinya )
26~42 = STUCK !
43 = lembah sikara
109 = diding luar lime
110 = hutan laywook timur
111 = hulu singai mimir
112 = daratan glasis
113 = danau cross
114 = barat red soil
115 = timur red soil
116 = Sevis
117 = utara poibus
118 = goa terlarang
119 = pulau terlarang barat
120 = pulau terlarang timur
124 = dimensi gelap
125 = dimensi api
126 = dimensi air
127 = dimensi kayu
128 = dimensi logam
129 = dimensi tanah
130 = dimensi cahaya

Code:
credit to yogaedan and me.
Cara seting jadi GM

ada 2 tipe GM

1. GM master [ bisa memproduksi item dan sebagai nya ] job 15
2. Sub GM [ tidak dapat membuat item ] job 7

1. masuk ke bagian Characters
2. di bagian JOb isi 15

Command GM

*item(spasi)nomor item

jadi misal gini

*item 4059

yang keluar tuh fly dragon+12

*item kodeitem [ contoh ketik *item 4059 ] kode item nya dari 1 sampai 11300 kurang lebih
*monster namamonster [ contoh ketik *monster piya ]
*move iduser [ contoh ketik *move 1 <--id no urut di table login ]
*kill_account
*kill_guild
teleport/pindah map tinggal ketik nama map nya [ contoh ketik 315 ]

by prans / http://celestiaseal.blogspot.com/2010/09/tutorial.html


TAMBAHAN COMMAND GM NEH BUAT PINDAH MAP

Quote:
ini saya tambahkan nama map
buat command GM
kan pada ga bisa toh pindah map pake command GM??
nah pake nama2 map ini

silahkan download via IDWS
1 lagi tambahan GM command

edited**
*gives <code item> (di pake klo mau bikin item sampah aja :P giranium dll)

soalnya item yang di hasilkan jumlahnya 299.. sudah di coba di item equip pet senjata
di databasenya num= 299 (pantasan aja +0

Read more


Seal Offline With Tutorial Picture

Downloads

MySQL Community Server(MySQL Server 5.1)

MySQL GUI Tools

Microsoft Visual C++ 2008 Redistributable Package (x86)

Interface Business update by GoldenAce(Making trade english)

Seals Online Client Mirror 1

Part 1
Part 2

Seals Online Client Mirror 2

Part 1
Part 2

SO3D_2.exe(Client)

Seals Online Clean Files(Not updated, by works)

SQL

Step 1

After downloading those files mentioned above, now we can begin.

We are going to setup Microsoft Loopback Adapter now, so make sure you follow every single step.

Go to Control Panel and click Printer and Other Hardware



Once you are done, click 'Add Hardware'



You should get this if you followed my instructions



Now wait..



Now click, 'Yes, I have already connected to the hardware'.



After clicking Next, you should be able to get this by scrolling down.



After clicking 'Add a new hardware device' and clicking next, you should be able to get..



Now click the 2nd option, and once you are done you should get this and scrolling down to network adapter.



Now click next and select 'Microsoft Loopback Adapter'.



Install and you are almost done.

Now go to Network Connections and right click at your Loopback Adapter and click properties.



Now click 'Internet Protocol(TCP/IP)' and click Properties.

Now click start, click run and type 'cmd'.

Once done, type ipconfig.

Now type your IP Address, subnet and default gateway in the Internet Protocol menu and once done, click Advanced.



Now click add in IP addresses column and add in these followings

IP Address : 192.168.2.8
Subnet Mask : 255.255.255.0



Click OK, restart computer and you are done.




Step 2

Extract Seals Online clean files and Client files.

Download WinRAR here to extract them.

Once done, leave it there and we will proceed to Step 3.

Step 3

Install Microsoft Visual C++ 2008 Redistributable Package (x86), MySQL GUI Tools and MySQL Server 5.1 mentioned in Downloads.

MySQL Server 5.1 Configuration


You should be able to get this once you finish installing.



Click next all the way until Security Option, and type 123456 in both boxes shown.



Now click Next and click Execute.



Now click MySQL Query Browser in MySQL in All Programs in Start.



Now select test, click File -> Open Script at top-left, and select test16.sql mentioned in Downloads.

Select the thunder button(Execute) and begin executing

When you are done, let's start our server!

Now go to server directory.

Click acc_.exe, chat_.exe, 1819.exe and finally 1820.exe.

Once done, go to the client directory, extract interfacebusiness.rar, and replace interface folder in Client directory and finally, replace the client mentioned in downloads in step 1.

Now click the launcher.



Now once done, in the combobox, select the third option.



Hurray, have fun!

(Account name : admin, password : admin)


Credits : Anak Anak Rz ...

Read more


PW OFFLINE WITH Vmware .. ( All By : Ari )

Yang Mau Buat Perfect World Sini
 
Vmware Network Config ;
IP = 10.1.1.9
Netmask = 255.255.255.0
Gateway = 10.1.1.9
DNS = 10.1.1.1

SERVER Files in here:
MUTLIUPLOAD
PART 1
PART 2
PART 3
PART 4

HOTFILE

Here for Client;

HOTFILE

Guide:
1. Install VMware (if You Do not have to try searching in Google)
2. Ekstract Image File
3. Chose an Open Vmware file menu




4. open the image file that has been in ekstract folder


5th. Ram Vmware settings like this (Adjust with the capacity of RAM that you have an example: if your PC 4Gb Of ram u can give 2GB for Vmware)

6. Start Your Vmware
7. Login to Console with User: ROOT | Passwd: aringaso


8. Change IP Vmware By typing in the console

Code:
root @ PW-Server: ~ # nano / etc / network / interfaces

Example: if your PC IP Address like this: 192.168.1.2. and the modem IP is 192.168.1.1 as you can change the IP Vmware like this: 192. 168.1.xx

9. Change Vmware DNS by typing in console

10. Restart your server by typing: reboot or init 6
11. Start pwAdmin Console:. / Tomcat_start.sh
12. Open your browser: http://10.1.1.9:8080/pwAdmin/[/B]



Note:
To open the entire folder, 2GB Ram I do not think it will be enough

14. Login Page: http://10.1.1.9/pw/register
15. Phpmyadmin: http://10.1.1.9/phpmyadmin
16. adminer: http://10.1.1.9/adminer

Read more


RF Server File 2.2.3 ( BSB ) + Tutorial Full

Buat yang mau Bikin Private Server RF Online atau hanya untuk LAN network dengan versi RF server 2.2.3 (Bellato Strike Back)

saya Sharing nih File2nya.

Sebagian File ini adalah milik Magenik @ Ragezone.com.
karena File nya di upload di rapidshare dan terdapat limit download disana, maka untuk para Nyit2ers, saya sudah download dan saya Share melalui FTP lokal.

File : Emulator RF 2.2.3 + Script + Intialize
1. Account and Login.rar
2. BillingAgent.rar
3. MngTools.rar
4. WebAgent.rar
5. ZonaServer.rar

File: Control Server includ File Control Server by YAPA (Fixed Ready To Use) just Setting Intialize.
6. ControlServer.rar
7. LogSpy.rar

File: Database SQL server (Create with SQL Server 2005)
8. DB SQL
9. SQL Server 2005 Enterprise (FULL [JaMu])
10. ODBC (Fixed)

Untuk Aphace Software dan Tutorial pemasangannya kalian bisa liat di bawah ini (untuk menjalankan Launcher RF nya):
1-TUTORIAL CONTROL SERVER:
Download

2-TUTORIAL APACHE + LAUNCHER
Download
-AppServer
3-Data Base Full
Dowload
-in this database already added the account for the ControlServer
-BilCruxRF.bak
-RF_USER.bak
-RF_WORLD_NOVUS.bak

4-TUTORIAL (.INI) SERVER
Download
5-DOWNLOAD ODBC
Download
Spesifikasi Hardware (Normal):
1. Core 2 Duo Proccesor
2. 8 GB DDR2/3
4. Motherboard (apa aja sesuaikan dengan Procesornya)
5. Hardisk 500gb/1 Terabyte
6. Cooling System
7. PSU supported High Voltage

(Recommended)
1. Xeon (E version)
2. 24 GB DDR2 RAM SERVER
3. Intel Server MainBoard (S version)
5. Hardisk Server 1 TB 12.000 Rpm
6. Water Cooling System
7. PSU 1400 Watt.




Credits Development : VinzGamer dan JoseRay ^^

Read more


[RF Server File] Tutorial Create RF 2.2.3 With Picture Fixed

RF Online Server (Bellato Strikes Back)

Features:

Ever wanted RF Online server Full package:



  • RF manager for manage your Server

  • Control your server via The RF manager like Send Notice without be in game

  • Edit your player without have a Control panel

  • Hackshield server Enabled

  • Log all your player activity via the Logspy for able Read their LOG in RF manager NEW link to the server.
    Download New Server Files
    1) Installation RF Server 2.2.3
    2) Requirements
    Operating system: 64 Bit OS (recommend you Windows Server 2003 64 bit) work on
    Windows 7 64bit for HOME server
    Ram: 8 Giga minimum
    Microsoft SQL server (Microsoft SQL Server 2005)
    RF Online 2.2.3 Server
    Webserver for Emulate your Launcher updater (Using Appserv network)
    RF Online 2.2.3 Client (can be downloaded from here> http://www.playrf.eu " rel="nofollow" target="_blank"> http://www.playrf.eu )

    3) Database Installation
    Install MSSQL server 2005
    Creating a database:
    Start the MSSQL query, create a database BillCruxRF, RF_User and RF_WORLD_NOVUS Set and restore databases from files.
    Configure ODBC for MSSQL (server exe> MSSQL)

    1. Click Start, select Administrative ToolsData Sources (ODBC), go to the tab [User DSN] and click [ADD]
    Select SQL Native Client (2005 MSSQL)



    Test the database connection and do the same for RF_User and RF_WORLD_NOVUS
    4) Configure Server Exe / Ini
    a) Account server

    Find AccountSystem.ini

    Code
          
    [Database]
    AccountDB_Machine = 127.0.0.1
    AccountDB_Name = RF_User
                         
    [System]
    NationCode = US
                         
    [DB_INFO]
    IP = 127.0.0.1
    Port = 1433
    DSN = BillCruxRF
    DBName = BillCruxRF
    Acc = sa
    PW = password
                         
                         
    [Service]
    MaxAccountNum = 100000
                         
    [World]
    WorldSet_Num = 1
    ServiceSet_Num = 1
                         
    Name0 = Novus
    Address0 = 127.0.0.1
    DBName0 = RF_WORLD_NOVUS
    Type0 = 0
    b) Login Server
    Find LoginSystem.ini

    Code
         
    [Account]
    AccountAddress = 127.0.0.1
    [System]
    NationCode = CN
    [CHECK ADDRESS]
    CHECK = TRUE
    [LOG]
    AUTH_LOG = TRUE
    [World]
    Lim World Num = 7
    DB Push Job = 0
    [BILLING]
    Check = FALSE
    BillingCode = 78
    [MOTP]
    Service = TRUE
    HostName = 127.0.0.1
    HostIP = 127.0.0.1
    URLPath = / MOTPValidation / ValidationServlet
    Port = 12380
    [IP Address Filter]
    FilterNum = 1
    Filter0 = 192.168.20.0
    FilterRange0 = 255
                         
                     [UserCountDisplyLimit]
    Limit0 = 5000
    Limit1 = 12000
    Limit2 = 27000
                         
    [CHI_BILLING]
    Addr = 127.0.0.1
    Port = 1433
    DBName = BillCruxRF
    ACC = sa
    PW = password     
    If you have an error: CGuildBattleController:: Instance () -> Load () Fail!
    Run the Query

    Code
         
    USE [RF_WORLD_NOVUS]
    GO

    /****** Object: Table [dbo]. [Tbl_battletournament] by Magenik Script Date: 06/19/2009 16:22:48 ******/
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    SET ANSI_PADDING ON
    GO

    CREATE TABLE [dbo]. [Tbl_battletournament] (
                        [CharacterSerial] [int] NOT NULL,
                        [CharacterName] [varchar] (17) NOT NULL,
                        [BattleWinGrade] [tinyint] NOT NULL,
                     CONSTRAINT [PK__tbl_battletournament] PRIMARY KEY CLUSTERED
    (
                        [CharacterSerial] ASC
    ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF
    GO
          
    If the error ReservedGuildBattleInfo
    Run this script


    Code
         
    USE [RF_WORLD_NOVUS]
    GO

    /****** Object: Table [dbo]. [Tbl_ReservedGuildBattleInfo] by Magenik Script Date: 06/19/2009 18:59:56 ******/
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    CREATE TABLE [dbo]. [Tbl_ReservedGuildBattleInfo] (
                        [ID] [int] NOT NULL,
                        [P1GuildSerial] [int] NOT NULL,
                        [P2GuildSerial] [int] NOT NULL,
                        [MapID] [int] NOT NULL,
                        [Number] [tinyint] NOT NULL,
                     CONSTRAINT [PK_tbl_ReservedGuildBattleInfo] PRIMARY KEY CLUSTERED
    (
                        [ID] ASC
    ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]

    GO     
    Download and run http://dump.ru/file/2937934 or run this script

    Code

    INSERT INTO [dbo]. [Tbl_economy_history] ([Serial], [Updatedate], [B_Dalant], [B_Gold], [C_Dalant], [C_Gold], [A_Dalant], [A_Gold], [ManageValue], [ B_MineOre1], [B_MineOre2], [B_MineOre3], [C_MineOre1], [C_MineOre2], [C_MineOre3], [A_MineOre1], [A_MineOre2], [A_MineOre3], [B_CutOre1], [B_CutOre2], [B_CutOre3], [C_CutOre1] , [C_CutOre2], [C_CutOre3], [A_CutOre1], [A_CutOre2], [A_CutOre3])
    VALUES (20060512, '2006-05-02 15:30:54.000 ', 0.0, 1.0, 0.0, 1.0, 0.0, 1.0, 1000, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0 , 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0)
    go

    INSERT INTO [dbo]. [Tbl_economy_history] ([Serial], [Updatedate], [B_Dalant], [B_Gold], [C_Dalant], [C_Gold], [A_Dalant], [A_Gold], [ManageValue], [B_MineOre1], [B_MineOre2], [B_MineOre3], [C_MineOre1], [C_MineOre2], [C_MineOre3], [A_MineOre1], [A_MineOre2], [A_MineOre3], [B_CutOre1], [B_CutOre2], [B_CutOre3], [C_CutOre1], [C_CutOre2 ], [C_CutOre3], [A_CutOre1], [A_CutOre2], [A_CutOre3])
    VALUES (20060513, '2006-05-13 15:30:54.000 ', 0.0, 1.0, 0.0, 1.0, 0.0, 1.0, 1000, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0 , 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0)
    go

    INSERT INTO [dbo]. [Tbl_economy_history] ([Serial], [Updatedate], [B_Dalant], [B_Gold], [C_Dalant], [C_Gold], [A_Dalant], [A_Gold], [ManageValue], [B_MineOre1], [B_MineOre2], [B_MineOre3], [C_MineOre1], [C_MineOre2], [C_MineOre3], [A_MineOre1], [A_MineOre2], [A_MineOre3], [B_CutOre1], [B_CutOre2], [B_CutOre3], [C_CutOre1], [C_CutOre2 ], [C_CutOre3], [A_CutOre1], [A_CutOre2], [A_CutOre3])
    VALUES (20060514, '2006-05-14 15:30:54.000 ', 0.0, 1.0, 0.0, 1.0, 0.0, 1.0, 1000, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0 , 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0)
    go
    If an error with CashShop
    You must remove procedure Prc_RFONLINE_Use and run it Download file Prc_RFONLINE_Use.rar
    Add a line running alter_tblRF_ItemOrderLog.sql which is here Download file Alter_tblRF_ItemOrderLog.rar

    BillCruxRF Fix
    Download Fix
    Putting everything turns

    FIX # 1
    FIX # 2
    FIX # 3
    Fix # 4

    To start controlserver you need to rename the folder Initilize in Initialize.
    The structures for the server
    Download

    PHP / Web Emulation For Launcher
    Requirements:
    1. Apache Server: AppServNetwork - AppServ 2.5.9 & 2.4.9 with Zend Optimizer AddOns Released!
    2. Open ports TCP: 80 - 8080 -10007

    INSTALLATION:
    1.Install Appserv on HDD, C
    2. Download emulator download
    3.Install working Apache server
    4. Navigate to the folder C: \ AppServ \ Apache2.2 \ conf
    5. Edit httpd.conf using the information from paragraph 2
    6. Copy rf-server.conf from paragraph 2 in the C: \ AppServ \ Apache2.2 \ conf
    7. Copy all the www folder of paragraph 2 in the C: \ AppServ \ www
    8. Edit the rf-server.conf using its IP
    9. Edit update.dll using Notepad in the C: \ AppServ \ www \ rfclient_update \ simply changing IP on your
    10. Edit tLPServerInfo.dat use information about your server at C: \ AppServ \ www \ rfclient_update \ update \ update1
    11. Make your Launcher with your IP and put it in C: \ AppServ \ www \ rfclient_update \ update \ Make_newRF Hex RF.lc (you can rename it RF.exe or RF_Myserver.exe) Look for 192.168.1.1, and 192.168.1.1 replace all their IP, and then save it and rename it RF.lc then run NewCab.bat newRF.cab then copy and paste in the folder C: \ AppServ \ www \ rfclient_update \ update \ update718 and C: \ AppServ \ www \ rfclient_update \ update718
    12. Start Apache
    13. Use your made launcher.


  • Read more


    [RF Development]RF Scanner Dupe Premium Only ! c Juntoa and Accuoz

    This is actually the announcement; so its “to be released, TBR” :)
    Keeping in line with the “dupe” frenzy, I have been working to create tools that will allow servers to better handle dupes. This tool in particular helps you to get rid of duped items on your server. It is partially based on the script created by FD Core Studio; he has created a similar script to find duplicate items on your server.
    The script “assumes” that if multiple unique ids exist, they are all duplicate items. I use the same “GROUP BY” method FD Core uses to group the items. However, you do not need 1 GB of RAM to perform this as memory is not utilized as much!
    Loading the ItemHistory database, the database which is used to check for duplicate items requires your to access PHP via CLI (command line).

    I will be adding the option later on, once the committing of the information is complete, to run an optional “delete items from the server”. This option will basically give you the ability to wipe out all the duplicate items from your server.
    You should not run this script too often as it takes a very long time depending on how big of a server you are running and how old of a server you are running; for small servers you will typically see the items being added to the temp DB at around 500,000 items (as the screenshot above is); for me this took around 2-3 minutes to complete.
    I am also including a web interface to see exactly what items were duped, how many times, as well as who has the duped items.

    Right now however this only looks at the “inventory” table and does not look at the Account Trunk or Trunk Extended, but I’m hoping to expand to that in a later release.

    I will update this post with a link for people to download it once it is complete :)

    Update [28/09/2010]

    I just ran the ItemHistory database building script (script which basically takes all your inventory data and puts it in an ItemHistory file) for 420,556 characters, which is 42,055,600 items in total, on an average computer (remember, higher the computer specs, including processor and hdd speed the better).
    It took 2 hours 24 minutes and 38 seconds to complete.
    That actually was fairly good! However I believe I can still make improvements in speed and probably cut that down by 30-50%. The actual database size ended up being 1.18 GB and I do not believe I can reduce that any further due to the need for indexing.
    At the end of the day however, this is all still being written in PHP. I am probably going to create a C++ app to do this all and it will definitely be much faster.

    Update

    I have now managed to get the time reduced (for the same, 42m items) to 1 hour 10 minutes and 43 seconds (~52% reduction in time) :)
    As well I have decided to scrap the use of SQLite as it does not support cursors and requires all the data to be loaded at once, which is exceptionally bad.  So now the data is loaded into a temp table created on the MSSQL server (RF WORLD DB) and is deleted everytime the script is ran again!

    Read more


    [RF Development]Script Anti Dupe di RF !!

    SQL Dupe Fix (RF Online)

    Anti Dupe RF Online . C> VinzGamer

    I have been working on this for the past couple of days; a way to solve the infamous dupe problems plaguing RF servers. Now, I think I have found a… “way” more than a solution.
    I am not going to go into any detail but here are the basics on what you should know, should you decide to use this!
    1. This has not been widely tested, so if things go wrong they can also go very wrong
    2. The fix has the “capacity” to cause a significant increase in server load
    3. I haven’t actually tested it for all dupes except the most common ones (reward, ah) as I do not know how to perform all the dupes. But, the assumption I am making is; all dupes require the usage of tbl_inven. Therefore, this fixes all the dupes
    4. Please take note. Data in the “ItemLogs” table does not contain “people duping”. No, it is simply data of all the players items! This script does not “catch” or “log” dupers, it PREVENTS dupes! The ItemLogs table is required to PREVENT (not log!) dupes

      This script is untested. Use at your own risk!

    So the biggest message of them all is: Use at your own risk! But I will help and would gladly accept any feedback from servers that do use this!
    How to start?
    First create the required tables:
    01CREATE TABLE [dbo].[ItemLogs](
    02[id] [int] IDENTITY(1,1) NOT NULL,
    03[serial] [int] NOT NULL,
    04[k_value] [int] NOT NULL,
    05[s_value] [bigint] NOT NULL,
    06[s_column] [varchar](10) NOT NULL,
    07CONSTRAINT [PK_ItemLogs] PRIMARY KEY CLUSTERED
    08(
    09[id] ASC
    10)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    11) ON [PRIMARY]
    12 
    13GO
    14 
    15CREATE NONCLUSTERED INDEX [IX_ItemLogs_k] ON [dbo].[ItemLogs]
    16(
    17[k_value] ASC
    18)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    19GO
    20 
    21CREATE NONCLUSTERED INDEX [IX_ItemLogs_s] ON [dbo].[ItemLogs]
    22(
    23[s_value] ASC
    24)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    25GO
    26 
    27CREATE NONCLUSTERED INDEX [IX_ItemLogs_serial] ON [dbo].[ItemLogs]
    28(
    29[serial] ASC
    30)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    31GO

    Ini Hanya membeli lengkap full script .. anti dupe semuanya .. kalo mau beli silahkan hubungi saya di facebook

    Read more

    Diberdayakan oleh Blogger.

     

    Can't hear anything? Please try one of the player links.

    Play stream in WinampWinamp/iTunes
    Play stream in Windows Media PlayerWindows Media Player
    Play stream in Real PlayerReal Player

    Pengikut

    Follow NetworkedBlog

    Promosi Banner

    ads ads ads ads

    Chit Chat

    Fans Page

    User Online

    Translator

    English French German Spain Italian Dutch
    Russian Portuguese Japanese Korean Arabic Chinese Simplified
    Home Hosting