IRC Logs

Network: freenode Channel: #php

	Enter your search terms Submit search form
	Web www.irclog.org

[12:50]<wux>i'll find a workaround for what i want to do
[12:50]<wux>thanks
[12:50]<tml>wuh: If you use a better RDBMS someday, look at sequences.
[12:50]<nnt||r2usn>hmm, i'm searching for a good editor to use with ftp file browser capability and multiple file open, preferably tabbed
[12:50]<wux>yeah i've just read about this in postgresql
[12:51]<nnt||r2usn>i've tried jedit, not the best i've used, this is for a linux platform,
[12:51]<nnt||r2usn>on windows i've always used editplus2, and it's excelent, but is there somethign comparable on linux?
[12:51]<ugcg0wgqu>NET||abuse, kde or gnome
[12:51]<nnt||r2usn>unkn0wn2u, gnome
[12:52]<ugcg0wgqu>NET||abuse, gedit and mount the ftp share in nautilus
[12:52]<bfrmrsfyrr>Peace
[12:52]<nnt||r2usn>and i've tried using the gnome fs to mount the ftp share and edit it but its a read only situation
[12:52]<ugcg0wgqu>NET||abuse, does the ftp server use ssh
[12:52]<nnt||r2usn>no
[12:53]<nnt||r2usn>my purpose is to find a tool to use on regular ftp accounts on normal hosting situations(shared virtual hosting) with numerous different hosting companies
[12:53]<ugcg0wgqu>NET||abuse, you still should check out fuse
[12:53]<nnt||r2usn>fuse?
[12:54]<nnt||r2usn>hehe, just started fuser
[12:54]<ugcg0wgqu>its a userland file system , it lets you mount sftp and ftp i think
[12:55]<nnt||r2usn>hmm,
[12:56]<nnt||r2usn>hahah, gmailfs in apt
[12:56]<nnt||r2usn>kewl.
[12:56]<ar2>I need to retrieve a row from mysql using adodb, modify it and insert it as a new row. how should I format the array that adodb returns to insert it into the mysql database?
[12:57]<nnt||r2usn>jgb, depends entirely on you database structure,,, your question is a bit too vague
[12:57]<zrlsds>INSERT INTO (SELECT ....)
[12:57]<zrlsds>use subquery if possible
[12:57]<zrlsds>;)
[12:57]<nnt||r2usn>rapsys, that is however a better idea :)
[12:57]<nnt||r2usn>good call
[12:58]<zrlsds>I just payed with that now ;)
[12:58]<zrlsds>and that's a headheck
[12:58]<nnt||r2usn>sub queries? nah, i like em,, or do stored proceedures :)
[12:58]<nnt||r2usn>and triggers .. yummy
[12:58]<zrlsds>expeacialy if you want to use @a:=@a+1 as a column (without beeing able to use SET @a:=0; in a previous request
[12:59]<zrlsds>yes stored procedure is better, but not realy portable...
[12:59]<zrlsds>(too) many mysql server are 4.x based one without that support :'(
[12:59]<nnt||r2usn>yup this is true, and annoying
[12:59]<usnz160>hello
[13:00]<zrlsds>NET||abuse: http://web.rapsys.be/?type=rapsys&arid=21#ar21 <= may you look at it (if you see some possible hack, error or anything ?)
[13:00]<zrlsds>Hi User370, ask your question ;)
[13:00]<usnz160>I need some help with GD does anyone have any experiance with it?
[13:01]<zrlsds>I use Sigma template+mdb2 (and hope having not makes mistakes)
[13:01]<tml>NET||abuse, unkn0wn2u: You can mount an SSH filesystem using fuse, yeah.
[13:01]<tml>But it's kind of heavy
[13:01]<tml>It does a lot of calls for even something like an "ls"
[13:01]<zrlsds>User370: http://fr2.php.net/gd <= look at doc
[13:01]<ugcg0wgqu>wow where did you come from
[13:01]<ar2>NET||abuse : i'm working with mantisbt. 26 fields in the row. what other info do i need?
[13:01]<zrlsds>and ask what you want to do
[13:02]<tml>Don't call it a comeback cuz I been here for years
[13:02]<ugcg0wgqu>tml what about ftp
[13:02]<zrlsds>unkn0wn2u: if you have possibility to use, prefer setup a nfsv4 connexion
[13:03]<zrlsds>it's done to share files over internet
[13:03]<zrlsds>fuse may crash your kernel in some way (I already see it)
[13:03]<ugcg0wgqu>rapsys, thats great i have a nfs server thanks
[13:03]<tml>unkn0wn2u: I wouldn't know, I don't allow FTP on my systems.
[13:03]<ugcg0wgqu>rapsys, I've used fuse for a year now with no crash
[13:04]<ugcg0wgqu>TML, why is everyone telling me all of this
[13:04]<zrlsds>unkn0wn2u: be carefull about the versio, v3 has lot of problem (dns resolve, reconnection, etc) that are fixed in v4
[13:04]<ugcg0wgqu>TML, did you look at the conversation up there
[13:04]<ugcg0wgqu>rapsys, shutup
[13:04]<tml>unkn0wn2u: I'm telling you because you asked "what about ftp"
[13:04]<ugcg0wgqu>ftp and fuse
[13:04]<tml>unkn0wn2u: I don't allow anything using the FTP protocol on my networks.
[13:05]<ugcg0wgqu>tml thats awesome
[13:05]<ugcg0wgqu>tml can fuse do ftp ?
[13:05]<tml>unkn0wn2u: I wouldn't know, I don't allow FTP on my systems, so I've never looked.
[13:06]<dycno9>hi there
[13:06]<dycno9>if i want to upload file - how can i avoid that the user can upload execteable files?
[13:06]<ugcg0wgqu>tml that was my entire question not nfs not how heavy sshfs is
[13:06]<dycno9>is there a type for check this?
[13:07]<zrlsds>chmod the file after
[13:07]<dycno9>hmm. php files can be exectuted without +x
[13:07]<zrlsds>you can't trust the mimetype nor extension of received file, user may fake them
[13:07]<tml>unkn0wn2u: I saw someone talking about fuse and SSH, just thought I'd throw in a piece of advice
[13:08]<fz2znaxn>HY
[13:08]<zrlsds>use the executable file to get the filetype or use mimemagic system
[13:08]<dycno9>rapsys: and is there no sultion that only downlods the file and never execute it?
[13:08]<zrlsds>you can't do that
[13:08]<fz2znaxn>are Xpath query efficient?
[13:09]<dycno9>rapsys: i don't undretstand :) how does phpBB or vbulltin do it? they are claim to be secure
[13:09]<ugcg0wgqu>TML, thats good advice I'll think of you every time i do an ls
[13:09]<zrlsds>because simplay php code is executed AFTER the whole file has been downloaded from user on server in the temp path
[13:09]<zrlsds>you only have the possibility in the php code to makes some check and move it to final location or die (and automaticaly delete the uplaoded file)
[13:10]<zrlsds>mike84: you don't care about the status of the uploaded file
[13:10]<zrlsds>you just need to avoid some specific extension : .php or .pl for example that whould be handled by apache handler
[13:11]<zrlsds>NET||abuse: did you looker ?
[13:11]<dycno9>rapsys: i have read about following solution: how can't call the file via URI like http://www.my.com/myfile.zip - only http://www.my.com/download.php?file=myfile.zip works - but i dont't know how to do that
[13:11]<zrlsds>looked ?
[13:11]<mnzmzjjv>labreche: what do you mean by efficient?
[13:12]<zrlsds>mike84: simple, move all the file in /somedir
[13:12]<zrlsds>set a .htaccess with deny from all (or better in the apache server)
[13:12]<zjw>header("Content-type: text/css; charset=iso-8859-1"); <-- thats howto set charset right not with a : but a =?
[13:12]<fz2znaxn>deadroot: i mean more faster than DOMElement->getElement
[13:12]<mnzmzjjv>labreche: if you mean by easily selecting the node(s) you want in an XML tree, yes. it is efficient
[13:13]<zrlsds>the use your php script to echo the content of the file (with correct content lenght headers)
[13:13]<dycno9>rapsys: and how can i handle the doqnload with php?
[13:13]<mnzmzjjv>labreche: XPath is far more flexible than getElement*
[13:13]<fz2znaxn>deadroot: in terms of execution time?
[13:14]<mnzmzjjv>labreche: i haven't done any timings, but if you want do select a bunch of nodes with complex selection rules, you can do it with one line in XPath

Back to #php
Or go to some related logs:
#debian
#gentoo
#python
#gentoo
#gentoo