SA-MP Forums Archive
[Plugin] [REL] MySQL Plugin (Now on github!) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)



Re: [REL] MySQL Plugin R4 (21/04/2010) - michael2572 - 08.07.2010

So mysql_retrive_row does not fetch data to pawn. So it's a little useless, no?


Re: [REL] MySQL Plugin R4 (21/04/2010) - Misiek - 08.07.2010

It's not, it fetches the next row internally allowing you to use mysql_fetch_field.


Re: [REL] MySQL Plugin R4 (21/04/2010) - Sergei - 08.07.2010

It's basically mysql_next_row, so it moves you to the next row. That way you can use mysql_fetch_field_row (mysql_get_field) without extracting result in pawn using mysql_fetch_row_format when you don't need it.


Re: [REL] MySQL Plugin R4 (21/04/2010) - michael2572 - 08.07.2010

Okay. That makes a lot of sense, actually. This plugin rrrrreally needs a documentation...maybe I'll write one.


Re: [REL] MySQL Plugin R4 (21/04/2010) - whitedragon - 09.07.2010

How make read and right users info from mysql?


Re: [REL] MySQL Plugin R4 (21/04/2010) - Sergei - 09.07.2010

Learn SQL language.


Re: [REL] MySQL Plugin R4 (21/04/2010) - mororo - 10.07.2010

Hello,
I have a question if the R4 version is available for Debian.
And I wonder if I could use the R4 a_mysql older plugin R2
Alternatively, if so I would ask to revive the link.

Resolving the problem and then sends the command to print individual row in their own changes

Код:
new field[256],str[256]
mysql_fetch_field_row(field, "NICK");
format(str,256,"Test %s, %d",field,field);
SendClientMessage(playerid,GREY,str);
This example does not work and can not use mysql_retrieve_row () any suggestions?
Thank you very much in advance and sorry for my English but (****** Translate)

Mororo


Re: [REL] MySQL Plugin R4 (21/04/2010) - Sergei - 10.07.2010

Did you save result? Did you fetched the row?

Код:
format(str,256,"Test %s, %d",field,field);
Both are strings, so %s.


Re: [REL] MySQL Plugin R4 (21/04/2010) - mororo - 10.07.2010

I do not understand what you mean my entire code: Thank you for your advice

Код:
dcmd_loadcar(playerid, params[]){
  #pragma unused params
	if(mysql_stav()){
		new query[256];
		format(query,sizeof(query),"SELECT * FROM `savecar` WHERE NICK='%s' LIMIT 1",Jmeno(playerid));
    mysql_reconnect();
    mysql_query(query);
    mysql_store_result();
		if(mysql_ping()>0){
//----------------------------------------------------------------------------------------
			new field[256],str[256]
			mysql_fetch_field_row(field, "Nick");
                        ... 17 row
			format(str,256,"Test %s, %d",field,field); // %d I just gave the test because of desperation to find out why it does not
//----------------------------------------------------------------------------------------
		}else{
      mysql_free_result();
    	SendClientMessage(playerid,RED,"Chyba : Nemбte v DB auto");
		}
	}else{
    SendClientMessage(playerid,RED,"Chyba : Server neni spuљtěn");
	}
	return 1;
}



Re: [REL] MySQL Plugin R4 (21/04/2010) - Sergei - 10.07.2010

Instead of
Код:
if(mysql_ping()>0)
use
Код:
if(mysql_retrieve_row())
And mysql_free_result() isn0t optional, so post it out of ifs


Respuesta: [REL] MySQL Plugin R5 (04/09/10) - 147147147 - 19.09.2010

Your Problem is in your mysql table. Check your db.


Re: [REL] MySQL Plugin R5 (04/09/10) - VIRUXE - 19.09.2010

I'm having a problem with gmx, with a fresh gamemode I'm working on.

I'm just connecting to the database on gamemodeinit and closing it on gamemodeexit. No querys executed at all.

And when I gmx, sometimes the server closes and sometimes it doesn't.

Here's the mysql_log:
Код:
[14:53:04] ---------------------------
[14:53:04] MySQL Debugging activated (09/19/10)
[14:53:04] ---------------------------
[14:53:04]  
[14:53:04] >> mysql_connect( )
[14:53:04] CMySQLHandler::CMySQLHandler() - constructor called.
[14:53:04] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "x" | Username: "root" ...
[14:53:04] CMySQLHandler::Connect() - Connection was successful.
[14:53:04] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[14:54:47] >> mysql_ping( Connection handle: 1 )
[14:54:47] CMySQLHandler::Ping() - Connection is still alive.
[15:19:30] >> mysql_ping( Connection handle: 1 )
[15:19:30] CMySQLHandler::Ping() - Connection is still alive.
[15:19:30] >> mysql_close( Connection handle: 1 )
[15:19:30] CMySQLHandler::~CMySQLHandler() - deconstructor called.
- CRASH
[15:21:43]  
[15:21:43] ---------------------------
[15:21:43] MySQL Debugging activated (09/19/10)
15:21:43] ---------------------------
[15:21:43]  
[15:21:43] >> mysql_connect( )
[15:21:43] CMySQLHandler::CMySQLHandler() - constructor called.
[15:21:43] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "x" | Username: "root" ...
[15:21:43] CMySQLHandler::Connect() - Connection was successful.
[15:21:43] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[15:23:41] >> mysql_ping( Connection handle: 1 )
[15:23:41] CMySQLHandler::Ping() - Connection is still alive.
[15:27:56] >> mysql_ping( Connection handle: 1 )
[15:27:56] CMySQLHandler::Ping() - Connection is still alive.
[15:27:56] >> mysql_close( Connection handle: 1 )
[15:27:56] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[15:27:56] CMySQLHandler::FreeResult() - The result is already empty.
[15:27:56] CMySQLHandler::Disconnect() - Connection was closed.
- DIDN'T CRASH
[15:28:08]  
[15:28:08] ---------------------------
[15:28:08] MySQL Debugging activated (09/19/10)
[15:28:08] ---------------------------
[15:28:08]  
[15:28:08] >> mysql_connect( )
[15:28:08] CMySQLHandler::CMySQLHandler() - constructor called.
[15:28:08] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "x" | Username: "root" ...
15:28:08] CMySQLHandler::Connect() - Connection was successful.
[15:28:08] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[15:29:53] >> mysql_ping( Connection handle: 1 )
[15:29:53] CMySQLHandler::Ping() - Connection is still alive.
[15:29:53] >> mysql_close( Connection handle: 1 )
[15:29:53] CMySQLHandler::~CMySQLHandler() - deconstructor called.
- CRASH

pawn Код:
public OnGameModeExit()
{
    print("* Exiting gamemode...");
   
    if(mysql_ping())
        mysql_close();
    return 1;
}
I changed today to version R5. Didn't experience any problems with the earlier versions.


Re: [REL] MySQL Plugin R5 (04/09/10) - VIRUXE - 27.09.2010

It's been "fixed". The server just crashes if the gamemode doesn't execute any querys. Since I wasn't executing any at the time, it was crashing.

Anyway, what exactly is this threaded callback business? Is it something like Hyper-Threading?


Re: [REL] MySQL Plugin R5 (04/09/10) - toneysix - 28.09.2010

Sometimes query's didn't executed.. In log:
Код:
[01:06:05] CMySQLHandler::Query(UPDATE `players` SET Sex=1,Age=21,Origin=0,DepositDay=0,Level=1,AdminLevel=0,Account=0,Muted=0,Warns=0,ConnectTime=1,Respect=1,Paycheck=281,PayDay=1,Deposit=0,Cash=5000,Bank=2117,SHealth=0.0,Health=76.0,Interior=3,Pos_x=-2025.3,Pos_y=-114.6,Pos_z=1035.1,Virtual=3,Local=255,House=255,Bizz=255,Job=0,Team=3,Member=0,Leader=0,FMember=7,Rank=6,FSkin=0,Model=133,ContractTime=0,DetSkill=0,LawSkill=0,RoadSkill=0,DrugsSkill=0,JackSkill=0,ProfSkill=0,MechSkill=0,GuardSkill=0,GunSkill=0,CarSkill=0,InkasSkill=0,BookmakerSkill=0,TaxiSkill=0,BusSkill=0,CourierSkill=0,TruckSkill=0,FishSkill=0,CookSkill=0,CarLic=11,BikeLic=0,FlyLic=0,BoatLic=0,FishLic=0,GunLic=0,Gun1=0,Ammo1=0,Gun2=0,Ammo2=0,Gun3=0,Ammo3=0,Gun4=0,Ammo4=0,Gun22Skill=0,Gun23Skill=0,Gun24Skill=0,Gun25Skill=0,Gun26Skill=0,Gun27Skill=0,Gun28Skill=0,Gun29Skill=0,Gun30Skill=0,Gun31Skill=0,Gun34Skill=0,HeadValue=0,Wins=0,Loses=0,Kills=0,Deaths=0,Crimes=0,Arrested=0,WantedDeaths=0,Article=0,Part=0,Jailed=0,JailTime=0,JailPrice=0,UpgradePoints=0,AlcoholPerk=0,DrugPerk=0,MiserPerk=0,PainPerk=0,TraderPerk=0,STD=0,Antiradar=0,GPS=0,CDPlayer=0,Dice=0,Drugs=0,Cigars=0,Fishes=0,BiggestFish=0,Fuel=0,LottoNr=0,Materials=0,PhoneNr=0,Phonebook=0,Married=0,MarriedTo='BeSingle',Offline=271,CarTime=0,Tutorial=0,PurposeMurder=0,Referal=0 WHERE Name='Michail_Suvorov') - Successfully executed.
But in table:

Uploaded with ImageShack.us
It's happened with 20 percent of the players.


Re: [REL] MySQL Plugin R5 (04/09/10) - kurta999 - 28.09.2010

Use this ` ! Without ` doesn't work.

Example:

UPDATE `players` SET `money` = '50000', `bank` = '150' WHERE `reg_id` = '1'


Re: [REL] MySQL Plugin R5 (04/09/10) - armyoftwo - 28.09.2010

Код:
BikeLic=0,FlyLic=0,BoatLic=0,FishLic=0,GunLic=0,Gun1=0,Ammo1=0,Gun2=0,Ammo2=0,Gun3=0,Ammo3=0,Gun4=0,Ammo4=0,Gun22Skill=0,Gun23Skill=0,Gun24Skill=0,Gun25Skill=0,Gun26Skill=0
It will be defiantly 0, so it did execute


Re: [REL] MySQL Plugin R5 (04/09/10) - Sergei - 28.09.2010

Quote:
Originally Posted by kurta999
Посмотреть сообщение
Use this ` ! Without ` doesn't work.

Example:

UPDATE `players` SET `money` = '50000', `bank` = '150' WHERE `reg_id` = '1'
You fail. Please learn about MySQL syntax.


Re: [REL] MySQL Plugin R5 (04/09/10) - VIRUXE - 28.09.2010

Quote:
Originally Posted by Sergei
Посмотреть сообщение
You fail. Please learn about MySQL syntax.
If you know better then just correct him. Your post was as useful as his.


Re: [REL] MySQL Plugin R5 (04/09/10) - VIRUXE - 28.09.2010

Quote:
Originally Posted by toneysix
Посмотреть сообщение
Sometimes query's didn't executed.. In log:
Код:
[01:06:05] CMySQLHandler::Query(UPDATE `players` SET Sex=1,Age=21,Origin=0,DepositDay=0,Level=1,AdminLevel=0,Account=0,Muted=0,Warns=0,ConnectTime=1,Respect=1,Paycheck=281,PayDay=1,Deposit=0,Cash=5000,Bank=2117,SHealth=0.0,Health=76.0,Interior=3,Pos_x=-2025.3,Pos_y=-114.6,Pos_z=1035.1,Virtual=3,Local=255,House=255,Bizz=255,Job=0,Team=3,Member=0,Leader=0,FMember=7,Rank=6,FSkin=0,Model=133,ContractTime=0,DetSkill=0,LawSkill=0,RoadSkill=0,DrugsSkill=0,JackSkill=0,ProfSkill=0,MechSkill=0,GuardSkill=0,GunSkill=0,CarSkill=0,InkasSkill=0,BookmakerSkill=0,TaxiSkill=0,BusSkill=0,CourierSkill=0,TruckSkill=0,FishSkill=0,CookSkill=0,CarLic=11,BikeLic=0,FlyLic=0,BoatLic=0,FishLic=0,GunLic=0,Gun1=0,Ammo1=0,Gun2=0,Ammo2=0,Gun3=0,Ammo3=0,Gun4=0,Ammo4=0,Gun22Skill=0,Gun23Skill=0,Gun24Skill=0,Gun25Skill=0,Gun26Skill=0,Gun27Skill=0,Gun28Skill=0,Gun29Skill=0,Gun30Skill=0,Gun31Skill=0,Gun34Skill=0,HeadValue=0,Wins=0,Loses=0,Kills=0,Deaths=0,Crimes=0,Arrested=0,WantedDeaths=0,Article=0,Part=0,Jailed=0,JailTime=0,JailPrice=0,UpgradePoints=0,AlcoholPerk=0,DrugPerk=0,MiserPerk=0,PainPerk=0,TraderPerk=0,STD=0,Antiradar=0,GPS=0,CDPlayer=0,Dice=0,Drugs=0,Cigars=0,Fishes=0,BiggestFish=0,Fuel=0,LottoNr=0,Materials=0,PhoneNr=0,Phonebook=0,Married=0,MarriedTo='BeSingle',Offline=271,CarTime=0,Tutorial=0,PurposeMurder=0,Referal=0 WHERE Name='Michail_Suvorov') - Successfully executed.
But in table:

Uploaded with ImageShack.us
It's happened with 20 percent of the players.
Maybe your query is too long?

Did you try executing that query before you applied it to your gamemode?


Re: [REL] MySQL Plugin R5 (04/09/10) - BMB! - 28.09.2010

good Job