Jump to content
Autentificarea cu Google și Facebook nu mai este disponibilă. ×
  • 0

SQLite 2 problems...

xxSPEEDYxx

Asked by xxSPEEDYxx,

 Share

Question

xxSPEEDYxx Veteran

xxSPEEDYxx

Posted
Posted

Salls...mam apucat iar de SQLite mia venit asa cheful:))..si mam uitat le vechiul meu proiect..."system de clanuri"

deci vreau sa stiu dc mi se creaza database in scriptfiles da nu pot sa o deschid + ii de 0 kbs...

uitati aici OnFilterScriptInit de unde se face DB...

public OnFilterScriptInit( )
{
	Database = db_open( "Clans.db" );
 	strcat( TableS, "CREATE TABLE IF NOT EXISTS `Clans` ", 420 );
	strcat( TableS, "( `ClanSef` varchar(30), \
					 `ClanName` varchar(40), \
					 `Member1` varchar(30), \
					 `Member2` varchar(30), \
					 `Member3` varchar(30), \
					 `Member4` varchar(30), \
					 `Member5` varchar(30), \
					 `Member6` varchar(30), \
					 `Member7` varchar(30), \
					 `Member8` varchar(30), \
					 `Member9` varchar(30) ", 420 );
	strcat( TableS, "`Member10` varchar(30), \
					 `ClanSkin` INT, \
					 `ClanSefSkin` INT, \
					 `ClanColor` INT, \
					 `Weapon1` INT, \
					 `Weapon2` INT, \
					 `Weapon3` INT, \
					 `Weapon4` INT, \
					 `Weapon5` INT, \
					 `ClanKills` INT, \
					 `ClanDeaths` INT, )", 420 );
 	db_free_result( db_query( Database, TableS ) );
	return 1;
}
asa...dar daca nu dau strcat...tot asa face nu se creaza...ca ii prea lung stringu din ea dar si asa cu strcat nu se face toat nush dc:))... oricum va las pe voi sa vedeti( cei ce stiti ) a doau problema ii de la OnDialogResponse uiati aici: 
if ( dialogid == ClanMemSkin )
	{
		if ( response == 1 )
		{
		    if ( strlen( inputtext ) )
			{
			    if ( IsInvalidSkin ( iputtext ) )
			    {
				    format( Query, sizeof( Query ), "INSERT INTO `Clans` ( `ClanSkin` ) VALUES( '%d' )", inputtext );
				    SetPlayerSkin( playerid, inputtext );
			    	db_query( Database, Query );
			    	db_free_result( db_query( Database, Query ) );
			    	ShowPlayerDialog( playerid, ClanLedSkin, DIALOG_STYLE_INPUT, "Leader Skin","{E60000}========{FFFF00}========{00FF00}========\n{FFFFFF}Please enter the leader skin:\n{E60000}========{FFFF00}========{00FF00}========:","OK","Cancel" );
		    		return 1;
				}
				else return ShowPlayerDialog( playerid, ClanMemSkin, DIALOG_STYLE_INPUT, "Member Skin","ERROR!\nThat you put there is invalid skin!\n{E60000}========{FFFF00}========{00FF00}========\n{FFFFFF}Please enter the member skin:\n{E60000}========{FFFF00}========{00FF00}========:","OK","Cancel" );
			}
		}
	}

...

acolo la SetPlayerSkin( playerid, inputtext ); imi da error asta: error 035: argument type mismatch (argument 2): stiu ca lipseste ceva..dar daca nu dau inputtext...nu i se va seta skinu...

si a doau prob ii la IsInvalidSkin ( inputtext ) )  imi tot aproape aceasi erroare: error 035: argument type mismatch (argument 1)

Fara reclama in semnatura!

5 answers to this question

Recommended Posts

IstuntmanI Grand Master

IstuntmanI

Posted
Posted

Pentru a 2-a problema:

inputtext este original string, deci tu trebuie sa folosesti strval( inputtext ) cand are rol de cifra (integrala, decimala).

xxSPEEDYxx Veteran

xxSPEEDYxx

Posted
  • Author
Posted

mda...am sters strlen( inputtext )...dar cum fac acolo if( IsInvalidSkin ( inputtext ) ca acolo da error si la SetPlayerSkin( playerid, inputtext );...sau acolo nu trebuie inputtext la setplayerskin...sau defapt nici nu trebuie?:))

Fara reclama in semnatura!

IstuntmanI Grand Master

IstuntmanI

Posted
Posted

Deci:

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
se vede clar ca inputtext este string, nu numar, asa ca 
if( IsInvalidSkin ( inputtext ) )
devine 
if( IsInvalidSkin ( strval( inputtext ) ) )
, iar 
SetPlayerSkin( playerid, inputtext );
devine 
SetPlayerSkin( playerid, strval( inputtext ) );

Guest farse

Guest farse

Posted
Posted

Sunt 521 caractere,deci new Tables[522]; ,si nu le pune globale,face .amx mai mare..

new table[522];\ 
strcat(table,"CREATE TABLE IF NOT EXISTS `Clans` \ 
( `ClanSef` varchar(30), \ 
`ClanName` varchar(40), \ 
`Member1` varchar(30), \ 
`Member2` varchar(30), \ 
`Member3` varchar(30), \ 
`Member4` varchar(30), \ 
`Member5` varchar(30),");\ 
strcat(table,"`Member6` varchar(30), \ 
`Member7` varchar(30), \ 
`Member8` varchar(30), \ 
`Member9` varchar(30) ,\ 
`Member10` varchar(30), \ 
`ClanSkin` INT, \ 
`ClanSefSkin` INT, \ 
`ClanColor` INT, ");\ 
strcat(tables,"`Weapon1` INT, \ 
`Weapon2` INT, \ 
`Weapon3` INT, \ 
`Weapon4` INT, \ 
`Weapon5` INT, \ 
`ClanKills` INT, \ 
`ClanDeaths` INT )");

xxSPEEDYxx Veteran

xxSPEEDYxx

Posted
  • Author
Posted

stuntman-=!!" post="82705" timestamp="1309809956"]

Deci:

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
se vede clar ca inputtext este string, nu numar, asa ca 
if( IsInvalidSkin ( inputtext ) )
devine 
if( IsInvalidSkin ( strval( inputtext ) ) )
, iar 
SetPlayerSkin( playerid, inputtext );
devine 
SetPlayerSkin( playerid, strval( inputtext ) );
da ms merge;)
Sunt 521 caractere,deci new Tables[522]; ,si nu le pune globale,face .amx mai mare.. 
new table[522];\ 
strcat(table,"CREATE TABLE IF NOT EXISTS `Clans` \ 
( `ClanSef` varchar(30), \ 
`ClanName` varchar(40), \ 
`Member1` varchar(30), \ 
`Member2` varchar(30), \ 
`Member3` varchar(30), \ 
`Member4` varchar(30), \ 
`Member5` varchar(30),");\ 
strcat(table,"`Member6` varchar(30), \ 
`Member7` varchar(30), \ 
`Member8` varchar(30), \ 
`Member9` varchar(30) ,\ 
`Member10` varchar(30), \ 
`ClanSkin` INT, \ 
`ClanSefSkin` INT, \ 
`ClanColor` INT, ");\ 
strcat(tables,"`Weapon1` INT, \ 
`Weapon2` INT, \ 
`Weapon3` INT, \ 
`Weapon4` INT, \ 
`Weapon5` INT, \ 
`ClanKills` INT, \ 
`ClanDeaths` INT )");
farse asa imi da error la: 
				`Weapon4` INT, \
				`Weapon5` INT, \
asta: 
C:\Documents and Settings\user\My Documents\RAS&MAP&FS&SERVERS\RAS\filterscripts\ccsql.pwn(76) : error 075: input line too long (after substitutions)
C:\Documents and Settings\user\My Documents\RAS&MAP&FS&SERVERS\RAS\filterscripts\ccsql.pwn(77) : error 037: invalid string (possibly non-terminated string)
C:\Documents and Settings\user\My Documents\RAS&MAP&FS&SERVERS\RAS\filterscripts\ccsql.pwn(77) : error 029: invalid expression, assumed zero
C:\Documents and Settings\user\My Documents\RAS&MAP&FS&SERVERS\RAS\filterscripts\ccsql.pwn(77) : warning 215: expression has no effect
C:\Documents and Settings\user\My Documents\RAS&MAP&FS&SERVERS\RAS\filterscripts\ccsql.pwn(77) : error 001: expected token: ";", but found "`"
C:\Documents and Settings\user\My Documents\RAS&MAP&FS&SERVERS\RAS\filterscripts\ccsql.pwn(77) : fatal error 107: too many error messages on one line
eu nu gasesc nimik neinregula acolo nush de la ce poate fii...am mai postat si pe sa-mp.com...acolo mi-a zis unu ca tre sa fie asa: 
Database = db_open( "Clans.db" );
    strcat( TableS, "CREATE TABLE IF NOT EXISTS `Clans` ");
    strcat( TableS, "(`ClanSef` varchar(30), \
                     `ClanName` varchar(40), \
                     `Member1` varchar(30), \
                     `Member2` varchar(30), \
                     `Member3` varchar(30), \
                     `Member4` varchar(30), \
                     `Member5` varchar(30), \
                     `Member6` varchar(30), \
                     `Member7` varchar(30), \
                     `Member8` varchar(30), \
                     `Member9` varchar(30),");
    strcat( TableS, "`Member10` varchar(30), \
                     `ClanSkin` INT, \
                     `ClanSefSkin` INT, \
                     `ClanColor` INT, \
                     `Weapon1` INT, \
                     `Weapon2` INT, \
                     `Weapon3` INT, \
                     `Weapon4` INT, \
                     `Weapon5` INT, \
                     `ClanKills` INT, \
                     `ClanDeaths` INT)");
    db_free_result( db_query( Database, TableS ) );

si o mers...deci cum fac?:))...las asa cum a zis ala sau cum spui tu?:))

Fara reclama in semnatura!

Guest
This topic is now closed to further replies.
 Share
Go to question listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.