-
Notifications
You must be signed in to change notification settings - Fork 0
/
vote_fredisballotbox.js
89 lines (82 loc) · 3.34 KB
/
vote_fredisballotbox.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
// authenticates you with the API standard library
// type `await lib.` to display API autocomplete
const lib = require('lib')({token: process.env.STDLIB_SECRET_TOKEN});
//VOTETHREAD_IS_BALLOT_BOX
// Using Node.js 14.x +
// use "lib" package from npm
if ((context.params.event.member.user.id = `296380281311723542`) //notarobot
|| (context.params.event.member.user.id = `864750688764559390`) //yaourt
|| (context.params.event.member.user.id = `265376610763538452`) //sad_vlad
|| (context.params.event.member.user.id = `341653406634475520`)) { //nawre
// make API request
let typingindicator = await lib.discord.channels['@0.2.2'].typing.create({
channel_id: `${context.params.event.channel_id}`
});
// make API request
let TopicRetrieve = await lib.discord.channels['@0.2.2'].retrieve({
channel_id: `${context.params.event.channel_id}`
});
let messageslist = await lib.discord.channels['@0.2.2'].messages.list({
channel_id: `${context.params.event.channel_id}`,
limit: 1
});
//While loop init
let latestmessageID = `${messageslist[0].id}`;
let messageslistlength = 100;
let vote;
let votecounter = 0;
let whileloopcounter = 0;
//While loop execute
while (messageslistlength === 100) {
whileloopcounter = whileloopcounter + 1;
console.log(`whileloopcounter = ${whileloopcounter}`);
//Retrieve the 100max messages
messageslist = await lib.discord.channels['@0.2.2'].messages.list({
channel_id: `${context.params.event.channel_id}`,
before: `${latestmessageID}`,
limit: 100
});
//While loop readjust
messageslistlength = messageslist.length;
latestmessageID = `${messageslist[(messageslistlength-1)].id}`;
//Log the 100max messages in google sheet
let fieldsetsarray = [];
for (let i = 0; i < messageslistlength; i++) {
vote = messageslist[i].content.split('//');
votecounter = votecounter + 1;
fieldsetsarray.push(
{
'TopicName': `${TopicRetrieve.name}`,
'TopicID': `${messageslist[i].channel_id}`,
'ID': `${messageslist[i].author.id}`,
'Gamer': `${messageslist[i].author.username}`,
'1': `${vote[0]}`,
'2': `${vote[1]}`,
'3': `${vote[2]}`,
'4': `${vote[3]}`,
'5': `${vote[4]}`,
'6': `${vote[5]}`,
'7': `${vote[6]}`,
'8': `${vote[7]}`,
'9': `${vote[8]}`,
'10': `${vote[9]}`
}
);
}
await lib.googlesheets.query['@0.3.0'].insert({
range: `votes!A:N`,
fieldsets: fieldsetsarray
});
}
// make API request
let result = await lib.discord.channels['@0.2.2'].messages.create({
channel_id: `${context.params.event.channel_id}`,
content: `Fin de l'enregistrement de ${votecounter} vote(s).`
});
}
else {
let result = await lib.discord.channels['@0.2.2'].messages.create({
channel_id: `${context.params.event.channel_id}`,
content: `Sorry, you don't have access to this command.`
});
}