jqkill
Prowler
- Joined
- Jan 21, 2013
- Posts
- 1,149
- Location
- West Coast, USA
- Society
- Calypso Rescue Team
- Avatar Name
- Test Jqkill Muffin
title says it all... is it on my end or for everyone?
etc etc etc.
webshop said:RXML run error: Query failed: Unknown column 'visible' in 'field list'
| <sqlquery host="SECRET" mysql-insert-id="var.refid" query="insert into misc.packages (environment, ecoID, name, internal, start, end, lastEcoUpdate, visible, price) values ('pro01', '1', 'Bronze', 'Bronze', 'INVALID', 'INVALID', '2014-09-23 15:12:43', '1', '50.00000 PED')">
| <else>
| <if variable="_.visible is 1">
| <packageToDB>
| <emit source="values" values="<package internal=\"Bronze\" end=\"INVALID\" price=\"50.00000 PED\" visible=\"1\" name=\"Bronze\" id=\"1\" start=\"INVALID\" updated=\"2014-09-23 15:12:43\" created=\"2014-05-22 12:49:01\" />","<package internal=\"Silver\" end=\"INVALID\" price=\"150.00000 PED\" visible=\"1\" name=\"Silver\" id=\"2\" start=\"INVALID\" updated=\"2014-12-18 15:10:19\" created=\"2014-05-22 12:54:21\" />","<package internal=\"Gold\" end=\"INVALID\" price=\"400.00000 PED\" visible=\"1\" name=\"Gold\" id=\"3\" start=\"INVALID\" updated=\"2014-12-18 15:10:57\" created=\"2014-05-22 12:54:43\" />","<package internal=\"Calypso Special Pack\" end=\"INVALID\" price=\"75.31001 PED\" visible=\"0\" name=\"Calypso Special Pack\" id=\"21\" start=\"INVALID\" updated=\"2014-06-05 12:18:01\" created=\"2014-06-05 12:18:01\" />","<package internal=\"Arkadia Special Pack\" end=\"INVALID\" price=\"75.31001 PED\" visible=\"0\" name=\"Arkadia Special Pack\" id=\"22\" start=\"INVALID\" updated=\"2014-06-10 09:44:31\" created=\"2014-06-10 09:44:31\" />","<package internal=\"Cyrene Special Pack\" end=\"INVALID\" price=\"75.31001 PED\" visible=\"0\" name=\"Cyrene Special Pack\" id=\"23\" start=\"INVALID\" updated=\"2014-06-16 08:48:05\" created=\"2014-06-16 08:48:05\" />","<package internal=\"srevive\" end=\"INVALID\" price=\"50.00000 PED\" visible=\"1\" name=\"Small Revive Pack\" id=\"41\" start=\"INVALID\" updated=\"2014-09-12 12:24:48\" created=\"2014-09-12 12:24:48\" />","<package internal=\"mrevive\" end=\"INVALID\" price=\"100.00000 PED\" visible=\"1\" name=\"Medium Revive Pack\" id=\"42\" start=\"INVALID\" updated=\"2014-09-23 13:01:44\" created=\"2014-09-12 12:25:45\" />","<package internal=\"lrevive\" end=\"INVALID\" price=\"500.00000 PED\" visible=\"1\" name=\"Large Revive Pack\" id=\"43\" start=\"INVALID\" updated=\"2014-09-23 13:01:59\" created=\"2014-09-12 12:26:26\" />","<package internal=\"compet5\" end=\"INVALID\" price=\"500.00000 PED\" visible=\"1\" name=\"ComPet 5 Deed Pack\" id=\"44\" start=\"INVALID\" updated=\"2014-09-12 12:29:39\" created=\"2014-09-12 12:29:39\" />","<package internal=\"compet10\" end=\"INVALID\" price=\"1000.00000 PED\" visible=\"1\" name=\"ComPet 10 Deed Pack\" id=\"45\" start=\"INVALID\" updated=\"2014-09-12 12:29:57\" created=\"2014-09-12 12:29:57\" />","<package internal=\"compet50\" end=\"INVALID\" price=\"5000.00000 PED\" visible=\"1\" name=\"ComPet 50 Deed Pack\" id=\"46\" start=\"INVALID\" updated=\"2014-09-12 12:31:27\" created=\"2014-09-12 12:31:27\" />","<package internal=\"compet100\" end=\"INVALID\" price=\"10000.00000 PED\" visible=\"1\" name=\"ComPet 100 Deed Pack\" id=\"47\" start=\"INVALID\" updated=\"2014-09-12 12:31:48\" created=\"2014-09-12 12:31:48\" />","<package internal=\"compet500\" end=\"INVALID\" price=\"50000.00000 PED\" visible=\"1\" name=\"ComPet 500 Deed Pack\" id=\"48\" start=\"INVALID\" updated=\"2014-09-12 12:32:06\" created=\"2014-09-12 12:32:06\" />","<package internal=\"smallua\" end=\"INVALID\" price=\"100.00000 PED\" visible=\"1\" name=\"Small Universal Ammo Pack\" id=\"49\" start=\"INVALID\" updated=\"2014-10-08 15:27:43\" created=\"2014-09-12 12:36:04\" />","<package internal=\"mediumua\" end=\"INVALID\" price=\"500.00000 PED\" visible=\"1\" name=\"Medium Universal Ammo Pack\" id=\"50\" start=\"INVALID\" updated=\"2014-10-08 15:27:59\" created=\"2014-09-12 12:36:22\" />","<package internal=\"largeua\" end=\"INVALID\" price=\"1000.00000 PED\" visible=\"1\" name=\"Large Universal Ammo Pack\" id=\"51\" start=\"INVALID\" updated=\"2014-10-08 15:28:29\" created=\"2014-09-12 12:36:43\" />","<package internal=\"petnametag\" end=\"INVALID\" price=\"50.00000 PED\" visible=\"1\" name=\"Pet Name Tag\" id=\"61\" start=\"INVALID\" updated=\"2014-10-15 10:44:56\" created=\"2014-10-15 10:44:56\" />","<package internal=\"petnametagbonus\" end=\"INVALID\" price=\"50.00000 PED\" visible=\"1\" name=\"Pet Name Tag Bonus Pack\" id=\"106\" start=\"INVALID\" updated=\"2015-01-12 16:36:58\" created=\"2015-01-12 16:36:58\" />","<package internal=\"au5\" end=\"INVALID\" price=\"250.00000 PED\" visible=\"1\" name=\"Arkadia Underground 5 Deed Pack\" id=\"121\" start=\"INVALID\" updated=\"2015-03-04 10:46:17\" created=\"2015-03-04 10:46:17\" />","<package internal=\"au10\" end=\"INVALID\" price=\"500.00000 PED\" visible=\"1\" name=\"Arkadia Underground 10 Deed Pack\" id=\"122\" start=\"INVALID\" updated=\"2015-03-04 10:46:31\" created=\"2015-03-04 10:46:31\" />","<package internal=\"au20\" end=\"INVALID\" price=\"1000.00000 PED\" visible=\"1\" name=\"Arkadia Underground 20 Deed Pack\" id=\"123\" start=\"INVALID\" updated=\"2015-03-04 10:46:49\" created=\"2015-03-04 10:46:49\" />","<package internal=\"au100\" end=\"INVALID\" price=\"5000.00000 PED\" visible=\"1\" name=\"Arkadia Underground 100 Deed Pack\" id=\"124\" start=\"INVALID\" updated=\"2015-03-04 10:47:05\" created=\"2015-03-04 10:47:05\" />","<package internal=\"sped\" end=\"INVALID\" price=\"100.00000 PED\" visible=\"1\" name=\"Small PED stack\" id=\"125\" start=\"INVALID\" updated=\"2015-03-09 10:38:33\" created=\"2015-03-09 10:38:33\" />","<package internal=\"mped\" end=\"INVALID\" price=\"300.00000 PED\" visible=\"1\" name=\"Medium PED stack\" id=\"126\" start=\"INVALID\" updated=\"2015-03-09 10:38:50\" created=\"2015-03-09 10:38:50\" />","<package internal=\"lped\" end=\"INVALID\" price=\"600.00000 PED\" visible=\"1\" name=\"Large PED stack\" id=\"127\" start=\"INVALID\" updated=\"2015-03-09 10:39:06\" created=\"2015-03-09 10:39:06\" />","<package internal=\"kingkongpack\" end=\"INVALID\" price=\"250.00000 PED\" visible=\"1\" name=\"KING KONG Starter Pack\" id=\"141\" start=\"INVALID\" updated=\"2015-03-24 17:09:39\" created=\"2015-03-24 17:09:39\" />","<package internal=\"sbox5\" end=\"INVALID\" price=\"50.00000 PED\" visible=\"1\" name=\"Strongbox 5\" id=\"181\" start=\"INVALID\" updated=\"2015-06-23 13:35:20\" created=\"2015-06-23 13:35:20\" />","<package internal=\"sbox10\" end=\"INVALID\" price=\"100.00000 PED\" visible=\"1\" name=\"Strongbox 10\" id=\"182\" start=\"INVALID\" updated=\"2015-06-23 13:35:54\" created=\"2015-06-23 13:35:54\" />","<package internal=\"sbox50\" end=\"INVALID\" price=\"500.00000 PED\" visible=\"1\" name=\"Strongbox 50\" id=\"183\" start=\"INVALID\" updated=\"2015-06-23 13:36:30\" created=\"2015-06-23 13:36:30\" />" variable="var.eco-packages">
| <handleEcoPackages>
| <if sizeof="var.call-service-error is 0">
| <nocache>
| <nocache>
| <nocache>
| <cache enable-protocol-cache="yes">
etc etc etc.