Access for Woi CN

[LikeReally]

Just doing a wrap up for whatever I had been doing the past few years.
If you would like to play chinese official version of woi, you can check it out.
You can visit my album if you do not wish to download any of it below.
Whether I will update or not, I can say I have no intention to continue anymore.

Album

 Spoiler

Album :
Video :

Creating account (OUTDATED. Edited 13.01.2024)

 Spoiler

Video was done earlier today. While it lasts. Good luck.
Video Guide:
Sample Accs
Acc :
Pass :qqq111
Acc :
Pass : qqqq111

Translating (OUTDATED. Edited 13.01.2024)

 Spoiler

Not providing you with TM I have. Shown how to do it manually. Good luck.
Video Guide:

Patched English WOI CN Client & Patches (UPDATED LINK. Edited 13.01.2024)

 Spoiler

Client already patched in English including UI, Task, strings etc.
As for Item.string, Npcstr.str, slk.string & string.string, you will have to re-edit after every update. Good luck.
CN Client (2104710) :
CN Patches (Translated) :
CN Patches (Untranslated) :

Unpatched BOI CN Clean no SQP Client & Patches (UPDATED LINK. Edited 13.01.2024)

 Spoiler

Edited : 22.02.2019
Client (9002009) :
CN Client (9004009) :
CN Patches :

Below is Boi Odin Clean English Client. You might want to copy and replace into chinese client for some english.

Extra Tools you might need (UPDATED LINK. Edited 13.01.2024)

 Spoiler

Link :

WOI CN Google Sheet English Patch Notes (Brief Summary)

 Spoiler

Will update when free
Link :

BOI CN Google Sheet English Patch Notes (Detailed Summary)

 Spoiler

Link :

Edit 22.02.2019 : Will be sharing with you english patches for Chinese WOI through Mega. Will update when free.

 Spoiler

How to patch :
Within the folder, there is a Steps for config.txt, you can follow that.

Edit 12.22.2018 : Those that can't launch, change your non-unicode lang to chinese prc.


While it lasts, I have done the 2104910 210510 english string patch for woi. You can apply to it from attachment below.

[LikeReally]

For those asking how I get the chinese clean client from, I know some BOI manual patcher is faulty, so here below I will show you. *For woi, it is still packed. However, steam cn is releasing woi soon, maybe it will have a full clean client there.

So,
1. Go to this , click on your top right to download. Install it, login with acc
(If you don't have, you can use my above free acc to login).
2. Go to the 2nd tab and search for games if you do not see any woi/boi pop up on your left side.
3. Click on the yellow button to download. The download speed is fast.
4. If you have trouble download, delete your woi/boi folder to recycle bin temporary to download
5. You will find it in D drive by default.
6. Upon download finished, you will see the zip file already, but please go task manager and end task for this to stop it from auto extract & installing.

Gallery 1

[LikeReally]

Two pointless comments
---
As some of you may know about desqp. It's a tool created by Dwar & Genz for unpacking sqp.
There are little use atm. Besides digging out old woi files packed in sqp, can't think of anything else.
Clean BOI no sqp files and chinese patches are above on post #1.
WOI cult of wrym up to latest chinese patches are on post #1 as well.

The purpose here is to provide some of you people that still want to use this tool,
but may had encounter the same error (customised dotnet4) when comes to compiling the tool.
This will allows you to create and compile new filelist.

I had posted this solution years ago on programarcity and ragzone but dead mods

So, you will need vmware because I have packed the whole os in there.
Why is this vm so big? Because it includes custom dnet4 & vs2010 pro for compile of course... Goodluck.

If you need WOI Pre-LC client (not sure if clean) you can download from

 Spoiler

Download 2.3gb (5.8gb unzipped)


How to use :

1. Download, extract, install vmware, open this file, run. Choose "I moved it" if pops.
2. Everything have been set up. Extract deSQP.rar on desktop. Open deSQP.sln
3. Build the project. Or just simply F6.
4. Go to SQPF\bin\Debug\_dest_full_file_list.txt - This will be your default filelist, you can customised to suit your need.
5. Run SQPF.exe, make sqpf, copy sqpf.dat to deSQP\Libs and replace.
6. Go back to vs and build or F6 again. Then head to deSQP\deSQP\bin\Debug\deSQP.exe
7. This folder will also be where you drag your .sqp files into for unpacking.
8. Launch deSQP.exe ignore the error and go ahead to unpack.
9. WTV.exe is provided for viewing .dds (For viewing .m4f visit post #1 Extra Tool)

(OUTDATED REFER TO POST BELOW ON MQPEDITOR. UPDATED LINK Edited 13.01.2024)

[vizual9]

server file ?!?

[ropke]

Can't you read?

[LikeReally]

Just arranging some files.

(Localhost/VM)
WOI LC (Client + VM+ Server Files + Some Tuts + GM Cmd) :

 Spoiler

(Localhost/VM/Live)
BOI Odin (Linx + Server + VM) :

 Spoiler

VM/Live:

(Localhost/VM)
WOI LO (Client + VM+ Server Files) :

 Spoiler

Credits : Tuan565

(Live)
BOI 1.8 Titan (Client + Linx + Server + Configurator) :

 Spoiler

Credits : LeRaz0r

BOI GOF (server+linx(mssql) + official document, no client)

 Spoiler

Dontaskme

Linux VM Tutorial

 Spoiler

Credit: Criztino(MartinLe)
Create Linux Tutorial:

.
..
...
(OUTDATED REFER TO POST BELOW. Edited 13.01.2024)
...
..
.

[LikeReally]

Been seeing a lot of posts about getting offline setup and I have no idea why it is that hard.
For any offline files available, all configuration and tedious stuffs have in fact already been set up nicely.

I don't know how further simple can this get.
I have placed all files into one vm for window side. Linux will be separate.
BOI Titan, Odin; WOI LO, LC

So here offline/localhost or whatever you call it,
will be for the clueless, error all day or just plain lazy :

 Spoiler

1. Download VMware 15, BOIWOIWINXP, and your selected linux, client.
For Win is not needed because I placed all into BOIWOIWINXP.
You can still download if you want to.

2. Install VMware, extract all download anywhere you like.

3. Start vmware, open file from your extracted Linux and BOIWOIWINXP.

4. Select "I moved it" if it pops up and carry on to power on/start the vm.

5. READ the guide note attached. READ.

6. Copy startgame.bat and serverlist.ini to Bin Folder.

7. Play.

8. If everything load correctly, but unable to select server ( select server doesn't glow),
run command promt as admin, type netsh winsock reset
then follows by a reboot of your computer.

Right HERE : Credits: Me duh.

The files are compressed to be small enough for download, don't complain about extract.


To change woi lc localhost drop rate :
ManagerServer\slk\Perdaytas.slk

How to create user if sql and localweb not work:


How to switch to vbox :


Configure your network on VM :
Edit > Virtual Network Editor > Change Setting (Run as Admin) > Bridged to (Select your adaptor) > Apply, Ok & Restart VM.

In case you don't see the little note I wrote, I added it eveywhere include attachment.
and DO NOT reply to this thread, I do prefer to keep it clean.
...
..
.
.
.
(UPDATED LINK. Edited 13.01.2024)
.
.
.
..
...

[LikeReally]

.
(Local Host/Live)
BOI Odin 4th Anniversary

 Spoiler

VM Linux :
Server Files:
Client : Pamizra games private server.
CLient : Memory

Credits : figure it yourself.

Ready to play localhost. For live, diy. Can have 10 tarot slots, diy. Have Fun.
Steps for config : Same thing. Run VM Linux, I moved it, copy server files to VM windows D drive and run start.bat.
For Linux sql login/pass, whatever in All In One Manual Guide.txt.

And DO NOT REPLY HERE. Ty. Learn to read.
...
..
.
.
(UPDATED LINK. Edited 13.01.2024)
.
.
..
...

[eddwood]

Originally Posted by LikeReally

Been seeing a lot of posts about getting offline setup and I have no idea why it is that hard.

Hi I have followed your instructions, everything seems to be right except no server showing in list, I flushed DNS.

Did notice There is no internet connection on VMware is this normal?

Also the first of the box's in VMware had this problem.

GAuthClient::connect to au failed!

auagent: 2020-01-19 17:45:53 INFO - zoneid=1,aid=9
auagent: 2020-01-19 17:45:53 INFO - SpeedLimit:window=20,high=2
auagent: 2020-01-19 17:45:53 INFO - PhoneTokenLimit parse Exception,use default
value(300, 2)
auagent: 2020-01-19 17:45:53 INFO - CouponLimit:window=300,high=1
auagent: 2020-01-19 17:45:53 INFO - CouponExchangeLimit:window=120,high=1
auagent: 2020-01-19 17:45:53 INFO - ThridParty time_policy parse Exception, set
time_policy to default value(15s)
auagent: 2020-01-19 17:45:53 INFO - Third Party Parsing:
auagent: 2020-01-19 17:45:53 INFO - Server overload parse Exception, set overlo
ad to default value(-1)
auagent: 2020-01-19 17:45:53 INFO - TimeoutLimit:window=180,high=200
auagent: 2020-01-19 17:45:53 INFO - issupport_cert=0
auagent: 2020-01-19 17:45:53 INFO - Auagent setup success!
java.net.NoRouteToHostException: No route to host: no further information
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(Unknown Source)
at com.goldhuman.IO.ActiveIO.Close(Unknown Source)
at com.goldhuman.IO.PollIO.Poll(Unknown Source)
at com.goldhuman.IO.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
assoc_session = com.goldhuman.IO.Protocol.Session@5b0668 activeio = com.goldhuma
n.IO.ActiveIO@1d5a0
auagent: 2020-01-19 17:45:53 INFO - GameDBClient::connect to gamedb failed!
java.net.NoRouteToHostException: No route to host: no further information
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(Unknown Source)
at com.goldhuman.IO.ActiveIO.Close(Unknown Source)
at com.goldhuman.IO.PollIO.Poll(Unknown Source)
at com.goldhuman.IO.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
assoc_session = com.goldhuman.IO.Protocol.Session@1f64158 activeio = com.goldhum
an.IO.ActiveIO@3c2378
auagent: 2020-01-19 17:45:53 INFO - =========GAuthClient::connect to au failed!

[tonyyt22]

Hi!

I have a very annoying problem with my server, I use this files

And Everything work as intended except for some text that's illegible, for example, all entrances to instances( I mean the text that let you teleport to the instance ) has random characters or "nothing", I fix this replacing one SLK file from other older server files, now I can play better, but for some reason, some other text still broken like this:



This at first didn't bother me much but I need to know why for example I cant fortify a pet or what boss spawn and where.

Someone knows where I can find these texts to replace them, or how to fix it?

Thanks in advance!

Regards Tony

[LikeReally]

.
Fresh files clean
LIVE BOI ODIN

 Spoiler

Server & Linux files:

LIVE BOI 4TH ANNI

 Spoiler

Server & Linux files:

LIVE WOI LC

 Spoiler

Server & Linux files:

.
..
...
(UPDATED LINK. Edited 13.01.2024)
...
..
.

[noob2525]

who knows what needs to be done to make the server level up? to start territorial wars and so on ?

[LikeReally]

Tutorial video for newbies.

 Spoiler

Basic Setup Tutorial

Credits : Sergiu Stan

Great work! Love to see more useful post!

...
..
.
.

[LikeReally]

Reading comments about know-how around places is giving me a good laugh.

Just a quote from me, don't talk like u know anything because u don't.

Will repost again since ppl doesn't know how and it's ugly, messy and naivete when they share what they swank on.

Update on desqp, there's mpqeditor. Credit:
Update on protocol unknown, if u dont alr know, managerserver.ini change gacd port to 29702. So gtfo about throwing errors. For u to figure.
Update on config, for ur easy sake.

WOI CoW Files and previous shared version in one link

 Spoiler

.
Before u comment, share ur things if u think urs better, else don't comment.


FILES :
CoW Client:

Server_BOI_2013060417_us_tar_gz BOI Odin Wrath
Server_BOI_2014010210_us_tar_gz BOI Glorious 4th Anniversary
Server_WOI_2013101411_us_tar_gz WOI Legendary Crusade
Server_WOI_2014011317_us_tar_gz WOI Cult of the Wyrm

Don't ask me for fixes. Figure it yourself.

Cult of Wyrm Pre-Mortal Patch Version
Includes: Debug line for pet +15 (Credits: Denuvo) and 8 realms
Includes: All pre mortal patch.
SERVER :
LINUX :
Client : No client from me. Find it yourself, since it's public right.
GM CMD : /t0ps3cr3t

Don't talk much. U mess, there u go.
.

Regard Petbug

 Spoiler

.
Before u comment, share ur things if u think urs better, else dont comment.
SQL :

Example :

CREATE DEFINER=`root`@`localhost` FUNCTION `getpetinteger`(PET_GET_ID BIGINT UNSIGNED, PET_GET_TYPE INT) RETURNS int(11)
    READS SQL DATA
    DETERMINISTIC
BEGIN
	DECLARE PET_VIT INTEGER UNSIGNED;
	DECLARE PET_INT INTEGER UNSIGNED;
	DECLARE PET_STR INTEGER UNSIGNED;
	DECLARE PET_SPR INTEGER UNSIGNED;
	DECLARE PET_DEX INTEGER UNSIGNED;
	SET PET_VIT = 0;
	SET PET_INT = 0;
	SET PET_STR = 0;
	SET PET_SPR = 0;
	SET PET_DEX = 0;
	SELECT CONV(CONCAT(SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+10,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+8,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+6,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+4,2)),16,10) INTO PET_VIT FROM pettab_sg WHERE PetID = PET_GET_ID;
	RETURN PET_VIT;
	ELSEIF PET_GET_TYPE = 2 THEN
	SELECT CONV(CONCAT(SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+50,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+48,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+46,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+44,2)),16,10) INTO PET_INT FROM pettab_sg WHERE PetID = PET_GET_ID;
	RETURN PET_INT;
	ELSEIF PET_GET_TYPE = 3 THEN
	SELECT CONV(CONCAT(SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+90,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+88,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+86,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+84,2)),16,10) INTO PET_STR FROM pettab_sg WHERE PetID = PET_GET_ID;
	RETURN PET_STR;
	ELSEIF PET_GET_TYPE = 4 THEN
	SELECT CONV(CONCAT(SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+130,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+128,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+126,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+124,2)),16,10) INTO PET_SPR FROM pettab_sg WHERE PetID = PET_GET_ID;
	RETURN PET_SPR;
	ELSEIF PET_GET_TYPE = 5 THEN
	SELECT CONV(CONCAT(SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+170,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+168,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+166,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+164,2)),16,10) INTO PET_DEX FROM pettab_sg WHERE PetID = PET_GET_ID;
	RETURN PET_DEX;
	END IF;
END

CREATE DEFINER=`root`@`localhost` FUNCTION `getpetfloat`(PET_INTEGER INTEGER UNSIGNED ) RETURNS int(11)
    READS SQL DATA
    DETERMINISTIC
BEGIN
	RETURN SIGN(PET_INTEGER) *  (1.0 + (PET_INTEGER &  0x007FFFFF) * POWER(2.0, -23)) * POWER(2.0, (PET_INTEGER & 0x7f800000) / 0x00800000 - 127);
END

SELECT RoleID, getpetfloat(getpetinteger(PetID,1)) AS 'VIT', getpetfloat(getpetinteger(PetID,2)) AS 'INT', getpetfloat(getpetinteger(PetID,3)) AS 'STR', getpetfloat(getpetinteger(PetID,4)) AS 'SPR', getpetfloat(getpetinteger(PetID,5)) AS 'DEX' FROM pettab_sg;

Oops. What's this? Hmm. That's right. It's possible on both. Do make it yourself.
It's extra bonus idea for u. Because that's all u got. Lacking.
Sharing free is no longer an option. Don't ask me to gift.
Gave enough freebies to be slam with discourtesy.

Showing a video to speak volume than words like "I have it fixed".
Will let the "fixed pro(s)" do the free sharing instead.

Reminder

 Spoiler

If u are part of the old grp of ppl from 2010-2015 that knows actual stuffs, be reminded u are outdated.
If u need new expansion server files or source code, be prepare on deep enough pocket > 60000 before u write to me.
If u hoping for leaks to happen, I wish u good health to dwell on it bcs i am divergent.
If u seen my posts long enough, i dont write without things on hands to give, not like the leeches.
If u want proof or to catch a glimpse of anything, u have to pass my discernment.

Discord: oxygen_57253

At this stage, i've seen more malarkey ppl online than i've seen offline.
Lastly, don't talk about anything if you have nothing good that u can actually share it to solve.

Credits

 Spoiler

.
CREDITS OLD EXFILES
ORIGIN:[PWE]
METHOD: HACKED
FROM: [FYYRE LOKO DEMO SCENA AR WHOEVER ELSE]
DATE: [2010 - 2016]

CREDITS NEW FILES
ORIGIN:[PWCN.TY]
METHOD: BOUGHT
FROM: [ZG JE SN AND OF COURSE ME]
DATE: [2017 - 2020]
.

DO NOT reply to this thread, I do prefer to keep it clean. Learn to read.

[deepgame]

Originally Posted by LikeReally

Reading comments about know-how around places is giving me a good laugh.

Just a quote from me, don't talk like u know anything because u don't.

Will repost again since ppl doesn't know how and it's ugly, messy and naivete when they share what they swank on.

Update on desqp, there's mpqeditor. Credit:
Update on protocol unknown, if u dont alr know, managerserver.ini change gacd port to 29702. So gtfo about throwing errors. For u to figure.
Update on config, for ur easy sake.

WOI CoW Files and previous shared version in one link

 Spoiler

.
Before u comment, share ur things if u think urs better, else don't comment.


FILES :
CoW Client:

Server_BOI_2013060417_us_tar_gz BOI Odin Wrath
Server_BOI_2014010210_us_tar_gz BOI Glorious 4th Anniversary
Server_WOI_2013101411_us_tar_gz WOI Legendary Crusade
Server_WOI_2014011317_us_tar_gz WOI Cult of the Wyrm

Don't ask me for fixes. Figure it yourself.

Cult of Wyrm Pre-Mortal Patch Version
Includes: Debug line for pet +15 (Credits: Denuvo) and 8 realms
Includes: All pre mortal patch.
SERVER :
LINUX :
Client : No client from me. Find it yourself, since it's public right.
GM CMD : /t0ps3cr3t

Don't talk much. U mess, there u go.
.

Regard Petbug

 Spoiler

.
Before u comment, share ur things if u think urs better, else dont comment.
SQL :

Example :

CREATE DEFINER=`root`@`localhost` FUNCTION `getpetinteger`(PET_GET_ID BIGINT UNSIGNED, PET_GET_TYPE INT) RETURNS int(11)
    READS SQL DATA
    DETERMINISTIC
BEGIN
	DECLARE PET_VIT INTEGER UNSIGNED;
	DECLARE PET_INT INTEGER UNSIGNED;
	DECLARE PET_STR INTEGER UNSIGNED;
	DECLARE PET_SPR INTEGER UNSIGNED;
	DECLARE PET_DEX INTEGER UNSIGNED;
	SET PET_VIT = 0;
	SET PET_INT = 0;
	SET PET_STR = 0;
	SET PET_SPR = 0;
	SET PET_DEX = 0;
	SELECT CONV(CONCAT(SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+10,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+8,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+6,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+4,2)),16,10) INTO PET_VIT FROM pettab_sg WHERE PetID = PET_GET_ID;
	RETURN PET_VIT;
	ELSEIF PET_GET_TYPE = 2 THEN
	SELECT CONV(CONCAT(SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+50,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+48,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+46,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+44,2)),16,10) INTO PET_INT FROM pettab_sg WHERE PetID = PET_GET_ID;
	RETURN PET_INT;
	ELSEIF PET_GET_TYPE = 3 THEN
	SELECT CONV(CONCAT(SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+90,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+88,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+86,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+84,2)),16,10) INTO PET_STR FROM pettab_sg WHERE PetID = PET_GET_ID;
	RETURN PET_STR;
	ELSEIF PET_GET_TYPE = 4 THEN
	SELECT CONV(CONCAT(SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+130,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+128,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+126,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+124,2)),16,10) INTO PET_SPR FROM pettab_sg WHERE PetID = PET_GET_ID;
	RETURN PET_SPR;
	ELSEIF PET_GET_TYPE = 5 THEN
	SELECT CONV(CONCAT(SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+170,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+168,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+166,2),SUBSTR(hex(PetInfo),INSTR(SUBSTR(hex(PetInfo),43), "3F00")+164,2)),16,10) INTO PET_DEX FROM pettab_sg WHERE PetID = PET_GET_ID;
	RETURN PET_DEX;
	END IF;
END

CREATE DEFINER=`root`@`localhost` FUNCTION `getpetfloat`(PET_INTEGER INTEGER UNSIGNED ) RETURNS int(11)
    READS SQL DATA
    DETERMINISTIC
BEGIN
	RETURN SIGN(PET_INTEGER) *  (1.0 + (PET_INTEGER &  0x007FFFFF) * POWER(2.0, -23)) * POWER(2.0, (PET_INTEGER & 0x7f800000) / 0x00800000 - 127);
END

SELECT RoleID, getpetfloat(getpetinteger(PetID,1)) AS 'VIT', getpetfloat(getpetinteger(PetID,2)) AS 'INT', getpetfloat(getpetinteger(PetID,3)) AS 'STR', getpetfloat(getpetinteger(PetID,4)) AS 'SPR', getpetfloat(getpetinteger(PetID,5)) AS 'DEX' FROM pettab_sg;

Oops. What's this? Hmm. That's right. It's possible on both. Do make it yourself.
It's extra bonus idea for u. Because that's all u got. Lacking.
Sharing free is no longer an option. Don't ask me to gift.
Gave enough freebies to be slam with discourtesy.

Showing a video to speak volume than words like "I have it fixed".
Will let the "fixed pro(s)" do the free sharing instead.

Reminder

 Spoiler

If u are part of the old grp of ppl from 2010-2015 that knows actual stuffs, be reminded u are outdated.
If u need new expansion server files or source code, be prepare on deep enough pocket > 60000 before u write to me.
If u hoping for leaks to happen, I wish u good health to dwell on it bcs i am divergent.
If u seen my posts long enough, i dont write without things on hands to give, not like the leeches.
If u want proof or to catch a glimpse of anything, u have to pass my discernment.

Discord: oxygen_57253

At this stage, i've seen more malarkey ppl online than i've seen offline.
Lastly, don't talk about anything if you have nothing good that u can actually share it to solve.

Credits

 Spoiler

.
CREDITS OLD EXFILES
ORIGIN:[PWE]
METHOD: HACKED
FROM: [FYYRE LOKO DEMO SCENA AR WHOEVER ELSE]
DATE: [2010 - 2016]

CREDITS NEW FILES
ORIGIN:[PWCN.TY]
METHOD: BOUGHT
FROM: [ZG JE SN AND OF COURSE ME]
DATE: [2017 - 2020]
.

DO NOT reply to this thread, I do prefer to keep it clean. Learn to read.

Thank u sensei