irugationz

I have a table in SQL which stores the datetime when the player did something (datetime format: YYYY-MM-DD HH:MM:SS).

 

I want to make a check up when the player try to talk to the NPC, that he will only proceed if the delay between the stored datetime in SQL and the current time in-game is less or equal to 25 hours.

So, if the current time is more then 25 hours later from the stored value in the SQL (datetime), the NPC won't talk.

 

But i do not know how to make those checks. How can i compare a datetime value in SQL to the current time in server plus some hours/days?

Thanks!

I've made an script in an arena which when a player kills the other, the event "OnPCKillEvent" will starts to give him items.

But, strangely, i noted that the player is getting the reward item twice.

So, i've made a "debugmes" to check it, and when the player kills the other, it is running "OnPCKillEvent" twice and giving the rewards twice. The same thing is happening to "OnPCDieEvent".

Does anyone knows how to solve this?

Hercules git: 37fefe0d863f74a8229dd57c72a6cef6c1071730

Thanks!

I tryed to make custom boxes (Group Items), but i got error when i try to open it.

item_db2.conf:

{

Id: 31550

AegisName: "1a2a50"

Name: "Black Box [Prontera]"

Type: 2

Buy: 0

Sell: 0

Weight: 1

Trade: {

nodrop: true

noselltonpc: true

}

Script: <" getrandgroupitem 31550,1; ">

},

item_group.conf:

1a2a50: (

("Red_Box_",10), //Old Red Box Item ID# 12189 (Red_Box_)

("Orcish_Axe_",10), //Orcish Axe [4] [One Hand] Item ID# 1309 (Orcish_Axe_)

("Long_Horn_M",10), //Long Horn [1] [One Hand] Item ID# 1428 (Long_Horn_M)

("Healing_Staff_C",10), //Staff Of Healing [0] [One Hand] Item ID# 1638 (Healing_Staff_C)

("Angel_Spirit",10), //Angel Spirit [0] [Middle Head] Item ID# 5389 (Angel_Spirit)

("Boots_Perforated",10), //Red Stocking Boots [0] [Footgear] Item ID# 2442 (Boots_Perforated)

("Bill_Guisarme",10), //Bill Guisarme [0] [Two Handed] Item ID# 1467 (Bill_Guisarme)

("Zweihander_",10), //Zweihander [2] [Two Handed] Item ID# 1171 (Zweihander_)

("Skeleton's_Cape",10), //Skeleton Manteau [0] [Garment] Item ID# 2511 (Skeleton's_Cape)

("Bow_Of_Roguemaster",10), //Roguemaster's Bow [0] [Two Handed] Item ID# 1719 (Bow_Of_Roguemaster)

("Blue_Fur_Hat",10), //Blue Beanie [0] [Upper Head] Item ID# 5236 (Blue_Fur_Hat)

("Holy_Dagger",10), //Holy Dagger [0] [One Hand] Item ID# 1244 (Holy_Dagger)

("1a1a1",10), //31501 "1a1a1" "Silver Coin"

("1a2a16",10), //31516 "1a2a16" "Monster Card ©"

("1a2a17",10), //31517 "1a2a17" "Monster Card ( B)"

("1a2a18",10), //31518 "1a2a18" "Monster Card (A)"

("3a1a200",10) //31700 "3a1a200" "Yggdrasil Wings"

)

Error: (attached image) So, anyone knows how to solve that issue? thanks!


-- Edited

Sorry for that.. i was doing all again and found the error. I was saving my item group changes in a backup file, not the db/re/item_group.conf.

When I Recompile, it shows a lot of messages like "e:\hercules\1 emulator\src\map\clif.c(1985): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data", but all rebuilds are succeeded.

Is there any problem with that, or i just have to ignore it?
 
How can i fix that?
 
Thanks!

 

1>------ Rebuild All started: Project: char-server, Configuration: Debug Win32 ------

2>------ Rebuild All started: Project: login-server, Configuration: Debug Win32 ------

3>------ Rebuild All started: Project: mapcache, Configuration: Debug Win32 ------

4>------ Rebuild All started: Project: map-server, Configuration: Debug Win32 ------

3> core.c

3> console.c

3> des.c

4> grammar.c

2> grammar.c

3> grfio.c

1> grammar.c

1> libconfig.c

2> libconfig.c

4> libconfig.c

1> scanctx.c

2> scanctx.c

1> scanner.c

3> memmgr.c

4> scanctx.c

2> scanner.c

4> scanner.c

3> showmsg.c

3> strlib.c

1> strbuf.c

2> strbuf.c

4> strbuf.c

4> mt19937ar.c

2> des.c

3> sysinfo.c

1> mt19937ar.c

2> mutex.c

4> conf.c

1> conf.c

3> utils.c

2> thread.c

1> core.c

4> core.c

4> console.c

1> console.c

2> account_sql.c

3> nullpo.c

2> HPMlogin.c

1> db.c

4> db.c

4> des.c

1> des.c

3> mapcache.c

1> ers.c

4> ers.c

2> ipban_sql.c

2> login.c

4> grfio.c

1> HPM.c

1> memmgr.c

4> HPM.c

1> mapindex.c

1> mutex.c

2> loginlog_sql.c

4> memmgr.c

2> conf.c

4> mapindex.c

1> nullpo.c

4> md5calc.c

4> mutex.c

1> random.c

1> showmsg.c

4> nullpo.c

2> core.c

2> console.c

4> random.c

4> showmsg.c

1> socket.c

2> db.c

1> sql.c

1> strlib.c

4> socket.c

2> ers.c

4> sql.c

1> sysinfo.c

2> HPM.c

4> strlib.c

4> sysinfo.c

1> thread.c

2> memmgr.c

2> md5calc.c

2> nullpo.c

4> thread.c

2> random.c

2> showmsg.c

2> socket.c

1> timer.c

4> timer.c

1> utils.c

1> HPMchar.c

4> utils.c

1> char.c

4> atcommand.c

2> sql.c

2> strlib.c

4> battle.c

2> sysinfo.c

1> geoip.c

4> battleground.c

1> int_auction.c

2> timer.c

4> buyingstore.c

2> utils.c

1> int_elemental.c

2> mt19937ar.c

1> int_guild.c

1> int_homun.c

1> int_mail.c

1> int_mercenary.c

4> channel.c

1> int_party.c

4> chat.c

1> int_pet.c

1> int_quest.c

4> chrif.c

1> int_storage.c

2> Creating library ..\login-server.lib and object ..\login-server.exp

1> inter.c

4> clif.c

4> date.c

3> mapcache.vcxproj -> E:\HERCULES\1 EMULATOR\vcproj-14\..\mapcache.exe

5>------ Rebuild All started: Project: plugin-sample, Configuration: Debug Win32 ------

4> duel.c

4>e:\hercules\1 emulator\src\map\channel.c(649): warning C4267: 'initializing': conversion from 'size_t' to 'unsigned char', possible loss of data

4> elemental.c

4>e:\hercules\1 emulator\src\map\clif.c(1985): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(2104): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(3639): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(3676): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(5510): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(5540): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(5595): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(5626): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(5643): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(5829): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4> guild.c

4>e:\hercules\1 emulator\src\map\clif.c(7969): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(8226): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(8256): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(8587): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(8595): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(8995): warning C4267: '=': conversion from 'size_t' to 'unsigned short', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(9029): warning C4267: '=': conversion from 'size_t' to 'unsigned short', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(9841): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(9850): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

5> sample.c

1> loginif.c

4>e:\hercules\1 emulator\src\map\clif.c(14675): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

1> mapif.c

1> pincode.c

4> intif.c

4>e:\hercules\1 emulator\src\map\clif.c(16105): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\clif.c(17640): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4> irc-bot.c

4> itemdb.c

4>e:\hercules\1 emulator\src\map\intif.c(170): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\intif.c(200): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\intif.c(250): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4>e:\hercules\1 emulator\src\map\intif.c(290): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4> log.c

4>e:\hercules\1 emulator\src\map\intif.c(668): warning C4267: '=': conversion from 'size_t' to 'uint16', possible loss of data

4> mail.c

4> map.c

4> mapreg_sql.c

4> homunculus.c

4> HPMmap.c

4> instance.c

4> mercenary.c

2> login-server.vcxproj -> E:\HERCULES\1 EMULATOR\vcproj-14\..\login-server.exe

4> mob.c

6>------ Rebuild All started: Project: plugin-HPMHooking_map, Configuration: Debug Win32 ------

4> npc.c

4> npc_chat.c

4> party.c

4> path.c

4> pc.c

4> pc_groups.c

4> pet.c

6> HPMHooking.c

4> quest.c

4> script.c

1> Creating library ..\char-server.lib and object ..\char-server.exp

4> searchstore.c

4> skill.c

4> status.c

4> storage.c

4> trade.c

4> unit.c

4> vending.c

1> char-server.vcxproj -> E:\HERCULES\1 EMULATOR\vcproj-14\..\char-server.exe

7>------ Rebuild All started: Project: plugin-HPMHooking_char, Configuration: Debug Win32 ------

5> Creating library plugin-sample\Debug\sample.lib and object plugin-sample\Debug\sample.exp

7> HPMHooking.c

4> Creating library ..\map-server.lib and object ..\map-server.exp

5> plugin-sample.vcxproj -> E:\HERCULES\1 EMULATOR\vcproj-14\..\plugins\sample.dll

8>------ Rebuild All started: Project: plugin-HPMHooking_login, Configuration: Debug Win32 ------

7> Creating library plugin-HPMHooking_char\Debug\HPMHooking_char.lib and object plugin-HPMHooking_char\Debug\HPMHooking_char.exp

8> HPMHooking.c

7> plugin-HPMHooking_char.vcxproj -> E:\HERCULES\1 EMULATOR\vcproj-14\..\plugins\HPMHooking_char.dll

8> Creating library plugin-HPMHooking_login\Debug\HPMHooking_login.lib and object plugin-HPMHooking_login\Debug\HPMHooking_login.exp

4> map-server.vcxproj -> E:\HERCULES\1 EMULATOR\vcproj-14\..\map-server.exe

6> Creating library plugin-HPMHooking_map\Debug\HPMHooking_map.lib and object plugin-HPMHooking_map\Debug\HPMHooking_map.exp

8> plugin-HPMHooking_login.vcxproj -> E:\HERCULES\1 EMULATOR\vcproj-14\..\plugins\HPMHooking_login.dll

6> plugin-HPMHooking_map.vcxproj -> E:\HERCULES\1 EMULATOR\vcproj-14\..\plugins\HPMHooking_map.dll

========== Rebuild All: 8 succeeded, 0 failed, 0 skipped ==========

I've made a group of "account variables" associated to custom passive skills that can improve the gameplay and enables some NPC features (like, if the player have the variable #XXX, he can use command @XXXX).

 

I was thinking if it is possible to make custom skills (like the platinum skills), all of them passive, just to possibility the player to view the skills ("variables") conditions, level and effects through skills tree list (alt + s).

 

So, the player can go to skill tree list and check all existant passive custom skills, but can not "open" the skill or level up it, because there is some restrictions to do that.

 

To open or level up, he has to talk with a specific NPC.

 

Is that possible to make custom passive skills like that? If yes, how can I do it? (or Is there a better solution for what i'm planning to do?)

Thanks!