Jump to content

Virtue

Members
  • Content Count

    259
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by Virtue


  1. Hi,

     

    since sql concerns about db, i have a question,

     

    is Hercules sql files the same as rathena's?

    no harmony(3.3.12) support for hercules as of the moment i may use rathena then migrate to hercules when daniel is back.

     

    PS : 

    I don't know if this is the right section to post this but, if i did it wrong I am sorry.


  2. trinity,113,84,3	script	Compensation NPC	715,{query_sql("SELECT `last_mac` FROM `login` WHERE `account_id`="+getcharid(3), .@vmacp$);query_sql("SELECT day FROM `virtue_promo` WHERE `last_mac`='"+escape_sql(.@vmacp$ )+"'", .@vmacp2$,.@Dayb);if(query_sql("SELECT day,account_id FROM `virtue_promo` WHERE `day`='"+gettime(4)+"' AND `account_id`='"+getcharid(3)+"'")) {	dispbottom "Your already received the items for Today.";	end;} else if (query_sql("SELECT last_mac,day FROM `virtue_promo` WHERE `last_mac`='"+escape_sql(.@vmacp$ )+"' AND `day`='"+gettime(4)+"'")) {	dispbottom "Your Computer is already registered at our logs. Please Do Not Abuse this System";	end;} else if(.@Dayb != gettime(4)){		query_sql "INSERT INTO `virtue_promo` (last_mac,day,account_id) VALUES ('"+escape_sql(.@vmacp$ )+"','"+gettime(4)+"','"+getcharid(3)+"')";		getitem 14609,100;		getitem 12214,20;		getitem 30034,20;		getitem 30020,10;		dispbottom "Enjoy!.";		end;		}} 

    Hi. this script works fine, but after sometime, something went wrong. nothing is shown at the map_server, but it does not query the sql_queries, i've tried removing all the queries and it works.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.