Threaded Mode | Linear Mode

Pidrila · 02-07-2014 10:38 PM

How i can mass pm to all players from web? I have a database where i add mass pm., but how can i display in game this message? Something like

Code:

"select mass_pm from database_ultima where topic_status =1"

Serv.allclients sysmessage <db.row.0.masspm> ...

or open like a dialog each player..

Sent from my PAP4055DUO using Tapatalk

Code:

[PLEVEL 1]

f_mass_pm

[function f_mass_pm]

db.connect

if ( <DB.connected> )

DB.QUERY "SELECT * FROM ibf_posts WHERE status='1'"

    if (<DB.ROW.NUMROWS> > 0)

        for R 0 <eval <DB.ROW.NUMROWS>-1>

        if (<DB.ROW.<eval <LOCAL.R>>.status> = 1)

        DB.EXECUTE "UPDATE ibf_posts SET status='0' WHERE pid='<DB.ROW.<eval <LOCAL.R>>.pid>'"

        serv.log Account: <DB.ROW.<eval <LOCAL.R>>.pid> mass pm from web

        sysmessage @55 <db.row.<eval <LOCAL.R>>.post>

        endif

        end

    endif

endif

okey i got that.. but how i can add not a sysmessage but something like a dialog appears? and in this dialog shows this message..??

Extreme · 02-08-2014 12:38 AM

serv.allclients sdialog blabla

[dialog blabla]
blabla
blabla
db.connect
if ( <DB.connected> )
DB.QUERY "SELECT * FROM ibf_posts WHERE status='1'"
if (<DB.ROW.NUMROWS> > 0)
for R 0 <eval <DB.ROW.NUMROWS>-1>
if (<DB.ROW.<eval <LOCAL.R>>.status> = 1)
DB.EXECUTE "UPDATE ibf_posts SET status='0' WHERE pid='<DB.ROW.<eval <LOCAL.R>>.pid>'"
serv.log Account: <DB.ROW.<eval <LOCAL.R>>.pid> mass pm from web
dtext 100 <eval 100+(20*<dlocal.r>)> 0 <db.row.<eval <LOCAL.R>>.post>
endif
end
endif
endif

Or

[function f_mass_pm]
db.connect
if ( <DB.connected> )
DB.QUERY "SELECT * FROM ibf_posts WHERE status='1'"
if (<DB.ROW.NUMROWS> > 0)
for R 0 <eval <DB.ROW.NUMROWS>-1>
if (<DB.ROW.<eval <LOCAL.R>>.status> = 1)
DB.EXECUTE "UPDATE ibf_posts SET status='0' WHERE pid='<DB.ROW.<eval <LOCAL.R>>.pid>'"
serv.log Account: <DB.ROW.<eval <LOCAL.R>>.pid> mass pm from web
list.masspm.add <db.row.<eval <LOCAL.R>>.post>
endif
end
endif
endif

[dialog blabla]
blabla
blabla
for 0 <eval <list.masspm.count>-1>
dtext 100 <eval 100+(20*<dlocal._for>)> 0 <list.masspm.<dlocal._for>>
endfor

Pidrila · 02-08-2014 02:28 AM

Code:

[function f_mass_pm]

db.connect

if ( <DB.connected> )

DB.QUERY "SELECT * FROM ibf_posts WHERE status='1'"

if (<DB.ROW.NUMROWS> > 0)

for R 0 <eval <DB.ROW.NUMROWS>-1>

if (<DB.ROW.<eval <LOCAL.R>>.status> = 1)

DB.EXECUTE "UPDATE ibf_posts SET status='0' WHERE pid='<DB.ROW.<eval <LOCAL.R>>.pid>'"

serv.log Account: <DB.ROW.<eval <LOCAL.R>>.pid> mass pm from web

list.masspm.add <db.row.<eval <LOCAL.R>>.post>

serv.allclients sdialog d_mass_pm

endif

end

endif

endif

[DIALOG d_mass_pm]

100, 100

PAGE 0

resizepic 0 0 9300 550 270

for 0 <eval <list.masspm.count>-1>

dtext 100 <eval 100+(20*<dlocal._for>)> 0 <list.masspm.<dlocal._for>>

endfor

tried, but dialog doesnt appear for player..
only if manualy .sdialog d_mass_pm
and there appears all of messages that was made.
i need only last one..

Extreme · 02-08-2014 02:44 AM

serv.allclients dialog_mass_pm

[function dialog_mass_pm]
trysrc <uid> sdialog d_mass_pm

[function f_mass_pm]
db.connect
if ( <DB.connected> )
DB.QUERY "SELECT * FROM ibf_posts WHERE status='1'"
if (<DB.ROW.NUMROWS> > 0)
list.masspm.clear
for R 0 <eval <DB.ROW.NUMROWS>-1>
if (<DB.ROW.<eval <LOCAL.R>>.status> = 1)
DB.EXECUTE "UPDATE ibf_posts SET status='0' WHERE pid='<DB.ROW.<eval <LOCAL.R>>.pid>'"
serv.log Account: <DB.ROW.<eval <LOCAL.R>>.pid> mass pm from web
list.masspm.add <db.row.<eval <LOCAL.R>>.post>
endif
endfor
serv.allclients dialog_mass_pm
endif
endif

another thing, clear the list before add the new msgs

Pidrila · 02-08-2014 03:41 AM

Thanks extreme Wink

Threaded Mode \| Linear Mode Mass pm from web
Author	Message