[Pagalbos] MySql

[JGDesigns]

Darau nuo new.pwn ir iškilo bėda:

C:\Users\Ziogus\Desktop\MidNight.LT\gamemodes\MidNight.pwn(59) : error 017: undefined symbol "DbHandle"
C:\Users\Ziogus\Desktop\MidNight.LT\gamemodes\MidNight.pwn(78) : error 017: undefined symbol "pInfo"
C:\Users\Ziogus\Desktop\MidNight.LT\gamemodes\MidNight.pwn(78) : warning 215: expression has no effect
C:\Users\Ziogus\Desktop\MidNight.LT\gamemodes\MidNight.pwn(78) : error 001: expected token: ";", but found "]"
C:\Users\Ziogus\Desktop\MidNight.LT\gamemodes\MidNight.pwn(78) : error 029: invalid expression, assumed zero
C:\Users\Ziogus\Desktop\MidNight.LT\gamemodes\MidNight.pwn(78) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664              Copyright (c) 1997-2006, ITB CompuPhase


5 Errors.

Jei atsiras žmonių kurie padės atsidėkosiu.

 

Visos eilutės

// This is a comment
// uncomment the line below if you want to write a filterscript
//#define FILTERSCRIPT

#include <a_samp>
#include <a_mysql>

#if defined FILTERSCRIPT

#define DIALOG_REGISTER 1
#define DIALOG_LOGIN 2

enum playerinfo
{
	ORM:ORM_ID,
	SQL_ID,
	Name[MAX_PLAYER_NAME],
	Password[129],
	Money,
	Xp,
	AdminLvl,
	Float:SpawnX,
	Float:SpawnY,
	Float:SpawnZ
};

new pInfo[MAX_PLAYERS][playerinfo]; //Sukuriame dviejų dimensijų masyvą: pirma dimensija su dalimis kiekvienam žaidėjui, antra su "playerinfo" enum dalimis.

new DbHandle; // Kintamasis kad atskirtume mysql prisijungimus.

public OnFilterScriptInit()
{
	print("\n--------------------------------------");
	print(" Blank Filterscript by your name here");
	print("--------------------------------------\n");
	return 1;
}

public OnFilterScriptExit()
{
	return 1;
}

#else

main()
{
	print("\n----------------------------------");
	print(" Blank Gamemode by your name here");
	print("----------------------------------\n");
}

#endif

public OnGameModeInit()
{
	SetGameModeText("Blank Script");
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
	mysql_log();
	DbHandle = mysql_connect("localhost","root","testas","");
	return 1;
}

public OnGameModeExit()
{
	return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
	SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
	return 1;
}

public OnPlayerConnect(playerid)
{
	GetPlayerName(playerid,pInfo[playerid][Name],24);
	pInfo[playerid][ORM_ID] = orm_create("zaidejai",DbHandle);
	orm_addvar_int(pInfo[playerid][ORM_ID],pInfo[playerid][SQL_ID],"SQL_ID");
	orm_addvar_string(pInfo[playerid][ORM_ID],pInfo[playerid][Name],24,"Name");
	orm_addvar_string(pInfo[playerid][ORM_ID],pInfo[playerid][Password],129,"Password");
	orm_addvar_int(pInfo[playerid][ORM_ID],pInfo[playerid][Money],"Money");
	orm_addvar_int(pInfo[playerid][ORM_ID],pInfo[playerid][Xp],"Xp");
	orm_addvar_int(pInfo[playerid][ORM_ID],pInfo[playerid][AdminLvl],"AdminLvl");
	orm_addvar_float(pInfo[playerid][ORM_ID],pInfo[playerid][SpawnX],"SpawnX"); 
	orm_addvar_float(pInfo[playerid][ORM_ID],pInfo[playerid][SpawnY],"SpawnY");
	orm_addvar_float(pInfo[playerid][ORM_ID],pInfo[playerid][SpawnZ],"SpawnZ");
	orm_setkey(pInfo[playerid][ORM_ID],"Name");
	orm_select(pInfo[playerid][ORM_ID],"OnPlayerCheck","d",playerid);
}

	forward OnPlayerCheck(playerid);
	public OnPlayerCheck(playerid)
	{
	switch(orm_errno(pInfo[playerid][ORM_ID]))
	{
	case ERROR_OK: ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Prisijungimas","Įveskite savo slaptažodį žemiau","Prisijungti","Išeiti");
	case ERROR_NO_DATA: ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Registracija","Įvesktie savo slaptažodį žemiau","Registruotis","Išeiti");
	}
	orm_setkey(pInfo[playerid][ORM_ID],"SQL_ID");
	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
	return 1;
}

public OnPlayerSpawn(playerid)
{
	return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
	return 1;
}

public OnVehicleSpawn(vehicleid)
{
	return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
	return 1;
}

public OnPlayerText(playerid, text[])
{
	return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
	if (strcmp("/mycommand", cmdtext, true, 10) == 0)
	{
		// Do something here
		return 1;
	}
	return 0;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
	return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
	return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
	return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
	return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
	return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
	return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
	return 1;
}

public OnRconCommand(cmd[])
{
	return 1;
}

public OnPlayerRequestSpawn(playerid)
{
	return 1;
}

public OnObjectMoved(objectid)
{
	return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
	return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
	return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
	return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
	return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
	return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
	return 1;
}

public OnPlayerExitedMenu(playerid)
{
	return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
	return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
	return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
	return 1;
}

public OnPlayerUpdate(playerid)
{
	return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
	return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
	return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
	return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
	return 1;
}

public OnDialogResponse(playerid,dialogid,response,listitem,inputtext[])
	{
	if(dialogid == DIALOG_REGISTER) // Jeigu tai regsitracijos lentelė
	{
	if(!response) return Kick(playerid); // Jeigu paspaudė "Išeiti", išmetame jį lauk.
	if(strlen(inputtext) < 6) // Jeigu įvesto slaptažodis trumpesnis už 6.
	{
	SendClientMessage(playerid,-1,"Slaptažodį turi sudaryti bent 6 simboliai");
	ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Registracija","Įvesktie savo slaptažodį žemiau","Registruotis","Išeiti");
	return 1;
	}
	strins(pInfo[playerid][Password],inputtext,0); // Įrašom į kintamajį "pInfo[playerid][Password]" žaidėjo slaptažodį.
	orm_insert(pInfo[playerid][ORM_ID],"OnPlayerRegister","d",playerid); // Įrašome į lentelę naują eilutę skirta žaidėjui.
	return 1;
	}
	else if(dialogid == DIALOG_LOGIN) // Jeigu tai prisijungimo lentelė.
	{
	if(!response) return Kick(playerid); // Jeigu žaidėjas paspaudė "Išeiti" - išmetam.
	if(strlen(inputtext) < 6)
	{
	SendClientMessage(playerid,-1,"Slaptažodį turi sudaryti bent 6 simboliai");
	ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Prisijungimas","Įveskite savo slaptažodį žemiau","Prisijungti","Išeiti");
	return 1;
	}
	if(!strcmp(pInfo[playerid][Password],inputtext)) //Jeigu įvestas slaptažodis yra lygus įrašytam duomenų bazėje(jau užkrautas jis buvo, prisijungiant)
	{
	SendClientMessage(playerid,-1,"Sėkmingai prisijungėte, gero žaidimo!");
	return 1;
	}
	else SendClientMessage(playerid,-1,"Slaptažodis neteisingas");
	}
	return 0;
	}
	forward OnPlayerRegister(playerid);
	public OnPlayerRegister(playerid)
	{
	if(orm_errno(pInfo[playerid][ORM_ID]) == ERROR_OK) // Jeigu nebuvo klaidų siunčiant užklausą.
		{
		SendClientMessage(playerid,-1,"Registracija sėkminga! Gero žaidimo");
		}
	return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
	return 1;
}

Redaguota Gruodžio 18, 2014, nario KenjiWorks™

[bebras]

Kaip supratau darei pagal mano pamoką. Jei taip, praleidai šią dalį: 

enum playerinfo { // Sukuriame enum.
    ORM:ORM_ID, // Tai ID kuriuo plugin atskirs kieno duomenis įrašinėti, todėl tai svarbu.
    SQL_ID,
    Name[MAX_PLAYER_NAME],
    Password[129],
    Money,
    Xp,
    AdminLvl,
    Float:SpawnX,
    Float:SpawnY,
    Float:SpawnZ
};
new pInfo[MAX_PLAYERS][playerinfo]; //Sukuriame dviejų dimensijų masyvą: pirma dimensija su dalimis kiekvienam žaidėjui, antra su "playerinfo" enum dalimis.

new DbHandle; // Kintamasis kad atskirtume mysql prisijungimus.

[JGDesigns]

Yra šitas bet meta Error.

Redaguota. 2014-12-18

Niekas nepadės?