Mysql noob and confusing question...

Mysql noob and confusing question... - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Mysql noob and confusing question... (/showthread.php?tid=217023)

Mysql noob and confusing question... - DRIFT_HUNTER - 26.01.2011

Well since im making new server (from scratch)i think to much about optimizing register/login system
Well i want to make good register/login base that will be easy to edit+it will work fast
Im kinda stuck with these...
How i can get SOMETHING from Sql and check it in SAMP server?

pawn Код:

format(Query,sizeof(Query),"SELECT 'IP' FROM `Users` WHERE `User` = '%s'",pName);
    mysql_query(Query);
    mysql_store_result();

And i dont want to use it like: select user from bla,bla where is ip = user ip and check is there any rows...

Re: Mysql noob and confusing question... - DRIFT_HUNTER - 27.01.2011

Bump...

Re: Mysql noob and confusing question... - 1337connor - 27.01.2011

pawn Код:

new Data[256];
mysql_fetch_row_format(Data,"|");
sscanf(Data,"p<|>s[56]",PlayerInfo[playerid][IP]); // What ever the IP String is.