[solved] shoopinglua is not empty , but....

A shopping addon for Roster

Moderator: Hannah

Write comments

[solved] shoopinglua is not empty , but....

Postby shan_aya » Sat Aug 12, 2006 2:05 pm

shoppinglist = {
}
shoppinglist = {

}
shoppinglist = {

}


no item...so wow addon doesnt work

uniloader write in file but nothing...without error
Last edited by shan_aya on Wed Aug 16, 2006 8:37 pm, edited 1 time in total.
shan_aya
WR.net Journeyman
WR.net Journeyman
 
Posts: 132
Joined: Fri Aug 11, 2006 12:58 pm
Top

Re: shoopinglua is not empty , but....

Postby Hannah » Sat Aug 12, 2006 4:49 pm

So you didn´t make an order in the roster shopping addon...

UniUploader only fills the file if there is an order in DB

Hope this helps

Hannah
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne
Top

Re: shoopinglua is not empty , but....

Postby shan_aya » Sun Aug 13, 2006 2:26 pm

no no,
i make an order,
roster saying .... Order in queue! Automated WoW-Upload with UniUploader! ...continue shopping

i selecte many "to deliver" but nothing in wow shopping addon

so i open file shopping.lua... only shoppinglist with no items


another thing : only items that I made works (alchemy)... other member's craft is not accessible with cart... if select : blank page (forge)

http://genesis.e-oxyde.ath.cx/roster/ad ... e=shopping
shan_aya
WR.net Journeyman
WR.net Journeyman
 
Posts: 132
Joined: Fri Aug 11, 2006 12:58 pm
Top

Re: shoopinglua is not empty , but....

Postby Hannah » Sun Aug 13, 2006 4:18 pm

Hi again!

I see the problem now :)

Have you checked your DB?

Try to look at it if you place a new order (made by your char or other)
if he writes it to the DB.

Check out roster_addon_shopping table there should be your order...

Check this and tell me about it :)

Thx Hannah

EDIT:
Btw your the first one with this problem, maybe it´s french localization or mysql setting... (maybe, i don´t know)
Last edited by Hannah on Sun Aug 13, 2006 4:19 pm, edited 1 time in total.
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne
Top

Re: shoopinglua is not empty , but....

Postby shan_aya » Sun Aug 13, 2006 9:16 pm

thx for short timed answer ^^

my db is ok, with items added in cart...

Résultat de la requête SQL

Serveur: localhost
Base de données: genesis
Généré le : Dimanche 13 Août 2006 à 20:03
Généré par: phpMyAdmin 2.6.4-pl4-Debian-2 / MySQL 4.1.15-Debian_1-log
requête SQL: SELECT * FROM `roster_addon_shopping` LIMIT 0, 30 ;
Enregistrements: 13
order_number order_item order_quantity order_maker order_requester order_maxprice order_note order_price_demand order_date order_state order_info
1 Teinture fantôme 1 Felysaya Mulevente 0 0 2006-08-12 09:08:40 outbox
2 Beignet de crabe 1 Felysaya Mulevente 0 0 2006-08-12 09:08:40 outbox
3 Barracuda luisant cuit 1 Felysaya Mulevente 0 0 2006-08-12 09:22:16 outbox
4 Bandage épais en laine 1 Felysaya Mulevente 0 0 2006-08-12 09:22:16 outbox
5 Teinture fantôme 1 Felysaya Orfeus 0 0 2006-08-12 10:16:52 outbox
6 Pierre philosophale 1 Felysaya Mulevente 0 0 2006-08-12 10:39:07 outbox
7 Teinture fantôme 2 Felysaya Aknoth 0 0 2006-08-12 12:34:36 outbox
8 Viande de sanglier rôtie 1 Felysaya Mulevente 0 0 2006-08-12 12:35:54 outbox
9 Pierre philosophale 1 Felysaya Felysaya 0 0 2006-08-12 13:06:21 outbox
10 Teinture fantôme 1 Felysaya Mulevente 0 0 2006-08-12 13:07:39 outbox
11 Bandage en tisse-mage 1 Orfeus Felysaya 0 0 2006-08-13 04:22:54 outbox
12 Pierre philosophale 1 Felysaya Felysaya 0 0 2006-08-13 13:11:56 outbox
13 Pierre philosophale 1 Felysaya Felysaya 0 0 2006-08-13 20:02:14 outbox

but in uniloader, serveur answer, 2nd windows show only shoppinglist={}, no data

debug :
[2006/08/13 18:26:00] RetrData: ------------------------------------------------------------------------
[2006/08/13 18:26:00]
[2006/08/13 18:26:00] Chargement sur l'URL primaire...: http://genesis.e-oxyde.ath.cx/roster/admin/update.php
[2006/08/13 18:26:00] GuildProfiler.lua - 11% Compressé. Taille: 0,08 KB
[2006/08/13 18:26:00] Shopping.lua - 81% Compressé. Taille: 0,05 KB
[2006/08/13 18:26:00] SavedVariables.lua - 47% Compressé. Taille: 0,25 KB
[2006/08/13 18:26:00] PvPLog.lua - 85% Compressé. Taille: 0,29 KB
[2006/08/13 18:26:00] CharacterProfiler.lua - 85% Compressé. Taille: 60,28 KB
[2006/08/13 18:26:05] Chargement sur l'url additionnelle # 1... - http://genesis.e-oxyde.ath.cx/roster/ad ... e=shopping
[2006/08/13 18:26:05] GuildProfiler.lua - 11% Compressé. Taille: 0,08 KB
[2006/08/13 18:26:05] Shopping.lua - 81% Compressé. Taille: 0,05 KB
[2006/08/13 18:26:05] SavedVariables.lua - 47% Compressé. Taille: 0,25 KB
[2006/08/13 18:26:05] PvPLog.lua - 85% Compressé. Taille: 0,29 KB
[2006/08/13 18:26:05] CharacterProfiler.lua - 85% Compressé. Taille: 60,28 KB
[2006/08/13 18:26:06]
[2006/08/13 18:26:06] RetrData: url: http://genesis.e-oxyde.ath.cx/roster/ad ... e=shopping
[2006/08/13 18:26:06] RetrData: param1: OPERATION
[2006/08/13 18:26:06] RetrData: val1: GETDATA
[2006/08/13 18:26:06] RetrData: param2: username
[2006/08/13 18:26:06] RetrData: val2: *****
[2006/08/13 18:26:06] RetrData: param3: password
[2006/08/13 18:26:06] RetrData: val3: *****
[2006/08/13 18:26:06] RetrData: Timeout: -1
[2006/08/13 18:26:06] RetrData: ------------------------------------------------------------------------
[2006/08/13 18:26:06] shoppinglist = {
[2006/08/13 18:26:06]
[2006/08/13 18:26:06] }
[2006/08/13 18:26:06] RetrData: ------------------------------------------------------------------------
[2006/08/13 18:26:06]

and can you explain where i can filled "price" and "note" ?
i'm very interrresting with this fonction ( trying to do a guild market with "dkp" style points)
Last edited by shan_aya on Sun Aug 13, 2006 9:26 pm, edited 2 times in total.
shan_aya
WR.net Journeyman
WR.net Journeyman
 
Posts: 132
Joined: Fri Aug 11, 2006 12:58 pm
Top

Re: shoopinglua is not empty , but....

Postby Hannah » Sun Aug 13, 2006 9:36 pm

Hi again!

Do you have gz compression set ?

This could be a problem.

In the moment note and price is not yet in use, but i´m working on that...
So give me some time and it will be ready for use :)

Hope it helps

Hannah
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne
Top

Re: shoopinglua is not empty , but....

Postby shan_aya » Sun Aug 13, 2006 9:58 pm

oki i stop gz compression... but nothing

and shopping_list.lua on my ftp is blank....


if i fill this file by myself, and try uniloader : blank list
if -------------------------, and use roster, file is changed and blank again on th ftp
Last edited by shan_aya on Sun Aug 13, 2006 10:09 pm, edited 1 time in total.
shan_aya
WR.net Journeyman
WR.net Journeyman
 
Posts: 132
Joined: Fri Aug 11, 2006 12:58 pm
Top

shoopinglua is not empty , but....

Postby Hannah » Mon Aug 14, 2006 11:43 am

Hi!

Do the following...
Edit index.php in addons/shopping folder on line 81 add this line:
Code: Select all
echo "\n Sql-query: SELECT * FROM ".$db_prefix."addon_shopping WHERE order_state ='outbox' \n";
echo $sel_order."\n";
 


add this after line 113:
Code: Select all
echo "\n Counter: ".$counter;
 


This is only for debuging needed...:)

Tell me the output plz.

CU Hannah
Last edited by Hannah on Mon Aug 14, 2006 11:45 am, edited 1 time in total.
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne
Top

Re: shoopinglua is not empty , but....

Postby shan_aya » Mon Aug 14, 2006 2:09 pm

if i do what you want correctly ^^

[2006/08/14 11:08:43] Initializing Application
[2006/08/14 11:08:43] .NET Framework v1.1.4322
[2006/08/14 11:08:44]
[2006/08/14 11:08:44] RetrData: url: http://www.wowroster.net/uniuploader_up ... update.php
[2006/08/14 11:08:44] RetrData: param1: OPERATION
[2006/08/14 11:08:44] RetrData: val1: GETLICMD5
[2006/08/14 11:08:44] RetrData: Timeout: 20000
[2006/08/14 11:08:44] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:08:44] 3e51ce44ec803bd6bc42e7d8870f5962
[2006/08/14 11:08:44] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:08:44]
[2006/08/14 11:08:44] MD5SUM of local LICENSE.TXT: 3e51ce44ec803bd6bc42e7d8870f5962
[2006/08/14 11:08:45]
[2006/08/14 11:08:45] RetrData: url: http://genesis.e-oxyde.ath.cx/roster/ad ... e=shopping
[2006/08/14 11:08:45] RetrData: param1: OPERATION
[2006/08/14 11:08:45] RetrData: val1: GETDATA
[2006/08/14 11:08:45] RetrData: param2: username
[2006/08/14 11:08:45] RetrData: val2:
[2006/08/14 11:08:45] RetrData: param3: password
[2006/08/14 11:08:45] RetrData: val3:
[2006/08/14 11:08:45] RetrData: Timeout: -1
[2006/08/14 11:08:45] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:08:45]
[2006/08/14 11:08:45] Sql-query: SELECT * FROM 2roster_addon_shopping WHERE order_state ='outbox'
[2006/08/14 11:08:45] Resource id #17
[2006/08/14 11:08:45]
[2006/08/14 11:08:45] Counter: 1shoppinglist = {
[2006/08/14 11:08:45]
[2006/08/14 11:08:45] }
[2006/08/14 11:08:45] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:08:45]
[2006/08/14 11:08:46]
[2006/08/14 11:08:46] RetrData: url: http://www.wowroster.net/uniuploader_up ... update.php
[2006/08/14 11:08:46] RetrData: param1: OPERATION
[2006/08/14 11:08:46] RetrData: val1: GETLANGMD5
[2006/08/14 11:08:46] RetrData: Timeout: 20000
[2006/08/14 11:08:46] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:08:46] e974d4962bc2282b4816a294bc2a568d
[2006/08/14 11:08:46] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:08:46]
[2006/08/14 11:08:46] MD5SUM of local languages.ini: e974d4962bc2282b4816a294bc2a568d
[2006/08/14 11:08:46]
[2006/08/14 11:08:46] RetrData: url: http://genesis.e-oxyde.ath.cx/roster/ad ... e=shopping
[2006/08/14 11:08:46] RetrData: param1: OPERATION
[2006/08/14 11:08:46] RetrData: val1: GETDATA
[2006/08/14 11:08:46] RetrData: param2: username
[2006/08/14 11:08:46] RetrData: val2:
[2006/08/14 11:08:46] RetrData: param3: password
[2006/08/14 11:08:46] RetrData: val3:
[2006/08/14 11:08:46] RetrData: Timeout: -1
[2006/08/14 11:08:46] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:08:46]
[2006/08/14 11:08:46] Sql-query: SELECT * FROM 2roster_addon_shopping WHERE order_state ='outbox'
[2006/08/14 11:08:46] Resource id #17
[2006/08/14 11:08:46]
[2006/08/14 11:08:46] Counter: 1shoppinglist = {
[2006/08/14 11:08:46]
[2006/08/14 11:08:46] }
[2006/08/14 11:08:46] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:08:46]
[2006/08/14 11:08:46] v2.4.1 Prêt.
[2006/08/14 11:08:46]
[2006/08/14 11:08:46] RetrData: url: http://www.wowroster.net/uniuploader_up ... update.php
[2006/08/14 11:08:46] RetrData: param1: OPERATION
[2006/08/14 11:08:46] RetrData: val1: CHECKUPDATES
[2006/08/14 11:08:46] RetrData: Timeout: 20000
[2006/08/14 11:08:46] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:08:46] 2.4.1|Version 2.4.1 changes:
[2006/08/14 11:08:46]
[2006/08/14 11:08:46] 1. URL syncronization URL enabled
[2006/08/14 11:08:46] 2. User Agent doesn't save unless it's changed via settings sync or user input.
[2006/08/14 11:08:46] 3. All references to wowroster.net changed to wowroster.net in UU and UU Updater
[2006/08/14 11:08:46] 4. Updater tries to update after 10 seconds of not detecting UU closure.
[2006/08/14 11:08:46] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:08:46]
[2006/08/14 11:08:59]
[2006/08/14 11:08:59] RetrData: url: http://genesis.e-oxyde.ath.cx/roster/ad ... e=shopping
[2006/08/14 11:08:59] RetrData: param1: OPERATION
[2006/08/14 11:08:59] RetrData: val1: GETDATA
[2006/08/14 11:08:59] RetrData: param2: username
[2006/08/14 11:08:59] RetrData: val2:
[2006/08/14 11:08:59] RetrData: param3: password
[2006/08/14 11:08:59] RetrData: val3:
[2006/08/14 11:08:59] RetrData: Timeout: -1
[2006/08/14 11:08:59] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:08:59]
[2006/08/14 11:08:59] Sql-query: SELECT * FROM 2roster_addon_shopping WHERE order_state ='outbox'
[2006/08/14 11:08:59] Resource id #17
[2006/08/14 11:08:59]
[2006/08/14 11:08:59] Counter: 1shoppinglist = {
[2006/08/14 11:08:59]
[2006/08/14 11:08:59] }
[2006/08/14 11:08:59] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:08:59]
[2006/08/14 11:09:06] Chargement sur l'URL primaire...: http://genesis.e-oxyde.ath.cx/roster/admin/update.php
[2006/08/14 11:09:06] SavedVariables.lua - Aucune Compression. Taille: 0 KB
[2006/08/14 11:09:06] CharacterProfiler.lua - Aucune Compression. Taille: 416 KB
[2006/08/14 11:09:06] Shopping.lua - Aucune Compression. Taille: 1 KB
[2006/08/14 11:09:06] GuildProfiler.lua - Aucune Compression. Taille: 0 KB
[2006/08/14 11:09:06] PvPLog.lua - Aucune Compression. Taille: 2 KB
[2006/08/14 11:09:16] Chargement sur l'url additionnelle # 1... - http://genesis.e-oxyde.ath.cx/roster/ad ... e=shopping
[2006/08/14 11:09:16] SavedVariables.lua - Aucune Compression. Taille: 0 KB
[2006/08/14 11:09:16] CharacterProfiler.lua - Aucune Compression. Taille: 416 KB
[2006/08/14 11:09:16] Shopping.lua - Aucune Compression. Taille: 1 KB
[2006/08/14 11:09:16] GuildProfiler.lua - Aucune Compression. Taille: 0 KB
[2006/08/14 11:09:16] PvPLog.lua - Aucune Compression. Taille: 2 KB
[2006/08/14 11:09:22]
[2006/08/14 11:09:22] RetrData: url: http://genesis.e-oxyde.ath.cx/roster/ad ... e=shopping
[2006/08/14 11:09:22] RetrData: param1: OPERATION
[2006/08/14 11:09:22] RetrData: val1: GETDATA
[2006/08/14 11:09:22] RetrData: param2: username
[2006/08/14 11:09:22] RetrData: val2:
[2006/08/14 11:09:22] RetrData: param3: password
[2006/08/14 11:09:22] RetrData: val3:
[2006/08/14 11:09:22] RetrData: Timeout: -1
[2006/08/14 11:09:22] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:09:22]
[2006/08/14 11:09:22] Sql-query: SELECT * FROM 2roster_addon_shopping WHERE order_state ='outbox'
[2006/08/14 11:09:22] Resource id #17
[2006/08/14 11:09:22]
[2006/08/14 11:09:22] Counter: 1shoppinglist = {
[2006/08/14 11:09:22]
[2006/08/14 11:09:22] }
[2006/08/14 11:09:22] RetrData: ------------------------------------------------------------------------
[2006/08/14 11:09:22]
shan_aya
WR.net Journeyman
WR.net Journeyman
 
Posts: 132
Joined: Fri Aug 11, 2006 12:58 pm
Top

Re: shoopinglua is not empty , but....

Postby Hannah » Mon Aug 14, 2006 2:55 pm

Hi shan_aya!

The sql-query ssems to be the problem:

In your post before yoou did a manuall sql command
requête SQL: SELECT * FROM `roster_addon_shopping` LIMIT 0, 30 ;


If you look at the sql command in inthe log:
SELECT * FROM 2roster_addon_shopping WHERE order_state ='outbox'

You have the '2' in front of the $db_prefix variable...

Are you using different table prefixes for roster and shopping ?
Check out $table_prefix on line 22 in functions_cart.php and
$db_prefix of your roster conf.

Check sql manually by first run this:
Code: Select all

SELECT * FROM 2roster_addon_shopping WHERE order_state ='outbox';
 

This should lead to no entry found...

and this
Code: Select all

SELECT * FROM roster_addon_shopping WHERE order_state ='outbox';
 


This shouls show your orders....


Hope this solves the problem :)

Good luck :) Hannah
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne
Top

Re: shoopinglua is not empty , but....

Postby shan_aya » Mon Aug 14, 2006 6:17 pm

yes i use different prefix !!!

i haven't read that is not recommended, sorry..

how i can solve this without reinstall shopping ?
shan_aya
WR.net Journeyman
WR.net Journeyman
 
Posts: 132
Joined: Fri Aug 11, 2006 12:58 pm
Top

Re: shoopinglua is not empty , but....

Postby Hannah » Mon Aug 14, 2006 7:31 pm

I´m at work, so i haven´t got the code in front of me :)

But:

In the file index.php there is the function called 'getOrder'

Search for the sql String:
Code: Select all

$sel_order = "SELECT * FROM ".$db_prefix."addon_shopping WHERE order_state ='outbox'";
 


and change it to:
Code: Select all

$sel_order = "SELECT * FROM YOURPREFIX_addon_shopping WHERE order_state ='outbox'";
 


Change YOURPRFIX to yoour used prefix for shopping e.g.
2roster_addon_shopping

This should do the trick...

But for feature release i´ll change this, cause it cauld be a problem to someone else :)

CU

Hannah
Last edited by Hannah on Mon Aug 14, 2006 7:32 pm, edited 1 time in total.
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne
Top

shoopinglua is not empty , but....

Postby shan_aya » Wed Aug 16, 2006 3:20 pm

oki it's works now !!!!

but


with french version, all recipe with "'" create blank page ....
and in french many many items use this symbol
shan_aya
WR.net Journeyman
WR.net Journeyman
 
Posts: 132
Joined: Fri Aug 11, 2006 12:58 pm
Top

Re: shoopinglua is not empty , but....

Postby Hannah » Wed Aug 16, 2006 4:09 pm

Posted this problem in another thread, haven´t had the time to implement it in shopping:


Hannah wrote:
Adariel wrote:Leatherworking: Hillman's Cloak will not add to the cart - it just shows a blank page.

I don't have a lot of people's profiles uploaded to test with atm, but have noted that Alchemy: Elixir of Ogre's Strength and Strong Troll's Blood Potion have the same issue.

I'm guessing it has to do with the apostrophe - but I have no idea where to change the code to escape it so the PHP doesn't argue with it.


Hi Adariel!
Here´s a quick way solution :)

Open functions_cart.php and find line 80:
Code: Select all

$id = str_replace("", "", $id);
 

and add the following line after that
Code: Select all

$id = escape($id);
 


Also find line 94:
Code: Select all

$_SESSION["cart"][$item_count][0] = $item["recipe_name"];
 

change it to this:
Code: Select all

$_SESSION["cart"][$item_count][0] = escape($item["recipe_name"]);
 


At the end of the file before this line:
Code: Select all
//ob_end_flush();
 

add the following part
Code: Select all

         /** Thx roster devs for this :)
         * Front-end to escape string for safe inserting
         *
         * @param string $string
         * @return string escaped
         */
        function escape( $string )
        {
                if( version_compare( phpversion(), '4.3.0', '>' ) )
                        return mysql_real_escape_string( $string );
                else
                        return mysql_escape_string( $string );
        }
 



That´s it...

Give it a try :)

This only happens on english clients cause in german it´s Hillmann-Umhang without the apostrophe...

Test it for me i´ll search the code for any equal problem and thx for your
reply :)

Hannah



Do this changes and it should work...:)
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne
Top

Re: shoopinglua is not empty , but....

Postby shan_aya » Wed Aug 16, 2006 8:36 pm

that's right way
thx
shan_aya
WR.net Journeyman
WR.net Journeyman
 
Posts: 132
Joined: Fri Aug 11, 2006 12:58 pm
Top
Write comments

Return to Shopping

Who is online

Users browsing this forum: No registered users and 1 guest

Powered by phpBB® Forum Software © phpBB Group
cron