SigGen & UniUploader

A signature and avatar generator addon

Moderator: zanix

SigGen & UniUploader

Postby Samadhi » Tue Dec 04, 2007 11:24 am

I hate to be a complainer, but have we looked at the latest version with UU to see how they play together? I'm seeing an error when I try to upload now that appears to be a missing where clause. If I check the server response tab, I get the html source of the upload page and I can see the following error:
Code: Select all
<tr>
<td class="membersRowRight1" style="white-space:normal;">Backtrace (most recent call last):<ul>
<li>lib/functions.lib.php<ul>
<li>Line: 240</li>
<li>Function Called: backtrace</li>
</ul></li>
<li>lib/dbal/mysql.php<ul>
<li>Line: 207</li>
<li>Function Called: die_quietly</li>
<li>Arguments:<ul><li>1064: 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 'LIMIT 1' at line 1</li>
<li>Database Error</li>
<li>/home/undea6/public_html/UFRoster2/lib/dbal/mysql.php</li>
<li>207</li>
<li>SELECT * FROM `roster_members` WHERE LIMIT 1;</li>
</ul></li>
</ul></li>
<li>addons/siggen/siggen.php<ul>
<li>Line: 155</li>
<li>Function Called: query</li>
<li>Arguments:<ul><li>SELECT * FROM `roster_members` WHERE LIMIT 1;</li>
</ul></li>
</ul></li>
<li>addons/siggen/index.php<ul>
<li>Line: 41</li>
<li>Function Called: require</li>
<li>Arguments:<ul><li>/home/undea6/public_html/UFRoster2/addons/siggen/siggen.php</li>
</ul></li>
</ul></li>
<li>index.php<ul>
<li>Line: 152</li>
<li>Function Called: require</li>
<li>Arguments:<ul><li>/home/undea6/public_html/UFRoster2/addons/siggen/index.php</li>
</ul></li>
</ul></li>
</ul>
</td>
</tr>


I can give you the full source that's generated, but it's enormous, so I probably shouldn't post it here. Please let me know if I can help test in any way.
Image
User avatar
Samadhi
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Mon Jul 17, 2006 10:38 pm
Location: NJ, USA

SigGen & UniUploader

Postby zanix » Tue Dec 04, 2007 12:13 pm

Oh, I might not have changed the update hook
One of the many small things that need to be fixed :(
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

SigGen & UniUploader

Postby Samadhi » Tue Dec 04, 2007 12:27 pm

I'm glad I brought it to your attention, then. :)
Image
User avatar
Samadhi
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Mon Jul 17, 2006 10:38 pm
Location: NJ, USA

SigGen & UniUploader

Postby Samadhi » Sat Dec 15, 2007 3:16 am

I just took another look at this, and it doesn't appear that the saved signatures are being updated, either. I imagine that's also due to the hooks not being updated?
Image
User avatar
Samadhi
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Mon Jul 17, 2006 10:38 pm
Location: NJ, USA

SigGen & UniUploader

Postby zanix » Sat Dec 15, 2007 3:23 am

Yeah, if you can use the SVN, try siggen from the roster1_addons repository
There isn't a download yet since I just haven't tested the current changes
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

SigGen & UniUploader

Postby Samadhi » Sat Dec 15, 2007 4:23 am

Thanks. I'll grab it and take a look.
Image
User avatar
Samadhi
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Mon Jul 17, 2006 10:38 pm
Location: NJ, USA

Re: SigGen & UniUploader

Postby knappster » Sat Dec 29, 2007 12:08 am

Sort of off-topic, but I think it belongs in this thread.

I'm using Roster 1.7.3 and I still have Siggen 0.2.3. It's working fine, but my server does not have allow_URL_fopen enabled. Is that pretty much just a limiting factor for using UniUploader with any current or future version of Siggen, or is there a version of Siggen where that is not required?

Everything works fine with Siggen so I don't really need to update it, I just wanted to if a new one will work with UniUploader on my server.
knappster
WR.net Apprentice
WR.net Apprentice
 
Posts: 63
Joined: Fri Jul 21, 2006 11:12 pm

SigGen & UniUploader

Postby tuigii » Sat Dec 29, 2007 12:24 am

I don't think SigGen needs allow_URL_fopen to be true. See this link http://phpsec.org/projects/phpsecinfo/t ... fopen.html for whats allow_URL_fopen all about.

I know ArmorySync needs it (or : Curl) and the Realmupdate code - because it will be your 'site-server' reaching out to other sites to obtain the data.

UniUpLoader is an executable on your PC - it just posts files on your server, or download files from it - nothing special is needed on your PC, neither your server.
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

SigGen & UniUploader

Postby PleegWat » Sat Dec 29, 2007 12:31 am

Old versions of siggen use fopen with local urls to generate saved signatures. I'm not sure what recent versions use.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Re: SigGen & UniUploader

Postby knappster » Sat Dec 29, 2007 1:03 am

Under the "Main Settings" of the Siggen Config there is an option for "UniUploader Fix".

If I mouseover that, it says:
Code: Select all
Enable UniUploader save images workaround
Requires allow_url_fopen to be enabled on your server!


I have yes selected, but as I mentioned earlier allow_url_fopen is disabled on the server.

When I upload a profile using the update.php page, the signature(s) get updated. If I use phpuniuploader or UniUploader, the signatures do not get updated, even though the profiles do.
knappster
WR.net Apprentice
WR.net Apprentice
 
Posts: 63
Joined: Fri Jul 21, 2006 11:12 pm

SigGen & UniUploader

Postby zanix » Sat Dec 29, 2007 2:24 am

Yes, the update process places actual images in the update
When using UniUploader, the update process strips all html tags, so another way must be used
readfile() is currently the only way to generate a SigGen image and readfile() needs allow_url_fopen enabled to function

SigGen 1.0.0 will allow generation of images using UniUploader without needing allow_url_fopen enabled
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US


Return to SigGen

Who is online

Users browsing this forum: No registered users and 0 guests

cron