Nick, at this point, you need to hire someone to do your work for you. We are not here to do your job. I would suggest finding a coder for hire and letting them do this job correctly.
Thanks. On Sat, Jun 15, 2013 at 2:38 PM, Nick the Gr33k <supp...@superhost.gr>wrote: > Hello, > > Trying to browse > http://superhost.gr/?page=**files.py<http://superhost.gr/?page=files.py>with > tailing -F of the error_log i noticed that error log outputs no error! > > So that means that the script is correct. > > here are the directory app's files. > > ni...@superhost.gr [~/www/data/apps]# ls -l > total 412788 > drwxr-xr-x 2 nikos nikos 4096 Jun 12 12:03 ./ > drwxr-xr-x 6 nikos nikos 4096 May 26 21:13 ../ > -rwxr-xr-x 1 nikos nikos 13157283 Mar 17 12:57 100\ Mythoi\ tou\ > Aiswpou.pdf* > -rwxr-xr-x 1 nikos nikos 29524686 Mar 11 18:17 Anekdotologio.exe* > -rw-r--r-- 1 nikos nikos 42413964 Jun 2 20:29 Battleship.exe > -rw-r--r-- 1 nikos nikos 51819750 Jun 2 20:04 Luxor\ Evolved.exe > -rw-r--r-- 1 nikos nikos 60571648 Jun 2 14:59 Monopoly.exe > -rwxr-xr-x 1 nikos nikos 1788164 Mar 14 11:31 Online\ Movie\ Player.zip* > -rw-r--r-- 1 nikos nikos 5277287 Jun 1 18:35 O\ Nomos\ tou\ Merfy\ > v1-2-3.zip > -rwxr-xr-x 1 nikos nikos 16383001 Jun 22 2010 Orthodoxo\ Imerologio.exe* > -rw-r--r-- 1 nikos nikos 6084806 Jun 1 18:22 Pac-Man.exe > -rw-r--r-- 1 nikos nikos 45297713 Jun 10 12:38 Raptor\ Chess.exe > -rw-r--r-- 1 nikos nikos 25476584 Jun 2 19:50 Scrabble.exe > -rwxr-xr-x 1 nikos nikos 49141166 Mar 17 12:48 To\ 1o\ mou\ vivlio\ gia\ > to\ skaki.pdf* > -rwxr-xr-x 1 nikos nikos 3298310 Mar 17 12:45 Vivlos\ gia\ > Atheofovous.pdf* > -rw-r--r-- 1 nikos nikos 1764864 May 29 21:50 V-Radio\ v2.4.msi > -rw-r--r-- 1 nikos nikos 3511233 Jun 4 14:11 Ευχή\ του\ Ιησού.mp3 > -rwxr-xr-x 1 nikos nikos 66896732 Mar 17 13:13 Κοσμάς\ Αιτωλός\ -\ > Προφητείες.pdf* > -rw-r--r-- 1 nikos nikos 236032 Jun 4 14:10 Σκέψου\ έναν\ αριθμό.exe > > > The code is as follows: > > # ==============================**==============================** > ==============================**======================= > # Convert wrongly encoded filenames to utf-8 > # ==============================**==============================** > ==============================**======================= > path = b'/home/nikos/public_html/**data/apps/' > filenames = os.listdir( path ) > > utf8_filenames = [] > > for filename in filenames: > # Compute 'path/to/filename' > filename_bytes = path + filename > encoding = guess_encoding( filename_bytes ) > > if encoding == 'utf-8': > # File name is valid UTF-8, so we can skip to the next > file. > utf8_filenames.append( filename_bytes ) > continue > elif encoding is None: > # No idea what the encoding is. Hit it with a hammer until > it stops moving. > filename = filename_bytes.decode( 'utf-8', > 'xmlcharrefreplace' ) > else: > filename = filename_bytes.decode( encoding ) > > # Rename the file to something which ought to be UTF-8 clean. > newname_bytes = filename.encode('utf-8') > os.rename( filename_bytes, newname_bytes ) > utf8_filenames.append( newname_bytes ) > > # Once we get here, the file ought to be UTF-8 clean and the > Unicode name ought to exist: > assert os.path.exists( newname_bytes.decode('utf-8') ) > > > # Switch filenames from utf8 bytestrings => unicode strings > filenames = [] > > for utf8_filename in utf8_filenames: > filenames.append( utf8_filename.decode('utf-8') ) > > # Check the presence of a database file against the dir files and delete > record if it doesn't exist > cur.execute('''SELECT url FROM files''') > data = cur.fetchall() > > for url in data: > if url not in filenames: > # Delete spurious > cur.execute('''DELETE FROM files WHERE url = %s''', url ) > > > # ==============================**==============================** > ==============================**======================= > # Display ALL files, each with its own download button > # ==============================**==============================** > ==============================**======================= > print('''<body background='/data/images/star.**jpg'> > <center><img src='/data/images/download.**gif'><br><br> > <table border=5 cellpadding=5 bgcolor=green> > ''') > > try: > cur.execute( '''SELECT * FROM files ORDER BY lastvisit DESC''' ) > data = cur.fetchall() > > for row in data: > (filename, hits, host, lastvisit) = row > lastvisit = lastvisit.strftime('%A %e %b, %H:%M') > > print(''' > <form method="get" action="/cgi-bin/files.py"> > <tr> > <td> <center> <input type="submit" > name="filename" value="%s"> </td> > <td> <center> <font color=yellow size=5> > %s </td> > <td> <center> <font color=orange size=4> > %s </td> > <td> <center> <font color=silver size=4> > %s </td> > </tr> > </form> > ''' % (filename, hits, host, lastvisit) ) > print( '''</table><br><br>''' ) > except pymysql.ProgrammingError as e: > print( repr(e) ) > > ==============================**============= > PLEASE take a look, its not a huge code, the encoding was of Steven > idea's, so from another thread is a bit more or less already known to the > most of you. > > I just want to know why it doesn't print anything. > > Thank you and please whoever does not feel like helping, please at least > not spam the thread. > > -- > What is now proved was at first only imagined! > -- > http://mail.python.org/**mailman/listinfo/python-list<http://mail.python.org/mailman/listinfo/python-list> >
-- http://mail.python.org/mailman/listinfo/python-list
