[Gesior acc. maker] Shopsystem: NEW offer_types

[xTremoxx]

Use this one:

INSERT INTO `z_shop_offer` (`id`, `points`, `itemid1`, `count1`, `itemid2`, `count2`, `offer_type`, `offer_description`, `offer_name`, `pid`, `free_cap`) VALUES
(1, 10, 0, 12, 0, 0, 'pacc', 'Buy 12 days of premium account for yourself or your friend!', '12 Days of PACC', 0, 0),
(6, 10, 0, 0, 0, 0, 'redskull', 'Remove Red Skull!', 'Remove Red Skull', 0, 0),
(8, 10, 2160, 1, 0, 0, 'itemlogout', 'Crystal Coin', 'itemlogout', 10, 100),
(9, 2, 0, 0, 0, 0, 'changename', 'Change Name', 'changename', 0, 0),
(11, 1, 0, 0, 0, 0, 'unban', 'UNBAN ACCOUNT', 'Unban Account', 0, 0);

now say

#1054 - Unknown column 'free_cap' in 'field list'

 

[Zoriath]

add column 'free_cap'

 

[vakacjus]

(8, 10, 2160, 1, 0, 0, 'itemlogout', 'Crystal Coin', 'itemlogout', 10, 100),

What is this?

 

[Pitufo™]

Is just to receive an item when player is logged out from the server

 

[klekSu]

Thanks Pitufo, repp.

 

[god nacke]

one problem

Hello,change name remove red is correct,and crystal coin (invalid format of new name)what is the problem


thz for all.

 

[Saj]

This is great, good job!

 

[god nacke]

Hello,pitufo

hello, I would like to ask for a bag with various items like you do?

 

[Xampy]

If a player try to change his name to another that already exists, the website show me this error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Zhaoxin-0' for key 2' in C:\xampp\htdocs\shopsystem.php:569 Stack trace: #0 C:\xampp\htdocs\shopsystem.php(569): PDO->query('UPDATE `players...') #1 C:\xampp\htdocs\phaltera.php(202): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\shopsystem.php on line 569

Fix it please.

Thanks. Repp++

 

[Xampy]

~ Sorry for spam but I can't edit my last post ~

There's a little bug on line 216:

$main_content .= '$main_content .= '<tr bgcolor[COLOR="Red"]="[/COLOR]="#bf3100"><td align="center"><img src="item_images/'.$item['id'].'.jpg"></td><td><b>'.$item['name'].'</b> ('.$item['points'].' points)<br />'.$item['description'].'</td><td align="center">';

Change it to:

$main_content .= '$main_content .= '<tr bgcolor="#bf3100"><td align="center"><img src="item_images/'.$item['id'].'.jpg"></td><td><b>'.$item['name'].'</b> ('.$item['points'].' points)<br />'.$item['description'].'</td><td align="center">';

 

[EtilicArmy]

verify your table

It means that you have the ID 1 in use.

 

[Azcarer]

This was working great

 

[richux]

Very nice work! Thank you! rep++ you!

 

[richux]

Bugs?:

1)If you are online when buying remove redskull, it takes away your points and says that rs is removed, instead of saying "You have to be offline", but does NOT remove your redskull. This should be fixed, because there are much sstupid kids that dont read and they will just loose their points if they will not logoug when buying rs remover.

2)Receive Item on Logout is working ONLY if your arrow slot is free. If you got something in arrow slot, it takes away your points but does not give you your item, even if you free your slot and relog again after purchasing. Also this will cause much trouble between owners and STUPID donaters.

Question:
Why did you make function "Receive Item on Logout", if there was already "Items" option in gesiors shop system offers that he released, besides it worked even if your arrow slot was not free? Also I would like to know, if this script:

-- time (in seconds) between connections to SQL database by shop script
SQL_interval = 30

may cause laggs when there are already pretty much players online?

Thank you!

 

[richux]

@up

dahh, I see there are much mistakes in my english(cant edit my post -.-), but I hope you will get my point.

 

[l0lz]

Błąd

zapytanie SQL:

INSERT INTO `z_shop_offer` ( `id` , `points` , `itemid1` , `count1` , `itemid2` , `count2` , `offer_type` , `offer_description` , `offer_name` , `level` , `pid` )
VALUES (
NULL , 10, 0, 12, 0, 0, 'pacc', 'Buy 12 days of premium account for yourself or your friend!', '12 Days of PACC', 0, 0
), (
NULL , 10, 0, 0, 0, 0, 'redskull', 'Remove Red Skull!', 'Remove Red Skull', 0, 0
), (
NULL , 10, 2160, 1, 0, 0, 'itemlogout', 'Crystal Coin', 'itemlogout', 0, 10
), (
NULL , 2, 0, 0, 0, 0, 'changename', 'Change Name', 'changename', 0, 0
)

MySQL zwrócił komunikat: Dokumentacja
#1054 - Unknown column 'level' in 'field list'

wtf ?

 

[aguacato]

HELP ME PLX [email protected]

Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\shopsystem.php on line 59

 

[Exiled Pain]

Yep, everything is pretty nice, but like our partner says @up.. if you buy an item and you have your arrow slot with something on it, you get CHARGED and don't recive anything... and also in the REDSKULL department...same thing if you are online by accident and do that transaction... you loose points and well.. you wont get the RS removed..

Can someone post a fix?

Besides that, nice work and thanks for sharing.

 

[richux]

Yep, everything is pretty nice, but like our partner says @up.. if you buy an item and you have your arrow slot with something on it, you get CHARGED and don't recive anything... and also in the REDSKULL department...same thing if you are online by accident and do that transaction... you loose points and well.. you wont get the RS removed..

Can someone post a fix?

Besides that, nice work and thanks for sharing.

Yeah!

@Putifo
Rlly thank you for sharing this awesome piece of code, but it does not seem to be done

 

[Alassam]

Cant get the pictures to work. In /item_images/ I add id.jpg's but dont see any pictures. Any ideas ?

Anyone up for making some more offer_types ? sex change ? xp ?