Quest Window's Quest Remind / Counting / Info

[Emistry]

How can i write a Source Code that enable Quest Counting upon player login ?

i mean the quest for these

db/quest_db.txt

What i trying to achieve

When a player online...the server will check the player whether he have "Un-Finished" Quest that shown in the Quest Window ( Alt + U )

if there is any Unfinished Quest there, it will display a message to show something like this

You have X unfinished Quests.

or perhaps can we develope a new command script to get those info ?

something like this ?

Example : ( just a concept )

getquestinfo( int ) 
0 - Quest Name
1 - Quest ID
2 - Quest Status ( Finished / Not )
3 - Total Quest Count 
etc..

---

Another question that are not related with src..

( just a simple question so i think there is no need to create 1 topic, as i lazy to write a long description also xD )

data/questid2display.txt

// Sample Quests

QuestID#Quest NAME#Quest Icon#Image#
Summary of Quest #
Objective of Quest.#

i would like to ask..how can i add a image for this by replace the QUE_NOIMAGE.

but i dunno what is the other available Image ...

[Elijah23]

Another question that are not related with src..

( just a simple question so i think there is no need to create 1 topic, as i lazy to write a long description also xD )

data/questid2display.txt

// Sample Quests

QuestID#Quest NAME#Quest Icon#Image#

Summary of Quest #

Objective of Quest.#

i would like to ask..how can i add a image for this by replace the QUE_NOIMAGE.

but i dunno what is the other available Image ...

you can look in the data or rdata grf for available images.. or add custom image..

it's located in the item folder in texture...

BMP format and 85x85 size

Edit:

Related to the first question, maybe you can use query_sql... to find if the charid has quest which has state as 1...

Edited February 21, 2012 by wakoko321

[Emistry]

Owh..thx for the Reply...

Haha..and ya..you just remind me there is a way to do this using Query_SQL..

xD

i just saw that a moment ago when i browsing my SQL table....

---

Is it possible to create a way to read the Quest Name ? ( Quest Title )

since the name is written in the

db/quest_db.txt

is is possible to make a script command to read the name ? or save the name into the mysql according to the quest id ?

[Elijah23]

actually you can alter the table of SQL to add the quest title.. but i think it would should be added in the src to make it automatic..

What you can do is made the npc script who is giving the quest auto add the quest name after giving the quest...

For example..

setquest (quest_id);

query_sql Update here.. like that...

[Emistry]

ya i know that way....but...there is...too much Quest to be done if using this way xD

just just trying to look for an easier way..

if we modify from NPC to NPC...it could take forever for me to edit..coz i am damn lazy hahaha

besisde...for the SQL Alter... >.<

i am suck in SQL..

anyway just let it be..

if someone have the idea / way to do so, please let me know~ xD