Donator IPN problem, $3 to whoever fixes it ASAP!

[rigla]

Guys, i dont know what to do anymore i have installed this mod months ago and it was working, now i have reinstalled and cant add packs anymore. Maybe some other mods screwed it up or something i dont know.

This is the Donator IPN from Cronus.

When I try to Add New Donator Pack I get this error even if i fill in all fields etc.

QUERY ERROR: Column count doesn't match value count at row 1
Query was INSERT INTO items VALUES('','999','Test Pack','Desc','0','0','0', '0', '0', '0', '0', '1', '0', '0', '0')

 

I dont know what that "999" value is, the fields start from 'Test Pack'

I need this fixed asap dont have time for support tickets, ill paypal you $3 if you fix it for me today, need it up and running please.

Cheers!

edit: also, see all the 0(zeros) after the description field?..arent they supposed to show the values ive inserted for that fields? why i get 0's in the error display?

[wolfe]

Re: Donator IPN problem, $3 to whoever fixes it ASAP!

999 is the itemtype.

The 0's are the values you are inserting.

You probably changed something in your item table and are not using the correct number of fields in the insert. You'll need to go thru and match up your query with the fields in your item table.

Maybe submit a support ticket on cronwerks so that you can get some help.

[rigla]

Re: Donator IPN problem, $3 to whoever fixes it ASAP!

submited the report but Cronus never replies for problems that are not provoked by his scripts.

Both the item table and queries in my donator.php are matching...what could be it ? anyone have any ideeas? still didnt fix this

offer remains!

[wolfe]

Re: Donator IPN problem, $3 to whoever fixes it ASAP!

If you are getting the column count error still then they are not matching. You need to make sure you are accounting for every value in the item table if you are going to use that insert method.

[rigla]

Re: Donator IPN problem, $3 to whoever fixes it ASAP!

first, thank you very much for giving me attention man, you are the only one you rule.

here is the item db:

  itmid int(11)   No  auto_increment               
 itmtype int(11)   No 0                
 itmname varchar(255) utf8_unicode_ci  No                 
 itmdesc text utf8_unicode_ci  No                 
 itmbuyprice int(11)   No 0                
 itmsellprice int(11)   No 0                
 itmbuyable int(11)   No 0                
 effect1_on tinyint(4)   No 0                
 effect1 text utf8_unicode_ci  No                 
 effect2_on tinyint(4)   No 0                
 effect2 text utf8_unicode_ci  No                 
 effect3_on tinyint(4)   No 0                
 effect3 text utf8_unicode_ci  No                 
 weapon int(11)   No 0                
 armor int(11)   No 0                
 helmet int(11)   No 0                
 boots int(11)   No 0                
 amulet int(11)   No 0                
 braclet int(11)   No 0                
 ring int(11)   No 0                
 special int(11)   No 0                
 itmpic 

 

now im not sure anymore whats the query list in the donator.php, if you have it from cronus can you take a look and compare, im confused at which query should i look at there are a few..or let me know with which it should start...

cheers

[rigla]

Re: Donator IPN problem, $3 to whoever fixes it ASAP!

also, here is the sql for the donator mod, maybe it helps

-- Table structure for table `dpacks`
-- 

CREATE TABLE `dpacks` (
 `id` int(11) NOT NULL,
 `name` varchar(255) NOT NULL,
 `crystals` int(11) NOT NULL,
 `money` int(11) NOT NULL,
 `days` int(11) NOT NULL,
 `price` decimal(10,2) NOT NULL,
 `description` text NOT NULL,
 `items` int(11) NOT NULL,
 `active` int(11) NOT NULL DEFAULT '1',
 `hidden` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Table structure for table `dpitems`
-- 

CREATE TABLE `dpitems` (
 `dpid` int(11) NOT NULL,
 `itemid` int(11) NOT NULL,
 `quantity` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

Also, i thought its a standalone and has nothing to do with the item table, the mod comes with 2 php files and its own sql above..the matching must be between this sql and the query in the php file right, it is dependant on the item table too?

[wolfe]

Re: Donator IPN problem, $3 to whoever fixes it ASAP!

Probably shouldnt be posting his tables since its a paid mod.

The mod inserts a listing into the item table because it turns donator packs into "items"

You have 22 fields in your item table.

The query you have up there only inserts 15. You have to account for all 22 fields or tell it to insert specific data.

INSERT INTO items VALUES('','999','Test Pack','Desc','0','0','0', '0', '0', '0', '0', '1', '0', '0', '0',etc,etc,etc... 
you have to do this until you account for all the fields in your table).

 

Another way is to do it like this:

 

("INSERT INTO items (itmtype,itmname,itmdesc,effect3_on) VALUES('999','Testpack','Desc,'1')");

 

This code only inserts the needed info into the item table.

I do believe cronus has an updated version of this that you should be able to download.

[Cronus]

Re: Donator IPN problem, $3 to whoever fixes it ASAP!

I actually use the item_add function in the mod, so if he can fix the item_add function, it will work also.

However, wolfe's fix will do the job.

[wolfe]

Re: Donator IPN problem, $3 to whoever fixes it ASAP!

It looks like his issue is in the DP creation, not the crediting. Thats why i offered that one up. Item_Add is for inventory addition.

[Cronus]

Re: Donator IPN problem, $3 to whoever fixes it ASAP!

 

It looks like his issue is in the DP creation, not the crediting. Thats why i offered that one up. Item_Add is for inventory addition.

Silly me, I guess its still too early for me to think straight.

Sorry about that.

But yes, I will update the script asap so it uses your suggestion wolfe.

However atm I'm heading for breakfast. =P

[rigla]

Re: Donator IPN problem, $3 to whoever fixes it ASAP!

thank you very much, that did the trick and im happy ive learned something, when i get that error i need to match and update the query accordingly to the related table.

i feel so good now :mrgreen:

thanks again!

[wolfe]

Re: Donator IPN problem, $3 to whoever fixes it ASAP!

NP.