Jump to content

  •  

icabit

Member Since 17 Jan 2013
Offline Last Active Oct 17 2016 12:44 AM
-----

Posts I've Made

In Topic: 3 questions regarding AnnieRuru scripts

01 September 2014 - 12:15 PM

a must pin and very educational


In Topic: for improvement

31 August 2014 - 11:30 PM

change

query_sql "SELECT `last_mac` FROM `login` WHERE `account_id`="+getcharid(3),.@lastmac1$;query_sql "SELECT `last_mac` FROM `login` WHERE `account_id`="+.@accid,.@lastmac2$;if(.@lastmac1$==.@lastmac2$) {
into
if ( query_sql( "select 1 from login where last_mac = ( select last_mac from login where account_id = "+ getcharid(3) +" ) and account_id != "+ getcharid(3), .@dummy ) ) {
.
.
btw this kind of script uses way too many query_sql in a single npc click
its better that you optimized the SQL query, like I did above ( squeezing 2 Sql_handle into 1),
otherwise this script might produce lag when used on a live server




example like the one below
query_sql "SELECT `time` FROM `totaltime` WHERE `account_id`="+.@accid,.@rtime;//gets the time of the recruiterquery_sql "SELECT `time` FROM `totaltime` WHERE `account_id`="+getcharid(3),.@rtime2;//gets the the of the newbieif (.@rtime2>=.@rtime) //compare both times
change into
query_sql "select ( select time from totaltime where account_id = "+ getcharid(3) +" ) - ( select time from totaltime where account_id = "+ .@accid +" )", .@time_diff;if ( .@time_diff > 0 ) //compare both times ... if positive numbers

 

thx annie ill test these things and try to understand how it works
im noob with queries using athena style

 

 

after checking out the things you gave me i learned something new :D

now i can finally check if the mac address of the newbee has already have a recruiter

so a mac address can only be recruited once :D

 

into


if ( query_sql( "select 1 from totaltime where mac = ( select last_mac from login where account_id = "+ getcharid(3) +" ) and account_id != "+ getcharid(3), .@dummy ) ) {

 

thx a lot annie!


In Topic: convert to hercules mod

15 August 2014 - 01:36 PM

[font="helvetica, arial, sans-serif;"]bump[/font]

Here yo go! ,I dont test shadow equipment ....good luck!
 

 

Posted Imagerefine_bonus.patch

 

thx it works perfectly :) i can't say thank you enough :)


In Topic: convert to hercules mod

12 August 2014 - 10:56 PM

[color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]bump[/color]


In Topic: convert to hercules mod

11 August 2014 - 07:01 PM

bump