| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
Comments:
<0> Stormchaser: I'm more of a hyper-realism guy. Misfile, Alpha-Shade
<0> NSGN: SQLite
<1> NSGN: Consider SQLite
<0> richardlynch: STFU
<2> hm...i have to say i'm not familiar
<3> lol
<4> TML: what about vgcats? :)
<0> Riding my bandwagon. Who do you think you are, anyway?
<5> TML: Search The Funky Universe?
<0> Jymmm: Stop The F***ing Usurpation
<2> somebody mind giving me a nutshell idea of what it is?
<0> That's right, everyone get out your dictionary.
<4> NSGN: nope.
<3> Usurpation, what a funky a word
<0> NSGN: php.net/sqlite
<6> wow, what an ego
<5> TML: **** the dictionary, I'm looking for the online spoken .wav file!
<3> LOL
<0> arpad: I'm fairly certain richardlynch knows I'm joking.
<6> because sarcasm is renowned for travelling well over irc?
<7> Jymmm: will .ape work too?
<1> NSGN: http://php.net/sqlite
<5> Ah, here we go... http://m-w.com/dictionary/Usurpation
<0> arpad: Because richardlynch has been here a lot before.
<7> STUPID richardlynch
<1> Reading email and doing IRC at same time is Stupid, isn't it?
<7> you are ultra-stupid :|
<5> Fushuing the only thing I have that uses the ext .ape onlt deals with CAD/CAM tyvm
<7> your stupidness even amazes stupidity itself that it comitted suicide by slicing its throat off while jumping off a skyscraper
<0> arpad: It's not as if sarcasm is a personality trait I developed in the last 15 minutes.
<8> thanks for all your help, goodbye
<5> TML 17.3424 minutes ago
<2> oh this is nice.... "Call to undefined function: sqlite_open()"
<1> NSGN: You'll have to compile it in (Un*x) or uncommont the sqlite line (Windows) -- and you have to be using recent version...
<9> TML: sorry for the delay, but yes the query works perfectly
<9> TML: oops
<9> wrong person
<1> NSGN: If the file is relatively small, array_walk might be faster/easier
<2> richardlynch: the current server i'm tergeting is a virtual server, and i cant control what is compiled for it
<2> :-/
<1> NSGN: Yeah, just go with array_walk then, and be done with it.
<2> durn
<2> ok
<9> TML: oh my bad right person, yeah the query works fine
<2> hm, i wouldnt be able to throw a wildcard in array_search...would i?
<0> lilkid: I didn't ask if the query worked
<0> lilkid: I asked if you've confirmed that it's actually arriving in that block of code
<0> lilkid: There are several branches right there
<0> lilkid: Before we debug the branch that runs the query, let's make ABSOLUTELY SURE that we're even getting INTO that branch
<1> NSGN: array_walk is gonna call a function with each element -- you can put the wildcard into the body of the function. I think you also get a bonus argument to p*** in whatever you want.
<10> TML and arpad: Thanks again for your solutions.
<2> ah screwit, i just realized i can forget line returns and use implode/explode
<5> serialize()
<9> TML: i made a new var $this->error = $row['userid']; when echo'ing it echo's the right value from the database.
<1> NSGN: Careful -- You want to watch out for "am" and "spam" as words... You'll want to be checking for word boundary with preg_match, and implode+preg might be more expensive than array_walk... Doubt it, but worth checking.
<9> TML: let me just check as you said if its getting into that black
<9> s/black/block
<2> richardlynch: maybe i'm dense...but whats wrong with those words?
<1> NSGN: Nothing, except it would be super easy to be looking for "am" and find "spam" after you implode the file contents.
<2> oh i see
<2> got ya
<1> NSGN: Been there, done that. :-)
<9> TML: ok thanks for your help, accidently placed the else statement on the wrong if statement >.<
<11> ok..im having trouble connecting to my sql database.. In cpanel my username is peerless so when I created the database it has the peerless_dbname as its name. And then I created a user, peerless_username is how it came out. So when i connect to the database..do i use (localhost,peerless_username,p***) or do I use (localhost,peerless,p***)
<12> peerless_username
<12> and select the database as peerless_dbname too
<11> yea..thats what im doing
<11> still not working
<11> damn
<11> for p***..i use the username p*** i made..not my cpanel p***..right?
<12> the p***word you made when creating peerless_username
<11> yea.
<11> everything seems right to me
<11> the only thing i think that could be wrong is localhost
<11> this is set up on a VPS server
<11> and my peerless cpanel account is on a different ip then the main shared ip
<11> is that why maybe?
<13> JJPeerless: sounds like you should be reading cPanel documentation
<4> !+g10
<14> Guideline #10) We don't support script(s). We help you *write* PHP, not recommend or download and install/hack/modify/adapt/use pre-written scripts
<15> anyone know if its possible to query mysql after executing a query to find out what the newly added primary key is?
<1> http://php.net/mysql_insert_id
<5> JJPeerless: You have been asked MANY times not to use the enter key as puncuation, please stop.
<1> JJPeerless: You may also want to examine the output of SELECT * from mysql.user -- and visit http://dev.mysql.com
<16> btw, is it normal that each time you do a query you have to reopen the connection to the database? or is it normal to make connection open for a longer period? oO
<1> Rockj: One connection per script, or you'll kill performance badly.
<12> blah, i've just knocked a whole kb and a lot of lines from my script using mysql_num_rows and mysql_fetch_row
<16> richardlynch: hum, I'm wondering what im coding wrong then. Need to take a closer look on the mysql_* functions and how they work.
<12> richardlynch: does that mean it would be easier to store the database connection in an include file, and just include that file to open a connection?
<12> nevermind, stupid question
<1> Rockj: Pastebin your script, maybe we can spot it in seconds...
<16> richardlynch: I have a database cl*** and a user cl***. Ill pastebin it .. 2 sec.
<1> bullrage: Yes, and put the include file OUTSIDE the webtree to help protect MySQL p***word.
<12> richardlynch: Any other suggestable places to store it?
<4> bullrage: Any other database.
<4> urf... nm
<1> bullrage: In root-read-only httpd.conf, but then never ever dump out $_ENV or use phpinfo() ...
<4> lol
<12> Those 2 are the only ways of protecting the contents of the file?
<16> richardlynch: will you be around for a while? I have to go pickup a friend that is comming to city
<17> help: im trying to replace an instance of $word that's not within "<abbr(nothere)>", but this: "/[^(<abbr(.*))]({$word})[^(.*)>(.*)]/", doesn't seem to work
<17> anyone have any ideas?
<1> bullrage: Not only, just best, imho.
<1> Rockj: Somebody will be around.
<4> bullrage: ...or encrypt it
<16> richardlynch: she just arrived so have to stick and pick her up but here the two cl***es, but you might need to view whole page to understand how I use it? User cl***: http://rockj.pastebin.com/735930 Database: http://rockj.pastebin.com/735929
<12> I presume the config.php files that store the database usernamd and p***word in them for different forums and blogs are encrypted?
<16> Ignore some stuff in the database, like the use of the global in the constructor.. I've changed it abit and havent cleaned up..
<13> bullrage: why would they be encrypted?
<1> bullrage,Stormchaser: Things is... If they can get to source, they can figure out how to unencrypt, as it's right there in the source.
<12> itrebal: Well they don't get uploaded outside of the webtree, and I was wondering how they did it..
<13> ah
<18> when i try to call the same function i'm inside, the return value gets screwed after it recurses on the function? and fix for return ?
<18> s/and/any
<4> richardlynch: ha?
<18> only thing i can think to do is use break; and set the return value as a global idk
<1> syle: Hunh? Maybe you want to return an array of all the answers from the recursion??? return array_push(samefunc($args), $results);
<16> richardlynch: just do changes in pastebin and messages here on irc with my nick as prefix. (as they get autologged) be back in a while =) or notes for what I should change and so on.. Thank you very much. Appriciated.
<12> richardlynch: what other methods would you suggest then?
<1> Rockj: will do
<18> richardlynch not really, what function is doing is generating an id, checking it against database, if it exists, recurse till it gets a unique one
<1> bullrage: Switch to a new host that lets you have a directory outside the webtree to put include files where they belong? All I got.
<18> so all it is a basic if else statement with return's in them
<18> samefunction($loopnumber); basically
<1> syle: Just do an insert and then use http://php.net/mysql_insert_id -- You WILL screw up if you try to anticipate the next ID.
<19> what is wrong with the contact form code? http://pastebin.com/735940
<12> richardlynch: haha. I've already got files outside the webroot. :)
<18> beleive me its from 1mill to 9mill which is pretty safe i think
<1> bullrage: So put the mysql_connect include outside too.
<18> besides the point though
<1> syle: Not safe enough.
<18> whats unsafe is using autoincrement as a username
<18> so not an option
<1> syle: Nobody said your unqiue key and the return of mysql_insert_id HAS to be an auto_increment...
<4> autoincrement.. as... username...
<18> mysql_insert_id will not pick a number between 1 mill and 10 mill for me, so i just want to figure out why return isnot working
<1> Rockj: http://rockj.pastebin.com/735946
<18> autoincrement is fine, if your using that as an id to base deletes etc on, but i need unique ids between those ranges that are random
<20> what's your code look like, syle?
<20> I do that occasionally when wanting random order IDs that aren't sequential
<20> why are you recursing? i'd just loop
<21> syle instead of doing that why don't you use uniqid()
<21> and set the database field to unique key?
<21> uniqid(microtime(),1)
<0> Putting a unique key on the field and catching failed inserts is a far better way than trying to "select/if exists, select again".
<17> can someone help me with regex? im trying to match $word as long as it's not between "<abbr" and "</abbr>" but im having trouble, this is what ive got so far: /[^(<abbr)]{$word}[^(<\/abbr>)]/
<18> hows that different that generating one with rand and checking it exists already or not
<0> syle: The latter has (what should be) an obvious race condition
Return to
#php
or
Go to some related
logs:
#suse
repost _FILES
#egghelp
#lisp
winetool package ubuntu
#javascript
#fedora
xine wmv the source seems encrypted
Gentoo M6811
debian pentium-m libc6-686
|
|