How to reset value in Table: acc_reg_num within scripts on selected time? (SOLVED)

[rakuzas]

Hello,

I want to make Stock Scripts Reset all player stock on 00:00 hour.. 

Below is my current example script : 

 

OnClock0951: 
	query_sql "delete from `acc_reg_num` where `key` = '#S1'";
	query_sql "delete from `acc_reg_num` where `key` = '#S2'";
	query_sql "delete from `acc_reg_num` where `key` = '#S3'";
	query_sql "delete from `acc_reg_num` where `key` = '#S4'";
	query_sql "delete from `acc_reg_num` where `key` = '#S5'";
	query_sql "delete from `acc_reg_num` where `key` = '#S6'";
	query_sql "delete from `acc_reg_num` where `key` = '#S7'";
	query_sql "delete from `acc_reg_num` where `key` = '#S8'";
	query_sql "delete from `acc_reg_num` where `key` = '#S9'";
	query_sql "delete from `acc_reg_num` where `key` = '#S10'";
	announce "[Stock Market] Our stock has been reset!",bc_all,0xFF0000;
	set $S_LastUpd$,"12:00";
	goto S_Fluc;
	end;

My current scripts sometimes make the map-server.exe broken/crash.. Not sure why..
Also, player who not relog.. Still can sell their current Stock.. And when ONLY IF they relog, the stock will be reset.. 

Already tried many ways.. But still somehow stuck.. Hope can get any guides.. Thank you..

Edited November 16, 2017 by rakuzas

[Emistry]

OnClock0951: 
	donpcevent strnpcinfo(3)+"::OnResetStock";
	announce "[Stock Market] Our stock has been reset!",bc_all,0xFF0000;
	set $S_LastUpd$,"12:00";
	goto S_Fluc;
	end;
	
OnResetStock:
	query_sql "DELETE FROM `acc_reg_num` WHERE `key` LIKE '#S%'";
	addrid(0);
	for (.@i = 1; .@i <= 10; .@i++) {
		setd("#S"+.@i, 0);
	}
	// dispbottom "Stock has reset.";
	end;

you can try something like this..... remove from SQL + attach online player and clear their variables.

[rakuzas]

Thanks.. So far it does not crashing my map-server.exe with your script.. 

But when check stock, it still shows up old stock data value.. When I buy BTC 100x it calculate with older stock data.. But I guess this is not a big deal since it solved when player relog.. 

Thank you Emistry for helping me out..  

Edited November 16, 2017 by rakuzas

[sumano98]

prontera,156,185,6	script	kdsjfhsdkfs	100,{
	mes "blah";
	next;
	if ( select( "Show me Top 7 highest Zeny", "Show me Top 5 highest Cash Points", "Show me Top 10 Gold Coin holder" ) == 1 ) {
		.@nb = query_sql( "select name, zeny from `char` left join login on `char`.account_id = login.account_id where group_id < 10 order by zeny desc limit 7", .@name$, .@zeny );
		for ( .@i = 0; .@i < .@nb; .@i++ )
			mes .@name$[.@i] +" - "+ .@zeny[.@i] +"Z";
	}
	else if ( @menu == 2 ) {
		.@nb = query_sql( "select name, value from `char` left join global_reg_value on `char`.account_id = global_reg_value.account_id left join login on `char`.account_id = login.account_id where global_reg_value.str = '#CASHPOINTS' and group_id < 10 group by `char`.account_id order by cast( value as signed ) desc limit 5;", .@name$, .@cash );
		for ( .@i = 0; .@i < .@nb; .@i++ )
			mes .@name$[.@i] +" - "+ .@cash[.@i] +" points.";
	}
	else {
		.@nb = query_sql( "select name, amount from inventory left join `char` on inventory.char_id = `char`.char_id left join login on `char`.account_id = login.account_id where nameid = 671 and group_id < 10 order by amount desc limit 10", .@name$, .@amount );
		for ( .@i = 0; .@i < .@nb; .@i++ )
			mes .@name$[.@i] +" - "+ .@amount[.@i] +" gold coins.";
	}
	close;
}

 

i need use this script but can use only show top zeny