benching

Members
  • Content Count

    349
  • Avg. Content Per Day

    0
  • Joined

  • Last visited

  • Days Won

    4

benching last won the day on February 8 2016

benching had the most liked content!

Community Reputation

40 Excellent

About benching

  • Rank
    Indie Game Developer

Profile Information

  • Gender
    Male
  • Github
    benching
  • Interests
    Jobs and Boobs

Contact Methods

Recent Profile Visitors

4,209 profile views
  1. By "modify warps" i mean in src code, Instead of warping a player to the destination map, Make it "create an instance of the destination map then warp the player to that instance", (Note: Im not sure if theres an instance for a single player, (no party or guild))
  2. Modify warps to create and join instance of destination map, Add monsters npc and etc to the instanceed map, you can grab this data from the original map, Yea, looks like a heavy work,
  3. // Copyrights Notice // ======================================================== // This work is licensed under the Creative Commons Attribution-NonCommercial 4.0 International License. // To view a copy of this license, visit http://creativecommons.org/licenses/by-nc/4.0/. // ======================================================== // Introduction // ======================================================== // Copyrights 2015-2020 Jordan Lacandula All rights reserved // ======================================================== // Script: Guild Package Giver/Redeemer NPC // ======================================================== // Programmer: Jordan Lacandula // Website: For more info, visit http://jordanlacandula.tk/ // ======================================================== // Bug Report/Job Request // ======================================================== // Email: [email protected] // Skype: jordan.lacandula // ======================================================== // Features/Includes // ======================================================== // SQL Database Support // used table names `gpack_code` and `guild_package` // Duplicate IP Checking (also supports same IP, see below) // Account Checking // Online Status Checker // Easy to change Package items for guild master // Easy to change Package items for guild member // Minimum Guild members Checking (default: 8) // ======================================================== // Multiple IP ( Use gpack code to bypass IP Checking ) // ======================================================== // End Introduction // ======================================================== quiz_02,233,367,8 script Guild Master 421,{ if( getgmlevel() == 99 ){ set .c_length,10; setarray .g_code$[0],"A","B","C","D","E","F","G","H","I","J","K","L", "M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","0","1","2","3","4","5","6","7","8","9"; mes "What can i do for you Sire?"; switch(select("Nothing:View Code List:^FF0000 Add Package Code^000000")){ case 1: break; case 2: query_sql("SELECT `guild_id`, `gcode`,`status` FROM `gpack_code` ORDER BY `status` DESC",[email protected],[email protected]$,[email protected]); dispbottom "Status | GPack Code"; for(set @ei,0; @ei < getarraysize([email protected]$); set @ei,@ei + 1){ query_sql("`SELECT `name` FROM `guild` WHERE `guild_id` = '"[email protected][@ei]+"'",[email protected]$); dispbottom ""[email protected][@ei]+" | "[email protected]$[@ei]+" | "[email protected]$+""; } close; break; case 3: next; mes "Creating New Code for Guild: "; input [email protected]$; set [email protected],query_sql("SELECT `guild_id` FROM `guild` WHERE `name` = '"[email protected]$+"'",[email protected]); if([email protected] <= 0){ mes "^FF0000 Guild Not Found!^000000"; close; } for(set @i, 0; @i< .c_length; set @i, @i+1) { set @random_char, rand(0,(getarraysize(.g_code$)-1)); set @new_code$, @new_code$ + .g_code$[@random_char]; } query_sql "INSERT INTO `gpack_code` (`guild_id`, `gcode`, `status`) VALUES ('"[email protected]+"', '"[email protected]_code$+"', '0')"; set @new_code$, ""; next; mes "Added Code for Guild"; mes "^FF0000 "[email protected]$+"^000000"; close; break; } mes "Proceeding to Player View"; next; } set [email protected],0; set [email protected]$,"null"; setarray [email protected][0],607,1,504,1; //gmaster pack setarray [email protected][0],607,10,504,1; //gmember pack if(getcharid(2) == 0){ mes "you're not member of a guild"; close; } query_sql("SELECT `master` FROM `guild` WHERE `guild_id` = '"+getcharid(2)+"'",[email protected]$); if([email protected]$ != strcharinfo(0)){ mes "Only Guild Masters can claim the packages"; close; } mes "^FF0000 Guild Package^000000"; mes "Greetings ^FF0000 "+strcharinfo(0)+"^000000"; mes "Master of the Guild^FF0000 "+strcharinfo(2)+"^000000."; next; mes "Do you have code?"; switch(select("No:Yes")){ case 1: break; case 2: input [email protected]$; mes "Verifying Code"; mes "Please Wait...."; set [email protected],query_sql("SELECT `gcode` FROM `gpack_code` WHERE `gcode` = '"[email protected]$+"'"); if ( [email protected] <= 0 ){ next; mes "^FF0000 Invalid Code^000000"; mes "Codes are Case-Sensitive, Please make sure of it."; close; } query_sql("SELECT `status` FROM `gpack_code` WHERE `gcode` = '"[email protected]$+"'",[email protected]); if( [email protected] != 0 ){ mes "Guild Package code has been used already"; close; } set [email protected],1; break; } next; mes "Do you wish to claim your ^FF0000 Guild Package^000000 ?"; switch(select("No:Yes")){ case 1: close; break; case 2: next; mes "^FF0000 CLAIM GUILD PACKAGE^000000 "; mes "Master will receive the following:"; for ( set [email protected], 0; [email protected] < getarraysize([email protected]); set [email protected], [email protected] + 2 ) mes [email protected][[email protected]+1] + " x " + getitemname([email protected][[email protected]]); next; mes "^FF0000 CLAIM GUILD PACKAGE^000000 "; mes "Members will receive the following:"; for ( set [email protected], 0; [email protected] < getarraysize([email protected]); set [email protected], [email protected] + 2 ) mes [email protected][[email protected]+1] + " x " + getitemname([email protected][[email protected]]); next; mes "[^FF0000 Warning^000000 ]"; mes "Every one in your Guild can only claim Once regarding of their IP."; mes "Only Online characters can claim a Guld Package"; mes "No special treatments if characters go offline while in process of claiming"; next; mes "^FF0000 NOTE:^000000 You can only claim once."; mes "^FF0000 NOTE:^000000 All members should be online."; mes "^FF0000 NOTE:^000000 Make sure everyone have lots of Space in their inventory."; next; mes "^FF0000 CLAIM GUILD PACKAGE^000000 "; mes "Claim now?"; switch(select("No:Yes")){ case 1: close; break; case 2: next; set [email protected],8; //required minimum members setarray [email protected]$[0],"null"; set [email protected],query_sql("SELECT `name` FROM `guild_member` WHERE `guild_id` = '"+getcharid(2)+"'",[email protected]$); if( [email protected] < [email protected] ){ mes "Should have Total of "[email protected] +" members."; close; break; } // enforce IP check when code is not available if( [email protected] == 0 ){ setarray [email protected]$[0],"null"; // same ip check for( set [email protected],0; [email protected] < [email protected]; set [email protected],[email protected]+1 ){ query_sql("SELECT `account_id` FROM `char` WHERE `name` = '"[email protected]$[[email protected]]+"'",[email protected]); query_sql("SELECT `last_ip` FROM `login` WHERE `account_id` = '"[email protected]+"'",[email protected]$); //check for duplicates for( set [email protected],0; [email protected] < [email protected]; set [email protected],[email protected]+1 ){ if( [email protected]$ == [email protected]$[[email protected]] ){ mes "^FF0000 Duplicate IP Address^000000"; mes "^FF0000 NOTE:^000000 Each player should have different IP address"; mes "If you should not see this, Please report to admin"; close; } } //add to list setarray [email protected]$[[email protected]],[email protected]$; } } for( set [email protected],0; [email protected] < [email protected]; set [email protected],[email protected]+1 ){ //account check query_sql("SELECT `account_id` FROM `char` WHERE `name` = '"[email protected]$[[email protected]]+"'",[email protected]); set [email protected],query_sql("SELECT `acc_id` FROM `guild_package` WHERE `acc_id` = '"[email protected]+"'"); //ip check query_sql("SELECT `last_ip` FROM `login` WHERE `account_id` = '"[email protected]+"'",[email protected]); set [email protected],query_sql("SELECT `claim_ip` FROM `guild_package` WHERE `claim_ip` = '"[email protected]+"'"); //character name check set [email protected],query_sql("SELECT `char_name` FROM `guild_package` WHERE `char_name` = '"[email protected]$[[email protected]]+"'"); if([email protected] > 0 || [email protected] > 0 || [email protected] > 0){ mes "One or more in your member(s) has already received the package."; close; break; } } // TODOs: check if master and all members are online set [email protected],query_sql("SELECT `name` FROM `guild_member` WHERE `guild_id` = '"+getcharid(2)+"' AND `online` = 0"); if( [email protected] > 0 ){ mes "Make sure all members are online"; close; break; } for ( set [email protected],0; [email protected] < [email protected]; set [email protected],[email protected]+1 ){ if( [email protected]$[[email protected]] == strcharinfo(0)){ for ( set [email protected], 0; [email protected] < getarraysize([email protected]); set [email protected], [email protected] + 2 ) getitem [email protected][[email protected]], [email protected][[email protected]+1]; }else{ for ( set [email protected], 0; [email protected] < getarraysize([email protected]); set [email protected], [email protected] + 2 ) atcommand "#item "[email protected]$[[email protected]]+" "[email protected][[email protected]]+" "[email protected][[email protected]+1]+""; } set [email protected],"null"; query_sql("SELECT `account_id` FROM `guild_member` WHERE `name` = '"[email protected]$[[email protected]]+"'",[email protected]); query_sql("SELECT `last_ip` FROM `login` WHERE `account_id` = '"[email protected]+"'",[email protected]_ip$); query_sql("SELECT `last_mac` FROM `login` WHERE `account_id` = '"[email protected]+"'",[email protected]_mac$); query_sql("SELECT `last_cpu` FROM `login` WHERE `account_id` = '"[email protected]+"'",[email protected]_cpu$); query_sql("SELECT `last_motherboard` FROM `login` WHERE `account_id` = '"[email protected]+"'",[email protected]_mb$); query_sql("SELECT `char_id` FROM `char` WHERE `name` = '"[email protected]$[[email protected]]+"'",[email protected]_id); query_sql "INSERT INTO `guild_package` (`acc_id`, `char_id`, `char_name`, `guild_id`, `guild_name`, `guild_master`, `claim_ip`, `claim_mac`, `claim_cpu`, `claim_motherboard`) VALUES ('"[email protected]+"','"[email protected]_id+"','"[email protected]$[[email protected]]+"','"+getcharid(2)+"','"+strcharinfo(2)+"','"+strcharinfo(0)+"','"[email protected]_ip$+"','"[email protected]_mac$+"','"[email protected]_cpu$+"','"[email protected]_mb$+"')"; } next; mes "Package has been Distributed."; close2; query_sql("UPDATE `gpack_code` SET `guild_id` = '"+getcharid(2)+"', `status` = '1' WHERE `gcode` = '"[email protected]$+"'"); announce "The Guild "+strcharinfo(2)+" has Signed Up for war",BC_ALL,0xFF0000; break; } break; } switch(rand(1,4)){ case 1: npctalk "Hey you noob, your turn"; sleep 1000; npctalk "Oh you're not noob? Then prove it in WOE"; break; case 2: npctalk "Next!"; break; case 3: npctalk "NEXT NEXT NEXT, Move Faster"; break; case 4: npctalk "No more? Good."; } OnInit: waitingroom "Claim Guild Package Here",0; query_sql "CREATE TABLE IF NOT EXISTS `guild_package` ( `acc_id` INT NOT NULL UNIQUE, `char_id` INT NOT NULL, `char_name` TEXT NOT NULL, `guild_id` INT NOT NULL, `guild_name` TEXT NOT NULL, `guild_master` TEXT NOT NULL, `claim_ip` TEXT NOT NULL, `claim_mac` TEXT NOT NULL, `claim_cpu` TEXT NOT NULL, `claim_motherboard` TEXT NOT NULL ) ENGINE=MyISAM"; query_sql "CREATE TABLE IF NOT EXISTS `gpack_code` (`guild_id` INT NOT NULL, `gcode` VARCHAR(10) NOT NULL, `status` INT NOT NULL ) ENGINE=MyISAM"; end; } I'm not sure what revision / hash of rA where they take the hardware details, This script was made that time, If the current version of rA you have don't take the hardware details of the client and save it to db, Then the claiming with same ip's is pretty much useless, This file is not being updated anymore, so through the updates of rA and MySQL, This file will throw errors, The code above will still show errors due to the column of hardware infos that are missing, You can just ignore them and assume that the same IP claiming is not working.
  4. Rathena has packet docs, you can just check on that, or find the packet parsing in the src,
  5. Not related answer, just wanna let you know, This path finding algorith will be a huge pain if the calculations are handled by the server, you need to do this on client side via modding the client or 3rd party,
  6. The first arg is the second of the skill or the caster, The 2nd arg is the target, I'm not sure how to call it on mob that it bump into.
  7. Change ++.w2[[email protected]] To (.w2[[email protected]]++) or without the parentheses
  8. Check skill_castend_damage_id and skill_castend_nodamage_id
  9. Let me check... Device too slow for me to check on GitHub,
  10. In which function in status.c are you calling that line? A small snippet would be good
  11. There is a function that is called on timer tick, (something like walkto) you can try finding and putting the code there, Putting the code in the walkto function will affect all the units that uses that, I suggest putting something to identify that only this unit will die when reached an obstacle, sc status would be helpful for this,
  12. I don't really remember things clearly, Try removing the unit-> You don't need that, also make sure that bl is the target, And is that the right function for using skill?
  13. benching

    FluxCP error

    use "mysqli" not "mysql"
  14. There's always an issue using someone's work, To avoid legal issues, you have to make everything from scratch, I suggest taking OpenGL / Vulcan for Graphics and C++ if you plan to start from scratch, But using engines out there is way better time saver than making your own engine too.
  15. prolly need src modification, be careful there if you plan to do it yourself.