gg_convert = gg4: winners [TODO]

[Lob]

Hi Guys,

Just a quick question regarding gg_convert.

I notice that gg3 winners can be converted but gg4 winners is not completed as of yet.

How long do you anticipate it will be until this part of the convert is completed.

I only ask as i have been looking forward to Gungame 5 but it would cause mayhem if my devoted players all lost their ranks.

I suspect this would be the case with a lot of other Servers too.

Thanks

- Lob

[XE_ManUp]

I would imagine since GunGame4 uses SQLite to store the winners that this shouldn't be too hard to do. Saul is the one that has coded gg_convert, so I will have to see what he says.

[Saul]

I have no experience(AT ALL) in SQL. If someone could do the code to do a loop through the SQL data in the file, I will happily code the rest.

[XE_ManUp]

I have no experience(AT ALL) in SQL. If someone could do the code to do a loop through the SQL data in the file, I will happily code the rest.

I need a GG4 winners database. Could someone provide me one so I could test it out?

*cough* *hint* *cough*

[Don]

Here you go:

[Lob]

Thanks very much Guys.

Your efforts are greatly appreciated.

- Lob

[Fragenstein]

I was just gonna submit a post regarding updating the GG4 winner database to GG5. Any update on this?

[XE_ManUp]

I was just gonna submit a post regarding updating the GG4 winner database to GG5. Any update on this?

I have been gone for the past 6 days due to work. I haven't had a chance to mess with it yet. As soon as I get a chance, I will get this done.

[PitBull]

I'm currently writing on a GG4 converter. I think it's finished, I will try it tomorrow. If it's working, I will upload the code. Sc0pE already offered me to include the code into the gg_converter for GG3. Would be great

[Saul]

Awesome! You mind posting the code here first so we can have a look?

[Fragenstein]

I'm currently writing on a GG4 converter. I think it's finished, I will try it tomorrow. If it's working, I will upload the code. Sc0pE already offered me to include the code into the gg_converter for GG3. Would be great

Sweet!

[PitBull]

Awesome! You mind posting the code here first so we can have a look?

The important part of code is this one:

Expand/Contract | Select All

def convert():
    es.sql('open', 'gg_database', '|gungame4/db')
    es.sql('query', 'gg_database', 'gg4c_db', 'SELECT * FROM gg_players')
    es.sql('close', 'gg_database')
   
    for steamid in gg4c_db['steamid']:
        dict_winners[steamid]['name'] = gg4c_db['name']
        dict_winners[steamid]['wins'] = gg4c_db['wins']

I don't know if I have a error in reasoning, but I think it should work. I'm currently setting up a test server. Could take about 1-2 hours.

Best Regards, PitBull

//EDIT: I tried it as above, but it doesn't work. I'm currently trying some other methods. I will answer again when I made it
//EDIT2: I opened a new topic for that. Go here!

[Warren]

We have added a GunGame4 converter based off of that code you started PitBull. Thanks for the help!

http://code.google.com/p/gungame-python ... tail?r=553

[PitBull]

I'm glad that it is now working. I'm also very impressed how you realised it. Nice

~PitBull

[Saul]

Nice one Sc0pE. The only thing I disagree with is the: try: except: clause. I'm sure we can come up with a better alternative that just catching all errors.

[Lob]

Good Work Guys

Thanks

- Lob

[Warren]

Nice one Sc0pE. The only thing I disagree with is the: try: except: clause. I'm sure we can come up with a better alternative that just catching all errors.

I agree. Some players in the GG4 Database aren't real players, for example they didn't even have a steamid set up, so it just spammed errors for those other parts of the DB that weren't players.

[Warren]

It turns out that the:

Expand/Contract | Select All

if not wins:
    continue

section gets rid of these not-real-people and doesn't spam any errors.

I am committing r555.