• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[MyAAC][Plugin] Gesior Shop System

You need to add the images needed. Set the URL to your images-folder into your config.local.php.

PHP:
$config['item_images_url'] = '/images/items/';

Use THIS if you don't have the images needed.
Thats Works thanks so much :)
 
Hello,

How can I unhide my z_shop_offer ? Cuz in SQL I got information that my database got that table but can't found it and I know that table are hidden. I want to edit my shop offers without delete them. Thanks.
 
Hello,

A new version - v2.3 has just been released.

It fixes some common problems people notified me about:
Code:
* Fix problem with redirection after transaction has been made (PayPal redirect)
* Do not override config.php after install - may upset some users ;)
* Fix payment_type being ignored (Thanks to OtLand User: DukeeH)
* (internal) Moving some SQL to schema.sql

I am planning one more upgrade - for adding categories more easily either with admin panel or with custom config.
 

Attachments

  • myaac-gesior-shop-system-v2.3.zip
    430.4 KB · Views: 88 · VirusTotal
Hello,

A new version - v2.3 has just been released.

It fixes some common problems people notified me about:
Code:
* Fix problem with redirection after transaction has been made (PayPal redirect)
* Do not override config.php after install - may upset some users ;)
* Fix payment_type being ignored (Thanks to OtLand User: DukeeH)
* (internal) Moving some SQL to schema.sql

I am planning one more upgrade - for adding categories more easily either with admin panel or with custom config.

Lua:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'itemid1' in 'field list'


Backtrace:

#0 C:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php(135): PDO->exec('INSERT INTO `z_...')
#1 C:\xampp\htdocs\system\pages\admin\gifts.php(129): OTS_Base_DB->insert('z_shop_offer', Array)
#2 C:\xampp\htdocs\admin\index.php(62): include('C:\\xampp\\htdocs...')
#3 {main}

when I try to add an item
Post automatically merged:

the items does not appear, even after creating these columns
 
Last edited:
Hello,

A new version - v2.3 has just been released.

It fixes some common problems people notified me about:
Code:
* Fix problem with redirection after transaction has been made (PayPal redirect)
* Do not override config.php after install - may upset some users ;)
* Fix payment_type being ignored (Thanks to OtLand User: DukeeH)
* (internal) Moving some SQL to schema.sql

I am planning one more upgrade - for adding categories more easily either with admin panel or with custom config.
why when i chose dondation, for example 5euro, cick next, it goes to paypal page and try to dante 0,00....
 
why when i chose dondation, for example 5euro, cick next, it goes to paypal page and try to dante 0,00....

It's known problem, more users are reporting the problem to me.

It's problem with Paypal, not the plugin itself.

I reported the problem to Paypal: Bug in donation (donation amount is 0) (https://www.paypal-community.com/t5/Payments/Bug-in-donation-donation-amount-is-0/m-p/2666630)

It happens only if you set this

'payment_type' => '_donations'

If you set to:
'payment_type' => '_xclick'

Then it works.
 
It's known problem, more users are reporting the problem to me.

It's problem with Paypal, not the plugin itself.

I reported the problem to Paypal: Bug in donation (donation amount is 0) (https://www.paypal-community.com/t5/Payments/Bug-in-donation-donation-amount-is-0/m-p/2666630)

It happens only if you set this

'payment_type' => '_donations'

If you set to:
'payment_type' => '_xclick'

Then it works.
veryfited paypal account works well, but another still see 0,00
 
someone had this same erros and can help me?

1621806395935.png
Post automatically merged:

and the an other problem its the NEW(OLD) Outfits when the player logout.. with a new outfit or retro outfit dont appear the image correctly.

1621806934073.png
1621806948561.png

Some itens too.. like steel helmet etc...
 
Last edited:
someone had this same erros and can help me?

View attachment 59073
Post automatically merged:

and the an other problem its the NEW(OLD) Outfits when the player logout.. with a new outfit or retro outfit dont appear the image correctly.

View attachment 59074
View attachment 59075

Some itens too.. like steel helmet etc...

1)

Seems you don't have points field in your z_shop_offer table, I don't know why.

Go to phpmyadmin, delete z_shop_offer table.

Then add it again with the query:
Code:
CREATE TABLE IF NOT EXISTS `z_shop_offer` (
    `id` INT(11) NOT NULL auto_increment,
    `points` INT(11) NOT NULL DEFAULT 0,
    `itemid1` INT(11) NOT NULL DEFAULT 0,
    `count1` INT(11) NOT NULL DEFAULT 0,
    `itemid2` INT(11) NOT NULL DEFAULT 0,
    `count2` INT(11) NOT NULL DEFAULT 0,
    `offer_type` VARCHAR(255) DEFAULT NULL,
    `offer_description` text NOT NULL,
    `offer_name` VARCHAR(255) NOT NULL DEFAULT '',
    `hidden` TINYINT(1) NOT NULL DEFAULT 0,
    PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

2) What version of tibia are you using?
 
1)

Seems you don't have points field in your z_shop_offer table, I don't know why.

Go to phpmyadmin, delete z_shop_offer table.

Then add it again with the query:
Code:
CREATE TABLE IF NOT EXISTS `z_shop_offer` (
    `id` INT(11) NOT NULL auto_increment,
    `points` INT(11) NOT NULL DEFAULT 0,
    `itemid1` INT(11) NOT NULL DEFAULT 0,
    `count1` INT(11) NOT NULL DEFAULT 0,
    `itemid2` INT(11) NOT NULL DEFAULT 0,
    `count2` INT(11) NOT NULL DEFAULT 0,
    `offer_type` VARCHAR(255) DEFAULT NULL,
    `offer_description` text NOT NULL,
    `offer_name` VARCHAR(255) NOT NULL DEFAULT '',
    `hidden` TINYINT(1) NOT NULL DEFAULT 0,
    PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

2) What version of tibia are you using?
hey, im gonna try in few minutes, so i use 12.64
 
1)

Seems you don't have points field in your z_shop_offer table, I don't know why.

Go to phpmyadmin, delete z_shop_offer table.

Then add it again with the query:
Code:
CREATE TABLE IF NOT EXISTS `z_shop_offer` (
    `id` INT(11) NOT NULL auto_increment,
    `points` INT(11) NOT NULL DEFAULT 0,
    `itemid1` INT(11) NOT NULL DEFAULT 0,
    `count1` INT(11) NOT NULL DEFAULT 0,
    `itemid2` INT(11) NOT NULL DEFAULT 0,
    `count2` INT(11) NOT NULL DEFAULT 0,
    `offer_type` VARCHAR(255) DEFAULT NULL,
    `offer_description` text NOT NULL,
    `offer_name` VARCHAR(255) NOT NULL DEFAULT '',
    `hidden` TINYINT(1) NOT NULL DEFAULT 0,
    PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

2) What version of tibia are you using?
Works, thanks a lot, so only the problem now its the any outfits new and retro and any items don't appear.
 
Last edited:
Back
Top