RapVerse.com Community

RapVerse.com Community (http://community.rapverse.com/index.php)
-   Lyricist Lounge (http://community.rapverse.com/forumdisplay.php?f=182)
-   -   RV Mods (Enter) (http://community.rapverse.com/showthread.php?t=224869)

Its a me.. Mario 03-22-06 10:43 AM

RV Mods (Enter)
 
Does the following show up for any of you when you logg into your Mod CP?

Connecting to database
Time before: 0.00120091438293
Time after: 0.00176596641541
Time taken: 0.000565052032471

--------------------------------------------------------------------------------

Query:

SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache')

Time before: 0.00187110900879
Time after: 0.00374507904053
Time taken: 0.00187397003174

table type possible_keys key key_len ref rows Extra
datastore range PRIMARY PRIMARY 15 5 Using where


--------------------------------------------------------------------------------

Query:

SELECT *
FROM session
WHERE sessionhash = '4b65044a3d85d5e8970f808707d9ca89'
AND lastactivity > 1143040259
AND host = '69.49.144.69'
AND idhash = 'd641cdb59606f64fef253d9819491950'

Time before: 0.0184409618378
Time after: 0.0189950466156
Time taken: 0.000554084777832

table type possible_keys key key_len ref rows Extra
session const PRIMARY PRIMARY 32 const 1


--------------------------------------------------------------------------------

Query:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_thread AS phrasegroup_thread,
language.phrasegroup_calendar AS phrasegroup_calendar,
language.phrasegroup_timezone AS phrasegroup_timezone,
language.phrasegroup_threadmanage AS phrasegroup_threadmanage,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 39012

Time before: 0.0195109844208
Time after: 0.0221130847931
Time taken: 0.00260210037231

table type possible_keys key key_len ref rows Extra
language system PRIMARY 1
user const PRIMARY PRIMARY 4 const 1
userfield const PRIMARY PRIMARY 4 const 1
usertextfield const PRIMARY PRIMARY 4 const 1
administrator const PRIMARY PRIMARY 4 const 0 unique row not found


--------------------------------------------------------------------------------

Query:

SELECT access.*, forum.forumid FROM forum AS forum LEFT JOIN access AS access ON
(userid = 39012 AND FIND_IN_SET(access.forumid, forum.parentlist))
WHERE NOT (ISNULL(access.forumid))

Time before: 0.0323250293732
Time after: 0.0328080654144
Time taken: 0.00048303604126

table type possible_keys key key_len ref rows Extra
forum ALL 323
access ref userid userid 4 const 2 Using where


--------------------------------------------------------------------------------

Query:

SELECT * FROM cpsession
WHERE userid = 39012
AND hash = '3646c5646802c835b8d2e7f90176c754'
AND dateline > 1143040259
Time before: 0.0334739685059
Time after: 0.033665895462
Time taken: 0.000191926956177

table type possible_keys key key_len ref rows Extra
cpsession system PRIMARY 1


--------------------------------------------------------------------------------

Query:
SELECT moderatorid, permissions FROM moderator WHERE userid = 39012
Time before: 0.0339529514313
Time after: 0.0340459346771
Time taken: 9.29832458496E-05

table type possible_keys key key_len ref rows Extra
moderator ref userid userid 4 const 4 Using where


--------------------------------------------------------------------------------












Moderation



Query:
SELECT script, action, optionname FROM adminhelp
Time before: 0.0347909927368
Time after: 0.0369729995728
Time taken: 0.00218200683594

table type possible_keys key key_len ref rows Extra
adminhelp index phraseunique 100 1163 Using index


--------------------------------------------------------------------------------

Query:
SELECT * FROM moderation
Time before: 0.0539300441742
Time after: 0.0541069507599
Time taken: 0.000176906585693

table type possible_keys key key_len ref rows Extra
moderation ALL 5


--------------------------------------------------------------------------------

Query:

SELECT DISTINCT forum.forumid
FROM forum AS forum, moderator AS moderator
WHERE FIND_IN_SET(moderator.forumid, forum.parentlist)
AND moderator.userid = 39012
AND moderator.permissions & 64
Time before: 0.0545120239258
Time after: 0.0546510219574
Time taken: 0.000138998031616

table type possible_keys key key_len ref rows Extra
moderator ref userid userid 4 const 4 Using where; Using temporary
forum ALL 323 Using where


--------------------------------------------------------------------------------




Help Threads Awaiting Moderation Query:

SELECT thread.threadid, thread.title AS title, thread.notes AS notes,
thread.forumid AS forumid, thread.postuserid AS userid,
thread.postusername AS username, thread.dateline, thread.firstpostid, pagetext
FROM thread AS thread
LEFT JOIN post AS post ON(thread.firstpostid = post.postid)
WHERE (1 = 0 OR thread.forumid IN (0,196,189,240,267,288,289,299,321,329,354,365,386 ,387)) AND thread.threadid IN(140782,118438,214535,212341)
ORDER BY thread.lastpost

Time before: 0.055300951004
Time after: 0.0554258823395
Time taken: 0.000124931335449


table type possible_keys key key_len ref rows Extra thread range PRIMARY,forumid PRIMARY 4 4 Using where; Using filesort post eq_ref PRIMARY PRIMARY 4 thread.firstpostid 1
--------------------------------------------------------------------------------


No Threads awaiting moderation










Help Posts Awaiting Moderation Query:

SELECT postid, pagetext, post.dateline, post.userid, post.title AS post_title,
thread.title AS thread_title, thread.forumid AS forumid, username, thread.threadid
FROM post AS post
LEFT JOIN thread AS thread ON(thread.threadid = post.threadid)
WHERE (1 = 0 OR thread.forumid IN (0,196,189,240,267,288,289,299,321,329,354,365,386 ,387)) AND postid IN(2580893)
ORDER BY dateline

Time before: 0.0564839839935
Time after: 0.0566630363464
Time taken: 0.000179052352905


If so whats the point?

If not then why the fuck am i seeing it?

KempoMRK 03-22-06 11:25 AM

Nah I don't get that, weeeird.

Its a me.. Mario 03-22-06 06:17 PM

Anyone else...

and kempo can you even enter the Mod CP?

dazy 03-22-06 06:19 PM

wat the heck ur computer is on drugs man

Magic5 03-22-06 06:22 PM

Quote:
Originally Posted by Led Poetic
Anyone else...

and kempo can you even enter the Mod CP?


Anybody who's modded can log onto the Mod CP in the forum that they're modding.

Magic5 03-22-06 06:23 PM

But. . take a screen shot of what you see and then I'll log into the Mod CP and tell you if I see the same shit.

Its a me.. Mario 03-22-06 06:24 PM

kk hold up lemme see if it still does it

Lay-z 03-22-06 06:28 PM

nah that dont show up.

-Substance- 03-22-06 06:39 PM

it don't show up to me......and jc real, your dumb, you ain't ever mod shit on here lol

Ysdat 03-23-06 12:19 AM

nah,doesnt show up for me. maybe the cookies for mod CP are fucking with your computer.

Lay-z 03-23-06 12:22 AM

yo animation is sexy. yo.

Sean Gunner 03-23-06 12:43 AM

Quote:
Originally Posted by JC REAL
wat the heck ur computer is on drugs man


Man, you don't even know what the Mod CP is.

I don't see it, it may be that certain settings on your comp are making you see it, because it sounds like the coding.

Ysdat 03-23-06 12:49 AM

^stop bullying JC real, damn wack emcees doing homework and shit :love:

Sean Gunner 03-23-06 12:50 AM

Quote:
Originally Posted by Po'etiquette
^stop bullying JC real, damn wack emcees doing homework and shit :love:


Word, that damn ambition to go to college and make $150,000/yr.

Ysdat 03-23-06 12:52 AM

colledge is for wise guys? like you.
*points finger*

Why not be like me and do nothing with your life,amount to nothing and leave nothing for your kids to have. Thast what a real man would do.


All times are GMT -4. The time now is 10:16 PM.