|
nice.
you can do few things: -create a "setting" for sms_field in vBoptions, and use something like $pager_status = $db->query_first("SELECT " . $vbsetting['sms_field'] . " AS status FROM " . TABLE_PREFIX . "userfield WHERE userfield.userid = $buddy[userid]"); in your plugins and your sms.php |
Just tried installing this mod, but keep getting this error whenever i try to test it out using the icon. Probably something obvious i've missed, but since it's nearly 6am i was hoping someone might be able to tell me a possible cause? :)
Database error in vBulletin 3.5.0: Invalid SQL: SELECT user.usergroupid as usergroupid, userfield.userid, userfield.field5 as pageron FROM vb3_userfield LEFT JOIN user ON (user.userid = userfield.userid) WHERE userfield.userid = 1 AND user.usergroupid NOT IN (1,2,3,8); MySQL Error : Table 'cd19861.user' doesn't exist Error Number : 1146 |
Yes, field number is correct, and i went over all the steps again and all seemed ok. Only thing was that in step 8 it says "put $sms_scripthead under the <body> tag" but there is no <body> tag in the header template that i can see...
|
The timeoffset is not correct. On the forum itself it is but in sms not.
|
The time displayed for all members is - 2 hours
|
Quote:
|
Thanks, tried the new sms.php version which solved the initial error...but created a new one! :p
Invalid SQL: SELECT vb3_user.usergroupid as usergroupid, userfield.userid, userfield.field5 as pageron FROM vb3_userfield LEFT JOIN vb3_user ON (user.userid = userfield.userid) WHERE userfield.userid = 1 AND user.usergroupid NOT IN (1,2,3,8); MySQL Error : Unknown table 'userfield' in field list Error Number : 1109 |
Had to add a couple of extra table prefixes, but it now works! Well, at least it lets me send a message without error, but i can't receive one, even though both members have the pager system enabled. :ermm:
|
Awesome it works! Thanks, looks like a great add-on hack. :)
I've attached the sms.php that worked for me, although it uses vb3_ instead of TABLE_PREFIX (it was the easiest way for me to check where the prefixes needed adding) so i guess those would need to be converted back for generic use! |
Just one thing...is there anyway to set the pager system up so no refresh or moving to another page is required to receive a message...or is there no way around that?
|
| All times are GMT. The time now is 03:40 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
| X vBulletin 3.8.12 by vBS Debug Information | |
|---|---|
|
|
 More Information |
|
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|