Help me

hieuhpp · 01-12-2008, 04:23 AM

i want convert sql of gamesitescript to another sql but i export GSS SQL to xls have error:

the field gameurl in table game is blank.i can't get game file

to av arcade .PlZ help me
take field gameurl.Sorry my english is bad

ArcadeSiteBuilder · 01-12-2008, 05:39 AM

The games table in GSS does not hold the complete game url. In fact it doesn't even dontaint the complete game file name.

GSS Games Table holds just the name itself, without the extension for the file.

It can get complicated but if you have standardized extensions you can export the GSS games table to excel and use excel concatenate function to re-intoduce the missing extensions to reconsrtuction the complete file names.

If you have a mixture of extensions upper case, lower case etc... it will require some special attention to details.

It can all be done... but exporting to sql will not get you where you want to go.

RickyG · 01-12-2008, 06:20 AM

If anyone knows Arcade SQL..that would be ASB. He is the man for this stuff!
RickyG

hieuhpp · 01-12-2008, 09:10 AM

uh`m it is difficult with me.I Have SQL anf Script GSS 2.2.I will upload to host and anybody will download and help me????

I will learn Enlish more time,My english very bad

brendgard · 01-12-2008, 12:31 PM

I would be willing to take a look at it over the weekend if I can sneek it in. You would need to upload both the GSS SQL data dump in an SQL format, and the structure you are trying to convert it to. I make no promises(busy schedule), but I have done it before. I would also need to know if the game files are named as .swf, .SWF, mixed, or something else.

01-12-2008, 04:23 AM	#1 (permalink)
hieuhpp New Member Join Date: Dec 2007 Posts: 5	Help me i want convert sql of gamesitescript to another sql but i export GSS SQL to xls have error: the field gameurl in table game is blank.i can't get game fileto av arcade .PlZ help me take field gameurl.Sorry my english is bad

01-12-2008, 05:39 AM	#2 (permalink)
ArcadeSiteBuilder Senior Member Join Date: Oct 2007 Posts: 209	The games table in GSS does not hold the complete game url. In fact it doesn't even dontaint the complete game file name. GSS Games Table holds just the name itself, without the extension for the file. It can get complicated but if you have standardized extensions you can export the GSS games table to excel and use excel concatenate function to re-intoduce the missing extensions to reconsrtuction the complete file names. If you have a mixture of extensions upper case, lower case etc... it will require some special attention to details. It can all be done... but exporting to sql will not get you where you want to go. __________________

01-12-2008, 06:20 AM	#3 (permalink)
RickyG Moderator Senior Member Join Date: Dec 2006 Location: Under Your Mouse! Posts: 1,102	If anyone knows Arcade SQL..that would be ASB. He is the man for this stuff! RickyG __________________ Arcade Banner Exchange, game packs, top site, arcade script and forum for all of your arcade needs http://www.mibbi.com

01-12-2008, 12:31 PM	#5 (permalink)
brendgard Gamer FX Staff Senior Member Join Date: Oct 2006 Posts: 674	I would be willing to take a look at it over the weekend if I can sneek it in. You would need to upload both the GSS SQL data dump in an SQL format, and the structure you are trying to convert it to. I make no promises(busy schedule), but I have done it before. I would also need to know if the game files are named as .swf, .SWF, mixed, or something else. __________________ http://gamersgo.com A list of arcade related sites, add yours. http://auntiefondy.com Lists, add your site. http://kbsplace.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

01-12-2008, 09:10 AM	#4 (permalink)
hieuhpp New Member Join Date: Dec 2007 Posts: 5	uh`m it is difficult with me.I Have SQL anf Script GSS 2.2.I will upload to host and anybody will download and help me???? I will learn Enlish more time,My english very bad