Strings in strcat - MySQL
#1

Sorry that I have been needing help with soo much stuff for the past few days.. been trying to convert a full script to MySQL with no understanding of it :/ Retarded I know.. but been stuck on this for ages! Can someone give me some help.. <3

I will upload the full function..

Код:
stock MySQL_Register(playerid, passwordstring[])
{
    new query[ 3584 ], pname[24];
//=============================[String Variable defines]
	new jailr[20], banr[20], whobanedme[25], whenigotbaned[25], Headby[25], City[20], Married[25], Family[20], Faction[20], PteamName[10],
	Job[10], Rankname[17];
	format(jailr, 20, "Not Jailed");
	format(banr, 20, "Not Banned");
	format(whobanedme, 25, "NoBodY");
	format(whenigotbaned, 25, "NoBodY");
	format(Headby, 25, "NoBodY");
	format(City, 20, "San Fierro");
	format(Married, 25, "NoBodY");
	format(Family, 20, "No Family");
	format(Faction, 20, "No Faction");
	format(PteamName, 10, "No Team");
	format(Job, 10, "No Job");
	format(Rankname, 17, "No Rank");
    GetPlayerName(playerid, pname, 24);
//=====================================
 	strcat(query, "INSERT INTO playerdata(user, password, bank, money, playerlvl, rpoints, playertime, jail, jailreason, jailtime, banned, banreason,");
	strcat(query, "whobannedme, whenigotbanned, Skin, ranklvl, rentprice,driverlic, flylic, boatlic, weplic, jobtime, jobskill, totalpayt,");
	strcat(query, "kills, deaths, housenum, loan, drugs, sdrugs, nreports, power, spawnX, spawnY, spawnZ, spawnZ, spawnInter,");
	strcat(query, "premiumexpire, playerteam, playerBarrierKeys, radio, freq1, freq2, freq3, tutorial, tbanned, city, married, family,");
	strcat(query, "faction, PTeamName, job, totalrules, fpay, warns, helper, curfreq, rankname, pdspawn, phonechanges, lastonline)");
	strcat(query, " VALUES ('%s', SHA1('%s'), 0, 10000, 1, 0, 0, 0, '%s', 0, 0, '%s', '%s', 7, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, '%s', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '%s', '%s', '%s', '%s', '%s', '%s', 0, 0 )", pname, passwordstring, jailr, banr, whobanedme, whenigotbaned, Headby, City, Married, Family, Faction, PteamName, Job, Rankname);
//=====================================
	mysql_query(query);
    SendClientInfo(playerid, "Congradulations, you have now registed. You will be spawned at SF train Station");
    PLAYERLIST_authed[playerid]=true;
    return 1;
}
Код:
: error 035: argument type mismatch (argument 3)
Reply


Messages In This Thread
Strings in strcat - MySQL - by Brandon_More - 06.11.2013, 22:45
Re: Strings in strcat - MySQL - by Jefff - 06.11.2013, 22:48
Re: Strings in strcat - MySQL - by Brandon_More - 06.11.2013, 23:06
Re: Strings in strcat - MySQL - by Jefff - 06.11.2013, 23:35
Re: Strings in strcat - MySQL - by Brandon_More - 06.11.2013, 23:44
Re: Strings in strcat - MySQL - by Jefff - 07.11.2013, 00:04
Re: Strings in strcat - MySQL - by Brandon_More - 07.11.2013, 02:02

Forum Jump:


Users browsing this thread: 1 Guest(s)