Help with SQL.dll

[brunomomesso]

how do I use the sql.dll with mysql and not SQL2005?

 

[bobsobol]

Rewrite it from scratch? (native API is completely different) Or use

To view the content, you need to sign in or register

with his Linux VM. (and good ODBC driver?)

--- EDIT ---
BTW... since you asked, and I was looking at it again not so long ago... API details for SQLDll.dll and Clan.dll ... as far as I can be sure of:-

Clan.dll

cdecl ClanPointInsert (arg1 ... 5)
cdecl ClanUserMarkNum (arg1 ... 2)
cdecl ClanUserTicKets (arg1... arg7)
_________________________________
[U]Unused Exports (therefore, unknown interface)...[/U]

ClanPointDelete
ClanUserTicKet
ClanUserLevel
GetClanIDX
GetClanMainIDX
GetClanSubIDX
GetServerName
GetTicket

SQLDll.dll

void? __cdecl CharLog (arg1 ... 10)
	eg. CharLog(x, x, x, x, x, lpszSvrName, x, x, x, [1-3])
	This is actually 3 routines with a similar template of arguements.

void? CharRecordLog (arg1 ... 11)
	again, last parameter is action index, 6th is server name.
	seems to be associated with character delete.

	Possible actions for these functions:-
	1 = Add character. (PristonSQLDll.SQLDelCharProcess)
	2 = Delete character. (PristonSQLDll.SQLAddCharProcess)
	3 = Character logout? (PristonSQLDll.SQLLogoutProcess)

void? ?? ClanMoney ??
void? GetGPCode (void)
void? __cdecl LogITEMPostRecord (arg1, arg2)
void? __cdecl LogITEMRecord (arg1, arg2)
void? __cdecl LogITEMTradeRecord (arg1, arg2)
int __cdecl PCRNoReservProduct(arg1, arg2)
struct __cdecl PCSearchReserve (arg1 ... 9)
struct __stdcall PCUse (arg1 ... 6?) // arg3 is always 0x845A40
void? __cdecl SQLLogon (arg1 ... 9)
void? __cdecl SQLLogout (arg1 ... 8)
void ServerDown (void)
void ServerExit (void)
void? __cdecl SiegeMoney (arg1 ... 5)
void __cdecl WithSOD2RecordRanks (arg1 ... 13)
_________________________________
[U]Unused Exports (therefore, unknown interface)...[/U]

ConnectSQLDB_Item
CurrentIPSearchPMNo
CurrentIPSearchRNo
GameLog
GameLogTime
GameLogTime_old
GameLog_old
GameOnOut
GetBillingNum
GetCountryIP
GetGameLogStartEndTime
GetGameUser
GetGameUserInfo
GetGameUserMX
GetGameUserRNo
GetGamer
GetGiveYouItem
GetPCBangInfo2
GetPCDisuseDayTime
GetPCUseTime
GetServerName
GetStartLastDay
GetStartLastEditDayTime
GetTCode
GetUseID
GetUserDetail
GetUserDisuseDayTime
GetUserUseTime
Hacklog
Hello
LogITEMRecord2
LogITEMRecord_old
LogITEMTradeRecord2
LogITEMTradeRecord_old
PCCheck
PCDelIPList
PCDelRegIP
PCDisSearch
PCHelp
PCHelpSearch
PCIPChangeLog
PCInsIPChangeLog
PCInsIPList
PCSearchGPCode
PCSearchIP
PCSearchIPRNo
PCSearchIPTime
PCSearchRNoTime
PCSearchReserv
PCUPDateRegIP
PCUseCountInsert
PCUseCountLog
PCUseCountSearch
PCUseCountUpdate
PCUseTime
PCUseTimeLog
SODRecord_Web
SearchChannel
SearchChannelDetail
SearchEvent
SetBilling
SetBillingLog
SetCIInfo
SetEditDayPC
SetEditDayRNoPC
SetEditDayRNoPCTime
SetGameUser
SetGameUser2
SetGameUserGPCode
SetGameUserGPCodeLog
SetGameUserMX
SetGamerActive
SetGiveYouItem
SetLastDay
SetLastDayInuse
SetPersonalMember
SetStartDay
SetStartDayTime2
SetTCode
SiegeMoneyTax
UserUseTime
UserUseTimeAuto
UserUseTimeLog
UserUseTimeResult
WithSODRecordRanks

My guess is that the unused exports are imported into ASP or such on official servers... I doubt exports like "Hello" are used for anything but testing though. XD

My general notation is that single question mark following a keyword (eg. void?) suggests there's something that still shakes my confidence in that interpretation, but that's what it seems to be doing. Double question marks where a keyword should be (eg. void ?? function(arg1...9)) means I either have completely conflicting evidence for what that keyword should be, or have no evidence one way or another.

Incomplete but... *gift*. : (so you can't complain) I do that, you see.

 

[brunomomesso]

Thank you for help, but for a few days will still be searching for something to create a new dll for connecting to mysql

 

[bobsobol]

Nothing will help you with that. Stop searching. What I posted is more information than has ever been provided to "help create a new dll for connecting to mysql" here before. (and that's not saying much, except that there is very little documentation.

If the link to Vormavs' shared (but not *yet* documented) MySQL dlls are no good for you, your only option is to do it all yourself.

 

[brunomomesso]

did not say that there are good, the contrary is an excellent work, I just want to understand better its structure, and also will be looking at them again.
excuse me its what I quoted gave that impression

 

[bobsobol]

In which case, I agree. I am also keen to see Vormavs' promised documentation to those dlls under WinDoze. XD But I also know he is keen for me to pull my finger out on an incomplete development I shared recently, and *everyone* is impatient for us to achieve more than we can afford the time to devote.

 

[Vormav]

I will eventually document it but meanwhile you can ask any question that is not too generic. If you tell me where you stuck than I can help you.

 

[brunomomesso]

Good evening, I'm Vormav your files using the very same windows, thank you very much for your help, now is to develop systems for mysql

thank you very much