GADDvent Calendar

[Monkeynutz 230]

GADDvent Calendar

Simple script.... It's an Advent calendar for Christmas!

It's been a while since i gave you all something. I spent the past few days creating this. Follow the instructions, shoot me a message on Discord if you need help!

https://github.com/GamingAtDeathsDoor/GADDvent

Update: Added day check to success messages to no longer display "Come back tomorrow" if it's Christmas day. Just merge your ClaimGift.sqf with the new one.
Update: Fixed ExileServerStartTime variable not defined. Please re-read the instructions all the way to the bottom if you see this issue. You will need to download the addon again and grab the files from the mission side of the addon.
Update: Fixed description.ext to include missing sound file.
Update: Added a configurable option to weapons where you can have it spawn with magazines and also choose the number of mags it will spawn with.  To update, merge your ClaimGift.sqf.
Update: You can now choose the quantity of the items you wish to give players.

Edited December 11, 2018 by Monkeynutz
Update.

[Z80CPU 527]

Hello @Monkeynutz,

That is an interesting piece of code! 

On behalf of others, thanks!

 

[[GC] lutz!p0 4]

Bekomme Folgende Fehlermeldung:

Get the following error message

[09:23:46:092518 +02:00] [Thread 6416] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Incorrect integer value: 'any' for column 'gaddvent' at row 1	[mysql_stmt_errno]: 1366	[mysql_stmt_sqlstate]: HY000	[statemnt]: UPDATE account SET gaddvent = ? WHERE uid = ?
[09:23:46:092643 +02:00] [Thread 6416] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session

 

Edited December 1, 2018 by [GC] lutz!p0

[[x] cit 23]

18 minutes ago, [GC] lutz!p0 said:

Bekomme Folgende Fehlermeldung:

Get the following error message

[09:23:46:092518 +02:00] [Thread 6416] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Incorrect integer value: 'any' for column 'gaddvent' at row 1	[mysql_stmt_errno]: 1366	[mysql_stmt_sqlstate]: HY000	[statemnt]: UPDATE account SET gaddvent = ? WHERE uid = ?
[09:23:46:092643 +02:00] [Thread 6416] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session

 

You need to update your db and add to exile ini some code.
 

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; GADDVent
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[gaddventGetNumber]
SQL1_1 = SELECT gaddvent FROM account WHERE uid = ?
Number Of Inputs = 1
SQL1_INPUTS = 1
OUTPUT = 1

[gaddventUpdateNumber]
SQL1_1 = UPDATE account SET gaddvent = ? WHERE uid = ?
Number Of Inputs = 2
SQL1_INPUTS = 1,2

 

[[x] cit 23]

I have all working, but trader show me only this: GADDvent Calendar", "Opening Gift for today! Stand by!

Then I hear music and no gift

[Brenner 114]

should it really be

Spoiler

ALTER TABLE `tanoa`.`account`

in GADDvent.sql or we should change it to the scheema we are using?

Using Chernarus 2035 map. Or this is Tanoa only addon?

Thanks

Edited December 1, 2018 by Brenner

[Monkeynutz 230]

4 hours ago, [x] cit said:

I have all working, but trader show me only this: GADDvent Calendar", "Opening Gift for today! Stand by!

Then I hear music and no gift

Description.ext Network Messages need adding.

[Monkeynutz 230]

Updated the script. Please all update your ClaimGift.sqf to the new version. Just copy and paste your gift lists into the new file.

[[x] cit 23]

I fixed my description,
but have no result
server rpt clear
client rpt have:
 

19:02:44 Error in expression <id = getPlayerUID player; 
_dayOfXmas = ExileServerStartTime select 2;
_pinRando>
19:02:44   Error position: <ExileServerStartTime select 2;
_pinRando>
19:02:44   Error Undefined variable in an expression: exileserverstarttime
19:02:44 File mpmissions\__CUR_MP.Altis\custom\GADDvent\ClaimGift.sqf, line 7

19:02:47 Error in expression < GADDventNumber;

if (_GADDventNumber > _dayOfXmas) exitWith
{
["ErrorTitleAndTe>
19:02:47   Error position: <_dayOfXmas) exitWith
{
["ErrorTitleAndTe>
19:02:47   Error Undefined variable in an expression: _dayofxmas
19:02:47 File mpmissions\__CUR_MP.Altis\custom\GADDvent\ClaimGift.sqf, line 107

 

[Monkeynutz 230]

Updated to fix Variable ExileServerStartTime missing. Some users who do not use status bars might experience an error where the variable is undefined. You will need to define it using the overrides provided in the repo.
Thanks @kuplion for the swift fix  

Edited December 1, 2018 by Monkeynutz