scidave's Forum Posts

  • Try this:

    sql = """INSERT INTO TEST(FIRST_NAME,
         LAST_NAME, AGE, SEX, INCOME)
         VALUES ('%s', '%s', 20, 'M', 2000)"""

try:

cursor.execute(sql,EditBox.Text,EditBox2.Text)
db.commit()
except:
db.rollback()

[/code:3c66z9fl]

If that doesn't work you can try changing the cursor execute line to this (notice the commas):
cursor.execute(sql,(EditBox.Text,),(EditBox2.Text,))

  • Try Construct 3

    Develop games in your browser. Powerful, performant & highly capable.

    Try Now Construct 3 users don't see these ads

  • Or someone is using his graphics with or without permission.

    I looks like they are using it without properly giving him credit (but maybe in the credits they list him). or perhaps it is him....doesn't look like it though. Danc, at least for those graphics, gave a liberal license for anybody to use his graphics for free, as long as they site where they came from.

    That's funny about the Construct user asking if dave made it.

  • I like the "one layout" rule..for the reasons you mention. For example, instead of allowing people to create all of these layouts for a big game appearance they can learn how to use layers more effectively or unlimited scrolling. It broadens people's horizons..

    I can see having a contest where we require .caps when it makes sense (for example a "best documented game" contest) or something along those lines. Although the prize might have to be a lot higher since documentation is rather boring.

    I'm looking forward to trying something out for this!

  • Did you create them, or did you just use them for demonstration purposes?

    I wish I was that good. I just used them for demo..they were made by:

    Danc

    http://www.lostgarden.com/2007/05/dancs ... -game.html

    Cool fact about him.. he started work at Epic Megagames!! Pretty awesome.

  • Yeah, I'm kinda against the whole require a .cap too (at least for the reason to see if only one layout is used). The contest is for one buck...I don't think we need to worry about cheating to win!

  • Either way works fine...I've done both. As long as your version of Python is 2.6..it isn't a problem to replace the current files with the ones you copy (but it is not necessary..just select "no" to overwriting existing files.

  • build and dist, at dist have library and dll.. i can now just make a folder named 'mysqldb' unzip them at python folder in construct?

    Yes, that sounds about right...you could just unzip all of the .pyc files in the dist directory in your Python folder. If you follow the quickguide step for that everything should work.

    You could also put them all in a separate directory like you mentioned.

  • Sorry, but personaly im againts these extra dealings.

    I rather pay a license right on begining Once.

    RakNet is actually a really good deal. It is a "gentlemen's" agreement. In the unlikely event that you make more than $50K on your game then you pay RakNet folks money. 99.9% of the people that use the plugin will be using it completely free and simply have to download the program and agree to the license out of procedure.

    when theres no official game made and such deal can turn off many potential game makers before they even begin to try using it.

    You don't worry about deals before you use...only in the rare chance you make $50k+ on your game. In that case, I think you would be pretty happy to pay a slice of your profits.

  • Even if python is installed...by default it wont necessarily recognized "python" on command line.

    The fact that you got an error saying "setuptools not found" suggests you should install setup tools.

    If you don't want to try that you're best bet is an executable build (pick the 2.6 build for 32-bit):

    http://www.codegood.com/archives/4

  • Im only getting insults when i try to give an opinion about something on these forums.Some even told me that im stupid and know nothing about Construct.

    DravenX.. I'm pretty sure 99% of the people here on the Construct forums welcome your input. You have to have a little bit of a thick skin when it comes to the internet because there is always going to be somebody that will piss you off (and you will piss somebody else off whether you intended to or not). You can expect that the more opinionated you get the more "interesting" conversation will result.

    You can either let it bother you or ignore it. Life is too short to worry about what a few people say that you will never meet....

  • Normally you can just do a "python setup.py install".

    If you type python at the command line and it is not recognized then you don't have Python installed correctly. Install this version of Python:

    http://www.python.org/download/releases/2.6.6/

    After you install Python and test with a "python" at the command line then try the "python setup.py install"

    If that doesn't work you could try setuptools:

    http://pypi.python.org/pypi/setuptools

    Let me know how it goes.

    p.s. Even if we get a networking plugin, it wont interface with SQL databases; so you would still need a Python solution for this or somebody would have to write an SQL access plugin.

    Edit... also try "setup.py install". ... you might not need the python in front...but you do need Python installed.

    Edit2: You may also want to try an executable build.

    http://www.codegood.com/archives/4

  • Keep it monthly though, weekly competitions will get too tiring and boring.

    Ditto. or every two months. People will drop off fast and there will be no contestants if it is held all the time. Plus that is a lot of work!

  • Yes, I looked through the example the module real quick and I don't see why it shouldn't work. The module supports Python 2.6 so that is good.

  • Maybe they are using HTML5 offline mode??

    http://diveintohtml5.org/storage.html

  • > But can I use podsixnet + this pymsmql at the same time?

    Yes, you can definitely combine them at the same time.

    although I heard podsixnet can be pretty laggy sometimes.

    Lag isn't an issue when accessing SQL databases (at least in choice of library to use). Podsixnet will perform just as good as Raknet or any other fast UDP library when it comes to things like this.

    On a separate note, to reduce the appearance of lag w/ Podsixnet you can use client-side interpolation and also use ping times to adjust your positions. Client-side interpolation is really easy to implement in construct using lerp() and timedelta.