Request NPC [1.4.1]

[ngek202]

@tr0n will there be any chance you can add a Reply function? for the Requests?

[tr0n]

I'm busy at the moment but I think about it.

[Hades03]

can you make 1 but txt i not using sql pls make 1 for txt ty

[tr0n]

UPDATE 1.4.1

Changelogs:

- Added Answer feature for GMs

- Added "My Requests" for player

__________________________________________________________________________

can you make 1 but txt i not using sql pls make 1 for txt ty

Sry I won't support a txt version for this script.

[Syouji]

To everyone who uses @loadnpc to load up an NPC, you can do so now to trigger the OnInit event as this new feature was recently added to rAthena.

[Yetsuki]

Thank you~! Works as intended.

[imanbg]

Also usable script for player that lazy post problem / error / suggestion at Forum Website.. Thanks again tr0n for sharing the script..

[Eroces]

This script works flawlessly. Awesome work tr0n!

[vBrenth]

 DB Error - Field 'answer' doens't have a default value? i'm using 3CeaM/eathena any help ?s

Edited September 4, 2012 by vBrenth

[Emistry]

 DB Error - Field 'answer' doens't have a default value? i'm using 3CeaM/eathena any help ?s
[/quote]
try change 
[code]
`answer` TINYTEXT NOT NULL
[/code]

into this

[code]
`answer` TINYTEXT NOT NULL DEFAULT ''
[/code]

[vBrenth]

Emistry it gives me new error..

saying 'answer' cannot have default value.

[Santino]

previous versions working fine, but got prob with this 1.4.1

 DB Error - Field 'answer' doens't have a default value?

same, but using rAthena ofc.

[EvilPuncker]

previous versions working fine, but got prob with this 1.4.1

 DB Error - Field 'answer' doens't have a default value?

same, but using rAthena ofc.

read emistry answer

[Santino]

previous versions working fine, but got prob with this 1.4.1

 DB Error - Field 'answer' doens't have a default value?

same, but using rAthena ofc.

read emistry answer

read the post after emistry's answer. xD

Emistry it gives me new error..

saying 'answer' cannot have default value.

[Emistry]

erm...vBrenth had solved his problem by switching to this...

https://rathena.org/board/index.php?/files/file/2498-%7B?%7D/

Sorry tr0n >.<

[Santino]

sorry too sir, tr0n. >.> cuz i just got errors.. sorry again! >.<

thanks emistry!

[tr0n]

which error do you exactly experience now on rAthena with 1.4.1 ?

[Santino]

vBrenth stated it sir..

 DB Error - Field 'answer' doens't have a default value? i'm using 3CeaM/eathena any help ? 

but mine, ofc, is rAthena..

Emistry it gives me new error..

saying 'answer' cannot have default value.

Edited September 4, 2012 by Sperm

[megaoka]

To fix your 'answer' problem,

Replace

query_sql "INSERT INTO `request` (`account_id`, `char_name`, `time`, `type`, `message`) " +
"VALUES ("+getcharid(3)+", '"+strcharinfo(0)+"', '"+gettimestr("%Y-%m-%d %H:%M:%S",21)+"', 'Ingame Question', '"+.@requestinput$+"')";

With

query_sql "INSERT INTO `request` (`account_id`, `char_name`, `time`, `type`, `message`,`answer`) " +
"VALUES ("+getcharid(3)+", '"+strcharinfo(0)+"', '"+gettimestr("%Y-%m-%d %H:%M:%S",21)+"', 'Ingame Question', '"+.@requestinput$+"', 'Not Yet Answered')";

The problem is when the INSERT query is called, the `answer` field is not being filled in. (It is Null)

I suggest in the future revisions, `answer` should be able to be left null.

[tr0n]

To fix your 'answer' problem,

Replace

query_sql "INSERT INTO `request` (`account_id`, `char_name`, `time`, `type`, `message`) " +
"VALUES ("+getcharid(3)+", '"+strcharinfo(0)+"', '"+gettimestr("%Y-%m-%d %H:%M:%S",21)+"', 'Ingame Question', '"+.@requestinput$+"')";

With

query_sql "INSERT INTO `request` (`account_id`, `char_name`, `time`, `type`, `message`,`answer`) " +
"VALUES ("+getcharid(3)+", '"+strcharinfo(0)+"', '"+gettimestr("%Y-%m-%d %H:%M:%S",21)+"', 'Ingame Question', '"+.@requestinput$+"', 'Not Yet Answered')";

The problem is when the INSERT query is called, the `answer` field is not being filled in. (It is Null)

I suggest in the future revisions, `answer` should be able to be left null.

good idea, I think I will add this.