Little help with Auto create table

Little help with Auto create table - 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)
+--- Thread: Little help with Auto create table (/showthread.php?tid=541897)

Little help with Auto create table - kbalor - 15.10.2014

Hi. Could someone please help me with this. how to create a table from phpmyadmin?

Here is the useful data needed to create to be able to make a player registration.

PHP код:



getdate(year,month,day);

gettime(hour,minute,second);

format(TempQuery, sizeof TempQuery,"INSERT INTO `"Users_Table"` (Username, Password, IP, Money, Score, Level, NitroType, Autofix, Fightstyle, SkinID, SB, AcceptPM, Kills, Deaths, Hours, Mins, Goto, Regged, LastOn) VALUES ('%s', sha1('%s'), '%s', '%i', '%i', '0', '0', '0', '0', '-1', '1', '1', '%i', '%i', '0', '0', '%i', '%02d.%02d.%02d','%02d.%02d.%02d at %02d:%02d:%02d')",

GetPName(playerid),szPass,PIP,GetPlayerMoney(playerid),GetPlayerScore(playerid), PInfo[playerid][Kills],PInfo[playerid][Deaths],

 PInfo[playerid][GotoToggle], day,month,year,day,month,year,hour,minute,second);

Because I don't have the dump file of .sql for this. so I have no choice but to make a new one.

Re: Little help with Auto create table - VishvaJeet - 15.10.2014

http://www.w3schools.com/sql/sql_create_table.asp