Desiderius Price

40908

Thanks, figured I’d try it and needed the guidance. Placement seems a bit on the cryptic side.

Long time coder myself, which is why I can sympathize/empathize with you Manta! When I played around with PHP/SQL/Web, think it was PHP-4/5? – enough to give me an idea of what you’re up to.

Psst… suggest not pinging and interrupting the coder unless you’ve found a bug in the new stuff. And even then, maybe have a single topic/thread to record them so she can deal with it one at a time?

Such a vulnerability would’ve existed since the PHP scripts were first written, and obviously became a problem once that scammy scammer decided to exploit it. That’s as far as I’ll speculate about it.

Well, SQL is the code that databases understand. Anyways, when in a rush or inexperienced or prototyping, the PHP website will take user input, directly make it part of the code that it sends to the database. Now, SQL injection is a user crafting input that isn’t a simple thing like “erotica”, instead they make it funny so instead of a simple “get data” SQL statement, it becomes a “SQL do-this-other-thing” which can be to modify the database, get more than they’re supposed to, etc. A solid fix is not make it part of the SQL, instead treating it as pure data, using the parameter-based SQL which avoids the injection issue. – That’s me trying to make it simple. Here’s a web-comic about it. https://xkcd.com/327/

Given the nature of the issue (SQL Injection), a fair chunk of the website’s PHP script SQL bindings have to be rewritten, parameterizing and seriously sanitizing all user input. Typos will happen, part of the process, I’m afraid.

See the posts/updates from manta2g. “Green” is supposed to be the key though to what’s been vetted.

40906

40904

40902

40900

40898

40896

40894

40890

40888

40886

That was the distinction I was missing. Fanfic, by its nature, is taking elements of canon and the contributions of the fanfic writer (at least in plot & the actual word arrangements) – I know, that’s being generous for some of the fanfic out there. An exact determination of derivative vs transformative can require a court case, to determine if fair use would apply (thereby allowing the fanfic writer to ignore a demand of the canon author to not post a fanfic). However, I’m not willing to spend $100k to defend a fanfic in court, and there’s that ever present chance to LOSE the case making the fanfic situation worse. Luckily for my Harry Potter fanfic, JK Rowling did famously allow fanfic on a not-for-money basis; thus rendering the debate closer to academic as I doubt I’d ever feel comfortable charging readers for my writings. (p.s. why is my auto-correct wanting to change “fanfic” to “fanatic”?)

40884

Apologize if you misunderstood. There’s a copyright lawyer on youtube, and I do watch a number of his videos on the topic of fair use, so that’s why I see this a bit more fuzzy than most, because there are times when something reads as a derivative work and succeeds at a fair use claim in court. (Was debating discussing this more or working on the Halloween story research … )

Thank you for your diligence and efforts here.

The spook I’ll get is the relevant advertisments will haunt me for years.

Nearly any line is jagged and a wide swath of area if you look at it closely enough. Now, I’m not a lawyer, but I do watch some on youtube… that makes me qualified, right? I’ll ignore the outright plagiarism you’re noting above and assume US copyright law based on what I’ve seen for my youtube law degree. Fanfiction is part source material and part new material. Author(s) of the source have copyright interests in their own works *AND* that part of your fanfiction that leverages their material. However, the fanfic writer does have copyright interest in the material they added in crafting their fanfic. Fanfic writers usually slap on a disclaimer, disavow profit, seek fair use as grounds for posting, and call it a wrap, easy done, easy go. BUT unless that fanfic writer has signed it away, they’ve got copyright in what they contributed, and therefore, they can use the DMCA against the offending website. That’s my $0.02 on how a fanfic writer can deal with a website that pirates their stories. If they want to go further, if there’s a legal tassle, then I’d seriously recommend consulting a copyright lawyer who can evaluate the situation.