Web Dev Questions That Don't Need Their Own Thread v4 - Developers

-Snip wrong post-

[QUOTE=Datzy;41718992]If it's not an intensely large amount of information, you could do with two or more MD5 encryptions. (That's what vB does by default)[/QUOTE] MD5 is not a cipher, it's a hash function. To explain the difference shortly, imagine that those two things are roads: MD5 sums are one way roads, and ciphers are regular roads. You can go along the MD5 road without problems from the right direction, turning data into a hash. But going the wrong way is nearly impossible, except with some tricks that either use problems in the algorithm - for instance in said MD5 function - or incorrect usage of the hash function to protect data. Ciphers, on the other hand, allow you to go both ways with ease, converting unencrypted into encrypted data and vice versa. The difference lies in the fact that ciphers essentially got barriers at both sides of the road. Symmetrical ciphers need the same key at both the entrance and the exit; you encrypt and decrypt data with the same key. Asymmetrical ciphers require a "keypair"; data can be encrypted with one key and only decrypted with the other key.

How do i center an image inside a <td>? at the moment what's happening is this [img]http://gyazo.com/52b8e776c72211aa6368fe1a4d460170.png[/img] i need the image vertically centered

[QUOTE=Blackfire76;41727033]How do i center an image inside a <td>? at the moment what's happening is this [img]http://gyazo.com/52b8e776c72211aa6368fe1a4d460170.png[/img] i need the image vertically centered[/QUOTE] vertical-align: center (or you can manually adjust it with pixels)

thanks, testing now

Alternatively you could also set the line-height.

- snip -

[QUOTE=Epiclulz762;41728486]If not then try: Depending on what you are centering this may also be suitable.[/QUOTE] he asked for vertical not horizontal.

- snip -

[QUOTE=jung3o;41727050]vertical-align: [B]center[/B] (or you can manually adjust it with pixels)[/QUOTE] vertical-align:middle

[QUOTE=CBastard;41729192]vertical-align:middle[/QUOTE] This man is correct. My bad [url]https://developer.mozilla.org/en-US/docs/Web/CSS/vertical-align[/url]

[QUOTE=Datzy;41718992]If it's not an intensely large amount of information, you could do with two or more MD5 encryptions. (That's what vB does by default)[/QUOTE] hi, im working randomkid88 actually on this. Since we're going to potentially deal with minor's information being submitted and stored in a third-party location, what is the best way to know that the data is going to be secure from brutes/ other means of unlawful access? Is there a way to make the database more secure?

[QUOTE=areolop;41730081]hi, im working randomkid88 actually on this. Since we're going to potentially deal with minor's information being submitted and stored in a third-party location, what is the best way to know that the data is going to be secure from brutes/ other means of unlawful access? Is there a way to make the database more secure?[/QUOTE] Here's the problem: there is no [b]good[/b] way to go about securing the contents of the database. Either you have an encryption key locally or you have one remotely. If you're going to be accessing the data frequently, then it doesn't make sense to have it remotely. If it is local, then if someone compromises the machine you are shit out of luck because now they have the data and the key to decrypt it. If you're storing it remotely are you still going to have access to it? If someone gets your source code are they going to be able to do the same actions you are (get, delete, update, etc)?

- snip -

[QUOTE=Epiclulz762;41736902]I have to guess this is a conflict with domains but, when I request [CODE]myWebSite.com[/CODE] everything is coolio, yet when I request [CODE]www.myWebsite.com[/CODE] my external JavaScript and Stylesheet file are not fetched. This happens sporadically, could it be a cache error or something related to the domain?[/QUOTE] DNS wise how is www handled? Also, in what way are you accessing your script / style files?

- snip -

[QUOTE=Elecbullet;41739520]Say what you will, Chrome has given me more trouble with CSS than anything. (Though I don't do much with Firefox.) I have an example page that I would like to use with [url=https://developer.mozilla.org/en-US/docs/Web/CSS/image-rendering]the image-rendering[/url] property. It works fine in Firefox but doesn't work at all in Chrome. [url]http://wolfenstein.wikia.com/wiki/User:Thisismyrofl/Interpolation[/url] View in Firefox to see the correct action. Basically, what should happen is the ''top'' two Hitlers should have crisp, contrasting edges, while the bottom should not. In Chrome, both are softened, which doesn't work on my wiki. Apparently image-rendering works in Chrome but I can't get it to. If anyone has any idea how to make it work in Chrome, please let me know. [url]http://wolfenstein.wikia.com/wiki/MediaWiki:Common.css[/url] contains the CSS I'm using: [php]div.crisp img { /* crisp sprites when upscaled */ image-rendering:optimizeSpeed; /* Legal fallback */ image-rendering:-moz-crisp-edges; /* Firefox */ image-rendering:-o-crisp-edges; /* Opera */ image-rendering:-webkit-optimize-contrast; /* Chrome (and eventually Safari) */ image-rendering:optimize-contrast; /* CSS3 Proposed */ -ms-interpolation-mode:nearest-neighbor; /* IE8+ */ }[/php][/QUOTE] If you use chrome on OSX you'll probably notice that it works perfectly. That's apparently the only version that has support for that. [url=https://code.google.com/p/chromium/issues/detail?id=106662]Source[/url]

Well that's fooken dumb, and I could really use that function on my wiki.

- snip -

[QUOTE=andersonmat;41732978]Here's the problem: there is no [b]good[/b] way to go about securing the contents of the database. Either you have an encryption key locally or you have one remotely. If you're going to be accessing the data frequently, then it doesn't make sense to have it remotely. If it is local, then if someone compromises the machine you are shit out of luck because now they have the data and the key to decrypt it. If you're storing it remotely are you still going to have access to it? If someone gets your source code are they going to be able to do the same actions you are (get, delete, update, etc)?[/QUOTE] They wont be able to do anything with the information due to the connection to the database being localhost only connections [editline]6th August 2013[/editline] as far as editing, deleting etc

[QUOTE=areolop;41741404]They wont be able to do anything with the information due to the connection to the database being localhost only connections [editline]6th August 2013[/editline] as far as editing, deleting etc[/QUOTE] Unless they compromise the machine.

I'm currently writing my own monitoring script in php with mysql, and I am only interested in keeping the last 'n' amount of rows in a database table. Is there an easy query to delete all rows but leave the newest 'n' in tact? Been looking online but cannot find any that seem to work correctly.

you could probably do it using OFFSET if that's usable in a delete statement.

[QUOTE=AndrewPH;41748812]you could probably do it using OFFSET if that's usable in a delete statement.[/QUOTE] Yeah just been looking around for ages, ended up doing it with two statements. Not sure if it's the best way, but it works. [t]http://tbx.me/9VL.png[/t]

Is it true that if you order a dedi from OVH you have to provide them with personal info (passport, driver's license)?

[QUOTE=Cowabanga;41752452]Is it true that if you order a dedi from OVH you have to provide them with personal info (passport, driver's license)?[/QUOTE] A lot of the time you do I think - although I haven't had to yet, just waiting for my to be set up.

If I need to delete multiple values form the same column in an SQL database, how would I do that?

[QUOTE=gokiyono;41756543]If I need to delete multiple values form the same column in an SQL database, how would I do that?[/QUOTE] [code]DELETE FROM `table_name` WHERE `column`='value' OR `column2` = 'value' [/code] is that what you mean?

[QUOTE=Snakess;41756241]A lot of the time you do I think - although I haven't had to yet, just waiting for my to be set up.[/QUOTE] Apparently they have to ask you if you're not a UK resident, that's lame.

[QUOTE=Cowabanga;41758998]Apparently they have to ask you if you're not a UK resident, that's lame.[/QUOTE] What do they need it for? Anti-piracy or something?