Raised This Month: $32 Target: $400
 8% 

[CS:S/CS:GO] GunGame


Post New Thread Reply   
 
Thread Tools Display Modes
PStar
Veteran Member
Join Date: Mar 2008
Old 06-06-2009 , 04:07   Re: GunGame:SM
Reply With Quote #11

For the opening post.
Put the change log into a scrolable box, it will make it more clear.
PStar is offline
Xp3r7
SourceMod Donor
Join Date: Jul 2006
Old 06-06-2009 , 11:30   Re: GunGame:SM
Reply With Quote #12

Quote:
Originally Posted by Xp3r7 View Post
Thank you!

May want to add that by the command in your post so others will see it easier and you wont be asked 1,000,000 times! lol




EDIT: Got this error.



It doesnt exist because GG5 saves their database as winnersdata.db.

GG4 saves theirs as es_gg_database.sqldb btw.

So that has to be from GG3 or earlier!
Quote:
Originally Posted by altex View Post
Updated first post. Thank you.
Thanks man!

Can we get support for importing GG4 and GG5 databases considering they are the 2 most recent versions and GG3 is like 2+ years old and there probably isnt a lot of GG3 servers out there?

I dont want to come off as nagging to you.

I just am suggesting some things that would definitely help this plugin out.

http://www.game-monitor.com/search.p...&type=variable
795 GG5 servers

http://www.sourcemod.net/newstats.php
2064 ES GG servers total and I bet 90% or more are GG4 and GG5 servers.
__________________
Xp3r7 is offline
Send a message via MSN to Xp3r7
altex
Veteran Member
Join Date: May 2009
Location: Russia
Old 06-06-2009 , 13:54   Re: GunGame:SM
Reply With Quote #13

You can export from gg5 sqlite database into text file, and then manualy (or via text editor replacing tool) convert in into old gg3 format. There is a firefox plugin to access sqlite databases.
altex is offline
Xp3r7
SourceMod Donor
Join Date: Jul 2006
Old 06-06-2009 , 20:24   Re: GunGame:SM
Reply With Quote #14

I tried that extension and a separate program but GG5 saves as a .db and I couldnt find anything to convert it.
__________________
Xp3r7 is offline
Send a message via MSN to Xp3r7
Stitllams
Junior Member
Join Date: May 2009
Location: New Zealand
Old 06-06-2009 , 21:54   Re: GunGame:SM
Reply With Quote #15

I haven't checked but if its the in same format as the .db in excel you can open it up in excel and save it as comma delimited from there.

Hope that helps.

Edit: Maybe this link may help, or not, I don't have a winnersdata.db to play around with.
http://gungame5.com/forums/viewtopic...sdata.db#p3284

Last edited by Stitllams; 06-06-2009 at 22:14. Reason: Extra info to help.
Stitllams is offline
Xp3r7
SourceMod Donor
Join Date: Jul 2006
Old 06-06-2009 , 23:11   Re: GunGame:SM
Reply With Quote #16

Yeah that was me askin on the GG5 forums how to open it up since the firefox addon or the program didnt work.

I didnt know I could just open it up in notepad/wordpad.

I tired saving it as es_gg_winners_db.txt and ran the import but it said I had nothing to import so GG3 must save different in the actual txt file.

I can PM u my winnersdata.db if ya like.

I also have an es_gg_database.sqldb from GG4 if you would like it to try to make a converter/workaround for it.

I just feel that since there are so many GG4/GG5 servers out there, this is a must as people wont want to switch to SMs GG if they cant convert their database.

Who wants to switch if they are going to lose their thousands apon thousands of player ranks, kills, etc.?
__________________

Last edited by Xp3r7; 06-06-2009 at 23:18.
Xp3r7 is offline
Send a message via MSN to Xp3r7
Stitllams
Junior Member
Join Date: May 2009
Location: New Zealand
Old 06-06-2009 , 23:24   Re: GunGame:SM
Reply With Quote #17

Quote:
I just feel that since there are so many GG4/GG5 servers out there, this is a must as people wont want to switch to SMs GG if they cant convert their database.
I totally agree, send away and if I can help I will.
Stitllams is offline
Xp3r7
SourceMod Donor
Join Date: Jul 2006
Old 06-07-2009 , 01:34   Re: GunGame:SM
Reply With Quote #18

Quote:
Originally Posted by Stitllams View Post
I totally agree, send away and if I can help I will.
Sent via PM.

I sent a GG5 database and a GG4 database.
__________________
Xp3r7 is offline
Send a message via MSN to Xp3r7
Stitllams
Junior Member
Join Date: May 2009
Location: New Zealand
Old 06-07-2009 , 09:30   Re: GunGame:SM
Reply With Quote #19

Thanks for that.

Haven't accomplished much but here is what I have noted so far.

GG4 database is definitely sqlite format so it is feasible that it could be imported using the sqlite support when that is implemented.

GG5 forums were right about the GG5 database format, they use python with cpickle to read and write to the database. Not really sure what to do with that, if it can't be done sourcemod side using c++ (cpickle is written in c), then a python script may be able to convert it to GGSM format.

Thats my thoughts so far anyway.

Last edited by Stitllams; 06-07-2009 at 09:52. Reason: found out cpickle written in c
Stitllams is offline
altex
Veteran Member
Join Date: May 2009
Location: Russia
Old 06-07-2009 , 11:53   Re: GunGame:SM
Reply With Quote #20

1) download and install http://www.python.org/ftp/python/2.6.2/python-2.6.2.msi
2) copy your gg5 winners db file into some folder
3) copy attached file to the same folder
4) unzip script
5) run script and you got gg3 winners file
Attached Files
File Type: zip convert_winners_gg5to3.zip (403 Bytes, 525 views)
altex is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 05:09.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode