WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė suomis· 2008 Lie. 3 23:07:33

sveiki ;) kazkur maciau toky nebloga moda puslapyje php-fusion ,kas kai vartotojas gauna PM is kart sonineje paneleje atsiranda ta zinute ?| ir buna pasirinkti variantus uzdaryti arba atsakyti ,jai spaudi uzdaryti zinute dingasta ?|

Parašė Dandžu· 2008 Lie. 3 23:07:50

Nemanai paieškoti Skriptų bibliotekoje? :?

Parašė suomis· 2008 Lie. 4 00:07:03

zinociau ko ieskot ieskociau, forume ieskojau tokio dalyko nemaciau :|

Sharkman: radau aciu ;)

Redagavo suomis· 2008 Lie. 4 00:07:09

Parašė suomis· 2008 Lie. 4 00:07:24

sory uz floda tik kazko kai ymetu ta koda meta man sita klaida kai gaunu zinute :

Unknown table 'tm'Unknown table 'tm'

Parašė bruzgis· 2008 Lie. 4 00:07:48

nugi susitvarkyk, ten bus vietoj ".$db_prefix." parasyta tm

Parašė suomis· 2008 Lie. 4 07:07:30

kas cia blogai sitam:

$data = dbarray(dbquery("SELECT ".DB_PREFIX."*, user_id,user_name,user_avatar FROM ".DB_PREFIX."messages tmLEFT JOIN ".DB_PREFIX."users tu ON tm.message_from=tu.user_id WHERE message_to='".$userdata['user_id']."' && message_read=0 ORDER BY message_datestamp DESC LIMIT 1"));

Redagavo suomis· 2008 Lie. 4 07:07:50

Parašė MAnjack· 2008 Lie. 4 09:07:46

Va tikrai veikianti:

$msg_count = dbcount("(message_id)", "messages", "message_to='".$userdata['user_id']."' AND message_read='0'AND message_folder='0'");

 

if ($_POST['uzdaryti']) {

$result = dbquery("UPDATE ".DB_PREFIX."messages SET message_read=1 WHERE message_id='".$_POST['message_id']."'");

redirect(FUSION_SELF.(FUSION_QUERY ? "?".FUSION_QUERY : ""));

}

 

if ($_POST['atsakyti']) {

$result = dbquery("UPDATE ".DB_PREFIX."messages SET message_read=1 WHERE message_id='".$_POST['message_id']."'");

redirect(BASEDIR."messages.php?folder=inbox&msg_send=".$_POST['message_from']."&msg_id=".$_POST['message_id']);

}

 

if ($msg_count != 0) {

 

openside("<blink>Nauja AŽ!</blink>");

$data = dbarray(dbquery("SELECT tm.*, tu.user_id,user_name,user_avatar FROM ".DB_PREFIX."messages tm

LEFT JOIN ".DB_PREFIX."users tu ON tm.message_from=tu.user_id WHERE message_to='".$userdata['user_id']."' && message_read=0 ORDER BY message_datestamp DESC LIMIT 1"));

 

echo "<center><a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'><b>".$data['user_name']."</b></a>

<br><img src='".IMAGES.($data['user_avatar'] ? "avatars/".$data['user_avatar'] : "noav.gif")."' alt='Siuntėjo Avataras'></center><small>".($data['message_smileys'] == 1 ? $data['message_message'] : parsesmileys($data['message_message']))."</small><br><br>

<form method='post' action='' name='submitform'><center>

<input type='hidden' name='message_id' value='".$data['message_id']."'>

<input type='hidden' name='message_from' value='".$data['message_from']."'>

<input type='submit' class='button' name='atsakyti' value='Atsakyti'>

<input type='submit' class='button' name='uzdaryti' value='Uždaryti'>

</center></form>";

 

closeside();

}

Parašė ch0k3· 2008 Lie. 4 09:07:47

$data = dbarray(dbquery("SELECT ".TM."*, user_id,user_name,user_avatar FROM ".TM."messages tmLEFT JOIN ".TM."users tu ON tm.message_from=tu.user_id WHERE message_to='".$userdata['user_id']."' && message_read=0 ORDER BY message_datestamp DESC LIMIT 1"));

Na pabandyk bet nezinau dar ar gerai

Parašė Toonis· 2008 Lie. 4 09:07:17

Man tai kuo puikiausiai veikė ir iš skriptų bibliotekos. :|

Parašė ch0k3· 2008 Lie. 4 09:07:07

#10

gal jis jau kazka ten su**ses

Parašė MAnjack· 2008 Lie. 4 09:07:13

#11

Nu tai pakeis su mano duota ir viskas veiks.

Parašė bruzgis· 2008 Lie. 4 11:07:48

#12

$data = dbarray(dbquery("SELECT *, user_id,user_name,user_avatar FROM ".$db_prefix."messages tm LEFT JOIN ".$db_prefix."users tu ON tm.message_from=tu.user_id WHERE message_to='".$userdata['user_id']."' && message_read=0 ORDER BY message_datestamp DESC LIMIT 1"));