[Help]How to open Quiz Event.

[lordwoldermal]

i have my question and answer in database already but i not sure what is m_chState is so i put 0 to 9 for my 10 question.


but when the Quiz next step the error say "Quiz List Load Failed!"


There is an error for sql that say

PHP Code:

query:usp_Quiz_Update  [MENTION=2138478]serverin[/MENTION]dex = '01', @m_nQuizType = 2
SQLSTATE:42000 error:[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'usp_Quiz_update' expects parameter '@m_nIndex', which was not supplied. 


but this sql error is just mean close event and shutdown the map.

[xTwiLightx]

Hi,it was already questioned . I made a short guide (in german), but it should be quite clear what to do.


It seems that your server is calling the wrong procedure name.
usp_Quiz_Update takes 5 parameters, while usp_Quiz_load (the one that should be called in your case) takes the two here:

@serverindex and @m_nQuizType

Also, m_chState takes not any numbers as far as I know, but it uses 'T' for the state 'can be answered' and 'F' for 'will not be questioned anymore'.

[lordwoldermal]

Originally Posted by xTwiLightx

Hi,it was already questioned . I made a short guide (in german), but it should be quite clear what to do.


It seems that your server is calling the wrong procedure name.
usp_Quiz_Update takes 5 parameters, while usp_Quiz_load (the one that should be called in your case) takes the two here:[code @dex and @m_nQuizType[/code]Also, m_chState takes not any numbers as far as I know, but it uses 'T' for the state 'can be answered' and 'F' for 'will not be questioned anymore'.

Thank you for reply sir. my question list is load now but just 1 question the other isn't.

there still same problem maybe this make stick with just 1 question.

about usp_Quiz_Update
i have 5 parameter to load


@dex char(2),
@m_nIndex int,
@m_nQuizType int,
@m_nAnswer int,
@m_szQuestion varchar(1024)


update dbo.tblQuiz set m_nQuizType = @m_nQuizType, m_nAnswer = @m_nAnswer, m_szQuestion = @m_szQuestion
where serverindex = @dex and m_nIndex = @m_nIndex


but it still error.

[xTwiLightx]

How does your data in tblQuiz and tblQuizAnswer look like?

[loboblanko]

Hi friend, I've already seen your guide and I found it very interesting and practical. My question is, how do I activate the event, that is, start it so that it happens either as GM or automatically? Where do I set the time or date, something like that?

Originally Posted by xTwiLightx

How does your data in tblQuiz and tblQuizAnswer look like?

I have even added the NPC, I already placed a question and an answer in SQL as you indicate in the guide, now when I click on the NPC and I want to start, those letters appear that translated say "the test event is not scheduled", could you please tell me where I activate it???

[lasdra]

Originally Posted by loboblanko

Hi friend, I've already seen your guide and I found it very interesting and practical. My question is, how do I activate the event, that is, start it so that it happens either as GM or automatically? Where do I set the time or date, something like that?



I have even added the NPC, I already placed a question and an answer in SQL as you indicate in the guide, now when I click on the NPC and I want to start, those letters appear that translated say "the test event is not scheduled", could you please tell me where I activate it???

Check the functextcmd.h on the commands of the quiz system. I remember correctly it is /qeo or something like /qee just find the word Quiz and it will lead right away in this file

[loboblanko]

Originally Posted by lasdra

Check the functextcmd.h on the commands of the quiz system. I remember correctly it is /qeo or something like /qee just find the word Quiz and it will lead right away in this file

Hello friend, I was able to activate it but I did it in the FunctextCmd.cpp file by changing the position of the definition since nothing happened where it was, I compiled and that's it, the detail is that these error reports appear, I would like you to verify them and give me your opinion, the event I created was a type_4c quiz and it works, I'm only worried about these error reports, thanks, I'm attaching them.

[loboblanko]

Another question, the players appear as aibatts, where could I change that so they look like normal players, thanks!!!