Jump to content

Dhall

Members
  • Posts

    62
  • Joined

  • Last visited

  • Days Won

    2

Posts posted by Dhall

  1. Please !! help me here!!

     

    : Access denied for user 'myserver'@'localhost' (using password: YES)
    [Error]: Couldn't connect with uname='myusername',passwd='MjQzYmMwNGE3ZWZ',host='127.0.0.1',port='3306',database='mydatabe'
    [Debug]: at loginlog.c:193
    [sql]: Access denied for user 'myserver'@'localhost' (using password: YES)
    [Error]: Couldn't connect with uname='myserver',passwd='MjQzYmMwNGE3ZWZ',host='127.0.0.1',port='3306',database='mydatabse'
    [Debug]: at inter.c:712
     
     
  2. Hi! Sorry about this!

     

    I am just wondering why this script don't kick any char if they use double login in "prtg_cas01", "schg_cas01", "bat_room" and "prtg_cas02". There is something wrong with this?

     

    Have no error when I start the server.

    -	script	dualclientkicker	-1,{
    OnPCLoadMapEvent:
    	set .@charmap$, strcharinfo(3);
    	if(!compare(.tmp$,.@charmap$)) end;
    	//set .@len, query_sql("SELECT DISTINCT `account_id` FROM `char` WHERE `account_id` IN (SELECT `account_id` FROM `login` WHERE `last_ip` = (SELECT `last_ip` FROM `login` WHERE `account_id`="+getcharid(3)+")) AND `online` <> 0;",.@a);
    	set .@len, query_sql("select account_id from `char` right join login on login.account_id = `char`.account_id where `char`.online = 1 and login.last_ip = '"+ getcharip() +"'",.@a ); //Annieruru Addition.
    	if(.@len-1) {
    		for(set(.@d,0);.@d<.@len;set(.@d,.@d+1)) {
    			getmapxy(.@map$,.@x,.@y,0,rid2name(.@a[.@d]));
    			if(.@charmap$==.@map$&&rid2name(.@a[.@d])!=strcharinfo(0)) {
    				dispbottom "No se permite doble login.";
    				warp "geffen",0,0;
    			}
    		}
    	}
    	end;
    	
    OnInit:
    	setarray   .maps$  ,	"prtg_cas01", "schg_cas01", "bat_room", "prtg_cas02";
    	set        .lens   ,	getarraysize(.maps$)                                   ;
    	for(set(.a,0);.a<.lens;set(.a,.a+1)) {
    		setmapflag .maps$[.a],	mf_loadevent ;
    		set .tmp$  ,.tmp$+.maps$[.a]+",";
    	}
    }
    

    Fixed it!! You can close now!!

    -	script	dualclientkicker	-1,{
    OnPCLoadMapEvent:
    	set .@charmap$, strcharinfo(3);
    	if(!compare(.tmp$,.@charmap$)) end;
    	set .@len, query_sql("SELECT DISTINCT `account_id` FROM `char` WHERE `account_id` IN (SELECT `account_id` FROM `login` WHERE `last_ip` = (SELECT `last_ip` FROM `login` WHERE `account_id`="+getcharid(3)+")) AND `online` <> 0;",.@a);
    	//set .@len, query_sql("select account_id from `char` right join login on login.account_id = `char`.account_id where `char`.online = 1 and login.last_ip = '"+ getcharip() +"'",.@a ); //Annieruru Addition.
    	if(.@len-1) {
    		for(set(.@d,0);.@d<.@len;set(.@d,.@d+1)) {
    			getmapxy(.@map$,.@x,.@y,0,rid2name(.@a[.@d]));
    			if(.@charmap$==.@map$&&rid2name(.@a[.@d])!=strcharinfo(0)) {
    				dispbottom "No se permite doble login.";
    				warp "geffen",0,0;
    			}
    		}
    	}
    	end;
    	
    OnInit:
    	setarray   .maps$  ,	"prtg_cas01", "schg_cas01", "bat_room", "prtg_cas02";
    	set        .lens   ,	getarraysize(.maps$)                                   ;
    	for(set(.a,0);.a<.lens;set(.a,.a+1)) {
    		setmapflag .maps$[.a],	mf_loadevent ;
    		set .tmp$  ,.tmp$+.maps$[.a]+",";
    	}
    }
    
  3. Thanks for the advice @Haziel !! I already created the mod_db for Devil's Tower :')

     

    Just got two errors!!

    // ---- Devil's Tower
    2937,M_LOKI,Loki,Loki,145,1215600,1,2,2,1,444,1835,15,89,76,66,90,55,189,22,10,12,1,7,20,0x37B5,100,76,384,288,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    2938,MM_MAGIC_SEAL,Magic Seal,Magic Seal,140,10000000,1,2,6999,1,156,157,80,200,16,26,30,115,79,5,10,12,2,0,20,0x37B5,200,1332,1332,672,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    2939,MM_EVIL_SHADOW1,Evil Shadow,Evil Shadow,138,112000,4500,7456,5983,1,2838,4145,30,30,88,44,88,21,95,44,10,12,2,6,47,0x37B5,150,432,432,360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    2940,MM_EVIL_SHADOW2,Evil Shadow,Evil Shadow,141,127650,1,8103,7783,1,2343,3414,121,36,60,103,45,35,172,15,10,12,2,6,47,0x37B5,150,432,432,360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    2941,MM_EVIL_SHADOW3,Evil Shadow‚Evil Shadow,142,153400,1,8863,6736,1,2795,4062,89,44,120,87,66,33,106,27,10,12,2,6,47,0x37B5,150,432,432,360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    2942,MM_EVIL_FANATICS,Evil Fanatic‚Evil Believer,151,8256000,1,1008650,988954,1,2949,4289,166,103,118,72,40,55,213,30,10,12,2,6,67,0x37B5,150,768,768,576,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    2943,MM_ICE_MINE,Ice Mine,Ice Mine,149,10000,1,0,0,1,509,589,200,10,200,200,200,200,200,200,10,12,0,4,88,0x3985,170,1084,2304,576,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    
    

    I can't create Monster 2941 and 2942!! Already made a reloadmobdb and then tried with a reloadscript, stop, and restar server, and nothing!

     

    screenroot029.jpg

  4. anyone have this, I tried to create one but, there's something wrong with it...Please help! :)

     

    I'm not lying ... there is mine  /wah  /sob

    2937,M_LOKI,Loki,Loki,145,1215600,4500,2,2,1,444,1835,15,89,76,66,90,55,189,22,10,12,1,7,20,133,150,160,528,360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    2938,MM_MAGIC_SEAL,Magic Seal,Magic Seal,140,10000000,4500,2,6999,1,156,157,80,200,16,26,30,115,79,5,10,12,2,0,20,133,100,aDelay,aMotion,dMotion,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    2939,MM_EVIL_SHADOW1,Evil Shadow,Evil Shadow,138,112000,4500,7456,5983,1,2838,4145,30,30,88,44,88,21,95,44,10,12,2,6,47,133,150,160,528,360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    2940,MM_EVIL_SHADOW2,Evil Shadow,Evil Shadow,141,127650,4500,8103,7783,1,2343,3414,121,36,60,103,45,35,172,15,10,12,1,6,47,133,150,160,528,360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    2941,MM_EVIL_SHADOW3,Evil Shadow‚Evil Shadow,142,153400,4500,8863,6736,1,2795,4060,89,44,120,87,66,33,106,27,10,12,2,6,47,133,100,150,160,528,360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    2942,MM_EVIL_FANATICS,Evil Fanatic‚Evil Believer‚151,8256000,4500,1008650,988954,1,2949,4289,166,103,118,72,40,55,213,30,10,12,2,6,67,133,150,160,528,360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    2943,MM_ICE_MINE,Ice Mine,Ice Mine,149,10000,4500,0,0,1,509,589,200,10,200,200,200,200,200,200,10,12,0,4,88,133,150,160,528,360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    

    Told you, big fail!  /spit

  5. Hi! I am trying to install Bio Island Instance on my server, I tried it on my test server and this is what happened!!

     

    I leave you guys the script! Amm..I just started with the translation, sorry if there is a short part in english and the rest in Korean :)

     

    Please help!  /sob

     

    I know that the "status_set_viewdata" it's beacuse I don't have the mobs on my mob_db, but with the first image?

    post-34528-0-40895200-1445891074_thumb.png

    post-34528-0-64947500-1445891075_thumb.png

    BioIsland.txt

  6. Sorry I get confused with the script :(

    ecl_in01,64,97,5	script	Slot Expert Nattuer#ecl	436,{
    	disable_items;
    	mes "[Slot Expert]";
    	mes "I am Slot Expert Nattuer.";
    	mes "If you bring me an item from my little brother Naphara along with 5 Splendide Coins, I will open up one Slot for you.";
    	next;
    	if (select("Activate a Slot.:Forget it.") == 2){
    		close;
    	}
    	mes "[Slot Expert]";
    	mes "Slot activation is an extremely difficult procedure that can fail even with heightened care and the use of a magnifying lens.";
    	next;
    	mes "[Slot Expert]";
    	mes "Of course, if your heart were as big as that flower-filled land, you wouldn't mind. Right? Should I go for it?";
    	next;
    	if (select("Continue.:Forget it.") == 2) {
    		close;
    	}
    	mes "[Slot Expert]";
    	mes "Which item would you like to activate with a Slot?";
    	next;
    	.@choice = select("Str Glove:Int Glove:Ag Glove:Vit Glove:Dex Glove:Luk Glove");
    	.@choice += 2916;
    	mes "[Slot Expert]";
    	mes "Let's confirm for the last time. Is the one you want " + getitemname(.@choice) + "?";
    	next;
    	if (select("Yes:No")==2) {
    		mes "[Slot Expert]";
    		mes "Why don't you talk to me when you know for sure.";
    		close;
    	}
    	if (countitem(.@choice) < 1) {
    		mes "[Slot Expert]";
    		mes "You don't have that item. Why don't you talk to me when you know for sure.";
    		close;
    	}
    	if (countitem(6081) < 5) {
    		mes "[Slot Expert]";
    		mes "You don't have enough coins. Why don't you talk to me when you know for sure.";
    		close;
    	}
    	progressbar "0xFFFF00",3;
    	mes "[Slot Expert]";
    	delitem 6081,5; //Splendide_Coin
    	.@luckyday = rand(1,100);
    	if (.@luckyday % 20){
    		emotion e_dots;
    		delitem .@choice,1;
    		mes "Shoot, I'm sorry. It failed.";
    		mes "But I'm sure it will work next time. I have a feeling.";
    		close;
    	}
    	emotion e_no1;
    	delitem .@choice,1;
    	getitem (.@choice+6),1;
    	mes "My eyes feel like they're gonna pop out.";
    	mes "Nonetheless, congratulations. Slot activation was successful.";
    	close;
    }
    

    But this is what I am trying to say! :D

    2917,Str_Glove,Str Glove,4,75000,,100,,0,,0,0xFFFFFFFF,63,2,136,,100,0,0,{ bonus bMaxHP,100; bonus bMaxSP,20; bonus bBaseAtk,(readparam(bStr)/10); if(readparam(bStr)>=110) bonus bAtkRate,1; },{},{}
    2918,Int_Glove,Int Glove,4,75000,,100,,0,,0,0xFFFFFFFF,63,2,136,,100,0,0,{ bonus bMaxHP,100; bonus bMaxSP,20; bonus bMatk,(readparam(bInt)/10); if(readparam(bInt)>=110) bonus bMatkRate,1; },{},{}
    2919,Agi_Glove,Agi Glove,4,75000,,100,,0,,0,0xFFFFFFFF,63,2,136,,100,0,0,{ bonus bMaxHP,100; bonus bMaxSP,20; bonus bFlee,(readparam(bAgi)/10); if(readparam(bAgi)>=110) bonus bFlee2,1; },{},{}
    2920,Vit_Glove,Vit Glove,4,75000,,100,,0,,0,0xFFFFFFFF,63,2,136,,100,0,0,{ bonus bMaxHP,100; bonus bMaxSP,20; bonus bMaxHP,(readparam(bVit)/10)*50; if(readparam(bVit)>=110) bonus bMaxHPrate,1; },{},{}
    2921,Dex_Glove,Dex Glove,4,75000,,100,,0,,0,0xFFFFFFFF,63,2,136,,100,0,0,{ bonus bMaxHP,100; bonus bMaxSP,20; bonus bHit,(readparam(bDex)/10); if(readparam(bDex)>=110) bonus bLongAtkRate,1; },{},{}
    2922,Luk_Glove,Luk Glove,4,75000,,100,,0,,0,0xFFFFFFFF,63,2,136,,100,0,0,{ bonus bMaxHP,100; bonus bMaxSP,20; bonus bCritical,(readparam(bLuk)/10); if(readparam(bLuk)>=110) bonus bCritAtkRate,1; },{},{}
    2923,Str_Glove_,Str Glove,4,75000,,100,,0,,1,0xFFFFFFFF,63,2,136,,100,0,0,{ bonus bMaxHP,100; bonus bMaxSP,20; bonus bBaseAtk,(readparam(bStr)/10); if(readparam(bStr)>=110) bonus bAtkRate,1; },{},{}
    2924,Int_Glove_,Int Glove,4,75000,,100,,0,,1,0xFFFFFFFF,63,2,136,,100,0,0,{ bonus bMaxHP,100; bonus bMaxSP,20; bonus bMatk,(readparam(bInt)/10); if(readparam(bInt)>=110) bonus bMatkRate,1; },{},{}
    2925,Agi_Glove_,Agi Glove,4,75000,,100,,0,,1,0xFFFFFFFF,63,2,136,,100,0,0,{ bonus bMaxHP,100; bonus bMaxSP,20; bonus bFlee,(readparam(bAgi)/10); if(readparam(bAgi)>=110) bonus bFlee2,1; },{},{}
    2926,Vit_Glove_,Vit Glove,4,75000,,100,,0,,1,0xFFFFFFFF,63,2,136,,100,0,0,{ bonus bMaxHP,100; bonus bMaxSP,20; bonus bMaxHP,(readparam(bVit)/10)*50; if(readparam(bVit)>=110) bonus bMaxHPrate,1; },{},{}
    2927,Dex_Glove_,Dex Glove,4,75000,,100,,0,,1,0xFFFFFFFF,63,2,136,,100,0,0,{ bonus bMaxHP,100; bonus bMaxSP,20; bonus bHit,(readparam(bDex)/10); if(readparam(bDex)>=110) bonus bLongAtkRate,1; },{},{}
    2928,Luk_Glove_,Luk Glove,4,75000,,100,,0,,1,0xFFFFFFFF,63,2,136,,100,0,0,{ bonus bMaxHP,100; bonus bMaxSP,20; bonus bCritical,(readparam(bLuk)/10); if(readparam(bLuk)>=110) bonus bCritAtkRate,1; },{},{}
    

    This is my Item DB .

     

    For example I bought a Str Glove (ID 2917) ... with the npc i told you already I should get Str Glove [1] (ID 2923). Everytime i go and talk to the npc to get the 2923 item, i always get the "Shoot, I'm sorry. It failed." (The NPC brakes my item)

×
×
  • Create New...