Ok... I still need help with my problems. I think I've figured out the paypal end but I can find NO information on the SQL problem as follows:
CREATE DEFINER=`root`@`localhost` PROCEDURE oxide.claim_donation(IN email_address VARCHAR(255))
BEGIN
set email_address = REPLACE(email_address,'@@','@');
set @ID = (
select IBN.id
from oxide.ibn_table as IBN
where IBN.iemail = email_address
and IBN.claimed = 0
and IBN.claim_date IS NULL
and IBN.ipaymentstatus = "Completed"
ORDER BY IBN.itransaction_date DESC
LIMIT 1);
UPDATE oxide.ibn_table
SET claimed = 1, claim_date = NOW()
WHERE id = @ID;
select IBN.item_name
from oxide.ibn_table as IBN
where IBN.id = @ID;
END
I get an error on line 4.
set email_address = REPLACE(email_address,'@@','@');
Am I supposed to change something here? If so whats the format?
Merged postWell this really sucks. Would really like to get this plugin working. As I stated the first time it would be great if we had access to the YEARS of Knowalge now lost in the old OXIDE Forums NOT TO POST but to search for answers. I could have had this plugin running by now and not had to bother anyone. Also the CODE not displaying i'm refering to is on ALL of the main plugin pages here on UMOD, I said nothing about the forums. For referance the SQL code on the Donation Claim main page on UMOD is imposable to read has no format and wont copy paste into the SQL querry properly and fails because it lacks the proper format. I had to go to the OXIDE plugin page just to get the SQL and the PHP files in the correct format, sorry if I sound a lil pissy but you came down on me about OXIDE without taking a moment to read fully what I was asking then you ignore my problem with the plugin all together. I understand your busy but DAMN...
