acquiring items via auto mail

[joelolopez]

i would like to request a script that will give you a random item on first login once a day , u will be able to receive random items attached on your mail...  

 

for example: 

                from: Admins

                bla bla bla bla bla

 

 

              <attached item>

 

is this possible?

Edited November 1, 2013 by joelolopez

[LuLu]

possible.just make a script that will run once a day per login and write down a mail via sql.

[joelolopez]

thanks for the reply but wat u did is you just confirmed it that its possible, im still requesting a script on how to mail an item to players in their first login once a day, how am i suppose to do with the sqls i dont have knowledge about sqls so far...

[LuLu]

Sorry don't have much time to do this npc and to think about the whole script. This is time consuming. Sorry, but I think this can be done via

query_sql("INSERT INTO `mail` ("modifications/actions here..........");

just select your sql info and start adding items like

query_sql("SELECT account_id,char_id FROM ...... = variables here....")

Sorry xD

[Patskie]

Refer to query_sql for the syntax : 

-    script    Sample    -1,{
    OnPCLoginEvent:
        if ( gettimetick(2) < #timer )
            dispbottom "Time left : " + ( #timer - gettimetick(2) ) + " seconds.";
        else {
            // .. your insert query_sql
            #timer = gettimetick(2) + 86400;
        }
        end;
}