#development | Top.gg | Page 88

neon leaf Jan 19, 2023, 9:30 PM

#

yeah, its just weird with my specific problem because I dont even use path for anything request related and it somehow still doesnt work on windows

wheat mesa Jan 19, 2023, 9:30 PM

#

Doing something wrong then

neon leaf Jan 19, 2023, 9:31 PM

#

obviously, do you want to know the details?

tulip ledge Jan 19, 2023, 9:31 PM

#

I tried something like this but it doesn't work

const generateString = (x) => {
  let string = "";

  while (string.length < x) {
    let num = list[Math.floor(Math.random() * list.length)];

    string += num;
    if (string.length === x) return string;
    else if (string.length > x) {
      string = string.substring(0, string.length - (num.length))
    } else string += " ";
  }
}

tulip ledge Jan 19, 2023, 9:32 PM

#

tulip ledge I tried something like this but it doesn't work ```js const generateString = (x)...

Nvm got it to workµ

lyric mountain Jan 19, 2023, 9:33 PM

#

Friends server + music/minigame bot is a thing

#

Not all servers want to be a big community, some just want to chill with friends

chrome orbit Jan 19, 2023, 9:34 PM

#

Yea but 1 server doesn't effect a verification.

lyric mountain Jan 19, 2023, 9:35 PM

#

There're also testing servers to check if a bot is dangerous or not before adding to a big server

chrome orbit Jan 19, 2023, 9:35 PM

#

Bots aren't dangerous, permissions are.

lyric mountain Jan 19, 2023, 9:35 PM

#

chrome orbit Yea but 1 server doesn't effect a verification.

One could say 75 wouldn't also, the important part is that discord team perceives your growth as genuine

lyric mountain Jan 19, 2023, 9:36 PM

#

chrome orbit Bots aren't dangerous, permissions are.

Not exactly

chrome orbit Jan 19, 2023, 9:36 PM

#

You choose the permissions you give a bot when you invite it.

#

A bot can't raid a server if it doesn't have permissions.

lyric mountain Jan 19, 2023, 9:36 PM

#

A bot with just send messages permission could wreck havoc in a server

#

Or mass dm everyone

#

Raid isn't the only dangerous thing

solemn latch Jan 19, 2023, 9:36 PM

#

it can severely impact a small community

chrome orbit Jan 19, 2023, 9:38 PM

#

Yea which is why people go with verified bots. Anyways, my point being back on subject is that a bot requesting verification would have no reason to be in 20+ servers of less than 10 people. That itself just yells botting.

solemn latch Jan 19, 2023, 9:38 PM

#

honestly, most my servers have less than 30 people 👀

#

and have bots ranging from small and unverified to huge

#

having a limit of 10 severely limits a bots potential growth imo

#

For example, some bots we've had in this community only got invited here due to being in our staffs small servers.

If a small bot gets invited to a large community its probably because some staff member had it in a smaller community first.

chrome orbit Jan 19, 2023, 9:43 PM

#

Honestly, my bot is in 5 servers currently and has a member count of 1700. It's all just about the contacts.

#

I was going to make a point, but I don't know where I'm going with this lol

deft wolf Jan 19, 2023, 9:50 PM

#

Congratulations

solemn latch Jan 19, 2023, 9:50 PM

#

👀 maybe topgg has changed my perspective a bit, but it sounds like your bot targets small communities right now.
Which it sounds silly to cut off a portion of your target audience.

deft wolf Jan 19, 2023, 9:51 PM

#

I just don't understand why people set some limit of users on the server so that the bot can be added there

#

It's you as the developer who is trying to get users and the user will find another bot if he can't add yours

solemn latch Jan 19, 2023, 9:53 PM

#

A limit of 1 user okay, maybe?

But I setup bots when creating a server.
Like, me a dev creating a support server before that is sent I'll make sure to have all the important bots first.

deft wolf Jan 19, 2023, 9:55 PM

#

solemn latch A limit of 1 user okay, maybe? But I setup bots when creating a server. Like, m...

Yes, but I mainly mean cases that require, for example, 10 users or 50 in some cases. This is pretty stupid to me

chrome orbit Jan 19, 2023, 10:25 PM

#

I don't set a limit on user count. With my bot being multi purpose, it usually only gets added to bigger servers.

deft wolf Jan 19, 2023, 11:02 PM

#

Maybe so, but I've always wondered what such people think when they require a certain number of users on the server

#

Because apart from the desire to have the right number of users on average per server and limitations, e.g. database, I see no point in doing something like that

sudden geyser Jan 19, 2023, 11:44 PM

#

I've only ever encountered one bot with a user count requirement

#

don't know where you're finding them

dry imp Jan 19, 2023, 11:50 PM

#

ive encountered some bot owner that does that, they said its to prevent sus and inorganic growth

#

idk if thats true or not

sudden geyser Jan 19, 2023, 11:51 PM

#

probably is

#

common for bots to be added to giant bot farms as well

quartz kindle Jan 19, 2023, 11:56 PM

#

one of my bots got fucked because of that

#

got denied verification for suspicious activity or whatever

sudden geyser Jan 19, 2023, 11:58 PM

#

L kid

quartz kindle Jan 20, 2023, 12:00 AM

#

elk kid

hushed robin Jan 20, 2023, 1:29 AM

#

dry imp ive encountered some bot owner that does that, they said its to prevent sus and ...

inorganic growth is based on how many unique server owners your bot has not member counts

#

and suspicious growth is based on how fast your bot grew

dry imp Jan 20, 2023, 1:49 AM

#

well thats funny because i added my bot to like 10 testing servers and its still verified xf

hushed robin Jan 20, 2023, 1:57 AM

#

🤷

rustic nova Jan 20, 2023, 6:48 AM

#

bots dont get unverified for inorganic growth after it gets verified already

#

its only important before verification

rustic nova Jan 20, 2023, 6:49 AM

#

sudden geyser I've only ever encountered one bot with a user count requirement

I've encountered several ones during bot reviewing

dry imp Jan 20, 2023, 6:58 AM

#

rustic nova bots dont get unverified for inorganic growth after it gets verified already

yea but i added mine before verification

#

idk how that works

rustic nova Jan 20, 2023, 6:59 AM

#

probably when discord barely cared about that yet

#

or their verification team is overloaded again

dry imp Jan 20, 2023, 6:59 AM

#

maybe

#

ig its when they started verifying bots like crazy

rustic nova Jan 20, 2023, 7:00 AM

#

yeah

crystal wigeon Jan 20, 2023, 11:31 AM

#

hey anyone use python here?

#

def main() -> str:
    print(type("backend service"), "here")
    return "Backend service"```

This keeps returning a class type 'byte' in the @after_request decorator

#

but the type being printed here is str

#

any idea whats happening? how do i fix this

rustic nova Jan 20, 2023, 11:40 AM

#

you cant force it to return a str in a flask response

#

have python handle it iself

spark flint Jan 20, 2023, 2:00 PM

#

Getting this for MongoDB with Next.js

#

It is from an import

#

#

this is the part of the code where the function is called

spark flint Jan 20, 2023, 2:26 PM

#

actually nvm

#

i found the issue

tulip ledge Jan 20, 2023, 3:00 PM

#

I have this really weird issue. I just made a vite react site and am deploying it to netlify. I noticed that it was a blank page. So I built it on my pc and previewed it and it was also blank! Even though when I run npm run dev it shows the page like it should, but when building it shows a blank page with nothing. When inspecting the page the root element is empty and there are 2 errors in the console TypeError: Go is not a function and TypeError: Go is not a function

rough jackal Jan 20, 2023, 3:24 PM

#

Verifications are quite slow. I don't see enough activity for it to take that long. Please check the requests.
I am trying to generate content for your page but if the process is this slow, unfortunately if this continues we will have to move with competitors.

spark flint Jan 20, 2023, 3:24 PM

#

it is because there are hundreds of bots in queue

#

and only so many people to review them

#

today along there are at least 50 new

#

(looking at logs)

sudden geyser Jan 20, 2023, 3:25 PM

#

why won't they just get more reviewers

spark flint Jan 20, 2023, 3:25 PM

#

they just got more

#

also because it is 18+ for reviewers

#

and most adults aren't on discord

rough jackal Jan 20, 2023, 3:26 PM

#

ask for support or artificial intelligence to handle this. We are already in 2023, are we going to depend on 3 people verifying?

spark flint Jan 20, 2023, 3:26 PM

#

they already just brought some more reviewers on in the last week

#

they are working on it, its clear that they are

rough jackal Jan 20, 2023, 3:27 PM

#

Thank you, see you soon I hope this lack improves.

tulip ledge Jan 20, 2023, 3:28 PM

#

tulip ledge I have this really weird issue. I just made a vite react site and am deploying i...

^^^

boreal iron Jan 20, 2023, 3:32 PM

#

rough jackal ask for support or artificial intelligence to handle this. We are already in 202...

How would you verify bots, automatically, especially interactions which only clients can use?

spark flint Jan 20, 2023, 3:33 PM

#

^^^

#

was gonna reply with that

#

you can't use AI to review bots, it would also be selfbotting

sudden geyser Jan 20, 2023, 3:35 PM

#

you ask bots to whitelist your bot

#

oh interactions

#

yeah good luck

#

pray to discord gods

wheat mesa Jan 20, 2023, 3:45 PM

#

rough jackal Verifications are quite slow. I don't see enough activity for it to take that lo...

bro has a god complex, this process is run by volunteers

#

It’s not fair to expect them to review your bot or you’re going to have to “go to other competitors”

#

You’re in line just like everyone else

tulip ledge Jan 20, 2023, 3:51 PM

#

rough jackal Verifications are quite slow. I don't see enough activity for it to take that lo...

Karen spotted

rough jackal Jan 20, 2023, 3:56 PM

#

tulip ledge Karen spotted

contributing with a bit of reality.

proud oracle Jan 20, 2023, 3:58 PM

#

How can we upload our website in to bot's description in top.gg?

rustic nova Jan 20, 2023, 3:58 PM

#

iframe

rough jackal Jan 20, 2023, 3:58 PM

#

boreal iron How would you verify bots, automatically, especially interactions which only cli...

The possibilities are endless my friend. The last few days I have seen impossible things in discord with AI.

boreal iron Jan 20, 2023, 3:59 PM

#

While the first part might be true, the terms of service will block you from doing what u want.

rustic nova Jan 20, 2023, 3:59 PM

#

this

#

AI is useful, but not good in decision-making as a human with common sense

#

take that twitch AI bot for example, that anime girl called Neuro AI

#

got banned for speaking about a certain topic referring to past history

#

And I can heavily tell you, AI will not be able to review bots

rough jackal Jan 20, 2023, 4:00 PM

#

It probably won't make final approval, but you will have a large percentage of the work done for your 3 reviewers.

rustic nova Jan 20, 2023, 4:01 PM

#

Then have a site bloated with bots that barely:

function
follow our rules
fail to get stopped during review as it didnt pass common sense related things

pearl trail Jan 20, 2023, 4:01 PM

#

e_skully

rustic nova Jan 20, 2023, 4:01 PM

#

AI is not able to interpret common sense

#

It knows facts, it tries to apply these facts to prompts, that fails miserably if it uses the wrong facts

#

and you end up with a bot that gets approved, even though it shouldn't be

#

why am I even here talking about it lol

lyric mountain Jan 20, 2023, 4:02 PM

#

until they manage to give AI conscience most HR jobs are pretty safe

pearl trail Jan 20, 2023, 4:02 PM

#

also most bots are using slash

#

you can't just make an http request to execute a slash command

rustic nova Jan 20, 2023, 4:03 PM

#

thats just the technical limitations on AI

#

on the "interface" its talking through

#

unless you let it view a display, control a mouse, control a keyboard

#

then we're back at ethics, understanding and tos

sudden geyser Jan 20, 2023, 4:03 PM

#

AI (or general automation) would more likely be useful as a means of filtering bad bots

#

So verification is faster

#

but that may just result in more bots getting submitted

lyric mountain Jan 20, 2023, 4:04 PM

#

https://thumbs.gfycat.com/PortlySerpentineBooby-size_restricted.gif

Gfycat

Robot beats "I am not a Robot" Captcha

▶ Play video

sudden geyser Jan 20, 2023, 4:04 PM

#

pen drop

rustic nova Jan 20, 2023, 4:04 PM

#

lyric mountain https://thumbs.gfycat.com/PortlySerpentineBooby-size_restricted.gif

+1

rustic nova Jan 20, 2023, 4:05 PM

#

rough jackal It probably won't make final approval, but you will have a large percentage of t...

also

efficiently < accuracy

#

just to put that in here too

rough jackal Jan 20, 2023, 4:07 PM

#

sudden geyser So verification is faster

sounds good

#

Anyway see you soon my gg's

tulip ledge Jan 20, 2023, 4:42 PM

#

tulip ledge I have this really weird issue. I just made a vite react site and am deploying i...

^^^

urban cape Jan 20, 2023, 5:29 PM

#

I got a question about the HTML video player.

I have a simple webserver and it serves a mkv file.
I have enabled "Experimental Web Platform features", so that I can change the language of my vid.

When I skip to 1 hour it loads the whole movie (So it loads the first 500mb. How to stop that. I does not want to load the whole vid when I skip part of the video.

Someone any idea?
(I do not want to change any movie file to another type)

lyric mountain Jan 20, 2023, 5:31 PM

#

the default html player is very crude

urban cape Jan 20, 2023, 5:31 PM

#

True, so not possible with the default player one?

lyric mountain Jan 20, 2023, 5:32 PM

#

don't think so, it works by reading the file, when u "skip" ur not really skipping, just telling the player to load to where u placed the seeker

#

players like youtube's work by loading only around the seeker

urban cape Jan 20, 2023, 5:34 PM

#

Thank you

quartz kindle Jan 20, 2023, 5:43 PM

#

urban cape I got a question about the HTML video player. I have a simple webserver and it ...

the typical solution is to use a library such as HLS.js or DASH

#

and convert your videos to a fragmented format like m3u8

#

thats what streaming services use

#

or you can do it yourself using some special browser APIs like MediaSource extensions and SourceBuffers

urban cape Jan 20, 2023, 5:49 PM

#

quartz kindle and convert your videos to a fragmented format like m3u8

I do not want to convert 400 movies.
But thanks for the help

quartz kindle Jan 20, 2023, 5:52 PM

#

urban cape I do not want to convert 400 movies. But thanks for the help

the way it usually works is that seeking on the video would send a request with a range header, and the server should respond with the data for said range only

#

however not all video formats support that without breaking the video without having to create fragments or breakpoints beforehand

#

and the html5 video player does not load video chunks by default, hence the need for advanced control with MediaSource extensions

#

another thing you can look into is the webtorrent protocol, which does support streaming many video formats over torrent

solemn latch Jan 20, 2023, 6:03 PM

#

Such a good conversation

#

saving this 👀

stiff dust Jan 20, 2023, 6:48 PM

#

any one used https://github.com/Platane/snk or https://github.com/yoshi389111/github-profile-3d-contrib before? I need help with these

signal lance Jan 20, 2023, 7:03 PM

#

https://top.gg/api/bots/stats broken?

lofty cipher Jan 20, 2023, 7:16 PM

#

How can i fetch a url in html and displayed in a div?

stark abyss Jan 20, 2023, 7:29 PM

#

pwetty sure you gotta use JS and some DOM method sounds about right

boreal iron Jan 20, 2023, 7:31 PM

#

lofty cipher How can i fetch a url in html and displayed in a div?

iframe is the element you're looking for

signal lance Jan 20, 2023, 7:48 PM

#

stark abyss pwetty sure you gotta use JS and some DOM method sounds about right

nah iframe

neon leaf Jan 20, 2023, 7:49 PM

#

I think he means like fetching stats from an api and displaying them

signal lance Jan 20, 2023, 7:50 PM

#

oh yea then u need to use javascript

#

but who still uses html. seriously 💀

stark abyss Jan 20, 2023, 7:52 PM

#

Oh I see

viral badge Jan 20, 2023, 7:52 PM

#

lofty cipher How can i fetch a url in html and displayed in a div?

there is XMLHttpRequest in JS you can use 😏
element.innerHTML = data

signal lance Jan 20, 2023, 7:52 PM

#

i recommend using axios to fetch an api

earnest phoenix Jan 20, 2023, 8:00 PM

#

signal lance i recommend using axios to fetch an api

Why recommend Axios over Undici or Node-Fetch?

signal lance Jan 20, 2023, 8:01 PM

#

cause axios isnt bad

stark abyss Jan 20, 2023, 8:01 PM

#

isnt fetch built in

neon leaf Jan 20, 2023, 8:01 PM

#

stark abyss isnt fetch built in

indeed

#

browser and nodejs

signal lance Jan 20, 2023, 8:02 PM

#

lofty cipher How can i fetch a url in html and displayed in a div?

and its easier to use for someone thats not experienced like this guy

urban cape Jan 20, 2023, 8:02 PM

#

quartz kindle another thing you can look into is the webtorrent protocol, which does support s...

Thank you very much for this suggestion

stark abyss Jan 20, 2023, 8:02 PM

#

then why recommend axios KEKW

earnest phoenix Jan 20, 2023, 8:02 PM

#

signal lance cause axios isnt bad

I don't get it, Axios is literal bloat and doesn't comply with the Fetch API standards well

earnest phoenix Jan 20, 2023, 8:02 PM

#

signal lance and its easier to use for someone thats not experienced like this guy

fetch api is simple

#

wdym

#

Yeah

signal lance Jan 20, 2023, 8:03 PM

#

earnest phoenix fetch api is simple

well if the guy knew how the fetch an api, he wouldn't ask

neon leaf Jan 20, 2023, 8:03 PM

#

maybe he knows but doesnt know how to display it?

earnest phoenix Jan 20, 2023, 8:03 PM

#

axios shid
fetch best

lyric mountain Jan 20, 2023, 8:15 PM

#

axios is an horribly bloated lib

quartz kindle Jan 20, 2023, 8:19 PM

#

node http best lib

sudden geyser Jan 20, 2023, 9:23 PM

#

For neovim users, is it normal for nvim to not take up the entire terminal screen (i.e. the borders)

earnest phoenix Jan 20, 2023, 9:46 PM

#

sudden geyser For neovim users, is it normal for nvim to not take up the entire terminal scree...

Can you show an screenshot of that behavior?

lyric mountain Jan 20, 2023, 9:46 PM

#

Terminals usually have some padding no?

sudden geyser Jan 20, 2023, 9:46 PM

#

maybe

lyric mountain Jan 20, 2023, 9:48 PM

#

Probably just padding

earnest phoenix Jan 20, 2023, 9:48 PM

#

That's normal

sudden geyser Jan 20, 2023, 9:51 PM

#

ah

stiff dust Jan 20, 2023, 10:11 PM

#

any one used https://github.com/Platane/snk or https://github.com/yoshi389111/github-profile-3d-contrib before?

earnest phoenix Jan 20, 2023, 10:16 PM

#

stiff dust any one used <https://github.com/Platane/snk> or <https://github.com/yoshi389111...

It's better to just ask your question rather than asking if someone has used those

stiff dust Jan 20, 2023, 10:24 PM

#

earnest phoenix It's better to just ask your question rather than asking if someone has used tho...

Well I want to use the snake one in my github profile

I follow the guide

I have a respotory with my name created a readme.md file put that 5 line in .md and also in actions created a workflow and paste the snipet in guide but I dont know why when I run the actions I got an err

#

https://media.discordapp.net/attachments/407574788048158724/1066062736288653312/image.png

#

https://media.discordapp.net/attachments/407574788048158724/1066048625320398999/image.png

earnest phoenix Jan 20, 2023, 10:27 PM

#

stiff dust https://media.discordapp.net/attachments/407574788048158724/1066048625320398999/...

That means that the github-actions[bot] user which performs the actions in your GitHub workflows doesn't have the permission to push to that repository of yours, you need to provide a GitHub token for it to be able to push those changes

stiff dust Jan 20, 2023, 10:28 PM

#

stiff dust https://media.discordapp.net/attachments/407574788048158724/1066062736288653312/...

So last line of this code

#

But how can I put my github token??

#

I cant put it just there

#

I have to use env variables

quartz kindle Jan 20, 2023, 10:29 PM

#

stiff dust But how can I put my github token??

https://docs.github.com/en/actions/security-guides/encrypted-secrets

GitHub Docs

Encrypted secrets - GitHub Docs

solemn cipher Jan 20, 2023, 10:30 PM

#

i love it when node.js just randomly stops for no reason

stiff dust Jan 20, 2023, 10:31 PM

#

quartz kindle https://docs.github.com/en/actions/security-guides/encrypted-secrets

Tnx

deft wolf Jan 20, 2023, 10:31 PM

#

There must be a reason

#

If you run it on a vps and want the bot to run 24/7, you must probably use a screen

quartz kindle Jan 20, 2023, 10:32 PM

#

solemn cipher i love it when node.js just randomly stops for no reason

errors were swallowed/hidden and the socket connection disconnected, so node exited because it had nothing else to do

earnest phoenix Jan 20, 2023, 10:32 PM

#

solemn cipher i love it when node.js just randomly stops for no reason

That means there's nothing else for Node.js to do, the event loop is no longer alive as there's nothing to do, it can be due to faulty code of yours or you using a bugged version of a library or something like that

solemn cipher Jan 20, 2023, 10:32 PM

#

earnest phoenix That means there's nothing else for Node.js to do, the event loop is no longer a...

ill look into that, ty

solemn cipher Jan 20, 2023, 10:33 PM

#

deft wolf If you run it on a vps and want the bot to run 24/7, you must probably use a scr...

been using a screen as demonstrated in the screenshot, it just stopped

urban cape Jan 20, 2023, 10:57 PM

#

I do not understand a thing anymore about dns.
Why does every dns provider see my website, except google?
https://dnschecker.org/#A/videosnl.ga
Anyone an idea?

DNS Checker

DNS Checker - DNS Check Propagation Tool

Check DNS Propagation worldwide. DNS Checker provides name server propagation check instantly. Changed nameservers so do a DNS lookup and check if DNS and nameservers have propagated.

quartz kindle Jan 20, 2023, 11:04 PM

#

dns propagation takes time

#

different resolvers have different cache timings

#

a dns entry is only refreshed when the cache expires

urban cape Jan 20, 2023, 11:05 PM

#

But I cant connect to my website through google dns, but I can through cloudflare. Even when waiting 5 min for google dns, it does not work

#

https://dns.google/query?name=videosnl.ga&rr_type=A&ecs= Doesnt do things either

#

OR without DNSSEC https://dns.google/query?name=videosnl.ga&rr_type=A&ecs=&disable_dnssec=true

lyric mountain Jan 20, 2023, 11:09 PM

#

use 1.1.1.1 instead

#

cloudflare ftw

urban cape Jan 20, 2023, 11:09 PM

#

I am using cloudflare dns, but I can not ask every user on the internet to use a specific dns

quartz kindle Jan 20, 2023, 11:11 PM

#

when did you update the domain's dns?

urban cape Jan 20, 2023, 11:11 PM

#

A couple of hours ago, but only changed the AAAA record

quartz kindle Jan 20, 2023, 11:11 PM

#

wait until tomorrow

urban cape Jan 20, 2023, 11:11 PM

#

Ok

lyric mountain Jan 20, 2023, 11:12 PM

#

urban cape I am using cloudflare dns, but I can not ask every user on the internet to use a...

ah, I though it was server -> user the issue, not user -> server

#

that's weird then

scenic wolf Jan 20, 2023, 11:52 PM

#

hello

lyric mountain Jan 21, 2023, 12:01 AM

#

?

scenic wolf Jan 21, 2023, 12:47 AM

#

how are you ?

quaint wasp Jan 21, 2023, 3:52 AM

#

How would I be able to access the "quote" property? I can't to do response.1.quote so I am kinda stuck. Ping in replies.

spark flint Jan 21, 2023, 3:58 AM

#

quaint wasp How would I be able to access the "quote" property? I can't to do `response.1.qu...

have you tried response[0].quote

quaint wasp Jan 21, 2023, 4:05 AM

#

spark flint have you tried response[0].quote

oh yeah thank you I forgot about that..

spark flint Jan 21, 2023, 4:06 AM

#

kek np

chrome orbit Jan 21, 2023, 5:31 AM

#

Am I dumb or what? I have console.log(user.displayedGuilds), which logs an array of each server I'm in including Id, name, Icon, settingsUrl, etc... If I put console.log(user.displayedGuilds.settingsUrl) or anything I just mentioned, it returns undefined when its clearly defined.

#

Here is an example of what is in user.displayedGuilds

#

and with user.displayedGuilds.settingsUrl, I get this

sudden geyser Jan 21, 2023, 5:38 AM

#

you probably want to map over it

chrome orbit Jan 21, 2023, 5:39 AM

#

Possibly. I did it like 2 days ago and it just spam listed each settingsUrl.

sudden geyser Jan 21, 2023, 5:40 AM

#

well it would get the settingsUrl for each item in the array

#

is there an exact thing you need to do?

chrome orbit Jan 21, 2023, 5:43 AM

#

Well not exactly, I'm just wondering why its returning undefined. I just wanted to check all the settingsUrl's for something

#

Looking for a way to sort them by servers the bot is in first.

#

And the settingsUrl should have /manage/:serverId for servers the bot is in and https://discordapp.com/blahblahblah for servers the bot isn't.

#

I've already tried using user.displayedGuilds.sort(), but it will only let me sort servers the bot is NOT in first. If I try the other way, it just ignores the sort.

solemn latch Jan 21, 2023, 6:03 AM

#

👀 displayedGuilds sounds like an array, arrays dont have properties.

#

or well, that property

pearl trail Jan 21, 2023, 6:05 AM

#

it is indeed an array from the screenshot provided

wispy mural Jan 21, 2023, 6:07 AM

#

ry

chrome orbit Jan 21, 2023, 6:26 AM

#

Yea but I can't map something that's undefined.

#

Figured it out. Just added a sort: 0 for servers the bot is in and sort: 1 for servers the bot isn't.

#

stiff dust Jan 21, 2023, 7:03 AM

#

quartz kindle https://docs.github.com/en/actions/security-guides/encrypted-secrets

well I can't create a secret with name GITHUB_TOKEN

sharp geyser Jan 21, 2023, 7:14 AM

#

return new Models[category](result);

logging this normally returns the class as it should but if I return it in a function and then log the result of that function it logs as a newline

quartz kindle Jan 21, 2023, 9:38 AM

#

stiff dust well I can't create a secret with name GITHUB_TOKEN

why not?

stiff dust Jan 21, 2023, 9:57 AM

#

quartz kindle why not?

because github envs shouldn't start with GITHUB

quartz kindle Jan 21, 2023, 10:17 AM

#

stiff dust because github envs shouldn't start with GITHUB

then give it a different name

#

also, just saw this

#

#

https://docs.github.com/en/actions/security-guides/automatic-token-authentication

GitHub Docs

Automatic token authentication - GitHub Docs

north cairn Jan 21, 2023, 10:53 AM

#

Hey I'm having trouble with slashcommands rn

#

Can someone help?

#

So when I try then command it says application did not respond

#

So what do I do

deft wolf Jan 21, 2023, 10:57 AM

#

But that doesn't mean anything, there could be more than one reason for this. It may be the fault of the bot itself, which is not online, for example, or it may be the fault of your command code

north cairn Jan 21, 2023, 10:57 AM

#

Command code ig

#

Bot's normal commands working perfectly

deft wolf Jan 21, 2023, 10:58 AM

#

Slash commands are not quite like normal commands

#

They have some rules of their own

north cairn Jan 21, 2023, 10:58 AM

#


const { readdirSync } = require("fs");

const Discord = require("discord.js")

const { REST } = require('@discordjs/rest');
const { Routes } = require('discord-api-types/v9');
const { token } = process.env.token;
const clientId =  "992806051806191626";

const ascii = require("ascii-table");
const client = require("discord.js");
let table = new ascii("SlashCommands");
table.setHeading("SlashCommand Name", "Loaded Status");


module.exports = (client) => { 
   
  const slashCommands = [];
  readdirSync("./SlashCommands/").forEach(dir => { 
    const commands = readdirSync(`./SlashCommands/${dir}/`).filter((file) =>
      file.endsWith(".js")
    );
    for (const file of commands) {
      const pull = require(`../SlashCommands/${dir}/${file}`);
       slashCommands.push(pull.data.toJSON());
         if (pull.data.name) {
        client.slashCommands.set(pull.name, pull);
        table.addRow(pull.data.name, "✅");
      } else {
        table.addRow(
          pull.data.name,
          `❌`
        );
       
      } 
    }
  
  console.log(table.toString());
  });
  const rest = new REST({ version: '9' }).setToken(process.env.token);

(async () => { 
    
try {
        console.log('Started refreshing application (/) commands.')
        await rest.put(
            Routes.applicationCommands(clientId),
            { body: slashCommands },
    );
  
    console.log('Successfully reloaded application (/) commands.')
  } catch(error) {
    console.log(error) 
}
 });
  }

#

Do u think anything is wrong??

deft wolf Jan 21, 2023, 10:59 AM

#

If the command is displayed in the bot commands and can be used, then this part works as it should. I think so

#

It's probably more about the command and how it is executed

north cairn Jan 21, 2023, 11:00 AM

#

Yes the bot displays that there's a ping command in my bot

#

But issue comes when running it

deft wolf Jan 21, 2023, 11:01 AM

#

Then you have to give us the code of the command itself that is executed when the command is used

north cairn Jan 21, 2023, 11:08 AM

#

const {MessageEmbed, Collection } =  require("discord.js");
const { readdirSync } = require("fs");
const Discord = require("discord.js")
const client = require("../../index")
const fetch = require("node-fetch");
 

const { QuickDB } = require("quick.db")
const db = new QuickDB();

client.on("interactionCreate", async interaction  => {
   
 
  if(!interaction.isCommand()) return;
    const slashCommand = client.slashCommands
  console.log(slashCommand)
    if(!slashCommand) return;
        try {
          if(slashCommand)
 await slashCommand.execute(interaction);
} catch(err) {
            console.log(err)
await interaction.reply({content: "An Error Occured!", ephemeral: true})
        }
})```

#

So this interaction create file

#

So do u see anything wrong

deft wolf Jan 21, 2023, 11:14 AM

#

It depends, it will most likely only work with one command because you don't extract the command from the collection in any way. Just to be sure, if console.log(slashCommand) is working, that part of your bot is working for now

north cairn Jan 21, 2023, 11:15 AM

#

@deft wolf error coming

#

Says slashCommand.execute isnt a fucntion

#

Function*

deft wolf Jan 21, 2023, 11:16 AM

#

Most likely because you didn't select a command from the collection

#

slashCommand is a collection, not a command data

#

You need to do something like this so that your bot selects the appropriate command from the collection and executes its code

command = client.slashCommands.get(interaction.commandName)

#

This code is missing from your interaction create handler

north cairn Jan 21, 2023, 11:31 AM

#

@deft wolf now command says same and when i logged slashCommand,it says undefined

deft wolf Jan 21, 2023, 11:32 AM

#

Because you don't have a client value in your handler

north cairn Jan 21, 2023, 11:33 AM

#

whre?

deft wolf Jan 21, 2023, 11:33 AM

#

You have access to interaction. You need to get the client out of this

deft wolf Jan 21, 2023, 11:33 AM

#

north cairn ```js const {MessageEmbed, Collection } = require("discord.js"); const { readdi...

There

#

All your client in it doesn't exist because you don't have it defined in any way

north cairn Jan 21, 2023, 11:36 AM

#

so i hve 2 do client = require("discord.js")?

deft wolf Jan 21, 2023, 11:37 AM

#

Wait, that's so weirdly written

deft wolf Jan 21, 2023, 11:37 AM

#

north cairn ```js const { readdirSync } = require("fs"); const Discord = require("discord...

This is index.js right?

north cairn Jan 21, 2023, 11:37 AM

#

no

#

its slashcommand handler

deft wolf Jan 21, 2023, 11:38 AM

#

Okay, where do you log into the bot then?

north cairn Jan 21, 2023, 11:39 AM

#

index.js

deft wolf Jan 21, 2023, 11:40 AM

#

north cairn ```js const { readdirSync } = require("fs"); const Discord = require("discord...

Okay but here you are defining a brand new client that is not that you did before

north cairn Jan 21, 2023, 11:41 AM

#

huh????

#

bro thats clientId

deft wolf Jan 21, 2023, 11:42 AM

#

You create the client once, you don't have to create it in every file

deft wolf Jan 21, 2023, 11:42 AM

#

north cairn bro thats clientId

So what is client = require("discord.js")?

north cairn Jan 21, 2023, 11:42 AM

#

i m just defining bruh

deft wolf Jan 21, 2023, 11:43 AM

#

I don't know, I'm so lost honestly

#

Either I don't understand "your programming style" or I don't know

north cairn Jan 21, 2023, 11:44 AM

#

sad

#

do u know someone who can help me??

deft wolf Jan 21, 2023, 11:47 AM

#

You can ask on other servers or wait for others on this server to read these messages and maybe they will know what to do about it

next storm Jan 21, 2023, 1:33 PM

#

Any way to change the ip/port in ubuntu using console commands?

rustic nova Jan 21, 2023, 2:33 PM

#

what ip/port?

next storm Jan 21, 2023, 2:50 PM

#

actually my bot isn't replying so i guess the possible reason for that would be that it got rate limit. So to fix it the only way is to change the ip address of host

rustic nova Jan 21, 2023, 2:51 PM

#

you cant just "change the ip of host"

#

especially not by just doing commands

craggy pine Jan 21, 2023, 2:53 PM

#

What you can do however is make a ticket to your VPS to request a change of IP which some do allow for good reasons.

rustic nova Jan 21, 2023, 3:02 PM

#

yeah you can request a change that is true

#

you can purchase another IP too

#

but you cant just tell linux to "change my ip"

#

unless you were provided an ip then you can change that in the networking config

sudden geyser Jan 21, 2023, 3:24 PM

#

next storm actually my bot isn't replying so i guess the possible reason for that would be ...

try sending a request via curl and see the info

next storm Jan 21, 2023, 3:35 PM

#

sudden geyser try sending a request via curl and see the info

how

sudden geyser Jan 21, 2023, 3:36 PM

#

e.g. curl -H "Authorization: Bearer <...>" -H "User-Agent: DiscordBot(..., ...)" https://discord.com/api/v10/users/@me

#

<...> is your bot token

next storm Jan 21, 2023, 3:37 PM

#

and DiscordBot(..., ...)?

sudden geyser Jan 21, 2023, 3:37 PM

#

it's a user agent discord likes you to attach

#

see https://discord.com/developers/docs/reference#user-agent

Discord Developer Portal

Discord Developer Portal — API Docs for Bots and Developers

Integrate your service with Discord — whether it's a bot or a game or whatever your wildest imagination can come up with.

next storm Jan 21, 2023, 3:37 PM

#

so do I've to put something between ()

sudden geyser Jan 21, 2023, 3:38 PM

#

where to find the library you're using and the version being used

#

e.g. where to find your bot and whatever version

#

probably doesn't matter much here

next storm Jan 21, 2023, 3:41 PM

#

{"code": 0, "message": "You are being blocked from accessing our API temporarily due to exceeding our rate limits frequently. Please read our docs at https://discord.com/developers/docs/topics/rate-limits to prevent this moving forward."}```💀

solemn latch Jan 21, 2023, 3:41 PM

#

👀 what in the world are you doing to get ratelimited frequently.

sudden geyser Jan 21, 2023, 3:41 PM

#

lol

#

try running it again with the -I flag

#

it should display some info about how long in the headers

next storm Jan 21, 2023, 3:42 PM

#

💀 I've my bot's join logs using webhook, and my bot was added in 200 servers within 5 mins, so you know what would have happened

solemn latch Jan 21, 2023, 3:43 PM

#

webhooks have their own ratelimits separate from the bot.

spark flint Jan 21, 2023, 3:43 PM

#

I'm trying to get a user from a database using Next.js and getServerSideProps, but session is being returned as null even though the user is logged in

next storm Jan 21, 2023, 3:43 PM

#

curl: (3) URL using bad/illegal format or missing URL
HTTP/2 429
date: Sat, 21 Jan 2023 15:43:02 GMT
content-type: application/json
retry-after: 1907
cache-control: no-cache
report-to: {"endpoints":[{"url":"https:\/\/a.nel.cloudflare.com\/report\/v3?s=QpjNfRZ3B75oRIAvhASqlU0EMV0IFgigbPof6celRBQELZayQvRuqm1%2BvYoeBQ1emAlfE1Og2IQ8K7ecXYVRkbd0vyC6neWuFvAW1zq%2FNjZC6vFkPUv87fSFxZw4"}],"group":"cf-nel","max_age":604800}
nel: {"success_fraction":0,"report_to":"cf-nel","max_age":604800}
strict-transport-security: max-age=31536000; includeSubDomains; preload
x-content-type-options: nosniff
server: cloudflare
cf-ray: 78d129c6d83381d5-IAD
alt-svc: h3=":443"; ma=86400, h3-29=":443"; ma=86400

next storm Jan 21, 2023, 3:44 PM

#

solemn latch webhooks have their own ratelimits separate from the bot.

waiting then how come the host got ratelimit, and it's been 3 hours it got ratelimit

spark flint Jan 21, 2023, 3:44 PM

#

actually, i did console.log(user) after fetching with session.user.id and its returning the database user

#

but when I pass through props, it returns as undefined or null

sudden geyser Jan 21, 2023, 3:45 PM

#

so like 30 minutes

spark flint Jan 21, 2023, 3:45 PM

#

next storm Jan 21, 2023, 3:45 PM

#

sudden geyser so like 30 minutes

what

sudden geyser Jan 21, 2023, 3:45 PM

#

until it expires

next storm Jan 21, 2023, 3:46 PM

#

you mean after 30 mins it will be fixed?

sudden geyser Jan 21, 2023, 3:46 PM

#

it should be

#

but you may just get rate limited again if whatever caused it isn't fixed

spark flint Jan 21, 2023, 3:46 PM

#

spark flint

nvm fixed, i was doing Onboarding({ props}) not Onboarding(props)

next storm Jan 21, 2023, 3:47 PM

#

sudden geyser but you may just get rate limited again if whatever caused it isn't fixed

but how did you come to know that it'll be all right in 30 mins?

sudden geyser Jan 21, 2023, 3:47 PM

#

this header: retry-after: 1907

#

that's in seconds

next storm Jan 21, 2023, 3:48 PM

#

ok

sudden geyser Jan 21, 2023, 3:51 PM

#

since it's just an hour, I have a feeling that you're spamming the api somewhere in a loop, since the rate limit for that is like 10,000 requests in 10 minutes

next storm Jan 21, 2023, 3:53 PM

#

Thinking_Pedrito I've some high loads command, like lockall, hideall which updates all the channels in the server. It's possible that someone would have spammed it in a server where there's a lot of channels

#

though I've used delay after every channel update

#

it updates channel at a speed of 1.75 second/channel

slender wagon Jan 21, 2023, 4:05 PM

#

earnest phoenix Jan 21, 2023, 4:09 PM

#

slender wagon

response.body can be null which seems to be what it's complaining about, assert that it's not null/undefined with the ! operator after the value: response.body!

slender wagon Jan 21, 2023, 4:11 PM

#

that only solved one issue

earnest phoenix Jan 21, 2023, 4:14 PM

#

slender wagon that only solved one issue

Is that response from Undici or?

slender wagon Jan 21, 2023, 4:15 PM

#

the response comes from an url fetch

#

 const response = await fetch(url);

earnest phoenix Jan 21, 2023, 4:17 PM

#

Oh, are you using the built-in fetch() method or?

slender wagon Jan 21, 2023, 4:17 PM

#

yup

#

easier than node-fetch

#

i am aware it's not stable yet so that might be an issue?

#

  let url = "";
  url = req.query.url as typeof url

  const response = await fetch(url);
  if (!response.ok) throw new Error(`unexpected response ${response.statusText}`);

  res.setHeader('Content-Type', 'application/zip');
  res.setHeader('Content-Disposition', 'attachment; filename=demofile.zip');
  await pipeline(response.body!, res);

here

earnest phoenix Jan 21, 2023, 4:18 PM

#

The Fetch API is generally stable at the moment

slender wagon Jan 21, 2023, 4:19 PM

#

this is typescript btw, pretty sure u are already aware

earnest phoenix Jan 21, 2023, 4:23 PM

#

I know, the ReadableStream instance you currently have is different from Node.js' common streams, because the one you have is a readable web stream, it has a pipeTo() method you can use

#

Here's something that can help you
https://developer.mozilla.org/en-US/docs/Web/API/Streams_API/Using_readable_streams

Using readable streams - Web APIs | MDN

That explains the basics of "default" readable streams.

next storm Jan 21, 2023, 4:25 PM

#

@sudden geyser bro I thought my bot was added in 200-300 servers, but now I came to see that it's added in 4.3k new servers 💀

#

bot died while processing 4.3k webhook messages

sudden geyser Jan 21, 2023, 4:26 PM

#

how'd that happen

next storm Jan 21, 2023, 4:26 PM

#

I don't even know

slender wagon Jan 21, 2023, 4:32 PM

#

earnest phoenix Here's something that can help you https://developer.mozilla.org/en-US/docs/Web/...

looking into it but it's really not helping

lament rock Jan 21, 2023, 4:39 PM

#

earnest phoenix I know, the `ReadableStream` instance you currently have is different from Node....

The pipeTo doesn't accept a node common stream as a param, only another web stream. If someone wanted to convert it to a readable, they'd have to do Readable.fromWeb(<undici stream>);

earnest phoenix Jan 21, 2023, 4:40 PM

#

I know, but we don't know what their res variable is so that's why I brought that up

lament rock Jan 21, 2023, 4:40 PM

#

👍

earnest phoenix Jan 21, 2023, 4:42 PM

#

slender wagon looking into it but it's really not helping

What exactly are you trying to pipe response.body to?

slender wagon Jan 21, 2023, 4:45 PM

#

i am downloading a file

earnest phoenix Jan 21, 2023, 4:46 PM

#

slender wagon i am downloading a file

Okay but what is res?

slender wagon Jan 21, 2023, 4:47 PM

#

earnest phoenix Jan 21, 2023, 4:48 PM

#

slender wagon

What library is that from?

slender wagon Jan 21, 2023, 4:48 PM

#

next?

#

res: Override<NextApiResponse, Data>)

earnest phoenix Jan 21, 2023, 4:49 PM

#

I got that, Next in there goes with the other words so it's not obvious

slender wagon Jan 21, 2023, 4:50 PM

#

everything i am using is

import stream from 'stream';
import { promisify } from 'util';
import type { NextApiRequest, NextApiResponse } from 'next'
const pipeline = promisify(stream.pipeline);

earnest phoenix Jan 21, 2023, 5:03 PM

#

So you're piping the readable web stream to a Next.js response object, you can either convert the readable web stream to a Node.js common stream by stream.Readable.fromWeb(), and use that, or you can get the reader of the readable web stream and write (?) to the Next.js response object

const reader = response.body.getReader();

let data = null;
while (!(data = await reader.read()).done)
  // Write to response object with the value of `data.value`

#

I don't use Next.js so I'm not sure if that's feasible or not

craggy pine Jan 21, 2023, 5:08 PM

#

Not exactly development related, but what's the purpose of these "Hoarding bots" servers? I just got a 15k server and I was like pog until I ran an eval to see who was a bot and who wasn't and 12 people are users KEKW

earnest phoenix Jan 21, 2023, 5:11 PM

#

craggy pine Not exactly development related, but what's the purpose of these "Hoarding bots"...

The purpose is to mostly test them and break them to either report the bugs to the developers or for malicious intents

craggy pine Jan 21, 2023, 5:12 PM

#

I haven;t had a single command ran via these servers.

#

i log each command into my db

earnest phoenix Jan 21, 2023, 5:14 PM

#

They probably plan to do that later, I mean there's 15k bots as you mentioned there

spark flint Jan 21, 2023, 5:15 PM

#

craggy pine Not exactly development related, but what's the purpose of these "Hoarding bots"...

my bot is added to those all the time

earnest phoenix Jan 21, 2023, 5:15 PM

#

Flashback to this server having every approved bots here, !help and boom

spark flint Jan 21, 2023, 5:15 PM

#

i call them "API fuckery" servers

#

they add thousands of bots to spam commands and get bots, channels and servers ratelimited

earnest phoenix Jan 21, 2023, 5:17 PM

#

When my bot was still alive I made it leave every server that had a lot of bots on join

#

It's a nice way to prevent them from breaking anything or getting the bot ratelimited

craggy pine Jan 21, 2023, 5:42 PM

#

earnest phoenix When my bot was still alive I made it leave every server that had a lot of bots ...

What was the threshhold you used? Like 75% of users are bots?

earnest phoenix Jan 21, 2023, 5:43 PM

#

craggy pine What was the threshhold you used? Like 75% of users are bots?

65%

craggy pine Jan 21, 2023, 5:43 PM

#

Ok.

earnest phoenix Jan 21, 2023, 5:43 PM

#

Although 70% is also good

craggy pine Jan 21, 2023, 5:43 PM

#

What would the math to that look like

earnest phoenix Jan 21, 2023, 5:51 PM

#

craggy pine What would the math to that look like

For example, for 70% you would have to divide the member count by 10 and multiply it by 7, and compare the number of bots in the server to the member count, if the number of bots is greater than or equal to the 70% of the total member count, leave the server

sudden geyser Jan 21, 2023, 6:13 PM

#

Does anyone use oh my zsh here? Any recommended plugins?

earnest phoenix Jan 21, 2023, 7:23 PM

#

sudden geyser Does anyone use oh my zsh here? Any recommended plugins?

Plugins or themes?

sudden geyser Jan 21, 2023, 7:23 PM

#

just plugins

#

already have a decent theme

earnest phoenix Jan 21, 2023, 7:31 PM

#

sudden geyser just plugins

The only plugin I can recommend (and also the only plugin I use) is https://github.com/zsh-users/zsh-syntax-highlighting

GitHub

GitHub - zsh-users/zsh-syntax-highlighting: Fish shell like syntax ...

Fish shell like syntax highlighting for Zsh. Contribute to zsh-users/zsh-syntax-highlighting development by creating an account on GitHub.

#

But here's a huge list of all the useful plugins here
https://github.com/unixorn/awesome-zsh-plugins#plugins

GitHub

GitHub - unixorn/awesome-zsh-plugins: A collection of ZSH framework...

A collection of ZSH frameworks, plugins, themes and tutorials. - GitHub - unixorn/awesome-zsh-plugins: A collection of ZSH frameworks, plugins, themes and tutorials.

rustic nova Jan 21, 2023, 7:40 PM

#

@drowsy crag hi

drowsy crag Jan 21, 2023, 7:41 PM

#

hey

rustic nova Jan 21, 2023, 7:44 PM

#

swag

signal lance Jan 21, 2023, 9:01 PM

#

anything to remove that form the number type for inputs?

sudden geyser Jan 21, 2023, 9:04 PM

#

try opening the inspector and seeing what properties is making that show up

quartz kindle Jan 21, 2023, 9:04 PM

#

or dont use type number

rustic nova Jan 21, 2023, 9:04 PM

#

use textfield instead and just dynamically check if it is a number

sudden geyser Jan 21, 2023, 9:05 PM

#

an input with a number here is probably better semantically

rustic nova Jan 21, 2023, 9:06 PM

#

you cant remove it unless you make it appear as a textbox on mozilla for example

#

also generally probably better to handle the ID as an string imo

compact pier Jan 21, 2023, 10:24 PM

#

quartz kindle or dont use type number

why?

quartz kindle Jan 21, 2023, 10:56 PM

#

compact pier why?

its inconsistent across browsers and has a lot of weird quirks

#

most standard input types have similar issues

#

thats why its usually preferred to use regular inputs and control them with js

#

the only advantage is that pn mobile it shows the numeric keyboad onstead of default

#

but i think that can also be forced using some html attributes

light jungle Jan 22, 2023, 2:30 AM

#

Is a global ban list where I can add raider/bot accounts to against TopGG tos? Servers would have to manually enable it in their servers, not on by default.

chrome orbit Jan 22, 2023, 2:34 AM

#

light jungle Is a global ban list where I can add raider/bot accounts to against TopGG tos? S...

Global ban list are fine.

thorn barn Jan 22, 2023, 11:56 AM

#

is there a way to test votes on top.gg because i'm doing a reward system on my bot

earnest phoenix Jan 22, 2023, 11:58 AM

#

thorn barn is there a way to test votes on top.gg because i'm doing a reward system on my b...

What do you mean by "text votes"?

thorn barn Jan 22, 2023, 11:59 AM

#

earnest phoenix What do you mean by "text votes"?

test votes*

#

by bad

earnest phoenix Jan 22, 2023, 12:02 PM

#

thorn barn test votes*

You can listen to bot votes on Top.gg via it's API which you can get help for in #topgg-api

Additionally you can check if someone voted for your bot with this Top.gg API endpoint:
https://docs.top.gg/api/bot/#individual-user-vote

Top.gg documentation

Bots

API resource for a bots or apps on a platform like Discord

thorn barn Jan 22, 2023, 12:06 PM

#

earnest phoenix You can listen to bot votes on Top.gg via it's API which you can get help for in...

#topgg-api message

wheat mesa Jan 22, 2023, 3:06 PM

#

Anyone else have this server add their bot? Seems suspicious, in less than 8 hours their guild member count has increased by nearly 2000 members

sudden geyser Jan 22, 2023, 3:07 PM

#

probably a bot farm

wheat mesa Jan 22, 2023, 3:08 PM

#

That’s what I’m thinking, haven’t updated my bot to be able to look at bot to member ratio since I haven’t touched the code in nearly 2 years

deft wolf Jan 22, 2023, 3:10 PM

#

Not this server but the name is similar so it's possible it's their server

wheat mesa Jan 22, 2023, 3:13 PM

#

That’s the same server, they update the member count in the server name

#

Pretty sure it’s a bot farm, this is odd:

#

Though I believe memberCount in my lib is only for cached users

deft wolf Jan 22, 2023, 3:18 PM

#

Indeed, it's the same server

wheat mesa Jan 22, 2023, 3:19 PM

#

Definitely suspicious if they’ve grown 20k members in that short of a time period

#

Might be scraping top.gg and adding every bot that they can

deft wolf Jan 22, 2023, 3:20 PM

#

My bot was added there on January 19th

#

20,000 bots in 3 days is a lot

wheat mesa Jan 22, 2023, 3:20 PM

#

3 days

#

Yeah

#

20k legitimate members in 3 days is also a lot

#

Either way I doubt it’s legit

icy burrow Jan 22, 2023, 3:37 PM

#

Hmm seems like there are a whole bunch of them

wheat mesa Jan 22, 2023, 3:39 PM

#

It’s the same server, they change the name to update with the server count

rustic nova Jan 22, 2023, 3:40 PM

#

"Join Server"

#

sus

deft wolf Jan 22, 2023, 3:40 PM

#

But wait, a server made in 2016?

#

I would have thought they would do something like this on some new servers/accounts

jaunty basalt Jan 22, 2023, 3:41 PM

#

How to change stuff of npm package we are using in our discord bot??

wheat mesa Jan 22, 2023, 3:42 PM

#

Why would you do that?

jaunty basalt Jan 22, 2023, 3:43 PM

#

jaunty basalt How to change stuff of npm package we are using in our discord bot??

Plz tell dudes

wheat mesa Jan 22, 2023, 3:43 PM

#

This is an XY problem

#

Tell us why you would want to do that first

#

Because you almost never want to do that to solve a problem

rustic nova Jan 22, 2023, 3:44 PM

#

"i have this error and I want to remove the error message"

wheat mesa Jan 22, 2023, 3:44 PM

#

Thats what I’m thinking

#

In which case the error is 99.9% probably from your code, not the package’s

lyric mountain Jan 22, 2023, 4:16 PM

#

jaunty basalt How to change stuff of npm package we are using in our discord bot??

Clone the library and add to the project

#

Worth to note, you won't receive any more updates if u do this

#

And you're very likely to wreck something up

wheat mesa Jan 22, 2023, 4:19 PM

#

I very highly doubt that his issue is from the library

craggy pine Jan 22, 2023, 4:20 PM

#

deft wolf Not this server but the name is similar so it's possible it's their server

That's the server I was added too recently. Like 20k

deft wolf Jan 22, 2023, 4:22 PM

#

At least now we know where "60,000 bot users" come from

rustic nova Jan 22, 2023, 4:27 PM

#

lyric mountain Worth to note, you won't receive any more updates if u do this

and not support from the developers either

#

KEKW

lyric mountain Jan 22, 2023, 4:27 PM

#

Sometimes all u need is to suffer a little to see why people tell u not to do something

#

They never listen otherwise

lofty cipher Jan 22, 2023, 4:33 PM

#

How can i fix this?

node:events:491
      throw er; // Unhandled 'error' event
      ^

Error [InteractionAlreadyReplied]: The reply to this interaction has already been sent or deferred.
    at ChatInputCommandInteraction.reply (C:\Users\diana\Documents\vscode\Hundy Bot\Hundybot\node_modules\discord.js\src\structures\interfaces\InteractionResponses.js:102:46)     
    at Client.<anonymous> (C:\Users\diana\Documents\vscode\Hundy Bot\Hundybot\index.js:68:25)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
Emitted 'error' event on Client instance at:
    at emitUnhandledRejectionOrErr (node:events:394:10)
    at process.processTicksAndRejections (node:internal/process/task_queues:84:21) {
  code: 'InteractionAlreadyReplied'
}

Node.js v18.12.0

earnest phoenix Jan 22, 2023, 4:34 PM

#

by reading the error

craggy pine Jan 22, 2023, 4:48 PM

#

The reply to this interaction has already been sent or deferred.

tulip ledge Jan 22, 2023, 4:52 PM

#

Can anyone help me fix this intellisense issue with vscode. I'm learning go and have declared a type deck in a file called deck.go but when using the type deck in my main.go file vscode gives me this error but I can run the code fine like it should, it's just really annoying.

wheat mesa Jan 22, 2023, 5:11 PM

#

have you installed the recommended extensions for go?

spark flint Jan 22, 2023, 5:18 PM

#

I can't get files to upload with Chakra + Next.js

#

#

the file is not included in the body

quartz kindle Jan 22, 2023, 5:27 PM

#

you need to add the boundary to the header

#

is that browser side? why not use fetch?

wheat mesa Jan 22, 2023, 5:30 PM

#

would you be able to use axios client side?

quartz kindle Jan 22, 2023, 5:31 PM

#

i think axios works on both node and browser

spark flint Jan 22, 2023, 5:41 PM

#

hmm

tulip ledge Jan 22, 2023, 8:34 PM

#

wheat mesa have you installed the recommended extensions for go?

yesµ

compact pier Jan 22, 2023, 8:38 PM

#

quartz kindle i think axios works on both node and browser

yes, they do

earnest phoenix Jan 23, 2023, 12:14 AM

#

Could there be a Pokemon Trade feature for Mudae?

cerulean ingot Jan 23, 2023, 12:26 AM

#

ive got my website up on my vps with nginx and shit and locally, my api works, but when it try to do it on the vps, i get this:

[blocked] The page at https://domain.com/ was not allowed to display insecure content from http://ip:port/get_sections. (a42c66d.js, line 2)
Not allowed to request resource
Fetch API cannot load http://ip:port/get_sections due to access control checks.
TypeError: Load failed

and btw i do do this:

app = Quart(__name__)
app=cors(app)
app.config['CORS_HEADERS'] = 'Content-Type' # i use cors...

# and

@route_cors()```
but it works when i do ip:port/get_sections just in my search bar...

rustic nova Jan 23, 2023, 12:45 AM

#

domain.com tries to reach out to ip:port, which fails due to cors not matching ip:port

#

You need to set your cors headers to allow domain.com

#

also, https is needed according to the message?

solemn latch Jan 23, 2023, 12:58 AM

#

which, if its an api it should have https

cerulean ingot Jan 23, 2023, 1:04 AM

#

yeah i fixed that

#

for some reason when i run my project locally for a specific file my style is correctly opacity: 75% and when i run it on my server, and npm run build and npm run start it is opacity: 1

lyric mountain Jan 23, 2023, 1:19 AM

#

Can't u just use 0.75?

cerulean ingot Jan 23, 2023, 1:42 AM

#

ya ill try that

sharp geyser Jan 23, 2023, 4:32 AM

#

lyric mountain Can't u just use `0.75`?

but thats a decimal not a percentage

#

mmLol

lyric mountain Jan 23, 2023, 5:04 AM

#

Listen here you little shit

earnest phoenix Jan 23, 2023, 7:14 AM

#

/imagine

rustic nova Jan 23, 2023, 7:21 AM

#

this aint midjourney

#

https://discord.com/invite/midjourney

sharp geyser Jan 23, 2023, 7:31 AM

#

rustic nova this aint midjourney

banned for ads

rustic nova Jan 23, 2023, 7:31 AM

#

indeed

stiff dust Jan 23, 2023, 9:53 AM

#

rustic nova https://discord.com/invite/midjourney

ADVERTISEMENT ALO

warm surge Jan 23, 2023, 11:26 AM

#

rustic nova https://discord.com/invite/midjourney

https://tenor.com/view/family-bvsiness-skip-this-ad-shoe-gang-kxng-crooked-crooked-i-gif-19977752

Tenor

quartz kindle Jan 23, 2023, 1:30 PM

#

midjourney, topjourney, junglejourney, botjourney

#

supportjourney

radiant kraken Jan 23, 2023, 1:59 PM

#

do you know a way on how to compare two binary files? @earnest phoenix

#

like is there a hash file command in linux or something

radiant kraken Jan 23, 2023, 2:01 PM

#

quartz kindle midjourney, topjourney, junglejourney, botjourney

top.gg -> top.journey

earnest phoenix Jan 23, 2023, 2:01 PM

#

radiant kraken like is there a hash file command in linux or something

Use the sha256sum command

#

It'll show the SHA256 hash of the binary file, which you can use to compare them

radiant kraken Jan 23, 2023, 2:03 PM

#

iara_nodnotes

radiant kraken Jan 23, 2023, 2:32 PM

#

@earnest phoenix how

earnest phoenix Jan 23, 2023, 2:40 PM

#

radiant kraken <@456226577798135808> how

You're most likely trying to run a 32-bit executable on a 64-bit environment, or vice-versa

radiant kraken Jan 23, 2023, 2:41 PM

#

earnest phoenix You're most likely trying to run a 32-bit executable on a 64-bit environment, or...

which? node?

earnest phoenix Jan 23, 2023, 2:41 PM

#

If that's what's causing the error

#

Try running node -v and see if it causes that error

radiant kraken Jan 23, 2023, 2:43 PM

#

nope

#

installed it with sudo apt install nodejs

earnest phoenix Jan 23, 2023, 2:45 PM

#

You shouldn't use the Node.js binaries provided by those repositories, they can be outdated or not work at all, use https://nvm.sh/

GitHub

nvm/README.md at master · nvm-sh/nvm

Node Version Manager - POSIX-compliant bash script to manage multiple active node.js versions - nvm/README.md at master · nvm-sh/nvm

radiant kraken Jan 23, 2023, 2:46 PM

#

earnest phoenix You shouldn't use the Node.js binaries provided by those repositories, they can ...

bruh

earnest phoenix Jan 23, 2023, 2:46 PM

#

After installing nvm, run nvm install --lts to install the latest LTS release

radiant kraken Jan 23, 2023, 2:47 PM

#

damn 😔

#

at this point i think i'm over-engineering my library

#

too much scripts and CI-related things

earnest phoenix Jan 23, 2023, 2:49 PM

#

Nah it's fine

sudden geyser Jan 23, 2023, 3:18 PM

#

like your country?

quartz kindle Jan 23, 2023, 4:09 PM

#

the binary must have corruption like your country

#

lmao

compact pier Jan 23, 2023, 5:54 PM

#

#

why is this so?

#

[1-10][a-c-A-C]

subtle nimbus Jan 23, 2023, 5:59 PM

#

because it requires both

#

[1-10] AND [a-c-A-C]

compact pier Jan 23, 2023, 6:01 PM

#

Tried something like this, but doesn't work if the number is higher

(([\0-1][0])|[1-9])[a-c-A-C]

#

I don't know a lot about regex so yeah :<

subtle nimbus Jan 23, 2023, 6:01 PM

#

but that it because the | is an or

#

either or

compact pier Jan 23, 2023, 6:01 PM

#

what is and ?

subtle nimbus Jan 23, 2023, 6:01 PM

#

and 1 is the first fetched

#

just write no |

#

then its an and xd

compact pier Jan 23, 2023, 6:02 PM

#

then it doesn't work :<

#

Can you maybe help me, how I can fix that regex? D:

subtle nimbus Jan 23, 2023, 6:04 PM

#

([1-9]|[0-1]{1,2})[a-c-A-C]

#

that should fix ur

#

no 100% if it works but it works for me for my cases

light jungle Jan 23, 2023, 6:07 PM

#

regex makes me want to die tbh

compact pier Jan 23, 2023, 6:07 PM

#

#

not really

#

I think I will do manual check with js :<

earnest phoenix Jan 23, 2023, 6:09 PM

#

compact pier

Can you tell me what exactly are you trying to match?

compact pier Jan 23, 2023, 6:10 PM

#

earnest phoenix Can you tell me what **exactly** are you trying to match?

I want to match

1a
1b
1c

to

10a
10b
10c

#

other cases 11b or 23b won't work

earnest phoenix Jan 23, 2023, 6:11 PM

#

So the first part should only be 1 through 10?

compact pier Jan 23, 2023, 6:11 PM

#

yes

#

and second should be a-c (capital too)

earnest phoenix Jan 23, 2023, 6:20 PM

#

compact pier and second should be a-c (capital too)

Then you can just do /(?:(?<!\d)[0-9]|10)[a-cA-C]/

stiff dust Jan 23, 2023, 6:21 PM

#

Hi, I want to add music feature into my bot is there any better package than https://distube.js.org/#/ ??

Note: my bot isn't Just Music Bot I want to add music as a feature

DisTube

A Discord.js module to simplify your music commands and play songs on Discord without any API key.

light jungle Jan 23, 2023, 6:22 PM

#

stiff dust Hi, I want to add music feature into my bot is there any better package than htt...

I use https://www.npmjs.com/package/discord-player with no issues.

npm

discord-player

Complete framework to facilitate music commands using discord.js. Latest version: 5.4.0, last published: 11 days ago. Start using discord-player in your project by running npm i discord-player. There are 16 other projects in the npm registry using discord-player.

earnest phoenix Jan 23, 2023, 6:22 PM

#

earnest phoenix Then you can just do `/(?:(?<!\d)[0-9]|10)[a-cA-C]/`

What that does is that if it's a 10, just take that, if not then match through 0 to 9 but ignore the ones that have a digit before it, and then match a through c and A through C

compact pier Jan 23, 2023, 6:25 PM

#

earnest phoenix Then you can just do `/(?:(?<!\d)[0-9]|10)[a-cA-C]/`

Woah, thank you so much

earnest phoenix Jan 23, 2023, 6:28 PM

#

You're welcome

wheat mesa Jan 23, 2023, 6:32 PM

#

earnest phoenix Then you can just do `/(?:(?<!\d)[0-9]|10)[a-cA-C]/`

Major parsing issue

earnest phoenix Jan 23, 2023, 6:35 PM

#

wheat mesa Major parsing issue

👀

lyric mountain Jan 23, 2023, 6:43 PM

#

compact pier I want to match ``` 1a 1b 1c to 10a 10b 10c ```

/[1-9][0-9]?[a-cA-C]/

compact pier Jan 23, 2023, 6:45 PM

#

lyric mountain `/[1-9][0-9]?[a-cA-C]/`

lyric mountain Jan 23, 2023, 6:46 PM

#

u don't want 22b?

compact pier Jan 23, 2023, 6:46 PM

#

lyric mountain u don't want 22b?

yeaaah

#

like every number that bigger then 10

lyric mountain Jan 23, 2023, 6:46 PM

#

then that'll work

compact pier Jan 23, 2023, 6:46 PM

#

but I think Voltrex's regex works

#

lyric mountain Jan 23, 2023, 6:46 PM

#

voltrex's is probably slower since it uses lookbehind

#

mine simply uses optional digits

hallow shell Jan 23, 2023, 6:47 PM

#

can i use markdown in the top.gg long description

lyric mountain Jan 23, 2023, 6:47 PM

#

yes

hallow shell Jan 23, 2023, 6:47 PM

#

alr

compact pier Jan 23, 2023, 6:47 PM

#

mhmm, I think I don't care a lot about perfomance issues, cause I do it on client (ikk, but my website, doesn't need backend server)

#

KEKW

#

it is school project

lyric mountain Jan 23, 2023, 6:48 PM

#

performance is still a concern on clientside

#

even more than performance on backend

compact pier Jan 23, 2023, 6:48 PM

#

yeah.. but I don't have other option

#

a backend server is too expensive for a school project

lyric mountain Jan 23, 2023, 6:50 PM

#

that's not what I said

#

performance is more noticeable on frontend than on backend

#

because a slow backend will just make processing take more time, a slow frontend will freeze the app/site

#

and users tend to panic when something freezes

compact pier Jan 23, 2023, 6:52 PM

#

yeah, the user's experience is the most importain

earnest phoenix Jan 23, 2023, 7:10 PM

#

lyric mountain then that'll work

That won't work

lyric mountain Jan 23, 2023, 7:10 PM

#

why?

earnest phoenix Jan 23, 2023, 7:10 PM

#

Yours does not filter out numbers larger than 10

lyric mountain Jan 23, 2023, 7:10 PM

#

?

earnest phoenix Jan 23, 2023, 7:10 PM

#

Which is what they want

lyric mountain Jan 23, 2023, 7:10 PM

#

it'll work from 1a to 99c

earnest phoenix Jan 23, 2023, 7:11 PM

#

They only want it to work from 1 to 10, nothing larger

lyric mountain Jan 23, 2023, 7:11 PM

#

well, then just /[1-9]0?[a-cA-C]/

#

oh wait

#

ah, now I understand

#

just a sec

earnest phoenix Jan 23, 2023, 7:12 PM

#

Told ya

lyric mountain Jan 23, 2023, 7:13 PM

#

yeah that'll require lookbehind

#

however, I don't see why would they process that through regex and not simply check the input

earnest phoenix Jan 23, 2023, 7:14 PM

#

@compact pier so yeah, you can keep using mine which is correct, but you can also do it without regex

#

Either by parsing or something similar

lyric mountain Jan 23, 2023, 7:15 PM

#

to do it through code simply strip anything that isn't a letter and check if the number is > 10

#

or get a substring of the first (if length == 2) or first 2 (if length == 3) digits

wheat mesa Jan 23, 2023, 8:29 PM

#

Parse it as hexadecimal 🧌

lyric mountain Jan 23, 2023, 8:34 PM

#

@wheat mesa do u have any idea how to check if a bunch of bytes is a webp image?

#

like, png and jpeg have a specific sequence of bytes at the start of the array

#

google docs don't help much

#

nvm, found something in wikipedia

rustic nova Jan 23, 2023, 8:48 PM

#

Yeah isn't there a filetype definition on the beginning of the file?

lyric mountain Jan 23, 2023, 8:50 PM

#

there is, I just need to figure out how to properly read it

rustic nova Jan 23, 2023, 8:51 PM

#

https://en.m.wikipedia.org/wiki/List_of_file_signatures will help a fuck ton

List of file signatures

This is a list of file signatures, data used to identify or verify the content of a file. Such signatures are also known as magic numbers or Magic Bytes.
Many file formats are not intended to be read as text. If such a file is accidentally viewed as a text file, its contents will be unintelligible. However, sometimes the file signature can be re...

frosty gale Jan 23, 2023, 9:07 PM

#

rustic nova https://en.m.wikipedia.org/wiki/List_of_file_signatures will help a fuck ton

or just use the filetype to differentiate

rustic nova Jan 23, 2023, 9:09 PM

#

until there's no extension or you're getting a stream of data

#

such as an upload

lyric mountain Jan 23, 2023, 9:17 PM

#

frosty gale or just use the filetype to differentiate

There's no filetype in a byte sequence

cursive musk Jan 23, 2023, 10:38 PM

#

Experimenting with 0AUTH2, how can I make it so if they're banned from the server then they can't use the 0auth2?

#

Haven't been able to find a response.

rustic nova Jan 23, 2023, 10:40 PM

#

Can you elaborate "banning from oauth2"?

#

You have control over the callback Webserver that receives the oauth, you could do anything: either compare their User ID with your banlist or ban the IP that made the oauth

#

First one allowing use on a different account, second one entirely disallow on IP

#

Second one being the requirement that they have authorized on oauth2 at least once, dont forget to declare that on your privacy policy though

cursive musk Jan 23, 2023, 10:55 PM

#

rustic nova You have control over the callback Webserver that receives the oauth, you could ...

I want to do the first one; not sure how to implement it though. Couldn't find a docs or tutorial on it.

lyric mountain Jan 23, 2023, 10:58 PM

#

you can't prevent the user from acessing the oauth2 screen since that's on discord's side

#

but you can simply refuse to do something once they accept it

#

if it's for inviting the bot simply make it leave the servers right away

rustic nova Jan 23, 2023, 11:01 PM

#

lyric mountain you can't prevent the user from acessing the oauth2 screen since that's on disco...

Yeah that

rustic nova Jan 23, 2023, 11:02 PM

#

cursive musk I want to do the first one; not sure how to implement it though. Couldn't find a...

Get user to authorize, once authorize obtain the user id through the users endpoint, check banlist for that user id, deny access or whatever once that match comes back true

#

There isn't much docs needed, fetch the user, fetch your servers banlist and done

cursive musk Jan 23, 2023, 11:04 PM

#

lyric mountain if it's for inviting the bot simply make it leave the servers right away

nope, takes them back to the site with their name on the navbar for now

rustic nova Jan 23, 2023, 11:05 PM

#

Or whats your general goal? Deny access to your dashboard?

#

They can always use the oauth2 endpoint, but its up to you what you do after them authorizing

lyric mountain Jan 23, 2023, 11:06 PM

#

cursive musk nope, takes them back to the site with their name on the navbar for now

well, you need to refuse access after you get the response

#

oauth2 is nothing more than "you want this data? sure, let me ask them first"

cursive musk Jan 23, 2023, 11:07 PM

#

rustic nova They can always use the oauth2 endpoint, but its up to you what you do after the...

alright, so I'll just make it so that it logs them out and then redirects them to a /banned page

rustic nova Jan 23, 2023, 11:08 PM

#

oauth -> user authorizes

fetch userid from the token, fetch your servers banlist, if user is on banlist, redirect to /banned
if not, allow access

#

Just remember to still do that on any dashboard usage, unless you're not even going to give them a session

#

Which is probably easier

hidden gorge Jan 24, 2023, 2:09 AM

#

AttributeError: 'Member' object has no attribute 'role'

lyric mountain Jan 24, 2023, 2:09 AM

#

And it indeed doesn't

sudden geyser Jan 24, 2023, 2:09 AM

#

fact checked: TRUE!

hidden gorge Jan 24, 2023, 2:09 AM

#

uploading code one second

lyric mountain Jan 24, 2023, 2:09 AM

#

No need

#

Member doesn't have role

#

(yes, go on, say it)

wheat mesa Jan 24, 2023, 2:10 AM

#

Me when I keep coming back to the same discord channel for the same error at least once a week for the last 2 years

hidden gorge Jan 24, 2023, 2:10 AM

#

   if user.role(whitelisted_humans):
                return;```

#

the humans role is an id

#

 whitelisted_humans = [849479291111866380]```

lyric mountain Jan 24, 2023, 2:11 AM

#

Ok TIFU more than I thought

hidden gorge Jan 24, 2023, 2:11 AM

#

what

lyric mountain Jan 24, 2023, 2:11 AM

#

Are you sure that's how ur supposed to check for roles?

hidden gorge Jan 24, 2023, 2:11 AM

#

i dont ever try this lol

lyric mountain Jan 24, 2023, 2:11 AM

#

hidden gorge what

Then read docs

warm surge Jan 24, 2023, 2:11 AM

#

hidden gorge i dont ever try this lol

Hm

lyric mountain Jan 24, 2023, 2:11 AM

#

Oops, reply went automatically

#

Tifu means "this is fucked up" btw

#

Naming a Member variable user is the recipe for chaos

#

To check for roles you need to get the roles of a member and check if it contains the desired role

#

U can't simply call functions that don't exist, always check the docs or at least use ctrl + space

hidden gorge Jan 24, 2023, 2:15 AM

#

if member.guild.get_role(849479291111866380) ^ SyntaxError: invalid syntax

lyric mountain Jan 24, 2023, 2:15 AM

#

That's somehow worse than it was

hidden gorge Jan 24, 2023, 2:15 AM

#

ive used it before

wheat mesa Jan 24, 2023, 2:15 AM

#

Sometimes I wonder if you’ve tried solving the issue or if you’re just looking up a ton of things and copy pasting the code…

hidden gorge Jan 24, 2023, 2:15 AM

#

wheat mesa Sometimes I wonder if you’ve tried solving the issue or if you’re just looking u...

nope

lyric mountain Jan 24, 2023, 2:16 AM

#

Just look at the docs

hidden gorge Jan 24, 2023, 2:16 AM

#

i try it makes no sense

lyric mountain Jan 24, 2023, 2:16 AM

#

Isn't ur editor telling u it's wrong?

#

Like, even the most basic code editors have some kind of autocomplete

#

Anyway, you need to learn how to read documentations

#

That's part of being a programmer

hidden gorge Jan 24, 2023, 2:28 AM

#

TypeError: on_message() missing 1 required positional argument: 'member'
Ignoring exception in on_message```

#

    @commands.Cog.listener()
    async def on_message(self, message, member):
        user = message.author
        if message.author.bot:
            return

        whitelisted_channels = [978933824241147904]
        whitelisted_humans = [849479291111866380] # 131920731490615296 bit.ly in own server.

lyric mountain Jan 24, 2023, 2:47 AM

#

Is self supposed to be there?

#

Also why are u creating a single-entry array?

carmine summit Jan 24, 2023, 4:51 AM

#

I need help trying to upload an image to a webhook. The image is in HTML Canvas

radiant kraken Jan 24, 2023, 12:35 PM

#

lyric mountain Is `self` supposed to be there?

they're probably using a custom class

radiant kraken Jan 24, 2023, 12:36 PM

#

hidden gorge ```py TypeError: on_message() missing 1 required positional argument: 'member' I...

on_message does not have a second, or member argument iirc

dry imp Jan 24, 2023, 12:39 PM

#

yea

rigid maple Jan 24, 2023, 2:18 PM

#

I can't understand where I went wrong

pearl trail Jan 24, 2023, 2:30 PM

#

https://github.com/amishshah/prism-media/issues/104 (?)

GitHub

The value of "sourceEnd" is out of range error in 2.0.0-alpha.0 · ...

Issue: RangeError [ERR_OUT_OF_RANGE]: The value of "sourceEnd" is out of range. It must be >= 0 && <= 3. Received 8 at validateOffset (node:buffer:11...

rigid maple Jan 24, 2023, 2:43 PM

#

unfortunately there is no solution posted here

final tangle Jan 24, 2023, 3:06 PM

#

rigid maple I can't understand where I went wrong

the error states that the sourceEnd value is out of range and must be between 0 and 3, but the value of 8 was received
try seeing if the code that is trying to access the array/string is properly checking and enforcing the range of the index being accessed, in this case between 0 and 3

#

also in ur code at line 334, it's saying DiscoidVoice

#

not sure if u spelled it wrong

#

i think it should be DiscordVoice

rigid maple Jan 24, 2023, 4:38 PM

#

no its true

quartz kindle Jan 24, 2023, 4:46 PM

#

rigid maple unfortunately there is no solution posted here

there is a possible fix in a PR request, but it was not merged, you can however try installing the PR version instead of the npm version:
https://github.com/dzlandis/prism-media

GitHub

GitHub - dzlandis/prism-media: Easily transcode media using Node.js...

Easily transcode media using Node.js 🎶. Contribute to dzlandis/prism-media development by creating an account on GitHub.

#

from looking at their code, the fix is not quite correct

#

but it might work

lyric mountain Jan 24, 2023, 4:54 PM

#

Tim if u don't mind, could u give me some performance advice?

so, let's say I have a huge array (raster data from image) and want to edit some pixels

#

what'd be the optimal way to edit said pixels?

#

like, the specific pixels will be supplied by a mask

quartz kindle Jan 24, 2023, 4:55 PM

#

the specific pixels are matched by color?

#

so they can be anywhere in the image, right?

#

you dont know their position beforehand

lyric mountain Jan 24, 2023, 4:56 PM

#

yes

#

the issue being that a linear array iteration is too painfully slow

#

the raster is a width * height * channels sized array

quartz kindle Jan 24, 2023, 4:58 PM

#

is it rgb or rgba?

lyric mountain Jan 24, 2023, 4:58 PM

#

rgba, but it can be anything

#

perhaps I could split the array into chunks and process each separately

quartz kindle Jan 24, 2023, 4:59 PM

#

if there is no hint about the possible pixel position, there is no other way besides iteration, but you dont need to match the entire mask at once for each pixel

#

you can match each rgba byte separately

#

so if the first byte doesnt match you dont need to check the others

lyric mountain Jan 24, 2023, 4:59 PM

#

wdym?

#

like, the mask is for "cutting" the image

quartz kindle Jan 24, 2023, 5:00 PM

#

like

#

if you want to change all pixels with a specific color into a different color

#

you dont need to check if the pixel matches all channels with something like buffer compare

#

actually, how are the pixels stored in the first place?

#

2d array?

lyric mountain Jan 24, 2023, 5:02 PM

#

1d array

quartz kindle Jan 24, 2023, 5:02 PM

#

so all pixels are merged in the same array, in groups of 4

lyric mountain Jan 24, 2023, 5:02 PM

#

I believe so

#

ah wait, I just noticed that I can just offset the iterator by the desired channel number

quartz kindle Jan 24, 2023, 5:03 PM

#

then you can iterate and skip

#

exactly

#

if the first byte doesnt match, skip the next 3

#

if the first matches, but the second doesnt, skip the next 2

#

etc

lyric mountain Jan 24, 2023, 5:03 PM

#

ic, ty tim

quartz kindle Jan 24, 2023, 5:04 PM

#

what lang btw?

lyric mountain Jan 24, 2023, 5:05 PM

#

java

quartz kindle Jan 24, 2023, 5:05 PM

#

another thing you can try is using array indexOf, or equivalent

lyric mountain Jan 24, 2023, 5:05 PM

#

trying to optimize my renderer, it's taking too long for some pixel ops

quartz kindle Jan 24, 2023, 5:05 PM

#

in my experience that function is faster than if you were to iterate yourself

#

at least it is in js lol

lyric mountain Jan 24, 2023, 5:06 PM

#

btw, I ran a benchmark on some webp vs png

#

5 warmups for each iteration

#

I didn't expect webp to be half as fast as png

#

I could run a bigger sample, but the step results were way too consistent

#

for example

quartz kindle Jan 24, 2023, 5:07 PM

#

half as fast? isnt the score 1887 vs 1742?

lyric mountain Jan 24, 2023, 5:07 PM

#

ah wait

#

I was looking at error lmao

quartz kindle Jan 24, 2023, 5:07 PM

#

xD

lyric mountain Jan 24, 2023, 5:07 PM

#

well, 0.1 ops/s diff isn't that bad then

quartz kindle Jan 24, 2023, 5:07 PM

#

webp is lossy compressed isnt it?

#

png is usually losless or at least color indexed

lyric mountain Jan 24, 2023, 5:08 PM

#

both were compressed at 80% quality

#

webp lossy yes

#

I don't really mind the loss, I just need transparency

quartz kindle Jan 24, 2023, 5:08 PM

#

so not surprising, webp algorithm is more complex

#

how fast is jpg?

lyric mountain Jan 24, 2023, 5:09 PM

#

lemme throw it into the benchmark

#

tho it'll take a while

quartz kindle Jan 24, 2023, 5:09 PM

#

im gonna get my groceries off the car lol

lyric mountain Jan 24, 2023, 5:11 PM

#

ain't done yet, but I think it'll be like fishing with a cannon

#

btw, it's a 1000x1000 image with randomly rolled pixels

#

the image is created for each iteration

#

too bad I cant use jpeg

quartz kindle Jan 24, 2023, 5:33 PM

#

so jpg is 10x faster than the other 2

#

lmao

lyric mountain Jan 24, 2023, 5:35 PM

#

png and webp gave bigger results for some reason

#

maybe it's because of cpu load

quartz kindle Jan 24, 2023, 5:35 PM

#

lel

#

i had a feeling jpg would be much faster

#

but not that much

lyric mountain Jan 24, 2023, 5:36 PM

#

jpeg is basically the UDP of image formats

quartz kindle Jan 24, 2023, 5:37 PM

#

unified department of police?

#

xD

#

btw

#

that benchmark is basically encoding performance no?

#

time taken to generate said pixels and encode them into the format

#

what about a decoding benchmark?

#

time taken to actually read and decode the pixels

sudden geyser Jan 24, 2023, 5:43 PM

#

lyric mountain

ay I thought you hated benchmarks

lyric mountain Jan 24, 2023, 5:45 PM

#

I hate wrongly done benchmarks

#

this one is using the openjdk benchmark lib

#

which makes sure all runs are done equally

whole glen Jan 24, 2023, 5:57 PM

#

I’ve been trying to find something about this but anyone know a resource on how to do a video pop out like this in html?

craggy pine Jan 24, 2023, 6:02 PM

#

Quesiton: Is 50 servers a cap of some sort for unverified slash commands? I woke up today to not being able to run slash commands in my own server. Also noticed my little description I have for my bot where you can click commands to autofill them are no longer highlighted.

torpid crystal Jan 24, 2023, 6:03 PM

#

craggy pine Quesiton: Is 50 servers a cap of some sort for unverified slash commands? I woke...

Nope, discord slash commands are down right now

craggy pine Jan 24, 2023, 6:03 PM

#

ah cool

#

I was kinda spooked.

lyric mountain Jan 24, 2023, 6:06 PM

#

whole glen I’ve been trying to find something about this but anyone know a resource on how ...

make a modal overlay with a video player

#

when the user clicks on it, make the modal visible

whole glen Jan 24, 2023, 6:34 PM

#

Thanks

rustic nova Jan 24, 2023, 7:18 PM

#

lyric mountain btw, I ran a benchmark on some webp vs png

mfw I misread it with "measurePog

lyric mountain Jan 24, 2023, 7:19 PM

#

lmao

thorn spruce Jan 24, 2023, 8:11 PM

#

Does anyone know how to avoid hundreds of setTimeout, I am trying to create a remindme system. I was actually going to use Cron, but you can't choose the number of iterations with node-cron. Because I think that having hundreds of setTimeout in progress is not incredible no?

#

I had seen Agenda but it only uses Mongodb I think and I use Mysql

rustic nova Jan 24, 2023, 8:12 PM

#

how about one setTimeout that processes through a list instead? Perhaps adding a expire timeout along with the remindme entry

#

then that setTimeout executing every second

#

though theres also the cons about setTimeout, since your reminders will get lost on a restart. So a repeating setTimeout that goes through a list might also allow you to store the reminders in a database

thorn spruce Jan 24, 2023, 8:14 PM

#

yes that's why i store them in my database to re-add them on restart (endDate-startDate)

rustic nova Jan 24, 2023, 8:15 PM

#

yeah then load your reminders into a list and have the setTimeout iterate through the list and do the reminders etc

thorn spruce Jan 24, 2023, 8:15 PM

#

The problem is that my reminders do not have the same expiration date

rustic nova Jan 24, 2023, 8:15 PM

#

you might also be able to have other bot instances that are specifically for working through the reminders, might help with processing

rustic nova Jan 24, 2023, 8:16 PM

#

thorn spruce The problem is that my reminders do not have the same expiration date

store the expiry time in the database aswell, so that the setTimeout can iterate through it and compare the current time with the one on the entry

#

thats at least how I would do it

thorn spruce Jan 24, 2023, 8:18 PM

#

what do you mean by a repeating setTimeout Think

rustic nova Jan 24, 2023, 8:19 PM

#

one single setTimeout that goes forever, that processes the reminders

sudden geyser Jan 24, 2023, 8:21 PM

#

aka a setInterval

rustic nova Jan 24, 2023, 8:21 PM

#

oh yeah forgot that exists too

#

you wont be able to reliably store reminders without some missing if your bot restarts if theres some that expire during the restart

sudden geyser Jan 24, 2023, 8:22 PM

#

though it really sounds like you want some persistent queue

thorn spruce Jan 24, 2023, 8:24 PM

#

sudden geyser aka a `setInterval`

aahh I understand yes, i was going on recursive function AkashiSparkle I forgot setInterval

opaque seal Jan 24, 2023, 9:39 PM

#

thorn spruce Does anyone know how to avoid hundreds of setTimeout, I am trying to create a re...

In an old Discord bot I made I had a sort of Interval for short reminders and I would cache the longer ones in redis and check them every minute.
Even tho I think there are much better stream / event options for that

#

I have the code here https://github.com/Giuliopime/Todo-Reminder/tree/main/src/main/java/me/todoReminder/bot/core/reminders (java)

lament rock Jan 24, 2023, 9:50 PM

#

thorn spruce Does anyone know how to avoid hundreds of setTimeout, I am trying to create a re...

NodeJS.Timeouts are actually pretty light on the process and a ton of them already get used to handle rate limits to Discord depending on how big your bot is. Reminders should be stored in some form of storage in case your process crashes

rustic nova Jan 24, 2023, 10:04 PM

#

opaque seal In an old Discord bot I made I had a sort of *Interval* for short reminders and ...

Oh fuck thats actually smart, to redis the longer ones

opaque seal Jan 24, 2023, 10:05 PM

#

rustic nova Oh fuck thats actually smart, to redis the longer ones

There has to be a more precise system tho

rustic nova Jan 24, 2023, 10:05 PM

#

Yeah was about to say, judging from the code, yours are on the minute, hour, week etc

#

Only way to make a precise way is to have another instance of the bot deal with it

quartz kindle Jan 24, 2023, 10:07 PM

#

opaque seal There has to be a more precise system tho

the best system i can think of is store them in a database, then use an interval to check the database every 5-10 minutes for any timer that will expire in less than 5-10 minutes, and for each one found, create a timeout for it

opaque seal Jan 24, 2023, 10:07 PM

#

quartz kindle the best system i can think of is store them in a database, then use an interval...

True

opaque seal Jan 24, 2023, 10:07 PM

#

rustic nova Yeah was about to say, judging from the code, yours are on the minute, hour, wee...

Yeah mine are minute precise

#

Not seconds

#

Unless it's a short reminder

#

Which is generally fine I guess

rustic nova Jan 24, 2023, 10:29 PM

#

So your border on a short and long reminder is seconds and minutes

quartz kindle Jan 24, 2023, 10:31 PM

#

with the above method i mentioned, everything is millisecond precision

craggy pine Jan 24, 2023, 11:16 PM

#

Anyone else getting a decent amount of "unknown intereaction" errors since the slash commands came back from being disabled temporarily? I'm getting one from just doing interaction.reply() which shouldn't throw that because it's the first thing it runs on that specific slash command ran

#

my buttons respond pretty slow too

solemn latch Jan 24, 2023, 11:45 PM

#

Its probably api issues still

deft wolf Jan 24, 2023, 11:50 PM

#

craggy pine Anyone else getting a decent amount of "unknown intereaction" errors since the s...

No, everything works as it should for me

craggy pine Jan 24, 2023, 11:51 PM

#

my errors seemed to have chilled out.

#

But for a good 30 minutes all I got were theses
https://scs.twilightgamez.net/5f5mb.png
Which 51 is

await interaction.reply({content: `Attempting to queue: \`${interaction.options.getString('song')}\``, ephemeral: true})

deft wolf Jan 24, 2023, 11:53 PM

#

It must have been related to those api issues

craggy pine Jan 24, 2023, 11:53 PM

#

yeah I just now had a realization that maybe I forgot to make 'song' required, but no, it is lol.

#

So ya api related likely.

sharp geyser Jan 24, 2023, 11:54 PM

#

That or the interaction is non existent.

craggy pine Jan 24, 2023, 11:54 PM

#

I mean, how would that happen?

sharp geyser Jan 24, 2023, 11:54 PM

#

You could be completing the interaction already.

#

Well no, djs tells you if you deferred a reply or smth like that

craggy pine Jan 24, 2023, 11:55 PM

#

ya it does.

wheat mesa Jan 24, 2023, 11:56 PM

#

unknown interaction is likely from the API errors earlier

craggy pine Jan 24, 2023, 11:57 PM

#

Ya it only started to happen after the slash commands came back so I was just curious if anyone else was experiencing the spam on unknown interactions on simple interaciton.replys but I haven't had one for almost an hr now so ya. Probably just api recovering from its stroke it had.

lament rock Jan 25, 2023, 3:06 AM

#

@craggy pine Are you receiving interactions via http or over the gateway

#

because Discord can tell your client to resume and during that window, your interactions can expire

craggy pine Jan 25, 2023, 3:19 AM

#

shrug

craggy pine Jan 25, 2023, 3:33 AM

#

lament rock because Discord can tell your client to resume and during that window, your inte...

basically it's almost every other interaction it becomes really really slow.

#

https://scs.twilightgamez.net/g/iUnOQ.gif

rigid maple Jan 25, 2023, 8:12 AM

#

quartz kindle there is a possible fix in a PR request, but it was not merged, you can however ...

unfortunately that didn't work 😞

opaque seal Jan 25, 2023, 8:17 AM

#

rustic nova So your border on a short and long reminder is seconds and minutes

the short one is milliseconds precise

rigid maple Jan 25, 2023, 3:18 PM

#

rigid maple unfortunately that didn't work 😞

I think I solved it somehow, but this time, when calculating the talk time, I have it calculated as buffer.length / 48000 / 4, which gives me a very low value. like; 0.07417708333333334

crystal wigeon Jan 25, 2023, 3:23 PM

#

Has anyone worked with millions of rows in db?

#

It takes quite a bit of time to retrieve 500k data. Even with all the indexing

valid oak Jan 25, 2023, 4:04 PM

#

crystal wigeon It takes quite a bit of time to retrieve 500k data. Even with all the indexing

500k lines?

#

500k data?*

#

like rows?

#

or

crystal wigeon Jan 25, 2023, 4:04 PM

#

yeah

valid oak Jan 25, 2023, 4:04 PM

#

lines

crystal wigeon Jan 25, 2023, 4:04 PM

#

500k rows

#

from postgres

#

its also a select query select * from x where x.uid = xx

#

x.uid is indexed and stuff

#

still takes about 30sec

rustic nova Jan 25, 2023, 4:08 PM

#

why are you trying to select every single data

#

consider optimizing your queries and moving over to a faster database system

lyric mountain Jan 25, 2023, 4:20 PM

#

postgres is probably the fastest free option

lyric mountain Jan 25, 2023, 4:20 PM

#

crystal wigeon its also a select query ``select * from x where x.uid = xx``

never use * unless u strictly need it

#

also is uid a primary key?

crystal wigeon Jan 25, 2023, 4:21 PM

#

lyric mountain never use `*` unless u strictly need it

All columns are needed

#

Nop

#

It’s like 1 uid can have multiple rows

#

One to many relationship

lyric mountain Jan 25, 2023, 4:22 PM

#

what's the table used for?

#

also, there's no "one to many table"

#

1-N is a relationship, not a table structure

#

@crystal wigeon come back

crystal wigeon Jan 25, 2023, 4:26 PM

#

brb

lyric mountain Jan 25, 2023, 4:26 PM

#

ah ok

crystal wigeon Jan 25, 2023, 4:29 PM

#

lyric mountain what's the table used for?

So it’s like this, let’s say a user has bunch of posts, user table has the primary key and these posts will have the uid has foreign key and indexed

#

It’s mostly the pagination total count that’s costing time

#

Using count(id) to get total rows

lyric mountain Jan 25, 2023, 4:30 PM

#

why dont u paginate through postgres directly?

crystal wigeon Jan 25, 2023, 4:31 PM

#

I do

#

I’m using limit and offset

lyric mountain Jan 25, 2023, 4:31 PM

#

do u need the total of posts?

crystal wigeon Jan 25, 2023, 4:31 PM

#

yeah

lyric mountain Jan 25, 2023, 4:32 PM

#

can posts be edited or deleted?

crystal wigeon Jan 25, 2023, 4:32 PM

#

Yep both

lyric mountain Jan 25, 2023, 4:32 PM

#

hm, are u getting the count together with the regular sql?

#

like SELECT *, COUNT(id) FROM ...

#

or in a separate query?

crystal wigeon Jan 25, 2023, 4:33 PM

#

Yeah along with it

lyric mountain Jan 25, 2023, 4:33 PM

#

btw, u can use COUNT(1) instead, it's faster sometimes

lyric mountain Jan 25, 2023, 4:33 PM

#

crystal wigeon Yeah along with it

do it separately

#

reason being COUNT() will fetch all rows, so it might be fetching the other fields too which, if you have very large values, will affect execution time

crystal wigeon Jan 25, 2023, 4:34 PM

#

I’m using count(id) actually

#

So you suggest making two db calls?

lyric mountain Jan 25, 2023, 4:35 PM

#

yes

#

with count(1) not id

crystal wigeon Jan 25, 2023, 4:35 PM

#

I’ll give that a try mmm

#

I see

#

Thanks I’ll give it a try

lyric mountain Jan 25, 2023, 4:35 PM

#

also u dont need to do any join for the count

#

just count directly from the table, filtering by id

crystal wigeon Jan 25, 2023, 4:38 PM

#

Yeah, there are no joins

#

I’ll check the performance on that mm

lyric mountain Jan 25, 2023, 4:40 PM

#

what u could also do, is disallow editing/deleting posts older than X days

#

then make a periodic procedure that counts archived posts and save to an aux table

#

then u can just filter posts where age < X and count them, appending the saved count

#

this is actually why most forums archive posts after some time

crystal wigeon Jan 25, 2023, 4:44 PM

#

lyric mountain what u could also do, is disallow editing/deleting posts older than X days

Well it’s not exactly posts, posts was just as an example haha, everything is active here.

lyric mountain Jan 25, 2023, 4:44 PM

#

but if ur dealing with massive amounts of data you should consider something like that

crystal wigeon Jan 25, 2023, 4:50 PM

#

lyric mountain but if ur dealing with massive amounts of data you should consider something lik...

Yeah, inactive data mmm but since it’s actively used it’s a pain with slow performance speeds

crystal wigeon Jan 25, 2023, 4:53 PM

#

lyric mountain but if ur dealing with massive amounts of data you should consider something lik...

Alright so it’s kinda slow even without the count ()

lyric mountain Jan 25, 2023, 4:53 PM

#

execute a PLAN EXPLAIN query and show the result please

#

redact the names if u must

crystal wigeon Jan 25, 2023, 4:54 PM

#

Gotcha, I think the problem is I’m using row count

#

I’ll send the query in a few

rigid maple Jan 25, 2023, 5:03 PM

#

I can't understand where I went wrong
the first buffer in the console is stereo, the second buffer is mono

#

When I convert the buffer to audio, I can listen to it, but when wit.ai converts it to text, it's empty.

crystal wigeon Jan 25, 2023, 5:24 PM

#

lyric mountain execute a `PLAN EXPLAIN` query and show the result please

okay so, this is the query i ran, and it took about 20secs

 id asc) from "collections" where 
"collections"."user_id" = 1 and "collections"."is_item" = false) 
as "collectionalias" where "collectionalias"."row_number" = 1```

Screenshot_2023-01-25_at_10.54.11_PM.png

#

this is for the user with more than 500k rows. its super fast for users with less data

lyric mountain Jan 25, 2023, 5:24 PM

#

lemme format that first

#

EXPLAIN ANALYZE
SELECT x.*
FROM (
     SELECT *
          , row_number() OVER (ORDER BY rank_id DESC, id ASC) AS row
     FROM collections
     WHERE user_id = 1
       AND is_item = FALSE
) AS x
WHERE x.row = 1

#

much better

crystal wigeon Jan 25, 2023, 5:25 PM

#

damn

#

how

#

to format

#

xd

lyric mountain Jan 25, 2023, 5:25 PM

#

ctrl + alt + L on intellij

eternal osprey Jan 25, 2023, 5:25 PM

#

hey

#

how do i access this count(*) variable?

#

like i am using it like: result[0].(property here)

#

however result[0].COUNT(*) will behave like an actual function...

crystal wigeon Jan 25, 2023, 5:26 PM

#

rename the object property,

eternal osprey Jan 25, 2023, 5:26 PM

#

how? It's a pulled variable from sqlite

crystal wigeon Jan 25, 2023, 5:26 PM

#

adding () is considered a method

#

what object is that?

eternal osprey Jan 25, 2023, 5:26 PM

#

SELECT COUNT(*) FROM table;

crystal wigeon Jan 25, 2023, 5:26 PM

#

or you can try result[0]["COUNT(()"]

lyric mountain Jan 25, 2023, 5:27 PM

#

ok, now it's better yet

eternal osprey Jan 25, 2023, 5:27 PM

#

okii will try thanks!

crystal wigeon Jan 25, 2023, 5:27 PM

#

its not good practice tho

lyric mountain Jan 25, 2023, 5:27 PM

#

ok so, first of all u never need = BOOLEAN since it's a boolean already

crystal wigeon Jan 25, 2023, 5:27 PM

#

eternal osprey SELECT COUNT(*) FROM table;

you can do select count(1) as total from table

crystal wigeon Jan 25, 2023, 5:27 PM

#

lyric mountain ok so, first of all u never need `= BOOLEAN` since it's a boolean already

no the value is either true or false

#

so it has to filter through rows that are false

lyric mountain Jan 25, 2023, 5:28 PM

#

yes, u don't need that

crystal wigeon Jan 25, 2023, 5:28 PM

#

otherwise row number gonna mess up

lyric mountain Jan 25, 2023, 5:28 PM

#

AND NOT field

#

or AND field

crystal wigeon Jan 25, 2023, 5:28 PM

#

aa

#

lemme see how that performs

lyric mountain Jan 25, 2023, 5:28 PM

#

wont make a difference

#

it's just a tip for making stuff more readable

crystal wigeon Jan 25, 2023, 5:28 PM

#

i see

lyric mountain Jan 25, 2023, 5:29 PM

#

u also dont need to spam " everywhere, only for stuff using keywords as names

crystal wigeon Jan 25, 2023, 5:29 PM

#

yeah its a knex debugger query log i copied it from

#

jsut to show as example here

lyric mountain Jan 25, 2023, 5:29 PM

#

why do u need row_number?

crystal wigeon Jan 25, 2023, 5:30 PM

#

so the rows have to be ordered and the user would choose something like the nth row

#

if you want to choose the 5th item

#

they type select 5

#

the order by is an addon for them to sort it by asc or desc

#

or based on a rank_id

lyric mountain Jan 25, 2023, 5:31 PM

#

EXPLAIN ANALYZE
SELECT *
FROM collections
WHERE user_id = 1
  AND NOT is_item
ORDER BY rank_id DESC, id
OFFSET :row_n LIMIT 1

#

u dont need row_number for that, simply use offset

crystal wigeon Jan 25, 2023, 5:32 PM

#

hmmm

#

let me try

lyric mountain Jan 25, 2023, 5:33 PM

#

also try not to use *

#

pick only what u really need

crystal wigeon Jan 25, 2023, 5:33 PM

#

yeah

lyric mountain Jan 25, 2023, 5:33 PM

#

like, I dont think the user would need to see is_item column

#

so it's one less column in the resultset

crystal wigeon Jan 25, 2023, 5:35 PM

#

mmm makes sense ye, but will need other columns i have

crystal wigeon Jan 25, 2023, 5:36 PM

#

lyric mountain like, I dont think the user would need to see `is_item` column

so it should be offset - 1 btw right? cause i select 1 it should not skip anything

#

offset 1 would skip the first row

#

damnnn that was fast

#

20k ms to 50ms

lyric mountain Jan 25, 2023, 5:36 PM

#

crystal wigeon so it should be offset - 1 btw right? cause i select 1 it should not skip anythi...

yes

crystal wigeon Jan 25, 2023, 5:37 PM

#

noice

#

but for the count thing, need to show row number

lyric mountain Jan 25, 2023, 5:37 PM

#

crystal wigeon 20k ms to 50ms

reason is, offset requires no processing at all, it simply ignore N rows and limit to X lines

crystal wigeon Jan 25, 2023, 5:37 PM

#

cause if they search for something with name, need to show on what row the item is on

#

yep

#

alr lemme solve 1 problem at a time

lyric mountain Jan 25, 2023, 5:38 PM

#

for the row number u can use an extra column

#

to store line number

crystal wigeon Jan 25, 2023, 5:38 PM

#

precomputed, but need to do this everytime collections are consumed etc

lyric mountain Jan 25, 2023, 5:38 PM

#

use a trigger for that, leave the work to the database

crystal wigeon Jan 25, 2023, 5:39 PM

#

mmmm

lyric mountain Jan 25, 2023, 5:39 PM

#

like, when deleting, update all rows with number higher than the deleted row

crystal wigeon Jan 25, 2023, 5:39 PM

#

it needs to like calculate the rows for each user data

#

mm

#

and when sorting

lyric mountain Jan 25, 2023, 5:39 PM

#

u wont sort the actual data, you'll sort the resultset

crystal wigeon Jan 25, 2023, 5:40 PM

#

lyric mountain reason is, offset requires no processing at all, it simply ignore N rows and lim...

Simple logic yet effective, thanks

#

I’ll brb

lyric mountain Jan 25, 2023, 5:40 PM

#

while at that, having a row number column also speeds up count

crystal wigeon Jan 25, 2023, 5:40 PM

#

Lemme do one at a time haha

#

I need to explain a bit more about the other one