[Gesior acc. maker] Shopsystem: NEW offer_types

[dawidzztop]

error

i have errors ... ;/

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'

 

[StreamSide]

#UP
Add the level table

 

[Tachi]

Im still getting the above errors.. i redownloaded it today(jan 1 2009 11:39 AM Central time.)

Anyways ill give you credit for getting th ideas and most of the coding right.. xD

Rep++++, once it's fixed 100% or you could give me some trouble shooting ideas..

i still cannot figure this out.. looked over the script and everything.. then again i dont know alot of php...

 

[Pitufo™]

i still cannot figure this out.. looked over the script and everything.. then again i dont know alot of php...

I really cant help you if YOU dont help to understand your problem! It is working for me with that script in TFS 0.3 Beta2+!

 

[Artii]

Great thanks, rep++

 

[malakam]

Plx Help To Me For Real MAp

add me plx [email protected]

 

[dawidzztop]

How do I add a table to level and how the copy shop to system.php I do not have information on shopSystem <_<

 

[GMNino]

can make this compatible for tfs 0.2 23?

 

[Pitufo™]

Last update: 3rd February 16:05
Newest version: 2.5 (Beta2)
Downloads(just replace this file for the one you have):
Mirror1

Credits(for this update):

Everyone who reported BUGs!
StreamSide - Helping me testing script!
And ME - For fixing your bug reports!

Fixes:
No more problems with:
"Invalid name format..."
Working offers 95% i guess

Added:
Added "free_cap" column at "z_shop_offer" for "itemlogout" offer, you can setup how manu free cap the player needs to receive item!

Removes
Removed "level" offer since if you added level and logged in the player will not update his health nor mana, etc!

SQL Queries needed:

ALTER TABLE `z_shop_offer` ADD `free_cap` INT( 11 ) NOT NULL DEFAULT '0';

ALTER TABLE `z_shop_offer` ADD `pid` INT( 11 ) NOT NULL DEFAULT '0';

Example of offers:

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);

NOTES:
Doesnt work for TFS 0.2

Please report any bugs at here!

Yours,
Pitufo

 

[dawidzztop]

Błąd

zapytanie SQL:

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 )

MySQL zwrócił komunikat: Dokumentacja
#1062 - Duplicate entry '1' for key 1

 

[Pitufo™]

Błąd

zapytanie SQL:

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 )

MySQL zwrócił komunikat: Dokumentacja
#1062 - Duplicate entry '1' for key 1

Im not PL! ENLGISH PLEASE!

 

[dawidzztop]

how to make such a division and the appearance of the table
???

ImageShack - Image Hosting :: divisionbk2.jpg

/\@up:already running

how to make such a division and the appearance of the table
???

ImageShack - Image Hosting :: divisionbk2.jpg[/QUOTE]

 

[Pitufo™]

@up

idk :/

 

[Tachi]

how to make such a division and the appearance of the table
???

ImageShack - Image Hosting :: divisionbk2.jpg

/\@up:already running

how to make such a division and the appearance of the table
???

ImageShack - Image Hosting :: divisionbk2.jpg

Im sure its some kind of layout that someone has.. it's probly custom you might as well ask the place you found it at if it;s custom or not and if not where they got it from....

 

[Pitufo™]

Im sure its some kind of layout that someone has.. it's probly custom you might as well ask the place you found it at if it;s custom or not and if not where they got it from....

You where having problems with the script right?

I already fix the script so there is no more errors

Link to Post: Here

 

[dawidzztop]

So, somebody tell me how to make such a division in the shop offer?

 

[Tachi]

Anyother thing that would be nice(duno if you could or not or if you ment to)

Make it so when someone buy's namechange, ect... it will show it on the tans history page!

Just an idea xD

 

[vakacjus]

It's will work at v0.3

 

[Pitufo™]

@up

Yes

 

[HeberPcL]

A good idea would add sales of New Key Recover!

Parabens by code.