[Gesior Shop-System] Shop Admin Page v4

[armaden]

ok, thx

but now, when i try delete offert from shop i have error:

Fatal error: Call to undefined function getorder() in C:\xampp\htdocs\shopadmin.php on line 262

 

[Norix]

Add this to config-and-functions.php at the last line before ?>

function makeOrder($arr, $order, $default) {
    // Function by Colandus!
    $type = 'asc';
    if(isset($_GET['order'])) {
        $v = explode('_', strrev($_GET['order']), 2);
        if(count($v) == 2)
            if($orderBy = $arr[strrev($v[1])])
                $default = $orderBy;
                $type = (strrev($v[0]) == 'asc' ? 'desc' : 'asc');
    }
    
    return 'ORDER BY ' . $default . ' ' . $type;
}

function getOrder($arr, $order, $this) {
    // Function by Colandus!
    $type = 'asc';
    if($orderBy = $arr[$this])
        if(isset($_GET[$order])) {
            $v = explode('_', strrev($_GET[$order]), 2);
            if(strrev($v[1]) == $this)
                $type = (strrev($v[0]) == 'asc' ? 'desc' : 'asc');
        }
    
    return $this . '_' . $type;
}

 

[HeberPcL]

You can create a button to edit the list of items?

Delete/Edit

 

[chricke90]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pid' in 'field list'' in C:\xampp\htdocs\shopadmin.php:138 Stack trace: #0 C:\xampp\htdocs\shopadmin.php(138): PDO->query('INSERT INTO `z_...') #1 C:\xampp\htdocs\index.php(178): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\shopadmin.php on line 138

This happends when I tried to add an item in my shop :>

 

[Norix]

Wtf please read the ******* thread. This error was asked 1000 times. And now for the last time:
Make this in phpmyadmin:

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

 

[MartyX]

I have a problem with this

[24/05/2009 22:42:59] Lua Script Error: [GlobalEvent Interface] 
[24/05/2009 22:42:59] data/globalevents/scripts/shop.lua:onThink

[24/05/2009 22:42:59] luaDoAddContainerItem(). Container not found

[24/05/2009 22:43:00] Lua Script Error: [GlobalEvent Interface] 
[24/05/2009 22:43:00] data/globalevents/scripts/shop.lua:onThink

[24/05/2009 22:43:00] luaDoAddContainerItem(). Container not found

[24/05/2009 22:43:00] Lua Script Error: [GlobalEvent Interface] 
[24/05/2009 22:43:01] data/globalevents/scripts/shop.lua:onThink

[24/05/2009 22:43:01] luaDoAddContainerItem(). Container not found

[24/05/2009 22:43:01] Lua Script Error: [GlobalEvent Interface] 
[24/05/2009 22:43:02] data/globalevents/scripts/shop.lua:onThink

[24/05/2009 22:43:02] luaDoAddContainerItem(). Container not found

[24/05/2009 22:43:02] Lua Script Error: [GlobalEvent Interface] 
[24/05/2009 22:43:03] data/globalevents/scripts/shop.lua:onThink

[24/05/2009 22:43:03] luaDoAddContainerItem(). Container not found

That is what I have to add to the script???

 

[Nikkster]

I tested the script. Doesn't work, the page is blank.

And you need forgot to tell them that they need to change their location of the server in the script, on line 250~~.

 

[Pietia]

I tested the script. Doesn't work, the page is blank.

And you need forgot to tell them that they need to change their location of the server in the script, on line 250~~.

yes when u are coming into ip/index.php?subtopic=shopadmin it's blank but when u are coming into ip/index.php?subtopic=shopadmin&action=view it's working however u have to add like ballack said be4 this 2 functions to get working all also ballack u should add support for editing .

 

[r0ck3r0]

my first post, i think

ballack13 (Y) perfect! 100% work for me! read all thread..

u're tbest!

Thx

 

[Regenade]

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

And I cant see my shopr offers =(

What shuld I do? Please help

 

[Hannaah]

so wait, does this work with unnamed v 2.x ?

 

[TibiaGameHost]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pid' in 'field list'' in C:\xampp\htdocs\newot\shopadmin.php:121 Stack trace: #0 C:\xampp\htdocs\newot\shopadmin.php(121): PDO->query('INSERT INTO `z_...') #1 C:\xampp\htdocs\newot\index.php(106): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\newot\shopadmin.php on line 121

Help?

 

[Norix]

Update v3

Updated v3. Check first Post for more information!

 

[Saj]

V3 works fine for me!

 

[CvB]

Help?

I have the same problem ; /

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pid' in 'field list'' in /var/www/korek/shopadmin.php:121 Stack trace: #0 /var/www/korek/shopadmin.php(121): PDO->query('INSERT INTO `z_...') #1 /var/www/korek/index.php(213): include('/var/www/korek/...') #2 {main} thrown in /var/www/korek/shopadmin.php on line 121

 

[Norix]

Make this in phpmyadmin:

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

 

[r0ck3r0]

Updated v3. Check first Post for more information!

perfect but can add a pic for Add Points form..
i wont take script if its look like original add point form cuz i have it already xd

 

[Kask]

please norix, put for edit them too

 

[richux]

It isnt working for me. If I selecet offer type = item or any other the page just refreshes. Item isnt shoving up even if I add it manually trough db. Will have to use old one :s

 

[Quqen]

To: From: Offer name Bought on page Received on OTS
God Quqen Your account 0 16 August 2009, 21:51:27 Not realized yet

I get That wehn i buy the items i dont recive them at the server ;(

PLease help fast i REP +++