MySQl Register Problem
#1

i did this

pawn Код:
#define SQL_HOST "mysql15.000webhost.com"
#define SQL_USER "a7402147_urcnr"
#define SQL_PASS "****************"
#define SQL_DB "a7402147_urcnr"

i add at the top of script #define reg 15000
pawn Код:
if(dialogid == reg)
    {
        new Query[3000];
        if(!response){
        Quited[playerid] = 1;
        Kick(playerid);
        return 1;
        }

        if(strlen(inputtext) <= 5){
        ShowPlayerDialog(playerid,reg,DIALOG_STYLE_INPUT,"{FF0000}Registeration","{FFFFFF}Password Must Be Than More Than 5 Charcters","Register","Quit");
        return 1;
        }

        if(strlen(inputtext) == 0){
        ShowPlayerDialog(playerid,reg,DIALOG_STYLE_INPUT,"{FF0000}Registeration","{FFFFFF}You Did not enter password!\nPlease enter password below to register","Register","Quit");
        return 1;
        }
        new pip[30];
        new playerip = GetPlayerIp(playerid,pip,30);
        format(Query,sizeof(Query),"INSERT INTO playerdata (name,password,playerIP,score,money,warnings,nameban,jailed,jailtime,raperrank,arrestrank,dragpoints,pvtlaw,armyranks,tazeranks,hitmanrank,takeddownrank,weapsdealer,salesdealer,medicrank,mechanicrank,cashinsured,canusearmy,canuseswat,armycommander,swatcommander,adminlevel,RegAsAdmin,presdient,RegularPlayer) VALUES ('%s','%s','%d',0,2500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)",PlayerName(playerid),inputtext,playerip);
        mysql_query(Query);
        SendClientMessage(playerid,COLOR_GREEN,"Congratulation! You have created own account have fun in our server!");
        PLAYERLIST_reg[playerid]=true;
        PLAYERLIST_authed[playerid] =false;
    }


When i go ingame its show me register dialog but when i register nothing happend in mysql database myname file doesn't go there ...
Reply
#2

Put
pawn Код:
mysql_debug(1);
under OnGameModeInit then restart your script, go through the register dialog, and then post the contents of your mysql log file in your server directory.

EDITED: Wrong thing.
Reply
#3

Its give me error on the line of mysql_log(1); accept my email request so it will be easy on you to help me please!
Reply
#4

My Email is; weh0@live.com add me please
Reply
#5

its not also work on the localhost pleas help!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)