Mysql RegDate
#6

i have now

Код:
mysql_query("CREATE TABLE IF NOT EXISTS playerinfo(user VARCHAR(24), password VARCHAR(400),killss INT(20),deaths INT(20), score INT(20), money INT(20), IP VARCHAR(16),adminlvl INT(5),hoursplayed INT(20), minutesplayed INT(20),ratio VARCHAR(5),regdate VARCHAR(10))");
	mysql_debug(1);
and in the register:

Код:
           	new year, month, day;
			getdate(year, month, day);
            mysql_real_escape_string(inputtext, escpass);
			WP_Hash(largestring, sizeof(largestring), escpass);
            GetPlayerIp(playerid, PIP, 50);
            format(Query, sizeof(Query), "INSERT INTO `playerinfo` (`user`, `password`, `killss`, `deaths`, `score`, `money`, `IP`, `adminlvl`,`ratio`, `regdate`) VALUES ('%s', '%s', 0, 0, 0, 0, '%s', 0,'%f','%s','%d/%d/%d')", escpname(playerid), largestring, PIP,(Float:PlayerInfo[playerid][killss] / Float:PlayerInfo[playerid][deaths]),day,month,year);
            mysql_query(Query);
what is wrong, before the getdate script, It was working 100 percent
Reply


Messages In This Thread
Mysql RegDate - by SanAndreasVille - 22.04.2012, 18:59
Re: Mysql RegDate - by Yako - 22.04.2012, 21:16
Re: Mysql RegDate - by SanAndreasVille - 22.04.2012, 21:28
Re: Mysql RegDate - by Yako - 22.04.2012, 22:19
Re: Mysql RegDate - by SanAndreasVille - 23.04.2012, 13:26
Re: Mysql RegDate - by SanAndreasVille - 23.04.2012, 16:00
Re: Mysql RegDate - by Claude - 23.04.2012, 16:28
Re: Mysql RegDate - by SanAndreasVille - 23.04.2012, 17:07
Re: Mysql RegDate - by AndreT - 23.04.2012, 17:21
Re: Mysql RegDate - by SanAndreasVille - 23.04.2012, 19:03

Forum Jump:


Users browsing this thread: 3 Guest(s)