Simple pager / sms / instant message system...

Gone

[Pvtiste]

Thanks for your work man !

[rb290]

Originally Posted by rb290

I get this:

Invalid SQL:

SELECT user.usergroupid as usergroupid, userfield.userid, userfield. as pageron
FROM userfield LEFT JOIN user ON (user.userid = userfield.userid)
WHERE userfield.userid = 1 AND user.usergroupid NOT IN (1,3,8);

MySQL 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 'as pageron
FROM userfield LEFT JOIN user ON (user.userid = u
Error Number : 1064
Date : Monday, November 21st 2005 @ 06:02:34 PM
Script : http://thugonline.net/sms.php?do=sms&userid=1
Referrer : http://thugonline.net/showthread.php?p=3387
IP Address : 69.156.38.253
Username : KILLA
Classname : vb_database

^what did i do wrong here ?

[rb290]

the field number is 10 so I replaced all the field_no with field10 and field90's with field10

[divided_by_fear]

mini2 can you look at my post on https://vborg.vbsupport.ru/showpost....&postcount=111 and let me know how this can be fixed im using the mod also from this post too https://vborg.vbsupport.ru/showpost....&postcount=109

[divided_by_fear]

damn hes back on track lol caching it now lol i just seen your post after i hit the quick reply lol but still wondering if you could look at that mod the person used its nice but it dont display the default avatar

[divided_by_fear]

i dont see where your talking about adding it too in the cache_templates cause it dont show in there

[divided_by_fear]

ok trying this now for the cache also do you think you could help get that guys mod to work with the default avatar? but im trying the cache now ill let you know how it goes

[divided_by_fear]

hell yeah that worked for cache now if i could figure out the default avatar lol with that guys mod it would be sweet

[divided_by_fear]

yeah if you have time could you possibly see if you could get that to work its nice addon to this... but if the person has a avatar it works but if they use the default it dont...

[rb290]

Originally Posted by mini2

You shouldn't replace the field_no variables. If you have any $field10 then change that BACK to $field_no. You only need to put the new variable in the sms.php at the top (field90 replace with field10). ONLY replace 90's with 10's, not the $field_no text itself.

Hope that makes sense.

k thanks that worked
but how come the "P" only shows under my name in the postbit and it says I can send a message to myself
but it doesnt show under the other users
and the Default for "Enable Paging system" is set to Yes so everyone has it on.
know what might be wrong ?