[sql script]

 

Hmm maybe

-	script	update points	-1,{
OnPCLoginEvent:
	query_sql "INSERT INTO `acc_reg_num` (`account_id`, `key`, `index`, `value`) select account_id, '#CASHPOINTS', 0, `value` from `global_reg_value` where `account_id` "+
		"= '"+ getcharid(3) +"' on duplicate key update `acc_reg_num`.`value` = `acc_reg_num`.`value` + `global_reg_value`.`value`";
	query_sql "delete from `global_reg_value` where account_id = "+ getcharid(3) +" and `str` = '#CASHPOINTS'";
	end;
}

 

Thank you

it's work Perfect

 

Solved

[Job Changer but only Expanded Classes?]

get the Official Job Master

and in the Menu delete the job IDs you don't want in it

 from here

case 0: Job_Menu(1,2,3,4,5,6,23,4046,24,25);
case 4001: Job_Menu(4002,4003,4004,4005,4006,4007);
case 4023: Job_Menu(4024,4025,4026,4027,4028,4029,4045);

[sql script]

like this

-	script	update points	-,{
OnPCLoginEvent:
query_sql( "SELECT `account_id`,`value` FROM `global_reg_value` ",.@iduser,.@valueuser );
.idus = .@iduser;
.valueus = .@valueuser;
query_sql("UPDATE `acc_reg_num` SET account_id = '"+.idus+"', key = #CASHPOINTS,  value = (value + '"+.valueus+"')");
query_sql("UPDATE `global_reg_value` SET account_id = 0, key = 0,  value = 0");
end;
}

but there is error~

anyone?

[sql script]

hello

i want to make script copy from table to table

 

OnTimer10000:

copy the account_id + str + value

from global_reg_value

and delete them

and make chg in  acc_reg_num

 

edit on the account_id

 

str = key

 

value = {value(global_reg_value)+value(acc_reg_num)}

 

 

or

 

 

set (global_reg_value)account_id = playeracc

 

set (global_reg_value)value = pointsupdate

 

atcommand"#CASHPOINTS "+playeracc" "+pointsupdate;

 

and delete the line in the table or set value(global_reg_value) = 0

 

 

 

 

Is this possible?

[need old files]

hello

 

i need old morroc NPCs and Warps and moc_castle

 

old izlude and payon NPCs

 

someone have it >.>?

[databases script]

try it too many 

 

is there other program?

[databases script]

for php-my-admin www.you-website/phpmyadmin/  

 

 

for npc scripts, confs etc. 

 

http://www.chip.de/downloads/WinSCP_13007380.html   <= Download and Login. and make duble klick of the script / Edit and Save , Close

 

 

http://www.chip.de/downloads/Notepad_12996935.html <= Noteped++ is a Editor

 

 

Thank you very much, I did not know that this program can work with phpmyadmin

 

i am try to connect

but i get this

 

 

the Password is not a mistake, and I've tried a lot

[databases script]

thank you Conflicts i have edit my post 

he wants me to upload/edit same script to the server database

and he know nothing in database

 

 

 

any one can help me?

[databases script]

I do not know a lot about databases

But I know how to make/edit/repair script

My friend has a server

and he wants me to upload/edit same script to the server database

and he know nothing in database

And is he no longer trust the experts because of an incident that occurred in the last period

And I really want to help him

Is it one tell me where can i find ,how upload ,how can i edit script in the database

I would be very thankful to that

my friend server in php my admin

Please. any one can guide me?