Game Development

Bálint

7:02 PM

Add a \ before the double quotes @yahoo5000

yahoo5000

you mean open new "" and add \ ?

\"SELECT LAST_INSERT_ID()");

PearsonArtPhoto

The 2017 Game Developers Choice Awards

►

No Man's Sky wins an award, no one there to pick it up...

John Hamilton

Yep, saw that :D

Bálint

Wait, you're passing 4-5 different strings to the function

Stephane Hockenhull

No man's there to pick up?

badum

John Hamilton

7:05 PM

Ho-hum

yahoo5000

oh yea i want to separete two querys INSERT and SELECT

Bálint

@Pearson They later told that they were eating in a closeby restauramt speaking about how they won't get a proue

yahoo5000

to catch last insert ID

Stephane Hockenhull

They sure innovated on over-promising stuff...

Bálint

Is the syntax error in the MySQL query or in the code?

yahoo5000

7:06 PM

in query

Bálint

So the code can compile without any problems

PearsonArtPhoto

Yeah, I heard about it, but it's nice to see the actual video.

yahoo5000

yea

i also tried SELECT MAX(id) FROM characters

i tried to add ; after first query but still got error tried varies ways

Bálint

Can you please copy the text of the query out in a raw form and post it without the code formatting? My screen is too small to see it in a whole

yahoo5000

so i guess problem is with separating one query from another

Bálint

7:09 PM

@yahoo read my message above yours

yahoo5000

like this ?

"INSERT INTO characters (userid,firsttimelogin,Name,Surname,Gender,Reputation,Money,Strength,Inteligence‌,Luck) VALUES (?,?,?,?,?,?,?,?,?,?) SELECT LAST_INSERT_ID()"

John Hamilton

@StephaneHockenhull the only thing they innovated on is the meaning of the word innovation

Bálint

Yeah, thankd

1.) You have to put a ; between commands, and 2.) That select statement is malformed

Stephane Hockenhull

yahoo5000

yea i tried that

Stephane Hockenhull

7:10 PM

@JohnHamilton

yahoo5000

still styntax error

John Hamilton

lolol

Bálint

What do you want the select to do?

Stephane Hockenhull

Seriously tho, the stuff they pulled hurts the entire industry.

yahoo5000

i want to Insert new row and get this row auto_increament id

Bálint

7:12 PM

@John @Stephane I know, we hate them, but you can't say their world generator wasn't an innovation

Stephane Hockenhull

It's not an innovation

John Hamilton

randomization != innovation

Stephane Hockenhull

People pulled that shit off on a C64

John Hamilton

minecraft has a better world generator

Bálint

Generating creatures and plants and terrain in a game? Yes it is

They generated believable creatures

Stephane Hockenhull

7:13 PM

No it's not innovative. It's been done before.

PearsonArtPhoto

Where?

John Hamilton

Well, I didn't buy in

Spore hurt me before

Not gonna believe anything that's close to it

PearsonArtPhoto

Okay, Spore, that's right.

John Hamilton

Yeap, Spore had a creature editor and that was fun

also the 2D part was pretty nice

Bálint

@Yahoo SELECT * FROM files WHERE id = SCOPE_IDENTITY();

Stephane Hockenhull

7:15 PM

c64-wiki.com/wiki/Elite

"As Commander Jameson the player can travel through eight galaxies"

John Hamilton

I'd honestly play a Spore game that is all the first stage and nothing else

PearsonArtPhoto

I liked Spore, but so far as I can tell, it has the same problem as NMS.

Stephane Hockenhull

EIGHT FRIGGIN GALAXIES on a 8bit 64KB RAM C64

PearsonArtPhoto

There actually is a version like that.

Bálint

Elite didn't have randomly generated creatures, neither did spore, those were hand-crafted

PearsonArtPhoto

7:16 PM

I think it was solve on Mobile or something.

yahoo5000

SELECT SCOPE_IDENTITY() FROM files;

this looks better

PearsonArtPhoto

$5 or so, even at the release of the game.

John Hamilton

yeah but wasn't good enough cuz it was too limited

yahoo5000

because i dont need everything just an id

Bálint

@yahoo that doesn't work

yahoo5000

7:16 PM

okay will try your way

DH.

The create your own stuff part was really good

All the rest was shit on Spore

Stephane Hockenhull

Putting a Pen and a Pineapple together is not innovation.

Bálint

If you want only the id, then I think that's SELECT (id) FROM characters WHERE id = SCOPE_IDENTITY()

PearsonArtPhoto

And let's be honest, NMS attempted to do something quite a bit more than Spore.

Bálint

> Innovation can be defined simply as a "new idea, device or method". However, innovation is often also viewed as the application of better solutions that meet new requirements, unarticulated needs, or existing market needs.

Stephane Hockenhull

7:19 PM

They just stitched together random animal parts using a template.

Bálint

The innovation part is how they used randomness

yahoo5000

@Bálint thats still give me syntax error

PearsonArtPhoto

Wasn't that how Spore worked?

Bálint

Did you put a ; between the commands?

Stephane Hockenhull

using random generators is not a new thing

PearsonArtPhoto

7:20 PM

I think NMS took templates and had controlled randomness in each template.

yahoo5000

yea i did

"(?,?,?,?,?,?,?,?,?,?); SELECT id FROM characters WHERE id=SCOPE_IDENTITY()"

Bálint

Are you sure none of the fields requires to be defined?

@StephaneHockenhull Again, it's not what they used, it's how they used it

yahoo5000

what do you mean ?

Bálint

What do ?s mean here?

yahoo5000

none of the fields requires to be defined?

Stephane Hockenhull

7:23 PM

If I put wagon wheels on a modern car that's not innovation.

Bálint

In MySQL tables you can make some cells don't allow NULL values, are there any of those in your tables?

@Stephane If you prove that it makes the car use less fuel, then it is.

yahoo5000

Bálint

None of the fields allow NULL. Do you set the values before you send the query?

Stephane Hockenhull

yahoo5000

id is auto_increament

yes

Stephane Hockenhull

7:26 PM

^^^ Better innovation than NMS

stick a pen into an apple

yahoo5000

@Bálint everything is set and syntax error comes only when i tried to Select

in the same query

Bálint

No man's sky showed the world, that using completely randomly generated world including animals and plants is possible. It pushed the game industry.

Stephane Hockenhull

What No man's sky did ^^^

it's not innovation.

Bálint

Isn't there a more detailed description of the error?

Stephane Hockenhull

Just because you do it on a computer

yahoo5000

7:29 PM

2017/3/22 19:20 Mysql Error code :1064
2017/3/22 19:20 Mysql State:42000
2017/3/22 19:20 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM characters WHERE id=SCOPE_IDENTITY()' at line 1

Stephane Hockenhull

The only thing it pushed was how to better commit fraud and get away with it.

It innovated in snake oil sales.

Bálint

@yahoo Wait, isn't there a mysql_insert_id() function?

yahoo5000

nop

Bálint

Then use SELECT LAST_INSERT_ID()

yahoo5000

syntax error i was doing this right from the beginning

Bálint

7:38 PM

Even if you remove the insert?

user92578

4

A: MySql and inserting last ID problem remains

Clarification, the mySQL .net ODBC driver doesn't allow multiple commands to be run like you are describing. You have to make two separate calls and wrap them in a transaction. // open a new connection using a default connection string I have defined elsewhere using( OdbcConnection connection = ...

Bálint

That explains

yahoo5000

@Bálint i believe if i split querys it will work

Bálint

I never used .NET MySQL before

Yes

That's what Tyyppi is referring to

@Tyyppi_77 BTW, how do you pronounce your username? Tippi or Type-i?

yahoo5000

@Bálint do i need execute after each one ? cuz if so that woudl make some problems

user92578

7:41 PM

It's more Type-i, if you want the real pronounciation go to Google Translate, type in Tyyppi, select Finnish and hit the audio button

Bálint

Oh, Tyyppi is a finnish word?

user92578

Means Guy, dude

Bálint

@yahoo5000 Look in the question tyyppi posted, I don't use C# MySQL

yahoo5000

this might work actually : SET @OpParam = SELECT LAST_INSERT_ID();

Bálint

@Tyyppi Tüpi?

user92578

7:45 PM

Mm that sounds about right

Bálint

That's basically the german Typ + i

user92578

Typpi means penis in icelandic which every god damn icelandian (or whatever they're called) wants to let me know of

Bálint

Imma call you dude from now on

user92578

Typpi means nitrogen in Finnish

yahoo5000

@Bálint so nothing is works actually , it would work if i would separate queries but because of threads i cant do that . i might need to go to StackOverflow for help

user92578

7:48 PM

Or do some googling, I just gave you the first link

Bálint

@yahoo Put them in a transaction. Again, did you read that answer?

yahoo5000

yea i did

Bálint

@dude_77

Or @penis_77

Choose one

user92578

It's technically peenis

Bálint

Then peenis

@peenis_77

user92578

7:49 PM

I'll go with dude though

yahoo5000

its Pyynis

user92578

No.

Bálint

K @Dude_77

jgallant

wait

user92578

Anyways let's just use usernames before anyone gets flagged?

user92578

7:50 PM

Hahahah

user92578

Almo is gonna kill you if he sees these

jgallant

lol

Bálint

Why?

jgallant

Almo doesn't know how to fight

I'll judo chop the shit out of him

user92578

Throw some of your multiple greenlit games at him

jgallant

7:52 PM

why does that say juno?

ok that was way too many

user92578

lol

jgallant

i wonder who is gonna release first.. me or @Tyyppi_77

race ya bitch!

Bálint

@Tyyppi we share the same language family, that's...nice

jgallant

what language?

Bálint

Hungarian and Finnish

Which may seem odd considering thex have half of Europe between each other

But we have like 30 words with similar spellings and that's enough for most linguists

jgallant

8:01 PM

Picross Touch#1 подарите Ване мозги

►

this guy is having a hard time with the game haha

Chris McFarland

@jgallant you're internet famous!!

jgallant

i like to look up the picross touch let's play hehe

i'm sure you do the same.

Chris McFarland

nah I'm too lazy
I just let Google Alerts find them for me

jgallant

LOL his face when he sees a 10x10

he still doesn't understand how to complete the 5x5

funny

Chris McFarland

there was a video of my game

guy couldn't figure out how to open the home door

jgallant

8:07 PM

isn't it frustrating to watch??

lol

Chris McFarland

I shook my head lol

jgallant

Chris McFarland

It was a case of user not reading the text on the screen to press the button to perform the action

hahahaha

jgallant

he quit and picked another 5x5 haha

he wasn't able to read the english -- so yeah I think having translations help with that a lot more

Chris McFarland

For sure

jgallant

8:09 PM

question for you

i get a shitload of soviet russia submissions

is this considered ... taboo or anything?

this symbol

i have gotten like 40 of them

basically I started banning some non-family friendly puzzles

Chris McFarland

:(

jgallant

is this family friendly?

Chris McFarland

I am not the guy to ask, not very knowledgeable of that

Bálint

I am

jgallant

the rate that they are submitted makes me think they are not

it reprensents communism

Chris McFarland

8:12 PM

right

jgallant

but I mean.. does anyone care?

Bálint

That's not a taboo symbol, but western cultures think it is

Uri Popov

it depends man in the nations that suffered trough communism it might be considered in bad taste at best.

Bálint

It's not a swastika

jgallant

i deleted a lot of those.

i get it

its hilarious

Uri Popov

8:13 PM

and more people were killed under it than the swastika ;)

jgallant

i seriously deleted estimate 60-70 swastikas

Bálint

@Uri My country suffered through communism, believe me when I say

No one cares about it

Chris McFarland

@jgallant can you ban the user?

jgallant

some people submitted multiple

DH.

I can't see it, but we are talking about the sickle and the hammer?

jgallant

8:14 PM

from what I read, banning 1 submittion bans the user

but I don't think it does

You can ban a user though

Bálint

If you ban the user with a submission like this, then ban people who draw flags too. It's almost the same

jgallant

oh, and the other one was penises

50+ penises

Chris McFarland

of course

Bálint

It's a system, it has it's pros and cons

Uri Popov

ha penises

jgallant

8:14 PM

no vaginas

1 pair of tits

Uri Popov

vaginas are hard to draw

jgallant

20x20 vagina draw contest.

DH.

lol

Chris McFarland

@jgallant you need to develop tech like Nintendo did. "Miiverse Penis Drawing Detection Took Weeks to Develop" ign.com/boards/threads/…

jgallant

hehe, i just look at the new puzzles

takes me a few seconds

i have a system :)

Chris McFarland

8:16 PM

well that's boring

jgallant

its easier.

plus i keep the penis puzzles in my personal collection

Bálint

@jgallant Seriously don't worry about the sickle and hammer. It's not taboo

jgallant

thanks man

now that I am greenlit, I can work on that editor

Chris McFarland

hehe cool

jgallant

nothing like building a community for your game :)

that editor code is pretty tight actually :D

pan, zoom, scrollbars, actionbars, toolbar

that camera system is solid

Chris McFarland

9:04 PM

from Unity newsletter: "Facebook launched Gameroom, a new PC gaming desktop app dedicated solely to helping gamers easily discover, share, and play the games they love. With Unity 5.6, you can now export your game into Gameroom directly from the Unity Editor. Learn more about how to leverage Facebook’s 1.8b users. developers.facebook.com/docs/games/gameroom "

jgallant

yeah fuck that shit

Chris McFarland

haha

Bálint

That's going to fail

I eat my hat if it doesn't.

Chris McFarland

fails to download Gameroom setup exe. top quality

jgallant

man.. who publishes games to facebook?

scummy pricks