rproffitt 2,701 https://5calls.org Moderator

Convert or connect? Two entirely different problems to solve.

Convert may have use export to a common format and import to SQL. Given all that's on the web, I'll stop here.
Connect to an existing DBF might be what you really wanted. Google shows me I shouldn't write more: https://www.google.com/search?q=vb.net+dbf+connection+string

rproffitt 2,701 https://5calls.org Moderator

There appears to be missing code or steps in your post. Read https://docs.microsoft.com/en-us/sql/ssms/visual-db-tools/create-union-queries-visual-database-tools?view=sql-server-2017 for an example of the UNION but you may need to redo your query (I don't see that here) to use the UNION ALL as the error calls out.

bckelley commented: since this is the only place I can comment! [customerName] is a string from the database i.e. George, Fred, Alice whatever, that was a placeholder +0
rproffitt 2,701 https://5calls.org Moderator

For me this would have me check prior solutions such as https://rosettacode.org/wiki/Category:Palindromes

rproffitt 2,701 https://5calls.org Moderator

"That's not good."

Before you do much of anything try to get your W7 CDKEY out with MAGIC JELLYBEAN KEYFINDER. It's free and you need this in case of a meltdown of the W7 OS. You can find W7 ISOs so I won't write about that.

Lattitudes are usually pretty tame laptops so this is not a good sign. Try another bootable OS (Linux) but other distros. See if the BIOS is current too. Using old BART's or old Linux to me is not what I'd do. I'd try current releases.

rproffitt 2,701 https://5calls.org Moderator

Since "occurs twice" appears to be the cause and what you need to investigate, where is the code that sets up or handles the drag, drop and mouse events?

PS. The code supplied doesn't appear to be causing this.

Milla S. commented: Thank you! +0
rproffitt 2,701 https://5calls.org Moderator

You did it again. You've posted questions that have prior discussions that we can use today.

https://www.google.com/search?q=measure+the+ROI+in+social+media

Can you tell the forum what you are really looking for here and not just a rehash of the same old question?

rproffitt 2,701 https://5calls.org Moderator

Welcome to Daniweb. Can you tell the forum what your concerns are?

rproffitt 2,701 https://5calls.org Moderator

You left out all the details.

  1. What are the needed tasks?
  2. How are you measuring "best"?
  3. It appears you are aware of Joomla, WordPress and others but left out why these don't work for you.
rproffitt 2,701 https://5calls.org Moderator

The answer to most if not all the questions is yes. I wish folk would number their questions and always end a question with a question mark so everyone can find the question and answer them by the numbers.

But I'm going to stop here and note that if the user can create the logins then there seems to be no reason to have any user security since this person created all 5 accounts. It's one really odd design and even odder to limit it to five. Hardcoding that limit may be adding complexity where leaving it to nearly unlimited might be better. That is, you do the usual please enter you account name then password and check if they are a current user and if so connect to their database.

And yes, SQL would be a great step up in learning the better methods and can push the security back into the database since leaving it in your app means the database is usually insecure.

As to being new, that wears off in time. Mostly by continuing classes and tutorials.

hyperion0 commented: Alright, thank you for informing me! +0
rproffitt 2,701 https://5calls.org Moderator

You appear to be asking for all the code for your application rather than help with your code. That's where you write your request for freelancers to create your app and deliver it good to go. Here we are fine with helping you with your code and it's trouble spots but for a total application and its code you need to post in a For Hire type posting.

rproffitt 2,701 https://5calls.org Moderator

Here's the exploit. Let's say you make FOSS of say Opera.

Evil person now takes that and makes an version that keylogs and sends files from the system to some other place.
Evil persons make fake web sites claiming we have the real Opera for download or "version 65 - Newest out today!"

Oh wait, that is exactly what is happening out there.

I feel this is far off topic but it's a real problem out there.

rproffitt 2,701 https://5calls.org Moderator

With py files being text what stops me from editing the app and showing what these variables are?

This is why I thought you could compile, and maybe do work in hiding the variables, XOR, and more with Pyarmor.

If you give up the source, where is this secure?

rproffitt 2,701 https://5calls.org Moderator

"Bamboozled again."

At some point the code has to exist somewhere. Let's say you distribute your .pyc files for others to run, they decompile, add prints and more?

  1. Security is an illusion?
  2. Now to fix this, make a a software as a service? (SAAS!)
rproffitt 2,701 https://5calls.org Moderator

As a test, take your .pyc and decompile it to see if your work at hiding the value is exposed with a decompiler.

https://sourceforge.net/projects/decompyle/

This is why, if there is a secret number or string we can't just assign it to anything directly.

IOW, I don't know how deeply you think about all this but variables with secrets are dangerous as they live for a time where as something transitory will be short lived and not in long term memory. I'm a season microprocessor user (think embedded micros) so back to thinking about how to keep the secrets from being used for a variable directly is one thing then another is if said secret is used to make a system API call which can be exposed with most debuggers.

This rabbit hole goes deep.

rproffitt 2,701 https://5calls.org Moderator

While you are not looking for obfuscation, it's still possible to get at those values as noted in my last link using the tools and inspections they note.

I'm reminded of this old saying. "Any code devised by humans can be decoded by humans." So if you are looking for value security then you never place the final value in a single variable. Use as much security as you see fit for the task.

In parting I'm reminded again of where there was a secret value but the programmer passed it from a web service and they picked it off with a packet sniffer. This was one determined attacker so about all they could have done was to make it a few steps harder by adding some XOR or encryption to the value so it never lives in a variable. Also, Python and the security level you appear to want is something you'll have to work at. I also would take bet few consider this a bug.

rproffitt 2,701 https://5calls.org Moderator

I think a lot of what you are noting is indirectly covered at https://wiki.python.org/moin/Asking%20for%20Help/How%20do%20you%20protect%20Python%20source%20code%3F

You have to read nearly to the bottom where it writes about Pyarmor and:

  • Encrypt code object by DES to protect constants and literal strings.
  • Obfuscate byte code of each code object when code object completed execution.
  • Clear f_locals of frame as soon as code object completed execution.

So backing up all the way to the top and running at this again, old Python does not secure your internal constants, literal strings and more. It's not what Python does so you have to think of ways such as that XOR use or other ways if you want to obfuscate secrets in Python or for that matter almost all other languages.

rproffitt 2,701 https://5calls.org Moderator

Out on a walk I recall something we did long ago to hide values that were at the time IN PLAIN SIGHT if you looked at the compiled code.

Let's say the secret number was coded like:

secret_number = 12345; // Hey that's my luggage combination too.

Since we had to distribute the compiled exe we would then do another operation on the variable so it wasn't so easy to pick off.

answer = value * (secret_number xor magic); // Not terrible secure but better.

Since Python is usually some plain text file, if the server was compromised then all secrets are laid bare but at least we have no real exposure of internal variables and constants from say Python scripts that run on the server and the client that is getting the output in their web browser.

Then again we could broach SQL injection which by now you know how to mitigate.

rproffitt 2,701 https://5calls.org Moderator

Review as in speed, code, etc?

https://gtmetrix.com/reports/www.peers24.club/DUY8Vy1x shows you did a great job. All grade A except one item which is fine.

If you are asking if I would sign up, no. Already here and on LinkedIn. I see no reason to join. Can you tell me why I should?

PS. I see you asked this before. At least it looks better that I recall but still doesn't have that pull.

rproffitt 2,701 https://5calls.org Moderator

I'm going to stay on the topic of access of privates inside our app. You did expand your questions to what may be web security and more.

Since your code is in Python and that is not on the client but the web server then the client can't access most of the variables and classes in your Python code.

As to all the NEW issues you bring up in your reply, well, that needs its own discussion.

rproffitt 2,701 https://5calls.org Moderator

As a primer I refreshed my view on privates at https://en.wikipedia.org/wiki/Law_of_Demeter

As to insta. at some point during debugging and more you will need access to all things. I don't consider this to be a big deal.

rproffitt 2,701 https://5calls.org Moderator

My thought is that the capture doesn't appear to support this so you'll have to make this a two step process in your code.

  1. Screen capture. This is well done with many priors so I won't write a word here.
  2. Crop your captured image. Example: https://www.google.com/search?q=crop+an+image+with+python&gl=US
rproffitt 2,701 https://5calls.org Moderator

Sadly the app appears to have fake reviews. Why are you endorsing this?

rproffitt 2,701 https://5calls.org Moderator

Here I just use a faster ISP. Also, with the news about mobile data providers throttling video, you won't be fixing that!

rproffitt 2,701 https://5calls.org Moderator

@Walterion.

  1. At the time of posting the Twitter link was non-op. Works now.
  2. You wrote "a tool that threats JSON" which is amusing but may not be what you intended to say.
  3. You made a bold claim but didn't back it up with test data or reports. Folk may think you are boasting or an assertion that is likely false.
rproffitt 2,701 https://5calls.org Moderator

Two questions.

  1. How do you solve this now? The answer leads to you coding that process.
  2. Why did your question vanish at https://stackoverflow.com/questions/57684251/optimizing-string-with-least-number-of-ones+&cd=1&hl=en&ct=clnk&gl=us I wonder if you were asked to restate or expand.
rproffitt 2,701 https://5calls.org Moderator

I read your post twice and don't see why a c++ math library would be needed. It looks to be simple math that doesn't use functions from say http://www.cplusplus.com/reference/cmath/

As such I worry you are asking for everyone to code this for you.

rproffitt 2,701 https://5calls.org Moderator

I would be guessing this is either:

  1. I don't know how to use Task Scheduler.
  2. Task Scheduler is broken.
  3. A CLEANER TOOL was used and broke Windows.

As presented without much story maybe restoring from your last good backup is best.

rproffitt 2,701 https://5calls.org Moderator

PS. I see nothing about the PC but am seeing too many show up at the repair counter that need the current OS and the drivers that the makers tell us to use. I also see why this happens. Folk did not expect to have to know this stuff decades later after the first PCs. Sorry folk, it's still up to us to sort that out.

rproffitt 2,701 https://5calls.org Moderator

I think you should be more consistent about restarts. That is, forget HIBERNATE since you have a SSD.

Even then, my most stable PC ever seems to still get an issue once every few months. I am not going to chase that one down as it seems relating to gaming.

Since you are running W10 you may have driver hell. That is, with Microsoft automatically updating drivers on a few PCs I've had to disable Microsoft's Driver Update (not to be confused with Windows Update) and then install the drivers from the makers.

In no way or words am I telling you this is the fix. But I would forget about hibernate, sleep and possible grab control back on drivers.

rproffitt 2,701 https://5calls.org Moderator

Can you tell me what you meant by "drop their out projects"? If it's a spelling error, fine but do correct this so folk know what you are asking.

Also why Turbo C++? It's from 1990, not that old is bad but for students, my advice is to move to something current like GNU C++, Visual Studio (Community Version is free) so they are not dealing with a near 30 year old system that will likely instill bad practices.

rproffitt 2,701 https://5calls.org Moderator

I'll avoid supplying the answer since you must code it yourself or I'd be doing your homework.

I take it you want to decrement by 2. SO... THINK about.

--i means i-=1; return i

So to decrement by 2, change the 1 to 2.

rproffitt 2,701 https://5calls.org Moderator

The one line of code goes where you pick up and use the slider value since the slider does not work as you wish so you fix it with ... one line of code.

rproffitt 2,701 https://5calls.org Moderator

Welcome.

Take a moment to fill out your Daniweb profile so others know you better.

rproffitt 2,701 https://5calls.org Moderator

I should have written how I worked around such long ago. This was over a decade ago so psuedocode.

Say we have a textbox with a value and a slider. Let the slider start be default and the step be one as usual. Set the max to be what works for the following.

Textbox value = StartValue + (SliderValue * step)

This was done because something similar was not working as we wanted in the native slider but with one line of code, done.

rproffitt 2,701 https://5calls.org Moderator

You would have to dive into the source to see why but the docs give me a clue it's rounding to Integers and again, you get to the source to see why this happens. I had someone counter that it shouldn't round but it does unless...

The default resolution is 1, which causes the widget to round all values to the nearest integer value. You can use the resolution option to specify another resolution; use -1 to disable rounding.

So if you don't want to get into source, and you want your start to be say 19 with a resolution of 2, what happens when you try a start of 18? Does it start at 19 with a resolution of 2?

rproffitt 2,701 https://5calls.org Moderator

I'll be honest with you. Long ago we tried going down that road (something akin to Xamarin) and after years had to rip it all up to move it to the mainstream dev kit. This is not an offer to write a treatise about all that. Just a nod why and what we went with this round. Android Studio.

I do know that many of today's programmers are looking for an easy way to avoid learning what needs to be learned but when they do that they often learn other lessons.

rproffitt 2,701 https://5calls.org Moderator

Tell more. Complete your DANIWEB PROFILE too. As it stands it sounds like you are spamming. Have a menu?
smallspam.gif

rproffitt 2,701 https://5calls.org Moderator

You followed with more questions. I'll put them into a list.

  1. Wrong place?
    This is fine.
  2. Cost of dev tools.
    The Community version is free. Android Studio is free. What's not to like here?
  3. Freeware one can download without spyware or advertising.
    I have installed both the ones I noted and consider them free from spyware and advertising. I can't guess if you would get them from a torrent or other than the source so maybe you are trying to avoid the source (Microsoft and Google) and ended up with a bad experience. I can't guess why folk do that.

As to the last question about Daniweb and navigating, I have yet to find any reading material about that.

rproffitt 2,701 https://5calls.org Moderator

I went with Android Studio. But what is this about a site? I would be guessing what you meant so tell more.

rproffitt 2,701 https://5calls.org Moderator

The Windows.old folder is normal. There are a lot of articles about it on the web so I will avoid duplicating the web here. After some time, Microsoft will clean it off for you. You can ignore it if you wish or you can do more research.

rproffitt 2,701 https://5calls.org Moderator

To me that looks like a bootable disc. It's not very useful from Windows unless you wanted to run Linux in some Virtual Machine like VirtualBox.

There are so many tutorials on booting from your drive over the years. Even I noted it a while ago at http://tips.oncomputers.info/archives2004/0401/2004-Jan-11.htm and I'm sure there are thousands of pages about booting Linux.

Bootiing these discs are what I find folk stumble at. The disk is bootable. Not very useful if you are running Windows.

rproffitt 2,701 https://5calls.org Moderator

My first thought was this would no longer work on today's PC. So much has changed that my bet is this may only work in old PC emulators like QEMU. Sure enough that appears to be going on here.

Read priors to cover this again.

I can't guess if you write this from scratch or copied someone else's work but I don't expect it to work today unless you find some over 10 year old hardware.

rproffitt 2,701 https://5calls.org Moderator

Don't you find it odd that your HOSTS file has so many aol.com entries?
Also, why post a scan from 2003?

Also, XP is a very dead OS. Few can optimize today from what I'm reading. I'd hit up BleepingComptur as well since:
https://www.bleepingcomputer.com/startups/khooker.exe-4941.html

You should research each line in your report and KNOW WHAT IT DOES. You'll find items you can do without but here's the awful thing I find. Many old PCs are beyond the end of life where I find the cause of the terrible performance to be a failing HDD. The owner usually won't admit that and will blame it on the OS. Not much you can do about those PCs.

Whoops, are you trolling? https://www.bleepingcomputer.com/forums/t/702783/please-help-me-my-computer-is-sooo-slow-and-i-dont-know-what-is-wrong-with-it/ wrote:

Topic closed. OP has been observed to be trolling malware forums re-posting old topics.

rproffitt 2,701 https://5calls.org Moderator

What you could consider is the Community version of Visual Studio. Once you get your apps done, then you can ponder if you want to buy that.

Why buy now?

rproffitt 2,701 https://5calls.org Moderator

I worry you are not using the search results we have today. I read just one article from https://www.google.com/search?q=What+is+the+Difference+between+crawling+and+indexing%3F&gl=US and it seems clear to me.

Can you share what is unclear to you?

rproffitt 2,701 https://5calls.org Moderator

It's been a day so what I did was pop your title question into google. I think it's a wee bit more complicated than one file to change and as such may be best to research this with your title question on a google search.

rproffitt 2,701 https://5calls.org Moderator

I defer on a full dissertation and leave it at that.

  1. Paypal. Folk know it and use it.
  2. Amazon. With a high percentage of users in N.A. Folk will have a little more trust if you use this one.
rproffitt 2,701 https://5calls.org Moderator

My question would be "Does SERP result in more income?"

Much of what SEO does for the lower ranks is next to no effect. Sure your visitations went up a little but your hours of work didn't result in you getting paid. I continue to see where the company's product and support is where the value is.

rproffitt 2,701 https://5calls.org Moderator

Quicken has their own cloud for this. Why the answer is yes, the reality is no, Quicken holds all the code so you can't change which cloud they have their apps on.

PS. Why wouldn't those at the company you promote know this? By asking this question you may be degrading that company's reputation.

rproffitt 2,701 https://5calls.org Moderator

As you appear to work for ifour, this means they seem to employ folk that can't dig into basic web concepts and as a company should be avoided.

Now maybe you were really trying to get your tagline and company some SEO love but I really want you to think about what you've done here. Your attempt to SEO or such can work against you and your company by posting low value content.