Page system - Printable Version

Page system - Printable Version

+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: Script Help (/Forum-Script-Help)
+--- Thread: Page system (/Thread-Page-system)

Page system - Pidrila - 04-09-2013 03:53 AM

Hello everyone i have a little problem..
What i need is the page numeric system that shows the current page and the number of all pages on the dialog. like this - PAGE: [2/38]

There is a problem, because it's need to bee checking by mysql database. i have a script like auction script. but just modifieded..

Script: When item is adding to auction!

Code:

[FUNCTION f_auction_additem]

if (<argo.dispid> == i_platemail_chest) || (<argo.dispid> == i_platemail_leggings) || (<argo.dispid> == i_platemail_arms) || (<argo.dispid> == i_platemail_gloves) || (<argo.dispid> == i_platemail_gorget) || (<argo.dispid> == i_platemail_helm) || (<argo.baseid> == i_tourmaline) || (<argo.baseid> == i_tin) || (<argo.baseid> == i_bronze) || (<argo.baseid> == i_corrundum) || (<argo.baseid> == i_lead) || (<argo.baseid> == i_silver) || (<argo.baseid> == i_gold2) || (<argo.baseid> == i_titanium) || (<argo.baseid> == i_steel) || (<argo.baseid> == i_blackrock) || (<argo.baseid> == i_crystal) || (<argo.baseid> == i_inferno) || (<argo.baseid> == i_acid) || (<argo.baseid> == i_glory) || (<argo.baseid> == i_plazma) || (<argo.baseid> == i_aqua) || (<argo.baseid> == i_DarkKingdom) || (<argo.baseid> == i_aruguno)

serv.newitem i_bag

new.name <argo.name> auction chart

new.cont=<obj.findlayer.21.uid>

new.link=<argo.uid>

new.tag.category=1 // Te liksim Bows

new.dialog d_auction_sell_item

return 0

Auction sell item function, here item is adding in mysql database.

Code:

DB.EXECUTE "INSERT INTO <topobj.tag.auction_table>(uid, amount, category, name, currentbid, step, minimum_price, saletime, seller) VALUES('<link.uid>','<link.amount>','<eval <tag.category>>','<link.name>','<eval (<argtxt[1]>)>','0','0','99999999999','<src.uid>');"

DB.query "SELECT saletime FROM <topobj.tag.auction_table> WHERE uid='<link.uid>'"

if (<db.row.numrows> < 1)

    serv.log There was a problem when adding the item to the mysql database. Most likely the mysql database was not connected. 

    src.sysmessage Putting this item for auction failed.

    remove

else

    link.cont=<uid>

    cont=<topobj.tag.safebox_uid>

    src.consume <def.auction_fee> i_gold

    src.sysmessage The item is up for auction. 

endif

return 1

And this is when dialog opens and mysql selects items and showing on the dialog page..

Code:

//Mysql query that fetches the rows from <src.ctag.dialogindex> to <src.ctag.dialogindex>+8

DB.QUERY "SELECT * FROM <tag.auction_table> ORDER BY `id` DESC LIMIT <eval (<src.ctag.dialogindex>)>,<eval (<src.ctag.dialogindex>+8)>";

what i need is that when dialog opens, it will show how many pages are in the auction

that can be calculating by something like this

Code:

[b]src.ctag.allpages=<eval (((<ctag0.allitems>-1) / 7) + 1)>//how to check how many items are there?? because if i know how many items are there, then i can calculate by something like this

because in one page are 8 items in dialog! thats why -1) / 7) + 1)[/b]

PAGE:[<Page where are you>/<eval (<src.ctag.allpages>)>]

Please help me i someone is good a this.. and sorry for my bad english im not so good at it.. /facepalm/

RE: Page system - Pidrila - 04-09-2013 05:27 AM

sorry for double posting! i did it myself.. if anyone need it. here it is.. i did simply by taking out id from table and then calculate sum of id (items) in db, -1) / 7) + 1 ! Smile

script.

Code:

////PAGE SYSTEM

DB.QUERY "SELECT * FROM <tag.auction_table> ORDER BY `id` DESC LIMIT 99999999";

src.ctag.totalpages=<eval (((<db.row.0.id>-1) / 7) + 1)>

dtext 715 3 0481 Items: <eval (<db.row.0.id>)>

dtext 623 448 0481 Page: [<eval (<src.ctag.actualpage>)>/<eval (<src.ctag.totalpages>)>]

RE: Page system - Pidrila - 04-09-2013 11:07 PM

sorry for DP DP.. but there i get a problem..

in this script is for main page of dialog right??

Code:

DB.QUERY "SELECT * FROM <tag.auction_table> ORDER BY `id` DESC LIMIT 99999999";

 src.ctag.totalpages=<eval (((<db.row.0.id>-1) / 7) + 1)>

 dtext 715 3 0481 Items: <eval (<db.row.0.id>)>

 dtext 623 448 0481 Page: [<eval (<src.ctag.actualpage>)>/<eval (<src.ctag.totalpages>)>]

but now i need to get info from only one field in the database calling category..

i tryed to do something like this

Code:

DB.QUERY "SELECT * FROM <tag.auction_table> WHERE category='1' ORDER BY `id` DESC LIMIT 99999999";

 src.ctag.totalpages=<eval (((<db.row.0.id>-1) / 7) + 1)> 

 dtext 715 3 0481 Items: <eval (<db.row.0.id>)>

 dtext 623 448 0481 Page: [<eval (<src.ctag.actualpage>)>/<eval (<src.ctag.totalpages>)>]

but it's givving the same info as the main page.. i tryed to do <eval (<db.row.0.category>)> or <eval (<db.row.11.id>)> //11 is the field of category but there is no success.. maybe you could help me..
how to get info and then array it on dialog taking info only from one field in db and summing it like id or smth..

Okey i finished it myself..

if someone need it. here it is.

Code:

DB.QUERY "SELECT COUNT(*) as category1_items FROM <tag.auction_table> WHERE category='1'";

src.ctag.totalpages=<eval (((<db.row.0.category1_items>-1) / 7) + 1)>

dtext 715 3 0481 Items: <eval (<db.row.0.category1_items>)>

dtext 623 448 0481 Page: [<eval <src.ctag.actualpage>>/<eval <src.ctag.totalpages>>]