Event Rewards Logs

[RyokoMVP]

hello i want to ask , before i use this script n SQL files work fine 100% , but now itsnt work again. my friend say now they dont use UPDATE and WHERE. but still error after i change it. can somebody help me?

 

Query_SQL("UPDATE `event_log` SET `won_by` = '" + Escape_SQL(StrCharInfo(0)) + "', `won_time` = NOW(), `price_id` = " + $get_item_id + ", `price_amount` = " + $get_item_amount + " WHERE `event` = 'Mr Password' AND `won_by` IS NULL");

 

Event_Log.sql

 

thanks for help

[Emistry]

I believe you should post the error you get or telling what things isn't working ... as well as the script.

[RyokoMVP]

: DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `event` = 'Mr Password' AND `won_by` IS NULL' at line 1
[Debug]: at script.c:15731 - INSERT INTO `event_log` SET `won_by` = 'RyokoMVP', `won_time` = NOW(), `price_id` = 607, `price_amount` = 1 WHERE `event` = 'Mr Password' AND `won_by` IS NULL
[Debug]: Source (NPC): Mr Password at prontera (141,175)
[sql]: DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `event` = 'Mr Password' AND `won_by` IS NULL' at line 1
[Debug]: at script.c:15731 - INSERT INTO `event_log` SET `won_by` = 'RyokoMVP', `won_time` = NOW(), `price_id` = 607, `price_amount` = 1 WHERE `event` = 'Mr Password' AND `won_by` IS NULL
 

[RyokoMVP]

bump

[Azeroth]

bump

You should post your WHOLE script instead of posting the script query. maybe Emistry can reproduce your errors.

[RyokoMVP]

this is my full scriptCluckers.txt

[RyokoMVP]

anyone help?

[Emistry]

query_sql("UPDATE `event_log` SET `won_by` = '" + escape_sql(strcharinfo(0)) + "', `won_time` = NOW(), `price_id` = " + $cluck_item_id + ", `price_amount` = " + $cluck_item_amount + " WHERE `event` = 'Cluckers' AND `won_by` = NULL");

[RyokoMVP]

@emistry : i already use your script , but still doesnt want to make a event log @phpmyadmin

 

are my event_log.sql already to old ?