[Gesior acc. maker] Shopsystem: NEW offer_types

[dox]

Nam changer need help
Can some1 creat for me MYSQL table with z_shop_history_changename

Also i've got problem with changename script when a player changing name and it's taken then i've got an error

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

It's any chance to change it for some txt like This name its taken or something.

 

[dox]

Someone can help me ?

 

[tuffe77]

Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\shopsystem.php on line 98
how can i fix it

 

[aantoon1]

SQL-fråga:

INSERT INTO `z_shop_offer` ( `id` , `points` , `itemid1` , `count1` , `itemid2` , `count2` , `offer_type` , `offer_description` , `offer_name` , `level` , `pid` )
VALUES (
NULL , 50, 2160, 50, 0, 0, 'itemlogout', '50 Crystal Coins', 'itemlogout', 0, 10
),

MySQL sa: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

 

[Alassam]

Aantoon:

at the end of your SQL query. dont use a , but use a ;

So:

INSERT INTO `z_shop_offer` ( `id` , `points` , `itemid1` , `count1` , `itemid2` , `count2` , `offer_type` , `offer_description` , `offer_name` , `level` , `pid` )
VALUES (
NULL , 50, 2160, 50, 0, 0, 'itemlogout', '50 Crystal Coins', 'itemlogout', 0, 10
);

 

[Muzode]

Look: #1054 - Unknown column 'level' in 'field list'


what should i do?

 

[Arrish]

Can i use this yo my 0.2.2 mystic spirit? . and is this a webpage there you can do acc,donate and so on ?.

 

[Arlaxis]

it isn't work with 0.2 tfs

 

[r0ck3r0]

any chance to put at shop a buy Storage, i mean for storage value, those who have vip system whit storage must wish whit that (me).

btw, nice code.. work 100% for me! thx

 

[grzechopl]

When unban on tfs 0,2 will work ?

 

[Konieczko171]

Good Job. :]

 

[Limannen]

If 0.2 users have problem with this, then use this instead:

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

INSERT INTO `z_shop_offer` (`id`, `points`, `itemid1`, `count1`, `itemid2`, `count2`, `offer_type`, `offer_description`, `offer_name`, `pid`, `free_cap`) VALUES (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);

/Limannen

 

[Cotizado]

good idea We really need this

true and make the guild hall only for leaders of 5+ members

 

[Yol]

work for tfs 0.3.5???

 

[Rizzla]

I get this error:

#1062 - Duplicate entry '1' for key 'PRIMARY'

why?

 

[kokosal]

Nice

Yess, nice, but where should i write the things in phpmyadmin?

 

[kokosal]

Dude, Where should i write the thing in phpmyadmin?

 

[kokosal]

Dude, where should i write; ALTER TABLE `z_shop_offer` ADD `pid` INT( 11 ) NOT NULL DEFAULT '0'; in phpmyadmin? On players?

 

[daisaku101]

Invalid name format of new name.

When someone has points and tries to buy an item, it says:
Invalid name format of new name.

 

[daisaku101]

when someone has points and tries to buy an item, it says:
Invalid name format of new name.

solved