|
|
GSADO.dll (C-Script to Lite-C)
#315829
03/19/10 13:20
03/19/10 13:20
|
Joined: Mar 2010
Posts: 13
Agnam
OP
Newbie
|
OP
Newbie
Joined: Mar 2010
Posts: 13
|
Hi, all I use Peacekeeper's ADO plugin to control ACCESS database, and has purchased OFFICE 2003 for this reason. I have a question: This plugin works fine on C-Script(A7 PRO 7.82). But CRASH with Lite-C. Who can instruct my how to define functions and value correctly? thank you. Thanks Peacekeeper, http://www.peacekeeper.com/3dgs/ado.html
|
|
|
Re: GSADO.dll (C-Script to Lite-C)
[Re: Agnam]
#315918
03/20/10 02:36
03/20/10 02:36
|
Joined: Mar 2010
Posts: 13
Agnam
OP
Newbie
|
OP
Newbie
Joined: Mar 2010
Posts: 13
|
and how to replace this:
function ADO_Create(STRING* con_name);
function ADO_SetVerbose(int );
function ADO_AddToPool(STRING* con_name);
function ADO_GetFromPool(STRING* con_name);
function ADO_SetConnStr(STRING* con_name,STRING*);
function ADO_SetQueryStr(STRING* con_name, STRING*);
function ADO_Connected(STRING* con_name,int );
function ADO_IsConnected(STRING* con_name);
function ADO_QueryActive(STRING* con_name,int );
function ADO_IsQActive(STRING* con_name);
function ADO_ExecuteSQL(STRING* con_name);
function ADO_First(STRING* con_name);
function ADO_Last(STRING* con_name);
function ADO_Next(STRING* con_name);
function ADO_Prior(STRING* con_name);
function ADO_FindFirst(STRING* con_name);
function ADO_FindLast(STRING* con_name);
function ADO_FindNext(STRING* con_name);
function ADO_FindPrior(STRING* con_name);
function ADO_IsQueryEOF(STRING* con_name);
function ADO_GetField(STRING* con_name,STRING* fieldstr,STRING*);
function ADO_ReturnRecSet(STRING* con_name, int);
function ADO_CmdTimeout(STRING* con_name,STRING*);
function ADO_ConnTimeout(STRING* con_name,STRING*);
function ADO_CursorLoc(STRING* con_name,int );
function ADO_DBType(STRING* con_name,int );
function ADO_IsoLevel(STRING* con_name,int );
function ADO_Mode(STRING* con_name,int );
function ADO_CursorType(STRING* con_name,int );
function ADO_Free(STRING* con_name);
|
|
|
Re: GSADO.dll (C-Script to Lite-C)
[Re: Agnam]
#315927
03/20/10 09:32
03/20/10 09:32
|
Joined: Mar 2010
Posts: 13
Agnam
OP
Newbie
|
OP
Newbie
Joined: Mar 2010
Posts: 13
|
anybody help me?
#include <acknex.h>
#include <default.c>
#define PRAGMA_PLUGIN "gsADO.dll"
var ADO_Create(STRING* con_name);
var ADO_SetVerbose(int);
var ADO_AddToPool(STRING* con_name);
var ADO_GetFromPool(STRING* con_name);
var ADO_SetConnStr(STRING* con_name,STRING* );
var ADO_SetQueryStr(STRING* con_name,STRING* );
var ADO_Connected(STRING* con_name,int);
var ADO_IsConnected(STRING* con_name);
var ADO_QueryActive(STRING* con_name,int);
var ADO_IsQActive(STRING* con_name);
var ADO_ExecuteSQL(STRING* con_name);
var ADO_First(STRING* con_name);
var ADO_Last(STRING* con_name);
var ADO_Next(STRING* con_name);
var ADO_Prior(STRING* con_name);
var ADO_FindFirst(STRING* con_name);
var ADO_FindLast(STRING* con_name);
var ADO_FindNext(STRING* con_name);
var ADO_FindPrior(STRING* con_name);
var ADO_IsQueryEOF(STRING* con_name);
var ADO_GetField(STRING* con_name,STRING* fieldstr,STRING* );
var ADO_ReturnRecSet(STRING* con_name,int);
var ADO_CmdTimeout(STRING* con_name,STRING* );
var ADO_ConnTimeout(STRING* con_name,STRING* );
var ADO_CursorLoc(STRING* con_name,int);
var ADO_DBType(STRING* con_name,int);
var ADO_IsoLevel(STRING* con_name,int);
var ADO_Mode(STRING* con_name,int);
var ADO_CursorType(STRING* con_name,int);
var ADO_Free(STRING* con_name);
STRING* sDatabaseString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=access2000.mdb;Persist Security Info=False;";
STRING* sExampleRecord = "";
STRING* sPrinter1 = "";
STRING* DebugTemp0001 = "";
TEXT* Debug_Txt =
{
pos_x = 200;
pos_y = 0;
string("ret:", DebugTemp0001, "MDB: ",sExampleRecord);
flags = SHOW;
}
var ret;
void main()
{
ADO_SetVerbose(1);
ADO_Create(_str("GetRecords"));
ADO_SetConnStr(_str("GetRecords"),sDatabaseString);
ADO_SetQueryStr(_str("GetRecords"),_str("SELECT * FROM Table1"));
ADO_QueryActive(_str("GetRecords"),1);
ADO_First(_str("GetRecords"));
ADO_IsQueryEOF(_str("GetRecords"));
ret = ADO_IsQueryEOF(_str("GetRecords"));
while(ret == 0) //(ADO_IsQueryEOF(_str("GetRecords")) == 0)
{
ADO_GetField(_str("GetRecords"),_str("Field1"),sPrinter1);
str_cat(sExampleRecord, sPrinter1);
str_cat(sExampleRecord, "\n");
ADO_GetField(_str("GetRecords"),_str("Field2"),sPrinter1);
str_cat(sExampleRecord, sPrinter1);
str_cat(sExampleRecord, "\n");
ADO_GetField(_str("GetRecords"),_str("NumberField1"),sPrinter1);
str_cat(sExampleRecord, sPrinter1);
str_cat(sExampleRecord, "\n");
str_cat(sExampleRecord, "\n");
ADO_Next(_str("GetRecords"));
ret = ADO_IsQueryEOF(_str("GetRecords"));
str_cpy(DebugTemp0001, str_for_num(DebugTemp0001, ret));
wait(1);
}
printf("Done!");
ADO_QueryActive(_str("GetRecords"),0);
on_exit = ADO_Free(_str("GetRecords"));
}
|
|
|
Re: GSADO.dll (C-Script to Lite-C)
[Re: Agnam]
#315933
03/20/10 10:06
03/20/10 10:06
|
Joined: Oct 2007
Posts: 5,209
İstanbul, Turkey
Quad
Senior Expert
|
Senior Expert
Joined: Oct 2007
Posts: 5,209
İstanbul, Turkey
|
that plugin was for v5.5 it may not fully work even if the DLL is converted, i currently do not have time for looking in to ADO plugin, but you can always try Sqlite. I am using it for project currently, it works great;)
3333333333
|
|
|
Re: GSADO.dll (C-Script to Lite-C)
[Re: Quad]
#315945
03/20/10 12:44
03/20/10 12:44
|
Joined: Mar 2010
Posts: 13
Agnam
OP
Newbie
|
OP
Newbie
Joined: Mar 2010
Posts: 13
|
Quadraxas thanks.
I planned that now uses SQLite. But SQLite Database does not support the encryption(Password protection). so, anybody may use the tool to open the *.db and replace weapon damage, health value, level, EXP...is a trouble.
Now already solved the database transformation.
ACCESS > export .txt (or update MSSQL) > SQLite Database Browser import and export .db(or MSSQL 2 SQLite tool)
Last edited by Agnam; 03/20/10 12:44.
|
|
|
Re: GSADO.dll (C-Script to Lite-C)
[Re: Agnam]
#315948
03/20/10 12:54
03/20/10 12:54
|
Joined: Oct 2007
Posts: 5,209
İstanbul, Turkey
Quad
Senior Expert
|
Senior Expert
Joined: Oct 2007
Posts: 5,209
İstanbul, Turkey
|
yes, if you need encryption then sqlite is not for you. I am storing strings used in the app(for easier localisation) on a databese, so it's not the case for me.
I do not have ms acess or any ADO experience so i cannot really help you in this case, sorry.
3333333333
|
|
|
Re: GSADO.dll (C-Script to Lite-C)
[Re: Agnam]
#315971
03/20/10 14:36
03/20/10 14:36
|
Joined: Oct 2007
Posts: 5,209
İstanbul, Turkey
Quad
Senior Expert
|
Senior Expert
Joined: Oct 2007
Posts: 5,209
İstanbul, Turkey
|
sqlite would fit for that. You can try diffrent things and see how it turns out. Try to use diffrent databases for items,dialogues etc.
3333333333
|
|
|
Re: GSADO.dll (C-Script to Lite-C)
[Re: Agnam]
#316084
03/21/10 11:22
03/21/10 11:22
|
Joined: Oct 2007
Posts: 5,209
İstanbul, Turkey
Quad
Senior Expert
|
Senior Expert
Joined: Oct 2007
Posts: 5,209
İstanbul, Turkey
|
Hm, i am not really sure what should be the problem. Maybe you could try the original sqlite dll instead of the GSTsqlite and see if it changes anything.
3333333333
|
|
|
|
