Reply to thread

Message

<blockquote data-quote="Sway" data-source="post: 225727" data-attributes="member: 1889">I have gotten way too interested in web development using Python. Below is the link to the source code of a small web application I created. &nbsp;It is a button that allows you to run any application of your choice (aslong as it is hard coded inside). Before you can do that, you will have to login to get to the button. It reads from a database that uses MySQL.&nbsp;It was initially created for a Habbo retro to turn on an emulator through this application, so it reads from a table called &quot;users&quot; and stuffs like that.. but you can edit it with ease.&nbsp;Source:<a href="http://pastebin.com/MtqWxsU5" target="_blank">http://pastebin.com/MtqWxsU5</a>&nbsp;Please give me any suggestions or improvements I can make to this. If you have any questions on how to use this or set it up, feel free to ask me.&nbsp;Stuffs needed: ** <a href="http://bottlepy.org" target="_blank">Bottle </a>(0.11) framework.** <a href="http://sourceforge.net/projects/mysql-python/" target="_blank">MySQLdb</a> module for Python 2.4-2.7.** <a href="http://www.python.org/download/releases/2.7/" target="_blank">Python 2.7</a>&nbsp;Snippet:[CODE]@post('/menu')def menu():&nbsp; &nbsp; db = MySQLdb.connect(host='localhost', port=3306, user=&quot;root&quot;, passwd=&quot;XefraDef4s&quot;, db=&quot;a101&quot;)&nbsp; &nbsp; query = db.cursor()&nbsp;&nbsp; &nbsp; user = request.forms.get('username')&nbsp; &nbsp; passw = request.forms.get('password')&nbsp; &nbsp; passw2 = str(passw)&nbsp; &nbsp; password = hashlib.md5(passw2).hexdigest()&nbsp; &nbsp; rank = int(7)&nbsp;&nbsp; &nbsp; ugh = query.execute(&quot;SELECT * FROM users WHERE username = '%s' AND password = '%s' AND rank &gt;= '%s'&quot; % (user, password, rank))&nbsp;&nbsp; &nbsp; &nbsp; if ugh:&nbsp; &nbsp; &nbsp; &nbsp; db.commit()&nbsp; &nbsp; &nbsp; &nbsp; return panel1()&nbsp; &nbsp; else:&nbsp; &nbsp; &nbsp; &nbsp; return 'failure'[/CODE]&nbsp;Thanks.</blockquote>

[QUOTE="Sway, post: 225727, member: 1889"] I have gotten way too interested in web development using Python. Below is the link to the source code of a small web application I created. It is a button that allows you to run any application of your choice (aslong as it is hard coded inside). Before you can do that, you will have to login to get to the button. It reads from a database that uses MySQL. It was initially created for a Habbo retro to turn on an emulator through this application, so it reads from a table called "users" and stuffs like that.. but you can edit it with ease. [B]Source:[/B] [URL]http://pastebin.com/MtqWxsU5[/URL] Please give me any suggestions or improvements I can make to this. If you have any questions on how to use this or set it up, feel free to ask me. [B]Stuffs needed: [/B] [B]** [/B][URL='http://bottlepy.org']Bottle [/URL](0.11) framework. ** [URL='http://sourceforge.net/projects/mysql-python/']MySQLdb[/URL] module for Python 2.4-2.7. ** [URL='http://www.python.org/download/releases/2.7/']Python 2.7[/URL] [B]Snippet:[/B] [CODE]@post('/menu') def menu(): db = MySQLdb.connect(host='localhost', port=3306, user="root", passwd="XefraDef4s", db="a101") query = db.cursor() user = request.forms.get('username') passw = request.forms.get('password') passw2 = str(passw) password = hashlib.md5(passw2).hexdigest() rank = int(7) ugh = query.execute("SELECT * FROM users WHERE username = '%s' AND password = '%s' AND rank >= '%s'" % (user, password, rank)) if ugh: db.commit() return panel1() else: return 'failure'[/CODE] Thanks[B].[/B] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members