GPCI MYSQL Help.
#1

Hello i have problem with GPCI. I added everything but now when i go in game, and after i register the spawn dialog won't appear.

PHP Code:
    //Settings
    
native                         WP_Hash(buffer[], len, const str[]);
    
native gpci(playeridserial[], len);
    
#define                         HOLDING(%0)                         ((newkeys & (%0)) == (%0))
    #define                         RELEASED(%0)                        (((newkeys & (%0)) != (%0)) && ((oldkeys & (%0)) == (%0))) 
PHP Code:
enum PlayerData
{
    
//MySQL
    
Logged,
    
Registered,
    
AutoLogin,
    
ID,
    
PlayerName[MAX_PLAYER_NAME],
    
Password[129],
    
IP[16],
    
Email[35],
    
Serial[64], 
PHP Code:
 mysql_tquery(mysql"CREATE TABLE IF NOT EXISTS `playersdata` (\
        `ID` int(11) NOT NULL AUTO_INCREMENT,\
        `PlayerName` varchar(25) NOT NULL,\
        `Password` varchar(129) NOT NULL,\
        `IP` varchar(17) NOT NULL,\
        `Email` varchar(35) NOT NULL,\
        `Serial` varchar(64) NOT NULL,\
        `Online` int(5) NOT NULL default 0,\ 
PHP Code:
stock PlayerSerial(playerid)
{
    new 
serial[64];
    
gpci(playerid,serialsizeof(serial));
    return 
serial;

PHP Code:
 case DIALOG_EMAIL: {
            if(!
response) return ShowPlayerDialog(playeridDIALOG_EMAILDIALOG_STYLE_INPUT"Email""{FFFFFF}Please enter your email address below:""Register""");
            else if(
response) {
                if(
isnull(inputtext)) return ShowPlayerDialog(playeridDIALOG_EMAILDIALOG_STYLE_INPUT"Email""{FFFFFF}Please enter your email address below:""Register""");
                if(!
IsValidEmail(inputtext)) return ShowPlayerDialog(playeridDIALOG_EMAILDIALOG_STYLE_INPUT"Email""{FF0000}Invalid email address!\n\n{FFFFFF}Please enter your email address below:""Register""");
                
format(Info[playerid][Email], 35inputtext);
                new 
query[324], yearc_monthday;
                
getdate(yearc_monthday);
                new 
month[15];
                switch (
c_month) {
                    case 
1month "January";
                    case 
2month "Feburary";
                    case 
3month "March";
                    case 
4month "April";
                    case 
5month "May";
                    case 
6month "June";
                    case 
7month "July";
                    case 
8month "August";
                    case 
9month "September";
                    case 
10month "October";
                    case 
11month "November";
                    case 
12month "December";
                }
                new 
register_on[25];                //Ex: 13 July, 2017
                
format(register_onsizeof(register_on), "%02d %s, %d"daymonthyear);
                
mysql_format(mysqlquerysizeof(query),"INSERT INTO `playersdata` (PlayerName, Password, IP, RegisteredOn, Email, Serial) VALUES ('%e', '%e', '%e', '%e', '%e','%e')"GetName(playerid), Info[playerid][Password], Info[playerid][IP], register_onInfo[playerid][Email], PlayerSerial(playerid));
                
mysql_tquery(mysqlquery"OnAccountRegister""i"playerid);
            }
        } 
PHP Code:
 cache_get_value_name(0"Serial"PlayerSerial(playerid), 64); 
Reply
#2

Bumb
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)