manuel Posted October 4, 2022 Posted October 4, 2022 (edited) hi. need update table sql but in consola . give warning prontera,150,187,5 script demosnpc 569,{ if( query_sql( "SELECT * FROM rush_mvp WHERE `char_id` = '"+getcharid(0)+"'", .@CharID) > 0) { query_sql("UPDATE `rush_mvp` SET `mvp_pontos` = (`mvp_pontos` + 1) WHERE `char_id` = "+ getcharid(0)+""); }else{ query_sql("INSERT INTO `rush_mvp` (`char_id`) VALUES ("+ getcharid(0) +")"); } end; } imghttps://prnt.sc/Rt8DWNhi2Hzw Edited October 4, 2022 by manuel Quote
0 Emistry Posted October 5, 2022 Posted October 5, 2022 SELECT * FROM rush_mvp WHERE `char_id` = '"+getcharid(0)+"'", .@CharID change to SELECT `char_id` FROM rush_mvp WHERE `char_id` = '"+getcharid(0)+"'", .@CharID or whatever that field was named for char id Quote
Question
manuel
hi. need update table sql but in consola . give warning
prontera,150,187,5 script demosnpc 569,{ if( query_sql( "SELECT * FROM rush_mvp WHERE `char_id` = '"+getcharid(0)+"'", .@CharID) > 0) { query_sql("UPDATE `rush_mvp` SET `mvp_pontos` = (`mvp_pontos` + 1) WHERE `char_id` = "+ getcharid(0)+""); }else{ query_sql("INSERT INTO `rush_mvp` (`char_id`) VALUES ("+ getcharid(0) +")"); } end; }
img
Edited by manuelhttps://prnt.sc/Rt8DWNhi2Hzw
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.