Woool2 SQL Server Files

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
You have to put your SQL details inside
DBServer/Configuration.ini
LoginSrv/Logsrv.ini
Mir200/!Setup.txt

[DATASETUP]
DataServer= <<SQL Instant Name, SQLExpress is default i think.
DataBase=CHERODB <<Database name, unless you renamed this, don't change.
DataAccount=sa <<Username
DataPassWord= <<Password
 
Last edited:

ervinzed

LOMCN Veteran
Veteran
Jan 26, 2013
351
11
45
kewl now it works

it was a blank password on Configuration.ini

thanks alot
 

oack123

Dedicated Member
Dedicated Member
Jan 24, 2013
11
0
27
Can i use server files ver 2 for ver 1 ?
I don't like deamon class.
I want delete all skill and everything of deamon class.

Plz, help me ! :(
 
Last edited:

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
Can i use server files ver 2 for ver 1 ?
I don't like deamon class.

Plz, help me ! :(

Yes you can use this version on both 1.9 and 2.0.

P.s stop with the goddam PM's, this source code isn't getting released.
 

oack123

Dedicated Member
Dedicated Member
Jan 24, 2013
11
0
27
Yes you can use this version on both 1.9 and 2.0.

P.s stop with the goddam PM's, this source code isn't getting released.

Can you share me ver Wol mssql for 1.9 don't have class deamon ?
Plz
P/s: I needn't good server, only server nice support for ver 1.
If you can develop web, then i can help you.
 
Last edited:

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
Can you share me ver Wol mssql for 1.9 don't have class deamon ?
Plz
P/s: I needn't good server, only server nice support for ver 1.
If you can develop web, then i can help you.

This version is for 1.9 and 2.0, you can use any client, if you use the 1.9 client you won't have Deamon class. I can't stop people from using the 2.0 client and using deamon, you will just have to add a script to kick them as that pure client coded.

#IF
checkjob Goblin
#ACT
kick
break
 

oack123

Dedicated Member
Dedicated Member
Jan 24, 2013
11
0
27
Tks sanity, you know use unicode for server and client?
ex: Á ô ơ à ư,....

---------- Post Merged on 26-11-2013 at 02:42 AM ---------- Previous Post was on 24-11-2013 at 12:26 PM ----------

I use client 1.9 for sv 2.0 error:
- NPC hidden
- Town Stone not run.
Can u share me merchar.txt and mapinfo.txt of sv for client 1.9?
Plz
 

Razhiel

Dedicated Member
Dedicated Member
Apr 14, 2012
198
1
45
sens very nice but is a fk tones work work to translate working in progress

Bla.jpg
 

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
Added new LoginSrv and Woool Launcher to first post to fix account register.

When it comes to translating, best just to just follow how it's scripted rather then google translate.
 

Razhiel

Dedicated Member
Dedicated Member
Apr 14, 2012
198
1
45
Translating breking alll scripts so need to make words by words if u dont like brake something from scrip ... like i say hard work :) and btw hard whit this ASCI for me :) but is ok can hundle it and 1 more think ffs sytatus items mc dc sc damn damn damn i wana in english not china and i try trick clinet and i brake 1 time hole client :) !!!!
 

oack123

Dedicated Member
Dedicated Member
Jan 24, 2013
11
0
27
Tks sanity, you know use unicode for server and client?
ex: Á ô ơ à ư,....

---------- Post Merged on 26-11-2013 at 02:42 AM ---------- Previous Post was on 24-11-2013 at 12:26 PM ----------

I use client 1.9 for sv 2.0 error:
- NPC hidden
- Town Stone not run.
Can u share me merchar.txt and mapinfo.txt of sv for client 1.9?
Plz
I fixed but server has many bugs (item and skill...)

Who can help me use unicode for client ?
Plz.
 
Last edited:

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
Translating breking alll scripts so need to make words by words if u dont like brake something from scrip ... like i say hard work :) and btw hard whit this ASCI for me :) but is ok can hundle it and 1 more think ffs sytatus items mc dc sc damn damn damn i wana in english not china and i try trick clinet and i brake 1 time hole client :) !!!!

You need to be careful when hex editing, sounds like your editing function code.

1 Chinese character = 2 English characters

When you see strings like %s属性

The %s is apart of the code, don't edit this, you won't break the client but you will break the function of that code.

Oh never copy and paste when doing this either.

Here every string (2.0 Client) decompiled
http://www.mediafire.com/view/7eplmq21hlmmx27/Woool2 Client Strings.xlsx
 

Razhiel

Dedicated Member
Dedicated Member
Apr 14, 2012
198
1
45
any way m8 this clinet is pain in ass and till i canot get a sgl edit for the new clinet file i will put in my project standby ! coz i'm for to do this from this editor program :(
 
  • Like
Reactions: spartekas

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
1-1-2014CTEngine.rar
Engine crashing on processing fixed.
Engine delay startup fixed.

Skill added to for user to change without editing source.
Fencing ;
Adjust hit rate levels 1-7

Slaying ;
Adjust usage/unlimted, damage delt 100/100 %.

FlameSword/ThunderSword
Adjust damage by level. Lv0= 100, Lv1=110, Lv2=120, Lv3=130 Lv4=140, Lv5=150, Lv6=160, Lv7=170
Enable/Disable double strike

Sabotage;[Passive]
Adjust chance of use. Lv0= 10, Lv1=15, Lv2=20, Lv3=30 Lv4=40, Lv5=50, Lv6=60, Lv7=70

BrokenShield;[Passive]
Adjust chance of use. Lv0= 10, Lv1=15, Lv2=20, Lv3=30 Lv4=40, Lv5=50, Lv6=60, Lv7=70

ForceArmor;
Adjust endurance of shield.

BladeStorm; [This includes SpiritDash]
Adjust time usage.

Sleight; [This effects Burrow and DeathBat]
Adjust range of use
adjust chance rate by % Lv1-7.

StrengthenSlaying [Hero]
TODO;

This update for 1.9 client only, fix's creating more then 2 characters.
Edit Hum_Info_Add stored procedures.
Code:
USE [CHERODB]
GO
/****** Object:  StoredProcedure [dbo].[HUM_INFO_ADD]    Script Date: 01/02/2014 03:00:18 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[HUM_INFO_ADD]
    @ACCOUNT   varchar(15) ,
    @NAME  varchar(15) ,
    @Hair tinyint ,
    @Sex tinyint ,
    @Job tinyint ,
              @YSMaster varchar(15)
AS
 DECLARE     @BinaryData binary(1647)
 
 IF EXISTS(SELECT ACCOUNT FROM D_HUM_INFO WHERE NAME=@NAME)
   RETURN(2)
ELSE
BEGIN
  if   @YSMaster=''   and      (SELECT Count(*) FROM D_HUM_INFO WHERE (ACCOUNT=@ACCOUNT)and (YSMaster='') and(boDelete=0) )>=2
      RETURN(2)
  INSERT INTO D_HUM_INFO
         (ACCOUNT,
    NAME,
             YsMaster,
    Hair  ,
    Sex  ,
    Job ,
BinaryData,
 boDelete,
boSelect,
UpDateTime 
 
          )
  VALUES (
@ACCOUNT,
    @NAME,
             @YsMaster,
    @Hair ,
    @Sex  ,
    @Job, 
             @BinaryData,
             0,
             0,
             GetDate()
     ) 
   RETURN(1)

END

Just to confirm this version works on 1.9.6.0+ and 2.0 but i do not recommend using 2.0, the client i recommend using is 1.9.9.9.8.3.3.
Il try clean up this topic when i get time.

Also if you could post any problems here instead of PM, i generally don't reply to pm's right away and tend to forget, all pm's have been replied to i think now .

---------- Post Merged on 03-01-2014 at 11:58 PM ---------- Previous Post was on 02-01-2014 at 03:06 AM ----------

03-01-2014CTEngine.rar

Wizard and Taoist skills are fixed and done, if you want more then let me know, MeteorShower layers is on my todo list as i need to know exactly how this works, i know at the moment it's bugged applying 3 layers on single cast il get this fixed.
Deamon has 2 skills coded which i didn't do, not tested them either but i won't be doing anything relating to that class at the moment, 1.9 my old focus.

Fixed mounts, was a mistake i forgot to change in last update.
String translating done.
English client will be release soon, a week or so i would assume.

---------- Post Merged on 07-01-2014 at 05:53 PM ---------- Previous Post was on 02-01-2014 at 03:06 AM ----------

07-01-2014CTEngine.rar

Skill tree update recoded.Magic.db
Descr
Skill you need to learn before (ID XX)
Equal If skill is learned, you cannot learn the follow. (ID XX)

Example

ID 11 Lighting
ID 49 IceBolt
You will see in Lighting Equal field the number 49 which means if you learn Lighting, you will not be able to learn IceBolt. Use , if you wish to do more then 1 skill 11,49

TrainTree in !Setup.txt no longer works, this method allows the user to choose the skill tree themselfs and not forced to use Shanda's one.
Current database release in this update is using Shanda skill tree but you can change as you wish.

Monster.db
New Field yyzg_lv
This is for Tamming, allows you to limit the number of monsters you want wizards to tame, if you want them to tame only 4 Deer, enter 4 in the field and that will be the max amount they will be able to tame.

CorpseTyrant disappearing fixed.
Monster drop editor should now reload the drop files after save, including when server is live.
Fixed Taoist Pets, should now summon fine.
HolyWord (TurnUndead) now only works on undead monsters.
Minimap no longer will disappear on login

These are already done but still working on others, trying to get the exact ui of bosses the way shanda have done them but i have not released it in this update as others still need looking at, the whole Monster.db has also been re done and cleaned up.
Hierarch (HighFounder Pre Boss) now uses Flamefield (Shanda), Forms remain bugged though, it's on my to do list.
SpiritDemon1 and SpiritDemon2 correct ui added (Shanda)

---------- Post Merged on 08-01-2014 at 06:03 PM ---------- Previous Post was on 02-01-2014 at 03:06 AM ----------

08-01-2014-CTEngine.rar

DragonKing Update

Monsters.db
Code:
GoldDragon,214,18,460,1000,1,100,1,1900,0,50,60,100,120,100,0,30,80,500,1,500,1800,5,,
PurpleDragon,214,18,461,1000,1,100,1,1900,0,50,60,100,120,100,0,30,80,500,1,500,1800,5
GreenDragon,214,18,462,1000,1,100,1,1900,0,50,60,100,120,100,0,30,80,500,1,500,1800,5,,,,

StdItems.db
Code:
1057,Dragonball,63,8,1,0,0,0,8077,100,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,,,,,,,,
1066,DragonShield1,12,70,1,0,1,0,8115,20000,10,20,10,20,10,20,0,0,0,0,,,0,35,40000,5,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,,,,
1067,DragonShield2,12,71,1,0,1,0,8117,20000,10,20,10,20,0,0,10,20,0,0,,,0,35,40000,5,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,,,,
1068,DragonShield3,12,72,1,0,1,0,8116,20000,10,20,10,20,0,0,0,0,10,20,,,0,35,40000,5,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,,,,

QFunction.txt
Code:
[@DragonKingFeed]
#ACT
SENDMSG 5 1=<$PARAM(70)>
SENDMSG 5 2=<$PARAM(71)>
SENDMSG 5 3=<$PARAM(72)>
#CALL [\GameFeatures\ItemTrigger.txt] @DragonKing
break

This is only a test script, @DragonKingFeed is the trigger to feed the dragon dragonballs, don't change this as it's coded.

GameFeatures\ItemTrigger.txt
Code:
[@DragonKing]
{
#if
EQUAL $EDITLW.0 99
#act
SENDMSG 5 "Your Dragon level is full, you can not continue with the upgrade!"
break
#if
small $LEVEL $EDITLW.0
#ACT
SENDMSG 5 "Cannot summon DragonKing, you need to first upgrade before releasing."
break
#if
pos $PARAM(71) Dragonball(L)
#ACT
takeID $PARAM(70)
EDITLW 1 + 10000
goto @DragonUpgrade
break
#if
pos $PARAM(71) Dragonball
#ACT
takeID $PARAM(70)
EDITLW 1 + 100
goto @DragonUpgrade
break
#ELSEACT
SENDMSG 5 "<$PARAM(71)> Can not be fed!"
break

[@DragonUpgrade]
#if
small $EDITLW.2 $EDITLW.1
#ACT
EDITLW 0 + 1
EDITLW 1 = 1
EDITLW 2 + 9050
EDITLW 3 + 350
EDITLW 4 + 1
EDITLW 5 + 1
EDITLW 6 + 1
EDITLW 7 + 1
EDITLW 9 + 2
EDITLW 10 + 2
EDITLW 11 + 2
EDITLW 12 + 2
EDITLW 13 + 2
goto @jinen
SENDMSG 5 "Congratulations, your DragonKing has been upgraded!"

[@jinen]
#IF
check [100] 0
checkjob warrior
#ACT
EDITLW 14 = 4
EDITLW 15 = 4
EDITLW 18 = 4
EDITLW 21 = 4
EDITLW 22 = 4
SET [100] 1
SENDMSG 5 "Congratulations, your DragonKing has been upgraded!"
break
#IF
check [100] 0
checkjob wizard
#ACT
EDITLW 14 = 4
EDITLW 16 = 4
EDITLW 19 = 4
EDITLW 21 = 4
EDITLW 22 = 4
SET [100] 1
SENDMSG 5 "Congratulations, your DragonKing has been upgraded!"
break
#IF
check [100] 0
checkjob taoist
#ACT
EDITLW 14 = 4
EDITLW 17 = 4
EDITLW 20 = 4
EDITLW 21 = 4
EDITLW 22 = 4
SET [100] 1
SENDMSG 5 "Congratulations, your DragonKing has been upgraded!"
break

zoglyt.jpg

15nkj5w.jpg

2na1h8w.jpg
 
Last edited:

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
10-01-2013-CTEngine.rar
Login Naked while wearing items Fixed
Login with bold head fixed
skills randomly being deleted fixed
Minimap should be fixed at login but may bugg when switching characters
NPC are invisible fixed, if this happens please tell me which npc it is.
Bag items randomly deleted fixed
Gold randomly deleted fixed
Title not appearing, this should be fixed but there is a bug in the script so il fix this.

Appears the engine had some clever coded restrictions and a pain in the ars to sort out but hopefully all sorted now and of the problems above happen, let me know.
 

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
2.0 Server files update 11-4-2014

Everything i did on 2.0 you can get here, includes all Deamon functionality, Achievements system and so on.

Although i don't recommend bothering with 2.0 i thought i get these released as people did help me find bugs for it.

The updates above for 1.9 are updated in this also, but they are not scripted in the files so you will have to do it yourself.
 
Last edited:

Phace

Dedicated Member
Dedicated Member
Nov 1, 2012
33
0
33
England
Sanity how come there is no SQL config file with this? I have tried the woool 2 server files but had no luck so trying these.
 

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
Sanity how come there is no SQL config file with this? I have tried the woool 2 server files but had no luck so trying these.

SQL config file? Do you mean the Database, 1.9 and 2.0 versions work exactly the same, Not sure were i put my 2.0 database, noticed it's missing but you can use the 1.9 one, it's fine.

Edit:
The 2.0 DB is in Wolserver/DB, just import the CT.mdb over your current database, guide here on how to do it
http://www.lomcn.org/forum/showthread.php?78565-SQL-Version-Update-Database
 
Last edited:

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
the SQL config tool? is it called something else in these files?

View attachment 14720

Oh, use the old one, i was updating it with the new databases and a backup cleaning setting and some other functions for restoring the database but i didn't finish it, might have problems restoring so use the old one.