|
 |
| | | Author: | Hubby  | | Posted: | Jul 15, 2022 04:16 | | Subject: | (Cancelled) | | Viewed: | 450 times | | Topic: | Help | |
|
| | (Cancelled) |
|
| | | | | |
| | | | | Author: | AlohaBrickRoad | | Posted: | Jul 15, 2022 04:37 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 156 times | | Topic: | Help | |
|
| Your feedback response seems to say you offered the paypal friends and family
payment in response to a request from the buyer to make it cheaper or something.
That's admitting to an attempt to violate Bricklink rules right in your
own feedback.
In Help, Hagbart writes:
| | Dear friends from Bricklink
Just got suspended, seems the work of a buyer that was a liar and a fraud.
What can I do to appeal this decision that is quite unfair as I have much more
transactions than this buyer!
Please help me to waive this.
Regards,
Hubert
|
|
|
| | | | | | | | | |
| | | | | | | Author: | Hubby | | Posted: | Jul 15, 2022 04:56 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 134 times | | Topic: | Help | |
|
| He asked this himself, he is the problem not me.
And without my accept initiated the cancellations of the order.
What can I do to get activated again?
Regards,
In Help, AlohaBrickRoad writes:
| | Your feedback response seems to say you offered the paypal friends and family
payment in response to a request from the buyer to make it cheaper or something.
That's admitting to an attempt to violate Bricklink rules right in your
own feedback.
In Help, Hagbart writes:
| | Dear friends from Bricklink
Just got suspended, seems the work of a buyer that was a liar and a fraud.
What can I do to appeal this decision that is quite unfair as I have much more
transactions than this buyer!
Please help me to waive this.
Regards,
Hubert
|
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | yorbrick | | Posted: | Jul 15, 2022 05:08 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 123 times | | Topic: | Help | |
|
| In Help, Hagbart writes:
| | He asked this himself, he is the problem not me.
And without my accept initiated the cancellations of the order.
|
Did he ask for cheaper postage, or ask for family and friends. Never suggest
family and friends!
You can refuse to cancel and go for NPB, but if postage costs are high it is
just easier to cancel with no loss on either buyer or seller side.
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | tons_of_bricks | | Posted: | Jul 15, 2022 06:06 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 97 times | | Topic: | Help | |
|
| In Help, Hagbart writes:
| | He asked this himself, he is the problem not me.
|
He may have asked for this, but did you go through with it? If so, then you willingly
breached paypals terms.
|
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | Author: | Stellar | | Posted: | Jul 15, 2022 06:53 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 97 times | | Topic: | Help | |
|
| In Help, firestar246 writes:
| | In Help, Hagbart writes:
| | He asked this himself, he is the problem not me.
|
He may have asked for this, but did you go through with it? If so, then you willingly
breached paypals terms.
|
And also the buyer is located in USA where BrickLink has to collect Sales Tax
on all orders with only PayPal Onsite or Stripe.
|
|
| | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | Author: | Hubby | | Posted: | Aug 8, 2022 12:08 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 81 times | | Topic: | Help | |
|
| In Help, Stellar writes:
| | In Help, firestar246 writes:
| | In Help, Hagbart writes:
| | He asked this himself, he is the problem not me.
|
He may have asked for this, but did you go through with it? If so, then you willingly
breached paypals terms.
|
And also the buyer is located in USA where BrickLink has to collect Sales Tax
on all orders with only PayPal Onsite or Stripe.
|
Yes true he asked for it and after he cancelled the order he reported me to the
bricklink support. Just a crock!
He just detroyed my shop and the support do not care and is not helping at all.
|
|
| | | | | | | | | |
| | | | | | | Author: | Hubby | | Posted: | Aug 19, 2022 15:55 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 36 times | | Topic: | Help | |
|
| Nobody is perfect but the joke is that no transaction ever found place with this.
Seems we have several sellers being blocked with no notice and just a message
from Anastasia from support that is preventive, but when asking for opening the
store as now we comply nothing else happends.
My time on bricklink might be over, quite a punishment for something that did
not ovcured as no transaction found place.
Can’t we appeal for this decision ?
In Help, AlohaBrickRoad writes:
| | Your feedback response seems to say you offered the paypal friends and family
payment in response to a request from the buyer to make it cheaper or something.
That's admitting to an attempt to violate Bricklink rules right in your
own feedback.
In Help, Hagbart writes:
| | Dear friends from Bricklink
Just got suspended, seems the work of a buyer that was a liar and a fraud.
What can I do to appeal this decision that is quite unfair as I have much more
transactions than this buyer!
Please help me to waive this.
Regards,
Hubert
|
|
|
|
|
| | | | | |
| | | | | Author: | miskox | | Posted: | Jul 15, 2022 05:01 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 93 times | | Topic: | Help | |
|
| In Help, Hagbart writes:
| | Dear friends from Bricklink
Just got suspended, seems the work of a buyer that was a liar and a fraud.
What can I do to appeal this decision that is quite unfair as I have much more
transactions than this buyer!
Please help me to waive this.
Regards,
Hubert
|
I guess only BL administration can help: https://helpdesk.bricklink.com/Main/
(you have to register again (because they use 3rd party software for helpdesk))
(preferably with the same username)
Saso
|
|
| | | | | |
| | | | | Author: | pitz8008 | | Posted: | Jul 15, 2022 06:40 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 95 times | | Topic: | Help | |
|
| In Help, Hagbart writes:
| | Dear friends from Bricklink
Just got suspended, seems the work of a buyer that was a liar and a fraud.
What can I do to appeal this decision that is quite unfair as I have much more
transactions than this buyer!
Please help me to waive this.
Regards,
Hubert
|
Again the breakdown of communication. Is it really that hard for Bricklink to
tell a store why they are being suspended? It literally can be accomplished in
a single sentence.
|
|
| | | | | | | | | |
| | | | | | | Author: | Gaston.La.Brick | | Posted: | Jul 15, 2022 10:09 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 90 times | | Topic: | Help | |
|
| | | Again the breakdown of communication. Is it really that hard for Bricklink to
tell a store why they are being suspended? It literally can be accomplished in
a single sentence.
|
Indeed.
Another suggestion to site admins, if they would be reading this: have some sort
of "warning" period before taking actual measures. This allows the seller to
mediate whatever issue is brought to his attention. Seems like a user friendly
way to approach these situations.
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | yorbrick | | Posted: | Jul 15, 2022 13:55 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 72 times | | Topic: | Help | |
|
| In Help, Gaston.La.Brick writes:
| | | | Again the breakdown of communication. Is it really that hard for Bricklink to
tell a store why they are being suspended? It literally can be accomplished in
a single sentence.
|
Indeed.
Another suggestion to site admins, if they would be reading this: have some sort
of "warning" period before taking actual measures. This allows the seller to
mediate whatever issue is brought to his attention. Seems like a user friendly
way to approach these situations.
|
For many things they will need to suspend immediately to stop the behaviour.
If a seller is trying to get a buyer to use PayPal F+F rather than PayPal with
buyer protection, then it makes sense to stop them immediately so the buyer doesn't
pay that way. Same with any obvious scams. So long as the reason is sent to the
seller with a clear reason (and possibly a tutorial they must complete before
selling again) and instructions how to reopen once resolved, it would be a good
thing.
They shouldn't (and i dont think they do) suspend for any minor things that
can easily be resolved. Whereas breaches of terms, or avoiding sales tax getting
paid properly, etc should be stopped immediately. Otherwise the seller would
be pocketing sales tax, and BL would still need to account for it.
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | calebfishn | | Posted: | Jul 15, 2022 18:20 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 77 times | | Topic: | Help | |
|
| In Help, Gaston.La.Brick writes:
| | | | Again the breakdown of communication. Is it really that hard for Bricklink to
tell a store why they are being suspended? It literally can be accomplished in
a single sentence.
|
Indeed.
Another suggestion to site admins, if they would be reading this: have some sort
of "warning" period before taking actual measures. This allows the seller to
mediate whatever issue is brought to his attention. Seems like a user friendly
way to approach these situations.
|
Stores that need to be suspended may need to be stopped immediately. There isn't
time to send a message with reasons. A seller should be able to contact the
help desk to find out why, and how to resolve the issue.
|
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | Author: | Llewyn | | Posted: | Jul 16, 2022 03:10 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 76 times | | Topic: | Help | |
|
| In Help, calebfishn writes:
| | Stores that need to be suspended may need to be stopped immediately. There isn't
time to send a message with reasons.
|
This is nonsense. The message can be sent after suspending the offending store.
It doesn't save anyone's time to require the seller to contact the helpdesk,
who would still have to reply with a message saying why the store is suspended.
|
|
| | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | Author: | yorbrick | | Posted: | Jul 16, 2022 11:31 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 75 times | | Topic: | Help | |
|
| In Help, Llewyn writes:
| | In Help, calebfishn writes:
| | Stores that need to be suspended may need to be stopped immediately. There isn't
time to send a message with reasons.
|
This is nonsense. The message can be sent after suspending the offending store.
It doesn't save anyone's time to require the seller to contact the helpdesk,
who would still have to reply with a message saying why the store is suspended.
|
Of course a message should be sent but that would be AFTER suspension. Read the
message before the one you replied to. It implies the message should be sent
before taking any action. In just about all cases where suspension is warranted,
the seller should be shut down immediately.
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | Author: | Hubby | | Posted: | Aug 17, 2022 07:17 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 61 times | | Topic: | Help | |
|
| | Any way of appealing that decision? |
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | Hubby | | Posted: | Aug 17, 2022 07:14 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 51 times | | Topic: | Help | |
|
| Yes or a kind of warning instead of just locking and removing the privileges1
THis sucks and my shop just got destroyed for good!
In Help, Gaston.La.Brick writes:
| | | | Again the breakdown of communication. Is it really that hard for Bricklink to
tell a store why they are being suspended? It literally can be accomplished in
a single sentence.
|
Indeed.
Another suggestion to site admins, if they would be reading this: have some sort
of "warning" period before taking actual measures. This allows the seller to
mediate whatever issue is brought to his attention. Seems like a user friendly
way to approach these situations.
|
|
|
| | | | | |
| | | | | Author: | BricksOfFaith | | Posted: | Jul 15, 2022 08:00 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 102 times | | Topic: | Help | |
|
| In Help, Hagbart writes:
| | Dear friends from Bricklink
Just got suspended, seems the work of a buyer that was a liar and a fraud.
What can I do to appeal this decision that is quite unfair as I have much more
transactions than this buyer!
Please help me to waive this.
Regards,
Hubert
|
It seems your having some luck, as the bad review has been taken down! Hopefully
you can open up again, here soon!
|
|
| | | | | | | | | |
| | | | | | | Author: | Hubby | | Posted: | Jul 15, 2022 09:05 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 97 times | | Topic: | Help | |
|
| Thanks a lot for updating me, this is good. But still locked for selling at the
moment.
Hopefully they will waive it too.
Regards,
In Help, BricksOfFaith writes:
| | In Help, Hagbart writes:
| | Dear friends from Bricklink
Just got suspended, seems the work of a buyer that was a liar and a fraud.
What can I do to appeal this decision that is quite unfair as I have much more
transactions than this buyer!
Please help me to waive this.
Regards,
Hubert
|
It seems your having some luck, as the bad review has been taken down! Hopefully
you can open up again, here soon!
|
|
|
| | | | | | | | | | |
| | | | | | | Author: | Nubs_Select | | Posted: | Jul 16, 2022 14:35 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 89 times | | Topic: | Help | |
|
| | wow now I'm confused |
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | peregrinator | | Posted: | Jul 16, 2022 15:46 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 106 times | | Topic: | Help | |
|
| In Help, Nubs_Select writes:
If the limit is only enforced on the client side then it's pretty easy
|
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | Author: | 1001bricks | | Posted: | Jul 16, 2022 16:30 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 107 times | | Topic: | Help | |
|
| In Help, peregrinator writes:
| | In Help, Nubs_Select writes:
If the limit is only enforced on the client side then it's pretty easy
|
And it may explain why his store is closed?
|
|
| | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | Author: | Hubby | | Posted: | Aug 17, 2022 07:42 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 79 times | | Topic: | Help | |
|
| | So what can be done then? |
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | Author: | Fr0stByt3 | | Posted: | Jul 17, 2022 10:35 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 66 times | | Topic: | Help | |
|
| In Help, peregrinator writes:
| | In Help, Nubs_Select writes:
If the limit is only enforced on the client side then it's pretty easy
|
That's interesting though. Presuming the server side is written in PHP, it
shouldn't be too difficult to perform a check by getting the length of the
$_POST array using var_dump.
Then again, I could be wrong. My forte's Lua but it still seems strange there
aren't any checks for this sort of thing.
|
|
| | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | Author: | SylvainLS | | Posted: | Jul 17, 2022 10:49 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 49 times | | Topic: | Help | |
|
| In Help, SomeRandomUser writes:
| | […]
That's interesting though. Presuming the server side is written in PHP, it
shouldn't be too difficult to perform a check by getting the length of the
$_POST array using var_dump.
|
Hmm, all the ‘old’ site’s URLs are in ‘.asp’, I think that’s a hint that it’s
not PHP 
(The new versions are ‘.page’, full of JavaScript and JSON.)
But that doesn’t change the ability to check, and more thoroughly than just the
size.
| | Then again, I could be wrong. My forte's Lua but it still seems strange there
aren't any checks for this sort of thing.
|
It’s not strange at all. Sadly, it’s SOP not to check anything so that you easily
get powned: https://xkcd.com/327/
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | Author: | BricksThatStick | | Posted: | Jul 17, 2022 10:56 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 46 times | | Topic: | Help | |
|
| In Help, SylvainLS writes:
| | In Help, SomeRandomUser writes:
| | […]
That's interesting though. Presuming the server side is written in PHP, it
shouldn't be too difficult to perform a check by getting the length of the
$_POST array using var_dump.
|
Hmm, all the ‘old’ site’s URLs are in ‘.asp’, I think that’s a hint that it’s
not PHP
(The new versions are ‘.page’, full of JavaScript and JSON.)
But that doesn’t change the ability to check, and more thoroughly than just the
size.
| | Then again, I could be wrong. My forte's Lua but it still seems strange there
aren't any checks for this sort of thing.
|
It’s not strange at all. Sadly, it’s SOP not to check anything so that you easily
get powned: https://xkcd.com/327/
|
All a load of gobbledegook to me. Wish I'd never mentioned it 
|
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | Author: | SylvainLS | | Posted: | Jul 17, 2022 11:17 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 47 times | | Topic: | Help | |
|
| In Help, BricksThatStick writes:
| | […]
All a load of gobbledegook to me. Wish I'd never mentioned it
|
Okay, so here’s the executive version:
— fields are defined and filled in the interface, the webpages (what the user
sees in their browser),
— their values are then sent to the server to be entered in the database,
— constraints (like max length for the feedback) should be checked both by the
server, for security and consistency, and in the interface, so as not to make
unnecessary roundtrip requests to the server (‘wrong, try again’).
As this feedback is longer than the interface/browser allows, it means it has
been sent to the server in another way¹ and the size was not checked by the server
(or the limit is not the same).
———
¹ Requests are just special URLs, so they can be forged. And one can use the
BL API, which is just a bunch of special URLs too. The goal of the API is to
not have to go through the webpages, to automatize things. A side effect is
that you don’t go through the checks in the webpages either.
|
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | Author: | qwertyboy | | Posted: | Jul 17, 2022 12:20 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 48 times | | Topic: | Help | |
|
| In Help, SylvainLS writes:
| | As this feedback is longer than the interface/browser allows, it means it has
been sent to the server in another way¹ and the size was not checked by the server
(or the limit is not the same).
|
At least we know the definition of the column is large enough. Now it is just
a matter of changing the front-end.
Niek.
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | Author: | BricksThatStick | | Posted: | Jul 17, 2022 16:04 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 39 times | | Topic: | Help | |
|
| In Help, SylvainLS writes:
| | some slightly less gobbledegook words
|
Right. Thanks I guess 
I'm just considering it a bug. I can understand that.
Bricklink: Bugs.
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | Author: | SylvainLS | | Posted: | Jul 17, 2022 16:19 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 58 times | | Topic: | Help | |
|
| In Help, BricksThatStick writes:
| | In Help, SylvainLS writes:
| | some slightly less gobbledegook words
|
Right. Thanks I guess
|
I could make a kindergarten version if you want, with drawings to colour
| | I'm just considering it a bug. I can understand that.
Bricklink: Bugs.
|
Yeah, way simpler
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | Author: | 1001bricks | | Posted: | Jul 17, 2022 11:04 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 40 times | | Topic: | Help | |
|
| | | It’s not strange at all. Sadly, it’s SOP not to check anything so that you easily
get powned: https://xkcd.com/327/
|
Trying to hack in forum...
[DELETE FROM FORUM "wildchicken13", "Nubs_Select", "SylvainLS"]
Hoping it works!
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | Author: | qwertyboy | | Posted: | Jul 17, 2022 12:16 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 50 times | | Topic: | Help | |
|
| In Help, 1001bricks writes:
| | | | It’s not strange at all. Sadly, it’s SOP not to check anything so that you easily
get powned: https://xkcd.com/327/
|
Trying to hack in forum...
[DELETE FROM FORUM "wildchicken13", "Nubs_Select", "SylvainLS"]
Hoping it works!
|
DELETE FROM forum_message WHERE userid=505455 OR userid=713109 OR userid=479387;
Niek.
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | Author: | 1001bricks | | Posted: | Jul 17, 2022 14:36 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 50 times | | Topic: | Help | |
|
| In Help, qwertyboy writes:
| | In Help, 1001bricks writes:
| | | | It’s not strange at all. Sadly, it’s SOP not to check anything so that you easily
get powned: https://xkcd.com/327/
|
Trying to hack in forum...
[DELETE FROM FORUM "wildchicken13", "Nubs_Select", "SylvainLS"]
Hoping it works!
|
DELETE FROM forum_message WHERE userid=505455 OR userid=713109 OR userid=479387;
|
I knew, but it was to delete the users (which would use a JOIN) 
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | Author: | qwertyboy | | Posted: | Jul 17, 2022 15:27 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 34 times | | Topic: | Help | |
|
| In Help, 1001bricks writes:
| | In Help, qwertyboy writes:
| | In Help, 1001bricks writes:
| | | | It’s not strange at all. Sadly, it’s SOP not to check anything so that you easily
get powned: https://xkcd.com/327/
|
Trying to hack in forum...
[DELETE FROM FORUM "wildchicken13", "Nubs_Select", "SylvainLS"]
Hoping it works!
|
DELETE FROM forum_message WHERE userid=505455 OR userid=713109 OR userid=479387;
|
I knew, but it was to delete the users (which would use a JOIN)
|
These are the users - they are the user IDs of those people. The database
will use this ID as the foreign key in the forum messages table, not the user
name (which can be changed by the user).
Niek.
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | Author: | SylvainLS | | Posted: | Jul 17, 2022 15:39 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 32 times | | Topic: | Help | |
|
| In Help, qwertyboy writes:
| | […]
These are the users - they are the user IDs of those people. The database
will use this ID as the foreign key in the forum messages table, not the user
name (which can be changed by the user).
Niek.
|
Thing is, the user IDs are used everywhere (messages, catalogue changes…). That’s
why BL doesn’t delete users when the accounts are closed. The names are replaced
with bl## so that the tables can still refer to them.
IOW: you need more work to get rid of us
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | Author: | qwertyboy | | Posted: | Jul 17, 2022 15:51 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 28 times | | Topic: | Help | |
|
| In Help, SylvainLS writes:
| | In Help, qwertyboy writes:
| | […]
These are the users - they are the user IDs of those people. The database
will use this ID as the foreign key in the forum messages table, not the user
name (which can be changed by the user).
Niek.
|
Thing is, the user IDs are used everywhere (messages, catalogue changes…). That’s
why BL doesn’t delete users when the accounts are closed. The names are replaced
with bl## so that the tables can still refer to them.
|
Yup. That is called a foreign key - ithe "userid" in the "forum_messages" table
refers to a primary key (the "id" in the users table).
| | IOW: you need more work to get rid of us
|
The SQL statement deletes the messages for the users mentioned by user 58243
(currently named "1001bricks"). He specifically said "delete from forum", not
"delete from BrickLink all together".
And it would not take that more work to get rid of users:
DELETE FROM users WHERE id=58243;
Byebye Sylvain #2 (who cares about dangling references in all other tables, right?).
Niek.
|
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | Author: | 1001bricks | | Posted: | Jul 17, 2022 15:47 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 33 times | | Topic: | Help | |
|
| In Help, qwertyboy writes:
| | In Help, 1001bricks writes:
| | In Help, qwertyboy writes:
| | In Help, 1001bricks writes:
| | | | It’s not strange at all. Sadly, it’s SOP not to check anything so that you easily
get powned: https://xkcd.com/327/
|
Trying to hack in forum...
[DELETE FROM FORUM "wildchicken13", "Nubs_Select", "SylvainLS"]
Hoping it works!
|
DELETE FROM forum_message WHERE userid=505455 OR userid=713109 OR userid=479387;
|
I knew, but it was to delete the users (which would use a JOIN)
|
These are the users [...]
|
Hum - I know, it was a joke.
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | Author: | qwertyboy | | Posted: | Jul 17, 2022 15:52 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 37 times | | Topic: | Help | |
|
| In Help, 1001bricks writes:
| | In Help, qwertyboy writes:
| | In Help, 1001bricks writes:
| | In Help, qwertyboy writes:
| | In Help, 1001bricks writes:
| | | | It’s not strange at all. Sadly, it’s SOP not to check anything so that you easily
get powned: https://xkcd.com/327/
|
Trying to hack in forum...
[DELETE FROM FORUM "wildchicken13", "Nubs_Select", "SylvainLS"]
Hoping it works!
|
DELETE FROM forum_message WHERE userid=505455 OR userid=713109 OR userid=479387;
|
I knew, but it was to delete the users (which would use a JOIN)
|
These are the users [...]
|
Hum - I know, it was a joke.
|
I was trying to give your most-excellent idea a better chance of succeeding.
Niek.
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | Author: | Fr0stByt3 | | Posted: | Jul 17, 2022 11:08 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 51 times | | Topic: | Help | |
|
| In Help, SylvainLS writes:
| | (The new versions are ‘.page’, full of JavaScript and JSON.)
|
Hm, I'm not familiar with that extension but given how you stated JavaScript,
is it reasonable to believe the back end is written in a JavaScript framework
of sorts?
| | It’s not strange at all. Sadly, it’s SOP not to check anything so that you easily
get powned: https://xkcd.com/327/
|
Good practice is to believe every client is malicious with the intent on breaking
through. That's how I typically handle things when programming in server-client
models.
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | Author: | SylvainLS | | Posted: | Jul 17, 2022 11:21 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 40 times | | Topic: | Help | |
|
| In Help, SomeRandomUser writes:
| | In Help, SylvainLS writes:
| | (The new versions are ‘.page’, full of JavaScript and JSON.)
|
Hm, I'm not familiar with that extension but given how you stated JavaScript,
is it reasonable to believe the back end is written in a JavaScript framework
of sorts?
|
I don’t know who uses the .page extension. It could actually be anything. (One
could write their pages in ASP and use the .php extension or vice-versa to ‘confuse
the enemy’ )
| | | | It’s not strange at all. Sadly, it’s SOP not to check anything so that you easily
get powned: https://xkcd.com/327/
|
Good practice is to believe every client is malicious with the intent on breaking
through. That's how I typically handle things when programming in server-client
models.
|
My point was that ‘good practice’ is sadly not ‘common practice’
|
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | Author: | peregrinator | | Posted: | Jul 17, 2022 13:10 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 35 times | | Topic: | Help | |
|
| In Help, SylvainLS writes:
| | I don’t know who uses the .page extension. It could actually be anything. (One
could write their pages in ASP and use the .php extension or vice-versa to ‘confuse
the enemy’ )
|
My guess is that the site is running .Net; older pages in ASP and newer ones
in C#. (C# is also used in Unity which is what I think Stud.io is developed in.)
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | Author: | SylvainLS | | Posted: | Jul 17, 2022 13:34 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 46 times | | Topic: | Help | |
|
| In Help, peregrinator writes:
| | In Help, SylvainLS writes:
| | I don’t know who uses the .page extension. It could actually be anything. (One
could write their pages in ASP and use the .php extension or vice-versa to ‘confuse
the enemy’ )
|
My guess is that the site is running .Net; older pages in ASP and newer ones
in C#.
|
Yeah, I think so too… but is the site directly developped on .Net? I doubt it.
And if there’s an intermediary framework, I don’t know which one.
(For instance, the help pages are on Zendesk, and the helpdesk site is SmarterTrack
(with JIRA as a BTS).)
| | (C# is also used in Unity which is what I think Stud.io is developed in.)
|
(Studio, no dot anymore since v2 )
AFAIK, the Studio devs are not the web devs (or at least, if they were ‘shared’
or ‘borrowed’, it shouldn’t be the case anymore).
|
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | Author: | peregrinator | | Posted: | Jul 19, 2022 11:01 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 40 times | | Topic: | Help | |
|
| In Help, SylvainLS writes:
| | But that doesn’t change the ability to check, and more thoroughly than just the
size.
|
OK, I tried an experiment and I was able to save a comment of 90 chars in length
- the one I submitted was much longer than 90 chars but it got cut off at 90.
The comment, ah, commented upon above is 200 characters. So maybe there was a
check on the server side after form submission to make sure the comment was 200
characters or fewer - now it checks for 90 or less.
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | Author: | peregrinator | | Posted: | Jul 19, 2022 11:01 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 33 times | | Topic: | Help | |
|
| In Help, peregrinator writes:
| | In Help, SylvainLS writes:
| | But that doesn’t change the ability to check, and more thoroughly than just the
size.
|
OK, I tried an experiment and I was able to save a comment of 90 chars in length
- the one I submitted was much longer than 90 chars but it got cut off at 90.
The comment, ah, commented upon above is 200 characters. So maybe there was a
check on the server side after form submission to make sure the comment was 200
characters or fewer - now it checks for 90 or less.
|
What I've not tried is doing it through the API. That's a bit too much
work for me at the moment.
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | Author: | qwertyboy | | Posted: | Jul 19, 2022 13:30 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 29 times | | Topic: | Help | |
|
| In Help, peregrinator writes:
| | In Help, peregrinator writes:
| | In Help, SylvainLS writes:
| | But that doesn’t change the ability to check, and more thoroughly than just the
size.
|
OK, I tried an experiment and I was able to save a comment of 90 chars in length
- the one I submitted was much longer than 90 chars but it got cut off at 90.
The comment, ah, commented upon above is 200 characters. So maybe there was a
check on the server side after form submission to make sure the comment was 200
characters or fewer - now it checks for 90 or less.
|
What I've not tried is doing it through the API. That's a bit too much
work for me at the moment.
|
Just did a test trying to post a feedback of 118 chars through the API. The request
was accepted, but the result was truncated to 80 chars.
Niek.
|
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | Author: | miskox | | Posted: | Jul 19, 2022 13:31 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 33 times | | Topic: | Help | |
|
| | | Just did a test trying to post a feedback of 118 chars through the API. The request
was accepted, but the result was truncated to 80 chars.
Niek.
|
Maybe this bug was just fixed?
Saos
|
|
| | | | | | | | | |
| | | | | | | Author: | miskox | | Posted: | Jul 17, 2022 04:03 | | Subject: | Re: Your store is suspended But WHY ? | | Viewed: | 86 times | | Topic: | Help | |
|
| In Help, BricksThatStick writes:
Guessing:
1.) API
2.) CTRL-C and CTLR-V
Saso
|
|
|
|
|
Denmark
USA, Hawaii
United Kingdom, England
Spain, Comunidad Valenciana
Slovenia
Belgium
Canada, Ontario
France, Provence-Alpes-Côte d'Azur
