help Weight Changer Script

[spuri]

I did a small script that change the weight of items to 15. But has a infinite loop in script and I dont know whats wrong. Can anyone help me? Thanks and sorry for my bad english.

 

-    script    Weight15    -1,{

OnInit:

set .@i, 501;

while (.@i<13710){

if (getitemname(.@i)){

setiteminfo .@i,6,150;

}

set .@i, .@i + 1;

}

end;

}

 

 

PS: Server in txt.

Edited February 15, 2016 by Emistry
codebox

[Emistry]

you can improve it if you have loaded the updated SQL item_db .

.@size = query_sql( "SELECT `nameid` FROM `item_db` ",.@id );
while ( .@i < .@size ) {
	setiteminfo .@id[.@i],6,150;
	.@i++;
}

of course, depend on how large the result returned, you may need to use freeloop to avoid the infinity loop error.

or another trick would be slightly delay the execution of the script using sleep.

 

it would be even simpler if you just edit the weight at the SQL database and export it to text version after that.