Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #include <a_samp>
- #include <p_ini>
- #include <a_mysql>
- new mMysql;
- #define SQL_HOST "localhost"
- #define SQL_USER "Pavel"
- #define SQL_DB "Mysqltest"
- #define SQL_PASS "123123"
- new string[200];
- new proverka;
- public OnGameModeInit()
- {
- printf("Начинаем тестирование p_ini...");
- proverka=GetTickCount();
- for new i=0;i<50;i++ do
- {
- valstr(string,i);
- new pini:File=OpenFile("ptest.ini");
- SetIntegerFile(File,string,i);
- format(string,200,"%dstr",i);
- SetStringFile(File,string,"Value");
- GetStringFile(File,string,string);
- format(string,200,"%dfloat",i);
- SetFloatFile(File,string,i/2);
- for new j=0;j<50;j++ do
- {
- format(string,200,"%desho",j);
- SetIntegerFile(File,string,j);
- GetIntegerFile(File,string,j);
- SetIntegerFile(File,string,i);
- format(string,200,"NumberStr%d",j);
- SetStringFile(File,string,"strvalue");
- GetStringFile(File,string,string);
- }
- CloseFile(File);
- }
- printf("Результаты p_ini: %d (ms)",GetTickCount()-proverka);
- printf("Начинаем тестирование MySQL...");
- proverka=GetTickCount();
- mMysql=mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
- for new i=0;i<50;i++ do
- {
- mysql_format(mMysql,string,"UPDATE `"SQL_DB"` SET `%d`='%d' WHERE `IDKEY`='1'",i,i);
- mysql_function_query(mMysql,string,false,"","");
- mysql_format(mMysql,string,"UPDATE `"SQL_DB"` SET `%dstr`='VALUE' WHERE `IDKEY`='1'",i);
- mysql_function_query(mMysql,string,false,"","");
- mysql_format(mMysql,string,"SELECT `%dstr` FROM `"SQL_DB"` WHERE `IDKEY`='1'",i);
- mysql_function_query(mMysql,string,true,"OnMySQLLoaded","i",1);
- mysql_format(mMysql,string,"UPDATE `"SQL_DB"` SET `%dfloat`='%f' WHERE `IDKEY`='1'",i,i/2);
- mysql_function_query(mMysql,string,false,"","");
- for new j=0;j<50;j++ do
- {
- mysql_format(mMysql,string,"UPDATE `"SQL_DB"` SET `%desho`='%d' WHERE `IDKEY`='1'",j,j);
- mysql_function_query(mMysql,string,false,"","");
- mysql_format(mMysql,string,"SELECT `%desho` FROM `"SQL_DB"` WHERE `IDKEY`='1'",j);
- mysql_function_query(mMysql,string,true,"OnMySQLLoaded","i",1);
- mysql_format(mMysql,string,"UPDATE `"SQL_DB"` SET `%desho`='%d' WHERE `IDKEY`='1'",j,i);
- mysql_function_query(mMysql,string,false,"","");
- mysql_format(mMysql,string,"UPDATE `"SQL_DB"` SET `NumberStr%d`='strvalue' WHERE `IDKEY`='1'",j);
- mysql_function_query(mMysql,string,false,"","");
- mysql_format(mMysql,string,"SELECT `NumberStr%d` FROM `"SQL_DB"` WHERE `IDKEY`='1'",j);
- mysql_function_query(mMysql,string,true,"OnMySQLLoaded","i",(j*i)+10);
- }
- }
- return 1;
- }
- main()
- {
- }
- forward OnMySQLLoaded(loaded);
- public OnMySQLLoaded(loaded)
- {
- if loaded==1 *then
- {
- string[0]=cache_get_row_int(0,0);
- return 1;
- }
- cache_get_row(0,0,string);
- if loaded==2411 *then
- {
- mysql_close(mMysql);
- printf("Результаты MySQL: %d (ms)",GetTickCount()-proverka);
- return 1;
- }
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement