Request GSP international terminal repair encountered difficulties need help!

biody

Banned
Banned
Apr 15, 2016
44
0
32
GSP international terminal repair encountered difficulties need help!:@:surprise:
The translator is not good at English but please understand!:indecisiveness:
Database structure A library and H library is what kind of structure? QQ图片20160607115733.jpg QQ图片20160607115739.jpg

---------- Post Merged at 11:36 AM ---------- Previous Post was at 03:59 AM ----------

QQ图片20160607193550.jpg
Database structure A library and H library is what kind of structure?:bi_polo:
 

biody

Banned
Banned
Apr 15, 2016
44
0
32
chinaboy 我想知道 A库和H库里面有结构有哪些!
DjDarkBoyZ
I want to know what have A library and H A repository structure.

---------- Post Merged at 02:49 AM ---------- Previous Post was at 02:26 AM ----------

Hi DjDarkBoyZ!
I want to ask the database A and database data structure of the H! :P
 

biody

Banned
Banned
Apr 15, 2016
44
0
32
The difficulties database structure is not clear I don't know how to repair!
 

Coly

LOMCN Developer
Developer
Mar 31, 2005
1,399
33
195
Germany
005B6538 <AnsiString> 'TBL_BasicCharQuest'
005B6554 <AnsiString> 'FLD_MADOUSER = ''
005B6570 <AnsiString> 'TBL_HonChonMadoQuest'
005B6590 <AnsiString> 'TBL_LevelCharQuest'
005B65AC <AnsiString> 'FLD_MADOHAVEUSER = ''
005B65CC <AnsiString> 'TBL_MadoHaveUserQuest'
005B65EC <AnsiString> 'FLD_SINUSERNAME = ''
005B6608 <AnsiString> 'TBL_SinGiSunQuest'

0065A5D8 <AnsiString> ' FROM TBL_ITEMMARKET WHERE FLD_BUYER is NULL '
0065A610 <AnsiString> ' ORDER BY FLD_SELLINDEX DESC) a ORDER BY FLD_SELLINDEX'
0065A650 <WideString> 'FLD_SELLINDEX'
0065A670 <WideString> 'FLD_SELLWHO'
0065A68C <WideString> 'FLD_ITEMNAME'
0065A6AC <WideString> 'FLD_SELLPRICE'
0065A6CC <WideString> 'FLD_SELLDATE'
0065A6EC <WideString> 'FLD_MAKEINDEX'
0065A70C <WideString> 'FLD_INDEX'
0065A724 <WideString> 'FLD_DURA'
0065A73C <WideString> 'FLD_DURAMAX'
0065A75C <AnsiString> 'FLD_DESC'
0065A76C <WideString> 'FLD_COLORR'
0065A788 <WideString> 'FLD_COLORG'
0065A7A4 <WideString> 'FLD_COLORB'
0065A7C0 <WideString> 'FLD_EXPIRETIME'
0065A7E4 <WideString> 'FLD_NAMEPREFIX'
0065A808 <WideString> 'FLD_TEXT'
0065A820 <WideString> 'FLD_QTY'

0065ABC8 <WideString> 'fld_image'
0065ABE0 <WideString> 'fld_update'


005531EC <WideString> 'fld_type'
00553204 <WideString> 'fld_index'
0055321C <WideString> 'fld_dura'
00553234 <WideString> 'fld_duramax'
00553250 <WideString> 'fld_desc0'
00553268 <WideString> 'fld_desc1'
00553280 <WideString> 'fld_desc2'
00553298 <WideString> 'fld_desc3'
005532B0 <WideString> 'fld_desc4'
005532C8 <WideString> 'fld_desc5'
005532E0 <WideString> 'fld_desc6'
005532F8 <WideString> 'fld_desc7'
00553310 <WideString> 'fld_desc8'
00553328 <WideString> 'fld_desc9'
00553340 <WideString> 'fld_desc10'
0055335C <WideString> 'fld_desc11'
00553378 <WideString> 'fld_desc12'
00553394 <WideString> 'fld_desc13'
005533B0 <WideString> 'fld_colorr'
005533CC <WideString> 'fld_colorg'
005533E8 <WideString> 'fld_colorb'
00553404 <WideString> 'fld_nameprefix'
00553428 <WideString> 'fld_expiretime'
0055344C <WideString> 'fld_qty'

00659008 <AnsiString> ' WHERE FLD_TEAMMASTER = (select fld_teammaster from '
00659048 <AnsiString> ' where fld_teammember=''
0065906C <AnsiString> '') GROUP BY FLD_TEAMMASTER, FLD_TEAMNAME'
0065909C <WideString> 'FLD_TOTALCOUNT'
006590C0 <WideString> 'FLD_TEAMNAME'
006590E4 <AnsiString> 'SELECT FLD_TEAMMEMBER FROM '
006592E8 <WideString> 'FLD_TEAMMASTER'
0065930C <WideString> 'FLD_TEAMNAME'
00659A68 <AnsiString> 'SELECT COUNT(FLD_TEAMMEMBER) AS FLD_TOTALCOUNT FROM '
00659AA8 <AnsiString> '' GROUP BY FLD_TEAMMASTER'
00659AC8 <WideString> 'FLD_TOTALCOUNT'
0065A478 <AnsiString> ' and FLD_ITEMTYPE='
0065A494 <AnsiString> ' and FLD_SELLWHO=''
0065A4BC <AnsiString> ' and FLD_ITEMNAME=''
 
Last edited:

biody

Banned
Banned
Apr 15, 2016
44
0
32
Coly
user-offline.png
What is your list of these about?
 

Coly

LOMCN Developer
Developer
Mar 31, 2005
1,399
33
195
Germany
at the moment I don't have the correct DB. It's only a bit info waht I have.
 

DjDarkBoyZ

Dev
Golden Oldie
Aug 11, 2006
1,065
228
260
127.Ø.Ø.1
Biody, you need to fix the Sql, recreate DB and storage procedures,
take a look for strings are in the exe using ollydbg or idapro debugging programs.

When you got fixed sql, you got like this gsp files fixed:
Mir3_160530_030601_GSP_Wincha.png


Nothing is imposible. ;)
Good luck! :D
 

ventus

LOMCN Veteran
Veteran
Oct 17, 2013
926
132
105
I check these forums everyday in the hopes someone will have released these files for everyone to enjoy.