website shop

[Alkyron]

Hi all,

How do I put page (Page 1, Page 2, Page 3) with 4 per page item shop on MPOG site.
I managed to put on each page but it is every time the same item shop

Sorry for wong post, please move my post .

[MentaL]

[alfredao]

Wrong Section

[Alkyron]

Sorry , but alfredo in your shop how do I put page (Page 1, Page 2, Page 3) with 4 per page item shop on MPOG site.
I managed to put on each page but it is every time the same item shop
-_-

[alfredao]

In your CashShop DB create a column named Page. Put the number of page you want item stay.

In PHP code, put this

    switch( antisql($_GET['pagina']) )
          {
             case "1":
                 $pagina = "Page = 1";
             break;
             case "2":
                 $pagina = "Page = 2";
             break;
             case "3":
                 $pagina = "Page = 3";
             break;
             case "4":
                 $pagina = "Page = 4";
             break;
             default:
                 $pagina = "Page = 1";
             break;
          } 

$res = mssql_query("SELECT * FROM CashShop WHERE  ".$pagina." AND Opened = 1 

To change page:

index.php?do=cashshop&sub=listallitems&expand=1&pagina=1
index.php?do=cashshop&sub=listallitems&expand=1&pagina=2

[Alkyron]

x1000 thanks Alfredo !

[alfredao]

Ok, But next time post in right section.

[Alkyron]

Ok sorry for wrong post .

EDIT : For the table Page is INT and NULL ?

[alfredao]

Ok sorry for wrong post .

EDIT : For the table Page is INT and NULL ?

Yes .

[Alkyron]

I want change $pagina to $page ? its work ?

[alfredao]

Yes, Page = 1 You can't change.

[Alkyron]

switch( antisql($_GET['pagina']) )
          {
             case "1":
                 $pagina = "Page = 1";
             break;
             case "2":
                 $pagina = "Page = 2";
             break;
             case "3":
                 $pagina = "Page = 3";
             break;
             case "4":
                 $pagina = "Page = 4";
             break;
             default:
                 $pagina = "Page = 1";
             break;
          } 

to

switch ( $item['Slot'] ){
                                                        case "1";
                                                        $slot = "Ranged";
                                                        break;
                                                        case "2";
                                                        $slot = "Melee";
                                                        break;
                                                        case "3";
                                                        $slot = "Armor";
                                                        break;
                                                        case "4";
                                                        $slot = "Set";
                                                        break;
                                                        case "5";
                                                        $slot = "Special";
                                                        break;
                                                    } 

?

[alfredao]

switch( antisql($_GET['pagina']) )
          {
             case "1":
                 $pagina = "Page = 1";
             break;
             case "2":
                 $pagina = "Page = 2";
             break;
             case "3":
                 $pagina = "Page = 3";
             break;
             case "4":
                 $pagina = "Page = 4";
             break;
             default:
                 $pagina = "Page = 1";
             break;
          } 

to

switch ( $item['Slot'] ){
                                                        case "1";
                                                        $slot = "Ranged";
                                                        break;
                                                        case "2";
                                                        $slot = "Melee";
                                                        break;
                                                        case "3";
                                                        $slot = "Armor";
                                                        break;
                                                        case "4";
                                                        $slot = "Set";
                                                        break;
                                                        case "5";
                                                        $slot = "Special";
                                                        break;
                                                    } 

?

No, just add in your page.

switch( antisql($_GET['pagina']) )
          {
             case "1":
                 $pagina = "Page = 1";
             break;
             case "2":
                 $pagina = "Page = 2";
             break;
             case "3":
                 $pagina = "Page = 3";
             break;
             case "4":
                 $pagina = "Page = 4";
             break;
             default:
                 $pagina = "Page = 1";
             break;
          } 

[Alkyron]

$res = mssql_query("SELECT * FROM CashShop WHERE  ".$pagina." AND Opened = 1 

I put it where?

[alfredao]

$res = mssql_query("SELECT * FROM CashShop WHERE  ".$pagina." AND Opened = 1 

I put it where?

Put only ".$pagina." in code where you select itens from your db.

[Alkyron]

".$type." 

to

".$pagina." 

?

[alfredao]

".$type." 

to

".$pagina." 

?

No, add in your code.

[Alkyron]

I do not see it? where is it please ?