ngek202 Posted April 12, 2012 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 530 Reputation: 33 Joined: 01/17/12 Last Seen: August 16, 2017 Share Posted April 12, 2012 @tr0n will there be any chance you can add a Reply function? for the Requests? Quote Link to comment Share on other sites More sharing options...
tr0n Posted April 12, 2012 Group: Members Topic Count: 28 Topics Per Day: 0.01 Content Count: 562 Reputation: 152 Joined: 02/21/12 Last Seen: February 27 Author Share Posted April 12, 2012 I'm busy at the moment but I think about it. Quote Link to comment Share on other sites More sharing options...
Hades03 Posted May 25, 2012 Group: Members Topic Count: 81 Topics Per Day: 0.02 Content Count: 242 Reputation: 3 Joined: 01/01/12 Last Seen: August 14, 2015 Share Posted May 25, 2012 can you make 1 but txt i not using sql pls make 1 for txt ty Quote Link to comment Share on other sites More sharing options...
tr0n Posted May 25, 2012 Group: Members Topic Count: 28 Topics Per Day: 0.01 Content Count: 562 Reputation: 152 Joined: 02/21/12 Last Seen: February 27 Author Share Posted May 25, 2012 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. Quote Link to comment Share on other sites More sharing options...
Syouji Posted May 25, 2012 Group: Members Topic Count: 70 Topics Per Day: 0.02 Content Count: 1245 Reputation: 392 Joined: 11/19/11 Last Seen: January 15, 2020 Share Posted May 25, 2012 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. Quote Link to comment Share on other sites More sharing options...
Yetsuki Posted May 25, 2012 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 34 Reputation: 7 Joined: 04/24/12 Last Seen: December 19, 2012 Share Posted May 25, 2012 Thank you~! Works as intended. Quote Link to comment Share on other sites More sharing options...
imanbg Posted July 17, 2012 Group: Members Topic Count: 0 Topics Per Day: 0 Content Count: 9 Reputation: 0 Joined: 01/04/12 Last Seen: May 12, 2014 Share Posted July 17, 2012 Also usable script for player that lazy post problem / error / suggestion at Forum Website.. Thanks again tr0n for sharing the script.. Quote Link to comment Share on other sites More sharing options...
Eroces Posted July 17, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 135 Reputation: 5 Joined: 06/25/12 Last Seen: September 22, 2012 Share Posted July 17, 2012 This script works flawlessly. Awesome work tr0n! Quote Link to comment Share on other sites More sharing options...
vBrenth Posted September 4, 2012 Group: Members Topic Count: 35 Topics Per Day: 0.01 Content Count: 311 Reputation: 46 Joined: 11/06/11 Last Seen: Wednesday at 09:59 AM Share Posted September 4, 2012 (edited) DB Error - Field 'answer' doens't have a default value? i'm using 3CeaM/eathena any help ?s Edited September 4, 2012 by vBrenth Quote Link to comment Share on other sites More sharing options...
Emistry Posted September 4, 2012 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10013 Reputation: 2348 Joined: 10/28/11 Last Seen: April 6 Share Posted September 4, 2012 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] Quote Link to comment Share on other sites More sharing options...
vBrenth Posted September 4, 2012 Group: Members Topic Count: 35 Topics Per Day: 0.01 Content Count: 311 Reputation: 46 Joined: 11/06/11 Last Seen: Wednesday at 09:59 AM Share Posted September 4, 2012 Emistry it gives me new error.. saying 'answer' cannot have default value. Quote Link to comment Share on other sites More sharing options...
Santino Posted September 4, 2012 Group: Members Topic Count: 25 Topics Per Day: 0.01 Content Count: 198 Reputation: 47 Joined: 08/01/12 Last Seen: July 1, 2015 Share Posted September 4, 2012 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. Quote Link to comment Share on other sites More sharing options...
EvilPuncker Posted September 4, 2012 Group: Members Topic Count: 19 Topics Per Day: 0.00 Content Count: 713 Reputation: 70 Joined: 11/08/11 Last Seen: April 9, 2023 Share Posted September 4, 2012 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 Quote Link to comment Share on other sites More sharing options...
Santino Posted September 4, 2012 Group: Members Topic Count: 25 Topics Per Day: 0.01 Content Count: 198 Reputation: 47 Joined: 08/01/12 Last Seen: July 1, 2015 Share Posted September 4, 2012 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 answerread the post after emistry's answer. xD Emistry it gives me new error.. saying 'answer' cannot have default value. Quote Link to comment Share on other sites More sharing options...
Emistry Posted September 4, 2012 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10013 Reputation: 2348 Joined: 10/28/11 Last Seen: April 6 Share Posted September 4, 2012 erm...vBrenth had solved his problem by switching to this... https://rathena.org/board/index.php?/files/file/2498-%7B?%7D/ Sorry tr0n >.< 1 Quote Link to comment Share on other sites More sharing options...
Santino Posted September 4, 2012 Group: Members Topic Count: 25 Topics Per Day: 0.01 Content Count: 198 Reputation: 47 Joined: 08/01/12 Last Seen: July 1, 2015 Share Posted September 4, 2012 sorry too sir, tr0n. >.> cuz i just got errors.. sorry again! >.< thanks emistry! Quote Link to comment Share on other sites More sharing options...
tr0n Posted September 4, 2012 Group: Members Topic Count: 28 Topics Per Day: 0.01 Content Count: 562 Reputation: 152 Joined: 02/21/12 Last Seen: February 27 Author Share Posted September 4, 2012 which error do you exactly experience now on rAthena with 1.4.1 ? Quote Link to comment Share on other sites More sharing options...
Santino Posted September 4, 2012 Group: Members Topic Count: 25 Topics Per Day: 0.01 Content Count: 198 Reputation: 47 Joined: 08/01/12 Last Seen: July 1, 2015 Share Posted September 4, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
megaoka Posted September 12, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 7 Reputation: 1 Joined: 08/15/12 Last Seen: February 15, 2018 Share Posted September 12, 2012 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. 1 Quote Link to comment Share on other sites More sharing options...
tr0n Posted September 13, 2012 Group: Members Topic Count: 28 Topics Per Day: 0.01 Content Count: 562 Reputation: 152 Joined: 02/21/12 Last Seen: February 27 Author Share Posted September 13, 2012 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.