User Inventory Q       Back to File List | Edit This File

User Inventory Q - Click to Download
Submitted by Dradaki on 10.03.2009 (810 Downloads)
I have attempted to use this mod: http://dragon.se7enet.com/mods/index.php?do=file&id=221 and get the following error: Fatal error: Call to undefined function: doquery2() in /home/saincai/public_html/towns.php on line 111. I remove the 2 from doquery2 and get this error: 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 '{table1}} as A left join {{table2}} as B on A.item_id= B.id where user_id = '1'' at line 1.

Anyone see what the problem is from that code on the mod page?
File rating: 3.22 out of 5.00 (9 votes total).
Rate this file:       (Sucks) 1   2   3   4   5 (Rocks)      

Posted by ErRoR on 10.05.2009
try deleting this number 2 behind
doquery.
Posted by ErRoR on 10.05.2009
$inventoryquery = doquery2("SELECT * from {{table1}} as A left join {{table2}} as B  on A.item_id= B.id where user_id = '1'", "inventory","items");


AT this line
Posted by ErRoR on 10.05.2009
damit i didnt read your full comment you allready tryed it

Posted by Fayt on 10.07.2009
There is a double space on that query which can cause the error.
Posted by ErRoR on 10.09.2009
Thanks, I will try that when I reinstall it.

~Dradaki
Posted by ErRoR on 10.09.2009
I removed a space from the double space here: as B  on , but I still get the same errors :(

~Dradaki
Posted by ErRoR on 10.10.2009
omfg i fixed this error but that mod just mess up whole buying thing you cant replace function buy3. anyway this shoud work:
$inventoryquery = doquery("SELECT * from dk_users as A LEFT JOIN dk_inventory as B ON B.item_id = A.id WHERE user_id = '1'", "inventory","items");
Posted by ErRoR on 10.10.2009
sorry its dk_items not dk_users in that function.
Posted by ErRoR on 12.08.2009
I had to do a few other things to get it to work properly, but the edit you placed ERROR seemed to let me get to that stage and I thank you

~Drad
Add A Comment

In order to cut down on comment spam, you must be registered on the support forums and provide your username and password before you are allowed to comment. The name shown in your comment will be your forums display name. Sorry it had to be like this. If you haven't already, please register an account.

Forums Username:


Forums Password:


Your Comment:




Information & Rules
This is a file index for any Dragon Knight modifications. If you've made a mod you'd like to share with the community, upload it.

Mod authors, please include a name, version, and brief description along with your file. All files should be submitted in a zip file that includes the actual PHP scripts as well as any readme/instruction files.

DISCLAIMER: I take absolutely no responsibility for the content or functionality of any of these files. You use them entirely at your own risk. Make sure to run all files through a virus scanner before opening them. Hopefully the people here are above such petty nonsense as putting a virus in the files, but you can never be to careful.