[[DOG]irinel1996]

Thank you man, you helped me.
sscanf helps anywhere. :O Hehe...

[[Nikk]]

SQL = shit, im still prefer Dini or Y_ini. It's more easy to use. And its the same for me.

[[DOG]irinel1996]

Quote:

Originally Posted by Nikk123 SQL = shit, im still prefer Dini or Y_ini. It's more easy to use. And its the same for me.

MySQL is faster, and now, for me it's easier.

[FireCat]

Quote:

Originally Posted by Nikk123 SQL = shit, im still prefer Dini or Y_ini. It's more easy to use. And its the same for me.

Why are you refering shit with preferences? -.-
Think.
SQL is better for some stuff, Dini isn't good for anything, and Y_Ini has it's goodies.

[FarSe.]

Quote:

Originally Posted by Nikk123 SQL = shit, im still prefer Dini or Y_ini. It's more easy to use. And its the same for me.

SQL is used by government institutes,webs,hosts,even your account is stored with SQL so SQL isn't a shit.
__
By the way,nice tutorial

[[Nikk]]

It's only what i think, sorry if dont like to you guys, but when i start with pawno im using Dini. Now I have a habit of using.
and shit is a way of saying, dont take as bad.
Sry for my bad english

[Konstantinos]

Quote:

Originally Posted by [Nikk] It's only what i think, sorry if dont like to you guys, but when i start with pawno im using Dini. Now I have a habit of using. and shit is a way of saying, dont take as bad. Sry for my bad english

When I started I was using Dini too because it was the easier. Then I learnt y_ini and I change the whole Gamemode to y_ini. Although, I ended using SQLite. Databases are amazing. I wanted to leant MySQL too but I got some problems with phpMyAdmin and with Web host, so I stopped there. Just the Dini is outdated.

[FireCat]

Quote:

Originally Posted by Jochemd Why don't you use mysql_format?

dafuq? I made this a few months ago... <.< Like in october 2011
But I posted it in december 2011.

[fadhilkab]

Nice

[logoster]

nice but what about adding an admin level and what format for admin cmds?

[SwiftKidZ]

This is amazing

[vIBIENNYx]

I keep getting these errors:

pawn Код:

C:\Users\Ben\Desktop\SF-RP\gamemodes\bensamp.pwn(939) : error 017: undefined symbol "Regdialog"
C:\Users\Ben\Desktop\SF-RP\gamemodes\bensamp.pwn(954) : error 017: undefined symbol "Logindialog"
C:\Users\Ben\Desktop\SF-RP\gamemodes\bensamp.pwn(958) : error 017: undefined symbol "Regdialog"
Pawn compiler 3.2.3664          Copyright (c) 1997-2006, ITB CompuPhase


3 Errors.

Cant find anything in the main post to fix this.

[Mustang[GTS]]

i Always Getting this errors

Код:

C:\Users\Wietse\Desktop\server bugge\pawno\new.pwn(64) : error 010: invalid function or declaration
C:\Users\Wietse\Desktop\server bugge\pawno\new.pwn(66) : error 010: invalid function or declaration
C:\Users\Wietse\Desktop\server bugge\pawno\new.pwn(70) : error 010: invalid function or declaration
C:\Users\Wietse\Desktop\server bugge\pawno\new.pwn(73) : error 021: symbol already defined: "mysql_real_escape_string"
C:\Users\Wietse\Desktop\server bugge\pawno\new.pwn(103) : error 010: invalid function or declaration
C:\Users\Wietse\Desktop\server bugge\pawno\new.pwn(105) : error 010: invalid function or declaration
C:\Users\Wietse\Desktop\server bugge\pawno\new.pwn(109) : error 010: invalid function or declaration
C:\Users\Wietse\Desktop\server bugge\pawno\new.pwn(111) : error 021: symbol already defined: "LoginPlayer"
C:\Users\Wietse\Desktop\server bugge\pawno\new.pwn(123) : error 001: expected token: ";", but found "stock"
C:\Users\Wietse\Desktop\server bugge\pawno\new.pwn(311) : warning 203: symbol is never used: "EscapedText"
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


9 Errors.

[PawnFox]

Hello, i've read this tutorial and i copy it in Pawn. When i compile i recive the following errors:

Код:

C:\Documents and Settings\Unlimited\Desktop\MySQL.pwn(198) : error 028: invalid subscript (not an array or too many subscripts): "pInfo"
C:\Documents and Settings\Unlimited\Desktop\MySQL.pwn(198) : warning 215: expression has no effect
C:\Documents and Settings\Unlimited\Desktop\MySQL.pwn(198) : error 001: expected token: ";", but found "]"
C:\Documents and Settings\Unlimited\Desktop\MySQL.pwn(198) : error 029: invalid expression, assumed zero
C:\Documents and Settings\Unlimited\Desktop\MySQL.pwn(198) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


4 Errors.

The code is the following:

pawn Код:

stock LoadStats(playerid)
{
    new
        pName[24],
        Query[80]
    ;
    
    GetPlayerName(playerid, pName, sizeof (pName));
    format(Query, sizeof(Query), "SELECT * FROM `Users` WHERE `Username` = '%s' ", pName);
    mysql_query(Query);
    mysql_store_result();
    mysql_fetch_row_format(Query, "|");
    sscanf( Query, "e<p<|>s[24]s[23]i>", pInfo[playerid] );
    mysql_free_result();
    GivePlayerMoney(playerid,PInfo[playerid][CASH]);
    return 1;
}

Line 198 is: sscanf( Query, "e<p<|>s[24]s[23]i>", pInfo[playerid] );

NOTE: I have included <sscanf>. Whats the problem !??!

Nvm, i found the problem.

Thanks for tut :P

[FireCat]

Quote:

Originally Posted by [V]PawnFox Hello, i've read this tutorial and i copy it in Pawn. When i compile i recive the following errors: Код: C:\Documents and Settings\Unlimited\Desktop\MySQL.pwn(198) : error 028: invalid subscript (not an array or too many subscripts): "pInfo" C:\Documents and Settings\Unlimited\Desktop\MySQL.pwn(198) : warning 215: expression has no effect C:\Documents and Settings\Unlimited\Desktop\MySQL.pwn(198) : error 001: expected token: ";", but found "]" C:\Documents and Settings\Unlimited\Desktop\MySQL.pwn(198) : error 029: invalid expression, assumed zero C:\Documents and Settings\Unlimited\Desktop\MySQL.pwn(198) : fatal error 107: too many error messages on one line Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 4 Errors. The code is the following: pawn Код: stock LoadStats(playerid) {     new         pName[24],         Query[80]     ;         GetPlayerName(playerid, pName, sizeof (pName));     format(Query, sizeof(Query), "SELECT * FROM `Users` WHERE `Username` = '%s' ", pName);     mysql_query(Query);     mysql_store_result();     mysql_fetch_row_format(Query, "|");     sscanf( Query, "e<p<|>s[24]s[23]i>", pInfo[playerid] );     mysql_free_result();     GivePlayerMoney(playerid,PInfo[playerid][CASH]);     return 1; } Line 198 is: sscanf( Query, "e<p<|>s[24]s[23]i>", pInfo[playerid] ); NOTE: I have included <sscanf>. Whats the problem !??! Nvm, i found the problem. Thanks for tut :P

Ups!
Turn that to a capital P "PInfo"

Edit: In the tutorial, its with a capital P

[PawnFox]

xD

Yeah, that was the problem .. i've noticed after i've made the post .

[Zilvinass]

Please help!

Код:

D:\desktop\srv\gamemodes\mysqlla.pwn(77) : error 017: undefined symbol "mysql_query"
D:\desktop\srv\gamemodes\mysqlla.pwn(82) : warning 202: number of arguments does not match definition
D:\desktop\srv\gamemodes\mysqlla.pwn(264) : error 017: undefined symbol "Regdialog"
D:\desktop\srv\gamemodes\mysqlla.pwn(264) : error 017: undefined symbol "cblue"
D:\desktop\srv\gamemodes\mysqlla.pwn(264) : warning 215: expression has no effect
D:\desktop\srv\gamemodes\mysqlla.pwn(264) : warning 215: expression has no effect
D:\desktop\srv\gamemodes\mysqlla.pwn(264) : warning 215: expression has no effect
D:\desktop\srv\gamemodes\mysqlla.pwn(264) : error 001: expected token: ";", but found ")"
D:\desktop\srv\gamemodes\mysqlla.pwn(264) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


5 Errors.

Who can help me? Who helps thank you..

[KingPilot]

Code:

C:\Users\Gubblek\Desktop\Server\gamemodes\Server.pwn(77) : error 017: undefined symbol "dialogid"
C:\Users\Gubblek\Desktop\Server\gamemodes\Server.pwn(79) : error 017: undefined symbol "inputtext"
C:\Users\Gubblek\Desktop\Server\gamemodes\Server.pwn(81) : error 017: undefined symbol "Regdialog"
C:\Users\Gubblek\Desktop\Server\gamemodes\Server.pwn(81) : error 017: undefined symbol "NPUT"
C:\Users\Gubblek\Desktop\Server\gamemodes\Server.pwn(81) : error 017: undefined symbol "cblue"
C:\Users\Gubblek\Desktop\Server\gamemodes\Server.pwn(81) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


6 Errors.

Sorry Im new on this.. What have i got to do here?

[DJTunes]

I need help:
I have an error on line 83 and the error says this:

Code:

C:\Users\Zach\Desktop\SA-MP SERVER\IW.pwn(83) : error 037: invalid string (possibly non-terminated string)
C:\Users\Zach\Desktop\SA-MP SERVER\IW.pwn(83) : error 017: undefined symbol "YourDatabaseName"
C:\Users\Zach\Desktop\SA-MP SERVER\IW.pwn(83) : error 029: invalid expression, assumed zero
C:\Users\Zach\Desktop\SA-MP SERVER\IW.pwn(83) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


4 Errors.

This is what I have on that line:

Code:

mysql_connect(mysql_host,mysql_user,mysql_database ,mysql_password)

See anything wrong?

[kamzaf]

Quote:

Originally Posted by DJTunes I need help: I have an error on line 83 and the error says this: Code: C:\Users\Zach\Desktop\SA-MP SERVER\IW.pwn(83) : error 037: invalid string (possibly non-terminated string) C:\Users\Zach\Desktop\SA-MP SERVER\IW.pwn(83) : error 017: undefined symbol "YourDatabaseName" C:\Users\Zach\Desktop\SA-MP SERVER\IW.pwn(83) : error 029: invalid expression, assumed zero C:\Users\Zach\Desktop\SA-MP SERVER\IW.pwn(83) : fatal error 107: too many error messages on one line Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 4 Errors. This is what I have on that line: Code: mysql_connect(mysql_host,mysql_user,mysql_database ,mysql_password) See anything wrong?

is this line properly indented at the top:

pawn Code:

#define mysql_database "YourDatabaseName"