1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Help Archive

Threaded Mode
Help me:D
Emanuelll
Big Clucker
***
Posts: 88
Threads: 3
Joined: Feb 2010
Reputation: 0
#1

29.11.2010, 18:20
( Последний раз редактировалось Emanuelll; 11.12.2010 в 12:39. )
Hello! I installed MySQL Plugin R5 de G-sTyLeZzZ and i modified script (from Moderntopia Roleplay: Los Santos ( http://forum.sa-mp.com/showthread.ph...ght=mtrp-final ), but when i'm login on server (on Windows and on Linux) something is repeated many times... the error maybe at OnPlayerUpdate... cand someone help me... sorry for my English

part from mysql_log Recurring...

mysql_log:
Код:
[08:21:45] CMySQLHandler::Query(UPDATE players SET pSHealth='0.000000',pHealth='100.000000',pArmour='0.000000',Inte=0,Local=255,Team=3,Model=264,PhoneNr=8608,House=255,Car1=0,Car2=0,Car3=0,Car4=0,Bizz=255,Pos_x='2246.000000',Pos_y='-1161.000000' WHERE id=1) - An error has occured. (Error ID: 1054, Unknown column 'Car1' in 'field list')

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(1029.000000); - Escaped 11 characters to 1029.000000.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Pos_z='1029.000000',CarLic=0,FlyLic=0,BoatLic=0,FishLic=0,GunLic=0,MatsLic=0,Gun1=0,Gun2=0,Gun3=0,Gun4=0,Ammo1=0,Ammo2=0,Ammo3=0,Ammo4=0,CarTime=0,PayDay=0,PayDayHad=0,CDPlayer=0,Watch=0,Frec=0 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Walkie=0,Cigars=0,Matches=0,FTools=0,Wins=0,Loses=0,AlcoholPerk=0,DrugPerk=0,MiserPerk=0,PainPerk=0,TraderPerk=0,Tutorial=1,Sprunk=0,Beer=0,Wine=0,Mission=0,Warnings=0,Adjustable=0,FWarns=0 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(No-one); - Escaped 6 characters to No-one.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Fpunish=0,Fuel=0,Married=0,MarriedTo='No-one',Updates01=0,Updates02=0,Updates03=0,Updates04=0,Updates05=0,Updates06=0,Updates07=0,Updates08=0,Updates09=0,Updates10=0,Updates11=0,Updates12=0 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Updates13=0,Updates14=0,Updates15=0,Locked=0 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_ping( Connection handle: 1 )

[08:21:45] CMySQLHandler::Ping() - Connection is still alive.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(12); - Escaped 2 characters to 12.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Password='12',PlayerLevel=3,AdminLevel=0,GM=0,Helper=0,Wipe=0,DonateRank=0,UpgradePoints=0,ConnectedTime=1,Registered=1,Sex=1,Age=20,Origin=3,CK=0,Muted=0,MuteTime=0,Respect=0,Money=11900 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Bank=50000,Crimes=0,Kills=0,Deaths=0,Arrested=0,WantedLevel=0,WantedPoints=0,WantedDeaths=0,Phonebook=0,LottoNr=0,Fishes=0,BiggestFish=0,Job=0,Paycheck=60,HeadValue=0,Jailed=0,JailTime=0,Materials=0 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Drugs=0,Leader=0,Member=0,FMember=255,Rank=0,Chara=48,ContractTime=0,DetSkill=0,SexSkill=0,BoxSkill=0,LawSkill=0,MechSkill=0,JackSkill=0,CarSkill=0,NewsSkill=0,DrugsSkill=0,CookSkill=0,FishSkill=0 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(0.000000); - Escaped 8 characters to 0.000000.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(100.000000); - Escaped 10 characters to 100.000000.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(0.000000); - Escaped 8 characters to 0.000000.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(2246.000000); - Escaped 11 characters to 2246.000000.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(-1161.000000); - Escaped 12 characters to -1161.000000.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET pSHealth='0.000000',pHealth='100.000000',pArmour='0.000000',Inte=0,Local=255,Team=3,Model=264,PhoneNr=8608,House=255,Car1=0,Car2=0,Car3=0,Car4=0,Bizz=255,Pos_x='2246.000000',Pos_y='-1161.000000' WHERE id=1) - An error has occured. (Error ID: 1054, Unknown column 'Car1' in 'field list')

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(1029.000000); - Escaped 11 characters to 1029.000000.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Pos_z='1029.000000',CarLic=0,FlyLic=0,BoatLic=0,FishLic=0,GunLic=0,MatsLic=0,Gun1=0,Gun2=0,Gun3=0,Gun4=0,Ammo1=0,Ammo2=0,Ammo3=0,Ammo4=0,CarTime=0,PayDay=0,PayDayHad=0,CDPlayer=0,Watch=0,Frec=0 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Walkie=0,Cigars=0,Matches=0,FTools=0,Wins=0,Loses=0,AlcoholPerk=0,DrugPerk=0,MiserPerk=0,PainPerk=0,TraderPerk=0,Tutorial=1,Sprunk=0,Beer=0,Wine=0,Mission=0,Warnings=0,Adjustable=0,FWarns=0 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(No-one); - Escaped 6 characters to No-one.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Fpunish=0,Fuel=0,Married=0,MarriedTo='No-one',Updates01=0,Updates02=0,Updates03=0,Updates04=0,Updates05=0,Updates06=0,Updates07=0,Updates08=0,Updates09=0,Updates10=0,Updates11=0,Updates12=0 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Updates13=0,Updates14=0,Updates15=0,Locked=0 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_ping( Connection handle: 1 )

[08:21:45] CMySQLHandler::Ping() - Connection is still alive.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(12); - Escaped 2 characters to 12.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Password='12',PlayerLevel=3,AdminLevel=0,GM=0,Helper=0,Wipe=0,DonateRank=0,UpgradePoints=0,ConnectedTime=1,Registered=1,Sex=1,Age=20,Origin=3,CK=0,Muted=0,MuteTime=0,Respect=0,Money=11900 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Bank=50000,Crimes=0,Kills=0,Deaths=0,Arrested=0,WantedLevel=0,WantedPoints=0,WantedDeaths=0,Phonebook=0,LottoNr=0,Fishes=0,BiggestFish=0,Job=0,Paycheck=60,HeadValue=0,Jailed=0,JailTime=0,Materials=0 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET Drugs=0,Leader=0,Member=0,FMember=255,Rank=0,Chara=48,ContractTime=0,DetSkill=0,SexSkill=0,BoxSkill=0,LawSkill=0,MechSkill=0,JackSkill=0,CarSkill=0,NewsSkill=0,DrugsSkill=0,CookSkill=0,FishSkill=0 WHERE id=1) - Successfully executed.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(0.000000); - Escaped 8 characters to 0.000000.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(100.000000); - Escaped 10 characters to 100.000000.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(0.000000); - Escaped 8 characters to 0.000000.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(2246.000000); - Escaped 11 characters to 2246.000000.

[08:21:45] >> mysql_real_escape_string( Connection handle: 1 )

[08:21:45] CMySQLHandler::EscapeString(-1161.000000); - Escaped 12 characters to -1161.000000.

[08:21:45] >> mysql_query( Connection handle: 1 )

[08:21:45] CMySQLHandler::Query(UPDATE players SET pSHealth='0.000000',pHealth='100.000000',pArmour='0.000000',Inte=0,Local=255,Team=3,Model=264,PhoneNr=8608,House=255,Car1=0,Car2=0,Car3=0,Car4=0,Bizz=255,Pos_x='2246.000000',Pos_y='-1161.000000' WHERE id=1) - An error has occured. (Error ID: 1054, Unknown column 'Car1' in 'field list')

[08:21
si OnPlayerUpdate
Код:
 
public OnPlayerUpdate(playerid) // by Luk0r v1.2
{
	if(IsPlayerConnected(playerid))
	{
		if(gPlayerLogged[playerid])
		{
			MySQLCheckConnection();
			new query[MAX_STRING];
			format(query, MAX_STRING, "UPDATE players SET ");
			MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "Password", PlayerInfo[playerid][pKey]);
	                //order code
		}
	}
	return 1;
}
Код:
public MySQLUpdatePlayerInt(query[], sqlplayerid, sqlvalname[], sqlupdateint) // by Luk0r
{
	MySQLUpdateBuild(query, sqlplayerid);
	new updval[64];
	format(updval, sizeof(updval), "%s=%d", sqlvalname, sqlupdateint);
	strcat(query, updval, MAX_STRING);
	return 1;
}

public MySQLUpdatePlayerFlo(query[], sqlplayerid, sqlvalname[], Float:sqlupdateflo) // by Luk0r
{
/*	new query[128];
	format(query, sizeof(query), "UPDATE players SET %s=%f WHERE id=%d", sqlvalname, sqlupdateflo, sqlplayerid);
	mysql_query(query);*/
	new flotostr[32];
	format(flotostr, sizeof(flotostr), "%f", sqlupdateflo);
	MySQLUpdatePlayerStr(query, sqlplayerid, sqlvalname, flotostr);
	return 1;
}

public MySQLUpdatePlayerStr(query[], sqlplayerid, sqlvalname[], sqlupdatestr[]) // by Luk0r
{
	MySQLUpdateBuild(query, sqlplayerid);
	new escstr[128];
	new updval[128];
	//samp_mysql_real_escape_string(sqlupdatestr, escstr);
	mysql_real_escape_string(sqlupdatestr, escstr);
	format(updval, sizeof(updval), "%s='%s'", sqlvalname, escstr);
	strcat(query, updval, MAX_STRING);
	return 1;
}
another suggest to script OnPlayerUpdate ? can someone help me to fix the problem (to not recur Query(UPDATE players SET ...) )

must substitute return 1 with something else? or MySQLUpdateFinish(query, PlayerInfo[playerid][pSQLID]); .. because there's a bug which is repeated over 20 times OnPlayerUpdate ..
Find
Reply
Johnny_Xayc
Huge Clucker
****
Posts: 422
Threads: 14
Joined: Aug 2009
Reputation: 0
#2

30.11.2010, 17:32
Delete All This code's,and write new code's,this all shit because every function have 1-2 query to MySQL DB,1 player =~100 Enum positions => 200 Query's to MySQL o.k. 20 players *~200 query's = 400 query's

in my code's one player = one query and don't use OnPlayerUpdate
create
pawn Код:
static stock SavePlayer(playerid)
{
// your code
return true;
}
}
Find
Reply
Emanuelll
Big Clucker
***
Posts: 88
Threads: 3
Joined: Feb 2010
Reputation: 0
#3

30.11.2010, 18:54
it's ok if I do something like?
Код:
 forward OnPlayerUpdateEx(playerid)
public OnPlayerUpdateEx(playerid)
{
//some codes
format(query, sizeof(query), "UPDATE players SET Password='%s' WHERE id=%d", PlayerInfo[playerid][pKey], PlayerInfo[playerid][pSQLID]);
			mysql_query(query);
			format(query, sizeof(query), "UPDATE players SET PlayerLevel='%d' WHERE id=%d", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pSQLID]);
			mysql_query(query);

// other codes
return 1;
}
or something same with:
Код:
 forward OnPlayerUpdateEx(playerid)
public OnPlayerUpdateEx(playerid)
{
//some codes
format(query, sizeof(query), "UPDATE players SET Password='%s', PlayerLevel='%d' WHERE id=%d", PlayerInfo[playerid][pKey], PlayerInfo[playerid][pLevel],,PlayerInfo[playerid][pSQLID]);
			mysql_query(query);
// other codes
return 1;
}
Find
Reply
Johnny_Xayc
Huge Clucker
****
Posts: 422
Threads: 14
Joined: Aug 2009
Reputation: 0
#4

01.12.2010, 09:01
Код:
stock OnPlayerUpdateEx(playerid)
{
//some codes
format(query, sizeof(query), "UPDATE `players` SET Password='%s', PlayerLevel=%d WHERE id=%d", 
PlayerInfo[playerid][pKey], 
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pSQLID]);
mysql_query(query);
mysql_free_result();
// other codes
return 1;
}
Use
Find
Reply
Emanuelll
Big Clucker
***
Posts: 88
Threads: 3
Joined: Feb 2010
Reputation: 0
#5

11.12.2010, 12:41
Thank You, the problem was at OnPlayerLogin ... i solved it!

Thank You!
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Help Archive