Jump to content
  • Sign Up

Virtue

Members
 View Profile  See their activity

  • Content Count

    259

  • Joined

  • Last visited

  • Days Won

    1

Posts posted by Virtue

  1. Posted

     

     

    	<html>	<head>	<title>Event Rewards Log</title>	</head>		<body><center><font size=16>Prizes given for events!</font><br /><font size=4>Event Reward Logs~</font><br /><br />	<table border='1'>	<tr>		<td>Character</td>		<td>Received</td>		<td>Quantity</td>		<td>Date</td>		<td>From</td>	</tr>	<?php	//-------------------------	// By Pancake with the help of #rathena at irc://irc.rathena.net	//-------------------------	// Connect to database server	mysql_connect("127.0.0.1", "User", "Password") or die (mysql_error ());	// Select database	mysql_select_db("rathena_rag") or die(mysql_error());	// SQL query	$strSQL = "SELECT * FROM itemizer ORDER BY id DESC";	// Execute the query (the recordset $rs contains the result)	$rs = mysql_query($strSQL);	// Loop the recordset $rs	while($row = mysql_fetch_array($rs)) {		echo "<tr>";			echo "<td>" . $row['char_name'] . "</td>";			echo "<td>" . $row['item_name'] ."</td>";			echo "<td>" . $row['item_amount'] ."</td>";			echo "<td>" . $row['when'] ."</td>";			echo "<td>" . $row['by_gm'] . "</td>";		echo "</tr>";	}	echo "</table>";	// Close the database connection	mysql_close();	?></center>	</body>	</html> 

     


     
    I want to add a pagination for the Index and another query
     
     
     

     

    <td>Claimed</td> 

     

     
     

     

    echo "<td>" . $row['collected'] . "</td>"; 

     

    But I want it to show Yes or No. if you put the code i just made it just shows 1 or 0

     

  4. Posted

    Hi Guys,

     

    I have been searching for a way to remove the GM Sprite at 2012-05-25aRagexeRE Client.

    however, I can't find anything about it. if there would be somebody that could help, it would really be nice, I'd like to show the Yellow Name/Yellow chat and only removing the GM Sprite.

     

    Thanks :)

  7. Posted

    Hi Guys, 

     

    I know this has been posted over and over again, but I think i have read and check all the other topics about this and still can't find the answer.

    what I think everybody wants/need/asks for is this.

     

    I found this script made by annie.

     

     

     

    prontera,159,179,4	script	Team Wars::teamwar	899,{	if (getgmlevel() >= 99){		menu "standard menu",standard,"reset",lend;	}standard:	set $@members,2; // number of party members change this to your party size you want	set $@start,0;	getpartymember(getcharid(1));	set @partymembercount,$@partymembercount;	if ( $@start == 1 ) {		mes "The Sign Ups are currently unavailable because a match is in progress. Don't hesitate to try again in a few minutes!";		close;	}	if ( @partymembercount == $@members ) {		if ( $@TeamID1 == getcharid(1) ) {			mes "Do you wish to sign out your team?";				next;				if (select("I Give up ~.","Never Say Quit !!")==2) close;				announce "Team 1 : [ " + getpartyname($@TeamID1) + " ] has sign out. We need another Party to sign up now!",bc_yellow|bc_map;				set $@TeamID1, 0;			close;			}		if ($@TeamID2==getcharid(1)) {				mes "Do you wish to sign out your team?";				next;				if (select("I Give up ~.","Never Say Quit !!")==2) close;			announce "Team 2 : [ " + getpartyname($@TeamID2) + " ] has sign out. We need another Party to sign up now!",bc_yellow|bc_map;				set $@TeamID2, 0;				close;			}		mes "Hello "+strcharinfo(0)+" what do you want?";		if (($@TeamID1!=0) && ($@TeamID2!=0)) {			mes "The Sign Ups are currently unavailable because a match is in progress. Don't hesitate to try again in a few minutes!";			close;		}		if ( getpartyleader(getcharid(1),2) != getcharid(0) ) {			mes "Only party leader have the right to sign up / out from the game with me..";			close;		}		mes "Choose your team to register.";		switch(select("Red Team - [" + GetPartyName($@TeamID1) + "] :Blue Team - [" + GetPartyName($@TeamID2) + "]")) {		case 1:	mes "[  Team War  ]";			if ($@TeamID1==0 || getpartyname($@TeamID1)=="null") {				getpartymember(getcharid(1)),1;				getpartymember(getcharid(1)),2;				copyarray $@partymembercidt1[0],$@partymembercid[0],$@members;				copyarray $@partymemberaidt1[0],$@partymemberaid[0],$@members;				for (set .@i,0; .@i<$@members; set .@i,.@i+1) {					if(isloggedin($@partymemberaidt1[.@i],$@partymembercidt1[.@i]))  set .@count,.@count+1;				}				if(.@count < $@members) {					mes "You need all your party members to be online to Register";					close;				}				set $@TeamID1, getcharid(1);					initnpctimer;					mes "Your Party is now subscribed, good luck!";					announce "Team 1 : [ " +getpartyname($@TeamID1)+ " ] has sign up For the Team War!",bc_blue|bc_map;					doevent "teamwar::OnSubscriptionTeam";					close;				} else {				mes "I'm sorry! Another Team has sign up before you...";					close;				}		case 2:	mes "[  Team War  ]";			if ($@TeamID2==0 || getpartyname($@TeamID2)=="null") {					getpartymember(getcharid(1)),1;				getpartymember(getcharid(1)),2;				copyarray $@partymembercidt2[0],$@partymembercid[0],$@members;				copyarray $@partymemberaidt2[0],$@partymemberaid[0],$@members;				for (set .@i,0; .@i<$@members; set .@i,.@i+1) {					if(isloggedin($@partymemberaidt2[.@i],$@partymembercidt2[.@i])) set .@count,.@count+1;				}				if(.@count < $@members) {					mes "You need all your party members to be online to Register";					close;				}				set $@TeamID2, getcharid(1);					initnpctimer;					mes "Your Party is now subscribed, good luck!";					announce "Team 2 : [ " +getpartyname($@TeamID2)+ " ] has sign up For the Team War!",bc_blue|bc_map;				doevent "teamwar::OnSubscriptionTeam";					close;				} else {					mes "I'm sorry! Another Team has sign up before you...";					close;			}		}	} else {		mes "[Event Handler]";		mes "Please contact your party leader.";		mes "Your team must have a party consisting of "+$@members+" members.";		close;	}OnSubscriptionTeam:	getpartymember($@TeamID2),1;	getpartymember($@TeamID2),2;	copyarray $@partymembercidtc2[0],$@partymembercid[0],$@members;	copyarray $@partymemberaidc2[0],$@partymemberaid[0],$@members;	for (set .@i,0; .@i<$@members; set .@i,.@i+1) {		if(isloggedin($@partymemberaidc2[.@i],$@partymembercidtc2[.@i])) set .@countx,.@countx+1;	}	if(.@countx < $@members) {		announce "Team War : "+getpartyname($@TeamID2)+"are not all online the match has been canceled",0;		announce "Team War : registration for 2 new teams are now available",0;		goto lend;	}	if ( $@TeamID2 && $@partymembercount != $@members ) {		announce getpartyname($@TeamID2) +" has extra party members !", 0;		goto lend;	}	getpartymember($@TeamID1),1;	getpartymember($@TeamID1),2;	copyarray $@partymembercidtc1[0],$@partymembercid[0],$@members;	copyarray $@partymemberaidc1[0],$@partymemberaid[0],$@members;	for (set .@i,0; .@i<$@members; set .@i,.@i+1) {		if(isloggedin($@partymemberaidc1[.@i],$@partymembercidtc1[.@i])) set .@countz,.@countz+1;	}	if(.@countz < $@members) {		announce "Team War : "+getpartyname($@TeamID1)+"are not all online the match has been canceled",0;		announce "Team War : registration for 2 new teams are now available",0;		goto lend;	}	if ( $@TeamID1 &&  $@partymembercount != $@members ) {		announce getpartyname($@TeamID1) +" has extra party members !", 0;		goto lend;	}	if($@TeamID1!=0 && $@TeamID2!=0){		announce "Team War : We have 2 Teams signed up now : "+getpartyname($@TeamID1)+" and "+getpartyname($@TeamID2)+".",bc_blue|bc_map;		set @win1, 0;		set @win2, 0;		goto Onstart;	}	end;OnTimer50000:	if (($@TeamID1!=0) && ($@TeamID2!=0)) {		stopnpctimer;		end;	}	stopnpctimer;	set $@TeamID1, 0;	set $@TeamID1, 0;	announce "Team War : we lack teams to start registration for two teams are now available",0;	end;	OnStart:	warpparty "guild_vs2",89,49,$@TeamID1;	warpparty "guild_vs2",11,49,$@TeamID2;	set $@start,1;	end;lend:	stopnpctimer;	set $@TeamID1,0;	set $@TeamID2,0;	set $@start,0;	set @win1,0;	set @win2,0;	set @partymembercount,$@members;	announce "Thanks for playing",0;	end;OnTimer250000:	Announce "Team War : No Party won due to time limit!",0;	mapwarp "guild_vs2","prontera",156,191;	goto lend;	end;OnPCDieEvent:OnPCLogoutEvent:	if(strcharinfo(3) != "guild_vs2") end;	warp "prontera",156,191;	for(set .@i, 0; .@i < $@members; set .@i, .@i + 1) {		if ( $@partymembercidt1[.@i] == getcharid(0)) {			deletearray $@partymembercidt1[.@i], 1;			deletearray $@partymemberaidt1[.@i], 1;			if( getarraysize($@partymembercidt1) == 0 ) {				set @win2,getarraysize($@partymembercidt2);				goto onwin;			}		}		if ( $@partymembercidt2[.@i] == getcharid(0) ) {			deletearray $@partymembercidt2[.@i], 1;			deletearray $@partymemberaidt2[.@i], 1;			if( getarraysize($@partymembercidt2)  == 0 ) {				set @win1,getarraysize($@partymembercidt1);				goto onwin;			}		}	}	end;onwin:	if (@win1==0) {		warpparty "prontera",156,191,$@TeamID1;		warpparty "prontera",156,191,$@TeamID2;		Announce "Team War :"+GetPartyName($@TeamID2)+" won",0;		for ( .@i = 0; .@i < @win2; .@i++ )			getitem 7588, rand(6,10), $@partymemberaidt2[.@i];		goto lend;	}	if (@win2==0) {		warpparty "prontera",156,191,$@TeamID1;		warpparty "prontera",156,191,$@TeamID2;		Announce "Team War :"+GetPartyName($@TeamID1)+" won",0;		for ( .@i = 0; .@i < @win1; .@i++ )			getitem 7588, rand(6,10), $@partymemberaidt1[.@i];		goto lend;	}	end;}guild_vs2	mapflag	nosave	SavePointguild_vs2	mapflag	nomemoguild_vs2	mapflag	nobranchguild_vs2	mapflag	pvp_noguildguild_vs2	mapflag	nocommand	60guild_vs2	mapflag	noicewallguild_vs2	mapflag	pvpguild_vs2	mapflag	partylock

     

     

     

     

    Now the script itself is amazing, but it just lacks one function, A Job check. since it would really be nice to have no duplicate jobs ( knight:knight = denied | knight:crusader = allowed )

     

    so i continued my search for it, then I found this 

    Annakid's Post at some support thread.

     

     

     

     

    getpartymember(getcharid(1),2);copyarray .@partyids[0],$@partymembercid[0],$@partymembercount;set .@count, $@partymembercount;for (set .@a, 0; .@a < .@count; set .@a, .@a + 1) {attachrid .@partyids[.@a];set .@jobs[.@a], Class;// Check Job from other current jobsfor (set .@b, 0; .@b < getarraysize(.@jobs); set .@b, .@b + 1) {if (Class == .@jobs[.@b]) {set .@matches, .@matches + 1;}}// Check if this job as too manyif (.@matches > 2) { // Too Many of the Same Job }// Less than 2, so reset counter for next playerset .@matches, 0;}

     

     

     

     

    but I tried to merge it to annie's script and no luck, it didn't work, so i decided to use annakid's script as a portal to get to annie's partyvsparty script but even though I have 2 Blacksmiths at my party it does not block my party from warping.

     

    What I really want to ask for is how do we put a DUAL JOB/CLASS Restriction on Annie's PVP Party vs Party Script.

     

  12. Posted · Edited by Virtue

    Hi Scripting Pros,

     

    is it possible to use this query on a script?

     

     

    SELECT COUNT(account_id) AS OnlinePlayers FROM char WHERE online=1; 

     

     

     

    I will be using it for some script that checks the online player count.

    Thanks to those who will help.

  13. Posted

    the scripts could work, but you'd have to rework the whole functions to what they changed for instance their I know someone made it work without eamod. :P it just takes a lot of time and effort but if you really want it you can find a way.

  14. Posted

    Hi,

    I am not quite sure why safety wall is causing errors on my client. can't find a fix but I am quite sure that safety wall is causing the error.

    No Errors encountered with effects off and safety wall but when the effects are turned on and you die near a safety wall the client crashes.

  19. Posted

    try to use the 2012-05-15Ragexe

     

    and i provided a packet for you

     

    [cbox]// 2012-05-15Ragexe

    #if PACKETVER >= 20120515

    packet(0x0369,26,clif->pFriendsListAdd,2);

    packet(0x094B,5,clif->pHomMenu,2,4);

    packet(0x089A,36,clif->pStoragePassword,0);

    packet(0x091F,26,clif->pPartyInvite2,2);

    packet(0x08A8,19,clif->pWantToConnection,2,6,10,14,18);

    packet(0x0923,7,clif->pActionRequest,2,6);

    packet(0x0947,10,clif->pUseSkillToId,2,4,6);

    packet(0x0366,-1,clif->pItemListWindowSelected,2,4,8);

    packet(0x0891,-1,clif->pReqOpenBuyingStore,2,4,8,9,89);

    packet(0x092C,2,clif->pReqCloseBuyingStore,0);

    packet(0x091A,6,clif->pReqClickBuyingStore,2);

    packet(0x096A,-1,clif->pReqTradeBuyingStore,2,4,8,12);

    packet(0x0817,-1,clif->pSearchStoreInfo,2,4,5,9,13,14,15);

    packet(0x0367,2,clif->pSearchStoreInfoNextPage,0);

    packet(0x087E,12,clif->pSearchStoreInfoListItemClick,2,6,10);

    packet(0x087C,5,clif->pWalkToXY,2);

    packet(0x087D,6,clif->pTickSend,2);

    packet(0x08AC,5,clif->pChangeDir,2,4);

    packet(0x0964,6,clif->pTakeItem,2);

    packet(0x0364,6,clif->pDropItem,2,4);

    packet(0x085A,8,clif->pMoveToKafra,2,4);

    packet(0x0869,8,clif->pMoveFromKafra,2,4);

    packet(0x08AD,10,clif->pUseSkillToPos,2,4,6,8);

    packet(0x08A2,90,clif->pUseSkillToPosMoreInfo,2,4,6,8,10);

    packet(0x09A5,6,clif->pGetCharNameRequest,2);

    packet(0x0957,6,clif->pSolveCharName,2);

    packet(0x0861,18,clif->pPartyBookingRegisterReq,2,4,6);

    #endif[/cbox]

    used that and now i can't even log in

×
×
  • Create New...

Important Information

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

  I accept