a must pin and very educational
- Viewing Profile: Posts: icabit
Community Stats
- Group Members
- Active Posts 45
- Profile Views 3940
- Member Title Advanced Member
- Age Age Unknown
- Birthday Birthday Unknown
-
Gender
Not Telling
4
Neutral
User Tools
Latest Visitors
Posts I've Made
In Topic: 3 questions regarding AnnieRuru scripts
01 September 2014 - 12:15 PM
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$) {intoif ( 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 belowquery_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 timeschange intoquery_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
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
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!
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
- Viewing Profile: Posts: icabit
- Privacy Policy
- Hercules Forum Rules ·