Shakes & Fidget Private - Full Script (Tulyita)

[TheCry]

Originally Posted by szymek111

I think Eptun paid for this files but he deleted some lines of code (maybe he want this only for him xd) than he uploaded sql file and request but guild chat and tower helpers aren't working.

Maybe its true, maybe no :/

I don't think so

[EptunLP]

The mediafire file is from tulyita I didnt deleted anything maybe tulyita

[TheCry]

Ask him why this not working if it should... We will see what he will answer: /

[EptunLP]

Im asking him everyday but he doesnt respond

[TheCry]

Originally Posted by EptunLP

Im asking him everyday but he doesnt respond

We must wait


I also sent him a few messages, perhaps will answer me

[UND3RW0RLD]

I still don't know how the to communicate with the client, so i could need some help from now..

SQL

CREATE TABLE IF NOT EXISTS `guild_chat` (
  `msg_id` int(11) NOT NULL AUTO_INCREMENT,
  `guild_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `reciver_id` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `msg` text NOT NULL,
  PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Replace

PHP Code:

case $ACT_SEND_CHAT :

break; 


with

PHP Code:

case $ACT_SEND_CHAT :
        // the ususal stuff
        // msg;0
        // what the hell means 0??
        $data = explode ( ';', $action_extra );

        $msg = $data[0];

        $time = new DateTime ();
        $time = $time->getTimestamp ();
        
        $recid = "0";
        
        // get some ids
        $qry = $db->prepare ( "SELECT user_id, guild_id FROM user_data WHERE ssid = :ssid" );
        $qry->bindParam ( ':ssid', $SSID );
        $qry->execute ();
        $ids = $qry->fetchAll ();

        // put into db
        $qry = $db->prepare ("INSERT INTO guild_chat(guild_id, sender_id, reciver_id, time, msg)  
                            VALUES(:guildid, :uid, :recid, :time, :msg)");
        $qry->bindParam ( ':guildid', $ids [0] ['guild_id'] );
        $qry->bindParam ( ':uid', $ids [0] ['user_id'] );
        $qry->bindParam ( ':recid', $recid );
        $qry->bindParam ( ':time', $time );
        $qry->bindParam ( ':msg', $msg );
        $qry->execute ();
        
        break; 


[TheCry]

But text is displaying on chat line?

[UND3RW0RLD]

nope.. there no callback to the client.. thats why i need help

Still empty

[TheCry]

Hmmm... we must do array.... but idk how XD

Im working on it

[HolzNudel]

Kann jemand die Files komplett Uplaoden als ein Download ?
Mit den files die man braucht inkl. mysql Datenbank ?

Wäre echt sehr nett und würde jeden helfen.

[nabbi]

Originally Posted by ǝnd1ǝss-ɯonǝʎ

nope.. there no callback to the client.. thats why i need help

Still empty

But you are at the right Way.
Here is my Chat :




You have wrote me at PN because i dont like to awnser because it is really hard to explain that in PN have you Skype or Teamspeak than i can help you with you Problems

[luzik78]

Originally Posted by ǝnd1ǝss-ɯonǝʎ

I still don't know how the to communicate with the client, so i could need some help from now..

SQL

CREATE TABLE IF NOT EXISTS `guild_chat` (
  `msg_id` int(11) NOT NULL AUTO_INCREMENT,
  `guild_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `reciver_id` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `msg` text NOT NULL,
  PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Replace

PHP Code:

case $ACT_SEND_CHAT :

break; 


with

PHP Code:

case $ACT_SEND_CHAT :
        // the ususal stuff
        // msg;0
        // what the hell means 0??
        $data = explode ( ';', $action_extra );

        $msg = $data[0];

        $time = new DateTime ();
        $time = $time->getTimestamp ();
        
        $recid = "0";
        
        // get some ids
        $qry = $db->prepare ( "SELECT user_id, guild_id FROM user_data WHERE ssid = :ssid" );
        $qry->bindParam ( ':ssid', $SSID );
        $qry->execute ();
        $ids = $qry->fetchAll ();

        // put into db
        $qry = $db->prepare ("INSERT INTO guild_chat(guild_id, sender_id, reciver_id, time, msg)  
                            VALUES(:guildid, :uid, :recid, :time, :msg)");
        $qry->bindParam ( ':guildid', $ids [0] ['guild_id'] );
        $qry->bindParam ( ':uid', $ids [0] ['user_id'] );
        $qry->bindParam ( ':recid', $recid );
        $qry->bindParam ( ':time', $time );
        $qry->bindParam ( ':msg', $msg );
        $qry->execute ();
        
        break; 


Nice $ACT_SEND_CHAT but where is

$ACT_PULL_CHAT_DATA, 
$ACT_GET_CHAT_HISTORY, 
$ERR_GUILD_CHAT_TEXT_ERROR, 
$RESP_CHAT_HISTORY, 
$RESP_CHAT_LINE

[WielkaNogawka]

@UP: me no work too





@EDIT:

cam someone upload request with gulid chat?

[barteklorek123]

[TheCry]

So?

Almost everyone has this script... at the moment nothing new it isn't: /

Originally Posted by WielkaNogawka

@UP: me no work too





@EDIT:

cam someone upload request with gulid chat?

Nikt ci nie upie takiego request'u ponieważ czat gildii jest bardzo trudny do zaprogramowania i nikt nie ma zamiaru tego udostępniać (przydało by się ) ... :/