little question about sql

[WordsUp]

is this code correct?

- script sql -1,{

OnAgitBreak:

if (query_sql("select `guild_id` from `woe_record` where `guild_id` = '"+getcharid(2)+"'",.@ignore)) {

query_sql("update `woe_record` set `id` = `id`+1 where `guild_id` = '"+getcharid(2)+"'",.@ignore);

}

OnAgitEnd :

if (query_sql("select `guild_id` from `woe_record` where `guild_id` = '"+getcharid(2)+"'",.@ignore)) {

query_sql("update `woe_record` set `castle_id` = '"+getcastlename(2)+"' where `guild_id` = '"+getcharid(2)+"'",.@ignore);

}

i don't know what .@ignore use i just copy that code somewhere in my files.

}

Edited December 22, 2011 by WordsUp

[Z3R0]

* query_sql "Query"{,<array>{,<array>{,...}}};

* query_logsql "your MySQL query", <array variable> {,<array variable>, ...};

http://ea.dj-yhn.com/index.php?c=query_sql

.@ignore is the returned values of the select to an array however, since he is only checking if it worked, there's no reason to worry about it...

[WordsUp]

thanks for the reply zero but can i ask if this works if i use it? or should i need to change anything for this code to work

[JayPee]

I dont know if this is going to work. I assume your checking if the .@ignore has a value?

- script sql -1,{

OnAgitBreak:

if (query_sql("select `guild_id` from `woe_record` where `guild_id` = '"+getcharid(2)+"'",.@ignore)) {

query_sql("update `woe_record` set `id` = `id`+1 where `guild_id` = '"+getcharid(2)+"'",.@ignore);

}

OnAgitEnd :

if (query_sql("select `guild_id` from `woe_record` where `guild_id` = '"+getcharid(2)+"'",.@ignore)) {

query_sql("update `woe_record` set `castle_id` = '"+getcastlename(2)+"' where `guild_id` = '"+getcharid(2)+"'",.@ignore);

}

i don't know what .@ignore use i just copy that code somewhere in my files.

}

If the code does not work try this.

I think the update statement do not need any variables since it is only updating.

script sql -1,{

OnAgitBreak:

query_sql("select `guild_id` from `woe_record` where `guild_id` = '"+getcharid(2)+"'",.@ignore);

if (getarraysize(.@ignore)>0) {

query_sql("update `woe_record` set `id` = `id`+1 where `guild_id` = '"+getcharid(2)+"'");

}

OnAgitEnd :

query_sql("select `guild_id` from `woe_record` where `guild_id` = '"+getcharid(2)+"'",.@ignore);

if (getarraysize(.@ignore)>0) {

query_sql("update `woe_record` set `castle_id` = '"+getcastlename(2)+"' where `guild_id` = '"+getcharid(2)+"'");

}

}

Edited December 22, 2011 by JayPeeMateo

[WordsUp]

then if .@ignore is no need then i can make it like this one?

if (query_sql("select `guild_id` from `woe_record` where `guild_id` = '"+getcharid(2)+"'")) {

query_sql("update `woe_record` set `id` = `id`+1 where `guild_id` = '"+getcharid(2)+"'");

}

[Emistry]

since you are using SELECT , you need a variable to store it....so ... .@ignore is needed in SELECT case

when you using UPDATE , there is not needed to use the .@ignore since nothing is used to save in that variable...

correct me if i was wrong..>.<

[WordsUp]

it still not recording on my sql

[Emistry]

i guess you are trying to update the point when the WOE End after the Guild has conquered the Castle...

try this

set .@i,getcastledata( "prtg_cas03",1 );
query_sql("UPDATE `woe_record` SET `id` = `id`+1 WHERE `guild_id` ="+.@i+"");

in your previous case...it wont work..because it need a player to be attached in order to get the information of getcharid( )

hope this work for you ~

[WordsUp]

getcharid(2) is use to find a guild name right?

[Emistry]

*getcharid(<type>{,"<character name>"})

This function will return a unique ID number of the invoking character, or, if a 
character name is specified, of that character.

Type is the kind of associated ID number required:

0 - Character ID number.
1 - Party ID number.
2 - Guild ID number.
3 - Account ID number.
4 - Battle ground ID

it use to find those ID....

but it required a Player to attach to it.....

[WordsUp]

i need to attach a player also hmm i will search about that.

[JayPee]

here

- attachrid(<account ID>)

- detachrid;

Like this?

script sql -1,{

OnAgitBreak:

attachrid(getcharid(3),strcharinfo(0));

query_sql("select `guild_id` from `woe_record` where `guild_id` = '"+getcharid(2)+"'",.@ignore);

if (getarraysize(.@ignore)>0) {

query_sql("update `woe_record` set `id` = `id`+1 where `guild_id` = '"+getcharid(2)+"'");

}

OnAgitEnd :

attachrid(getcharid(3),strcharinfo(0));

query_sql("select `guild_id` from `woe_record` where `guild_id` = '"+getcharid(2)+"'",.@ignore);

if (getarraysize(.@ignore)>0) {

query_sql("update `woe_record` set `castle_id` = '"+getcastlename(2)+"' where `guild_id` = '"+getcharid(2)+"'");

}

}

Edited December 22, 2011 by JayPeeMateo

[Emistry]

*getcharid(<type>{,"<character name>"})

This function will return a unique ID number of the invoking character, or, if a
character name is specified, of that character.

Type is the kind of associated ID number required:

0 - Character ID number.
1 - Party ID number.
2 - Guild ID number.
3 - Account ID number.
4 - Battle ground ID

it use to find those ID....

but it required a Player to attach to it.....

In order to make use of above Command....you must have provide a Players ID to be attached...or the Player it self must "CLICK" on this NPC..

you cant use any getcharid without a players is attachable.....

attachrid(getcharid(3),strcharinfo(0));

even though you try to make use of attachrid...but your getcharid is unable to attach a players to get the info of getcharid(3)

[JayPee]

Aw I didnt notice that XD.

I think he needs to know what castle has been conquered and then query first the castle holders/owners in the guild_caste db and then query them in woe_record db if they exist (update) and not exist(Insert)?

Edited December 22, 2011 by JayPeeMateo

[Z3R0]

I thought OnAgitBreak: carried char over, from the mob death triggered event...

does it not?

[Emistry]

....i didnt realize there is a ...OnAgitBreak Event...i just saw OnAgitEnd ... after all...the above answer / solution...is....useless..

[WordsUp]

i see OnAgitBreak: on agit_template.txt so i need to put that in there?